470,613 Members | 2,470 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

Debugging ASP

Hi

I've just inherited a web site. Someone's just asked me "what database
table fields are looked at in a particular search?"

You'd think this would be easy, but I'm looking at an ASP page that when
printed out is >16 pages and has 20 include files. And no comments. It's
just a series of scary logic.

I really need to run this though in "debug mode", seeing what every variable
is set to at each stage. If this were an ASP page calling a VB COM object
I'd have no problems, however, I've no idea how to trap this in debug mode
using standard ASP code. I know the debugger often start up when there's an
error in the code, but there isn't. So, can anyone enlighten me as to how I
can step into code using simple ASP (not .Net).

Many thanks in advance.

Griff
Jul 19 '05 #1
6 2807
"GriffithsJ" wrote ...
So, can anyone enlighten me as to how I
can step into code using simple ASP (not .Net).


I think the majority of people would just use

Response.Write strVariable

and maybe to halt the app

Response.End
Its a bit of a pain if there are lots of variables - but it shouldn't be too
hard to locate the database stuff, although thats likely to be a manual read
of each include to find it I would guess...

Hope this helps...

Rob

Jul 19 '05 #2
GriffithsJ wrote:
Hi

I've just inherited a web site. Someone's just asked me "what
database table fields are looked at in a particular search?"

You'd think this would be easy, but I'm looking at an ASP page that
when printed out is >16 pages and has 20 include files. And no
comments. It's just a series of scary logic.

I really need to run this though in "debug mode", seeing what every
variable is set to at each stage. If this were an ASP page calling a
VB COM object I'd have no problems, however, I've no idea how to trap
this in debug mode using standard ASP code. I know the debugger
often start up when there's an error in the code, but there isn't.
So, can anyone enlighten me as to how I can step into code using
simple ASP (not .Net).

Many thanks in advance.

Griff


For server-side script debugging, you will need to get Visual Interdev. I
know of no other option, besides liberal use of response.write.

If you are using SQL Server, you can use SQL Profiler to at least see the
SQL statements being used.

Sorry,
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.
Jul 19 '05 #3
Great! Slow progress, but getting there...many thanks!
Jul 19 '05 #4
On Mon, 17 Nov 2003 18:53:57 -0000, "GriffithsJ"
<Gr************@hotmail.com> wrote:
I've just inherited a web site. Someone's just asked me "what database
table fields are looked at in a particular search?"
Find the SQL call and Response.Write the SQL statement right before
it.
You'd think this would be easy, but I'm looking at an ASP page that when
printed out is >16 pages and has 20 include files. And no comments. It's
just a series of scary logic.
Man, you'd think I wrote it then... :)
I really need to run this though in "debug mode", seeing what every variable
is set to at each stage. If this were an ASP page calling a VB COM object
I'd have no problems, however, I've no idea how to trap this in debug mode
using standard ASP code. I know the debugger often start up when there's an
error in the code, but there isn't. So, can anyone enlighten me as to how I
can step into code using simple ASP (not .Net).


Visual Interdev is about it I think.

Jeff
Jul 19 '05 #5
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:3f*****************@msnews.microsoft.com...
On Mon, 17 Nov 2003 18:53:57 -0000, "GriffithsJ"
<Gr************@hotmail.com> wrote:
error in the code, but there isn't. So, can anyone enlighten me as to how Ican step into code using simple ASP (not .Net).


Visual Interdev is about it I think.


Start here:
http://support.microsoft.com/?kbid=244272

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

Jul 19 '05 #6
<<
I've just inherited a web site. Someone's just asked me "what database
table fields are looked at in a particular search?"


There might be an area that has something like this:
strSQL = "SELECT LName, FName, Company FROM MyTable ORDER BY LName,
FName"

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Serdar Kalaycý | last post: by
2 posts views Thread by Andy Fish | last post: by
2 posts views Thread by Alex Clark | last post: by
5 posts views Thread by Velvet | last post: by
6 posts views Thread by KevinGPO | last post: by
5 posts views Thread by =?Utf-8?B?Z2FkeWE=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.