Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

ASP Insert using the JavaScript Function

What I need is that as the page unloads(or get closed), it inserts all records into the database. The database is built in MS Access. I've even used a slight JavaScript within the code. What modification shall be made in the following code ... ????

<head>
<script language="JavaScript">

      function goVal()
      {
          insertAll(document.forms[0].prod_parent.value,document.forms[0].prod_child.value);
          window.parent.close();
      }

      function insertAll(p,c)
      {
// ----- ASP insert code to be placed here          
      }

</script>
</head>

<body>
<form name="sales" method=post action="Categories.asp">
FName:<input name="fname" size=20>
<br>LName:<input name="fname" size=20>
<br><input type=button value="Submit" onClick="goVal()">
</form>
</body>

Remember the ASP Insert Code must be placed in the function, insertAll().
0
adnan_rais
Asked:
adnan_rais
  • 7
  • 5
  • 3
2 Solutions
 
alorentzCommented:
What makes you think that you can put ASP function in Javascript?  ONly way would be to redirect to page for that:

function insertAll(p,c)
      {
      window.open("submitrecords.asp");      
      }
0
 
adnan_raisAuthor Commented:
thats so simple alorentz........... isn't there another alternate ....????
0
 
alorentzCommented:
>>thats so simple alorentz

WHy make it hard...

>>isn't there another alternate ....????

No, you cannot call ASP with Javascript.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
adnan_raisAuthor Commented:
like such

onUnload="<script>EnterValues()</script>"
0
 
alorentzCommented:
What don't you inderstand....NO...you cannot do it!

You could try XMLHTTP:

<script>
 function insertAll(p,c)
{
     var xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
     xmlhttp.Open("GET", "submitrecordspage.asp?p="+p+"&c="+c, false);
     xmlhttp.Send();
}

</script>

Good luck....that's all i got for ya :)
0
 
adnan_raisAuthor Commented:
any idea...???
0
 
justinbilligCommented:
0
 
alorentzCommented:
justinbillig  - where does it say anything about this in the link?
0
 
justinbilligCommented:
Remote Scripting is a way to call server functions from the client.

It is IE only and it uses a java applet...

there are some other versions of remote scripting that claim to be cross browser but i have never used them so i dont know

http://www.ashleyit.com/rs/
0
 
alorentzCommented:
Yes, I know that...but this was a ASP question.  So I wasn't addressing Java.

Thanks.
0
 
justinbilligCommented:
no you see it uses a java applet you dont program the java applet someone else already has done it ( Microsoft to be exact ) ... its is an answer to your asp question

"ASP Insert using the JavaScript Function"

If you want to do that you can use remote scripting ...

you call an ASP function from javascript code

read throught that article and you'll see what i am saying
0
 
adnan_raisAuthor Commented:
I mafe the code look like such. How to make it executable???? If I check the string using alert function, it displays exact data but doesn't allow to inert the record into database. So any idea ???? The Java session wasn't clearly understood to me. So plz let me know what to change in the following code to allow the data to be entered within the database.

<script language="JavaScript">

        function Insert_Prod(fname_,lname_)
        {
           var str = 'Conn.Execute("';
           str += '<%="insert into ChildProdItems(FName,LName) values('+part+','+child+')"%>';
           str += '")'
<%=str%>
//        alert(str);
        }

</script>

<body onUnload="Insert_Prod('<%=Request("fname")%>',document.forms[0].lname.value)">
<form name=sales method=post>


</form>
</body>
0
 
adnan_raisAuthor Commented:
Sorry the scripting code is as

<script language="JavaScript">

        function Insert_Prod(fname_,lname_)
        {
           var str = 'Conn.Execute("';
           str += '<%="insert into ChildProdItems(FName,LName) values('+fname_+','+lname_+')"%>';
           str += '")'
<%=str%>
//        alert(str);
        }

</script>
0
 
adnan_raisAuthor Commented:
any idea.........??? Why I'm not using XML and Java is that my Web Hosting doesn't support these both platforms. That's why I've to use the code using ASP and JavaScript
 
0
 
adnan_raisAuthor Commented:
Thanx alorentz..... Sorry to say I couldn't get ur code implemented. I've solved the matter in some other way. When I couldn't enter the recods on Unload action, I've to redirect the URL to another window and then get it closed as it loads. Anyhow I'll still grade u points as the solution was quite different from the question being asked. Thanx for all ur support guyz............
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now