Executes and persits the results of an SQL statement.[SQLExecute Params]WebDNA to evaluate to a single SQL statement[/SQLExecute]
select firstName,lastName from employees;
|conn_ref (or just 'ref')||(Required) - The name of the connection variable you created with a prior execution of [SQLconnect] (the value you set for the "conn_var" or "var" parameter)|
|result_var (or just 'var')||(Optional) - The name of the SQLresult variable you wish to create on successful execution. This 'result' variable can be used later by setting the "result_ref" (or "ref") parameter of [SQLresult] to this value. If you do not specify a variable name, none will be created and it is assumed you wish to execute non-Select SQL commands. Even if you do execute a non-Select command, you may still want to 'save' the result. For example, if you execute a delete command, you can still specify a result variable, so that you can access other information, such as the number of rows affected.|
DOWNLOAD WEBDNA NOW!
A list of the currently available modules...Tips and Tricks
A list of user-submitted tips ...AWS Raw WebDNA LAMP-Plus WebServer
Amazon Web Services (AWS) README for Machine Image ID...Download WebDNA Applications
A compilation of some user's questions...Technical Change History
This Technical Change History provides a reverse chronological list of WebDNA changes...
File Formats - Order File/Shopping Cart in WebDNA...[sendmail]
There is hardly a website that doesn't at some point need to send an email...[version]
will display a random number...[deletefile]
Deleting a file from your website...[cart]
Putting [cart] in your template automatically creates a unique shopping cart...