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? Why the requirement to use the heredoc for the entire query string?
Sean