473,233 Members | 1,389 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 software developers and data experts.

Createobject of '(null)' caused exception C0000005

Hi,

I'm getting this error on my asp page intermittently. One day it is fine,
another day, it crashes a lot. I have searched the web and microsoft on
this and they say it is a recordset assigned to a session variable.

I dont assign any record sets to session variables in my code. I assign
values to the session variables though.
The place it seems to crash is Set AccessConn =
Server.CreateObject("ADODB.Connection")

code:

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.mapPath("EmployeeTransactions.mdb")
Set AccessConn = Server.CreateObject("ADODB.Connection")
AccessConn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploctype")
loccode = session("splocationdesc")

'Determining the ability to access update records
if lloc = "School" then
accessupdate = 0
else
accessupdate = 1
end if

Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select emprecid, employeeno, employeelastname, employeefirstname,
iif(isnull(hrstatus),'&nbsp',hrstatus) as hrstatus,
iif(isnull(hrdate),'&nbsp',hrdate) as hrdate,
iif(isnull(budgetstatus),'&nbsp',budgetstatus) as budgetstatus,
iif(isnull(budgetdate),'&nbsp',budgetdate) as budgetdate," & _
" iif(isnull(payrollstatus),'&nbsp',payrollstatus) as payrollstatus,
iif(isnull(payrolldate),'&nbsp',payrolldate) as payrolldate,
iif(isnull(benefitdate),'&nbsp',benefitdate) as benefitdate,
iif(isnull(createdby),'&nbsp',createdby) as createdby,
iif(isnull(processstatus),'&nbsp',processstatus) as processstatus,
employeetype, location from employeetransaction "

'we only display the records for the school location otherwise, we display
all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid desc
"
end if
set rs = AccessConn.execute(sql)

Any ideas??
thanks,
Will
Jul 19 '05 #1
14 11051
Several suggestions.

(a) don't use Server.CreateObject, just CreateObject

(b) what is set rs = Server.CreateObject("ADODB.Recordset") for? You
override it later with set rs = AccessConn.execute(sql) ... I also changed
"AccessConn" to a more standard "Conn"...

(c) don't do presentation things (replace null with "&nbsp;") in the query.
Do that where it belongs, in the presentation tier! Wherever you have a
value coming back from the resultset that needs to be at least "&nbsp;", use
the function I wrote below called sb (showblanks). Or, just response.write
rs("column") & "&nbsp;" ... it makes your query much easier to read, doesn't
it?

(d) make sure you close and destroy both the recordset object and the
connection object after you're done.
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.mapPath("EmployeeTransactions.mdb")
Set Conn = CreateObject("ADODB.Connection")
Conn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploctype")
loccode = session("splocationdesc")

'Determining the ability to access update records
accessupdate = 1
if lloc = "School" then accessupdate = 0

sql = "SELECT emprecid, employeeno, employeelastname, employeefirstname,
hrstatus, hrdate, budgetstatus, budgetdate, payrollstatus, payrolldate,
benefitdate, createdby, processstatus, employeetype, location FROM
employeetransaction "

' we only display the records for the school location
' otherwise, we display all for departments

if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid desc
"
end if

set rs = Conn.execute(sql)

....
response.write sb(rs("hrstatus"))

function sb(s)
sb = s : if len(trim(sb)) = 0 then sb = "&nbsp;"
end function

rs.close: set rs = nothing
conn.close: set conn = nothing
--
http://www.aspfaq.com/
(Reverse address to reply.)


"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:ed**************@TK2MSFTNGP09.phx.gbl...
Hi,

I'm getting this error on my asp page intermittently. One day it is fine,
another day, it crashes a lot. I have searched the web and microsoft on
this and they say it is a recordset assigned to a session variable.

I dont assign any record sets to session variables in my code. I assign
values to the session variables though.
The place it seems to crash is Set AccessConn =
Server.CreateObject("ADODB.Connection")

code:

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.mapPath("EmployeeTransactions.mdb")
Set AccessConn = Server.CreateObject("ADODB.Connection")
AccessConn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploctype")
loccode = session("splocationdesc")

'Determining the ability to access update records
if lloc = "School" then
accessupdate = 0
else
accessupdate = 1
end if

Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select emprecid, employeeno, employeelastname, employeefirstname,
iif(isnull(hrstatus),'&nbsp',hrstatus) as hrstatus,
iif(isnull(hrdate),'&nbsp',hrdate) as hrdate,
iif(isnull(budgetstatus),'&nbsp',budgetstatus) as budgetstatus,
iif(isnull(budgetdate),'&nbsp',budgetdate) as budgetdate," & _
" iif(isnull(payrollstatus),'&nbsp',payrollstatus) as payrollstatus,
iif(isnull(payrolldate),'&nbsp',payrolldate) as payrolldate,
iif(isnull(benefitdate),'&nbsp',benefitdate) as benefitdate,
iif(isnull(createdby),'&nbsp',createdby) as createdby,
iif(isnull(processstatus),'&nbsp',processstatus) as processstatus,
employeetype, location from employeetransaction "

'we only display the records for the school location otherwise, we display
all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30)) OR (Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid desc "
end if
set rs = AccessConn.execute(sql)

Any ideas??
thanks,
Will

Jul 19 '05 #2
Aaron [SQL Server MVP] wrote:
Several suggestions.

(a) don't use Server.CreateObject, just CreateObject

(b) what is set rs = Server.CreateObject("ADODB.Recordset") for? You
override it later with set rs = AccessConn.execute(sql) ... I also
changed "AccessConn" to a more standard "Conn"...

(c) don't do presentation things (replace null with "&nbsp;") in the
query. Do that where it belongs, in the presentation tier!


I do this in my query when I want to use GetString.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #3
How many people are hitting the site? Any time there are "intermittent"
errors that are Access database related, I'd say that they are often related
to concurrency issues and Access not being able/meant to handle lots of
connections.

As far as the code you included below, I'd drop the Set rs =
Server.CreateObject("ADODB.Recordset") line. What you're doing is creating
an empty recordset there, and then on the Set rs = AccessConn.Execute(sql)
line, you're destroying the recordset and creating a new one. So, it's a
microsecond of extra processing time there.

Also, instead of doing all that IsNull stuff in your query, I suggest
dropping all of that. What you can do instead is:

....
sql = "select emprecid, employeeno, employeelastname,
employeefirstname,hrstatus,
hrdate,budgetstatus,budgetdate,payrollstatus,payro lldate,benefitdate,createdby,,processstatus,
employeetype, location from employeetransaction "
....

And then, after you get your recordset back, use .GetRows to dump the
recordset into an array. (Then quickly close and destroy your recordset and
ado connection!) With the GetRows method, you can convert all the nulls to
&nbsp; as such:

Set rs = AccessConn.Execute(sSQL)
If Not rs.EOF Then aData = rs.GetRows(2,,,"&nbsp;")
If you aren't sure what to do with the aData array then or haven't used
GetRows before and would like to know more about it, just post back here.

Ray at work
"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:ed**************@TK2MSFTNGP09.phx.gbl...


Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select emprecid, employeeno, employeelastname, employeefirstname,
iif(isnull(hrstatus),'&nbsp',hrstatus) as hrstatus,
iif(isnull(hrdate),'&nbsp',hrdate) as hrdate,
iif(isnull(budgetstatus),'&nbsp',budgetstatus) as budgetstatus,
iif(isnull(budgetdate),'&nbsp',budgetdate) as budgetdate," & _
" iif(isnull(payrollstatus),'&nbsp',payrollstatus) as payrollstatus,
iif(isnull(payrolldate),'&nbsp',payrolldate) as payrolldate,
iif(isnull(benefitdate),'&nbsp',benefitdate) as benefitdate,
iif(isnull(createdby),'&nbsp',createdby) as createdby,
iif(isnull(processstatus),'&nbsp',processstatus) as processstatus,
employeetype, location from employeetransaction "

'we only display the records for the school location otherwise, we display
all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30))
OR
(Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid
desc
"
end if
set rs = AccessConn.execute(sql)


Jul 19 '05 #4
thanks for the great suggestions. I'll try them and see what happens.

Will
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:OE**************@TK2MSFTNGP11.phx.gbl...
Several suggestions.

(a) don't use Server.CreateObject, just CreateObject

(b) what is set rs = Server.CreateObject("ADODB.Recordset") for? You
override it later with set rs = AccessConn.execute(sql) ... I also changed
"AccessConn" to a more standard "Conn"...

(c) don't do presentation things (replace null with "&nbsp;") in the query. Do that where it belongs, in the presentation tier! Wherever you have a
value coming back from the resultset that needs to be at least "&nbsp;", use the function I wrote below called sb (showblanks). Or, just response.write rs("column") & "&nbsp;" ... it makes your query much easier to read, doesn't it?

(d) make sure you close and destroy both the recordset object and the
connection object after you're done.
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.mapPath("EmployeeTransactions.mdb")
Set Conn = CreateObject("ADODB.Connection")
Conn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploctype")
loccode = session("splocationdesc")

'Determining the ability to access update records
accessupdate = 1
if lloc = "School" then accessupdate = 0

sql = "SELECT emprecid, employeeno, employeelastname, employeefirstname,
hrstatus, hrdate, budgetstatus, budgetdate, payrollstatus, payrolldate,
benefitdate, createdby, processstatus, employeetype, location FROM
employeetransaction "

' we only display the records for the school location
' otherwise, we display all for departments

if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30)) OR (Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid desc "
end if

set rs = Conn.execute(sql)

...
response.write sb(rs("hrstatus"))

function sb(s)
sb = s : if len(trim(sb)) = 0 then sb = "&nbsp;"
end function

rs.close: set rs = nothing
conn.close: set conn = nothing
--
http://www.aspfaq.com/
(Reverse address to reply.)


"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:ed**************@TK2MSFTNGP09.phx.gbl...
Hi,

I'm getting this error on my asp page intermittently. One day it is fine, another day, it crashes a lot. I have searched the web and microsoft on
this and they say it is a recordset assigned to a session variable.

I dont assign any record sets to session variables in my code. I assign
values to the session variables though.
The place it seems to crash is Set AccessConn =
Server.CreateObject("ADODB.Connection")

code:

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.mapPath("EmployeeTransactions.mdb")
Set AccessConn = Server.CreateObject("ADODB.Connection")
AccessConn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploctype")
loccode = session("splocationdesc")

'Determining the ability to access update records
if lloc = "School" then
accessupdate = 0
else
accessupdate = 1
end if

Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select emprecid, employeeno, employeelastname, employeefirstname,
iif(isnull(hrstatus),'&nbsp',hrstatus) as hrstatus,
iif(isnull(hrdate),'&nbsp',hrdate) as hrdate,
iif(isnull(budgetstatus),'&nbsp',budgetstatus) as budgetstatus,
iif(isnull(budgetdate),'&nbsp',budgetdate) as budgetdate," & _
" iif(isnull(payrollstatus),'&nbsp',payrollstatus) as payrollstatus,
iif(isnull(payrolldate),'&nbsp',payrolldate) as payrolldate,
iif(isnull(benefitdate),'&nbsp',benefitdate) as benefitdate,
iif(isnull(createdby),'&nbsp',createdby) as createdby,
iif(isnull(processstatus),'&nbsp',processstatus) as processstatus,
employeetype, location from employeetransaction "

'we only display the records for the school location otherwise, we display all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >=
(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid

desc
"
end if
set rs = AccessConn.execute(sql)

Any ideas??
thanks,
Will


Jul 19 '05 #5
> I do this in my query when I want to use GetString.

Why? GetString() supports NullExpr (which allow you to specify "&nbsp;" or
something else for any value that is Null).
http://msdn.microsoft.com/library/en...ordset)ado.asp

--
http://www.aspfaq.com/
(Reverse address to reply.)
Jul 19 '05 #6
Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access
database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:eo**************@TK2MSFTNGP15.phx.gbl...
How many people are hitting the site? Any time there are "intermittent"
errors that are Access database related, I'd say that they are often related to concurrency issues and Access not being able/meant to handle lots of
connections.

As far as the code you included below, I'd drop the Set rs =
Server.CreateObject("ADODB.Recordset") line. What you're doing is creating an empty recordset there, and then on the Set rs = AccessConn.Execute(sql)
line, you're destroying the recordset and creating a new one. So, it's a
microsecond of extra processing time there.

Also, instead of doing all that IsNull stuff in your query, I suggest
dropping all of that. What you can do instead is:

...
sql = "select emprecid, employeeno, employeelastname,
employeefirstname,hrstatus,
hrdate,budgetstatus,budgetdate,payrollstatus,payro lldate,benefitdate,created
by,,processstatus, employeetype, location from employeetransaction "
...

And then, after you get your recordset back, use .GetRows to dump the
recordset into an array. (Then quickly close and destroy your recordset and ado connection!) With the GetRows method, you can convert all the nulls to &nbsp; as such:

Set rs = AccessConn.Execute(sSQL)
If Not rs.EOF Then aData = rs.GetRows(2,,,"&nbsp;")
If you aren't sure what to do with the aData array then or haven't used
GetRows before and would like to know more about it, just post back here.

Ray at work
"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:ed**************@TK2MSFTNGP09.phx.gbl...


Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select emprecid, employeeno, employeelastname, employeefirstname,
iif(isnull(hrstatus),'&nbsp',hrstatus) as hrstatus,
iif(isnull(hrdate),'&nbsp',hrdate) as hrdate,
iif(isnull(budgetstatus),'&nbsp',budgetstatus) as budgetstatus,
iif(isnull(budgetdate),'&nbsp',budgetdate) as budgetdate," & _
" iif(isnull(payrollstatus),'&nbsp',payrollstatus) as payrollstatus,
iif(isnull(payrolldate),'&nbsp',payrolldate) as payrolldate,
iif(isnull(benefitdate),'&nbsp',benefitdate) as benefitdate,
iif(isnull(createdby),'&nbsp',createdby) as createdby,
iif(isnull(processstatus),'&nbsp',processstatus) as processstatus,
employeetype, location from employeetransaction "

'we only display the records for the school location otherwise, we display all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30))
OR
(Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid
desc
"
end if
set rs = AccessConn.execute(sql)

Jul 19 '05 #7
http://www.aspfaq.com/2467

--
http://www.aspfaq.com/
(Reverse address to reply.)


"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:#E**************@TK2MSFTNGP14.phx.gbl...
Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access
database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:eo**************@TK2MSFTNGP15.phx.gbl...
How many people are hitting the site? Any time there are "intermittent"
errors that are Access database related, I'd say that they are often related
to concurrency issues and Access not being able/meant to handle lots of
connections.

As far as the code you included below, I'd drop the Set rs =
Server.CreateObject("ADODB.Recordset") line. What you're doing is

creating
an empty recordset there, and then on the Set rs = AccessConn.Execute(sql)
line, you're destroying the recordset and creating a new one. So, it's a microsecond of extra processing time there.

Also, instead of doing all that IsNull stuff in your query, I suggest
dropping all of that. What you can do instead is:

...
sql = "select emprecid, employeeno, employeelastname,
employeefirstname,hrstatus,

hrdate,budgetstatus,budgetdate,payrollstatus,payro lldate,benefitdate,created by,,processstatus,
employeetype, location from employeetransaction "
...

And then, after you get your recordset back, use .GetRows to dump the
recordset into an array. (Then quickly close and destroy your recordset

and
ado connection!) With the GetRows method, you can convert all the nulls

to
&nbsp; as such:

Set rs = AccessConn.Execute(sSQL)
If Not rs.EOF Then aData = rs.GetRows(2,,,"&nbsp;")
If you aren't sure what to do with the aData array then or haven't used
GetRows before and would like to know more about it, just post back here.
Ray at work
"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:ed**************@TK2MSFTNGP09.phx.gbl...


Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select emprecid, employeeno, employeelastname, employeefirstname, iif(isnull(hrstatus),'&nbsp',hrstatus) as hrstatus,
iif(isnull(hrdate),'&nbsp',hrdate) as hrdate,
iif(isnull(budgetstatus),'&nbsp',budgetstatus) as budgetstatus,
iif(isnull(budgetdate),'&nbsp',budgetdate) as budgetdate," & _
" iif(isnull(payrollstatus),'&nbsp',payrollstatus) as payrollstatus,
iif(isnull(payrolldate),'&nbsp',payrolldate) as payrolldate,
iif(isnull(benefitdate),'&nbsp',benefitdate) as benefitdate,
iif(isnull(createdby),'&nbsp',createdby) as createdby,
iif(isnull(processstatus),'&nbsp',processstatus) as processstatus,
employeetype, location from employeetransaction "

'we only display the records for the school location otherwise, we

display all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTransaction.PayrollDate >=(date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<> FALSE)) order by emprecid desc "
else
sql = sql & " where ((EmployeeTransaction.PayrollDate >= (date()-30)) OR
(Isnull([EmployeeTransaction].[PayrollDate])<>FALSE)) order by emprecid desc
"
end if
set rs = AccessConn.execute(sql)


Jul 19 '05 #8
Aaron [SQL Server MVP] wrote:
I do this in my query when I want to use GetString.


Why? GetString() supports NullExpr (which allow you to specify
"&nbsp;" or
something else for any value that is Null).

http://msdn.microsoft.com/library/en...ordset)ado.asp

It's not to replace Nulls.

In one instance, I do it pad hard spaces between pieces of data to simulate
columns in a SELECT. (so it will display say company number and company name
in columns in the SELECT) - I also concatenate all the OPTION tags in the
query as well (gasp!)

There's nothing like a simple

Response.Write rs.GetString

to reduce the amount of code on a page. This also cuts down on the number of
include files. This dropdown box is used in quite a few pages in which I
would have to #include the asp page to create the same option list that is
coming from my stored procedure. I see no point to doing this merely to
satisfy a theoretical "presentation layer-data layer" division. Using such a
division is supposed to improve my codes maintainability, not reduce it.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #9
GetRows returns a two-dimensional array, where the first dimension
represents the columns in the recordset, and the second dimension represents
the rows, so to speak. So, if you had a query like:

"select firstname,lastname from people"

And you dumped that to an array with .GetRows, you'd iterate through it as
such:

<%

For i = 0 To UBound(aData, 2) '<-- the UBound of the second dimension
'''since the rows are in the second dimension
'''you want to loop through the number of times
'''as there are "records" in it.
Response.Write "Firstname = " & aData(0,i) & "<br>"
Response.Write "Lastname = " & aData(1,i) & "<hr>"
Next
%>
So, if you're used to working with arrays, it's just like having an array
like:

Dim someArray(1,5)
someArray(0,0) = "Bob" : someArray(1,0) = "Smith"
someArray(0,1) = "Ted" : someArray(1,1) = "Jones"
someArray(0,2) = "Jen" : someArray(1,2) = "Giles"
someArray(0,3) = "Kim" : someArray(1,3) = "Baron"
someArray(0,4) = "Ned" : someArray(1,4) = "Heinz"
someArray(0,5) = "Gus" : someArray(1,5) = "Baker"
Ray at work

"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access
database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will

Jul 19 '05 #10
> coming from my stored procedure. I see no point to doing this merely to
satisfy a theoretical "presentation layer-data layer" division.


I think a lot of people on the database side would disagree with you. Some
of them vehemently and maybe even violently. ;-)

--
http://www.aspfaq.com/
(Reverse address to reply.)
Jul 19 '05 #11
thanks Ray. I'll give it a try.

Will
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:e4**************@TK2MSFTNGP10.phx.gbl...
GetRows returns a two-dimensional array, where the first dimension
represents the columns in the recordset, and the second dimension represents the rows, so to speak. So, if you had a query like:

"select firstname,lastname from people"

And you dumped that to an array with .GetRows, you'd iterate through it as
such:

<%

For i = 0 To UBound(aData, 2) '<-- the UBound of the second dimension
'''since the rows are in the second dimension
'''you want to loop through the number of times
'''as there are "records" in it.
Response.Write "Firstname = " & aData(0,i) & "<br>"
Response.Write "Lastname = " & aData(1,i) & "<hr>"
Next
%>
So, if you're used to working with arrays, it's just like having an array
like:

Dim someArray(1,5)
someArray(0,0) = "Bob" : someArray(1,0) = "Smith"
someArray(0,1) = "Ted" : someArray(1,1) = "Jones"
someArray(0,2) = "Jen" : someArray(1,2) = "Giles"
someArray(0,3) = "Kim" : someArray(1,3) = "Baron"
someArray(0,4) = "Ned" : someArray(1,4) = "Heinz"
someArray(0,5) = "Gus" : someArray(1,5) = "Baker"
Ray at work

"wk6pack" <wk***@sd61.bc.ca> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will


Jul 19 '05 #12
Aaron [SQL Server MVP] wrote:
coming from my stored procedure. I see no point to doing this merely
to satisfy a theoretical "presentation layer-data layer" division.


I think a lot of people on the database side would disagree with you.
Some of them vehemently and maybe even violently. ;-)


