The value for the "?" will be shown after the query in the debugging output labelled Parameter # 1. All is well...don't fret ;-)
Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 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: "Jason Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 16, 2002 1:36 PM Subject: cfqueryparam problem > I'm trying to perfom the following: > > <cfquery name="Get_email" datasource="users" dbtype="odbc"> > SELECT TOP 1 User_Name > FROM Users > WHERE User_Email='<cfqueryparam value="#Form.User_Email#">' > </cfquery> > > while outputting <cfoutput query="Get_email">#User_Name#</cfoutput> > I'm receiving this: "?" (MSSQL 2K). > > when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right >answer. > > Is there a known issue or something I misunderstood on string w/ cfqueryparam? > > Thanks. > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
