Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: My Web page building question

  1. #1
    Regular Member Mourgos's Avatar
    Join Date
    Oct 2003
    Posts
    291

    Default

    My question is like this :

    I want to make my page collect some data from input boxes and then send them to an asp file that will put them in a database and confirm its action to the user with a message.
    Also I want my page to be able to retrieve the data from the database.
    In simple words I want to do something similar to the registring and signing in of this forum .

    What I have in mind for the registring is sth like this:
    <html><body><form action="response.asp"><input type="text" name="user">
    <input type="submit" value="submit></form></body></html>
    Then in response.asp I will assign the user name in a variable like this:
    <%
    dim a
    username=request.querystring{"user") %>
    and now I want to put the variable&#39;s value in a database but I don&#39;t know how.Also I don&#39;t know how to retrieve the data from the page.

    I&#39;ve heard that it&#39;s possible to do it in php but I only know asp,vbscript and Javascript scripting.

    So to conclude ,do you know how to do this ?(Without using php scripting which I don&#39;t know ,as I have already stated)

    Edit:Forgive me if my english are bad

  2. #2
    Jet Set Willy
    Guest

    Default

    The language will probably have some sort of extension for using databases such as mySQL, or you can put it in a flat file custom database if you&#39;re so inclined.

    It&#39;s just something you&#39;ll have to look up, nobody can list the appropriate functions for you to use as well as the documentation itself.

  3. #3
    Regular Member Mourgos's Avatar
    Join Date
    Oct 2003
    Posts
    291

    Default

    I just opened this www.w3schools.com page that a friend had told me about.It looks good and I may find sth relevant there but nevertheless if anyone could help I would appreciate it.

  4. #4
    Forum Administrator Lefteris_D's Avatar
    Join Date
    Sep 2003
    Location
    Athens, Greece
    Age
    38
    Posts
    3,856

    Default

    First of all, what kind of database are you going to use? ASP needs to have a ADO connection string just like Visual Basic. As for manipulating data try to remember the "recordset" commands. I cant help more as my ASP is a bit rusted.
    ...

  5. #5
    Forum Administrator GHDpro's Avatar
    Join Date
    Sep 2003
    Location
    The Netherlands
    Age
    42
    Posts
    500

    Default

    Lefteris_D already mentioned the most important stuff. Look for
    help on "ADO" and "recordset". Ah the memories. My current
    database library in PHP still is based on that principle (which really
    isn&#39;t that bad).

    Be aware though that your host does need to have given you access
    to either a MS SQL server database or Access database (or possibly
    other ODBC solution).

    Also, my advice above may not be entirely accurate... it&#39;s been a WHILE
    since I did anything in ASP...

  6. #6
    Forum Administrator Lefteris_D's Avatar
    Join Date
    Sep 2003
    Location
    Athens, Greece
    Age
    38
    Posts
    3,856

    Default

    ODBC is needed on SQL Server either he likes it or not, there is no other way to perform the connection. As for Access databases, he can make a direct connection to an Access database as long as he has the absolute path to that file. For example, Snitz forums operate by absolute path or ODBC connection to Access databases.

    Direct connections and ODBC connections to Access are the same in Visual Basic as well. Try finding how to create the ADO connection string in visual basic without using visual components and you will have almost the exact the code you need.
    ...

  7. #7
    Jet Set Willy
    Guest

    Default

    No, ODBC is a Microsoft API for standardising SQL databases across platforms. As usual you don&#39;t know what you&#39;re saying.

  8. #8
    Forum Administrator Lefteris_D's Avatar
    Join Date
    Sep 2003
    Location
    Athens, Greece
    Age
    38
    Posts
    3,856

    Default

    Mourgos wants to manage a database using ASP(insert data). The easiest solution is to use an ADO connection string to an access database after finding out the direct path(example c:&#092;databases&#092;mydb.mdb).

    The alternative is for that database to be linked using ADBC. For that the server admin needs to create the connection so applications & scripts can use it.

    Last time I checked the native platform for ASP(the language Mourgos wants to use) was made by Microsoft so giving him ODBC tips is not wrong.
    ...

  9. #9
    Jet Set Willy
    Guest

    Default

    "ODBC is needed on SQL Server either he likes it or not, there is no other way to perform the connection."

    I think you need to state that you mean only for ASP, then. Even then, I think it&#39;s still inaccurate.

  10. #10
    Forum Administrator Lefteris_D's Avatar
    Join Date
    Sep 2003
    Location
    Athens, Greece
    Age
    38
    Posts
    3,856

    Default

    Yes, ODBC is needed ONLY in ASP to perform a connection to Microsoft SQL Server.

    When it comes to ASP.NET I dont know if there are other ways to perform the connection as I have yet to study the language so anything I say concerns the previous version.

    In PHP there are already libraries that can perform connection to SQL Server without ODBC.
    ...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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