Update Db table string

[Jason Csizmadi]

I'm having a problem with getting the correct syntax for my upload
string.

=================

strSQL = "UPDATE dbo.content_selection SET content_cmd = '" & strLink &
" and cont_col = '" & strNum "'" &_
" WHERE cmd = " & strID

=================

I've added this to the above string:

and cont_col = '" & strNum

But my but I keep getting a server error. I'm new to asp and I'm having
a heck of a time with this. Below is the orginal string:

+++++++++++++++++

strSQL = "UPDATE dbo.YourTable SET sCatName = '" & strLink & "'" &_
" WHERE SCAT = " & strID

+++++++++++++++++

I would appreciate any help. Thanks Jason

[Hans]

Hi!

Something like this may work
strSQL = "UPDATE dbo.contetn_selection SET content_cmd = '" & strLink & "' ,
cont_col='" & strNum & "' WHERE cmd=" & strID

Note that if the columns are string columns you should add single quotes but
if the field is numeric you should remove the quotes. For example the
cont_col sounds like a numeric value and if so the the syntax should be
something like

strSQL = "UPDATE dbo.contetn_selection SET content_cmd = '" & strLink & "' ,
cont_col=" & strNum & " WHERE cmd=" & strID

The same is true for the WHERE condition. If the cmd field is not numeric
you must add quotes like
strSQL = "UPDATE dbo.contetn_selection SET content_cmd = '" & strLink & "' ,
cont_col=" & strNum & " WHERE cmd='" & strID & "'"
You must distinguish between
update some_table set myfield=5

and
update some_table set myfield='5'

where the first one will try to insert the integer value 5 into the field
myfield. The second will insert the string '5' (without quotes) into the
myfield field.

Regards
/Hans