What is wrong with this ASP code? (WXP) [Archive]

rsasalm

01-29-2003, 03:02 PM

Hi all

I have some problem with ASP script.
If someone can help me to point out what I am doing wrong.

Below you can see the code.

It works as follow:
When one click on "Add a customer" button with all fields filled with text, alert
dialogs appear with the text filled in the field and it seems to work fine.
Then I try to open a mySQL database and insert a row with data.
But the alert dialog with text "New customer inserted" never pops up which means
that there is some syntax problem with the statement to open and insert inta
the database. Kan some trace out what is wrong with these line of code.

I have one more question:
As you see that my "myfunction" is written and called in Javascript language.
What changes do I need if the same code for "myfunction" is written in VB and
how to call when "Add a customer" is pressed?

Thanks in advance for your help

regards
/rsasalm

<%@ LANGUAGE="VBSCRIPT" %>

<html>
<head>

<title>init.asp</title>

<script type="text/javascript">

</script>
</head>

<H1> Register a new customer</H1>

<form >
<table border="4">
<tr>
<td>
Namn:</td>
<td> <input type="text" name="Name"> </td>
</tr>

<tr>
<td>
Email:</td>
<td> <input type="text" name="Email"> </td>
</tr>

<tr>
<td>
Telefonnummer:</td>
<td> <input type="text" name="Telefon"> </td>
</tr>

<tr>
<td>
Rabattgroup:</td>
<td>
<select>
<option value ="professional">professional
<option value ="Student">Student
<option value ="unemployed">unemployed
</select>
</td>
</tr>

<tr>
<td>
Password:</td>
<td> <input type="password" name="Password"> </td>
</tr>

</table>
</br>

<input type="submit" name="B1" value="Add a customer">
<input type="reset" onreset/>
</form>
</br>
<script type="text/javascript">

</script>
</body>
</html>

adamdelves

01-31-2003, 03:11 AM

Hi I've just read over the script. It appears you have got ASP and JavaScript a bit mixed up.

ASP is a server scripting language. This means that when you request an ASP page it is first parsed through and interpreter and any ASP scripts are executed. Then the page is sent to the clients web browser. The clients web browser does not have an ASP interpreter. This means that ASP cannot popup a dialog box on the clients screen because all the code is executed on the server. It can however access database and other programs the run on the server. These programs can be used to store and manipulate data. E.g. queries can be execute on an SQL database such as mySQL.

JavaScript on the other hand is and event driven client side scripting language JavaScript code is ignored by the web server unless explicitly told otherwise and sent to the clients browser. The clients web browser has a JavaScript interpreter. This means that JavaScript can respond to events on the web page and display dialog boxes on the clients machine. It cannot however execute server side programs such as databases for security reasons.

It appears that in your script you have tried to add ASP code to a client side Javasctipt function. The caused the Javascript interpreter to crash as no Server object exists in JavaScript.

When embedding ASP code into a asp page it must be enclosed in <% %> tags. This tells the server side ASP interpreter that there is an ASP script to execute. This is an example of an ASP page.
<pre>
<%@ LANGUAGE="VBSCRIPT" %>
<html>
<head>
<title>Hello World</title>
<body>
<% For x = 1 to 6 %>
<h<% = x %>>Hello World</h<% = x %>
<% Next %>
</body>
</pre>
When you view the source in the web browser you’ll see the following:
<pre>
<html>
<head>
<title>Hello World</title>
<body>
<h1>Hello World</h1>
<h2>Hello World</h2>
<h3>Hello World</h3>
<h4>Hello World</h4>
<h5>Hello World</h5>
<h6>Hello World</h6>
</body>
</pre>
As you can see the asp script has gone and all that remains is its output. You there fore need to send the form back to the server and open the database with ASP. You can use the client side JavaScript to validate the data and ensure the client has entered information into all the fields. Here is what your first page should look like:
<pre>
<html>
<head>
<title>init.asp</title>
<script language="Javascript">
function validate (){
if (document.forms[0].elements[0].value == '' || document.forms[0].elements[1].value == '' ||
document.forms[0].elements[2].value == '' || document.forms[0].elements[3].value == '' ||
document.forms[0].elements[4].value == '') {
alert("Some of your Input is missing form cannot be submitted");
return 0;
} else
return 1;
}
</script>
</head>
<body>
<H1> Register a new customer</H1>
<form action="insert.asp" method="post" onSubmit="if (! validate()) return false;">
<table border="4">
<tr>
<td> Namn:</td>
<td> <input type="text" name="Name"> </td>
</tr> <tr>
<td>Email:</td>
<td> <input type="text" name="Email"> </td>
</tr> <tr>
<td>Telefonnummer:</td>
<td> <input type="text" name="Telefon"> </td>
</tr> <tr>
<td>Rabattgroup:</td>
<td> <selectname=”rebbid”>
<option value ="professional">professional
<option value ="Student">Student
<option value ="unemployed">unemployed
</select>
</td>
</tr><tr>
<td>Password:</td>
<td> <input type="password" name="Password"> </td>
</ tr>
</table>

<input type="submit" value="Add a customer">
<input type="reset">
</form>
</body>
</html>
</pre>
When the form is submitted the data entered into is passed to the server and then o the page insert.asp this page can then contain an ASP script which uses the request objects QueryString method to access these data using the names defined in the html document above and enter them into the database:
<pre>
<%
name = Request.Form(“Name”)
email = Request.Form(“Email”)
tel = Request.Form(“Telefon”)
rabbid = Request.Form(“rebbid”)
pwd = Request.Form(“Password”)

DBConn = Server.CreateObject("ADODB.Connection")
DBConn.open ("Shop")
DBConn.Execute("insert into tblcustomer values (1,'mosa','mosa@xyz.com','00-123456',1,'mosa')")
%>
<html>
<head>
</head>
<body>
<h1>New Customer created</h1>
</body>
</pre>
Here you have used both JavaScript and ASP to create a form. Hope this helps.

ADAM