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[0]#</cfoutput>
The error lies in the cfset field, I don't understand how I can extract data from the query?
Can someone help thanks..