| George Pitcher 2005-02-01, 4:01 pm |
| Sorry about the cross-posting.
I've been a Filemaker user for around 10 years now. Its brilliant for small
scale applications, but over recent months, I've been porting a site based
on Filemaker v5 to PHP/MySQL. I am using PEARD:DB and the Smarty templating
engine.
One of the nice tricks in FM is the ability to select a field and have the
value of that field set in the current found set.
By using a little bit of javascript in the form, I am able to capture the
filed in focus, and have built a function that will form the SQL query so
that it takes account of the column type being selected.
This morning, I have extended this by making it work on a multi-row table.
So I can be working on a 75-row table and I can now update one of the
columns to store the data that I have selected in one of the rows (obviously
in the same column).
If anyone would like more info (and code snippets) please let me know off
list.
Cheers
George in Oxford
|