Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Does AXL executeSQLQuery support UPDATE SQL?

Wondering if anyone is using executeSQLQuery to do updates as opposed to just reads via select statements?

TIA

2 REPLIES

Re: Does AXL executeSQLQuery support UPDATE SQL?

It only works with selects. You can only manipulate the call manager db via AXL starting with CCM 5.0 - it has a new AXL command called executeSQLUpdate, which allows you to do inserts, updates and deletes.

New Member

Re: Does AXL executeSQLQuery support UPDATE SQL?

Thanks, was hoping otherwise but had the feeling this was the case. It would have just been alot quicker to update an E164Mask on a line via SQL (which I can still do in Query Analyser or SQL Server EM) than via the updatePhone approach which is just long and convoluted.

Thanks again.

200
Views
5
Helpful
2
Replies
CreatePlease to create content