Cheesecake87

Anyone tell me why this Coldfusion code aint working ? I built the system on the Coldfusion 9 developer server locally then uploaded it to a Coldfusion 8 hosted server and I get this strange error. Error can be seen here: http://75.126.153.165/$sitepreview/ka-radio.co.uk Code where error is highlighed can be seen …

[CODE]<cfquery name="Sort" datasource="JD8989776555"> SELECT * FROM ResMenuItems ORDER BY "ItemOrder" ASC </cfquery> <p>Output</p> <cfoutput query="Sort"> #ItemOrder# - #ItemName#<br /> </cfoutput> <p>loop</p> <cfloop query="Sort"> <cfoutput>#ItemOrder# - #ItemName#<br /></cfoutput> </cfloop>[/CODE] I am honestly not joking :S That code there, is here : [url]http://jadedragon-co-uk.securec12.ezhostingserver.com/admin/MenuManager/TEST.cfm[/url]

I am having a problem looping out a value from posted data into a loop, heres some code: [CODE] <cfset tempAmount = "URL.amount_" & 1> <cfset tempQuantity = "URL.quantity_" & 1> <cfoutput> <cfif #tempAmount# EQ 1> Yes <cfelse> no </cfif> #tempAmount##tempQuantity# </cfoutput> [/CODE] That is a small test section I …

[CODE]<cfquery name="Booking_Link" datasource="HotelBookingSystem" username="HBSuser" password="HBSpass"> SELECT * FROM Bookings WHERE BookingDateIN AND BookingDateOUT NOT BETWEEN <cfqueryparam value="#FORM.SelDateIN#" cfsqltype="cf_sql_date"> AND <cfqueryparam value="#FORM.SelDateOUT#" cfsqltype="cf_sql_date"> </cfquery>[/CODE] This works .... But if my booking date(UK - dd/mm/yyyy) has a range of 05/02/2010 to 09/02/2010 And my search value is 04/02/2010 to 05/02/2010 ... this …

Hey, Building a hotel booking system as a college project, And as I do not want to go through the building a calendar that shows dates that are already booked, aww can be bothered. ok the max number of days of stay allowed are 7, now I have thought of …