NYCPHP Meetup

[Phil Powell]

Ahh.. it WAS a Cartesian product in the long run.. I found this one 
buried query somewhere in the mountain of code that pulls up a few other 
list pages (pages of lists of interns) and the query indeed pulls a 
Cartesian product (including in one instance a boatload of empty rows to 
display on the screen).. thanx for your help!

Phil

John Lacey wrote:

>
>
> Phil Powell wrote:
>
>> John Lacey wrote:
>>
>>>
>>> prolly got a Cartesian product in the query... 
>>
>>
>>
>>
>> Actually, some of the queries could be producing Cartesian products, 
>> but there are those that simply have this:
>>
>> SELECT id, fname, lname, gpa, major, minor FROM interns ORDER BY 
>> lname, date desc
>>
>> For queries such as these (this is one of the queries that has on 
>> occasions thrown the Fatal Error upon attempt to use mysql_query() 
>> upon this statement (occurs in about 5 different scripts now).
>>
>
> seems the query as indicated above, would not yield a CP, since it's 
> only a single table... I notice you're ordering by some columns that 
> are not in the requested list of fields you want returned... if you 
> can duplicate it, either try eliminating the date and desc in the 
> ORDER BY clause or include them in the SELECTED field list...
>
> doing this may lead to some further insights...
>
>
> however, have you thought of the possibility that
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
>


-- 
Phil Powell
Web Developer
  ADNET Systems, Inc.
  11260 Roger Bacon Drive, Suite 403
  Reston, VA  20190-5203
Phone: (703) 709-7218 x107   Cell: (571) 437-4430   FAX: (703) 709-7219
EMail:  Phillip.Powell at adnet-sys.com      AOL IM: SOA Dude






>From hans not junk at nyphp.com  Wed Mar 17 16:18:49 2004
Return-Path: <hans not junk at nyphp.com>
Received: from ehost011-1.exch011.intermedia.net (unknown [64.78.21.3])
	by virtu.nyphp.org (Postfix) with ESMTP id A1D8DA87D6
	for <talk at lists.nyphp.org>; Wed, 17 Mar 2004 16:18:49 -0500 (EST)
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 17 Mar 2004 13:20:31 -0800
Message-ID: <41EE526EC2D3C74286415780D3BA9F87FE4010 at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Document Management....
Thread-Index: AcQMWqBA3RRRIqPyR+GRc7isdqfkNwAB6Wc5AADJkYA=
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Subject: [nycphp-talk] RE: Document Management....
X-BeenThere: talk at lists.nyphp.org
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: NYPHP Talk <talk at lists.nyphp.org>
List-Id: NYPHP Talk  <talk.lists.nyphp.org>
List-Unsubscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=unsubscribe>
List-Archive: <http://lists.nyphp.org/pipermail/talk>
List-Post: <mailto:talk at lists.nyphp.org>
List-Help: <mailto:talk-request at lists.nyphp.org?subject=help>
List-Subscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=subscribe>
X-List-Received-Date: Wed, 17 Mar 2004 21:18:50 -0000


> OK guys, I got spoiled.  I read a very kewl article a while=20
> back at Dev Shed about how to build a Document Management=20
> open source tool (check it out:=20
> http://www.devshed.com/c/a/PHP/Cracking-The-Vault-%28part-1%29).
> =20
> However, it used PHP & MySQL  (my perfered developemnt=20
> tools)..  Now I need to get a basic Document Managment=20
> solution for a customer using CF (4.5 or MX) and Access or=20
> Oracle.  They DON'T need all the bells and whistles and they=20
> don't need content management.

Out of curiosity, why must it be in CF?  And for that matter, why
Access?  PHP/Oracle would be a nice combo, but CF/Access... eek.

Sorry though; don't know of anything that would do this in the CF world,
although there's certainly some commercial packages I'm sure.  That
said, just code it in PHP and have the parser parse .cfm as .php  :)

H