iREv mysql and revexecuteSQL problem?
johnpatten at mac.com
Sun Aug 7 14:21:38 CDT 2011
Hi All... (sending this in two parts, I tried to send it before but never saw it show up on list...length maybe?)
I'm still having problems with a irev mysql file. I'm attempting to create a new record in a table. The new record gets created by I still seem to get errors reported back.
Here's what I have.
>From the rev stack:
set the itemDel to Tab
put cd fld "tradeeID" of cd 3 into tTradeeID
put cd fld "playerID" of cd 3 into tPlayerID
put item 2 of cd fld "myItem" of cd 3 into tMyItem
put item 2 of cd fld "theirItem" of cd 3 into tTheirItem
put tTradeeID & tab & tPlayerID & tab & tMyItem & tab & tTheirItem into tTradeVariables
put "mymessage="&URLEncode(tTradeVariables) into tTradeVariables
post tTradeVariables to URL "http://myaccount.on-rev.com/conference/offertrade.irev "
put it into tData
if tData is a number then
answer info "New record added."
answer error "There was a problem updating the record to the database:" & cr & tData
More information about the use-livecode