Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 2000051

[PHP3] odbc behaviour (was odbc_result getting same row) From: systems (systems <email protected>)
Date: 05/15/00

Hi, last week I posted a please for help with failing 'odbc_result' ...
>From experiments done on Friday and today, I think the odbc_result thing was
some kind of red herring. In trying suggestions from a couple of folks on
this list, I found that there was something a bit more fundamental going on.

ok, here's some really simple code:

<?php

  $id = odbc_connect("DSN=crime_no;UID=ingres;PWD=XXX","","");

  $res = odbc_exec("$id, "select pfid, fiscallocation from pf_fiscal");
  $x = odbc_result_all($res);

?>

- that works; it looks ok, all 14 rows in the table are printed.
->
 pfid fiscallocation

    AB CrownOffice
    DI Dingwall (etc etc)

Now, I change the exec to this:

  $res = odbc_exec("$id, "select pfid from pf_fiscal");

- what do I get now? - "No rows found" !!!!
- the *only* change I made to the code was to remove the column from the
select.
- I've tried various combinations of columns (select * was ok, select pfid
was ok...,
 select eaddress, pfid -no rows...)

Has anyone come across something like this? Am I doing something really
stupid?
(BTW, that table above has only 3 columns; none are nullable; none is larger
than 250 chars.)

(I could have sent this out on Friday afternoon, but thought I'd wait - just
in case I was really going crazy!...)

help <;-( ..

[Context: PHP 3.0.15; Apache 1.3.9; Linux (Red Hat 6.1); PHP running as
Apache module, compiled --with-iodbc --with-openlink. RDBMS is Ingres 6.4
on Unix (svr4)]

gordon gallacher
inverness

PS The openlink-provided 'odbctest' program running at the Linux prompt
gives the correct result set for all the queries above. 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>