Results 1 to 6 of 6

Thread: Still can't get custom form to work!! Please help!

  1. 05-25-2001, 09:58 AM #1
    Rich Paino Guest

    Still can't get custom form to work!! Please help!

    THIS SHORT BIT OF CODE:

    <%
    Set MyDb = Server.CreateObject(&#34;ASPDB.EP&#34
    MyDb.dbmdb=Server.MapPath(&#34;PMQA.mdb&#34
    MyDb.dbStartup = &#34;EditAdd&#34;
    MyDb.dbUnit=333449
    MyDb.dbMode=&#34;Form&#34;
    MyDb.dbColor = &#34;#FFFACD,Black,E6E6FA,Black&#34;
    MyDb.dbEditParams = &#34;(;,)TableName=[Customer Info], BookMarkFlds=0, UpdateIcon=True, EditIconsLayout=Left&#34;
    MyDb.dbEditFlds = &#34;OrderNo, QACheckStatus, Checkedby&#34;
    MyDb.dbEditAddTemplate = &#34;AddForm2.htm&#34;
    MyDb.dbNavigationItem = &#34;Top,Prev,Next,Bottom,Reload,Update,Add&#34 ;
    MyDb.dbSQL = &#34;Select * from [Customer Info]&#34;
    MyDb.dbEditAddSQL = &#34;INSERT INTO [Customer Info] (OrderNo, QACheckStatus, Checkedby ) VALUES (&#39;#OrderNo&#39;, &#39;#QACheckStatus#&#39;, &#39;#Checkedby#&#39&#34;
    MyDb.aspDBEP
    Response.Write (&#34;<br><br><center><a href=&#39;http://scl4apweb05/rich_paino/SelectIDC.htm&#39;>Return to the Main Screen</a>&#34
    %>

    DOESN&#39;T WANT TO WORK WITH THE FORM CODE BELOW. I JUST GET A BLANK SCREEN. IF I COMMENT OUT THE &#34;dbEditAddTemplate&#34; line I GET THE STANDARD INPUT FORM JUST FINE. PLEASE HELP!

    <body>
    <body>
    [[FormTag]]
    <BR><BR>Order #:
    <INPUT TYPE=TEXT NAME=&#34;OrderNo&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;QACheckStatus&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;Checkedby&#34; VALUE=&#39; &#39;><br><br>
    [[AddSubmitButton]]
    [[ReturnButton]]<BR><BR>
    [[/FormTag]]
    </body>
    Reply With Quote Reply With Quote
  2. 05-25-2001, 12:35 PM #2
    Rich Paino Guest

    Still can't get custom form to work!! Please help! (reply)

    I&#39;ve tried it with just the filename and it still doesn&#39;t work.


    ------------
    Nancy Steinmann at 5/25/01 1:33:36 PM

    On the example I saw, you have to put Server.MapPath in front of your template file name.
    Nancy
    Reply With Quote Reply With Quote
  3. 05-25-2001, 12:35 PM #3
    Mark Guest

    Still can't get custom form to work!! Please help! (reply)

    ASP-db GOLD is Required for Templates. See:
    http://www.usintertech.com/matrix.shtm
    Mark



    ------------
    Nancy Steinmann at 5/25/01 1:33:36 PM

    On the example I saw, you have to put Server.MapPath in front of your template file name.
    Nancy
    Reply With Quote Reply With Quote
  4. 05-25-2001, 05:56 PM #4
    Frank Kwong Guest

    Still can't get custom form to work!! Please help! (reply)

    get rid of the &#34;#&#34; and see what happens.

    FK


    ------------
    Rich Paino at 5/25/01 10:58:26 AM

    THIS SHORT BIT OF CODE:

    <%
    Set MyDb = Server.CreateObject(&#34;ASPDB.EP&#34
    MyDb.dbmdb=Server.MapPath(&#34;PMQA.mdb&#34
    MyDb.dbStartup = &#34;EditAdd&#34;
    MyDb.dbUnit=333449
    MyDb.dbMode=&#34;Form&#34;
    MyDb.dbColor = &#34;#FFFACD,Black,E6E6FA,Black&#34;
    MyDb.dbEditParams = &#34;(;,)TableName=[Customer Info], BookMarkFlds=0, UpdateIcon=True, EditIconsLayout=Left&#34;
    MyDb.dbEditFlds = &#34;OrderNo, QACheckStatus, Checkedby&#34;
    MyDb.dbEditAddTemplate = &#34;AddForm2.htm&#34;
    MyDb.dbNavigationItem = &#34;Top,Prev,Next,Bottom,Reload,Update,Add&#34 ;
    MyDb.dbSQL = &#34;Select * from [Customer Info]&#34;
    MyDb.dbEditAddSQL = &#34;INSERT INTO [Customer Info] (OrderNo, QACheckStatus, Checkedby ) VALUES (&#39;#OrderNo&#39;, &#39;#QACheckStatus#&#39;, &#39;#Checkedby#&#39&#34;
    MyDb.aspDBEP
    Response.Write (&#34;<br><br><center><a href=&#39;http://scl4apweb05/rich_paino/SelectIDC.htm&#39;>Return to the Main Screen</a>&#34
    %>

    DOESN&#39;T WANT TO WORK WITH THE FORM CODE BELOW. I JUST GET A BLANK SCREEN. IF I COMMENT OUT THE &#34;dbEditAddTemplate&#34; line I GET THE STANDARD INPUT FORM JUST FINE. PLEASE HELP!

    <body>
    <body>
    [[FormTag]]
    <BR><BR>Order #:
    <INPUT TYPE=TEXT NAME=&#34;OrderNo&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;QACheckStatus&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;Checkedby&#34; VALUE=&#39; &#39;><br><br>
    [[AddSubmitButton]]
    [[ReturnButton]]<BR><BR>
    [[/FormTag]]
    </body>
    Reply With Quote Reply With Quote
  5. 05-29-2001, 09:30 AM #5
    Guest

    Still can't get custom form to work!! Please help! (reply)

    Frank,
    I took the &#34;#&#34; out of the values segment of the Insert statement but it diddn&#39;t allow the template to work. I&#39;ve been told that we need the gold version of ASP-db in order to use templates.


    ------------
    Frank Kwong at 5/25/01 6:56:08 PM

    get rid of the &#34;#&#34; and see what happens.

    FK


    ------------
    Rich Paino at 5/25/01 10:58:26 AM

    THIS SHORT BIT OF CODE:

    <%
    Set MyDb = Server.CreateObject(&#34;ASPDB.EP&#34
    MyDb.dbmdb=Server.MapPath(&#34;PMQA.mdb&#34
    MyDb.dbStartup = &#34;EditAdd&#34;
    MyDb.dbUnit=333449
    MyDb.dbMode=&#34;Form&#34;
    MyDb.dbColor = &#34;#FFFACD,Black,E6E6FA,Black&#34;
    MyDb.dbEditParams = &#34;(;,)TableName=[Customer Info], BookMarkFlds=0, UpdateIcon=True, EditIconsLayout=Left&#34;
    MyDb.dbEditFlds = &#34;OrderNo, QACheckStatus, Checkedby&#34;
    MyDb.dbEditAddTemplate = &#34;AddForm2.htm&#34;
    MyDb.dbNavigationItem = &#34;Top,Prev,Next,Bottom,Reload,Update,Add&#34 ;
    MyDb.dbSQL = &#34;Select * from [Customer Info]&#34;
    MyDb.dbEditAddSQL = &#34;INSERT INTO [Customer Info] (OrderNo, QACheckStatus, Checkedby ) VALUES (&#39;#OrderNo&#39;, &#39;#QACheckStatus#&#39;, &#39;#Checkedby#&#39&#34;
    MyDb.aspDBEP
    Response.Write (&#34;<br><br><center><a href=&#39;http://scl4apweb05/rich_paino/SelectIDC.htm&#39;>Return to the Main Screen</a>&#34
    %>

    DOESN&#39;T WANT TO WORK WITH THE FORM CODE BELOW. I JUST GET A BLANK SCREEN. IF I COMMENT OUT THE &#34;dbEditAddTemplate&#34; line I GET THE STANDARD INPUT FORM JUST FINE. PLEASE HELP!

    <body>
    <body>
    [[FormTag]]
    <BR><BR>Order #:
    <INPUT TYPE=TEXT NAME=&#34;OrderNo&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;QACheckStatus&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;Checkedby&#34; VALUE=&#39; &#39;><br><br>
    [[AddSubmitButton]]
    [[ReturnButton]]<BR><BR>
    [[/FormTag]]
    </body>
    Reply With Quote Reply With Quote
  6. 05-30-2001, 07:47 AM #6
    Frank Kwong Guest

    Still can't get custom form to work!! Please help! (reply)

    Yes, that&#39;s it.....



    ------------
    at 5/29/01 10:30:23 AM

    Frank,
    I took the &#34;#&#34; out of the values segment of the Insert statement but it diddn&#39;t allow the template to work. I&#39;ve been told that we need the gold version of ASP-db in order to use templates.


    ------------
    Frank Kwong at 5/25/01 6:56:08 PM

    get rid of the &#34;#&#34; and see what happens.

    FK


    ------------
    Rich Paino at 5/25/01 10:58:26 AM

    THIS SHORT BIT OF CODE:

    <%
    Set MyDb = Server.CreateObject(&#34;ASPDB.EP&#34
    MyDb.dbmdb=Server.MapPath(&#34;PMQA.mdb&#34
    MyDb.dbStartup = &#34;EditAdd&#34;
    MyDb.dbUnit=333449
    MyDb.dbMode=&#34;Form&#34;
    MyDb.dbColor = &#34;#FFFACD,Black,E6E6FA,Black&#34;
    MyDb.dbEditParams = &#34;(;,)TableName=[Customer Info], BookMarkFlds=0, UpdateIcon=True, EditIconsLayout=Left&#34;
    MyDb.dbEditFlds = &#34;OrderNo, QACheckStatus, Checkedby&#34;
    MyDb.dbEditAddTemplate = &#34;AddForm2.htm&#34;
    MyDb.dbNavigationItem = &#34;Top,Prev,Next,Bottom,Reload,Update,Add&#34 ;
    MyDb.dbSQL = &#34;Select * from [Customer Info]&#34;
    MyDb.dbEditAddSQL = &#34;INSERT INTO [Customer Info] (OrderNo, QACheckStatus, Checkedby ) VALUES (&#39;#OrderNo&#39;, &#39;#QACheckStatus#&#39;, &#39;#Checkedby#&#39&#34;
    MyDb.aspDBEP
    Response.Write (&#34;<br><br><center><a href=&#39;http://scl4apweb05/rich_paino/SelectIDC.htm&#39;>Return to the Main Screen</a>&#34
    %>

    DOESN&#39;T WANT TO WORK WITH THE FORM CODE BELOW. I JUST GET A BLANK SCREEN. IF I COMMENT OUT THE &#34;dbEditAddTemplate&#34; line I GET THE STANDARD INPUT FORM JUST FINE. PLEASE HELP!

    <body>
    <body>
    [[FormTag]]
    <BR><BR>Order #:
    <INPUT TYPE=TEXT NAME=&#34;OrderNo&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;QACheckStatus&#34; VALUE=&#39; &#39;><br><br>
    <INPUT TYPE=TEXT NAME=&#34;Checkedby&#34; VALUE=&#39; &#39;><br><br>
    [[AddSubmitButton]]
    [[ReturnButton]]<BR><BR>
    [[/FormTag]]
    </body>
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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