ark Henderson [mailto:[EMAIL PROTECTED]
Sent: 16 August 2004 01:15
To: CF-Talk
Subject: RE: Query Manipulation Error in UNION
I've now discovered this is only happening when there are either no gifs or
no jpgs in the specified directory. So I guess I could just check to see if
either director
I've now discovered this is only happening when there are either no gifs or no jpgs in the specified directory. So I guess I could just check to see if either directory listing has a recordset, and merge only if both do.
Regards
Mark Henderson
Web Designer
mailto:[EMAIL PROTECTED] mailto:[EMAIL
I've now discovered this is only happening when there are either no gifs or no jpgs in the specified directory. So I guess I could just check to see if either directory listing has a recordset, and merge only if both do.
Regards
Mark Henderson
Web Designer
mailto:[EMAIL PROTECTED] mailto:[EMAIL
Why not pull them from the database ordered in the first place? SQL
provides the ability to do this readily:
SELECT fields
FROM tables
WHERE conditions
ORDER BY field
If the field that you want to order by is indexed there shouldn't be any
large performance hit.
Jon
There are a number of CF components for sorting queries (including one by
me), with varying features. See
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=query+
and+sortsearch=search. Note that these won't have the advantage of prebuilt
indexes that your database should
]
Para: [EMAIL PROTECTED] [EMAIL PROTECTED]
Fecha: martes 25 de julio de 2000 14:24
Asunto: RE: Query manipulation
There are a number of CF components for sorting queries (including one by
me), with varying features. See
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=query
sure a custom tag will greatly increase performance anyway!
Thanks again!
-Mensaje original-
De: [EMAIL PROTECTED] [EMAIL PROTECTED]
Para: [EMAIL PROTECTED] [EMAIL PROTECTED]
Fecha: martes 25 de julio de 2000 14:24
Asunto: RE: Query manipulation
There are a number of CF
7 matches
Mail list logo