Sysdate????Date????Please help

[Ryan Ahmed]

Hiya Everyone,
I have a small problem,I am a java programmer working for a small 
company,
We have just been given project to build a  greetings program for 
a website,thats no problem but one of the parameters is an option 
to send the greeting at a later date,not today.

I have kinda worked out the logic in my head but I need to query 
the database for the system date and get a reply something like this 
1 or 01 for the first and 2 or 02 for the second and so onand 
also for months(for january) 01 or 1 (for Feb) 02 or 2 and so on.


The logic,
I'm using a thread that will sleep for 23 hours and check the system/current 
date,month and then query the database for people who want to send 
their greetings on the same date,month and then connect to the smtp 
server etc...any ideas?


ALL reply's are welcome,good or bad,abuses or hugs!
:-)
Cheers,
-Ryan
P.S I would really appreciate it if you could send your answers to 
[EMAIL PROTECTED] and the MySql list.
Thanx


in leaving let me give you something to cheer you up,


A couple bought themselves a squirrel pet.
Once they went and locked it up  in the closet.
In the night a thief penetrated into their house,
 but having heard the owners' car coming in, he hid in the closet.
They came, undressed and went to bed.
But in the middle of the night they were waked up by a scream.
The husband opened the closet to see the man squirming on the floor.
He picked up on the picture, bound him tightly and asked what made 
him holler so shrill.
When your screwy squirrel took my ass for a hollow - I held out,
when it took my  testes for nuts - I gritted my teeth, but when it 
decided to carry the nuts into the hollow i cracked up.







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

HELP Server configuration denies access to data source

[Ryan Ahmed]

Hi Everyone,
I am in a very very
desperate state 'coz my whole site is down and if I
cannot connect to the database through my servlet my
@ss is grass.

Everything seems to be working fine except when I
execute the servlet I get this frustrating error:


" Server configuration denies access to data source "


And to connect my servlet code is:

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con =
DriverManager.getConnection("jdbc:mysql://jumac.com:3306/DBNAME?user=ryanpassword=pw007");


Is the problem with my code or my hosting service?
What should I do?
Please give me detailed instructions as I am not too
familiar with MySql so if you are telling me to make
changes in the database please be specific.

Remember if you help me, when I become a LITTLE richer
than Bill Gates I won't forget you either!

Cheers,
Ryan.
([EMAIL PROTECTED])




__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php