CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.custom_modules Tags:
Item Type: NewsGroup Date Entered: 9/9/2004 5:55:06 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 13 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
6 Items, 1 Pages 1 |< << Go >> >|
jjmartin
Asp.Net User
Plus symbols in SqlDataProvider9/9/2004 5:55:06 AM

0/0

While im looking for the answer in old messages, Ill ask in case someone knows the answer faster than I can find it.

My SqlDataProvider has a stored procedure with some plus symbols in it...

SELECT {databaseOwner}{objectQualifier}Modules.ModuleID, {databaseOwner}{objectQualifier}ModuleDefinitions.FriendlyName + ':' + {databaseOwner}{objectQualifier}Tabs.TabName + ':' + {databaseOwner}{objectQualifier}Modules.ModuleTitle as ModuleDescription

but when this is run at installation time the plus symbols seem to be stripped out:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 9: Incorrect syntax near 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
[SNIP]
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.PhotoAlbumModuleList ( @FriendlyName varchar(50) = 'Photo Gallery Module', @PortalId int ) AS SELECT dbo.Modules.ModuleID, dbo.ModuleDefinitions.FriendlyName ':' dbo.Tabs.TabName ':' dbo.Modules.ModuleTitle as ModuleDescription FROM dbo.Modules INNER JOIN dbo.ModuleDefinitions ON dbo.Modules.ModuleDefID = dbo.ModuleDefinitions.ModuleDefID INNER JOIN
[SNIP]

Thought i have read about this type of thing before but I can't remember the exact issue.
Jeff Martin
MCSD C# .NET
http://www.jeffmartin.com
cjsmitty
Asp.Net User
Re: Plus symbols in SqlDataProvider9/9/2004 10:32:29 AM

0/0

Make certain that when you are saving your SQL Scripts that you do so in UTF-8 format, not the standard ANSI.

That should do it! Good luck...
~Chris

Net Data Design
706Horsman.us
jjmartin
Asp.Net User
Re: Plus symbols in SqlDataProvider9/9/2004 2:23:47 PM

0/0

That was it, I ended up finding the answer in another forum post.

I haven't looked at the DNN code, but this seems like shoddy text reading on DNN's part. Anyone know if there is a fix planned for this?
Jeff Martin
MCSD C# .NET
http://www.jeffmartin.com
mrswoop
Asp.Net User
Re: Plus symbols in SqlDataProvider9/11/2004 5:39:15 AM

0/0

Jeff ~

Forgive me, I'm reaching way back in my memory here and answering on someone else's behalf. As I recall, the file reading for the installer is pretty complex. The main reason for this is related to internationalization. When the files are uploaded, we have no way of knowing what encoding system was used on the source platform... and so we are actually using some code to try to determine which of the many possible file encodings were used... we handle all the Unicode options pretty well, I think.

If you have some code which can reliably identify an unknown file encoding... we would gladly accept it!

Cheers,
Scott
Scott Willhite
It is only with the heart that one can see rightly... what is essential is invisible to the eye.
~ Antoine de Saint-Exup?ry
JimHugh
Asp.Net User
Re: Plus symbols in SqlDataProvider9/11/2004 8:21:14 PM

0/0

You may want to check out the code at http://www.dotnet247.com/247reference/System/Text/ASCIIEncoding.aspx
Jim Hughes
mrswoop
Asp.Net User
Re: Plus symbols in SqlDataProvider9/12/2004 6:12:02 AM

0/0

Thanks Jim ~

We actually do use code very similar to this. If you follow the article, at one point it does also indicate that you have to make a choice about what to default to if you are unable to detect a specific Unicode format by the Byte Order Mark (BOM), which is not always present. We have chosen to default to an expectation of UTF-8, rather than ASCII, since we have a significant installed base internationally and will be fully supporting internationalization in the application. Windows default is also, I believe, UTF-8... so should make sense most of the time.

It's pretty non-trivial, and these decisions are not made arbitrarily. If someone has another working solution... tested under many scenarios... we would welcome a look at it.

Cheers,
Scott
Scott Willhite
It is only with the heart that one can see rightly... what is essential is invisible to the eye.
~ Antoine de Saint-Exup?ry
6 Items, 1 Pages 1 |< << Go >> >|


Free Download:


Web:
CodeProject: Creating a DNN Module and Understanding DNN ... You can access the code behind file by clicking the plus symbol next to the .... Open the SqlDataProvider.cs file and look in the Public Methods region. ...
SQL Stored Procedure losing '+' when installed as part of a PA ... SqlDataProvider file as part of my PA, when I upload and install it appears that the "+" ... The Plus symbol or Hex 2B must have special meaning in UTF7. ...
SQL Project: Creating a DNN Module and Understanding DNN ... You can access the code behind file by clicking the plus symbol next to the .... we are going to need to modify the SqlDataProvider that inherits from the ...
GraffitiCMS review - Steve Schofield Weblog Add link syntax: Note the syntax is separated by a PIPE "|" symbol ... Graffiti allows for custom categories, additional users, RSS feeds, plus a few other ...
Catalook Administrator User Manual Customized currency symbols: You can add customized currency symbols to all ...... SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ...
WinTechPost CTRL+ALT+Plus (+) symbol on the numeric keypad ...... ERROR: Could not connect to database specified in connectionString for SqlDataProvider ...
WWWCoder.com Feedage.com Have you been using SQL Plus or any of the other third-party tools for ...... Learn how to extend this architecture to add Intellisense symbols for your ...
Resharper 4 - Karl Seguin NET,it's only possible to localize currency symbol, decimal separators, ...... and inject the Test|SqlDataProvider into the Indicator class? ...
Beginning DotNetNuke 4.0 Website Creation in C# 2005 with Visual ... Rather than use a trademark symbol with every occurrence ...... In the Solution Explorer, scroll back up and open the SqlDataProvider.cs file. This is ...
u.s. consulates in russia [url=http://hometown.aol.com ... ... .envy.nu/timepunch.sqldataprovider.html]timepunch.sqldataprovider[/url] ...... u.s. fought japan[/url] www.verenique plus size.com wyckoff chrysler.com ...




Search This Site:










difference between a web application and an asp.net website?

sql errors

could not load type with framework 2.0

blog module is final available !

?make masterpage menus appear over the content of other pages

activedirectorymembershipprovider account lock out

help - i'm trying to exclude a configuration file from visual studio, but it keeps popping up

treeview node display question

replacing "resource not found" error message when accessing unauthroized pages

client side caching

error messages in native language?? i need them in english ...how to change how vs 2005 is working?

dynamically adding user control, please help

removing dnn menu from specifc pages

remove register button on login form for a child portal

integrated windows authentication problem

vwd jit compiler error

how to rename website

legal: copyright concern.

what is my current release?

a problem occurred sending the email. please contact the system administrator.

login form use variables passed from 3rd party site

how to get a picture from webcam using asp.net

netpolls - free dnn poll module

i have a stupid question, but cannot find the answer anywhere....what's the deal with the app_code and app_data folders? why?

dnn v2 forum and dnn v3 forum on asp.net?

css friendly gridview

how to cache server control on master page

treeview selectednodechanged event

3.1.1 installation issue

xml as data for small store
 
All Times Are GMT