Database Results Wizard and User Login

[bearguy904]

I have a page that I would like to have the User's Login automatically
default in the DRW. I have captured the User Name in the following code,

<%
Dim aName
Dim strName

' create an array by splitting variable by the \
aName = Split(Request.ServerVariables("LOGON_USER"), "\")

' populate variable
strName = aName(UBound(aName))
%>

But what I would like to do is somehow pull strName into the FP_sDefault
column. I tried user_name=<%=strName%> and several other variables to no
avail. Is there another way to do this, I can put the variable in a form
field, but I would really like for this information to populate as the page
loads. Any help would be greatly appreciated.

Thanks

Earl Kelly

 

[Stefan B Rusynko]

See the DBRW tweaks at
http://spiderwebwoman.com/thingumajig/tweaks.htm#scriptmods

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have a page that I would like to have the User's Login automatically
| default in the DRW. I have captured the User Name in the following code,
|
| <%
| Dim aName
| Dim strName
|
| ' create an array by splitting variable by the \
| aName = Split(Request.ServerVariables("LOGON_USER"), "\")
|
| ' populate variable
| strName = aName(UBound(aName))
| %>
|
| But what I would like to do is somehow pull strName into the FP_sDefault
| column. I tried user_name=<%=strName%> and several other variables to no
| avail. Is there another way to do this, I can put the variable in a form
| field, but I would really like for this information to populate as the page
| loads. Any help would be greatly appreciated.
|
| Thanks
|
| Earl Kelly

 

[bearguy904]

Stephan,

I saw this out on the website before, can you explain to me exact what I
need to use to make the variable work?

Thanks

Earl