I finally found a solution: the pdo_odbc driver seems to work fine :-)
Quite easy solution, but it took me a while to figure that out :-(
Sören
On 10/5/07, Mitko Iliev wrote:
> The problem is that php open the cursor as dynamic, as a workaround can
> try to set the cursor as forward only.
That seems to be too complicated for me right now. I'm also wondering
why TOP is even not considered if I do SELECT DISTINCT, which
according to the do
Hi Sören,
The problem is that php open the cursor as dynamic, as a workaround can
try to set the cursor as forward only.
We are looking for a solution.
Best Regards,
Mitko
Sören Auer wrote:
> Hi all,
>
> I tried the following code with both Virtuoso for Windows and Linux:
>
> $db=odbc_connect('v
Sören Auer wrote:
> Hi all,
>
> I tried the following code with both Virtuoso for Windows and Linux:
>
> $db=odbc_connect('virtuoso','dba','dba');
> $result = odbc_exec($db,'SELECT TOP 3 * FROM DB.DBA.SYS_USERS');
> print_r(odbc_result_all($result));
>
> However, I always get the full result set
Hi all,
I tried the following code with both Virtuoso for Windows and Linux:
$db=odbc_connect('virtuoso','dba','dba');
$result = odbc_exec($db,'SELECT TOP 3 * FROM DB.DBA.SYS_USERS');
print_r(odbc_result_all($result));
However, I always get the full result set and not just the top three
as I wou
