Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...command replacecommand replace
Previous
 
Next
New Post
2/28/2010 10:28 AM
 

Hi,

I have installed DNN 5.2.3. with sql 2008
In DNN 5.2.3 is a bug with the portal settings.
Because this, I'am not able to edit the copyright text in my portal.
now I want to use the following command to replace the footer text in the database.
The sql command does not givens an error, however the replace is done.
The command I use is.


select replace(footertext, 'Ton Hermes, Patrijzenhof 31, 1742BH Schagen', 'Ton Hermes, Patrijzenhof 32, 1742 BH Schagen, Netherlands') from portallocalization where portalid = '26'

Somebody knows what I'am doing wrong?
Regards, Ton Hermes


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
2/28/2010 1:35 PM
 

Try this:

UPDATE PortalLocalization
     SET
        FooterText = 'Ton Hermes, Patrijzenhof 32, 1742 BH Schagen, Netherlands',
        LastModifiedByUserID = 2,
        LastModifiedOnDate = getdate()
     WHERE PortalId = 26
GO

Before executing the command, replace the UserId value with your UserId. Also, if your DNN installation uses a different {databaseOwner} then dbo or a non-blank {objectQualifier} be sure to adjust the table name appropriately. Note that since PortalId is an int, do not use single quotes around it's value.

Note also that this will update all entries for PortalId 26 in the table to the same FooterText regardless of the CultureCode.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
2/28/2010 1:56 PM
 

Hi William,

This worked out good.
Many thanks  .

With regards, Ton


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...command replacecommand replace


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out