Search results for query: *

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

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

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

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

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!

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

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

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

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

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

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

I am trying to create a page (using ColdFusion) that while trying to search for a particular record based on what is typed in the search box, results are displayed on the same page - It will be similar to how the MS Outlook Adress book functions - while typing in the type Name or select from...

I am trying to create a page that while trying to search for a particular record based on what is typed in the search box, results are displayed on the same page - It will be similar to how the MS Outlook Adress book functions - while typing in the type Name or select from list search box...

Hi Everyone, I have a question someone here might be able to help with. I want to send date notifications to a list of people using cfmail. However, I want the email to be in the form of a meeting request so that it can automatically be placed on their calenders. Is there a way to send the...

Hi Everyone, I have an SQL Loader related question. I am expected to load about 3 tables with information that would be sent to me in one excel file. My first thought was to break this table into 3 different tables that will actually match the fields in the target table, and then create the csv...

Hi Everyone, I am trying to generate id numbers using sequence for an existing database. The problem is that the data currently in the database does not follow any order and the numbers are pretty random. The highest ID in the table is 2345 - this does not mean that every number from 1 - 2345...

Hi Everyone, I am trying to generate id numbers using sequence for an existing database. The problem is that the data currently in the database does not follow any order and the numbers are pretty random. The highest ID in the table is 2345 - this does not mean that every number from 1 - 2345...

Hello everyone: People have been making changes to an access database we are working on. Mainly, the changes have been inserting data into tables. We just noticed that all the changes that we have made since monday are now not showing. I have research and found that everybody in the team made...

Hello, I am trying to automatically generate 6 digit numbers in a Coldfusion Application. When a user clicks to add a new product, I want the generated numbers to be in the form when the product information is being entered.The problem is that the database already contains numbers for some...

Hi Everyone, I have an oracle DB question. I am trying to convert an access DB to an Oracle DB. What is the best way to transfer my data from access to oracle without having to create admin pages to add data manually? Do the tables in both DBs have to be identical, that is same name and...