Add any comments or questions regarding the Form Validation, Dependant Drop Downs, Data Level Security in OWS tutorial from Issue 55

we are having some problem with the code for this ISSUE. Category and SubCategory modules work as intended but the the Parts code has a small error that renders it handicaped What is your suggestion for correcting this, or how to find where the error ricides.

we are having some problem with the code for this ISSUE. Category and SubCategory modules work as intended but the the Parts code has a small error that renders it handicaped What is your suggestion for correcting this, or how to find where the error ricides.

Can you Expand the ACTUAL section of the debug? The Error section tells you that you had a SQL error, but the ACTUAL is the section where the actual rendered query is displayed. If you could copy and past that, i could see where the error is driven from and help you better.

I was not able to reproduce this error on my side.

Thanks,

Paul

Hello all. We are using your example to add validation to our form and it works wonderfully in IE but in Firefox it doesn't work at all. There are 2 of us and we are both using Firefox 3.6.3. Simple validation includes making sure a text field has text in it and if we delete the text and hit save/submit firefox returns no error and saves the blank record. Has anyone else seen this problem?

I know this topic is a bit old but I am new to OWS and found this the single best tutorial of any I have taken. Everything is carfully explained and understandable. It covers almost everything I would want to do with a data application. Thanks for a wonderful job.

While trying to use your validation example within one of my test application I cannot get one thing working correctly.

Onclick created by OWS Quickbuilder:
<button type="button" onclick= <br /> "$jq('#[AddEditID,A]').slideUp('slow');$jq('#[ListID,A]').slideUp('slow',function(){ows.Fetch('[ModuleID,System]',0,'Action=Save');});"> <br /> Save</button> <br /> <br /> My first attempt to add validation: <br /> <button type="button" onclick= <br /> "if (typeof(Page_SmartValidate) == 'function') return Page_SmartValidate('GroupRecordName');" <br /> "$jq('#[AddEditID,A]').slideUp('slow');$jq('#[ListID,A]').slideUp('slow',function(){ows.Fetch('[ModuleID,System]',0,'Action=Save');});"> <br /> Save</button> <br /> <br /> My second attempt to add validation: <br /> <button type="button" onclick= <br /> "if (typeof(Page_SmartValidate) == 'function') return Page_SmartValidate('GroupRecordName');$jq('#[AddEditID,A]').slideUp('slow');$jq('#[ListID,A]').slideUp('slow',function(){ows.Fetch('[ModuleID,System]',0,'Action=Save');});"> <br /> Save</button> <br /> <br /> With my changes the validation works fine but the record will not save. I'm sure it has to do with two onclick events on the same button and my understanding is this should work if I have the javascript organized correctly. Right now the second event does not fire. <br /> <br /> Any chance you could give me an idea where I went wrong? <br /> <br /> Thanks again for a wonderful tutorial.

I have no idea if Paul is listening, but he is the expert here.

You might also see if you can get help with this on the OWS forum.

Thanks for the reply Joseph. I will try OWS forum also.