Saturday, 13 September 2008
|
| RE: file size limit in Response.binarywrite Old Pedant 23:14:30 |
| | "S N" wrote:
I am using the following code to hide the download url of files on my website. The code uses Response.Binarywrite to send file to the client. Kindly indicate the maximum size of the file that can be downloaded using this method. call Response.AddHeader("Content-Disposition","attachment; filename=""" & strFileSave & """") Response.ContentType = "bad/type" Set Fsys = Server.CreateObject("Scripting.FileSystemObject") Set TS = Fsys.GetFile(strFile).OpenAsTextStream(1, -1) Do While Not (TS.AtEndOfStream) Response.BinaryWrite(TS.Read(1)) Loop
Ummm...that code isn't goint to work, anyway. See the method
OpenAsTEXTstream
???
You really can only use FileSystemObject reliably with text files; it wasn't
designed to work with binary files.
You need to use ADODB.Stream object, instead.
http://msdn.microsoft.com/en-us/library/ms675032(VS.85).aspx
And then you could easily control the amount you write in each chunk by just
limiting the amount you Read each time.
|
| |  16 answers | Add comment |
|
| FileSystemObject: how to get a file's title Fniles 00:12:01 |
| | I am using the FileSystemObject to display the content of a directory/folder
in a browser.
I am wondering if there is a way for me to get/show the file's title (this
is the one in the property of the file, in the "Summary" tab, not the name
of the file).
I do not see the property in the file object to get the file's title.
Thank you.
strPhysicalPath = Server.MapPath(strPath)
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder(strPhysicalPath)
Set objCollection = objFolder.Files
For Each objItem in objCollection
strName = objItem.Name
next
|
| | 2 answer | Add comment |
Friday, 12 September 2008
|
| ASP Page Counter Paul W Smith 19:48:02 |
| | I have written a hit counter, which I believe counts the times my page is
hit by a user for each unique session by the user.
The relevant part of my code is below:
If IsEmpty(Session("TotalCount")) Then
' Increment or reset the count
If Weekday(Date(),vbSunday) = 1 And dtDate <> Date then
iCount = 1
Else
iCount = iCount + 1
End If
dtDate = Date
End If
Session("TotalCount")= iCount
The page is www.middlesexccl.com
My issue is I cannot believe the number of hits I am getting - or more
accurately should I trust the number of hits I am getting.
When I first go to the URL I see the count increased by one, but it does not
incredment if I reload the page.
Is there any techniques that the clubs involved could be using, i.e. some
sort of 'fancy' linking to the page from their web site which might be
causing the count to be incremented unduely? I am sorry if that sounds a
little vague but I cannot udnerstand where the hits are coming from.
If anyone has any other odeas on how to test this please let me have
details.
Many thanks to all those who give this isue their attention.
Paul Smith
|
| | 26 answers | Add comment |
Thursday, 11 September 2008
|
| Button Arrays. Mj 23:20:40 |
| | Hi all, not sure if this is the right forum,but I'd like to create an array
of Radio Buttons for a web page.
I understand how to create an array, but I need one for RB specifically and
know how to access them.
Searching the web is great, but I'm winding up with too many pages that take
me off on a winding road, with no precise solution.
Any help would be appreciated.
Thanks.
|
| | 3 answer | Add comment |
|
| how to set Multiple Simultaneous connection in ORACLE Balakrishnan Dinesh 13:01:00 |
| | hi frndz ,
I have developed the web application with the backend as
ORACLE database , I configured my database in DEDICATED MODE..
Can u tell me how to configure no of simultaneous connection in
ORACLE , where to configure that option ?.
|
| | Add comment |
|
| Better debugging of classic ASP with Visual Studio 2008 SP1 Mike Gale 09:48:22 |
| | VS 2008 initially didn't debug classic ASP.
SP1 fixes this in some ways. You can debug if you select the debug option
to "Start Without Debugging, then either attach the debugger manually or
place a stop directive in the code which ends up doing the same thing.
The problem with this is that you can't debug browser side Javascript in the
same debug run.
You get a "The breakpoint will not currently be hit. The document is not
loaded." if you try to both at the same time.
Does anybody here know how to debug the whole application (Browser
Javascript and server side VBScript) in one run of the debugger?
|
| | 3 answer | Add comment |
Wednesday, 10 September 2008
|
| creating website programmatically using C# Mandar 21:08:19 |
| | Hi,
I have written some code in C# to programmatically create a website
and an application pool. Both seems to be getting created alright with
whatever settings I have applied. However, when I fire a request to
the website, I get a "page can not be displayed" message". I get
nothing in the event viewer logs. I read somewhere that from website
properties > Home Directory > Application Settings, if I remove and
recreate the application pool, website starts serving requests. This
DOES work but I am unable to figure out how to accomplish this from my
code. When I checked Metabase.XML file of IIS before and after doing
this change manually, only change I noticed that following gets added
inside <IIsWebVirtualDir>.
UNCPassword="49634462500000000600000040000000bd77b5e56b3f000048866b15ac840f0bc531565bfc2a1b5c6eb77c9661f527ba8edd7344f93776e7cf6ae118bcdb8db8a6ea143d7ae1d03c8672ac2c84bd677cd3fde3c37cf6e6a0"
However, my app pool is running under "local system" identity. So this
string might correspond to some default encrypted string.
Does anyone know how to get it working from my code?
Thanks,
Mandar
|
| | 6 answers | Add comment |
|
| ASP Web Form Database Pull Help Jason 16:27:42 |
| | So I have an online submission form that submits info to a Access
database. I also have a second page where the user can update their
info on the form (which pulls the data from the database of course).
The text fields pull fine, but I'm having problems pulling data of
Dropdowns, Checkboxes, and Radio Buttons. For instance, if someone had
selected a checkbox from the submission form, when they go to the
"update" form, the checkbox would be checked.
Any help is much appreciated.
|
| | 3 answer | Add comment |
Tuesday, 9 September 2008
|
| Re: Operation not Allowed Ron Hinds 01:55:06 |
| |
"Anthony Jones" <AnthonyWJones@yadayadayada.com> wrote in message
news:uHV3UjGEJHA.1268@TK2MSFTNGP05.phx.gbl...
"Ron Hinds" <billg@microsoft.com> wrote in message news:e0TWFv5DJHA.4600@TK2MSFTNGP04.phx.gbl... "Anthony Jones" <AnthonyWJones@yadayadayada.com> wrote in message news:%23oZRLm5DJHA.1228@TK2MSFTNGP02.phx.gbl... IIS6 limits the AspMaxRequestEntityBody to 200K. (It was something much larger on IIS5). You will need to modify this value to allow the larger Is that a regsitry setting? No its a Metabase setting. In IIS there is Metabase.xml file tuck away with all the settings. Many IIS admins well tinker with this directly but its better to use a tool whose job it is to do that. If you haven't already got the resource kit:- Now you could set this value for your entire site but it would be better to limit it to only the directories (or even files that need it). The purpose of the setting is to limit your site exsposure to inadvertant or malicous attempt to tie up your site by sending ludicrously large amounts of data to it. In IIS Manager find the directory or file you want to apply the setting to. Open its properties and look at the enable content expiration check box on the http headers tab. If its on skip the rest of this paragraph. If its off turn it on, apply, turn it off and OK. This creates a path to the folder or file in the metabase and saves a fair bit of faffing about. Now open the MetaBase explorer from the IIS resources. Navigate down the path LM\W3SVC\xxxx\root\yourpath where xxxx is the site ID (if you have multiple sites click on each and the ServerComment value in the right hand pane will tell which one it is) and yourpath is the path down to the folder or file you want to apply the setting to. Right mouse click the folder or file in the tree and choose New | DWord record. In the Record Name or Identifier drop down choose AspMaxRequestEntityBody (or simply type 7053 in the same box). Click OK. Double click the value that has appeared in the right hand pane and enter the max bytes you want to allow. --
Much Thanks!
|
| | Add comment |
Sunday, 7 September 2008
|
| Date formatting to iCal Standard. Jerry Yang 02:53:00 |
| | Hi
My DB has 2 fields, one which has the date the other has the time.
The date field is called Appt_Date and has values like 12/03/2008 (DD/
MM/YYYY)
The time field is called Appt_Time and has values like 10:30 (am)
I can retrieve both of these fields from the DB and present them on
screen, but I need to do it in iCAL format.
For example, the following represents Janurary 18, 1998, at 11 PM:
19980118T230000
Any idea how I can do this ?
Thanks
|
| | 2 answer | Add comment |
Saturday, 6 September 2008
|
| Forced submit Ellie 10:23:10 |
| | How can I force a submit on a form. I want to load a form but then I want to
close it and have it do something and then redirect it. This is ASP 3.0.
thanks
|
| | 2 answer | Add comment |
Friday, 5 September 2008
|
| Consuming XmlNode type with classic ASP. Guest 22:34:43 |
| | We wrote a .NET class library that contains a class that produces an
XML document. We traverse that document and set a number of
properties. We wrapped the resulting DLL using COM so that we can
consume it using classic ASP. All of that works just fine. We can
access the XML document and all of the properties. We can load the
XML into a classic ASP variant using the DOM, etc.
We don't need 95 percent of the XML so we are attempting to wring out
some overhead by grabbing an XmlNode from the XML document and setting
it to a property. Since the DLL is returning a complex type, how can
we access the XmlNode property using classic ASP?
Kind of a weird one I know. Need some expert assistance here.
|
| | Add comment |
|
| Timeout or "Cannot find server or DNS Error" with Response.Redirec Brent Rogers 21:23:52 |
| | I have a asp page that does a Respnse.Redirect() and sometimes I keep
getting a "Cannot find server or DNS Error" [after about a 90 second timeout].
I have validated that the URL being redirected to is valid.
The URL including the query sttring is about 370 charcters long.
The server is a Virtual Machine running Windows Server 2003.
Anyone know what could cause this problem. ?
|
| | 2 answer | Add comment |
|
| Search for record between two fields (Access) David 17:14:49 |
| | Hi,
I have a table called 'jobserial'
This contains amongst others, 2 fields called 'PSL_F_Serial' &
'PSL_L_Serial'
Both of these are 'Text' fields (VarChar) which at present hold serial
numbers
I have a form on my ASP page which loads the new serials into the
Access database as a range only, i.e. The first serial in the range
(from TEXTBOX1) loads into 'PSL_F_Serial' and the last serial in the
range (from TEXTBOX2) loads into 'PSL_L_Serial'
Only these 2 numbers are stored per record in the table.
I need an SQL statement that will check the 2 serial numbers entered
against matching serials in 'PSL_F_Serial' & 'PSL_L_Serial' and also
BETWEEN 'PSL_F_Serial' & 'PSL_L_Serial'.
i.e. if record 52 exists as :
PSL_F_Serial = 0908216206
and
PSL_L_Serial = 0908216245
so, in theory, there are 40 serial numbers including the first & last
in this range, but only the first & last are stored.
Then when the user enters a number in Textbox 1 and 2 it needs to find
out if
Text box1 = 0908216206 or 0908216245....RECORD FOUND
Text box2 = 0908216206 or 0908216245....RECORD FOUND
and
If user enters any number BETWEEN 0908216206 & 0908216245 in textbox1
or 2 ..... RECORD FOUND
Could you show me how ? thanks .... this one is really important, as
at present, duplicates are getting into the DB if the number entered
is BETWEEN the range, as I have not worked out how to catch them !
Many thanks in advance
David
|
| | Add comment |
|
| Re: Newbie, Wikipedia SharkD 10:10:07 |
| | On Sep 4, 2:26pm, Old Pedant <OldPed...@discussions.microsoft.com>
wrote:
"SharkD" wrote: 1. query Wikipedia for information regarding articles using the 2. process the queries and build and serve HTML tables based on the First of all, is what I am hoping to do accomplishable in regular I don't see how a C# framework is at all applicable to ASP. It is *ONLY* Can it be accomplished in ASP.NET at all? Ummm...I think, *if* you use *that* methodology, then it can *ONLY* be ************** Unless you are a starving student, you might consider getting a paid hosting click on the "compare windows plans" tab for what you get at that price. (Don't let them sell you any of the unnecessary add-ons, though.)
*OK*, *thanks*.
|
| | 3 answer | Add comment |
Thursday, 4 September 2008
|
| If Then Paulmitchell507 11:08:02 |
| | I am designing a small .asp (classic) application, I am connecting to
a Access 2k database via ADO to retrieve data. I have a number
variable's that contain text that is posted from a previous screen
AMPM = Request.Form("AMPM")
AMPMDate = Request.Form("AMPMDate")
halfday = "(" & AMPM & "," & AMPMDate & ")"
I then compose a CDOSYS email and send the value of the variable in
the .HTML body of the email
.HTML = "Number of Days" & halfday
What I would like to do is only display the value of the halfday
variable if it contains a value. I was thinking along the lines of
If halfday = Null Then
halfday = ""
Else
halfday = halfday
End if
I know this does not work, but it gives an idea of what I am trying to
achieve.
Any help would be appreciated.
Regards
|
| | 2 answer | Add comment |
|
| IIS and SQL Server 2000 Windows Authentication John Barr 11:02:55 |
| | We have asp.net application setup using Windows Authentication. For the
website, under directory security the only thing checked is "Windows
Authentication". We have the users specified in SQL who have rights to
connect...etc. In the Web.Config, it is specified as Integrated
Security=true. However, when the user goes to the site, an error message is
displayed saying Login attempt failed for (Our Domain Name)\(Our Web
Application Server Name)$ . I have a couple of issues here...
1. Why is it attempting to logon with this account?
2. The domain Machine name doesnt have a $ on it, so why is it showing that
way?
3. Is this some internal naming for a windows account?
|
| | 2 answer | Add comment |
Wednesday, 3 September 2008
|
| Flash dimension Paulo 06:10:09 |
| | Hi, the users can upload flashs, but how do I retrieve its dimension?
tried below, but it returns me a wrong width/heigth number
http://www.4guysfromrolla.com/webtech/tips/t102001-1.shtml
Thanks!
|
| | Add comment |
Tuesday, 2 September 2008
|
| ASP access to Data on Remote devices P Byers 09:53:24 |
| | Good Morning Folks
I have a LAN
Among the several connections to it are the following four devices:
A MAXSTOR network Storage Device
A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4)
A PC running Microsoft Windows XP Professional 5.1.2600 (SP2)
A PC running Microsoft Windows XP Professional 5.1.2600 (SP2)
All of the PCs are running IIS
The 'Public Internet' is connected via a Broadband connection from the
LAN
On the MAXSTOR is a folder called 'CENTRALDATA'
In that folder are a number of Access dotMDB files.
The Access files can be opened on all of the PCs by double clicking on
them in Windows Explorer.
================================================================
QUESTION ONE
Can the access files on the MAXTOR be accessed from dotASP pages on the
three PCs ??
If so, how ??
If so, are there any simple tutorial pages that explain in simple
language how to do it ??
================================================================
I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that
I own
QUESTION TWO
Can the access files on the "Public Internet Server" be accessed from
dotASP pages on the three PCs ??
If so, how ??
If so, are there any simple tutorial pages that explain in simple
language how to do it ??
================================================================
I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that
I own
QUESTION THREE
Can the access files on the "Public Internet Server" be accessed from
dotASP pages on other "Public Internet Server" servers ??
If so, how ??
If so, are there any simple tutorial pages that explain in simple
language how to do it ??
================================================================
By the way, I tried to create Virtual Folders using IIS Admin on the
three PCs on the LAN, but it will not allow it for 'Remote' folders.
I await your replies with interest
Thank You in Advance
Pete (Northolt UK)
|
| | 24 answer | Add comment |
Sunday, 31 August 2008
|
| ASP to Word send by ObjSendMail ?? Jerry Yang 17:25:30 |
| | Hi
I can get the data I need from my DB and show it on screen fine.
One user has asked if I can have an option when the submits his new
data to the DB, instead of it emailing him a plain text or html email,
(as it does now) could it send a copy of the data as a word doc.
Can any one help ??
Server is windows 2003
Thanks
|
| | 5 answers | Add comment |
|
| Re: Please Help Advanse Search, two parts are working, the 3rd to Old Pedant 07:11:50 |
| | "Bob Barrows [MVP]" wrote:
If you had added " ... immediately after opening the recordset." I would have had no comment.
Yah, I know. But in 8 years of writing ASP code (which I no longer do
except for a couple of pro bono non-profit org sites) I never once had a
reason to use or need a BOF test. I think the exceptions are so rare that
saying "never" is better than bothering to describe the exceptions that will
(in practice) not be encountered.
Oh...and in over 86,000 posts I made on the ASPMessageBoard site, answering
all sorts of questions, never once did anybody have any code that needed the
BOF test, either. ( http://www.aspmessageboard.com/scripts/topPosters.asp )
Sometimes, even for an old pedant, it's not worth expounding the theory when
the practice is so overwhelmingly one-sided.
It's nice to meet somebody even more pedantic than I am. <grin/>
p.s.: Actually, I gave myself that name because of my penchant for
correcting English syntax, not code syntax. <grin style="monstrous" />
|
| | 12 answers | Add comment |
|
| "Script timed out" error Justin Doh 04:00:43 |
| | I am trying to retrieve a data over web using SQL2005 and ASP page.
I am still not able to fix my issue.
"Script timed out"
I think if I query data at SQL2005 directly, it takes about 2 min 38 sec.
and I am able to get data.
So, I am trying to fix at ASP coding.
First, I set up
<% server.ScriptTimeout = 10000 %>, but still getting error.
Second,
I have this set up this during the retrieval of recordset using a stored
procedure.
.ConnectionTimeout = 4800
.CommandTimeout = 4800
Thirdly,I had placed "Response.Flush" at the end of looping of data.
But I am still getting error.
If it runs fine at the SQL server directly, what can I do at ASP page?
I would appreciate for any help.
Thanks.
|
| | 2 answer | Add comment |
Saturday, 30 August 2008
|
| Gradient fill? Bob Altman 01:42:02 |
| | Hi all,
Here's another rank beginner question. What is the standard way to fill a
client-side table cell with a horizontal gradient background?
TIA - Bob
|
| | 4 answer | Add comment |
|
| SQL Injection and DB user permissions Randy 01:11:25 |
| | I have a .asp web application (using MSSLQ SRV).
I have actually taken it down after reading articles posted here and
elsewhere, since it contains quite a bit of 'dynamic sql' and I KNOW that
it' FULL of vulnerabilities to SQL Injection attach. I decided not to wait
around for this to happen and I'm working to 'harden' it.
So this is probably a stupid question and, no doubt, there is a concept that
I am not grasping.
But, since my site is purely informational, and, (by intention at least)
only allows the user to search and display the data, I would THINK, that
employing a database user in the connection string with read-only
permissions, would at least make it LESS susceptible to this kind of
attach.
Am I missing something here?
|
| | 2 answer | Add comment |
|
