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.

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]

@Denburt
"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]

MessageBox.Show(ex.Message);

Yep, it's C# alright.

[donilourdu]

@donilourdu
I solved the issue

[NeoPa]

I'm pleased to hear it Doni.

Perhaps you wouldn't mind posting your solution now you have one.

[donilourdu]

@NeoPa
Denburt is correct. I wrongly undestand the concepts. Extremly sorry man for so much of delay.