I have 2 files... one an include.

Security.asp contains sql code and should define a field called "lkey"
The second file has an applet that needs one of the parameters to look in security.asp (which is an include) for the field "lkey"

Here is what I havrso far but does not work...I think I am missing something...

security.asp
CODE ************************************************** **

'Declare some variables
dim mysql
dim lkey
dim active

'Read Database
mySQL = "SELECT lkey,active " _
& "FROM licensekey " _
& "WHERE active='active' " _
& "AND lkey<>''"

set rsTemp = openRSexecute(mySQL)
do while not rsTemp.EOF

lkey = ("lkey")
call closeRS(rsTemp)

END CODE ************************************************** **



menupage.asp
CODE ************************************************** **

<applet Code=apXPButtonMenu.class Width=140 Height=451>
<param name=key value="<%=(lkey) %>">
<param name="isHorizontal" value="false">
<param name="menuItems" value="

{Setup & Utilities,utilities.asp,_self,new4-136.gif}
">
</applet>

Can someone pleez help?
Thanks in advance.

might want to put this under the ASP section

It is already, thanks