No I have not tried to compare against an empty string.
I inherited this system. so I have what I have. I appreciate you help. --- In [email protected], Scott Dexter <[EMAIL PROTECTED]> wrote: > Convoluted Context Switching, Batman! > > > > Here is the code > > Do Until RSPayGradeSteps.EOF > > %><% Pay = RSPayGradeSteps("PayStep") & " $ " & RSPayGradeSteps > > ("PaySalary") %> <option Value="<% response.write Pay %>"><% > > response.write Pay %></option> > > <% RSPayGradeSteps.MoveNext > > Loop > > This is an aside to your issue, but to ease readibility and the > webserver's heart rate, you might reconsider how the above code is > structured. Each pair of <% %> toggles the webserver in and out of > 'ASP code reading' mode, which is a performance hit. > > > > > SField = Request.Form("PaySalary") > > Salary = mid(SField, 6, 4) > > PayStep = mid(SField, 1, 2) > > So you have one form field that is responsible for two data elements? > Eek. I think your trouble might lay in the mid(SField, 6, 4) call > above. Is it possible to redo the form itself and make it two > separate form fields? > > > > Can you tell me how I can fix this and also how can you validate > > that a value is being inserted into the field in the employee > > table. > > I have some records where no value was inserted (I cannot duplicate > > You can compare against the empty string (""). If it's empty, don't > insert it. Have you tried that? > > > Good luck, hope this helps-- > Scott Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
