Jump to content

smeshy123

Newbies
  • Posts

    4
  • Joined

  • Last visited

smeshy123's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. I have 3 databases that I have linked based on a couple fields. They are linked by the actual values in the fields and not by foreign keys because of limitations in how much code I can change. I would like to be able to change one of the linked values in any one of the databases and have it change that value in the two other databases. Any ideas in how to do this would be greatly appreciated! Thanks Smeshy
  2. My code: include('FileMaker.php'); $conn =& new FileMaker(); $databases = $conn->listDatabases(); print_r($databases); $conn->setProperty('database', 'Employee Info'); $conn->setProperty('username', 'fasdf'); $conn->setProperty('password', 'safdfadf'); $cmd =& $conn->newFindCommand('Data Entry'); $cmd->addFindCriterion('First', 'Rick'); $result = $cmd->execute(); if (FileMaker::isError($result)) { echo $result->message . '(' . $result->code . ')'; } My results: First the result from the databases printing (there are a bunch of errors in there I think?) FileMaker_Error Object ( [_fm] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => utf-8 [locale] => en [logLevel] => 3 [hostspec] => http://localhost [recordClass] => FileMaker_Record [prevalidate] => ) [Vea4b3413] => [V9a3dcbce] => ) [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => 20602 [message] => [userinfo] => [backtrace] => Array ( [0] => Array ( [file] => /Filepath/Error.php [line] => 50 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => [1] => 20602 ) ) [1] => Array ( [file] => /Filepath/Implementation/Parser/FMResultSet.php [line] => 48 [function] => FileMaker_Error [class] => FileMaker_Error [object] => FileMaker_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => utf-8 [locale] => en [logLevel] => 3 [hostspec] => http://localhost [recordClass] => FileMaker_Record [prevalidate] => ) [Vea4b3413] => [V9a3dcbce] => ) [1] => [2] => 20602 ) ) [2] => Array ( [file] => /Filepath/Implementation/FileMakerImpl.php [line] => 227 [function] => parse [class] => FileMaker_Parser_FMResultSet [object] => FileMaker_Parser_FMResultSet Object ( [Vcb5e100e] => 20602 [Vf5bf48aa] => Array ( [build] => 06/13/2007 [name] => FileMaker Web Publishing Engine [version] => 9.0.1.74 ) [V1ea7e575] => Array ( [database] => [date-format] => [layout] => [table] => [time-format] => [timestamp-format] => [total-count] => 0 ) [V9f81f3c0] => Array ( ) [Vaae0d98d] => Array ( [count] => 0 [fetch-size] => 0 ) [Vae581270] => Array ( ) [V6e52c40b] => Array ( ) [Ve13f1c92] => [V43432a31] => [V51bc3e3b] => [V26005321] => [V6468d939] => [_fm] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => utf-8 [locale] => en [logLevel] => 3 [hostspec] => http://localhost [recordClass] => FileMaker_Record [prevalidate] => ) [Vea4b3413] => [V9a3dcbce] => ) [V5431b8d4] => Resource id #19 [V6de51026] => [_result] => [_layout] => ) [type] => -> [args] => Array ( [0] => ) ) [3] => Array ( [file] => /Library/WebServer/intranet.redandblack.com/docs/FileMaker/FileMaker.php [line] => 382 [function] => listDatabases [class] => FileMaker_Implementation [object] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => utf-8 [locale] => en [logLevel] => 3 [hostspec] => http://localhost [recordClass] => FileMaker_Record [prevalidate] => ) [Vea4b3413] => [V9a3dcbce] => ) [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => /Library/WebServer/intranet.redandblack.com/docs/FileMaker/test.php [line] => 5 [function] => listDatabases [class] => FileMaker [object] => FileMaker Object ( [_impl] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => utf-8 [locale] => en [logLevel] => 3 [hostspec] => http://localhost [recordClass] => FileMaker_Record [prevalidate] => ) [Vea4b3413] => [V9a3dcbce] => ) ) [type] => -> [args] => Array ( ) ) ) [callback] => ) (-1) Then the error from the connection attempt: (-1) Any help would be greatly appreciated! Thanks! Smeshy
  3. I'm trying to get rid of the first letter in a certain field, but only if that letter is a -. I have 4000 entries so I can't do it by hand. Anyone know the kind of calculation I could write to do this? Thanks, Smeshy
  4. I have a mysql database and in this database I have a parent and child setup. What I am trying to do is import the newest child or if there are no children then just the parent. So if I have 4 entries for a name I want to import the newest entry. If I only have 1 entry for the name that one is imported. While I import I would like to check against what was imported last time I loaded filemaker to see if the entry is in the database. If it is not, import it. If it is and the information is the same do nothing. If it is and the information is different write over the current entry. Is this possible using filemaker scripts with ODBC connectivity? If so, can someone point me in the right direction? Thanks, Smeshy
×
×
  • Create New...

Important Information

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