SELECT FilmID, MovieTitle, PitchText, Summary, DateInTheaters FROM Films ORDER BY MovieTitle SELECT FilmID, MovieTitle, PitchText, Summary, DateInTheaters, AmountBudgeted FROM Films WHERE FilmID=#ARGUMENTS.FilmID# 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 [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => ChuckRWD [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> Problems with Recordset (Query) in Dreamweaver BindingsPanel - Coldfusion Database Access

Problems with Recordset (Query) in Dreamweaver BindingsPanel - Coldfusion Database Access

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 ...

  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. #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

  3. #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

Similar Threads

  1. Replies: 0
    Last Post: September 9th, 12:54 AM
  2. Dreamweaver recordset, selecting table
    By fused in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: June 29th, 10:40 PM
  3. Replies: 1
    Last Post: June 26th, 04:09 PM
  4. recordset query not working
    By Don Pacino in forum Dreamweaver AppDev
    Replies: 5
    Last Post: April 2nd, 09:13 PM
  5. Why Dreamweaver edit the Recordset will show thiserror?
    By GGeiger in forum Dreamweaver AppDev
    Replies: 1
    Last Post: February 22nd, 11:13 PM

Bookmarks

Posting Permissions

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