Recent content by amillia

The Oracle stored procedure below is called into an asp page as an ADO dataset. CREATE OR REPLACE PACKAGE BODY "PACK_CHARLESTON" AS PROCEDURE CHARLESTON (JKNUM OUT o_JKNUM, JKNAME OUT o_JKNAME, BUILD OUT o_BUILD) IS -- To retrieve the...

Thank you very much for your help. I changed the code a little because what I realized I really needed to do was set the field in the asp page when the record set was pulled. Here is the jest of the code. <script type="text/javascript"> var now = new Date(); function putDate(now) { if...

I have a cHTML page with a date field called obj_lmt_dte which I need to insert todays date and time into when the a field called obj_lmt is entered. The format for the date field I need is 5/5/2007 1:02:03 PM. I am trying to build the script myself but I don't know javascipt too well so any...

Thank you, this works great. You made my day.

I just thought I can make this alot simpler by putting a timestamp into another table when an update occurs to the user_info table. I don't really need the username and date from the user_info. All I need is a table to hold each time a user logs in. That should be simple. I will keep working...

The login trigger is not an option because the system we are using for a front end is pooling sessions. What do you mean by statement level?

I am trying to write a trigger that when the user_info.ui_lastlogin is updated then I want the data sent to another table. The point of this is that the user_info table is only keeping up with the last time a person logged in and their user name. We need every time a person logs in and their...

I changed the <=7 to <=8 and it works. Thank you very much for this. Excellent.

When I ran it it is skipping a day. Here is the table data SCORE SHOP WEEK_ENDING 1.5 722 10/9/2006 1.6 722 10/16/2006 1.65 722 10/23/2006 1.45 722 10/30/2006 1.85 722 11/6/2006 1.95 722 11/13/2006 1.75 722 11/20/2006 1.85 722 11/27/2006 1.95 722 12/4/2006 Here is the output of the query...

sample data from table SCORE SHOP WEEK_ENDING 0.75 722 11/21/06 0.1 722 11/28/06 2 722 11/14/06 1.5 722 11/07/06 1.7 722 10/31/06 1.7 722 10/24/06 1.4 722 10/17/06 1.22 722 10/10/06 1.4 722 10/03/06 1.5 722 09/27/06 1.12 722 12/05/06 What I need output from the query SCORE...

This is difficult to even understand, sorry but Let me try to clarify. Week_ending is actually a name of a field in a table and is one day which will be filled in one time on every Monday. So for this Field Week_ending I need the Week_ending and the other fields for the past 8 weeks plus a...

I need the dates from the field week_ending for the past 8 weeks also I need the next 4 week dates and I have to have it under the same field name because I am using it with coldfusion charts. Can anyone help. Some of my code: SELECT shop, (Five_S_tbl.week_ending and Five_S_Tbl.week_ending...

I am having a problem when I output my chart with dates alone the bottom all of the date data reads 12/31/69. I know the data is right because when I output the dates in a simple cfoutput tag then it works fine.

I have one heck of a query that I have tried several different approaches to get it to work and I am just about over it. So I come for help. I have to find the turn around time between several dates in my tables. Then I have to find the average TAT for a specific group of aircraft. Depending...

Okay, we got this going with what carp sent and I had to take out the execute sequence stuff because I didn't have sufficient privileges. Thank you for your help. It was great and I will definately pick up the book you recommended. This is the final code. CREATE OR REPLACE PROCEDURE DOCNUM AS...