Jump to content

Bazilisk

Members
  • Posts

    75
  • Joined

  • Last visited

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by Bazilisk

  1. Have error for MySQL select:

    $select = \IPS\Db::i()->select( '*', 'news_artcms_news', array('categorynum LIKE ?','%main%'), 'news_artcms_news.num DESC', array( 0, 12 ) );
    $results = \IPS\Db::i()->query($select);
    Quote

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? ORDER BY news_artcms_news.num DESC LIMIT 0,12' at line 1

    Where is my mistake?

    I try to change problems code: 

    array('categorynum LIKE ?','%main%')

    to

    array('categorynum = ?','main')

    but error dont fixed....

    categorynum is text field

  2. I make application and have to use html tags <p></p> in variables.

    $text = "<p>some text</p><p>second paragraph text</p>";

    But IPS auto convert it to symbols: &lt;p&gt;

    I try to fix it in template:

    {{$text = htmlspecialchars_decode($text, ENT_NOQUOTES);}}

    But htmlspecialchars_decode dont change variable.

    Is it possible to send formatted text as clear html to template?

  3. Have error in this script in Application system. I have 2 records in array if have record in table news_upload.

    $select = \IPS\Db::i()->select( '*', 'news_news', NULL, 'news_artcms_news.num DESC', array( 0, 25 ) );
    $select = $select->join( 'news_uploads', 'news_uploads.recordNum=news_news.num', 'LEFT' );
    $results = \IPS\Db::i()->query($select);

    Where is my mistake?

    Next code work Ok in block system. 

    $select = $connection->select( '*', 'news_news', NULL, 'news_news.num DESC', array( 0, 25 ) );
    $select = $select->forceIndex( 'num' ); 
    $select = $select->setKeyField( 'num' );
    $select = $select->join( 'news_uploads', 'news_uploads.recordNum=news_news.num', 'LEFT' );
    $results = \count($select); 

    But in application system I have error for forceIndex() and setKeyField.

    Think what problem because tables have field 'num', and select get this from second table, but I have to get it from first....

    Possible using distinct can decide this task, but can not find sintax.

×
×
  • Create New...