Ask a Question related to Coldfusion - Getting Started, Design and Development.
-
SupDave #1
cfqueryparam
Hi, I am trying to take values passed through a form and do a search based on
that, but I am getting an error
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 3: Incorrect syntax near
','.
My code looks like this: (form.type is equal to "Single family
home,Townhouse,Condo")
<cfquery name="fheidlookup" datasource="custom">
select *
from dbo."fhe_listings"
where property_style=<cfqueryparam value="#form.type" list="yes">
</cfquery>
I apperciate the help
SupDave Guest
-
Problem using cfqueryparam
CF throw me an error if I use <cfqueryparam cfsqltype="cf_sql_longvarchar"... on MS Access Memo field. My data in the Memo field is around 1000+... -
cfqueryparam and mysql
I have a question, is cfqueryparam's cfsqltype attribute database dependent? For example, in the LiveDocs, there is no mention of mysql's mediumint... -
CFQUERYPARAM Error
Hello, I am using MX7 and am having problems with cfqueryparam. I am new to a project and the old code does not use them and everything I have... -
sql in operator with cfqueryPARAM
here is my query select distinct option_type, description, id from option_types where id NOT IN(<cfqueryPARAM value = "#mikeslist#" CFSQLType =... -
cfqueryparam question
Hi, all. I am not too sure where to put the cfqueryparam in my code below. Alos for for this code: where id =... -
mxstu #2 Re: cfqueryparam
If you're searching a list of values, use WHERE ... IN instead of equals "="
WHERE property_style IN (<cfqueryparam value="#form.type" list="yes">)
Also, its better to specify the columns you need in the SELECT statement
Instead of using SELECT * .
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
