LOGON_USER Becomes Null

I create a web site in a Windows 2003 server/IIS6, and I used asp pages to get ServerVariables. After I set FrontPage Extension 2002, some ServerVariables like LOGON_USER become null. Any body has an idea?

View Replies


ADVERTISEMENT

RecordSet (and GetRows) Is Retrieving Null Values When They Aren't Null

I have an interesting situation that needs to be addressed ASAP.

I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned.

The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever.

In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null.

I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.

View Replies View Related

LOGON_USER

I am trying to retrieve the LOGON_USER and it comes up blank. Below is my
code:

struser = Request.ServerVariables("LOGON_USER")

View Replies View Related

Getting LOGON_USER

I am trying to retrieve the LOGON_USER and it comes up blank. Below is my code:

struser = Request.ServerVariables("LOGON_USER")

I need to validate internal people on out intranet.

View Replies View Related

LOGON_USER & IIS

I know that if you intend to use the LOGON_USER in an ASP page you need to have Windows Authentication selected.

I have a website in one domain which can be accessed by 2 other domains. If I am to change to Windows Authentication, will there be a security issue of any type?

View Replies View Related

LOGON_USER / NT Security

I'm trying to get the NT login id of a user on a web page without making the
user type it into a login box. I'm using the LOGON_USER server variable.
The problem is, if the web page allows anonymous access, LOGON_USER returns
nothing. If the page is set to Basic Security, the NT login popup box comes
up, even though the user is already logged into the network, and HAS access
to this page.

Moreover, if I try this on my PC instead of our webserver, it
works like I would expect. That is, when set to Basic Security, it does NOT
pop up a login box if the user is allowed to view the page, and LOGON_USER
returns the userid. Is there some setting on the server I need to change?
Or something else?

View Replies View Related

Not Getting Info In LOGON_USER

I have an intranet site hosted in IIS 5.0 Win2000, and want to display the name of the user logged into the local machines(WinXP) in the pages they access like 'Welcome JohniBravo'.

So, i used the Request.ServerVariables("LOGON_USER"), but get a blank ("") displayed in the page. And i even tried "REMOTE_USER" but, still the same. from somewhere i got to know that theres something called 'Allow anonymous user' should be enabled to get these info from servers. help me with the same?

View Replies View Related

AUTH_USER LOGON_USER

I have used the same syntax in two pages and sometimes each server variable is return, and sometime it is blank. In fact, I created a test page this morning which worked fine, and then an hour later the variables are blank. I read some of the threads about the anonymous user box in IIS, but this just seems strange.

P.S. Each PC in our environment is authenticated through active directory (just to logon to the PC, not security applied to the web folders).

View Replies View Related

Full Domain Name In Logon_User

I'm using Windows Integrated Authentication on my company intranet ASP web
site (IIS6 W2K3).

I would like to know how could I get the full Active Directory domain name
from the Logon_User variable.

I always get the netbios name of the domain, but I need the full domain name
to be able to distinguish users (because actually there is two companies on
the intranet having their AD forest linked, but also having some subdomains
with identical netbios name !).

I mean, for instance for a user login "theuser" coming from the domain is
"thedomain.thecompany.com", I need to get in Logon_User environement variable
the following content: "thedomain.thecompany.com heuser"
At the moment I only get "thedomain heuser", excepted if I switch to basic
authentication, that I don't want.

View Replies View Related

Logon_user Blank In Front Page Web Only

I have 2 webs under my default web running win2003

1. A front-page intranet
2. A asp (not .net) web is fine

Both allow anonomous access. My front page web always gets a BLANK Request.ServerVariables("Logon_User"). The asp web gets the logon_user OK. Both webs have a global.asa that has Code:

View Replies View Related

Request.servervariables("Logon_USer")

Request.servervariables("Logon_USer") is working perfectly well for one asp page returning the NT userid as expected but returning an empty string for another asp page.Both the asp pages are in the same directory.This directory have both Anonymous Access and Integrated Authentication enabled att IIS.

View Replies View Related

Request.ServerVariables("logon_user")

I'm trying to determine whose looking at various pages on our intranet and wanted to use

Request.ServerVariables("logon_user")

but it just gives me a blank value.

I'm thinking its got something to do with Authentification in IIS however when I turn Anonymous users off and use domain users instead it prompts me for a username and password when viewing the webpage ...

View Replies View Related

Clear "Logon_user"

I have a non anonymous site in IIS5
The site is for collecting any kind of data from employees.
Authentication is done with the server variable "Logon_User"

Pages:

start.asp - Authentification mask appears -->
form.asp - form for data input -->
form_ack.asp - displays the data again and stores in SQL when
acknowledged in checkboxes

After data are stored I'd like to have a button such as "Log off"
which points back to start.asp.

In the samples I tried there is always the current logged in user
present even when I do a "session.abandon" or
"Session.Contents.Remove"

But how can I "reset" the current logged in user?

View Replies View Related

Is Not Null

I have created a table. How do I limit the result of that table to only show the entries that have the "address" filled in. In Access here is the sql coding to acheive the results.

SELECT Dropoffs.City, Dropoffs.StateInitials, Dropoffs.AcceptedItems, Dropoffs.MoreInfo, zipcodes.Address
FROM zipcodes, Dropoffs
WHERE (((zipcodes.Address) Is Not Null));

How do I set this up in my VBSCRIPT page?
Here is my working page so that you can see what I am trying to acheive. When the page comes up you can type 45255 for the zipcode.

View Replies View Related

Not Null Value

I try to select the not null value from the database in column comment.

select s.ques_no, s.task_no, s.goal_no, g.comment from step_tab s, gen_tab g where s.id = g.id and g.comment is not null

But it still return all the null value.

Can anyone please tell me why?

