Problem in fetching data from MySQL table using Classic ASP |
| |
|
|
|
New Coder Posts: 31 Topics: 10
|
|
|
December 19, 2008, 12:53:26 PM
|
|
I am facing very strange problem in my ASP and MySQL application. Whenever, I try to fetch the time value from MySQL table and print it, it displays the current date instead of the value stored in the MySQL table. I am connecting to the database using MySQL ODBC Driver 3.5. I am sure there is no code issue as the same application works on my local system but not working on live web site.
Could it be related to version of ODBC Driver installed on the server ?
Kailash
|
|
| |
|
|
|
Code Guru Gender:  Posts: 1399 Topics: 85
|
|
|
January 11, 2009, 10:58:53 AM
|
|
lol - thats wierd! Did you sort this out?, if so how did you do it? Is ASP trying to format the time value into a date?
|
|
| |
|
|
|
New Coder Posts: 44 Topics: 0
|
|
|
March 29, 2011, 09:48:29 PM
|
|
Sorry but I am using SQL server 2005 so I didn't get this problem.
« Last Edit: April 10, 2011, 09:54:50 PM by Admin »
|
|
| |
|
|
|
Skilled Coder Posts: 125 Topics: 0
|
|
|
May 12, 2011, 02:30:14 AM
|
|
Could you please post your code, so we can review it and provide proper solution for it.
|
|
| |
|
|
|
New Poster Posts: 3 Topics: 0
|
|
|
June 21, 2011, 01:11:54 AM
|
|
nice work
« Last Edit: June 27, 2011, 09:10:14 PM by Admin »
|
|
| |