[FX.php List] communication problem

DC dan.cynosure at dbmscan.com
Thu Jun 12 10:05:22 MDT 2008

Previous message: [FX.php List] communication problem
Next message: [FX.php List] communication problem
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

just FYI... the XML parser parses ALL fields on the returned layout. you 
  mention this in your email:

"Both layouts showed a related field (which was however not used in the 
FX-connection)"

but, if a field is *on* a layout, it is "used" by the FX connection 
because FX translates the XML output by the CWP engine to PHP arrays.

cheers.

Robert Janssen wrote:
> really empty, no relation found
> 
> 
> 
> ------------------------------------------------------------------------
>  > Date: Thu, 12 Jun 2008 11:50:22 -0400
>  > From: dan.cynosure at dbmscan.com
>  > To: fx.php_list at mail.iviking.org
>  > Subject: Re: [FX.php List] communication problem
>  >
>  > really, empty, empty or just filled with "invisible" and corrupted data?
>  >
>  >
>  > Robert Janssen wrote:
>  > > We finally solved the problem, however we cannot explain it.
>  > >
>  > > In the dutch database there were 2 tables where the connection failed.
>  > > Both layouts showed a related field (which was however not used in the
>  > > FX-connection) and for some records the relation was empty. For the
>  > > queries where there was an empty relation shown in the layout, the
>  > > connection failed.
>  > >
>  > > Just by removing this field from both layouts everything worked fine
>  > > again. The strange thing is that in the belgian database these layouts
>  > > are identical, showing the same fields, also with some empty 
> relations,
>  > > and here there is no problem.
>  > >
>  > > if anyone can explain this ...
>  > >
>  > > I'd still very much would like to hear it,
>  > >
>  > > thanks!
>  > >
>  > >
>  > >
>  > >
>  > > 
> ------------------------------------------------------------------------
>  > >
>  > > > Date: Thu, 12 Jun 2008 10:29:49 -0400
>  > > > From: dan.cynosure at dbmscan.com
>  > > > To: fx.php_list at mail.iviking.org
>  > > > Subject: Re: [FX.php List] communication problem
>  > > >
>  > > > also, xml parser can choke on corrupt data coming out of the database
>  > > > fields (including high ascii chars).
>  > > >
>  > > > cheers,dan
>  > > >
>  > > > Dale Bengston wrote:
>  > > > > 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
>  > > > >
>  > > > _______________________________________________
>  > > > FX.php_List mailing list
>  > > > FX.php_List at mail.iviking.org
>  > > > http://www.iviking.org/mailman/listinfo/fx.php_list
>  > >
>  > >
>  > > 
> ------------------------------------------------------------------------
>  > > Lees jij al je Hotmail op je mobiel? Probeer het nu!
>  > > 
> <http://windowslivemobile.msn.com/BrowserServiceHotmail.aspx?lang=nl-nl>
>  > >
>  > >
>  > > 
> ------------------------------------------------------------------------
>  > >
>  > > _______________________________________________
>  > > 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
> 
> ------------------------------------------------------------------------
> Lees jij al je Hotmail op je mobiel? Probeer het nu! 
> <http://windowslivemobile.msn.com/BrowserServiceHotmail.aspx?lang=nl-nl>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

Previous message: [FX.php List] communication problem
Next message: [FX.php List] communication problem
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the FX.php_List mailing list