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

[Anthony Holloway]

Gerrad,

>From you what you have described, this looks ok.  Have you tried dumbing
down your INSERT statement to a simple:

insert into test_table (col1) values ('value1')


There is a lot going on there, and we don't even know if you have
permissions to write to the table.  Testing a simple insert on a test table
would help us understand.

See if you can also attach an MIVR log for us.

Anthony

On Fri, Feb 4, 2011 at 2:17 PM, Biffle, Gerrad <
Gerrad.Biffle at greensboro-nc.gov> wrote:

>  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.
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110204/01befdf2/attachment.html>