filemaker hangs when doing php odbc number insert

[VoidState]

Hi

I have been wrestling with this problem for days. I have written a php page which adds data from an html form to filemaker pro 5.5

There are 5 fields in the db. Four text fields, 1 number field.

It works ok provided none of the text fields contain more than 34 characters. However, if I change the number field to a text field, any number of characters can be entered into the text fields.

I have searched everywhere I can think of: in forums like this, the filemaker site and elsewhere on the web for even a mention of why this might be. Can anyone help? I have successfully used php and odbc to connect to filemaker several times before without any problem, but this has me stumped.

examples:

this works (text field has over 34 characters, but number field changed to text field): INSERT INTO myDb (recordtype, dlname, dltype, dldescrip, dlaccesslevel) VALUES ('dl', 'qwert', 'qwert', 'qwert qwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert', '1')

and so does this (no text field over 34 characters and number field left as number field): INSERT INTO myDb (recordtype, dlname, dltype, dldescrip, dlaccesslevel) VALUES ('dl', 'qwert', 'qwert', 'qwert' , 1)

but this doesn't (a text field is over 34 characters and the number field is left a s a number field): INSERT INTO myDb (recordtype, dlname, dltype, dldescrip, dlaccesslevel) VALUES ('dl', '1111', '1111', 'qwertqwert qwertqwert qwertqwertqwertqwert qwertqwertqwertqwert qwertqwert qwertqwert qwertqwert qwertqwert qwertqwert', 1)

Any suggestions would be really appreciated.

Fergus

[VoidState]

Problem solved. Turns out the ODBC driver was corrupted. I removed all DSNs, uninstalled and then reinstalled Filemaker. What a waste of 3 full 8 hour days... God I hate computers sometimes! :