This content has been marked as final. Show 4 replies
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?