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

    File Upload with pure ASP

    What Windows write permissions did you set up for the destination folder? We are talking about the 'upLoadEnd.asp' file being on the destination server, right? "Nothing is impossible until proven otherwise"
  2. madanthrax

    Classic ASP: Remote Scripting problem

    Hmmm, so the server crashed and IP shortcuts failed. Try finding the old IP address of the server, if you still know it, by searching all the scripts on your site. It would not be the first time someone had referred to a fixed IP address. If you find any entries rename them to the new IP...
  3. madanthrax

    Using parameters when calling a recordset

    Dear all, I have inherited an old classic asp site (MS SQL 2005) that was fairly well secured against SQL injection and CSS using various techniques which I won't go into here. Recently there has been pressure from above to use parameters for extra protection. I researched and found solutions...
  4. madanthrax

    Windows Antivirus 2012 has found critical process activity

    If you hover over the google link and read the status bar I doubt you will see your websites address. This could be a spoof website. Just out of interest how do you access an INTRANET site from home? Are you using a VPN connection? By the way I think this topic belongs in the browser forums...
  5. madanthrax

    Execute scripts permissions

    Dear all, I have a website running asp classic on a Win 2003 RE server. The server is centrally managed and I am not allowed to play with the IIS settings. I have a pure asp upload commercial component on my site and recently we were successfully attacked with an aspx file being placed on the...
  6. madanthrax

    Strange Error 404s

    Thanks for the reply, will stop worrying. "Nothing is impossible until proven otherwise"
  7. madanthrax

    Strange Error 404s

    Hi all, I hope I have got the right forum for this.... I have a custom Error 404 page which is asp. I capture the referrer and the destination URL plus the remote IP address and insert it in a SQL database. This great for finding internal bad links and bad links from external sites plus...
  8. madanthrax

    Trim leading blank space within CASE statement

    Thanks dhulbert. In case anyone is interested in the solution, this worked for me. Using LTRIM in the case statement was not possible so I used it on the SeriesInfo field in the select statement. This code was accepted by SQL Server Man. Studio but somehow the SUBSTRING was still reading the...
  9. madanthrax

    Trim leading blank space within CASE statement

    Hi all, I have a select statement with case in it which you guys helped me with a few months ago. Its been running fine, but recently the inputs to the field that is the subject of the case function (SeriesInfo) have been getting a blank leading space which messes up the character count (see...
  10. madanthrax

    Add column with brains to view

    George, Thanks a lot for the swift help. Its so obvious when its shown to you, I feel stupid. Several hours ago I think there was a Select in there... :-) regards, Anthony. "Nothing is impossible until proven otherwise"
  11. madanthrax

    Add column with brains to view

    ...Category. I have no real idea what I am doing in SQL code but I have put this together from info gathered from the web: USE [Documents] GO /****** Object: View [dbo].[vw_WebDocs5] Script Date: 09/23/2010 17:31:07 ******/ SET ANSI_NULLS ON GO CREATE VIEW [dbo].[vw_WebDocs5] (PubId...
  12. madanthrax

    Remove short words from string

    Excellent, works like a charm. Many thanks. "Nothing is impossible until proven otherwise"
  13. madanthrax

    Connecting to sql server 2008 db

    I have SQL 2005 and IIS6 running on my laptop as I write this. I use DSNless connections since 8 years, for simplicity. Here is a demo of how I get a recordset, adapt as you need. This code I have in "connection.asp" file: <% Dim conn_string conn_string =...
  14. madanthrax

    Website hosting that lets visitors to upload a picture

    mrkyn, When people want to upload pictures to your website, probably .jpg or .gif files, then the pages on your website do the work of uploading (maybe in combination with an upload component hosted by your host). You will need to use an upload script depending on what scripting services are...
  15. madanthrax

    Remove short words from string

    Hi, Is there an elegant way of removing all words from a text string that are less than 4 characters in length please? This is search related. &quot;Nothing is impossible until proven otherwise&quot;
  16. madanthrax

    Search like contains

    Thanks all, vicvirk, now that I see your code I realise likely queries will find a lot of matches, nuclear related words will repeatedly appear in most of the titles. If I change the OR to AND it will be more accurate but runs a high risk of returning nothing. So you guys are right the SP is...
  17. madanthrax

    Search like contains

    Thanks for the reply gmmastros. I want to return results that contain all of the words*. Nothing fancy for a first attempt. The search text box is restricted to 50 characters so they could input several words. *Question: if they input 4 words and one word is not found anywhere will this upset...
  18. madanthrax

    Search like contains

    Correction to above: performance should NOT be a factor. &quot;Nothing is impossible until proven otherwise&quot;
  19. madanthrax

    Search like contains

    Hi, I have a website that displays Technical Publications. Its ASP with MS SQL. Visitors can browse for publications by topic. I now need to create a search by "title text". I have made an input form and a page to display results using the code below to create the SQL query: stext =...
  20. madanthrax

    While Wend syntax

    Wow fast replies! Great job George! Now I know. It works perfectly. Thanks. Tsuji thanks for the help too but maybe my explanation was a bit lacking. Anthony. &quot;Nothing is impossible until proven otherwise&quot;

Part and Inventory Search

Back
Top