urgent : Syntax error in UPDATE statement.

[snowboardr]

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.


ConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("ads.mdb&quot
set my_conn = Server.CreateObject("ADODB.Connection&quot
my_conn.Open ConnString

strSQL = "UPDATE ads SET view=" & strView + 1 & " WHERE bID=" & strPID

rs = my_conn.execute(strSql) '< error here
'< I have tried &quot;set rs =&quot; also..
' with same error

my_conn.Close
Set my_conn = nothing www.vzio.com

if I helped.

 

[FesterSXS]

is 'view' a number field or a text field in your database?? Does it require quotes around the value strView + 1 ?? Tony

http://www.phoenix-paints.co.uk/portfolio

 

[snowboardr]

it is a number field i have tried it with ' ' and without.. still the same error. www.vzio.com

if I helped.

 

[FesterSXS]

try this...

strSQL = "UPDATE ads SET view=" & CInt(strView + 1) & " WHERE bID=" & strPID

Tony

http://www.phoenix-paints.co.uk/portfolio

 

[snowboardr]

I think my problem was the database table name &quot;view&quot; wasnt aloud, i changed that and it seems to be working now..

thanks though. www.vzio.com

if I helped.

 

[FesterSXS]

i've had that with 'date' and 'group' They took me AGES to figure out I'll add 'view' to my list of no-no's Tony

http://www.phoenix-paints.co.uk/portfolio

 

[snowboardr]

It also could have been because there may not have been a value for view.. but i will never know. it works fine now.. lol

well from now on im naming db names something like

db_firstname.. etc

so there is no mistake that takes 2 hours to figure out.

happy coding. www.vzio.com

if I helped.