I did find the problem (at least with this particular query. I'm thinking I should still figure out this driver thing.) I had a column percentEffort DECIMAL(4,1) and that was causing problems. I changed it to FLOAT and it all works now.
I did go through and check all of my "output"s though and some were still set to true from debugging. Thanks Joelle Doug Boude (rhymes with 'loud') wrote: > Joelle, If you subsitute in a known good ID instead of the variable values > for project ID, does your cfquery work then? I'm suspecting that perhaps the > getProjectID() method in the cfc may not have its "output" attribute set to > false, thus possibly returning some extra space with your actual project ID. > > Just something to look at. > > Doug :0) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
