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 | |
|---|---|---|
|
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 )
|
|
|
CreateXML | This low level method creates the result XML from the ExecuteSQL call. Method always creates [XML output](vfps://Topic/XML%20Response%20Format).
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)
|
|
cAllowedCommands | Comma delimited list of SQL commands that are allowed when handling SQL commands. |
|
|
cErrorMsg | Error Message returned when an error occurs. |
|
|
cFullSQL | Contains the SQL command that will be run after ParseXML or S_Execute completes. |
|
|
cSQLCommand | Contains only the SQL command keyword (select,delete,execute etc) as opposed to the full SQL statement. |
|
|
cRequestXML | The incoming XML that is to be processed. Available only after the S_Execute call completes. |
|
|
cResponseXML | The output XML generated by the request. |
|
|
cConnectString | A SQL Connect string used to connect to the database. If you use this property a new connection is created for each request. If you want to reuse a connection use the… |
|
|
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