| plutonas | Riastradh: that kind of pages are a vaste of time anyway, even if they use plain html |
| nyef | I mean, grammatically, "how to X" is, at best, a noun phrase. |
| slyrus | nyef: the annoying thing is that my thread state in signal_emulation_wrapper appears to be hosed stack alignment issues maybe? |
| vagif | my question is how to do outer joins with (select [blabla]) instead of (query "babla") |
| Xach | vagif: i don't know, sorry. |
| nyef | slyrus: ... Maybe. I've been semi-wondering about that. |
| kpreid | Riastradh: I'd like to object to that, but I don't know how exactly to put it. |
| nyef | vagif: And that, or a "how can I X" form, is a question. |
| Cin | Riastradh, well, it's an example of a user interface that features a lot of movement and navigating through content |
| vagif | ok then, if there's no way to do outer joins with (select) (i could not find any), then next question is, how do you defend against sql injection in clsql ? |
| Cin | Riastradh, Javascript could probably do it, but it'd be a bit slow |
| action | Maddas wonders why people would consider such an interface desirable. (Especially if 'a pretty fast computer', 'lots of colours', and '1024x768 screensize' are system requirements, as stated on the front page) |
| Maddas | wonders why people would consider such an interface desirable. (Especially if 'a pretty fast computer', 'lots of colours', and '1024x768 screensize' are system requirements, as stated on the front page) |
| robsynnott | vagif: I think there is a way to do outer joins, all right. I remember seeing a fairly comprehensive guide to the clsql select syntax somewhere, but can't find it now using clsql's select syntax should protect against injection, more or less; it escapes things passed to it |
| vagif | robsynnott: yes, i read that quide, there's nothing about outer joins |
| nyef | vagif: Just going by the manual, I'd suspect the :SET-OPERATION keyword parameter to SELECT might have something to do with it. |
| vagif | :set-operation is for uinons |
| nyef | Alternately, something clever with the :FROM parameter. |
| robsynnott | alternatively, you could use query and escape things manually (clsql has an escaping function) |
| vagif | nyef: any example of "clever" with :from ? robsynnott: could you please tell me the name of that escaping function ? |
| nyef | vagif: Note also that the CLSQL manual refers to the CommonSQL documentation from Lispworks. |
| vagif | i went through ALL commonsql manuals there's no mention of outer join anywhere infact i found a library called ystoksql |
| robsynnott | hmm, apparently it actually doesn't have an (exported) one |
| vagif | that claims that UNLIKE clsql and commonsql it supports outer joins |
| robsynnott | though kmrcl has an 'add-sql-quotes' function |
| vagif | kmrcl ? |
| robsynnott | a big random collection of utilities http://www.cliki.net/kmrcl |
| nyef | Ah, right. Outer joins aren't standard SQL. |
| robsynnott | not entirely sure whether it's entirely safe in all circumstances, though |
| nyef | (Or, rather, they may be standard SQL, but they aren't universally (or consistently) implemented.) |
| robsynnott | I know that php's "addslashes" function isn't, for instance, due to hideous unicode issues |
| vagif | nyef: WHAT ?! outer join is standart sql synthax |
| nyef | vagif: Next you'll be telling me SELECT TOP N * FROM ... is standard. |
| vagif | in fact where a = b for joins is not standart |
| nyef | (Or SELECT ... LIMIT N.) |