Display Filtered Recordset based on Authorised users or any Conditions

Have you come across a situation where you want to show Filtered Recordset results based on some Criteria/ conditions? Please Note that I am not talking about Filtering Recordset values but Filtered Recordsets.

e.g. you have a search - Result/Detail page in which some of Filteres Recordset Results are supposed to be shown only to authorised Members.
OR

You have Search - Result pages in which you have given the Users the option of "OR" and "AND" (sorry for my terrible english, to have an idea of what i am talking about see this search page).
We will go through the two Scenarios one by one.

Insert/ Update the same Request/ Form Variable in multiple Fields of Database Table using DW Insert/Update behaviour

Unfortunately by default it is not possible to Insert or Update the same Request/ Form Variable in multiple Fields of Database Table while using DW Insert/ Update Server Behaviour. Well you have to handcode few lines only and its done.
So lets see what we can do about it!

Setting NTFS Folder Permissions for IUSR account
This Tutorial is for Newbies. It is fairly simple to set the Ntfs Folder permissions. So i will just demonstrate here step by step how easy it is
Multiple paramater ASP - Access Database search
This tutorial will explain how to create a database search page, a results page and a detail page using Dreamweaver and Microsoft Access. You will need both these applications and a PC with Windows 98, Windows NT with PWS (Personal Web Server) or Windows 2000 or XP pro with IIS (Internet Information Server) installed in order to complete the tutorial.

NOTE: This tutorial was originally written for Ultradev 4, however, with the exception of a few interface differences, the process is almost identical for Dreamweaver MX and you shouldn't have any problems following the tutorial.

Take a look at the working demo to see how the finished pages will work.
Using DBManager to Configure MySQL

It is sometimes daunting for a beginner to configure and use the MySQL database engine. A good GUI can help no end. My favourite Windows-based GUI is called DBManager, and is available from www.dbtools.com.br.

This tutorial assumes you have read and followed my two earlier tutorials, on installing Apache and PHP, and on installing MySQL.

 

Database Programming with mySQL and PHP
This tutorial is mainly intend to the audience who already has a little background on databases and want to do database programming in mySQL and PHP. If you are in a real hurry I suppose you can rush to the summery straight away.
Resize Images more than once with Smart Image Processor extension
Resize Image more than Once Using Smart Image Processor Extension
Installing PHP as CGI binary (on Windows Platform)
This is a set of Instruction rather than a tutorial, for those who want to get the PHP up and running as soon as possible. I'll be looking forward to discuss more PHP with you in the future. So this could be a good starting point.
Configuring Apache 2 and PHP 4 for Windows
This tutorial is designed to help you set up a server environment for using PHP with Dreamweaver on a Windows platform. The tutorial recommends using the Apache Web Server, Windows Installer Version, and zipped source code for PHP.
Inserting Data into Multiple Rows of Database
This is in response to a user that is "looking for a tutorial on inserting data from a UD4 form into multiple rows of a SQL Server database table."
Newer articles Older articles