|
| |
|
|
Lydecker
Posts: 609
From: Oxshott, Surrey, England (UK)
Status: offline
 |
What do I need to use for a delete query? - 3/26/2002 18:21:26
I am currently using:
DELETE from Table1
WHERE ID='::ID::'
But it's not working
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: What do I need to use for a delete query? - 3/27/2002 0:53:26
DELETE from Table1 WHERE ID=::ID::
All numerics dont require quotes :)
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
Lydecker
Posts: 609
From: Oxshott, Surrey, England (UK)
Status: offline
|
RE: What do I need to use for a delete query? - 3/27/2002 8:42:13
Well spotted - thanks, thats done the trick.
But why does the query verification stage not pick up errors like that?
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: What do I need to use for a delete query? - 3/27/2002 16:42:44
Unfortunately the verification isnt much good for a lot of things. It cant distinguish between all feild types
Check the advanced section of my site below for some more info
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
