Jan K. van Dalen
|
| Posted: 04/24/2002, 9:26 PM |
|
Hi Everyone,
I'm using SQL Anywhere 5.5 and it seems that the code generated is not
correct. This is the error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Sybase][ODBC Driver]Syntax error: near 'SELECT' in ...Count(*) FROM
([SELECT] * FROM Carrier)...
/cctest3/Classes.asp, line 1412
Any ideas?
I tried selecting several of the "Database Type" with no luck.
|
|
|
 |
Jan K. van Dalen
|
| Posted: 04/25/2002, 12:21 PM |
|
I guess I'm the only one with this problem?
"Jan K. van Dalen" <vandalen@mindspring.com> wrote in message
news:aa80he$qe0$1@news.codecharge.com...
> Hi Everyone,
>
> I'm using SQL Anywhere 5.5 and it seems that the code generated is not
> correct. This is the error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Sybase][ODBC Driver]Syntax error: near 'SELECT' in ...Count(*) FROM
> ([SELECT] * FROM Carrier)...
> /cctest3/Classes.asp, line 1412
>
> Any ideas?
>
> I tried selecting several of the "Database Type" with no luck.
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 04/26/2002, 4:26 AM |
|
Please check if there is ORDER BY clause in your subselect statement ,
if so, most probably your db does not support ORDER BY in subselects.
We are working on this issue.
Currently this can be worked around by modifing SQL in Classes.asp.
--
Alex
CodeCharge Developer
"Jan K. van Dalen" <vandalen@mindspring.com> wrote in message
news:aa9kvh$13f$1@news.codecharge.com...
> I guess I'm the only one with this problem?
>
> "Jan K. van Dalen" <vandalen@mindspring.com> wrote in message
>news:aa80he$qe0$1@news.codecharge.com...
> > Hi Everyone,
> >
> > I'm using SQL Anywhere 5.5 and it seems that the code generated is not
> > correct. This is the error:
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> > [Sybase][ODBC Driver]Syntax error: near 'SELECT' in ...Count(*) FROM
> > ([SELECT] * FROM Carrier)...
> > /cctest3/Classes.asp, line 1412
> >
> > Any ideas?
> >
> > I tried selecting several of the "Database Type" with no luck.
> >
> >
>
>
|
|
|
|
Jan K. van Dalen
|
| Posted: 04/26/2002, 9:14 AM |
|
Hi Alexey,
No order by specified.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:aabdhi$k9o$2@news.codecharge.com...
> Please check if there is ORDER BY clause in your subselect statement ,
> if so, most probably your db does not support ORDER BY in subselects.
> We are working on this issue.
> Currently this can be worked around by modifing SQL in Classes.asp.
>
>
> --
> Alex
> CodeCharge Developer
>
>
> "Jan K. van Dalen" <vandalen@mindspring.com> wrote in message
>news:aa9kvh$13f$1@news.codecharge.com...
> > I guess I'm the only one with this problem?
> >
> > "Jan K. van Dalen" <vandalen@mindspring.com> wrote in message
> >news:aa80he$qe0$1@news.codecharge.com...
> > > Hi Everyone,
> > >
> > > I'm using SQL Anywhere 5.5 and it seems that the code generated is not
> > > correct. This is the error:
> > >
> > > Error Type:
> > > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> > > [Sybase][ODBC Driver]Syntax error: near 'SELECT' in ...Count(*) FROM
> > > ([SELECT] * FROM Carrier)...
> > > /cctest3/Classes.asp, line 1412
> > >
> > > Any ideas?
> > >
> > > I tried selecting several of the "Database Type" with no luck.
> > >
> > >
> >
> >
>
>
|
|
|
|
RonB
|
| Posted: 04/29/2002, 6:40 AM |
|
Same here. It happens to me when I use the wizard to generate a set of
pages. If I build the pages myself the problem does not occur. I use PHP.
Ron Borkent
"Jan K. van Dalen" <vandalen@mindspring.com> schreef in bericht
news:aa80he$qe0$1@news.codecharge.com...
> Hi Everyone,
>
> I'm using SQL Anywhere 5.5 and it seems that the code generated is not
> correct. This is the error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Sybase][ODBC Driver]Syntax error: near 'SELECT' in ...Count(*) FROM
> ([SELECT] * FROM Carrier)...
> /cctest3/Classes.asp, line 1412
>
> Any ideas?
>
> I tried selecting several of the "Database Type" with no luck.
>
>
|
|
|
|
Jan K. van Dalen
|
| Posted: 04/29/2002, 1:14 PM |
|
Yes, I created the form using the Wizard. I have not tried doing it
manually. I did not think I could do a better job<g>
"RonB" <r.borkent@123chello.nl> wrote in message
news:aajih0$2vl$1@news.codecharge.com...
> Same here. It happens to me when I use the wizard to generate a set of
> pages. If I build the pages myself the problem does not occur. I use PHP.
>
> Ron Borkent
>
>
> "Jan K. van Dalen" <vandalen@mindspring.com> schreef in bericht
>news:aa80he$qe0$1@news.codecharge.com...
> > Hi Everyone,
> >
> > I'm using SQL Anywhere 5.5 and it seems that the code generated is not
> > correct. This is the error:
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> > [Sybase][ODBC Driver]Syntax error: near 'SELECT' in ...Count(*) FROM
> > ([SELECT] * FROM Carrier)...
> > /cctest3/Classes.asp, line 1412
> >
> > Any ideas?
> >
> > I tried selecting several of the "Database Type" with no luck.
> >
> >
>
>
|
|
|
|
|
