Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
david stephan
yasminpriya
Gaurav Pal
Ram
christianasteves

I know there is a method built in for retrieving the encrypted password, but how do I retrieve the encrypted security answer?

What I want to do is have a member profile update screen that the end user can update their password and security question and answer. However, when they get to this page, I want to already be showing the security question (the easy part) and its answer (the not so easy part).

I haven't done ANYTHING yet, since I already have a user store with hashed information. I wanted to get some functionality done before publishing, wiping the store and recreating users (only a couple developers).

Thanks,
Kerry

### formula to display all combination output

hi all

i am now think of how to get all the output for all the combinations

eg.

given : 1234

output = 1234,1243,2143......and so on.....all 24 possible output

if given : 123

output = all 12 output

if given 12345 , all 120 output...

can someone provide me the algorithm or formula for that ?

thanks

### order by in combination with union

Hi All,

How can I order this by count? so if it appears above and below the union statement, I want it on top

```	SELECT distinct BIER.Naam, BIER_L2.L2_Naam, BIER_L3.L3_Naam from BIER_MATCH, BIER, BIER_L2, BIER_L3
where BIER_L2.L2_ID = BIER.L2_ID and BIER_L2.L3_ID = BIER_L3.L3_ID and BIER.ID = BIER_MATCH.BIER_ID
and RECEPT_ID = @RECEPT_ID

UNION

--L2
SELECT distinct BIER.Naam, BIER_L2.L2_Naam, BIER_L3.L3_Naam from BIER_MATCH, BIER, BIER_L2, BIER_L3
where BIER_L2.L2_ID = BIER.L2_ID and BIER_L2.L3_ID = BIER_L3.L3_ID and RECEPT_ID = @RECEPT_ID
and BIER_MATCH.BIER_ID is null```

### insert into in combination with inner join

Hi All,

I have my data split in 3 tables for cascading dropdownlists.

How can I make an update statement of this select statement?

```SELECT distinct BIER.Naam as naam1, BIER_L2.L2_Naam as naam2, BIER_L3.L3_Naam as naam3
from BIER, BIER_L2, BIER_L3
where BIER_L2.L2_ID = BIER.L2_ID and BIER_L2.L3_ID = BIER_L3.L3_ID ```
` `
`Thanks`

### Regular Expression for Digits, comma & space combination

Hi Can you suggest a Regular Expression for the following category. A text box which should contain: Max size : 53 0-9 digits + a comma + a space The 0-9 numbers should be repeated 5 times and separated by a comma and a space Eg: 123456789, 123456789, 123456789, 123456789, 123456789 Thanks, David.

### Problem with calculation in combination with crossjoin

Hi fellows   I dont know how to rewrite my MDX in order to get the correct result.    The following MDX statement is reduced to a minimum in order to explain my problem: WITH    MEMBER [Article].[Article].[Article_CE]    AS AGGREGATE ([Article].[Article].[Article_1], [Customer].[Customer].[Unknown], [Location].[Location].[USA])              SELECT       {[Measures].[SalesNet]       ,[Measures].[Budget] } ON COLUMNS ,       NON EMPTY         [Customer].[Customer].[Customer].members         * {[Article].[Article].[Article].members          ,[Article].[Article].[Article_CE]} ON ROWS FROM SALES   If i dont display the customer hierarchie " [Customer].[Customer].[Customer].members " on rows, then every thing works fine! As Soon as I add the above customer hierarchie to my mdx statment, then every thin works fine except for my member " [Article].[Article].[Article_CE]". Instead of showing only one row for customer "Unknown" (see Member definition), a row appears for each customer and with the same SalesNet and Budget.   Any Idea how to rewrite my mdx ?   best regards Pellito

### SQL User Permission (No answer found by searching)

Hello all!   I'm hoping someone will be able to answer my simple question!   Previously, I've run the below script to give one user access to their db in SQL management studio but nothing else. use [someDB] -- use the real db name go sp_changedbowner 'theUser' -- use the new username go 4. Next, deny the new user "public" access to ALL databases: use master go deny VIEW any DATABASE to theUser go   However I now need to add an additional user with view on permissions to the database and can't figure out how to do it. I'm sure it's simple but my SQL knowledge is at a low level.   Many thanks, Lee.

