I'm using the following syntax to write to a database in a IVR script.
INSERT INTO call_log
The above works fine, However when I substitute the variable name instead of the straight text the write doesn't work.
Is there a syntax issue that I'm missing? All the docs that I find show examples of writing actual values not variables.
I'm substituting the variable name for the values listed above. If I leave the quotes then I get the variable NAME inserted in to the database. If I remove the quotes the insert fails.
Any ideas ?