Submission form

[jay]

I created a submission form using the database interface
wizard to add records to an Access database. When I use
the form and submit a new record it looks like it
processess the data and adds the record to the database.
When I review the data posted to the database only the 1st
4 fields are added to the database and the rest is
ignored. Does anyone have any ideas about this ?

Thanks

Jay Moore
(e-mail address removed)

 

[Jim Buyens]

-----Original Message-----

I created a submission form using the database interface
wizard to add records to an Access database. When I use
the form and submit a new record it looks like it
processess the data and adds the record to the database.
When I review the data posted to the database only the
1st 4 fields are added to the database and the rest is
ignored. Does anyone have any ideas about this ?

Try applying this procedure to the page that's supposed to
add the records:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=35

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

Jim,

I followed your tip, however it did not yield any
messages. But when I rechecked the results, submission,
and database editor asp forms I notice that one of the
fields is missing from the top frame in the datbase
editor. This field is included on the results page, and
the submit form. It is also included on database region on
the bottom frame of the editor. The field is is defined as
follows
Results page - <!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,covertest,Cover,month,year,number,Title,Pub
lisher,Condition,NM Quantities,NM price,NM Cost,NM Selling
price,VF Quantities,VF price,VF Cost,VF Selling price,F
Quantities,F price,F Cost,F Selling price,VG Quantities,VG
price,VG Cost,VG Selling price,G Quantities,G price,G
Cost,G Selling price,Auction,Opening Bid,Auction Sales
Price,shipping cost,Total Issues Sold,Total Sales for
Issues,Total Sales for Shipping,Paypal,In Stock" s-
column="Paypal" b-tableformat="TRUE" b-hashtml="FALSE" b-
makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Paypal&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Paypal")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14434" -->

Submit form - &nbsp;<!--webbot bot="Validation" s-display-
name="Paypal" s-data-type="String" b-value-
required="False" i-maximum-length="0" --><textarea
rows="10" name="Paypal" cols="64"></textarea><br>

editor(bottom frame) <!--webbot bot="DatabaseResultColumn"
s-
columnnames="ID,covertest,Cover,month,year,number,Title,Pub
lisher,Condition,NM Quantities,NM price,NM Cost,NM Selling
price,VF Quantities,VF price,VF Cost,VF Selling price,F
Quantities,F price,F Cost,F Selling price,VG Quantities,VG
price,VG Cost,VG Selling price,G Quantities,G price,G
Cost,G Selling price,Auction,Opening Bid,Auction Sales
Price,shipping cost,Total Issues Sold,Total Sales for
Issues,Total Sales for Shipping,Paypal,In Stock" s-
column="Paypal" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside startspan b-makelink b-MenuFormat
preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Paypal&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%
=FP_FieldVal(fp_rs,"Paypal")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14434" --

</td>

When I posted the test the data appears to be posting to
the wrong fields

Any help would be appreciated

Jay