Blank input fields

When an input field is blank during an Edit, there are two ways to build the Edit SQL ->

1. field = null
2. field = ''

Look at the following code. If you include the line

.dbEditAllowZeroLength = True

You'll have field=''. Otherwise, you'll get the standard field=null.

Another example of how flexible is ASP-db.

Fk



Dim SP As New Tornado.z
With SP
.dbQP = "Unit=1|S=7|M=G!sys=t|Ps=-1|Ni=b5,update|Th=ti=SQL Queries|Pv=SQLCLIENT| dt=SQL| bm=table1;0"
.dbBoolText = "DisplayTrue=<IMG SRC='/tornado/images-net/happyface.gif'>| DisplayFalse=<IMG SRC='/tornado/images-net/sadface.gif'>| DropTrue=-1| DropFalse=0"
.dbEditUpdateFlds = "0,1,fi=required|ty=SelectBox|va=TnF|te=BOOL"
.dbCommonTables = "(;,~)Index=TnF,BOOL|Value=-1,0~Ya,Na"
.dbDSN = "ultra\sqlexpress;SQL1;sa;sasa"
.dbSQL = "SELECT * FROM Table1"
.dbDebug = "EditAction"
.dbEditAllowZeroLength = True '..this is for field=''
.ASPdbNET()
End With