<< Previous 5    Next 5 >>
<:::  28-Jan-2010
Clear Sort By     <CF>      :::>
ActivePDF and Coldfusion

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">

TK = createObject("COM","APToolkit.Object",expandPath('APToolkitNET.dll'));
name = expandPath(TK.getUniqueFileName());
TK.outputPageHeight = 546;
TK.outputPageWidth = 546;

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.

<:::  28-Jan-2009
Clear Sort By     <CF>      :::>
SQL - how to left join on two unioned tables

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
SELECT IndividualCurrentFiles.*
FROM IndividualCurrentFiles
WHERE StatusWhen = '1/9/2009'


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

AS unionedTables

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

<< Previous 5    Next 5 >>

All designs and original content posted on these pages are Copyright © 2006 Chad Gray, All Rights Reserved. No part of this website may be reproduced in any form without written or email consent from the author. These designs are free for non-commercial use.