p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Professional (http://p2p.wrox.com/forumdisplay.php?f=63)
-   -   while loop (http://p2p.wrox.com/showthread.php?t=34010)

mikedeepak October 5th, 2005 03:32 AM

while loop
 
i have table name loan with 2 columns
while i retrieved and using recordset i got the result like the below list
<%
While not rs.eof
response.write rs(0) & "- " rs(1)
rs.movenext
wend
%>
Result is
Personal Loan – PLType1
Personal Loan – PLType 2
Personal Loan – PLType 3
Personal Loan – PLType 4
Home Loan - HLType1
Home Loan - HLType2

now i need to display the result as

Personal Loan(PLType1/PLType2/PLType3/PLType4)
Home Loan(HLType1/HLType2)


Could any one help to make the result

jrwlkn October 6th, 2005 11:13 AM

Do you need the new result to appear exclusively or have that result be the only one to appear


happygv October 7th, 2005 04:46 AM

MikeDeepak,

Do not repost the queries in more than one section just for the sake of seeking quick reply. If you are not sure of to which section your query belongs, post that on one section which closely suits your query, thus saving the time of both the viewer's and yours.

FYI, This has been answered on the other thread.

Cheers

_________________________
- Vijay G
Strive for Perfection

mikedeepak October 11th, 2005 03:34 AM

happygv,
OK,thanks for your Information..



All times are GMT -4. The time now is 07:48 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.