Hi,
I haven't used Access for a while, but we're using it on a tiny site due
to go live. Running on CF5 and Access2000 database. Okay locally, but
when uploaded to our live server, we get:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or
Hyperlink Object when you select unique values (va_description).
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (36:5) to (36:57).
Haven't seen this before. The query concerned is:
<!--- grab the appropriate info --->
<cfquery name="vacancies" datasource="#request.dsn#">
SELECT DISTINCT va.*, lo.lo_place
FROM vacancy AS va, location AS lo, vacancy_title_link AS vtl
WHERE va.lo_id = lo.lo_id
<cfif len(form.title) GT 0>AND va.va_id = vtl.va_id AND
vtl.ti_id IN (#form.title#)</cfif>
<cfif form.location GT 0>AND va.lo_id = #form.location#</cfif>
<!---<cfif form.discipline GT 0>AND va.di_id =
#form.discipline#</cfif>--->
</cfquery>
Is that error prototypical of anything in particular?
Ross
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
