From: Martin DeMello <martindemello@...>
Date: 2006-12-19T17:29:38+09:00
Subject: Re: string of strings...

On 12/19/06, Josselin <josselin@wanadoo.fr> wrote:
> I got an array of id's :
>
> ids = [22443, 22468, 22371, 22218, 22472, 22377, 22245]
>
> I would like to get a string of strings (to be used in SQL WHERE..IN  clause
>
> " '22443' , ' 22468' , ' 22371' , ' 22218' , '22472' , '22377' , '22245'  "
>
> If a use  ids.join(','), I get
> "22443,22468,22371,22218,22472,22377,22245" which is obviously not
> useful for SQL....

ids.map {|i| "'#{i}'"}.join(" ,")

martin