ID: 10568
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Description: error using ODBC
(Iam using a traductor English/Spanish)
I use the software Microsoft Query for test the DNS connection and it worked very
well, but when I try to enter through php it throws me the mentioned error and not you
that it is.
This is a script:
?php
function a() {
$connect = odbc_connect ( dig , root , cir0921, SQL_CUR_USE_ODBC );
$query = SELECT * FROM local;
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)) {
$id=odbc_result($result,1);
$pass=odbc_result($result,2);
echo id:$id,pass:$pass
;
}
odbc_close_all($connect);
return true;
} / / a
?
?php
echoLines Before;
$bb = a();
echo Lines Later;
?
Previous Comments:
---
[2001-05-01 09:59:18] [EMAIL PROTECTED]
i'm not sure i understand the error you're receiving. can you please give a sample
script that creates the error?
also, are you sure your SELECT statement works properly?
---
[2001-04-30 18:37:36] [EMAIL PROTECTED]
Hello:
I am using a database called RECITAL . I am trying to connect myself using ODBC.
When executing the command: odbc_exec($connect, $query) I can revise the connection
from the database and indeed her ago. But then treatment of consenting to the data
using any function ODBC, for example:
odbc_result_all($connect, BGCOLOR = ' #AAFFAA ' border=3 width=30% bordercolordark = '
#FF ');
---
and it throws me this error:
-
Warning: Not tuples available at this result index in programa/apache c:/archivos
group/apache/htdocs/b.html on line 7
-
I need to know if they can help me with this.
thank you.
(the table if it exists, some fields is: nlocal,ncontr)
This is the program php:
---
?php
function to () {
$connect = odbc_connect ( dig , root , cir0921, SQL_CUR_USE_ODBC );
$query = SELECT * local FROM;
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)) {
$id=odbc_result($result,1);
$pass=odbc_result($result,2);
echo id:$id,pass:$pass
;
}
odbc_close_all($connect);
return true;
} / / a
?
?php
echoLines Before;
$bb = a();
echo Lines Later;
?
---
---
Full Bug description available at: http://bugs.php.net/?id=10568
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]