Dumb ASP question (including not being able to find the ASP section)
Posted by:
John Sharp
Date: March 30, 2006 03:13AM
Folks,
I think I'm being dumb but don't know how or why.
I've got a table with the last field of type TEXT, when I add data to it through the MySQL Data tool it works perfectly well but trying to do an insert through ADO doesn't.
The code fragment, if it'll help.
strSQL = "select * from table"
oRec.Open strSQL, oConn, 1, 2
oRec("varchar1") = value1
oRec("date1") = value2
oRec("textfield") = value3
oRec.Update
Further to playing around with the code it appears that I can only add new records to the table as long as the data going into the textfield is shorter or equal in length to data that already appears in the table.
Please help.
John
Subject
Written By
Posted
Dumb ASP question (including not being able to find the ASP section)
March 30, 2006 03:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.