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!

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

Recent content by cybermud

  1. cybermud

    Sum Of Sums On Two Unrelated Tables

    I meant to say, I am getting an error on the final "GROUP BY", so I removed it, and it errored on the final "ORDER BY" SO I removed that and it errored on the last ), so there is an error somewhere and I can't figure out where.
  2. cybermud

    Sum Of Sums On Two Unrelated Tables

    Thanks for the advice, but I tried it and I am getting an error somewhere in the code. Here is my actual query: SELECT dDate, SUM(aAmount) FROM ( SELECT strPPADate AS dDate, strPPAPrice AS aAmount FROM ParkingPaymentTransactions WHERE strPPAPaymentTransactionNumber IN ( SELECT...
  3. cybermud

    Sum Of Sums On Two Unrelated Tables

    Gang: I have two unrelated tables that contain dates and amounts. I would like to sum these amount and group by date but I am having problems doing it with a single query. I can do it using a temp table, but I would rather do it using a single query. Perhaps someone here can help. sPayments...
  4. cybermud

    Query Returns < and > character

    I might give that a shot, although there is no HTML in the variable. Its a string of ascii characters that may contain the < and > character which are picked up by the HTML parser against my wishes.
  5. cybermud

    Query Returns &lt; and &gt; character

    Gang: I answered my own question. I just issued a replace command on the < and > characters as the string is outputted. It seems to work ok, even passing between pages. Thanks anyway. Cybermud
  6. cybermud

    Query Returns &lt; and &gt; character

    Gang: I have a databse query which returns a string. The string may contain the > and < character. When this is outputted, characters beyond the < do not display. Any tips on getting those characters on the page? Thanks, Cybermud
  7. cybermud

    CLIENT variable issues

    Carl: I ended up disabling the 'remember my login info' feature as well...thanks for the reply. Erik
  8. cybermud

    CLIENT variable issues

    Carl: Did you ever find a resolution to this? I am having the same problem in 4.5 SP2...user A tells the tite to remember login information, which is stored in the cdata table, then user B & C go to the site and sees user A's information there and can log in as user A. This has only happened...
  9. cybermud

    Remote SQL Servers

    Thanks, this is just what I was looking for!
  10. cybermud

    Remote SQL Servers

    I have several remote SQL Servers which I get data from on a daily basis via a VPN link over the internet. The method that I use is a SQL Server Agent job that executes a stored procedure which connects to each remote server (sp_addlinkedserver), sets up a logon (sp_addlinkedsrvlogin), and...
  11. cybermud

    Incomplete Queries

    I have a paradox 9 database that is updated every half hour by an external system....I am trying to query that in Excel using MSQuery manually, on a daily basis, to make a chart. My problem is that the queries are incomplete. For example, I have data up to today, that I can see if I view the...
See more

Part and Inventory Search

Back
Top