Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Any suggestions ?

Any suggestions ?

From: Mike <mike.walton_at_btinternet.com>
Date: Fri, 14 Jan 2005 21:45:01 GMT
Message-ID: <x3XFd.543$N25.236@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 - 15:45:01 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US