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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode