com.aspc.Layers.aspc_app.subscription

Class RecordOnlineSub

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.subscription.RecordOnlineSub

All Implemented Interfaces:

CommandBuildResultsPlugin

public class RecordOnlineSub
extends SQLCommand

Syntax

  CREATE_SUBSCRIPTION [[KEY global_key] |

                             [ FIRST_NAME sub_first_name
                               LAST_NAME sub_last_name
                               [EMAIL sub_email]
                               [AREA_CODE sub_area_code]
                               [PHONE sub_phone]
                               [COUNTRY sub_country]
                               [SUBURB_CITY sub_suburb_city]
                               [COMPANY sub_company]
                               [POSITION sub_position]
                               [SUMMARY sub_summary]
                               [DESCRIPTION sub_description]
                             ]
                             PRODUCT sub_product
                             TYPE sub_type
                             [TERM sub_term]
                             [START_DATE sub_start_date]
                             [QTY sub_qty]
                             [ENQUIRY_SOURCE_NAME enquiry_source_name]
  

Usage

  CREATE_SUBSCRIPTION
                      FIRST_NAME Kate
                      LAST_NAME  McGrath
                      EMAIL kate@gmail.com
                      PHONE 5345344
                      AREACODE 560027
                      COUNTRY india
                      CITY trivandram
                      POSITION software engineer
                      COMPANY extolution
                      SHORTDESCRIPTION trail
                      DESCRIPTION  trail web
                      DUEBY 10
                      CLOSEDDATE 12/11/2007
  

THREAD MODE: SINGLE THREADED command

Since:

21 February 2007

Author:

nabhilash

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
RecordOnlineSub(Connection connection, Pattern pattern)

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) get the column type
java.lang.String	getRecordID(int row) We are at the last row when we return null for the record ID.
java.lang.Object	getValue(int row, int col) The value for this column/row

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

RecordOnlineSub

public RecordOnlineSub(Connection connection,
                       Pattern pattern)

Parameters:

connection -

pattern -

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Parameters:

col - the column

Returns:

the name

getColumnType

public java.lang.String getColumnType(int col)

Description copied from interface: CommandBuildResultsPlugin

get the column type

Parameters:

col - the column

Returns:

the value

getRecordID

public java.lang.String getRecordID(int row)

Description copied from interface: CommandBuildResultsPlugin

We are at the last row when we return null for the record ID. All rows must have a unique ID. Nothing else is assumed about a record ID other than it is unique and will return the same value at a later time.

Parameters:

row - the row to use

Returns:

the value

getValue

public java.lang.Object getValue(int row,
                                 int col)

Description copied from interface: CommandBuildResultsPlugin

The value for this column/row

Parameters:

row - the row to use

col - the column

Returns:

the value