Variable is deffined in URL

Ask a Question related to Macromedia ColdFusion, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. #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...
    2. #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...
    3. #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...
    4. 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...
    5. 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...
  3. #2

    Default Re: Variable is deffined in URL

    It should be........

    <cfif isDefined("url.category")>

    See how that goes.
    simontux Guest

  4. #3

    Default 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

  5. #4

    Default 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

  6. #5

    Default 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

  7. #6

    Default Re: Variable is deffined in URL

    Thanks for the help
    TheScarecrow 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