Quoting Diarmuid King <[EMAIL PROTECTED]>: > > I am using cfmx pro version (with updater 2) on a RedHat Linux 7.2 system > connecting to MySQL 3.23.36 > > I just started updating my querys to use cfqueryparam and its not working.
> <CFQUERY datasource="#request.dsn#" name="getText"> > SELECT text > FROM home_page_text > WHERE wac_id = <CFQUERYPARAM cfsqltype="cf_sql_integer" > value="#arguments.wac_id#"> > </CFQUERY> Looks correct. > -i have tested to ensure that the variables are there and corect Have you verified that in the MySQL query log? http://www.mysql.com/doc/en/Query_log.html > - it runs without throwing an error but returns 0 results > > - in the debug output it shows the query like this > > SELECT text from home_page_text WHERE wac_id = ? > > - in every query i use a cfqueryparam in the query returns 0 results and the > debug output shows the queryparam var as a ? You can expand the debug view to see the values of the variables as well. 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
