Jump to content

Micah Woods

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Micah Woods

  • Rank

Profile Information

  • Gender
  • Location
    Kalamazoo, MI

Contact Methods

  • Website URL
  1. Hi Colleen, this is a confusing little query that's actually being used to build a INSERT statements by concatenating together some hard-coded pieces, for example: 'INSERT INTO Employee(Department_ID, Employee_ID, First_Name, Last_Name, Salary) VALUES (' with some dynamic data from the Employee table. It's a query that builds a query, kind of like you can have a FileMaker calc that builds an expression that can then be evaluated. I created this so I could store all the data in the Employee table, then delete all the records, then run the query to restore everything. I hope that makes some
  2. Hello Jake, I think the helper functions are great for people new to SQL and they're also convenient even for those with more SQL experience. I recently presented on internal SQL at PauseOnError and promoted your plug-in as my SQL plug-in of choice. Our SmartPill plug-in has SQL but we don't yet support the new API which is very nice. In regards to other functions that would be useful, it would be nice to have an easy way to apply a query to the current found set (as FileMaker developers, were so used to context, it gets a bit tricky when we have to think in SQL queries). Kevin Frank
  3. I don't know of any others. Here's the complete list of plug-ins that support SQL (at least that I know of). Any others?? 2empowerFM SQL Runner 24U Toolbox Plug-In 360Works ScriptMaster CNS MMQuery Monkeybread MBS myFMbutler DoSQL qutic FMSQL Scodigo SmartPill fmDataGuard Youseful ysflSQL
  4. Kalamazoo, MI, January 15, 2008 Scodigo, Inc. is pleased to announce the availability of our public beta for the next version of SmartPill PHP Edition . Available for download @ http://www.scodigo.com/support/downloads. What Is SmartPill PHP Edition? SmartPill does one simple but very powerful thing, it allows you to run PHP code and return the results back to FileMaker. Putting the power of PHP inside FileMaker opens a whole new world of possibilities. Visit PHP's website to view a complete list of functions: http://www.php.net/manual/en/funcref.php. Just a few of the thin
  5. Thanks, here's the updated URL: http://www.scodigo.com/dawn-heady-and-chris-hansen-join-scodigo
  6. Kalamazoo, MI, February 14, 2007 Scodigo, Inc. is very pleased to announce the commercial release of our first plug-in, SmartPill PHP Edition. After many months in beta and many improvements along the way, SmartPill is finally ready for action. Along with the release of SmartPill, we're debuting our new website: http://www.scodigo.com. What Is SmartPill PHP Edition? SmartPill does one simple but very powerful thing, it allows you to run PHP code and return the results back to FileMaker. Putting the power of PHP inside FileMaker opens a whole new world of possibilities. Visit PHP
  7. There’s a technique you can use to make this a bit more systematic. In a nutshell, you put the fields you want to set on a layout and then your script tabs through each field and sets them. The trick is not specifying the field for the set field script step. By not specifying the field, what ever field you’re in will get set. You then use Get ( ActiveFieldName ) to calculate the name of the current field which is then used as the key in your PHP code to get the correct value out of the array (or it could be an XML tag, etc.). When you've tabbed through all the fields, you're done. The nice thi
  8. Hello Adam, There are many ways to return data to FileMaker. Some things to consider include how the information is stored in your PHP code, for example, your class may have methods used for retrieving the various data or you may be returning an array. If you're making a web service call, it might be easiest to return XML. You also have to decide if you're going to return all the data at once or if you're going to leave it in memory and come back for it. If you want to return all the data at once, you'll need to include a delimiter or use XML or some other method that allows you to p
  9. > Boiling it all down, PHPlot generates a PNG/JPG/GIF image of a chart, and > yes, my ultimate desire was to put the resulting image into a FileMaker > container field. So I guess what you're saying is the call to ImagePng(), > ImageJPEG(), ImageGIF(), and others just don't work if you try to send the > output to PHP's default output device? We need to provide a special function in order to write to a container field. The issue has to do with FileMaker's plug-in API which requires special handling when dealing with container fields. > As I discovered that yo
  10. We were able to get this to work. We now add the PHP Support folder path to the include_path setting. You can still use a custom php.ini file with your own include path settings and the plug-in will simply add the support folder path to the end. Thanks for your question, I think this is a nice little addition...
  11. It sounds like you're trying to set the contents of a container field? If so, this isn't supported, instead you have to write the file to disk and then import it. You can then delete it if you like or we sometimes just use a name like temp and overwrite it each time. We're looking into adding support for writing to containers in the next version. In regards to the header() function, what are you trying to achieve?
  12. We're looking into a way to dynamically determine the correct path to the PHP Support folder when the plug-in starts up and then append it to the include path. I think this would be the best solution because then the path will always be correct no matter where FM is installed or which version or platform you're using. I'll keep you posted.
  13. The problem I see is that we don't know the exact path, for example, it could be FileMaker 8 or 8.5 and for each it could be Advanced or not. We also have both OSX and Windows to consider. There's also the possibility that FileMaker is installed in a non-standard location. And eventually, FileMaker 9 will be out. Anyway, yes we could compile the plug-in with the typical location of the PHP Support folder but I'm not sure I'd want to write code that depends on this. Personally, I think it's better to be sure by setting the include path dynamically. I agree with you regarding not wanti
  14. I think there are a couple of good solutions. One is to use a custom php.ini file that has the appropriate include path settings. If you put your own php.ini file in the PHP Support folder, then it will be read when the plug-in starts up (otherwise the default settings are used). Another option is to use PHP's set_include_path function at the start of your script. Here's some code that doesn't require you to create a FileMaker field and is also cross-platform. You could include this at the top of your PHP code and you might even create a FileMaker custom function that executes this code a
  15. Kalamazoo, MI, January 9, 2007 Scodigo, Inc. is pleased to announce the availability of a release candidate version of our SmartPill PHP Edition plug-in for FileMaker. The public beta was announced back in August, just prior to DevCon, and we've spent the last 5 months testing, fine-tuning and extending SmartPill's functions. We'd like to thank the 1,500+ people that took time to download the beta version and special thanks to those that shared their experience, reported issues and suggested improvements. New version with extended beta license available here: http://www.scodigo.com
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.