Hi all,
i'm still working on my 'search' page but have made some progress !
What i need to do now is pass a session variable to the next page. I have a
text box on a form and a session variable called ptype. i have bind the sess
ion
to the empty text box for the user to type in. The form has a submit button 
and
the code to open the enxt page is as follows...

srchresults.asp?ID=<%= Session("ptype") %>

The next page should list the results filtered from the session variable but
when the results page opens the URL at the top of the page looks like this..
.

http://localhost/mysite/Intranet/srchresults.asp?ID=

The text the user input in the textfield is not there.
when i open the recordset property for the results page and test it by
manually typing in text it pulls up results !!
Can anyone advise me on where I am going wrong please ?

Mitch........

I'm not completely sure I understand what you are trying to do, so I'll expl
ain
two methods.

1:
Session variables are inherently stored until the user ends the session
(usually by closing the browser), so there is no need to pass them through a
querystring in the URL.  Simply using <% Session("ptype") =
Request("<textname>") %> will store the value that was entered in <textname>
 in
the session variable "ptype".  You can then use it on another page by callin
g
Session("ptype") any time you want to use that variable.  (You won't be able
 to
set the session variable to the value of the text box until after the form i
s
submitted, so if the "action=" sends it to another page, the session variabl
e
will be an empty string ( "" ))  If you wanted to store the session variable
and then send it to the results page, you'd have to set
action="<thesamepage>.asp" and then put the code that I mentioned up top at 
the
top of the page, then use <%Response.Redirect "srchresults.asp?ID=" &
Session("ptype") %> to redirect to the results page.

2.  It sounds like you don't even need to use a session variable to do what
you want to accomplish.  Name the text box something like "ptype", set the f
orm
action="srchresults.asp", and on srchresults.asp you can get the value that 
was
in the text box by using Request("ptype").

Hope this helps.

Thanks Paul,
I have decided to give your second suggestion a try
but i'm not sure how to use the 'request(ptype)'  code you mentioned. Is thi
s
done setting the filter in the recordset for the results page ?

Mitch....

Oh I'm sorry.  I thought you were manually editing the code for this.

Yes, you would set the Filter to whatever column you want it to filter by,
then select either URL Parameter or Form from the dropdown below that one (U
RL
Parameter if your form has GET as the method, and Form if your form has POST
 as
the method).  Then in the last filter field put the name of the text box tha
t
you had on your form.  To use multiple filters you'll have to click on Advan
ced
and copy the syntax there.

As an aside, in case you wondering, the URL Parameter option will insert cod
e
that looks something like <% Request.Querystring("fieldname") %> and the For
m
option will insert code like <% Request.Form("fieldname") %>.  .Querystring
will grab the value that is appended to the URL (you saw the ?ID= added on
there) and then grab the value on the new page from there.  .Form will colle
ct
the data that was "secretly" passed by the from through the POST method.   T
he
code I mentioned <% Request("fieldname") %> will grab the data from either o
f
these.  Since users can manually append ?ID=etc... to the end of the URL, if
you don't want users looking at certain records, you'll want to use POST and
Request.Form().  Also if you are having the user enter a large amount of tex
t
you'll want to use POST as well, since the maximum size of a URL is somewher
e
around 2024 characters.

Any questions - ask!

I hope some day soon i'm competent enough to edit the code manually but not
just yet :)

Anyway, your advice has saved the day, it worked perfectly !! This task has
been bothering me for a few days now so its nice to get the functionality
working, I just have to tidy up the design now.

Thanks again for your solution, you've saved my neck !!

Mitch...

In article <1130205871.363293.172550@g43g2000cwa.googlegroups.com>,
masta_d_funk@hotmail.com says...
>
>Hey
>
>I have a problem using dreamweaver. The problem is im creaing a login
>page that accepts the username and password. When the user logins i
>only want their information displayed. My columns for the username
>consists of UserID, Username and Password. And my other table is called
>Data consisting of UserID, Email, Address, etc.. When the user logins i
>want it to check in the Data table for the UserID so that it displays
>his/her information only. i know i can do it if i had a Username column
>in the Data table, but i do not want that..
>
>im currently using dreamweavers login authentication wizard..which
>takes in 2 values..the username and password..i need help on creating a
>recordset that will user the users UserID and will link it to the Data
>UserID column..

There are a couple of ways to handle this. First of all, are you sure you ca
n't
combine those fields in a single table? I don't know your schema or data, bu
t
those fields are related to users and might belong together.

If the columns do belong in 2 tables, then you need to write SQL to join the
tables together on the common UserID field. You need to go to the Advanced t
ab
on the RecordSet dialog and enter your SQL.

Another option is to create a view in your DBMS (in Access you could use a
query) that joins the tables, and then select the view from the Recordset
dialog. But for a simple query like yours, this is overkill.

ok thx...ive tried creating the advanced SQL statement..my SQL
statement is like this:
SELECT tblCustomer.sUsername, tblIssue.sIssueNumber,
tblIssue.iIssueDate, tblIssue.sZIP, tblIssue.sEXE, tblIssue.sPDF
FROM tblCustomer INNER JOIN tblIssue ON
tblCustomer.iUserID=tblIssue.iUserID;
WHERE tblIssue.iUserID = tblCustomer.iUserID

But when i want to use the iUserID as a session variable it displays an
error message. My session variable is Session("MM_Username) where the
MM_Username is the sUsername is my table...

Im creating a website that has 2 tables, when the user accesses the
website..he/she can only download the updates that are currently issued
to them..So that is why ive created 2 tables..one of the user details
and the other is the table where it looks up for the iUserID...

Can you please help me?

ok thx...ive tried creating the advanced SQL statement..my SQL
statement is like this:
SELECT tblCustomer.sUsername, tblIssue.sIssueNumber,
tblIssue.iIssueDate, tblIssue.sZIP, tblIssue.sEXE, tblIssue.sPDF
FROM tblCustomer INNER JOIN tblIssue ON
tblCustomer.iUserID=tblIssue.iUserID;
WHERE tblIssue.iUserID = tblCustomer.iUserID

But when i want to use the iUserID as a session variable it displays an
error message. My session variable is Session("MM_Username) where the
MM_Username is the sUsername is my table...

Im creating a website that has 2 tables, when the user accesses the
website..he/she can only download the updates that are currently issued
to them..So that is why ive created 2 tables..one of the user details
and the other is the table where it looks up for the iUserID...

Can you please help me?

In article <1130801635.319726.306990@g14g2000cwa.googlegroups.com>,
masta_d_funk@hotmail.com says...
>
>ok thx...ive tried creating the advanced SQL statement..my SQL
>statement is like this:
>SELECT tblCustomer.sUsername, tblIssue.sIssueNumber,
>tblIssue.iIssueDate, tblIssue.sZIP, tblIssue.sEXE, tblIssue.sPDF
>FROM tblCustomer INNER JOIN tblIssue ON
>tblCustomer.iUserID=tblIssue.iUserID;
>WHERE tblIssue.iUserID = tblCustomer.iUserID
>
>But when i want to use the iUserID as a session variable it displays an
>error message. My session variable is Session("MM_Username) where the
>MM_Username is the sUsername is my table...
>
>Im creating a website that has 2 tables, when the user accesses the
>website..he/she can only download the updates that are currently issued
>to them..So that is why ive created 2 tables..one of the user details
>and the other is the table where it looks up for the iUserID...

OK, first of all, I'm not that familiar with MySQL join syntax as I don't us
e
that DBMS. But it seems to me that you have a redundant join in the where
clause. In other DBMS's, you can either use the join keyword, or put the joi
n in
the where clause - but not use both.

What you don't have in the where clause is the UserID that the user logged i
n
with. So you are probably getting multiple rows returned. You need to restri
ct
the result set to the user that has logged in by including the session varia
ble
in the where clause. Or is that where you are having the problem?