Recent content by JabbaTheNut

I have CR8 Reports (.dsr files) embedded in my VB6 project. When I run the project, a temp file is generated (by Crystal Reports?) for each report. Is there a way to turn this activity off? Why is CR creating these temp files? thank you Game Over, Man!

I have a large number of queries in an Access 97 db. I am deleting a table and would like to modify the dependent queries. I do not remember which queries are using this table. Is there a quick way I can do a search of tables used in queries. thank you Game Over, Man!

I am in the market for a good database comparison and synchronization tool. I have read about the following tools thus far: RedGate SQL Compare DB SynchroComp AdeptSQL Diff ApexSQL Diff Based on your personal experiences, what would be the best tool to buy for comparing both structure and...

I want to restrict access to a subdirectory based on the port over which the request came. For example, if the request comes over port 80, it would be denied. If it comes in over port 8080, it would be allowed. I know this sounds strange, but here is why I want to do this. I am using an SSL...

I have developed a web-based ActiveX control that will transfer sensitive files via https from the server to the client over the internet. To do this, the client would click a button on the web page which would supply the ActiveX control the URL and password info required to access the...

bump Game Over, Man!

I found the following entry in my IIS logs. I immediately updated my server with the latest patches through windowsupdate.com. However, I am afraid there may have been a security breach. Any suggestions on how I can investigate? 2004-01-16 14:21:09 64.x.x.x - 192.x.x.x 80 GET /NULL.IDA...

I have phone numbers that are in 10 digit format (i.e., 2125558888). I want to format them in the following manner: "(212) 555-8888". I know I can do the following: -------------------------------------------- string myNum = "2125558888"; //the source would be a field in a...

I am looking for a good way to handle null integer values in a class. I need to develop a class that will extract data from several tables which can contain null values and provide the results in a set of property values. For example... ################################## private int x =...

The answer is: It is ok to assign a transaction to multiple commands. I apologize for asking a question that was easily answered with relatively little research effort. I imagine it was much like my asking: Do you use "open" to open a connection? Game Over, Man!

Are there any potential problems with assigning the same transaction to multiple commands? I want to execute a few commands. However, if any one of them fails, I want to rollback everything. The following code illustrates what I want to do (Note that I am assigning the same transaction to both...

AngelWPB, That worked perfectly! Thanks :) I wonder why the CASE statement (and others like it) is supported in the Query Analyzer, but not in the Query Designer? Seems strange to me. Game Over, Man!

I have the same problem trying to create a View. However, when I try the above suggestion in the Query Designer, I get an error that says the CASE statement is not supported in the Query Designer. I have used ISNULL(MiddleInitial, '') before. However, it does not handle the '.' issue...

r937, Excellent! You saved me a lot of frustration. Thanks :) Game Over, Man!

THE LAYOUT: I have two tables: "Applicant_T" and "StreetSuffix_T" The "Applicant_T" table contains fields for the applicant's current address, previous address and employer address. Each address is broken up into parts (i.e., street number, street name, street...