The reason I am doing mySQL is that I can easily create the
input portion in the cgi script once I get the output I'm
looking for. I should have probably not even mentioned
Access as the input side is a no-brainer for me in Perl.
I guess I am just used to having all my db's on the server
(mysql), and just quickly linking up via myodbc for quick
development. All output, however, is always on our webserver.
As a side note, I've been playin with GD::Graph in Perl
to get some pie/bar charts out of mysql. Neat stuff :-)
I think I am just going to take a stab at it myself as see
what turns out.
Mike
On Thu, Jul 27, 2000 at 01:35:10PM -0700, Mike Cantrell wrote:
I don't know of anything that does specifically what you need as far as an
automagic calender/database solution but I'm not sure why you'd use mySQL
for something that's already in a Access database unless it gets failry
large or performance and high stability are issues.
1) The DBI:ODBC module used along with UnixODBC for the driver would provide
direct access to the access database eliminating the need for a 3rd
database. If the access database is on a different machine on the network,
you can get a free limited license copy of Easysoft ODBC bridge at
http://www.easysoft.com that will allow direct access over the network.
2) You should be able to find lot's of interesting modules to help you with
the date stuff here:
http://www.cpan.org/modules/by-module/Date/
There might even be some nice calendar stuff in there somewhere. I havn't
had to deal w/ any of them before so I'm not sure what's available.
Regards,
Mike Cantrell
----- Original Message -----
From: "Lucas Vogel" <
lvogel@exponent.com>
To: <
plug-discuss@lists.PLUG.phoenix.az.us>
Sent: Thursday, July 27, 2000 12:51 PM
Subject: RE: perl->php- Calendar
> I know Zope has a Calendar control that you can slap into Zope apps that
you
> could probably build in a day, but you were looking for php/perl so I
guess
> it's not very helpful...
>
> > -----Original Message-----
> > From: Mike Starke [mailto:mgcon@neta.com]
> > Sent: Thursday, July 27, 2000 12:49 PM
> > To: plug-discuss@lists.PLUG.phoenix.az.us
> > Subject: perl->php- Calendar
> >
> >
> > I have three conferance rooms which we have sheets outside
> > the door for the folks the reserve the room.
> >
> > I was just asked to come up with a web page solution which shows the
> > schedules.
> >
> > What I kind of had in my mind was a perl-mysql solution. I'd like
> > to set up the receptionist with a small MS ACCESS front-end to enter
> > the times requested, and then have the cgi script automagically
> > pull up the schedule for the room.
> >
> > Am I better off doing this from scratch, or does anyone know of a
> > simple php or perl script that someone has already done?
> >
> > Doesn't look like a big project, I just hate to re-invent the wheel.
> >
> > Mike
> > mgcon@getnet.com
> > http://www.getnet.com/~mgcon
> > Phoenix, AZ
> > USA
> >
> >
> > _______________________________________________
> > Plug-discuss mailing list - Plug-discuss@lists.PLUG.phoenix.az.us
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
>
> _______________________________________________
> Plug-discuss mailing list - Plug-discuss@lists.PLUG.phoenix.az.us
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
_______________________________________________
Plug-discuss mailing list -
Plug-discuss@lists.PLUG.phoenix.az.us
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
--
V/R
Mike Starke
mstarke@mobl.com
public key "
http://www.neta.com/~mgcon/downloads/mstarke_public.txt"
chgrp -R USMC /home/*