I had time to try ActivePDF's ToolKit dll file with CF8 and here is how i got it working:

<cfset font = "Arial">
<cfset text = "Text From CFM CODE alsjflkdsfajlkjfd">

<cfscript>
TK = createObject("COM","APToolkit.Object",expandPath('APToolkitNET.dll'));
name = expandPath(TK.getUniqueFileName());
TK.outputPageHeight = 546;
TK.outputPageWidth = 546;
TK.OpenOutputFile(name);
TK.PrintMultilineText(font,16,200,72,400,400,text,'0');
TK.PrintTiff(expandPath("image.tif"),72,72,72,72,'true');
TK.CloseOutputFile();
ReleaseComObject(TK);
</cfscript>

This code creates a unique file that is 546 points square. Then places some text on the PDF and Image on the PDF at the X-Y coordinates that i specify. X and Y are determined from the bottom left of the PDF.

I cant seem to get it working with a createObject() using .net though. Not sure why.

I wanted to union two tables together then do a left join onto another table. Here is what worked for me.

SELECT unionedTables.*, Users.UserName
FROM
(
SELECT IndividualCurrentFiles.*
FROM IndividualCurrentFiles
WHERE StatusWhen = '1/9/2009'

UNION ALL

SELECT VariationCurrentFiles.*
FROM VariationCurrentFiles
WHERE StatusWhen = '1/9/2009'
)

AS unionedTables

LEFT JOIN Users ON unionedTables.ApproveUserID = Users.UserID
ORDER BY JobNum, FileName Asc