Search results for query: *

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

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

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

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

Hi, I have access to a read only view from the printing dept DB in our organisation. We all use MS SQL 2005. The DB is poorly designed and is out of my control. Through a series of views of views I piece the data together and use it on our website as we want to display it. The pages display...

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. "Nothing is impossible until proven otherwise"

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

Hi, I have a view created from two tables, one with uploaded file data (url, link text, date etc) and one with the folders info. The view gives me the folder name attached to every row of file data. I need to place records in about 9 places on an asp page. They need to have the folder title...

Hi, Some time ago I stored away some code posted by Tarwn in a reply, thinking I might need it one day. dim teststring teststring = "this is a test: slash\ bracket{ bracket} singlequote' lparen( rparen) whee" Response.Write "teststring Unchanged is: " & teststring & "<br/>" Response.Write...

Hi all, I have not used arrays before and am having a problem working out how to insert multiple rows into MySQL DB. This is my test form: <form action="insert-answers.php" method="post"> <input type="text" name="answer[1]"> <input type="text" name="aValue[1]"><br> <input type="text"...

I am changing over to PHP/MySQL/Apache from ASP. I am just going through all the stuff in basic form that I will need for my first PHP app and have already wasted an incredible amount of time on an insert to DB page. I feel really stupid, but I just can't find the right combination for the if...

Hi guys, During the last few years I have learnt ASP and built smallish webapps, with great help from this forum. I love ASP its been a good friend. Although I could not say like Tarwn that I know it inside out, I can do most things I want. About two years ago I was sent on a DotNet training...

Hi all, I use Dreamweaver for html and css but nowadays like to write my own asp code (as advised in this forum). However I use an asp upload script which was sold as a DW extension. I have adapted it a lot to suit my needs, rewriting most of the silly DW asp code surrounding it. Now there is a...

Hi guys, I need the difference in days between two fields which have datetime entries, StartDate and EndDate, put into a third field called TotalDays. I need the number of days between dates for each entry. I have tried "datediff(day, StartDate, EndDate)" as the TotalDays column default value...

Hi all, I am having a hard time finding anything out about using asp custom error pages in IIS6. I develop on my laptop which has XP and IIS5. I need to get some info about page not found 404 errors. I already have a custom error page 404 setup, its a .htm. So I make an asp page instead with...

Hi all, I have an html page in a password protected folder on an internet website 1. I want to make a hyperlink available to a file up/download page on website 2 on another server. This transfer needs to take with it some credentials to authenticate it with the receiving asp page which would be...

Hi guys, I have a problem with a select stored procedure. This runs fine using the query - EXEC dbo.sp_getFileCategory @FileID = 4 (FileID is seed PK) CREATE PROCEDURE dbo.sp_getFileCategory @FileID INT = NULL AS BEGIN SET NOCOUNT ON SELECT FileID...

Hi all, I have a web page displaying various types of uploaded files (details stored in SQL 2000). The page headings and other page details need 2 recordsets, and if I do it the simple (for me) way then I will require 8 recordsets for each of the 8 file types so they display under sub headings...

Hi guys, I have been given access to a 'view' from another SQL database which is on the same physical server as my website's database. I have no control over this other database. All the raw details about a few thousand documents in pdf format are available. The other database classifies the...

Hi guys, I know how to check if a file exists on the webserver an asp page resides on, but does anyone know if you can check an http://anothersite.com/downloads/test.pdf type of path to see if a file exists? I have an associated site on another server that stores its pdf files (several...