Is the data from the query going to be always structured so neatly? ie. will "fieldValue" always start at 1?
You could loop through the query and convert it to an Array of Structures or something? Gareth. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steve Onnis Sent: Friday, 20 August 2004 1:51 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Simplified recordset. Have fun your going to have to do some nice grouping with your query and play around with the output it can be done, just a little mucking about Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ricardo Russon Sent: Friday, August 20, 2004 1:32 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Simplified recordset. MySQL. 4.1.1a Steve Onnis wrote: > what database system you using? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ricardo > Russon > Sent: Friday, August 20, 2004 1:10 PM > To: CFAussie Mailing List > Subject: [cfaussie] Simplified recordset. > > > excuse me while i think out in open space, But if any one has any ideas, > please throw them back at me. > > The table is structured in a fairly complex way. and it has to be this way. > It relates to 2 other tables for different reasons. > > So the complex table that i need to simplify on output is something like.. > > id clientID fieldValue value > 1 1 1 firstName1 > 2 1 2 middleName1 > 3 1 3 lastName1 > 4 2 1 firstName2 > 5 2 2 middleName2 > 6 2 3 lastName2 > 7 3 1 firstName3 > > and so on... > there are other values stored in that table, but i don't need them for this. > > What i want to get out of it is something like. > > clientID 1 2 3 > 1 firstName1 middleName1 lastName1 > 2 firstName2 middleName2 lastName2 > 3 firstName3 middleName3 lastName3 > > I guess what i am really trying to figure out is if i can do this against > the database, or if i have to recreate the table on the cf. > > There is another step which i left out, that the column names (1,2,3...) > actually get their values from another table. But that opens up so many > more problems... > > baby steps. > > TIA > Ricardo. > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
