Hello!
I need help with an update query on my CF page. I am creating a shift bid
process, each agent will see a list of available shifts and will be able to bid
for these shifts based on number preference, 1 is first shift they want, 2 is
2nd choice, etc.
When I enter the pick number in different available shift rows and hit the
update button, those picks are all written into the first record of the dataset
showing as 12345...
I have created a unique ID code for each shift and assumed that field was the
one that was used to make the update to the table, but it doesn't seem to. I'm
including the code for the page and would appreciate any suggestions. I know
it's probably very messy, I'm a beginner at coldfusion and I'm sure that I'm
doing things in the best possible way.
Thank you!!
Here is the first section of code:
<!---Get agent data--->
<cfquery name="agt" datasource="shifts" result="result">
SELECT Distinct AgentName, HireDate, SenNum
>From tbl_Bid_Info
WHERE SSNo Like <!---'%#FORM.SSNo#%'--->'678912'
</cfquery>
<!---Get available shifts--->
<cfquery name="avail" datasource="shifts" result="result">
SELECT AgentName, BidDate, SchedNo, StartTime, EndTime, Sunday, Monday,
Tuesday, Wednesday, Thursday, Friday, Saturday, BidNum, Id
>From tbl_Bid_Info
WHERE SSNo Like <!---'%#FORM.SSNo#%'--->'678912'
ORDER BY SchedNo
</cfquery>
<!---Update form--->
<cfform action="bid_mix_upd.cfm">
<!---Embed Id as hidden field--->
<cfoutput>
<input type="hidden" name="Id" value=#avail.Id#>
</cfoutput>
<h1><font size="2" face="Arial, Helvetica, sans-serif">Agent Data</font></h1>
<!---Display agent data table--->
<TABLE cellpadding="1" cellspacing="1" border="1" align="center">
<th width="304"><font size="2" face="Arial, Helvetica,
sans-serif">AgentName</font></th>
<th width="114"><font size="2" face="Arial, Helvetica,
sans-serif">HireDate</font></th>
<th width="69"><font size="2" face="Arial, Helvetica, sans-serif">Seniority
Number</font></th>
<cfoutput query="agt">
<tr>
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#AgentName#</font></div></td>
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#DateFormat(HireDate, "MM/DD/YY")#</font></div></td>
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#SenNum#</font></div></td>
</tr>
</cfoutput>
</table>
And here is the second section, table and input code:
<!---Display avail shift table--->
<TABLE border="0" align="center" cellpadding="1" cellspacing="3"
bordercolor="#FFFFFF">
<th><font size="2" face="Arial, Helvetica, sans-serif">Sched#</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Start Time</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">End Time</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Sunday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Monday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Tuesday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Wednesday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Thursday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Friday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Saturday</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">ID Number</font></th>
<th><font size="2" face="Arial, Helvetica, sans-serif">Bid Number</font></th>
<cfoutput query="avail">
<!---Set alternating row color--->
<cfif CurrentRow MOD 2 IS 1>
<cfset bgcolor="##CCCCCC">
<cfelse>
<cfset bgcolor="White">
</cfif>
<tr bgcolor="#bgcolor#">
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#SchedNo#</font></div></td>
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#TimeFormat(StartTime, "h:mm tt")#</font></div></td>
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#TimeFormat(EndTime, "h:mm tt")#</font></div></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Sunday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Monday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Tuesday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Wednesday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Thursday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Friday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif"><cfif
#Saturday# IS "1"><strong> X </strong><cfelse></font></div></cfif></td>
<td><div align="center"><font face="Arial, Helvetica,
sans-serif">#ID#</font></div></td>
<td><div align="center"><font face="Arial, Helvetica, sans-serif">
<cfinput type="text"
name="BidNum"
value=#Trim(avail.BidNum)#
required="No"
size="5"
maxlength="10"></font></div></td>
</tr>
</cfoutput>
<td colspan="2" align="center">
<input type="submit" value="Update">
</td> </tr>
</table>
I know it's probably very messy, I'm a beginner at coldfusion and am not sure
I'm doing things in the best possible way.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3752
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
