New to ColdFusion and it is truncating the entered field value
(fyi: This was all created by a predicessor).
I have a simple intranet page that displays data pulled from a database and allows the user to delete individual entries, with a single click. The sql delete requires UnitNumber and FleetGroup to identify the unique record. My issue is that the CFDfg variable is truncating to 10 characters, despite the values being as long as 50 characters. How do I get ColdFusion to pass the full FleetGroup value to MS SQL? I ran SQL Server Profiler, which is how I know it is only getting 10 charcters of the FleetGroup value.
Here is the delete code.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
<table width="45%" align="center" border="1" cellspacing="0" cellpadding="0">
<td colspan="6" align="center" valign="top" nowrap><a href="/DataManager/TMReadiness.cfm? CFAdded=AddATruck">Add A Truck</a></td>
<tr class="style6">
<td width="52%" nowrap><span class="style6"><strong>Fleetgroup</strong></span></td>
<td width="33%" nowrap><span class="style6"><strong>Truck Unit Number</strong></span></td>
<td width="15%" nowrap><strong>Delete?</strong></td>
</tr>
<cfoutput query="TRKQRY">
<tr class="style6">
<td nowrap><span class="style6">#FleetGroup#</span></td>
<td nowrap><span class="style6">#UnitNumber#</span></td>
<td class="style6"><a href="/DataManager/TMReadiness.cfm?CFAdded=DelaTruck&CFDid=#UnitNumber#&CFDfg=#FleetGroup#">Yes</a></td>
</tr>
</cfoutput>
</table>
</cfif>
<cfif CFAdded eq 'DelaTruck'>
<cfquery datasource="intranet" name="DelATruck" username="cwddata" password="cwdrolloff">
delete [Intranet].[dbo].[TM_Readiness_Vechicles] where UnitNumber = #URL.CFDid# and FleetGroup = #URL.CFDfg
</cfquery>
<META http-equiv="refresh" content="0; Url=/DataManager/TMReadiness.cfm?CFAdded=AddDelTruck">
</cfif>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thanks for your help,
Andy
AdChoices