Search results for query: *

I have been thinking about how to do this query for hours but have yet to figure it out. Here is what I have Table ItemCode Inv# ExtAmt /ITM550 3221 500 /ITM550 3221 250 /ITM550 1111 100 /ITM550 1111...

Hey guys. I searched through this forum and was not able to find the answer to this. I have an application that needs to automatically download a file that is created dynamically after a form post. Here's my work flow: 1. I log into a website 2. I navigate to a certain page lets say...

InvDate Division CustomerNum 4/7/2008 30 10 1/7/2008 50 10 1/7/2008 50 10 10/8/2007 50 10 10/8/2007 50 10 7/9/2007 50 10 7/9/2007 50 10 4/11/2007 50 10 4/11/2007 50 10 4/11/2007 50 10 2/9/2007 50 10 12/7/2007 50 15 2/12/2007 50 15 1/7/2008 30 26 10/8/2007 30 26 10/8/2007 30 26 9/21/2007 30...

Hi everyone! My website is http://www.iamthang.com. In IE, it works fine, but in FireFox, the light gray background does not show up at all. If you look at the site in both IE7 and FireFox2, you will see that IE7 shows the middle section with a gray background all the way down to the footer...

I have a machine that has the following: Windows 2003 IIS6 Tomcat 5.5.17 The HelloWorldExample works if I use port 8080 but gives me a 503 error if I use port 80. Help...

I downloaded the msi version of Apache 2.0.48 and proceeded through the install to the last screen "Installing Shortcut". At that point the install just hung up. I am working as a local admin (it won't allow none IT personnel to be network admins) if this is the root of the problem I can have...

When I connect to my work server via a Cisco VPN Client (Version 4.6.03.0021), I lose my local internet connection. I searched around the forum and found one answer, but it was only for a Windows VPN connection. Is there anyway that I can connect to the Cisco VPN server without losing my local...

I'm not sure if this question goes here, but i couldn't find a development forum for PL/SQL. I am using Oracle 9 and I have some procedures that are stored in a package body. I want to test to see if a procedure exists. Does anyone know if this is possible?

Select U.user_id, U.Username, U.timestamp, U.account_type From users U Where U.user_id IN (Select T.user_id From txnlog T Where T.result = 'Cash Paid' Group By T.user_id) This is the code that I am working with. I don't know where i'm...

I been trying to setup a VPN server for a couple hours now using my home network. I have a VPN server already setup. I have forward port 1723 and port 47 to my VPN server. I have also enabled PPTP passthrough. On the VPN client, if i use the local IP of the VPN server, 192.168.x.x then it...

I'm not sure if this is possible, but i have one site that is hosting the database (www.in-call.com) and i am creating another site (1internet-phone.com) where i would like to use the database from www.in-call.com. How would i go about doing this? Can it even be done in MySQL?

I have a column in my database like the one below. ID1 1092200001 1092200002 1234567890 2678100001 2678100002 2678100003 2678100004 2678100005 5112300001 5329500001 5329500002 5329500003 5329500004 5329500005 What i am trying to do is create a query where it will separate the first 4 number...

Here is my sample data Patient_ID Visit_Number Last_Visit ----------- ------------ ----------- 9283 1 Jan 20 2003 6372 2 Jan 20 2003 7347 3 Jan 20 2003 2372 4 Jan 20 2003 8493 5 Jan 20 2003 4283...

I have a database with queries from: 4/10/2005 Data 4/22/2005 Data 4/23/2005 Data2 5/1/2005 Data 5/5/2005 Data2 5/10/2005 Data2 I want to be able to group everything by month so using the data i gave, i want it to be April 2005 Data 2 April 2005 Data2 1 May 2005 Data 1 May 2005 Data2 2 Help

Ok I have to find the total charge for procedures of the patient with the higest total payment. Here are some data Procedure_Code, Procedure_Description, Procedure_Charge CXR,Chest X-Ray,55.00 REX,Routine Exam,40.00 AEX,Annual Exam,350.50 SLB,Setting Leg Bone,110.00 SAB,Setting Arm Bone,95.50...

I have 1 table Visit_Procedure. What I want to find is which procedure was ordered the most. Visit_Number Procedure_Code Number_Of_Times 1 BDR 1 1 EEX 1 1 REX 1 2 EEX 1 2 REX 3 3...

Hi I am having problems trying to get two tables to show reference each other correctly. Here is the problem: What are the Lab_Test_Result for Visit with number less than 7? Include the Visit_Number, Lab_Order_Number, Result_Code Result_Reading, and the Result Units. This is what I got, but...

I have this one Table with information about Calls_Completed and Call_Duration. Each row in the Calls_Completed Column counts as 1 call, so i used a count statement to count each row for that and it works, but my problem is trying to count Call_Duration. In this column each unsuccessful call is...