Query Problem

[AkronBoy]

My query Company name contains a "&" in the title. When I do a search, nothing is is returned. How do I get around this problem. If I substitute a "-" in the title everything works.

<CFQUERY NAME=&quot;ActionQuery&quot; DATASOURCE=&quot;ResourceCenter&quot;>
SELECT *
FROM ShopContactList
WHERE Company='Anytown Bolts & Screws'
</cfquery>

 

[Wes98765]

Hmm. When you are using a field like Date in SQL it doesn't work bc Date is a key word. If you put &quot;&quot; around Date then it will work. I am not sure what the syntax would be in your case though.

Also you could rig it using like

<cfif CompanyVar eq &quot;Anytown Bolts & Screws&quot;>
WHERE Company LIKE 'Anytown Bolts%'
<cfelse>
WHERE Company='#CompanyVar#'
</cfif>