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
