yup....try an ampersand (&) ------------------------------------------------------------------ Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net ------------------------------------------------------------------ United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message----- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 14:39 To: CF-Talk Subject: Re: Access problem - Help please I have tried the + sign but no good. Anybody out there know how to set up concatenation in Access?? Jim ----- Original Message ----- From: "Sam Farmer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 9:16 AM 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
