Hello and welcome to our community! Is this your first visit?
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
    Sep 2005
    Jacksonville, Florida
    Thanked 0 Times in 0 Posts

    Load SQL query results into a JavaScript array

    I am trying to figure out Javascript code needed to build a table array, populate the array with results of a SQL query at page load, and will support a function which dynamically populates a text-area with data from the array based on a user's choice of a related option/select list.

    Particulars related to this effort:
    option/select list named: "Subject"
    textarea named: "Message"

    SQL table to JavaScript Array:
    RecID / Location / MsgTrigger / Subject / MsgInternal / MsgExternal

    User action: Selects a subject text string, eg:Appointment Scheduled, from a drop-down select named "Subject".

    Dynamic Action: MsgInternal (related to the "Subject") text needs to load into the textfield="Message", e.g.Appointment for <insert name> has been scheduled on <insert date/time> from the values found in the JavaScript array.

    The above activity is performed within a Cold Fusion Page, running on IE 5.0+


  2. #2
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Near Chicago, IL, USA
    Thanked 32 Times in 31 Posts
    Any reason you have to do it that way?

    I have dynamic cfm pages similar to this, but instead of storing the values in an array, it uses an AJAX-like setup. User chooses an option and the choice affects another form element. Much easier to write than trying to get everything in an array and such. Works fine in IE5.

    Since they are password protected, I can't link them, but I could post code if you're interested, once I get home.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit


Posting Permissions

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