[cisco-voip] UCCX database write help ...

[Biffle, Gerrad]

Anthony Holloway or other UCCX gurus -

I know it's late on a Friday ... but I'm hoping someone can tell me what I might be missing on the following SQL statement for a database write from one of my scripts:

INSERT INTO contactcentersurvey (Purpose,FirstTime,Courteous,Helpful,Outcome,Rate,HearAbout,resourceID,CallingParty,DateTime) VALUES ($Purpose,$FirstTime,$Courteous,$Helpful,$Outcome,$Rate,$HearAbout,$resourceID,$CallingParty,GetDate())

I can see the database schema refreshes, the datasource is setup and test okay, etc. ... but I cannot get my script to write to it.

Thanks.
_________________________________________

Gerrad Biffle, VOIP & Telephony Systems Manager
CGCIO, MCTS
Information Technology
City of Greensboro
300 W. Washington, Greensboro, NC  27401
www.greensboro-nc.gov
_________________________________________


=======================================================
Please note that email sent to and from this address is subject 
to the North Carolina Public Records Law and may be disclosed to 
third parties.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110204/e99944f0/attachment.html>