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
