Displaying 2 results from an estimated 2 matches for "since_date".
2008 Mar 14
2
MySQL IN clause for an array of strings
...ips_clause.blank?
zips_clause += ''\'''' + z + ''\'''' # wrap string in single-quotes
}
zips_clause = ''('' + zips_clause + '')''
conditions = sanitize_sql(["updated_at > ? AND local_code IN ?",
since_date, zips_clause])
This is the resulting SQL:
SELECT * FROM tips WHERE (updated_at > ''2008-03-14 11:55:29'' AND
local_code IN ''(\''94952\'',\''08054\'',\''11111\'')'')
And this is the error:
Mysql::Error: You have...
2009 Aug 03
1
use gnulib, and begin to pass its "make syntax-check" tests
...{
- # Convert each single quote to '\''
- $s =~ s/\'/\'\\\'\'/g;
- # Then single quote the string.
- $s = "'$s'";
- }
- return $s;
-}
-
-sub quoted_cmd(@)
-{
- return join (' ', map {shell_quote $_} @_);
-}
-
-{
- my $since_date = '1970-01-01 UTC';
- GetOptions
- (
- help => sub { usage 0 },
- version => sub { print "$ME version $VERSION\n"; exit },
- 'since=s' => \$since_date,
- ) or usage 1;
-
- my @cmd = (qw (git log --log-size), "--since=$since_date",
-...