Insert several dates for the same event

all little bugs in your code aside (i.e. unnecessary ##, pulling fields from db that are not used anywhere, etc), i am not clear on which field the speaker description is stored in in your db? is it in review.review? you are not displaying that data anywhere in the form, anyway....

also, in your original (first) post you mentioned 2 tables: speakers and venues... but in your rsInsert query you are joining speakers and review... is this a different issue then?

<cfoutput query="rsInsert">
<option value="#rsInsert.speakerID#">#rsInsert.speakerName# -- #rsInsert.speaker.eventDate#</option>
</cfoutput>
</select>

would give the .evenDate that was with each record pulled...

- Mike

Thanks Sabaidee,

Please find below the whole code:

<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ

"insert">
<cfquery datasource="utcg302">
INSERT INTO speaker (speakerName, venue, eventDate)
VALUES (
<cfif IsDefined("FORM.speaker") AND #FORM.speaker# NEQ "">
<cfqueryparam value="#FORM.speaker#" cfsqltype="cf_sql_clob"

maxlength="150">
<cfelse>
''
</cfif>
,
<cfif IsDefined("FORM.Venue") AND #FORM.Venue# NEQ "">
<cfqueryparam value="#FORM.Venue#" cfsqltype="cf_sql_clob"

maxlength="50">
<cfelse>
''
</cfif>
,
<cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">
<cfqueryparam value="#FORM.date#" cfsqltype="cf_sql_timestamp">
<cfelse>
NULL
</cfif>
)
</cfquery>
</cfif>

------------------------------------------------

<cfquery name="rsInsert" datasource="utcg300">
SELECT speaker.speakerID, speaker.speakerName, speaker.venue,

speaker.eventDate, review.reviewID, review.review
FROM speaker INNER JOIN review ON speaker.actID = review.actID
ORDER BY speaker.eventDate
</cfquery>

----------------------------------------------------


<form action="<cfoutput>#CurrentPage#</cfoutput>" id="insert" name="insert"

method="POST">
<label for="textfield">Date</label>
<p>
<input name="date" type="text" id="date" />
</p>
<table width="200">
<tr>
<td><label>
<input type="radio" name="Venue" value="Stoney" />
Stoney</label></td>
</tr>
<tr>
<td><label>
<input type="radio" name="Venue" value="William Edwards" />
William Edwards</label></td>
</tr>
</table>
<p> </p>
<p>
<label for="select">speaker</label>
<select name="speaker" id="Speaker">
<option value="">Choose One</option>
<option value=""></option><cfoutput query="rsInsert">
<option value="#rsInsert.speakerID#">#rsInsert.speakerName#</option>
</cfoutput>
</select>

<p>
<label for="Submit"></label>
<input type="submit" name="Submit" value="Submit" id="Submit" />
</p>

<input type="hidden" name="MM_InsertRecord" value="insert">
</form>

post your query. hard to say without seeing it...

Please excuse me, my mind is all over the places at the moment.

What I failed to explain (or add) is that each Speaker has a description about themselves. Joining the two tables on SpeakerID shows the dates, but doesn't bring the description over with it..

I'm missing something in the form, but don't know what.

Many thanks

So if you join your two tables on speakerID, you should be in business.

What's a dynamic dropdown field?