Probably. But why give us the string functions and then tell us not to use
them? :-)

This is not to say that I'm a total rebel on this point. There are things
that I prefer to handle in the "presentation" tier that could be handled
with more or less effort or performance impact in the database tier. I just
don't follow this philosophy blindly. If I did, I would use much fewer
stored procedures and triggers (business logic should be in the business
layer, right?)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #13
> don't follow this philosophy blindly. If I did, I would use much fewer
stored procedures and triggers (business logic should be in the business
layer, right?)


In reality (at least at my workplace and in all my contract situations), the
"business layer" is either disappearing, or never existed. There is no more
COM and interop and all that crap. Why should I build COM or .NET
components that need to be compiled and are a pain in the ass to (re-)deploy
when (not if) specs change? Why use three tiers when I only need two?

Plus, let's face it, some of your data validation you want to do on the
client side, and some of it you have to do in the database.

--
http://www.aspfaq.com/
(Reverse address to reply.)
Jul 19 '05 #14
Aaron [SQL Server MVP] wrote:
don't follow this philosophy blindly. If I did, I would use much
fewer stored procedures and triggers (business logic should be in
the business layer, right?)


In reality (at least at my workplace and in all my contract
situations), the "business layer" is either disappearing, or never
existed. There is no more COM and interop and all that crap. Why
should I build COM or .NET components that need to be compiled and
are a pain in the ass to (re-)deploy when (not if) specs change? Why
use three tiers when I only need two?

