Michael Wesner
|
Posted: 04/24/2002, 10:35 AM |
|
CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This causes an error
in all MySQL versions.
It is the "[" and the "]" which will work fine with the MSSQL server but not
with MySQL.
(I used the Portal example)
Michael
|
|
|
Oleg Dudko
|
Posted: 04/24/2002, 10:50 AM |
|
Michael,
Did you set "MySQL" database for connection?
Thanks,
Oleg
"Michael Wesner" <m.wesner@gmx.de> wrote in message
news:aa6qct$hla$1@news.codecharge.com...
> CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This causes an
error
> in all MySQL versions.
> It is the "[" and the "]" which will work fine with the MSSQL server but
not
> with MySQL.
>
> (I used the Portal example)
>
> Michael
>
>
|
|
|
Michael Wesner
|
Posted: 04/24/2002, 10:54 AM |
|
Of course I did select MySql! Else CCS wouldn't output the db_mysql.php
file.
"Oleg Dudko" <oleg.dudko@yessoftware.com> schrieb im Newsbeitrag
news:aa6r8e$jil$1@news.codecharge.com...
> Michael,
>
> Did you set "MySQL" database for connection?
>
> Thanks,
> Oleg
>
> "Michael Wesner" <m.wesner@gmx.de> wrote in message
>news:aa6qct$hla$1@news.codecharge.com...
> > CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This causes an
> error
> > in all MySQL versions.
> > It is the "[" and the "]" which will work fine with the MSSQL server but
> not
> > with MySQL.
> >
> > (I used the Portal example)
> >
> > Michael
> >
> >
>
>
|
|
|
Oleg Dudko
|
Posted: 04/24/2002, 11:13 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_006F_01C1EBD4.FEE5ED40
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
Michael,
I just tried to repeat but couldn't.
Please
1. Right click on Connection and select "Edit"
2. Then set "MySQL" for
"Design" Tab / "Database" Property
"Server" Tab / "PHP Database Library" Property
3. Publish Project again
Thanks,
Oleg
> Of course I did select MySql! Else CCS wouldn't output the =
db_mysql.php file.
>=20
> > Did you set "MySQL" database for connection?
> >
> > > CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This =
causes an error
> > > in all MySQL versions.
> > > It is the "[" and the "]" which will work fine with the MSSQL =
server but not with MySQL.
> > >
> > > (I used the Portal example)
> > >
> > > Michael
------=_NextPart_000_006F_01C1EBD4.FEE5ED40
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Michael,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I just tried to repeat but =
couldn't.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1. Right click on Connection and select =
"Edit"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2. Then set "MySQL" for</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Design" Tab / "Database"=20
Property</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Server" Tab / "PHP Database Library"=20
Property</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3. Publish Project again</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Oleg</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV><FONT face=3DArial =
size=3D2>> Of=20
course I did select MySql! Else CCS wouldn't output the db_mysql.php=20
file.<BR>> <BR></FONT><FONT face=3DArial size=3D2>> > Did you =
set "MySQL"=20
database for connection?<BR>> ><BR></FONT><FONT face=3DArial =
size=3D2>>=20
> > CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This =
causes=20
an error<BR>> > > in all MySQL versions.<BR>> > > =
It is=20
the "[" and the "]" which will work fine with the MSSQL server but not=20
with MySQL.<BR>> > ><BR>> > > (I used the Portal =
example)<BR>> > ><BR>> > > =
Michael</FONT></BODY></HTML>
------=_NextPart_000_006F_01C1EBD4.FEE5ED40--
|
|
|
Michael Wesner
|
Posted: 04/24/2002, 11:22 AM |
|
Sorry! This works (selecting MySql in both tabs) - but I still dont
understand.
I use the Access file in Design time therefore I selected Access for
"Design" and MySQL for "Server" why is that wrong?
thx
Michael
"Oleg Dudko" <oleg.dudko@yessoftware.com> schrieb im Newsbeitrag
news:aa6sku$mcd$1@news.codecharge.com...
Michael,
I just tried to repeat but couldn't.
Please
1. Right click on Connection and select "Edit"
2. Then set "MySQL" for
"Design" Tab / "Database" Property
"Server" Tab / "PHP Database Library" Property
3. Publish Project again
Thanks,
Oleg
> Of course I did select MySql! Else CCS wouldn't output the db_mysql.php
file.
>
> > Did you set "MySQL" database for connection?
> >
> > > CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This causes an
error
> > > in all MySQL versions.
> > > It is the "[" and the "]" which will work fine with the MSSQL server
but not with MySQL.
> > >
> > > (I used the Portal example)
> > >
> > > Michael
|
|
|
Alexey Alexapolsky
|
Posted: 04/26/2002, 8:46 AM |
|
It all ok. Considered it a feature that will be fixed soon.
--
Alex
CodeCharge Developer
"Michael Wesner" <m.wesner@gmx.de> wrote in message
news:aa6t62$nhi$1@news.codecharge.com...
> Sorry! This works (selecting MySql in both tabs) - but I still dont
> understand.
> I use the Access file in Design time therefore I selected Access for
> "Design" and MySQL for "Server" why is that wrong?
>
> thx
> Michael
>
>
>
> "Oleg Dudko" <oleg.dudko@yessoftware.com> schrieb im Newsbeitrag
>news:aa6sku$mcd$1@news.codecharge.com...
> Michael,
>
> I just tried to repeat but couldn't.
>
> Please
> 1. Right click on Connection and select "Edit"
> 2. Then set "MySQL" for
> "Design" Tab / "Database" Property
> "Server" Tab / "PHP Database Library" Property
> 3. Publish Project again
>
> Thanks,
> Oleg
>
> > Of course I did select MySql! Else CCS wouldn't output the db_mysql.php
> file.
> >
> > > Did you set "MySQL" database for connection?
> > >
> > > > CCS outputs sql strings like "SELECT a,b, FROM [tab1]". This causes
an
> error
> > > > in all MySQL versions.
> > > > It is the "[" and the "]" which will work fine with the MSSQL server
> but not with MySQL.
> > > >
> > > > (I used the Portal example)
> > > >
> > > > Michael
>
>
|
|
|
|