math - ColdFusion 9 - SQL Statement - Boolean Logic -

-

I plugged it on. And this would be a simple little mathematical logic problem. But for my life I can not get it to work properly.

Trying to avoid double booking material in the booking system. Current code ... 

  and schdate = #createODBCDate (schdate) # and (schstart & gt; = #createODBCTime (time) # and actend & lt; = #createODBCTime (actend) #)   
 Basically try to do a check - if say that the start time is 2:00 and ends at 3 o'clock ... I have to check whether I Trying to overlap the book ... Try to say book at 2:15 pm ... stop saying this - conflict  
 Thought this is a mathematical argument - not a coldfusion is ... an air brain today ...  
 Thanx for direct - I think I would have thought this - still test ... seems to work under Dev link is given .  
  and schdate = #createODBCDate (schdate) #and schstart & lt; #contentabacktime (acting) #andactand & gt; #createODBCTime (time) #    
 
 
  Update:  < / P> 
 Below is a little more intuitive of the original query, basically reverse the comparison:  
  where date is column = # requested date # and start time column < # Requested end time #and endtime columns & gt; # Requested start time #   
 
 I remember a great thread on this subject: (ASCII illustration is a good touch :) Assume that your booking does not last for several days, It should work fine for the right time.  
 It is normal view to check each type of conflict:  
     
  •  Overlap: i.e. requested at 9-10, but for 9: 30-11 AM There is a reservation from  
  •  Falls within: the requested time is 10-11 AM, but there is an existing reservation for 9-12 PM  
  •  included: either requested time 12-5PM , But a more elegant approach to the 2 - 3 PM   
     link has been mentioned. Basically, it reduces all those steps for a single filter.    Where EF & gt; = SD and FS & lt; = ED   
     If it finds a match, then you know that there is a conflict. The translation should look like this (untouchable).  
      Select from few columns Columns where # requested time # & gt; = Starttime column and # requested start date # & lt; = End time column and date column # # Requested date #   
      NB:  I deliberately left for clarity  cfqueryparam  obviously I I would suggest using it in your actual query.

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more