<cfquery name="isSpecIn" datasource="#request.dsn#">
SELECT COUNT(*) AS testCount
FROM prodSpecs
WHERE prodPartNum = #FORM.prodPartNum#
</cfquery>
i just want to check to make sure specs_partnum
is not isSpecIn.testCount GTE 1
<script>
$().ready(function() {
// validate signup form on keyup and submit
$("#insertSpecs").validate({
//As soon as a key within a form field in "myform" is
release then start
event: "keyup",
//Here the rules for the individual inputs are defined.
rules: {
specs_partnum: "required",
sap_partnum: "required",
prod_descsap: "required",
prod_descsap2: "required",
prod_hierarchy: "required",
prod_sbu: "required"
},
//Here the error messages for all rules are defined.
messages: {
specs_partnum: 'Please enter a Part Number',
sap_partnum: 'Please enter a SAP Part Number',
prod_descsap: 'Please enter a SAP Product Description',
prod_descsap2: 'Please enter a SAP Product Description 2',
prod_hierarchy: 'Please enter a Product Hierarchy, such as
1150101',
prod_sbu: 'Please enter a SBU, such as 01'
},
//Optionally: This message appears, when the rules are met
success: function(label) {
label.html('ok').addClass("success");
}
});
});
</script>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299891
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
