Did you use the "" around the -? The "" allows you to add spaces, etc to make it look better in presentations. The ampersand is for concatenating but if you add other symbols etc you need to also use "". ie: in access if I want a name to read like Smith, John I would put in the query Name:LastName &", "& FirstName
so I've taken both fields and given it a new name Are you using a query grid to make this? If so maybe try TERMS:term &"-"&term1&" "& term2&"." -----Original Message----- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 10:17 AM 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
