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/
