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]

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

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
"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

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

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:eI**************@TK2MSFTNGP11.phx.gbl...

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

Jeff
"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

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
"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

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

Ray at home

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:eI**************@TK2MSFTNGP11.phx.gbl...

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

Jeff
"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
> 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