how to pass form results

[debbieg]

Hi,
I am in the process of constructing a web page containing an Offic
PivotTable Component in FP.
The data is held in Access and depending on who logs in, only the dat
which the person is allowed to view will be displayed on the pivo
table.
What I'm having trouble with is how I can pass the userID (UID) fro
the form where authentication takes place, to the query in Access.
thought that I should be typing the following in the Command text i
the Pivot table property toolbox:

select * from table where UID = ::UID::

but that doesn't work.

Does anyone have any ideas?
Please help me.

Thank you,
Debbi

 

[Stefan B Rusynko]

Server side processing (ASP) does not support Access Pivot table views or data pages from Access
You need to either use the limited functionality of the FP DBRW or learn to hand code your ASP to display your Access tables as
desired

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|
| Hi,
| I am in the process of constructing a web page containing an Office
| PivotTable Component in FP.
| The data is held in Access and depending on who logs in, only the data
| which the person is allowed to view will be displayed on the pivot
| table.
| What I'm having trouble with is how I can pass the userID (UID) from
| the form where authentication takes place, to the query in Access. I
| thought that I should be typing the following in the Command text in
| the Pivot table property toolbox:
|
| select * from table where UID = ::UID::
|
| but that doesn't work.
|
| Does anyone have any ideas?
| Please help me.
|
| Thank you,
| Debbie
|
|
| --
| debbieg
| ------------------------------------------------------------------------
| debbieg's Profile: http://www.hightechtalks.com/m767
| View this thread: http://www.hightechtalks.com/t2336634
|