Can you post the full stack trace?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Les Mizzell
Sent: Friday, April 15, 2005 9:07 PM
To: [email protected]
Subject: Re: [CFCDev] One more query question
Roland Collins wrote:
> You forgot to remove the select *!
OK, cleaned up a bit, but it's still tossing a "Too few parameters"
error...
<cfquery name="srch2" datasource="myDATA">
SELECT
color.colorCAT,
color.colorNAME,
color.colorID,
colorLOOKUP.itemNUM,
colorLOOKUP.colorID,
papers.ITEM_NUM,
papers.ID,
papers.PA_TYPE,
papers.PA_CATEGORY
FROM ( color
INNER JOIN colorLOOKUP ON color.colorID = colorLOOKUP.colorID)
INNER JOIN papers ON colorLOOKUP.itemNUM = papers.ITEM_NUM
WHERE papers.ITEM_NUM NOT IN
(SELECT ITEM_NUM FROM papers
WHERE
(ITEM_NAME LIKE '%#FORM.SRCH#%' or
PA_TYPE LIKE '%#FORM.SRCH#%' or
PA_CATEGORY LIKE '%#FORM.SRCH#%' or
PA_COUNTRY LIKE '%#FORM.SRCH#%' or
ITEM_DESC LIKE '#FORM.SRCH# %' ))
AND (color.colorCAT = '#FORM.SRCH#'
OR color.colorNAME = '#FORM.SRCH#' )
</cfquery>
I *will* add cfqueryparam to it once it's working for me properly...
--
-----------
Les Mizzell
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
