Re: selecting different template based on file name

2009-09-28 Thread Tom Chiverton
On Tuesday 22 Sep 2009, Damo Drumm wrote: > where IINVOICE_Key = #url.invoice# > AND InvoiceTemplateType_Key = 1 > Use CFQUERYPARAM ! Unless you really want someone putting "?invoic

Re: selecting different template based on file name

2009-09-22 Thread Damo Drumm
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: > > >SELECT > IT.Invoic

re: selecting different template based on file name

2009-09-22 Thread Jason Fisher
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: SELECT IT.InvoiceTemplate_FileName, IT.InvoiceTemplateType_Key,

selecting different template based on file name

2009-09-22 Thread Damo Drumm
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. [Macromedia]