issue in sending query string.

[nirmalsingh]

hai all,

i am using, ajax and c#.net.

my problem is,

i want to store a huge data in database using(c#), which is done in behind the screen. when i get data from a html textarea(more than 2000 characters), and pass to c# page through query string from javascript(ajax). i cant pass the value. what is the solution to do this.

thanx in advance.

with lov
Nirmal

[dmjpro]

hai all,

i am using, ajax and c#.net.

my problem is,

i want to store a huge data in database using(c#), which is done in behind the screen. when i get data from a html textarea(more than 2000 characters), and pass to c# page through query string from javascript(ajax). i cant pass the value. what is the solution to do this.

thanx in advance.

with lov
Nirmal

Simply use "POST" method.

Debasis Jana

[nirmalsingh]

Simply use "POST" method.

Debasis Jana

i am getting permission denied error.

[dmjpro]

i am getting permission denied error.

Post your Code here.

Debasis Jana

[nirmalsingh]

Post your Code here.

Debasis Jana

I pass more than 2000 character field parameter in terms and tried to save.

var termsxmlHttp=null;
//Calling Ajax Page Function
function CallAjax(param,terms,mode,term_id)
{
 
termsxmlHttp=termsGetXmlHttpObject();
if (termsxmlHttp==null)
  {
  alert ("Your browser does not support AJAX!");
  return;
  } 
 
var url="../Ajax_Pages/aj_terms_conditions.aspx";
url=url+"?Ref="+param;
url=url+"&Terms="+terms;
url=url+"&mode="+mode;
url=url+"&terms_id="+ term_id;
url=url+"&sid="+Math.random();
termsxmlHttp.onreadystatechange=termsstateChanged;
termsxmlHttp.open("POST",url,true);
termsxmlHttp.send(null);
//changed
}
 
////
 
function termsGetXmlHttpObject()
{
 var termsGetxmlHttp=null;
  try
    {
    // Firefox, Opera 8.0+, Safari
    termsGetxmlHttp=new XMLHttpRequest();
    }
  catch (e)
    {
    // Internet Explorer
    try
      {
      termsGetxmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
      }
    catch (e)
      {
      termsGetxmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
      }
    }
  return termsGetxmlHttp;
}
 
///
 
function termsstateChanged() 
{ 
    if (termsxmlHttp.readyState==4)
    { 
 
        hideProgressImage("DisplayMsg", "displayError", "btnClose");
        var strArr = new Array();
        strArr =  termsxmlHttp.responseText.split("^");
        document.getElementById("DisplayMsg").innerHTML =strArr[0];
        if (strArr[1]==1)
        {
            document.getElementById("displayError").style.color="Green";
        }
        else if (strArr[1]==2)
        {
            document.getElementById("displayError").style.color="Red";
        }
        document.getElementById("displayError").style.visibility = 'visible';
        document.getElementById("btnClose").style.visibility = 'visible';
        document.getElementById("btnClose").focus();
        document.getElementById("txtRef").value="";
        document.getElementById("txtTerms").value="";
        document.getElementById("terms_id").value="0";
        document.getElementById("hmode").value = "Save";
        CallAjaxList(1,'','','../Ajax_Pages/aj_terms_conditions.aspx');//nirmal from 21
    }
}
 

[dmjpro]

I think you are using IE.
Then enable your Activex Control.

Debasis Jana

[nirmalsingh]

I think you are using IE.
Then enable your Activex Control.

Debasis Jana

yes of course, i'm using ie, how to enable the activex control?

with lov
Nirmal

[dmjpro]

yes of course, i'm using ie, how to enable the activex control?

with lov
Nirmal

Tools->Internet Options->Security Tab->Custob Level->[automatic prompting for activex control=>disable,download activex control=>enable,intialize and script activex ..... =>enable,run activex control=>enable and script activex controls ... =>enable]

Debasis Jana

[nirmalsingh]

Tools->Internet Options->Security Tab->Custob Level->[automatic prompting for activex control=>disable,download activex control=>enable,intialize and script activex ..... =>enable,run activex control=>enable and script activex controls ... =>enable]

Debasis Jana

I have done as u said, but still i am getting unspecified error.

[dmjpro]

I have done as u said, but still i am getting unspecified error.

Do one thing ..... Simply try this code.

try
      {
      termsGetxmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
      }
    catch (e)
      {
      termsGetxmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
      }
 

Actually the error comes from here or somewhere else.
Let me know that please.

Debasis Jana

[nirmalsingh]

Do one thing ..... Simply try this code.

try
      {
      termsGetxmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
      }
    catch (e)
      {
      termsGetxmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
      }
 

Actually the error comes from here or somewhere else.
Let me know that please.

Debasis Jana

thanx jana but,
same thing is done in my posted code line no:38 to 46.
and also refer this link

http://www.webmasterworld.com/forum21/6607.htm

[dmjpro]

thanx jana but,
same thing is done in my posted code line no:38 to 46.
and also refer this link

http://www.webmasterworld.com/forum21/6607.htm

So you have that error from somewhere else.
Right?
So you have the error with "Query String"?
Did you do with "POST" method.

Have a look at this code fragment.

xhreq.open("post", "sumPostForm.phtml", true);
xhReq.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
var query = "param1=paramvalue1&param2=paramvalue2..............................";
xhReq.send(query);
 

Good Luck with this code !

Debasis Jana.

[nirmalsingh]

So you have that error from somewhere else.
Right?
So you have the error with "Query String"?
Did you do with "POST" method.

Have a look at this code fragment.

xhreq.open("post", "sumPostForm.phtml", true);
xhReq.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
var query = "param1=paramvalue1&param2=paramvalue2..............................";
xhReq.send(query);
 

Good Luck with this code !

Debasis Jana.

this is very new for me. can u integrate this code with previously posted code by me, i don't know how to use this.

[dmjpro]

this is very new for me. can u integrate this code with previously posted code by me, i don't know how to use this.

First let me know with that code fragment "ActiveXObject" is working without error.
First let me know that, then I will integrate that one.

Debasis Jana

[nirmalsingh]

First let me know with that code fragment "ActiveXObject" is working without error.
First let me know that, then I will integrate that one.

Debasis Jana

dear jana
code fragment "ActiveXObject" is working without error.

[dmjpro]

dear jana
code fragment "ActiveXObject" is working without error.

One more thing let me know.
Tell me the length of url by alerting that url.
Is that more than "1350"?

alert(url.length); //after setting all parameters how long it is ....
 

If it is then, try this one ..............

termsxmlHttp.open("POST",url,true);
termsxmlHttp.onreadystatechange=termsstateChanged;
termsxmlHttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
termsxmlHttp.send(url);
 

Debasis Jana

[nirmalsingh]

One more thing let me know.
Tell me the length of url by alerting that url.
Is that more than "1350"?

alert(url.length); //after setting all parameters how long it is ....
 

If it is then, try this one ..............

termsxmlHttp.open("POST",url,true);
termsxmlHttp.onreadystatechange=termsstateChanged;
termsxmlHttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
termsxmlHttp.send(url);
 

Debasis Jana

yes, it is more than 1350. that is 2576(according to my parameter i passed to save).

[dmjpro]

yes, it is more than 1350. that is 2576(according to my parameter i passed to save).

Then use my Code.

Debasis Jana

[nirmalsingh]

Then use my Code.

Debasis Jana

sorry jana,
still i am getting unspecified error!

[dmjpro]

Oppssss !
Sorry the code mistyped.

var url="Ref="+param;
url=url+"&Terms="+terms;
url=url+"&mode="+mode;
url=url+"&terms_id="+ term_id;
url=url+"&sid="+Math.random();
termsxmlHttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
termsxmlHttp.onreadystatechange=termsstateChanged;
termsxmlHttp.open("POST","../Ajax_Pages/aj_terms_conditions.aspx",true);
termsxmlHttp.send(url);
 

Now have a try with this.
Good Luck !

Debasis Jana

[nirmalsingh]

Oppssss !
Sorry the code mistyped.

var url="Ref="+param;
url=url+"&Terms="+terms;
url=url+"&mode="+mode;
url=url+"&terms_id="+ term_id;
url=url+"&sid="+Math.random();
termsxmlHttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
termsxmlHttp.onreadystatechange=termsstateChanged;
termsxmlHttp.open("POST","../Ajax_Pages/aj_terms_conditions.aspx",true);
termsxmlHttp.send(url);
 

Now have a try with this.
Good Luck !

Debasis Jana

sorry to say jana.
again the same problem.
unspecified error in ie
and
uncaught error in firefox.

[dmjpro]

sorry to say jana.
again the same problem.
unspecified error in ie
and
uncaught error in firefox.

I am trying to update the "function termsstateChanged()"
Just try this and let me know what happens.

function termsstateChanged()
{
    if (termsxmlHttp.readyState==4 && termsxmlHttp.status==200)
     alert("Ajax Call Done ......... Yahoo!!!");
}
 

Please let me know, whether you get the alert or not?

Debasis Jana

[nirmalsingh]

I am trying to update the "function termsstateChanged()"
Just try this and let me know what happens.

function termsstateChanged()
{
    if (termsxmlHttp.readyState==4 && termsxmlHttp.status==200)
     alert("Ajax Call Done ......... Yahoo!!!");
}
 

Please let me know, whether you get the alert or not?

Debasis Jana

the error occured b4 statechanged function. so no alert displayed.

[dmjpro]

the error occured b4 statechanged function. so no alert displayed.

Try it .............

      function termsstateChanged()
      {
          alert("helllo world");
          if (termsxmlHttp.readyState==4 && termsxmlHttp.status==200)
           alert("Ajax Call Done ......... Yahoo!!!");
      }
 
 

Watch it, how many times "hello world" gets alerted.
Good Luck !

Debasis Jana

[nirmalsingh]

Try it .............

      function termsstateChanged()
      {
          alert("helllo world");
          if (termsxmlHttp.readyState==4 && termsxmlHttp.status==200)
           alert("Ajax Call Done ......... Yahoo!!!");
      }
 
 

Watch it, how many times "hello world" gets alerted.
Good Luck !

Debasis Jana

thanx jana.
i tried but no alert is dsipalyed.

[dmjpro]

thanx jana.
i tried but no alert is dsipalyed.

Send me the code, so far what you tried.

Debasis Jana