[FX.php List] Generating Safe links to Database Records

Malcolm Fitzgerald malcolm at notyourhomework.net
Mon Jan 16 17:18:14 MST 2012


On 17/01/2012, at 11:02 AM, Malcolm Fitzgerald wrote:

> This morning I was testing a routine and the results looked odd. After some head-scratching I increased the modification number on the record and got the right results. The record id returned by FX consists of the internal record ID and it's modification number. The modification number is inherently unstable. 
> 
> I want to be able to generate links to records in the database that do not rely on the modification number. How does FX handle this?

I'll answer my own question. 

Searching by -recid works perfectly well as the key to access data but it is not sufficient to act as a key for the data array which is returned. The returned array has a key which consists of the internal record ID and it's modification number. There should only be one item returned array so it is easy to access. 

Malcolm


More information about the FX.php_List mailing list