ASP: 'request'-object is unknown - ASP / Active Server Pages

spacecake

hi, I get an error that the request object is unknown, the owc
pivottable is normally clientside and request.querystring is something
from the serverside, maybe that't the problem... Can anybody help
me???

thx

<html>

<head>
<title>PivotTable Component</title>



</head>

<body>


<object classid="clsid:0002E520-0000-0000-C000-000000000046"
id="PivotTable1" width="450" height="300">
</object>
<script language=VBScript>

Dim sSQL
Dim sConn
Dim item
Dim c
Set c = PivotTable1.Constants
PivotTable1.AutoFit = True
PivotTable1.AllowDetails = False
PivotTable1.DisplayFieldList = false

' Specify the SELECT criteria
sSQL = "select * from alles"

'Specify the connection string
sConn = "Provider=SQLOLEDB; Data Source = bew2vachach01; Initial
Catalog = finrap; User Id = sa; Password= as"

' Bind the PivotTable to the results of the query
PivotTable1.ConnectionString = sConn
PivotTable1.CommandText = sSQL
' Show all result columns in the report
'PivotTable1.ActiveView.AutoLayout

' Format the numbers
set pview = PivotTable1.ActiveView

'rijen instellen
For teller=1 to request.form("aantal")
rij="rij" & teller
if request.form(rij) <> "" then
pview.RowAxis.InsertFieldSet pview.FieldSets(request.form(rij))
end if
next
</script>

</body>
</html>

Jul 19 '05 #1

Subscribe Reply

4261

Curt_C [MVP]

you realize that this:
<script language=VBScript>

Makes this all CLIENT-SIDE VBScript, not ASP

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"spacecake" <re***********@hotmail.com> wrote in message
news:38**************************@posting.google.c om...

hi, I get an error that the request object is unknown, the owc
pivottable is normally clientside and request.querystring is something
from the serverside, maybe that't the problem... Can anybody help
me???

thx

<html>

<head>
<title>PivotTable Component</title>



</head>

<body>


<object classid="clsid:0002E520-0000-0000-C000-000000000046"
id="PivotTable1" width="450" height="300">
</object>
<script language=VBScript>

Dim sSQL
Dim sConn
Dim item
Dim c
Set c = PivotTable1.Constants
PivotTable1.AutoFit = True
PivotTable1.AllowDetails = False
PivotTable1.DisplayFieldList = false

' Specify the SELECT criteria
sSQL = "select * from alles"

'Specify the connection string
sConn = "Provider=SQLOLEDB; Data Source = bew2vachach01; Initial
Catalog = finrap; User Id = sa; Password= as"

' Bind the PivotTable to the results of the query
PivotTable1.ConnectionString = sConn
PivotTable1.CommandText = sSQL
' Show all result columns in the report
'PivotTable1.ActiveView.AutoLayout

' Format the numbers
set pview = PivotTable1.ActiveView

'rijen instellen
For teller=1 to request.form("aantal")
rij="rij" & teller
if request.form(rij) <> "" then
pview.RowAxis.InsertFieldSet pview.FieldSets(request.form(rij))
end if
next
</script>

</body>
</html>

Jul 19 '05 #2

Ray at

If you do a view-source, you'll see that your code shows up in there,
because the code you have is not specified as being server-side code, either
with <% %> or <script RUNAT=SERVER...></script>

Ray at work

"spacecake" <re***********@hotmail.com> wrote in message
news:38**************************@posting.google.c om...

hi, I get an error that the request object is unknown, the owc
pivottable is normally clientside and request.querystring is something
from the serverside, maybe that't the problem... Can anybody help
me???

thx

<html>

<head>
<title>PivotTable Component</title>



</head>

<body>


<object classid="clsid:0002E520-0000-0000-C000-000000000046"
id="PivotTable1" width="450" height="300">
</object>
<script language=VBScript>

Dim sSQL
Dim sConn
Dim item
Dim c
Set c = PivotTable1.Constants
PivotTable1.AutoFit = True
PivotTable1.AllowDetails = False
PivotTable1.DisplayFieldList = false

' Specify the SELECT criteria
sSQL = "select * from alles"

'Specify the connection string
sConn = "Provider=SQLOLEDB; Data Source = bew2vachach01; Initial
Catalog = finrap; User Id = sa; Password= as"

' Bind the PivotTable to the results of the query
PivotTable1.ConnectionString = sConn
PivotTable1.CommandText = sSQL
' Show all result columns in the report
'PivotTable1.ActiveView.AutoLayout

' Format the numbers
set pview = PivotTable1.ActiveView

