Not yet. It seemed a little "out there" that it would
work. So I thought I would ask. Someone who really
knows the internals of iBatis would be able to say
yes/no right off.
Rob
--- Larry Meadors <[EMAIL PROTECTED]> wrote:
> Did you try it?
>
> On 5/29/05, Rob Butler <[EMAIL PROTECTED]> wrote:
> > I want to create a statement that performs inserts
> (or
> > updates, or creates tables) that can have the
> table
> > name as well as the number and type of the columns
> > determined at run time.
> >
> > Assume a Map has two entries, tableName and
> records.
> > Records is a List of record objects. Record
> objects
> > have 3 values, fieldName, value and type.
> fieldName
> > is the name of the column, and type is the JDBC
> type
> > of the column. Value is always either a Date,
> Integer
> > (object, not primative), Long (object, not
> primative)
> > or String.
> >
> > So assuming everything above, would the sqlMap
> segment
> > below work?
> >
> > <insert id="insertRecord"
> > parameterClass="java.util.Map">
> > insert into $tableName$
> > <iterate open="(" close=")" conjunction=", ">
> > $records[].fieldName$
> > </iterate>
> > values
> > <iterate open="(" close=")" conjunction=", ">
> > #records[].value#:$records[].type$
> > </iterate>
> > </insert>
> >
> > Thanks!
> > Rob
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
