This message was multiposted. It has been answered elsewhere.
"Mike" <mike.walton_at_btinternet.com> wrote in message
news:IgXFd.568$N25.380_at_newsfe3-gui.ntli.net...
>
> Anybody able to advise please
>
> I get the following message
> ORA-00933: SQL command not properly ended
>
> which relates to the following statement
>
> strSQL = "select * from Cottages, Pricebands where Location = '"&
> strLocation &"', Price Number = '"& strDates &"', Bedrooms Number = '"&
> strRooms &"', Pets = '"& strPets &"' "
>
> What's wrong ??
Received on Fri Jan 14 2005 - 16:49:51 CST
