try & ----- Original Message ----- From: "Jim Watkins" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 3:39 PM 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
