Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JabbaTheNut

    CR8 in VB6 Generating Excessive TMP Files on Compile

    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!
  2. JabbaTheNut

    Searching All Queries in an Access 97 db for Existence of a Table

    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!
  3. JabbaTheNut

    Database Comparison and Synchronization Tool?

    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...
  4. JabbaTheNut

    Use Web.Config to Restrict Access to a Subdirectory based on Port?

    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...
  5. JabbaTheNut

    Secure Transfer of Data to an ActiveX Control from a Web Page

    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...
  6. JabbaTheNut

    Security Breach?

    bump Game Over, Man!
  7. JabbaTheNut

    Security Breach?

    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...
  8. JabbaTheNut

    Simple phone number formatting question

    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...
  9. JabbaTheNut

    Class strategy for handling null integers

    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 =...
  10. JabbaTheNut

    Assigning the same transaction to multiple commands

    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!
  11. JabbaTheNut

    Assigning the same transaction to multiple commands

    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...
  12. JabbaTheNut

    SQL: Only put a period "." if there is a middle intial.

    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!
  13. JabbaTheNut

    SQL: Only put a period "." if there is a middle intial.

    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...
  14. JabbaTheNut

    Normalized Addresses - Need Help

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

    Normalized Addresses - Need Help

    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...
  16. JabbaTheNut

    ActiveX Control to Access Client-Side Devices

    I want to develop a control that I can embed in my web page that will interact with a USB signature pad device on the client's machine. I have a third party ActiveX control that does this now. However, I wanted to develop a better control for use on my site. My client's are all restricted to...
  17. JabbaTheNut

    ActiveX Control to Access Client-Side Devices

    Is it possible to write an ActiveX control in Visual C# that can access client-side hardware devices and does not require the client to have the .Net Framework? Game Over, Man!
  18. JabbaTheNut

    dynamically generating a pdf file

    While I am not 100% certain, I believe there is a concurrent user limitation with Crystal Reports for VS.Net. I thought that I read that the limit was 5 concurrent users. To enable more, one would need to purchase additional licenses. Please correct me if I am wrong. Game Over, Man!
  19. JabbaTheNut

    Get Text Value of a Drop Down

    ter79, Use this... var ddl = new Object(); ddl = document.form.ofclist; var ofc = ddl.options[ddl.selectedIndex].text; If you don't want to create the new object as above, you can do it this way... var ofc = document.form.ofclist.options[document.form.ofclist.selectedIndex].text; Either way...
  20. JabbaTheNut

    Command Still Executes When Cancel Is Selected On Dialog Box

    Blaxo, You are awesome! Thanks :) Game Over, Man!

Part and Inventory Search

Back
Top