Liam, One more suggestion when working with SQL strings... try the following...
put "'" into ap --stands for apostrophe put ap & cleanSQL (field tField) & ap & "," after tRowData which is much easier to read and type than put "'" & cleanSQL (field tField) & "'" & "," after tRowData instead, you could use put numtochar(39) into ap Jim Ault Las Vegas On 1/13/06 12:45 PM, "liamlambert" <[EMAIL PROTECTED]> wrote: > I have not set the itemDel > > on fSave > global gConID > > if fld "total" is empty then > answer error "THERE IS NO TOTAL" as sheet exit to top > end if > > put > "name1,phone,child,adult,total,credit,paymenttype,address,address1,addre > ss2,email,seatNo,ticket,showID" into tFieldNames > repeat for each item tField in tFieldNames > put "'" & cleanSQL (field tField) & "'" & "," after tRowData > end repeat > > _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution