tattoo's Q&A profile

• SQL Server Display Last 2 Comments to a Record

  Ok, I'll try to explain this as best as I can... I have an Invoice Record in one table (Invoices) and in another table (Comments) I have multiple comments to an Invoice. I'm looking for a statement that will output the last 2 comments per Invoice Record. Example: The Comments table has multiple ID #'s corresponding to the ID # in the Invoices table. Invoice ID # 1 has 4 Comments; Invoice ID #2 has 3 Comments; ID# 3 has 2 comments. The output would be 6 records with 2 comments for each ID #1, 2, and 3. Something like this should work for you, Scotty. You may be able to tweak it a bit but hopefully this will get you a start. select InvoiceID , Comment , Date from Comments C1 ...Show All

• .NET Development SOAP Attachements Interop (c# <-> java)

  Hello, I have a requirement to implement WebServices Client in C# and WebServices Server in Java(webSphere). The application involves uploading attachments. Preliminary research suggest I use MTOM, but the webSphere app server I am going to be using does not support MTOM. I have to restrict my ideas towards either MIME or DIME. Please suggest best approach with the mentioned constraints...any sample code with the interop(C# <-> Java) would be appreciated. Thanks in advance. Cheers, Sridhar. You can use WSE2 (Web Services Enhancements version 2.0) with .net 1.1. MTOM is supported in .Net 2.0 with WSE3. See http://msdn.microsoft.com/library/default.asp url=/library/en-us/wseref/html/N_Microsoft_Web_Services2_Dime.asp for more deta ...Show All

• Visual Studio VSS 6.0d - moved servers - cannot reconnect VB6 projects

  Over the weekend, our Visual Source Safe database (v6.0d) was moved from one server to another. That said, updating our VS2003 applications to point to the new source control was easy. The thing is, we still have some VB6 applications floating around that also need to point to the new source control. How do I change an individual VB6 project's source control database path   Right now, when I try to open an existng VBP file (for a project already in VSS) in VB6 , I get this error:  Access to file " \\server01\Vss\data\rights.dat " denied  The reason for this File server "server01" no longer exists, and the new server is "server02" (names made up just for simplicity reasons - long story short, I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bug where it becomes impossible to save your files

  Hi all, Has anybody encountered a bug where somehow XNA game studio express doesn't allow you to save your files I've encountered it once (and I forgot the message it popped up unfortunately), but I thought it was a one-off thing. Then a co-worker told me he got it quite regularly when starting and stopping programs. Just wondering if this is something that more people are experiencing. At the time I had two XGSE's open, one with my (saved) project, and one with a temporary spacewar project. Unfortunately when I was trying to repro this bug, I couldn't get it to do this again. My co-worker gets it when editing files while the program is running. Cheers, Nick Waanders i have seen this problem a few times. ...Show All

• SQL Server Field type as date and not datetime

  Hi, In my application i am sending mails depending upon some subscription data. The mail has a table, which has a column of type date. Currently  the content is showing the datetime i.e. for eg: 11/09/2006 12:00:00AM but i want it to display only the date i.e. 11/09/2006 I have given the fieldtype in the eventclass as Datetime as sql server data types doesn't have date as datatype. I have tried to use convert(varchar(10),<DATE>,101) in the queries, but still shows the date with the time. Can i change the xslt i.e. content formatter, so that it shows the date only & not the datetime Or is there a better way   Thanks in advance, navbhan   Hi fafnir, I changed the field type to ...Show All

• Visual FoxPro how to check for your prg running?

  heres my prob. when you launch my application and minimize it and then try and launch it in a second screen you get alot of errors. how can i check if the program is already running so i know to cancel the prg right away if it is alrdy running Another possibility... use Windows Management Instrumentation Service... I use this function to kill existing processes I don't want running... PARAMETERS pc_ProcessToKill * Get connection to Windows Management Instrumentation service lo_WMI = GETOBJECT ("winmgmts://") * Set query into service to look for process to kill lc_Query = "select * from win32_process where name='" + pc_ProcessToKill + "'" * ...Show All

• .NET Development Shared ownership of an IDisposable object.

  Hello, Recently while writing a Managed DirectX project, I was in the situation where I wanted to share textures between several objects. Textures (like many other MDX classes) implement the IDisposable interface, so I need to call Dispose() on them when I'm done with them. Obviously one object can't call Dispose() on a texture if it's still being used by another object, which leads me to the situation where Dispose() can only be called when no other objects need the texture. I'm from a C++ background, so to me this suggests that I use a reference count, e.g., like boost::shared_ptr , but I was wondering if there's an accepted .NET design pattern for this situation that I should use instead Thanks for your advice, Peter Hi Salvador, ...Show All

• SQL Server Subreport question

  I am converting an older report from Crystal Reports to Reporting Services. On this report there are several subreports where in Crystal, I was able to create "links" to items from the parent report and only those items in the subreport that matched the items in the main report would display. I am having a problem with this in SQL RS. I built the parent report and now I am creating the additional subreports. When I put the subreport on the main report, ALL records from the subreport are displayed. How do I "link" the subreport to the parent report and only display the items I would like Thanks for the information and help. You can pass in parameters from the main report to the su ...Show All

• Architecture Asp.Net application hosting on Linux

  Hello All, I have developed an ASP.Net application in .net framework 1.1 I want to host my application on linux server. Should I need to re-write my code or there is any solution provided by Microsoft. Urgent reponse would be great. Thanks a Lot! hi all, i got an asp.net1.1 project running in windows iis server on XP. can i able to port it to the sun solaris machine. will this mono project support ado.net,user controls, xml parsing... thanks for your valuable information ...Show All

• Visual Studio 2008 (Pre-release) LinearGradientBrush in a Setter Value??

  I was woundering how can i set the Value in a <Setter> Tag to a LinearGradientBrush Example:: <Rectangle.Fill> <LinearGradientBrush StartPoint="0,0" EndPoint="0,1"> <GradientBrush.GradientStops> <GradientStopCollection> <GradientStop Color="white" Offset="0" /> <GradientStop Color="transparent" Offset="1" /> </GradientStopCollection> </GradientBrush.GradientStops> </LinearGradientBrush> </Rectangle.Fill> Putting the Above into the Value below:: <Setter Property=" ...Show All

• Visual C# receive sms in web application

  Hello, I need receive a sms in web application and work with the content. How i do this Some idea Thanks Welcome to the MSDN Forums! You need an SMS Gateway that can receive SMS text messages, most of the companies that deliver these services provide a API as a Webservice or something to read the text messages. There are alot of companies that deliver these services, so just find one that satisfy your needs. They can be found easy with any search engine like google . A other option is to buy a SMS Modum or a Cellphone and connect this to a PC. Most modums and phones support reading the textmessages. The most cheap way is to use a Cellphone that supports reading the textmessages (most do!). ...Show All

• SQL Server looping through table tom exec an SP many times

  Hi, If i have an SP called mySP that accepts one parameter @param If I have a table of paramaters with only one column like this: Param1 Param2 .. ParamN How do I do if I want to execute the SP on all the table fields: some thing like this: Exec my SP 'Param1' Exec mySP 'Param2' ... Exec mySP 'ParamN' I want that automatically since the parameters are going to be in a table called myTblParams Notice that I don t want to pass all the parameters to the SP just once but only one value each time I execute the SP since mySP ccepts only one parameter. Thanks a lot for guidelines If I understand you correctly, you want to execute mySP for every row in the myTblParams table. To do this, you could write another sp that has a cursor to l ...Show All

• SQL Server Questions about "Dimension Processing Destination" & "Analysis Services processing Task"

  First I will thanks for any friends open this one. My questions is: 1.What's the diffrent between Processing a dimension by "Dimension Processing Destination" or just by "Analysis Services processing Task" I found that I could do the same work by both, and the MSDN tell nothing about the diffrence. 2.Why the Process Option in the "Dimension Processing Destination" is diffrent to the Process Option in the "Analysis Services processing Task" to deal with a dimension In the "Analysis Services processing Task",the Option is the same with the MSDN, without the "incremental" option. But in the "Dimension Processing Destination",there is the "incremental&qu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is XNA a Game Engine or Middleware ?

  Hello I'm sorry about this thread but I did not found any concrete informations on what's exactly XNA Game Studio Express is... I know it's a framework like XNA about game making which support Xbox360 etc. but : 0) Is XNA GSE is a Game engine 1) Is there features like : collisions, physics, tilemaps, particles, scripts, network libraries 2) In what way concretly XNA GSE will help me to achieve games better than others middlewares like BlitzMax, Torque Game Builder, Haaf Game Engine, ... 3) I'm intend to write 2D games and have some experiences with those Middlewares but often fall into engines limitations, it is why i seek C# 2D full featured Game Engine without any result at this time :( Thanks for your help :) ...Show All

• Windows Live Developer Forums Contact Groups Not Updating Between Computers

  I have two computers which I use live messenger. On one computer my contact groups have updated to reflect the most recent changes I have made. I verified this by viewing the contact group on msnspaces. On the other computer the contact group list will not update. What is going on What news groups Sorry for being obtuse, but I found this thread via a web search. How do I find these news groups I'm having the same problem. On WebMessenger and on Live Messenger on my laptop, my contact list is perfect. Here on my desktop, however, I have a few contacts that have not updated. Thanks in advance ...Show All