Assuming I create an object as below
<%
Dim objMainItem
Set objMainItem = New ItemContent
objMainItem.item_id = 1
objMainItem.Open()
%
and the class ItemContent creates a recordset based on the item_id passed in. Each item record contains the fields (header,label,content). I would like to reference the fields in the following format
<%= objMainItem.header %
When I write the code
Code:
Set a = new C1
Block of code
Set a = Nothing
Set b= new C2
Block of code
Set b = Nothing
The Class C2 doesn't work.
I've been searching for some information on the use of Classes in ASP, but
found very little information.
I found this http://www.daniweb.com/tutorials/tutorial19997.html .
Are there more information somewhere online?
For the majority of my work, I just use plain ASP. On the rare occasion that
I am doing something intensive that does require user interaction I might
create a COM component (ie where performance gain outweighs the overhead of
COM).
A simple Rule-of-Thumb. I imagine this is fairly common practice... (I hope
it is, at least).
However, I'm curious about VBScript Classes. I would have imagined that if a
page was complex enough to merit defining and creating your own
classes/objects, that COM would be appropriate...
In which case, when and how do people use VBScript Classes?
I am re-coding a VB application to be used on the web, some of which requires additional DB components for user registration etc. Usually I use ASP classes to manage the DB I/O stuff but I was wondering whether they are any benefits in having them as VB classes and compiled as dlls?
I like the idea of having the VB application as dlls, but using asp classes for the general functionality of the application. However, I don't wish to do this out of convience for myself.
one developer once told me that he doesn't use classes as there is a performance issue. is this true? the functions i'd be creating can easily go into an include file as a set of functions and not a class. so i'm not too sure about going ahead and encapsulating them into classes. has anyone got any input?
View Replies View RelatedI've been working in .NET for some time now and I don't remember specifically
how asp classes are cleaned up in classic asp. I've been put on a Classic
ASP project(ugh) and we're having some serious stability problems. Once we
reach a point of sustained CPU useage of over 80% IIS 6 restarts the w3wp.exe
process which of course terminates all sessions and resets the website.
I've
noticed that the previous developer has an include which creates a couple of
class objects in ASP. Not third party or "CreateObject" objects, but ASP
classes. This include is in A LOT of files and the classes not being
destroyed in any of them.
My question is could this be the problem? I seem to remember a problem with
ASP classes and not destroying them causing leaks of some sort. I need to
mention that the memory doesn't seem to be leaking but the CPU utilization
goes wacko as if ASP/IIS is corrupt. My environment is Windows 2k3 and IIS
6. The previous environment was Windows 2K and IIS5. Both environments had
the problem.
Before I go through these hundreds of files I was wondering if anyone
remember what the problem was with ASP classes not being destroyed.
I've always had problems getting my head around using collections and classes together. Separately, they seem like fairly simple subjects, but I'm getting muddled up when trying to use them together.
Can someone toss together a simple example of how I'd create my classes and collection? Code:
I'd like to create a class file for a shopping cart that I'm working on but I'm not sure about how to use the database with it.
Do I connect and open to the database inside the class or outside of the class and set the properties?
I'm thinking that if I open and close the database with say a getItem() method and I have 15 items to get, I'll be opening and closing a connection 15 times. Isn't that bad?
I write classes in php, beans in jsp, what "modularity" does asp have? Can I write classes? Or "com" what can I do? which advantages exist with these paths: classes, com, etc.
View Replies View RelatedIs there a way to use classes written in .NET in an ASP classic application? Maybe similair to using DLLs with Server.CreateObject? I want to write all our new classes using .NET with the intent of eventually changing the web application to ASP.NET.
I've tried Googling for the answer but I only get ASP.NET literature. Any suggestions for that problem?
Suppose if I am using two classes in my code Say C1 and C2 then is there some procedure or special way to use them one after another.
Set a = new C1
Block of code
Set a = Nothing
Set b= new C2
Block of code
Set b = Nothing
The Class C2 doesn't work. Any idea Why?
I'm currently new to OO programming with Classic ASP and have been stopped dead in my tracks on the issue of validation inside classes and if I should be doing things that way. I have been using a User class and it has methods such as Save(), Update() and Delete(). Particularly with the Update() method I'm unsure if I should be validating my form(s) within the class or on the actual edit.asp page that uses the Update() method?
I have two types of edit pages; one for Admin users and one for the My Account page. On the My Account page if the user wants to change their password they have to enter their current password, a new password and then their new password again to confirm .
If an Admin user is updating that same user's info they do not have to go through those steps and they can simple just change the password by typing it in. The point here is that there are two separate cases of validation rules on two separate pages that both use the Update() method. Do you validate your forms inside your classes or outside?
I'm trying to pass an array of classes through a function using vbscript and then access these the other side. for instance (in psuedo code)
redim Array()
for 0 to array end fill with data (these happen to be classes)
but not sure that should make any difference?!)
someFunction(array())
function someFunction(data)
response.write data(0).property
end function
which doesn't work although data.property does if I specify which part of the array I'm passing i.e. someFunction(array(1))
I've written two classes in ASP (vbscript). Basically I am attempting a form of data encapsulation. The classes are a "master" class and an "address" class. The address class basically wraps a recordset. I've attached the file. whenever I call the "move" method the recordset should be EOF since there is only 1 record in my streetaddress table. If I write out the value of of p_oRs.eof inside of the "move" method it returns true.
I have declared p_oRs as a public variable. But if I access it from a different method (or a property get/let) then the p_oRs recordset is no longer EOF the pointer is on the first and only record.
Say I have a few functions for accessing a database e.g. openDBConn, closeDBConn, openRs, closeRs, getRsAsArray, executeSql, getDbConnString etc
I could put these functions in to an include file "incDbHelper.asp" and include the file in any page that needs database functionality... or I could create a class "clsDbhelper.asp" which again I would include in any page that needs it. Now once the files have been included, to access the functions I could do: Code:
I've read that one shouldn't include ADO objects in the Global.asa for the sake of performance, but would user-defined classes cause the same kind of performance hit? Assuming that they wouldn't, is it possible to do it?
I can't seem to figure out how to include them, nor find any reference to it in msdn.
Is there a way to do this? Or should I create a slew of Session variables? Code:
I can't seem to get error handling to work from inside my classes. On the outside it works but on the inside it doesn't. Any thoughts?
if err.number <> 0 then response.write "errors" end if
I'm trying to catch all the errors as I go and I can't do that if it won't work on the inside of my classes.
im building a page which has a few while loops. this means that im inevitably going to end up with about 20 recordsets on the page. will this slow the page down at all? its quite a lot of hits to the database/server. the results the recordsets will be returning wont be that big though.
View Replies View RelatedMy ASP code creates an ADO recordset object on the server.
Later on the same page, I have a javascript code snippet that I use to
dynamically populate a drop-down box based on choices made in another
drop-down box. Can this javascript (or a server-side equivalent)
Is there a way of using multiple recordsets with the same connection?
My recordset at the moment inserts data into the database, and i want to have a drop down box with data already within the database, as well as the insert recordset, is there a way of doing this?
Am having trouble opening multiple recordsets - keep getting the er:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/eft/postflight4.asp, line 146
Have checked the permissions and the user has full access.
Code:
How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn
I create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
Is there a performance advantage to parsing thru a recordset verus using an array?
I'm currently trying to populate a listbox by returning data from my database, then either parsing thru the recordset until I reach the EOF, or putting the data into an array.
I have never sorted a recordset - using rs.Sort - i have no problem sorting it in SQL.
All the tutorials i get say that i have to use a client cursor location, so this is my code:
Let's say you have pages 1 | 2 | 3 | 4 | 5 and you're on page 3. How do you make the code so that 3 will be without url?
View Replies View RelatedAssuming I had a recordset set up like this:
Set rs = Server.CreateObject("ADODB.Recordset")
is it enough to close out the code with
set rs=nothing
or is there a benefit to
rs.close
set rs=nothing ?
im building a site for a clinic. they want to have a calendar which displays the times for each day that are available for appointments.
at the moment i have a calendar on my page. i want to display the correct times for each day. should i use one big recordset that gets all the times/dates from the db or cycle through each day and create a recordset for each day that there are times available (some days the clinic wont be open)?
if i go with the latter option, i could potentially have 30 recordsets open. is there a fast way to execute recordsets.
I have an array of items and for each item I need to find sizes and and for each size I need to find colors The array of items comes from the previous page. Code:
View Replies View RelatedI have a table that is just dumping an entire database data. I would like to have the values of the columns re-sort the data. Not the column heads for the data displayed under the column head varies.
For example, one column, Components, displays 80 components types and another column, Category, displays 40 categories types. When a visitor clicks on one of the component values, it should then display only that data. I've done this before but, it has been a very long time. I remember creating a link surrounding the recordset in my table but what was written.
I have 2 recordsets. One contains all customer info data, the other recordset contains 1 field of customer id's.
How do I create a recordset that contains all customer information (from the 1st recordset)for only the customers in the customer id recordset (2nd recordset)?
I have two different query in my ASP page:
- the first is the list of all my users:
"SELECT DISTINCT lastname, id FROM table1"
- the second is the list of users that join a meeting:
"SELECT DISTINCT lastname, id FROM table1, table2 WHERE table2.codeMeeting = " & Request("code") & " AND table1.id = table2.id"
I want to show all the users in a table (with a FOR loop), with a checkbox that is checked if the users join the meeting (= if users is in the 2° recordset)
How can I do?