FOUND THE SOLUTION!! woohoo
SELECT Table1.ItemCode, Table1.[inv#], Query2.ExtAmtTotals
FROM Table1, Query2
WHERE Table1.ItemCode+Table1.[inv#] = Query2.ItemCode+Query2.[inv#]
ORDER BY Table1.ItemCode
Hi MazeWorx. Thakns for the reply.
I actually had a query similar to that but it returns too many results.
My goal is to add the extamttotals to each row in the original table.
So I need the same number of rows returned but with another oclumn that shows the ExtAmtTotal. This is needed so I...
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...
Hi guys,
Thanks for the reply.
Here is how my application is currently setup:
I have a web browser control that sends a post to a website to log into it. Yes this is probably a bad way of doing things because any changes on the website will require that I make changes to the code, but this is...
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...
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 am using IIS to redirect to tomcat, so instead of typing http://machineName:8080/servlets-examples/servlet/HelloWorldExample I can type http://machineName/servlets-examples/servlet/HelloWorldExample.
I got it working though. Seems to be a permssion issue on the isapi_redirect.dll file.
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...
I read about SPlit Tunneling, but unfortunately, I do not know how to do that. I can probably tell the lead developer to do it, but I just need to find out how.
Is there no easier way to do this task?
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 tried doing it that way but it doesn't work. My procedures are all stored within a package body. I looked inside the database and i think the only way i can query what is inside the package is by doing a search of the source code... I'm not that familar with pl/sql so i was hoping there might...
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...
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.