SEO

#1 (**permalink**) 03-09-2008, 01:37 PM

I don't know if this a bug in MySQL (5), a bug in MyODBC, or if I just
misunderstand parameterization of queries, but insight would be
appreciated!

If I make a parameterized query such as

"Select user from usertable where id=@User LIMIT @Number;"

....it hurls on the @Number. If I replace it with a number in the
query instead of paramterizing it, like this:

"Select user from usertable where id=@User LIMIT 10;"

....then it works just fine. Is this some known limitation or bug, or
should I not expect to be able to make the value of the LIMIT clause a
parameter?

Thanks!
Dave

#2 (**permalink**) 03-09-2008, 01:37 PM

On Sat, 08 Mar 2008 21:02:04 +0100, <wikitalk@gmail.com> wrote:

> I don't know if this a bug in MySQL (5), a bug in MyODBC, or if I just
> misunderstand parameterization of queries, but insight would be
> appreciated!
>
> If I make a parameterized query such as
>
> "Select user from usertable where id=@User LIMIT @Number;"
>
> ...it hurls on the @Number. If I replace it with a number in the
> query instead of paramterizing it, like this:
>
> "Select user from usertable where id=@User LIMIT 10;"
>
> ...then it works just fine. Is this some known limitation or bug, or
> should I not expect to be able to make the value of the LIMIT clause a
> parameter?

http://dev.mysql.com/doc/refman/5.0/...variables.html

"User variables may be used in contexts where expressions are allowed.
This does not currently include contexts that explicitly require a literal
value, such as in the LIMIT clause of a SELECT statement, or the IGNORE N
LINES clause of a LOAD DATA statement."
--
Rik Wasmus

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Why can't you parameterize the value of a LIMIT clause?