> What do you consider "passing a parameter to the view" to be?
>
This is where Microsoft Access has twisted me :)
Access as you may or may not know allows you to use parameters in a query:
SELECT * FROM table WHERE table.pkey=[Enter The Primary Key];
The bit in [] represents a prompt to the user. They can also be filled in
programatically.
The basic select statement for my problem is going to work as follows:
select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2 from table
where date=SomeDateEnteredByTheUser;
Can I pass SomeDateEnteredByTheUser to Postgres in some way and get back
the set of records I want? If I can is there a way to call this from PHP?
If I can't and end up dynamically writing the query and sumbitting that
to Postgres is this a smart way to do it?
Or should I simply query out the basic values: colA, colB, colC and colD
and then do the calculations within PHP?
Shawn
