PC Review


Reply
Thread Tools Rate Thread

Data view with SQL server

 
 
=?Utf-8?B?d2lsbGVtIG5ldW1hbm4=?=
Guest
Posts: n/a
 
      31st Mar 2005
I need to do some different filters to vid different information in Share
point server.

I'm using the [current user] var but it return me the full user name .

I have another to use that return me the user id ?

Thanks
 
Reply With Quote
 
 
 
 
Kevin Spencer
Guest
Posts: n/a
 
      31st Mar 2005
User ID? What User ID?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"willem neumann" <(E-Mail Removed)> wrote in message
news:BFD5C854-7696-4041-A592-(E-Mail Removed)...
>I need to do some different filters to vid different information in Share
> point server.
>
> I'm using the [current user] var but it return me the full user name .
>
> I have another to use that return me the user id ?
>
> Thanks



 
Reply With Quote
 
=?Utf-8?B?SmltIEJ1eWVucw==?=
Guest
Posts: n/a
 
      31st Mar 2005
Sorry, but no. The actual id code behind the value of [current user] is a
GUID that wouldn't be helpful anyway.

To work around this, you can either:

o Modify the SQL query to provide a calculated that matches the
[current user] format, or

o Stop using [current user] and instead feed in your own value as an
[Input Parameter]. (For an example, see
http://support.microsoft.com/default...b;en-us;831093 ).

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


"willem neumann" wrote:

> I need to do some different filters to vid different information in Share
> point server.
>
> I'm using the [current user] var but it return me the full user name .
>
> I have another to use that return me the user id ?
>
> Thanks

 
Reply With Quote
 
=?Utf-8?B?d2lsbGVtIG5ldW1hbm4=?=
Guest
Posts: n/a
 
      31st Mar 2005
login name

"Kevin Spencer" wrote:

> User ID? What User ID?
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> What You Seek Is What You Get.
>
> "willem neumann" <(E-Mail Removed)> wrote in message
> news:BFD5C854-7696-4041-A592-(E-Mail Removed)...
> >I need to do some different filters to vid different information in Share
> > point server.
> >
> > I'm using the [current user] var but it return me the full user name .
> >
> > I have another to use that return me the user id ?
> >
> > Thanks

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Verify that looking at DATA of SQL SERVER VIEW will be read-only =?Utf-8?B?U3RldmUgWg==?= Microsoft Excel Discussion 1 1st Sep 2006 08:32 PM
Cannot view data in forms on server =?Utf-8?B?VG9ueQ==?= Microsoft Access Forms 2 19th Jul 2005 10:48 PM
Re: Binding Access Forms to a SQL Server Data source : View Or StoredP J. Clay Microsoft Access ADP SQL Server 4 14th Jul 2004 09:17 PM
Re: Binding Access Forms to a SQL Server Data source : View Or StoredP Vadim Rapp Microsoft Access ADP SQL Server 2 14th Jul 2004 02:08 AM
Strange date format when importing data from SQL server view lordslayer Microsoft Excel Misc 0 5th Feb 2004 10:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:39 AM.