[FX.php List] Date range and MySQL

[Dale Bengston]

Thanks, Chris! I'll explore that route.

Dale

On Jan 24, 2008, at 2:36 AM, Chris Hansen wrote:

> Dale,
>
> Although it's not the more common AddDBParam() method, there are  
> times when it makes the most sense to use PerformSQLQuery().  This  
> replaces both the parameters and the action call.  Check it out and  
> let me know if you have any questions.  HTH
>
> --Chris
>
>
> On Jan 23, 2008, at 8:50 PM, Dale Bengston wrote:
>
>> Hi folks,
>>
>> Anyone know what the parameter should look like to do a date range  
>> search with FX to MySQL?
>>
>> In FMP, it would look like this:
>>
>> 	$findRec->AddDBParam('myDate', $startDate . '...' . $endDate);
>>
>> How would this translate to MySQL?
>>
>> Thanks,
>> Dale
>>
>>
>>
>>
>> --
>> Dale Bengston
>> Partner, The Whole Brain Group, LLC
>> TheWholeBrainGroup.com
>>
>> _______________________________________________
>> 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