Hi all,
i am an ASP developer with 1,5+ years experience. After sneaking around the
ASP Classic world for a bit i became a bit dissatisfied of my ASP code
practices so i'd like to have some advice from the advanced/pro users...
some advice that would help me to grow up!
I know that many (if not all) the stuff that was a hassle in ASP 3 has been
corrected in ASP.NET/VS.NET (which i'm studying) but ASP 3 will still be
around for a long time (at least for all the lifetime of Win2k3) so i think
it would still be worth knowing how to program the right way in ASP 3.
So here are my questions
- How do you design multi-tier web applications? What needs to go in the
Data/Business/Presentation layer? Otherwise (if 3 tier is overkill for you,
as it would be for the stuff i write) how do you architect your application?
Where do you put code, ect...?
- How do you access the db? Do you have customized classes for accessing the
data, retrieving recordsets?
- Do you have any datagrid class for displaying/editing/sorting data?
- Do you store db connections as an application variable?
- Some links to useful components (preferably free!)
- Any else?
Thank You very much for paying attention to this post.
Lorenzo
18  9164 
In my previous post i forgot and important subject: error handling,
especially form processing error handling, user input validation, etc...
Lorenzo
> - Do you store db connections as an application variable?
NEVER!
> In my previous post i forgot and important subject: error handling, especially form processing error handling, user input validation, etc...
I do as much validation as I can on the client side. This way, the user
gets feedback right away, instead of waiting for a round-trip to the server.
Also, this means less toll on your web server, particularly if your user
base consists of a large ratio of numbskulls (or if your forms aren't
designed very well :-).
However, I think it is important to also validate on the server side (for
format issues, in ASP; for data violations, in SQL Server). There should
never be a way for bad data to get into the system, and a cunning user can
usually find a way to bypass client-side validation. Where do you put code, ect...?
- Option Explicit is the first thing after the language declaration
- Pre-processing code - getting the data from the database; updates;
inserts; deletes all go above the <HTML> tag, so redirecting is not an issue
when the db work is done.
- Presentation - that is, everything the user sees after getting the data -
goes between the <HTML>of course</HTML>.
- All javascript validations and instructions are collected into an array
and output as the last thing before the </HTML> tag. I have another post on
this subject, earlier in this group.
- Subs and functions local to the page go after the </HTML> tag.
- Subs and functions used throughout the app go into other files, such as
stringFunctions.asp, sqlFunctions.asp, etc etc etc, and are included as
needed immediately after the Option Explicit line.
- Because we specify IE5.5 as a minimum standard for our application,
behaviors are used whenever possible to limit the amount of code written in
every page.
- How do you access the db? Do you have customized classes for accessing
the data, retrieving recordsets?
Customized classes? No. Wrapper functions? Yes. For instance,
GetRs conn, rs, sSQL, "[Somepage.asp].[Function1] Getting employee data<p>"
& sSQL
- creates the connection if conn.state <> 1
- creates the recordset if rs is not an object
- redirects to an "Oops" page if rs.state <> 1, displaying the error
message shown in the last parameter
CreateConnection objConnection:=conn, UseShape:=false
- accepts a connection object
- gets connection string for shape queries if true, vanilla OLEDB if false
- redirects to an "Oops" page if conn.state <> 1, displaying the error
message built from the connection's errors collection
- Do you have any datagrid class for displaying/editing/sorting data?
No.
- Do you store db connections as an application variable?
NO. NEVER. NOT EVER. ON PAIN OF DEATH. OR JUST PAIN. Let me be
completely unambiguous: NO.
- Some links to useful components (preferably free!)
JMail. http://www.dimac.net. Beats the hell out of CDONTS.
- Wm "agressively lazy" Morris
--
William Morris
Product Development, Seritas LLC
> JMail. http://www.dimac.net. Beats the hell out of CDONTS.
I don't think anybody ever suggested that CDONTS was any good. It was
deprecated for a reason (well, dozens of reasons, probably).
If you have access to SQL Server, I prefer xp_smtp_sendmail for sending
alerts, etc. This way, all mailing is controlled from one location, and it
is capable of sending alerts for database errors, ASP errors (500, 404, 403,
etc), and you can also schedule it to send daily, weekly emails to lists of
users, etc. You have a single stored procedure wrapped around this xp, and
you can call it from anywhere (stored procedure, directly from ASP, from a
job, etc).
Of course, you might have to rely on a COM, or CDO.Message object if you are
worried that xp_smtp_sendmail will ever fail... but that's easy enough to
set up. In the procedure that wraps the xp, just have an error trap that
uses sp_OACreate to send mail via jmail, CDO.Message, or some other object
to send the mail. You might also wish to send a NET SEND in this case, in
case it's the SMTP server and not the sending itself, or else have a backup
SMTP server available as well.
In any case, for more info about xp_smtp_sendmail, see www.aspfaq.com/2403
WIlliam Morris wrote: ... - Do you store db connections as an application variable?
NO. NEVER. NOT EVER. ON PAIN OF DEATH. OR JUST PAIN. Let me be
completely unambiguous: NO.
care to elaborate on the issue(s) ?
--
William Tasso - http://WilliamTasso.com
Tnx to everybody who has partecipated in this thread!
Lorenzo
After retrieving data into a RecordSet, I used to iterate thru the RS and I
have even issued a GetRows into an array, but I now save it into an XML
structure and iterate thru its Nodes.
Putting data into an array makes maintenance a PITA because you have to
identify the columns using numbers, so visiting the page some days later
causes headaches.
here's what I do now:
set oXML = Server.CreateObject("MSXML2.DomDocument")
oRS.save oXML,1
' now close all ADO objects
set rows = oXML.selectNodes("//z:row")
rowCount = rows.length
for each row in rows
' use row.getAttribute("columnName")
next
Brian
"Lorenzo Bolognini" <lo*****@mysurname.net> wrote in message
news:Wm**********************@news2.tin.it... Hi all,
i am an ASP developer with 1,5+ years experience. After sneaking around
the ASP Classic world for a bit i became a bit dissatisfied of my ASP code
practices so i'd like to have some advice from the advanced/pro users...
some advice that would help me to grow up!
I know that many (if not all) the stuff that was a hassle in ASP 3 has
been corrected in ASP.NET/VS.NET (which i'm studying) but ASP 3 will still be
around for a long time (at least for all the lifetime of Win2k3) so i
think it would still be worth knowing how to program the right way in ASP 3.
So here are my questions
- How do you design multi-tier web applications? What needs to go in the
Data/Business/Presentation layer? Otherwise (if 3 tier is overkill for
you, as it would be for the stuff i write) how do you architect your
application? Where do you put code, ect...?
- How do you access the db? Do you have customized classes for accessing
the data, retrieving recordsets?
- Do you have any datagrid class for displaying/editing/sorting data?
- Do you store db connections as an application variable?
- Some links to useful components (preferably free!)
- Any else?
Thank You very much for paying attention to this post.
Lorenzo
Why not make a client side cursor recordset and use it as a disconnected
recordset?
Just disconnect right after rs.open.
<%
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
rs.CursorType = adOpenStatic
rs.Open strSQL, ObjConn
Set ObjConn = Nothing
Do While Not rs.EOF
'What Ever
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
%>
iterating an XML is expensive processing time.
-dlbjr
Discerning resolutions for the alms
Brian Staff wrote: After retrieving data into a RecordSet, I used to iterate thru the RS
and I have even issued a GetRows into an array, but I now save it
into an XML structure and iterate thru its Nodes.
Putting data into an array makes maintenance a PITA because you have
to identify the columns using numbers, so visiting the page some days
later causes headaches.
You can use constants to save yourself those headaches:
rs.open (select username, userpassword from ..." ...
arResults = rs.GetRows
const cUserName = 0
const cUserPassword = 1
sUserName = arResults(cUserName, 0)
etc.
An array will outperform the XML Parser, so if you need performance, stick
with the array.
HTH,
Bob Barrows
dlbjr wrote: Why not make a client side cursor recordset and use it as a
disconnected recordset?
Just disconnect right after rs.open.
iterating an XML is expensive processing time.
It will probably outperform a recordset loop (I've never tested this - it's
just my gut feeling), but an array will beat both handily.
Bob Barrows
I Agree! Just don't use the XML idea
--
-dlbjr
Discerning resolutions for the alms
Don't write it off so quickly. Performance is not an issue for me - it's
plenty fast enough.
Having my data in an XML structure now allows me to separate the tiers quite
easily.
The data tier reads the data and creates an XML structure. It then passes it
off to the business tier who iterates thru it creating a XHTML structure who
then passes it to the GUI tier where it may, depending on the client,
transform it using XSL before sending it to the end user.
It works for me<g>.
Brian
"dlbjr" <do******@do.u> wrote in message
news:ee**************@TK2MSFTNGP11.phx.gbl... I Agree! Just don't use the XML idea
--
-dlbjr
Discerning resolutions for the alms
Brian Staff wrote: Don't write it off so quickly. Performance is not an issue for me -
it's plenty fast enough.
I didn't mean to recommend that it be "written off". I was merely commenting
on the relative performance.
I use xml documents extensively, mainly for passing structured data between
processes, such as from server-side to client-side code.
Bob Barrows This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: byrocat |
last post by:
I'm chasing after a documetn that was available on one of the Microsoft
websites that was titled somethign like "MS SQL Server Best Practices"
and detailed a nyumber of best practices about...
|
by: Matt Kruse |
last post by:
http://www.JavascriptToolbox.com/bestpractices/
I started writing this up as a guide for some people who were looking for
general tips on how to do things the 'right way' with Javascript. Their...
|
by: john doe |
last post by:
A quick question, about so-called 'best practices', I'm interested in
which of A/B of the two examples people would choose, and why.
public enum MyEnum
{
Option1 = 0,
Option2 = 1,
Option3 =...
|
by: Amelyan |
last post by:
Could anyone recommend a book (or a web site) that defines best practices in
ASP.NET application development?
E.g.
1) Precede your control id's with type of control btnSubmit, txtName, etc.
2)...
|
by: Luis Esteban Valencia |
last post by:
Hello. Can somebody recomend me books of design patterns in c# and best
practices too.
|
by: jojobar |
last post by:
Hello,
I am trying to use vs.net 2005 to migrate a project originally in vs.net
2003. I started with creation of a "web site", and then created folders for
each component of the site.
I read...
|
by: Ren |
last post by:
Hi All,
I'm still rather new at vb.net and would like to know the proper way to access
private varibables in a class. Do I access the variable directly or do I use
the public property?
...
|
by: AJ |
last post by:
Hi all,
I am wondering if their are any links out their dealing with best practices
when
it comes to enterprise web site organization. We are still maintaining
classic ASP applications so...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
