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/
