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 Rhinorhino 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: CatManDave
  • Order by date
  1. CatManDave

    Upgrading SQL 7 to SQL2k script error

    Everyone, I am attempting to upgrade an existing installation of SQL7 to SQL2k. It gets through most of the upgrade with no problem until it gets to the final piece of the upgrade where it runs 17 SQL scripts. It fails immediately on script 1 with the insightful message error running script 1...
  2. CatManDave

    ADODB assembly not found

    Well it worked like a charm. Thanks a bunch.
  3. CatManDave

    ADODB assembly not found

    I wrote into certain purchase order VB.NET applications, EMAIL notifications. I added cdo for windows 2000 COM object in my project and everything works fine in development. Once I moved these applications to production (2000 Server), I started getting the following error: File or assembly...
  4. CatManDave

    Adding an alert to a CDO message

    Very nice post. I will give it a try. I would suggest anyone using CDO in .NET copy the code in your post. Thanks again, Dave
  5. CatManDave

    Adding an alert to a CDO message

    Guys, I have a request to mark EMAILs as urgent (!) that are getting sent as a result of a vacation request. I have looked at the CDO properties and methods and I don't see a way to do this. However, since is is common knowledge that the more you look at something the less you see, I was...
  6. CatManDave

    Getting selected values from form problem

    adamroof, I was just getting ready to blow the form away again and recreate and debug it one text box or DDL at a time. I wouldn't have gotten any different results, although I may have left work early for the bar :) You were absolutely right, I had not databound my DDLs or text boxes. Once I...
  7. CatManDave

    Getting selected values from form problem

    Guys, I'm still sort of new to .NET. I am having problems being able to get selected values from one of my forms. All I get are the original values and not any changes that may have been made. I have tried everything I can think of from completely redoing the form from scratch to creating a...
  8. CatManDave

    sqldataadapter.update error: String or binary data would be truncated

    Atmoic Chip is right. You have a column in a SQL table that has a character length too small for one of your values. It may not be your "Customers" column if you've double checked it. I would check every column you're updating because the error you're getting can be nothing other than a...
  9. CatManDave

    atoi problem

    Thanks BoulderBum. That should work just fine. -Dave
  10. CatManDave

    atoi problem

    Guys, I'm an old Visual C++ developer who hasn't use it for about 6 years. I am not using C#.net and I have a need to convert a string to int. In C++ it was easy to just atoi. When I try to use atoi in C#.net I get the old familiar "not in namespace" error. Here's the piece of code...
  11. CatManDave

    C#.net date format

    Chip, I tried that and I got a compile error stating that the "ToString" function only has one parameter. Thanks anyway, Dave
  12. CatManDave

    C#.net date format

    Guys, Thanks for your help, but I finally found the answer. If you're interested here's the code: wrk = tempDataRow["EDate"].ToString(); indx = wrk.IndexOf(" "); char[] DateArray = new char[indx]; wrk.CopyTo(0,DateArray ,0, indx); tempDateText= new String(DateArray); "wrk" starts with a...
  13. CatManDave

    C#.net date format

    You're sort of on the right track Chip. Here's exactly what I'm trying to do. I'm retrieving data, including a date (see below), from a SQL table using a stored procedure. wrk = tempDataRow["EDate"].ToString(); wrk now contains, we'll say, "7/2/2004 12:00:00". I want to now get rid of the...
  14. CatManDave

    C#.net date format

    Guys, I haven't worked in C for awhile and I'm trying to remember how to do the following: I have a date returned from a SQL table to a literal in my web app we'll call - EDate. This literal now contains the date but also a time. I want to eliminate the time portion and keep the date. This...
  15. CatManDave

    Setting mutiple item selections for Listbox

    Got it to work okay. Here's the code snippet: wrkarry = Split(docList, ",") phyBound = UBound(wrkarry) indx1 = 0 cmd = New SqlCommand( _ "SELECT DrID, DrInit FROM PhyDoctor " _ & "ORDER BY...
  16. CatManDave

    Setting mutiple item selections for Listbox

    Thanks Isadore. It looks like something that would work in my situation. I'll give it a shot. -Dave
  17. CatManDave

    Setting mutiple item selections for Listbox

    checkai, Yeah, that's whay I'm trying to do, however I do not know the proper syntax to code it. .NET tends to be very picky about how you code everything. That's what I was looking for. Thanks for your help, Dave
  18. CatManDave

    Setting mutiple item selections for Listbox

    Guys, I'm trying to load a listbox with database values and set multiple select values at the same time. For instance, I select an administrative assistant from a drop down box which kicks off the selected index change event which grabs the selected value of the drop down box and reposts the...
  19. CatManDave

    How to grab the session("LOGON_USER") variable in .NET

    Sure. Go to your Default Web Site under IIS. Then find your web app and right click for properties. You'll see the Directory Security tab. Click on it. CLick on the Anonymous Access button and make sure that ONLY the Integrated Security check box is checked. That will force the NT login...
  20. CatManDave

    How to grab the session("LOGON_USER") variable in .NET

    Thanks dragonwell. Worked as advertised. -Dave

Part and Inventory Search

Back
Top