SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy ASP FAQ tutorial

    i have been using the ASP FAQ tutorial on webmasterbase.com and my code is practically the same. however, i cannot use PWS to run my scripts but i can use an ODBC. the problem is, i don't know how.
    i've read so many tutorials but when i try them, my code doesn't work.
    can someone please let me know the exact changes i would need to make to the FAQ tutorial code in order to view my ASP scripts using an ODBC?
    the tutorial is at:
    http://www.webmasterbase.com/article/536

    thank you in advance.

  2. #2
    SitePoint Wizard iTec's Avatar
    Join Date
    May 2001
    Location
    Sydney, Australia
    Posts
    2,243
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You cant use odbc to run an asp script.
    ODBC is a method for your scripts to connect to a database, it still needs something that can run the scripts, be it PWS or IIS.

    why cant you use PWS?

  3. #3
    SitePoint Guru siphilp's Avatar
    Join Date
    Nov 2001
    Location
    Fife, Scotland
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you set up your virtual directorys right. Your posting is abit confusing. You should post the error your getting


    Si

  4. #4
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, now I am using PWS. This is the error message:

    ADODB.Recordset error '800a0bb9'

    The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

    /help.asp, line 16

    and this is the code:

    <% Option Explicit %>

    <html>

    <head>
    <title>Frequently Asked Questions</title>
    </head>

    <body link="red" alink="red" vlink="red">
    <font face="Verdana">
    <center><h2>FAQ</h2>

    <%
    Dim rsFAQ
    Set rsFAQ = Server.CreateObject("ADODB.Recordset")
    rsFAQ.Open "SELECT questionID, question FROM FAQ", Application("strConn")

    Do While Not rsFAQ.EOF
    Response.Write "<b><a href=""answer.asp?ID=" & rsFAQ("questionID") & _
    """>"
    Response.Write rsFAQ("question") & "</a></b><br>-<br>"
    rsFAQ.MoveNext
    Loop
    If rsFAQ.BOF Then
    Response.Write "<p>Sorry, there are no entries in the database.</p>" & vbNewLine
    End If

    rsFAQ.Close
    %>

    </center>
    </font>
    </body>

    </html>

  5. #5
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,286
    Mentioned
    121 Post(s)
    Tagged
    1 Thread(s)
    Is application("strConn") defined and open? It doesn't look like it from the code you posted.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  6. #6
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Do you have a global.asa we can look at? That's often where application-scope variables are defined
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  7. #7
    + platinum's Avatar
    Join Date
    Jun 2001
    Location
    Adelaide, Australia
    Posts
    6,441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I could never get kevins tutorial to work for some reason ... there are better ways (apparently) to do it.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •