Help with this error

  • jadwalke

    SSC Rookie

    Points: 25

    I am trying to determine a problem in some software I'm running:

    I type the following:

    Select

          *

    From

          ILT_ProductAssignment pa

          left outer join ILT_BadgeInfo bi on pa.ProductAssignmentID = bi.ProductAssignmentID

    Where

          OrderNumber = '563'

    I get the following error:
    Msg 102, Level 15, State 1, Line 2
    Incorrect syntax near ' '.

    I have attempted to remove the single quotations, add double quotations remove the space between the = and 563.  Still get the same error. Also tried

    Select

          *

    From

          ILT_ProductAssignment

    Where

          OrderNumber = '563'

     

    Same thing?  Can anyone identify what I've been doing wrong?  Thanks

  • Thom A

    SSC Guru

    Points: 98272

    jadwalke - Monday, September 17, 2018 11:56 AM

    I am trying to determine a problem in some software I'm running:

    I type the following:

    Select

          *

    From

          ILT_ProductAssignment pa

          left outer join ILT_BadgeInfo bi on pa.ProductAssignmentID = bi.ProductAssignmentID

    Where

          OrderNumber = '563'

    I get the following error:
    Msg 102, Level 15, State 1, Line 2
    Incorrect syntax near ' '.

    I have attempted to remove the single quotations, add double quotations remove the space between the = and 563.  Still get the same error. Also tried

    Select

          *

    From

          ILT_ProductAssignment

    Where

          OrderNumber = '563'

     

    Same thing?  Can anyone identify what I've been doing wrong?  Thanks

    Line 2 implies the line containing the *. Do you have a hidden special character there, something invisible to the user? The only things that should be before the * is a tab or white space. Perhaps delete the white space and hit space 4 times instead of tab; does that do the trick?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • jadwalke

    SSC Rookie

    Points: 25

    Yes that worked!

    Thanks so much!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply