dbEditDropFlds Values

[Mike Shroyer]

Hello All,
I am using the dbEditDropFlds parameter for the first time and hope I have what will turn out to be a simple question.

The database field (MSSQL Server) has values of 0 or 1. I want to present to the user as "On-Premise" or "Off-Premise". I understand how to do this in HTML with:
<select>
<OPTION value=&#39;1&#39;>On-Premise
<OPTION value=&#39;0&#39;>Off-Premise
</select>

but I can&#39;t figure out how to do this in ASP-DB.

Thanks for any help,
Mike Shroyer

[Mark]

Mike,
Use the dbBoolText property (all 4 parameters). See Example 20 at:
http://www.aspdb.com/v2

Also, see the doc at:
http://www.aspdb.com/docs/aspdbman.htm#dbBoolText

That should do it.
Mark.


------------
Mike Shroyer at 10/2/00 10:24:37 AM

Hello All,
I am using the dbEditDropFlds parameter for the first time and hope I have what will turn out to be a simple question.

The database field (MSSQL Server) has values of 0 or 1. I want to present to the user as &#34;On-Premise&#34; or &#34;Off-Premise&#34;. I understand how to do this in HTML with:
<select>
<OPTION value=&#39;1&#39;>On-Premise
<OPTION value=&#39;0&#39;>Off-Premise
</select>

but I can&#39;t figure out how to do this in ASP-DB.

Thanks for any help,
Mike Shroyer

[Mike Shroyer]

Mark,
That worked perfect!! Thanks.

The obvious next question is:

What if the databse field is not a bit (MSSQL 7) field but a text or varchar. It just so happened that the field in question was a varchar useing 0 or 1 and had an easy conversion to a bit field.

Thanks,
Mike Shroyer

------------
Mark at 10/2/00 11:19:16 AM

Mike,
Use the dbBoolText property (all 4 parameters). See Example 20 at:
http://www.aspdb.com/v2

Also, see the doc at:
http://www.aspdb.com/docs/aspdbman.htm#dbBoolText

That should do it.
Mark.


------------
Mike Shroyer at 10/2/00 10:24:37 AM

Hello All,
I am using the dbEditDropFlds parameter for the first time and hope I have what will turn out to be a simple question.

The database field (MSSQL Server) has values of 0 or 1. I want to present to the user as &#34;On-Premise&#34; or &#34;Off-Premise&#34;. I understand how to do this in HTML with:
<select>
<OPTION value=&#39;1&#39;>On-Premise
<OPTION value=&#39;0&#39;>Off-Premise
</select>

but I can&#39;t figure out how to do this in ASP-DB.

Thanks for any help,
Mike Shroyer

[Mark]

Mike,

You can use dbDisplayLookupList or code you own list using dbFilterDropFlds. See Example APP 13 at http://www.aspdb.com/V2

Bottom line is: ASP-db is VERY FLEXIBLE!

Mark.

------------
Mike Shroyer at 10/2/00 1:36:49 PM

Mark,
That worked perfect!! Thanks.

The obvious next question is:

What if the databse field is not a bit (MSSQL 7) field but a text or varchar. It just so happened that the field in question was a varchar useing 0 or 1 and had an easy conversion to a bit field.

Thanks,
Mike Shroyer

------------
Mark at 10/2/00 11:19:16 AM

Mike,
Use the dbBoolText property (all 4 parameters). See Example 20 at:
http://www.aspdb.com/v2

Also, see the doc at:
http://www.aspdb.com/docs/aspdbman.htm#dbBoolText

That should do it.
Mark.


------------
Mike Shroyer at 10/2/00 10:24:37 AM

Hello All,
I am using the dbEditDropFlds parameter for the first time and hope I have what will turn out to be a simple question.

The database field (MSSQL Server) has values of 0 or 1. I want to present to the user as &#34;On-Premise&#34; or &#34;Off-Premise&#34;. I understand how to do this in HTML with:
<select>
<OPTION value=&#39;1&#39;>On-Premise
<OPTION value=&#39;0&#39;>Off-Premise
</select>

but I can&#39;t figure out how to do this in ASP-DB.

Thanks for any help,
Mike Shroyer