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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

write to a DB

could some one confirm what I am doing is corret, I am trying to insert a value into a database from a variable.

so i have

1) created the SQL database

2) added a column called Number (type = string)

3) created the DSN

4) added a DB read

5) can sucessfully access the database

6) added a string variable called Number default value="12345"

7) added a DB write

8) entered this SQL

INSERT INTO tbl_number (Number) values $Number

9) SQL test returns 0

does not update the table

6 REPLIES
Hall of Fame Super Silver

Re: write to a DB

Make sure that the DSN dbuser has write privilages to that table.

Chris

New Member

Re: write to a DB

it updates if I use this query

INSERT INTO tbl_number (Number) values ('500')

Re: write to a DB

What is the string size in the table? Atleast characters? The syntax is correct. So, it should work if the varchar field size fits the string passed

Re: write to a DB

Also, trace your DB Steps. Then, you can see the actual error in the MIVR log

New Member

Re: write to a DB

I have noticed that the script works fine with int but not with string values, it seems that text in SQL uses single quotes ' ' where CRS uses double quotes " " there must be a way round this?

New Member

Re: write to a DB

Hello,

We just recently received a request to have caller's input saved into an SQL DB as well, and I'm having a bit of trouble getting this done.

Would anyone have a sample IVR script that I could look at to get more familiar with how this can work?

299
Views
0
Helpful
6
Replies