Page History

Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.

SELECT * FROM app_fd_table WHERE  id = '#requestParam.id#'

Note: If you use JDBC in a form grid for load/save, be advised the SQL syntax is different from the above. Kindly download and view the sample app for JDBC in a form grid at the bottom of this page.

Use syntax like curly brackets {field_id} in query to inject submitted form data.

INSERT app_fd_table 
       (id, 
        c_name, 
        c_emailaddress, 
        c_contacttel) 
VALUES ({id}, 
        {name}, 
        {emailAddress}, 
        {contactTel}) 

Note: Be advised JDBC load/save binders cannot be used if your form or form grid has file or image attachment field elements. You will need to use the default Multirow Form Binder in this circumstance.

Use syntax like curly brackets {field_id} in query to inject submitted form data.

UPDATE app_fd_table 
SET    id = {id}, 
       c_name = {name}, 
       c_emailaddress = {emailAddress}, 
       c_contacttel = {contactTel} 
WHERE  id = {id} 

Used in deleting form data records in Datalist/Grid element. Use syntax like curly brackets {id} in query to inject form data primary key

DELETE FROM app_fd_table 
WHERE  id = {id}