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 | 1437 (1017) | killa bee |
| » | MySQL BETWEEN dates?Oddelek: Programiranje | 1556 (1470) | Housy |
| » | SQL problemOddelek: Programiranje | 1673 (1510) | Bossek |
| » | mysql vprasanje (update)Oddelek: Programiranje | 1159 (1069) | MUC |
| » | easy way za odštevat datumeOddelek: Izdelava spletišč | 1119 (1009) | Uporabnik |