SPUG: MS Access and DBI

[Alyssa Harding]

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/