|
| |
|
|
Trevor
Posts: 15
From: None
Status: offline
 |
Updating via hyperlink problem - 9/6/2001 23:15:00
I have a drw where I have a link to cancel or "archive" a record. This link passes the "name" field to another page where I use the sql statement
UPDATE Subjects
SET
archive = 'ON'
Where subj_name='::subj_name::'
This works just fine but I want to use the unique ID field as the matching criteria in case there are two records with the same name, or no name at all, but when I pass the ID field as the parameter and change the sql to ID='::ID::'
I get this error: Data type mismatch in criteria expression.
(using access db ID field is autonumber)
Thanks for any help
Trev.
|
|
|
|
Mojo
Posts: 2431
From: Chicago
Status: offline
|
RE: Updating via hyperlink problem - 9/7/2001 20:34:00
Try removing the single quotes --You have this: ID='::ID::' Try using this instead: ID= ::ID::
Joe
| |
|
|
|
Trevor
Posts: 15
From: None
Status: offline
|
RE: Updating via hyperlink problem - 9/7/2001 20:30:00
Hey thanks, I'll try it ,, just out of curiosity, as it is now using subj_name, I have the single quotes in there and its working ,, do I have to remove them because I'm using the auto number or key field ?
| |
|
|
|
Mojo
Posts: 2431
From: Chicago
Status: offline
|
RE: Updating via hyperlink problem - 9/8/2001 20:37:00
do I have to remove them because I'm using the auto number or key field ?Use it for numeric fields. Joe
| |
|
 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 
