#lisp - Sat 17 Mar 2007 between 15:34 and 15:47

NY Lost Funds



plutonasRiastradh: that kind of pages are a vaste of time anyway, even if they use plain html
nyefI mean, grammatically, "how to X" is, at best, a noun phrase.
slyrusnyef: the annoying thing is that my thread state in signal_emulation_wrapper appears to be hosed
stack alignment issues maybe?
vagifmy question is how to do outer joins with (select [blabla]) instead of (query "babla")
Xachvagif: i don't know, sorry.
nyefslyrus: ... Maybe. I've been semi-wondering about that.
kpreidRiastradh: I'd like to object to that, but I don't know how exactly to put it.
nyefvagif: And that, or a "how can I X" form, is a question.
CinRiastradh, well, it's an example of a user interface that features a lot of movement and navigating through content
vagifok 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 ?
CinRiastradh, Javascript could probably do it, but it'd be a bit slow
actionMaddas 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)
Maddaswonders 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)
robsynnottvagif: 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
vagifrobsynnott: yes, i read that quide, there's nothing about outer joins
nyefvagif: 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
nyefAlternately, something clever with the :FROM parameter.
robsynnottalternatively, you could use query and escape things manually (clsql has an escaping function)
vagifnyef: any example of "clever" with :from ?
robsynnott: could you please tell me the name of that escaping function ?
nyefvagif: Note also that the CLSQL manual refers to the CommonSQL documentation from Lispworks.
vagifi went through ALL commonsql manuals
there's no mention of outer join anywhere
infact i found a library called ystoksql
robsynnotthmm, apparently it actually doesn't have an (exported) one
vagifthat claims that UNLIKE clsql and commonsql it supports outer joins
robsynnottthough kmrcl has an 'add-sql-quotes' function
vagifkmrcl ?
robsynnotta big random collection of utilities
http://www.cliki.net/kmrcl
nyefAh, right. Outer joins aren't standard SQL.
robsynnottnot 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.)
robsynnottI know that php's "addslashes" function isn't, for instance, due to hideous unicode issues
vagifnyef: WHAT ?! outer join is standart sql synthax
nyefvagif: Next you'll be telling me SELECT TOP N * FROM ... is standard.
vagifin fact where a = b for joins is not standart
nyef(Or SELECT ... LIMIT N.)

Page: 2 9 16 23 30 37 

IrcArchive

NY Lost Funds