Results 1 to 2 of 2

Thread: Submitting data to a database

  1. Jun 21st, 2001, 08:44 AM #1
    kanejone
    kanejone is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224

    Submitting data to a database

    Hi Guys,
    I have a form with two fields. Name and e-mail address. I was just wondering if someone could show me quickly how to send these two values to an online Access Database called mydb.mdb.
    Sorry for asking such a simple Question.

    Thanks
    JK
    Reply With Quote Reply With Quote
  2. Jun 21st, 2001, 09:04 AM #2
    CiberTHuG
    CiberTHuG is offline
    Frenzied Member
    Join Date
    Feb 2001
    Posts
    1,140
    The form has a page it calls as its POST action. That page (hopefully being an ASP) can get the submitted information via the Request object.

    Code:
    Request.Form("userName")
Request.From("userEMail")
    You can put these into the SQL statement

    Code:
    SQL = "UPDATE field IN table VALUES " & Request.From("myValue")
    I've been using ADODB, which works the same way as in VB.
    Travis, Kung Foo Journeyman
    As always, RTFM.

    WWW Standards: HTML 4.01, CSS Level 2, ECMA 262 Bindings to DOM Level 1, JavaScript 1.3 Guide and Reference
    Perl: Learn Perl, Llama, Camel, Cookbook, Perl Monks, Perl Mongers, O'Reilly's Perl.com, ActiveState, CPAN, TPJ, and use Perl;
    YBMS, but Mozilla doesn't.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width