Webmaster Forum / ASP / Database Access / September 2003

I am in the process of re-writing an .ASP to replace some
recordset processing with a DOM object, and performing a
transformation to present the data.  My initial objective
was to clean up the code, and further separate the logic

The following code runs in less than one second when used in an ASP page but
when used in Session_onStart() in global.asa, the first page in a new
session is delayed by more than thirty seconds. The code seems to work - its
just slooow. Why is this so and how do I fix it?

   I have been asked to create an ezine which basically is a monthly
newsletter in the form of  html email. I was wondering if anybody can
provide me with any direction on this or point me to any resources that deal
with this subject.

I would like sort table. The table is createobject method (open a function
and use SAP connection) and the table not use recordset. is it possible sort
table for example or how can i sort table columns.
Thanks

Whats happend to the ASP groups over the last couple of days - seem to be
'spam'ed to all over the place - used to be reasonably immune
I assume all these "check this correction patch......." stuff must be from a
new virus, not seen one hitting newgroups before - since MS never ...

I am new to ASP.NET and IIS web applications, but not to
SQL databases. I can successfully build Windows apps using
Visual Studio that use ADO.  However, for Web Forms, I
created data connection and sqladapter to my SQL Server -

The following is the code, can someone please help me with the syntax please
in the first line please
Conn.Execute "UPDATE tblRentalProperty SET " _
& "tblPropertyType = '" & tblPropertyType & "', " _

I get this error:
Error Type:
Active Server Pages, ASP 0115 (0x80004005)
A trappable error (C0000005) occurred in an external object. The

whne I used this code to delete record from MS access DB thru Radio
Button I'm always got a balnk ID
===
<%

Hi,  I'm new to asp coding database, but have been working with Web Design
and MS Access for quite a few years.
I'm access a db and am useing the following code (1) and all is well.  When
I replace the sql string with the code at (2) I get an "error '80004005'

ISP has told me that I should be using OLEDB connections instead of ODBC to
get better ASP > ADO > Access DB performance.
After a visit to ConnectionStrings.com this OLEDB seemed straightforward
enough with a DB with no password and then I tried it with DB that has a

Is their a way i can group a bunch of records by their 'Type' And Order
these records within each group by their category. I am using Jet Sql
"Access".
This is what i have so far..

I just built an asp page taking values from sql server and need the currency
in ?. this worked for about a week and now my currency has changed to $ how
do I correct this. My system locale is set to ?
Thanks

The following ASP code yields the following error, but actually the new
record is stored
in database. The same error happens when the application deletes a record,
such as

Could anybody tell me please what the "1,2"   refers to in the last line of
this code and where I can get a list of the parts to this '.open' argument?
~~~
set conn=server.createobject("ADODB.Connection")