Phillip Thanks, I've done it and it works without a problem, but...
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? Kola -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 14:00 To: CF-Talk Subject: RE: Manually created queries,any limitations? I'll break this into small parts; > I have a field in a database which contains data over > multiple rows in the database. > (I didn't design the database nor can i change it) I'm sorry <g> > i'd like to create a query object with the data from > the field(s) held in one row as opposed to multiple > rows. I'm considering creating a query object, adding a > row and setting the data in the cell To start off with, a created query, to all intence and purposes is exactly the same as a CFQUERY in memory - in fact you can modify the data in a CFQUERY returned data set by using QuerySetCell() > however i wondered if there are any limitations to the > length of data which can be held in cells manually created Nope, if it can contain a Text (SQL Server) or Memo (Access) field, then it can certainly contain any data you can throw at it - until you run out of server memory that is > and set also do queries created manually this way > behave like normal query objects (e.g. have a > recordcount field )? Exactly the same - I create queries at times instead of using an Array with Structures - they're easier to use (CFLOOP and CFOUTPUT), but more code to create Just remember that you should make sure you're writing to the correct row and all should be happy 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. ********************************************************************** ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
