you create a Datasource name in the administrator (pointing a name to the MDB file). The Name attribute is for you to name your query results variable. Datasoure="" will point to the Datasource name you set up in the admin. Then you just write regular SQL inbetween the two <CFQUERY> tags.
HTH -----Original Message----- From: Sean Nelson [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 11:46 AM To: CF-Talk Subject: using cfquery Sorry for what is probably the easiest question for you folks but hey I'm new to this. Short and sweet. Do I have to create the query in the database itself and then use the name in the <cfquery name="whatever" datasource="database.mdb">or does CF just tell the DB what the query is in its own language? --------------------------------- Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4