Using MySQL db- Need to autonumber ID field with Frontrpage?

[Sam White]

Hi, I just set up a MySQL server for storing information. I created a
website and made two pages, one to view data and one to input data. The
data viewing page works just fine. The input page is another issue. For
the ID field I have to put in a number manually or no data is entered.
Of course that means I have to remember what the last ID number was.

Yet when I enter data using Open Office Base I do not need to enter
anything in the ID field as that is set to auto number.

The pages were made using Frontpage which could be the issue. I thought
if the db was receiving data in the other fields it would auto number
the ID field. Is there a way I can get this set so I do not have to
bother with an ID field on the form page?

 

[Thomas A. Rowe]

The MySQL database needs to be set to automatically add the Record ID for each record added. To
learn how to do this, you will need to visit a site MySQL resource site.

FP will not do this for you when working with any database. Access and MS SQL server will
automatically add a ID number for each record if set to do so, this is not something is done by FP.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Sam White]

I know that autonumbering is a function of the db. The table was set to
auto number. The problem is of course the form made with Frontpage, when
submitting the data for some reason does this in a way that the MySQL
auto number of the ID field no longer works.

Another issue I seem to find now is that any field in the db marked as
text (Text, LONGTEXT, & MEDIUMTEXT) are not accepting input. This is not
the case for any field for numbers. Does special encoding need to be
made to work with MySQL?

 

[Thomas A. Rowe]

The form had no impact on the database adding a autonumber to a record, unless you have a field on
the form that is the same name at the autonumber field in the database, which you shouldn't.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================