#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 'intTableNo' at line 19

Question

5.00/5 (1 vote)

See more:

, +

SQL

CREATE  PROCEDURE `FetchSupplierByRequest`(intConferenceId int, intRank int,intTableNo int)
BEGIN
SELECT Distinct
c.ID ,
  c.CompanyName,
c.Type
FROM
  conferencetabletop cp,
  companies c,
meeting m
WHERE
  cp.ConferenceID = intConferenceId
    AND
  c.ID = m.SupplierID
and m.AgendaID=cp.ConferenceId
and m.Rank=intRank
ORDER BY
  m.CreatedDate DESC
LIMIT 0, intTableNo;
END

showing the error when its upload in server .

error: #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 'intTableNo' at line 19

Posted 20-Jan-14 19:35pm

Rajib Mahata

Add a Solution

Comments

Rajib Mahata 21-Jan-14 1:39am

but if i check the select query in server then it works .
SELECT DISTINCT c.ID, c.CompanyName, c.Type
FROM conferencetabletop cp, companies c, meeting m
WHERE cp.ConferenceID =21
AND c.ID = m.SupplierID
AND m.AgendaID = cp.ConferenceId
AND m.Rank =1
ORDER BY m.CreatedDate DESC
LIMIT 0,10;

idenizeni 21-Jan-14 17:27pm

Are you missing a statement delimiter after the END keyword? Should the last line be END;

Rajib Mahata 22-Jan-14 4:16am

i added delimiter but shown same error .

idenizeni 22-Jan-14 17:45pm

I just saw your reply. If you use the Reply on a comment then a message gets sent to the poster. As for your question; from what I can tell it looks like the issue may be related to the fact that LIMIT cannot be parameterized in MySQL. So, it works in your test because you are using literal values in the LIMIT clause.

Rajib Mahata 22-Jan-14 5:37am

when i run
SELECT DISTINCT c.ID, c.CompanyName, c.Type
FROM conferencetabletop AS cp, companies AS c, meeting AS m
WHERE cp.ConferenceID =21
AND c.ID = m.SupplierID
AND m.AgendaID = cp.ConferenceID
AND m.Rank =1
ORDER BY m.CreatedDate DESC
LIMIT 0 , 12

its return value .

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

idenizeni · Answer 1 · 2014-01-22T11:51:00

Solution 1

According to the information I can find, older versions of MySQL cannot use variables in the LIMIT clause and constants must be used.

Similar issue posted to StackOverflow with some useful information.

http://stackoverflow.com/questions/2875238/passing-limit-as-parameters-to-mysql-sproc[^]

Posted 22-Jan-14 11:51am

idenizeni

Comments

Rajib Mahata 3-Feb-14 5:39am

Thanks For Answer