navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

UPDATE RECORDS

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> UPDATE RECORDS
Page: [1]
 
TAMAJAMA

 

Posts: 28
From: KANSAS
Status: offline

 
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

 

Posts: 28
From: KANSAS
Status: offline

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


(in reply to TAMAJAMA)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> UPDATE RECORDS
Page: [1]
Jump to: 1





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