On 2/17/2009 1:18 AM, Tchavdar Paskov wrote:
I also have another question. When i insert my custom query it looks like the profile is loaded successfully but then when i place a call or use
lcr ########## default /which is where i defined the sql query/ and check the console output turns out that the switch is using the default sql guery .
lcr_admin show profiles should show you the profiles loaded and the profile's settings. "default" is a reserved profile name -- I should probably prevent that from loading.
How i can make sure that the custom sql is the only one that is to be executed. /All required fields in the custom sql are in accordance with the requirements - it returns the exact required names and returned field number is also correct/.
Thank you agai for your time Chav
Try running with debug logging turned on (f8 on the console). This will show the sql being passed to the database. == Regarding passing the callerid to the custom sql, let me see what I can come up with...