Active Server Pages (ASP) Programming Discussion

adCurrency problem in ASP

Jonathan Dodds - 26 Mar 2005 11:32 PM - 6 messages

I'm using ADO from an ASP 3.0 page written in JScript to query a database table in SQL Server 2000. One of the columns in a currency field. Instead of retrieving a value of 1095.60 like I expect, I'm getting ...

screen scraping

Roland Hall - 26 Mar 2005 6:51 PM - 5 messages

Am I correct in assuming screen scraping is just the response text sent to the browser? If so, would that mean that this could not be screen scraped? function moi() { var tag = '<a href='; var tagType1 = '"mail'+'to:', tagType2 = '">', tagType3 = '<\/a>'; ...

Newbie to ASP.Net

Xarky - 26 Mar 2005 3:59 PM - 4 messages

Hi, I am writing a small application and I am facing the 2 following problems. 1) I have implemented an authentication screen (simple username and password), and when user signs in, I use the following and redirect user to a main page ...

add data to access - fail

dek - 26 Mar 2005 7:01 AM - 4 messages

please review my asp code: <% Dim adoCon ''hold database connection object Dim rsAddRecord ''hold recordset for new record to be added ...

Permission denied error - MS Access

Benny - 26 Mar 2005 3:38 AM - 2 messages

Dear All, My ASP-MS Access application works fin in our local server and in our hosting I get this errors, while adding/editing or deleteing. When deleting a product: error Microsoft VBScript runtime error '800a0046' Permission denied /webadmin/Products.asp, line 27 ...

Storing objects in Session Variables - exactly why not?

mjkahn - 25 Mar 2005 10:45 PM - 15 messages

I've read (and read!) that you shouldn't store objects in Session variables. I've read these reasons: - The object takes up memory that may not be freed until the session times out. Better to create the object only when you actually use it. ...

Expert suggestion needed for a asp based web application

Jack - 25 Mar 2005 9:21 PM - 4 messages

Hi, We have a couple of web applications where data is updated on a weekly basis. The data entry is done in a vb access application which is kept internal. The database is uploaded to the web which has a web interface for ...

Create ASP.NET web application in the default website

Pranab - 25 Mar 2005 7:53 PM - 2 messages

On my local sandbox , in IIS I created some Websites . Now when I try to create a ASP.NET we app , it tries to create it in the website last created and fails . But my requirement is to create it in the Default We Site mapped to ...

Excel follow-up

middletree - 25 Mar 2005 5:42 PM - 13 messages

I read through Curt's sample code for using ASP to create a spreadsheet (.xls). I think I understand the basics, but am still running into problems. I'm doing this on an Intranet app, so I saved a page to an HTML file, and ...

Request.form usage not clear

Jack - 24 Mar 2005 11:29 PM - 6 messages

Hi, I am trying to get a thorough understanding of a code where a addition or deletion of records can be done from a list of records. For addition part of the form, data is being obtained from set of input boxes. ...

Session variable being reset by global.asa

joled - 24 Mar 2005 8:43 PM - 6 messages

Hello, It looks like a session variable that I created in the global.asa is being reset by the global.asa when you return to a pge in the virtual root directory. Ex. /vroot/index.asp - website home page ...

error message

Andrew - 24 Mar 2005 7:23 PM - 3 messages

Hi there, I migrate ASP to Win2003, and the error page doesn't display the errors but a general error like "The page cannot display..." when error displays, and the error doesn't occur in Win2000. How can I know the error message? thanks ...

Display aspx page or Reporting Services page in User Control

Ralph O'Flinn - 24 Mar 2005 7:01 PM - 5 messages

What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code? It would be very much appreciated! ...

Session variable usage?

McKirahan - 24 Mar 2005 6:47 PM - 7 messages

Is there a way to use a Session Variable to prevent the successful resubmission of a form if the user uses the Back button and tries to submit it again? Thanks in advance. ...

