On 1/21/06, liamlambert <[EMAIL PROTECTED]> wrote: > I would like to put the costumer detales into the fields > userID,name,Phone.....ect > with a repeat command but am stuck here > > > get fld "showID" > put it into tshowID > put "SELECT > userID,name,phone,address,address1,address,email,showID FROM > costumer" WHERE SHOWID = '" & tshowID & "'" into tSQLCostm > --> EXECUTE SQL > put revdb_querylist(,,gConID,tSQLCostm) into tListCostm > put tListCostm into fld "costumerlist" > > put "userID,name,phone,address,address1,address2,email,showID" > into tFieldNames
Assuming the items in the SQL query come back tab-delimited, this is what I would do: put "userID,name,phone,address,address1,address2,email,showID" into tFieldNames replace comma with tab in tFieldNames -- so they are also tab-delimited set the itemDelimiter to tab repeat with x = 1 to the number of items in tFieldNames put item x of tListCostm into fld (item x of tFieldNames) end repeat HTH, Sarah _______________________________________________ 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