Any time dude, any time. 

......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-----Original Message-----
From: Tom King [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 07, 2006 8:41 AM
To: CF-Talk
Subject: RE: Head Banging Access LIKE error in QoQ

Yay!!!

For reference, my SQL now reads:

        <cfquery dbtype="query" name="GetTaggedPhotos">
                SELECT * from request.photolist WHERE 
                (
                PhotoTag IS NOT NULL
                AND
                PhotoTag LIKE '%#trim(variables.thistag)#%'
                );

                </cfquery>

Thanks y'all!!!!


T

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259428
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to