<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'>
<BR>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.<BR>
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.<BR>
<BR>
thnx in advance<BR> </div></body>
</html>