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 | 1417 (997) | killa bee |
| » | MySQL BETWEEN dates?Oddelek: Programiranje | 1535 (1449) | Housy |
| » | SQL problemOddelek: Programiranje | 1657 (1494) | Bossek |
| » | mysql vprasanje (update)Oddelek: Programiranje | 1152 (1062) | MUC |
| » | easy way za odštevat datumeOddelek: Izdelava spletišč | 1103 (993) | Uporabnik |