Besides that, why i can't increase the number that i selected from the database.
id_no = rs("id_no")
id_no = cint(id_no") + 1

Why the id_no never increase even i had "+1"?

View Replies View Related

NULL Value?

I might be doing this wrong but I am modifying the body tag depending on what a recordset tells me.

It works fine if the value exist, but if it is returned null then I can't get it to work ...

View Replies View Related

NULL Vs. No Value

I had set up the following 'trouble-shooting' code to determine how a certain value was being 'evaluated' for lack of a better term. The field "status" in this example has no value in it.

<%
status = RS("status")
If isnull(status) Then
response.write("status is null")
end if
if status = "" Then
response.write("status has no value")
end if
%>

The database field 'status' has no value in it. If I run the above trouble-shooting code, the first statement "status is null" will print out. If I remove the first if statement and use the second if statement 'if status = "" ...', the statement will NOT print indicating that the value <> "".

Questions: What is the difference between something not having a value and NULL?

Most importantly, what is the PROPER way to check for a field not having a value in it? In the past I have always checked for a 'no value' using double quotes.

View Replies View Related

Null

I'm using the following code to, firstly erase any old logins the user has. Then to check whether the page has been idle for longer than 30 minutes or not. If it has been idle for longer than 30 mins then the user will be required to input their password again. However it's not working! Code:

View Replies View Related

Null Number

Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15

What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?

View Replies View Related

How To Check Value Is Null Or Not

how to check any value in asp that it is null or not.

View Replies View Related

When The Field Is Null

I have a condition that will run depending if a field in the database is NULL. It will not run at all, and I tried various way to write it but none works so far

'not working
If assignee = DBNull Then

'not working
If assignee = null Then

'not working
If assignee = "" Then

If I write assignee to the page then the value of assignee will write if it has a value and nothing if it is null.

View Replies View Related

Null Insertion

I have a data entry form. If the user submits the form without entering any data, the record should be inserted with null entries for the respective fields.
But when i execute the INSERT SQL query with these null values, it gives me an error.
This is vat I am doing:

<%
.....
address = request.form("address")
if request.form("Age")= "" then
ageValue=""
.....
.....
%>
I use these values in SQL query
This is the SQL statement when the above is executed
" INSERT INTO tblStatistics (Age,address) VALUES (, aaa)"
Because of no value for age, the query is not gettin executed.
I dont want a 0, I want a nul entry (<null>).
Could someone throw some light on how to set the age field to null?

View Replies View Related

Null: 'replace'

Can someone help with an error? It's a StoreFront store. right after the credit card screen is gives me the error. I get the following:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'replace' /ssl/SFLib/incGeneral.asp, line 85

--------------------------------------------
84 Function makeInputSafe(str)
85 makeInputSafe=replace(str, "'", "''")
86 End Function
-------------------------------------------

View Replies View Related

Convert Null

i had select the data from the database. The null value are returned.
How can i convert the null value to integer so that i can add some value for it??
Actually i try to use both of this statement but there's nothing come out...when i try to selecte the data in the database, the null value are returned

if rs("max_id") = "NULL" then
id_no = 1
response.write "id_no = " &id_no& "<br>"
end if

and

if rs("max_id") = "" then
id_no = 1
response.write "id_no = " &id_no& "<br>"
end if

View Replies View Related

NULL Values In SQL

I have 2 questions about SQL server. First, what should i do about allowing NULL values when designing the database? What difference does it make? And if I disallow NULL values, should i enter default values?

Second, when adding new records to database with recordset.addnew, what SELECT statment, cursor, and lock type should i use?

I've always used "SELECT * FROM Table" and adOpenStatic, and adLockOptimistic. This SELECT statement looks very inefficient to me, but I don't know what else to use.

View Replies View Related

Null Variable

I am updating a table depending on the user input that could be left blank for the numeric as well as the string field. I am getting an error if I do the following:

Dim a = null

sql = "update country set number =" & a

If I do ... sql = "update country set number = null", it works fine.

How can I use the variable to change the value to null.

View Replies View Related

Null Value Filtering

I have set up a database, myDB, in MS Access. one of my Table, myTable, has columns Col1, Col2, ..., Col10. Depending on some scenarios, I insert some values in some (but not all) of the columns. Now I want to delete those records that their col3 is null or nothing is set.

I used col3= '' and col3=NULL in the below statement
objRS.Open "SELECT * FROM myTable WHERE col3 = '' ", myDB, , , adCmdText

but none of them works.How to delete a record based on Null value filtering?

View Replies View Related

Null Date

I am new to using the filter property. When I try publishDate = '' I
get a type mismatch error

View Replies View Related

NULL In If Then Statement

Code:

<img src="/images/thumbs/<% IF rsListProduct("AHFC_Product_ThumbURL") = null THEN %> no_image.gif <%ELSE%><%=rsListProduct("AHFC_Product_ThumbURL")%><%END IF%>" width=50 border=0>

Why does this not work? Field is for SURE null in DB if no image uploaded.

View Replies View Related

Check For Null

Is there an easier way to check if any of the fields returned in a select statement have null values? After running this command:

set rs = conn.execute("select A,B,C,D,E,F,G,H,I,J from SomeTable
where...")

I could check each field this way:

If IsNull(rs("A") Then
Response.Write("The value of A is null")
Else
Response.Write("The value of A is " & rs("A"))
End If

If IsNull(rs("B") Then
Response.Write("The value of B is null")
Else
Response.Write("The value of B is " & rs("B"))
End If

If IsNull(rs("C") Then
Response.Write("The value of C is null")
Else
Response.Write("The value of C is " & rs("C"))
End If

etc.

But is there a simpler way? Also, my "solution" probably wouldn't work if more than one recordset was returned...

View Replies View Related

Best Way To Find <> NULL

How do I go about testing to see if a value is not equal to NULL? isNULL provides the opposite functionality, but all my attempts at the former return a FALSE value.

View Replies View Related

My.mind = Null

I have an add page, sending data too an access database, and what I want to do is, if their is a Null value (for example a user forgets to write in a name) then users will be redirected to a page called "wrong.asp"

the following are the add pages, the info is put in through add.asp, and sent through add1.asp. Add.asp is pritty big because there are 3 dynamic drop down lists, (D1, D2, D3)

Code:

View Replies View Related

Update Value Null

I would like to update a field with the value of a "empty check box". The problem that my numeral field (kom1) in the db will be emty, instead of 0.
I need the value 0 becaus it's used by a SUM in an query.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved