[FX.php List] Query question content from one field equal to content of other field for the same record?

Tim 'Webko' Booth tim at nicheit.com.au
Sun Nov 9 15:16:52 MST 2008


On 08/11/2008, at 5:52 AM, Gjermund Gusland Thorsen wrote:

> Well, what I build is a newssystem, and from MySQL I'm used to SELECT
> * from aricle where articleID=articleIDownedBy;

Yeah, the FM way is to have a calc field in the system that evaluates  
this for you, as far as I can tell... Then you query that field and  
return the IDs from the found records

Cheers

Webko
>
>
> ggt
>
> 2008/11/7 Chris Hansen <chris at iviking.org>:
>> The best idea that comes to me is a purpose built calc field...  If  
>> the
>> comparison value needs to be set dynamically, you could either use  
>> a script
>> parameter and a pre-find script, or a global field (just be sure to  
>> use the
>> appropriate FX function...)
>>
>> --Chris
>>
>> On Nov 7, 2008, at 1:08 AM, Gjermund Gusland Thorsen wrote:
>>
>>> Go figure
>>>
>>> 2008/11/6 Steve Winter <steve at bluecrocodile.co.nz>:
>>>>
>>>> ggt,
>>>>
>>>> This is FMP not SQL ;-)
>>>>
>>>> Cheers
>>>> Steve
>>>>
>>>> On 6 Nov 2008, at 18:02, Gjermund Gusland Thorsen wrote:
>>>>
>>>>> Query question content from one field equal to content of other  
>>>>> field
>>>>> for the same record, possible with FileMaker's XML engine?
>>>>>
>>>>> Have anyone here noticed a way to do a query to search for two  
>>>>> fields
>>>>> with the same value?
>>>>>
>>>>> $q->AddDBParam( 'field1', field2 );
>>>>>
>>>>> I assume the location where I put field2 is for strings only and  
>>>>> that
>>>>> there are no ways to reference content from fields...
>>>>>
>>>>> ggt667
>>>>> _______________________________________________
>>>>> 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

Tim 'Webko' Booth :: Niche IT Pty Ltd, Sydney, Australia
[e] tim at nicheit.com.au :: [m] 0418 993 306







More information about the FX.php_List mailing list