update statement

[s4dadmin]

This update statement does not have any errors, but the last field does not update the field in the database. I have response.write the statement and the data is correct. It is an update statement without a where clause. Here is the statement

sqlUpdate = "Update site_config SET " _
& "letterSubject = '" & strSubject & "'," _
& "txtHeader = '" & strtxtHeader & "'," _
& "htmlHeader = '" & strhtmlHeader & "';"

Can anyone help?

 

[Bastien]

Inside the strHTMLHeader, are there quotes? or other characters that can conflict with the parsing of the sql statement

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[ctarr]

Is the HTML exceeding the field size? And is it the right type?

Craig

 

[s4dadmin]

No there are not any quotes or any other characters in this string and I change all single quotes to double quotes, the field size is set to text in mysql which is like a memo at something like 65,000 characters.
I am testing something like 20 characters

 

[GaryC123]

Add this to the end of your connection string and see if it works

;Option=16387

http://www.intouchmedialtd.com

 

[Bastien]

can you show the sample code and sample string?

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[s4dadmin]

Here is the sql statement again.
sqlUpdate = "Update site_config SET " _
& "letterSubject = '" & strSubject & "'," _
& "txtHeader = '" & strtxtHeader & "'," _
& "htmlHeader = '" & strhtmlBody & "' " _
& "Where rowNum = 1;"

And here is the response.write statement
Update site_config SET letterSubject = 'This is the Subject. dddsfasdf d zzz',txtHeader = 'This is the text header asdfsdf sdzzz',htmlHeader = 'This is the html body.a dfasdf zzz' Where rowNum = 1;

letterSubject updates, txtHeader updates, htmlHeader does not update