Hello,

I need to take values from a dbf file and display on website. Does any one
know of JavaScripts that can do this?

Thank you in advance.

Re: Putting dbf on web site by Anders

Anders
Mon Jun 18 13:34:02 CDT 2007

Java can uase a VFP database through an OLE DB connection. Install
VFPOLEDB.DLL. The same way it would connect throgh an OLE DB driver for any
database.
-Anders

"Emily" <Emily@discussions.microsoft.com> wrote in message
news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
> Hello,
>
> I need to take values from a dbf file and display on website. Does any
> one
> know of JavaScripts that can do this?
>
> Thank you in advance.



Re: Putting dbf on web site by Emily

Emily
Mon Jun 18 15:14:01 CDT 2007

Thank you but I looked into this and this is not supported by Vista. Any
other ideas?

What I need actually can maybe handled through the ReportListener class. I
found out I can create a report and save it as an html file which is
wondering that is all I need however I am unable to work the thing keep
getting syntax error on the examples that are even provided by Microsoft.

Maybe if someone could look at this code and tell me what I am doing wrong?

Thanks.

Down below this is the line giving me a syntax error:
REPORT FORM r_commnunpdweb OBJECT oHtml


LOCAL oHtml
lcThisDir = dir_data
oHtml = NEWOBJECT("HtmlListener","_reportlistener.vcx")
oHtml.targetFileName = lcThisDir + 'TEST.HTM'
oHtml.quietmode=.t.
REPORT FORM r_commnunpdweb OBJECT oHtml
MODIFY FILE (oHtml.targetFileName)
ACTI SCREEN
? oHtml.XsltProcessorUser.Stylesheet.Xml



Emily

"Anders Altberg" wrote:

> Java can uase a VFP database through an OLE DB connection. Install
> VFPOLEDB.DLL. The same way it would connect throgh an OLE DB driver for any
> database.
> -Anders
>
> "Emily" <Emily@discussions.microsoft.com> wrote in message
> news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
> > Hello,
> >
> > I need to take values from a dbf file and display on website. Does any
> > one
> > know of JavaScripts that can do this?
> >
> > Thank you in advance.
>
>
>

Re: Putting dbf on web site by Dan

Dan
Mon Jun 18 18:09:37 CDT 2007

If all you're doing is static HTML, you don't even need the report.

use your.dbf
do (_genhtml) with 'output.html', Dbf(), 2


Dan


Emily wrote:
> Thank you but I looked into this and this is not supported by Vista.
> Any other ideas?
>
> What I need actually can maybe handled through the ReportListener
> class. I found out I can create a report and save it as an html file
> which is wondering that is all I need however I am unable to work the
> thing keep getting syntax error on the examples that are even
> provided by Microsoft.
>
> Maybe if someone could look at this code and tell me what I am doing
> wrong?
>
> Thanks.
>
> Down below this is the line giving me a syntax error:
> REPORT FORM r_commnunpdweb OBJECT oHtml
>
>
> LOCAL oHtml
> lcThisDir = dir_data
> oHtml = NEWOBJECT("HtmlListener","_reportlistener.vcx")
> oHtml.targetFileName = lcThisDir + 'TEST.HTM'
> oHtml.quietmode=.t.
> REPORT FORM r_commnunpdweb OBJECT oHtml
> MODIFY FILE (oHtml.targetFileName)
> ACTI SCREEN
> ? oHtml.XsltProcessorUser.Stylesheet.Xml
>
>
>
> Emily
>
> "Anders Altberg" wrote:
>
>> Java can uase a VFP database through an OLE DB connection. Install
>> VFPOLEDB.DLL. The same way it would connect throgh an OLE DB driver
>> for any database.
>> -Anders
>>
>> "Emily" <Emily@discussions.microsoft.com> wrote in message
>> news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
>>> Hello,
>>>
>>> I need to take values from a dbf file and display on website. Does
>>> any one
>>> know of JavaScripts that can do this?
>>>
>>> Thank you in advance.



Re: Putting dbf on web site by Emily

Emily
Mon Jun 18 18:20:01 CDT 2007

Okay so I figured out why I was getting a syntax error.

There was an error on the report and instead of the usual report errors that
is how it told me there is something wrong.

Thank you Anders. In case you ever need it too. It is a nifty class called
ReportListener.

Emily




"Emily" wrote:

> Thank you but I looked into this and this is not supported by Vista. Any
> other ideas?
>
> What I need actually can maybe handled through the ReportListener class. I
> found out I can create a report and save it as an html file which is
> wondering that is all I need however I am unable to work the thing keep
> getting syntax error on the examples that are even provided by Microsoft.
>
> Maybe if someone could look at this code and tell me what I am doing wrong?
>
> Thanks.
>
> Down below this is the line giving me a syntax error:
> REPORT FORM r_commnunpdweb OBJECT oHtml
>
>
> LOCAL oHtml
> lcThisDir = dir_data
> oHtml = NEWOBJECT("HtmlListener","_reportlistener.vcx")
> oHtml.targetFileName = lcThisDir + 'TEST.HTM'
> oHtml.quietmode=.t.
> REPORT FORM r_commnunpdweb OBJECT oHtml
> MODIFY FILE (oHtml.targetFileName)
> ACTI SCREEN
> ? oHtml.XsltProcessorUser.Stylesheet.Xml
>
>
>
> Emily
>
> "Anders Altberg" wrote:
>
> > Java can uase a VFP database through an OLE DB connection. Install
> > VFPOLEDB.DLL. The same way it would connect throgh an OLE DB driver for any
> > database.
> > -Anders
> >
> > "Emily" <Emily@discussions.microsoft.com> wrote in message
> > news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
> > > Hello,
> > >
> > > I need to take values from a dbf file and display on website. Does any
> > > one
> > > know of JavaScripts that can do this?
> > >
> > > Thank you in advance.
> >
> >
> >

