Sorry to ask a question about this but I am having problems. I set up my
application.cfm for sessions. I am able to use them almost all the time. Then out of
the blue I will get this error message.
------------------------------------------------------------------------------------
Error Diagnostic Information
ODBC Error Code = S0022 (Column not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'na'.
SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER= na"
Data Source = "assets"
------------------------------------------------------------------------------------
I know what the error means I can fix that. Its why I am getting this that is
puzzling. I know its not setting the session.user_name. But why?? out of the blue.
Here is my application page.
-------------------------------------------------------------------------------------------------------------------
<CFAPPLICATION NAME="surg"
SESSIONMANAGEMENT="YES"
SESSIONTIMEOUT="#CREATETIMESPAN(0,0,30,0)#">
<CFIF NOT ISDEFINED('SESSION.USER_NAME')>
<CFPARAM NAME="SESSION.USER_NAME" DEFAULT="na">
<CFPARAM NAME="SESSION.NAME" DEFAULT="na">
<CFPARAM NAME="SESSION.SECUREDGROUP" DEFAULT="na">
<CFPARAM NAME="SESSION.SESSIONID" DEFAULT="na">
<CFPARAM NAME="SESSION.LOGIN" DEFAULT="na">
<CFPARAM NAME="SESSION.ORGROUP" DEFAULT="na">
<CFSET DIFF = 'NO'>
<CFLOOP CONDITION="DIFF EQ 'NO'">
<CFSET IDNUMBER= #RANDRANGE(10000, 10000000)#>
<CFQUERY NAME="ID" DATASOURCE="assets">
SELECT IDNUMBER
FROM tblsessions
WHERE IDNUMBER = #IDNUMBER#
</CFQUERY>
<CFIF #ID.RECORDCOUNT# IS 0>
<CFSET DIFF = 'Yes'>
</CFIF>
</CFLOOP>
<CFLOCK TIMEOUT="30" NAME="#SESSION.USER_NAME#">
<CFSET SESSION.USER_NAME="#IDNUMBER#">
</CFLOCK>
<CFSET TIMET= TIMEFORMAT(NOW(), 'HH:MM:SS')>
<CFQUERY DATASOURCE="assets" NAME="INSERT">
INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS)
VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#')
</CFQUERY>
<CFELSE>
<CFSET TIMEL= TIMEFORMAT(NOW(), 'HH:MM:SS')>
<CFIF #SESSION.USER_NAME# IS NOT 'NA'>
<CFQUERY NAME="UPDATE" DATASOURCE="assets">
UPDATE tblsessions
SET LASTTIME ='#VARIABLES.TIMEL#'
WHERE IDNUMBER= #SESSION.USER_NAME#
</CFQUERY>
</CFIF>
</CFIF>
<CFIF ISDEFINED("Cookie.CFID") AND ISDEFINED("Cookie.CFTOKEN")>
<CFSET CFID_LOCAL = COOKIE.CFID>
<CFSET CFTOKEN_LOCAL = COOKIE.CFTOKEN>
<CFCOOKIE NAME="CFID" VALUE="#cfid_local#">
<CFCOOKIE NAME="CFTOKEN" VALUE="#cftoken_local#">
</CFIF>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists