Israel
|
| Posted: 05/02/2002, 11:41 AM |
|
I am new at using Code Charge and also new to ASP/ SQL. I usually do static
pages.
In the old Code Charge, I could make a simple grid and it worked with
sorting. When I do this in CCBeta, I get the message below when I use any
ORDER BY clause or click on the colum sort icon (which is an ORDER BY
statement.).
Where could I place a TOP statement in CCStudio?
Please help ...
Thanks
Israel (webmaster@atclubs.com)
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The ORDER BY clause is invalid in views, inline functions, derived tables,
and subqueries, unless TOP is also specified.
/testproject/Classes.asp, line 1412
|
|
|
 |
CodeCharge Support
|
| Posted: 05/02/2002, 2:38 PM |
|
Hi Israel,
We have a new newsgroup "codechargestudio.beta" for discussing CCS Beta.
Regardig your question, you can:
a) Change "Table" to "SQL" in the Data Source dialog / Data Source Type.
b) Modify generated code. CCS will then re-generate everything except the
section that you modified.
Konrad
"Israel" <webmaster@atclubs.com> wrote in message
news:aas193$qmt$1@news.codecharge.com...
> I am new at using Code Charge and also new to ASP/ SQL. I usually do
static
> pages.
>
> In the old Code Charge, I could make a simple grid and it worked with
> sorting. When I do this in CCBeta, I get the message below when I use any
> ORDER BY clause or click on the colum sort icon (which is an ORDER BY
> statement.).
>
> Where could I place a TOP statement in CCStudio?
>
> Please help ...
> Thanks
> Israel (webmaster@atclubs.com)
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> The ORDER BY clause is invalid in views, inline functions, derived tables,
> and subqueries, unless TOP is also specified.
> /testproject/Classes.asp, line 1412
>
>
>
>
>
>
|
|
|
|
Barry G. Sumpter
|
| Posted: 05/06/2002, 2:23 AM |
|
Hi Konrad,
Thanks for the effort in replying to all these questions.
I tried a) which keeps the page from erroring.
but the grid will not sort.
Any hints?
Thanks,
baz
"CodeCharge Support" <support@codecharge.com> wrote in message
news:aasblb$er8$1@news.codecharge.com...
> Hi Israel,
>
> We have a new newsgroup "codechargestudio.beta" for discussing CCS Beta.
> Regardig your question, you can:
> a) Change "Table" to "SQL" in the Data Source dialog / Data Source Type.
> b) Modify generated code. CCS will then re-generate everything except the
> section that you modified.
>
> Konrad
>
>
> "Israel" <webmaster@atclubs.com> wrote in message
>news:aas193$qmt$1@news.codecharge.com...
> > I am new at using Code Charge and also new to ASP/ SQL. I usually do
> static
> > pages.
> >
> > In the old Code Charge, I could make a simple grid and it worked with
> > sorting. When I do this in CCBeta, I get the message below when I use
any
> > ORDER BY clause or click on the colum sort icon (which is an ORDER BY
> > statement.).
> >
> > Where could I place a TOP statement in CCStudio?
> >
> > Please help ...
> > Thanks
> > Israel (webmaster@atclubs.com)
> >
> > Error Type:
> > Microsoft OLE DB Provider for SQL Server (0x80040E14)
> > The ORDER BY clause is invalid in views, inline functions, derived
tables,
> > and subqueries, unless TOP is also specified.
> > /testproject/Classes.asp, line 1412
> >
> >
> >
> >
> >
> >
>
>
|
|
|
|
|
