retrieve the fields name of a table

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

This topic has been closed for replies.

Inspiring

select * from yourtable where 1 = 2

The resulting columnlist will give you all the field names.

Inspiring

A better approach might be to use <cfdbinfo>.

--

Adam

A

Anonymous

Thanks. It worked for me.

Sign up