Class wwHTTPSQLServer
The wwHTTPSQLServer class is an XML based SQL Command handler that takes XML inputs and generates XML outputs for the requested commands. It is the server side handler for the wwHTTPSQL class.
Class Members
| Member | Description | |
|---|---|---|
 |
CreateXML |
This low level method creates the result XML from the ExecuteSQL call. Method always creates XML output. o.CreateXML() |
|
ExecuteSQL |
This low level method executes the actual SQL statement. This method also processes the XML parameters and any return values from stored procedures or wwHTTPSQLServer custom method calls. o.ExecuteSQL() |
|
ParseXML |
This low level method takes the XML input and parses the XML into the properties of the object. This allows you to check and possibly filter you SQL statements before the command runs. o.ParseXML(lcXML) |
|
S_Execute |
The core SQL handler method parses the incoming XML, executes the SQL statement/command and then returns the result (or error) as an XML response in the cResponseXML property. o.S_Execute( lvXML ) |
 |
cAllowedCommands |
Comma delimited list of SQL commands that are allowed when handling SQL commands. |
|
cConnectString |
A SQL Connect string used to connect to the database. If you use this property a new connection is created for each request. |
|
cErrorMsg |
Error Message returned when an error occurs. |
|
cFullSQL |
Contains the SQL command that will be run after ParseXML or S_Execute completes. |
|
cRequestXML |
The incoming XML that is to be processed. |
|
cResponseXML |
The output XML generated by the request. |
|
cSQLCommand |
Contains only the SQL command keyword (select,delete,execute etc) as opposed to the full SQL statement. |
|
lError |
Error Flag set when an error occurs. |
|
oSQL |
Instance of a wwSQL object that can be used to execute a SQL connection. Use this if you have a persistent SQL connection object you want to re-use. |
See also:
Class wwHTTPSQL
Comment or report problem with topic