June 22, 200520 yr I'm trying to understand how to have a web server insert data into a FileMaker database. The data is coming from a perl-based shopping cart, and we have FileMaker Server Advanced. The goal is that as orders are entered on the existing shopping cart, the perl script "pushes" XML at the FileMaker server creating a new record in the database. I'm finding that resources are hard to come by.
June 22, 200520 yr XML is output by FMSA, but is not used as input for record creation. For record creation and editing, standard CGI queries are used. Consider reading the CWP Guide that comes with FMSA, Appendix A about the query language.
June 22, 200520 yr Author Thank you, that is good information to hear, I didn't know that. I'll start looking at Appendix A.
June 22, 200520 yr Author Martin, your post was VERY helpful. Thank you. Using this I can add a record to a database... http://192.168.0.100/fmi/xml/fmresultset.xml?-db=TESTGETCSV&-lay=layout&BillingFirstName=Wes&BillingLastName=Plate&BillingCompany=AutomaticDuck&-new SO COOL.
June 23, 200520 yr If you can, turn off XML publishing and use only XSLT publishing for the DB in question. With XML publishing too much information can be read from the database with the right queries.
Create an account or sign in to comment