Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 2000051

[PHP3] R: [PHP3] odbc behaviour (was odbc_result getting same row) From: Gibellini Paolo (p.gibellini <email protected>)
Date: 05/15/00

Hi
I have a configuration similar to your, and it works.
If your first query works, the other must works too.

Check, please, your call is:
  $res = odbc_exec("$id, "select pfid from pf_fiscal");
or:
$res = odbc_exec($id, "select pfid from pf_fiscal");

Bye,
  Paolo Gibellini
  p.gibellini <email protected>

P.S. I've attached a little test I use in my context. Hope it help you.

----- Original Message -----
From: systems <systems <email protected>>
To: <php3 <email protected>>
Sent: Monday, May 15, 2000 3:20 PM
Subject: [PHP3] odbc behaviour (was odbc_result getting same row)

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

  • application/x-zip-compressed attachment: test.zip 

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