Re: Another Query to Table
Well David, that's the way... :-) Thanks a lot. Patric - Original Message - From: "David Gassner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 29, 2000 2:25 AM Subject: RE: Another Query to Table | Patric, you'll need to use the index array method of getting to query data. | Here's some code which does what you want, assuming a query named "q" and a | field called "fieldvalue": | | | | | | | | | | | | | | | | | | | | #dataindex#-#q.fieldvalue[dataIndex]# | | | | | | | | | David Gassner | Vintage Business Applications -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Another Query to Table
Patric, you'll need to use the index array method of getting to query data. Here's some code which does what you want, assuming a query named "q" and a field called "fieldvalue": #dataindex#-#q.fieldvalue[dataIndex]# David Gassner Vintage Business Applications > but i wanted it like > > 1 5 9 > 2 6 10 > 3 7 11 > 4 8 12 > > Hope this is possible...!?! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Another Query to Table
Hi Joe, thanks for your reply, but this ain't the way i wanted it to be displayed... the way you described is like 123 456 789 10 11 12 ... but i wanted it like 1 5 9 2 6 10 3 7 11 4 8 12 Hope this is possible...!?! Patric - Original Message - From: Joseph Eugene <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 28, 2000 8:15 PM Subject: Re: Another Query to Table > Patric, > I am not sure what you are trying to do? > Do you want to put a database query results in the > format described below?? > If so, here is the code. > > Select *from your_table. > > > > > > > #Your_Column# > > > > > > > > Hope this helps > > Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Another Query to Table
Patric, I am not sure what you are trying to do? Do you want to put a database query results in the format described below?? If so, here is the code. Select *from your_table. #Your_Column# Hope this helps Joe - Original Message - From: "Patric Stumpe" <[EMAIL PROTECTED]> To: "Cf-Talk" <[EMAIL PROTECTED]> Sent: Sunday, May 28, 2000 1:34 PM Subject: Another Query to Table > Well, another problem. > > I read the thread about 'Query to Table' but it didn't fit my need for > generating a table with three columns in the following format: > > 1 5 9 > 2 6 10 > 3 7 11 > 4 8 12 > > Then it should easily be possible to alter the row's bgcolor every second > row. > > Thanks... > > Patric Stumpe > > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Another Query to Table
Well, another problem. I read the thread about 'Query to Table' but it didn't fit my need for generating a table with three columns in the following format: 1 5 9 2 6 10 3 7 11 4 8 12 Then it should easily be possible to alter the row's bgcolor every second row. Thanks... Patric Stumpe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.