IT Newsgroups: Active Server Pages (ASP) Programming Discussion

database connection

SOC - 17 Feb 2007 8:01 PM - 5 messages

I am familiar with connecting asp pages to sql server when both servers are on a LAN. Can anyone advise on how to connect when the servers are remote from each other? Thanks Soc. ...

FTP Question

SteveT - 17 Feb 2007 5:46 PM - 4 messages

OK I know this question doesn't belong here but there are a lot more knowledgeable people on this forum and since most of us use FTP to transfer our ASP files and we are concerned about security I am hoping someone has ...

Syntax Error in IF statement

Nate - 17 Feb 2007 2:20 PM - 3 messages

I am trying to use the following IF statement, and whenever I use a single or double quote, I receive a syntax error. When using no quotes, the syntax is accepted, but the statement does not perform properly. ***The problem line*** ...

HELP: IIS6 pernamently caches XSL uri and won't change!! woes ...

Andrew Wan - 16 Feb 2007 8:23 PM - 3 messages

Okay, this is really weird. We have two Windows 2003 Server SP1 PCs. One hosts IIS6 website, and the other hosts our DCOM service program. Our website is ASP/XSL. An ASP page uses Msxml2.DOMDocument.4.0 to transform a ...

CDONTS

SimonW - 16 Feb 2007 5:08 PM - 5 messages

Platform WinSVR 2003 IIS 6 Having installed and registered CDONTS.dll in \system32, I am still experiencing the following error message when runnng the intranet web site. (And my boss is getting edgy with me) ============================ Processing.......... Microsoft VBScript runtime error '800a004c' ...

Response.AddHeader problem when using Javascript as the server-side scripting language

Andyza - 16 Feb 2007 12:43 PM - 2 messages

With reference to the ASPFAQ 2161 article - [link] Does the 'Content-Disposition' code work if the user is using JAVASCRIPT as the SERVER SIDE scripting language, i.e.: ...

MSXML2.ServerXMLHTTP works only with text files?

lopi - 16 Feb 2007 10:42 AM - 9 messages

Hello. I'm trying to remotely get a pdf file - http://remoteServer/file.pdf - in order to store it into another server, maybe with Scripting.FileSystemObject However the following code doesn't work properly: ------------ url = "http://remoteServer/file.pdf" ...

how to extract email ids from a text paragraph

visu - 16 Feb 2007 4:58 AM - 1 message

I ve a text paragraph something like sample sample sample sample r*@yahoo.com <e*@ss.com> sample sample sample sample sample sample sample sample sample sample d*@example.com sample sample sample <w*@example.com> sample sample ...

how to real XML Values

G - 16 Feb 2007 4:21 AM - 1 message

Hello Sir, I am new to ASP. I am retriving one table values from mysql database. displying the values on the browser in XML Format. now my problem is I want to read this XML Values but i Don't want to save ...

include file outside web site

SteveT - 16 Feb 2007 3:00 AM - 20 messages

Is it possible to have an include file that resides outside of the web site parent folder? For instance, lets say you have several websites under Inetpub/global/websites/ but the include file is in Inetpub/inc/ I get a file not found error trying file/virtual starting with the root and ...

Problem creating a web app in ASP

BigAl - 15 Feb 2007 6:55 PM - 2 messages

Can anyone help me? Here's the error: Unable to create WebApplication1. The file path: 'C\inetpub\wwwroot\webapplication1' does not correspond to Http://localhost/webapplication1.....access denied It seems like the inetpub\wwwroot path is not mapping to the localhost ...

ServerVariable Caching

rclowser - 15 Feb 2007 4:37 PM - 2 messages

Everyone, I don't know if I'm putting this in the right group or not (sorry). I'm developing a website, using ASP VBScript, and I'm using Response.ServerVariable("cert_subject") to get information about the client's certificate (smart card). But this variable is cached, the user can take the ...

Store Dictionary Object in Session not working

J055 - 15 Feb 2007 4:18 PM - 3 messages

