[FX.php List] Query for Last Record Created of a Found Set

DC dan.cynosure at dbmscan.com
Tue May 30 09:56:58 MDT 2006


sound like you need to add a "date created" field to your database and 
then sort records on that value.

dan

Kim Hawksworth had written:
> I’m  developing an application that needs to pass the field values from 
> the last record created in a found set to a form.  Is there a way with 
> fx and php  to identify the last record created in a found set?  The 
> found count will vary from query to query.  
> 
> Sof far I’ve thought about creating a portal and using the 
> Get(PortalRowNumber) function, but then you have the issue of making 
> sure the records are sorted so the last record is always in the first 
> row.  Is there a better solution?
> 
> Thanks for your help.
> 
> --Kim
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> 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