dbEditDropFlds

[Jim]

Why when I leave out "NoBlank" is the lookup not honored???
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,,,Distinct"

When I change it to the following:
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
the lookup is honored. This type implementation is needed for optional fields that can have a blank or NULL value.

[Jim]

The following code is not honoring the lookup at all.
Please help.
Set Y=Server.CreateObject("ASPdb.Y2K&#34
Y.dbUnit = 105
Y.dbDSN="provider=SQLOLEDB; data source=; initial catalog=Pubs; user id=sa; password="
Y.dbDBType="SQL"
Y.dbMode="dual"
Y.dbGridIndex = true
Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
Y.dbEditParams = "TableName=titles, BookMarkFlds=title_id, TableTag=Border=1, RecordScope=single, CriteriaSize=3x10, EditCol=1"
Y.dbDisplayLookupList = "(;|)pub_id||Select pub_id,pub_name FROM publishers;"
Y.dbFormDisplayFlds = -1
Y.dbSQL="Select * FROM titles ORDER BY title"
Y.dbGridTableTag = "Border=1 CELLSPACING=1 CELLPADDING=1"
Y.dbImageDir = "../aspdb/images/"
Y.dbExportFlds = "0,1,2,3,4,5,6"
Y.dbGridInc = -1
Y.dbNavigationIcon="std"
Y.dbNavigation="bottom"
Y.dbNavigationItem="top,bottom,next,prev,reloa d,filter,add,update"
Y.dbColor="White,#000000,#FFFFD7,Black"
Y.ASPdbY2K

------------
Jim at 3/9/00 9:21:49 AM


Why when I leave out "NoBlank" is the lookup not honored???
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,,,Distinct"

When I change it to the following:
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
the lookup is honored. This type implementation is needed for optional fields that can have a blank or NULL value.

[Mark]

Jim,

I changed your code from:
'Y.dbEditDropFlds="pub_id,,publishers,pub_ name,,,Blank,,Distinct"

to:

Y.dbEditDropFlds="(;|)pub_id||||Select pub_id,pub_name FROM publishers ORDER BY Pub_Name"

It looks OK to me. Give it a try.
Mark.

------------
Jim at 3/9/00 9:41:36 AM


The following code is not honoring the lookup at all.
Please help.
Set Y=Server.CreateObject("ASPdb.Y2K&#34
Y.dbUnit = 105
Y.dbDSN="provider=SQLOLEDB; data source=; initial catalog=Pubs; user id=sa; password="
Y.dbDBType="SQL"
Y.dbMode="dual"
Y.dbGridIndex = true
Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
Y.dbEditParams = "TableName=titles, BookMarkFlds=title_id, TableTag=Border=1, RecordScope=single, CriteriaSize=3x10, EditCol=1"
Y.dbDisplayLookupList = "(;|)pub_id||Select pub_id,pub_name FROM publishers;"
Y.dbFormDisplayFlds = -1
Y.dbSQL="Select * FROM titles ORDER BY title"
Y.dbGridTableTag = "Border=1 CELLSPACING=1 CELLPADDING=1"
Y.dbImageDir = "../aspdb/images/"
Y.dbExportFlds = "0,1,2,3,4,5,6"
Y.dbGridInc = -1
Y.dbNavigationIcon="std"
Y.dbNavigation="bottom"
Y.dbNavigationItem="top,bottom,next,prev,reloa d,filter,add,update"
Y.dbColor="White,#000000,#FFFFD7,Black"
Y.ASPdbY2K

------------
Jim at 3/9/00 9:21:49 AM


Why when I leave out "NoBlank" is the lookup not honored???
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,,,Distinct"

When I change it to the following:
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
the lookup is honored. This type implementation is needed for optional fields that can have a blank or NULL value.

[Jim]

You are absolutely correct!
Thanks!


------------
Mark at 3/9/00 3:32:30 PM

Jim,

I changed your code from:
'Y.dbEditDropFlds="pub_id,,publishers,pub_ name,,,Blank,,Distinct"

to:

Y.dbEditDropFlds="(;|)pub_id||||Select pub_id,pub_name FROM publishers ORDER BY Pub_Name"

It looks OK to me. Give it a try.
Mark.

------------
Jim at 3/9/00 9:41:36 AM


The following code is not honoring the lookup at all.
Please help.
Set Y=Server.CreateObject("ASPdb.Y2K&#34
Y.dbUnit = 105
Y.dbDSN="provider=SQLOLEDB; data source=; initial catalog=Pubs; user id=sa; password="
Y.dbDBType="SQL"
Y.dbMode="dual"
Y.dbGridIndex = true
Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
Y.dbEditParams = "TableName=titles, BookMarkFlds=title_id, TableTag=Border=1, RecordScope=single, CriteriaSize=3x10, EditCol=1"
Y.dbDisplayLookupList = "(;|)pub_id||Select pub_id,pub_name FROM publishers;"
Y.dbFormDisplayFlds = -1
Y.dbSQL="Select * FROM titles ORDER BY title"
Y.dbGridTableTag = "Border=1 CELLSPACING=1 CELLPADDING=1"
Y.dbImageDir = "../aspdb/images/"
Y.dbExportFlds = "0,1,2,3,4,5,6"
Y.dbGridInc = -1
Y.dbNavigationIcon="std"
Y.dbNavigation="bottom"
Y.dbNavigationItem="top,bottom,next,prev,reloa d,filter,add,update"
Y.dbColor="White,#000000,#FFFFD7,Black"
Y.ASPdbY2K

------------
Jim at 3/9/00 9:21:49 AM


Why when I leave out "NoBlank" is the lookup not honored???
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,,,Distinct"

When I change it to the following:
Ex: Y.dbEditDropFlds="pub_id,,publishers,pub_name, ,,NoBlank,,Distinct"
the lookup is honored. This type implementation is needed for optional fields that can have a blank or NULL value.