---------- Forwarded message ---------- From: Mike McGonagle mjmogo@gmail.com Date: Nov 13, 2007 3:29 PM Subject: Re: [PD-dev] Fwd: Fwd: Fwd: Fwd: Connecting up an SQL Database to PD To: "jamie@postlude.co.uk" jamie@postlude.co.uk
Jamie,
I was just noticing another thread where Hans asked about the [entry] object. Have you tried to use this with your 'psql'? It looks very interesting, although, it does not output as if it were a message. Basically, when I typed in some text...
select id, name from mytable where x = 2;
and it output a list as
list select id\, name from mytable where x = 2\;
yes, the escape characters are there, and there is a comma...
Just a thought. I will try this at home tonight on my stuff...
Thank,
Mike
Mike McGonagle wrote:
I was just noticing another thread where Hans asked about the [entry] object. Have you tried to use this with your 'psql'? It looks very interesting, although, it does not output as if it were a message. Basically, when I typed in some text...
select id, name from mytable where x = 2;
and it output a list as
list select id\, name from mytable where x = 2\;
yes, the escape characters are there, and there is a comma...
That would definitely be useful if we want to separate the db connection and the query handler into two separate classes. It might even be possible to provide the above functionality without using externals. Perhaps an abstraction with:
|44( | [makefilename %c]
and some [list] magic would do the trick...
Jamie