Active Server Pages error "ASP 0113"

Active Server Pages error "ASP 0113"

am 04.09.2007 22:21:15 von Anup.Haryani

Hello Friends,
I stuck with a problem.
Well i have an ASP page and it works fine but once i added a new if
condition with Lcase function in it , its giving me Script timed out
error.
I also tried changing the default setting for script time out from 90
sec to 180 but the error still appears.
i can't understand wt might be the reason just adding a Function like
Lcase shouldn't cause this error.
Please help me its kind of urgent.


Thanks,
Anup

Re: Active Server Pages error "ASP 0113"

am 05.09.2007 03:34:40 von Steve Schofield

Sounds like a code issue. When you mark something with lcase, it changes
the behavior or IF / THEN statements in VBScript. This could be causing
something else in your logic.

--

Best regards,

Steve Schofield
Windows Server MVP - IIS
http://weblogs.asp.net/steveschofield

http://www.IISLogs.com
Log archival solution.
Install, Configure, Forget

wrote in message
news:1188937275.173571.174280@50g2000hsm.googlegroups.com...
> Hello Friends,
> I stuck with a problem.
> Well i have an ASP page and it works fine but once i added a new if
> condition with Lcase function in it , its giving me Script timed out
> error.
> I also tried changing the default setting for script time out from 90
> sec to 180 but the error still appears.
> i can't understand wt might be the reason just adding a Function like
> Lcase shouldn't cause this error.
> Please help me its kind of urgent.
>
>
> Thanks,
> Anup
>

Re: Active Server Pages error "ASP 0113"

am 05.09.2007 20:05:46 von patfilot

Most likely you are introducing a looping condition that is throwing you
off - if that is the case, you would see a CPU spike that coincides with the
request.


pat

"Steve Schofield" wrote in message
news:%23Efsuz17HHA.4612@TK2MSFTNGP03.phx.gbl...
> Sounds like a code issue. When you mark something with lcase, it changes
> the behavior or IF / THEN statements in VBScript. This could be causing
> something else in your logic.
>
> --
>
> Best regards,
>
> Steve Schofield
> Windows Server MVP - IIS
> http://weblogs.asp.net/steveschofield
>
> http://www.IISLogs.com
> Log archival solution.
> Install, Configure, Forget
>
> wrote in message
> news:1188937275.173571.174280@50g2000hsm.googlegroups.com...
>> Hello Friends,
>> I stuck with a problem.
>> Well i have an ASP page and it works fine but once i added a new if
>> condition with Lcase function in it , its giving me Script timed out
>> error.
>> I also tried changing the default setting for script time out from 90
>> sec to 180 but the error still appears.
>> i can't understand wt might be the reason just adding a Function like
>> Lcase shouldn't cause this error.
>> Please help me its kind of urgent.
>>
>>
>> Thanks,
>> Anup
>>
>

Re: Active Server Pages error "ASP 0113"

am 07.09.2007 18:26:35 von Anup.Haryani

Hello Steve,
Thanks for your reply.
Well could you clarify a little more so that i can think of the
solution.
I am posting you the chuck of code for reference so that you can have
a look,
The following code is causing problem,

if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
4,5),".")<> 0) or rs("Hide")= true) then
if(rs("Hide") = true and Lcase(rs("ProductName")) <>
Lcase(pr_name) ) then
rs.movenext
else
i = i+1
end if
else
i= i+1

It works fine when the inner if that i have added is removed.
If you see some loop hole in it please let me know.

Thanks,
Anup
On Sep 4, 9:34 pm, "Steve Schofield" wrote:
> Sounds like a code issue. When you mark something with lcase, it changes
> the behavior or IF / THEN statements in VBScript. This could be causing
> something else in your logic.
>
> --
>
> Best regards,
>
> Steve Schofield
> Windows Server MVP - IIShttp://weblogs.asp.net/steveschofield
>
> http://www.IISLogs.com
> Log archival solution.
> Install, Configure, Forget
>
> wrote in message
>
> news:1188937275.173571.174280@50g2000hsm.googlegroups.com...
>
> > Hello Friends,
> > I stuck with a problem.
> > Well i have an ASP page and it works fine but once i added a new if
> > condition with Lcase function in it , its giving me Script timed out
> > error.
> > I also tried changing the default setting for script time out from 90
> > sec to 180 but the error still appears.
> > i can't understand wt might be the reason just adding a Function like
> > Lcase shouldn't cause this error.
> > Please help me its kind of urgent.
>
> > Thanks,
> > Anup

