VS: Strange problem with MySql & IIS & ASP

2002-10-25 Thread Morsky Juha
Millions of thanks! Now it's working perfectly!!! Once again MS bugs... Regards Juha -Alkuperäinen viesti- Lähettäjä: Terence [mailto:terencel@;sunway.edu.my] Lähetetty: 23. lokakuuta 2002 4:54 Vastaanottaja: Morsky Juha; [EMAIL PROTECTED] Aihe: Re: Strange problem with MySql

Strange problem with MySql & IIS & ASP

2002-10-21 Thread Morsky Juha
Hi All! I've Select like this: SELECT ExpDepDate, ActArrDate FROM oceandata It works beautifully But When I modify it like this SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata I'll get nothing, just a empty screen with a browser! I'm using Ultradev to create this and whe

Strange problem with MySql & IIS & ASP

2002-10-18 Thread Morsky Juha
Hi All! I've Select like this: SELECT ExpDepDate, ActArrDate FROM oceandata It works beautifully But When I modify it like this SELECT ExpDepDate, ActArrDate, (TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as Act_Est FROM oceandata I'll get nothing, just a empty screen with a browser! I'm using U

Update problem in MySQL

2002-09-26 Thread Morsky Juha
Do anyone has a idea how to Insert (create SQLQuery) from onetable to an other table as decripted under: Here is the orginal Table: Table1: Ref | Timestamp | ActionDate ---+-+ 001 | DEP + 2002/01/02