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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: jimoo
  • Content: Threads
  • Order by date
  1. jimoo

    How execute JS

    I am have a basic understand of JS and I have worked with VB Script quite a bit so I am familiar with scripting languages. I have decided to explore my knowledge of JS further. Of course, there are lots of examples and articles. The basic question I have is what is the best way for me to...
  2. jimoo

    How to set variable to field in current row

    I am trying to set a couple of variables to equal the field values of the current record so I can process that information. I put together sample code that creates a temp table and has 2 attributes (animal & breed) and I would like to set the variables myAnimal and myBreed accordingly based on...
  3. jimoo

    Need to Comma Separate Multiple Fields together

    I have data in several fields that need comma separated and combined in one field. I will called the output field MyResults MyReults will begin with F1 for field01, F2 for field02, and so on. The data in MyResults should not begin or end with a comma. Below is code to create the table and...
  4. jimoo

    Unexpected Join Results

    parent table (p) has 569,275 records and child table (c) has 633,283 select count(*) from parent -- 569,275 select count(*) from child -- 633,283 All parents have at least 1 child select p.* FROM [parent] p where p.pID in (select cid from child) -- 569,275 matches parent count Why...
  5. jimoo

    Seek Max record of a Group

    I am seeking a query that will return the last item (max) based on a set. The personID is the same for several records. I would like the last record for each. For the 1st person (1458748) the nameid I'd like to return is 1405 and the name lastname is Smith. In short, there are 6 sets in...
  6. jimoo

    I am trying to get a list of all

    I am trying to get a list of all tables and counts for a data conversion project so I can work to eliminate tables with 0 records and identify core child tables. Below is code that I put together that retrieves a unique table names from the database and has a field named cnt (count) for me to...
  7. jimoo

    Export Many SQL Tables to Excel

    I am using SQL Server 2012 and Excel 2016. I need to export all tables in a database that end with the word "type" to excel. I queried the database and got a list, and I was able t do it using the export tools, but that wasn't efficient. I then did it from excel data tab and selected the tables...
  8. jimoo

    Odd Julian Date to Gregorian / Calendar Date

    I have some data that came from AS/400 DB2 and it contains julian date data that is described as INT (7) and I need to convert it to a normal calendar date (gregorian). Here is a format of the data. This would represent 10/27/1960 1960301 - should be converted to 10/27/1960 1977308 -...
  9. jimoo

    Excel to DBF

    I have not used Foxpro for several years and a friend has asked me a question that I don't recall for sure. He is trying to use Foxpro exclusively to convert an excel file to DBF. In the past, they have used Access as an interim but are trying to get away from that for a few reasons. If my...
  10. jimoo

    Quality Certification

    I don't know if this is the right forum, but I don't see a section about Quality under the certifications forum so I will try here. Does any have any recommendation on which body to use if one is seeking a quality certification. For example, I found the following: 1. Certified Associate in...
  11. jimoo

    Exam simulator

    I am considering launching a site with an exam simulator. Does anyone know if there is one out there that can be used? The simulator would have to provide me a way to add / update questions and seen results. Jim
    • jimoo
    • Thread
    • Replies: 2
    • Forum: PHP
  12. jimoo

    Read / Write and display environmental variable

    Looking for a script that can read an environmental variable and then display it. Also, looking for a script to write to one. Would like to be able to test interactively. Jim
  13. jimoo

    Exam simulator

    I want to create a website that will link to an a web bases exam simulator with a set number of questions and length of time. For example, 100 questions in 2 hours. I'd like to be able to add tests and categorize the questions. Example: TEST 1 (Sports, Music, Math, Science) I'd like for...
  14. jimoo

    Is it possible to delete records without logging them to the log file

    We have a SQL Table with over 155 million rows covering about 10 years. We want to delete out all by the current 4 years worth of data but are concerned it will overfill the log. Is there a way to delete these records without logging them to the log file and/or do you have another suggested...
  15. jimoo

    IE Freezes when popup is opened

    I have an application that uses a content switch that directs to 2 web servers. When using the content switch, the application hangs when opening a java popup using IE, but not other browsers. The application also works correctly if the url contains the names of one of the 2 web servers...
  16. jimoo

    Timer - Showing stop watch time on form

    I want to show a time elapse on a form. The time will continue to show starting at 00:00 and then go up by 1 second intervals: 00:01 = 1 second, 01:01 = 1 minute 1 second, etc.. The timer control is the best option, but how to implement to show the time as I mentioned and stop with the elapse...
  17. jimoo

    Need Assembly Microsoft.vbe.interop 15.0.0.0

    A legacy vb app that has been convert .net has landed on my lap to make a change to and install on a user's pc. It is a "fat" app. It runs fine on my pc but when I publish the project and the try to install in on the user's pc I encounter the following: Unable to install or run the...
  18. jimoo

    Comments do not show when hoving over object in 2013

    I just upgraded to Visio 2013 and opened a document that contains a flowchart. Several of the boxes have comments added to them and when you hover over the box the comment is supposed to popup. This works fine in older version of Visio but it not working in my new version. I suspect it is a...
  19. jimoo

    Identifying Social Security Numbers with reverse order digits

    I am cleaning some legacy data and have noticed there are individual in the Database twice with the same 9 digits in their social security number (SSN) but 2 of the digits are reversed, probably because of a keypunch error. I am looking for a way to identify people with the same 9 digits, but 2...
  20. jimoo

    SASS Naming convenventions

    Our database is SQL server. Our naming convention is CamelCase and do not use underscores. A contractor is creating a database (warehouse) and it will primarily use SASS to access the data. The contract used a naming convention as: FIRST_NAME, LAST_NAME, etc.. Tables are perfixed with DIM...

Part and Inventory Search

Back
Top