Click here to Skip to main content
11,432,627 members (66,705 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: PHP MySQL
Hi all,
I have a form with dropdownlist containing fieldnames like firstname, lastname
I have a textbox to type the keyword.
According to the fieldname selected in dropdown and the keyword typed in textbox , I have to filter the user details.
I have written a stored procedure with prepared statement. But its not working.
 
create procedure prcUsers
(
	PvchFieldName varchar(30),
	PvchFieldValue varchar(30)
)
begin
	declare f,v varchar(30);
    set @fname=PvchFieldName;
	set @val=PvchFieldValue;
	set @q= concat('select * from tbmstuser where ',f,'=? like',v,'=?%');
	prepare stmt from @q;	
	execute stmt using @fname, @val;
	deallocate prepare stmt;
end

calling the procedure gives me the following error

Error Code: 1064. 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 'NULL' at line 1	0.000 sec
Have to call like this
call prcUsers('vchFirstName','a');
Posted 16-Jan-13 19:02pm
Edited 16-Jan-13 21:43pm
(no name)500.9K
v2
Comments
Sandeep Mewara at 17-Jan-13 1:44am
   
How do you call this SP?
Member 9762654 at 17-Jan-13 2:03am
   
have given in my solution check with that

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.150428.2 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100