RE: [PHP] odbc_exec

I am using NT. SQL Server 7 On Wed, 22 Nov 2000, Andrew Hill wrote: > Date: Wed, 22 Nov 2000 08:44:12 -0500 > From: Andrew Hill <ahill@openlinksw.com> > To: Bernie Terrado <bbt@teamyehey.com> > Cc: php-general@lists.php.net > Subject: RE: [PHP] odbc_exec > > Hi Bernie, > > Have you tried your query via the native SQL interface of whatever database > you are using? If this returns the expected results you can perform a trace > on the driver, and see exactly what it is doing. > > What odbc driver is this, and what driver mananger do you have compiled in > with PHP? The driver manager will determine how you perform the ODBC trace. > Also, what platform is this? > > Best regards, > Andrew > ---------------------------------------------------- > Andrew Hill > Director Technology Evangelism > OpenLink Software > http://www.openlinksw.com > XML & E-Business Infrastructure Technology Provider > > > > > -----Original Message----- > > From: Bernie Terrado [mailto:bbt@teamyehey.com] > > Sent: Tuesday, November 21, 2000 8:58 PM > > To: Andrew Hill > > Cc: php-general@lists.php.net > > Subject: RE: [PHP] odbc_exec > > > > > > Hello Andrew, > > > > I hope that is not the case. > > > > First I used a query analyzer to generate the results, just to make sure > > the execution does not result to an infinite loop. > > > > The query analyzer returned only 10 resluts (as an example). > > When I used the same query within odbc_exec and echoed the results, it > > echoed too many results(4000), i.e. redundant rows(values). > > > > Is there by any chance a query analyzer's results be different from that > > of odbc_exec's execution(results) when both have the same query? > > > > Thank you. > > > > > > Bernie > > (suggestion kept) > > > > On Tue, 21 Nov 2000, Andrew Hill wrote: > > > > > Date: Tue, 21 Nov 2000 08:13:55 -0500 > > > From: Andrew Hill <ahill@openlinksw.com> > > > To: bernie terrado <bbt@teamyehey.com>, php-general@lists.php.net > > > Subject: RE: [PHP] odbc_exec > > > > > > Hi Bernie, > > > > > > At first guess, you probably have generated what is called a 'cartesian > > > product' e.g. you are joining improperly. > > > > > > To verify, add a "distint" clause: (select distinct > > table1.field from ....) > > > If this returns the correct number of records, I would > > rearrange your select > > > via something like: > > > > > > select table1.field from table1, table2 where table1.id = table2.id and > > > table1.id = "value"; > > > > > > You can also try (depending on if your driver/database support SQL92) > > > something like > > > > > > select table1.field from table1 natural join table2 where table1.id = > > > "value" or > > > select table1.field from table1 join table2 on table1.id = table2.id and > > > table1.id = "value"; > > > > > > Hope this helps. > > > > > > Best regards, > > > Andrew > > > ---------------------------------------------------- > > > Andrew Hill > > > Director Technology Evangelism > > > OpenLink Software > > > http://www.openlinksw.com > > > XML & E-Business Infrastructure Technology Provider > > > > > > > > > > -----Original Message----- > > > > From: bernie terrado [mailto:bbt@teamyehey.com] > > > > Sent: Tuesday, November 21, 2000 1:34 AM > > > > To: php-general@lists.php.net > > > > Subject: [PHP] odbc_exec > > > > > > > > > > > > I have a problem.... > > > > > > > > it's about odbc_exec > > > > > > > > $topicgenquery = odbc_exec($conn,"select something.columns > > from tbl1 join > > > > tbl2 on tbl1.id = tbl2.id and tbl1.id =value;"); > > > > > > > > one odd thing i've noticed is it returns more than what it is > > supposed to > > > > have queried. > > > > > > > > There were only 13 rows to be returned but it returned 4002! > > > > > > > > Have encountered this kind of problem? > > > > > > > > > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > > For additional commands, e-mail: php-general-help@lists.php.net > > > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > > > > > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > >