-
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
Last edited by Frank; 03-11-2008 at 06:46 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|