prob with ado reading http://

Ron - 24 Mar 2005 4:25 PM - 5 messages

Hello, I keep getting a runtime error with the following ado routine that I run from a VB6 app - note: I tried it with ref to mdac2.6 and mdac2.7 and mdac2.8. This worked once, but it doesn't work anymore. I think I changed something, ...

Help with command object parameters query?

What-a-Tool - 24 Mar 2005 11:05 AM - 8 messages

Have no problem getting my select queries to work using this method: strSQL = "SELECT tblUI.IPAdd FROM tblUI WHERE (tblUI.IPAdd =?)" arSPrm = Array(strRemHst) Set rst = cmd.Execute(,arSPrm) Can anyone point me to some examples of using this method for UPDATE and ...

Problems with the half symbol

Astra - 24 Mar 2005 10:46 AM - 3 messages

Hi All This is really bizarre prob that I don't know how I'm going to get round it. In essence I have created a site that allows the user to select their preferred shoe size, this then gets added to a simple cart and then they ...

Navigate in database

Vinnie Davidson - 24 Mar 2005 10:10 AM - 4 messages

Hi! I have a detail page that shows one spesific record based on the article ID. I need to make a navigation on this detail page, with "previous article" and "next article" links. So, my question is how can I get the previous and next article ID based on ...

ASP design question

Roland Hall - 23 Mar 2005 9:46 PM - 5 messages

If I wanted to write my own blog application, what functionality should it contain? TIA... ...

Sending CDONTS HTML email issue

BaWork - 23 Mar 2005 7:32 PM - 6 messages

I have a web form where a client can select which site members to send an email to. This form is populated from the contents of the member table, so the form can have 0-x names listed on it depending on member expiration dates. ...

Redirection question...

Frank Side Burns - 23 Mar 2005 7:13 PM - 4 messages

