UPDATE RECORDS (Full Version)

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



Message


TAMAJAMA -> UPDATE RECORDS (3/1/2001 23:27:00)

I am setting up the page used to update records, and when I am creating my custom query, I am getting this error message: My database connection is verified. So I'm not sure where I'm going wrong.

Server error: Unable to retrieve schema information from the query:

UPDATE ALL Tests SET VIEWED= 'UPDATETOVIEWED' WHERE COC="'COC'"

*****************************************
The only other thing I can think of is that UPDATETOVIEWED is going to update a true-false (checkbox) field. Is there some other text that I should be using?
Thanks in advance for your help!





TAMAJAMA -> RE: UPDATE RECORDS (3/1/2001 14:50:00)

Please disregard my post. I worked on it a little bit more, and noticed the big UGLY space between my table name. That was the problem. Previously it was All Tests for my table name, it is now ALLTESTS. I'm awake now~

Live, Laugh, Learn!!!





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625