No IP restriction template found for user

2002-10-06 Thread Nick Didkovsky
Hello, I just added a user called "our_guest" to our mysql database, and the user should be able to log on through a jsp page I *can* log our_guest into MySQL from a command line. But the user cannot log on via the www. The SQLException thrown is java.sql.SQLException: No IP restriction

Re: SV: Comparing dates

2001-02-19 Thread Nick Didkovsky
906 900 62 > http://never.no - icq:103476059 > ~ hvis du ikke klarer det pa sorste forsok vil jeg ikke anbefale hangliding > ~ > > > -Opprinnelig melding- > > Fra: Nick Didkovsky [mailto:[EMAIL PROTECTED]] > > Sendt: 19. februar 2001 14:53 > > Til: mys

Comparing dates

2001-02-19 Thread Nick Didkovsky
Hello, Is there a more general way to compare DATE values than the following. ...WHERE TO_DAYS(myDateField) > TO_DAYS('2001-02-14'); I really have to objection to converting to a common unit of days in order to compare (as long as I don't care about comparing times within the same day), but I

DATE field with current date as default ?

2001-01-13 Thread Nick Didkovsky
Hello, Is there a way to have a field of type DATE get the current date as its default? Something like ... mydatefield DATE DEFAULT curdate() ...which does not work. But that's the idea. Best, Nick Didkovsky - B