I would var your local struct variable:
<cfset var redirectLookupResults=StructNew()>
I would also var your query variable immediately after your cfargument tags:
<cfset var redirectLookup = QueryNew()>
I would also wrap your struct assignments in a cfif to make sure the
function doesn't error in the event that no records are returned by your
query:
<cfif redirectLookup.RECORDCONT gt 0>
<cfset redirectLookupResults.redirectURL =
"#redirectLookup.redirectURL#">
<cfset redirectLookupResults.redirectID = "#redirectLookup.redirectID#">
<cfset redirectLookupResults.redirectStatus =
"#redirectLookup.redirectStatus#">
</cfif>
And finally, there's no need for parenthesis in your SQL statement.
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
