ASP using javascript instead of VBScript

Hey all, does anyone know of some good sites with tutorials on how to use javascript for server-side script?

Thanks
-Matt

Try this site!

Planet Source Code

You talking about JSP? I havnt seen any articles on that at PSC..... oh well, I know now

And I think its Java, not JavaScript

No, i am actually talking about using the javascript as the serverside language, but on Microsofts ASP technology (not JSPs which use java). I know this isnt common and the vast majority is done by VBScript..

Thanks
-Matt

<% LANGUAGE="JavaScript" %> Should do the trick.

Thanks parksie, i realize this.. but what i am looking for is a tutorial or examples of database connectivity and dealing with the request and response objects with javascript..

Thanks
-Matt

Oops sorry :)

Quote:

ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (JScript)
[This is preliminary documentation and subject to change.]
This example uses the ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction properties to execute a stored procedure. Cut and paste the following code to Notepad or another text editor, and save it as ActiveConnectionJS.asp.


<%@LANGUAGE="JScript"%>
<%// use this meta tag instead of adojavas.inc%>


<html>
<head>
<title>ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties</title>
<style>

</style>
</head>

<body bgcolor="White">

<%
var iRoyalty = parseInt(Request.Form("RoyaltyValue"));
// check user input

if (iRoyalty > -1)
{
// connection and recordset variables
var Cnxn = Server.CreateObject("ADODB.Connection")
var strCnxn = "Provider=sqloledb;Data Source=" + Request.ServerVariables("SERVER_NAME")+ ";" +
"Initial Catalog=pubs;User Id=sa;Password=;"
var cmdByRoyalty = Server.CreateObject("ADODB.Command");
var rsByRoyalty = Server.CreateObject("ADODB.Recordset");
var rsAuthor = Server.CreateObject("ADODB.Recordset");
// display variables
var filter, strMessage;

// open connection
Cnxn.Open(strCnxn);

cmdByRoyalty.CommandText = "byroyalty";
cmdByRoyalty.CommandType = adCmdStoredProc;
cmdByRoyalty.CommandTimeOut = 15;

// The stored procedure called above is as follows:
// CREATE PROCEDURE byroyalty
// @percentage int
// AS
// SELECT au_id from titleauthor
// WHERE titleauthor.royaltyper = @percentage
// GO

prmByRoyalty = Server.CreateObject("ADODB.Parameter");
prmByRoyalty.Type = adInteger;
prmByRoyalty.Size = 3;
prmByRoyalty.Direction = adParamInput;
prmByRoyalty.Value = iRoyalty;
cmdByRoyalty.Parameters.Append(prmByRoyalty);

cmdByRoyalty.ActiveConnection = Cnxn;

// recordset by Command - Execute
rsByRoyalty = cmdByRoyalty.Execute();

// recordset by Recordset - Open
rsAuthor.Open("Authors", Cnxn);

while (!rsByRoyalty.EOF)
{
// set filter
filter = "au_id='" + rsByRoyalty("au_id")
rsAuthor.Filter = filter + "'";

// start new line
strMessage = "<P>";

// get data
strMessage += rsAuthor("au_fname") + " ";
strMessage += rsAuthor("au_lname") + " ";

// end line
strMessage += "</P>";

// show data
Response.Write(strMessage);

// get next record
rsByRoyalty.MoveNext;

}

//clean up
rsByRoyalty.Close;
rsAuthor.Close
Cnxn.Close
}
%>

<hr>

<form method="POST" action="ActiveConnectionJS.asp">
<p align="left">Enter royalty percentage to find (e.g., 40): <input type="text" name="RoyaltyValue" size="5"></p>
<p align="left"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
 

</body>

</html>

Isn't JScript supposedly faster than VBScript?

yeah, and JScript, and java script are not the same thing!

here, this site is and interesting article about JScript VS. VBscript

http://msdn.microsoft.com/library/de...tml/vbsvjs.asp

It's written by microsoft though...:rolleyes:

Not the same... JScript was from Microsoft and Javascipt was developed by Netscape..

another question should be asked.. is Jscript as widely used as javascript? will browsers like Netscape and Opera support it the same way as javascript is supported?

-mcd

JScript might as well be JavaScript.

Technically IE doesn't support javascript, it supports JScript. JScript has many more capabilities than javascript, and is a lot like VBScript.