Thanks Larry - that sounds like just the thing.
I'm a bit confused about inline parameters now though - in the sqlmaps pdf
guide, it says that you
can specify types and null values using
#propertyName:TYPE:NULLVALUE#
So if I want to specify an inline parameter with a typehandler and a null
val
Sure, but since I lied to you once ("
I know that dynamic SQL and parameter maps work..." - sorry about
that), you may not believe me. ;-)
Any attributes that you would put in
the parameter map, you can put inline like this:
#myColumn,typeHandlerCallback=someClassOrAlias#
Larry
On 10/28/05, Gare
So it does... Thanks for clearing that up.
That's a bit of an arse as far as my datamodel is concerned though...
In that case, as I'm only using Parameter Maps because I need to specify a
custom type handler,
does anyone know of a way to specify a type handler for a particular column
without u
Hi
In the iBatis-SqlMaps-2.pdf (page 16) it states:
Note! Dynamic mapped statements (described below) only support inline parameters
and do not work with
parameter maps.
Regards
Neil
Quoting g m <[EMAIL PROTECTED]>:
> Well spotted - it appears I pasted the wrong xml
> fragment. My mistake.
> H
Well spotted - it appears I pasted the wrong xml
fragment. My mistake.
Here's the correct one, along with the parameter map
I'm using.
insert into supplierextrastmsupplierextras
( preferredsupplier, contactname, websiteaddress,
companyregno, emailaddress, supplier) values (?, ?,
There is something else going wrong here..
In the stack trace, it shows this message:
"Check the Supplier.insertSupplierExtras-InlineParameterMap"
That tells me that you were running "insertSupplierExtras" with an inline parameter map.
But the statement sent was "updateSupplierExtras" with an
Before acting on this e-mail or opening any attachments you are advised to read
The Caudwell Holdings group of companies' disclaimer at the end of this e-mail.
===
I'm trying to write insert/update statements that can have their table
dynamical
