5
Sorry for my bad english
Quote:
Dave_L wrote:
Don't the XOOPS object and criteria classes already accomplish this?
No
Actually all query is construct when we need it.
All query are a constructed string.
We don't have some thing like this
SELECT * FROM table WHERE Id=? and param to put in after like we can have PRO*C (C with preprocessor Oracle)
We constuct a string like this
SELECT * FROM table WHERE Id=1
and this query is not the same at
SELECT * FROM table WHERE Id=2
then the SQL engine don't say it the same query then he calculate another time the optimize parse etc...
If you have this
SELECT * FROM table WHERE Id=? with param to passe the query is the same then we gain time of optimize parse.
It's work like that in Oracle.
Criteria just construct a String, it just put String from name of column and add string of the value you have, and add couple of column name, and value. Value is a print of $value
Like this :
colomnname = 'value' AND colomname2 = 'value2'
Criteria don't put
colomname = ?param1 AND colomname2 = ?param2
