Kludgy, but without subselects I end up using TRANSFORMs

Post #101,749 by tseliot 5/13/03 9:01:45 PM Reply	Kludgy, but without subselects I end up using TRANSFORMs `TRANSFORM status SELECT orderstatus.ordernum FROM orderstatus WHERE orderstatus.ordernum = '$ordernum' GROUP BY orderstatus.ordernum PIVOT orderstatus.status` Then pass through the result set and test for (($no_status Is Null) AND (Not $status Is Null)). Since you are filtering by ordernum in WHERE, your result set should always be one entry, I think. Did you intend that? Many fears are born of stupidity and ignorance - Which you should be feeding with rumour and generalisation. BOfH, 2002 "Episode" 10
Post #101,761 by drewk 5/13/03 9:53:00 PM Reply	Oops, didn't mean to filter on ordernum But in any case, it turns out my query was correct, and it was just taking far too long. I worked around the issue by requiring that you select a start date for an on-screen report, and warning the user that doing a printable report without a start date could take an extremely long time. Are `TRANSFORM` and `PIVOT` available in MySQL? I'm not familiar with them. === Implicitly condoning stupidity since 2001.
Post #102,103 by tseliot 5/15/03 1:09:48 PM Reply	Oops, no they're not. Teach me to flail out the shortcuts. Wow, no transform, no subselects...tell me again why you're using MySQL? >:) Many fears are born of stupidity and ignorance - Which you should be feeding with rumour and generalisation. BOfH, 2002 "Episode" 10
Post #102,127 by drewk 5/15/03 2:55:58 PM Reply	It was there when I was hired === Implicitly condoning stupidity since 2001.

Welcome to IWETHEY!