I still don't see how this is a problem with your session variables? Check the type of the contact_key field in the contact table and make sure it's a string of some sort if that's what you're trying to compare it with.
Also, your CFSET above that is using the operator IS instead of an equal sign. Maybe that's supposed to be a CFIF instead? -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ----- Original Message ----- From: "Cecilia Shaw" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 4:53 AM Subject: Re: Passing Session variables > Here is the error I get on the 3rd page: > > Error Diagnostic Information > ODBC Error Code = 22005 (Error in assignment) > > > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria > expression. > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (71:3) to (71:52). > > Date/Time: 05/06/02 01:51:28 > Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) > Remote Address: 172.142.191.243 > HTTP Referrer: ./../dsp_membergraphs.cfm?contact_key=memberfirst&memberlast > Query String: contact_key=member > > This is the query producing the error: > > <CFSET action IS "URL.contact_key"> > > <CFQUERY NAME="progress_report" DATASOURCE="#db#"> > SELECT contact.contact_key, progress.* > FROM contact,progress > WHERE contact.contact_key = progress.contact_key > AND contact.contact_key = '#URL.contact_key#' > ORDER BY contact.contact_key > </cfquery> > > > > > >From: "Justin Scott" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: Re: Passing Session variables > >Date: Mon, 6 May 2002 03:31:20 -0400 > > > >It would be helpful if you could post the entire error it is giving you, as > >well as the code for that custom JavaScript function. > > > >-Justin Scott, Lead Developer > > Sceiron Internet Services, Inc. > > http://www.sceiron.com > > > > > >----- Original Message ----- > >From: "Cecilia Shaw" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Monday, May 06, 2002 3:08 AM > >Subject: re: Passing Session variables > > > > > > > For all you all nighters:) > > > > > > I am having a problem passing session variables in my app. The variable > > > I am using does not get invoked until after you are already in the > > > app. Where I am having the problem is passing that variable from the > >page > > > after it get initialized. Here is the code in part: > > > > > > Page 1: > > > <cfquery name="members" datasource="#db#"> > > > SELECT * > > > FROM contact,contact_role,progress > > > WHERE contact.contact_role_key = contact_role.contact_role_key > > > AND contact_role.contact_role_key = 1 > > > AND contact.contact_key = progress.contact_key > > > </cfquery> > > > > > > Select a Member to Evaluate<br> > > > <FORM NAME="select1"> > > > <SELECT NAME="select1" onChange="surfto(this.form)" SIZE=1> > > > <OPTION> -- Select a Member -- </option> > > > <cfoutput query="get_members"> > > > <option value="dsp_membergraphs.cfm?contact_key=#first#&#last#"> > > > #first# #last#</cfoutput> > > > </option> > > > </select> > > > </form> > > > > > > Passes to Page 2: > > > <cfoutput> > > > <strong>Progress Tracker Report: #SESSION.member_contact_key#</strong> > ><P> > > > > > > > > > <p align="left"> > > > <ul> > > > <li><a href="dsp_progress-report.cfm?action=#URL.contact_key#">View/Edit > > > </a>Report > > > > > > <li> <a href="index2.cfm?contact_key=#URL.contact_key#">View</a> Member > > > Graphs > > > > > > </ul> > > > </cfoutput> > > > > > > Passes to page 3: (Problem page) > > > <cfset action="SESSION.member_contact_key"> > > > > > > <cfoutput> > > > <table border="0" cellpadding="3" cellspacing="3"> > > > <th align="left" colspan="3" bgcolor="006951"> > > > <font color="White"> > > > Here are the current progress tracker scores for: > > > #SESSION.member_contact_key#</font></th> > > > </cfoutput></table> > > > > > > This page gives me an error. It's late and I'm on brain lock:) > > > This needs to work by morning. Any suggestions are truly appreciated! > > > > > > > > > Cecilia Jimason Shaw > > > > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
