facebook  linkedin  Twitter  skype  Rss googlePlus


SQL

Replace Text via SQL Replace in a DNN HTMLText Module

Oct 19 2008
6975
When migrating portals from one instance to another, you can use the template creation in DotNetNuke to export a template with content and then import that template to another instance. The problem you end up with however is the links tend to break as your portals directory usually has another id assigned to it. With SQL 2005 you can use the replace function to replace some text, but you're dealing with an ntext field, and you also don't want to run the replace on all DesktopModules if you have a multi portal instance. Here's a SQL 2005 sto...

Beyond Stored Procedures: Defense-in-Depth Against SQL Injection

Jul 26 2006
6849
A few years ago, mentioning the phrase "SQL Injection" to developers or asking to adopt a "defense-in-depth" strategy would probably get you a blank stare for a reply. These days, more people have heard of SQL Injection attacks and are aware of the potential danger these attacks present, but most developers' knowledge of how to prevent SQL Injection is still inadequate, and when asked how to defend their applications against SQL Injection, they usually reply, "That's easy, just use stored procedures." As we will see, using stored procedures is ...

TSQL Code Snip: Searching for Locations within a Radius of a Zipcode

Aug 17 2005
6292
In a previous article we provided a code snippet in ASP on how to conduct a search based on two criteria from the user, a postal code, and a miles for searching within a radius. In this article we provide the same functionality, but all within TSQL. This solution provides some benefits over the previous version, instead of running the calculation in the ASP code, and sending a request for a long list of matching zipcodes, we do the entire calculation in the stored procedure. This reduces the amount of requests and traffic needed to sent over t...

Indexing Database Content with dotLucene

May 04 2005
8250
In this article we will discuss how you can use dotLucene to index content located within a database. dotLucene is a open source full-text catalog solution developed in C# which is a direct line by line port of the popular Lucene engine based on Java. In this particular example, we will discuss how the Weblog indexer was created for BlingBlangBlog.com and WWWCoder.com that goes out and spiders Weblog content, places it into a warehouse, and then code is written to index the content via dotLucene for later searching. In order to inde...

Calling a stored procedure from ASP.Net

May 04 2005
7589
 By Brad Kingsley I guess I'm from the "old school" because I learned coding without a fancy GUI and I still have a tendency to lean that direction when possible. The latest version of Visual Studio is a great tool, but I still like to understand what's going on rather than just dragging and dropping controls onto a page. Perhaps with some more time I'll give up on this way of thinking, but for now I still like to hand-code at times. With ASP.Net 2.0 available now, I wanted to create an ASP.Net page that would pass parameters to a S...
Displaying 1 of 4 - Next Page

 

Thank you for visiting our site, before you leave, please visit some of the areas or information you may have missed.

Popular Articles