Forum » Izdelava spletišč » Invalid SQL
Invalid SQL
Hammer ::
tole mi napiše:
Invalid SQL:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(, , , , , , , , 6))
ORDER BY displayorder ASC
mysql error: 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 ' , , , , , , , 6))
ORDER BY displayorder ASC' at line 3
mysql error number: 1064
Kako to popravit ?
LP, hammer
Invalid SQL:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(, , , , , , , , 6))
ORDER BY displayorder ASC
mysql error: 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 ' , , , , , , , 6))
ORDER BY displayorder ASC' at line 3
mysql error number: 1064
Kako to popravit ?
LP, hammer
arch5 ::
sej ti piše
tole: (, , , , , , , , 6) ga moti nadomesti z (6) tako da bo usergroupid IN(6) ali pa usergroupid =6
tole: (, , , , , , , , 6) ga moti nadomesti z (6) tako da bo usergroupid IN(6) ali pa usergroupid =6
Vredno ogleda ...
Tema | Ogledi | Zadnje sporočilo | |
---|---|---|---|
Tema | Ogledi | Zadnje sporočilo | |
» | problem pri sprembi root gesla v MySQL v UbuntuOddelek: Pomoč in nasveti | 1287 (867) | killa bee |
» | MySQL BETWEEN dates?Oddelek: Programiranje | 1408 (1322) | Housy |
» | SQL problemOddelek: Programiranje | 1536 (1373) | Bossek |
» | mysql vprasanje (update)Oddelek: Programiranje | 1082 (992) | MUC |
» | easy way za odštevat datumeOddelek: Izdelava spletišč | 1015 (905) | Uporabnik |