Discussion

To pass a value list in where Clause in ConnectSQL

I have a Value List present on clipboard. I need to bring some records from the database based on the values present in the value list. Could you tell me how could i do this?

***Updated by moderator: Marissa to close post***

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

May 27, 2008 - 9:19am

The query i m using is :

{SQLPage:SQLBrowse}

Select pyStatusWork as ".pyStatusWork"
from pc_work
Where pzInsKey = {pyWorkCover.pxCoveredInsKeys(<CURRENT>)}

But it is not taking the <CURRENT> subscript. Could you tell me any method of doing this?