sql Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

sql Server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-22 : 07:04:20

raja writes "how to insert data from active server page(not in asp.net)to sql server database.i already created a table in sqlserver.but how to write the query using insert.i am sending example code once check it and give the correct answer .and also how to generate auto increment of regid

this is the code i designed

@ Language=VBScript
option explicit



dim sRegNo,sName,sSurName,sDOB,sSex,sMStatus,sPhoneNo
dim sMobileNo,sEmail,sAddress,sPastExp,raRegistration,sSQL
'sRegNo = value(RegNo+1)
sName = Request.Form ("txtname")
sSurName = Request.Form ("txtsname")
sDOB = Request.Form ("txtdob")
sSex = Request.Form ("txtsex")
sMStatus = Request.Form ("txtmstatus")
sPhoneNo = Request.Form ("txtphone")
sMobileNo = Request.Form ("txtmobile")
sEmail = Request.Form ("txtemail")
sAddress = Request.Form ("txtaddress")
'sPastExp = Request.Form ("txtname")

set rsRegistration = Server.CreateObject ("ADODB.Recordset")
sSQL = "INSERT INTO Registrations Values(sName,sSurName,sDOB,sSex,sMStatus,sPhoneNo,sMobileNo,sEmail,sAddress)
rsRegistration.Open sSQL,con
'-- If if user details are added into the database then go to the family details
Response.Redirect "examination.asp?"

<html><head><title>VASANT SCRIBES LTD.</title></head>

<script language="JavaScript">
<!--

function MM_findObj(n, d) { //v3.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); return x;
}

function MM_showHideLayers() { //v3.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; }
obj.visibility=v; }
}

function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

// Form validation

function ValidForm(frmRefister)
{
var flag = 0; // Flag to check for a condition. If the condition is checked, then turn it to 1
var errFlag = 1;
// Flag to check whether an alert is generated, if it is generated, then turn it to 0
if(document.frmRegister.txtname.value == "")
{
if (errFlag == 1)
{
alert("Please enter your name.");
document.frmRegister.txtname.focus();
document.frmRegister.txtname.select();
errFlag = 0;
}
flag = 1;
}
if(document.frmRegister.txtsname.value == "")
{
if (errFlag == 1)
{
alert("Please enter your surname.");
document.frmRegister.txtsname.focus();
document.frmRegister.txtsname.select();
errFlag = 0;
}
flag = 1;
}
if(document.frmRegister.txtdob.value == "")
{
if (errFlag == 1)
{
alert("Please enter your Date of Birth.");
document.frmRegister.txtdob.focus();
document.frmRegist

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-22 : 07:09:56

Refer some basics of SQL here
www.sqlcourse2.com
www.sqlzoo.com

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources