Re: columnlist value

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

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

need columnlist help

Hello, Trying to do queryname.columnlist and it is putting it in a different order then the database any idea why or how to fix. code below and looking for it to be in the order of the select part. cfquery name=Excelfile datasource=#query_datasource# username=#query_username#

Re: need columnlist help

PROTECTED] Sent: Saturday, February 16, 2002 11:09 PM Subject: need columnlist help Hello, Trying to do queryname.columnlist and it is putting it in a different order then the database any idea why or how to fix. code below and looking for it to be in the order of the select part

ColumnList

I just saw Saro's post from early October, complaining about the ordering of the columns in CFQUERY's ColumnList property. I have a pure-CFML custom tag, CF_ColumnList, which will return the columns in the order you'd expect. The tag is available at Allaire's Developers Exchange; here's

Re: ColumnList

Excellent find, David! I never noticed that before. Seems like it would be easier for them to return ColumnList in the proper order and then we could just use ListSort() if we want it sorted. Nelson - Original Message - From: David Shadovitz [EMAIL PROTECTED] To: CF-Talk [EMAIL

RE: columnlist

Professional Macromedia Certified Web Site Developer [EMAIL PROTECTED] www.doceus.com -Original Message- From: saro cf [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 6:43 PM To: CF-Talk Subject: columnlist How to preserve the ordering of columnlist returned by cfquery

RE: columnlist

-solutions.com http://www.biznet-solutions.com/ -Original Message- From: Nate Smith [mailto:[EMAIL PROTECTED]] Sent: 05 October 2001 15:45 To: CF-Talk Subject: RE: columnlist I'm not sure if there is a way to return the column names from a query result set in the query order. However, if you

RE: columnlist

The original poster wanted the columns in the order specified in the database. So your post of: Or Queryname.Columnlist Jerry Staple would not work. The only way to do that, to the best of my current knowledge, is to query the system tables. - Nate Smith, Lead Developer

columnlist

How to preserve the ordering of columnlist returned by cfquery. By default it is ordering by alphabetical. I need the same column order specified in table. -Saro -- saro cf [EMAIL PROTECTED] - email (818) 630-2340 x6093 - voicemail/fax

Re: columnlist

. A query object is an array of structures. One element in the array for each row in the result set. And each row contains a structure... What is the application? At 03:43 PM 10/04/2001 -0700, you wrote: How to preserve the ordering of columnlist returned by cfquery. By default it is ordering

Query columnlist order in 4.0?

L 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEQuery columnlist order in 4.0?/TITLE /HEAD BODY PFONT SIZE=3D2 FACE=3D&q

RE: Query columnlist order in 4.0?

You can dump the query.ColumnList into a new variable and re-sort it however you please, perhaps using ListSort(). -Original Message- From: Williams, Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 5:15 PM To: CF-Talk Subject: Query columnlist order in 4.0

columnlist

hi all, To retrieve the columnlist from the table i'm using #queryname.columnlist# by doing this i'm getting all the columnnames, no problems, but itz not giving the output in the same way in which i created in the table. eg: in the database i've got the table, fields consists of eno,ename

RE: columnlist

To: CF-Talk Subject: columnlist hi all, To retrieve the columnlist from the table i'm using #queryname.columnlist# by doing this i'm getting all the columnnames, no problems, but itz not giving the output in the same way in which i created in the table. eg: in the database i've got