MySQL Forums
Forum List  »  General

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

Options: ReplyQuote


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.