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 Rhinorhino 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. newbieDev

    Query to insert 300 recordsfrom one table into another

    Hello, I have been having a hard time with this so I decided to ask for help. I am trying to insert student names from one table to another. The student name is the primary key in the new table and I have about 300 records. How do i insert all records at once? Thanks NewbieDev
  2. newbieDev

    Selecting records between Two Dates

    Hello, I am trying to write a query that selects students that enrolled between a two dates: select firstname, lastname from students where startdate >= 10/1/2007 and startdate <= 09/30/2008 But this is not working for me because there is something I should be doing with the dates that I...
  3. newbieDev

    How to simultaneously update 3 fields in 3 different tables

    Hello, I am trying to update 3 fields in 3 different tables - these fields are related so for some reason I can't change one before the other. I tried updating the primary table first, and then the other tables using it as a foreign key but it wouldn't let me. Is there a cascade update thing...
  4. newbieDev

    single sign on usinf Microsoft windows login username/pin number

    Thanks Phil, Yes, the users may have to login at their workatation to use the application without entering their username and password - I think we may have something else for users who are not at their workatations to enter their username and passwords. This option will only show if the user...
  5. newbieDev

    WMI Scripts for finding out info on person using application

    That's almost all I was looking for! I will give it a shot. Thanks!
  6. newbieDev

    ControlM and Oracle

    Thanks! I will give this a shot and let you know how it works out.
  7. newbieDev

    WMI Scripts for finding out info on person using application

    I am pretty new to WMI Scripting but I heard one could use it to find out who is current logged into an access Database/application. Would really appreciate any help with puting the script together - I want to be able to know the workstation/username/time/date that the user logged in, and...
  8. newbieDev

    Microsoft Windows Environment Variables

    Hi Everyone, Does anyone know how to capture windows environment variables for Windows XP in coldfusion/Html? I am trying to use such info for login security. Any help will be appreciated. Thanks!
  9. newbieDev

    ControlM and Oracle

    thargtheslayer - What do you mean by take care of the tables for me? Do you mean I shouldn't worry about students being related to all the classes etc that they currently have in the access database? And that the tables will be loaded with new ID but relationships will be kept intact? I am not...
  10. newbieDev

    single sign on usinf Microsoft windows login username/pin number

    Thanks fo the response philhege - Yes, it is an intranet App. Yeah, the problem is users sometimes have to use other workstations so we have to at least keep track of the username, and check it against the username and access level in the DB. Is there a way to capture windows workstation...
  11. newbieDev

    Access Database Corruption Issues

    Thanks Guys, JoeAtWork - The front end is an Access MDB file (with I think some VB6 code)which links to an Access DB backend. Yes, everyone is opening the same fromt end. Hmm... I actually thought about that for a second but discounted it because i don't know that much about access. I'll try...
  12. newbieDev

    ControlM and Oracle

    Thargtheslayer, Thanks for the response. This is the problem I am trying to solve: We have this application created using an access database that is now being transfered to an Oracle Database which will have more tables than existed in the original Database. We are trying to assign new...
  13. newbieDev

    ControlM and Oracle

    Hi Guys, Thanks for the reply! thargtheslayer - Let me see if I get this: After doing everything needed to create the external table, I will not need to create source tables in Oracle, but query the external tables (which is really a text data file) for records that need to be inserted into my...
  14. newbieDev

    Access Database Corruption Issues

    I have an application that was created using an Access Database backend and a Visual Basic forms front end. The users have been geting numerous error messages informing them that the Database has been corrupted - ussually all we have to do is restore the VB GUI fron end and everything will be...
  15. newbieDev

    single sign on usinf Microsoft windows login username/pin number

    Hello everyone, I have a few questions. I currently have a ColdFusion application in which users are assigned a username and password to be able to access/use the application. The problem is people are tired of entering different passwords for different applications and they would like a...
  16. newbieDev

    Single Sign on with Microsoft Windows usename/password

    Hello everyone, I have a few questions. I currently have an application in which users are assigned a username and password to be able to access/use the application. The problem is people are tired of entering different passwords for different applications and they would like a single sign...
  17. newbieDev

    ControlM and Oracle

    Hi everyone: I need some help with some data migration related issues. I am receiving a couple of flat files from a DB2 database. These flat files will be placed in a designated folder. I was told this folder will have to be on a server that has COntrolM so that it could be picked up by ORACLE...
  18. newbieDev

    Access Database Migration to Oracle Database

    Hi Everyone, I have some data migration questions. I have been tasked with migrating an Access database to an Oracle database. The Oracle database structure is different from the Access database as I now how more tables, and existing tables were somewhat modified to have more or less fields...
  19. newbieDev

    auto suggest drop-down and 508

    Is there a way of making the auto suggest drop-down 508 compliant? It should pass both JAWS and Dragon testing. Thanks, NewbieDev
  20. newbieDev

    Displaying search results during a search

    Thanks for the reply!

Part and Inventory Search

Back
Top