MYSQL data fetching error using limit

donilourdu

hi,
I am trying to retrive data from MYSQL database.I am using limit to fetch the data.It will fetch two rows instead of fetching ten rows.But when i try to debug it fetches eight rows instead of ten rows.The codes are given below for your reference.

Expand|Select|Wrap|Line Numbers

 private void data(string slimit,string elimit)

{

MySqlConnection conn = new MySqlConnection(ss);

conn.Open();

try

{

MySqlCommand cmd = new MySqlCommand("select iddocument from document_info where scanby is not null limit " + slimit + "," + elimit + ";" , conn);

//cmd.Parameters.Add("?iddocument", MySqlDbType.VarChar).Value = aa;

MySqlDataReader myread;

myread = cmd.ExecuteReader();

while (myread.Read())

{

f.log_insert(myread.GetString(0));

}

myread.Close();

myread.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

 conn.Close();

}

With Regards,
Doni

NeoPa

Doni,

I'm confused. Should this be in the Access forum? This doesn't look like VBA code at all.

If you can say where this should be then I can move it there for you.

Denburt

Looks like Javascript to me.

NeoPa

I'll move it there pro tem.

dlite922

Quote:

Originally Posted by Denburt

Looks like Javascript to me.

"public void " is JavaScript? its Java!

Java != JavaScript ... not even close.

OP,

I think you may be having trouble with understanding how the LIMIT function works.

In MySQL the first parameter is the number of the record to START from, the second is how many to display from there.

If you have ten records and said LIMIT 5,3 you would get record number 5 through 8. If you said LIMIT 10,10 you would get only one because counting from 10 there's only one record left (ie there is no 11,12,13...20)

If you're doing this for a pagation the first parameter should be page_number-1 * items_perPage.

so in your code subtract one from string, multiply it by estring and put this result as the first parameter and the number of records to display on a page as the second parameter.

Hope that makes enough sense. Try running some queries without code, from command line or the client to test it out.

Dan

NeoPa

Dan,

We're not from the dark-side you know. How you play with your coffee is your business.

Java / Javascript / whatever. They're all foreign languages to us over in Access. We would care, but you guys seem to have that well covered so why bother :D

I'll move it to Java for you.

Denburt

LOL actually it says "private void" I missed that, at a quick glance thats what it appeared to be. I am also quite well aware that Java != JavaScript ... not even close. Thank you

Markus

I have £20 on it being C#. Any more bets?

Also, C# != Java != Javascript .. not even close ;)

r035198x

Expand|Select|Wrap|Line Numbers

MessageBox.Show(ex.Message);

Yep, it's C# alright.

MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

re: MYSQL data fetching error using limit

Similar Java bytes

/bytes/development

/bytes/it

/bytes/about