Search results for query: *

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

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

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

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

Is there any way to compile a recursive function without it "failing" the first time? It does seem to actually complile, but shows an error in the output. If you compile it a second time, it works without error messages. CREATE OR REPLACE FUNCTION Rbm_Fgetholdoverlength( txtlease...

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

Hi, I'm having a little problem with and outer join (and I can't get TGML to work either). It's the one that I tried to highlight below. SELECT trim(foc.code_name), trim(bc.code_name), TRIM(pt.code_name) , trim(pu.code_name) , SUBSTR(a.st_fcly_cde,3,2) AS st_fcly_cde ...

I am trying to do a timeline based on number of days only. So if there is a date in the future, I want to show - 45 days for a task, 30 days for another and show the cumulative day counts (regardless of date). I don't want to display any dates at all. Is this possible? Programming today is a...

Sorry if this seems basic but I'm having a brain cramp this morning. I want to update a table with data from another table but I really don't need to join the two. My query from the second table returns just one row. So it looks something like this UPDATE myTable SET col1 = subquery.colA...

It's been about 5 years since I trained on Oracle and I haven't used it since (I've been using SQL Server). I'm trying to write a basic function that will take a date and make sure that it happens between 7AM and 5PM M-F excluding holidays. I know that I could do it in a SQL Server procedure...

I'm trying to connect to a server via VPN and I don't know its IP address only its server name. I can query the server via an ASP page that I wrote. Is there a query that will return the IP address of the server? Programming today is a race between software engineers striving to build better...

I'm importing data from an excel file and for some reason I only get 1599 rows (there are 1900 in the spreadsheet). Any ideas on what's going on? Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce...

I'm trying to clean up massive amounts of code. The biggest problem that I'm having is pinpointing the cause of memory leaks. I'm pretty sure that the main cause is objects that are not killed correctly (or at all). In the following : set cn = server.createObject("adodb.connection") cn.open...

I'm trying to clean up a large site that isn't formed too well. We started having memory problems about 2 months ago and they seem to be getting worse. The IT department had to restart the site this morning and it was using 1G of RAM. We watched it go up 30M in just 20 minutes. Something is...

I've created a site for the local soccer association's referees to record game scores. On it there is a very basic feature to send the user their password. Many of these emails are being blocked as spam - perhaps because I am listed as the sender but the server the emails are coming from is...

I have a table that holds data from a linked server. It is updated daily. tLease leaseNum effDate expDate When I update it, I need to add any new leases as well as update any leases where the effective date or expiration date has changed. Is there any way to do this without checking each...

I'm working on a stored procedure that pulls data from a Sybase table via a linked server. When I write a direct query like select * from sybServ.dbo.table1 where field like 'VA008%' I get no result. I do get a result if I broaden the search but I still don't get records above 'VA007%'...

While working with a page that uses an excel object yesterday, it suddenly started to hang. The code is ' create the Excel object Set excelApp = Server.CreateObject("Excel.Application") ' open the spreadsheet file excelApp.Workbooks.Open Server.MapPath("../uploads/lrt/abstracts/" &...