Data view with SQL server

W

willem neumann

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
 
K

Kevin Spencer

User ID? What User ID?

--
HTH,

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

Jim Buyens

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.aspx?scid=kb;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)
|/---------------------------------------------------
*----------------------------------------------------
 
W

willem neumann

login name

Kevin Spencer said:
User ID? What User ID?

--
HTH,

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

willem neumann said:
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
Click to expand...
Click to expand...
 
Top