Update ????

[Jeff Uchtman]

This command worked prior to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
now it won't. Any help would be appreciated.

db.execute("update faq set count=count+1 where faqid=" &
request.querystring("faqid"))

Count is a field name in FAQ table in MS Access DB.

 

[Ray at]

This command worked prior to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
now it won't. Any help would be appreciated.

Now it doesn't? What happens? Do you get an error?

db.execute("update faq set count=count+1 where faqid=" &
request.querystring("faqid"))

Count is a field name in FAQ table in MS Access DB.

It is also a reserved word. Bracket it as so:
"UPDATE faq SET [count]=[count]+1 WHERE faqid=" &
request.querystring("faqid")

Ray at home

 

[Jeff Uchtman]

Thanks Ray, thats what I suspected. Where can I locate a list of reserved
words for the "next time"

Jeff

This command worked prior to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
now it won't. Any help would be appreciated.

Now it doesn't? What happens? Do you get an error?

db.execute("update faq set count=count+1 where faqid=" &
request.querystring("faqid"))

Count is a field name in FAQ table in MS Access DB.

It is also a reserved word. Bracket it as so:
"UPDATE faq SET [count]=[count]+1 WHERE faqid=" &
request.querystring("faqid")

Ray at home

 

[Ray at]

Here you are.
http://aspfaq.com/2080

Ray at home

Thanks Ray, thats what I suspected. Where can I locate a list of reserved
words for the "next time"

Jeff

This command worked prior to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
now it won't. Any help would be appreciated.

Now it doesn't? What happens? Do you get an error?

db.execute("update faq set count=count+1 where faqid=" &
request.querystring("faqid"))

Count is a field name in FAQ table in MS Access DB.

It is also a reserved word. Bracket it as so:
"UPDATE faq SET [count]=[count]+1 WHERE faqid=" &
request.querystring("faqid")

Ray at home

 

[Jeff Uchtman]

Thank you kindly!

Jeff

Here you are.
http://aspfaq.com/2080

Ray at home

Thanks Ray, thats what I suspected. Where can I locate a list of reserved
words for the "next time"

Jeff

This command worked prior to "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="
now it won't. Any help would be appreciated.

Now it doesn't? What happens? Do you get an error?


db.execute("update faq set count=count+1 where faqid=" &
request.querystring("faqid"))

Count is a field name in FAQ table in MS Access DB.

It is also a reserved word. Bracket it as so:
"UPDATE faq SET [count]=[count]+1 WHERE faqid=" &
request.querystring("faqid")

Ray at home