### website and webapplication combination

Salam All Experts, i have two solutions, 1st one is webapplication, 2nd one is website. the 1st soltions (webapplication) includes aspx pages, user controls .... etc. the 2nd solution (website) also includes pages, user controls ... etc. now i need to combine between those, so i copy the webapplication inside a folder in the website, and i put the DLL's for the webapplication inside the main Bin folder, and the theme's like so. but after that, i make some changes in the source code of webapplication, i build the solution, but the new source code updates doesnot appear in the run time !!!! its still running the code before i make combination !! does that because i make the 1st solution as a webapplication ?? how can i convert the 1st solution to a webapplicatoin? or in other words how can i make combination between webapplication and website to run as one solution? please response. thanks

### Script components on 64bit environments - Is there a clear answer for that?

Hello all,  I'm having an issue with a package that contains a script component. The package was originally designed in SSIS 2005, was migrated to 2008 and not to a 2008 64 bit machine. We're able to run the package in VS/32 bit mode, but it fails when we deploy the package. I was able to find a few articles out there, but not clear answer for this issue. Is it possible to run packages with scripts in 64 bit machines? The script is pretty simple, it only reads configuration from the machine.config file. Below is the error message I'm getting:     Executed as user: CITRITE\svcacct_qasqlapps. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  4:13:22 PM  Error: 2010-08-30 16:13:22.70     Code: 0x00000001     Source: Script Task      Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.     at ScriptTask_4b9f5fd6bf8e4c5e99a637abdc7bd178.vbproj.ScriptMain.Main()     --- End of inner exception stack trace ---     at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&

### Is SQL Server Express the answer?

I really wasn't sure where to put this, and this seemed like a decent enough place. I'm sure like a lot of other small businesses we are in the process of moving from Visual Studio 6 and Office 2000 up to Visual Studio 2010 and Office 2010.  All of our applications are run inhouse so distribution isn't a issue here as everything is "local".  We are now running into the question of do we really need to use and spend money on Access.  I'm going to say that 98% of our applications that use access are just using it as a database and not using Access (i.e. using C++, C# or VB as the front end).  Now that SQL Server Express Edition is around would that be a better alternative for what we are doing?  We do run SQL Server 2000 (moving to 2008) for our "bigger" needs but our DBA would rather keep the smaller things away from it (his choice and there is no changing his mind).  We currently run 4 servers and would be able to put SQL Server Express on one of the other servers.  Would this be something that would work, are there user limits I'm not aware of?  Looking for input on this.  Thanks everyone in advance!

### WPF & WCF Questions and answers

Find some questions here WCF Questions Please post WPF Questions.  http://www.technicalcontents.com/

### cannot we hide as we say clip which is combination of table and some static text when the table valu

hello

well am just having a problem as

cannot we hide as we say clip which is combination of table and some static text when the table value is empty or null.

Hi...
Can u pls tel me

### Defining uniqueness of a record with combination of IDs

Hello,

My question may be trivial but I just have a hard time abstracting table relationships :P

I have 3 tables:

[] -> primary key

Datas: [ID], Data
DataValues: DataID, ValueTypeID, Value
ValueTypes: [ID], Name

The first is the main table;
The second is an value-attributing table and reason of this topic;
The third is the value type definer;

The problem is as follows:
I want to be sure on this low-level model that ONE ValueType record only gets refferenced by ONE Data record.

Example:
Datas: ID -> 27, Data -> "Some Data"
ValueTypes: ID -> 14, Name -> "Length"
DataValues: DataID -> 27, ValueTypeID -> 14, Value -> 9

I want not to be possible to add another record in DataValues with DataID = 27 AND ValueTypeID = 14
It should allow, though, DataID = 27 AND ValueTypeID = 18 or DataID = 65 AND ValueTypeID = 14, for example.

Thank you,

Matheus Simon.

### Why do these forums have to show every answer twice?

It's a stupid idea and annoying.

Hi. :)

I am still studying to become a webintegrator and this is my private project to try and learn C# better. This might be a little complicated so please just ask if you feel like it does'nt make sense.