Ricky Pusch's Q&A profile

• Commerce Server associates Tags To products

  Hello Does any one have a suggestion on How to create Tags in commerse server and associate them to a product The Tag need to be multiValue (each producr in a specific category can have more than one tag). The Tag also need to be multilingual Thanks Arik You can create multi value (it's called Multiple Choice) properties for Catalogs. Look into the schema manager by creating a multi value peroperty then associate it to a product definition. You can only have one tag per product. You can also create a property and call it tags which is a comma dilimeted list (just make sure that you spell it correctly in every product) then do a like search. Doing like searches can be a perf hit on SQL. You could enable ...Show All

• SQL Server RSInternalError when drilldown levels have zero rows

  SSRS 2005 (No service packs yet) - We have a report that supports a drilldown to a subreport. When the subreport level has no rows and the user attempts to click on the "+" the user gets an RSInternalError. As long as there is one subreport item in one of the groupings the report does not generate an error when the "+" is clicked. ...Show All

• Visual Basic Reading Bits

  I am pulling an 'int' data type out of SQL Server with a length of '4' which I want to read the bits.  I have no clue on where to start on this as far as declarations or methods to use...I need to be able to read each bits to see whether it is set or not.  Possibly the easiest way I see is to store each byte as an array of bits so then I could just loop through and do my comparisons.  I do not need to write, just read.  Thanks a ton! EDIT Sry - I screwed up trying the example - It does give a list of boolean values representing the 1s and 0s. I've been looking at this for a while and haven't found any built-in methods for doing this.  Most methods that refe ...Show All

• .NET Development your code solution please?: System.Web.Mail Help Please...

  Hello, I've tried searching and searching, but I've had no real luck. I'm working on sending an email via an external SMTP server (I'm trying to use Gmail.com, could this be a problem ) and then send to another email, which also happens to be a Gmail.com address. Now, before posting my code, I'd like to say, what I'm developing this for is basically a plugin for a program based on .NET 1.1, so I don't believe that System.Net.SmtpClient is an option, so therefore I'm stuck with System.Web.Mail. Hmm, I've tried some classes from Codeproject.net, but none seem to be working, as I still get crash errors. I'm not sure if it's the SMTP server or not. GMail allows people to use third-party programs such as Outlook and Thunderbird to ac ...Show All

• Windows Forms WSUS Install Fails; There is a problem with this Windows Installer package.

  I am trying to install WSUS on Windows Server 2003 R2 and the installer fails with the above error message. The log files are shown here: ********** **** 2006-06-01 14:29:15 13:29:15 Executing External Command: C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -ir ***** ***** 2006-06-01 14:29:26 13:29:26 External Command Exited, Return Code: 0 ***** Running a transacted installation. Beginning the Install phase of the installation. See the contents of the log file for the C:\Program Files\Update Services\Setup\bin\Microsoft.UpdateServices.Setup.CustomActions.dll assembly's progress. The file is located at C:\Program Files\Update Services\LogFiles\WSUSCa_060601_1426.log. Installing assembly 'C:\Program F ...Show All

• Windows Forms change form in a console application

  hello world! a simple question, i need to change the output "form" of a console application, how can i pass the control from a consol page to another I’m sorry but I still do not understand... if from your console application you are spawning off a form or two, you do so just like you described above... Are you looking to spawn off new console windows from a single master window the same way you would spawn new forms off from another form or console app ...Show All

• SQL Server SSIS <DTS:PackageVariable>

  Just noticed I mis-posted this on public DTS forum so posting here. I'm building packages programmatically. I notice that if I open them in BIDS after building them, then make a change, my package grows in size trememdously. An example today went from 60k to 90k. The reason is that when the package is resaved in BIDS a large section of XML is added with <DTS:PackageVariable> info. I read on http://sqljunkies.com/WebLog/knight_reign/archive/2005/1/13.aspx why this info exists. My question is, since I'm not creating it programmatically, do I need to It seems that it doesn't have to be there for the package to run correctly. Am I safe creating packages that do not have this section of info Thanks! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Post-Processing Woes

  I've started experimenting with full-screen post-processing after using a tutorial on Ramblings of A Hazy Mind (tutorial number 8 I believe), that lets you modify many things using pixel shaders, unfortunately I'm unable to find good examples of post-processing effects that will work with this implementation. I'm not really looking for a different way of doing this, rather I'd like to port an effect I've had trouble with into something that will work with Hazy Mind's system. The main one I've had a problem with is a Blur/Glow effect that I found on the XNA5D site, unfortunately it also implements a vertex shader which I have no knowledge of (I know very little about pixel shaders also) so I don't know how to get it to work without involvin ...Show All

