Query problems with cfqueryparm

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phillip Loya - 16 Mar 2007 19:18 GMT

Any ideas to why this wouldn't be working properly.

<cfparam name="FORM.login" default="1">
<cfquery name="Recordset1" datasource="userLogin2">
SELECT welcome
FROM Book1
WHERE user_name =
<cfqueryparam value="#FORM.login#" cfsqltype="cf_sql_clob" maxlength="255">
</cfquery>

Welcome <cfoutput>#Recordset1.welcome#</cfoutput>, thank-you for signing in.

Reply to this Message

Dan Bracuk - 16 Mar 2007 20:04 GMT

What is the datatype of book1.user_name in your db?

Reply to this Message

Phillip Loya - 16 Mar 2007 20:21 GMT

it's text.

Reply to this Message

Dan Bracuk - 16 Mar 2007 22:34 GMT

[q][i]Originally posted by: [b][b]Phillip Loya[/b][/b][/i]
it's text.[/q]
Use varchar, not clob for your cfsqltype attribute

Reply to this Message

Adam Cameron - 17 Mar 2007 00:24 GMT

> Any ideas to why this wouldn't be working properly.

Not without you giving us some hint as to why you think it's not "working
properly", no (*).

I can confidently say that no-one using these forums seems telepathic.

Signature

Adam

(*) actually, I have an idea, but unless yuo more accurately describe your
problem, I dunno.

Reply to this Message

cgsj_usa@yahoo.com - 30 Mar 2007 13:08 GMT

Change the "cfsqltype" in the "cfqueryparam" tag to be varchar. Thanks.

Chris

Reply to this Message

Webmaster Forum / ColdFusion / Getting Started / March 2007

Query problems with cfqueryparm