DMXzone Database Connector PHP Support Product Page
Answered
I'm lost.
Asked 11 years ago
2
have this question
11 years ago Randy Riesterer posted:
I'm trying to custom refine a displayed dataset from a database like we used to build using DW's recordset server behaviors... e.g. ----------------------------------------
SELECT ID, StartDate, Headline, SUBSTRING_INDEX(NewsArticle, ' ', 10) AS SummaryFROM breakingnewsWHERE CurDate() >= StartDate AND CurDate() <= EndDateORDER BY StartDate DESC
---------------------------------------------------
Is there a tutorial that covers how to build custom SQL-like queries and implement it using your Database Connector?
Replies
Replied 11 years ago
11 years ago Teodor Kuduschiev replied:
Hello Randy,
Unfortunately it is not possible to use custom sql queries with the extension. You can use the query builder to build your query.
Unfortunately it is not possible to use custom sql queries with the extension. You can use the query builder to build your query.