Philip,
If I understand your statement correctly, I think I have to take issue.
I have a newsletter app I've been working on where the following code
works just fine (article_text is an Access memo field, and criteria is
the form field):
WHERE article_text LIKE '%#criteria#%'
Maybe an exception to the rule?
Regards,
--John
Philip Arnold - ASP wrote:
>
> > Besides the indexing issue, are there any drawbacks to using the Memo
> > type?
>
> They can't be used in a WHERE, you can only deal with them in the SELECT
> part of your SQL
>
> Once it's in CF, you can do whatever you want.
>
--
Great minds discuss ideas;
Average minds discuss events;
Small minds discuss people.
-- Eleanor Roosevelt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
