Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: Grouping


Message #1 by Atoo <Atoo@m...> on Wed, 25 Apr 2001 11:51:16 -0400
Hello all,



I have an asp report that needs to be grouped by each department and get

totals at the end of each department.  Example:



Department A              Amount Given = $1,000.00



	Coffee			$500.00

	Tea			$200.00



	Total  			$700.00

	Remaining Balance	$300.00



Department B		Amount Given = $2,000.00



	Envelopes		$400.00

	Pens			$200.00



	Total			$600.00

	Remaining Balance	$1,400.00



Secondly, I have a logon form that requests userID to open this report with

the current user's information.  The problem is whenever I go back to type

in an ID a drop down list pops up with all the previously typed IDs which

makes it insecure because anybody can come in and select from the dropdown

list to look at someone else report.  How do I stop this, I have set the

page to expire in 1 minute but that doesn't help.



Thanks!!

Message #2 by Kyle Burns <kburns@c...> on Wed, 25 Apr 2001 12:29:19 -0500
This is a feature of Internet Explorer that cannot be turned off at the web

server level.  One thing you could do, however, is dynamically generate the

name of the id box and pass the name of the id box in a hidden field to the

page that processes the request. e.g.:



***** In LOGON form *****

<FORM ACTION="processingpage.asp" METHOD="post">

<%

	Dim UIDField

	UIDField = SomeFunctionToGenerateRandomName()

%>

	<INPUT TYPE="hidden" NAME="UIDField" VALUE="<% =UIDField %>">

	<INPUT TYPE="text" NAME="<% =UIDField %>">

...

</FORM>





***** In PROCESSINGPAGE *****

<%

	Dim UIDFieldName

	Dim UID



	UIDFieldName = Request("UIDField")

	UID = Request(UIDFieldName)

%>





>> -----Original Message-----

>> From: Atoo [mailto:Atoo@m...]

>> Sent: Wednesday, April 25, 2001 10:51 AM

>> To: ASP Web HowTo

>> Subject: [asp_web_howto] Grouping

>> 

>> 

>> Hello all,

>> 

>> I have an asp report that needs to be grouped by each 

>> department and get

>> totals at the end of each department.  Example:

>> 

>> Department A              Amount Given = $1,000.00

>> 

>> 	Coffee			$500.00

>> 	Tea			$200.00

>> 

>> 	Total  			$700.00

>> 	Remaining Balance	$300.00

>> 

>> Department B		Amount Given = $2,000.00

>> 

>> 	Envelopes		$400.00

>> 	Pens			$200.00

>> 

>> 	Total			$600.00

>> 	Remaining Balance	$1,400.00

>> 

>> Secondly, I have a logon form that requests userID to open 

>> this report with

>> the current user's information.  The problem is whenever I 

>> go back to type

>> in an ID a drop down list pops up with all the previously 

>> typed IDs which

>> makes it insecure because anybody can come in and select 

>> from the dropdown

>> list to look at someone else report.  How do I stop this, I 

>> have set the

>> page to expire in 1 minute but that doesn't help.

>> 

>> Thanks!!

>> 

>> ---

>> SoftArtisans helps developers build robust, scalable Web 

>> applications!

>> Excel Web reports, charts: 

http://www.softartisans.com/excelwriter.html

File uploads: http://www.softartisans.com/saf.html

Transactional file management: http://www.softartisans.com/saf1.html

Scalability: http://www.softartisans.com/saxsession.html

ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html




$subst('Email.Unsub')

Message #3 by "Anil Rhemtulla" <AnilR@T...> on Fri, 27 Apr 2001 09:58:41 +0200
Three options I can think of:



    - For IE 5 and above : add the attribute "autocomplete=off" to the INPUT

field.



    - Turn the autocomplete feature in the browser off.



    - Use a password field instead of a text field. From what you say the

information is secret.





hope this helps,

Anil





----- Original Message -----

From: "Atoo" <Atoo@m...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Wednesday, April 25, 2001 5:51 PM

Subject: [asp_web_howto] Grouping





> Hello all,

>

> I have an asp report that needs to be grouped by each department and get

> totals at the end of each department.  Example:

>

> Department A              Amount Given = $1,000.00

>

> Coffee $500.00

> Tea $200.00

>

> Total  $700.00

> Remaining Balance $300.00

>

> Department B Amount Given = $2,000.00

>

> Envelopes $400.00

> Pens $200.00

>

> Total $600.00

> Remaining Balance $1,400.00

>

> Secondly, I have a logon form that requests userID to open this report

with

> the current user's information.  The problem is whenever I go back to type

> in an ID a drop down list pops up with all the previously typed IDs which

> makes it insecure because anybody can come in and select from the dropdown

> list to look at someone else report.  How do I stop this, I have set the

> page to expire in 1 minute but that doesn't help.

>

> Thanks!!

>


  Return to Index