dbTalk Databases Forums  

2 Problems with FileMaker and PHP over ODBC

comp.databases.filemaker comp.databases.filemaker


Discuss 2 Problems with FileMaker and PHP over ODBC in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mirko@abitur97.de
 
Posts: n/a

Default 2 Problems with FileMaker and PHP over ODBC - 07-21-2005 , 07:53 AM






hello,

I need your help because the filemaker support in europe and the
filemaker support in us don't answer my questions. I have 2 problems:

1/ The performance from the odbc driver is very poor. A simple SELECT
statement like "SELECT country FROM countries" need around 30 seconds
before I see the result. The countries table have 58 entries. If the
countries table have more than 70 entries i became an: Fatal error:
Maximum execution time of 30 seconds exceeded... We use an Windows 2000
Server with php 4.3 and Filemaker 7 Advanced Server. You can see the
test page at: http://www.dicota.com/neu/test.php

2/ If I touch a SELECT on an media field only the first 3 kB a
returned. The picture is broken if it's larger than 3 kB.

I hope anybody can help....

THANKS!


Reply With Quote
  #2  
Old   
FMWebschool
 
Posts: n/a

Default Re: 2 Problems with FileMaker and PHP over ODBC - 07-21-2005 , 12:15 PM






You may want to check out www.cafephp.com this system is pretty fast


Reply With Quote
  #3  
Old   
mirko@abitur97.de
 
Posts: n/a

Default Re: 2 Problems with FileMaker and PHP over ODBC - 07-22-2005 , 01:08 AM



Do I understand this? It's cafephp a class like fm-and-php
(http://www.fm-and-php.info)? We used fm-and-php at the moment - but i
cant make a select like:

SELECT * from country as cou, language as lang where cou.id = lang.id

Can i make a select like the above one with cafephp ?

Mirko


Reply With Quote
  #4  
Old   
FMWebschool
 
Posts: n/a

Default Re: 2 Problems with FileMaker and PHP over ODBC - 07-22-2005 , 09:40 AM




CAFEphp has it's own imbedded class. Yes you can make a "select" like
the one below. We are currently integrating the FX.php class with
CAFEphp.

Remember please try before you buy!

mirko (AT) abitur97 (DOT) de wrote:
Quote:
Do I understand this? It's cafephp a class like fm-and-php
(http://www.fm-and-php.info)? We used fm-and-php at the moment - but i
cant make a select like:

SELECT * from country as cou, language as lang where cou.id = lang.id

Can i make a select like the above one with cafephp ?

Mirko


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.