开发者

Problem with stored procedure in MySQL

I've made the following procedure:

/*Stored procedure*/
 create proce开发者_JAVA百科dure SP_getlagerstatus(in Kategori VARCHAR(15), in minverdi int(3))
 select * from deler join delekategori on deler.DelekategoriID=delekategori.DeleKategoriID
 where DeleKategoriNavn ='Kategori' and Lagerstatus > 'minverdi';

when i run it with call SP_getlagerstatus('biler',1);I dont get any results, but when I run query directly as:

select * from deler join delekategori on deler.DelekategoriID=delekategori.DeleKategoriID
 where DeleKategoriNavn ='biler' and Lagerstatus > 1;

I get the desired result. What am I missing?

/Andy.l


omit the ' around the parameters

 select * from deler join delekategori on deler.DelekategoriID=delekategori.DeleKategoriID
 where DeleKategoriNavn =Kategori and Lagerstatus > minverdi;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