Re: columnlist value

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

columnlist value

Hi, How can I dynamically get value of columnlist. I need to port data from MySql to MS SQL DB. This is what I am trying to do; cfset InsValueList= cfquery name=getTables datasource=db1 show tables /cfquery cfloop query=getTables cfquery name=Selec datasourcedb1 Select *

Re: columnlist value

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'