[classic-asp] Forum Topics

For some reason I keep getting the following error: [code=asp] error '80020009' Exception occurred. [/code] It applies to the line of code: [code=asp] If (cInt(objRS("User_ID")) = Cookie_ID) Then [/code] for some reason it freaks out with "cInt(objRS("User_ID"))" when it runs through the db to find a User ID that matches …

Hello, I am using ASP and MS SQL Sever 2000 as backend database.. I am writing a SQL query which will pick up top 5 recipes details who have scored the highest marks from the following table tblrecipes - [code] ID | recipe_name | Total [/code] [u]The following points to …

Hello Im sorry to ask such a basic question - but I am doing some development work in ASP and need to know where I can find a reference library of standard functions for string handling and Date functions. A complete library would be really great. The next question is …

I'm working in VBScript and want to sort a multidimensional array on two of the columns in it. I've got a function (based on TONS of examples around the Net) that is sorting on one column, but I can't seem to get how to then do a second column. I'm …

I'm using this code to place Time\Date stamps in specific Access Columns: [code=asp] Dim conn,strsql,sql_update,ssn,cps,hdDate,TOD,PageDate,h h=hour(now()) ssn = "Select SSN From CWCT07 where SSN = '" & Request.Form("SSN") & "'" If _ (Request.form("PageDate")) = "1/30/2007" And "h" < "12" _ Then _ sql_update = "Update CWCT07 Set Jan30AM = '" …

We had recently upgraded our IIS 5 to IIS 6 version for better performance of our ASP based portal. After the upgrade we have been facing a strange issue with the portal. When we click the back button of the browser it displays “web page expired” instead of showing the …

Hi all, how, using asp, can i make a form menu change the style sheet loaded, when it is clicked on, then refresh and page, and create a cookie which tells the browser which style sheet to load for that user when they next enter the website? Thanks, Max.

here is the asp code: [Response.Redirect("[URL]http://www.yahoo.com[/URL]")] what i am trying to do is loop through my database and send variables through a querystring to the same target address. but if my code redirects to the target url it will stop at the first record before it gets to the next. …

Have gotten the select statement and Update statement to work separatly, but need them to work on the same page and cannot seem to make it happen. Here is the current state of things. Any help would be appreciated. [code=asp] <% Dim conn,rs,strsql,sql_update,ssn,cps strsql = "Select SSN From CWCT07 where …

I have a problem creating a ODBC connection. I am using MS SQL server 2000. Local access. I create it in System DSN. 1. I select the "With SQL Server authentication using a login ID and password entered by the user rather than Windows NT. But the error message occur …

I hope someone can help me decide what is happening with this. It recognizes and carries out the select statement, will redirect to the proper place if entry is valid/invalid, but will not insert anything into the database. I first wanted an timestamp but am trying to troubleshoot backwards and …

need help on making an reply back in either VBScript or JavaScript or in ASP or in HTML, can some one please teach me I need it on my current project. please?

Hello All, I am using an ASP script on my site that reads a microsoft excel file and adds the values to the database (MS SQL Server). The script works completely fine on my LOCAL server, but it shows me the following error when I upload it to the server …

Hi,I use Response.ContentType = "application/vnd.ms-excel" in ASP in order to print out all my records in excel file. My problem is how to make the excel file auto continue to print the data to next new worksheet if the records is more than 65536 rows (every worksheet only limit to …

[COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I …

File Download Dialog Box(ASP) I have a ASP Page that allow the users to Download a File @ the Click of the button the [B]File Download Dialog Box [/B] will pop up on the Scream ,on the download dialog Box are 4 buttons namely[B] Open [/B] ,[B]Save[/B],[B]Cancel[/B] and [B]More Info[/B] …

Hi, I'm posthumous. I'm a Web developer. I've got some legacy ASP and VB but it looks like all new development is going to be ColdFusion. I hope ColdFusion people hang out here.

Hello, To start with here is the code: Public Function Paymentget (s12MoRate) strCompanyCode = objXML.selectSingleNode("policy/companyCode").text strState = objXML.selectSingleNode("policy/insured/state").text set rsDownPayment = getCache("down_payment") dim tempPremium, totalTaxes totalTaxes = 0 tempPremium = s12MoRate ' calculate the taxes so they can be front loaded in the payment schedule dim TaxCov for each TaxCov …

[COLOR=#000000]Have problems with the recordset…if the value of tempPremium is more than > 10,000 than I get no results after this statement executes:[/COLOR] [COLOR=#000000][/COLOR] [COLOR=#000000]set rsDownPayment = applyFilterAndReloadRecordset(rsDownPayment,"min_premium <=" & tempPremium & " and b80_userline = '" & objLogic.userline & "' and profile = '" & objLogic.profile & "'")[/COLOR] [COLOR=#000000]I …

I am having a problem reading a .txt file off a web page using Microsoft's XMLHTTP method. After reading the the page into a variable called strContents I would like to write the data to a file. I have the following code but seem to get an error in writing …

Hi im having trouble creating a MS Access Databse using ASP. Scenario: When a user registers, i want to be able to create an MS access database. Here is a little code im using.. [code] <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include virtual="Includes/adovbs.inc"--> <% Dim sDatabaseName sDatabaseName = "\access_db\MyNewDatabase.mdb" Sub CreateAccessDatabase(sDatabaseToCreate) Dim catNewDB ' …

hey can i get an ASP based XML Editor for a CMS purpose

Hello, I have a question: Suppose I have a table named as tblfriends and there are 3 columns with several row. Column names are: name, email, phone I want to pick 5 names randomly from the table each time my asp page refreshes. How can this be coded in classic …

I am trying to generate a report in asp that breaks down sales, credits, misc daily, weekly, month. Not sure how to do this. The date format in the db is yyyy-mm-dd.

I have a radio button i want it to bind with database field when i click on the radio button it will call the value n get displayed all data in textbox given. how to do it

i am developing a application that if i want to send sms from my application to my client mobile.what language i would use presently my application is in vb6 and also in asp

Hello I am using a hometemplate for the homepage and another one for all the inner pages. I would like to use a 3rd one for some of the inner pages where I don't want to display the left nav, but only the footer and top nav. In pages like …

Hello all - I've got an interesting problem that I can't seem to solve, so any input on this would be greatly appreciated. I have a group of web pages. I'm passing several variables back and forth between those pages successfully. One of the variables is called sntime. Essentially, it's …

Hello All, I need a help from you all ,I have a big problem right now I am developing a stock market related site where I have to calculate XIRR return of investment and this is in built function of excel So wht I want is to take data from …

I have a Select in a form, which has multiple values. How can I get all the values from the Request Form collection ? I am using the post method. When I am specifying [CODE] Response.write Request.Form("Select1") [/CODE] it only shows the last value. I have tried using Request.Form("Select1").options[x] as …

well i have started software and web Development business. But I dont have an idea about Relative Link what is this.When i develop website for my client how i use Relative link in my Client's Website

well i have started software and web Development business. But I dont have an idea about Absolute Link what is this.When i develop website for my client how i use absolute link in my Client's Website

well i have started software and web Development business. But I dont have an idea about Link Exchange what is this.When i develop website for my client how i use Link Exchange in my Client's Website

well i have started software and web Development business. But I dont have an idea about Recomended Link what is this.When i develop website for my client how i use Recomended link in my Client's Website

hey frends.. i have to create a asp page with 2 select pulldowns(state,city),options to b displayed in the CITY depends on STATE choice. the option list is to retrived from a db dynamically. i have a table with fields--state,stateID,city,cityID. here is the code snippet i have.. :idea:[code=asp] <html> <head> <title>testpage</title> …

[code=asp] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[URL]http://www.w3.org/TR/html4/loose.dtd[/URL]"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Untitled Document</title> </head> <body> <% '***** BEGIN FUNCTIONS ***** ' This function takes a string as input and links any www's it ' finds so that they are then clickable in a browser. If only …

Hello. I want to make forms in ASP (login and contact forms) Let's start with the contact page: (where the form is) (is this right, and am I gonna call it for example; contact.html or contact.asp? [code=html] <html> <head> <title>Hope you can help me...</title> </head> <body> <form action="thanks.asp"> Name: <input …

I used the following tutorial to make my login system. [URL]http://support.microsoft.com/default.aspx?scid=kb;en-us;321439[/URL] i have a error with the page, when i try and login using it, i get the error "Error is: 006~ASP 0158~Missing URL~A URL is required." Also using this system i want to make a page where users can …

Hi. I have a Java Applet with an assortment of buttons that is loaded onto an html web page. I would like any given button to run my ASP code which returns a web page containing results from a database query. But I can't figure out how to link the …

I am trying to code a page for an internal website that will generate a list of files and display them on an ASP page. I have this portion of the code working. I am trying to load an HTA page to run an executable with a parameter of whichever …

[COLOR=#000000]Hello,[/COLOR] [COLOR=#000000]Here is the code: [/COLOR] [COLOR=#000000]<tr>[/COLOR] [COLOR=#000000]<tr>[/COLOR] [COLOR=#000000]<td class="FormCell">Do you live in US? </td>[/COLOR] [COLOR=#000000]<td class="FormCell"><input type="radio" value="true" name="Country">Yes</td>[/COLOR] [COLOR=#000000]<td class="FormCell"><input type="radio" value="false" checked name="Country">No</td>[/COLOR] [COLOR=#000000]</tr>[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000] <% if true then %> [/COLOR] [COLOR=#000000] <td class="FormCell"> This is a test </td>[/COLOR] [COLOR=#000000]<td class="FormCell" colspan="2"><select name="TEST">[/COLOR] [COLOR=#000000] <option …

Hi People, I'm fresh to the forum, come from a design background and now living and working in london looking to startup a website as detailed below, get in touch if your interested or just want to have a chat and share ideas etc Yes we're looking for talent with …

Hi all, im trying to make a script which sends the link of the page to a specified email address. I have made it work by using a script from an external file, but when i call up the server variable request url, ht gets the wrong one, so i …

Case: [URL=http://www.newegg.com/Product/Product.asp?Item=N82E16811163015]SILVERSTONE TJ-03[/URL] $273.99 Fans: 2 x [URL=http://www.ncix.com/products/index.php?sku=21011&vpn=NF-S12-800&manufacture=Noctua]Noctua NF-S12-800 120MM[/URL] $19.50 each MotherBoard:[URL=http://www.newegg.com/product/product.asp?item=N82E16813188009]EVGA 122-CK-NF68-AR[/URL]$249.99 Memory: [URL=http://www.newegg.com/Product/Product.asp?Item=N82E16820146563]Crucial Technology Ballistix 2GB [/URL] $ 309.99 Power Supply: [URL=http://www.newegg.com/Product/Product.asp?Item=N82E16817190012]XION Supernova XON-600R14-201 ATX 600W[/URL] $109.99 Procesor: [URL=http://www.newegg.com/Product/Product.asp?Item=N82E16819115001]Intel Core 2 Extreme X6800 Conroe 2.93GHz [/URL] $966.99 I'm going to use my GeForce 7800 GT that I …

Hi. I understand that ASP is server side and JS is, at least in my case, run on the client. So, an ASP process will be run before a JS process. I want to make them work together if possible. Here is my problem: I have an ASP process that …

How do I convert [B]12/15/1985 [/B]to [B]15 December 1985[/B] format using classic ASP? Thanx in advance

I have multiple pages with the same information on them (forthcoming events information), and when that information needs to be changed i have to change every page which takes time. I was wondering if XML can be used to change the information on the pages by editing one central XML …

I am a novice . Just started to design webpages. I have an ASP page., where there is an INPUT TEXT BOX. I input a Tel No into this input box. Now I need to fetch the Name and Address from a 5 column EXCEL sheet ( Telno, Name, Address1, …

Hi, I am trying to send the following HTML mail thru the ASP CDO component. This is the HTML mail i wanna send from Page 1: [CODE]<div align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><div align="center"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="820" height="540"> <param name="movie" value="http://mywebsite.com/movie1.swf"> <param name="quality" value="high"> <embed src="http://mywebsite.com/movie1.swf" quality="high" …

Hi, I am building class for my project ,but yhe problem i do not get the proper answer here is the code [System.ComponentModel.DesignerCategoryAttribute("code")] public class Buying : System.Data.DataSet { private ContractDataTable tableContract; private BuyerDataTable tableBuyer; // private SellerDataTable tableSeller; public Buying() { this.InitClass(); // // TODO: Add constructor logic here …