• SQL Server Exceptions in Data Flow Scripts

  What is the "correct" way of dealing with exceptions in a data flow script component. i.e. am I supposed to catch all exceptions and then set some failure flag The reason I ask is I've got a script in a dataflow which is occasionally throwing exceptions when trying to convert an empty string to a decimal. Problem was the package locked up and had to be terminated when the exception was thrown (and not caught in the script) The only thing which differentiates this package from others I've created is the data flow has a conditional split which creates 2 seperate paths loading 2 seperate SQL tables - the exception is being thrown in a script on one branch which seems to hand the entire flow PS I have fixed the script so t ...Show All

• SQL Server Adding images with SQL Server Express Management Studio

  Can I add images to a table with SQL Server Express Management Studio If so, how, if not, what alternative methods other than the point-and-click can I use Thanks in advance, Fedor Steeman hi Fedor, there's no "point and click" solution for your requirement in SSMS... but you can "load" a column executing the appropriate Transact-SQL statement.. something like SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.TestTB ( Id int NOT NULL PRIMARY KEY, img varbinary(MAX) NULL ); GO PRINT 'retrieve the img from file'; DECLARE @img varbinary(MAX); SET @img = ( SELECT Q.BulkColumn FROM OPENROWSET(BULK 'D:\MVPLogo.gif', SINGLE_BLOB) AS Q ); SELECT CONVERT(v ...Show All

• Visual Studio 2008 (Pre-release) XLinq: Get XElement Line Number

  Hi, Does anyone knows how I could read the line number of a particular XElement read from a XML file Regards chionhhm I have posted an example to http://blogs.msdn.com/mikechampion/archive/2006/09/10/748408.aspx ...Show All

• Visual Studio Team System Get files listed for a specific Changeset

  How do you get just the files which are listed in the details dialog for a particular Changeset From my root project, I need to get all the files which were merged in under one changeset. I did a get Specific version and in Version type I, I specified the Changeset a wanted. I thought this would get me just the files that were checked in for that changeset but instead I got all the file for that project. What do I need to do The changeset tells me there are 5 files which were merged in, all from a different location. I don't want to go and get each file separatly and click on get specific version with the changeset number, i want to get all 5 files in one hit by specifying that changeset. ...Show All

• Visual Studio Express Editions how can I integrate C program in VB express?

  how can I integrate C program in VB express Regards, Yaniv Here's what I did to test. Created a C Win32 DLL, removed all the superfluous ***, including the precompiled headers: Created a file called test.cpp #include <windows.h> float __stdcall DoMultiply( float x, float y) { return x * y; } Added a .DEF file, also: LIBRARY "test" EXPORTS DoMultiply @1 Compiled it into a DLL (removed the precompiled headers that the 'wizard' put in), then created a VB Windows program: Public Class Form1 Private Declare Auto Function DoMultiply Lib "test.dll" ( ByVal x As Single , ByVal y As Single ) As Single Private Sub Form1_Load( B ...Show All

• Visual Studio 2008 (Pre-release) Is WSE going away?

  Hello. As you may have seen in this post of mine (clicking on it is optional): http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1022444&SiteID=1 I have not been able to write a WCF client to consume our java-based web service. And I'm wondering, is WCF replacing the WSE-approach to writing WS clients Or is WCF just another layer that is supposed to make things "easier" for developers I am able to write a client using either WSE 2.0 and 3.0. Maybe not being able to use WCF is not such a bad thing. Or is it In other words, is it a MUST that a web service is consumable by a WCF-based client Is WSE being obsoleted Thanks in advance for your inputs. Ever This http://msdn.micr ...Show All

• SQL Server insert statement problem

  Hi all, I'm trying to calculate the data from one table and insert the results into another table. The queries are the following: 1. select top 5 userId, count(photoId) numOfPhoto from photo group by userId order by count(photoId) desc 2. select top 5 userId, count(photoId) numOfPhoto from photo where datesubmitted > DATEADD(dd,-30,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) and datesubmitted < DATEADD(dd,-8,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))group by userId order by count(photoId) desc 3. select top 5 userId, count(photoId) numOfPhoto from photo where datesubmitted > DATEADD(dd,-7,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) and datesubmitted < DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) group by userId order by coun ...Show All