Search results for query: *

Carp, Thanks for the replies. I think I found a solution by partitioning the row number on the folderid... SELECT m. (select rr.efolderid, rr.return_reason , 'sub' src, rr.return_date FROM rbm_treturnreason rr JOIN eevent e on rr.efolderid = e.efolderid AND e.eactionname = 'Can Not Accept'...

Thank you both for the responses. Unfortunately, the events table is part of a commercially sold software program and should not be modified (it currently has about 4.5M rows). Also the returnReason table has 60k rows and while I can add a column to it, I'm not sure how to populate that...

I have a table that records all events (events). Some of those events causes data to be written to a second table (returnreason) where we have a column that counts the iteration as the event may happen more than once. Unfortunately I cannot find a way to link the particular event to the...

That is interesting. Does it work in 9i? For now I will stick with the current solution I have. Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe...

carp, What I've actually seen is that the job will run immediately when it is unbroken whether is is scheduled to run or not. Fortunately all of my jobs run either hourly or nightly. The hourly ones will run an hour after everything is enabled again and the nightly ones will run the night...

I was able to develop a solution: CREATE OR REPLACE PROCEDURE job_fixer AS CURSOR broken_jobs_cur IS SELECT job, interval FROM user_jobs WHERE broken = 'Y'; dtNext date; BEGIN FOR job_rec IN broken_jobs_cur LOOP execute immediate('select ' || job_rec.interval...

Thank you for the reply. My issue is that I cannot seem to unbreak the job with a value in the next_date field. The value is there in the USER_JOBS table in the INTERVAL field event after the jobs is broken. The problem I am having is that the value is a text field like 'SYSDATE + (1/24)' and...

I am delivering a script that will be run by a customer. At the beginning of the script, I break the jobs so that they will not start during the script execution. At the end of the script, I am fixing the jobs. The only problem that I am having is that a job that is fixed executes immediately...

I think it will take me a while to absorb the whole page, but I have been through the first few examples and I have found them well written and extremely helpful. I will have to try to work them into my queries and try to get used to using them. Thank you again. Programming today is a race...

...> TO_DATE('1900','yyyy')) )x , ( SELECT txtAssignedAnalyst, TRUNC(dbms_random.value(1,cnt)) rnd FROM (SELECT txtAssignedAnalyst, COUNT(*) cnt FROM rbm_management WHERE TRUNC(dtActualDay2Complete) = TO_DATE('2/14/2008','mm/dd/yyyy') OR (TRUNC(dtWithdrawn) =...

Thank you for the reply. Example #2 is more accurate. The RequestNumber field is actually a 17 digit alpha-numeric field that really isn't sequential at all. Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe...

Hi, I am trying to write a query that will give me one random row per user. Let's say the table has a userName column and a requestNumber column. The requestNumber column is unique so that one user may have many requests. Can I write a query that will list each user once with a random request...

Hi everyone, I'm a little stuck on this one... Table eEvent tracks actions that happen to items in rbm_management. I need to find the last event that happened before billing (the billing date is returned by the function rbm_fGetBillingDate). The code works very fast when I hard code the...

I have a table which tracks events - the data looks like this. EEVENTID EFROMSTAGE ETOSTAGE EEVENTTIME 3 Request Creation Validation Check 6/26/2007 18:29 4 Validation Check Initial Review 6/26/2007 18:29 12 Initial Review Data Input 6/27/2007 15:51 21 Data...

Chopstik - server.urlEncode will actually do the opposite of what I want done. I'm trying to prevent encoding of the string which seems to be happening on its own. My script that says response.redirect "http://myserver/Metastorm/customASP/ownedIRG.pdf#page=7" makes...

I am trying to redirect to a PDF file and open at a certain page. Unfortunately, the "=" sign becomes "%3D" in the address bar and does not resolve. Is there a way to prevent the encoding? response.redirect "http://myserver/Metastorm/customASP/ownedIRG.pdf#page=7" Programming today is a...

...VARCHAR2, dteff DATE) RETURN NUMBER IS intMonths PLS_INTEGER := 0; intResult PLS_INTEGER; BEGIN SELECT COUNT(*) INTO intResult FROM RBM_MANAGEMENT m, EFOLDER f, RBM_TACTION a WHERE m.efolderid = f.efolderid AND m.txtactiontype = a.action_code AND...

Here's the final solution I worked out... <xsl:template name="text.replace"> <xsl:param name="texttosearch"/> <xsl:param name="texttofind"/> <xsl:variable name="textlength" select="string-length($texttosearch)"/> <xsl:if test="$textlength &gt; 0"> <xsl:choose> <xsl:when...

Here's where I am so far - I can call the function and get the results for 'ABCZ' - but I can't figure out how to replace it with a carriage return... <TD align="center"> <xsl:attribute name="headers">idFolderName<xsl:value-of select="position()"/></xsl:attribute> <xsl:variable name="aMess"...

I'm working with a COTS product that uses an XSL page for some of its output. We are trying to add line feeds to the text that is output by <TD align="center"> <xsl:attribute name="headers">idFolderName<xsl:value-of select="position()"/></xsl:attribute> <xsl:value-of...