Jason Davis wrote: > 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?
Loose the quotes and use a cf_sql_type: WHERE User_Email = <cfqueryparam value="#Form.User_Email#" cfsqltype="cf_sql_varchar"> Jochem ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
