10-12-2006 12:21 AM - edited 03-13-2019 03:21 PM
Wondering if anyone is using executeSQLQuery to do updates as opposed to just reads via select statements?
TIA
10-12-2006 01:41 AM
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.
10-12-2006 05:16 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide