# Perl's DBI::quote functionality?

**URL:** <https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545>\
**Category:** Ruby\
**Created:** [December 6, 2005, 12:30am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545 "2005-12-06T00:30:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![akonsu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/13edae/32.png) [@akonsu](https://www.ruby-forum.com/u/akonsu)\
**Post date:** [December 6, 2005, 12:30am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545/1 "2005-12-06T00:30:23Z")

</div>

hello,

does anyone know of any modules that would allow me to “prepare” sql  
strings? something similar to perl’s DBI::quote?

thanks  
konstantin

---

<div class="post-metadata">

**Author:** ![akonsu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/13edae/32.png) [@akonsu](https://www.ruby-forum.com/u/akonsu)\
**Post date:** [December 6, 2005, 12:58am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545/2 "2005-12-06T00:58:49Z")

</div>

ActiveRecord::Base has ‘quote’ and ‘sanitize’ methods, among others.

---

<div class="post-metadata">

**Author:** ![akonsu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/13edae/32.png) [@akonsu](https://www.ruby-forum.com/u/akonsu)\
**Post date:** [December 6, 2005, 1:39am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545/3 "2005-12-06T01:39:23Z")

</div>

thanks. is this a part of rails?

---

<div class="post-metadata">

**Author:** ![akonsu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/13edae/32.png) [@akonsu](https://www.ruby-forum.com/u/akonsu)\
**Post date:** [December 6, 2005, 1:47am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545/4 "2005-12-06T01:47:29Z")

</div>

> does anyone know of any modules that would allow me to “prepare” sql  
> strings? something similar to perl’s DBI::quote?

Did you check out ruby-dbi?

[http://ruby-dbi.sourceforge.net/](http://ruby-dbi.sourceforge.net/)

Caleb

---

<div class="post-metadata">

**Author:** ![akonsu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/13edae/32.png) [@akonsu](https://www.ruby-forum.com/u/akonsu)\
**Post date:** [December 6, 2005, 4:01am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545/5 "2005-12-06T04:01:22Z")

</div>

On 12/5/05, ako… [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> does anyone know of any modules that would allow me to “prepare” sql  
> strings? something similar to perl’s DBI::quote?

Yes. DBI#quote.

-austin

---

<div class="post-metadata">

**Author:** ![akonsu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/13edae/32.png) [@akonsu](https://www.ruby-forum.com/u/akonsu)\
**Post date:** [December 6, 2005, 1:47am UTC](https://www.ruby-forum.com/t/perls-dbi-quote-functionality/49545/6 "2005-12-06T01:47:29Z")

</div>

On 12/5/05, ako… [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> thanks. is this a part of rails?

ActiveRecord can be used with or without rails. It is in rails by  
default, of course.

Below is an article on how to use it without rails:

[http://wiki.rubyonrails.com/rails/pages/HowToUseActiveRecordOutsideRails](http://wiki.rubyonrails.com/rails/pages/HowToUseActiveRecordOutsideRails)