Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Custom Function parameters
Mon, Feb 6 2006 9:10 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Can anyone suggest a way of passing a list to be used in an IN statement as a custom function parameter?

eg inside the custom function I want to build a statement like

WHERE Field IN (FunctionParams[3])

Roy Lambert
Mon, Feb 6 2006 11:21 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Can anyone suggest a way of passing a list to be used in an IN statement
as a custom function parameter?

eg inside the custom function I want to build a statement like

WHERE Field IN (FunctionParams[3]) >>

Why not simply as a comma-delimited string ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 6 2006 12:30 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

><< Can anyone suggest a way of passing a list to be used in an IN statement
>as a custom function parameter?
>
> eg inside the custom function I want to build a statement like
>
> WHERE Field IN (FunctionParams[3]) >>
>
>Why not simply as a comma-delimited string ?

Hmm does IN work on a comma delimited string? I'll go and suck it Smiley

Roy Lambert

Tue, Feb 7 2006 11:00 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Hmm does IN work on a comma delimited string? I'll go and suck it Smiley>>

Sure, as long as you're taking the string and building it into the SQL text
dynamically and not trying to use it as a parameter.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image