There are two things you need to watch when you populate HTML form fields with existing data from a VFP table:
- VFP tables do not have varchar fields, so they pad the data with spaces up to the length of the field. You should use the TRIM function before populating your HTML forms with these values.
- You should also make sure to set the MAXLENGTH clause of your INPUT tags to match the length of the field in your VFP table. If you include a MAXLENGTH clause, then the SIZE clause will only affect the displayed size of the HTML form field -- not the number of characters you can type in it.
FoxWeb Support Team support@foxweb.com email |
Sent by Lew En Lai on 06/18/2002 12:02:37 PM:
Hi
I have currently installed foxweb 1.29c with VFP 6.0 running on IIS 4.0.
I am currently encountering a problem with web forms. Upon capturing the
data from the DBF and to be displayed back into the form into each of the
text fields accordingly for editting via MRG file, I notice that If I were to
add more text on that field, it did not allow me to do so and the cursor just stop
right at the end of the original text on the field. Is there a way to overcome this
problem? I did not trim any of the fields/variables before displaying it on the form. The
forms were created in Frontpage 98.
Thanks