[thelist] ASP/SQL Question Almost Got It!
Jim Davis
jdavis at hy-tech.net
Fri Sep 14 15:27:56 CDT 2001
I may be joining the discussion a bit late, but are you using an InnerJoin
statment on your TABLES?
What is the final goal of this output?
Jim D
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of J. Blanchard
Sent: Friday, September 14, 2001 4:14 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] ASP/SQL Question Almost Got It!
Using this script ;
<%
DIM pd
pd = ""
While Not product.EOF
If pd <> (product.Fields.Item("ProductDesc").Value) Then
pd = (product.Fields.Item("ProductDesc").Value)
response.write (pd & "<br>")
While pd = (product.Fields.Item("ProductDesc").Value)
response.write ((product.Fields.Item("ProductID").Value) & "<br>")
product.MoveNext
Wend
End If
product.MoveNext
Wend
%>
I get this from one recordset;
Mineral Insulated Cable (productdesc)
MIQ (productid)
Power Limiting Heating Cable
HPT
D1-HPT
Self-Regulating Heating Cable
RSX
RSX 15-2
D1-RSX
TSX
D1-TSX
VSX
D1-VSX
Series Constant Watt Heating Cable
TEK
There are only a couple of bumps;
Not all of the productdesc's show up (you can comment out the do while loop
and they all show up), and have a similar existence...they are productdesc's
that have only one product in them and they ARE NOT the first
productdesc/productid. The first one, whil sharing a the same
characteristics, writes out fine.
On productdesc's with multiple productid's after the first
productdesc/productid combination the first productid for a productdesc is
not printed out.
I know I missed something in the code, but I have looked at it for too long
and can't see it. Can anyone help?
Thanks!
Jay Blanchard
Web Development Manager
Thermon Manufacturing Company
1.800.820.HEAT x327
___________________________________________________________________________
Visit http://www.visto.com.
Find out how companies are linking mobile users to the
enterprise with Visto.
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list