I can't use mysqldump as client wants an interface to select the tables. I tried with the following code:
<cfloop list="#selec.columnlist#" index="columnname"> #selec[columnname][currentRow]# </cfloop> but this will display one column name at a time, but i need to write something like this Insert into table values (#id#,#name#) any help would be appreciated >You'll need something like this: > ><cfloop list="#selec.columnlist#" index="field"> > #selec[columnList][currentRow]# ></cfloop> > >Though I'd recommend you use a dump/import rather than a SELECT/INSERT >mechanism to do it. Be a lot faster, and probably easier on your >brain. MySQL has a very nice 'mysqldump' utility that'll output your >data in raw format that is customizable up the wazoo, and then you can >just import that into SQL Server directly. > >cheers, >barneyb > >On 9/25/05, simmyana a <[EMAIL PROTECTED]> wrote: > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/ > >Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
