Record set returning less number of values?--URGENT HELP!!!

[kazai]

I have a select statement that returns 5 records, when i run it on access, but when i run the same on the browser(in a loop), using recordset object, it gives me 3 rows. I checked the statement, and it is exactly the same as the one i use for the access DB.
Any inputs on this, as to why it could be the case?
-Thanks,
Radhika.

 

[ToddWW]

Let's take a look at your ASP code showing the recordset creation and the loop..

ToddWW

 

[kazai]

I've fixed that problem, Thankyou Todd ...there was a pbm. in the logic....I now have a different question:
I have an insert statement which is perfect..I run it on Access, and it gives me the correct o/p.(ie, it inserts.) I saw the string on the browser, and copy-pasted it onto Access, and it works.
But if I do a conn.Execute(strSQL), it gives me an error saying "Query must be an updatable one". Now I found that a random user must have permission to insert into the table. But this permission was granted, and it still gives the same message. Can you tell me why?
Thanks Todd,
Radhika.

 

[ToddWW]

Unfortunately no, because I do not use Access. Since we already have 3 replies to this post, it might get ignored by others. Go ahead and post a new thread and I'm sure you'll get a quick response.

ToddWW

 

[kazai]

Sure, Thankyou Todd. (BTW, how many coffee mugs have you collected? ...it's ok, I don't expect an answer to that )

 

[ToddWW]

Actually NONE !! But if and when I do finally get one, it'll be the most expensive coffee mug I've ever owned. LOL

ToddWW

 

[kazai]

lol!! I'm sure