Re: Active Server Pages error "ASP 0113"

am 07.09.2007 18:30:09 von Anup.Haryani

Hello Pat,
Thanks for your reply.
Well could you clarify a little more so that i can think of the
solution.
I am posting you the chuck of code for reference so that you can have
a look,
The following code is causing problem,

if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
4,5),".")<> 0) or rs("Hide")= true) then
if(rs("Hide") = true and Lcase(rs("ProductName")) <>
Lcase(pr_name) ) then
rs.movenext
else
i = i+1
end if
else
i= i+1

It works fine when the inner if that i have added is removed.
If you see some loop hole in it please let me know.

Thanks,
Anup

On Sep 5, 2:05 pm, "Pat [MSFT]" wrote:
> Most likely you are introducing a looping condition that is throwing you
> off - if that is the case, you would see a CPU spike that coincides with the
> request.
>
> pat
>
> "Steve Schofield" wrote in message
>
> news:%23Efsuz17HHA.4612@TK2MSFTNGP03.phx.gbl...
>
> > Sounds like a code issue. When you mark something with lcase, it changes
> > the behavior or IF / THEN statements in VBScript. This could be causing
> > something else in your logic.
>
> > --
>
> > Best regards,
>
> > Steve Schofield
> > Windows Server MVP - IIS
> >http://weblogs.asp.net/steveschofield
>
> >http://www.IISLogs.com
> > Log archival solution.
> > Install, Configure, Forget
>
> > wrote in message
> >news:1188937275.173571.174280@50g2000hsm.googlegroups.com.. .
> >> Hello Friends,
> >> I stuck with a problem.
> >> Well i have an ASP page and it works fine but once i added a new if
> >> condition with Lcase function in it , its giving me Script timed out
> >> error.
> >> I also tried changing the default setting for script time out from 90
> >> sec to 180 but the error still appears.
> >> i can't understand wt might be the reason just adding a Function like
> >> Lcase shouldn't cause this error.
> >> Please help me its kind of urgent.
>
> >> Thanks,
> >> Anup

Re: Active Server Pages error "ASP 0113"

am 07.09.2007 19:26:22 von patfilot

This isn't the full loop - but here is my guess.

The inner if (if(rs("Hide")...) always resolves to true, so the rs.movenext
is always getting called. There may be an error in the recordset and the
outer loop (not provided) is not handling it correctly.


Pat

wrote in message
news:1189182609.186417.138790@d55g2000hsg.googlegroups.com.. .
> Hello Pat,
> Thanks for your reply.
> Well could you clarify a little more so that i can think of the
> solution.
> I am posting you the chuck of code for reference so that you can have
> a look,
> The following code is causing problem,
>
> if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
> isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
> 4,5),".")<> 0) or rs("Hide")= true) then
> if(rs("Hide") = true and Lcase(rs("ProductName")) <>
> Lcase(pr_name) ) then
> rs.movenext
> else
> i = i+1
> end if
> else
> i= i+1
>
> It works fine when the inner if that i have added is removed.
> If you see some loop hole in it please let me know.
>
> Thanks,
> Anup
>
> On Sep 5, 2:05 pm, "Pat [MSFT]" wrote:
>> Most likely you are introducing a looping condition that is throwing you
>> off - if that is the case, you would see a CPU spike that coincides with
>> the
>> request.
>>
>> pat
>>
>> "Steve Schofield" wrote in message
>>
>> news:%23Efsuz17HHA.4612@TK2MSFTNGP03.phx.gbl...
>>
>> > Sounds like a code issue. When you mark something with lcase, it
>> > changes
>> > the behavior or IF / THEN statements in VBScript. This could be
>> > causing
>> > something else in your logic.
>>
>> > --
>>
>> > Best regards,
>>
>> > Steve Schofield
>> > Windows Server MVP - IIS
>> >http://weblogs.asp.net/steveschofield
>>
>> >http://www.IISLogs.com
>> > Log archival solution.
>> > Install, Configure, Forget
>>
>> > wrote in message
>> >news:1188937275.173571.174280@50g2000hsm.googlegroups.com.. .
>> >> Hello Friends,
>> >> I stuck with a problem.
>> >> Well i have an ASP page and it works fine but once i added a new if
>> >> condition with Lcase function in it , its giving me Script timed out
>> >> error.
>> >> I also tried changing the default setting for script time out from 90
>> >> sec to 180 but the error still appears.
>> >> i can't understand wt might be the reason just adding a Function like
>> >> Lcase shouldn't cause this error.
>> >> Please help me its kind of urgent.
>>
>> >> Thanks,
>> >> Anup
>
>

Re: Active Server Pages error "ASP 0113"

am 08.09.2007 04:46:46 von Steve Schofield

Hi,

I would need more data to make a recommendation. One thing I learned reading
"code complete" if something seems too hard, it probably is. I would look
at making your code simpler so it is easier to debug. A few ElseIf or
Select Case might help. Just a thought.

--

Steve Schofield
Windows Server MVP - IIS
http://weblogs.asp.net/steveschofield


wrote in message
news:1189182395.732129.123080@19g2000hsx.googlegroups.com...
> Hello Steve,
> Thanks for your reply.
> Well could you clarify a little more so that i can think of the
> solution.
> I am posting you the chuck of code for reference so that you can have
> a look,
> The following code is causing problem,
>
> if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
> isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
> 4,5),".")<> 0) or rs("Hide")= true) then
> if(rs("Hide") = true and Lcase(rs("ProductName")) <>
> Lcase(pr_name) ) then
> rs.movenext
> else
> i = i+1
> end if
> else
> i= i+1
>
> It works fine when the inner if that i have added is removed.
> If you see some loop hole in it please let me know.
>
> Thanks,
> Anup
> On Sep 4, 9:34 pm, "Steve Schofield" wrote:
>> Sounds like a code issue. When you mark something with lcase, it changes
>> the behavior or IF / THEN statements in VBScript. This could be causing
>> something else in your logic.
>>
>> --
>>
>> Best regards,
>>
>> Steve Schofield
>> Windows Server MVP - IIShttp://weblogs.asp.net/steveschofield
>>
>> http://www.IISLogs.com
>> Log archival solution.
>> Install, Configure, Forget
>>
>> wrote in message
>>
>> news:1188937275.173571.174280@50g2000hsm.googlegroups.com...
>>
>> > Hello Friends,
>> > I stuck with a problem.
>> > Well i have an ASP page and it works fine but once i added a new if
>> > condition with Lcase function in it , its giving me Script timed out
>> > error.
>> > I also tried changing the default setting for script time out from 90
>> > sec to 180 but the error still appears.
>> > i can't understand wt might be the reason just adding a Function like
>> > Lcase shouldn't cause this error.
>> > Please help me its kind of urgent.
>>
>> > Thanks,
>> > Anup
>
>

Re: Active Server Pages error "ASP 0113"

am 08.09.2007 18:27:58 von Tiago Halm

My guess is that
rs.MoveNext
never gets called again after a certain point (or from the early start
probably).

If your outerloop is checking for
Not rs.Eof
then re-evaluate the if/then/else conditions.

Tiago Halm

wrote in message
news:1189182609.186417.138790@d55g2000hsg.googlegroups.com.. .
> Hello Pat,
> Thanks for your reply.
> Well could you clarify a little more so that i can think of the
> solution.
> I am posting you the chuck of code for reference so that you can have
> a look,
> The following code is causing problem,
>
> if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
> isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
> 4,5),".")<> 0) or rs("Hide")= true) then
> if(rs("Hide") = true and Lcase(rs("ProductName")) <>
> Lcase(pr_name) ) then
> rs.movenext
> else
> i = i+1
> end if
> else
> i= i+1
>
> It works fine when the inner if that i have added is removed.
> If you see some loop hole in it please let me know.
>
> Thanks,
> Anup
>
> On Sep 5, 2:05 pm, "Pat [MSFT]" wrote:
>> Most likely you are introducing a looping condition that is throwing you
>> off - if that is the case, you would see a CPU spike that coincides with
>> the
>> request.
>>
>> pat
>>
>> "Steve Schofield" wrote in message
>>
>> news:%23Efsuz17HHA.4612@TK2MSFTNGP03.phx.gbl...
>>
>> > Sounds like a code issue. When you mark something with lcase, it
>> > changes
>> > the behavior or IF / THEN statements in VBScript. This could be
>> > causing
>> > something else in your logic.
>>
>> > --
>>
>> > Best regards,
>>
>> > Steve Schofield
>> > Windows Server MVP - IIS
>> >http://weblogs.asp.net/steveschofield
>>
>> >http://www.IISLogs.com
>> > Log archival solution.
>> > Install, Configure, Forget
>>
>> > wrote in message
>> >news:1188937275.173571.174280@50g2000hsm.googlegroups.com.. .
>> >> Hello Friends,
>> >> I stuck with a problem.
>> >> Well i have an ASP page and it works fine but once i added a new if
>> >> condition with Lcase function in it , its giving me Script timed out
>> >> error.
>> >> I also tried changing the default setting for script time out from 90
>> >> sec to 180 but the error still appears.
>> >> i can't understand wt might be the reason just adding a Function like
>> >> Lcase shouldn't cause this error.
>> >> Please help me its kind of urgent.
>>
>> >> Thanks,
>> >> Anup
>
>

