Query Syntax

[Bigjjames]

HI,

Can someone give me a few poitners on the most efficient uses of QUERY.... e.g
if there are several query's on one page would it be best to group into one and
and ref all fields from that one, how does the DB (Access) deal with the
query's best? etc tec

thanks

[Syncopation]

It depends on what type of query you're doing. It may be easier for you to put
all your queries/functions in one file (*.CFC) and call that page using the
<cffunction> tag. You can combine all your queries into one if you are simply
getting data from a specific table also. just pass in the variables necessary
and do something like this:

<cfquery name="get#TableName#" datasource="myAccess">
SELECT *
FROM #TableName#
</cfquery>