I'm migrating from mssql to mysql due to the cost of licensing with macrosoft. Most of the sql statements in my application have transferred without any problem. However, when I do a recordset addnew and then update on this one page, I get "Invalid string or buffer length".
Here is the addnew code:
Does anyone else have experience with mysql to know why this may be bombing out?
Thanks
Here is the addnew code:
Code:
set rsCart = server.CreateObject("adodb.recordset")
rsCart.Open "tblCartItems",objConn,3,3
rsCart.AddNew
rsCart("CartID") = session("cart")
rsCart("ItemID") = ProdID
rsCart("Quantity") = Quant
if rsCart("PlasticColor") <> "" Then rsCart("PlasticColor") = PlasticColor
rsCart("ShapeNum") = shape
rsCart("Sides") = numsides
rsCart("NumInksA") = numInksa
if numInksB <> "" Then rsCart("NumInksB") = numInksB
rsCart("InkColor1") = inkcol(1)
rsCart("InkColor2") = inkcol(2)
rsCart("InkColor3") = inkcol(3)
rsCart("InkColor4") = inkcol(4)
rsCart("InkColor5") = inkcol(5)
rsCart("InkColor6") = inkcol(6)
rsCart("InkColor7") = inkcol(7)
if numInksB > 0 Then
rsCart("InkColorB1") = inkcol2(1)
rsCart("InkColorB2") = inkcol2(2)
rsCart("InkColorB3") = inkcol2(3)
rsCart("InkColorB4") = inkcol2(4)
rsCart("InkColorB5") = inkcol2(5)
rsCart("InkColorB6") = inkcol2(6)
rsCart("InkColorB7") = inkcol2(7)
end if
delim = instr(Opt,",")
if instr(Opt,",") Then rsCart("OptName") = left(Opt,delim - 1)
if instr(Opt,",") Then rsCart("OptPrice") = mid(Opt,delim + 1)
rsCart("Comments") = comments
rsCart("PMSCharge") = PMSCharge
rsCart.Update
rsCart.close
set rsCart = nothing
Does anyone else have experience with mysql to know why this may be bombing out?
Thanks