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

IPCC Express - DB Read step with variables

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.

1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Re: IPCC Express - DB Read step with variables

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.

8 REPLIES
New Member

Re: IPCC Express - DB Read step with variables

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.

New Member

Re: IPCC Express - DB Read step with variables

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!

New Member

Re: IPCC Express - DB Read step with variables

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

New Member

Re: IPCC Express - DB Read step with variables

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.

New Member

Re: IPCC Express - DB Read step with variables

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

New Member

Re: IPCC Express - DB Read step with variables

Hi,

Yes, that is correct.

Rob.

New Member

Re: IPCC Express - DB Read step with variables

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

New Member

Re: IPCC Express - DB Read step with variables

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

803
Views
25
Helpful
8
Replies