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