Thanks to everyone for the help. Using the #ValueList()# function did the
trick.
David Henry
-----Original Message-----
From: Gabriel Roffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 05, 2000 5:32 PM
To: [EMAIL PROTECTED]
Subject: RE: Query Question
You want to use the function ValueList() in the second query
select * from table
where RecordID in (#ValueList(FirstQuery.RecordID)#)
>
> I am using a database query which gets a value from a URL Parameter and
> returns all of the records associated with that Parameter. So
> far, so good.
> Next, I want to use the RecordID from the first query in a second query.
> The problem is that when I try it, I only get the first recordID to appear
> in the Second Query.
>
> Does this make sense? If so, can anyone help.
>
> Thanks,
>
> David
>
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
