Webmaster Forum / ASP / Database Access / October 2006

This post is a modifed version of one I made to the interop section (on
09.29.2006) but no one replied... since the question is partially about ASP
this group may be appropriate. Any help you could offer would be much
appreciated!!

Hi, is there an easy method for outputting data into html data? something
along the lines of going through each recordset value name and then
outputting the recordset values?
it's late and i'm tired

i have a question. I am using Access 2000, ADO and ASP
select document_no, document_date, ledger_ac, debit, credit from
accounts
returns:

I am attempting to learn ASP and toying around with reading my products
Jet database to have something to play with.  I seem to have ASP enabled
on my server, very simple ASP pages work, but the examples with accessing
a database just give a 500 internal server error.  I'm using IIS ...

Can you submit multiple commands in one SQL query in ASP? Something
like this:
"SELECT * FROM users; INSERT INTO users ('user','pass') VALUES
('test','test');"

Six years ago I wrote ASP code by hand in an HTML/ASP editor.  It was a great
learning experience.  Have developed Access Applications the last 5 years and
now am ready to get back to ASP - to - Access web coding.  Small to Mid size
sites, no ecommerce, just data and filesharing.  ...

i have an asp page with a form that takes an email address and writes it to
an access DB. if i enter someone@somewhere.com and on a different page
SELECT email addresses that equal SOMEONE@SOMEWHERE.COM, my results are
returned. i was expecting this query to not return anything ...

I have a table with three columns, ID, Field, and Data.  There are
about 1000 rows with a given ID (and given an ID each row has a unique
Field value).  At some point in a script, I need to update the Data
column of a subset of these rows (somewhere between 1 and maybe 30 of

Is it possible to keep code inside a database row, for example, a
response.write or something
The idea is to keep a recordset opening command inside the db so when i use
that db the code is processed.

I have a problem with AzMan under Windows XP.
On my web site I use AzMan/AD role management. Store installed on Win
2003 SP1 server, but site works under WinXP SP2.
For IIS identity domain account with non-admin?s privileges is used.

I'm having an issue running a stored procedure in a vbscript using ADO
... I keep getting "operation is not allowed when the object is closed"
on my first line of testing my connection.
The sproc I'm trying to run can be found here:

Hello everyone. I apologize for this newbie question but after searching the
'net I am at a loss. I also posted this request to
microsoft.public.frontpage.programming and hope this is okay.
I have a database with two tables. The first, table 1, is for the user

I'm tryting to update 2 date fields in an access database.
Thecode I'm using is:
strSQL = "UPDATE TblAbsence SET [StartDate] = #" & strStartDate &  "# ,
[EndDate] = #" & strEndDate & "# WHERE (id = " & iRecordId & ");"

I am trying to connect to a MS Access dB on a network share using the
following syntax but it doesn't work:
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\Calsj1\PMAPPS\pmdata.mdb"

Hi,
Here is my code and I keep getting error -
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'EOF'