Forum: Ruby array

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Vetrivel V. (Guest)
on 2009-02-20 18:33
In array I have content like this

         a = ["c" , "d", "e" , "f" ]
But I need  like this

          'c','d','e','f'

I want this for my following purpose
      insert into tablename values a .

a has to subtitude in below statement,.
lasitha (Guest)
on 2009-02-20 20:20
(Received via mailing list)
On Fri, Feb 20, 2009 at 10:03 PM, Vetrivel V.
<removed_email_address@domain.invalid> wrote:
> In array I have content like this
>
>         a = ["c" , "d", "e" , "f" ]
> But I need  like this
>
>          'c','d','e','f'
>
> I want this for my following purpose
>      insert into tablename values a .

While the ruby to do that is trivial, i feel its more important that i
point out you should _never_ construct a SQL statement like this -
it's a classic security hole.

http://en.wikipedia.org/wiki/SQL_injection  or just google sql
injection.

Whatever tool you're using to interface with your database, it will
certainly have a safe way to pass parameters into a sql statement.
Please look that up - it will make the world safer and bypass your
original problem to boot :)

Cheers,
lasitha
This topic is locked and can not be replied to.