Hey all, I'm far from new to programming, neither ASP nor SQL. However, my SQL knowhow is apparently wanting... I have allways validated user input to pieces prior to integrating it into a SQL statement, in order to avoid SQL Injection attacs. A colleague of mine told me that binding my ...more >>

Is there a way to suprress the HTTP_Referer using VBScript/ASP? Thank you! ...more >>

Can someone suggest a few software tools (preferably free ones) that can be used to test the performance of an ASP application? Thanks, Arpan ...more >>

I'm turning green on this!! What I need to do is insert a date from a textfield by using rsFakt("DomeneDato") = Request.Form("DatoDomene") I just get this error: Provider error '80020005' Type mismatch. /Server_ny.asp, line 344 The database-field is set up with date/time. I use...more >>

How do I find out how many columns exist in a SQL Server DB table before displaying the records of that table? Also how do I get all the column names as an array so that I can seperate each column using the Split function? Thanks, Arpan ...more >>

Hi, I am wondering how to do automatic ASP background process to generate every few minutes statistics from DataBase? I.e. how many people are already registered... or how many people were born in 1980(?) etc... And of course this background process should insert measurements into a special ROW ...more >>

Hi, Does anyone know if there are any scripts/tutorials to resize an image in pure asp/vb without the use of components/cgi? In the past I have used components to do this however in this particular instance i am unable to. Any suggestions/thoughts appreciated. J...more >>

Hello - I pass an item to an asp page as a query string. The value has a space in it. On the receiving page, the value displays fine just as a variable, but if I use it to pre-fill an input box, only the first word displays. Ex: The URL- http://myserver.com/test.asp?Item=Blue%20Vase The pa...more >>

I would like to retrieve a remote URL using the XMLHTTP object. However, I only want to "display" a certain portion of the page. How can I go about doing this? Thank you! ...more >>

Ok, I'm stumped on something that really shouldn't be this hard. I've created some cool code to transform a dataset via XSLT into SpreadsheetML (XML for Excel) and I'm storing the physical file on a file server. Now... I currently provide a hyperlink to view/save the file, but this won't wor...more >>

Hello to all, I have the following code that consults a data base SQL server: SET CONN = Server.CreateObject("ADODB.Connection") CONN.Open application("StrConApp") Set R = conn.Execute("select * from usuarios order by cargo") strSQLs = "select Venta,Margen,Abrasion,Steel,AcEsp,KAB,SIndustria...more >>

Hi, I was wondering if for an application, I can change the default session timeout property via IIS Administration? If so, how does one do it. Thanks in advance. ...more >>

I've created a Stored Procedure which adds a new record and updates some more records and then returns the primary key for the added record. The SP seems to work OK, but I'm having problems getting at the returned key in my ASP code: "Item cannot be found in the collection corresponding to...more >>

I have a website which has a popup window (this only opens when the user chooses to open it). In the popup window I have a <select> control which lists a selection of "classes". Each class has a description and a class_id (stored in the value attribute of each option). The user will then selec...more >>

Hello i have following problem with ASP (using Interdev, Win2003 Server): if a special character is entered in a textbox, ASP or the Client Browser (IE 6) seems to convert this character in HTML entities. eg characters on this site: http://unicode.e-workers.de/kyrillisch.php come back as...more >>

Hi, I'm facing typical problem in SQL Server SP & ASP When ever i try to insert new record, the record has been inserted and gives error " User Already Found" How to solve this issue? Thanks in Advance. -DNK My SP: ------------------------- CREATE PROCEDURE [dbo].[sp_InsertUser] ...more >>

I have a table with a huge amount of data. At present my data is like so. userid:1588 | 1 | CR1 userid:1588 | 2 | CR2 userid:1588 | 1 | CR3 userid:1588 | 1 | CR4 userid:1588 | 1 | CR5 userid:1588 | 2 | CR6 Intened format below: userid | CR1| CR2| CR3| CR4| CR5| CR6 "Columns" ...more >>

Hi, I need asp.net code for conditioned-redirection: I have multiple domains pointing to one page , let's call it page0.aspx I want to put a code in page0.aspx so when domain1 opens page0.aspx it redirects it to page1.aspx when domain2 opens page0.aspx it redirects it to page2.aspx ......more >>

An ASP application updates a SQL Server database table after a Form is submitted after which the user is directed to another page that should display the updated records. If the code is ---------------------------------------- 'records get updated here Response.Redirect("Records.asp") objR...more >>

Suppose an ASP application which retrieves data from a SQL Server database table is accessed by 100 users. Each of the users have a password. Assume that the DB table has 25 columns [Column1....Column25] & the passwords of 3 users are 'A1', 'B2', 'C3' (excluding the quotes). What the applicati...more >>

I'm a new to asp and I'm trying to display the entired last row on the DB. I try the objRecordset.MoveLast but I get the erros saying "Rowset does not support fetching backward." How I can do that? Thanks in advance for any help -- Pao Pao...more >>

Here's my project info first... DB: Access 2000 server: IIS 2003 Here is the error I'm getting... ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /admin/website_specs_step1_process.asp, line 166 H...more >>

On one of my client's website customer's are uploading a few files each week using SA-FileUp. My clients wants that each uploaded file to be copied on another website he has got. Any hint on how to copy one file between domains ? I was thinking about using AspHTTP which is installed on the ori...more >>

Hello.. I'm for a very long time trying to make somthing, but everytime it = doesn't work.. This is what must happend: If i have a guestbook with 100 letters, then wath i want is that a = script distribute the letters on a page of 10 end that i have under the = letters a buttun to go to te...more >>

When I fill an html table using ASP with data from a database, there is no border around any cell that has no data. I know I can manually put in a blank character or nbsp, but how do I do this when I am using asp? Has anyone else had this problem and came across an easy fix? Thanks, Doug ...more >>

Hi, I am facing problems with the replace command in classic ASP. my code is as follows: .......... test = Replace(test,"xxxx/xxxxxxxxxx","yyy/yyyyy",,,1) .......... I want to use compare method as vbTextCompare i.e. 1 When I remove this parameter, it works fine. the error is as fo...more >>

So I'm new to ASP and set it up on my computer and just want a simple text based guestbook where it just adds your entry to the end of the textfile and to display just displays the contents of the textfile. So displaying the contents is not the problem. Here is the code <html> <body> <% C...more >>

I create an ASP application for Windows 2003 server (Czech) with Exchange 2003. When I want to create new user in Active Directory from my application - this error occurs: Active Directory error 80070005' General Access error denied Web application runs under ADMINISTRATOR account and prob...more >>

I have a web server that has a COM+ DLL. This is successfully called by a web page running on that server. I exported the COM+ package (as an MSI and NOT as a proxy stub) and imported it onto a new machine. I set up the web application in (I believe) an identical fashion. When I run the ...more >>

Hi, I've a problem with code that should produce a Windows(ANSI) encoded text file but doesn't. Server is IIS 5 on Win 2k, with ASP ver? My ASP uses data from an upstream HTML form on a UTF-8 encoded page. The latter is output by a server-side system and I can't alter that source format. ...more >>

My users have to select an value from a fixed selection of values. The obvious choice of control for such a requirement is to use a <select> (i.e. a combo box). My problem is that sometimes, these combo boxes will have a *large* number of values. There could be any number of values in them ...more >>

What is the best way to produce these? Is there a SQL statement that selects, say, records 30-40 from the results? ...more >>

Is possible to have a connection to SQL server and another one conaxion to a data base Access to process data among them Thanks. ...more >>

Hi, We have a web application(asp based) without any report features. I have to build web reports. Right now, these reports are build on an Access 97 desktop application. The idea is to have our clients to print the reports via web application. I am wondering, what is the best way to develo...more >>

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 It's getting a bit tiresome seeing one misguided American after another with their cutsie little yellow or red-white-blue ribbons on their outsized SUVs. Yeah, I guess it's the thing to do; maybe part of that whole soccer-mom culture. Unfortuna...more >>

I have an ASP application that is a electronic purchase orders system. My problem is that only 3 people can authorise a purchase order. When a purchase order is selected I update the table to show that the field is locked. If they complete the form then the database is updated and the lock ...more >>

Hello, I have the below requirement. When ever my website is opened by any link: say clicked from the google search result or a link from other website: Then I should able to know the referrer URL. How Do I get that? I know about Request.ServerVariables("HTTP_REFERER"). So I used this i...more >>