Help on application.cfm

[AKRUP]

Hi I am using this application.cfm for session variable. I don't know what
type of application need for define the session variable. I am running the
query below to get user's information from HEALTHFORM table and USER_INFO
table. Now it is returning nothing (blank return). I don't know query is wrong
or session variable. Please help.

<!--- Application. cfm --->

<cfapplication name="UserSearch"
clientmanagement="Yes"
clientstorage="NewEnet"
sessionmanagement="Yes"
sessionTimeout = #CreateTimeSpan(0, 0, 0, 60)#>



<cflock scope = "Session" timeout = "30" type = "Exclusive">

<cfif NOT IsDefined("session.size")>
<cfset session.size = ""> <!---What suppose to go in the place of
session.size = "" > ? --->
</cfif>

<cfif NOT IsDefined("session.color")>
<cfset session.color = "">

</cfif>
</cflock>



<cflock scope = "Application" timeout = "30" type = "Exclusive">
<cfif NOT IsDefined("application.size")> <!--- what is the application
..size ?--->
<cfset application.size = "">
</cfif>
</cflock>


<cflock scope = "Application" Timeout = "30" type = "readOnly">


<cfoutput> </cfoutput>

</cflock>





<!--- Query for getting information from User_Info and HealthForm --->



<cfquery name="getUserHealthForms" datasource=#MM_NewEnet_DSN#
username=#MM_NewEnet_USERNAME# password=#MM_NewEnet_PASSWORD#>
SELECT ui.*, hf.*
FROM USER_INFO ui, HEALTHFORM hf
WHERE 0 = 0

<cfif NOT IsDefined('SESSION.Password')>
AND ui.Password='FORM.password'
<cfelse>
AND ui.Password='SESSION.Password'
</cfif>
<cfif NOT IsDefined('SESSION.userName')>
AND ui.userName='FORM.username'
<cfelse>
AND ui.userName='SESSION.userName'
</cfif>
AND hf.userID=ui.userID
</cfquery>

--->

<!---delete this entire line of text if you would like to see what the query
has retrieved for debugging
<cfdump var="getUserHealthForms">


<cfif (NOT IsDefined("SESSION.userName")) OR(NOT
IsDefined("SESSION.Password"))>
<cfset SESSION=StructNew()>
<cfset SESSION.userName="getUserHealthForms.userName">
<cfset SESSION.Password="getUserHealthForms.Password">
</cfif>

Thanks / Any help would be appreciated.

[Simon Dallmair]

Hi AKRUB,

I found some things - be sure to surround Variables which should be decoded
with ##

> <cfif NOT IsDefined('SESSION.Password')>

use double qoutes: IsDefined("Session.Password")

> AND ui.Password='FORM.password'

You really have a Password named "FORM.Password" ? Or should it be:
ui.Password='#Form.Password#'

>
> --->

End of Comment? And where is the Start?

> <!---delete this entire line of text if you would like to see what the

query

> has retrieved for debugging
> <cfdump var="getUserHealthForms">

Cause here Starts a Comment - and there is no End the Following Lines will
not be executed...

>
> <cfif (NOT IsDefined("SESSION.userName")) OR(NOT
> IsDefined("SESSION.Password"))>
> <cfset SESSION=StructNew()>
> <cfset SESSION.userName="getUserHealthForms.userName">
> <cfset SESSION.Password="getUserHealthForms.Password">
> </cfif>

Try to rewrite the Code - cause it seems it is only copied from another
Source. Delete all Lines which are not used - and try it again. If you have
Problems with Queries, try only the Query with an <cfdump > at a test site:

<cfset form.password="MyPassword">
<cfset form.username="MyUsername">

<cfquery name="getUserHealthForms" datasource=#MM_NewEnet_DSN#
username=#MM_NewEnet_USERNAME# password=#MM_NewEnet_PASSWORD#>
SELECT ui.*, hf.*
FROM USER_INFO ui, HEALTHFORM hf
WHERE hf.userID=ui.userID

<cfif NOT IsDefined('SESSION.Password')>
AND ui.Password='FORM.password'
<cfelse>
AND ui.Password='SESSION.Password'
</cfif>
<cfif NOT IsDefined('SESSION.userName')>
AND ui.userName='FORM.username'
<cfelse>
AND ui.userName='SESSION.userName'
</cfif>

</cfquery>
<cfdump var="getUserHealthForms">


:-)

cu Simon