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 <jgoer...@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/
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe
