Search results for query: *

I have a frameset with two frames. Both the frames have forms. What I wish to do is have the top form have one button that submits both frames. Is that possible? And how? I had the idea that the top window, from javascript, would submit the bottom frame, check for the existence of a variable...

What I want to do is take a string, entered by the user, and then make a valid database query from that. They will be searching a text field for certain words. What I am having a problem with is taking the input and creating the query. If they type in: CDE -sun -solaris I want to have this...

I want my document root to be authenticated for everything but the "index.html" file. Basically I want users to be able to see the index page before they have to authenticate. I would then authenticate for everything else. Is that possible? lance

My "onChange" code is executing in Netscape 6.2.2 even when I make no change. The problem really is that I come into my page the first time and it works just fine (change the data and the onchange event code fires). If I do a refresh on the page, which sets the data back to original...

I came up with this user defined function today. Was wondering if someone would look at it and see if anything is wrong? /* * User Defined Function :: fn_Drop_Weekends * * In trying to find the datediff between two * dates, there was a need to exclude the weekends. * Thus this function...

Will office 2000 work on XP? If so, are there any problems? Lance

This is my first attempt at a plpgsql function. Here is what I have thus far: create function fnInsWeeks() returns integer as ' DECLARE --theDate wedates2.wedate%TYPE; thedate DATE; BEGIN SELECT INTO thedate wedate FROM wedates2 WHERE id=(SELECT MAX(id) FROM wedates2); INSERT INTO...

I have my backup setup as follows: DECLARE @theDate DATETIME SET @theDate=GETDATE()+7 BACKUP DATABASE CustomerSupport TO CustomerSupport WITH EXPIREDATE=@theDate I thought I understood the EXPIREDATE parameter. Could someone tell me what is supposed to happen when the expiredate is reached...

I have data in a table as this: NUM State Transition_Date ---- ----- --------------- 1430 0 2001-10-09 10:57:52.000 1430 1 2001-10-13 09:42:52.000 I have more than just this record with states 0 and 1. What I want to come up with is this: The AVG difference in hours...

Here is a quote from the books online: Quoted identifiers are used by default in SQL Server 2000, that is, they are set to ON. This is different from SQL Server 7.0 where they were set to OFF by default. Here is my problem. I developed my system, using v7, to have double quotes around all...

I have worked with Oracle in the past. If I wanted a single script to run several scripts I could do this (in Oracle): list of files: main.sql a.sql b.sql c.sql contents of main.sql would be: @@a @@b @@c...

I installed red hat the other day. I can configure X so that I can use it (and everything works just fine). When I exit out of the X desktop (to go back to command line mode), it just hangs. The power light on the monitor starts blinking and command mode never comes up. The...

Is it possible to get a file inserted into a table? If so, how? Or would it be better to store the path to the file into the table? We are trying to come up with a way to allow customers to upload flat files to our support site. The flat files will more than likely only contain text...

In oracle we had sequences (database object that was an auto-incremented number) which are very useful to build data for primary keys. Is there such a thing in MS Sql Server? I have search the online books but have not found anything compatible.