Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bla1979
  • Content: Threads
  • Order by date
  1. bla1979

    Round Number onchange

    I have been trying to figure a way to round the value of a number onchange event. Just not working.. <html> <head> <script type="text/javascript"> function round(x) { var y=document.getElementById(x).value document.getElementById(x).value=y.Math.round() } </script> </head><body>Enter your...
  2. bla1979

    Where Clause on first 3 number

    I have a table of zip codes, I want to be able to search by only the first 3 numbers, but I want the user to input all 5. Anyone have a clue.
  3. bla1979

    RIGHT command on NTEXT. Not work?????

    I have a NTEXT field, I want to only show the first 100 characters from it, not sure how. I tried this but got the following error. Select RIGHT(com_text,100) from blog_comment ERROR: Argument data type ntext is invalid for argument 1 of right function.
  4. bla1979

    Case or not to case...

    I am pretty sure I sure use case, but not 100% if it will be the best way. Here's what I got, I have a blog site, I want to create a query that shows the 10 most recent blogs, But I want to change the value in the date column to show if it posted "Today" or "yesterday" or "2 Days" or "+3 Days...
  5. bla1979

    Need to alter current trigger. With delete before insert

    This trigger works perfectly. Unfortunately, I need it to do more, I THINK , I need it to delete the previous insert that this trigger performed first before it inserts the new values. Here the whole thing. I have a table called blog_blog, it has the following trigger on it. CREATE TRIGGER...

Part and Inventory Search

Back
Top