docs.roxen.com
main | demo | docs
download | community | pike
2000 Roxen Internet Software
Suggestions, Comments or Complaints
manuals@roxen.com

DocsRoxen2.0Web Site Creator ManualDatabase tags


  • <sqlquery>
  • <sqltable>
  • <sqlquery/>

    Executes an SQL query, but doesn't do anything with the result. This is mostly used for SQL queries that change the contents of the database, for example INSERT or UPDATE.

    Attributes

    host
    host=database
    Which database to connect to, usually a symbolic name set in the

    module. If omitted the default database will be used.
    query
    query=SQL statement
    The actual SQL-statement.
    parse
    If specified, the query will be parsed by the RXML parser. Useful if you wish to dynamically build the query.
    mysql-insert-id
    mysql-insert-id=form-variable
    Set form-variable to the insert id used by Mysql for auto-incrementing columns. Note: This is only available with Mysql.