|
-
March 19th, 2009, 07:37 AM
#12
Re: BLOB & MySQL problem
we have progress, I found that I missed a post from above. My new code is:
modMySql.MySQLQuery = "UPDATE " & modMySql.MySQLDatabase & ".btt SET ScreenShot = ?FileUpload WHERE Ticket=?TN"
modMySql.MySQLConnection.Open()
modMySql.MySQLCommand.CommandText = modMySql.MySQLQuery
modMySql.MySQLCommand.Prepare()
modMySql.MySQLCommand.Parameters.Clear()
modMySql.MySQLCommand.Parameters.Add("?FileUpload", ScreenFile)
modMySql.MySQLCommand.Parameters.Add("?TN", strTicketNo)
My new error is:
+ ex {"Data too long for column 'ScreenShot' at row 52"} System.Exception
Any ideas on this error? Thanks again for all your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|