Problem with extracting a url from MS SQL Server & displaying it
I've got this really weird error - We store a link to our terms and conditions pdf file in our database which we then display on the bottom of our invoices which are also PDF's - The link either doesn't display or if it does display - It truncates the link
The code is as follows
<cfquery name="companyDetails">
select TermsAndConditions from companyDetails
where company = <companyName>
</cfquery>
Then I display it as follows:
<cfdocument format="pdf"
margintop="0.2"
marginbottom="1"
marginleft="0.9"
filename="#documentName#"
overwrite="yes">
<cfif isDefined("companyDetails.TermsAndConditions")>
<cfdocumentitem type= "footer">
<cfoutput>
<div align="center" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px;">
<strong>Terms and Conditions: #companyDetails.TermsAndConditions#</strong>
</div>
</cfoutput>
</cfdocumentitem>
</cfif>
<cfoutput > ......</cfoutput>
</cfdocument>
The contents of the TermsAndConditions field in the DB looks like this: www.<sitename>.co.uk/default/assets/File/Terms.pdf - We are using MS SQL Server - Any help would be most appreciated - It's currently hard-coded which is a pain because we produce invoices for 2 companies and therefore need to pick up the correct value as they are different
