Question, We ran into this problem on MySQL 3.23.54 / Linux
If no url.id is passed, and you have the following code, it seems that if there is no url.id, cfqueryparam adds a ? and then requires '' around the cfqueryparam. Example <cfparam name="url.id" default=""> SELECT columns.... FROM table WHERE id = <cfqueryparam value="#url.id#" cfsqltype="CF_SQL_VARCHAR"> Now if no url.id isn't passed, it errors out not liking the '?" in the WHERE statement ... if you put ' around the '<cfqueryparam>' it runs just fine .... Any thoughts? Paul Giesenhagen QuillDesign ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
