Displaying 4 results from an estimated 4 matches for "sqlcmd".
Did you mean:
sqlca
2003 Jul 11
4
module : cdr_sybase.so
...static struct tm _date(struct timeval tv)
{
struct tm tm;
time_t t;
t = tv.tv_sec;
localtime_r(&t,&tm);
return tm;
}
static int sybase_log(struct ast_cdr *cdr)
{
struct tm tm, end, start, answer;
struct timeval tv;
struct timezone tz;
char *sqlcmd, timestr[128], timestart[128], timeend[128], timeanswer[128];
time_t t;
sqlcmd = (char *)malloc(2048);
memset(sqlcmd,0,2048);
start = _date(cdr->start);
end = _date(cdr->end);
answer = _date(cdr->answer);
gettimeofday(&tv,&tz);
t = tv.tv_sec;
localtime_r(&...
2010 Mar 08
2
using sprintf to pass a variable to a RMySQL query
Hello,
I am using RmySQL and would like to iterate through a few queries.
I would like to use sprintf but I think I'm having problems mixing and
matching the sprintf syntax and the SQL regex.
I have checked my sqlcmd and it works when I wan to match %MG1% but how
do I iterate for i 1-72? Escape characters,?
thanks in advance
i<-1
sqlcmd_ScaffLen<-sprintf('SELECT scaffold.length
FROM scaffold,scaffold2contig,contig2read
WHERE scaffold.scaffold_id=scaffold2contig.scaffold_id AND
scaffold2contig.conti...
2005 Mar 21
0
Cdr_odbc asterisk 1.0.6
Asterisk Ready.
*CLI> -- Executing route("SIP/7408-02e3", "370263") in new stack
-- odbcquery: query=370263
> Query = 370263 : SQLcmd = select routing, ring_timer from ddi_pool
where ddi_inbound = '370263'
Urgent handler
> app_route: Query Successful!
-- Varname= 55
-- odbcquery: set route 721017101
-- odbcquery: set timer 15
Urgent handler
-- Executing Dial("SIP/7408-02e3", "OH32...
2008 Sep 10
3
Write Asterisk CDR MySQL records to multiple servers
Hi to all, I actually have an asterisk server configured to write CDR mysql
records in the same machine (localhost), but I want to write this records to
another machine also in mysql at the same time, It is possible? It means
that I want save the records in both machines.
Thanks in advance.
Ricardo Melendez
-------------- next part --------------
An HTML attachment was scrubbed...
URL: