[PHP-DEV] Bug #10568 Updated: error using ODBC

2001-05-07 Thread kalowsky

ID: 10568
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: 
Comments:

the SQL_CUR_USE_ODBC does not require quotes, try that first.

second PHP 4.0.5 is out, do please see if this continues there.  and third have you 
tried checking to make sure your db connection exists?  it seems you do the 
odbc_connect and never check the result.

Previous Comments:
---

[2001-05-02 08:58:48] [EMAIL PROTECTED]
(I’am 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   
echo”Lines Before”;   
$bb = a();  
echo “ Lines Later”;  
?  
  


---

[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;  
?  
  
  
---

---



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10568edit=2


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




[PHP-DEV] Bug #10568 Updated: error using ODBC

2001-05-01 Thread kalowsky

ID: 10568
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
PHP Version: 4.0.4pl1
Assigned To: 
Comments:

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?

Previous Comments:
---

[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;  
?  
  
  
---

---



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10568edit=2


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