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!

  • Congratulations strongm 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. MikeCallon

    Exception Handling in Collection - Suggestions ?

    Thanks for the pointers guys.... While we're at it - what if iIndex is < 0 :-)
  2. MikeCallon

    Exception Handling in Collection - Suggestions ?

    Hi there, I've created a collection class, but what's the best way of handling an exception that occurs when the user of the class requests an invalid item from the collection ? So in the Example below, what's the best way of handling the situation where the user of this class passes an iIndex...
  3. MikeCallon

    datepart returning wrong date

    vongrunt, You're right about the date in VB (should check things out myself rather than relying on second hand info next time eh ?) I guess we have to try and fix the way that VB converts the current date to a double so that it matches SQL Servers (seemingly correct) interpretation of the...
  4. MikeCallon

    datepart returning wrong date

    Thanks for the replies. We're stuck with doubles - this is a large legacy database - there are a lot of applications reading the data - I can't change the data type without loads of potential problems. I'm not looking forward to breaking the news that their date calculations maybe incorrect -...
  5. MikeCallon

    Calling a SP with changing Parameters

    Can you edit the stored procedure to use : WHERE YourCriteria IN(YourCommaDelimitedListOfSelectedItems) instead of "WHERE YourCriteria = " within the stored procedure ? Mike
  6. MikeCallon

    default value in a combo

    In order to be xhtml compliant you'll need to do a Response.Write("selected=""selected""") instead of just "SELECTED" Mike
  7. MikeCallon

    datepart returning wrong date

    Sorry if this is the wrong group but this is my first post - total newbie so please be gentle...... We have a SQL Server database where dates are stored as a float in a field called DT_StartDate (the dates are entered from a Visual Basic application running on various clients which use...

Part and Inventory Search

Back
Top