 WebProWorld Dev Forum |
Online Text Format & ASP
What I'm looking for is a script that gives the visitor the ability to format what he/she is typing directly in the text field like what is called "Online HTML Generator." The same as typing posts in forums
Passing a variable through the url
We are doing a site for a client, we are collecting payment info from customers. I have greated a variable cust_num which works well within the payment program.
|
|
 |
Recent Articles |
Creating Dynamic Website Content with PHP - MySQL
Fresh website content for your visitors can be of real benefit when attempting to generate repeat traffic. Most webmasters, however, just don't have enough spare time to frequently update or rebuild their pages manually.
MySQL for Beginners – How to create a MySQL Database
Whether you are an experienced web programmer or a complete novice attempting to provide data interactivity with your web site, MyQSL is an easy to use and free database solution that can allow you to store and configure data to be displayed on your web site.
|
|
| 06.15.05
Querying System Tables
You might have come across situations where it was necessary to copy all the details in your database into another. To make the situation more complex, consider it between different servers.
Think, think and think very hard. Ultimately you end-up with the solution which is inefficient and time-consuming. Passing the complete stored procedure text as a command string or executing the script file associated with the stored procedure.
Read The Whole Article
Writing Secure Transact-SQL
There are plenty of good sources of information about how to deploy SQL Server in a secure fashion. However, these resources are often targeted at database administrators tasked with securing already developed applications. In addition, there is a rich body of information that discusses writing secure .NET and ASP.NET code, including .NET code that accesses SQL Server. However, many of these resources focus on the data access code that runs on the application servers rather than the Transact-SQL (T-SQL) code that executes within SQL Server. Developing T-SQL code that runs securely on SQL Server is the primary focus of this column.
Secure Your Development SQL Server
Write 10,000 lines of code in 10 minutes!
Iron Speed Designer – Free Evaluation |
|
The first step to developing secure T-SQL is to secure your development SQL Server. Why bother locking down a SQL Server instance that doesn't hold real-world data and will never be exposed to end users? Because this will force you to write more secure T-SQL, and it will also make it much easier to secure your application when it is deployed to production. The following are some specific steps you can take to quickly secure your development server:
Read The Whole Article
How to Implement SQL Server Log Shipping Using Visual Basic
Log Shipping is a Disaster Recovery (DR) tool that provides you the ability to have a readily available "warm backup." Essentially, should your existing system fail, you have a backup SQL Server and database available to take over with relatively up-to-date information. If your database is critical to your business, such as in a call center, log shipping provides an incredible opportunity to make sure that business does not stop for long.
As an example, last year, downtown Houston was flooded so that most of the buildings were inaccessible. Companies that had implemented log shipping to remote DR sites were able to continue using their line of business applications within minutes of losing access to their primary databases. In this situation, a simple clustering solution would have been completely ineffective.
Read The Whole Article
Letting Java in on SQL Server Notifications
Starting with SQL Server 2000, Microsoft added the concept of notification services to their flagship database engine. SQL Server Notification Services lets you generate and send notifications whenever some criterion is met. Generally, you use notifications to alert or update data for users or applications without having to repeatedly poll the database to discover whether data has changed or to display the latest data. For example, if you follow fantasy sports, it would be nice to have a notification service that informs you when your star player is injured. Alternatively, if you prefer the stock market, you may want to be notified when a stock you own reaches a particular price on the upward or downward curve!
With SQL Server 2005, you can generate notifications and have the SQL Server distributor send those notifications in any of several ways:
Read The Whole Article |
