Home All Groups Group Topic Archive Search About



Active Server Pages (ASP) Programming Discussion

microsoft.public.inetserver.asp.general
Score Retain Whitespaces
rn5a - 6 Jan 2007 4:04 PM - 2 messages
When a Button is clicked in a Form, the JavaScript 'prompt' dialog pops-up for users to enter any text. When the user clicks OK in the prompt dialog, the text is populated in a TextBox & the Form posts. I ...
Score HTML doesn't work for FIREFOX
vietgurlqt - 6 Jan 2007 1:14 PM - 9 messages
I don't what is wrong my site but some of my members cant view it on firefox. I been browsing the net for answer but i havent find the solution. Some said add <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> which ...
Score does anybody knows how should i correct this error?
liav.ezer - 5 Jan 2007 9:53 PM - 2 messages
This is the error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 3.51 Driver][mysqld-4.1.13a-nt]No database selected given after trying to browse to my login.asp. my DB is mysql & i have a ...
Score SQL Select Query help
Simon Gare - 5 Jan 2007 9:30 PM - 16 messages
Hi, trying to retrieve postal codes from the db but only want the query to look at the first 3 digits of the code tried using (LEFT(dbo.booking_form.COLL_POST_CODE),3) but that doesn't work. I don't want the query to count individual post codes but instead look at an area ...
Score Blogging app
John - 5 Jan 2007 7:58 PM - 2 messages
Hi Can anyone recommend a good asp/asp.net blogging app that I can install on my own server? Thanks Regards ...
Score Euro ( ? ) turns up "?"
Kim - 5 Jan 2007 7:22 PM - 5 messages
Inserting a record through sql (asp, msaccess textfield), inserting the euro sign "?" shows up like a questionmark "?" in the output. I have <%@ LANGUAGE="VBSCRIPT" CodePage=28591 LCID=2077 %> at the top of the page where the insert statement is but still the euro sign is inserted like ...
Score Export to Excel query
Simon Gare - 5 Jan 2007 6:54 PM - 3 messages
Hi have succesfully exported data from db to excel and dynamically generated filename, problem is I need a space between the invoice ID and Customer name, at present it generates the data but joined together eg   311Mackenzie Centre should read 311 Mackenzie Centre ...
Score ASP and Oracle
RcTricia - 5 Jan 2007 6:18 PM - 2 messages
When I place a record set on an asp page designed in dreamweaver. I get the following error when i try to run d page. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 127 ...
Score Sessions without cookies question
Griff - 5 Jan 2007 11:35 AM - 4 messages
UserA has a PC running IE 6.  This has the cookies disabled: 1 - Override automatic cookie handling: checked 2 - First party cookies: Block 3 - Third-party cookies: Block 4 - Always allow session cookies: Unchecked The server runs a Classic ASP application running in IIS 5.x that uses the ...
Score File upload problem
PW - 5 Jan 2007 11:01 AM - 5 messages
I'm writing a small system to allow users to upload documents to my server. I'm using Persist AspUpload for this.  I have 2 ASP files. In the first ASP file I prompt the user for a file description and a ...
Score Can't insert records from asp page with request.form
.Net Sports - 5 Jan 2007 12:00 AM - 6 messages
I'm trying to insert records into an sql database coming from a page using the request ..form method. The table "general" has a primary key 'geid .' I get the following error: Cannot insert the value NULL into column 'geid', table 'general'; ...
Score ASP.net page with Crystal Report using Integrated Security
Hellotalktome13 - 4 Jan 2007 9:53 PM - 3 messages
Using a simple ASP.net page with a crystal report on it.  Loading from IIS using Integrated Secruity in the reports connection string it populates the report in the browser. What User ID and password is Crystal Report using to get permission to ...
Score Need help reviewing code please ASAP is possible
MrHelpMe - 4 Jan 2007 8:12 PM - 4 messages
Hello experts and thanks so much for having a look at this.  I have the following peice of code that I am stumped on. [code] <table width="90%" cellpadding=0 align="center"> <tr>      <td align="left"><font face="arial,helvetica" size=4 Color = ...
Score session expires when logged in from two different login from two different pc
simon - 4 Jan 2007 6:18 PM - 6 messages
well i have admin panel and agent panel. when i open admin panel and log in it works fine. but when agent opens agent panel in different pc  and login and acts something like open a page or so, both admin panel and agent panel expires session and asks ...
Score How do I check to see if a submitted value is an INT?
MSUTech - 4 Jan 2007 5:49 PM - 5 messages
Is there an easy way to check to make sure a submitted value is an int or double, as opposed to a varchar ... ? thanks ...
Score Organization Chart Logic/Component
JP SIngh - 4 Jan 2007 4:21 PM - 3 messages
Hi All We urgently needs some help please. We need to create an org chart from our employee data but struglling. We are using ASP with SQL Server 2000. Does anyone know of a commercial component or some sample code to help us ...
Score Restrict Insert if record exsists
Mangler - 4 Jan 2007 1:33 PM - 9 messages
Can someone point me in the right direction on this?  There are 3 fields in the DB: model, rma, bagqty.  If the values on a certain row are I530, 1108, 50 and a user goes to input the same data I dont want ...
Score Error message
amatuer - 4 Jan 2007 12:15 PM - 4 messages
ADODB.Recordset error '800a0cb3' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /devag/newProjSave.asp, line 321 sqlOCF = "SELECT * FROM DA_OtherCFacilities"     set rstOCF = CreateObject("ADODB.Recordset") ...
Score Show dynamic content if greater than 0
Simon Gare - 4 Jan 2007 9:29 AM - 5 messages
Hi all, I have a dynamic value from a recordset that if it is a 0 value I want it to be hidden. something like If  Recordset.Fields.Item("CarPark") = 0 Then value hidden Else Show value Anyone help? ...
Score populate record from db into web form textfield
weiwei - 3 Jan 2007 8:46 PM - 3 messages
Hi I am trying query the data from db and populate in the web form's textbox field. so far I cannot put that record into the text field box. anyone has idea on that, below is my sample code ...
Score requests queued too high?
Michael Shutt - 3 Jan 2007 8:19 PM - 3 messages
We've got a web application running on a 2-server IIS6 web farm.  The application is part asp and part asp.net.  We were analyzing some performance data and found something peculiar.  We are collecting data from these ASP ...
Score cscript results from browser
bfonseca3 - 3 Jan 2007 7:04 PM - 1 message
Hi, i have a query made using wmi and i would like to transform this to be viewed from a website. I have installed a iis and asp.net 2.0. Can anyone help me to re-arrange the code to be able to view the ...
Score Date calculation
Brett_A - 3 Jan 2007 3:03 PM - 8 messages
I have the following code: If ad_expiration_date > (date() + 90) then ad_expiration_date = (date() + 90) else end if What I want to happen is if the ad_expiration_date entered by the user is beyond 90 days from today's date, the Expiration Date should be ...
Score I can't get a Username in classic ASP
Dany - 3 Jan 2007 1:41 PM - 6 messages
Hi, I'm trying to get the username of users in my intranet, using the request.servervariables("LOGON_USER")  command in classic ASP, but I get nothing, not even an error message. the basic script looks something like this: ------------------------------------------------------ dim chUser ...
Score Imagemagick to trim whitespace?
ben.r.casey - 3 Jan 2007 11:43 AM - 1 message
Hi - does anyone know if it's possible to crop whitespace regions from around the edges of an image using Imagemagick? I have a whole bunch of signature images (as in, people's handwritten signatures) and I'd like to crop them so that there's no whitespace margin around them. I can do ...
Score Server.Execute Problem
Eric - 3 Jan 2007 10:25 AM - 13 messages
I am working on a site using classic ASP.  The production server is a Windows 2003 server, and my local machine is running Windows XP Pro. The problem I have is that while all other ASP commands work OK on the local ...
Score Get File from FTP Server - ServerXMLHTTP
SPRFRKR - 3 Jan 2007 12:40 AM - 6 messages
<% Response.Buffer = True Set objHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP") 'objHTTP.open "GET","ftp://xxx.xxx.xx.xxx/xxx.mp3", false, "username", "password" objHTTP.open "GET","ftp://username:passw***@xxx.xxx.xx.xxx/xxx.mp3", false objHTTP.send Response.ContentType = "application/octet-stream" ...
Score HTML Page With ASP Frames
rn5a - 2 Jan 2007 10:18 PM - 9 messages
I have a HTML page named Index.html which is divided into 3 frames. The URL of 2 of the frames are HTML pages but the 3rd frame houses a ASP page. Now when I go to Windows Explorer, navigate to the folder in which the ...
Score Need suggestions on Response.BinaryWrite
mattridings - 2 Jan 2007 7:04 PM - 2 messages
Hi gang, Have a script that works fine.  However, it's really cpu intensive and I'm looking for suggestions on a) whether or not that's normal and if so b)a better way of doing it. Script is very simple, there is a folder of files with numeric names. ...
Score ASP inside a JavaScript Function
Mangler - 2 Jan 2007 6:16 PM - 6 messages
I am having trouble with a JavaScript Function that includes ASP in it. The function almost works, I was wondering if someone can take a look at it to see if the ASP in the function is the cause of the ...
Score UTF-8 and Server.URLEncode
burnsy2000 - 2 Jan 2007 5:44 PM - 2 messages
We are running ASP classic on IIS 5 on W2k SP4. We recently added <% Response.charset="utf-8"%> to the top of all our pages (as suggested by validator.w3.org). A problem arose on a page which applies ...
Score Error in Classic ASP site brings the entire site down
Fregas - 2 Jan 2007 5:33 PM - 5 messages
There is an old site that i'm having to maintain in classic asp.  For some reason, the original developers didn't belive in validation, so there are many places where if the user puts in invalid data, asp/vbscript throws a big sql server error.  In development, on my ...
Score ADO/ASP/Isnull issue.
jimm.sander - 2 Jan 2007 4:52 PM - 5 messages
Hello, Problem: Im using isnull() in vbscript to determine if a field returned from a ado object call is in fact null.  The problem is when I use isnull in anything other than a response.write() I get the following ...
Score cookie codepage problem on iis 5.0
eyal.herlin - 2 Jan 2007 4:29 PM - 11 messages
hi, i set a cookie to hold a utf-8 string. either by the server or by the client. it doesn't matter. when i try to read this cookie using Request.Cookies("my_utf8_cookie") on iis 5.0 i get garbage. ...
Score Distinct and Top in Select
mianiro - 2 Jan 2007 3:08 PM - 2 messages
I want to use a distinct and a top in a select statement, however I want the distinct to only apply to one of the columns. For example SELECT DISTINCT TOP 15 col1,col2,col3,col4 from table1 I only want the distinct to apply to say col2.  Is there a way to do ...
Score How do I figure out why my ASP.NET pages won't come up
David Thielen - 1 Jan 2007 7:42 PM - 5 messages
Here are 2 lines from my log file: 2007-01-01 19:27:08 W3SVC1 127.0.0.1 GET /WindwardPortal/images/button.gif - 80 THIELEN\dave 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 ...
Score error reasing database file
John - 1 Jan 2007 6:23 PM - 3 messages
can somebody tell me what's wrong wth this code ? IF Request.QueryString("YEAR") <> "" THEN SELECT * FROM tblMatches ORDER BY Year DESC, END IF I'm getting an error message: "Server error: Unable to retrieve schema information from the query:" ...
Score BackUp Tables from MySql in ASP
Michael - 1 Jan 2007 4:21 PM - 4 messages
Happy new year. I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files. Thanks ...
Score searching txt file
Jeff - 1 Jan 2007 2:46 PM - 2 messages
Hey everyone, and Happy New Year. Is there a way, using asp sript, or maybe something else... to take a 32 digit number submitted by a form, and search through a txt file that resides on the server. I want to be able to take someone's guid , and run it through a background ...
Score build a website with different language
TW - 1 Jan 2007 12:25 PM - 2 messages
Hi, My scenario: I want to build a website who handle 3 different countries (english, german, french). The changes between the countries is the text on the website. I know that i can put the text in a database to change it dynamic. ...
Next »