Recent content by xpblueScreenOfDeath

Thanks r937. With that query, it seems like it could return more than 100 records per category if there a products that have the same sell count. What would the performance of that query vs creating a store procedure that loops through the category table and select the top 100 products from...

Category --------- CategoryID CategoryName Product --------- ProductID CategoryID ProductionName Price SellCount ...

I have table of categories, and a list of products with a counter in the product table. The counter in the product table gets incremented by 1 each time that product is sold. How do I get the top 100 selling products in each category?

Can someone help me with my css? The following looks correctly in IE 6, but not in FireFox. Can someone help me with my css to make it look correctly in both browsers? I am having server side code generate a page with a panel like this, so the html tags have to stay the same but the css needs...

Does anyone know how the social networking sites are importing address books from popular online email accounts? They ask for your email and password and then they are able to retrieve your address book. And if you want they will invite your friends to join. How are they doing? Does anyone...

Thanks Marty. That works great.

I need a regular expression that would find all tags between two phrase or a phrase and a carriage return. For example: Test1/this is just a test Test2/abc da da da Test Phase/sssss I want to be able to get "this is just a test" by matching "Test1/" and a carriage return but I also want to be...

Is there a way I can peek into the print stream and send an email notification to the intented user? I don't want to interupt the print job. I just want to capture what ever is printing and send the content via email notification to the intended user. Whatever that is printed contains enough...

I have an xml and xslt document. What I want to do is use the xslt document to transform the xml into another format so I can read it into a dataset. When I use XslCompliedTransform to transform the document it adds a date to the transform document so that it throws an exception that the root...

I'm using MySQL. Thanks.

Can I execute multiple queries with PEAR DB? But, I notice PEAR DB has a function called nextResult which is suppose to return the next resultset. When I try the follow, PEAR always give me an error about syntax. But when I take off the last part that return the id, it works fine. So, how do...

I don't quite understand when I need === instead of ==. Can someone clearify this for me?

You must put the symbol "#" infront of all temporary tables. Try this: declare @tempstr varchar(8000) declare @freds varchar(3000) set @freds = '8347151, 4, 7608501' set @tempstr = 'select fredid, bubbid, count(dotid) into #temp from freds where fredid in (' + @freds + ')' exec (@tempstr)...

Not much, I think the only benifit of value types is that they are slightly more efficient in terms of speed. Value types are store in the stack, while reference types are store in the heap. So, value types access the values directly from the stack. On the other hand reference types are store...

I'm new to using .net typed dataset. I could not figured out how to commit the changes I made in the typed dataset into the database. For the typed dataset, I created a new dataset through Visual studio and I started to drag and drop the tables from server explorer. I configured it to...