if there is a method out there that allows me to create a web page util to see if URL links are still valid. In other words I've created a system whereby a user can add their own links/urls page, but they want to periodically check whether all of these links by executing a multi-check.
My theoretical thought on this would be that the script would check if it receives a 404 on each page request and mark a flag if and when it gets it, but as to how I would do this in ASP or JavaScript.
already created a Database Util class using ASP Classic that they would be willing to share which prevents things such as:
-Replaces single tick with double tick so the SQL string is not compromised -Prevents SQL injection -Any other SQL prevention code that I am missing here
I have searched and found bits and pieces but I wanted to add this post to also find out what other items I should be concerned about with SQL that I do not have listed.
Is there a way I can make my server's 404 page display even when a correct page is requested?
Here's what I'm doing: on a certain page, the requestor's IP number is checked. If the number is an intranet number (192.168.x.x or 10.x.x.x), then the user is allowed to see the page. Otherwise, I want the 404 page to appear, as if the page doesn't even exist.
i want to include an xml file as an asp include file - i'm transforming it using xslt, but it just appears as a blank.i take it i have to use xslt to transform the xml file to an asp page. can anyone point me to tutorials or tell me how ?
I am looking to create some sort of function that on the click of a submit button, a new HTML page will be created. Is this a simple task or something that I should research?
i am creating a appointment calender everything is fine except for one page what I want is to have no duplicate times for example if someone books 2opm on tuesday 22 of june no one else can book the same time.
I have set the database to not allow duplicate entries but I need a page that if someone tries to book the same time it will say sorry that time is taken.
how to get started with this project. I want a page where a user can manually enter an order. Our users know our order# system and it's much easier to manually enter items as opposed to using a shopping cart and flipping through multiple pages. On the page would be the following.... 1) Billing address 2) shipping address 3) fields for order numbers
Billing and shipping seem pretty straight forward. Because I have no idea of how many products a customer will order, I'm picturing a new order# field being created when one is filled out. How do I do this?Then, assuming I get all these dynamically generated fields, how do I get them into an OrderDetails table?
i have been trying to create a search and result page. - (The same page if possible) using both Dreamweaver and Frontpage. But keeps returning a provider failure code. i know want to just code it to see if that will work but am a newbie when it comes to coding. I wish to do a search on 1 field in a SQL database if at all possible using a trusted connection, but return more fields from various tables.
I got a ASP page where one can add a record or update any existing records. As soon as a record is added it is appended to the existing records. With this design user can check for erors in existing records or the added record. Initially, there was ino data validation rule.
Now, as soon as I am putting data validation via script, I cannot update the exisiting data as the validation looks for empty space in the text boxes meant for adding data. Is there any way, I can avoid this situation and can update existing records. If this is possible, how does one validate the existing records.
I’ve created an application with 3 pages[forms] that have information that must be entered. This application has a session variable that is passed from page to page to ensure that the information that is put in the tables in the Sql Server database is linked together. It also sends an email after the last page is submitted.
My problem is that I am trying to create a page that will show the user what they have entered and allow them to go back and make changes if necessary, before they go to the next page. [A verification page I guess you would say]
I have created the 1st verification page which shows the info [from the first form] the way I want it to and it allows them to go back and make changes, [while I’m testing locally, that is]. When I go live, it skips over the 1st verification page and goes straight to the next form page. It does process all the code that is in the verification page and adds the info to the database but it will not show the verification page! When I do get it to show the verification page, it does not process the code behind the page that adds to the database. Code:
I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst' Does someone know where i am going wrong? Code:
I have a database that holds information in many tables. I have created an "Update" and an "Insert" form in dreamweaver MX 2004 which work fine but it allows me to add duplicate names in to the database. Does anyone know of any codeto stop this. If possible i would like it to bring up a pop up saying "Client Name Already Exists" etc
I have an .asp page that correctly queries a table and returns data if a 'job number' and week ending date exist and the user can update the information that is there. What I need to do is, if a record does not exist the page needs to create one and then refresh/requery so the user can edit the data. Any suggestions on how to accomplish this?
i have a textbox for user to put there loginid...and one button login valiablity...where user can click to check this userid is available...till here everything is ine...suppose between this another user registerd with same userid..and now first user will put this user id than it will get non avaliblity of this id.so in such case what should i do?
I have built a page that lists all our databases, the users connected to each database, and what application they are using. Because these databases are moved, or removed from time to time I need to check if the database still exists before trying to query it. Otherwise I get funny SID errors when it tries to process this command:-
Just wondering if someone could look at this and see where I may be going wrong. The basic concept is to use FileSystemObject to see if an image exists. If it does, display the image. If not, display image does not exists message.
<% Set fs=Server.CreateObject("Scripting.FileSystemObject") strFilename = ="e:path oimageprodPixscienceTN" & (RecordSet1.Fields.Item("ID").Value) & ".jpg" If (fs.FileExists(strFilename))=true Then %> <%=(Recordset1.Fields.Item("ID").Value)%> <% Else Response.Write("No Image Available") End If set fs=nothing %>
I populate a recordset and dump it into an array. How can I check if a value exist in the array? I want to check if the c_Member_mgr has a particular value or not?
Dim rs2 set rs2 = Server.CreateObject("ADODB.Recordset") rs2.open sub_Emp_Source, Conn
Dim aSubordinates
If not rs2.EOF then
aSubordinates = rs2.GetRows()
'Close Recordset to use the new array with the 2 columns data rs2.Close() set rs2 = Nothing
'Declare Constants for the above SQL columns for better readability 'Use these Constants instead of referring to the array numeric indexes Const c_Member_Mgr = 0 Const c_Subordinate = 1 Const c_EmpID = 3 Const c_EmpName = 4
I'm building some dynamic image links based on if the image file exists. How can I check 'if files exists' using asp or javascript? I've messed around some with FileSystemObject but so far no success.
is it possible to check a table exists before opening the record set? We have a sql query that requests information from a table depending on what information the user enters. So if the user enters information that requests a table that does not exist then I get the following error -:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'y2005m12'
therefore is there a way to check the table exists before running the query or opening the recordset, and therefore redirecting the user to a different pages informing them of the problem?
