Does the query work with plain JDBC? In MS SQL "TABLE" is a reserved keyword and should be escaped using "[TABLE]".
Niels -----Original Message----- From: Joachim Hoffmann [mailto:[EMAIL PROTECTED] Sent: woensdag 14 september 2005 19:10 To: [email protected] Subject: example for mapping CHAR(n) to String Could someone point me to an example how to map a limited text field to a string? I couldn't get it to work for CHAR(n).. VARCHAR works fine, but COMMENT CHAR(30) ... insert into TABLE (comment) VALUES (#comment#) ... doesn't work for me. iBaits returns with a "general error" and advises to check the ParameterMap of the insert-statment. Regards, JoHo
