dbExportFlds

Define field names or number to be exported to session variables for subsequent processing. The format of the session variable is session("ASPdb_Unit_FieldName"). Optionally, if the field item is wrapped by "()" then the RAW value will be exported and dbOptions="ExportMagic=True" condition will be override for the field. When export is RAW the export Date value will be convertd by DateFormat but when export is Magic then exported Date value will not be processed by DateFormat. Use dbOptions="ExportBlank=BlankText" to control blank exports.

Property Syntax

Obj.dbExportFlds="FieldNameNumber1,(FieldNameNumber2)...repeat"

Parameters

Parameters

Default Value

Description

FieldNameNumber No Export As always, unless specified, Field name and number can be mixed.

Example

<%
Set X=Server.CreateObject("Asp.DB")
X.dbQuickProps="115;NWIND;employees;Form"
X.dbMemoTextSize=20
X.dbNavigationItem="prev,next"
X.dbFormDisplayFlds="0,1,2,3,Notes"
X.dbExportFlds="0,1,(2),notes"
X.dbOptions="ExportMagic=true"
X.dbMagicCell="0,,ID #0#"
X.ASPDB

response.write("<B>Note that Memo are always exported in FULL...</B><BR>")
response.write("* Export - Notes=" & session("aspdb_115_Notes") & "<BR>")
response.write("<B>Note that ExportMagic=true and now exported values are converted values including the HTML Tags except field (2) which exports in RAW.</B><BR>")
response.write("* Export - Last Name=" & session("aspdb_115_LastName") & "<BR>")
response.write("* Export - First Name=" & session("aspdb_115_FirstName") & "<BR>")
response.write("* Export - ID=" & session("aspdb_115_employeeID") & "<BR>")
%>

Output


Notes