Help Recordset paging

[Miss Jo]

Hi I can't seem to get my recordset navigation bar to work. I am getting the
following error:-

Variable COUNTRYNAME is undefined.


The error occurred in D:\Inetpub\wwwneuops\contacts_results.cfm: line 4

2 : <cfparam name="PageNum_rs_GetCResults" default="1">
3 :
4 : <cfif #countryname# neq "Select One" and #locationname# neq "Select One"
and #post# neq "Select One">
5 : <cfquery name="rs_GetCResults" datasource="Locations_details">
6 : SELECT *

The variable countryname is defined for the first 5 results are shown? Any
suggestions?

[Miss Jo]

:brokenheart;

[Miss Jo]

I think its because I am using if else statements & this executes once? and
apparently loop structures execute repeatedly?

Part of my if else structure is:-

<cfif #FORM.countryname# neq "0" and #FORM.locationname# neq "0" and
#FORM.post# neq "0">
<cfquery name="rs_GetCResults" datasource="Locations_details">
SELECT *
FROM "NEU Contacts" INNER JOIN positions ON "NEU Contacts".pos=positions.id
WHERE Country = '#FORM.countryname#' AND location = '#FORM.locationname#' AND
pos= '#FORM.post#'
</cfquery>

<cfelseif #FORM.countryname# neq "0" and #FORM.locationname# neq "0">
<cfquery name="rs_GetCResults" datasource="Locations_details">
SELECT *
FROM "NEU Contacts" INNER JOIN positions ON "NEU Contacts".pos=positions.id
WHERE Country = '#FORM.countryname#' AND location = '#FORM.locationname#'
</cfquery>

But should I use a loop and if so how do you loop multiple conditions?

Hope this makes sense.

[Miss Jo]

I think its because I am using if else statements & this executes once? and
apparently loop structures execute repeatedly?

Part of my if else structure is:-

<cfif #FORM.countryname# neq "0" and #FORM.locationname# neq "0" and
#FORM.post# neq "0">
<cfquery name="rs_GetCResults" datasource="Locations_details">
SELECT *
FROM "NEU Contacts" INNER JOIN positions ON "NEU Contacts".pos=positions.id
WHERE Country = '#FORM.countryname#' AND location = '#FORM.locationname#' AND
pos= '#FORM.post#'
</cfquery>

<cfelseif #FORM.countryname# neq "0" and #FORM.locationname# neq "0">
<cfquery name="rs_GetCResults" datasource="Locations_details">
SELECT *
FROM "NEU Contacts" INNER JOIN positions ON "NEU Contacts".pos=positions.id
WHERE Country = '#FORM.countryname#' AND location = '#FORM.locationname#'
</cfquery>

But should I use a loop and if so how do you loop multiple conditions?

Hope this makes sense.