repeat with
Jim Ault
JimAultWins at yahoo.com
Fri Jan 13 19:14:23 EST 2006
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" <liamlambert at mac.com> 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
>
>
More information about the use-livecode
mailing list