,Greg wrote:
> OK, I'm trying to use cfqueryparam on a varchar field insert and it's
> inserting a "?" even though I'm entering a value in the form field that's
> posting to this query. Anyone know what's wrong here?
> 
> VALUES ('<cfqueryparam value="#Trim(Attributes.firstname)#"
> cfsqltype="CF_SQL_CHAR"
> null="#YesNoFormat(Len(Trim(Attributes.firstname)))#">',...

No quotes around cfqueryparam. Never.

Jochem

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at http://www.coolfusion.com

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to