Søgning i UDU !!
Oprettet af Maya
2011-09-12 10:00:12
| Forfatter | Indlæg |
|---|---|
|
Skrevet af Maya
2011-09-12 10:00:12
|
Hvad sker der lige for almindelig SØG :blink: No valid database connection 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 'SELECT distinct person.person_id, fornavne, efternavn, PRB_persontyp' at line 3 SQL=INSERT INTO `PRB_searchlog_2` (`timestamp` ,`results` ,`searchtime`, `query`) VALUES (NOW(), '0', '0.001', SELECT distinct person.person_id, fornavne, efternavn, PRB_persontype.beskrivelse as persontype, foedselsdag as birthday, foedselsmaaned as birthmonth, foedselsaar as birthyear, foedested.foedested AS birthplace, gift as married, station.station_id, filmrulle.filmrulle_id, person.registerblad_id, station.navn as station_name, station.nummer as station_number, filmrulle.nummer as filmrulle_number, GROUP_CONCAT(stilling ORDER BY stilling ASC SEPARATOR ', ') as stillinger FROM PRB_person as person LEFT OUTER JOIN PRB_foedested as foedested ON person.foedested_id = foedested.foedested_id LEFT OUTER JOIN PRB_registerblad as registerblad ON person.registerblad_id = registerblad.registerblad_id LEFT OUTER JOIN PRB_filmrulle as filmrulle ON registerblad.filmrulle_id = filmrulle.filmrulle_id LEFT JOIN PRB_person_stilling as personstilling ON person.person_id = personstilling.person_id LEFT OUTER JOIN PRB_stilling as stilling ON personstilling.stilling_id = stilling.stilling_id LEFT JOIN PRB_station as station ON filmrulle.station_id = station.station_id LEFT JOIN PRB_persontype ON person.person_type = PRB_persontype.type WHERE fornavne LIKE '%Carlo Marius%' AND efternavn LIKE 'Madsen' GROUP BY person.person_id ORDER BY efternavn, fornavne, foedested.foedested, station_number, filmrulle_number') |
|
Skrevet af Jeppe
2011-09-12 11:46:49
|
Prøv igen. Bo har været igang ;) |
|
Skrevet af Maya
2011-09-12 13:45:51
|
Ok, mange tak. Nu Virker det igen :-) :-) |