'rijen instellen
For teller=1 to request.form("aantal")
rij="rij" & teller
if request.form(rij) <> "" then
pview.RowAxis.InsertFieldSet pview.FieldSets(request.form(rij))
end if
next
</script>

</body>
</html>

Jul 19 '05 #3

spacecake

I changed my code this way:

For teller=1 to request.form("aantal")
rij="rij" & teller
if <% request.form(rij) %> <> "" then
pview.RowAxis.InsertFieldSet pview.FieldSets(<% request.form(rij) %>)
end if
next

when I run the program I get this error:

Error Type:
Request object, ASP 0102 (0x80004005)
The function expects a string as input.

POST Data:
rij1=manager&aantal=5

Jul 19 '05 #4

Evertjan.

spacecake wrote on 05 mrt 2004 in
microsoft.public.inetserver.asp.general:

I changed my code this way:

For teller=1 to request.form("aantal")
rij="rij" & teller
if <% request.form(rij) %> <> "" then
pview.RowAxis.InsertFieldSet pview.FieldSets(<%
request.form(rij) %>)
end if
next

when I run the program I get this error:

Error Type:
Request object, ASP 0102 (0x80004005)
The function expects a string as input.

POST Data:
rij1=manager&aantal=5

Faulty code

request.form("aantal") shows you are in serverside ASP,
then you start ASP by <% request.form(rij) %>

Mixing serverside and clientside code will never work.

Probeer je code netjes te scheiden.

===============================================

btw:

Even if you were in a clientside HTML part of your code,
<% request.form(rij) %> would not give any output,
should be <% = request.form(rij) %>

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Jul 19 '05 #5

Similar topics

6288

Finish execution of ASP script when client disconnects

by: Boris Nikolaevich | last post by:

This is backwards of what I usually want--normally if you have a long-running ASP script, it's a good idea to check to see whether the client is still connected so you can cancel execution. ...

ASP / Active Server Pages

2395

ASP Help Please!

by: No Spam Please | last post by:

I have a script. Its a login form that has the user enter their First Name, Last Name and ID #. That data along with the currdate and currtime is placed in an access database and the framed page...

ASP / Active Server Pages

5452

ASP Login Script not working

by: Wayne Smith | last post by:

Applies to: Microsoft FrontPage 2000, Microsoft Access 2000, IIS 5.0 Operating System: Microsoft Windows 2000 Professional I am trying to protect a portion of a web site by allowing users to...

ASP / Active Server Pages

4984

ASP sessionstate

by: Roland Hall | last post by:

I eliminated cookies from my shopping cart this morning. I'm now using sessions to keep track of users. In my global.asa I have the following: sub Session_onStart session.Timeout = 20...

ASP / Active Server Pages

2643

*Impossible* to build an upload progress meter using ASP.NET. Can you prove me wrong?

by: Brian Birtle | last post by:

**** A CHALLENGE TO THE GURUS - refute the statement "It's impossible to build a file upload progress meter using ASP.NET" **** First person to prove me wrong gets "All Time .NET Programming GOD"...

ASP.NET

2027

ASP.Net cookie -> ASP -> ASP.Net

by: Ben | last post by:

I'm having problems with cookies from asp.net to asp back to asp.net. It seems like I can set a cookie in asp.net fine, and alter it at will, as soon as asp touches it, asp.net won't have...

ASP.NET

12270

Opening ASP page causes file download dialog instead

by: Neil Rossi | last post by:

I have an issue with a particular ASP page on two web servers. Let's call these servers Dev1 and Beta1. Both Servers are running IIS 5, Windows 2000 SP4 with "almost" all of the latest patches. ...

ASP / Active Server Pages

6207

Asp Validation for login and registration (High importance and priority) respond fast

by: satishknight | last post by:

Hi, Can some one tell me how to change the validation sequence for the code pasted below, actually what I want it when any one enters the wrong login information (already registered users) then it...

ASP / Active Server Pages

3409

asp vbscript textbox paste from word problem

by: =?Utf-8?B?R1ROMTcwNzc3?= | last post by:

Hi Guys, It's been a while, I've got a small problem that I could do with your expertise on. As you know (I Think) I build websites for recruitment agencies, part of the website includes a job...

ASP / Active Server Pages

3675

Trying to get ASP form to show up in Access Database

by: jerrydigital | last post by:

Hello, I am new to this forum but have read several posts and I thank you for your great assistance. I am stumped right now. I have a user registration form in asp that is set to a form...

ASP / Active Server Pages

7123

Changing the language in Windows 10

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...

Windows Server

7326

Problem With Comparison Operator <=> in G++

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,...

C / C++

7046

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

7498

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5627

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5053

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

4707

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3182

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

418

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General