Hi Mike,
Actually I've visited that site. What I do not understand is how FP
communicates via ASP with Access using the code window. That is the true
nature of the question. Once I get that secret I can handle the rest
First, you need to understand the difference between the FrontPage program,
and what it is used to create. This is much like the difference between Word
and a Word document. FrontPage is a program for creating web sites and web
pages.
The reason I say this is that you're asking about 2 different things:
FrontPage communicates with a database when you use the FrontPage database
wizards to create a database application in a web site (a set of ASP pages).
FrontPage doesn't use ASP to do this. ASP is a web server application for
use by web pages. There is a big difference between a desktop application
talking to a database and a web page talking to a database. But the
FrontPage program *does" talk to a database when you use it to create web
pages that talk to a database.
Now, these ASP pages are created by FrontPage, and they communicate with a
database using ASP, which uses a scripting language for its functionality.
What FrontPage does when it creates ASP pages for you is to write the ASP
script in the pages for you. So, FrontPage talks to the database at design
time, and the ASP page talks to the database at run time.
I hope that makes it more clear. When you write your own ASP, you don't use
FrontPage to do it (other than typing the code in, in the FrontPage Code
view). When you write your own ASP, FrontPage doesn't communicate with the
database at all.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
We got a sick zebra a hat,
you ultimate tuna.
Mike C said:
Actually I've visited that site. What I do not understand is how FP
communicates via ASP with Access using the code window. That is the true
nature of the question. Once I get that secret I can handle the rest
--
Mike C
Stefan B Rusynko said:
If you are a beginner and don't know ASP and DB connections try starting
with the FP DBRW
Otherwise learn about DB connections (ADO) and ASP at
http://www.w3schools.com/ado/default.asp
http://www.w3schools.com/asp/default.asp
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| Added this to the code window trying to see if I can talk to the db and
get
| information out of it. What am I missing ?
|
| <%
| Dim oRSv, strconn
| strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
| Source=c:\inetpub\wwwroot\PracticeOne2\fpdb\ArmadaWBv110.mdb"
| set oRSv = Server.CreateObject("ADODB.Connection")
| oRSv.open strconn
|
| oRSv.open "tbl_ClosedOrders"
| oRSv.MoveFirst
| Response.Write oRSv("Comcode") & ", "
| oRSv.MoveNext
| oRSv.Close
| %>
| --
| Mike C
