ASP and SQL2000 drop-down menu

Okay, I am new to this so be gental.
I have a form with 2 drop down menus and a text field that I am concerned
with. Size, Packaging, and Cost. Size and Packaging pull their info from a
Size and a Packaging table respectively. I need the third field, Cost, to
take the values selected by the user in the Size and Packaging fields, and
use those values to query a third table "Cost." The Cost Table has three
fields: Size, Packaging, and Cost (The cost field is always different
depending on the Size and Packaging chosen).
I have created a server side procedure:
Create Procedure getmycost
@.size int,
@.packaging varchar(50),
@.cost money OUT
AS
Select @.cost=Cost
From Cost
Where
Size = @.size AND
Packaging = @.packaging
I have placed the this code on the client side within Cost the field:
declare @.size int, @.packaging varchar(50), @.cost money
set @.size=Size
set @.packaging=Packaging
Execute getmynumber @.size,@.packaging,@.cost OUT
select @.cost
I am sure I am doing this all wrong;
I am geting an error:
Invalid column name 'Size'
Is this not the way to reference a field on the web form (Size)?
And will this even work?Hi
Did you check out the links in your previous post?
John
"HollyylloH" wrote:

> Okay, I am new to this so be gental.
> I have a form with 2 drop down menus and a text field that I am concerned
> with. Size, Packaging, and Cost. Size and Packaging pull their info from a
> Size and a Packaging table respectively. I need the third field, Cost, to
> take the values selected by the user in the Size and Packaging fields, and
> use those values to query a third table "Cost." The Cost Table has three
> fields: Size, Packaging, and Cost (The cost field is always different
> depending on the Size and Packaging chosen).
> I have created a server side procedure:
> Create Procedure getmycost
> @.size int,
> @.packaging varchar(50),
> @.cost money OUT
> AS
> Select @.cost=Cost
> From Cost
> Where
> Size = @.size AND
> Packaging = @.packaging
> I have placed the this code on the client side within Cost the field:
> declare @.size int, @.packaging varchar(50), @.cost money
> set @.size=Size
> set @.packaging=Packaging
> Execute getmynumber @.size,@.packaging,@.cost OUT
> select @.cost
> I am sure I am doing this all wrong;
> I am geting an error:
> Invalid column name 'Size'
> Is this not the way to reference a field on the web form (Size)?
> And will this even work?
>|||Yes I did check them out. No I can't answer my question from them.
"John Bell" wrote:
> Hi
> Did you check out the links in your previous post?
> John
> "HollyylloH" wrote:
>

AS2005 Cube Excel 2007 Filtering Issue

When browsing our AS2005 Cube we only have one filtering option. Top 10... under the Value Filters menu item. All other filtering options are disabled. I can create a pivot table manually from data in an excel worksheet and the filtering options work fine. Which leads me to believe it is something wrong with our cube design / metadata? Any ideas for what we might need to have the filtering options enabled.Have you installed SP2 on the AS server ? Some features of Excel 2007 are only enabled against AS SP2.|||No it doesn't, I have tested against my local copy of sql server which does have sp2 and it resolved the issue. Thanks for the help.|||

Hello Mosha. It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2?

Is this something that you have mentioned in your Blog(multiselect) or something else?

Do you mean internal features like the MDX being generated from Excel2007?

Are these new features being enabled by an update on the client?

Kind Regards

Thomas Ivarsson

|||

> It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2?

I agree that it would be interesting to know. This question belongs to the Excel forum, however. Also, in couple of months when everybody has upgraded to SP2, this will become a moot point.

> Are these new features being enabled by an update on the client?

I beleive it's enough to upgrade AS server only.

|||

From what you are saying I think the new features will be in an Office 2007 SP1, not in SSAS2005 SP2, even if SSAS2005 will provide the basis for that.

Writeback in Excel 2007 will be on my whish list.

I think we have a problem of where to post Excel 2007 and ProClarity questions regarding SSAS2005.

Regards

Thomas Ivarsson

|||

For Excel 2007 questions, the following forum seems to be appropriate: http://forums.microsoft.com/technet/showforum.aspx?forumid=544&siteid=17