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
