Experts Exchange connects you with the people and services you need so you can get back to work.

How to loop over all form fields, setting blank fields to "Null"

So far I have this:

<cfloop collection="#Form#" item="ThisField">
<cfif len(form[ThisField]) LT 1>
<cfoutput>
#ThisField# is blank<br>
</cfoutput>
<cfelse>
<cfoutput>
#ThisField# is populated<br>
</cfoutput>
</cfif>
</cfloop>

Which outputs the field name and if populated or blank.

How can I set the VALUE of each blank field to "NUll" or "EMPTY" or anything?

Should I be using a list?

SDtubeone

Asked: 2004-08-10

Advertise Here

Web Servers

1 Solution

LVL 15

danrosenthalCommented: 2004-08-10

This should do it:

<CFLOOP LIST="#form.fieldnames#" Index="field">
<CFIF len(evaluate('form.'&field)) eq 0>
<CFSET 'form.#field#' = "NULL">
#field# value is NULL<BR>
<CFELSE>
#field# value is #evaluate(field)#
</CFIF>
</CFLOOP>

SDtubeoneAuthor Commented: 2004-08-10

#field# value is NULL
#field# value is #evaluate(field)#

This is the output I get...Am I missing something?

SDtubeoneAuthor Commented: 2004-08-10

Oh...Just my CFOUTPUT tages...

Thanks very much...

Cheers,

Paul

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

How to loop over all form fields, setting blank fields to "Null"

Join & Write a Comment Already a member? Login.

Featured Post