I have the following equation. <% varWT = Round(CInt((rsFreePack.Fields.Item("Weight").Value)) + CInt(Session("w"))) %> Assume.... Round(CInt((rsFreePack.Fields.Item("Weight").Value)) = .12 CInt(Session("w")) = 30 How can I get it to always ROUND up to 31 ...? thanks ...more >>

I have a Drop Down box that is being populated using the SQL Distinct command. How do I get it so it doesn't show Null values? Here is my SQL statement sSQL = "SELECT DISTINCT Title FROM Everyone ORDER BY Title ASC" ...more >>

I have 3 drop down boxes on the same page. Each one is being populated by a database. One is called Location, One is called Device and the other one is called Job Title. When the user selects something from one of the drop down boxes I would like it so it automatically calls the phonelist.asp an...more >>

I want to create textboxes dynamically but with dynamic names also. i am retrieveing a load of values from a table in SQL into a DataReader. Then i want to create textboxes from those variables. I want to dim various textboxes with different names depending on what I retrieve from SQL. I ...more >>

Hi All, Is it possible to read any ASP variable from a javascript file (.js) ? Thanks Prabhat ...more >>

Hello, I want to do a Ms Word document in a ASP page. I can do it, With the code lines: ///// Response.ContentType = "application/msword" Response.AddHeader "content-disposition", "inline; filename=OrderFax.doc" //// With these lines all document content show like a Word document. But i...more >>

I have an XML file which I access from a remote server like Set http = CreateObject("MSXML2.ServerXMLHTTP") http.open "GET","http://www.andrewlouis.co.uk/viewcountries.xml",false http.send strXML = http.responseText The real server is password protected with, I think, with basic authentic...more >>

Hi, I'm trying to write a piece of ASP that will allow me to display only one element of a XML file. I am new to XML and wanted to find out what I am doing wrong. I think it may be to do with the nodes ? When this is currently run it comes up with the error "Overflow" ('800a0006'). Any p...more >>

Is there a way to get the name of the page that was submited to another asp page?? ...more >>

I have an ASP login section on my site that is experiencing some problems. Go to the following page and create a fake account (this is a test environment, so don't worry): http://seminarystreet.com/dev_testing/registration/default.asp Upon completion, you will be redirected to the login pa...more >>

Hi, I have a input with type checkbox. I want it to be automatically checked if the value from the corresponding field in the database is also checked. I tried this: <% set objdc = Server.CreateObject("ADODB.Connection") etc ... sql="select maa13 from mytable" dim rsArray Set rs = objdc.e...more >>

Hi All, I have the following code: Basically when I enter the server name and hit the "submit" button, IE says "the page cannot be displayed.There is a problem with the page you are trying to reach and it cannot be displayed.". Further, how can I debug my code, is there a debugger I should ...more >>

Hello All I am writing an asp app for generating quotes. What I would like to do is allow the user to edit the quote lines without having to open a new page each line. On the quote I have created a loop which goes through the recordset and populates a sort of data grid. Can you use javascri...more >>

hi - I have a form with 6 multiline text boxes each accepting data to be stored in a memo field. the form accept as much date as can be typed, but refuses to send data after a certain limit (havent actually counted the # characters) Is there a limit to the number of characters a form can s...more >>

be patient, it's me again: I copied this code from http://http://www.w3schools.com/asp/showasp.asp?filename=demo_reqquery. I created the file demo_reqquery.asp in the web site folder but when I execute it, after digiting a name and pressing enter, not output is produced (ie the string "hell...more >>

In using a page with IFrame, I woudl like to write a line like this: If (certain criteria met) then response.redirect(somepage.asp) end if Pretty simple, except that I would like to make it to the full page. In other words, if it were a regular HTML hyperlink, the code would be <a href=som...more >>

Hi all, I cannot understand why, I simply create a new web site using Windows 2000, IIS 5. I use say c:\test as a home page, in this folder there is a file homepage.asp. I assign a dedicated ip address to this web site. If I try to browse to this web site I just get a "You are not autho...more >>

hi this code bellow get data from a web service (tradicional asp) but result is not parsed into XML ... that is, JUST get "cat4" instead of "<animal><name>cat</name><legs>4</legs></animal> set osoap= Server.CreateObject("MSSOAP.SoapClient30") osoap.ClientProperty("ServerHTTPRequest")...more >>

I have an error handling routine that emails me the Err.Source, Err.Nbr, and Err.Description in the event of an error. How can I include the line number of the error as well and the filename? *** Sent via Developersdex http://www.developersdex.com ***...more >>

How do I change this script to delete records after they are one year old? RSa.MoveNext Loop set fso = Nothing RSa.Close ' Then, Delete old notifications sql = "DELETE FROM residential WHERE enddate < #" & DateAdd("d",-365,NOW()) & "#" RSa.Open sql, "DSN=Auction" sql = "DELETE...more >>

I just finished writing an app for an ASP.NET website which uses SQL, C# ASP.NET and web services on my development box. Ported the app over to the Web Server (running W2K3, IIS 6, SQL2K), created the website on IIS, setup the appropriate SQL db, and loaded VS.NET 2K3 to compile the app. Howev...more >>

What am I missing here. Why doesn't this produce a random string. It is kind of random. <% Const ConstantLower = "bcdfghjklmnpqrstvwxyz" Const VowelLower = "aeiou" Const Numbers = "0123456789" Const NumOfChar = 12 Dim x : x = 0 Dim TmpVal Dim TmpName Dim y y = 0 Do wh...more >>

I'm getting the following error on my locahost at work when I browse in IIS. "Class does not exist. " I created a web site in classic asp but I get this error. When I check IIS for the web logs it gives me 18:52:07 127.0.0.1 GET /PatientPortal/blank.asp 500 What can I do to correct this? ...more >>

Why can't I get the following running??? <% Dim GetODBCdsn GetODBCdsn = <!--#include virtual="\connections\sqlconnection.txt" --> Response.Write(GetODBCdsn) %> TIA, Steve ...more >>

hi, had a question on preloading a dropdown. we have a textbox and dropdown on the page, user is suppose to enter in a zip into textbox, then the dropdown should load the state based on the zip. we can pull the state from the database on a zip match table, but how do we preload the dropdown, ...more >>

I have an asp page accepting input from users Lets say this is form A, form A passes data to another form (say form B) to validate the data, if its valid then I want to open up another asp form (say form C) that does some queries based on data sent by form B. I need help in opening the for...more >>

Hi All, How can i find an asp file's TAG like input, button from another asp file... For example i call a.asp from internet explorer and i want to list b.asp 's elements.(input, button, etc...) Thanks alot. ...more >>

Hello, I have enabled authentication for the site in iis and set the default domain to the domain we are on. This is working fine and when i list all the server variables it shows the auth_user as domain\username so all is good there. However we have a NAS server that has a hidden share a...more >>

Hi All Do u know of any good ng or forum that specifically tackles ASP ecommerce queries? Thanks Laphan ...more >>

First of all, my apologies for the xpost. I realise the netiqute, but this query seems to cross the boundaries of both these groups. Basically I have created a small ASP site that allows a user to upload their own pics via ASPupload so that they can be used on their site. I use a very sim...more >>

Hi Everybody I put the On Error Resume Next command as the very first line in my ASP pages, which may contain various inc files and sub-routines/functions, so that I can try and stop the dreaded DB error messages displaying to visitors and would-be hackers. My question is, does this one ...more >>

I have created an Excel spreadsheet for the web. When it opens in IE 6.0 I get the message that the format is not supported. This is because it is in tab delimited format. Ane when I save the file, It saves it as txt. How can this file be created so that Excel sees it as an .xls format. I create...more >>

Posting variables from an HTML FORM, via the Request.Form function on the receiving ASP page is great. But how can you POST a Form variable to an ASP page -- without a human pushing a Submit button? An ASP page that can decide when to POST and send the Form vaiables, but out without a hu...more >>

Hello, I want to be able to client process of the ASP page to get the value populated in Request("rssFeed"), how can I do this because the Request object is not available to the Client-side. Thanks ...more >>

I have a form which shows all Records from a database eg. select * from sometable the user inputs criteria in a form on the sam page and submits it. i need to see if the form has been submited. and the way to do it is to see if i have 'Request.form(somefield)' and then refrase the sql into ...more >>

I have read 10000 opinions on returning random records and I am more confused now that before I started. I have a small access db that will contain 20 or so rows with 3 or 4 columns. I like to return a set of 6 distinct rows and display the columns in html. I have seen response.write and ...more >>

If you try this url http://msdn.microsoft.com/library/en-us/dnanchor/html/anchoraspdotnet.asp you will lend at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anchoraspdotnet.asp Can anybody explain the rational behind such a design? Thanks in advance S...more >>

Will CDO work under Windows Server 2000? I'm guessing it will. The problem is that I wrote a nice little ASP app under Windows Server 2003 which works REALLY well. Sends out the email with NO problem. 'Course, it uses an external SMTP server, but I'm assuming this shouldn't matter, right?. B...more >>

Hi Just to confirm, if I create a cookie via one of my web sites, I can't call and query that cookie from a different site can I? I want to keep checking the state between a http site and a https site that both need to work together and at the moment I have to post the relevant session i...more >>

OK, the ProgID is correct. The .dll is registered. This is a permission issue. I can create objects when I disable anonymous access on the Web site in IIS (Win XP Pro). And I've given IUSR_<MachineName> pemissions all over the place (registry, files, folders, etc.)! Still can't create the o...more >>

Hi, Quick question. Is there any point in having response.end after response.redirect? Thanks in advance Christian ...more >>

I am building up a library of Class'es that represent various columns of table layouts. One often used column is "name" and each occurrence is treated identically. (What a concept, eh?) Part of that library of Class'es includes representations of various tables. (Just let me know if you see a ...more >>

Hi all, I am looking some ASP coding utilities, and I was hoping that some people out there wouls have suggestions. I am looking for a tool for ASP code that works similar to MZ Tools with VB. Basically, I would love to have something that can analyze the code base and tell where a certain...more >>

In an ASP page, I get the above error which is Error number 429. I have 2 seperate webs. 1 web you must log on. It creates an object by getting DLL just fine. This works great. The other web is open to the public, no login. The same web page gets the above error message. How can I have a...more >>

I have an application that we are moving to a 2003 server using IIS6. Currently, it works fine with IIS5 on a NT server. When I try to log into the application and connect to an Oracle DB, I get the following error: ADODB.Connection error '800a0bb9' Arguments are of the wrong type, are out of a...more >>

My prod box consists of the following: - Windows 2003 Server - Exchange 2003 If I use cdoConfig to send emails from my .asp application do I need to include the following typelib on my .asp page if I'm running Exchange 2003: <!--METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB-00C04FB...more >>

Hello, I have an aspx file where i've put a placeholder element. On load i create dynamically a table which contains a checkbox and a radiobuttonlist in each tablerow . The radiobuttonlist contains two items (yes,no). Both the checkboxes and the radiobuttonlist are NOT autopostbacked ( .autop...more >>

Hello, I'm experienced Windows programmer, however, I'm quite novice in HTML technologies. Recently I was assigned a task to write small utility for internal use in our development team. I chose to write its GUI in HTML and make front end as HTA. While developing application's logic is...more >>

I am working with Classes in classic VBScript on IIS 5.0 and am having a problem wrapping my head around a solution. I have a Class defining a record layout. (Bear with me here as I completely roach the OOP language.) The objects are columns of the record and each column is defined as its own ...more >>

Hi All, I want to store the processed salary information in the data base. My requirement is as follows: 1.For each location for an employee , I have to pay/deduct different components (at least 38 )which differ from person to person. 2.Each component is mapped to component table which...more >>