Thanks all for the rapid replies. I'm sure it's something stupid I'm doing, arrghhh
I've tried this as a test and it works fine: <cfquery name="rooms" datasource="#application.cfdatasource#"> SELECT * FROM tbl_confRooms where confID = #session.confID# </cfquery> <HTML> <HEAD> </HEAD> <BODY BGCOLOR="#FFFFFF"> <form method="post" name="MyForm" id="MyForm" action="register-new.cfm" > <!--- <FORM METHOD=POST name="MyForm" action="process.asp"> ---> 1<INPUT TYPE="radio" NAME="rdo" onClick="document.MyForm.submit()"><BR> 2<INPUT TYPE="radio" NAME="rdo" onClick="document.MyForm.submit()"><BR> 3<INPUT TYPE="radio" NAME="rdo" onClick="document.MyForm.submit()"><BR> 4<INPUT TYPE="radio" NAME="rdo" onClick="document.MyForm.submit()"><BR> <cfoutput query="rooms"> 4.5<input type="radio" name="roomID" value="#rooms.roomID#" onClick="document.MyForm.submit()"<cfif session.temproomID is session.roomID> checked </cfif>> </cfoutput> 5<input name="roomID" type="radio" value="0" onClick="document.MyForm.submit()"<cfif session.roomID is 0> checked </cfif>> </FORM> </BODY> </HTML> But when it's on the page I need it on I get the error: <cfif not isdefined("session.isMember")> <cfset session.ismember = 0> </cfif> <cfif isdefined("url.ismember") and val(url.isMember) gt 0> <cfset session.ismember = url.ismember> </cfif> <cfif isdefined("url.confID")> <cfset session.confID = url.confID> </cfif> <cfif not isdefined("session.confid")> <cflocation url="../ukasfp/conference.cfm"> </cfif> <cfif not isdefined("session.roomID")> <cfset session.roomID = 0> </cfif> <!--- Conference ---> <cfquery name="conf" datasource="#application.cfdatasource#"> SELECT * FROM tbl_conf where confID = #session.confID# </cfquery> <cfset session.confprice = conf.confPrice> <!--- MEMBER ---> <cfif isdefined("session.userID") and val(session.userID) gt 0> <cfquery name="member" datasource="#application.cfdatasource#"> SELECT * FROM tbl_members where memberID = #session.userID# </cfquery> <cfset session.confprice = conf.confMemberPrice> </cfif> <cfif isdefined("form.name")> <cfset session.name = form.name> </cfif> <cfif isdefined("form.email")> <cfset session.email = form.email> </cfif> <cfif isdefined("form.phone")> <cfset session.phone = form.phone> </cfif> <cfif isdefined("form.add1")> <cfset session.add1 = form.add1> </cfif> <cfif isdefined("form.add2")> <cfset session.add2 = form.add2> </cfif> <cfif isdefined("form.city")> <cfset session.city = form.city> </cfif> <cfif isdefined("form.county")> <cfset session.county = form.county> </cfif> <cfif isdefined("form.postcode")> <cfset session.postcode = form.postcode> </cfif> <cfif isdefined("form.roomID")> <cfset session.roomID = form.roomID> </cfif> <cfset session.continue = 1> <cfif not isdefined("session.name") or not len(session.name)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.email") or not len(session.email)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.phone") or not len(session.phone)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.add1") or not len(session.add1)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.add2") or not len(session.add2)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.city") or not len(session.city)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.county") or not len(session.county)> <cfset session.continue = 0> </cfif> <cfif not isdefined("session.postcode") or not len(session.postcode)> <cfset session.continue = 0> </cfif> <!--- ACCOMMODATION ---> <!--- all rooms ---> <cfquery name="rooms" datasource="#application.cfdatasource#"> SELECT * FROM tbl_confRooms where confID = #session.confID# </cfquery> <!--- booked room ---> <cfif isdefined("session.roomID") and val(session.roomID) gt 0> <cfquery name="BookedRoom" datasource="#application.cfdatasource#"> SELECT * FROM tbl_confRooms where roomid = #session.roomID# </cfquery> <cfset session.confprice = session.confprice + bookedRoom.roomprice> </cfif> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html><!-- InstanceBegin template="/Templates/2005-01-09.dwt.cfm" codeOutsideHTMLIsLocked="false" --> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!-- InstanceBeginEditable name="doctitle" --> <title>Untitled Document</title> <!-- InstanceEndEditable --> <link href="../styles.css" rel="stylesheet" media="screen" type="text/css"> <LINK REL=stylesheet MEDIA="aural" HREF="../ukaural.css" TYPE="text/css"> <LINK REL=stylesheet MEDIA="print" HREF="../ukprintfinal.css" TYPE="text/css"> <!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --> </head> <body> <table width="800" border="0" align="center" cellpadding="5" cellspacing="0" id="main"> <tr> <td colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing="0" id="header"> <tr> <td><img src="../pageart/ukasfp-logo.png" alt="United Kingdom Association for Solution Focused Practice" width="800" height="132"></td> </tr> </table></td> </tr> <tr> <td colspan="2"><table width="100%" border="0" cellpadding="5" cellspacing="0" id="navtop"> <tr> <td> <cfinclude template="../nav/menu-top.cfm"> </td> <td> <cfoutput> <ul> <li><a href="/directory/joining.cfm">Join UKASFP</a></li> <cfif not isdefined("session.mm_username") or session.mm_userauthorization is ""> <li><a href="/login/login.cfm">Sign in</a></li> <cfelse> <li><a href="/login/logout.cfm">Sign out</a></li> </cfif> </ul></cfoutput> </td> </tr> <tr> <td> <cfif isdefined("session.mm_username") and session.mm_username neq ""> <cfquery datasource="#application.cfdatasource#" name="welcome"> select dbo.tbl_members.f_name, dbo.tbl_members.s_name from dbo.tbl_members where dbo.tbl_members.login = '#session.mm_username#' </cfquery> <cfoutput>Welcome back #welcome.f_name# #welcome.s_name# <cfif isdefined("session.subsdue") and session.subsdue is 1> - <a href="/paypal/paypal-join.cfm">Your subscription is due</a> </cfif></cfoutput> <cfelse> Welcome to the UKASFP </cfif> </td> <td></td> </tr> </table></td> </tr> <tr> <td width="145" valign="top"> <br> <table width="145" border="0" cellpadding="0" cellspacing="0"> <tr><td><img src="../pageart/top.png" width="145" height="13"></td></tr> <tr> <td valign="top"><!-- InstanceBeginEditable name="leftnav" --> <cfinclude template="/ukasfp/menu.cfm"> <!-- InstanceEndEditable --></td> </tr> <tr><td><img src="../pageart/bottom.png" width="145" height="13"></td></tr> </table> </td><td width="700" valign="top"><table width="100%" border="0" cellpadding="3" cellspacing="0" id="pagetitle"> <tr> <td class="page"><!-- InstanceBeginEditable name="PageTitle" -->Conference Registration<!-- InstanceEndEditable --></td> </tr> </table> <table width="100%" border="0" cellpadding="0" cellspacing="0" id="contents"> <tr> <td valign="top"><!-- InstanceBeginEditable name="Contents" --> <form method="post" name="MyForm" id="MyForm" action="register-new.cfm" > <cfif session.isMember is 0> <table width="500" border="0" cellspacing="0" cellpadding="3"> <tr> <td> <cfif isdefined("session.userID") and val(session.userID) gt 0> <a href="register-new.cfm?isMember=1">Book as MEMBER</a> <cfelse> <a href="register-new.cfm?isMember=2">Book as NON-MEMBER</a> </cfif> </td> </tr> <tr> <td>If you are a member of UKASFP and your subscription is up-to-date please <a href="../login/login.cfm">SIGN IN</a> before booking!</td> </tr> </table> </cfif> <cfif session.ismember gt 0> <table width="550" border="0" cellpadding="3" cellspacing="0"> <tr> <td colspan="3"> <cfif session.ismember is 1> MEMBER BOOKING <cfelse> NON-MEMBER BOOKING </cfif> </td> </tr> <tr> <td>Full name</td> <td><input name="name" type="text" id="name" <cfif isdefined("session.name")> value="<cfoutput>#session.name#</cfoutput>"</cfif> size="30" /></td> <td><cfif not isdefined("session.name") or not len(session.name)>Please enter your name</cfif></td> </tr> <tr> <td>Email</td> <td><input name="email" type="text" id="email" <cfif isdefined("session.email")> value="<cfoutput>#session.email#</cfoutput>"</cfif> size="30" /> </td> <td><cfif not isdefined("session.email") or not len(session.email)>Please enter your email address</cfif></td> </tr> <tr> <td>Phone</td> <td><input name="phone" type="text" id="phone" <cfif isdefined("session.phone")> value="<cfoutput>#session.phone#</cfoutput>"</cfif> size="30" /></td> <td><cfif not isdefined("session.phone") or not len(session.phone)>Please enter your phone number</cfif></td> </tr> <tr> <td>Address</td> <td><input name="add1" type="text" id="add1" <cfif isdefined("session.add1")> value="<cfoutput>#session.add1#</cfoutput>"</cfif> size="30" /></td> <td><cfif not isdefined("session.add1") or not len(session.add1)>Please enter your address</cfif></td> </tr> <tr> <td> </td> <td><input name="add2" type="text" id="add2" <cfif isdefined("session.add2")> value="<cfoutput>#session.add2#</cfoutput>"</cfif> size="30" /></td> <td> </td> </tr> <tr> <td>City</td> <td><input name="city" type="text" id="city" <cfif isdefined("session.city")> value="<cfoutput>#session.city#</cfoutput>"</cfif> size="30" /></td> <td><cfif not isdefined("session.city") or not len(session.city)>Please enter your email address</cfif></td> </tr> <tr> <td>County</td> <td><input name="County" type="text" id="County" <cfif isdefined("session.County")> value="<cfoutput>#session.County#</cfoutput>"</cfif> size="30" /></td> <td><cfif not isdefined("session.county") or not len(session.county)>Please enter your email address</cfif></td> </tr> <tr> <td>Postcode</td> <td><input name="postcode" type="text" id="postcode" <cfif isdefined("session.postcode")> value="<cfoutput>#session.postcode#</cfoutput>"</cfif> size="20" /> </td> <td><cfif not isdefined("session.postcode") or not len(session.postcode)>Please enter your email address</cfif></td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <table width="500" border="0" cellspacing="0" cellpadding="3"> <tr> <td colspan="4"><em>Choose accomodation</em></td> </tr> <cfoutput query="rooms"> <cfset session.tempRoomID = rooms.roomID> <cfquery name="booked" datasource="#application.cfdatasource#"> SELECT * FROM dbo.count_rooms_booked where roomID = #session.tempRoomID# </cfquery> <tr> <td> </td> <td>#rooms.roomDescr#</td> <td>#LSCurrencyFormat(rooms.roomPrice,'local')#</td> <td><cfif booked.booked lt rooms.maxRooms> <input type="radio" name="roomID" value="#rooms.roomID#" onClick="document.MyForm.submit()"<cfif session.temproomID is session.roomID> checked </cfif>> <cfelse> Fully booked </cfif> </td> </tr> </cfoutput> <tr> <td> </td> <td>Accommodation not required</td> <td> </td> <td> <input name="roomID" type="radio" value="0" onClick="document.MyForm.submit()"<cfif session.roomID is 0> checked </cfif>> </td> </tr> </table> <table border="0" cellpadding="3" cellspacing="0"> <tr> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <cfif session.isMember is 1> <tr> <td width="200">Member registration</td> <td width="100"><cfoutput>#LSCurrencyFormat(conf.confMemberPrice,'local')#</cfou tput></td> <td width="100"></td> <td width="200"> </td> </tr> <cfelse> <tr> <td>Non member registration</td> <td><cfoutput>#LSCurrencyFormat(conf.confPrice,'local')#</cf output></td> <td> </td> <td> </td> </tr> </cfif> <tr> <td>Accommodation</td> <td> </td> <td> </td> <td><input name="confID" type="hidden" id="confID" value="#session.confID#"></td> </tr> <tr> <td>Total </td> <td><cfoutput>#LSCurrencyFormat(session.confPrice,'local')#< /cfoutput></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td></td> <td> </td> <td> </td> </tr> <tr> <td> <div align="center"> <input name="submit" type="submit" id="submit" value="Confirm booking details"> </div></td> <td></td> <td> </td> <td> </td> </tr> </table> </cfif> </form> <cfif session.continue is 1> <form action="register-process.cfm" method="post" name="payment"> <table width="500%" border="0" cellspacing="0" cellpadding="10"> <tr> <td><input name="submit" type="submit" id="submit" value="Continue to payment"></td> <td> </td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> </tr> </table> </form> </cfif> <!-- InstanceEndEditable --></td> </tr> </table></td> </tr> <tr> <td colspan="2"><table width="100%" border="0" cellpadding="5" cellspacing="0" id="footer"> <tr> <td width="53%"> United Kingdom Association for Solution Focused Practice © 2006 </td> <td width="47%"><a href="http://www.fasttrackonline.co.uk/" target="_blank">Fast Track Online - Web Design - Web Development</a></td> </tr> </table></td> </tr> </table> </body> <!-- InstanceEnd --></html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4