iREv mysql and revexecuteSQL problem?

[Bob Sneidar]

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. 

Bob


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."
>   else
>      answer error "There was a problem updating the record to the database:" & cr & tData
>   end if
> end mouseUp
> 
> 
> John Patten
> SUSD
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode