Assigning a Variable a Null Value

Question

Hi all. I've got a loop that queries a query outside of the loop. The problem is, the query may get defined, and it may not. But if it gets defined, how do I undefine it for the next loop iteration. Here's some code to wrap your head around it (edited for brevity).

<cfloop>
<cfset queryValue = possibleEmptyString >
<cfif Len(queryValue)>
<cfquery name="queryName" dbtype="query">
select * from something
</cfquery>
</cfif>

<cfif IsDefined("queryName") AND queryName.RecordCount>
error="some error message"
</cfif>
</cfloop>

So, is there not a Function that sets the var to Undefined, or Null, or something? If not, what's the alternative?

Thanks all! 😉

Kronin555 · Accepted Answer

select * from somethingerror="some error message"

Sky Worker · Answer

Thanks Dan. But, that won't quite solve my problem.

The problem is that once it becomes a query, I can't reset it back to a String value because I've already turned it into a complex type so IsQuery() it will always return true.

not sure how using a try/catch will solve it either. Am I missing something here?

Thanks for your reply, I appreciate the attentiont to this issue.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded