If you can, take out all of the spaces in the object and in the database. To differentiate between words, use upper cases, such as: SocialActivities. That might help out.
I take it you don't have control over the hosting computer (it's outsourced.) So your plan is to actually FTP the Access database file up to your web host after you have updated it with information from the Oracle database. Is this correct?
In this case I don't think it's the script that is running slow, it's the write time to the database. Especially Access, which is really not a robust piece of software. Your solution might be found in trying to write to a SQL Server database instead, it is more robust and can handle more...
Let's say I keep the current record in a variable called "filetodelete". How would I call this variable from the cmdshell?
exec xp_cmdshell "del c:\??filetodelete??" No_Output
I can tell that we're close here... :)
Eva,
A batch would probably be a much better solution. I just had the ASP page all ready to go. I think I'll look into building a batch, but I have one question:
Can you delete files on the hard drive from a batch file?
I want to query records that have reached an 'expiration date' and...
I am trying to make SQL Server run an ASP page at a scheduled time each day. The ASP page is a cleanup file that removes old files from our server.
So I have two questions:
1. Can I run the ASP page from SQL Server when no one is logged into the server?
2. Is there any way to close the ASP...
Found the solution!
You have to use the XMLHTTP property to get the raw data from the XML file that is located on an external server. Then, the Call xmlhttp.send brings back the information that you can then parse and look for information. This example found an external XML file and printed...
Found the solution!
You have to use the XMLHTTP property to get the raw data from the XML file that is located on an external server. Then, the Call xmlhttp.send brings back the information that you can then parse and look for information. This example found an external XML file and printed...
Thank you for your response, but I'm confused by the code. I'm programming in ASP and you have semi-colons after each line.
This is the code that I have now. It can read from a copy of the external XML file that I have on my server. The problem is that I want it to read from the original...
I've been all over the XML message boards and had no luck with this one. But I'm an ASP junkie and I know that you people can help.
I'm trying to get values from an external XML document using ASP. Does anyone know how to do this directly from my .asp page?
I've looked everywhere for an...
I'm having the same problem. I have an XML document on another server, that I want my website to be able to get values from. How can I do this through ASP and not XSL? I only have read access to the XML document, so hopefully this answer doesn't involve editing the XML document directly...
RATS. The server I'm trying to get to is in New York, and all I have is the URL of where the XML document is stored.
I was kind of hoping there would be a way to actually "look" at the XML document itself, and then do a kind of linear search via ASP, looking for key tags and then...
Will this still work with a file that is located on a different server?
Once I get that, how do I go about finding the 4 points of information that I need and displaying them?
Thanks
I'm trying to encorporate this file into an existing website that does not use XSL. It does use ASP extensively, and I'm familiar with that. Any ideas on how to get XML values through ASP?
Thanks for the response!
Coming from a database background, I must say that databases are much easier to implement on websites than XML. I've been working with XML for a while, and I've noticed that the encoding and decoding specifications for XML can be somewhat mind numbing.
All of the XSLT stuff that you have to...
I'm totally new to XML. I've been reading up on it and everything made sense until I came upon this problem. I have an external XML document located on another server that I have to receive stock information from and display on the website I'm creating. I only need 4 of the values from the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.