Re: cgi calender

--- oryann9 <oryann9@xxxxxxxxx> wrote:

--- Tom Phoenix <tom@xxxxxxxxxxxxxx> wrote:

On 2/27/07, oryann9 <oryann9@xxxxxxxxx> wrote:

Problem: cgi calender daynames are not matching
up
with dates. For example: Todays date 02/27/2007
is
being printed under Thursday instead of Tuesday.

Is the problem that you need to determine the day
of
the week for a
given date, or that you need to get something to
line up vertically
with something else?

From looking briefly at your code, you seem to be
using SQL to
manipulate dates and times. In Perl, it's
generally
easier to use a
module to do that. (Unless, of course, using SQL
is
part of the
homework assignment.)

--Tom Phoenix
Stonehenge Perl Training


Tom, thank you for replying. Well I solved the
first
issue, determining the day of week for a given date
using select dayofweek(curdate()), so yes I am
having
issues lining these days line up with dates b/c as
the
days move forward the foreach $day ('-15' .. '15')
loop alters the table. This is a homework
assignment
for an online SQL class I am taking through O'reilly
for continuing education even though I work as a
Unix Engineer.



Will anyone offer some kind help?





____________________________________________________________________________________
Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/
.

Relevant Pages

  • Re: Do we always have to update or insert? Why cant we just relate?
    ... >> assignment - it's a requirement. ... SQL does not support it. ... Every boolean function can be built using NAND (or ... But let's talk about a programming language that has AND, OR, NOT. ...
    (comp.databases.theory)
  • Re: Need help setting up first query
    ... SQL is the "code" for a query. ... down") for assignment to change its behavior. ... There is an "event" that occurs every time the SignUp comb box is changed, ...
    (microsoft.public.access.queries)
  • Re: Table analysis
    ... could have a default value assignment, ... necessarily indicating any usage. ... Provide the Oracle version you're using. ... I actually ended up using the following SQL which worked well for what ...
    (comp.databases.oracle.misc)
  • Re: a simple DBMS and SQL Engine parser
    ... this assignment asks you to create a parse-tree for sample ... > hold the data i.e. you are creating an extremely rudimentary SQL Engine ... In fact, your DBMS software ... Your parser should be able to parse the ...
    (microsoft.public.vc.language)