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 gkittelson 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: *

  1. JStevison

    Zero Length Double Type Problem and datetime problem

    When I look at the fields with myphpadmin it says the field length on these fields is 0.
  2. JStevison

    Zero Length Double Type Problem and datetime problem

    After upgrading from 4.0.16 to 4.0.18 any field that had a zero length has been destroyed. Specifically I had some double fields that had "4" and now have "2.055313086699586e-320". I also had some some datetime fields that have 0 length that now have "0000-00-00 00:00:00" where there were...
  3. JStevison

    IN Operator question

    That's what I was looking for. Thanks a million.
  4. JStevison

    IN Operator question

    Thanks for the post. I get the same exact output either way. Any other suggestions.
  5. JStevison

    IN Operator question

    Why does this not work? select * from Menus where 'g' IN (Menus.menuSecurity) Explanation: Menus.menuSecurity contains an nvarchar field with this data - a,b,c,d,e,f,g,h I get 0 results. If I remove everything except the letter g I get a result of 1 record as expected.

Part and Inventory Search

Back
Top