re: Custom Query Size Limit in FP 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jim Buyens (news_at_interlacken.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 14:46:56 -0800

>-----Original Message-----
>FP 2000 seems to have a size limit on placing large SQL
>Statements into the Custom Query box in the Database
>Results wizard.
>
>Anyway around this?

Define as much of the query as possible within the
database, and then use a simpler SQL statement in the DRW.

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: Help with SQL please
    ... Rerun the DRW, leave the SQL as is, and on page 3, click ... Microsoft FrontPage MVP ... >statement it produces a database error What am I doing ...
    (microsoft.public.frontpage.client)
  • re: data view web part with custom query
    ... Microsoft FrontPage MVP ... >I would like to call an Oracle stored procedure from the ... >database has returned an unexpected result" or some such. ...
    (microsoft.public.frontpage.programming)
  • re: Display database results as form field objects!
    ... require some knowledge of Visual Basic, SQL, ActiveX Data ... create drop-down boxes filled with values from a database. ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Custom Query Size Limit in FP 2000
    ... FP 2000 seems to have a size limit on placing large SQL ... Statements into the Custom Query box in the Database ... Results wizard. ...
    (microsoft.public.frontpage.client)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)