Announcement

Collapse
No announcement yet.

Long SQL Statements in Javascript

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • jbartels
    replied
    Re:Long SQL Statements in Javascript

    YES!

    http://www.mirthproject.org/index.ph...9&catid=2#6769

    Leave a comment:


  • Svetlomir Kasabov
    started a topic Long SQL Statements in Javascript

    Long SQL Statements in Javascript

    Hello all,

    I wanted to ask you if there is a way to write long quieries in the Javascript-Transformer that aren't on one line. For example:

    Code:
    SELECT tblnarkosen.Fallnummer, tblnarkosen.Protokollnummer, tblstammdaten.IdExtern, tblebm.LeZiffer, tblebm.inserttime, tblebm.Menge, tblstammdaten.Name, tblstammdaten.Vorname, tblstammdaten.Geburtsdatum 
    FROM (SELECT LeZiffer, inserttime   
    INNER JOIN (tblstammdaten 
    INNER JOIN tblnarkosen ON tblstammdaten.Nummer = tblnarkosen.Nummer) ON tblebm.Protokollnummer = tblnarkosen.Protokollnummer 
    WHERE ((tblebm.statusCodeHL7)>200 AND (tblebm.statusCodeHL7)<300) ORDER BY Protokollnummer
    instead of:

    Code:
    SELECT tblnarkosen.Fallnummer, tblnarkosen.Protokollnummer, tblstammdaten.IdExtern, tblebm.LeZiffer, tblebm.inserttime, tblebm.Menge, tblstammdaten.Name, tblstammdaten.Vorname, tblstammdaten.Geburtsdatum FROM (SELECT LeZiffer, inserttime    INNER JOIN (tblstammdaten INNER JOIN tblnarkosen ON tblstammdaten.Nummer = tblnarkosen.Nummer) ON tblebm.Protokollnummer = tblnarkosen.Protokollnummer WHERE ((tblebm.statusCodeHL7)>200 AND (tblebm.statusCodeHL7)<300) ORDER BY Protokollnummer;
    So I could increase the understandability of my query.

    Thanks a lot for any help!

    Greets,

    Svetlomir

    Post edited by: Svetlomir Kasabov, at: 09/12/2008 08:25
Working...
X