RE: [PHP-DB] Select from Array - Openlink

Aubrey, I would imagine that either the "@" is causing problem or the "odbc_exec" is. Try rewriting using odbc_prepare and odbc_execute istead of odbc_exec, and also try passing a select without the ampersat. You may need a special escape to use it within PHP, even though it is working directly via ODBC. Please let me know how you get on with this. Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Aubrey Davies [mailto:aubrey@isoft.co.za] > Sent: Tuesday, September 26, 2000 11:19 AM > To: php > Subject: [PHP-DB] Select from Array - Openlink > > > 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. > > It all used to work fine with PHP3 and Openlink ODBC. > > Help > TIA > > > Aubrey > > ------------------------------------------------------------------ > ---------- > ------------ > Aubrey Davies (aubrey@isoft.co.za) > I-Soft Net Pty Ltd, 16 Napier Street, Cape Town, South Africa > Tel: 4197140 > Mobile: 0832287064 > SMS: 0832287064@sms.co.za > http://www.isoftnet.co.za > ------------------------------------------------------------------ > ---------- > ------------ > > >