asterisk users - Sep 2010 - 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,

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-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Neeraj Chand
Sent: Sunday, September 26, 2010 9:09 PM
To: asterisk-users at 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

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