Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Nov 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    An Elegant Table Mapping Form???

    I need an input form that displays the existing columns of a table and
    allows the user to input new names into each field.

    The idea, as you probably know, is to map a couple of tables. My approach
    was to extract the column names from the first table, loop through them all,
    generate a form for each column, and collect them all. I'd then loop through
    all the records of the new input file, and build the new one.
    tables. But this strikes me as pretty wasteful, and something this
    useful must either already be available, or should be much, much more
    elegant. Like an existing form that already allows this. Or outputs
    the input and output lists of names as one or two SQL tables. Or maybe
    just a way to write entire columns all at once?

    Is the brute force method the best I can do, or not?

    Thanks!!

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,502
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    How about this ...
    http://www.drasticdata.nl/DDDrasticGrid.php

    Test it out too ... they use AJAX for immediate on-screen changes.

    I haven't tried it out yet myself, but it looks interesting.
    The download file has a lot of examples too.



    .


  •  

    Tags for this 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
    •