Search results for query: *

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

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

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

I am creating a stored procedure to create a new number everyday into a table called Next_NUM. The fields in the table are called Todays_dte and fld_next_num. I am using a sequence for the number to be put into fld_next_num. I should only have one row in the table. This is my first attempt at...

The javascipt I am working on that does not work goes like this: <script language="javascript"> function assign_dte (){ if (document.form.test_one.option.value = "test1" ){ document.form.test_two.readonly="true" } } </script>

UPDATE dbo.SoftOwnIndex, dbo.tblSoftwareOwnerComp SET dbo.SoftOwnIndex.Competency = [dbo.tblSoftwareOwnerComp].[Competency] WHERE ((([dbo.softOwnIndex].[SOKey])=[dbo.tblSoftwareOwnerComp].[Pkey])) The thing is that I get an error at the first comma. So I thought I would take out the second...

I have the following code in an xsl doc. <td colspan="17"> <select name="frm" tabindex="1"> <option> <xsl:attribute name="value"><xsl:value-of select="mci/form"/></xsl:attribute><xsl:value-of select="mci/form"/> </option> <option value="ROCK">ROCK</option> <option...

I need to write a vb script that when the select box named LSP in an XSL page is set to JKW then focus must go to another select box named LMB and the user should not be able to leave the LMB box until something is entered or value is not null. I don't want the LMB box to even be available...

do you guys see any obvious problems with this query. UPDATE tbl_INSPECTIONS, Query3 INNER JOIN Query4 ON (Query3.PARA3 = Query4.TASK_NO1) AND (Query3.CARD1 = Query4.CARD_NO1) SET Query4.REQ_ID = tbl_INSPECTIONS.REC_ID;

I have a huge update query, that goes and gets ids from many look up tables about 20. Should i use pass through queries instead of putting it all together in the update query? do you know of an example? I can post an example of the query i am working with but it is rather huge.

I am inserting a table with a field that contains a leading zero if it is one character. IE: 01,02,03...10,11,12. I need the first 1-9 to be a single digit so it will match one of my the fields in the join. I can't change it to a number because of the join. How do I trim off the 0. thank you...

I need to use the timer event when I run a macro which opens two queries. I need to find out how long it takes to run the macro. How do I do this?

I have a function that i want to use to format a julian date as a regular date. Where do I put it? so I can use it on a field in a query. I'm am quite sure this is an easy question but I don't know so I had to ask. Thank you.

What would be the best way to rename styles in a word document? Could I use a search and replace procedure?

We have around 200 Tech pubnical publications that we will be converting to xml. The have the xml already and all of the associated files. The problem is that the word documents do not have associated files so when they are imported everthing is clumped together as normal style. What is the...

We have a pdf. that we require links within the document to other bullets in the same document. What is the easiest way to do this?

Basically I need to put the ghannt view in my project file in a power point presentation. Can anyone help me?