Plus, let's face it, some of your data validation you want to do on
the client side, and some of it you have to do in the database.


Yes, my point exactly
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Som | last post by:
A clients website is a combination of ASP pages and COM/COM+ objects - The following errors are being reported. Once this happens on the server the entire script engine fails... we have to...
2
by: Dean J. Garrett | last post by:
Hello, The periodic error below keeps coming up and causing our server to crash. Once it happens, the only way to recover is to issue an IISRESET or reboot. We've updating the scripting engine,...
10
by: gregory_may | last post by:
I have an application I created called "JpegViewer.exe". It simply loads a Jpeg file and displays in on the screen. It works great, in my lab. When I am using it at a customer site, things...
3
by: David Lozzi | last post by:
Hello, I'm receving the following on my webserver (Windows 2003 Server SP1) Event ID: 5 Source: Active Server Pages Error: File /KQShopping/ordercomplete4.asp Script Engine Exception. A...
1
by: Vasuki | last post by:
Hi My application crashes all of a sudden giving me the following error. Can anybody help please? Exception code: C0000005 ACCESS_VIOLATION Fault address: 77FCE005 03:00002005...
7
by: news | last post by:
..Net 2.0 Hi, I'm getting a nullreferenceexception when calling a function from a worker thread: private void CallbackProc(string response, Exception ex) { if (this.InvokeRequired) {...
1
by: Lynn Zou | last post by:
In our system , we use an ASP page to upload files but sometimes it doesnot work as it suppose to do and we found error log in Application Error as: Event Type: Error Event Source: Active...
0
by: amitpatil | last post by:
I am having trouble with following error. there are few registration page when i register 2 members it works but when i try to create 3rd one i get following error and then for 10 mins or so website...
2
by: pedrito | last post by:
I've got an app that downloads from several concurrent threads. Occasionally, I get an expcetion trying to read the HttpWebResponse stream... Sorry, the code isn't short, but I figured best to...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.