Evening everyone! I have an UPDATE query that is killing me! I'm generating the "Syntax error in UPDATE statement" when the query is processed on my ASP page. My syntax looks correct as far as I can see; and I made sure use the correct quote tags for the numeric db fields. But obiviously something isn't right
The code is below, I put the field type next to each string. Any help is appreciated, thanks!!
Code:
sql= "UPDATE [members] SET "
sql=sql & "[password]= '" & password & "'," 'text field
sql=sql & "[fullname]= '" & fullname & "'," 'text field
sql=sql & "[age]= " & age & "," 'number field
sql=sql & "[gender]= " & gender & "," 'text field
sql=sql & "[alocation]= '" & alocation & "'," 'text field
sql=sql & "[emailaddress]= '" & emailaddress & "'," 'text field
sql=sql & "[yahoo]= '" & yahoo & "'," 'text field
sql=sql & "[msn]= '" & msn & "'," 'text field
sql=sql & "[icqnumber]= '" & icqnumber & "'," 'text field
sql=sql & "[website]= '" & website & "'," 'text field
sql=sql & "[gamertag]= '" & gamertag & "'," 'memo field
sql=sql & "[intrests]= '" & intrests & "'," 'memo field
sql=sql & "[avatarid]= " & avatarid & "," 'number field
sql=sql & "WHERE " & memberid & " = [members.memberid]" 'number field
cnnSimple.Execute(sql)
dBforums
>
Update query Troubles
11-02-04, 22:18
Update query Troubles
Linear Mode