HI Can someone tell me what is wrong with this? The first 'if' condition works but the 'else' condition seems to get the right Count but the contents of the key and items are lost. Set dic_qs = CreateObject("Scripting.Dictionary") ...

nightmare with ASP, IIS6 & VC6 PSDK

Andrew Wan - 15 Feb 2007 3:10 PM - 11 messages

I have been having a nightmare with ASP/ASP.NET & IIS6. We use Msxml2.DOMDocument.4.0 object to create a XML object in ASP. The Msxml2.DOMDocument.4.0 is from the Windows Platform SDK Feb 2003 (the last ...

Debugger getting confused - any suggestions?

Griff - 15 Feb 2007 11:20 AM - 7 messages

Hi - I have completely rebuilt my PC from scratch and it's running XPsp2 and VS2003 sp1. Sometimes when I run my ASP code (this is CLASSIC asp by the way) through the VS2003 debugger, I get the following error message (the following is an ...

Login to database + getting table's data

Eitan M - 15 Feb 2007 7:33 AM - 4 messages

Hello, I am looking for a simple code of login to db of asp dotnet (vb dotnet code). with user name + password & simple database. When login to database - I want to see a table data with all it's columns. ...

Problem with an .asp page displaying data based on a form field value.

Brave - 14 Feb 2007 7:18 PM - 3 messages

I'm hoping someone can help me with a small issue. I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria. ...

Not sure which object to use to load xml into xsl

Chuck - 14 Feb 2007 6:07 PM - 2 messages

Hello, I am having trouble loading the returned XML from a Webservice into my XSL. Any suggestions would be appreciated. ' Build custom HTTP header xmlServerHttp.open "POST", "https://.../Site.asmx", False ' False = Do not respond immediately xmlServerHttp.setRequestHeader "Content-Type", "text/xml; charset=utf-8" ...

Secure Download Online

Claire - 14 Feb 2007 12:35 PM - 1 message

Digital Download Protection - protect your digital products from theft and link sharing. Products Feature Overview: ° Secure single product sales ° Built-in shopping cart ° Create Membership sites ° Expiring dowload links ° Limit download attempts ° offer promotional coupons ...

Calculate Friday dates only

David - 14 Feb 2007 11:04 AM - 3 messages

Hi, I need to display 3 fields with future dates (Fridays only) as table column headers. i.e. 16th Feb | 23rd Feb | 2nd March. As each week passes, i.e. from the Saturday, the dates should move accross 1, i.e. column 1 will update to 23rd Feb, Column 2 to 2nd ...

Plz do help me im in difficult situation

brainy brainy - 14 Feb 2007 11:03 AM - 2 messages

i have to read an excel file and on that excel file i must calculate the sum of the 2nd column and that sum should be stored on the access database which contains tablename "ben" and the fileds will be ...

MCSE books and exam info

jeff - 14 Feb 2007 7:36 AM - 1 message

Get free exam information, books, for MCSE, CCNA, MCSD, MCSA, CCAP. ...

Anonymous Access to ASP Pages not working

Daniel Frey - 14 Feb 2007 12:43 AM - 1 message

Hi A freshly installed IIS on my Windows XP SP2 does not allow anonymous acces to the default ASP file (localstart.asp). I just used default configuration for installation, which enables anonymous access. But when I load http://localhost I just get a login box. A simple ...

Session vars in ASP app under IIS6 not sticking

Jack Black - 13 Feb 2007 11:44 PM - 5 messages

Hi, all! Developed a basic ASP web site with MS Access 2k3 as a database back end. I've developed it on two different Win2k3 servers, and app works flawlessly on both. However, we just moved it to a client's Win2k3 Server, ...

chopping file while sending it via asp response.binary write

.nLL - 13 Feb 2007 10:03 PM - 2 messages

hi everyone. i use asp to send files to users to prevent hotlinking and i always used following code Response.ContentType="video/3gpp" response.addheader "Content-Disposition", "attachment;filename="& file ...

Redirect After update help

Mangler - 13 Feb 2007 6:37 PM - 1 message

I have a form that does multiple updates on the page. For some reason that I cant figure out it is redirecting before the update is done. It doesnt do this on another page that I have. <% If Request("Submit") <> "" Then ...

Alternative querystring - using / instead of ? and &

royend - 13 Feb 2007 6:19 PM - 5 messages

Hi. Is is possible to pass parameters with this URL: [link] instead of the usual method: [link] And, if I need to add more parameters at a later time, may I then use ...

Assistance with changing column header Dates .................

David - 13 Feb 2007 5:40 PM - 2 messages

Hi, I need to set up an HTML table or the like, with 4 columns. Each column needs to have a header with a FRIDAY (dd/mm/yy) date. i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb ...

Session() variables question

Griff - 13 Feb 2007 5:04 PM - 2 messages

I have an ASP [Classic] application running under IIS 5 & 6 [on different servers (obviously)] I need to implement Session() variables to cache some frequently looked up data. Because of the nature of the data, it is best held in the Session() ...

REMOTE_ADDR Gives my External IP Instead of LAN Address

danknauf - 13 Feb 2007 4:14 PM - 2 messages

I have a webserver which is behaving strangely. The server is a fresh copy of Windows 2003 running IIS with default options + Active Server Pages installed. The server is connected to a Linksys router, and has a static IP address of 192.168.1.10. ...

Go back w/o loading the form?

Rolf Rosenquist - 13 Feb 2007 12:42 PM - 5 messages

From a page with a form I collect the fields in the next page. The fields are compared with a database and if a certain condition does not fit, I want to go back to the first page with the form, and still keep all the other ...

The correct way to close a database connection?

Andyza - 13 Feb 2007 12:31 PM - 16 messages

I'm looking at another developers code and I'm now confused about the correct way to close a database connection and destroy the object. I would normally do it this way: Set conn = Server.CreateObject("adodb.connection") conn.Execute(UPDATE TABLE Blah Set Something = 'Somevalue' WHERE ...

Efficient download script?

robert - 13 Feb 2007 11:40 AM - 3 messages

Hi, I'm new to ASP but do know my way around VB and a bit of VB script. MY ISP have ASP enabled for my website. So I'm pondering on how to write an efficient script for users to download a few files from my website. ...

javascript and asp email

rvj - 13 Feb 2007 10:22 AM - 9 messages

Im attempting to convert a simple CDO VB script to Javascript but keep getting Internal Error 500. The VB version works fine. As far as I can tell all I need to do change the object definition and add the language declaration. ...

[URGENT] Error incorrect syntax near

Dax - 13 Feb 2007 8:32 AM - 2 messages

When i insert some values float in a form made with ASP appear an error message like this: Microsoft OLE DB Provider for SQL Server (0x80040E14) Line 1: Incorrect syntax near ','. sql="select id from tbl_monete where id_taglio="&idtaglio ...

Prompt to Print Page

Trevor Tucker - 13 Feb 2007 1:45 AM - 1 message

Is it possible to prompt the user to print an asp page? For example, in this instance, I have created a job logging and monitoring system. At the completion of the job, I would like the user to be prompted if they want to ...

Send data to microsoft access

trig - 12 Feb 2007 11:19 PM - 6 messages

Please help! I am an ICT teacher at a secondary school and my year 12 (AS Level) group need to create a website where data can be sent from a form to a Microsoft Access database. I am trying to do this in my own time and then hopefully teach them ...

motorola ringtones

motorola ringtones - 12 Feb 2007 12:55 PM - 1 message

...

how to read xml node value

.nLL - 11 Feb 2007 5:26 PM - 2 messages

hi everyone i am trying to read a nodes ( i dont know if i am right by calling it node. see sample) value with asp. xml page is very simple : <?xml version="1.0" ?> <response success="true" > </response> ...

ASP: Truncated URL

Leo595 - 11 Feb 2007 5:15 PM - 4 messages

I have a page that creates dynamic hyperlinks for each recorded displayed. Many of the constructed URLs exceed 128 characters. Those that with greater than 128 are truncated for some reason unknown to me. I know that IE supports URLs up to 2048 characters. Is there a way ...