Text disappearing from text fields...

Hello,

I'm currently working with a MySQL backend and is trying to use
FileMaker 9's Web Form capabilities as a front end. From FileMaker
Pro's interface, I have used the ODBC to connect my FileMaker database
to my MySQL tables. The schema and existing data records loads into
FileMaker without a problem.

However, when I'm trying to insert text (VARCHAR and TEXT) data from
FileMaker, it blanks out and ends up only inserting a blank into
MySQL. Default values set on the MySQL side only take effect if I left
that field blank on FileMaker when I create a new record. Default
field values set on FileMaker also blanks out upon committing. I could
insert fine directly into MySQL via phpMyAdmin. Inserting numerical
values from FileMaker also commits fine. It's just text-based stuff
from FileMaker...

It doesn't seem like anyone else has had this type of problem
before...could I just be overlooking something that is very simple?
Advices on how to approach this issue is greatly appreciated.

Thank you.

Re: Text disappearing from text fields...

On Sep 7, 2:30 pm, "jlin...@gmail.com" wrote:
> Hello,
>
> I'm currently working with a MySQL backend and is trying to use
> FileMaker 9's Web Form capabilities as a front end. From FileMaker
> Pro's interface, I have used the ODBC to connect my FileMaker database
> to my MySQL tables. The schema and existing data records loads into
> FileMaker without a problem.
>
> However, when I'm trying to insert text (VARCHAR and TEXT) data from
> FileMaker, it blanks out and ends up only inserting a blank into
> MySQL. Default values set on the MySQL side only take effect if I left
> that field blank on FileMaker when I create a new record. Default
> field values set on FileMaker also blanks out upon committing. I could
> insert fine directly into MySQL via phpMyAdmin. Inserting numerical
> values from FileMaker also commits fine. It's just text-based stuff
> from FileMaker...
>
> It doesn't seem like anyone else has had this type of problem
> before...could I just be overlooking something that is very simple?
> Advices on how to approach this issue is greatly appreciated.
>
> Thank you.

It would appear that the driver that was provided by MySQL (MySQL
Connector/ODBC 3.51 was what I used) is not supported by FileMaker.
Upon installing the Actual ODBC driver, which is supported by
FileMaker, the problem disappeared.