This element allows you to execute SQL sentences that does not have a result set. This is the case of inserts, updates, deletes or some kinds of stored procedures.

Use the QRYEXEC tag when you want to modify any information of a database by executing an insert, update or delete statement.

If you do not define the DOC property, the query will be executed as soon as it became interpreted. This is useful when we need to execute multiple statements in certain page.

In this mode, you set the property DOC to a certain document that you want to retrieve after the execution of the sentence. Here, the element will not execute the sentence at the moment of the interpretation. Instead, it will replace the element with an URL. Just when this URL is requested, then sentence is executed. This is very useful for defining multiple actions in a single page (for example: adding, updating and deleting information from a catalog, depending on the user selection).

File: /QryExec/Insert.dbsp

dataset example

insert data into a table

this example shows you a dataset containing all the dbsp_users table records. to insert a record into this table, you can add a simple input form to the page, and execute an insert command in the form submit event handler. the add button shows a page where you can add records to the dbsp_users table.

<#dataset alias=dbspdemo queryid=19>






 <#nodata>

 this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.this example shows how to insert records using a web page.

 <#/dataset>

first name	last name	username	password

<#firstname/>	<#lastname/>	<#usrname/>	<#usrpassword/>
there are no users registered.

SQL Sentence QUERYID=46

SELECT TITLE FROM DBSPEXAMPLES WHERE EXAMPLEID = :EXAMPLEID

SQL Sentence QUERYID=19

UPDATE DBSPNEWS SET TITLE = :TXTTITLE, IMAGEFILE = :TXTIMAGEFILE, INTRO = :TXTINTRO, BODY = :TXTBODY, NEWSDATE = "now", ORDEN = :TXTORDEN WHERE NEWSID = :ID

File: /QryExec/InsertExec.dbsp

dataset example

insert data into a table

just type the new user information to insert it into the database. once you have finished press accept.


first name*
last name*
username*
password*

SQL Sentence QUERYID=46

SELECT TITLE FROM DBSPEXAMPLES WHERE EXAMPLEID = :EXAMPLEID

File: /QryExec/Update.dbsp

dataset example

update a record

this example shows you a dataset containing all the dbsp_users table records. to update a record you can add a simple input form to the page, and execute an update command in the form submit event handler. the update button shows a page where you can update the selected record.

<#dataset alias=dbspdemo queryid=19>







 <#nodata>



 <#/dataset>

	first name	last name	username	password

	<#firstname/>	<#lastname/>	<#usrname/>	<#usrpassword/>
there are no users registered.

File: /QryExec/Delete.dbsp

dataset example

delete a record

       this example shows you a dataset containing all the dbsp_users table records. to delete a record you have to execute a delete command in the form submit event handler. once you have press the delete button a message appears to ask you for a confirmation. if your answer is afirmative the record is deleted.

<#dataset alias=dbspdemo queryid=19>







 <#nodata>



 <#/dataset>

	first name	last name	username	password

	<#firstname/>	<#lastname/>	<#usrname/>	<#usrpassword/>
there are no users registered.

File: examples/Ex6_5_1.dbsp

QRYEXEC Example


 
 <#HEADER NAME="Cache-Control" VALUE="no-cache,no-store"/>

QRYEXEC Example

This example shows a simple insertion into a table named CONTACTS. We include a very simple validation to avoid null insertions in any of the fields.

<#DATASET ALIAS="OPEX" QUERYID="13">




 <#NODATA>
 




 <#/DATASET>

Name	e-mail
<#USERNAME/>	<#EMAIL/>
There are no contacts registered.

Add a new contact

Name *

 e-mail *

SQL Sentence: ID=13

SELECT * FROM CONTACTS

SQL Sentence: ID=14

INSERT INTO CONTACTS (USERNAME, EMAIL) VALUES ('<#CONTACTNAME>','<#EMAIL>')

SQL Sentence: ID=15

DELETE FROM CONTACTS

File: examples/Ex6_5_2.dbsp

Multiple insertion example


 
 <#HEADER NAME="Cache-Control" VALUE="no-cache,no-store"/>

Multiple insertion example

This example shows how to insert multiple records in a single request to the server.

<#DATASET ALIAS="OPEX" QUERYID="13">




 <#NODATA>
 




 <#/DATASET>

Name	e-mail
<#USERNAME/>	<#EMAIL/>
There are no contacts registered.

Add multiple contacts

When you use a multiple execution statement, the first field in the MULTIVALUEPARAMS list must not be null (in this case, the NAME field). Otherwise, the entire row is ignored and the statement does not execute for this particular row.

SQL Sentence: ID=13

SELECT * FROM CONTACTS

SQL Sentence: ID=14

INSERT INTO CONTACTS (USERNAME, EMAIL) VALUES ('<#CONTACTNAME>','<#EMAIL>')

SQL Sentence: ID=15

DELETE FROM CONTACTS