I did not actually use "TABLE" as name for a table, and I'm aware of
reserved words.
I just replaced the strange sounding table names with a place holder, in
order to create
a more readable sample of pseudo-SQL.
JoHo
Niels Beekman wrote:
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
