php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #6843 Select from Array
Submitted: 2000-09-21 23:08 UTC Modified: 2001-03-11 21:17 UTC
From: aubrey at isoft dot co dot za Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.2 OS: Linux 6.2
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: aubrey at isoft dot co dot za
New email:
PHP Version: OS:

 

 [2000-09-21 23:08 UTC] aubrey at isoft dot co dot za 
When I run an odbc_exec from PHP-4.0.2 which connects to a Progress 83C database in order to retreive an array field as follows:

select name,narrative@1 from customer

I get an SQL syntax error as follows:

Warning SQL Error [OpenLink][ODBC] Syntax error or access, SQL State 37000 in SQLExecDIRECT

This works if I connect to my Progress Database using odbctest.

I think I may be using an old version of the ODBC libraries linked into PHP4

Is this correct ?

It all used to work fine with PHP3 and Openlink ODBC.


Thanks

Aubrey

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-10-02 19:48 UTC] aubrey at isoft dot co dot za 
This used to work in PHP3 and I have checked that I am using the latest libraries.
Is it possible to get PHP not to check the syntax of the SQL statement but just to pass it on.
 [2001-01-17 09:37 UTC] kalowsky@php.net 
Please try the latest release and see if this continues for you...
 [2001-03-11 21:17 UTC] kalowsky@php.net 
no user feedback, considered fixed
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sat Jul 05 10:01:33 2025 UTC