Recent content by cisscott

Windows 2K Adv Server (Clustered, Fully Patched) Sql Server 2000 Im trying to prepare to install SQL Server Reporting Services on both nodes of my cluster. According to the documentation, Microsoft .NET Framework is supposed to be resident on the machine. It doesnt seem to be there. I have...

Dreamweaver MX v6.1 w/ updater Windows XP SP2 Webserver = IIS 5.0 Document type: ASP VB Script I have a page built in dreamweaver that i need to connect to a SQL Server database table. I have the database connected using an ODBC connection and i can see the tables in the Database Panel. However...

Thanks for the replies guys! Ill try a these suggestions out today. Havent used DISTINCT COUNT cuz im not really after a count. I have tried using both a running total and a sum function, but get the same kind of whacky results either way.

Excellent suggestions, thanks to both of you!

Crystal Reports 9.1 SQL Server 2000 8.00.760 on W2K Adv Server We have recently begun selling product over the internet. Some people chooose to have their purchase mailed to them, others come and pick it up. In the live.audit.dbo table there is a transaction type "H" for held, "R" for...

oops sorry ... php

Dreamweaver MX 6.1 SQL Server 2000 Hi all. I set up a web page to search our customer comments database. I wrote a simple SQL query to select the recordset. I have a conflict between the date in the database and the date variable in the webpage app. Here is the code: SELECT * FROM...

Nevermind, figured it out. Had an extra fwd lookup zone on the local dns server that contained wrong record info and deleting it fixed the problem.

Windows 2000 Server SP4 I have set up a W2K server. It is a domain controller, is running DNS, DHCP, RRAS, IIS, and IAS. I wrestled with trying to get the server to share its internet connection with clients through RRAS using two NICs, one on the INSIDE Lan, and the other on the outside...

Harkness, the code you gave would simply set every field in the CLIENTS table = to Tom Jones. Is that really what you want to do? You can find out column names by using sp_columns TABLENAME in the query analyzer.

Im trying to do a fairly simple update where i have to join two tables, and I keep getting the error "The column prefix event2 does not match with a table name or alias used in the query" I know I just have a problem with the syntax of the query, and would appreciate any advice.. Here is the...

Windows XP Pro definitely does not come with a POP3 server. Im not sure that Server 2003 does, either, I havent used it. I would be surprised if it did, since that would cut into sales of Exchange Server. There is a pretty cool free mail handler available called MailEnable...

Do you have any other servers on your network? It sounds like you don't have a domain controller defined. If there are no other servers on your network, did you run dcpromo and get AD all set up? If not, definitely check it out...

Thanks for the reply. Actually I figured it out. It was one of those "couldn't see the forest for the trees" deals. I just deleted the scope and recreated it, and changed the mask, instead of accepting the default.

OK, after more research I know whats causing the problem, I just cant fix it. the basic idea is this: sum(eventseat.price) where eventpaid.buyer = 'A' and (eventseat.orderid = eventpaid.orderid) table EVENTSEAT is a one-to-many relationship with table EVENTPAID. I believe this is causing it...