[Top] [Prev] [Next] [Bottom] [Contents]

Insert, Update, and Delete Using QUERY_STRING

 The Sapphire/Web Java Data Control supports another method for insert, update, and delete besides form post. This method uses QUERYSTRING.

Insert Using QUERYSTRING

To use this method for insert, add the following parameter:

<param name="insCols" value="0,1,2,3,4,5,6,7,8" >
The above indicated that 9 columns are sent in ascending order. The syntax for this parameter is the same as that for indexCols. So the following is equivalent to the above example:

<param name="insCols"
value="au_id,au_lname,au_fname,phone,address,city,state,c
ountry,postalcode" >
For the argument bindings, you must change the code fragments to these:

SaGetNArg(0)
SaGetNArg(1)
SaGetNArg(2)
SaGetNArg(3)
SaGetNArg(4)
SaGetNArg(5)
SaGetNArg(6)
SaGetNArg(7)
SaGetNArg(8)

Delete Using QUERYSTRING

 To use this method for delete, add the following parameter:

<param name="delCols" value="0" >
The above indicated that the first column is sent. The syntax for this parameter is the same as that for indexCols. So the following is equivalent to the above example:

<param name="delCols" value="au_id" >
For the argument binding, you must change the code fragments to:

SaGetNArg(0)

Update Using QUERYSTRING

 To use this method for update, add the following parameters:

<param name="updCols" value="1,2,3,4,5,6,7,8" >
<param name="updWhere" value="0" >
The above indicated that 9 columns are sent. The au_id column is the last column. It is being used in the where clause. Its value is the old value, before the update. The syntax for these parameter is the same as that for indexCols.

Therefore the following is equivalent to the above example:

<param name="updCols"
value="au_lname,au_fname,phone,address,city,state,country
,postalcode" >
<param name="updWhere" value="au_id" >
For the argument bindings, you must change the code fragments to these:

SaGetNArg(8)
SaGetNArg(0)
SaGetNArg(1)
SaGetNArg(2)
SaGetNArg(3)
SaGetNArg(4)
SaGetNArg(5)
SaGetNArg(6)
SaGetNArg(7)


[Top] [Prev] [Next] [Bottom] [Contents]

info@bluestone.com
Copyright © 1997, Bluestone. All rights reserved.