Hi
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.
example query (simple one but the same thing is happening everywhere i put
cfqueryparam in)
<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>
- datasource works fine with queries not using cfparam
-i have tested to ensure that the variables are there and corect
- the query should return a result but dosent
- 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 ?
Does anyone have any idea if i am doing something wrong or if this is a bug in cfmx?
any help would be greatly appreciated.
Thanks,
Diarmuid King
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.456 / Virus Database: 256 - Release Date: 2/18/2003
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
