Hi I have the below script When I use the xml.load method it is always shows Response Code as "200" However the Content expiration is set to 2 days. My Question is how to force the script to use the cached xml file when the file is in the cache? Tested in MSIE 7.0 if(document.all) var xml = new ActiveXObject("Microsoft.XMLDOM"); else var xml = document.implementation.createDocument("", "", null); var xmlObj; function verify() { if (xml.readyState != 4) return false; } function loadXML() { xml.async=false; xml.onreadystatechange=verify; xml.load("http://"+document.location.host+"/xmlstore/test.xml"); } function createDocument() { xmlObj=xml.documentElement; } //loadXML() //createDocument() //alert(xmlObj)

Raj..

Hi I am in the situation to write code to pull the data from a table which has 1 Million rows per day what are the optimal ways to search the text ? database : SQL Server 2000 I have index on the table The table is portioned nrk

Use group by siteId ...

N.Rajakumar B.E.,

If you using SQL Server Try this select object_name(id) from sysObjects where type = 'u'

N.Rajakumar B.E., Application Developer,

try it !!! declare @cid int set @cid = 2 declare @S int declare @E int insert into temptblCategory select *,-1 from tblCategory where parentId in(@cid) select @E=count(cid) from temptblCategory where status=-1 set @S=1 while @S<=@E begin select top 1 @cid=cid from temptblCategory where status=-1 update temptblCategory set status=1 where cid=@cid insert into temptblCategory select *,-1 from tblCategory where parentId in(@cid) select @E=count(cid) from temptblCategory where status=-1 end

N.Rajakumar B.E., Application Developer

CREATE PROCEDURE tryproc(@product varchar(10),@LOCATION varchar(50)) AS SET @first = 0; SELECT SUM(t) AS first FROM demand WHERE product = @product AND LOCATION = @LOCATION create table abc (demandsum int); insert into abc (demandsum) values (@first); N.Rajakumar B.E., Application Developer

Hi I would like to create a COM which is used to generate PDF from HTML content .. but i don't have any idea on creating com for pdf .. can anybody give me some fundamentals of creating com for pdf ..

N.Rajakumar B.E., Application Developer,

Hi, There are plenty of articles says that Do not store objects in Session or Application scope for better performance !! can anybody tell me 1.what happen when we store the Objects (e.g FSO,DICTIONARY,RecordSet) in session or application ? 2.How the performance get down, if objects are stored in the session scope ?

N.Rajakumar Application Developer,

Hi I am frequently getting the following type of Error Message .. when i Restart my IIS Server its working. can anyone help me on this issue. Error Message 1.IIS Out-Of-Process Pooled Applications or Some time IIS will show Error msg like RPC Server unavailable

Raji, Application Developer

Hi All I have a web application which is developed by ASP and SQL I planed to optimize the asp code.... Can anybody suggest? Doing optimization on the asp file will boost the performance? Or creating VB COM will do better? Which one will be good? Note : I have done with a testing by creating COM that pulls around 100000 records from DB and display it in the Web page.... But I don't find any time difference when I ran the same with ASP file? Can anybody give me idea on this....? Regards N.Rajakumar B.E., Application Developer

Hi Vasudevan Deepak Kumar Thanks for sent me a web link but it speaks about .NET ..I want this to be done with ASP let me know if you have any idea....

N.Rajakumar B.E., Application Developer,

The code is in VB Script for my ASP Application .....not .Net

N.Rajakumar B.E., Application Developer,

Dear all Please find the below sendMail() procedure 1. if the To email Id is external emailid then the email is not delivered whereas if the emailid is same domain it is working fine ..... Sub sendMail() sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = Server.CreateObject("CDO.Configuration") Set cdoMessage = Server.CreateObject("CDO.Message") With cdoConfig.Fields .Item(sch & "sendusing") = 2 ' cdoSendUsingPort .Item(sch & "smtpserver") = "mail.company.com" .update End With With cdoMessage Set .Configuration = cdoConfig .From = "info@company.com" .To = "someone@yahoo.com" .Subject = "Inquiry" .HTMLBody=strMsg .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing End Sub can anyone tell me what is wrong with my script....if not what is the solution for this issue Thnaks inadvance N.Rajakumar B.E., Application Developer

encodeURIComponent is working fine on all reserved chars where as encodeURI is limited...

N.Rajakumar B.E., Application Developer, www.newdreamz.tk

Hi all before sending request to web server using ajax i am creating a string with form element's name and corresponding value.the constructed string will looks like source.asp?elementName1=elementValue1&elementName2=elementValue2&elementName3=elementValue3 the problem with the above format is: if the elementValue itself contains any "&" symbol i can't able to get the value of the form element from server side. is there any way to resolve this issue other than replace the "&" char with some other char ..

N.Rajakumar B.E., Application Developer, www.newdreamz.tk

Hi all I have a web application which was developed in ASP + VB + Scripting Language The problem is when replacing the existing dll with newly created one the IIS needs a restart...Is there any other way to replace the dll with out IIS restart...

N.Rajakumar B.E., Application Developer, www.newdreamz.tk

I am developing COM component in VB for My ASP Application. I would like to know how to handle the versioning problem.

N.Rajakumar B.E., Application Developer, www.newdreamz.tk

Hi All, Can anyone tell me the order in which sql Query executes Example: select C.*,RenewalDate=(select * From CustomerApprovals where CustNo=1 Order By ApprovalDate Desc) from Customers C where C.CustNo=1

N.Rajakumar B.E., Application Developer, www.newdreamz.tk

Hello Dear, Please give me some good ADO Books name. N.Rajakumar B.E., Application Developer, www.newdreamz.tk

Hello Dear, How to Install FONT in to the client system......I am using ASP N.Rajakumar B.E., Application Developer, www.newdreamz.tk