Click here to Skip to main content
15,922,533 members
Home / Discussions / Web Development
   

Web Development

 
Generaljavabean: cannot find symbol Pin
Anonymous26-Mar-05 21:36
Anonymous26-Mar-05 21:36 
QuestionHow Can I Send Free E-Mail Using CDONTS Pin
Member 183249126-Mar-05 21:22
Member 183249126-Mar-05 21:22 
AnswerRe: How Can I Send Free E-Mail Using CDONTS Pin
Yulianto.27-Mar-05 14:37
Yulianto.27-Mar-05 14:37 
QuestionWhat would be the best solution Pin
j45mw26-Mar-05 4:08
j45mw26-Mar-05 4:08 
GeneralSpeech application problems on the south of France Pin
Member 167953425-Mar-05 21:03
Member 167953425-Mar-05 21:03 
Generalinclude files and event handling Pin
gagirl_4325-Mar-05 9:06
gagirl_4325-Mar-05 9:06 
GeneralRe: include files and event handling Pin
Roger Wright26-Mar-05 4:14
professionalRoger Wright26-Mar-05 4:14 
GeneralRe: include files and event handling Pin
gagirl_4328-Mar-05 3:43
gagirl_4328-Mar-05 3:43 
GeneralRe: include files and event handling Pin
Jesse Evans23-Mar-06 9:27
Jesse Evans23-Mar-06 9:27 
GeneralRe: include files and event handling Pin
gagirl_4323-Mar-06 13:55
gagirl_4323-Mar-06 13:55 
GeneralRe: include files and event handling Pin
Jesse Evans24-Mar-06 6:03
Jesse Evans24-Mar-06 6:03 
Questionhow to send and receive sms from internet Pin
govindnaroji25-Mar-05 7:23
govindnaroji25-Mar-05 7:23 
Questionasp:button image? Pin
bizjosh25-Mar-05 0:19
bizjosh25-Mar-05 0:19 
General[ASP.net / C#] Checkbox Checked Always false Pin
Jaymz66624-Mar-05 23:57
Jaymz66624-Mar-05 23:57 
GeneralRe: [ASP.net / C#] Checkbox Checked Always false Pin
Jeff Martin28-Mar-05 7:38
Jeff Martin28-Mar-05 7:38 
GeneralRe: [ASP.net / C#] Checkbox Checked Always false Pin
Jaymz66628-Mar-05 21:41
Jaymz66628-Mar-05 21:41 
GeneralRe: [ASP.net / C#] Checkbox Checked Always false Pin
Jeff Martin29-Mar-05 3:13
Jeff Martin29-Mar-05 3:13 
GeneralJavascript for adding html Pin
shaiba24-Mar-05 19:12
shaiba24-Mar-05 19:12 
GeneralRe: Javascript for adding html Pin
Yulianto.27-Mar-05 15:37
Yulianto.27-Mar-05 15:37 
GeneralRe: Javascript for adding html Pin
Anonymous27-Mar-05 17:33
Anonymous27-Mar-05 17:33 
GeneralRe: Javascript for adding html Pin
Yulianto.27-Mar-05 17:47
Yulianto.27-Mar-05 17:47 
GeneralASP.NET VB on DWMX for User Registration page Pin
bizjosh24-Mar-05 17:36
bizjosh24-Mar-05 17:36 
GeneralCSocket & critical sections under IIS 6 Pin
Sorin24-Mar-05 15:48
Sorin24-Mar-05 15:48 
GeneralASP cant read the data from the Access database Pin
Member 145397924-Mar-05 15:39
Member 145397924-Mar-05 15:39 
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
%>
GeneralRe: ASP cant read the data from the Access database Pin
Hesham Amin26-Mar-05 0:53
Hesham Amin26-Mar-05 0:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.