09-20-2010 12:02 PM - edited 03-14-2019 06:31 AM
I am attempting to create a new record and append new information stored in a variable to a table. I am able to get the script to do a static string but it will not use the value of the string variable I have setup.
For example:
user calls in and inputs their phone number.
script places the number in a variable called PhoneNumber
The DBwrite step attempts to upload and create a new record to table with the phonenumber field populated by the value in the variable PhoneNumber.
INSERT INTO tivr_test
(phonenumber)
VALUES
('PhoneNumber')
Ayn assistance would be welcome and appreciated.
Solved! Go to Solution.
09-21-2010 06:24 AM
Did you try using $PhoneNumber?
09-21-2010 06:24 AM
Did you try using $PhoneNumber?
09-21-2010 08:01 AM
Its the oddest thing. After I originally posted this I did use the
$PhoneNumber statement and it still did not work. I then read somewhere that
IPCC and SQL handle string variables differently and that I would need
to convert the string to and integer in order to do this. I did this but neglected to
change the SQL statement to use the int variable.
I tested and was able to write the string to the
table. It wasnt until I checked the SQL statement that I realized that i was writing a string to the database. I am still investigating why it is now working.
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