SPUG: MS Access and DBI

[Brose, Eric]

Yes.

It isn't necessary to use the asterik.  
Access doesn't seem to mind when you do though. 

Thanks,
Eric

-----Original Message-----
From: Alyssa Harding [mailto:alyssa at atuin.net]
Sent: Wednesday, May 30, 2001 3:58 PM
To: dbitsef at qwest.com
Cc: Brose, Eric; 'spug-list at pm.org'
Subject: Re: SPUG: MS Access and DBI




you seem to be deleting everything from the Player table where the 
Player schema's playerName table = Scooby...

I think you may mean:

DELETE from Player WHERE playerName = "Scooby"
(delete everything from the Player table for the player named "Scooby" 
while you are logging in as the DB user who owns this table)

my $sql = 'DELETE from Player WHERE playerName = "Scooby"';

A.

David Bitseff wrote:

> 
> Sorry, 
> 
> What I meant was;  Try removing the '*' character.  I'm not familiar
> with Access, but I think SQL delete statements don't have an asterisk.
> 
> 
> Brose, Eric writes:

>> my $sqlstatement="DELETE * from Player WHERE
Player.playerName=\"Scooby\";";


-- 
Alyssa Harding
http://www.atuin.net/~alyssa
-------------------------------------------------------------------
"The thing is that Mr. Dibbler can even sell sausages to people who have
bought them off him *before*."
         -- Now *that's* marketing
            (Terry Pratchett, Moving Pictures)


 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
     POST TO: spug-list at pm.org       PROBLEMS: owner-spug-list at pm.org
      Subscriptions; Email to majordomo at pm.org:  ACTION  LIST  EMAIL
  Replace ACTION by subscribe or unsubscribe, EMAIL by your Email-address
 For daily traffic, use spug-list for LIST ;  for weekly, spug-list-digest
  Seattle Perl Users Group (SPUG) Home Page: http://www.halcyon.com/spug/