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. ********************************************************************** ______________________________________________________________________ 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
