Ask a Question related to Coldfusion Database Access, Design and Development.
-
julibean #1
Components, Query, Select Box Problem
:confused;
I'm new to this.. and cannot for the life of me figure this out. Please help.
This is the error I am receiving:
Attribute validation error for tag cfoutput.
The value of the attribute query, which is currently "GetRelatedWebsiteType",
is invalid.
The error occurred in
C:\inetpub\wwwroot\TOCU\AdminSys\Admin\ManageRelat edWebsites\dsp_add_related_web
site.cfm: line 60
58 : <td><select name="sel_URL_Type_req">
59 : <option value=" ">--Select--
60 : <cfoutput query="GetRelatedWebsiteType">
61 : <option value="#GetRelatedWebsiteType.web_Type_ID#"<cfif
isDefined('Client.sel_URL_Type_req')><cfif Client.sel_URL_Type_ID_req eq
GetRelatedWebsiteType.web_Type_ID>selected</cfif></cfif>>#GetRelatedWebsiteType.
web_Type_Name#</option>
62 : </cfoutput>
This is my component:
<cfcomponent>
<!--- get related website type ID --->
<cffunction name="Get_RelatedWebsiteType" returntype="query">
<!--- define variables --->
<cfargument name="WebTypeID" type="string" required="false">
<cfargument name="WebTypeName" type="string" required="false">
<cfargument name="WebTypeDescription" type="string" required="false">
<!--- get all related website type IDs query --->
<cfquery name="GetRelatedWebsiteType" datasource="#Application.TOCU_Data#">
select Lkp_Website_Type.web_type_id, Lkp_Website_Type.web_type_name,
Lkp_Website_Type.web_type_description
from Lkp_Website_Type
where 1=1
<cfif isDefined("Arguments.WebTypeID")>
AND Lkp_Website_Type.web_type_id = <cfqueryparam
value="#Arguments.WebTypeID#" CFSQLType="CF_SQL_VARCHAR">
</cfif>
<cfif isDefined("Arguments.WebTypeName")>
AND Lkp_Website_Type.web_type_name = <cfqueryparam
value="#Arguments.WebTypeName#" CFSQLType="CF_SQL_VARCHAR">
</cfif>
<cfif isDefined("Arguments.WebTypeDescription")>
AND Lkp_Website_Type.web_type_description = <cfqueryparam
value="#Arguments.WebTypeDescription#" CFSQLType="CF_SQL_VARCHAR">
</cfif>
</cfquery>
<!--- end of query --->
<!--- return results --->
<cfreturn GetRelatedWebsiteType>
</cffunction>
<!--- end of get all related website types function --->
</cfcomponent>
Here is where they are calling the error from:
<!---
<cfinvoke
component ="#RootURL#Components/Query/qry_Manage_Related_Websites"
method = "Get_RelatedWebsiteType"
returnVariable = "GetRelatedWebsiteType">
</cfinvoke>
--->
<form action ="add_related_website_action.cfm" method="post">
<table>
<tr>
<td>*Title:</td>
<td><input type="text" name="txt_Title_req" size="50"></td>
</tr>
<tr>
<td>*URL:</td>
<td><input type="text" name="txt_URL_req"></td>
</tr>
<tr>
<td>*URL Type:</td>
<td><select name="sel_URL_Type_req">
<option value=" ">--Select--
<cfoutput query="GetRelatedWebsiteType">
<option value="#GetRelatedWebsiteType.web_Type_ID#"<cfif
isDefined('Client.sel_URL_Type_req')><cfif Client.sel_URL_Type_ID_req eq
GetRelatedWebsiteType.web_Type_ID>selected</cfif></cfif>>#GetRelatedWebsiteType.
web_Type_Name#</option>
</cfoutput>
</select>
</td>TextText
julibean Guest
-
Problem using SELECT TOP and ORDER BY together in a query
SQL is based on set theory. You are ordering the resultset by the StoryDate. So you have 6 articles at the top of the list. How is the database... -
Query of Query to select a title first letter
The column "title" exists in a normal query. Need to select the first letter of the titles to build a list for a prev-next alphabetical search. ... -
SELECT query Error, possible date problem?
Hello, I have what I thought was a fairly straight forward date based query that is returning an error I cant seem to get past. Here is my... -
Using < and > in a select query
I am trying to write a select query to recieve results between two date ranges i have got these lines in my cfquery tag (example): and... -
problem with the select query
Hi people, this is my first mail to the group. i am having a problem with the select query. There are a few values in few columns of a table with... -
pea1963 #2
Re: Components, Query, Select Box Problem
Hello, I'm new to this also, and I'm receiving error "attribute validation
error for tag cfloop". The value of the attribute query, which is currently
"list_get_sorted_records" is invalid. This happens when I'm trying to locate a
court case in web page [url]www.courts.gov/[/url]. Do you have any suggestions on what I
may need to do or not do? Thanks, Rhonda
pea1963 Guest



Reply With Quote

