retrieve the fields name of a table

[Guest]

HI,

I need to write a loop to get the name of each fields in a table. I nedd something like

for each field.fieldname do something

thanks,

Mandana

[Dan_Bracuk]

select * from yourtable where 1 = 2

The resulting columnlist will give you all the field names.

[Adam Cameron.]

A better approach might be to use <cfdbinfo>.

--

Adam

[Guest]

Thanks. It worked for me.