Hi,

I need some help on this. I want to use two fields from the registration module and concat it into a single DNN profile.

Another thing is , i have a dropdown box, I need it have some underlying value which corresponds to what is shown in the dropdown list.

For e.g if the value selected in the dropdown list is monday. i want the value that gets stored into the dnn Profile to be 1.

Is that possible in Dyn. Reg or i need to get into the data base.

Help me out on this!!

Thanks

Amith

This is What i did. Ineeded to update a profile property by using two values from the dyn.Reg and 1 from the database.

I used SQL completion event and typed in the following query.

Please let me know if i can use the dyn.reg parameters like this:

DECLARE @UserID INT
DECLARE @PropertyValue VARCHAR(50)
DECLARE @Carrier VARCHAR(50)

SET @Carrier = SELECT CarrierAddress FROM Carriers WHERE CarrierName=$(MobileC)
SET @PropertyValue = $(MobileN)+@Carrier
SET @UserID = $(UserID)

INSERT INTO UserProfile(UserID,PropertyDefinitionID,PropertyValue,PropertyText,Visibility,LastUpdatedDate)
VALUES(@UserID,77,@PropertyValue,NULL,2,GETDATE())

Is the syntax of the query correct?

Help me write is query

Thanks

Amith

Hi. Well you can fully test any SQL directly under Host, SQL before creating a SQL completion event from it.

1st, if the user already has a profile property then this would cause an issue as it would be inserting another one. You would want to create an insert or an update stored procedure. If you didn't create an add/update you would at least want to delete from the table for that specific UserID and that specific profile property definition ID.

2nd, anywhere you are referencing a varchar property that is an actual token you would want to use ' before and after the token. So it woudl look like '$(MobileC)' and not $(MobileC) or it would look like '$(MobileN)' + @Carrier

Ummm... Once you have it working I would make it a stored procedure to limit the possible security issues (SQL Injection).

As far as the dropdownlist text/value - Just add options and then click on each option to set the text and the value to be different. After you set them you can reference them within completion events as $(Field) which represents the value and $(Field_Text) which represents the text.

We can also handle any of the above implementation for you if you need something sooner and don't want to code the completion events etc... You can review our standard support VS premium support at http://www.datasprings.com/productsupport/

-Chad

Thanks Chad, it works.

Amith