Home All Groups Group Topic Archive Search About



Active Server Pages (ASP) Programming Discussion

microsoft.public.inetserver.asp.general
Score IF EXISTS error! (0x80040E14)
Robin Lawrie - 26 Feb 2005 7:25 PM - 5 messages
I've written an asp form that successfully takes a users firstname, surname, email address, username and password and then add's those details to an Access database. I've been trying to modify the code so that the script checks that the ...
Score Session_OnEnd does not DeleteFile()
andrea azzini - 26 Feb 2005 5:38 PM - 12 messages
I've got an ASP3 (IIS6) site, in which some scripts need to generate temporary files in order to work. Now, the fact is: I would like those temporary files to be deleted when a user's session ends (even though i've ...
Score Client side detection of JScript?
What-a-Tool - 26 Feb 2005 12:39 PM - 2 messages
I'm playing around in my personal site trying to figure out a way to detect if JavaScript is enabled client side, and get that info back to the server without any manual intervention, or visibility on the clients end. ...
Score group total in a report
Rajani - 26 Feb 2005 4:19 AM - 2 messages
Hello,   I have a table(msaccess) with the structure... job_code        text   6 style           text   10 qty             number ...
Score aspfunction does not work?
Jim - 26 Feb 2005 3:41 AM - 22 messages
Hi I am a newbie to asp and i built this test program: <HTML> <HEAD><TITLE>Test</TITLE></HEAD> <BODY>    the time is <% = Time %> ...
Score Is the following script possible in asp technology
Jack - 25 Feb 2005 10:23 PM - 3 messages
Hi, I have the following javascript that is written in html. It works great. However, I need to transfer the concept to an asp application where the form itself is an asp page. I was wondering if that is possible to do? Thanks in ...
Score Global.asa problems with IIS 6
Dave Anderson - 25 Feb 2005 7:42 PM - 6 messages
I have one IIS 6 machine that seems to ignore global.asa completely. I can't get *anything* to fire -- not Session_OnStart(), not typelib declarations. This is true in the web root as well as in any application folder. In particular, this is preventing me from loading the ADO 2.8 type library, ...
Score Do Until Loop problem
.Net Sports - 25 Feb 2005 7:28 PM - 1 message
I am trying to display records from a recordset after sql statement: <% sqlstr ="SELECT  horsename FROM tblhorseentry WHERE trackname = '" & request.querystring("trackname") & "' and racedate = '" & request.querystring("racedate");" Set rs1 = Server.CreateObject("ADODB.Recordset") rs1.Open sqlstr,pConn,3 ...
Score Do Until Loop problem
.Net Sports - 25 Feb 2005 7:25 PM - 5 messages
I am trying to display records from a recordset after sql statement: <% sqlstr ="SELECT  horsename FROM tblhorseentry WHERE trackname = '" & request.querystring("trackname") & "' and racedate = '" & request.querystring("racedate");" Set rs1 = Server.CreateObject("ADODB.Recordset") rs1.Open sqlstr,pConn,3 ...
Score Log on a user via ASP script?
Brian Madden - 25 Feb 2005 7:02 PM - 3 messages
Hello Everyone, This is sort of a followup to the protecting files question I asked earlier today. I would like to protect a file so that only certain users could download it from my website. It would be very easy for me to simply use IIS Admin to ...
Score Another checkbox manipulation question
Jack - 25 Feb 2005 6:49 PM - 4 messages
<i><input type="checkbox" name="chk_Complete" value="TRUE" <%Response.Write l_IsChecked%>"<%if cbool(l_IsChecked) then Response.Write " checked" Else Response.Write " unchecked"%>> The above code shows a checkbox on a asp form where the checkbox value is ...
Score Accessing Stored Procedure from IIS
stjulian - 25 Feb 2005 6:14 PM - 5 messages
I have a stored procedure that is supposed to     1. Increment a counter in Table A via a transaction     2. Use this value as the primary key to add in an address to customers ...
Score Access Stored Procedure Problem
Savas Ates - 25 Feb 2005 5:04 PM - 2 messages
my stored procedure in access XP (I create it Succesfully) It returns me all records.. For example in my db there are records with catid=1 but no record with id=2 I try my code both catid=1 and catid=2 it returns same records.. What is my ...
Score Re: SSL Capable browser?
Richard P - 25 Feb 2005 3:59 PM - 1 message
Thanks for the reply. Can you see anything wrong with the code? It couldn't be much simplier, just two lines, the problem is that in IE it comes back with data in Firefox it does not. '*********************************************************** certUserName = Request.ClientCertificate("SUBJECTEMAIL") ...
Score private key crypto on form post data
ESPN Lover - 25 Feb 2005 3:08 PM - 1 message
Hello, I need to find a way to encode a form post element with a private key, which then can be decoded using that same private key using ASP.  Yeah, Yeah, I know strange request.  Is there some object on my IIS 6 server or some ...
Score Updating dates
Dthmtlgod - 25 Feb 2005 2:51 PM - 2 messages
I am using a short date format (mm/dd/yy).  When I enter in a date and run my update query, it is not accepting the data it puts in 12/30/1899 Here is the response.write of my SQL statement. ...
Score Getting report problems
Utada P.W. SIU - 25 Feb 2005 10:43 AM - 2 messages
Deall All Experts, I am not sure I posted in right group or wrong group, but please help me I have wrote a ASP application, which retrieve data from sql server, and do some calculation, then generate report to user. ...
Score Zip files
Vinod - 25 Feb 2005 6:20 AM - 5 messages
Hi, I wanted to know whether we can zip files on the fly without using any components. Regards Vinod ...
Score Protect PDF files via ASP?
Brian Madden - 25 Feb 2005 3:37 AM - 6 messages
Hello All, I have what I thought would be a simple problem although I've been searching for a few hours with no luck. I have several PDF and MPG files I would like to provide to users to download via HTTP. I also have a database of user accounts. I would like to ...
Score Help with IIS server Error (Provider error '80040154' Class not registered)
Martin Franklin - 25 Feb 2005 12:35 AM - 5 messages
I am trying to get a total record count on a Acess 97 mdb database. However I get the following error when I try to load the page: Provider error '80040154'  Class not registered [link] ...
Score Problems with checkbox value stored in database
Jack - 24 Feb 2005 11:43 PM - 5 messages
Hi, I have a checkbox the value which goes to a database via a asp page that builds the sql string. In the front end asp page, the checkbox code is written as follows: <i><input type="checkbox" name="chk_Complete" value="<%Response.Write ...
Score newbie question
Auddog - 24 Feb 2005 10:24 PM - 2 messages
I have a small problem, that I just can't solve.  I'm passing information from a form, defining my variables which are then emailed to me.  I'm not having problems send the email or anything like that.  My problem is ...
Score Trusted Connection via ASP page.
CD - 24 Feb 2005 10:14 PM - 5 messages
Win03 and Win03SQLsp3a servers in the same domain.  We are in hybrid mode with W03 DC's Back on NT 4, one could not do a trusted connection via web page when IIS and SQL were on different servers. ...
Score Procedure/Query Confusion
Morris - 24 Feb 2005 9:18 PM - 8 messages
I've created a procedure/query in an Access 2000 database using the following code: <% strAppend = "ProcName" strSQL = "Create Procedure [qry" & strAppend & "] AS Select * From Stories ORDER BY StoryID DESC;" cn.execute(strSQL) %> I know I have successfully created the procedure/query, because when I run ...
Score Passing Value Problem
Doug - 24 Feb 2005 7:56 PM - 3 messages
This should work, but I can't see the value when it hits the ASP code.  I am trying to get the hang of this before moving forward with my project HTML code <form action="updTicket.asp" method="post"> ...
Score About Response.Redirect
qq - 24 Feb 2005 5:35 PM - 8 messages
Hi, Does anyone know about Response.Redirect? I want user to login to our FTP server via an asp page on my website with their username and password. I have created a form with username and password in a .html. User input their ...
Score INSERT INTO error
Gtbntgar - 24 Feb 2005 4:30 PM - 4 messages
Please can someone look at my SQL command it is not working.  It is giving me a syntax error Act = request.form("Act") NT = request.form("NT") Set Conn = Server.CreateObject("ADODB.Connection") DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; " ...
Score Collection in ASP
Logico - 24 Feb 2005 4:28 PM - 3 messages
Hi everybody, does anyone know how to define own Collection objets in ASP (not ASP.NET!) and VBScript? Is it better to use the Collections or the "Scripting.Dictionary" object? Thanks, bye AM ...
Score Collection in ASP
Logico - 24 Feb 2005 4:25 PM - 1 message
Ciao a tutti, sto lavorando con ASP (non ASP.NET) e VBScript e avrei bisogno di definirmi delle mie Collection personalizzate, ma non riesco a trovare da nessuna parte la sintassi per crearle... qualcuno sa darmi una mano? Si può fare? ...
Score Paging with selection and sumarization
TomazL - 24 Feb 2005 2:29 PM - 1 message
Hi! I have searched through a lot of paging articles. But I have not found any specific recommendations for my issue. I have a large record set that I need to page through (1000 records). But on each page (100 records) I must be able to select some rows, add ...
Score Easy date handling?
Sune - 24 Feb 2005 2:07 PM - 4 messages
I'm working on a system that requires alot of date handling, and i'm getting pretty tired of doing custom calculating when modifying dates, so i hope someone would be able to help me. Is there any easy way to do re-calculating of dates? such as adding 2,11 ...
Score Picture/Image Gallery....recommendations
CD - 24 Feb 2005 1:20 PM - 2 messages
The platform is Win03, Access and SQL is available, along with all the normal image components (aspjeg, etc..). I have searched and I could spend several days looking for something.  I was hoping to get some recommendations based on experience.  I would like to ...
Score incomplete data in muliple dimension array
Michael Kirchner - 24 Feb 2005 9:26 AM - 5 messages
Hi everybody The output of my multiple dimension array is quite confusing. Im declaring an array, store some values in it and then I save the array   in a session variable. On an other page I store the data of the ...
Score HTTP Redirect with POST
Victor - 24 Feb 2005 4:52 AM - 9 messages
I need to redirect to another web page, but that redirect will include the submission of form data. So, unlike ServerXMLHTTP which stays on the originating web page, I need the script to redirect to the page that I'm ...
Score Corrupted Double-byte characters in Windows 2003 / IIS 6.0
Vincent Zhu - 24 Feb 2005 12:39 AM - 1 message
I moved ASP WebPages from Windows 2000 server to Windows 2003 server platform. Those double-byte characters (Japanese) retrieved from SQL server 2000 are corrupted. I am using Macromedia Dreamweaver MX as the development tool, by encoding webpage as "UTF-8" as the following, ...
Score time management apps
shank - 23 Feb 2005 9:15 PM - 3 messages
Can anyone recommend project management, timeline and calendar apps I could install on my own site? Hopefully ASP and SQL based. Most of my searches are ending with expensive or limited options. Free is great of course! I need something reasonably priced. ...
Score Item cannot be found in the collection corresponding to the requested name or ordinal.
Dthmtl - 23 Feb 2005 8:20 PM - 5 messages
I know what this error is, all fieldnames have been verified and reverified. Not sure why it is happening. Here is the SQL statement strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems LEFT JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE ...
Score Why IIS could not release DLL which have been used in ASP page.
Bo - 23 Feb 2005 7:29 PM - 4 messages
HI guys:   I use vb create a DLL compoment(SessionManger.dll) which is used in ASP page.   in ASP page(test.asp) code:   <%@ Language=VBScript %>   <%response.buffer = true%> <%   dim Session ...
Score Are there "IIS" freeware (read ASP scripts in Localhost only)?
clemilsoncorreia - 23 Feb 2005 6:53 PM - 6 messages
Hi for all I need one freeware that read ASP script alocated in my locahost. Beacause i have other OS, without IIS, and i need run off-line, only local. Thanks ...
Score Can't get Global.asax to execute Sub
tshad - 23 Feb 2005 6:08 PM - 3 messages
I have an example I copied from "programming asp.net" (o'reilly) and can't seem to get the Sub (writefile) to execute.  It displays all the response.write lines that are called directly, but not any of the ...
Score Populate a popup window with clickable records from an Access DB and upon clicking, populate a selec
Enjoy Life - 23 Feb 2005 3:29 PM - 3 messages
We have an ASP site that hits up an Access database of categories of products and products.  (e.g. Categories = Napkins, Tablecloths; Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60 Tablecloths) We currently have select boxes that when you select a category, it ...
Score Checkbox Question
HartNA - 23 Feb 2005 2:56 PM - 3 messages
I have a script that will work on it is own, but the problem is the site I am trying to implement the checkbox on a site with attachments on the same form.  In my testing I check LOW.  The result I am looking for is YES, but ...
Score HTTP Auth problem
Neil Hitchmough - 23 Feb 2005 1:02 PM - 2 messages
I want to access a page on a remote webserver that is protected by HTTP authenticate (username and password box) that appears when you go to the page. I know that you can do this (using PHP or CGI) but I'm not sure how to ...
Score CDO.Message and emails bouncing back
Paul - 23 Feb 2005 12:20 PM - 2 messages
Hi all, I'm using the CDO.Message object to send out a large number of subscription emails daily from a website. We always get a large number of delay and failure notification emails coming back. Does anyone know of a way to specify in the CDO.Message object that you ...
Score "CDO for Windows 2000 Library" on an XP server
Luis - 23 Feb 2005 12:15 PM - 2 messages
I use CDO to send an email to users as part of a 'Reset Password' functionality I have on a intranet site. I use: METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB- 00C04FB1625D" NAME="CDO for Windows 2000 Library" in my asp page to send the e-mail (via Exchange 2003). It ...
Score Free Tree view
Vinod - 23 Feb 2005 10:19 AM - 4 messages
Hi, I wanted to know whether any free TreeView components are available in Asp. I  should be able to drag drop, copy,paste and there should be checkbox facility in the nodes. Any help will be appreciated. Regards Vinod ...
Score Retrieve email address from NT login with ASP
GoCMS - 22 Feb 2005 10:19 PM - 1 message
Sorry for the duplicate posting, but I tried to cross_post from adsi.general board, and it didn't work. :( Here's my question:   I'm using windows 2000, and integrated windows authentication for company intranet.   I'm constructing a web page with ASP. I got user's login by ...
Score check image size (width)
Øyvind Isaksen - 22 Feb 2005 9:43 PM - 2 messages
Hello! How can I use ASP to check the size of the images used in my solution? This is what I need to do: If the width of an image is more than 256px, I want to set the image width ...
Score an important thing I forgot to tell about this problem
Gabriel Mejía - 22 Feb 2005 7:28 PM - 1 message
I can replicate the crashes of my web site, and that is  when I run a desktop visual basic application. this apllication works fine but has a long transaction that blocks the sql database. After that aplication runs,  the ...
Score NEWBIE NEEDS DIRECTION
John - 22 Feb 2005 4:17 PM - 8 messages
I have found almost all the answers I needed on this newgroup and am grateful for all of the help.  I'm hoping this time I will still find answers I need although they are not as cut and dry as the previous. ...
Score server-side validation
middletree - 22 Feb 2005 1:50 PM - 4 messages
I posted this yesterday afternoon, but for some reason, I don't see it in my newsreader, on either of my 2 computers. So I am re-posting. I'd like to see if there is any guidance in the form of sample code or a ...
Score Calling Exe in Asp
Vinod - 22 Feb 2005 8:38 AM - 9 messages
Hi, I have a problem, i am calling an exe from asp program. Its not working fine. When i execute the exe through the dos program directly i get the desired result. My exe will convert files in the folder to encrypted files. ...
Score I am having a problem in my asp in the recorsets running at iis 6.0 and sql 2000. Sometimes it retu
Gabriel Mejía - 21 Feb 2005 3:21 PM - 13 messages
Services or applications using ActiveX Data Objects (ADO) 2.0 or greater may intermittently return empty recordsets on queries that should be returning valid results. At the time the problem occurs, the same queries successfully return the expected data when run from non-ADO sources, such as from ISQL in ...
Score CDONTS
Mac Davis - 21 Feb 2005 2:43 PM - 2 messages
Ive just learned that CDONTS is not available of Server 2003. So, I've been trying to make sense out of what I can read. I have succeeded in completely confusing myself. In one place Microsoft suggests that I can install CDONTS from Server 2000 ...
Next »