4 Replies Latest reply: Dec 16, 2014 6:36 AM by Peter Cammaert RSS

    Do I need quotes or none or ...

    Friedrich Hofmann


      Hi,

       

      actually, what I'm trying to do in this step is very easy:

      - I have a list of bookings from our Database that were done on one specific box.

      - Each of those bookings has a date-time-stamp

      - I have one date-time-stamp and I want to get all bookings on that box that were done before
        => To be able to compare it, I have put the numeric equivalent of that date-time-stamp into a variable
        => In the next LOAD I `have included a WHERE clause, specifying that num([date-time-stamp]) < '$([variable])'

      However, that doesn't work: I do get some bookings - but including the one with that date-time-stamp and that name - I wanted to exclude that and get only those that were done strictly before that (operator < )

      => I thought that it might be because of the quotes and I removed them

      => Then the log said "Garbage after statement"

       

      I post here the last few lines from the log so you know what I am talking about.

       

      16.12.2014 11:17:52: 0600  NoConcatenate
      16.12.2014 11:17:52: 0601  Trans_Dtl2:
      16.12.2014 11:17:52: 0602  LOAD
      16.12.2014 11:17:52: 0603      Tran_Date_v1 as Tran_Date_v4,
      16.12.2014 11:17:52: 0604      User_Signon_v1 as User_Signon_v4,
      16.12.2014 11:17:52: 0605      Tracking_Nr_v1 as Track_Nr_v4,
      16.12.2014 11:17:52: 0606      QUANTITY as Qty_v4
      16.12.2014 11:17:52: 0607  RESIDENT Transaction_Details_pre
      16.12.2014 11:17:52: 0608  WHERE Tracking_Nr_v1 = 'B3D254'
      16.12.2014 11:17:52: 0609  AND num(Tran_Date_v1) < 41974,27712963

      16.12.2014 11:17:52:        4 fields found: Tran_Date_v4, User_Signon_v4, Track_Nr_v4, Qty_v4, 1 lines fetched
      16.12.2014 11:17:54:       Error: Garbage after statement
      16.12.2014 11:17:54:       General Script Error
      16.12.2014 11:17:54:       Execution Failed
      16.12.2014 11:17:54:      Execution finished.

       

      Can anybody help me there?

      Best regards,

       

      DataNibbler