Re: Active Server Pages error "ASP 0113"

am 11.09.2007 20:35:52 von Anup.Haryani

On Sep 7, 1:26 pm, "Pat [MSFT]" wrote:
> This isn't the full loop - but here is my guess.
>
> The inner if (if(rs("Hide")...) always resolves to true, so the rs.movenext
> is always getting called. There may be an error in the recordset and the
> outer loop (not provided) is not handling it correctly.
>
> Pat
>
> wrote in message
>
> news:1189182609.186417.138790@d55g2000hsg.googlegroups.com.. .
>
> > Hello Pat,
> > Thanks for your reply.
> > Well could you clarify a little more so that i can think of the
> > solution.
> > I am posting you the chuck of code for reference so that you can have
> > a look,
> > The following code is causing problem,
>
> > if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
> > isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
> > 4,5),".")<> 0) or rs("Hide")= true) then
> > if(rs("Hide") = true and Lcase(rs("ProductName")) <>
> > Lcase(pr_name) ) then
> > rs.movenext
> > else
> > i = i+1
> > end if
> > else
> > i= i+1
>
> > It works fine when the inner if that i have added is removed.
> > If you see some loop hole in it please let me know.
>
> > Thanks,
> > Anup
>
> > On Sep 5, 2:05 pm, "Pat [MSFT]" wrote:
> >> Most likely you are introducing a looping condition that is throwing you
> >> off - if that is the case, you would see a CPU spike that coincides with
> >> the
> >> request.
>
> >> pat
>
> >> "Steve Schofield" wrote in message
>
> >>news:%23Efsuz17HHA.4612@TK2MSFTNGP03.phx.gbl...
>
> >> > Sounds like a code issue. When you mark something with lcase, it
> >> > changes
> >> > the behavior or IF / THEN statements in VBScript. This could be
> >> > causing
> >> > something else in your logic.
>
> >> > --
>
> >> > Best regards,
>
> >> > Steve Schofield
> >> > Windows Server MVP - IIS
> >> >http://weblogs.asp.net/steveschofield
>
> >> >http://www.IISLogs.com
> >> > Log archival solution.
> >> > Install, Configure, Forget
>
> >> > wrote in message
> >> >news:1188937275.173571.174280@50g2000hsm.googlegroups.com.. .
> >> >> Hello Friends,
> >> >> I stuck with a problem.
> >> >> Well i have an ASP page and it works fine but once i added a new if
> >> >> condition with Lcase function in it , its giving me Script timed out
> >> >> error.
> >> >> I also tried changing the default setting for script time out from 90
> >> >> sec to 180 but the error still appears.
> >> >> i can't understand wt might be the reason just adding a Function like
> >> >> Lcase shouldn't cause this error.
> >> >> Please help me its kind of urgent.
>
> >> >> Thanks,
> >> >> Anup

Hey Pat,
This is the full loop i have and its still giving me the script timed
out error.
<%
i=0
if not (rs.BOF and rs.eof)then
rs.MoveFirst
else
Response.Write ("There are currently no records that satisfy your
query


")
end if

do until rs.EOF

strseminar = rs("productID")
if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
4,5),".")<> 0) or rs("Hide")= true) then
if(rs("Hide") = true and Lcase(strseminar) <> Lcase(pr_name) )
then
rs.movenext
else
i = i+1
end if
else
i= i+1
%>

%>" id=form3 name=form3>

<%

if rs("ProductName")= "" then
%>Product Name not
available
<%
else
%>

