View Poll Results: Wat can i do to make it work?

Voters
2. You may not vote on this poll
  • I was told that this is a good site.

    2 100.00%
  • could some1 help me pls ! im kinda desperate ;(

    0 0%
Multiple Choice Poll.
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Thumbs down Unanswered: problem retriving information from database

    hey guys, im a newbie in asp. im pretty bad in the part that connects the webpage to the mssql database using asp connection.
    ive tried ways after ways to retrive the information from the database and i still cant get it right dont even know if im on the right track. hope u guys can help me out

    info in mssql -(table name : cust), (database name : silverstone )
    -----------
    -------------------------------
    custid | custname |
    ----------------------------- |
    A0123 | Joel Dumb dumb |
    A0122 | Emous Bim Boe |
    -------------------------------

    coding
    ------
    <%
    Set SysConn = Server.CreateObject("ADODB.Connection")
    SysConn.Open "silverstone", "sa", ""
    %>
    <html>
    <body>
    <%
    CustID = Session(mstrSessionPrefix & "CustDlg-CustUserID"CustID = Request.QueryString("CustID")

    ' Set sql.
    strSQL = "SELECT * "
    strSQL = strSQL & "FROM cust "

    %>
    <tr>
    <tr>
    <td> Car Registration Number : </td>
    <form name="form4" method="post" action="">
    <td>
    <input name="text_regno" type="text" id="text_regno">
    </td>
    </form>
    </tr>

    <tr>
    <td> Car Registration Number : </td>
    <form name="form4" method="post" action="">
    <td>
    <input name="text_regno" type="text" id="text_regno">
    </td>
    </form>
    </tr>
    </tr>
    </body>
    </html>

    <%
    SysConn.Close
    set SysConn = nothing
    %>



    pls help me out. thankx in advance !

  2. #2
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53
    http://www.asp101.com/samples/db_edit.asp

    Here's a quick sample that ties together a number of database functions into a simple little script for adding, deleting, and editing data in a database table. It's a pretty simple little script, but it illustrates a number of useful techniques and should help tie all the pieces together into one script.
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

Posting Permissions

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