WebGuy
|
| Posted: 05/02/2002, 6:09 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.).
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/02/2002, 1:23 PM |
|
Hi WebGuy,
No Solution Here.
I am also getting this message using a SQl Serve Databasase.
I just havn't had time to chase this down.
I've stopped using the Order by: option in any of the wizards for now. And
don't use the dynamic column sort hyperlink at the top of the columns.
I believe there is a tick box somewhere which specifies weather I want the
dynamic column sort hyperlink built on my asp pages. I just have to find
out where it is.
Perhaps in the tutorial page 30: Define Grid Sorting and Navigation |
SOrting: No Sorting (Tick Box)
However, I would like to know how to use the dynamic column sort hyperlink
with SQL Server instead of excluding it.
I'll have to sort out the TOP caluse soon, as well.
baz
"WebGuy" <webmaster@atclubs.com> wrote in message
news:aardqi$k9e$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.).
>
> 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
>
>
|
|
|
|
Israel
|
| Posted: 05/02/2002, 2:15 PM |
|
Well ... I have made a discovery myself. I can create a dynamic table and
have the colum sort just fine until I add the record navigation form. It's
strange. ... If I then delete the page navigation form ... the "TOP problems
appears no more. ...????
I'm a newbie, so it's ALL a learning process : )
Thanks
Israel
"Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
news:aas77u$68g$1@news.codecharge.com...
> Hi WebGuy,
>
> No Solution Here.
>
> I am also getting this message using a SQl Serve Databasase.
> I just havn't had time to chase this down.
> I've stopped using the Order by: option in any of the wizards for now.
And
> don't use the dynamic column sort hyperlink at the top of the columns.
> I believe there is a tick box somewhere which specifies weather I want the
> dynamic column sort hyperlink built on my asp pages. I just have to find
> out where it is.
>
> Perhaps in the tutorial page 30: Define Grid Sorting and Navigation |
> SOrting: No Sorting (Tick Box)
>
> However, I would like to know how to use the dynamic column sort hyperlink
> with SQL Server instead of excluding it.
>
> I'll have to sort out the TOP caluse soon, as well.
>
>
> baz
>
>
>
> "WebGuy" <webmaster@atclubs.com> wrote in message
>news:aardqi$k9e$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.).
> >
> > 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/03/2002, 11:12 PM |
|
Hi Israel,
Could give us a point by point instruction as to how you did this?
Thanks,
Baz
"Israel" <webmaster@atclubs.com> wrote in message
news:aasa9l$c74$1@news.codecharge.com...
> Well ... I have made a discovery myself. I can create a dynamic table and
> have the colum sort just fine until I add the record navigation form. It's
> strange. ... If I then delete the page navigation form ... the "TOP
problems
> appears no more. ...????
>
> I'm a newbie, so it's ALL a learning process : )
> Thanks
> Israel
>
>
> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>news:aas77u$68g$1@news.codecharge.com...
> > Hi WebGuy,
> >
> > No Solution Here.
> >
> > I am also getting this message using a SQl Serve Databasase.
> > I just havn't had time to chase this down.
> > I've stopped using the Order by: option in any of the wizards for now.
> And
> > don't use the dynamic column sort hyperlink at the top of the columns.
> > I believe there is a tick box somewhere which specifies weather I want
the
> > dynamic column sort hyperlink built on my asp pages. I just have to
find
> > out where it is.
> >
> > Perhaps in the tutorial page 30: Define Grid Sorting and Navigation |
> > SOrting: No Sorting (Tick Box)
> >
> > However, I would like to know how to use the dynamic column sort
hyperlink
> > with SQL Server instead of excluding it.
> >
> > I'll have to sort out the TOP caluse soon, as well.
> >
> >
> > baz
> >
> >
> >
> > "WebGuy" <webmaster@atclubs.com> wrote in message
> >news:aardqi$k9e$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.).
> > >
> > > 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
> > >
> > >
> >
> >
>
>
|
|
|
|
Morten Brun
|
| Posted: 05/05/2002, 6:37 PM |
|
I get the same error when trying to click on the sort label on the
grid. Using SQL server. A solution will be much appreciated.
Morten
"Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote:
>Hi Israel,
> Could give us a point by point instruction as to how you did this?
>Thanks,
> Baz
>
>"Israel" <webmaster@atclubs.com> wrote in message
>news:aasa9l$c74$1@news.codecharge.com...
>> Well ... I have made a discovery myself. I can create a dynamic table and
>> have the colum sort just fine until I add the record navigation form. It's
>> strange. ... If I then delete the page navigation form ... the "TOP
>problems
>> appears no more. ...????
>>
>> I'm a newbie, so it's ALL a learning process : )
>> Thanks
>> Israel
>>
>>
>> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>>news:aas77u$68g$1@news.codecharge.com...
>> > Hi WebGuy,
>> >
>> > No Solution Here.
>> >
>> > I am also getting this message using a SQl Serve Databasase.
>> > I just havn't had time to chase this down.
>> > I've stopped using the Order by: option in any of the wizards for now.
>> And
>> > don't use the dynamic column sort hyperlink at the top of the columns.
>> > I believe there is a tick box somewhere which specifies weather I want
>the
>> > dynamic column sort hyperlink built on my asp pages. I just have to
>find
>> > out where it is.
>> >
>> > Perhaps in the tutorial page 30: Define Grid Sorting and Navigation |
>> > SOrting: No Sorting (Tick Box)
>> >
>> > However, I would like to know how to use the dynamic column sort
>hyperlink
>> > with SQL Server instead of excluding it.
>> >
>> > I'll have to sort out the TOP caluse soon, as well.
>> >
>> >
>> > baz
>> >
>> >
>> >
>> > "WebGuy" <webmaster@atclubs.com> wrote in message
>> >news:aardqi$k9e$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.).
>> > >
>> > > 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
>> > >
>> > >
>> >
>> >
>>
>>
>
|
|
|
|
Morten Brun
|
| Posted: 05/05/2002, 6:49 PM |
|
Here is the details:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
An ORDER BY clause is invalid in views, derived tables, and subqueries
unless TOP is also specified.
/CitiLinks/admin/Classes.asp, line 1412
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705)
Page:
GET /CitiLinks/admin/CitiLinksC_list.asp
Morten Brun <morb@novonordisk.com> wrote:
>I get the same error when trying to click on the sort label on the
>grid. Using SQL server. A solution will be much appreciated.
>
>Morten
>
>
>
>"Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote:
>
>>Hi Israel,
>> Could give us a point by point instruction as to how you did this?
>>Thanks,
>> Baz
>>
>>"Israel" <webmaster@atclubs.com> wrote in message
>>news:aasa9l$c74$1@news.codecharge.com...
>>> Well ... I have made a discovery myself. I can create a dynamic table and
>>> have the colum sort just fine until I add the record navigation form. It's
>>> strange. ... If I then delete the page navigation form ... the "TOP
>>problems
>>> appears no more. ...????
>>>
>>> I'm a newbie, so it's ALL a learning process : )
>>> Thanks
>>> Israel
>>>
>>>
>>> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>>>news:aas77u$68g$1@news.codecharge.com...
>>> > Hi WebGuy,
>>> >
>>> > No Solution Here.
>>> >
>>> > I am also getting this message using a SQl Serve Databasase.
>>> > I just havn't had time to chase this down.
>>> > I've stopped using the Order by: option in any of the wizards for now.
>>> And
>>> > don't use the dynamic column sort hyperlink at the top of the columns.
>>> > I believe there is a tick box somewhere which specifies weather I want
>>the
>>> > dynamic column sort hyperlink built on my asp pages. I just have to
>>find
>>> > out where it is.
>>> >
>>> > Perhaps in the tutorial page 30: Define Grid Sorting and Navigation |
>>> > SOrting: No Sorting (Tick Box)
>>> >
>>> > However, I would like to know how to use the dynamic column sort
>>hyperlink
>>> > with SQL Server instead of excluding it.
>>> >
>>> > I'll have to sort out the TOP caluse soon, as well.
>>> >
>>> >
>>> > baz
>>> >
>>> >
>>> >
>>> > "WebGuy" <webmaster@atclubs.com> wrote in message
>>> >news:aardqi$k9e$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.).
>>> > >
>>> > > 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
>>> > >
>>> > >
>>> >
>>> >
>>>
>>>
>>
|
|
|
|
|
