Re: Please Help Need Search Stored Proc
Hi Peter, Thanks again. I know you're probably getting annoyed with my questions by now...I am a newbie :) but thanks for all your help. A few questions.
- Where do I put the "SELECT @sql" statement into the sproc? I tried running that statement by itself and returned no results.
-More importantly, you have in your WHERE statement "WHERE 1=1;" What exactly does that mean? DOes that mean it's returning true? I feel like we're getting really close, the error message I get from my PHP now is "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1"
There is no 0 at line 1...please a little more help and please let me know if you need any additional information...thanks!! :)
Subject
Views
Written By
Posted
3562
March 11, 2009 11:13AM
2058
March 11, 2009 02:16PM
2010
March 11, 2009 06:39PM
1978
March 12, 2009 01:53PM
1904
March 12, 2009 03:05PM
1874
March 15, 2009 09:56AM
1897
March 15, 2009 12:07PM
1908
March 16, 2009 09:46AM
1977
March 16, 2009 12:47PM
1940
March 17, 2009 07:41AM
1856
March 17, 2009 09:48AM
1860
March 17, 2009 10:57AM
1871
March 17, 2009 10:21PM
Re: Please Help Need Search Stored Proc
1907
March 18, 2009 09:36AM
1944
March 18, 2009 09:49AM
1937
March 18, 2009 01:04PM
1915
March 18, 2009 01:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.