The code:
SQLUPDATE="UPDATE BRDICT.TAUDIT "
SQLUPDATE=SQLUPDATE & "SET "
SQLUPDATE=SQLUPDATE & "LOG_INIT_UPD = " & "'" & qsLOG_INIT_UPD & "', "
SQLUPDATE=SQLUPDATE & "LOG_UID = " & "'" & qsLOG_UID & "', "
SQLUPDATE=SQLUPDATE & "PURPOSE = " & "'" & qsPURPOSE & "', "
SQLUPDATE=SQLUPDATE & "CHG_DTL = " & "'" & qsCHG_DTL & "', "
SQLUPDATE=SQLUPDATE & "SW_SYSTEM = " & "'" & qsSW_SYSTEM & "' "
SQLUPDATE=SQLUPDATE & " Where REC_NUM = " & qsRECNUM
conn.Execute(SQLUPDATE)
generates:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[NEON][SCOD32.DLL][DB2]DSNT408I SQLCODE = -102, ERROR: LITERAL STRING IS TOO LONG. STRING BEGINS xxxxxxx

/dss/ProdChangeLog/update_Taudit.asp, line 50


the string beginning displayed is actually the first characters in qsPURPOSE of line 5 above.

The line reference for the problem is line 9

The form fields that source qsPURPOSE and qsCHG_DTL are both 1kb varchars in DB2 table. The form fiield textareas are limited at 1000 chars.

I am stumped. I know this is a total newbie problem and I hang my head in shame.

Can anyone make heads or tails of this?

From http://developmentnow.com/g/62_2004_...sp-general.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com