Re: Query Formulation Question

> operationsengineer1(at)yahoo(dot)com wrote:
> > consider the following simplified queries (php
> using
> > heredoc):
> >
> > $sql_1 = <<<_EOSQL
> >
> > select count(inspect)
> > from t_inspect, t_product, t_test_area
> > where t_product.product_num = 1
> > and t_test_area.id = 5
> >
> > _EOSQL
> >
> > $sql_2 = <<<_EOSQL
> >
> > select count(inspect)
> > from t_inspect, t_product, t_test_area
> > where t_product.product_num = 1
> >
> > _EOSQL
> >
> > what is the best way to handle both of these cases
> in
> > one statement?
>
> You are using a programming language--why not
> construct the query on the
> fly?

the simple answer is i don't know how. btw, that's
the complex answer, too. ;-) can you share a quick
example?

> Why the requirement to use the heredoc for the
> entire query string?

that's not a requirement. i like the heredoc format
for readability and ease of c&p to pgadmin3's query
executer. however, i'm not married to it and will use
another option when i have a good reason.

based on your comments, i could use a heredoc for the
base query and then check to see if i need to
concatenate the where statement to it. i think that
will work.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com