Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Asking for VFP records
Message
De
18/02/2003 04:57:29
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
17/02/2003 23:45:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00754339
Message ID:
00754377
Vues:
11
>What should I use to ask VFP to send its data to be displayed in Internet Explorer? Can I use JavaScript or ASP to do that job?
>
>Assume that I'm viewing a web page in Internet Explorer and when I click on a button, I want the VFP data to be displayed as requested in the criteria text box.
>
>Thanks a lot for your kind help,
>Best Regards,
>Clarissa

You could use both. If you've VFP7 you could use VFPOLEDB, if not ODBC for connection. ie: (with VFPOLEDB) :
<%
    dbpath = Server.MapPath("data")
    set oConnection = Server.CreateObject( "adodb.connection" ) 
    with oConnection
       .ConnectionString = "Provider=VFPOLEDB.1;data source=" & dbpath & "\testdata.dbc"
       .Open
       Set rs = .Execute( "select * from employee" )
    end with
    Response.Write("<TABLE border='1'><TR><TD>Emp Id</TD><TD>First Name</TD><TD>Last Name</TD></TR>")
    while not rs.eof
            Response.Write("<TR>")
            Response.Write("<TD>" & rs.Fields("emp_id").value & "</TD>")
            Response.Write("<TD>" & rs.Fields("first_name").value & "</TD>")
            Response.Write("<TD>" & rs.Fields("last_name").value & "</TD>")
            Response.Write("<TD>" & rs.Fields("title").value & "</TD>")
            Response.Write("<TD>" & rs.Fields("birth_date").value & "</TD>")
            Response.Write("<TD>" & rs.Fields("hire_date").value & "</TD>")
            Response.Write("</TR>")
            rs.MoveNext
    wend
    Response.Write("</TABLE><BR/>")
	
    oConnection.Close
    set oConnection = nothing
%>
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform