04-20-2006 05:30 AM - edited 03-13-2019 11:42 PM
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
04-20-2006 06:34 AM
Make sure that the DSN dbuser has write privilages to that table.
Chris
04-20-2006 07:24 AM
it updates if I use this query
INSERT INTO tbl_number (Number) values ('500')
04-20-2006 11:55 AM
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
04-20-2006 11:55 AM
Also, trace your DB Steps. Then, you can see the actual error in the MIVR log
04-21-2006 01:04 AM
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?
11-25-2009 08:02 AM
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?
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: