ok so i'm working on the restricted access part 1 tutorial and i was on the part were you're your showing the visitor's names on each page. I add to the recordset sql statement what the tutorial had and it kept giving me an error saying that there is a missing operator. CAn somebody please helpme the code is below.

SELECT AccountID, UserAccessLevel, UserAddress1, UserAddress2, UserCityTown, UserCountry, UserDOB, UserEmail, UserFaxno, UserPostcode, UserRegion, UserSurname, UserForename, UserTelephone
FROM website_users
WHERE AccountID = varUserID
SET VarUserID as Session("MM_UserID";

think it's just a typo, Uppercase Lowercase

WHERE AccountID = varUserID
SET VarUserID as Session("MM_UserID";

VarUserID and .... <b>v</b>arUserID

that wasn't the problem but thanks any way i still don't know the problem i went through w3schools trying to learn sql since this problem came up but can't seem to find the problem. I orginally had it more complex and started to get that error then made it simpler and still i'm getting the same thing.

Couple of maybe's for you - if the ID's are text rather than numeric then you need to use WHERE AccountID = 'varUserID'
otherwise here's some working code for you in Javascript to have a nosey at. (based on a text field)

&lt;%
var Recordset1__MMColParam = "1";
if (String(Session("MM_Username") != "undefined" &&
String(Session("MM_Username") != "" {
var1 = String(Session("MM_Username");
}
%&gt;
&lt;%
var Recordset1 = Server.CreateObject("ADODB.Recordset";
Recordset1.ActiveConnection = MM_pb_STRING;
Recordset1.Source = "SELECT * FROM Users WHERE Username = '"+ var1 + "'";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%&gt;

Hi Evan

What language are you using?

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

i'm using asp vbscript

Hi Evan

This is not valid you need to remove it from your SQL code SET VarUserID as Session("MM_UserID". with this code removed you will have a record returned for the varUserID submitted.

I'm not sure what you're going to do with the returned recordset, if all you're going to do is display the visitor name on each page, why have you included all the other data?

An easy way to do this is on the login page, which I'm assuming you have.

1. Edit the login server behaviour SQL SELECT statement to include UserSurname and UserForename along with your username, password and accesslevel fields

2. Edit the login server behaviour to create a session variable and assign it the UserSurname and UserForename values where this line is in the code:

' username and password match - this is a valid user
Session("MM_Username" = MM_valUsername
' Add the following:
Session("myVisitorsName" = MM_rsUser.Fields.Item("UserForename".Value & " " & MM_rsUser.Fields.Item("UserSurname".Value

3. Write the session variable contents to the page

Response.Write(Session("myVisitorsName")

If you get stuck post back.


Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>