re: data view web part with custom query

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

  • Next message: Yiu Yan: "Re: Hide my E-mail address on form" 
    Date: Sat, 29 May 2004 20:08:21 -0700

    Try accessing the data by means of a view rather than a
    stored procedure.

    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)
    |/---------------------------------------------------
    *----------------------------------------------------

    >-----Original Message-----
    >I would like to call an Oracle stored procedure from the
    Custom Query of a
    >Data View Web Part
    >(The query i wish to run has a join, so i can't just
    specify rows and
    >filters)
    >I have tried entering the SP name and "execute sp_name")
    but just get "the
    >database has returned an unexpected result" or some such.
    >The SP executes fine in an Oracle environment, and the
    database is reachable
    >(albeit one table at a time) in the data vies.
    >
    >What am I missing?
    >
    >
    >.
    >

  • Next message: Yiu Yan: "Re: Hide my E-mail address on form"

    Relevant Pages

    • re: Custom Query Size Limit in FP 2000
      ... >Statements into the Custom Query box in the Database ... database, and then use a simpler SQL statement in the DRW. ... Microsoft FrontPage MVP ...
      (microsoft.public.frontpage.client)
    • re: Stopping duplicate data entries
      ... There are error traps but it doesn't seem to effect the way Access hands off the error. ... Saving Form Data in a Database ... Microsoft FrontPage MVP ... >Is there a way to stop duplicate entries that are being ...
      (microsoft.public.frontpage.client)
    • Re: Date Range filtering trouble
      ... Please don't make duplicate posts, or ask the same question via ... As to the invalid date syntax, yes, if you ask the database to perform ... Microsoft FrontPage MVP ... > order to filter the ...
      (microsoft.public.frontpage.client)
    • Re: Problem with form validation
      ... I can't reproduce your entire setup because I don't have the ... To turn on script debugging in IE, choose Tools, Internet Options, ... Microsoft FrontPage MVP ... > is the end of a Database Results ...
      (microsoft.public.frontpage.client)
    • re: Source Control or something else?
      ... Diagnosing Errors Saving a Form to a Database ... Microsoft FrontPage MVP ... >>Administration Home) to ensure the settings were how I ... >Server that need to be in place. ...
      (microsoft.public.frontpage.client)