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
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
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#
3 matches
Mail list logo