Select currently looks like this:

<select name=xox">
  <option value="00"
          <cfif qry.xox EQ 00> selected="selected"</cfif>>00</option>
  <option value="01"
          <cfif qry.xox EQ 01> selected="selected"</cfif>>01</option>
  <option value="02"
          <cfif qry.xox EQ 02> selected="selected"</cfif>>02</option>

  ...up to whatever number
</select>

Gotta be a better way using a loop, and if the numbers were simply 1 
through whatever, no problem. It's keeping the leading zero and starting 
with "00" and then "01", "02", ... , whatever that's making me scratch 
my head.

The database field is a varCHAR so no problem there.

Ideas?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by AdobeĀ®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270438
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to