-
dbOptions - CellFontTag Revisited
Dear Forum Members,
I know this topic has been discussed ad nauseum, but I just can't get the CellFontTag and HeaderFontTag in dbOptions to work. I am aware of the dbColor conflict and have switched to a standard color setup. I have tested the page on both my local system and on the server. I have tried every variation of the command line format that I can find in the FAQs, ASPdb Manual, and in this forum, but it has no effect.
I have simplified the page and it is posted below. It is a simple questionnaire form. If you can shed any light on the topic, I would be very appreciative.
Thanks,
Ted
<%@ LANGUAGE="VBSCRIPT" %>
<%Response.Buffer=true %>
<%
if Request("aspDBEditBut_23" = "Exit to Home Page" then Response.Redirect("default.htm"
Set MyDb = Server.CreateObject("ASPdb.Pro"
MyDB.dbUnit=23
Mydb.dbDSN = "tti"
MyDb.dbDBtype="Access"
MyDb.dbRecordCount=500
MyDb.dbOptions= "(;|)CellFontTag=Face=""Arial"" ; Size=2 | HeaderFontTag=Face=""Arial"" Size=2"
MyDb.dbColor="4"
'MyDb.DBColor="Navy,navy,silver,cyan 4;
MyDb.dbGridTableTag="border=1 cellspacing=1 cellpadding=1 width=90%"
MyDb.dbFormTableTag="border=1 cellspacing=1 cellpadding=1 width=90%"
MyDb.dbStartup="editadd"
MyDb.dbSQL="SELECT * FROM persons ORDER by last"
MyDb.DbMoDE="both"
MyDb.dbGridInc=30
MyDb.dbFormCol="2,auto"
MyDb.dbButtonAnchor=false
MyDb.dbBoolText="yes,no"
MyDb.dbgridDisplayFlds = -1
MyDb.dbNavigation = "both"
MyDb.dbEditFlds = "1,2,3,4,5,6,7,8,9,10"
Mydb.dbEditParams = "EditTable=persons,TableName=persons,BookMarkF lds=0,TableTag=Border=2,RecordScope=single,SingleQ uote=2,InputSize=10x40,AddNewText=Click to Submit Form,ReturnText=Click to Leave Form,ResetText=Click to Clear Form,ActionText=To Exit Use Navigation Below"
MyDb.dbImageDir="images/aspdb/"
Mydb.dbNavigation="both"
Mydb.dbNavigationItem="Next, Prev, top, bottom, Filter, add, update, delete, download"
Mydb.dbNavigationIcon="std"
MyDb.ASPdbPro
if Request("aspDBEditBut_23" = "Click To Submit Form" then
Response.Redirect("con_emaillist.asp"
end if
%>
-
dbOptions - CellFontTag Revisited (reply)
Hi Ted,
It works for us. See Example D55: http://www.aspdb.com/apps/mh-black.asp
Can we have your URL so we can see it run on your system?
Keep in mind that CellFontTag, etc doesn't apply to an INPUT FORM, just
the Grid and Form DISPLAYS.
Mark.
------------
Ted Moore at 12/14/99 3:19:43 PM
Dear Forum Members,
I know this topic has been discussed ad nauseum, but I just can't get the CellFontTag and HeaderFontTag in dbOptions to work. I am aware of the dbColor conflict and have switched to a standard color setup. I have tested the page on both my local system and on the server. I have tried every variation of the command line format that I can find in the FAQs, ASPdb Manual, and in this forum, but it has no effect.
I have simplified the page and it is posted below. It is a simple questionnaire form. If you can shed any light on the topic, I would be very appreciative.
Thanks,
Ted
<%@ LANGUAGE="VBSCRIPT" %>
<%Response.Buffer=true %>
<%
if Request("aspDBEditBut_23" = "Exit to Home Page" then Response.Redirect("default.htm"
Set MyDb = Server.CreateObject("ASPdb.Pro"
MyDB.dbUnit=23
Mydb.dbDSN = "tti"
MyDb.dbDBtype="Access"
MyDb.dbRecordCount=500
MyDb.dbOptions= "(;|)CellFontTag=Face=""Arial"" ; Size=2 | HeaderFontTag=Face=""Arial"" Size=2"
MyDb.dbColor="4"
'MyDb.DBColor="Navy,navy,silver,cyan 4;
MyDb.dbGridTableTag="border=1 cellspacing=1 cellpadding=1 width=90%"
MyDb.dbFormTableTag="border=1 cellspacing=1 cellpadding=1 width=90%"
MyDb.dbStartup="editadd"
MyDb.dbSQL="SELECT * FROM persons ORDER by last"
MyDb.DbMoDE="both"
MyDb.dbGridInc=30
MyDb.dbFormCol="2,auto"
MyDb.dbButtonAnchor=false
MyDb.dbBoolText="yes,no"
MyDb.dbgridDisplayFlds = -1
MyDb.dbNavigation = "both"
MyDb.dbEditFlds = "1,2,3,4,5,6,7,8,9,10"
Mydb.dbEditParams = "EditTable=persons,TableName=persons,BookMarkF lds=0,TableTag=Border=2,RecordScope=single,SingleQ uote=2,InputSize=10x40,AddNewText=Click to Submit Form,ReturnText=Click to Leave Form,ResetText=Click to Clear Form,ActionText=To Exit Use Navigation Below"
MyDb.dbImageDir="images/aspdb/"
Mydb.dbNavigation="both"
Mydb.dbNavigationItem="Next, Prev, top, bottom, Filter, add, update, delete, download"
Mydb.dbNavigationIcon="std"
MyDb.ASPdbPro
if Request("aspDBEditBut_23" = "Click To Submit Form" then
Response.Redirect("con_emaillist.asp"
end if
%>
-
dbOptions - CellFontTag Revisited (reply)
Thanks Mark,
Doh! Didn't realize it doesn't work with INPUT forms. OK, how do I set the font on input forms?
The input form I am working with is at www.unilights.com/register.asp
Thanks/Ted
------------
Mark at 12/14/99 3:40:45 PM
Hi Ted,
It works for us. See Example D55: http://www.aspdb.com/apps/mh-black.asp
Can we have your URL so we can see it run on your system?
Keep in mind that CellFontTag, etc doesn't apply to an INPUT FORM, just
the Grid and Form DISPLAYS.
Mark.
------------
Ted Moore at 12/14/99 3:19:43 PM
Dear Forum Members,
I know this topic has been discussed ad nauseum, but I just can't get the CellFontTag and HeaderFontTag in dbOptions to work. I am aware of the dbColor conflict and have switched to a standard color setup. I have tested the page on both my local system and on the server. I have tried every variation of the command line format that I can find in the FAQs, ASPdb Manual, and in this forum, but it has no effect.
I have simplified the page and it is posted below. It is a simple questionnaire form. If you can shed any light on the topic, I would be very appreciative.
Thanks,
Ted
<%@ LANGUAGE="VBSCRIPT" %>
<%Response.Buffer=true %>
<%
if Request("aspDBEditBut_23" = "Exit to Home Page" then Response.Redirect("default.htm"
Set MyDb = Server.CreateObject("ASPdb.Pro"
MyDB.dbUnit=23
Mydb.dbDSN = "tti"
MyDb.dbDBtype="Access"
MyDb.dbRecordCount=500
MyDb.dbOptions= "(;|)CellFontTag=Face=""Arial"" ; Size=2 | HeaderFontTag=Face=""Arial"" Size=2"
MyDb.dbColor="4"
'MyDb.DBColor="Navy,navy,silver,cyan 4;
MyDb.dbGridTableTag="border=1 cellspacing=1 cellpadding=1 width=90%"
MyDb.dbFormTableTag="border=1 cellspacing=1 cellpadding=1 width=90%"
MyDb.dbStartup="editadd"
MyDb.dbSQL="SELECT * FROM persons ORDER by last"
MyDb.DbMoDE="both"
MyDb.dbGridInc=30
MyDb.dbFormCol="2,auto"
MyDb.dbButtonAnchor=false
MyDb.dbBoolText="yes,no"
MyDb.dbgridDisplayFlds = -1
MyDb.dbNavigation = "both"
MyDb.dbEditFlds = "1,2,3,4,5,6,7,8,9,10"
Mydb.dbEditParams = "EditTable=persons,TableName=persons,BookMarkF lds=0,TableTag=Border=2,RecordScope=single,SingleQ uote=2,InputSize=10x40,AddNewText=Click to Submit Form,ReturnText=Click to Leave Form,ResetText=Click to Clear Form,ActionText=To Exit Use Navigation Below"
MyDb.dbImageDir="images/aspdb/"
Mydb.dbNavigation="both"
Mydb.dbNavigationItem="Next, Prev, top, bottom, Filter, add, update, delete, download"
Mydb.dbNavigationIcon="std"
MyDb.ASPdbPro
if Request("aspDBEditBut_23" = "Click To Submit Form" then
Response.Redirect("con_emaillist.asp"
end if
%>
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
|
|