stick with double quotes and # around the variable for your DSN: <cfquery name="DupCheck" datasource="#myDSN#">
Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Mike Miessen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 9:46 AM Subject: RE: newbie school of hard knocks > Great! I think this will help. > OK I have a variable named myDSN which holds the database name. > When I write my query do I use double quotes or should I use single > quotes? Do I need quotes? > > Which one of these is correct? > > <cfquery name="DupCheck" datasource="myDSN"> > <cfquery name="DupCheck" datasource="#myDSN#"> > <cfquery name="DupCheck" datasource='#myDSN#'> > <cfquery name="DupCheck" datasource=myDSN> > > > Thanks. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
