How do I Compare Prices?

Thread: How do I Compare Prices?

1. Senior Member
Join Date
Dec 1969
Posts
228

How do I Compare Prices?

I finally figured out how to say this, now how do I do it?<BR><BR>How do I compare prices for data coming from two tables, so that for each, say airline flight, out of one table, the matching values from another are laid out for the end user to compare?<BR><BR>As in <BR><BR> ValueJET Aire TWAA PanAM <BR>London \$100 \$150 \$110 \$130<BR>Paris \$300 \$299 \$345 \$500<BR><BR>I have the headings part figured out, but do I get these prices laid out for comparison, if there is only the one &#060;%=rs("price")%&#062; after the &#060;%rs("destination"%&#062;.<BR><BR><BR>

2. Lastly Guest

RE: How do I Compare Prices?

Each price should be in its own cell in the table. Simply check to see if there is a price to be entered. if not, enter an &#039&nbsp;&#039 in that cell as a place holder, and move on to the next one.<BR><BR>Depending on how your code is written, you may need to identify how many columns of data (price) you have brought back, and then dynamically create the cells to fit the max size.

3. Senior Member
Join Date
Dec 1969
Posts
228

RE: How do I Compare Prices?

Okay, I figured it out. Yes, you were partly right, too! But for each price after the first one, the cursor must move to the next price in the table. So &#060;%rs.move 1%&#062;&#060;%=rs("price")%&#062; must be inserted in each table cell after the first "price" is displayed. BUT NOW HOW DO I GENERATE TABLE CELLS ON THE FLY?<BR><BR>&#060;table&#062;<BR>&#060;%do while not rs6.eof%&#062;<BR>&#060;tr&#062;<BR>&#060;td&#062; <BR>&#060;%=rs6("equipmentdesc")%&#062;<BR>&#060 ;/td&#062;<BR>&#060;td&#062;&#060;%=rs6("unitprice") %&#062;<BR>&#060;/td&#062;<BR>&#060;td&#062;<BR>&#060;%rs6.move 1%&#062;<BR>&#060;%=rs6("unitprice")%&#062;<BR>&#0 60;/td&#062;<BR>&#060;td&#062;<BR>&#060;%rs6.move 1%&#062;<BR>&#060;%=rs6("unitprice")%&#062;<BR>&#0 60;/td&#062;<BR>&#060;/tr&#062;<BR>&#060;/table&#062;<BR>&#060;%rs6.movenext<BR>loop%&#062;< BR>&#060;/table&#062;

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•