I have a drop down list that is populated by fields from a table
called PayGradeSteps.
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
the drop down list is populated but when I take the values the user
selected and insert them my employee table my salary is being cut
off. Here is the code for the insert:
if not isempty(Request.Form("OK")) then
SField = Request.Form("PaySalary")
Salary = mid(SField, 6, 4)
PayStep = mid(SField, 1, 2)
conn.execute "update tblemployee set " _
& "Salary = '" & Salary & "', " _
& "PayStep = '" & Paystep & "', " _
& "Paygrade = '" & Request.Form("Paysave") & "' " _
& "where SSN = '" & Request.Form("EmpId") & "' "
Response.Redirect "./Previous_Addh1.asp?LoginSSN=" & Request.Form
("Save1")
end if
set RSEmp = conn.execute("select * from TBLemployee where EmpId = '"
& EmpId & "' ")
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
this in my testing though).
Any help is greatly appreciated.
Karen
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/
