Ok.
I am able to get one class id inserted besed on the record count.
My problem now is at the bottom of this page.
it needs to be conditional on wether the insert is for date/time 01 or
date/time 02.
But how is my form suposed to know what date has been selected befor the
actual submit button is hit?
i need a
<CFIF ClassID = 1>
<input type="hidden" name="SU_Number1" value="<cfoutput>#rsDate01_total# +
1</cfoutput>">
<CFELSE>
<input type="hidden" name="SU_Number2" value="<cfoutput>#rsDate02_total# +
1</cfoutput>">
</CFIF>
</CFIF>
any help would be awsome!
thanks
-paul
<!--- CODE BELOW --->
<cfquery name="rsClass" datasource="practice" >
SELECT ClassID, ClassName, ClassTeacher, ClassEmail, ClassDescription,
ClassRoom,
ClassStartTime, ClassEndTime, ClassDate
FROM tbl_Class
WHERE ClassID = 1
OR ClassID = 2
</cfquery>
<cfquery name="rsDate01" datasource="practice" >
SELECT SignUpID, SU_DateOfferdID
FROM tbl_SignUp
WHERE SU_DateOfferdID = 1
</cfquery>
<cfquery name="rsDate02" datasource="practice" >
SELECT SU_DateOfferdID
FROM tbl_SignUp
WHERE SU_DateOfferdID = 2
</cfquery>
<select name="slctDate">
<cfloop query="rsClass">
<option value="<cfoutput>#rsClass.ClassID#</cfoutput>"
selected><cfoutput>
# LSDateFormat(rsClass.ClassDate, 'DDDD, MMMM DD, YYYY') #
</cfoutput></option>
</cfloop>
</select>
<td width="123"> <font face="Arial, Helvetica, sans-serif">
<input type="hidden" name="SU_Number1"
value="<cfoutput>#rsDate01_total# + 1</cfoutput>">
<input type="hidden" name="SU_Number2"
value="<cfoutput>#rsDate02_total# + 1</cfoutput>">
</font></td>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.