Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

$4.95 Windows Hosting at Webhost4life.com
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
Verndale
The Official Microsoft ASP.NET Website
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Single Quotes in Database installation script
Previous Previous
 
Next Next
New Post 1/22/2006 4:55 AM
User is offline Niclas Lindblom
2 posts
10th Ranked


Single Quotes in Database installation script 

Hi,

I have a stored procedure wich requires a space in a select statement using single quotes. I am trying to build a SQLDATAPROVIDER file for distribution, but the script seem to fail when it gets to the single quotes. Is there a work around for this ?

Sample

{objectQualifier}Table1.Name + ' ' + {objectQualifier}Table2.Name AS FullName

 

Niclas

 
New Post 1/22/2006 12:05 PM
User is offline cathal connolly
2756 posts
www.cathal.co.uk
5th Ranked










Re: Single Quotes in Database installation script 

You have to save your script in unicode (UTF8). Open it in notepad, and during save as select utf8 as encoding.

Cathal

 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Single Quotes in Database installation script
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


SINA101
WANT A SPECial sIte iN TAIWAN?
sina101.com
Web Development and Strategy Firm
The Risdall Interactive Agency s websites, strategies, branding, & promotion in digital space.
www.Risdall.net/
Windsor Management Group
Fund Accounting Software for K12 Education.
Infinitevisions.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP