M
mscertified
I am running a query via an OLEDB connection from an HTML web page.
The syntax is:
db.execute("exec qryWebInsertPortal '" & strAssignmentGroup & "', '" &
strClientID & "', '" & strKeyWords & "', '" & strState & "', '" & strEmailSub
& "', '" & strHITicketNo & "', '" & strBarCode & "', '" & strProblem & "', '"
& strAltPhoneSub & "'" )
This just does an INSERT to an Access table.
What is happening is that sometimes the value in 'strProblem' (which can be
a very long string of text) does not make it to the destination table (the
other values do make it). There are no special characters or anything in the
string. I tested it with just repeating 'x''s.
This seems to happen randomly but now I'm wondering if there is a length
limit on a query parameter or maybe on the entire query. In my tests I got
some failures when the strProblem value exceeded 1110 characters. In Access,
this is a memo column.
The syntax is:
db.execute("exec qryWebInsertPortal '" & strAssignmentGroup & "', '" &
strClientID & "', '" & strKeyWords & "', '" & strState & "', '" & strEmailSub
& "', '" & strHITicketNo & "', '" & strBarCode & "', '" & strProblem & "', '"
& strAltPhoneSub & "'" )
This just does an INSERT to an Access table.
What is happening is that sometimes the value in 'strProblem' (which can be
a very long string of text) does not make it to the destination table (the
other values do make it). There are no special characters or anything in the
string. I tested it with just repeating 'x''s.
This seems to happen randomly but now I'm wondering if there is a length
limit on a query parameter or maybe on the entire query. In my tests I got
some failures when the strProblem value exceeded 1110 characters. In Access,
this is a memo column.