Re: Putting dbf on web site by Anders

Anders
Mon Jun 18 17:51:15 CDT 2007

You may have a UAC problem installing the driver vfpoledb.dll but it's
certainly supported by Vista.
-Anders

"Emily" <Emily@discussions.microsoft.com> wrote in message
news:DC2ADE10-5ECC-4B31-A940-388C5A55C404@microsoft.com...
> Thank you but I looked into this and this is not supported by Vista. Any
> other ideas?
>
> What I need actually can maybe handled through the ReportListener class.
> I
> found out I can create a report and save it as an html file which is
> wondering that is all I need however I am unable to work the thing keep
> getting syntax error on the examples that are even provided by Microsoft.
>
> Maybe if someone could look at this code and tell me what I am doing
> wrong?
>
> Thanks.
>
> Down below this is the line giving me a syntax error:
> REPORT FORM r_commnunpdweb OBJECT oHtml
>
>
> LOCAL oHtml
> lcThisDir = dir_data
> oHtml = NEWOBJECT("HtmlListener","_reportlistener.vcx")
> oHtml.targetFileName = lcThisDir + 'TEST.HTM'
> oHtml.quietmode=.t.
> REPORT FORM r_commnunpdweb OBJECT oHtml
> MODIFY FILE (oHtml.targetFileName)
> ACTI SCREEN
> ? oHtml.XsltProcessorUser.Stylesheet.Xml
>
>
>
> Emily
>
> "Anders Altberg" wrote:
>
>> Java can uase a VFP database through an OLE DB connection. Install
>> VFPOLEDB.DLL. The same way it would connect throgh an OLE DB driver for
>> any
>> database.
>> -Anders
>>
>> "Emily" <Emily@discussions.microsoft.com> wrote in message
>> news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
>> > Hello,
>> >
>> > I need to take values from a dbf file and display on website. Does any
>> > one
>> > know of JavaScripts that can do this?
>> >
>> > Thank you in advance.
>>
>>
>>



Re: Putting dbf on web site by swdev2

swdev2
Tue Jun 19 13:42:33 CDT 2007

Why bother with javascript ?
Host your tables on an IIS servers and install Active FoxPro Pages on that
server.

But -

If you have to use java and dbf's and a non-windows server -

Install the odbc pack for the operating system.
Copy yer dbf files there in solely fox2x format.
Have yer 'JavaScript' use the odbc package and get to the dbf files
directly.

Regards / xie xie [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Emily" <Emily@discussions.microsoft.com> wrote in message
news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
> Hello,
>
> I need to take values from a dbf file and display on website. Does any
one
> know of JavaScripts that can do this?
>
> Thank you in advance.



Re: Putting dbf on web site by swdev2

swdev2
Tue Jun 19 13:43:38 CDT 2007

Vista?

You said originally you had to get yer dbf files on a web server and display
them with javascript.

Wow - Talk about wandering system requirements!!!
EEK!

[Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Emily" <Emily@discussions.microsoft.com> wrote in message
news:DC2ADE10-5ECC-4B31-A940-388C5A55C404@microsoft.com...
> Thank you but I looked into this and this is not supported by Vista. Any
> other ideas?
>
> What I need actually can maybe handled through the ReportListener class.
I
> found out I can create a report and save it as an html file which is
> wondering that is all I need however I am unable to work the thing keep
> getting syntax error on the examples that are even provided by Microsoft.
>
> Maybe if someone could look at this code and tell me what I am doing
wrong?
>
> Thanks.
Altberg" wrote:
>
> > Java can uase a VFP database through an OLE DB connection. Install
> > VFPOLEDB.DLL. The same way it would connect throgh an OLE DB driver for
any
> > database.
> > -Anders
> >
> > "Emily" <Emily@discussions.microsoft.com> wrote in message
> > news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
> > > Hello,
> > >
> > > I need to take values from a dbf file and display on website. Does
any
> > > one
> > > know of JavaScripts that can do this?
> > >
> > > Thank you in advance.
> >
> >
> >



Re: Putting dbf on web site by swdev2

swdev2
Tue Jun 19 14:15:41 CDT 2007

Hey Emily -

After reading your postings -

I have to wonder (again) -

You want to put the contents of a dbf file INTO html ? yes?
then post the html file to a server ? or simply read the html file with a
browser?
No other interaction required, like 1) lookup 2) update 3) insert 4) delete
?
Yes? No ?

make a cursor or table that contains ONLY the information you want.

Then Browse this thing in VFP IDE.

THEN? Select 'Save as HTML'

Then post the file on your favorite website.

Regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Emily" <Emily@discussions.microsoft.com> wrote in message
news:A8C4EE8A-D7ED-4403-97C7-AB9FC0431AB2@microsoft.com...
> Hello,
>
> I need to take values from a dbf file and display on website. Does any
one
> know of JavaScripts that can do this?
>
> Thank you in advance.