Databases
StackOverflow2013
Postsdbo
POHow to perform lookup from textfield value and populate form elements without reloading page?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to perform lookup from textfield value and populate form elements without reloading page?
    primarykey
    data
    text
    <p>I have a very simple Form which has a textfield called <code>CustomerNumber</code>. There are other elements in the Form such as selects and lists that need to contain values related to the <code>CustomerNumber</code>.</p> <p>All I want to do is:</p> <ol> <li>User enters in a value into the <code>CustomerNumber</code> textfield and then 'tabs' out or just clicks somewhere else on the page </li> <li>the value entered in <code>CustomerNumber</code> should then be passed as to a database query which will return the results that are based on the <code>CustomerNumber</code> value (e.g. customer's previous orders)</li> <li>The results from the database query are used to populate the other Form elements</li> <li>Finally once the user has filled in the form correctly, they will submit the entire form (including the CustomerNumber) to the server for processing</li> </ol> <p>I just had a little look at JQuery and tried some simple DOM manipulation (e.g. <code>paragraph.text("new value")</code>) and the first I noticed is that none of the HTML in the Sourcecode gets changed. Within the browser I can see the change but not in the HTML. </p> <p>This leads me to wonder that if I user JQuery to manipulate Form elements (through an AJAX call or something - I don't know Jquery yet), how will the database data returned from the AJAX call populate the Form elements and how will it actually get submitted to the server when they don't exist in the HTML? </p> <p>I tried doing it using just HTML forms and have a submit button next to the <code>CustomerNumber</code> textfield and do a self-submit page, but that would mean having a Form within a Form which isn't possible...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USvolume one
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThe easiest way to accomplish this is with the bind attribute of cfinput.
      singulars
      1. POHow to perform lookup from textfield value and populate form elements without reloading page?
      1. USDan Bracuk
    2. CO@DanBracuk thanks for the tip. I was thinking to do just that but thought that CF is simply generating the javascript on my behalf which means I am losing some control...??
      singulars
      1. POHow to perform lookup from textfield value and populate form elements without reloading page?
      1. USvolume one
    3. CO*how will it actually get submitted to the server when they don't exist in the HTML* As long as the form elements exist (and are valid) whatever value(s) they contain at the time of submission will be sent to the server. Regardless of whether the value was entered manually by a user or programatically w/Jquery. *Re: CF is simply generating the javascript on my behalf* Correct. It has a few quirks, and also uses older versions of most of the js libraries like ExtJS. Personally, I would recommend using jquery instead, or using ExtJS directly.
      singulars
      1. POHow to perform lookup from textfield value and populate form elements without reloading page?
      1. USLeigh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload