Printable View
I am trying to create a page where it has my database that I have already created. I guewss it requires javascript to do this and it also requires me to connect the database to a web page. I have the code and I think it is connected, but it doesn't work properly. Any ideas?
Thank you
Care to post the code here? AFAIK, it's not possible to connect to a database using HTML/Javascript.Quote:
Originally posted by rgyankees23
I am trying to create a page where it has my database that I have already created. I guewss it requires javascript to do this and it also requires me to connect the database to a web page. I have the code and I think it is connected, but it doesn't work properly. Any ideas?
Thank you
I can't post the code, so how can i get it to you or on here...
What does AFAIK mean?
and thirdly,
The Book, Beginnning JavaScript, pages 694 from Chapter 16 has a section called, "Accessing Databases from a web page."
But if it isn't possible then what over way can I do it....
You can PM it to me, if you'd like.Quote:
Originally posted by rgyankees23
I can't post the code, so how can i get it to you or on here...
As Far As I KnowQuote:
What does AFAIK mean?
THe reason you can't do it is because you're attempting to do it client side. Javascript can access databases, but if it is running as a server side script. If you check Chapter 16, it might mention it somewhere in the beginning itself. For example, if you have PWS or IIS on your machine, you'll be able to use that code.Quote:
and thirdly,
The Book, Beginnning JavaScript, pages 694 from Chapter 16 has a section called, "Accessing Databases from a web page."
But if it isn't possible then what over way can I do it....
OK, the code you have posted will work, only server side, as mentioned before. This means that your server must be configured to support and execute ASP scripts. For this, you need a web server such as PWS or IIS.Quote:
Originally sent from rgyankees23 to mendhak
I have nmo idea what that means
Here is the code....
//
<center>2003 New York Yankees Schedule</center>
<table border=1>
<thead>
<tr>
<th>GameID</th>
<th>GameDate</th>
<th>GameTime</th>
<th>TeamA</th>
<th>TeamB</th>
</tr>
</thead>
<%
var adoConnection = Server.CreateObject("ADODB.Connection");
var adoRecordset;
var mySQL;
adoConnection.Open("DSN=2003yankeeschedule");
var mySQL = "Select GameID, GameDate, GameTime, TeamA, TeamB"
adoRecordset = adoConnection.Execute (mySQL);
while ( adoRecordset.Eof == false )
{
%>
<tr>
<td><%=adoRecordset ("GameDate").Value%></td>
<td><%=adoRecordset ("GameTime").Value%></td>
<td><%=adoRecordset ("TeamA").Value%></td>
<td><%=adoRecordset ("TeamB").Value%></td>
</tr>
<%
adoRecordset.MoveNext ();
}
adoRecordset.Close();
adoRecordset = null;
adoConnection.Close ();
adoConnection = null;
%>
</table>
//