To recap my dilemma: I wan't to save/display a default image for each user who registers and does not have one to upload initially. This way when I setup the User Directory module or Tailored Text module, there will always be some kind of photo showing up either from the user or just a default image. As an immediate solution to this problem utilizing the existing Dynamic Registration form functionality, Chad has suggested using a SQL "If" statement. Chad, will you please expand on this with a SQL example and where it should be implemented?

I think I know what Daniel's issue is as I have the same problem.  The issue is that when a field is not filled in, an entry will never be made for it in userprofile.  So, an Insert needs to be made to create that property in userprofile, not an update - which will always fail if the field was never filled in by the user.  Chad's SQL could only work if the user had already specified an image during registration.

I too would very much like the ability to setup a default image that sticks.  I'm not sure quite how to resolve this issue properly.

I could live with it if DynamicUserDirectory could be convinced to ignore empty/missing images, but it doesn't seem like it can.

Thanks for the response David - the issue is I don't know how to write those.   I guess I will need to figure it out some how.  I was kind of hoping the module could deal with this, but it doesn't, so tough luck for me.

David - you are right, this is a powerful technique   I took your example and made some modifications to suit our naming.  The main changes are:

1. rename variables/names to match what we are doing.

2. change the update command - it had 2 problems: A) it didn't update the LastUpdatedDate, and B) the WHERE clause was modified to specify the PropertyDefinitionId - the way it was, it would update *all* PropertyValues for that UserID to PictureVar...  Definitely not what you wanted

At any rate, thanks alot, this was very useful in pointing me toward the light!  Using an SP may also allow me to work around some issues with DUD filters.  For your (or google's) edification here is the complete SQL I'm now using for this particular task:

-- based on quick pointer example from David To/dnncreative
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}vwg_CheckVendorLogoProperty') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}vwg_CheckVendorLogoProperty
GO

-- no logo:   exec vwg_CheckVendorLogoProperty 279, 'spacer.gif'
-- has logo: exec vwg_CheckVendorLogoProperty 263, 'spacer.gif'

create procedure vwg_CheckVendorLogoProperty(@UserID int, @newLogoVal nvarchar(500))
as
begin
 declare @logoVar nvarchar(500)

 if (@newLogoVal = '') set @logoVar = 'spacer.gif' else set @logoVar = @newLogoVal

 declare @logoID int
 set @logoID = (select PropertyDefinitionID from ProfilePropertyDefinition where PropertyName = 'Logo')

 -- if record doesn't exist, insert a new record
 if not exists(select userid from UserProfile where userid = @UserID and PropertyDefinitionID = @logoID)
  begin

    insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate) values(@UserID,@logoID,@logoVar,2,getdate())

    -- DEBUG   select UserId, PropertyValue from UserProfile where userid = @UserID AND PropertyDefinitionID = @logoID

  end
 else
  -- record exists, update it instead
  begin

    update UserProfile set PropertyValue = @logoVar, LastUpdatedDate = getdate() where UserId = @UserID AND PropertyDefinitionID = @logoID

    -- DEBUG   select PropertyValue,LastUpdatedDate from UserProfile where userid = @UserID and PropertyDefinitionID = @logoID

  end

end

Actually David, The SP looks up the propertyID for you in the code segment:

declare @logoID int
set @logoID = (select PropertyDefinitionID from ProfilePropertyDefinition where PropertyName = 'Logo')
 

So, assuming the shortname of the property field is Logo, nothing should need changing.  If it is named differently, then just change 'Logo' to 'Whatever_you_are_using' and it should just work (TM).

Corey, the procedure I posted (and will post again, since some quoting seems to have been munged) needs to be loaded into your DB.  Then you set up an SQL  completion event that calls this procedure, passing it the UserID and the value of the logo field you are using.  In the SP, if the value is empty, 'spacer.,gif' will be placed into the property table for that user, else, whatever they uploaded will be placed there.

If you are unfamiliar with SQL and Stored Procedures (SP) it will be well worth your while to become familiar with them.  While I found many of the Datasprings modules are capable, you will almost always need to 'tweak' things for your specific requirements, and SP/SQL knowlege is very important.

So, I'll repost the SP here (using a 'blockquote' tag which will hopefully preserve all of the characters).

To load it into your DB, you will need to use SQL Exec from Host in dnn (with host privileges of course).  Cut/paste into the command box, check 'Execute as script' and submit it.

Then to call it, in your SQL completion event for the form, you will need an SQL statement to the effect of:

exec vwg_CheckVendorLogoProperty $UserID, $Field_containing_logo

Where $Field_containing_logo is the value they entered for their logo on your form.

Hope that helps.  Really, SQL and SP knowlege are very important when dealing with this stuff

So, here is the same procedure in a 'block quote' which will hopefully preserve all the characters.  Good luck!

(You may want to change the names for the function and variables to more properly fit your site, once you've got a handle on what's going on.  It's really not as bad as it may seem at first glance

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}vwg_CheckVendorLogoProperty') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}vwg_CheckVendorLogoProperty
GO

-- no logo:  exec vwg_CheckVendorLogoProperty 279, 'spacer.gif'
-- has logo: exec vwg_CheckVendorLogoProperty 263, 'spacer.gif'

create procedure vwg_CheckVendorLogoProperty(@UserID int, @newLogoVal nvarchar(500))
as
begin
 declare @logoVar nvarchar(500)

 if (@newLogoVal = '') set @logoVar = 'spacer.gif' else set @logoVar = @newLogoVal

 declare @logoID int
 set @logoID = (select PropertyDefinitionID from ProfilePropertyDefinition where PropertyName = 'Logo')

 -- if record doesn't exist, insert a new record
 if not exists(select userid from UserProfile where userid = @UserID and PropertyDefinitionID = @logoID)
  begin

    insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate) values(@UserID,@logoID,@logoVar,2,getdate())

    -- DEBUG   select UserId, PropertyValue from UserProfile where userid = @UserID AND PropertyDefinitionID = @logoID

  end
 else
  -- record exists, update it instead
  begin

    update UserProfile set PropertyValue = @logoVar, LastUpdatedDate = getdate() where UserId = @UserID AND PropertyDefinitionID = @logoID

    -- DEBUG   select PropertyValue,LastUpdatedDate from UserProfile where userid = @UserID and PropertyDefinitionID = @logoID

  end

end