Results 1 to 1 of 1

Thread: Blank input fields

  1. #1
    Join Date
    Oct 2002
    Posts
    933

    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
  •