2. PHPRunner General questions
  3. problem in search
This topic is locked

problem in search

 		7/3/2006 10:05:41 AM
PHPRunner General questions
A
 albo author

Hi

I have a problem in the advanced search form.

when i try to search by age (field made by myself MID(FLOOR((NOW() - `dtnascita`)/10000),1,2) )

i receive an error:
Errore di tipo 256

Errore di descrizione 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 'dtnascita`)/10000),1,2)`) like upper('%35%'))' at line 1

URL casting.mediavivere.it/Schede_list.php?

Errore di file /var/www/virtual/casting.mediavivere.it/include/dbconnection.php

Errore di linea 26
Anyone know how to fix it?
Thx
Alexey admin 7/4/2006

Hi,
looks like you modified GetFullFieldName function in generated include\dbcommon.php ?

Show me the line you edited and I'll help you to fix the error.
A
 		albo author 7/4/2006
function GetFullFieldName($field,$table="")

{

global $strTableName;

if(!$table)

$table=$strTableName;

$field = RemoveFieldWrappers($field);

// Schede

if("Schede"==$table && $field=="PrgScheda") return "`Schede`.`PrgScheda`";

if("Schede"==$table && $field=="PrgScheda2") return "`Schede`.`PrgScheda2`";

if("Schede"==$table && $field=="PrgScheda1") return "`Schede`.`PrgScheda1`";

if("Schede"==$table && $field=="flgStato") return "`Schede`.`flgStato`";

if("Schede"==$table && $field=="FlgStm") return "`Schede`.`FlgStm`";

if("Schede"==$table && $field=="DtUltVar") return "`Schede`.`DtUltVar`";

if("Schede"==$table && $field=="DtEsport") return "`Schede`.`DtEsport`";

if("Schede"==$table && $field=="PrgEsportaz") return "`Schede`.`PrgEsportaz`";

if("Schede"==$table && $field=="PathFoto") return "`Schede`.`PathFoto`";

if("Schede"==$table && $field=="FileFoto") return "`Schede`.`FileFoto`";

if("Schede"==$table && $field=="NomeFotoDopoEsp") return "`Schede`.`NomeFotoDopoEsp`";

if("Schede"==$table && $field=="PathVideo") return "`Schede`.`PathVideo`";

if("Schede"==$table && $field=="FileVideo") return "`Schede`.`FileVideo`";

if("Schede"==$table && $field=="NomeVideoDopoEsp") return "`Schede`.`NomeVideoDopoEsp`";

if("Schede"==$table && $field=="Ok") return "`Schede`.`Ok`";

if("Schede"==$table && $field=="Sesso") return "`Schede`.`Sesso`";

if("Schede"==$table && $field=="Nazione") return "`Schede`.`Nazione`";

if("Schede"==$table && $field=="Nome") return "`Schede`.`Nome`";

if("Schede"==$table && $field=="Cognome") return "`Schede`.`Cognome`";

if("Schede"==$table && $field=="Dtnascita") return "`Schede`.`Dtnascita`";

if("Schede"==$table && $field=="LuogoNasc") return "`Schede`.`LuogoNasc`";

if("Schede"==$table && $field=="Ind") return "`Schede`.`Ind`";

if("Schede"==$table && $field=="CAP") return "`Schede`.`CAP`";

if("Schede"==$table && $field=="Citta") return "`Schede`.`Citta`";

if("Schede"==$table && $field=="regione") return "`Schede`.`regione`";

if("Schede"==$table && $field=="Prov") return "`Schede`.`Prov`";

if("Schede"==$table && $field=="TelAbitaz") return "`Schede`.`TelAbitaz`";

if("Schede"==$table && $field=="TelCel") return "`Schede`.`TelCel`";

if("Schede"==$table && $field=="Agenzia") return "`Schede`.`Agenzia`";

if("Schede"==$table && $field=="Telage") return "`Schede`.`Telage`";

if("Schede"==$table && $field=="TitStudio") return "`Schede`.`TitStudio`";

if("Schede"==$table && $field=="Lingue") return "`Schede`.`Lingue`";

if("Schede"==$table && $field=="Collocam") return "`Schede`.`Collocam`";

if("Schede"==$table && $field=="Enpals") return "`Schede`.`Enpals`";

if("Schede"==$table && $field=="CdFiscale") return "`Schede`.`CdFiscale`";

if("Schede"==$table && $field=="PIVA") return "`Schede`.`PIVA`";

if("Schede"==$table && $field=="RifVideo") return "`Schede`.`RifVideo`";

if("Schede"==$table && $field=="Vivere") return "`Schede`.`Vivere`";

if("Schede"==$table && $field=="RuoVivere") return "`Schede`.`RuoVivere`";

if("Schede"==$table && $field=="Teleprom") return "`Schede`.`Teleprom`";

if("Schede"==$table && $field=="RouTeleprom") return "`Schede`.`RouTeleprom`";

if("Schede"==$table && $field=="CentoVetr") return "`Schede`.`CentoVetr`";

if("Schede"==$table && $field=="RuoCentoVetr") return "`Schede`.`RuoCentoVetr`";

if("Schede"==$table && $field=="Recitaz") return "`Schede`.`Recitaz`";

if("Schede"==$table && $field=="Accento") return "`Schede`.`Accento`";

if("Schede"==$table && $field=="Altezza") return "`Schede`.`Altezza`";

if("Schede"==$table && $field=="Seno") return "`Schede`.`Seno`";

if("Schede"==$table && $field=="Vita") return "`Schede`.`Vita`";

if("Schede"==$table && $field=="Fianchi") return "`Schede`.`Fianchi`";

if("Schede"==$table && $field=="Taglia") return "`Schede`.`Taglia`";

if("Schede"==$table && $field=="Peso") return "`Schede`.`Peso`";

if("Schede"==$table && $field=="Scarpe") return "`Schede`.`Scarpe`";

if("Schede"==$table && $field=="Collo") return "`Schede`.`Collo`";

if("Schede"==$table && $field=="Aspetto") return "`Schede`.`Aspetto`";

if("Schede"==$table && $field=="MisCapelli") return "`Schede`.`MisCapelli`";

if("Schede"==$table && $field=="ColCapelli") return "`Schede`.`ColCapelli`";

if("Schede"==$table && $field=="Occhi") return "`Schede`.`Occhi`";

if("Schede"==$table && $field=="Corporat") return "`Schede`.`Corporat`";

if("Schede"==$table && $field=="Buono") return "`Schede`.`Buono`";

if("Schede"==$table && $field=="Brillante") return "`Schede`.`Brillante`";

if("Schede"==$table && $field=="Bonaccione") return "`Schede`.`Bonaccione`";

if("Schede"==$table && $field=="Sexy") return "`Schede`.`Sexy`";

if("Schede"==$table && $field=="MaterPater") return "`Schede`.`MaterPater`";

if("Schede"==$table && $field=="Sportivo") return "`Schede`.`Sportivo`";

if("Schede"==$table && $field=="Determin") return "`Schede`.`Determin`";

if("Schede"==$table && $field=="Ricco") return "`Schede`.`Ricco`";

if("Schede"==$table && $field=="Semplice") return "`Schede`.`Semplice`";

if("Schede"==$table && $field=="NotePregi") return "`Schede`.`NotePregi`";

if("Schede"==$table && $field=="Cattivo") return "`Schede`.`Cattivo`";

if("Schede"==$table && $field=="Sfigato") return "`Schede`.`Sfigato`";

if("Schede"==$table && $field=="Arrogante") return "`Schede`.`Arrogante`";

if("Schede"==$table && $field=="Opportun") return "`Schede`.`Opportun`";

if("Schede"==$table && $field=="Introverso") return "`Schede`.`Introverso`";

if("Schede"==$table && $field=="Nevrotico") return "`Schede`.`Nevrotico`";

if("Schede"==$table && $field=="Volgare") return "`Schede`.`Volgare`";

if("Schede"==$table && $field=="Elegantone") return "`Schede`.`Elegantone`";

if("Schede"==$table && $field=="Pettegolo") return "`Schede`.`Pettegolo`";

if("Schede"==$table && $field=="NoteDifetti") return "`Schede`.`NoteDifetti`";

if("Schede"==$table && $field=="Note") return "`Schede`.`Note`";

if("Schede"==$table && $field=="Registraz") return "`Schede`.`Registraz`";

if("Schede"==$table && $field=="Blocco") return "`Schede`.`Blocco`";

if("Schede"==$table && $field=="Episodio") return "`Schede`.`Episodio`";

if("Schede"==$table && $field=="MessaOnda") return "`Schede`.`MessaOnda`";

if("Schede"==$table && $field=="domindirizzo") return "`Schede`.`domindirizzo`";

if("Schede"==$table && $field=="domcitta") return "`Schede`.`domcitta`";

if("Schede"==$table && $field=="domcap") return "`Schede`.`domcap`";

if("Schede"==$table && $field=="domregione") return "`Schede`.`domregione`";

if("Schede"==$table && $field=="dompv") return "`Schede`.`dompv`";

if("Schede"==$table && $field=="domstato") return "`Schede`.`domstato`";

if("Schede"==$table && $field=="RifVideoCento") return "`Schede`.`RifVideoCento`";

if("Schede"==$table && $field=="RegistrazCento") return "`Schede`.`RegistrazCento`";

if("Schede"==$table && $field=="BloccoCento") return "`Schede`.`BloccoCento`";

if("Schede"==$table && $field=="EpisodioCento") return "`Schede`.`EpisodioCento`";

if("Schede"==$table && $field=="MessaOndaCento") return "`Schede`.`MessaOndaCento`";

if("Schede"==$table && $field=="NotePregiCento") return "`Schede`.`NotePregiCento`";

if("Schede"==$table && $field=="RifVideoTeleP") return "`Schede`.`RifVideoTeleP`";

if("Schede"==$table && $field=="RegistrazTeleP") return "`Schede`.`RegistrazTeleP`";

if("Schede"==$table && $field=="BloccoTeleP") return "`Schede`.`BloccoTeleP`";

if("Schede"==$table && $field=="MessaOndaTeleP") return "`Schede`.`MessaOndaTeleP`";

if("Schede"==$table && $field=="NotePregiTeleP") return "`Schede`.`NotePregiTeleP`";

if("Schede"==$table && $field=="EpisodioTeleP") return "`Schede`.`EpisodioTeleP`";

if("Schede"==$table && $field=="NoteAltreProduzioni") return "`Schede`.`NoteAltreProduzioni`";

if("Schede"==$table && $field=="FlagVideo") return "`Schede`.`FlagVideo`";

if("Schede"==$table && $field=="AltreProduzioni") return "`Schede`.`AltreProduzioni`";

if("Schede"==$table && $field=="Email") return "`Schede`.`Email`";

if("Schede"==$table && $field=="MID(FLOOR((NOW() - `dtnascita`)/10000),1,2)") return "`Schede`.`MID(FLOOR((NOW() - `dtnascita`)/10000),1,2)`";


This code?
Alexey admin 7/4/2006

Hi,
please modify the last line this way:

if("Schede"==$table && $field=="MID(FLOOR((NOW() - `dtnascita`)/10000),1,2)") return "MID(FLOOR((NOW() - `dtnascita`)/10000),1,2)";


You need to modify this function to be able to search for calculated and joined fields as described in PHPRunner Help:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm
A
 		albo author 7/4/2006

many thx <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=9618&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
A
 		albo author 10/24/2006

sorry wrong reply <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12089&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />