View Single Post
  #1 (permalink)  
Old February 18th, 2017, 02:58 PM
wwwebconcepts wwwebconcepts is offline
Registered User
Points: 21, Level: 1
Points: 21, Level: 1 Points: 21, Level: 1 Points: 21, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Feb 2017
Location: Houston, TX
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote