> How does one get data from MySQL? I can write the query and > get a resultset back, but how do I get inside the resultset? > > Like say I query a table called Locations and gets > Locationname in return. > > How do I use Locationname values in my app? I want the value > from the record that is returned. > > I have everything written (query, etc) just need to get the > data out of the row that is returned.
If your query looks like this: <cfquery name="qLocations" ...> SELECT Locationname FROM Locations </cfquery> you could output the first Locationname value like this: <cfoutput>#qLocations.Locationname#</cfoutput> You could loop over the query to write all the values like this: <cfoutput query="qLocations"> #qLocations.Locationname#<br/> </cfoutput> > I have been searching on LiveDocs for an hour and not finding > what I need. I guess I dont know how to formulate my query > into words that get me the right answer. I suggest you read the section of the documentation entitled "Getting Started Building ColdFusion MX Applications". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
