Page 1 of 1

Preparing Queries: Bind Sql

Posted: Sun Aug 07, 2005 6:39 pm
by raghavan20
I was studying some excerpt from a book and I came across binding sql.
1. How many of you use this concept of using placeholders in the sql statement and the input is/are passed later and which is/are processed and a new query string is formed for execution?

2. Can you give me some link where I can find more information/ discussion regarding the same?

Posted: Sun Aug 07, 2005 6:53 pm
by timvw
Meaby you find more if you search for "prepared statements"

I usually use them via ADOdb (which has also emulation for those dbms that don't support it)

Posted: Sun Aug 07, 2005 7:03 pm
by raghavan20
prepared statements seem to be faster as they are precompiled.
but think they are useful when we are going to use a same query several times across the application; sounds like useful when big applications are developed.