Search results for query: *

I have a dmp file that's a full export of my database from a few days ago. One of our devs wants the data contained in that export from table X. The tricky part is that he doesn't want to overwrite the current table X with the old data, he wants a new table (Y) created with the same data from...

Anyone know if it's possible to bg a process and keep it running even after logout? I've tried nohup, but it's an irc client so I need to interact when I bring it into the foreground. Ideally I'd like to be able to ssh into my server, launch the program and when I'm ready to log out, Ctrl-Z...

answer dawned on me a while after I submitted. If anyone's interested, the command I used that works is: SELECT LOCATION, TIMES FROM( SELECT LOCATION, COUNT(LOCATION) TIMES FROM TABLE_NAME GROUP BY LOCATION ORDER BY TIMES DESC ) WHERE ROWNUM < 6

I have a table with the following 3 columns: Ticket_Number, Location, date_created I need to return a top 3 list that contains the locations sorted by the count of each location. For instance, say I have 10 rows total. 4 rows have &quot;Main Office&quot; for location, 3 have &quot;Satellite...

I've got strings of numbers like: a = 4 b = 416 c = 723 d = 1534 I want to be able to convert these numbers into time format so that a = 12:04am b = 4:16am c = 7:23am d = 3:34pm Anyone know of a quick and painless method?

A simple insert command that I use: set ad = CreateObject(&quot;ADODB.Connection&quot;) strConnect = &quot;Provider=SQLOLEDB;Server=169.254.1.1;database=testdatabase;uid=dbaseuser&quot; ad.Open strConnect form1 = Request.Form(&quot;field1&quot;) form2 = Request.Form(&quot;field2&quot;) form3 =...

I'm having trouble accessing a file with the Scripting.FileSystemObject. The following works great: Set fs = Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) Set folder = fs.GetFolder(&quot;E:\webfiles\directory&quot;) However, when I try to use the UNC, I get a path not found...

I need to call multiple trees in an xml document. set branch1 = tree.item(0).childNodes set branch2 = tree.item(1).childNodes ...etc... This works just fine. But what I need is to have a loop that does something like this. for x = 0 to something.length set branch = tree.item(x).childNodes do...

I need to call multiple trees in an xml document. The call for a single tree is simple. I just define tree as an object that points to the document and... set branch1 = tree.item(0).childNodes set branch2 = tree.item(1).childNodes ...etc... I need to have a loop that does something like...

I currently have a setup where we use a demo and a live site. We make changes to the demo site and publish to the live site. Our home page is an active server page. The issue I'm having occurs when I publish the demo site to the live site, it takes my index.asp and publishes it as index.html...

I'm trying to update a file contained within a website. Right now, only those with author permission on the entire site can update this file. (It's updated through a web form and asp/xml) Is there any way in Frontpage to specify read/write permissions to this particular file; or should I try...

I'm getting some kind of access restrictions when trying to update an xml file. The following code works fine. It will read in the file and I can display and manipulate the data: <% Set xmlDoc = Server.CreateObject(&quot;Microsoft.XMLDOM&quot;) xmlDoc.async = false xmlDoc.load...

I have an xml database that contains the contact info for employees. I've written an interface that displays this info according to different groups, but now I'd like to be able to have each user edit their own info. I've created a form who's different fields display the corresponding user's...