in reply to Re^3: undefined value as a hash reference?
in thread undefined value as a hash reference?

I removed the comma and now I get invalid syntax near DATEDIFf, this query is driving me crazy! It works fine on sql server, I have been stuck on this problem for days.
  • Comment on Re^4: undefined value as a hash reference?

Replies are listed 'Best First'.
Re^5: undefined value as a hash reference?
by MidLifeXis (Monsignor) on Nov 05, 2008 at 16:36 UTC

    If this is working on SQLServer, what are you moving it to? If it is SQLServer specific code, it makes sense that extended commands will fail.

    or did I fully misunderstand your comment?

    Anyway, without having full error messages, this might be difficult to resolve.

    --MidLifeXis

      it works in query analyzer as is the purpose is to schedule it to periodically send email reminders to registered clients for classes should the date fall between 1-7 and a reminder has not already been sent and the class is being held within 24 hours.