Search results for query: *

I have an invoice file that I use to put products on an invoice and send to customers. I have a header, body and footer. The problem I'm having is figuring out how to only show so many repetitions of the product fields. If I only have one product I just want to show one row. If I have 25...

I have a table, contactInfo. In it there are two columns, contactDate and customerID. I'm trying to create query that returns the single most recent row for each customerID within the table. Of course, there are mutliple rows for each customer. Any ideas?

I have a cross tab report that is pulling orders from a DB with the following criterion: "Estimated Book Date" that's between to specified dates OR "Complete Date" that's between the same to specified dates. The row is Estimated Book Date grouped by month. The summarized fields are “estimated...

I have a field called PartNumber. I know there a duplicates in it and I am wanting to create SQL query that returns those duplicates. I was looking around and it seems that everyone just wants to know what the duplicates are and not actually list the duplicate rows with a RecordID or Unique ID...

I started a project out in Visual C++ 6.0. I then saved the project wiped out my drive. Installed Visual C++ .NET. Opened the file and converted it to work with .NET. It compiles perfectly, but when I go to edit a dialog box, I cannot even view it because of an error. It says something like 4...

I am trying to create a query where SQL selects a break point in a row of numbers. I have a cloumn containing a number, lets say 1-100. They all exsist except 50. How would I get SQL to tell me that 50 is not in use?

I have an illustrator file with a true type font in it. When I went to Kinkos to get some printed they were able to embed the font I have in the illustrator file into the acrobat file. However, I cannot accomlish this. I bought this font and I cannot embed it. I can get Times and other generic...

I'm trying to make it to where I table has a primary key in it. There are tables associated with that table. When a row in the table with the primary key is deleted it cascades through the other tables deleting associated rows. How do I do this? Triggers?

Does anyone know anything about coldfusion and BC Math. Example: Add 0.01 to a 0. loop that 100 times and then subtract 1.0 from it. Notice all the extra numbers after the number? It should be 0.0 but its not.. its like 0.0000000006432423. any Suggestions?

How do I control an IIS server remotley? I have a server with back office on it. But I want to be able to get the Managment console on another computer. I am unable to install this since it says it requires Windows NT Server. How do I do this? I've tried to access the web console also, with no luck.

How would I use SSL with IIS 4.0? Do I need to by a certificate from versign? Then what?

I have a web applications that requires people to login. It uses session variables to do this. My time span in the application file is set to 5 hours. It works find as long as the user is constantly requesting webpages. But if the user is inactive from anywhere 5 minutes to 10 minutes the...

I have a field called customer ID. I want to make it a primary key but it says there are duplicates. How do I find these so I can delete one of them? There's abuot 4,000 records so I can't really look through them.

Can anyone help? I have a database file that is sitting here but I cannot use. My o/s drive crashed on me and now I cannot get my database up again. How can I get SQL 7 to recognize that the file is a database..Is my database gone for good??

I had a database running. SQL Server was on my o/s drive but the actually db_Data file was on another drive. When I reinstall SQL server, how do I restore the database from that file? I can't goto restore database becuase there is no backups to restore.

When trying to import an xls file I get an error that one of my columns is to large for the current buffer size, how do I raise the buffer size?

Is there any way to create a boolean search. I noticed verity doesn't even do this. What I want to accomlish is this: Lets say a product name is: This Product Is Cool I want them to be able to search with the phrases: This cool, product cool, this product, etc... Is there a way to create...

How is the SQL 2000 Evaluation Copy crippled, or is it? Does it ever expire? Is it limited to a certain # of users?

I'm trying to set a field equal to the math of other fields. Example. I want the field NetProfit to equal TotalGrossProfit-TotalOverHeadAdj, which are both fields also. How would I do this? Does it have something to do with the default value?

I'm trying to output some products on my webpage. Is there anyway to have a header that has the company and then list the products under that company header and so on. There would be mutiple companies with mutiple products under each company. Is there a way to do all of this with one query?