The business of ESQL

Cases:

Transaction start, lock connection

<esql module=base1 Act=edit commit=false><! [Cdata[set @rownum =0]]></esql>

middle of SQL operations

<esql module=base1><! [Cdata[show databases]]></esql>

Execute commit

<esql module=base1 id=list commit=end><! [Cdata[    Selectusername, (@rownum: [email protected]+1) as ID from Base_users order by id]]></esql>

Fromcommit= falseStart, tocommit= EndEnd, same module (module=base1) of all esqlThe SQL statement in the tag will form a transaction to commit to the database
The complete code

(Example file: _samples/commit.html, note that the MySQL database is required for this instance to execute correctly)
For experienced programmers, there is no need to make much explanation, just run the example and try it out.
Download and description of light-open platform resources
platform free Download:http://download.csdn.net/detail/tx18/8381859
Latest Development Manual Download: http://download.csdn.net/detail/tx18/8411089
Development example: Light Open e-commerce website , free download: http://download.csdn.net/detail/tx18/8318585
The light-open platform will be upgraded to provide you with more powerful and easy features, please note the latest development manuals
The business of ESQL