RE: [PHP-DB] odbc - strange behaviour on multiple odbc_exec... From: Andrew Hill (ahill <email protected>)
Date: 08/14/00

Gordon,

I would try odbc_connect instead of odbc_pconnect, as a first guess, and
make sure you are using the latest PHP version, as some odbc_exec problems
were just fixed.

Hope this helps!

Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Professional Services Consultant
OpenLink Software
http://www.openlinksw.com
Universal Database Connectivity Technology Providers

> -----Original Message-----
> From: systems [mailto:systems <email protected>]
> Sent: Monday, August 14, 2000 7:28 AM
> To: php-db <email protected>
> Subject: [PHP-DB] odbc - strange behaviour on multiple odbc_exec...
>
>
> hi folks, I have another odbc problem - I hope someone can see what I'm
> doing wrong, because I sure can't!
>
> The code makes a connection, and executes two queries. The first works
> fine - no problem there. The second always gives an error. If I
> strip out
> the first completely, just leaving the second, it works ok!
>
> Here is the code:--
> $id = odbc_pconnect("DSN=crime_no; UID=ingres;PWD=xxx", "", "");
> $sql = "select charge_type, search_descrip from CHARGE_CODES" .
> " where charge_code = '$c' ";
> $res = odbc_exec($id, $sql);
> $r = odbc_fetch_row($res);
> $ctype = odbc_result($r, "charge_type");
> $sdesc = odbc_result($r, "search_descrip");
> // everyrthing is cool to here - the above sql works
> perfectly
> // the next two lines are an attempt to get over
> my problem
> $e = odbc_commit( $id);
> $e = odbc_free_result( $r );
>
> // this following query gives me 'Warning: bad result
> index 1 in
> ... for each of
> // the odbc_result calls.
> $sql = "select seq_no, charge_text from CHARGE_STYLES " .
> " where charge_code = '$c' order by seq_no";
>
> $res = odbc_exec($id, $sql);
> while ( $r = odbc_fetch_row($res)) {
> $seq = odbc_result($r, "seq_no");
> $txt = odbc_result($r, "charge_text");
> echo "<P>$txt\n";
> };
>
> One interesting thing is that, before I put in the
> odbc_free_result, I used
> to get an error saying there was no variable "seq_no", and
> "charge_text" in
> these last two odbc_result calls. BUT, if I changed "charge_text" to read
> "charge_type" (ie, a column in the *first* odbc_exec), then that
> is found!!
> It's like as if the odbc result stuff is not clearing ; it's
> still got stuff
> from the previous query - hence my attempt at odbc_free_result...
>
> any thoughts please?
>
> many thanks again
>
> (Linux RH 6.1; Openlink ;, PHP 3; apache....)
>
>
> Gordon Gallacher
> Inverness, Scotland
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>