Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListNew Data TypeNew Data Type
Previous
 
Next
New Post
10/19/2006 10:47 AM
 
Trying to fix the installation problem I started from scratch and forgot to update the resx files... thanks.

I have not been able to figure out why I am getting that SQL Error when installing the module, I read some posts about encoding but saving both as Unicode - Codepage 1200 and UTF-8, has not solved the problem.

I'd appreciate any ideas you have in this regard.

Thanks!
 
New Post
10/19/2006 1:41 PM
 

try

CREATE PROCEDURE {databaseOwner}{objectQualifier}UserDefinedTable_GetTableModules
AS
SELECT M.ModuleTitle
FROM {objectQualifier}Modules as M
INNER JOIN {objectQualifier}ModuleDefinitions as MD ON M.ModuleDefID = MD.ModuleDefID
WHERE     (MD.ModuleName= 'DNN_UserDefinedTable') AND (M.IsDeleted = 0)
ORDER by M.ModuleTitle
GO


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/21/2006 12:39 AM
 
The new type is working.

The user selects the ReferencedString and types a string of the form TableTitle;FieldTitle on the extended settings box.

If the extendedsettings are not valid, the field will behave like a regular text field, if a valid TableTitle-FieldTitle combination is typed, the user is presented with a ComboBox populated with the values contained on the referenced Table-Field when adding or editing a row.

If anyone is interested in the option let me know, I'll be happy to provide you with the code.

I still have not sorted out the problem of the installation, I had to install the stored procedures manually, and have not yet updated the Uninstall script, will be figuring that out this weekend.

Thanks to Leupold and Steffan for all the suport.

Next step is to add filtering capabilities to the grid...

Benicio
 
New Post
10/21/2006 7:51 AM
 

Benicio,

I am glad you solved your issues (and Iam sure, you learned a lot ;) )

If you don't mind, I would like to have a look at your enhancements, please send it to leupold (at) gamma-concept (dot) de.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/2/2006 10:45 PM
 

Hi Benicio,

Yes, I would be curious to see your code for this. I have made similar data type addition to populate drop list based upon SQL statement. Would be nice if I could let users specify either UDT or SQL source for their drop list. My code is messy and I have not attempted install package, but would be happy to share it with you or anyone else that is interested.

-Lauren

 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListNew Data TypeNew Data Type


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