Jeff
Try
select requirements from reqlist where reqid in (&vwhat)
In using ctxt(reqid), it's looking for text values like
('1025','1098',....) - individual items in the list are surrounded by
quotes.
Dawn Hast
Office - (828) 646-2669
Cell - (828) 246-8543
"Jeffrey M. Watson" <[EMAIL PROTECTED]> wrote on 03/13/2008
05:35:51 PM:
> I am trying to find a way to get a select working on a comma separated
> list so I don't have to throw it in a while-loop and parse it. I was
> trying the following (which means it is inherently incorrect)
>
> say my field name Is IDLIST and It contains the values
> '1025,1098,2048,3152'
>
> set var vwhat = '1025,1098,2048,3152'
>
> select requirements from reqlist where ctxt(reqid) in (.vwhat)
>
> where reqid is an integer column in reqlist... is there some way to
> manipulate it like this?
>
> Jeff Watson [EMAIL PROTECTED]
> Tube Methods, Inc.
> 610-279-7700
>
>
