You can't use parameters in the select list, but you can use literals. insert into AnObject(First, Second, Third) select First, Second, 'Literal String' from AnotherObject
Diego On Fri, Jun 11, 2010 at 15:37, MSD <[email protected]> wrote: > Can we use parameters in an Insert Select hql that would be executed > using ExecuteUpdate. The parameter is to be used in the Select part > for example: > "insert into AnObject (first, second, third) > select from AnotherObject (first, second, :paramThird)" > > the we use SetParameter to set paramThird. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
