Displaying 3 results from an estimated 3 matches for "from_date".
2007 Nov 02
3
Date Issues + Oracle + RoR
Hi Experts
I''ve a product like this
ID -> 1
Name -> Xyz
Price -> 30
Created_at -> 02-NOV-07
from_date = Date.new(2, 10, 07)
to_date = Date.new(2, 10, 07)
@product = Product.find_by_sql("select * from products where
created_at between from_date and to_date")
code works perfectly, buy my issue is i dont get any data. always says
no record found
but if i use as like this
from_date = Date...
2009 Feb 22
6
CHECK if param exists? please help
hi folks.
i want to check if a param exists if not to set it to a default value
for my date range filter. in my controller i have:
@from_date = Date.strptime(params[:startdate],"%d/%m/%Y")
@to_date = Date.strptime(params[:enddate],"%d/%m/%Y")
@articles = @results.find(:all,
:conditions => [ "created_at >= ? and
created_at <=?",@from_date,@to_date],...
2009 Dec 14
1
AGI with PHP
...,n,NoOp(Result is : ${callnum})
exten => 111,n,HangUp()
My php file is:
#!/usr/bin/php
<?php
$start = '5';
$mysql_host = 'localhost';
$mysql_user = 'username';
$mysql_password = 'password';
$my_database = 'asteriskcdr';
$dbtable = 'cdr';
$from_date = '20091205000000';
$to_date = '20100104235959';
$callnum = '0';
$minutes = '0';
$query_duration = "SELECT SUM(billsec) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"...