RE: [PHP] odbc_exec

Hi Bernie, I suggest you analyze your trace to see why too many results are coming back. Another alternative is to try a different ODBC driver - Openlink's drivers work quite well with PHP. Please let me know if I may be of assistance. 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: Monday, November 27, 2000 8:23 PM > To: Andrew Hill > Cc: php-general@lists.php.net > Subject: RE: [PHP] odbc_exec > > > Thanks Andrew. > > I used the query analyzer of sql server 7 to execute my query (native sql > interface right?) > > I am only a novice user of sql server 7. > > On Mon, 27 Nov 2000, Andrew Hill wrote: > > > Date: Mon, 27 Nov 2000 09:06:38 -0500 > > From: Andrew Hill <ahill@openlinksw.com> > > To: Bernie Terrado <bbt@teamyehey.com> > > Cc: php-general@lists.php.net > > Subject: RE: [PHP] odbc_exec > > > > Bernie, > > > > Tracing can be enabled in the "Tracing" tab of the ODBC Administrator > > control panel. > > > > Again, have you tried this query via the native SQL interface of the > > database you are using? > > > > 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: Wednesday, November 22, 2000 9:49 PM > > > To: Andrew Hill > > > Cc: php-general@lists.php.net > > > Subject: 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > 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 > > >