just feel idiot
|
| Posted: 08/30/2002, 5:03 AM |
|
Database error: Invalid SQL: SELECT COUNT(*) FROM (ILANarsa LEFT JOIN ILANkategori ON ILANarsa.kategori_NO = ILANkategori.kategori_NO) LEFT JOIN ILANverenler ON ILANarsa.ilanveren_NO = ILANverenler.ilanveren_NO WHERE `kategori_NO` = 1
MySQL Error: 1064 (You have an error in your SQL syntax near '`kategori_NO` = 1' at line 1)
Session halted.
i try to make a search, im doing everything same as in the tutorial, but going to think that something wrong with "visual qery builder" in CCS...
someone please HELP HELP HELP!!!!
|
|
|
 |
Nicole
|
| Posted: 08/30/2002, 6:00 AM |
|
Hello,
looks like MySQL version you're using doesn't accept quotes that are surround field name.
You can disable the single quotes by editing the file ..CodeChargeStudio\Components\Databases\MySQL.xml file. Find the
lines:
fieldLeftDelim="`"
fieldRightDelim="`"
and remove delimiter symbol so that they become:
fieldLeftDelim=""
fieldRightDelim=""
It is CCS feature that was added in CCS1.0.7. The quotes are added as fields delimiters. It was made in order to let users use e.g. reserve words as field names or use spaces in field names.
|
|
|
|
just feel idiot
|
| Posted: 08/30/2002, 6:12 AM |
|
if it works , i ll be very happy, thanks nicole
erdem
|
|
|
|
|
