[FX.php List] communication problem

[Robert Janssen]

Hi Dale
 
the FMFindall gives the same results as the fmFind,   Fm view returns an array, (I never used the Fmview, so I don't know exactly if this is a good thing and or useful in some way)  ( fmView array included at the end of this text ) 
 
Both databases are shown and can be accessed using the web companion.
 
I asked my administrator about the file access permissions and he assures me they'r okay, and sinds it is possible to acces some 
tabels ( layouts )  I'm inclined to believe him on this one.
 
thnx for hoping,
 
grtz, Robert.fmView result --> 
 
Array ( [data] => Array ( ) [linkNext] => [linkPrevious] => [foundCount] => -1 [fields] => Array ( [0] => Array ( [name] => project_nr [extra] => [type] => EDITTEXT [valuelist] => ) [1] => Array ( [name] => project_omschrijving [extra] => [type] => EDITTEXT [valuelist] => ) [2] => Array ( [name] => projectlabel [extra] => [type] => EDITTEXT [valuelist] => ) [3] => Array ( [name] => land [extra] => [type] => POPUPLIST [valuelist] => landen ) [4] => Array ( [name] => opdrachtgever [extra] => [type] => EDITTEXT [valuelist] => ) [5] => Array ( [name] => kontaktpersoon [extra] => [type] => EDITTEXT [valuelist] => ) [6] => Array ( [name] => medewerkernummer [extra] => [type] => EDITTEXT [valuelist] => ) [7] => Array ( [name] => medewerkers::samengestelde naam [extra] => [type] => EDITTEXT [valuelist] => ) [8] => Array ( [name] => debiteur_nr [extra] => [type] => EDITTEXT [valuelist] => ) [9] => Array ( [name] => updated [extra] => [type] => EDITTEXT [valuelist] => ) [10] => Array ( [name] => afvoerdatum [extra] => [type] => EDITTEXT [valuelist] => ) [11] => Array ( [name] => status [extra] => [type] => EDITTEXT [valuelist] => ) [12] => Array ( [name] => vestiging [extra] => [type] => EDITTEXT [valuelist] => ) [13] => Array ( [name] => reisafstand [extra] => [type] => EDITTEXT [valuelist] => ) [14] => Array ( [name] => werkmij [extra] => [type] => EDITTEXT [valuelist] => ) [15] => Array ( [name] => alternatief_projectnr [extra] => [type] => EDITTEXT [valuelist] => ) [16] => Array ( [name] => alternatief_medewnr [extra] => [type] => EDITTEXT [valuelist] => ) [17] => Array ( [name] => werkt_voor_buitenland [extra] => [type] => EDITTEXT [valuelist] => ) [18] => Array ( [name] => aanmaakdatum [extra] => [type] => EDITTEXT [valuelist] => ) ) [URL] => http://IntranetColumbus:Amerika1498@89.146.3.100:80/fmi/xml/FMPXMLLAYOUT.xml?-db=digitale_urenstaten_NL.fp7&-lay=project_nummers&-max=50&medewerkernummer=1999015&-view [query] => [errorCode] => 0 [valueLists] => Array ( [landen] => Array ( ) ) ) 



> From: dbengston at tds.net> To: fx.php_list at mail.iviking.org> Subject: Re: [FX.php List] communication problem> Date: Thu, 12 Jun 2008 09:06:56 -0500> > Hi Robert,> > What happens if you do FMFindall() or FMView() queries against the > Dutch database? Can you retrieve data at all?> > Can you confirm in the Web Publishing admin console that the Dutch > database is available to the web? There is a page showing hosted > databases. Are both the Dutch and Belgian versions showing?> > Another thing to check would be file access permissions (at the > operating system level) after the transfer.> > Hope this helps,> Dale> > > --> Dale Bengston> Partner, The Whole Brain Group, LLC> thewholebraingroup.com> > On Jun 12, 2008, at 8:29 AM, Robert Janssen wrote:> > > Hello people> >> > I have a rather puzzling problem with the FX module. I’ll try to be > > as succinct as possible but that is proving difficult.> >> > I have two different timesheet programs, one for Dutch timesheets, > > one for Belgian. These two programs are largely similar in> > their communication ( databases ). Last week Filemaker was > > transferred to another> > server ( both windows 2003 servers ) (filemaker version 8.0.2.208 > > advanced )> >> > After this migration the Dutch version failed to operate properly. > > However the Belgian version works flawlessly.> >> > I’ve isolated the code where the problem occurs.> >> >> > include_once($_SERVER['DOCUMENT_ROOT'] . "/FX/FX.php");> > include_once($_SERVER['DOCUMENT_ROOT'] . "/FX/ > > server_data_urenstaat.php");> >> > $gekozen_week = 24;> > $gekozen_jaar = 2008;> > $filemaker_id = 1999001;> >> >> >> > $query = new FX($serverIP, $webCompanionPort, $dataSourceType, > > $scheme);> > $query->SetDBUserPass ($webUN, $webPW);> >> >> > $query->SetDBData($databaseName, "urenregistratie");> > $query->AddDBParam('weeknummer', $gekozen_week);> > $query->AddDBParam('weekjaar', (100*$gekozen_jaar+$gekozen_week));> > $query->AddDBParam('medewerkernummer', $filemaker_id);> > $query->AddSortParam('project_nr', 'ascend', 1);> > $query->AddSortParam('activiteit_code', 'ascend', 2);> > $query->AddSortParam('opmerking', 'ascend', 3);> > $query->AddSortParam('datum', 'ascend', 4);> > $data = $query->FMFind();> >> >> > print_r($data);> >> >> > if I run the code on the belgian database which for the > > "urenregistratie" layout is the same as the Dutch version, I get > > results.> > If I run the code on the dutch database an error occurs and the > > print_r($data) returns the following code> >> > FX_Error Object ( [error_message_prefix] => [mode] => 1 [level] => > > 1024 [code] => 100 [message] => FX: ExecuteQuery XML error: Invalid > > document end at line 2 [userinfo] => [backtrace] => Array ( [0] => > > Array ( [file] => c:\Inetpub\intranet-ace-eu\FX\FX.php [line] => > > 1473 [function] => FX_Error [class] => FX_Error [type] => -> [args] > > => Array ( [0] => ExecuteQuery XML error: Invalid document end at > > line 2 ) ) [1] => Array ( [file] => c:\Inetpub\intranet-ace-eu\FX > > \FX.php [line] => 1687 [function] => ExecuteQuery [class] => FX > > [type] => -> [args] => Array ( [0] => -find ) ) [2] => Array > > ( [file] => c:\Inetpub\intranet-ace-eu\FX\FX.php [line] => 1921 > > [function] => FMAction [class] => FX [type] => -> [args] => Array > > ( [0] => -find [1] => 1 [2] => full [3] => 1 ) ) [3] => Array > > ( [file] => c:\Inetpub\intranet-ace-eu\gogo.php [line] => 23 > > [function] => FMFind [class] => FX [type] => -> [args] => Array > > ( ) ) ) [callback] => )> >> > I observed a similar problem in the online fx trouble forum:> > [FX.php List] FX: ExecuteQuery XML error> > Steve Bennett (steve at bentechaps.com)> > Sat Sep 8 09:57:39 MDT 2007> >> > however that never ended in a sollution,> >> > best regards,> >> > Robert Janssen> >> > Het beste van Windows, nu ook online. Deel jouw wereld met Windows > > Live. Download nu._______________________________________________> > FX.php_List mailing list> > FX.php_List at mail.iviking.org> > http://www.iviking.org/mailman/listinfo/fx.php_list> > _______________________________________________> FX.php_List mailing list> FX.php_List at mail.iviking.org> http://www.iviking.org/mailman/listinfo/fx.php_list
_________________________________________________________________
Check je Hotmail nu ook op je mobiel!
http://windowslivemobile.msn.com/BrowserServiceHotmail.aspx?lang=nl-nl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080612/2ab1a015/attachment-0001.html