Click here to Skip to main content
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)498.5K
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)

  Print Answers RSS
0 OriginalGriff 459
1 Maciej Los 325
2 Sergey Alexandrovich Kryukov 234
3 DamithSL 233
4 BillWoodruff 200
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2014
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