Yes, the word ACROSS clarifies it.
Besides, i've got another problem escaping SQL.
I want to add this to the SQL sentence:
WHERE b.type LIKE 'L''%'
E.g. all types beggining with an L and following with an apostrophe.
I've escaped the apostrophe writing it twice, but if filter is user input i
need to use a function that escapes any string. DAL does this for us but in
this case i cannot use DAL.
Can i access to the escaping functions of DAL (glueon)?. Something like:
user_escaped = glueon.escaping_function(user_input)
sql = sql + " WHERE b.type LIKE '" + user_escaped + "%'"
I've tested different escaping function without success, and have no idea
how to make use of glueon internal escaping.
Best regards,
Manuel.
El jueves, 27 de junio de 2013 13:53:17 UTC+2, Anthony escribió:
>
> On Thursday, June 27, 2013 7:42:54 AM UTC-4, viniciusban wrote:
>
>> See this: http://web2py.com/books/default/chapter/29/06#Inner-joins
>>
>
> He was asking about joining tables across MySQL schemas.
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
