Youll need a comma 'term&[-]&term1 term2' should be 'term&[-]&term1, term2'
HTH -----Original Message----- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 15:17 To: CF-Talk Subject: Re: Access problem - Help please OK I used below suggestion and get following error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'term&[-]&term1 term2' All the rest of my select statement does work Just get the error when I try to Concatenate Jim ----- Original Message ----- From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 9:39 AM Subject: RE: Access problem - Help please > term &"-"& term1 term2 > > -----Original Message----- > From: Sam Farmer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 28, 2001 9:17 AM > To: CF-Talk > Subject: Re: Access problem - Help please > > > Because pipes are not used for concatenation in Access (only Oracle > uses them I think). Try using a + sign or something else (not being > an Access user at all). > > Sam > > ----- Original Message ----- > From: "Jim Watkins" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, November 28, 2001 8:38 AM > Subject: Access problem - Help please > > > > Why do I get this error: > > "Microsoft][ODBC Microsoft Access Driver] Invalid use of vertical > > bars in > > query expression 'term||'-'||term1 term2'." > > > > When using this code: > > <cfquery name="select" DataSource="survey"> > > SELECT distinct coursename,term,term1, term||'-'||term1 term2 > > FROM courseeval > > </cfquery > > > > Thanks for your input > > > > Jim Watkins > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists