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

MemberDescription

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

© West Wind Technologies, 1996-2018 • Updated: 02/07/02
Comment or report problem with topic