in reply to Re: perl, IIS, and sql Server help
in thread perl, IIS, and sql Server help

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.

Replies are listed 'Best First'.
Re: Re: Re: perl, IIS, and sql Server help
by how do i know if the string is regular expression (Initiate) on Mar 29, 2001 at 23:12 UTC
    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