----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: arnab Message 1 in Discussion I am facing a strange problem. Created a asp page and it works perfectly on the test server, gives out data. As soon as I put it on the live server, it states that no data could be found. The database is on a third server and not on the web server machine I printed all the imp points in the code and found out that the following sql statement is the problem. strSQL="select SNo,Section_Name,convert(varchar,News_DateTime,120) as NewsDt,substring(convert(varchar,news_datetime,100),13,7) + ', ' + substring(convert(varchar,news_datetime,113),1,11) as News_DateTime,Heading,Article_Text,Co_Name,Bse_Code, " _ & " Symbol from News_Snippets WHERE (News_DateTime > DATEADD(mm, - 3, convert(datetime,'"&cudate&"',103)))" _ & " order by NewsDt desc " Now in this code if I remove the where clause it is working fine on the live machine. What I am not able to understand is how the same code is working without any problems on the test server but giving such problems on the live one. Any help will be appreciated Regards Arnab ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