<% if(rs("Hide")= true ) then
Response.Write("" +
ucase(rs("ProductName")) )
Response.Write("
[HIDDEN]
")
else
Response.Write(rs("ProductName"))
end if
end if %>
please let me know if you spot something.

Thanks
Anup.

Re: Active Server Pages error "ASP 0113"

am 11.09.2007 20:37:57 von Anup.Haryani

Hey Tiago,
Could you help me understand your point little more elaborately.
well i am sending you the full loop code..
This is the full loop i have and its still giving me the script timed
out error.
<%
i=0
if not (rs.BOF and rs.eof)then
rs.MoveFirst
else
Response.Write ("There are currently no records that satisfy your
query


")
end if

do until rs.EOF

strseminar = rs("productID")
if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
4,5),".")<> 0) or rs("Hide")= true) then
if(rs("Hide") = true and Lcase(strseminar) <> Lcase(pr_name) )
then
rs.movenext
else
i = i+1
end if
else
i= i+1
%>
%>" id=form3 name=form3>

<%

if rs("ProductName")= "" then
%>Product Name not
available
<%
else
%>

<% if(rs("Hide")= true ) then
Response.Write("" +
ucase(rs("ProductName")) )
Response.Write("
[HIDDEN]
")
else
Response.Write(rs("ProductName"))
end if
end if %>
please let me know if you spot something.

Thanks
Anup.

On Sep 8, 12:27 pm, "Tiago Halm" wrote:
> My guess is that
> rs.MoveNext
> never gets called again after a certain point (or from the early start
> probably).
>
> If your outerloop is checking for
> Not rs.Eof
> then re-evaluate the if/then/else conditions.
>
> Tiago Halm
>
> wrote in message
>
> news:1189182609.186417.138790@d55g2000hsg.googlegroups.com.. .
>
> > Hello Pat,
> > Thanks for your reply.
> > Well could you clarify a little more so that i can think of the
> > solution.
> > I am posting you the chuck of code for reference so that you can have
> > a look,
> > The following code is causing problem,
>
> > if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
> > isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
> > 4,5),".")<> 0) or rs("Hide")= true) then
> > if(rs("Hide") = true and Lcase(rs("ProductName")) <>
> > Lcase(pr_name) ) then
> > rs.movenext
> > else
> > i = i+1
> > end if
> > else
> > i= i+1
>
> > It works fine when the inner if that i have added is removed.
> > If you see some loop hole in it please let me know.
>
> > Thanks,
> > Anup
>
> > On Sep 5, 2:05 pm, "Pat [MSFT]" wrote:
> >> Most likely you are introducing a looping condition that is throwing you
> >> off - if that is the case, you would see a CPU spike that coincides with
> >> the
> >> request.
>
> >> pat
>
> >> "Steve Schofield" wrote in message
>
> >>news:%23Efsuz17HHA.4612@TK2MSFTNGP03.phx.gbl...
>
> >> > Sounds like a code issue. When you mark something with lcase, it
> >> > changes
> >> > the behavior or IF / THEN statements in VBScript. This could be
> >> > causing
> >> > something else in your logic.
>
> >> > --
>
> >> > Best regards,
>
> >> > Steve Schofield
> >> > Windows Server MVP - IIS
> >> >http://weblogs.asp.net/steveschofield
>
> >> >http://www.IISLogs.com
> >> > Log archival solution.
> >> > Install, Configure, Forget
>
> >> > wrote in message
> >> >news:1188937275.173571.174280@50g2000hsm.googlegroups.com.. .
> >> >> Hello Friends,
> >> >> I stuck with a problem.
> >> >> Well i have an ASP page and it works fine but once i added a new if
> >> >> condition with Lcase function in it , its giving me Script timed out
> >> >> error.
> >> >> I also tried changing the default setting for script time out from 90
> >> >> sec to 180 but the error still appears.
> >> >> i can't understand wt might be the reason just adding a Function like
> >> >> Lcase shouldn't cause this error.
> >> >> Please help me its kind of urgent.
>
> >> >> Thanks,
> >> >> Anup

Re: Active Server Pages error "ASP 0113"

am 11.09.2007 20:38:46 von Anup.Haryani

