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
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/