Hello,
Thanks a lot for ur help, really appreciate it.
I am inserting dates into SQL Server db using a coldfusion page, As u know if there is a blank date inserted into SQL SERVER db it inserts with 01/01/1900, and when i am lanching the page again, the page pullling up those date values stored in the db. If user selects a particular date and stores in the db, i am getting those dates. But user doesnt select a date on creation and while editing 01/01/1900 is being pulled into the screen. How could i eliminate these 01/01/1900 dates in the textfields of a coldfusion page, if no dates were selected.
Here is the example of the code:
**************************
**********
**********
**********
**********
**********
*
<td>
<cfset mulProdOnHoldDt =
getCSSProdHeadDetails('css
_onhold_da
testamp','
#projectID
#','#produ
ct_type#',
'#legacy_s
ys_type#')
>
<input size="8" readonly="" style="background:CCCCCC" name="preOnHoldDate_#i#"
type="text" value="<cfif mulProdOnHoldDt neq "">#DateFormat(mulProdOnHo
ldDt)#</cf
if> "/>
<a href="javascript:NewCal('p
reOnHoldDa
te_#i#','M
Mddyyyy')"
>
<img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a>
</td>
**************************
**********
**********
**********
**********
**********
Any help would be really appreciated!! Thanks U
Start Free Trial