Thanks That would explain it. I was weary of using it for this recent project but as its all text its fine, thanks for the heads up regarding dates I'll stay clear of em...
Kola -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 14:29 To: CF-Talk Subject: RE: Manually created queries,any limitations? > 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. ********************************************************************** ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
