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 Mike Lewis 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
  • 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

    How much do i have to ask for a web site?

    I would like a copy. I think I just lost a job because I did not have a detail contract. I have one typed and ready to go, But I would be interested in what you have, Just to compare. Thanks again.
  4. bla1979

    how do I return anything in year 2005

    Another Way... Select DATENAME(yy ,somedate) as 'Somedate' from mytable Where DATENAME(yy ,somedate) = '2005'
  5. bla1979

    Case or not to case...

    Hey Guys Thanks for all the answers, I am ending up going with select blog_id,blog_author, Blog_title,blog_date, Case When DateDiff(dd, blog_date,GetDate()) < 1 Then 'Today' When DateDiff(dd, blog_date,GetDate()) = 1 Then 'Yesterday' When DateDiff(dd, blog_date,GetDate()) = 2 Then...
  6. bla1979

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

    Thank You SQLDenis, You are the man.
  7. 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.
  8. 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...
  9. 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