jingxigirl's Q&A profile

• SQL Server Select customers who havnt made orders

  Using the northwind database, how do I select the cutomerID of customers who havnt placed an order. is it something like this select Customers.CustomerID FROM Customers INNER JOIN Orders ON Customers.CustomerID <> Orders.CustomerID and how can I display the customers who HAVE made orders alongside customers who havnt made orders. Thanks in advance. Using EXISTS/NOT EXISTS is the best way and straight forward. NOT IN will have problems if there can be orders with NULL CustomerID for example. Ex:   select t1.i from (select 1) as t1(i) where t1.i not in (select t2.i from (select null) as t2(i))   The query above will return NO row when it should return 1. With NOT ...Show All

• Visual Studio Tools for Office Manual Page breaks vs automatic page breaks in WordML

  Hi, I have a scenario where I'm programmatically generating WordML documents based on data from a database table. Sometimes, because of the source data in the database table, the output WordML a <wx:sect> tag spans more than one page in Word. Is there a way to insert a manual page break in the WordML for this section whenever this happens This way, I can make sure that for every row in the database table, the output will start on a fresh page in Word. At the same time, I want to avoid having consecutive page breaks which seem possible if I get this working. Thanks, JGP Be sure to let me know if I'm boring you... :-) Mail merge letters do this so that you can have a "Differ ...Show All

• Visual Studio to display all fields with null date vlaue in cryatal report

  hi, iam using vb.net and inbuilt crystal report. using dataset to populate crystal report. some date value is null in database . how to show it in report that particular record which contains Null date value is not displayed. i want all other fields to be displayed with date fiels as empty or some other string value. your help is very much appreciated. thanks. Check your dataset-if it's a stored procedure make sure that there are no conditions expressed on the date field (ex: not null) or that the date field is not linked to another table. If you are passing any kind of date parameter to this field then it will not include the records with a "null" value. If you are passing a date parameter, ...Show All

• SQL Server size of data replicated???

  hi, can anybody advice me how to find the size of the data replicated every minute. is there and procedure for getting the size of replicated data. Thanks in advance Jacx When you say size, do you mean how much megabytes per minute No, we don't track that information right now, but we're looking to do so in a future release. In the meantime, you can try perfmon, netmon, or you can run sp_browsereplcmds at the distribution database to estimate the existing data that needs to be replicated. ...Show All

• Visual C++ Activex browser

  Hi, I want to scan the registered objects into a list box to select the object like insert object dialog in VC++ or office. How can I implement it Thanks in advance. I would suggest you to examine the solution described in this article: http://www.codeguru.com/cpp/com-tech/activex/controls/article.php/c5527/ . I hope it helps. ...Show All

• Commerce Server Configuration Wizard (Admin database) fails

  We are currently installing a CS 2007 for a client. I have successfully completed the installation of CS and ran into some problems when running the Configuration Wizard. The log file contains the following [excerpt]: [09:21:14 INFO] Beginning configuration of feature Administration Database (Feature.MS.CS.Admin). [09:21:29 INFO] Database 'MSCS_Admin' exists on server 'SHOP' [09:21:29 INFO] The ComparisonStyle for Database 'MSCS_Admin' is 196609 [09:21:29 ERROR] CSConfig failed during configuration of feature Administration Database (Feature.MS.CS.Admin). [09:21:29 ERROR] Exception occured during feature configuration: Microsoft.CommerceServer.Internal.Config.ConfigurationException: Incorrect syntax near '0x0a0d'. Must declare the sc ...Show All

• Visual FoxPro MsComm Problem

  My dear Professor, Thank you very for helping me on many forums. Now I am facing a serious problem about MsComm. I am using MsComm with following properties Commport :1 Setting :4800,n,8,1 Handshaking :0,ComNone InBufferSize :1024 OutBufferSize :512 RThreshold :0 SThreadhold :0 InPutLen :0 EoFEnalbe : UnMark PartiyReplace : NullDiscart :Unmark RTSEnable :Unmark DTREanable :Marked I do not use any event of MsComm. Following commands are under a command button Thisform.mscomm.portopen=.t. abc=thisform.mscomm.input Mscomm receives weight from Input Device called HB-8210. Everything work fine in VFP 6 on WIndows 98 platform. ***Now problem details When I run this form, with same settings, on Win ...Show All

• Visual C# Help me in sending mail thru gmail sys every time please try after some time

  i tried to send mail using c#, the code is displayed below MailMessage mailmess= new MailMessage(); mailmess.To="pp_tprd@yahoo.com"; mailmess.Subject="hi this is a test"; mailmess.From="pramodib@gmail.com"; mailmess.Body="hi this is a test"; SmtpMail.SmtpServer="smtp.gmail.com"; mailmess.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", 465) ; mailmess.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", 1); mailmess.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "myname"); mailmess.Fields.Add("http://schemas.microsoft.com/cdo/configurati ...Show All

