ColdFusion If Statements

Hi there,

Is there a way of setting a cfif statement to use GT and LT and the same time i want it to be GT 4 but LT 7

Thanks

Jonathan

This topic has been closed for replies.

Correct answer JMF3

<cfif myVal gt 4 and myVal lt 7

JMF3Correct answer

Participating Frequently

<cfif myVal gt 4 and myVal lt 7

A

Anonymous

Hi mate yeah that works thanks very much

got a new problem now i get this error when it gets to the last CFIF when 4 or GT.

Error Occurred While Processing Request
Element TWIN is undefined in FROM.

only come up when it runs the last cfif any ideas

<cfquery name="twin" datasource="strand">
SELECT *
FROM hotel_rooms
WHERE hotel_rooms.ID = 1</cfquery>

<cfquery name="double" datasource="strand">
SELECT *
FROM hotel_rooms
WHERE hotel_rooms.ID = 2</cfquery>

<cfquery name="family" datasource="strand">
SELECT *
FROM hotel_rooms
WHERE hotel_rooms.ID = 3</cfquery>

<cfquery name="suite" datasource="strand">
SELECT *
FROM hotel_rooms
WHERE hotel_rooms.ID = 4</cfquery>

<cfquery name="penthouse" datasource="strand">
SELECT *
FROM hotel_rooms
WHERE hotel_rooms.ID = 5</cfquery>

</cfif>

Inspiring

Element TWIN is undefined in FROM.

Read the error message (and your code) more closely.

--

Adam

Sign up