Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2014
    Posts
    3

    Unanswered: Web Injection Errors

    I am writing a query with a series of unions to help display columns into rows. I am getting a web injection error which I have never come across. I have read all I can on this topic but cannot seem to find the error / solution to my code. Any suggestions?

    Code:
    SELECT
       trainee.name,
       '1' AS Session,
       '1' AS Unit,
       'SITXOHS001B' AS 'Unit Code',
       CASE 
          WHEN tp_sit30707.sitxohs001b_canvas = '1' THEN 'Complete' 
          ELSE 'Canvas Assessment' 
       END AS 'Assessment Due'   
    FROM
       trainee   
    INNER JOIN
       tp_sit30707_trainee_c   
          ON trainee.id = tp_sit30707_trainee_c.tp_sit30707_traineetrainee_idb   
          AND tp_sit30707_trainee_c.deleted = 0   
    INNER JOIN
       tp_sit30707   
          ON tp_sit30707_trainee_c.tp_sit30707_traineetp_sit30707_ida = tp_sit30707.id   
          AND tp_sit30707.deleted = 0   
          AND tp_sit30707.sitxohs001b_dd = 'RCC'   
    INNER JOIN
       tp_sit30707_cstm   
          ON tp_sit30707.id = tp_sit30707_cstm.id_c   
    UNION
    ALL SELECT
       trainee.name,
       '1' AS Session,
       '2' AS Unit,
       'SITXOHS002A' AS 'Unit Code',
       CASE 
          WHEN tp_sit30707.sitxohs002a_canvas = '1' THEN 'Complete' 
          ELSE 'Canvas Assessment' 
       END AS 'Assessment Due'   
    FROM
       trainee   
    INNER JOIN
       tp_sit30707_trainee_c   
          ON trainee.id = tp_sit30707_trainee_c.tp_sit30707_traineetrainee_idb   
          AND tp_sit30707_trainee_c.deleted = 0   
    INNER JOIN
       tp_sit30707   
          ON tp_sit30707_trainee_c.tp_sit30707_traineetp_sit30707_ida = tp_sit30707.id   
          AND tp_sit30707.deleted = 0   
          AND tp_sit30707.sitxohs002a_dd = 'RCC'   
    INNER JOIN
       tp_sit30707_cstm   
          ON tp_sit30707.id = tp_sit30707_cstm.id_c
    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what is reporting this?
    Im not aware of any MySQL error message of this type
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •