repeat with

[liamlambert]

I am trying to tidy up this code with repeat but haveing trubble
This works fine
get field "name1"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "phone"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "child"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "adult"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "total"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "credit"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "paymenttype"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "address"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "address1"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "address2"
   put "'" & cleanSQL(it) & "'" & "," after tRowData
   get field "email"
   put "'" & cleanSQL(it) & "'"  & "," after tRowData
   get field "seatNo"
   put "'" & cleanSQL(it) & "'"  & "," after tRowData
   get field "ticket"
   put "'" & cleanSQL(it) & "'"  & "," after tRowData
   get field "showID"
   put "'" & cleanSQL(it) & "'" after tRowData

this does not

get field  
"name1,phone,child,adult,total,credit,paymenttype,address,address1,addre 
ss2,email,seatNo,ticket,showID"
   put it into tColData
   repeat with i = to number of items in tColData
     put "'" & cleanSQL(it) & "'" & "," after tRowData
   end repeat

thanks
Liam Lambert
liamlambert at mac.com
IRELAND