Recent content by SBpsc

Hi: We are using WSS 3.0 with Search Server Express. I have a question about the modifying the Search results display. When you search on a contact (ex: Branson), the display looks something like the follwoing: Branson Eric ...ericbranson@test.co...

I am using SharePoint 2003. When I upload a document to the site, I get two alerts - one that says the document has been added, and another that says that the document has been modified. I was expecting only one email about the document being added. Does anyone else have this problem? Any ideas...

Hi: Using Crystal Reports XI and MySQL 4.1.5 Each report has a query in the Command box of the Database expert in Crystal Reports. There are more than a 100 reports that have been delivered to the customers. Unfortunately...we have found a bug in the queries that need to be fixed. Does anyone...

I had the same problem with our reports and it was horrible because our reports were sent to clients. The reports would take forever to run because it was trying to find my machine. Anyway, to fix the problem, I turned on the "No printer" option from the File | Printer Setup. In this way, the...

Thanks Feherke. It worked great. I got the results I wanted.

Using MySQL 4.1 I have the following table: Stat | StatDt | ChkDt ========================= 1 | 8/3 | 8/3 NULL | NULL | 8/7 23 | 9/12 | 9/12 5 | 9/17 | 9/17 NULL | NULL | 9/25 NULL | NULL | 10/1 If a stat is available (NOT NULL value), the StatDt...

I am using a simple HelloWorld servlet that runs just fine under the /classes folder, but it does not run under the /classes/bjohnson directory. Works as: /classes/HelloWorld Does not work when I run it as: /classes/bjohnson/HelloWorld I have the .class file in both folders. Both folders...

Thanks a bunch. It worked. - SB

The datatype for the Date column is DateTime.

Using MySQL 4.1.5. I am pretty new to writing SQL queries so I am hoping someone can help me with this. I have the following data in a database. ID | Date | Value ------------------------ 2 | June 3 | 10 2 | June 15 | 5 2 | June 20 | 7 2 | July 7 | 10 3 | June 8 | 2 What I...

Thanks, LB. It did not fix the problem by itself but I added on a few more formulas with it and was able to get the charts to display correctly. Thanks for the advice. - SB

I am having some problems with running totals and charting and I hope someone can help me. I am using MySQL 4.1.5 and Crystal Reports XI. Trying to chart the actual cost per month. Currently, I have the following formulas: ActualCost:If type = 'a' then CCur(mycost) else CCur(0); I also...

Hi: I am really new to xml and have a question about apostrophe. What is the difference between &apos; and &#8217; If I use &apos; for something defined as an element, the page displays properly. It gives me garbage if I use &#8217; However, within the paragraph <p>...</p>, I have to use...

Hi: I am new to stored procedures so I am hoping someone can point me in the right direction... My original query looks something like: (SELECT * FROM db) [tab]AS tb1 INNER JOIN (SELECT tb2.a, tb2.b FROM db WHERE tb2.b='xyz') [tab]AS tb2 ON tb1.a = tb2.a Using stored procedures, I...

Yes, I am very new to stored procedures and still a novice to databases too. Got thrown into the pit and I am trying to get myself out of it... Thanks for the information though. They really helped. - SB