You just output the query <cfoutput query="queryname"> </cfoutput>
And inside the cfoutput you reference your columns Firstname : #firstname# Lastname : #lastname# Etc - Russ -----Original Message----- From: Jason Slack [mailto:[EMAIL PROTECTED] Sent: 11 November 2006 21:36 To: CF-Talk Subject: Re: RE: Data from MySQL 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. -Jason On 11/11/06, Matt Quackenbush <[EMAIL PROTECTED]> wrote: > http://livedocs.macromedia.com/coldfusion/7/index.html > > LiveDocs is your friend. Arguably your best friend. :-) > > > > -----Original Message----- > From: Jason Slack [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 11, 2006 3:13 PM > To: CF-Talk > Subject: Data from MySQL > > So I am doing good on my 2nd day with CF. > > 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. > > Thanks, > > -jason > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:260025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
