Professional Web Applications Themes

Inserting into one table data from 2 tables and some input data. - ASP

Alrighty, I pull records from a database table onto a page based on vendor #. On this page I have an input box after each row of data that is just placed in there with the movenext of the rs so the text box has the same name set to all of them. What I need and want to do is let users add a date in text boxes as they need to. If there is a date in the text box I want some of the information in that record on that page and that date loaded into a ...

  1. #1

    Default Inserting into one table data from 2 tables and some input data.

    Alrighty,
    I pull records from a database table onto a page based on vendor #. On
    this page I have an input box after each row of data that is just
    placed in there with the movenext of the rs so the text box has the
    same name set to all of them. What I need and want to do is let users
    add a date in text boxes as they need to. If there is a date in the
    text box I want some of the information in that record on that page
    and that date loaded into a new table when they click the submit
    button. Somethings I think/know I need:
    A way to check to see if there is a date entered into the text box if
    not move on to the next record and check that one.
    A way to make sure my insert statement will go thorough and insert
    each row.

    I saw no examples on using an insert with a recordset so that might
    not even be possible. Any help would be greatly appreciated. Thanks so
    much!
    Renie83
    Renie83 Guest

  2. #2

    Default Re: Inserting into one table data from 2 tables and some input data.

    Renie83,
    You can validate the data on the server side or on the client side.

    You may have to write update statement for each updation you want.

    Thats a easy job!!
    Kiran Math


    Kiran Math Guest

Similar Threads

  1. Replies: 0
    Last Post: June 1st, 03:15 AM
  2. Inserting data into two seperate tables with Dreamweaver
    By lutzlut896 in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: October 13th, 07:40 PM
  3. Replies: 4
    Last Post: October 27th, 03:01 PM
  4. Replies: 2
    Last Post: March 8th, 11:57 AM
  5. Inserting data into a table
    By Geoff Wickens in forum ASP
    Replies: 1
    Last Post: August 25th, 10:06 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139