I have a form that does not require all fields to be
filled out. On the action page, I need to check the
non-required fields for content, and if empty place
"n/a" or a zero in the field before the record is
added to the database. I tried using <cfparam>, but
it does not seem to work. The code is:
<cfparam name="Pages" default=0>
<cfparam name="Year" default=0>
<cfparam name="Service" default="N/A">
<cfparam name="Position" default="N/A">
<cfparam name="Ndate" default="N/A">
<cfparam name="Volume" default="N/A">
<cfparam name="Issue" default="N/A">
<cfparam name="Authors" default="N/A">
<cfparam name="ArticleTitle" default="N/A">
<cfparam name="Source" default="N/A">
<cfparam name="Other" default="N/A">
<CFQUERY NAME="qInsert" DATASOURCE="request">
INSERT INTO data (Location, Requested, Service, TDate,
Position, Extension, NDate, Format, PeriodicalTitle,
Volume, Issue, Authors, Pages, Year, ArticleTitle,
Source, NLM, Other, Status)
Values ('#form.Location#', '#form.Requested#',
'#Service#', '#TDate#', '#Position#',
#form.Extension#, '#NDate#', '#form.Format#',
'#form.PeriodicalTitle#', '#Volume#', '#Issue#',
'#Authors#', #Pages#, #Year#, '#ArticleTitle#',
'#Source#', '#NLM#', '#Other#', '#Status#')
</CFQUERY>
Any other ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists