> I'm trying to remember a while ago when I tried something > similar and I found some anomalies regarding datatypes. I > cant remember the details but think I had a query which > did something along the lines of: > > Select name from > Users where age < 6 > > Where users was actually another query created using querynew() > > But the what query produced was produced as all text datatypes > and the numerical comparisons were failing... > > Anyway to explicitly set the data types of queries created with > querynew?
This is because ColdFusion is type-less, so if you're running a Query a Query, then it might see the data-types as all text, but you can convert them with simple SQL functions, such as; Sele Name >From Users Where Val(Age) < 6 Give that a try and see what happens - it's a real problem with QaQ and certain Datatypes - wait until you try using Dates... Now THAT can be a problem Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
