<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
thnx Anthony let me work on these steps and will share a result.<BR>
<BR>
<BR>
<DIV>
<HR id=stopSpelling>
Date: Wed, 2 Nov 2011 11:52:45 -0500<BR>Subject: Re: [cisco-voip] SQL Query Rolls back Using UCCX DB Nodes<BR>From: avholloway+cisco-voip@gmail.com<BR>To: shaary1@hotmail.com<BR>CC: cisco-voip@puck.nether.net; cisco-voip-bounces@puck.nether.net<BR><BR>
<DIV>Hi Shary,</DIV>
<DIV> </DIV>
<DIV>*First off, did you mean to leave out the "$" on your insert statement? That could be the problem.</DIV>
<DIV> </DIV>
<DIV>Just like with any troubleshooting, you'll want to break things down a bit, in an effort to isolate the problem.</DIV>
<DIV> </DIV>
<DIV>1. Focus on select statement first</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV>a. Can you read the table directly via a tool like query analyzer?</DIV>
<DIV>b. Can you read the table from a remote machine via a tool like <A href="http://www.squirrelsql.org/" target=_blank>SQuirreL</A>?</DIV>
<DIV>c. Can you read the table from a simple UCCX script and via active debugging (no variables, hard coded values)?</DIV>
<DIV>d. Can you read the table from a simple UCCX script and via active debugging (using variables for your values)?</DIV></BLOCKQUOTE>
<DIV>2. Now focus on the insert statement</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV>a. Can you modify the table directly via a tool like query analyzer?</DIV>
<DIV>b. Can you modify the table from a remote machine via a tool like SQuirreL?</DIV>
<DIV>c. Can you modify the table from a simple UCCX script and via active debugging (no variables, hard coded values)?</DIV>
<DIV>d. Can you modify the table from a simple UCCX script and via active debugging (using variables for your values)?</DIV></BLOCKQUOTE>
<DIV>Knowing the answer to these questions will help you to isolate where the problem might be.</DIV>
<DIV> </DIV>
<DIV>A couple of other troubleshooting suggestions if needed:</DIV>
<DIV>Create a new database and table for testing (make these as simple as possible)</DIV>
<DIV>Connect to a different database server for testing (MySQL, PostgreSQL, DB2, etc.)</DIV>
<DIV> </DIV>
<DIV>Anthony
<DIV> </DIV>
<DIV> </DIV></DIV>
<DIV class=ecxgmail_quote>On Wed, Nov 2, 2011 at 6:36 AM, shary shary <SPAN dir=ltr><<A href="mailto:shaary1@hotmail.com">shaary1@hotmail.com</A>></SPAN> wrote:
<DIV> </DIV>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; PADDING-LEFT: 1ex" class=ecxgmail_quote>
<DIV>
<DIV dir=ltr>
<DIV>hi all, i am facing a very strange issue in uccx while Reading or writing data into SQL DB from uccx DB Read and Write query.</DIV>
<DIV>For Read i am using the query "select * from tble where fil1=$customerinput" and for write "INSERT into tble (field1) Values (customerinput)" . When i test these queries it displays 1 row alterred while in at SQL side i can't see any new data. The DB guys are saying they are getting insert request from uccx but it rolls back intead of Commit. Same thing when i try to Read the data the call goes into success node but then from DB get node it passes from unsuccessful. Variable types are same at both side. What could e the issue. We are usign SQL ODBC connector. Your prompt will be appreaciateble.</DIV>
<DIV> </DIV>
<DIV>thnx in advance</DIV>
<DIV> </DIV></DIV></DIV>
<DIV>_______________________________________________</DIV>
<DIV>cisco-voip mailing list</DIV>
<DIV><A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV>
<DIV><A href="https://puck.nether.net/mailman/listinfo/cisco-voip" target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A></DIV>
<DIV> </DIV>
<DIV> </DIV></BLOCKQUOTE></DIV>
<DIV> </DIV></DIV> </div></body>
</html>