Peter Schoenster wrote:
> On 3 Aug 98, at 12:11, Jack Killpatrick wrote:
> > John Stewart wrote:
> > > Jack Killpatrick wrote:
> > > >
> > > > John Stewart wrote:
> > > > > We have three individuals that have spent their full time
> > > > > the past year
> > > > > trying to integrate and Access database into a web-based solution
> > > > > with no success.
> > > >
> > > > How'd they keep their jobs?
> > >
> > > Their job was to make it work or show that it wouldn't work.
> > > Conceptually, it should work. In actuallity, the NT OS and associated
> > > software are not mature enough to accomplish. They are now
> looking into
> > > a similar solution based around MSSQL server.
> >
> > Do you know where their solution failed?
>
> Oh my gosh, is this a joke or what.
Um, judging from John's answer, it was a question worth asking. Please see
my other post regarding his answer.
> > > > > trying to integrate and Access database into a web-based solution
>
> > > a similar solution based around MSSQL server.
>
> You can use Perl/DBI to update/modify/query an access database on
> NT.
Yes. This is a good thing. It's always great to have more ways to do
something, esp when they're free! Perl excels at handling text. I'm using it
in conjunction with CF for a project right now. Each have their strengths.
See other thread for CF/Perl chatter.
> I use it rather than the much
> slower access gui and my interest is data not design or
> endurance.
I find the GUI to be much more usable than the command line for creating the
foundation of complex SQL queries across numerous tables with (sometimes)
dozens of fields. It is a lot easier to drag a bunch of fields around in the
visual query editor, click the "SQL View" button and copy the SQL into my
perl, CF script or onto the command line of a telnet session.
I can also preview the data result from a complex SQL query much quicker
using the visual query editor in Access. No SQL writing at all, just some
drags and drops and push a button. Wala, instant preview. This is good for
deciding on final query design for a script. When you're ready for the SQL
in your script, hit the SQl view button and cut and paste it in. It's saved
me hours of time, maybe days, with the exact same end result.
BTW, Cold Fusion studio also includes a visual query editor, for anyone who
cares to know.
> You can see my script here:
>
> http://www.rede.com/rdbms/index.html
>at the bottom of this page.
>How did they explain what seems to be a big waste of time?
giggle.
Jack
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