On Sep 7, 10:46 pm, "Steve Schofield" wrote:
> Hi,
>
> I would need more data to make a recommendation. One thing I learned reading
> "code complete" if something seems too hard, it probably is. I would look
> at making your code simpler so it is easier to debug. A few ElseIf or
> Select Case might help. Just a thought.
>
> --
>
> Steve Schofield
> Windows Server MVP - IIShttp://weblogs.asp.net/steveschofield
>
> wrote in message
>
> news:1189182395.732129.123080@19g2000hsx.googlegroups.com...
>
> > Hello Steve,
> > Thanks for your reply.
> > Well could you clarify a little more so that i can think of the
> > solution.
> > I am posting you the chuck of code for reference so that you can have
> > a look,
> > The following code is causing problem,
>
> > if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
> > isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
> > 4,5),".")<> 0) or rs("Hide")= true) then
> > if(rs("Hide") = true and Lcase(rs("ProductName")) <>
> > Lcase(pr_name) ) then
> > rs.movenext
> > else
> > i = i+1
> > end if
> > else
> > i= i+1
>
> > It works fine when the inner if that i have added is removed.
> > If you see some loop hole in it please let me know.
>
> > Thanks,
> > Anup
> > On Sep 4, 9:34 pm, "Steve Schofield" wrote:
> >> Sounds like a code issue. When you mark something with lcase, it changes
> >> the behavior or IF / THEN statements in VBScript. This could be causing
> >> something else in your logic.
>
> >> --
>
> >> Best regards,
>
> >> Steve Schofield
> >> Windows Server MVP - IIShttp://weblogs.asp.net/steveschofield
>
> >>http://www.IISLogs.com
> >> Log archival solution.
> >> Install, Configure, Forget
>
> >> wrote in message
>
> >>news:1188937275.173571.174280@50g2000hsm.googlegroups.com. ..
>
> >> > Hello Friends,
> >> > I stuck with a problem.
> >> > Well i have an ASP page and it works fine but once i added a new if
> >> > condition with Lcase function in it , its giving me Script timed out
> >> > error.
> >> > I also tried changing the default setting for script time out from 90
> >> > sec to 180 but the error still appears.
> >> > i can't understand wt might be the reason just adding a Function like
> >> > Lcase shouldn't cause this error.
> >> > Please help me its kind of urgent.
>
> >> > Thanks,
> >> > Anup

Hey steve,
This is the full loop i have and its still giving me the script timed
out error.
<%
i=0
if not (rs.BOF and rs.eof)then
rs.MoveFirst
else
Response.Write ("There are currently no records that satisfy your
query


")
end if

do until rs.EOF

strseminar = rs("productID")
if ((rs("ProductName")= "DELETED" ) or (len(strseminar)= 8 and
isnumeric(mid(strseminar,4,5))= True and instr(mid(strseminar,
4,5),".")<> 0) or rs("Hide")= true) then
if(rs("Hide") = true and Lcase(strseminar) <> Lcase(pr_name) )
then
rs.movenext
else
i = i+1
end if
else
i= i+1
%>
%>" id=form3 name=form3>

<%

if rs("ProductName")= "" then
%>Product Name not
available
<%
else
%>

<% if(rs("Hide")= true ) then
Response.Write("" +
ucase(rs("ProductName")) )
Response.Write("
[HIDDEN]
")
else
Response.Write(rs("ProductName"))
end if
end if %>
please let me know if you spot something.

Thanks
Anup.

Re: Active Server Pages error "ASP 0113"

am 11.09.2007 21:05:42 von tiago.halm

Anup,

No need to post the same code 3 times, this is a single newsgroup. In
fact, the code is not event complete (the "Loop" statement is
missing). I'm sure no one here will try to decipher what the "Ifs"
"LCases", etc ... do in your code, its business specific. The only
thing we're all trying to point out is that your code is looping
because the code is not ending for some reason.

Technically speaking, the code is a loop with the following condition:
## do until rs.EOF
therefore, this loop can only end when you reach the last record of
the RecordSet.

On the other hand you have the following line:
## if(rs("Hide") = true and Lcase(strseminar) <> Lcase(pr_name) )
then
## rs.movenext
## else
## i = i+1
## end if

If the first line above returns FALSE, the RescordSet will stop being
navigated, the loop will NEVER end because all the IF statements
relate to the same record in the RecordSet, and you will have a
endless loop. On the other hand, the "i" variable is used nowhere in
the code shown, so look into that.

I'm sure this should be enough to pinpoint the issue and have a
starting point for troubleshooting.

Cheers,
Tiago Halm