Hello I'm new to ColdFusion, for my work I've been asked to learn it..
I'm coming from an extensive PHP background. For the life of me I cannot figure out how to simply take a query from SQL and load it into an array and then display it. I though this would be a very simple task which has become a headache.
Anyhow come code:
<!--- Show user details ---> <cfquery name="at" datasource="sql"> SELECT * FROM tbladmins </cfquery> <cfset FieldIArray = ListToArray(at)> <cfoutput>#FieldIArray#</cfoutput>
The error lies in the cfset field, I don't understand how I can extract data from the query?
Can someone help thanks..