Problems with Recordset (Query) in Dreamweaver BindingsPanel

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Problems with Recordset (Query) in Dreamweaver BindingsPanel

    Coldfusion Gurus-

    I keep getting this error when I try to make a connection to my database using
    the Dreamweaver Bindings Panel:

    "There are no functions containing returntype='query' and access='public'
    attributes defined within current selected component."

    However, this is not true! Here is the component I'm trying to access and you
    will see these ARE in fact defined:

    <cfcomponent>

    <cffunction name="List" access="public" returnType="query" output="false">
    <!--- Get Movie List From Database --->
    <cfquery name="movies" datasource="ows">
    SELECT FilmID, MovieTitle, PitchText, Summary, DateInTheaters
    FROM Films
    ORDER BY MovieTitle
    </cfquery>
    <cfreturn movies>
    </cffunction>


    <cffunction name="GetDetails" access="public" returnType="query"
    output="false">
    <cfargument name="FilmID" type="numeric" required="true">
    <!--- Get a Movie From Datasource --->
    <cfquery name="movie" datasource="ows">
    SELECT FilmID, MovieTitle, PitchText, Summary, DateInTheaters, AmountBudgeted
    FROM Films
    WHERE FilmID=#ARGUMENTS.FilmID#
    </cfquery>
    <cfreturn movie>
    </cffunction>

    </cfcomponent>

    So what am I haveing this problem? WHat can I do to recitify it? I have the
    Coldfusion Extension installed on Dreamweaver, and am relatively new to this
    program, and have went down every avenue I know to rectify this with no
    results! Please help me as I am totally lost!

    Thanks!
    Chuck

    ChuckRWD Guest

  2. Similar Questions and Discussions

    1. Dreamweaver recordset, selecting table
      In Dreamweaver 8, when I go to set up a recordset, in the recordset dialog box, the "table" dropdown box indicates a path to the table in the...
    2. Complicated "CASE WHEN" query for Dreamweaver Recordset
      Hello, I have a table called "categories_ctg" with the following fields: id_ctg, int(11), auto_increment idctg_ctg, int(11)(can be NULL)...
    3. ASP/SQL Query Recordset up to 200 characters?
      Is it possible through SQL to query a recordest lets say a memo description feild for lets say only the first 200 characters? Or To somehow...
    4. Why Dreamweaver edit the Recordset will show thiserror?
      In your Connection file, change MM_Habook_STRING = 'dsn=Habook;' to MM_Habook_STRING = 'dsn=Habook;un=; pw=' Where the username and password have...
    5. PHP & Simple Recordset Query
      Why can't I open the simple dialog box on recordset queries with PHP? It works with ASP but I can open a blank PHP page in a Blank site and still get...
  3. #2

    Default Re: Problems with Recordset (Query) in DreamweaverBindings Panel

    Also, with the above Component, when I look at the two functions in the
    Bindings Panel, it says" Connection not defined (ows). When I run my template
    though, it works great! This is right out of a Macromedia Book called
    "Coldfusion MX7, Web Application Construction Kit". What am I doing wrong or
    not doing to make this run?

    ChuckRWD Guest

  4. #3

    Default Re: Problems with Recordset (Query) in DreamweaverBindings Panel

    I figured it out. In the Bindings Panel when you're looking at your component
    page, if a connection isn't made, make sure that the Database is
    CASE-SENSITIVE. My database was listed as "OWS", but I wrote, "ows", therefore
    it would not work. Once I made this change, everything worked great!

    ChuckRWD Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139