Recent content by cybermud

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.

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

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

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.

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

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

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

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

Thanks, this is just what I was looking for!

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

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