• Smart Device Development ActiveSync and SpamPal

  I've been receiving so much spam that I installed SpamPal. I've learned that it listens on 127.0.0.1. Something strange is happening whenever I sync my Dell Axim X30. The Axim retrieves my e-mail (from SpamPal I assume) even though I don't want it too and never instructed it too! Is there a setting or such I can change to stop this from happening Robert W.. This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. If you’re having a hardware issue, please contact hardware manufacturer or reseller. If you having an issue with 3rd party software, please contact respective software manufacturer or reseller. Othe ...Show All

• Visual C# how can i serialize a object received from a MessageQueue?

  I am sending to a message queue objects of a type "employee" ( a type that i created), sending part executes properly.. i need to know how i can retrieve the objects properly, how can i serialize it back to "employee" type currently i'm using the following code.. it doesnt work.. BinaryFormatter binaryFormatter = new BinaryFormatter (); MessageQueue msgQueue = new MessageQueue (MessageQueueName); System.Messaging. Message msg = msgQueue.Receive(); msg.Formatter = new System.Messaging. XmlMessageFormatter ( new string [] { "System.String" }); Employee emp = ( Employee )msg.Formatter; MessageBox .Show(emp.Name); Hi, Have you i ...Show All

• Visual Studio 2008 (Pre-release) Options I miss in svcutil.exe

  How do I generate code for ServiceContracts only (without DataContracts at all) How do I auto-merge code and .config-s from >1 services at once As you mention, for 1, you can use /r, for 2, there is no option to do it. You can use Mex OM to do it if you really want it. basically you can use mexdataexchangeclient ( http://msdn2.microsoft.com/en-us/library/system.servicemodel.description.metadataexchangeclient.aspx ) to download multiple medatadataset and merge them together yourself, then use wsdlimporter to import code ( http://msdn2.microsoft.com/en-us/library/system.servicemodel.description.wsdlimporter.aspx ). ...Show All

• Visual Basic Upgrade Wizard Error - SSTab

  Hi, I am attempting to upgrade a working VB6 project to VB.Net 2003. I am using multiple forms in the project and a couple of them use the SSTab control. When the Upgrade Wizard attempt to perform the conversion I get the following message... Upgrade failed: Exception occurred: The referenced component SSTab is missing a design time license. I have tried registering the ocx on the system that I have 2003 installed on, copying the ocx to the folder where the source code is and neither has cleared the error message. Any help resolving this will be greatly appreciated. Bruce Thanks. I have taken the SSTab out of the project and now I get another error - see my posting 'VB Upgrade Wizard error'. Nothing in this life ...Show All

• Visual C++ VS .Net 2005, how to disable intellisense...

  Hi I am really frustrated with the performance of VS .Net 2005. This is because I always see at the bottom "updating intellisense..." and it uses 60% to 70% of CPU. How to disable this updating of intellisense... Please this is making Visual studio unusable. Thanks Chandra I just want to join the chorus. The intellisense update is making my C++ project (hundreds of files, many hundreds of classes) unusable. Please restore the VS 2003 performance. ...Show All

• Visual Basic Problem with XPath

  Hello, I am having some problems with XPath. First off, I would really love to read some good documentation on it. I feel that the vb.net documentation on XPath usage is just terrible. If you know of any really good documentation for XPath with vb.net, please point me to it. Now on to my real problem. I have xml like this <foo> <bar>blah</bar> <bar123>test</bar123> </foo> and here is that I am using (gleaned from some site mostly). This is what it looks like after tearing my hair out and trying to fix it. Dim xpathDoc As XPathDocument Dim xmlNav As XPathNavigator Dim xmlNI As XPathNodeIterator xpathDoc = New XPathDocument(path) xmlNav = xpathDoc.CreateNav ...Show All

• Software Development for Windows Vista Using the WF rules engine editor

  Hello there, I am working on a project where I am using the WF rules engine frequently. I have a set of rules that need to be implemented into the WF rules engine. But when I was implementing the rules into the rules editor (the dialog that came along with the WF) I found a problem. I need to write a rule like.. if ( ifCondition ) DoSomeWorks(); else if (elseIfCondition) DoSomeOtherWorks(); else DoDefaultWorks(); But I am facing trouble inserting this rule. the dialog does not allow me to insert the else if part. If I break down the else if part to another if-else group then the it will be too complicated when I have a long if-else if-else if- else if -....else chain. one more thing I found that the rule ...Show All