I have a web page (let's call it main.aspx) that must only be accessible thru another web page in my web application. Users should not be able to browse directly to 'main.aspx'...they can only be redirected their from ...

ASP Script Hangs

Andi B - 23 Mar 2005 7:11 PM - 9 messages

Hi folks, Wondering if anyone can help me - I have recently set up a website on our work intranet, which allows staff members in our team to attach a photo of themselves to their profile on the page. The photos are uploaded to the ...

Compiler Error Message: BC30451: Name 'changelang' is not declared.

selena - 23 Mar 2005 6:56 PM - 4 messages

I have created 2 ASP pages that gives users the option of switching back and forth between French and English. They click on the word English and it converted the text to English and the French link converts the text to French. In the ASP page with the form on it there ...

Saving and display of records in asp page

Jack - 23 Mar 2005 5:25 PM - 6 messages

Hi, I need to build a asp page where it would serve as a data entry record page as well as display page for records saved. This page should also allow editing of records that has been saved. e.g. ...

Generate a table with ASP

Øyvind Isaksen - 23 Mar 2005 4:33 PM - 5 messages

Hi! I need to create a table with 4 cols and X rows based on the number records in my database. I dont know how this can be done, mabye with an array? If I got for example 6 records in my database, a table with 4 cols and 2 ...

asp.net newbie question

romy - 23 Mar 2005 3:35 PM - 2 messages

Hi I'm trying to run some .aspx file (For testing) http://localhost/page.aspx For some reason the browser doesn't compile and run the script, but just display as text file. if page.aspx is blank then filedownload window pops. ...

SQL Question

Jim Holmes - 23 Mar 2005 3:29 PM - 5 messages

I have an Access table with a column of ascending values. I am trying to find the value in that column that is less than a calculated variable (kind of like the vlookup function in Excel). Haven't had any success in writing ...

Passing variable to frame page

Jeff - 23 Mar 2005 3:18 PM - 3 messages

I have a question. Is it possible to send a variable through a hyperlink, to a frames page, and have all 3 pages in the frame pick up the variable using the request.querystring ? In other words, I click on a link that has ?id=2 lets say.. it goes to a ...

beginning tutorial for exporting data from ASP to Excel

middletree - 23 Mar 2005 3:04 PM - 5 messages

I did a search in this forum, as well as at [link], and MSDN, and would like to know how to use ASP to build a report and create an .xls file as a result. ...

An error occured in ASP page

Petar Popara - 23 Mar 2005 12:31 PM - 3 messages

This is from Event Viewer. What is it? Error: Script Engine Exception. A ScriptEngine threw expection 'C0000005' in 'IActiveScript::SetScriptState()' from 'CActiveScriptEngine::ResetToUninitialized()'.. For additional information specific to this message please visit the Microsoft Online Support sitelocated at: [link] ...

how to use SSL with asp/vbscript

Dean g - 23 Mar 2005 9:41 AM - 3 messages

I'm complety new to ssl so this is a total newbie question, the isp i'm using has authorized ssl on my site but i dont know how to tell a particular page that it can only be run as a secure page... Where at the ...

ASP to Excell

Mustafa - 23 Mar 2005 2:57 AM - 2 messages

I have an ASP script where i am generating the excell sheet dynamically i am passing text as column heading which is long text so i want it to display it vertically in column (cell).In excell i can do it manually using format ...

Please help with cmd.execute select SQL?

What-a-Tool - 23 Mar 2005 2:06 AM - 6 messages

What is the proper format for my SQL str using command.execute? Even though I know I have matching data in my table, I keep coming up with a ..RecordCount of -1. What am I doing wrong? Thanks in advance : ...

string Truncated error

Chumley Walrus - 22 Mar 2005 6:53 PM - 4 messages

I'm getting a "string could be truncated" error at the line where my strSql is executed ( my_conn.Execute (strSql) ), but it doesnt happen all the time, just periodically. I used to have this pointing to an Access db, but I changed it over to Sql, getting rid of the # datetime ...

HTTP_REFERER question

M Smith - 22 Mar 2005 4:14 PM - 3 messages

On our web site we allow our members access to features hosted by another web site. The way the other web site authenticates users is to check the value of the HTTP_REFERER. If it comes from our Login.asp page it lets them ...

HELP! I've done something really stupid

Adam Short - 22 Mar 2005 3:09 PM - 3 messages

Take a plastic fork and stick it in my eye... In the persuit of gaining knowlwdge I have inadvertantly dropped a right clanger! I have a Windows 2003 IIS Server. All was well and good this morning, databases worked fine, then I started ...

Request.Form("") order from multi select

Mike D - 22 Mar 2005 12:55 PM - 2 messages

Will the Request.form show the correct order that they were displyed in or will it do something different. I have been testing and it always shows the order they were displayed. Is this just coincidental? Mike ...

Query LDAP with ASP

A Lake - 22 Mar 2005 12:23 PM - 2 messages

I'm trying to get user details using ASP under IIS (Win2000) with the following code: Set User = GetObject("WinNT://domainname/" & mid(strNTUser,8) & ",user") strNTUserFullName= User.Fullname The website this is running under uses Windows Authentication only (no ...

How to use different sites in IIS on WinXP Pro

Astra - 22 Mar 2005 11:47 AM - 3 messages

Hi All Probably way off the mark here, but I have IIS running on my WinXP machine and I thought I could host multiple domains over the old Win98 method where I could only have the one? All I can see at the moment is that I have a Default Web Site, which is ...

sql problem with sub queries

Jean-Paul - 22 Mar 2005 10:25 AM - 6 messages

Hi, This "query2" is used in an MS Access environment. SELECT T_Perso.*, query1.* FROM T_Perso LEFT JOIN query1 ON T_Perso.IdPerso = query1.IdPerso; In SQL, "query1" is : SELECT T_Items.*, T_Items.IdTypeItem FROM T_Items WHERE (((T_Items.IdTypeItem)="Inscription")); I would like to translate "query2" in full SQL language in order to use it ...

Trapping odbc error when exec'ing INSERT command

Doo-Dah Man - 22 Mar 2005 5:37 AM - 5 messages

I hope this is the right group for this question, if it's not please direct me. I have a data-driven website that allows users to enter records for sales leads. It all works perfectly. The only thing I want to do ...

Image

vichet - 21 Mar 2005 7:50 PM - 2 messages

How to read image from SQL server to asp to show on web? ...

SSL/Response Object/data to client

Stefan Berglund - 21 Mar 2005 7:25 PM - 4 messages

This may not be the right group for this since the ASP part of the equation seems to be working as it should, but at the very least perhaps someone will point me to the correct group or even better, a solution. ...

Checking for duplication in an array or delimited string

CJM - 21 Mar 2005 5:38 PM - 6 messages

In an application I'm working the user has the opportunity to record the despatching of one or more items with serial numbers. For each item they despatch, they have to chose the serial no that they want to despatch from a list of available ones. In many cases, these items will ...

Sending Mail Using ASP/VBScript to Exchange Mail Box

martin smith - 21 Mar 2005 2:33 PM - 4 messages

Here's the scenario. I'm currently using cdosys/asp to send mail to our SMTP server. We use a product called MailFilter to check for SPAM. It doesn't work very well. If MailFilter isn't working cdosys also has ...

Global.ASA Reg.

Harish - 21 Mar 2005 12:34 PM - 2 messages

Hi, I dont have any idea about Global.asa. Is it for global variable declarations? Any body can help me. TIA Harish ...

Can a web user can be logged on as an account other than IUSR_?

steves - 21 Mar 2005 11:14 AM - 6 messages

Hello, We are developing a web application written in classic ASP, which will end up running on Windows 2000 server. The site has a public side (the login page and related images), and a private side (a series of ASP scripts which check session variables to ...

xslisapi download

Stefan Burgold - 21 Mar 2005 7:45 AM - 3 messages

Hi, does anyone have the xslisapi-filter Install-Files. I need version 2.x. Why does microsoft has remove all about these isapi filter, are there bugs ? I've found thousend of articles in the web, e.g. [link] . ...

IIS6 & ASP: accessing network files with FSO fails

Thomas - 21 Mar 2005 3:18 AM - 37 messages

after spending countless hours trying, i give up and hope to get some help in here. on server1 i got the web myweb.com with my test.asp. in the test.asp, i'm trying to read a file from an UNC path with a FSO: ...

Call php/mysql database from ASP

John - 20 Mar 2005 9:25 PM - 14 messages

First I'll answer "why". Because, while SQL Server is available, it is also "expensive". MySQL is CHEAP and a lot more robust than Access. Is there a way to add, update, retrieve, and delete data from a MySQL DB via ...

500 errors!!

John - 20 Mar 2005 9:19 PM - 10 messages

I recently finished a project for someone and they are getting 500 errors. What's driving me nuts is the application works fine from my location. All I can think is it could be a firewall issue but I've messed with my firewall ...

Please help - trying to return XML from a recordset

Alan Silver - 20 Mar 2005 7:55 PM - 7 messages

Hello, I have an ASP that takes a connection string and SQL statement in the querystring and is supposed to return the XML representation of the recordset to the Response stream (don't worry, this is a local page, not ...

ASP / Exchange 2003

John Smith - 20 Mar 2005 7:52 PM - 2 messages

Hi, I am writing a small CRM at the moment and would like one of the features to be that the first page picks up mail from a 'info@' mailbox on a locally hosted exchange 2003 server. I am finding it a nightmare to track-down either how to do this or find the ...

Display Session Variable in textbox?

What-a-Tool - 20 Mar 2005 4:36 PM - 5 messages

I want to display a session variable as a textbox value: I've tried several different variation of this and can't get it to display properly with any. Help please? Sean ...