Best of Talk (06/09/04)

 
Jul 03, 2004

by Dina Hess

Title: Union and Sorting
Date: 06/09/04      (4 Posts)
Summary: Need to sort UNION'd recordsets by the order in which they occur? MySQL developers can add an ORDER BY clause and enclose the SQL statements in parentheses. Alternately, you can try this:
 
SELECT *, 1 as SortOrder
FROM Table1

UNION

SELECT *, 2 as SortOrder
FROM Table2

ORDER BY SortOrder
 
Title: CFMAIL Flagged as Spam
Date: 06/09/04      (18 Posts)
Summary: Is your CFMAIL being targeted as spam? While forged headers may be a problem, SpamAssassin will also detect known non-routable addresses.
Related: Spam: RE: CFMAIL Flagged as Spam
 
Title: MySQL Question
Date: 06/09/04      (21 Posts)
Summary: Considering a MySQL database? Get the download free. Note that you can use MySQL Control Center much like SQL Server's Enterprise Manager.
 

Add a Comment
(If you subscribe, any new posts to this thread will be sent to your email address.)
  
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting