SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE
IDNUMBER= na"
Use single quotes around the na, so it should look like this
UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE
IDNUMBER='na'
--Greg
----- Original Message -----
From: "Michael Ross" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 9:37 AM
Subject: Sessions/cookies
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
