Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • SQLPlugin problems

    Posted by nathanvi

    Hi all,
    i've a problem with sqlplugin in tikiwiki 1.9.4.
    I used a sql string in a wiki page.
    It worked in tikiwiki 1.8.6 but it gives me an error "Missing db param"...
    If i clear all question marks (?), it works again....
    It seems it doesn't like question marks..

    Here my string:
    Image

    Copy to clipboard
    {SQL (db=>twd)}SELECT `CodiceEmettitore` as 'CodEmett', `Categoria`, `Accordo`, `Esenzione`, `StatoAccordo`, 
IF(`CodificaIntranet` IS NOT NULL,CONCAT('<a href="/tiki-list_file_gallery.php\?galleryId=4&find=',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`CodificaIntranet`,'</a>'),'') as 'CodificaIntranet', 
IF(`Comunicazioni` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`Comunicazioni`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`Comunicazioni`,'</a>'),'') as 'Comunicazioni',
IF(`TabelleFinanziarie` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`TabelleFinanziarie`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`TabelleFinanziarie`,'</a>'),'') as 'TabelleFinanziarie',
IF(`ProdottiFinanziabili` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`ProdottiFinanziabili`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`ProdottiFinanziabili`,'</a>'),'') as 'ProdottiFinanziabili',
IF(`ElencoPuntiVendita` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`ElencoPuntiVendita`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`ElencoPuntiVendita`,'</a>'),'') as 'ElencoPuntiVendita',
IF(`Modulistica` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`Modulistica`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`Modulistica`,'</a>'),'') as 'Modulistica',
IF(`CardCarrier` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`Comunicazioni`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`CardCarrier`,'</a>'),'') as 'CardCarrier', 
IF(`Generale` not like 'NO',CONCAT('<a href="/tiki-list_file_gallery.php',`Generale`,'-',`CodificaIntranet`,'&search=cerca&sort_mode=created_desc">',`Comunicazioni`,'</a>'),'') as 'Generale'
FROM `AccordiCodiciEmettitori` 
WHERE `StatoAccordo`='AT' and `CodiceEmettitore` not like '---' ORDER BY `Accordo`{SQL}
    Reads: 531