Limitation of the number of recordsets ASP is able to proceed?

Is there a limitation of the number of recordsets ASP is able to proceed?
When my Access database exceeded 544 records, only first 544 records are
shown

Bob
Wed Feb 01 10:49:42 CST 2006

aa wrote:
> Is there a limitation of the number of recordsets

recordsets? Do you mean records?

> ASP is able to proceed?
process?

> When my Access database exceeded 544 records, only first 544
> records are shown

Show the code (only the relevant bit please. We don't need to see all the
html ...).

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

aa
Wed Feb 01 12:21:18 CST 2006

Thanks, Bob
in the query I have

WHERE filed_name<>"something"
and I did not have filed_name field filled in the recently added records.
I did not realised that if the value of a field is not entered, then
filed_name<>"something" evaluated to false, thought I expected it to
evaluate to true as undefined is not equal to "something"


"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:O43AB#0JGHA.648@TK2MSFTNGP14.phx.gbl...
> aa wrote:
> > Is there a limitation of the number of recordsets
>
> recordsets? Do you mean records?
>
> > ASP is able to proceed?
> process?
>
> > When my Access database exceeded 544 records, only first 544
> > records are shown
>
> Show the code (only the relevant bit please. We don't need to see all the
> html ...).
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Bob
Wed Feb 01 12:34:12 CST 2006

So your problem is solved?

aa wrote:
> Thanks, Bob
> in the query I have
>
> WHERE filed_name<>"something"
> and I did not have filed_name field filled in the recently added
> records. I did not realised that if the value of a field is not
> entered, then filed_name<>"something" evaluated to false, thought I
> expected it to evaluate to true as undefined is not equal to
> "something"
>
>
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:O43AB#0JGHA.648@TK2MSFTNGP14.phx.gbl...
>> aa wrote:
>>> Is there a limitation of the number of recordsets
>>
>> recordsets? Do you mean records?
>>
>>> ASP is able to proceed?
>> process?
>>
>>> When my Access database exceeded 544 records, only first 544
>>> records are shown
>>
>> Show the code (only the relevant bit please. We don't need to see
>> all the html ...).
>>
>> Bob Barrows
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get
>> a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

aa
Wed Feb 01 13:15:13 CST 2006

Yes, sorry for the false alarm.
However how would you explain that filed_name<>"something" evaluates to
false if filed_name is undefined?


"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OHaMa41JGHA.2708@tk2msftngp13.phx.gbl...
> So your problem is solved?
>
> aa wrote:
> > Thanks, Bob
> > in the query I have
> >
> > WHERE filed_name<>"something"
> > and I did not have filed_name field filled in the recently added
> > records. I did not realised that if the value of a field is not
> > entered, then filed_name<>"something" evaluated to false, thought I
> > expected it to evaluate to true as undefined is not equal to
> > "something"
> >
> >
> > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> > news:O43AB#0JGHA.648@TK2MSFTNGP14.phx.gbl...
> >> aa wrote:
> >>> Is there a limitation of the number of recordsets
> >>
> >> recordsets? Do you mean records?
> >>
> >>> ASP is able to proceed?
> >> process?
> >>
> >>> When my Access database exceeded 544 records, only first 544
> >>> records are shown
> >>
> >> Show the code (only the relevant bit please. We don't need to see
> >> all the html ...).
> >>
> >> Bob Barrows
> >> --
> >> Microsoft MVP -- ASP/ASP.NET
> >> Please reply to the newsgroup. The email account listed in my From
> >> header is my spam trap, so I don't check it very often. You will get
> >> a quicker response by posting to the newsgroup.
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Bob
Wed Feb 01 13:30:33 CST 2006

I think you mean " ... if filed_name contains Null"
Any comparison with Null results in Null, which is not true

aa wrote:
> Yes, sorry for the false alarm.
> However how would you explain that filed_name<>"something" evaluates
> to false if filed_name is undefined?
>
>
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:OHaMa41JGHA.2708@tk2msftngp13.phx.gbl...
>> So your problem is solved?
>>
>> aa wrote:
>>> Thanks, Bob
>>> in the query I have
>>>
>>> WHERE filed_name<>"something"
>>> and I did not have filed_name field filled in the recently added
>>> records. I did not realised that if the value of a field is not
>>> entered, then filed_name<>"something" evaluated to false, thought I
>>> expected it to evaluate to true as undefined is not equal to
>>> "something"
>>>
>>>
>>> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
>>> news:O43AB#0JGHA.648@TK2MSFTNGP14.phx.gbl...
>>>> aa wrote:
>>>>> Is there a limitation of the number of recordsets
>>>>
>>>> recordsets? Do you mean records?
>>>>
>>>>> ASP is able to proceed?
>>>> process?
>>>>
>>>>> When my Access database exceeded 544 records, only first 544
>>>>> records are shown
>>>>
>>>> Show the code (only the relevant bit please. We don't need to see
>>>> all the html ...).
>>>>
>>>> Bob Barrows
>>>> --
>>>> Microsoft MVP -- ASP/ASP.NET
>>>> Please reply to the newsgroup. The email account listed in my From
>>>> header is my spam trap, so I don't check it very often. You will
>>>> get a quicker response by posting to the newsgroup.
>>
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get
>> a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

aa
Wed Feb 01 15:51:38 CST 2006

Thanks,Bob