Okay shoot me because I can't don't know what to do but I have a form that needs to 
check 3 fields against the db to make sure there isn't a duplicate.  I can't make my 
JS code work because I am not that smart..... anyone bored and want to help? :)  HERE 
is whats between my tags.  

thanks
<SCRIPT LANGUAGE="JavaScript">

                <CFSET IP = ''>
                <CFSET HOST = ''>
                <CFSET NIC = ''>
        <CFOUTPUT QUERY="ALL_PCS">
                <CFSET IP = #listappend(IP, IPADDRESS)#>
                <CFSET HOST = #listappend(HOST, PCNAME)#>
                <CFSET NIC = #listappend(NIC, NICADDRESS)#>
        </CFOUTPUT>
        <CFSET a = findnocase(document.forms.add.IPADDRESS.value, IP,1)>
        <CFSET b = findnocase(document.forms.add.PCNAME.value, HOST,1)>
        <CFSET c = findnocase(document.forms.add.NICADDRESS.value, NIC,1)>
        <CFIF #VARIABLES.A# IS NOT 0>
                     alert ("You Entered a Duplicate IP Address.");
                             return false;
        </CFIF>
        <-CFIF #VARIABLES.B# IS NOT 0>
                     alert ("You Entered a Duplicate PCNAME.");
                             return false;
        </CFIF>
        <CFIF #VARIABLES.C# IS NOT 0>
                    alert ("You Entered a Duplicate NIC Address.");
                            return false;
        </CFIF>         
</script>               

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to