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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
