[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>")
	End If

I get this from one recordset;

Mineral Insulated Cable (productdesc)
MIQ (productid)
Power Limiting Heating Cable
Self-Regulating Heating Cable
RSX 15-2
Series Constant Watt Heating Cable

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?


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