Updating via hyperlink problem (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Trevor -> 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 -> 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 -> 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 -> 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




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
4.785156E-02