Data not going into Database

[Steve Grosz]

I've created a simple database to store contact info. Put it in the FPDB
folder within FP2003. When I'm working with my form, verified that the
database connection was good, could see all the fields in the database, and
assigned the form fields to match up with the fields in the database.

I then posted it to my web server. When I enter test data into the form,
and press submit, I get the confirmation form. Problem comes along when I
open up the database. There's nothing in it!!!

If you'd like to see the form, here's the link:
http://www.scootervilleusa.com/MailList.asp

Any assistance would be appreciated, this is quite frustrating!!

Thanks,
Steve

 

[Jim Buyens]

Make sure that none of your database field names contain spaces or special
characters, and that none of them are reserved words (such as "date" or
"timestamp").

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

 

[Steve Grosz]

They're not. And I've granted access for all users for the database file
itself, and for the folder the db is in.

Steve

 

[MD WebsUnlimited.com]

Hi Steve,

When you publish are you stripping the webbot code under optimize HTML?

 

[Steve Grosz]

Mike,

No, I'm not doing anything with the optimize HTML options.

Steve

 

[MD WebsUnlimited.com]

You may not be doing anything but what are they set to?

 

[Steve Grosz]

In my FP2003, when I go into the 'remote web site' and look at the 'optimize
published html' option, nothing is checked or selected.

Steve