You are right Steve, Thanks so much!! I really appreciate it...THanks
everyone for helping out...
Steve Onnis wrote:
> Your first CFIF says...
>
>
>
>
> and your second one says
>
>
>
> Obviously the first query isnt running because "Confirmed" does not equal
> "", it equals "CONFIRM" so
Your first CFIF says...
and your second one says
Obviously the first query isnt running because "Confirmed" does not equal
"", it equals "CONFIRM" so when the second query gets run the query named
"SelectedOrders" does not exist.
Steve
--~--~-~--~~~---~--
Here's my code syntax- I have tried to use spaces to make it more
readable...
Basically there is an IF condition and the complicated sub query, then
there is another IF condition and i am using the ValueList function in
this query here..
SELECT SALESHEADER.SalesHDRID, ACCOUNTS_1.ParentAccoun
The argument for ValueList is..
ValueList(queryName.columnName)
The error suggests that the query name you are passing in ( SelectedOrders )
is not a query. This value is the value you use for the "name" attribute of
the cfquery tag.
So...
SELECT myColumn
FROMMy
ok i tried the ValueList syntax as per Steve Onnis, but i get an error
message -
"The ValueList() function has an invalid parameter:
SelectedOrders.SalesHDRID.
Parameter 1 of function ValueList which is now
(SelectedOrders.SalesHDRID) must be pointing to a valid query name."
'SelectedOrders' is
Make you complicate query a database view
On 12/11/2008, Khush <[EMAIL PROTECTED]> wrote:
>
>
> How do i reference a field (SalesHDRID) from a query (called
> SelectedOrders) in the where condition of another query.
>
> My CF query looks somewhat like this-
> SELECT salesdetail.packerid
> F
SELECT salesdetail.packerid
FROM SALESDETAIL
WHERE SALESDETAIL.SalesHDRID IN
(#ValueList(SelectedOrders.SalesHDRID)#)
That will output all the items returned from that column into your query
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Be
