Saturday, 15 November 2008
|
| Heads up, Update 955069 breaks transformNodeToObject in ASP Anthony Jones 23:23:01 |
| | This info is for those of you who are using the transformNodeToObject method
in an ASP page to send the results of the transform directly to the ASP
Response object.
The security update 955069 includes a change in behaviour where the IStream
passed in the output parameter has its Commit method called where in older
version this never called. The IStream implemention in on ASP Response
object will through an error if its Commit method is called.
Workarounds:
1. Don't install 955069 (not recommend its a security update).
2. Create an IStream wrapper object that delegates to an inner IStream
except the Commit method.
3. Don't use transfomNodeToObject just transformNode and Response.Write
4. Send XML and get your client to do the transform
Option 2 only really an option if you the tools and the control over the
server to implement it.
Option 3 if you were generating large content with buffering turned off
transformNodeToObject is pretty effecient, with transformNode and
Response.Write you are going to use more memory and will need a buffer size
big enough to handle the result (or slice up the result). You will also
need to consider encoding, where ToObject would have encoded to CharSet
transformNode always returns unicode. Hence the best approach would be to
set Response.CharSet = "UTF-8" (you were doing that already right?) and
Response.CodePage = 65001. On 2000 SP4 with IIS5 this gets trickier still
because the Response object doesn't have a CodePage property, you would need
to do it on the session then set the codepage back to its original value
after the Write.
Option 4 is well worthwhile if you can stand the upheaval but for new code
its worth considering.
--
Anthony Jones - MVP ASP/ASP.NET
|
| |  3 answer | Add comment |
Friday, 14 November 2008
|
| Display alert or messages to the user. Marge 02:54:08 |
| | This may be in the wrong forum, but here goes.
How can I display an alert in the users browser window from an asp page.
For example, a welcome message. I know I can do this with response.write,
but I'd like to have a general method of displaying messages to the user.
Thanks a lot all.
|
| | 25 answers | Add comment |
Thursday, 13 November 2008
|
| Re: ASP.NET 1.1 Update PA Bear 23:35:10 |
| | [Forwarded to microsoft.public.inetserver.asp.general newsgroup via
crosspost.]
cf.
http://www.microsoft.com/downloads/results.aspx?DisplayLang=en&nr=20&categoryid=7&freetext=asp.net+1.1&sortCriteria=date
--
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002
AumHa VSOP & Admin http://aumha.net
DTS-L http://dts-l.net/
Kevin wrote:
How often has ASP.NET 1.1 been updated since April 1, 2008? We are running a two servers and they have different ASP.NET 1.1 modify dates. The version numbers are the same, 1.1.4322. We have a third party vendor that is claiming that a problem occurred in their software because of an update to ASP.NET 1.1. Could you give me the date and description of all ASP.NET 1.1 updates since April 1, 2008?
|
| | 6 answers | Add comment |
|
| Searching foreign characters - Classic ASP & SQL 2005 Matt 19:48:36 |
| | I originally posted this in microsoft.public.sqlserver.server, and it
was suggested that I post here.
I'm having problems with searches via a classic ASP front-end of terms
including foreign characters. For example, Profiler indicates that a
search for: ,
is actually executed as:
SELECT top 1 '1' from dbo.mytable where contains(myfield,
'"все ок, юзай
на
здоровье"')
How do I prevent the foreign characters (in this case Cyrillic) from
being converted to HTML ASCII?
Thanks!
|
| | 5 answers | Add comment |
Wednesday, 12 November 2008
|
| CDONTS and Japanese Characters Dooza 18:38:34 |
| | Hi there,
I have a funny problem that I need some advice on.
I have a UK colo server, with UK regional settings. We have several
forms setup (ASP/VBScript) that are request more information type forms.
We have recently setup an office in Asia, and have created a website for
them on our UK based server. They too want a request more information
form. What do I need to do to enable Japanese characters to be sent
through an form to an ASP page that uses CDONTS to sent emails?
So far I have set on the form page and the sending page:
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
When I use <% @CODEPAGE=932%> at the top of the sending page the output
is even worse, I get stuff like this where the data should be:
?????item_field[company]=??????item_field[address]=?????
What is worse is that the recipient is going to be accessing the emails
from a OWA server in the UK, but they do have a Hotmail account that
they have access to.
Any advice is welcome.
Cheers,
Steve
|
| | 1 answer | Add comment |
|
| Long String Error Scott 01:54:26 |
| | I'm trying to capture all form elements posted on a page and concatenate
them into a string for testing and to include in an email message. I'm
getting the below error "Out of string space". I thought using the "chr(13)
& chr(10)" characters at the end of each line would fix the issue, but it
doesn't work.
How can I get such a long string concatenated without the below error?
' Code: ***********************************
<%
sRequestForm = "<TABLE><TR><TD><B>Request Form Values</B></TD>" & chr(13)
& chr(10)
sRequestForm = sRequestForm & sRequestForm & "<TD><B>Value</B></TD></TR>"
& chr(13) & chr(10)
For Each s in Request.Form
sRequestForm = sRequestForm & sRequestForm & "<TR><TD>" & name & "</TD>"
& chr(13) & chr(10)
sRequestForm = sRequestForm & sRequestForm & "<TD>" & Request.Form(s) &
"</TD>" & chr(13) & chr(10)
sRequestForm = sRequestForm & sRequestForm & "</TR>" & chr(13) & chr(10)
Next
sRequestForm = sRequestForm & sRequestForm & "</TABLE>"
Response.Write "sRequestForm: " & sRequestForm & "<BR>"
%>
' Error: **********************************
Microsoft VBScript runtime error '800a000e'
Out of string space
/bathroom_wall_sign.asp, line 668
|
| | 3 answer | Add comment |
Tuesday, 11 November 2008
|
| Redesign of Table with Multiple Forms in Each Row Ll 21:51:08 |
| | Hi all,
I've inherited a site and am currently looking to redesign a page that
displays a table of course curriculum, with each row representing a
"Topic" of the curriculum. There is a courseID that exists throughout
the site, identifying each course.
Within each row of the aforementioned table, there are 4 columns,
consisting of MainTopics, their associated SubTopics, uploaded
LectureNotes for that MainTopic, and finally a DeleteRow button in the
last column.
The way this page was originally done was very workable, although it
is a little tedious. Each MainTopic is actually an individual form
with textarea containing a description of the MainTopic and a Save
submit button. Likewise, in the second column, each SubTopic is its
own form, consisting of a textarea containing a description of the
SubTopic and a Save button and a Delete button. In the third column,
listed are any uploaded LectureNote documents in link form, along with
a Delete button. In the fourth column, there is a DeleteRow button
which, as it states, deletes the entire row. *Note: Each row can only
have one MainTopic, although it can have multiple SubTopics and
multiple uploaded LectureNotes.
In the code, there is a SQL statement that queries the MainTopic table
first, getting the MainTopicID. The first MainTopic is then displayed
in the first column of the table. Next, another SQL statement queries
the SubTopic table, referring to its (foreign key) MainTopicID to
select the appropriate SubTopic. The associated SubTopic(s) are then
displayed in the second column of the table. Next, a SQL statement
queries the LectureNote table, referring to its (foreign key)
MainTopicID to select the appropriate LectureNote. The associated
LectureNote(s) are then displayed in the third column of the table.
The DeleteRow button then occupies the fourth column before the
MainTopic loop goes on to form another table row.
I would like to be able to do three things in redesigning this page:
1. Save updates to the entire row with a single submit button (one on
each row, rather than one by each textarea).
2. Change the MainTopic number for the entire row (for MainTopic,
SubTopic(s), LectureNote(s), and DeleteRow button with drop down
select/save.
3. Create a "copy" function that will allow the user to, by perhaps a
dropdown box, select MainTopic and associated SubTopic(s) and
LectureNote(s) from another course (with another courseID) and then
copy that course's MainTopics, SubTopics, LectureNotes to the current
course.
Would this be do-able with classic ASP? My main intent is to stay as
close to the original design as possible, although if it does require
a re-build, that's ok. Would AJAX perhaps make this an easier task to
comlete?
I can post code, if that would be more helpful.
Thanks for any help or resources,
Kind Regards,
Louis
|
| | 3 answer | Add comment |
|
| stuck on UPDATE subquery for lookup table in Access 2003 Mike 20:14:55 |
| | Hello,
I have a table [lookup] that I have some values like this:
ID L A
1 1 3
2 2 4
3 3 7
4 4 9
5 5 12
and I have another table [data] that has some values like this:
ID L A
1 2 null
2 4 null
3 5 null
4 5 null
5 4 null
6 4 null
I need a query that will take the value of the L column from the
[data] table and look it up in the [lookup] table and UPDATE the
[data] table column A with the appropriate value from the [lookup]
table. For example, the first record of the [data] table should read
"4" in the A column after the update, while the second record should
read "9" in the A column after the update, etc.
I tried something like this:
UPDATE [data] SET [data].A = (SELECT [lookup].A FROM [lookup] WHERE
[lookup].L = [data].L)
but I get an error. Can someone show me how to do this (so it works
Access 2003)?
Thanks,
Mike
|
| | 2 answer | Add comment |
|
| MSXML size limitation Sidlet 15:47:01 |
| | I'm using the following:
source = new ActiveXObject("Microsoft.XMLDOM");
source.async = false;
//Send request string and read the result into the XMLDOM object
source.load(sreq);
This works fine (I get over 4MB back in XML) on my development workstation
which is Win2K but on the Windows 2003 server it's cutoff
So my new question is whether there is something in the Metabase on the 2003
server which can alter this to work as it did before under Win2k so I get the
larger than 2MB back into the XML document?
|
| | 2 answer | Add comment |
|
| Forms sending some blank emails Guest 15:34:58 |
| | Hi, I'm validating a form with this ASP but receiving some blank email
responses; does anyone see anything wrong with it?:
function isFormVarExcluded(thisForm, strToCheck)
{
var strExcludeVars = thisForm.elements["$excludevars"].value;
var arrExcludeVars = strExcludeVars.split(",");
for (var j=0; j<arrExcludeVars.length; j++)
{
if (arrExcludeVars[j] == strToCheck) return true;
}
return false;
}
function getFormVars(thisForm)
{
var oFormVars = thisForm.elements["$formvars"];
var strPrevVal = "";
oFormVars.value = "";
for (var x=0,objElem=null; objElem=thisForm.elements.item(x); x++)
{
if (!isFormVarExcluded(thisForm, objElem.name))
{
if (objElem.name != strPrevVal)
oFormVars.value += objElem.name + ",";
}
strPrevVal = objElem.name;
}
oFormVars.value = oFormVars.value.substr(0,oFormVars.value.length-1);
}
|
| | 2 answer | Add comment |
Sunday, 9 November 2008
|
| Re: Display alert or messages to the user. Nothing Better to DO??? Marge 12:39:12 |
| | I've re-read every post here and I have to say, some of you people are
complete and utter jerks.
To think that one would do this "TOP POSTING" on purpose (yes a few have to
make a point), is utter stupidity and in my opinion is a complete waste of
time to natter about. Not to mention waste of bandwidth and disk space. GROW
UP LITTLE KIDS!!!
Get a life and forgive people that make a mistake once in a while!
If you all think you are better than anyone else, then good luck to you and
your miserable life!!! JERKS!!!!
This is supposed to be an NG for help, not RIDICULE!!!
I'm Ok with this, cause it was just a mistake, not a life threatening
issue!!!
"marge" <mpeg@yahoo.ca> wrote in message
news:uMH5IpgQJHA.1164@TK2MSFTNGP02.phx.gbl...
Thank you, now I understand. If correct, it means I should reply to the post that I am directly reading as opposed to the one(s) above? I will try to make sure I don't do that again!!! Yes, am much better - lots more to go, but better. Thanks for the kind comment and the info. M. "Adrienne Boswell" <arbpen@yahoo.com> wrote in message news:Xns9B50A898E66BAarbpenyahoocom@69.16.185.250... Gazing into my crystal ball I observed "marge" <mpeg@yahoo.ca> writing in news:OaSB1GfQJHA.4060@TK2MSFTNGP02.phx.gbl: I'm sorry, but I don't know why everyone is yelling at me about Top Basically, top posting makes it hard for others to read messages, because the order has been mixed up. 1. How many should we buy? 1. How many should we buy? Now that I'm out of the hospital I started to catch up and Hope you are feeling better. Arbpen Web Site Design Services Please respond to the group so others can share
|
| | 1 answer | Add comment |
Saturday, 8 November 2008
|
| Application Pool crashing due to excesive memory use or ASP error - ASP problem MettÀ 13:17:11 |
| | I have a web site on a shared server (Win2003) and occasionally the site
goes down with a message "Service Unavailable" The ISP says there must be a
problem with the ASP content and excessive use of the Application Pool is
causing the problem
I can't find the cause but wonder if putting
<%Session.Abandon%>
and /or
<%Session.Contents.RemoveAll()%>
on the DB output pages will help to clear the excessive memory usage???
Any ideas???
Thanks
M
|
| | 2 answer | Add comment |
|
| microsoft jet database engine cannot open the file Snazzy 02:14:23 |
| | I have created an web application using Visual Studio 2008. The application
works OK in Debug. However it does not work after publish. The following
message appers "The Microsoft Jet database engine cannot open the file
'\\192.168.0.2\Test\Test.mdb'. It is already opened exclusively by another
user or you need permission to view its data".
|
| | 2 answer | Add comment |
Friday, 7 November 2008
|
| Trying to Redirect from https to http (secure to non secure) Raven 14:56:04 |
| | Hi,
I have a problem with a server side redirect from a secure page to a
non-secure page (same domain name, same folder)
I have added some test code that can display the target URL and that
containt http:// and yet it redirects to https://
example:
I am on
https://www.example.com/test/files/login.asp?Cmd=logout
enter username+password into a form; page posts back to itself, then
calls my function for redirection to non secure pages:
redirectNoSSL("myaccount.asp")
this executes
Response.Redirect "http://www.example.com/test/files/myaccount.asp"
but the browser goes to
https://www.example.com/test/files/myaccount.asp
Any ideas why this happens?
I suspect this has to do with a cookie that persists user/pwd info,
could that force the client to go to the Secure page?
thanks in advance
Axel
See my relevant code below:
Function stripSSL(sTarget)
Dim host
Dim sUrl
Dim i
stripSSL=""
if sTarget="" Then Exit Function
sUrl=Request.ServerVariables("URL")
host=Request.ServerVariables("server_name") '
Request.ServerVariables("HTTP_HOST")
sTarget=" & sTarget
i=InStrRev(sUrl, "/")
stripSSL= "http://" & host & Left(sUrl,i) & sTarget
End Function
Function redirectNoSSL(sUrl)
Dim sNewURL
sNewURL = stripSSL(sUrl)
If False Then ' Print link instead of redirect
Response.Write "<BODY>TEST: Redirect to stripSSL (" & sUrl & ") =
<a href=" & sNewURL & ">" & sNewURL & "</a>"
Response.Write "<BR>ServerVariables(HTTPS)=" &
Request.ServerVariables("HTTPS") & "</BODY>"
Response.End
Else
Response.Redirect sNewURL
End If
End Function
|
| | Add comment |
Thursday, 6 November 2008
|
| Accessing VB DLL (COM) from ASP Chris 13:43:11 |
| | Hello,
I am a newbie learning COM. I used the below sample to build a
prototype.
http://www.stardeveloper.com/articles/display.html?article=2000041001&page=1
I was able to create the .dll using VB6. The .dll wasn't automatically
registered as I am using OS - Vista. I registered the .dll manually
using regsvr32 command.
After registering, when I tried to use it in ASP application using the
below code, and it gave me an error. The error was on the line "Set sd
= Server.CreateObject("Stardeveloper.Author")"
I tried googling around, but did not find any solution. Am I missing
something?
Code:
---------
<html>
<head>
</head>
<body>
<%
' Declaring variable
Dim sd
' Creating instance of our Component
Set sd = Server.CreateObject("Stardeveloper.Author")
Response.Write "Name of author is : " & sd.Author
Set sd = Nothing
%>
Error:
--------
An error occurred on the server when processing the URL. Please
contact the system administrator
Thank you!
Christina
|
| | 2 answer | Add comment |
Tuesday, 4 November 2008
|
| Could not find stored procedure problem Malcolm O'Nions 17:19:20 |
| | I am updating an old ASP application that connects to a SQL server database and I'm getting a "Could not find stored procedure" error.
The procedure is owned by dbo and the user connecting to the database has specifically been granted execute permissions on the procedure (and I've tried making the user a member of the db_owner group and even tried my own sysadmin privileged user account). The connection is correct (it's the same one as is used succesfully on other procedures). It only affects newly written stored procedures.
I've checked all the obvious (user permissions, connection etc) and it's none of those
This is the procedure:-
CREATE PROCEDURE proc_GetGroupsByLetter(
@intGroup int = NULL,
@strLetter varchar(1) = NULL
)
AS
SET NOCOUNT ON
IF ISNULL(@intGroup, 0) = 0
BEGIN
IF ISNULL(@strLetter, '') = ''
BEGIN
SELECT CustomerGroup, CustomerGroupName, GroupType, ContractType, Tier,
CONVERT(varchar, ContractStartDate, 105) AS ContractSDate, CONVERT(varchar, ContractEndDate, 105) AS ContractEDate
FROM CustomerGroups
END
ELSE
BEGIN
SELECT CustomerGroup, CustomerGroupName, GroupType, ContractType, Tier,
CONVERT(varchar, ContractStartDate, 105) AS ContractSDate, CONVERT(varchar, ContractEndDate, 105) AS ContractEDate
FROM CustomerGroups
WHERE LEFT(CustomerGroupName,1) = @strLetter
END
END
ELSE
BEGIN
SELECT CustomerGroup, CustomerGroupName, GroupType, ContractType, Tier,
CONVERT(varchar, ContractStartDate, 105) AS ContractSDate, CONVERT(varchar, ContractEndDate, 105) AS ContractEDate
FROM CustomerGroups
WHERE CustomerGroup = @intGroup
END
This is the code that connects
strConn = "Provider=SQLOLEDB.1;"
strConn = strConn & "Data Source=(local);"
strConn = strConn & "Initial Catalog=CostSavings"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout = 0
objConn.Open strConn, "webread", "wa4asp"
Set cmdADO = Server.CreateObject("ADODB.Command")
Set prmADO = Server.CreateObject("ADODB.Parameter")
Set rsADO = Server.CreateObject("ADODB.RecordSet")
With cmdADO
.ActiveConnection = objConn
.CommandType = adCmdStoredProc
.CommandText = "proc_GetGroupsByLetter"
Set prmADO = .CreateParameter("@intGroup", adInteger, adParamInput, 0, Null)
.Parameters.Append prmADO
Set prmADO = .CreateParameter("@strLetter", adVarChar, adParamInput, 1, strLttr)
.Parameters.Append prmADO
Set rsADO = .Execute
End With
And this is what happens
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Could not find stored procedure 'proc_GetGroupsByLetter'.
/cs/ajax/geteurogrouplist.asp, line 37
Any ideas what the problem might be?
Thanks
|
| | 3 answer | Add comment |
|
| Successful way to Rewriting URLs with ASP? Toni 13:49:23 |
| | Does anyone have a recommended method of rewriting URLs with classic ASP?
For example, if the browser shows the Friendly URL
www.mydomain.com/blue_widget
my app will show the following Content Page
www.mydomain.com/item.asp?id=32&type=d&color=blue
Right now, I'm experimenting with having my error 404 file do the redirect. But it's not
as clean as I'd like - if I do a Server.Transfer or Server.Execute to the content page
(the query strings are passed as session variables), the PATH_INFO shows that the URL is
my error 404 file, which messes up my SmarterStats site statistics (BTW, "Smarter"Stats
is actually pretty dumb).
If my error 404 file performs a Response.Redirect, the address bar sometimes shows the
Content Page URL instead of the Friendly URL, defeating the purpose.
Before deciding to spend the time, energy, and effort to move to ASP.NET 2.0, can anyone
tell me if you've successfully implemented a rewriting URL method that makes you happy?
Can the ASP.NET web.config file be made to work in this to successfully rewrite URLs?
Thanks!!!
Toni
|
| | 3 answer | Add comment |
|
| Regular expression to identify HTMLEncoded string Gabriela 12:33:21 |
| | Hi,
I need help with writing a regexp that identifies HTML encoded
strings.
The problem occurred because I have a field in the DB, that contains
regular ASCII chars, as well as HTMLencoded strings (e.g.:
זאת לא).
Is there a quick way to determine which strings are HTML encoded?
Thanks,
Gabi.
|
| | 2 answer | Add comment |
Monday, 3 November 2008
|
| ASP.NET app - Slow initial load IIS6 Med 16:33:00 |
| | Hi,
Initial load of my ASP.NET app takes 50 seconds to load. Then it become
fairly fast. Followings are my app/hardware configs:
Server/IIS:
-----------
IIS 6 running on Hosted VPS Windows 2003 Enterprise, with allocated 512MB
RAM. Lots of memory still available when my app runs. CPU usage is low too.
Application pool default settings.
ASP.NET:
--------
ASP.NET 3.5 using "StateServer" service.
Initially I thought delay was caused by SQL connection, so I created a blank
asp.net app, with one page (default.aspx) only. This page does not try to
connect to SQL on load. It only does this when a button on default.aspx is
clicked which calculates connection time.
When I tried to load default.aspx, it still took more than 50 seconds to
load. Considering there is no code to run when this page loads. SQL
Connection takes less than 7 millisecond to execute. So SQL connection is
not source of the problem.
Does anyone knows possible cause of this delay? I think it is asp.net/IIS
related or might have something to do with app pooling or "StateServer"
service perhaps?
Thanks for your time.
Kind Regards
Med
|
| | 1 answer | Add comment |
Saturday, 1 November 2008
|
| ASP.Net Frame Work Doug Bynum 15:22:29 |
| | Which O/S has more tools to program in ASP.Net; XP or Vista?
--
D.E.B.
|
| | 2 answer | Add comment |
Friday, 31 October 2008
|
| Unexpected Exception. Devin 18:28:31 |
| | Hi,
I'm getting an exception error on this line:
do while not rs.eof and ucase(rs.fields("category")) =
ucase(holdLast)
This error occurs on the last record in the table (mdb). I deleted
the last few records from the table to see if it was something with
the record. The same thing occured.
I also response.write the values of rs.fields("category") and
holdLast and they output the values I would expect.
Am I going nuts?
I don't want to post my enter page, but if the error could really go
beyond this line then please let me know.
Thanks for any input.
DC
|
| | 3 answer | Add comment |
Thursday, 30 October 2008
|
| Creating date-based grid in ASP Mike P 20:03:49 |
| | I need to create a grid which along the y axis has a user name and along
the x axis has a date. Somehow I need to populate the x axis with 6
months worth of dates from the current date, and then look at a database
table that lists what dates a user is busy on so that I end up with a
grid that shows all users and all dates for the next 6 months and when
they are busy and when they are not busy.
I have very little experience in ASP so this is proving very tricky, I
think the hardest part would be creating the grid with a column for each
date for the next 6 months.
Can anybody help?
*** Sent via Developersdex http://www.developersdex.com ***
|
| | 2 answer | Add comment |
|
| Consuming .NET Webservice from classic ASP Guest 16:23:35 |
| | I am trying to consuming a .NET web service from a standard (classic)
ASP, but having not so much luck as I dont have much experience about
SOAP.
Here is the webservice url: http://test.webservices.superbreak.com/SoapEndpoint.asmx
I have been advised that i need to use this through MSSOAP Toolkit or
through soap envelope.
Could someone advise about some coding pattern to access this service?
Thanks!
arno
|
| | 2 answer | Add comment |
|
| system.web.httpcontext.current.user.identity.name shows old usenam Antonio O''Neal 15:22:07 |
| | We changed a username in AD. The user now logs on to a computer on our
network using the new username without any problems. They can not logon using
the old username. However, when they access a IIS 6.0 web site where a
programmer compares system.web.httpcontext.current.user.identity.name to a
lookup table containing usernames they could not gain access with the new
userid. We created a web page to show what
system.web.httpcontext.current.user.identity.name is returning. It is
returning their old username. If we put the old username in the table the
user may access the web site. The IIS site logs for the web site show the
new username for the user as he accesses the site. I have used adsiedit to
look at the user's information in AD. It shows only the new username through
out the the account parameters.
We also have a sharepoint 3.0 site that shows the user's old username when
he accesses that site.
What can I do so system.web.httpcontext.current.user.identity.name will
contain the new username for this renamed account?
Thank you,
Antonio
|
| | Add comment |
|
