08-29-2007 09:59 AM - edited 03-14-2019 01:14 AM
Hi,
Using IPCC Express 4.0.5. I have a DB Read step that is pulling call coverage info from CallManager about particular extensions. Under the "Field Selection" tab I have:
In this case it successfully pulls the info for extension 66960. What I really want is to replace '66960' with a variable that gets set earlier in the script.
Does anyone have experience with this? I can create a String variable called "test." However if I replace '66960' with $test I get a "SQL Statement variable not defined: test" error message.
Any help appreciated.
Thanks - Rob.
Solved! Go to Solution.
09-04-2007 11:48 AM
Can you ceck if you have a carriage return after the variable "test" in the db read step. If so, deleting the same will allow to save the step with variable in the query without any error message.
09-04-2007 11:48 AM
Can you ceck if you have a carriage return after the variable "test" in the db read step. If so, deleting the same will allow to save the step with variable in the query without any error message.
09-06-2007 10:20 AM
Thanks for pointing me in the right direction. I meant to include in my original post that I had defined:
SELECT DNOrPattern, CFADestination,
CFBDestination, CFNADestination FROM NumPlan
WHERE (DNOrPattern = $Test)
As my SQL statement. I didn't look closely, but the Script Editor was actually coming back with an error message something like: SQL statement variable unknown: Test)
The script thought the variable included the trailing parenthesis! I changed my statement to:
SELECT DNOrPattern, CFADestination,
CFBDestination, CFNADestination FROM NumPlan
WHERE (DNOrPattern = $Test )
Note the space between $Test and ). Now it works great. Urrgh!
03-10-2008 01:52 AM
Hi;
Just I would like to know two issues that might help me in understanding this post that really I need it:
1) Are u doing that from the ICM script or from the CRS (ipivr)?
2) These script are written in the SQL server or in the IPCCE? Where exactly?
Any advise?
Regards
Bilal
03-10-2008 09:07 AM
Hi,
Yes, I am doing this in an IP-IVR script, but its very similar to IPCC Express.
So this is not specific to IPCCE. The step I am referring to is a "DB Read" step used in the Cisco CRA Editor used for IP-IVR and IPCC Express.
Rob.
03-11-2008 02:26 AM
Dear Rob;
You mean that the following script was written at CRS at "DB Read" step, correct?
SELECT DNOrPattern, CFADestination,
CFBDestination, CFNADestination FROM NumPlan
WHERE (DNOrPattern = $Test )
Regards
Bilal
03-11-2008 05:36 AM
Hi,
Yes, that is correct.
Rob.
03-11-2008 05:52 AM
OK Rob, that is good. Thanks for ur help.
Do u have idea when to use the ODBC and when to read / write from the DB directly without ODBC?
Any advise?
Regards
Bilal
06-10-2009 09:40 PM
Hi webber
I want to use DB get step in my script can you send me your script using DB get step thanks in advance
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