• user warning: Table 'site_513_0.skinr_rules' doesn't exist query: SELECT * FROM skinr_rules in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 300.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr' doesn't exist query: SELECT theme, module, sid, settings, skins FROM skinr WHERE theme = 'acquia_prosper' AND module = 'node' AND sid = 'blog' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 491.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr' doesn't exist query: SELECT theme, module, sid, settings, skins FROM skinr WHERE theme = 'acquia_prosper' AND module = 'block' AND sid = 'blog-0' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 491.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr' doesn't exist query: SELECT theme, module, sid, settings, skins FROM skinr WHERE theme = 'acquia_prosper' AND module = 'block' AND sid = 'user-0' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 491.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skinsets' doesn't exist query: SELECT * FROM skinr_skinsets in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 826.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'marvin' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'chameleon' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'bluemarine' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'minnelli' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'garland' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'pushbutton' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_starter' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'fusion_core' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.
  • user warning: Table 'site_513_0.skinr_skins' doesn't exist query: SELECT * FROM skinr_skins WHERE name = 'acquia_prosper' in /var/aegir/drupal-6.16/sites/all/modules/skinr/skinr.module on line 877.

FileMaker Server

FileMaker Server Side Scripting Gotchas

Submitted by eow on Wed, 05/27/2009 - 16:35

It has been  long time since I blogged about technology and even longer since I blogged about FileMaker, but here is a little tidbit that is worth mentioning.

 

FileMaker 9 and 10 can both run FileMaker Scripts on the server. This is great, but it is really helpful to understand what the differences are between running a script on the Server and running them on the client.

The obvious one is many of the scripts steps that aren't supported. You can't use any of those.  But there are a couple of others that can be real gotchas unless you understand what the Server Side environment actually is.

When FileMaker Server runs a script, it behaves as though it actually the following

  1. Opens a copy of FileMaker client, as host.
  2. Runs the script
  3. Closes the client.

The effect of this is pretty profound. So everything that is happens when File is opened and closed as HOST happens in this case.

  • Open and close scripts run. 
  • Globals are set permanently.

But this one is also true

Syndicate content