Codeasearch.com - Search your code with us Login | Register | Contact us
  Forums > Asp > Using JScript in ServerSide
forums_reader
Posted on Jul 20, 2007 		Join Date: July 2007
Location: India ( Chennai )
Posts: 24
 
Using JScript in ServerSide  

<%@ Language=JScript%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<title>Simple DataBase Connection in Asp Using JScript in ServerSide</title>
</HEAD>
<BODY>
<%
path = Server.MapPath("dummy.mdb")
con = Server.CreateObject("Adodb.Connection");

con.Provider = "Microsoft.Jet.OLEDB.4.0";
con.Open(path);

rs = Server.CreateObject("Adodb.Recordset");
rs.open("select * from db",con,3,3);

while(!rs.EOF)
{
Response.Write("<a href=js.asp?q="+ Server.URLEncode(rs(1)) +"&id="+ rs(0) +">"+ rs(1) +"</a>");
Response.Write("<br>");
rs.MoveNext
}
rs.Close();


if(Request.Form("q")!="")
{
rs.Open("select * from db where pname='"+Request.Form("q")+"'",con,2,3);
if(!rs.EOF)
{
Response.Write("Already Exists.")
}
else
{
con.Execute("insert into db (pname) values ('"+ Request.Form("q") +"')");
Response.Write("Record has been Added")
}
}
%>

<form method="post">
<input type="text" name="q">
<input type="Submit" value="Submit">
</form>


</BODY>
</HTML>
 Hot Discussion
Go Tech launches Android tablet for Rs 3,999...
Sony targets retailers with quick sales pitches and rew...
Share and discover new activities with Google Schemer...
Samsung gets 9 mn preorders for Galaxy S3: Report...
Google revamps search engine to think like a person...
 
 Discussion Topics
IT News
Php
Javascript
Technology Updates
Asp.Net
MySql
Ajax
Html
Fedora
Software Testing
Asp
Java
General
Flash
Ruby on Rails
 
Copyrights © 2007-2012 Codeasearch Codeasearch.com @ facebook | About us | Contact us | iWannaSearch