in reply to perl, IIS, and sql Server help

What is displayed in the browser when you access this page?
Have you you tried running the "non-working" script from the command prompt?
I don't know a lot about IIS, but do you have it set up to execute .pl files and all that wacky stuff?

- FrankG

Replies are listed 'Best First'.
Re: Re: perl, IIS, and sql Server help
by esolm (Acolyte) on Mar 29, 2001 at 22:43 UTC
    IIS on my local machine is set up to execute .pl files as I note with the hello world! script written to display on my webserver in html.

    As for the non_working script the browser shows the title as defined at <title>dbtest </title> but then shows a blank screen.

    I know the basic database query works because the second code non html works from the command line. So the problem is that the third code does not work when called from the url.
[reply]
[d/l]
      Ok... I see a problem.
      In your code in the third script: 
      while (($name, $type, $len) = $sqlquery->fetchrow_array) {
        print "<tr><td>$name</td>
                <tr>$type</td>
                <tr>$len</td></tr>";
}

      [download]
      A couple of those <tr>'s should be <td>'s.
      Change it to this: 
      while (($name, $type, $len) = $sqlquery->fetchrow_array) {
        print "<tr><td>$name</td>
                <td>$type</td>
                <td>$len</td></tr>";
}

      [download]

      And just as a rule, when I run into problems like this, the first thing I usually do is run the script from the command line. It often helps you figure out what is and is not going on.

      - FrankG

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom