Great! BTW, you don't need all of those additional pound signs... You
only need pound signs if you need to "output" the value to screen or in
an attribute of a tag. Revised below....
<cfquery name="LoginUser" datasource="douglasmcgregor.co.uk"
dbname="douglasmcgregor.co.uk" dbserver=".\SQLEXPRESS" username="sa"
password="hidden">
SELECT * FROM tblUsers WHERE Username = '#form.Username#' AND
Password = '#hash(form.Password)#'
</cfquery>
<cfif form.Username EQ LoginUser.Username AND form.Password Eq
hash(form.Password)>
<cfset session.FirstName = LoginUser.FirstName />
</cfif>
<cfoutput>#session.FirstName#</cfoutput>
Douglas McGregor said the following on 08/22/2011 04:37 PM:
It's started working now. My revised code that works is below:
<cfquery name="LoginUser" datasource="douglasmcgregor.co.uk"
dbname="douglasmcgregor.co.uk" dbserver=".\SQLEXPRESS" username="sa"
password="hidden">
SELECT * FROM tblUsers WHERE Username = '#form.Username#' AND
Password = '#hash(form.Password)#'
</cfquery>
<cfif #form.Username# Eq #LoginUser.Username# AND #form.Password# Eq
#hash(form.Password)#>
<cfset #session.FirstName# = #LoginUser.FirstName# />
</cfif>
<cfoutput>#session.FirstName#</cfoutput>
Thank you all.
Douglas
------------------------------------------------------------------------
*From:* [email protected] [mailto:[email protected]] *On
Behalf Of *Peter J. Farrell
*Sent:* 22 August 2011 22:31
*To:* [email protected]
*Cc:* Douglas McGregor
*Subject:* Re: [OpenBD] Session variables not working
Douglas McGregor said the following on 08/22/2011 04:29 PM:
Still not having any success. However, after ticking Enable Debug
Output in the BlueDragon Administrator,
Can you share your revised code?
--
Peter J. Farrell
[email protected]
[email protected]
http://blog.maestropublishing.com
Identi.ca / Twitter: @maestrofjp
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
--
Peter J. Farrell
[email protected]
[email protected]
http://blog.maestropublishing.com
Identi.ca / Twitter: @maestrofjp
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
