Ask a Question related to Macromedia ColdFusion, Design and Development.
-
TheScarecrow #1
Variable is deffined in URL
Following is my code and then the error i am getting.This is a search results
page. I think there error is on the line IsDefined("#URL>category#") and I am
not sure why. DO I need to set up a cfparameter? The error is this:
Parameter 1 of function IsDefined, which is now 'Record Sheets', must be a
syntactically valid variable name.
Any one have any ideas?
<cfif Not IsDefined("SESSION.Cf_group_letter")>
<cfset SESSION.Cf_group_letter = "">
</cfif>
<cfif ISDEFINED ("group_letter") AND group_letter GT "">
<cfset SESSION.Cf_group_letter = group_letter>
<CFSET SESSION.Cf_groups = " ">
<cfelse>
<CFSET group_letter = "">
</cfif>
<cfif Not ISDEFINED ("session.marker_find")>
<cfset session.marker_find = 1>
</cfif>
<cfif session.Cf_group_letter EQ ''>
<cfif session.marker_find EQ 1>
<CFIF IsDefined ("#URL.category#")>
<cfset SESSION.Cf.category = #URL.category#>
<CFSET SESSION.Cf_description = "">
<CFSET SESSION.Cf_project = " ">
<CFSET SESSION.Cf_groups = " ">
<CFSET SESSION.Cf_pub_num = " ">
<cfset session.marker_find = 0>
<cfelse>
<cfset session.marker_find = 0>
<cfif IsDefined("Form.description")>
<CFSET SESSION.Cf_description = FORM.Description>
<cfelse>
<CFSET SESSION.Cf_description = "">
</cfif>
<cfif IsDefined("Form.project_select")>
<CFSET SESSION.Cf_project = FORM.project_select>
<cfelse>
<CFSET SESSION.Cf_project = " ">
</cfif>
<cfif IsDefined("Form.group_select")>
<CFSET SESSION.Cf_groups = FORM.group_select>
<cfelse>
<cfif IsDefined("group_search")>
<cfset SESSION.Cf_groups = group_search>
<cfelse>
<CFSET SESSION.Cf_groups = " ">
</cfif>
</cfif>
<cfif IsDefined("Form.category_select")>
<CFSET SESSION.Cf_category = FORM.category_select>
<cfelseif IsDefined ("URL.category")>
<CFSET SESSION.Cf_category = #URL.category#>
<cfelse>
<CFSET SESSION.Cf_category = " ">
</cfif>
<cfif IsDefined("Form.PUB_num")>
<CFSET SESSION.Cf_pub_num = FORM.PUB_num>
<cfelse>
<CFSET SESSION.Cf_pub_num = " ">
</cfif>
</CFIF>
</cfif>
<CFQUERY NAME="searchresult" DATASOURCE="4h_projects">
SELECT *
FROM resource
WHERE 0=0
<!---search by Description--->
<CFIF #SESSION.Cf_description# GT "">
AND title LIKE '%#SESSION.Cf_description#%' OR search_key LIKE
'%#SESSION.Cf_description#%'
</CFIF>
<!---search by Category--->
<CFIF #SESSION.Cf_category# GT " ">
AND CATEGORY = '#SESSION.Cf_category#'
</CFIF>
<!---search by Group--->
<CFIF #SESSION.Cf_groups# GT " ">
AND membership = '#SESSION.Cf_groups#'
</CFIF>
<!---search by Project--->
<CFIF #SESSION.Cf_project# GT " ">
AND proj_key = #SESSION.Cf_project#
</CFIF>
<!---search by Publication Number--->
<CFIF #SESSION.Cf_PUB_num# GT " ">
AND PUB_num LIKE '%#SESSION.Cf_PUB_num#%'
</CFIF>
ORDER BY title
</CFQUERY>
<cfelse>
<CFQUERY NAME="searchresult" DATASOURCE="4h_projects">
SELECT *
FROM resource
WHERE title LIKE '#SESSION.Cf_group_letter#%' OR search_key LIKE
'%#SESSION.Cf_group_letter#%'
ORDER BY title
</CFQUERY>
</cfif>
TheScarecrow Guest
-
#39634 [NEW]: session variable and normal variable
From: erhanbaris at gmail dot com Operating system: Win Xp SP1 PHP version: 5.2.0 PHP Bug Type: Variables related Bug... -
#39251 [NEW]: variable variable class array property is read only
From: taskfreak at gmail dot com Operating system: mac os PHP version: 5.1.6 PHP Bug Type: Class/Object related Bug... -
#22237 [Com]: PHP crashes when class references property using variable variable
ID: 22237 Comment by: rep at devdomain dot com Reported By: peter at globalvision dot com dot au Status: Closed... -
passing javascript variable into asp variable using vbscript
The subject pretty much sums up what I need to do. Here is what I have so far, but still can't figure out how to get it working: <script... -
Datalist - how (if) to use a sub variable or session variable in the footer?
Hi, sorry to be greedy with all my posts lately, but can you tell I'm doing new things this week? I've just done my first datalist (a simple... -
simontux #2
Re: Variable is deffined in URL
It should be........
<cfif isDefined("url.category")>
See how that goes.
simontux Guest
-
TheScarecrow #3
Re: Variable is deffined in URL
Now i get the error Element CF_CATEGORY is undefined in SESSION. at the line
<CFIF #SESSION.Cf_category# GT "">
AND CATEGORY = '#SESSION.Cf_category#'
</CFIF>
Any ideas?
TheScarecrow Guest
-
simontux #4
Re: Variable is deffined in URL
You need to have something showing the GT value....... I not 100% sure but I
don't think you can have a GT "" it either needs to be GT 0 or IS NOT "" also
you don't need the quote around #SESSION.Cf_category#
simontux Guest
-
TheScarecrow #5
Re: Variable is deffined in URL
I have it now. The correct code is this.
<cfif Not IsDefined("SESSION.Cf_group_letter")>
<cfset SESSION.Cf_group_letter = "">
</cfif>
<cfif ISDEFINED ("group_letter") AND group_letter GT "">
<cfset SESSION.Cf_group_letter = group_letter>
<CFSET SESSION.Cf_groups = " ">
<cfelse>
<CFSET group_letter = "">
</cfif>
<cfif Not ISDEFINED ("session.marker_find")>
<cfset session.marker_find = 1>
</cfif>
<cfif session.Cf_group_letter EQ ''>
<cfif session.marker_find EQ 1>
<CFIF IsDefined ("URL.category")>
<cfset SESSION.Cf_category = URL.category>
<CFSET SESSION.Cf_description = "">
<CFSET SESSION.Cf_project = " ">
<CFSET SESSION.Cf_groups = " ">
<CFSET SESSION.Cf_pub_num = " ">
<cfset session.marker_find = 0>
<cfelse>
<cfset session.marker_find = 0>
<cfif IsDefined("Form.description")>
<CFSET SESSION.Cf_description = FORM.Description>
<cfelse>
<CFSET SESSION.Cf_description = "">
</cfif>
<cfif IsDefined("Form.project_select")>
<CFSET SESSION.Cf_project = FORM.project_select>
<cfelse>
<CFSET SESSION.Cf_project = " ">
</cfif>
<cfif IsDefined("Form.group_select")>
<CFSET SESSION.Cf_groups = FORM.group_select>
<cfelse>
<cfif IsDefined("group_search")>
<cfset SESSION.Cf_groups = group_search>
<cfelse>
<CFSET SESSION.Cf_groups = " ">
</cfif>
</cfif>
<cfif IsDefined("Form.category_select")>
<CFSET SESSION.Cf_category = FORM.category_select>
<cfelseif IsDefined ("URL.category")>
<CFSET SESSION.Cf_category = #URL.category#>
<cfelse>
<CFSET SESSION.Cf_category = " ">
</cfif>
<cfif IsDefined("Form.PUB_num")>
<CFSET SESSION.Cf_pub_num = FORM.PUB_num>
<cfelse>
<CFSET SESSION.Cf_pub_num = " ">
</cfif>
</CFIF>
</cfif>
<CFQUERY NAME="searchresult" DATASOURCE="4h_projects">
SELECT *
FROM resource
WHERE 0=0
<!---search by Description--->
<CFIF #SESSION.Cf_description# GT "">
AND title LIKE '%#SESSION.Cf_description#%' OR search_key LIKE
'%#SESSION.Cf_description#%'
</CFIF>
<!---search by Category--->
<CFIF #SESSION.Cf_category# GT "">
AND CATEGORY = '#SESSION.Cf_category#'
</CFIF>
<!---search by Group--->
<CFIF #SESSION.Cf_groups# GT " ">
AND membership = '#SESSION.Cf_groups#'
</CFIF>
<!---search by Project--->
<CFIF #SESSION.Cf_project# GT " ">
AND proj_key = #SESSION.Cf_project#
</CFIF>
<!---search by Publication Number--->
<CFIF #SESSION.Cf_PUB_num# GT " ">
AND PUB_num LIKE '%#SESSION.Cf_PUB_num#%'
</CFIF>
ORDER BY title
</CFQUERY>
<cfelse>
<CFQUERY NAME="searchresult" DATASOURCE="4h_projects">
SELECT *
FROM resource
WHERE title LIKE '#SESSION.Cf_group_letter#%' OR search_key LIKE
'%#SESSION.Cf_group_letter#%'
ORDER BY title
</CFQUERY>
</cfif>
TheScarecrow Guest
-



Reply With Quote

