Olá!
Eu preciso converter um Select feito para MySQL :
StringBuffer query = new StringBuffer( "SELECT cr.id AS chatid, cm.chatRoomId, cm.id, cm.senderId, cm.dateTime, cm.attachFileId, sst.TOOL_ID, GROUP_CONCAT(cm.txtMessage, CONCAT_WS(',',par.name,cm.
dateTime,' ')) AS txtmessage , cm.channelId, cr.laid,cr.coordinator, l.id, l.title, par.name,par.la_fk, ssp.SITE_ID, ssp.PAGE_ID, ssp.PAGE_ID FROM SAKAI_SITE_PAGE AS ssp, SAKAI_SITE_TOOL AS sst, chatmessage AS cm, chatroom AS cr, la AS l, participant AS par WHERE ssp.TITLE = 'Chat' AND l.toolid = '2' AND cr.laid = par.la_fk AND ssp.SITE_ID = l.worksiteid AND cr.laid = l.id AND cm.chatRoomId = cr.id AND ssp.PAGE_ID = sst.PAGE_ID AND cm.dateTime BETWEEN \'");
query.append("\' AND \'") ;
query.append(finalDate);
query.append("\' GROUP BY cm.chatRoomId");
Eu já li vários fóruns sobre HSQL, fiz algumas tentativas mas todas sem sucesso!
O problema é que não encontro nada que pode substituir as funções do MySql: GROUP_CONCAT, CONCAT_WS, e em uma outra consulta o SUBSTRING_INDEX.
Alguém pode me ajudar, please?????????
Agradeço desde já!
Converter Um Select De Mysql Para Hsql
Started By crmclau, 14/05/2010, 15:01
4 replies to this topic
#1
Posted 14/05/2010, 15:01
#2
Posted 12/09/2017, 23:53
Amoxil Bd cialis By Requip Online La Viagra Y Sus Efectos Viagra For .75 A Pill Medsindia cialis Cialis 20mg 12 St Preisvergleich
Ceallas And Viag For Sale cialis Keflex Pregnant Xenical En Ligne Amoxicillin 500mgs cialis Kaufen Viagra Billig
Cephalexin Safety In Pregnancy cialis Free Shipping Stendra Want To Buy No Script Needed
Cialis 5mg Tadalafil Lilly Order Now Bentyl With Free Shipping Drugs
Cephalexin For Dental <a href=http://cialtobuy.com>buy cialis</a> Q Es Propecia
Ceallas And Viag For Sale cialis Keflex Pregnant Xenical En Ligne Amoxicillin 500mgs cialis Kaufen Viagra Billig
Cephalexin Safety In Pregnancy cialis Free Shipping Stendra Want To Buy No Script Needed
Cialis 5mg Tadalafil Lilly Order Now Bentyl With Free Shipping Drugs
Cephalexin For Dental <a href=http://cialtobuy.com>buy cialis</a> Q Es Propecia
#3
Posted 21/09/2017, 12:21
Generic Alternative To Cialis cialis online Info Cephalexin 250mg 400 Mg Metronidazole No Prescription Cialis Ha Funzionato Viagra Compresse Costo cialis online Canadian Pharmacy 24h Catalog
Nizoral Canada cialis Acquisto Levitra Generico
Cialis Vendita On Line In Italia Propecia Side Effects Rash Cialis Original Preis
Similar A Propecia <a href=http://cialtobuy.com>generic cialis</a> Priligy 30 Mg Cuanto Cuesta
Nizoral Canada cialis Acquisto Levitra Generico
Cialis Vendita On Line In Italia Propecia Side Effects Rash Cialis Original Preis
Similar A Propecia <a href=http://cialtobuy.com>generic cialis</a> Priligy 30 Mg Cuanto Cuesta
#5
Posted 26/10/2017, 23:12
My Canadian Pharcharmy Androgel When Will Alli Diet Pill Be Available vardenafil 20 mg.no prescription Do People Overdose On Amoxicillin Cephalexin Online Pharmacy
Can You Have Alcohol With Amoxil viagra Viagra Como Se Toma
Can You Have Alcohol With Amoxil viagra Viagra Como Se Toma
0 user(s) are reading this topic
0 membro(s), 0 visitante(s) e 0 membros anônimo(s)