wcakey

I have not done any FMP7/8 IWP sites to date, but I am contemplating replacing an existing CDML site with an IWP site. However, there is one functionality that needs to be retained, but which I do not know if it is possible to do with IWP. Unfortunately, it is not a situation where I can just whip up a test file and try it out, hence my coming to the IWP experts here. The current CDML site registers people for classes, and then, as a final step, pulls the sales data from the database and posts it to VeriSign, via a simple web form, to complete the payment process. Is it possible to mimic such behavior using IWP? It seems it should be possible, to create a clickable URL on an IWP layout that could forward the user to the VeriSign website and also send along the appropriate sales data from the database or maybe using OpenURL. If this is possible, would the data have to be sent as a GET, or is there a way the data could be sent as a POST? Thanks in advance for any help/advice received. William

I can't get this to work for me. I can explode the field using explode("n", $Field) and then use in_array() to display the checkboxes, with the proper checkboxes checked. OK, so far. But, if I then subsequently use implode("n", $Field) before submitting it back to the database, I get a PHP bad argument warning for the implode() function and $Field in the database becomes blank. If I do not use Field[] to collect the checkbox values and do not use implode, then only the last checked value gets submitted to the database So, what am I doing wrong? It seems it should work, but it doesn't. Thanks William

Hi All, I have been getting reported failures of a simple registration form that creates a new record in a FM 7 database using FX.php. The reported error is error code 958 which has the description of "parameter missing from query". The problem is, I have never been able to make the registration process fail, so I doubt that there is truly a missing parameter. The registration process works fine for me, whether I fill in all fields on the registration form or leave it blank -- a record is always written to the database. To get a bit more information, I set up the confirmation.php page to send me an email message with all of the user posted data if the query returns a non-zero error code. One thing I have noted so far is that all of the reported failures have had strange characters in the posted data. All except one of the failed registrations has come from international registrants and the one from the USA registrant also included strange characters. The only thing I do to the posted data is to use stripslashes() and trim() to clean it up. Is there something else I should routinely be doing with the posted data? I did note that the header of the application form had a setting of chartset=iso-8859-1 and I have since changed that to charset=utf-8. Your thoughts would be appreciated. Thanks William

Martin, Thanks very much. I'll check it out. If I can't make that work, I'll probably resort to using FX.php. William

I understand how to add a record to a FM7 database using a URL and XML and have successfully done so. What I want to be able to do is create a record in a FM7 database without specifying a response page (sort of a "silent post"), but I cannot figure out how to construct such a URL. Is it possible to do this and, if so, what would such a URL look like? Thanks in advance for any help. William

Daniel, You might also want to check out Chris Moyer and Bob Bowers new book "Advanced FileMaker Techniques for Developers" which devotes the first 5 chapters to a discussion of the Relational Model soecifically in the context of FileMaker. HTH William William Akey Peninsula db, LLC Cell: 650-906-5104