[Haskell-cafe] Re: Looking for Haskellers on Windows

[Günther Schmidt]

Hi John,

thx for responding  :)

I'm trying to analyze the HDBC code so that, maybe, I'm able to find the  
spot that's causing me trouble.

Do you happen to have some documentation on how you desigend this?

Also while digging through the code I learned some stuff that I found  
quite interessting. As an example I found the function "executeMany" to be  
part of a data declaration, now that's certainly something I as a newbie  
have never seen before, is there a special name for this technique?

Günther



Am 10.01.2009, 18:12 Uhr, schrieb John Goerzen <jgoerzen at complete.org>:

> Günther Schmidt wrote:
>> Hi Kyra,
>>
>> and again, thanks for taking the effort.
>>
>> Kyra I've tried any sort of values to any sort of columns. I tried  
>> "insert
>> into somesinglecolumntable (someNumbercolumn) values (?)" [toSql 5] ...
>> and so on.
>>
>> So I'm not certain at all the error message does actually give the right
>> clue.
>>
>> It just blows no matter what.
>>
>> What does work though is this:
>>
>> 	run dbc "insert into sometable (someVarcharcolumn) values ('some string
>> value')" []
>
> It is probably good to avoid this.  HDBC does not provide SQL string
> escaping functions because it is designed around the model of the
> replacable parameters, which are more secure and more performant.  You
> will have to be very careful to sanitize input if you do take this  
> approach.
>
> As to the larger question, there are quite a few Windows Haskell users
> out there.  Some well-known Haskell personalities work for a division of
> Microsoft, even.
>
> I am not sure that there are all that many people talking to Access
> databases via ODBC to start with, though, but of course if anybody has a
> patch to contribute, I'd be happy to apply it.
>
> -- John



-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/