|
I already create the ASP script for the database and also set up the ODBC for the database, why my ASP still can't read the data from the database? Please help me!!!
This is the ASP code:
<form method = "POST" action="online_result.asp" onSubmit="validInput()">
<p align="center">ENTER FIRST NAME:
<input type="text" name="FirstName" size="20">
</p>
<p align="center">ENTER LAST NAME :
<input type="text" name="LastName" size="20">
</p>
<p align="center"> ENTER STUDENT ID:
<input type="password" name="StudentID" size="20">
</p>
<p align="center">
<input type="submit" value="Check In" name="Submit">
<input type="reset" value="Reset" name="Reset">
</p>
</form>
<%
Else
%>
<p align="center"><font face="Comic Sans MS" size="5">
<strong>YOUR RESULT</strong></font>
</p>
<%
Dim SQLString
SQLString = "SELECT student.StudentID, student.FirstName, student.LastName, result.SubjectTaken, result.Grade FROM student, result WHERE student.StudentID = result.StudentID"
If Not Request.Form.Item("StudentID") = "All" Then
SQLString = SQLString & " WHERE result.StudentID=" & chr(39) & Request.Form.Item("StudentID") & chr(39)
End If
If Not Request.Form.Item("FirstName") = " " Then
SQLString = SQLString & " AND result.FirstName=" & chr(39) & Request.Form.Item("FirstName") & chr(39)
End If
If Not Request.Form.Item("LastName") = " " Then
SQLString = SQLString & " AND result.LastName=" & chr(39) & _Request.Form.Item("LastName") & chr(39)
End If
'Create an instance for the Connection Object
Set DatabaseConnection = Server.CreateObject("ADODB.Connection")
'Open Connection to onlineresult database
DatabaseConnection.Open "FILEDSN=Studentresult.dsn"
'Create an instance of the recordset object
Set ResultRecordSet = Server.CreateObject("ADODB.RecordSet")
'Open the onlineresult database and retrieve the data
ResultRecordSet.Open SQLString, DatabaseConnection
Set objResultFirstName = ResultRecordSet("FirstName")
Set objResultLastName = ResultRecordSet("LastName")
Set objResultStudentID = ResultRecordSet("StudentID")
Set objResultSubjectTaken = ResultRecordSet("SubjectTaken")
Set objResultGrade = ResultRecordSet("Grade")
If ResultRecordSet.EOF Then
%>
<p align = "center"><font face ="Arial Black" size="5">
<strong>Sorry. No Records match your search!!!</strong></font>
</p>
<%
Else
%>
<%
<p align = "left"><font face="Arial Narrow" size="3">
<strong>Name: </strong> Response.Write "&objFirstName&" "&objLastName&"
</font>
</p>
<p align = "left"><font face="Arial Narrow" size="3">
<strong>Student ID : </strong> Response.Write "&objStudentID&"
</font>
</p>
%>
<Table border ="2" cellspacing="0" cellpadding="2">
<tr><td>Subject Code</td><td>Grade</td></tr>
<%
Do Until ResultRecordSet.EOF
Response.Write "<tr valign="top"><td>"&objResultSubjectTaken&"</td>
<td>"&objResultGrade&"
ResultRecordSet.MoveNext
Loop
DatabaseConnection.Close
Response.Write "</table>"
End If
End If
%>
|
|
|
|
|
Do you get any errors ?
do your queries work fine when you run them in MS Access ?
|
|
|
|
|
Hello friends
I have the follow html page (do you can copy and save as test.htm, by example)
<div id="divOrigin"><br>
<STYLE> <!-- .Test1 { color: #0000FF; font-weight: bold } .Test2 { color:
#FF0000; font-weight: bold } --> </STYLE><br>
<span class='Test1'>Test1</span><br>
<span class='Test2'>Test2</span> <br>
</div><br>
<div id="divDestination"></div><br>
<SCRIPT type="text/javascript">
<!--
function CopyContents(div1, div2)
{
div2.innerHTML = div1.innerHTML;
}
someDiv = document.getElementById("divOrigin");
otherDiv = document.getElementById("divDestination");
CopyContents(someDiv,otherDiv);
alert(someDiv.innerHTML);
alert(otherDiv.innerHTML);
</SCRIPT>
Please, check the contents of divOrigin, and the 2 alertboxes in Internet Explorer and FireFox...
IE (Alert1):
<STYLE> <!-- .Test1 { color: #0000FF; font-weight: bold } .Test2 { color: <br />
#FF0000; font-weight: bold } --> </STYLE><br />
<span class='Test1'>Test1</span><br />
<span class='Test2'>Test2</span>
IE (Alert2), FireFox(Alert1) and FireFox(Alert2)
<span class='Test1'>Test1</span> <span class='Test2'>Test2</span>
I wish one EXACT COPY of contents from divOrigin to divDestination, but I know not how I can do it works in Firefox and IE... I need what all alerts show equals of IE(Alert1).
Someone can help me?
Loane
|
|
|
|
|
I am writing a web-form using HTML and Javascript. I need to populate another field using a selection of other part of the form. Is there a way to do it? My problem is user selects an option, can I use that data to populate another text box in the same form?
Thanks for your help!
Jamal
|
|
|
|
|
Hello
I m facing a problem in my site that when i click on menu which i build using Dreamweaver. Menu goes into back and combo control appear infront of that menu. Any body please guide me how i control this.
Tariq Mahmood
|
|
|
|
|
I have added the CWebBrowser control to my MFC program. I can Get/Set the URL, but was wondering if it is possible to get hold of some of the data being displayed on the page; e.g. tables elements and current Combo selection.
Don't know if this is the correct forum for this question,
Cheers,
Graham.
grahamfff
|
|
|
|
|
have a 3 tier (biz data and gui layers) web app.
Should I be destroying the BLL or DAL objects after I am none using them?
How come w3wp.exe on the server keeps growing as people use the web app?
Does the fact that none is destroying the objects when they use them have anything to do with it?
We recently moved to the QC box and I am very concerned with the mem usage of w3wp.exe going up as I am testing the site. I am the only user.
Thank you in advance for any advice.
Paixtis
|
|
|
|
|
Actually i am doing a program in JSFL(Flash Javascript).So i
posted the thread here and it's a basic problem.
Suppose,
string = 'welcome to moni\'s homepage'
var i = string.indexOf("\'");
var j = string.indexOf("\'",j);
valueOfString = string.substring(i+1, j);
now valueOfString is welcome to moni
but i need to return it as welcome to moni's homepage.
What should i do?Thanks
|
|
|
|
|
You need a replace function, not a substring function. Probably string.replace("\", "")
Jeff Martin
My Blog
|
|
|
|
|
Monisankar wrote:
Actually i am doing a program in JSFL(Flash Javascript).So i
posted the thread here and it's a basic problem.
Suppose,
string = 'welcome to moni\'s homepage'
var i = string.indexOf("\'");
var j = string.indexOf("\'",j);
valueOfString = string.substring(i+1, j);
now valueOfString is welcome to moni
but i need to return it as welcome to moni's homepage.
What should i do?Thanks
As said, in the previous reply to your question you either need a replace method, or you need to add on the end of the string to the current one.
Ie. valueOfString = string.substring(i+1,j) + string.substring(j+1,stringLength)
I don't know what the string length function in JSFL though...
_____________________
Don't take out the Magic Pen,
Don't draw on the Infinity Board
- Neil Young
|
|
|
|
|
Thanks to both of u.
Got it and solved.
Thanks
|
|
|
|
|
A few months ago, I found an article on making like a class with java script. It forgot the link. Any body knows this article? Thanks.
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
|
You mean this? [^](Use Javascript object like you do it in C#] [http://weblogs.asp.net]
Edbert
|
|
|
|
|
Hi guys,
I searched all over the web for a login script in JAVASCRIPT!! but all i could find is VBscripts. Can someone please help, i desperatly need a JS login script that links to an access database.
Thanks!
|
|
|
|
|
in my web page i put 3radio button one buuton for excel.2nd button for html and last one for pdf.so when user click on the button a save as dilog box will open with corresponding file format.for example if a user choose excel button then a save as dilog box will open with save as type *.xls.i also want to retrieve the full physical path where the user store the file.
how i'll do this in java script plz any body know help me.
with regards
swagatika
|
|
|
|
|
Hello there,
Recently I have been developing Java Applet program. And I am trying to use HTML to design the main page. What I am in doubt is I have a ENTER button. When user press on the ENTER button, the developed Java Applet will be loaded.
However, I dont know what code or line of stuff i need to do to make the above scenario happened. For your information I am using Front Page to create the HTML page and JCreator to do the Applet Program.
Please help!
Thanks,
Lee
|
|
|
|
|
Hi,
I have data retrieved from Oracle into a jsp page where onload i like to append the '$' and '%' symbols along with the data onload. Let me know, if anyone know how to do this.
Thanks,
angel
|
|
|
|
|
Never done any Web development before, but would like my MFC dialog program to interface with Web Pages. The server will obtain data and this data will be displayed on Web Pages.
My 1st question is what should I be looking at to use Edit boxes, push buttons combo list etc on the Web Page to Get/Set various options using these controls. Can I do it with plain HTML, or do I need to use ASP or JavaScripts. I have just started to use HTML, so a good tutorial would be very helpful.
2nd question, how do I get hold of the data on these controls (Edit box, combo list- on the Web Page) in my MFC program. I have placed an ActiveX Web Browser on my main dialog. Currently I can Set/Get the Web Browsers current ULR.
grahamfff
|
|
|
|
|
I assume the web pages you will be creating will be on a web server and not on the local machine. I know some developers put their help section in a web page and make it a part of the installation on the end-user's computer, but this limits you to what can be done. If it is on the server, you can use whatever you like.
The good news is you can do it with plain HTML if your help section is pretty basic. This would give you pages with text and regular hyperlinks. If you want to add in something like a text search or anything like that, you will need to use a back-end language like ASP, PHP, etc. I wouldn't worry about javascript for your situation.
If the files are on a web server, you can start out with raw html and later beef-up the pages with ASP or whatever you want. If you are new to web development, stick to the easy path until you want to add in more things.
|
|
|
|
|
Thanks for your post.
I will be using Visual Studio .Net to produce these Web Pages, but having trouble getting a value from an Edit Box or Combo into say a table on the Web Page. Is that another page?
May be getting confused with MFC C++ events etc
Any good sites/books for getting started, writing simple display Web Pages is OK its the interaction/moving data around.
Thanks.
grahamfff
|
|
|
|
|
When I go to http://localhost I get the error "Bad Request". When I try http://127.0.0.1 I get my local site. My Hosts file has an entry for localhost.
I'm running Windows 2003 / IIS6. I'm going insane.
Anyone have any suggestions?
cheers,
Chris Maunder
|
|
|
|
|
Verify that your site is listening to all addresses on the host. Then check to see if the site is reading the header data for hostname resolution. The problem is most likely to be with the second one.
|
|
|
|
|
Hi,
I want to Save images from a website programatically and not by the "Save Image As..." Option. I have certain websites in my list which provide these images and I want to scrape images from there on to the hard disk.
Any suggestions ?
Thanks.
|
|
|
|
|
Howdy all.
Something that should be incredibly simple I would appreciate some help with.
How do you use the Post method to send data to an asp page without building a form, setting field values and requiring the user to click on a button?
In fact, the only thing that needs to be different from the normal idea of using the "POST" method is that the user shouldn't need to click a button, it should be clicked automatically.
Does this make sense? Can anyone help sort me out?
Cheers all,
Kutz
_____________________
Don't take out the Magic Pen,
Don't draw on the Infinity Board
- Neil Young
|
|
|
|
|
Ok... I'm silly. Don't worry.
I believe the answer is to use javascript.
Ie. Document.formName.submit();
Cheers for reading, if, indeed, you're reading this.
Adios,
Kutz
_____________________
Don't take out the Magic Pen,
Don't draw on the Infinity Board
- Neil Young
|
|
|
|