I'm trying to created an INSERT statement to insert data from another table as well as explicit data. This is what I've tried:
**this statement gets all the agentid's I need**
INSERT INTO SYS2_CSIO_BROKERINFORMATION
(AGENTID)
SELECT DISTINCT agentID
FROM Sys2_AgentsAndDirectors AD
WHERE...
Is it possible to view messages in Outlook Today. Rather than just seeing the number of unread messages, I'd like to see those messages (Date, From, Subject). Any ideas?
I have a strange problem happening, to which I found a solution, but don't understand the problem.
Print Server - Windows 2003 R1
Workstation - Windows XP Pro SP3
Printers are all HP
We have many print queues setup on our print server. Out of the blue, a few computers starting having...
This error has started coming up in the last couple days when we run queries that we've run many times in the past. I've googled the error and read many articles about what it means and how to resolve it but I'd like to understand why it's coming up in our particular situation. A quick look at...
I'm very new to vb.net (last used vb6). My situation is that I have a form1 with a combobox (cb1). When a certain item is selected in the combobox, form2 opens.
'initial declaration
Dim FORMNAME
'inside combobox SelectIndexChanged event
FORMNAME = New contractequip
FORMNAME.ShowDialog(Me)...
I've been struggling to learn how to do a PITR in Windows. I can create the archive and I can start and stop the back but when it comes to creating the recovery.conf file, something seems to go wrong. The command I've been doing is:
restore_command = 'copy C:\\archive\\%f "%p"' # Windows...
I have inherited and database (oracle 9i) with a table called "attacheddocuments". In this table is a field called "object" that is of Long Raw type. This field contains files that users have attached (via the front end system). My problem is we are suppose to change to a new system and need...
Background:
I have a main form with a combo box. Each item in the combo box opens a subform where the users selects certain info and clicks submit which assigns values to public variables and closes the subform. This works as designed. Since I will have multiple subforms, I want to create a...
I've gone through the article about passing values between forms and ran into a problem.
Here the scenario:
Click a button on FORM1 and open FORM2
FORM2 has a treeview.
Select a node and pass the value back to FORM1 and populate a text box with the value.
It appears to work but once the...
Here's the case. I have two systems (each with it's own tape drive). Both have BE 12.5 installed and the settings are identical. When I run a backup on one server (bs1) and then put that tape in the other tape drive (bs2), it brings up different data for the drive. BS1 says that tape is...
My company uses a system with an Oracle 9i backend. Each night, a full database export is run. The question I have is, how can I use the IMP statement to re-import that data back into the existing database (for whatever reason)? When I ran...
imp <user>/<password>@<tns> file=your.dmp full=y...
Basically, I'm in a For loop and I need to assign a value to a variable depending on the value of the counter. Variable names are: glbnumconvict1, glbnumconvict2, glbnumconvict3, and glbnumconvict4. I opted to declare the variables before hand so they exist when I try to assign the value but...
First off, I'm using JavaScript from within Adobe LiveCycle Designer (if that makes any difference).
I'm trying to assign a value to an object (txtbox) by referencing the txtbox name which is stored in a variable.
Here's how it works...
math.value= xfa.form.form1.rb.rawValue; --> a radio...
I'm trying to copy the contents of a remote folder to a local folder and overwrite the local contents. I'm running the script at logon via GPO. I get a permission error when the CopyFile command runs. The users do not have permission to edit the contents of the folder (if i log on as an...
I've been asked (by one of our consultants) to run pupbld.sql as we don't seem to have the PRODUCT_USER_PROFILE table. The question I have, and have not had answered yet, is will this break any currently setup in Oracle? I don't have a test system to run this on and can't afford to have our...
I'm trying to build a macro in excel that will group my rows based on the value in column A. I think I can get the first set of items to group but I'm not sure how to start the second group.
Has anyone setup a Dual WAN router infront of their PIX? We have a Xincom Twin WAN DPG502 that we'd like to setup infront of our PIX 515E. We use the PIX for VPN as well so will the Xincom break that? Do I have to change the PIX outside Interface IP or add a route (or two) in the Xincom?
I'm new to PIX (and job) and need to solve an issue with our PIX. As far as I know, split-tunneling is setup but it is not working. When clients VPN in (using windows client), they can access the internet but not the network. If you check off "use default gateway on remote network" then you...
I'm trying to setup a batch file to add a static route for a VPN user. The problem is, the below only works if I put the exact interface ID in
route add 172.16.0.0 mask 255.255.0.0 172.16.xxx.xxx IF XXXXXXXX
If I don't specify the interface, I get an error (Interface index wrong or gateway...
Okay, so here is my question about scavenging ...the date stamp on my Reverse PTR's are dated 06/Nov/2007 but the date stamp on my Forward records about 05/Feb/2008. Is scavenging not taking place? I'm assuming not since there are missing/mixed up entries in both Reverse and Forward zones...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.