Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Active Server Pages error 'ASP 0113'

 
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  Passing Session variables(Network UserIDs)  
Author Message
Anup.Haryani

External


Since: Sep 04, 2007
Posts: 6



(Msg. 1) Posted: Tue Sep 04, 2007 5:05 pm
Post subject: Active Server Pages error 'ASP 0113'
Archived from groups: microsoft>public>inetserver>iis (more info?)

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

 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Steve Schofield

External


Since: Sep 27, 2007
Posts: 36



(Msg. 2) Posted: Tue Sep 04, 2007 9:34 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

<Anup.Haryani.TakeThisOut@gmail.com> 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
>

 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Pat [MSFT]

External


Since: May 24, 2006
Posts: 102



(Msg. 3) Posted: Wed Sep 05, 2007 11:05 am
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <steve.DeleteThis@iislogs.com> 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
>
> <Anup.Haryani.DeleteThis@gmail.com> 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
>>
>
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Anup.Haryani

External


Since: Sep 04, 2007
Posts: 6



(Msg. 4) Posted: Fri Sep 07, 2007 4:26 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <st... DeleteThis @iislogs.com> 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
>
> <Anup.Hary... DeleteThis @gmail.com> 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
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Anup.Haryani

External


Since: Sep 04, 2007
Posts: 6



(Msg. 5) Posted: Fri Sep 07, 2007 4:30 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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]" <patfi... RemoveThis @online.MICROSOFT.COM> 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" <st... RemoveThis @iislogs.com> 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
>
> > <Anup.Hary... RemoveThis @gmail.com> 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
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Pat [MSFT]

External


Since: May 24, 2006
Posts: 102



(Msg. 6) Posted: Fri Sep 07, 2007 4:30 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

<Anup.Haryani.DeleteThis@gmail.com> 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]" <patfi....DeleteThis@online.MICROSOFT.COM> 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" <st....DeleteThis@iislogs.com> 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
>>
>> > <Anup.Hary....DeleteThis@gmail.com> 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
>
>
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Steve Schofield

External


Since: Sep 27, 2007
Posts: 36



(Msg. 7) Posted: Fri Sep 07, 2007 10:46 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


<Anup.Haryani.RemoveThis@gmail.com> 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" <st....RemoveThis@iislogs.com> 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
>>
>> <Anup.Hary....RemoveThis@gmail.com> 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
>
>
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Tiago Halm

External


Since: Apr 12, 2005
Posts: 38



(Msg. 8) Posted: Sat Sep 08, 2007 5:27 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

<Anup.Haryani DeleteThis @gmail.com> 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]" <patfi... DeleteThis @online.MICROSOFT.COM> 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" <st... DeleteThis @iislogs.com> 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
>>
>> > <Anup.Hary... DeleteThis @gmail.com> 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
>
>
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
tiago.halm

External


Since: Sep 10, 2007
Posts: 14



(Msg. 9) Posted: Tue Sep 11, 2007 12:05 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Anup.Haryani

External


Since: Sep 04, 2007
Posts: 6



(Msg. 10) Posted: Tue Sep 11, 2007 6:35 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Sep 7, 1:26 pm, "Pat [MSFT]" <patfi... RemoveThis @online.MICROSOFT.COM> 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
>
> <Anup.Hary... RemoveThis @gmail.com> 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]" <patfi... RemoveThis @online.MICROSOFT.COM> 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" <st... RemoveThis @iislogs.com> 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
>
> >> > <Anup.Hary... RemoveThis @gmail.com> 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<br><br><br>")
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
%>
<form method="post" action="description.asp?itemID=<%=rs("itemID")
%>" id=form3 name=form3>
<tr>
<%

if rs("ProductName")= "" then
%><td width="8%" height="20"><font size=2>Product Name not
available</font></TD> <%
else
%>
<td width="8%" height="20"><font face=arial size=2><b>
<% if(rs("Hide")= true ) then
Response.Write("<font face=arial color=orangered size=4><u>" +
ucase(rs("ProductName")) )
Response.Write("</u>[HIDDEN]</font>")
else
Response.Write(rs("ProductName"))
end if
end if %>
please let me know if you spot something.

Thanks
Anup.
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Anup.Haryani

External


Since: Sep 04, 2007
Posts: 6



(Msg. 11) Posted: Tue Sep 11, 2007 6:37 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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<br><br><br>")
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
%>
<form method="post" action="description.asp?itemID=<%=rs("itemID")
%>" id=form3 name=form3>
<tr>
<%

if rs("ProductName")= "" then
%><td width="8%" height="20"><font size=2>Product Name not
available</font></TD> <%
else
%>
<td width="8%" height="20"><font face=arial size=2><b>
<% if(rs("Hide")= true ) then
Response.Write("<font face=arial color=orangered size=4><u>" +
ucase(rs("ProductName")) )
Response.Write("</u>[HIDDEN]</font>")
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" <th....TakeThisOut@nospam.hotmail.com> 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
>
> <Anup.Hary....TakeThisOut@gmail.com> 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]" <patfi....TakeThisOut@online.MICROSOFT.COM> 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" <st....TakeThisOut@iislogs.com> 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
>
> >> > <Anup.Hary....TakeThisOut@gmail.com> 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
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Anup.Haryani

External


Since: Sep 04, 2007
Posts: 6



(Msg. 12) Posted: Tue Sep 11, 2007 6:38 pm
Post subject: Re: Active Server Pages error 'ASP 0113' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Sep 7, 10:46 pm, "Steve Schofield" <st....TakeThisOut@iislogs.com> 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
>
> <Anup.Hary....TakeThisOut@gmail.com> 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" <st....TakeThisOut@iislogs.com> 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
>
> >> <Anup.Hary....TakeThisOut@gmail.com> 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<br><br><br>")
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
%>
<form method="post" action="description.asp?itemID=<%=rs("itemID")
%>" id=form3 name=form3>
<tr>
<%

if rs("ProductName")= "" then
%><td width="8%" height="20"><font size=2>Product Name not
available</font></TD> <%
else
%>
<td width="8%" height="20"><font face=arial size=2><b>
<% if(rs("Hide")= true ) then
Response.Write("<font face=arial color=orangered size=4><u>" +
ucase(rs("ProductName")) )
Response.Write("</u>[HIDDEN]</font>")
else
Response.Write(rs("ProductName"))
end if
end if %>
please let me know if you spot something.

Thanks
Anup.
 >> Stay informed about: Active Server Pages error 'ASP 0113' 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]