PC Review


Reply
Thread Tools Rate Thread

Database Results Wizard and User Login

 
 
bearguy904
Guest
Posts: n/a
 
      9th Mar 2008
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
 
Reply With Quote
 
 
 
 
Stefan B Rusynko
Guest
Posts: n/a
 
      10th Mar 2008
See the DBRW tweaks at
http://spiderwebwoman.com/thingumaji...htm#scriptmods

--

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


"bearguy904" <(E-Mail Removed)> wrote in message newsA420FF9-DB44-4122-BBE8-(E-Mail Removed)...
|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


 
Reply With Quote
 
bearguy904
Guest
Posts: n/a
 
      10th Mar 2008
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

"Stefan B Rusynko" wrote:

> See the DBRW tweaks at
> http://spiderwebwoman.com/thingumaji...htm#scriptmods
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "bearguy904" <(E-Mail Removed)> wrote in message newsA420FF9-DB44-4122-BBE8-(E-Mail Removed)...
> |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
>
>
>

 
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
results without the Database Results Wizard-via MS-Access marc Microsoft Frontpage 0 1st Mar 2009 09:13 PM
Database Results Wizard formatting Excel results KarenM Microsoft Frontpage 10 28th Aug 2008 03:38 PM
Database results wizard and ChiliSoft ASP with MySQL database =?Utf-8?B?Qm9i?= Microsoft Frontpage 4 2nd Apr 2005 12:26 AM
Cannot open database requested in login ''. Login fails. Login failed for user ''. Nevena Microsoft ADO .NET 1 16th Apr 2004 06:55 PM
How to Add an All Values Item to a Database Query by Using the FrontPage 2003 Database Results Wizard =?Utf-8?B?RGFuaWVs?= Microsoft Frontpage 4 2nd Feb 2004 05:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:47 AM.