It seems that i was wrong.. the query works. I was using the wrong method :-/ . So just ignore the mail .
bye Norman Norman Maurer schrieb: > Hi guys, > > after testing a bit more the VirtualUserTableService while workin in the > management stuff i notice that my sqlResource sql statement for derby > not work as aspected. Anyone can tell me how this statement must look > for derby ?: > > select VirtualUserTable.target_address from VirtualUserTable, > VirtualUserTable as VUTDomains where (VirtualUserTable.user like ? or > VirtualUserTable.user like '%') and (VirtualUserTable.domain like ? or > (VirtualUserTable.domain like '%' and VUTDomains.domain like ?)) order > by concat(VirtualUserTable.user,'@',VirtualUserTable.domain) desc limit 1" > > > i tried: > > select VirtualUserTable.target_address,(VirtualUserTable."user" || '@' > ||VirtualUserTable.domain) from VirtualUserTable, VirtualUserTable as > VUTDomains where ((VirtualUserTable."user") like ? or > (VirtualUserTable."user") like '%') and (VirtualUserTable.domain like ? > or (VirtualUserTable.domain like '%' and VUTDomains.domain like ?)) > order by 2 desc > > But this seems not to work. Im a bit lost now :-/ > > bye > Norman > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > !EXCUBATOR:1,4560bfa853072089013839! > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
