Ask a Question related to Coldfusion Database Access, Design and Development.
-
ChuckRWD #1
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
-
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... -
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)... -
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... -
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... -
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... -
ChuckRWD #2
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
-
ChuckRWD #3
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



Reply With Quote

