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

Re: Strange problem with MySql & IIS & ASP

2002-10-22 Thread Terence
I had the same problem. It's in your connection, somehow ASP doesnt retrieve the results when doing a select and count, so you need to use a connection like this: dim myConn Set myConn= Server.CreateObject ("ADODB.Connection") myConn.ConnectionString = "Driver={MySQL};SERVER=xxx.xxx.xxx.xxx;DATAB

Re: Strange problem with MySql & IIS & ASP

2002-10-22 Thread Dennis Salguero
IL PROTECTED]> Sent: Monday, October 21, 2002 7:39 AM Subject: Strange problem with MySql & IIS & ASP 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 NoOfRe

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