Sorry if this is a repeat, but I never saw it come through...

I have a problem...

I need to loop through the columns in a record to see if any of them contain
the word VOICE as the first 5 characters. I tried using this...

<CFLOOP INDEX="num" FROM="0" TO="29">
        <cfif #Left('a#num#',5)# is 'VOICE'>
                <cfset voice1 = 'a#num#'>
        </cfif>
</cfloop

But it doesn't work correctly and I'm not sure why. Any help would be
appreciated.

Also, is there any way to 'lock' a record to exclusive use by a user? I know
I can set a flag, and not allow a user to grab the record if the flag was
set, but thats a kludge and I was hoping there was an elegant solution.

thanks... Marcus

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to