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