front page 2000: METHOD.GET does not carry all of the text from the current form to the next where a

[Bill]

I am using a METHOD.GET to collect the updated and newly added data in the
form from the update data form to the next page where a SQL update statement
updates that row in the database. The problem is that when there is a lot
of data in the form fields, the SUBMIT button will not do anything, until I
reduce the data in the form fields to a certain length. If I take that same
data in all the form fields and do an insert into SQL, the submit button
works fine, it passes the data to the database. It is only when my form has
a METHOD.GET to collect the data and pass it to another SQL update page, is
where the SUBMIT button dies. Has anyone heard of this before as a FP2000
issue or is there a max char limitation using this function?

Thanks!

 

[Jim Buyens]

The GET method appends the form field data to the URL,
and this can indeed result in truncation. To get around
that, try using method="POST", which transmits the form
data in the body of the request.

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)
|/---------------------------------------------------
*----------------------------------------------------