[FX.php List] foundcount: -1

Fri Apr 6 07:44:38 MDT 2007

Alex,

Could we look at the query code?  The "No Action Taken" makes it  
sound like something isn't right.  Best,

--Chris Hansen
   FileMaker 8 Certified Developer
   FileMaker 7 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Apr 6, 2007, at 7:09 AM, Alex Gates wrote:

> Hi everyone:
>
> I'm trying my hand at installing FileMaker Server 8 advanced using IIS
> on XP Pro.
>
> Have any of you ever gotten a foundcount of -1 on a simple query test
> using fx.php?
>
> Here is my returned array:
>
> Array ( [data] => Array ( ) [linkNext] => [linkPrevious] =>  
> [foundCount]
> => -1 [fields] => Array ( ) [URL] =>
> http://****:****@localhost:80/fmi/xml/FMPXMLRESULT.xml?- 
> db=Web_Cookbook_
> Dev2.fp7&-lay=Login&-max=50&-findany [query] => [errorCode] => No  
> Action
> Taken [valueLists] => Array ( ) ) foundcount: -1
>
> Any suggestions?
>
> Alex
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
> Gusland Thorsen
> Sent: Thursday, April 05, 2007 5:09 PM
> To: adenman at tmea.org; FX.php Discussion List
> Subject: Re: [FX.php List] New to FX: A few basic questions
>
> If you need OLAP features you have to use layouts as cubes.
>
> ggt667
>
> On 4/5/07, Andrew Denman <adenman at tmea.org> wrote:
>> 2. Is data entry FM session based or transaction based?
>>
>> If you're asking the question I think you are, the answer is that it
> is
>> transaction based.  Each find, add, edit, and delete you make through
> FX.php
>> is completely separate from each other.
>>
>> Andrew Denman
>> TMEA IT Administrator
>> 1-888-318-TMEA x109
>> Fax: (512) 451-9213
>> www.tmea.org
>>
>> -----Original Message-----
>> From: fx.php_list-bounces at mail.iviking.org
>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Vision
> Computer
>> Consulting
>> Sent: Thursday, April 05, 2007 1:19 AM
>> To: FX.php Discussion List
>> Subject: Re: [FX.php List] New to FX: A few basic questions
>>
>> Excuse me. I left something out of the question. I meant to say:
>>
>>> I have worked extensively with PHP session variables and yes they
>>> work great. Are you talking about PHP sessions and not FMP sessions?
>> Doesn't the add,update, delete look like a transaction to FM even
>> when it is done within a PHP session?
>>
>>
>> On Apr 4, 2007, at 11:09 PM, Vision Computer Consulting wrote:
>>
>>> I have worked with extensively with PHP session variables. Are you
>>> talking about PHP sessions and FMP sessions?
>>>
>>> On Apr 4, 2007, at 7:31 PM, Bob Patin wrote:
>>>
>>>> I second others' advice not to use scripts if at all possible with
>>>> PHP. So far I've been able to do some fairly complex things with
>>>> PHP without any scripting; between the wealth of PHP scripts and
>>>> functions available on the web, and PHP's flexibility when
>>>> compared to CDML or Lasso, I think you'll quickly find it to be
>>>> much easier to work with.
>>>>
>>>> Look into session variables; they're immensely valuable and very
>>>> easy to use; not having to deal with tokens as I did with CDML was
>>>> such a relief!
>>>>
>>>> Have fun!
>>>>
>>>> Bob Patin
>>>> Longterm Solutions
>>>> bob at longtermsolutions.com
>>>> 615-333-6858
>>>> http://www.longtermsolutions.com
>>>>
>>>>   CONTACT US VIA INSTANT MESSAGING:
>>>>      AIM or iChat: longterm1954
>>>>      Yahoo: longterm_solutions
>>>>      MSN: tech at longtermsolutions.com
>>>>      ICQ: 159333060
>>>>
>>>>
>>>> On Apr 4, 2007, at 8:11 PM, Vision Computer Consulting wrote:
>>>>
>>>>> Thank you Kevin and Alex for your help.
>>>>>
>>>>> Here is a link to FM error codes,
>>>>> http://www.briandunning.com/error-codes/?source=FileMaker
>>>>>
>>>>> Stephen Calia
>>>>> Vision Computer Consulting
>>>>> info at visioncomputerconsulting.com
>>>>>
>>>>>
>>>>> On Apr 4, 2007, at 5:49 PM, Kevin Futter wrote:
>>>>>
>>>>>> On 5/4/07 10:09 AM, "Alex Gates" <alex at gandrpublishing.com>
> wrote:
>>>>>>
>>>>>>> Hi Stephen-
>>>>>>>
>>>>>>> I can only help with one of your questions as I'm relatively
>>>>>>> new to this
>>>>>>> as well.
>>>>>>>
>>>>>>> The answer to 1 is yes.  The field that you are retrieving data
>>>>>>> from has
>>>>>>> to be on the layout you specify.
>>>>>>>
>>>>>>> Sorry I can't help with anything else -
>>>>>>>
>>>>>>> Alex
>>>>>>>
>>>>>>> Vision Computer Consulting wrote:
>>>>>>>> 1. I was a lasso programmer who has been doing PHP/MySQL for
>>>>>>>> the last 4
>>>>>>>> years, but I remember that we created a layout that had all
>>>>>>>> fields on it
>>>>>>>> to make them accessible to lasso. What I have noticed is that,
>>>>>>>> unless
>>>>>>>> the related field is on the layout you are accessing, data in
>>>>>>>> that field
>>>>>>>> can't be retrieved. I know that in recent versions of
>>>>>>>> Filemaker one can
>>>>>>>> grab data from many layers of related layouts.
>>>>>>>>
>>>>>>>> That is a long way of asking whether the field you are
>>>>>>>> retrieving data
>>>>>>>> from has to be on the layout you specify in SetDBData?
>>>>>>>>
>>>>>>>> 2. Is data entry FM session based or transaction based?
>>>>>>>>
>>>>>>>> 3. I am using PHP to do data validation (especially  date and
>>>>>>>> time). Any
>>>>>>>> hints on how to format date and time in such a way that FM
>>>>>>>> won't throw
>>>>>>>> and error? How do I setup Filemaker to best accept date and
> time
>>>>>>>> information?
>>>>>>>>
>>>>>>>> 4. Is it a good idea to run FM scripts from FX? If so, any
>>>>>>>> suggestions
>>>>>>>> on when it might appropriate to use FX to run an FM script?
>>>>>>>>
>>>>>>>> Thank you in advance for your help.
>>>>>>>>
>>>>>>>> Stephen Calia
>>>>>>
>>>>>> 1. Alex is right - all fields (and value lists) you need must be
>>>>>> on the
>>>>>> layout you specify.
>>>>>>
>>>>>> 2. I'm not sure - I assume it's transacted-based, but that's
>>>>>> just an
>>>>>> educated guess.
>>>>>>
>>>>>> 3. Normally FM accepts dates separated only by periods (.) or
>>>>>> forward-slashes (/). IIRC, anything else is invalid for a
>>>>>> FileMaker date -
>>>>>> off the top of my head mind. Your safest be is just to make sure
>>>>>> that any
>>>>>> dates you submit to FM are formatted that way. Remember,
>>>>>> everything you pass
>>>>>> to FM (or *any* database) via the web is a string, FM makes it
>>>>>> into whatever
>>>>>> data type is specified by the target field definition, as long
>>>>>> as it
>>>>>> qualifies.
>>>>>>
>>>>>> 4. No, it's best to avoid running internal FM scripts from the
>>>>>> web, for a
>>>>>> variety of reasons - they can compromise security, there can be
>>>>>> data sync
>>>>>> issues, they can be expensive server-side and slow down the
>>>>>> transaction
>>>>>> queue, etc. I've done it, but only as a last resort.
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Kevin Futter
>>>>>> Webmaster, St. Bernard's College
>>>>>> http://www.sbc.melb.catholic.edu.au/
>>>>>>
>>>>>>
>>>>>>
>>>>>>
> ###################################################################
>>>>>> ##################
>>>>>> This e-mail message has been scanned for Viruses and Content and
>>>>>> cleared
>>>>>> by MailMarshal
>>>>>>
> ###################################################################
>>>>>> ##################
>>>>>>
>>>>>> This e-mail and any attachments may be confidential. You must
>>>>>> not disclose or use the information in this e-mail if you are
>>>>>> not the intended recipient. If you have received this e-mail in
>>>>>> error, please notify us immediately and delete the e-mail and
>>>>>> all copies. The College does not guarantee that this e-mail is
>>>>>> virus or error free.  The attached files are provided and may
>>>>>> only be used on the basis that the user assumes all
>>>>>> responsibility for any loss, damage or consequence resulting
>>>>>> directly or indirectly from the use of the attached files,
>>>>>> whether caused by the negligence of the sender or not. The
>>>>>> content and opinions in this e-mail are not necessarily those of
>>>>>> the College.
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>
>>>
>>> _______________________________________________
>>> 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
>>
> _______________________________________________
> 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
>