RE: [PHP] PROGRESS SQL_CUR_USE_ODBC
| From: | Programmer | Date: | Tue, 04 Oct 2005 19:07:50 +0000 |
| Subject: | RE: [PHP] PROGRESS SQL_CUR_USE_ODBC | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223621@lists.php.net to get a copy of this message | ||
I don't know if this will help you.
I use an openlink ODBC driver to connect to Progress via PHP like so:
$dbconn =
odbc_connect("MyDB_ODBC",$username,$password,SQL_CUR_USE_ODBC);
$strQry = "SELECT * FROM mytable WHERE mytable.field = ".$somevar;
$rsTable = odbc_do($dbconn, $strQry);
while (odbc_fetch_row($rsTable))
{
// do stuff;
}
Jeremy Schreckhise
-----Original Message-----
From: cybermalandro cybermalandro [mailto:cybermalandro@gmail.com]
Sent: Tuesday, October 04, 2005 11:48 AM
To: php-general@lists.php.net
Subject: [PHP] PROGRESS SQL_CUR_USE_ODBC
I am connecting to a PROGRESS DB through the MERANT ODBC driver, When I
have
the 4th parameter SQL_CUR_USE_ODBC as shown, my queries return nothing
but
if I have the 4th parameter as lower case it returns my query results
but
with a PHP error complainning
*Notice*: Use of undefined constant sql_cur_use_odbc - assumed
'sql_cur_use_odbc'
Wtf? I don't get it, most of the documentation from people connecting to
PROGRESS do have the 4th parameter uppercase can someone help me out ?
Thanks!