[FX.php List] Different results on 2 installations of same DB and sctipt

Vision Computer Consulting info at visioncomputerconsulting.com
Sat Apr 28 19:09:31 MDT 2007


Turns out to be corrupted layout. Made a new layout based on the  
shopping table and got the correct 'foundCount'.


On Apr 28, 2007, at 3:54 PM, Alex Gates wrote:

> As Jonathan mentioned, you are getting an FX Object returned-
> Do a print_r($fx_Result); That will give you some information - and  
> also the URL that fx is using to query filemaker.
>
> Try adding a new field to your shopping layout named "test" and  
> place a 1 in the field in FileMaker -
> Then try to do a find on that layout for only that field - -
> It should work for you - if it doesn't, then you now the problem is  
> deeper -- -
>
> Like Jonathan said - start simple and comment out most of your  
> params - (I'd really try the "test" field and finding 1) if that  
> works, then uncomment out until you can deduce what line is causing  
> the problem.
>
> If all else fails and you think it is the layout, recreate the  
> layout and give it a different name and try that -
>
> My guess, though, is that it is something simple.  The simple  
> problems are often overlooked.
> Start with a simple request and work from there.
>
> Alex
>
> Vision Computer Consulting wrote:
>> I have alot of PHP experience, but not that much with FM. Is it  
>> possible to have a corrupted layout. I ask because I can do a find  
>> on other layouts . I put the find on the shopping layout in the  
>> body of the script and get not result. Put a different find in the  
>> same place in the code and get a 'foundCount'/
>> On Apr 28, 2007, at 3:07 PM, Jonathan Schwartz wrote:
>>> This error, from my experience, occurs when fx expects to get an  
>>> array of returned  data after a query, but instead gets  
>>> none...which it calls a scalar.  (my interpretation).
>>>
>>> So, if I'm correct, then this isn't the problem.  It's a result  
>>> of the problem.
>>>
>>> Did you turn on Debug to examine the queries that FX is sending  
>>> FMP?  It's tell the story.
>>>
>>> J
>>>
>>>
>>> At 2:54 PM -0700 4/28/07, Vision Computer Consulting wrote:
>>>> I got about this error, but thought I should investigate why it  
>>>> is happening first.
>>>>
>>>> Warning: Cannot use a scalar value as an array in /Users/spcalia/ 
>>>> Sites/ram/fx/theprogRAM/php/lib/cust_cart_class.php on line 1024
>>>>
>>>> Cose is:
>>>>
>>>> //define db and layout to be used
>>>>                 $layout="shopping";
>>>>                 $my_fx->SetDBData($db,$layout);
>>>>                 $my_fx->AddDBParam('warranty_type',$cat);
>>>>                 $my_fx->AddDBParam('session',$this->cart_id);
>>>>                 $fx_Result=$my_fx->FMFind();
>>>>                 $count = $fx_Result['foundCount']; //leave in  
>>>> for $contents['items'] = $count;
>>>>         //echo $cat. $count;
>>>>                 $i = 0;
>>>>         foreach($fx_Result['data'] as $key=>$value) { //line  
>>>> 1024                  $contents[$i] = array(
>>>>                         'warrantyID'=> $value['warrantyID'][0],
>>>>                         'name'=> $value['warranties_new::name'][0],
>>>>                         'name_sub'=> $value 
>>>> ['warranties_new::name_sub'][0],
>>>>                         'price'=> $value['warranties_new::price'] 
>>>> [0],
>>>>                         'quantity'=> $value['quantity'][0],
>>>>                         'online_discount'=> $value 
>>>> ['warranties_new::online_discount'][0]
>>>>                 );
>>>>                                 $i++;
>>>>                 }
>>>>
>>>>
>>>> As far as I can tell, the error is telling me $fx_Result is a  
>>>> scalar instead of an array.
>>>>
>>>> As I said, exact same code works in another installation.
>>>>
>>>> Thanks in advance for your help.
>>>>
>>>> Stephen
>>>>
>>>>
>>>> On Apr 28, 2007, at 12:47 PM, Bob Patin wrote:
>>>>
>>>>> Well, that tells you that the connection is being made.
>>>>>
>>>>> I would probably try trimming my query; comment out all but one  
>>>>> parameter to see if you can get some results. If that doesn't  
>>>>> work, try duplicating the same search in the db itself (you may  
>>>>> have already tried this).
>>>>>
>>>>>
>>>>> On Apr 28, 2007, at 2:23 PM, Vision Computer Consulting wrote:
>>>>>
>>>>>> Error code come back the first time as 401 (to be expected),  
>>>>>> but then the error code doesn't show up on subsequent finds on  
>>>>>> the cart.
>>>>>>
>>>>>> On Apr 28, 2007, at 12:19 PM, Bob Patin wrote:
>>>>>>
>>>>>>> So other finds work on the web?
>>>>>>>
>>>>>>> Did you try returning the error code? $findResult['errorCode']
>>>>>>>
>>>>>>>
>>>>>>> On Apr 28, 2007, at 2:14 PM, Vision Computer Consulting wrote:
>>>>>>>
>>>>>>>> I am getting data on some cases. I am populating page  
>>>>>>>> content from the db and that works. What is not working is  
>>>>>>>> finding recording in my shopping cart records. I can search  
>>>>>>>> the db manually and find the record I am looking for, but  
>>>>>>>> not through FX. That is the only part that doesn't work.  
>>>>>>>> Other Finds work.
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> FX.php_List mailing list
>>>>>>> FX.php_List at mail.iviking.org  
>>>>>>> <mailto: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  
>>>>>> <mailto: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 <mailto: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 <mailto:FX.php_List at mail.iviking.org>
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>>
>>> -- 
>>> Jonathan Schwartz
>>> Exit 445 Group
>>> jonathan at exit445.com <mailto:jonathan at exit445.com>
>>> http://www.exit445.com
>>> 415-381-1852
>>> FileMaker 8 Certified Developer
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org <mailto: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
>



More information about the FX.php_List mailing list