cfquery and select question

Sabaidee wrote:
> then combine them into one: at least you will be making fewer requests/trips to the database...
>

Thanks. I was able to combine four pages' similar queries into one
query, which I made into an include template. Much easier to work with
now. I just had to add all the Select row names and it works perfectly.

Though I did have to leave two pages' querys out because they used
different SQL statements entirely, but I'm very pleased with the results.

then combine them into one: at least you will be making fewer requests/trips to the database...

What's that part again about having three to ten selects in 4 queries?

Dan Bracuk wrote:
> It depends on:
> Can the tables be joined?
> Will a single query give you the data you need?
> What will run faster (it's not always one query, you gotta test it)

It's all from the same table. There isn't much data, just client info
such as name, website, testimonial, etc.

Yes, a single query will give me all the data I need.

I'm not sure about it running faster, but I don't think it will make a
difference.

Should I leave them separate or join them into one query?

It depends on:
Can the tables be joined?
Will a single query give you the data you need?
What will run faster (it's not always one query, you gotta test it)