Showing posts with label products. Show all posts
Showing posts with label products. Show all posts

Friday, March 30, 2012

Named set is not working in excel

Hi All,

I have created the named set to get the top 4 referers for my products.

But it is not working as expected.I am using Ecel 2007 as reporting UI using Pivot tables.

The referers are in rows and product is in filter.

Say I want the top referers (google.com,altavista.com...etc) for VB (or) VC++ or SQL 2005 ....etc

Please suggest me how I can do this i.e arrange in order and vary with change of product.

I have three tables Dim_Product, Dim_Referer, Fact table

The content of this new named set would be:

{([Dim Referer].[name category].Members,4,[Measures].[value])}

Rgds

Sai

Named sets created in the MDX Script are static - they are evaluated only once. Therefore changing the current product won't affect the content of the named set.sql

Friday, March 9, 2012

MySQL and MSSQL?

Is it possible to have both these products installed in the same system?
And if so what the best versions for each that would be best here? Thanks.
--
George Hester
__________________________________George
You asked this at the right time
12 hours ago i got an install od MSSQL server (2000), MySQL Server (4.x),
Apache Web Server, PHP all working on a Win2003 server. Now can I can create
portals for our systems.
So yes and they work fine together.
Regards
Jeff
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003|||Hi George,
> Is it possible to have both these products installed in the same system?
Yes. Pay attention to TCP/IP ports, if you do not change them, no problem.
Tune up your server and your databases. Be careful on choosing the server
hardware, remember that it will be a "double database" server and you could
possible find a bottleneck soon.
> And if so what the best versions for each that would be best here?
Thanks.
SQL Server: use 2000 version
MySQL: try 4.0.14, avoid 4.1.x series
Regards,
Fernando Monteiro

Monday, February 20, 2012

My Products table

hello,

i have a Products table, and i want to make an image data type to one of his rows (Picture1 for example), i want to know, what is best, to store the picture in the database or store only the direction to the picture?

if i store only the direction, i should take it from some output parameters of the Upload function of ASP and the add it to the Database? can i add it to a special folder for example MySite\UserName\ + file name?

and another thing: let's say i have Promotion - tinyint, to store the promotion value of this product..If i show products using DataList, i could order my products first after Promotion and then after date added? could i use a special CssClass(font weight or other background) for the products witch has the Promotion more than 10 for example?

how can i know the exact date time (yy/mm/dd/hh/mm) ? - it is taked from the Server date?

thank you

Have a look at

http://www.codeproject.com/aspnet/PicManager.asp|||

Hi zuperboy90,

i have a Products table, and i want to make an image data type to one of his rows (Picture1 for example), i want to know, what is best, to store the picture in the database or store only the direction to the picture?

if i store only the direction, i should take it from some output parameters of the Upload function of ASP and the add it to the Database? can i add it to a special folder for example MySite\UserName\ + file name?

Well, it depends. If your image file size is very large on everage, I would suggest you using sql database to store the link and using a file server to store the actual image file. Actually it's not too dificult to impliment. Using asp.net update control to store the image file to a specific folder, and pass the path(with the file name) to your backend database.

If your image file is not a big one,then just create a new field named "image" with type "binary(SIZE)", and fill this field using a stream writer. This is a very conveninet way if you only want to store some icon/thumbnail pictures.

There are lots of sample articles on this, just type "picture gallery asp.net" into google and you will find millions of resources.

Hope my suggestion helps

|||

for a wile i store in my database only the link to the pictures (they are very many, and hight resolution), and i think i'll use something like ImageUrl = <%# Eval("url") %>, i don't know exacly how it will be, i'll se if it is ok when implementing the code that alowes you to add pictures, and then chose the best way

thank you