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 > > > > > > >