[thelist] Data Shaping and Count

Joshua Olson joshua at waetech.com
Mon May 9 10:36:13 CDT 2005


> -----Original Message-----
> From: Michele Foster (WizarDev)
> Sent: Monday, May 09, 2005 11:17 AM
> 
> I have this query ....
> 
> strShapeSQL = "SHAPE... (complex query here...)"
> 
> Which gives me,
> 
> JobTitle1 (PositionEn)
>     Applicant1 (FirstName, LastName)
>     Applicant2
>     Applicant3
> 
> JobTitle2
>     Applicant1
>     Applicant2
> etc.

Michele,

Before we delve into a solution for your other problem... is there a real
need here for data shaping?  Have you tried to tackle this with normal SQL
and some creative output looping?

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/




More information about the thelist mailing list