>Does anyone know where I can find the syntax for asp? I would like to convert the code below to connect to a VFP table rather than an access table (database).
>
>1 set conntemp=server.createobject("adodb.connection")
>2 cnpath="DBQ=" & server.mappath("yourtable.mdb")
>3 conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
>4 set rstemp=conntemp.execute("select * from authors")
You don't need _all_ of this. The syntax for a fox table is the same for an access table, they both have to be set up as an ODBC datasource. All you need is
<%Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("dsn=myvfpDataSource")
Conn.Execute("select * from authors")
%>
www.west-wind.com has some stuff about ASP.
Erik Moore
Clientelligence