Professional Web Applications Themes

insert into a db... - ASP Database

Our graphic designer has just finished redeveloping our website. On the site, we use SSL to secure the area where a user enters their personal information to order items from us. (we do not do many transactions - maybe 1 per day...) We are a log home mfg company so they would only order plan books, maybe a video etc... When the user clicks "Submit Order", we want to encrypt each data item (because of new legislation governing customer personal info etc...) and write a record to an access db. From here it will be imported into our Customer DB ...

  1. #1

    Default insert into a db...

    Our graphic designer has just finished redeveloping our website. On the
    site, we use SSL to secure the area where a user enters their personal
    information to order items from us. (we do not do many transactions - maybe
    1 per day...) We are a log home mfg company so they would only order plan
    books, maybe a video etc...

    When the user clicks "Submit Order", we want to encrypt each data item
    (because of new legislation governing customer personal info etc...) and
    write a record to an access db. From here it will be imported into our
    Customer DB leads database...

    I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in
    many ways...

    Does someone have a good ASP script for encrypting data? And, if so, is it
    fairly strong encryption?

    Also, is there any trick to writing an "insert" SQL script in ASP or is it
    exactly the same as I would do in VB or Access? Maybe someone has an
    "insert" script handy they could pass along including the command to
    actually execute it?

    Thanks,

    Brad


    Brad Guest

  2. #2

    Default Re: insert into a db...

    Is it a requirement to have encrypted data in the database itself? Where I
    work, there are also many guidelines that we have to follow. The US's OCC
    (http://www.occ.gov/) has lots of rules like this that they're always
    auditing our Web site security. While we must encrypt all data that is sent
    from the browser to the server when it is anything remotely customer
    related, (i.e. via httpS), we are not required to store the data encrypted
    in the database itself.

    As far as coding things the same in VB and ASP, well, that depends on what
    you're doing in VB. I assume that you'll be using VB Script as your ASP
    language, yes? So, the code should be pretty similar. Browse around some
    of the FAQs at www.aspfaq.com for some code samples. One specific one that
    you may want to read prior to duplicating VB coding style in an ASP page is
    this one. http://www.aspfaq.com/show.asp?id=2191

    Ray at work


    "Brad Pears" <com> wrote in message
    news:%phx.gbl... 


    Ray Guest

  3. #3

    Default Re: insert into a db...

    I'd also suggest the following articles as well.

    http://www.aspfaq.com/show.asp?id=2080
    http://www.aspfaq.com/show.asp?id=2126
    http://www.aspfaq.com/show.asp?id=2183

    Ray Costanzo [MVP] wrote:
     
    >
    >
    >[/ref]

    joker Guest

  4. #4

    Default Re: insert into a db...

    Don't forget the Windows Script doentation

    http://surl.co.uk/?785

    --

    Regards

    Steven Burn
    Ur I.T. Mate Group
    www.it-mate.co.uk

    Keeping it FREE!


    "joker" <com> wrote in message
    news:#phx.gbl... [/ref]
    Where I [/ref]
    OCC [/ref]
    sent [/ref]
    encrypted [/ref]
    what [/ref]
    some [/ref]
    that [/ref]
    is [/ref][/ref]
    plan [/ref][/ref]
    it [/ref][/ref]
    it 
    > >
    > >
    > >[/ref]
    >[/ref]


    Steven Guest

Similar Threads

  1. Question Insert from ASP to SQL using recordset data as values in insert statement
    By JasonM in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 13th, 05:54 PM
  2. What's faster - loop for insert or insert...select.
    By mr. modus in forum Coldfusion Database Access
    Replies: 2
    Last Post: December 10th, 01:57 AM
  3. Multiple Insert or Looping Insert
    By payado in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 25th, 09:33 PM
  4. Replies: 0
    Last Post: July 23rd, 11:30 PM
  5. Replies: 3
    Last Post: September 30th, 09:24 PM

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