cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
333
Views
5
Helpful
2
Replies

Does AXL executeSQLQuery support UPDATE SQL?

nathan.a.reeves
Level 1
Level 1

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

TIA

2 Replies 2

stephan.steiner
Spotlight
Spotlight

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.

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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: