p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   call Function in SQL Statement (http://p2p.wrox.com/showthread.php?t=99378)

wwwebconcepts February 18th, 2017 02:58 PM

call Function in SQL Statement
 
I'm searching a blog post database field with embedded HTML and highlighting the found strings but it's selecting and highlighting HTML tags breaking the HTML.

I have a regular expression function RemoveHTMLI use to display excerpts without the HTML that I am trying to call from my SQL to prevent tag matches but it does nothing.

Here's the SQL: "SELECT Content_ID, Content_Title, Content_Body, Content_FeaturedImage FROM Content WHERE ((Content_Title) Like ?) OR (" & RemoveHTML("Content_Body") & " Like ?) And Content_Active = 'Y' ORDER BY Content_Title ASC;"

The query runs but it returns HTML. Any ideas?


All times are GMT -4. The time now is 01:54 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.