Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. intranetgeeky

    Syntax error in INSERT INTO statement

    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.
  2. intranetgeeky

    Slow Scripts!

    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?
  3. intranetgeeky

    Slow Scripts!

    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...
  4. intranetgeeky

    Run ASP page from SQL Server

    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... :)
  5. intranetgeeky

    Run ASP page from SQL Server

    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...
  6. intranetgeeky

    Run ASP page from SQL Server

    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...
  7. intranetgeeky

    ASP code to read external XML document

    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...
  8. intranetgeeky

    incorporate XML to 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...
  9. intranetgeeky

    ASP code to read external XML document

    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...
  10. intranetgeeky

    ASP code to read external XML document

    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...
  11. intranetgeeky

    incorporate XML to ASP?????

    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...
  12. intranetgeeky

    External XML Document Translated to HTML

    Thanks for that lead. I'm looking into using a parser to use ASP to get the info I need. I'll keep you up-to-date if I figure it out.
  13. intranetgeeky

    External XML Document Translated to HTML

    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...
  14. intranetgeeky

    External XML Document Translated to HTML

    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
  15. intranetgeeky

    External XML Document Translated to HTML

    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!
  16. intranetgeeky

    Why XML? Why not databases?

    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...
  17. intranetgeeky

    External XML Document Translated to HTML

    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...

Part and Inventory Search

Back
Top