iREv mysql and revexecuteSQL problem?
bobs at twft.com
Mon Aug 8 11:51:40 EDT 2011
I would have to see the error. If the record gets created, it is probably not a critical error, and it is almost definitely an SQL error.
On Aug 7, 2011, at 12:21 PM, John Patten wrote:
> Hi All... (sending this in two parts, I tried to send it before but never saw it show up on list...length maybe?)
> First Part:
> 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:
> on mouseUp
> 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
> end if
> end mouseUp
> John Patten
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode