Tuesday, July 10, 2001

Date: Sun Mar 4, 2001 12:45 am
Subject: Weekend Update


1) WAP and HDML
Some of you have asked about Wireless Web and Cell Phone Browser
access to web sites. Here's a link to good info:
http://www.4guysfromrolla.com/webtech/LearnMore/WAP.asp

2) MySite Database connection
Below is a code example of how to use SQL commands with database
files on MySite without creating the connection in System
ODBC.
Note the path in the MICROSOFT.JET driver. You will
substitute your username for dlbarker. If you want to be able to
upadate the database they need to place the database file in the
cgi_bin directory.
Report any problems to me and we'll get them fixed.

3) More ASP Tutorials
http://www.1001tutorials.com/asp/index.shtml

Dan

--------------------ASP Code Follows--------------------
<%
Dim Connection, query, ItemList

uid = Request.QueryString("id")

Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA
SOURCE=d:\users\dlbarker\cgi_bin\store.mdb"


query = "SELECT * FROM Items"

Set ItemList = Server.CreateObject("ADODB.Recordset")
Call ItemList.Open(query, connection)

On error Resume Next

%>



Our Catalog.




<%
While Not ItemList.EOF
%>




<%
ItemList.MoveNext()
Wend
%>






No comments:

Post a Comment

&id=<%=uid%
>"><% =ItemList("Name") %>
<% =ItemList("Size") %>

Blog Archive