R Sens
|
| Posted: 09/23/2002, 2:04 AM |
|
Hello,
I've got a problem with every SQL statement generated by CCS.
For example 'Select 'Login','Password' from userlogin.....
Each fieldname is embedded in '', which creates a syntax error during
runtime. These '' shouldn't be there. Anyone having the same problems of is
there a solution somewhere. I'm using PHP4 + templates.
Thank you,
Ron
|
|
|
 |
Sixto Luis Santos
|
| Posted: 09/23/2002, 5:58 AM |
|
Hello Ron,
CCS is not to blame here, but your MySQL version. If within your power, you
should upgrade your MySQL server to a newer version (http://www.mysql.com).
Other options are to either do a global search and replace with a good text
editor (low risk as the ` character is seldom used), or to modify MySQL.xml
under \Program Files\CodeChargeStudio\Components\Databases\. (and this i do
not recommend, but if you do it anyway, you do under your own risk)
In MySQL.xml locate:
fieldLeftDelim="`"
fieldRightDelim="`"
And change to:
fieldLeftDelim=""
fieldRightDelim=""
As always, make a copy of the original MySQL.xml file before you begin.
After saving the modified file, restart CCS, reload your project and regen.
Good luck,
Sixto
"R Sens" <info@sensoft.nl> wrote in message
news:ammlfd$vqf$1@news.codecharge.com...
> Hello,
>
> I've got a problem with every SQL statement generated by CCS.
>
> For example 'Select 'Login','Password' from userlogin.....
>
> Each fieldname is embedded in '', which creates a syntax error during
> runtime. These '' shouldn't be there. Anyone having the same problems of
is
> there a solution somewhere. I'm using PHP4 + templates.
>
> Thank you,
>
> Ron
>
>
|
|
|
|
R Sens
|
| Posted: 09/23/2002, 7:08 AM |
|
Thank you, that was exactly what I was looking for.
Upgrading MySQL is also an option, as we are using our own webserver. But
for the moment changing the XML was enough.
Ron
"Sixto Luis Santos" <sixto@tecnoapoyo.com> wrote in message
news:amn355$oh0$1@news.codecharge.com...
> Hello Ron,
>
> CCS is not to blame here, but your MySQL version. If within your power,
you
> should upgrade your MySQL server to a newer version
(http://www.mysql.com).
> Other options are to either do a global search and replace with a good
text
> editor (low risk as the ` character is seldom used), or to modify
MySQL.xml
> under \Program Files\CodeChargeStudio\Components\Databases\. (and this i
do
> not recommend, but if you do it anyway, you do under your own risk)
>
> In MySQL.xml locate:
>
> fieldLeftDelim="`"
> fieldRightDelim="`"
>
> And change to:
>
> fieldLeftDelim=""
> fieldRightDelim=""
>
> As always, make a copy of the original MySQL.xml file before you begin.
>
> After saving the modified file, restart CCS, reload your project and
regen.
>
> Good luck,
> Sixto
>
> "R Sens" <info@sensoft.nl> wrote in message
>news:ammlfd$vqf$1@news.codecharge.com...
> > Hello,
> >
> > I've got a problem with every SQL statement generated by CCS.
> >
> > For example 'Select 'Login','Password' from userlogin.....
> >
> > Each fieldname is embedded in '', which creates a syntax error during
> > runtime. These '' shouldn't be there. Anyone having the same problems of
> is
> > there a solution somewhere. I'm using PHP4 + templates.
> >
> > Thank you,
> >
> > Ron
> >
> >
>
>
|
|
|
|
|
