Barry G. Sumpter
|
| Posted: 05/06/2002, 2:25 AM |
|
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
>
>
>
>
>
>
|
|
|
 |
Dave Rexel
|
| Posted: 05/06/2002, 2:07 PM |
|
This is very strange
- The sender of the reply is shown as Barry G
- but the reply to Israel is signed Konrad
Barry G are you Konrad?
I assumed that Konrad is CC personnel
Just wondering
"Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
news:ab5i63$cj8$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
> >
> >
> >
> >
> >
> >
>
>
>
>
|
|
|
|
Dave Rexel
|
| Posted: 05/06/2002, 2:10 PM |
|
Ahh, I found the thread on the CC NG
The fog clears
"Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
news:ab6r9v$qsk$1@news.codecharge.com...
> This is very strange
> - The sender of the reply is shown as Barry G
> - but the reply to Israel is signed Konrad
> Barry G are you Konrad?
> I assumed that Konrad is CC personnel
> Just wondering
>
>
> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>news:ab5i63$cj8$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
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
|
|
|
|
|
