Re: selecting different template based on file name

On Tuesday 22 Sep 2009, Damo Drumm wrote: where IINVOICE_Key = #url.invoice# AND InvoiceTemplateType_Key = 1 /cfquery Use CFQUERYPARAM ! Unless you really want someone putting

selecting different template based on file name

Hi im having trouble with the below piece of code, im trying to set it up to add the correct template as a watermark based on the filename in the database in field (INVOICE_PDFFile) can anyone help me out? at the minute im getting this error message - Error Executing Database Query.

re: selecting different template based on file name

The error means that InvoiceTemplateType_Key is a column in both tables, so you have to let the database know which one you actually want. Use your table aliases: cfquery name=qgetcreditnotetemplate datasource=#request.dsn# SELECT

Re: selecting different template based on file name

Hi Jason Ive tried that but Im still getting the same error The error means that InvoiceTemplateType_Key is a column in both tables, so you have to let the database know which one you actually want. Use your table aliases: cfquery name=qgetcreditnotetemplate datasource=#request.dsn#