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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lfc77

  1. lfc77

    IBuySpy

    Never mind anyway...
  2. lfc77

    IBuySpy

    Obviously I tried that...it redirects back to asp.net.
  3. lfc77

    IBuySpy

    Where has IBuySpy gone? It used to be found at asp.net... Cheers, lfc77
  4. lfc77

    stored procedure question

    If I have multiple table updates in a stored procedure and one fails, does this mean that the earlier updates are automatically rolled back, since the stored procedure is a block of code that is run as a whole? Cheers, lfc77
  5. lfc77

    sockets in C#

    When did this forum change from Tek-Tips to Sarcastic-Tek-Tips??
  6. lfc77

    viewing triggers

    Cheers Katy!
  7. lfc77

    viewing triggers

    How can I view all triggers for a particular database? I'm currently trying to find if there are any triggers on a large number of tables by right clicking on the table > all tasks > manage triggers and it's taking forever. Can anybody help me out? Cheers, lfc77
  8. lfc77

    sockets in C#

    How do you use sockets in C#? I need to convert some old VBScript code to C#, and I need to establish a socket connection to another machine and then send to it. Any assistance would be really appreciated. Cheers, lfc77
  9. lfc77

    appending text to a file

    Found a good example here : http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=5
  10. lfc77

    appending text to a file

    Does anybody have a simple example of appending text to a text file? Cheers, lfc77
  11. lfc77

    stored procedure parameter question

    DBomrrsm, Yes, all the string variables in my app are initialising to "" before I try to populate them with the contents of an XML file. If the relevant tag in the XML file is there, then I populate the string with it, otherwise I leave the string in the state it was in when it was...
  12. lfc77

    stored procedure parameter question

    This seems to work : UPDATE MyTable SET Column2 = CASE @Param2 WHEN '' THEN Column2 ELSE @Param2 END Cheers, lfc77
  13. lfc77

    stored procedure parameter question

    John, That isn't quite what I was trying to do. If the Param is empty, I DON'T want to update the field....is this possible? Cheers, lfc77
  14. lfc77

    stored procedure parameter question

    I have 9 different parameters which are coming in from an XML document, and they may or may not be entered by the user. When I am parsing the XML I am setting a string to the value of the relevant parameter, so if the value is entered by the user, the string will equal that value, otherwise the...
  15. lfc77

    stored procedure question

    Cheers SQLSister...that could explain some of the problems we've been having with one of our websites. Thanks, lfc77
See more

Part and Inventory Search

Back
Top