Re: [asterisk-users] Asterisk ODBC Insert issue

2010-09-26 Thread Tilghman Lesher 
On Sunday 26 September 2010 13:08:43 Neeraj Chand wrote:
> Hi guys,
>
> Having issues with doing an insert statement using ast 1.4.24:
>
> [START]
> dsn=mssql-asterisk
> write=INSERT INTO testdb (callarrival,callerid) VALUES
> ('${VAL1}','${VAL2}')
>
>
> SET(ODBC_START()${TIMESTAMP},${CALLERID(num)})

I'd say you're missing an equal '=' sign.  Without that, nothing is
actually getting executed.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Asterisk ODBC Insert issue

2010-09-26 Thread Tarek Sawah 
DID you grant your user the ability to INSERT into the MSSQL db?
I have asterisk inserting easily
Just a privileges issue
Regards

-Original Message-
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Neeraj Chand
Sent: Sunday, September 26, 2010 9:09 PM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] Asterisk ODBC Insert issue

Hi guys, 

Having issues with doing an insert statement using ast 1.4.24: 

[START]
dsn=mssql-asterisk
write=INSERT INTO testdb (callarrival,callerid) VALUES
('${VAL1}','${VAL2}')


SET(ODBC_START()${TIMESTAMP},${CALLERID(num)})

No errors pop up on execute, but nothing gets inserted. 

Read and update work fine, 

Wondering where I'm going off track with this, 

Thanks, 

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Asterisk ODBC Insert issue

2010-09-26 Thread Neeraj Chand 
Hi guys, 

Having issues with doing an insert statement using ast 1.4.24: 

[START]
dsn=mssql-asterisk
write=INSERT INTO testdb (callarrival,callerid) VALUES
('${VAL1}','${VAL2}')


SET(ODBC_START()${TIMESTAMP},${CALLERID(num)})

No errors pop up on execute, but nothing gets inserted. 

Read and update work fine, 

Wondering where I'm going off track with this, 

Thanks, 

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users