-
Yes No Boolean Text in Exported Variables
Dear Forum Members,
ASPdbPro Prior to version 6.3027.
I am using dbBoolText to display Yes and No for several fields. However, I had to create a custom display page using export variables (dbExportVariables) and it only shows True and False.
I have tried changing the boolean format to Yes/No within the Access database, but this does not work either.
Any ideas how I can export Yes/No? I have about 25 yes/no fields to work with.
Thanks in advance - Ted
-
Yes No Boolean Text in Exported Variables (reply)
Try this ->
<!-- #include File=..ASPdb.Inc -->
<% Response.Buffer=True %>
<%
Set X= Server.CreateObject("ASP.DB"
X.dbUnit = "999"
X.dbMode = "Grid"
X.dbBoolText = "Yes,No,True,False"
X.dbExportFlds = "Discontinued"
X.dbDSN = "DSN=NWIND"
X.dbOptions = "ExportMagic=True"
X.dbSQL = "SELECT ProductID,Discontinued FROM Products"
X.ASPdb
Response.write("Export field: Discontinued = " & session("ASPDB_999_Discontinued")
%>
------------
Ted Moore at 1/8/01 2:47:04 PM
Dear Forum Members,
ASPdbPro Prior to version 6.3027.
I am using dbBoolText to display Yes and No for several fields. However, I had to create a custom display page using export variables (dbExportVariables) and it only shows True and False.
I have tried changing the boolean format to Yes/No within the Access database, but this does not work either.
Any ideas how I can export Yes/No? I have about 25 yes/no fields to work with.
Thanks in advance - Ted
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
|
|