Perhaps you should create the columns in the database in alphabetical order.
Why does this matter? What are you trying to do?
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 10, 2000 3:32 AM
> 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 the table, fields consists of eno,ename,phone
> Once i retrieved the columnlist i should get in the same order but i'm
> getting ename,eno,phone(may be itz giving in alphabetical order)
>
> how to solve this, any suggetions would be appreciated.
>
> thanx in advance
> ramesh
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
