At 11:14 AM 4/3/2001, you wrote:
>They work - both in Access and SQL 2000. Here's the question: is there a
>more efficient way to do the <cfif isDefined>'s using SQL rather than CF? I
>keep reading that as much as possible of the sorting should be done in the
>database rather than CF......
Since you need to determine the existence of these variables prior to doing
the query writing, the answer is no. This will not affect the speed at
which the query runs, either, since the query must be written by CF before
being passed via ODBC/OLE DB/whateverelseyoumightbeusing to the DB.
HTH,
-dhs
Dean H. Saxe
[EMAIL PROTECTED]
AIM: FullFrntlNerdity
http://www.FullFrontalNerdity.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
