Uwe Oeder wrote:

> When I run the script below I get the following error. Can somebody help.
> "Dynamic SQL Error SQL error code = -901 feature is not supported in"
>
> Using Apache Version Apache/2.0.52 (Win32) ; PHP/5.0.2 ;Firebird
> 1.5.2 (Win32 Build)
>
> PHP Script :
>
> $SQLQuery = "SELECT WPIDSQ , WPVBSQ , WPName FROM Whitepage WHERE WPName
> LIKE '%MOTOR%' AND WPName LIKE '%CAR%'" ;

Looks OK.
Have you tried testing this directly in the database? Use IBOConsole or
something like that, to check out the SQL before using it.
I work that way all the time, so I can see what the query is returning (
or not ;) ) before trying to work with it in the PHP end. Often throws
up problems one has missed which don't relate to the code, but the
actual database structure.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services