re: Custom querys - ORDER BY clause?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Buyens (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 13:49:30 -0800

>-----Original Message-----
>FP2002. I used the database results wizard to create a
>simple asp page with a seach form and parameters that
>queries an Access2002 db. I run successfully. When I
>try to add a sort by parameter for dynamic sorting (ORDER
>BY ::SortColumn:: ASC) the "verify query" test is
>successful but runtime viewing produces a "The operation
>failed. If this continues, please contact your server
>administrator" error.
>What am I doing wrong with the ORDER BY clause?

Are you sure that you have a form field named SortColumn,
and that its value is that of a column in your query?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

Relevant Pages

  • Re: DataAdapter.Update
    ... If it's successful, call ... I begin a transaction on my connection and attempt to update ... rows as one transaction to the database. ... now I rectify my second row in order to rectify ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: CompanyWeb Broken
    ... The psconfig utility, which gets run after Sharepoint updates, failed to complete for some reason. ... Total number of successful configuration settings: ... Remove the content database from Manage ... >> Installation status: Successful ...
    (microsoft.public.windows.server.sbs)
  • Re: Warning: supposed "lisp video" is an anti-lisp troll
    ... putting constraints into your database takes away from flexibility. ... but were running the very real risk of being ... produce a marketable product. ... Still, they have been successful for about 20 years, ...
    (comp.lang.lisp)
  • Re: WORD XP MAIL-MERGE - FAILS - USING ACCESS QUERY
    ... They changed the method used to connect to an Access database in Word ... > So it is somehow Word not reading the Query successfully I guess. ... > "old" successful mail-merge is that if I look at the Mail-merge ...
    (microsoft.public.word.application.errors)
  • Custom querys - ORDER BY clause?
    ... simple asp page with a seach form and parameters that ... queries an Access2002 db. ... successful but runtime viewing produces a "The operation ...
    (microsoft.public.frontpage.programming)