I came across this rather strange error, when our webhoster upgraded this
particular server to Win2k. Beforehand I had never seen it. If anyone could
shed some light on it, it would be greatly appreciated.
THE ERROR ::
----------------------------------------------------------------------------
--------
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 (G.group_description_1).
THE QUERY:: (its rather large)
----------------------------------------------------------------------------
--------
SELECT
DISTINCT(G.group_id) as g_id,
P.product_order,
SSG.ssg_first,
SSG.ssg_order,
SS.sub_section_description AS ss_name,
G.Group_Ref_Name as g_ref,
G.group_style as g_style,
G.group_code as g_code,
<cfif attributes.SearchField EQ "g.group_id">
G.group_description_1 as g_desc1,
G.group_description_2 as g_desc2,
G.group_picture_1 as g_pic1,
G.group_picture_2 as g_pic2,
G.group_pdf as g_pdf,
</cfif>
G.group_tch1 as g_col1,
G.group_tch2 as g_col2,
G.group_tch3 as g_col3,
G.group_tch4 as g_col4,
G.group_tch5 as g_col5,
G.group_tch6 as g_col6,
G.group_tch7 as g_col7,
G.group_tch8 as g_col8,
G.group_tch9 as g_col9,
G.group_title as g_title,
P.product_tc1 as p_tc1,
P.product_tc2 as p_tc2,
P.product_tc3 as p_tc3,
P.product_tc4 as p_tc4,
P.product_tc5 as p_tc5,
P.product_tc6 as p_tc6,
P.product_tc7 as p_tc7,
P.product_tc8 as p_tc8,
P.product_tc9 as p_tc9,
P.product_description as p_name,
P.product_id as p_id,
P.product_code as p_code,
P.product_weight as p_weight,
<cfif session.international NEQ 1 and session.customerid NEQ 0>
P.product_base_price * P.product_price_factor as p_price,
<cfelse>
P.product_rrp * #session.dealerfactor# as p_price,
</cfif>
P.product_price_factor as p_factor
FROM
SSG_details SSG, sub_section_details SS,
group_details G, product_details P
WHERE
<cfif attributes.partcode EQ "">
(
#attributes.SearchField# = #url.id#
OR
#attributes.SearchField# IN
(#iRelatedIdList#)
)
<cfelse>
(
P.product_code LIKE '%#form.partcode#%'
OR
#attributes.SearchField# IN
(#iRelatedIdList#)
)
</cfif>
<cfif attributes.SearchField EQ "ss.sub_section_id" AND url.ef EQ 1>
<cfif url.gid NEQ 0>
AND g.group_id = #url.gid#
<cfelse>
AND SSG_First = 1
</cfif>
</cfif>
AND G.Group_Active = 1
AND ssg.ssg_sub_section_id = ss.sub_section_id
AND g.group_id = ssg.ssg_group_id
AND p.product_group_id = g.group_id
GROUP BY
SSG.ssg_first,
SSG.ssg_order,
P.product_order,
G.group_id,
P.product_description,
P.product_code,
SS.sub_section_description,
G.group_code,
G.Group_Ref_Name,
G.group_style,
<cfif attributes.SearchField EQ "g.group_id">
G.group_description_1,
G.group_description_2,
G.group_pdf,
G.group_picture_1,
G.group_picture_2,
</cfif>
G.group_tch1,
g.group_title,
G.group_tch1,
G.group_tch2,
G.group_tch3,
G.group_tch4,
G.group_tch5,
G.group_tch6,
G.group_tch7,
G.group_tch8,
G.group_tch9,
P.product_id,
P.product_tc1,
P.product_tc2,
P.product_tc3,
P.product_tc4,
P.product_tc5,
P.product_tc6,
P.product_tc7,
P.product_tc8,
P.product_tc9,
p.product_weight,
p.product_base_price,
p.product_rrp,
p.product_price_factor
ORDER BY
ssg.ssg_first,
ssg.ssg_order,
P.product_order
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
