Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tsyle
  • Order by date
  1. tsyle

    Help with a SQL Statement

    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
  2. tsyle

    Help with a SQL Statement

    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...
  3. tsyle

    Help with a SQL Statement

    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...
  4. tsyle

    How to automatically download a file that is dynamically created

    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...
  5. tsyle

    How to automatically download a file that is dynamically created

    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...
  6. tsyle

    Unable to get nested query to work

    thanks! that worked. I can't believe it was something simple. I was trying to make it harder than it should be.
  7. tsyle

    Unable to get nested query to work

    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...
  8. tsyle

    CSS DIV tags are not showing correct background color

    Thank you for the help! Setting "overflow:hidden;" inside page_centerContainer_center did the trick. Thanks again.
  9. tsyle

    CSS DIV tags are not showing correct background color

    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...
  10. tsyle

    Tomcat's HelloWorldExample test return 503 error?

    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.
  11. tsyle

    Tomcat's HelloWorldExample test return 503 error?

    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...
  12. tsyle

    Apache Install 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...
  13. tsyle

    Connect to Cisco VPN Client but lose Local Internet Connection

    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?
  14. tsyle

    Connect to Cisco VPN Client but lose Local Internet Connection

    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...
  15. tsyle

    Testing to see if a procedure exists within a package body

    I actually found another way to solve the problem. Thank you for all your help.
  16. tsyle

    Testing to see if a procedure exists within a package body

    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...
  17. tsyle

    Testing to see if a procedure exists within a package body

    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?
  18. tsyle

    WHERE IN statement isn't working correctly...

    oh... My version is 4.0... if i update it will i lose all my tables?
  19. tsyle

    WHERE IN statement isn't working correctly...

    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...
  20. tsyle

    VPN Server Setup with Linksys BEFW11S4 v2

    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...

Part and Inventory Search

Back
Top