Announcement

Collapse
No announcement yet.

Long SQL Statements in Javascript

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

  • 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

  • #2
    Re:Long SQL Statements in Javascript

    YES!

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

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment

    Working...
    X