469,915 Members | 2,652 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,915 developers. It's quick & easy.

Update ????

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.
Jul 19 '05 #1
4 1698

"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
Jul 19 '05 #2
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

Jul 19 '05 #3
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


Jul 19 '05 #4
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



Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Dave | last post: by
8 posts views Thread by Lauren Quantrell | last post: by
27 posts views Thread by VK | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
5 posts views Thread by PAUL | last post: by
8 posts views Thread by Zorpiedoman | last post: by
5 posts views Thread by Stephen Plotnick | last post: by
3 posts views Thread by Michel Esber | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.