Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 11 of 11
  1. #1
    max
    max is offline
    New to the CF scene
    Join Date
    Jun 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    forms and database

    1.
    <%@ Language=VBScript %>
    <% Option Explicit %>
    <!--#include file="DatabaseConnect2.asp"-->
    <!--#include virtual="/adovbs.inc"-->
    <HTML>
    <BODY>
    <FORM ACTION="ProcessOrder.asp" METHOD=POST>
    <SELECT NAME="ShippingChoice">
    <%
    Dim objRS
    Set objRS = Server.CreateObject ("ADODB.Recordset")
    objRS.Open "tblShipping", objConn, , , adCmdTable
    Do While Not objRS.EOF
    Response.Write "<OPTION VALUE='" & objRS("ShippingCode") &"'>"
    Response.Write objRS("Description")
    objRS.MoveNext
    Loop
    objRS.Close
    Set objRS = Nothing
    objConn.Close
    Set objConn = Nothing
    %>
    </SELECT>
    <INPUT TYPE=SUBMIT VALUE="Submit">
    </FORM>
    </BODY>
    </HTML>
    2.<%
    Dim objConn
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.ConnectionString ="Driver={Microsoft Access Driver (*.mdb)};"& "DBQ=C:\My Documents\WidgetWorld.mdb"
    objConn.Open
    %>
    3.

    <%
    if NOT Request.form("EmployeeName") = "" then %>
    <!--#include file="databaseconnect2.asp"-->
    <!--#include file="listing1604.asp"-->
    <%End if%>

    The user select an option from the drop down menu, and he will get the reult from the database. THat is my goal. So, what is wrong with the code?

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Location
    The Planet Earth Code Poet: True
    Posts
    282
    Thanks
    0
    Thanked 1 Time in 1 Post
    So what works so far and what doesn't? I do not see where you querry the DB for the recordset you need to fill the HTML select box?

    It sounds like you want to get the info for the select box from the DB, have the user make a selection from those options then send the selected options to your ProcessOrder.asp page.

    So what part of this works already, what part is broken, and what specifically are you trying to do? If you can expalin more of what the problem and end goal is we can be of more help.

  • #3
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,032
    Thanks
    0
    Thanked 248 Times in 245 Posts

    Re: Re: forms and database

    that is a DSN-less connection for an Access database. As long as the database is on the correct path on the server, it will work just fine. Of course if it's going to be published somewhere else, the db should be on the server directory and the path in the db connection should be changed accordingly.

    Originally posted by Dave Clark

    Also, the one exposed connection seems to be using a local database file. Is that what you're doing? I ask, because that line is not the best way to code a dynamic database connection (in other words, one that will work both on your local PC and on a site that you may or may not intend to publish this page to).

    OK?

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    exposed = DSN-less
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #5
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    Here's a working example of what John was referring to, if this was what you meant: a select box that is populated from a db, the selected value of which is used as a variable in a query to fetch the result set.

    Dynamic Queries

  • #6
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Re: forms and database

    Originally posted by Dave Clark


    Code:
    <%@ Language=VBScript %> 
    <% Option Explicit %> 
    <!--#include file="DatabaseConnect2.asp"--> 
    <!--#include virtual="/adovbs.inc"--> 
    
    <%
    	If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
    %> 
    <!--#include file="databaseconnect2.asp"--> 
    <!--#include file="listing1604.asp"--> 
    <%
    	End if
    %>
    I'm not sure, but when you use the Include file command you can't really use it in an if statement. As soon as IIS (Or whatever server you're using) processes the ASP, it'll include the files regardless of your "IF" condition.

    I've tried using a dynamic include (IE - Include this file if it's this condition, or include this file if it's another condition.)

    It didn't work for me. - I read somewhere that it's very unpredictable whether or not this will work.

    Just thought I'd give you the heads up, in case you run into problems.

    ~Quack

  • #7
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    P.S. Here's a DSN-less Access DB connection that works on brinkster, at any rate:

    Set Conn = Server.CreateObject("ADODB.Connection")
    sConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
    sMapPath = Server.MapPath("\")
    sMapPath = Mid(sMapPath, 1, InStrRev(sMapPath,"\")-1) & "\database\databasename.mdb;" & _
    "Persist Security Info=False;"
    sConnString = sConnString & sMapPath
    Conn.Open sConnString

    Set Conn = Nothing
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #8
    Regular Coder
    Join Date
    Jun 2002
    Posts
    676
    Thanks
    1
    Thanked 0 Times in 0 Posts
    ReyN posted...
    /me just a whispers®...

    just a heyyytheres® rey...:O))) great to see ya made it just a over® to the codingforums :O)))
    The New JustaBuster Version 2.0 OR JustaBusta Lite V2.0
    ...just a special® thanx kinda hugs to jkd n' nex ...:O)))

    CommemorateWTC.com --Please lend your support

  • #9
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, just a little something on this Server.MapPath thingy:

    Server.MapPath returns the physical file path that corresponds to the specified virtual path on the Web server.

    This is useful (in fact is obligatory) in cases where the data source is not in the same directory as the calling page. Dave's logic might have been better seen as follows:

    The physical path to the data source in your local drive may not be the same physical path on the Web server, even if your local web has the same exact file structure as your web on the remote machine, as the mapping or assignment of the virtual root of your web app in your local host may not be the same as on the remote server.

    For instance, the files for my site are physically located at c:\aspxtreme in my local machine.

    In aspalliance.com (the mother site of aspxtreme), all columnists' virtual directories are physically located on d:\domains\aspalliance.com\ plus the name of the columnist's virtualdir . . . (in my case, aspxtreme)

    Using Server.MapPath with the specified virtual path, for example:

    /aspxtreme/shared/data/whatever.mdb

    ensures that the data source would be referenced correctly whether I am working locally or on the remote.

    No offense, whammy but that code at brinkster is totally unnecessary. A simple Server.MapPath that points to your data source as seen from your virtual root will do. For example, this alone will work:

    strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
    Server.MapPath("/virtualroot/subdir/whatever.mdb")

    Hello justame.

  • #10
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    btw

    Server.MapPath is not necessary for SQL Server data. SQL data could be anywhere, in another drive or even in another remote machine, and the path is automatically mapped when you attach the database to the instance of SQL Server you will be using.

  • #11
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would have thought it was unnecessary, as well - yet when I used a simple connection string (actually I believe it was identical to the one you posted), I always got errors on brinkster. I usually use a very simple one at work (when I actually use an Access DB, that is - which is very rarely).

    I'd have to try it again to be sure, though.
    Last edited by whammy; 06-21-2002 at 01:38 AM.
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

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