http://www.learnasp.com/learn/debug2.asp
gives good model for seeing if a SQL statement generates an error.
If it does generate an error emailing onself the SQL statement will
allow you to diagnose why it errored and fix the data later since you
will then have a record of what they tried to insert.
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/
