Should I post my question there? I have inherited this system and
do not know a lot about ASP . There is no error. I just need to
know how do I keep the salary from being cut off
Here is a snippet of the data they see in the drop down list
<option Value="22 $ 10.20">22 $ 10.20</option>
<option Value="23 $ 10.25">23 $ 10.25</option>
<option Value="24 $ 10.30">24 $ 10.30</option>
<option Value="25 $ 10.35">25 $ 10.35</option>
<option Value="26 $ 5.50">26 $ 5.50</option>
<option Value="1 $ 9.05">1 $ 9.05</option>
<option Value="2 $ 9.10">2 $ 9.10</option>
<option Value="3 $ 9.15">3 $ 9.15</option>
When the value = 1 through 9 the first number is the salary is
deleted when the record is written to the employee table.
thanks.
--- In [email protected], Charles Carroll
<[EMAIL PROTECTED]> wrote:
> 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/
