http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk
is better place for this question.
All the Classic ASP experts live there. Many of them are not on this list.
On Mon, 10 Jan 2005 19:31:50 -0000, klrclark <[EMAIL PROTECTED]> wrote:
>
> 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 Sponsor
>
> ADVERTISEMENT
>
>
> ________________________________
> 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 the Yahoo! Terms of Service.
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/
