NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
How to delete duplicates in a mysql table using ASP
35154
How to delete duplicates in a mysql table using ASP
http://www.coxeh.com/How_to_delete_duplicates_in_a_mysql_table_using_ASP.html
Here is the simpliest way of deleting duplicate items in a mysql database that i know of. As far a i know mysql have yet to develop a delete duplicate function.
ASP > Tips and Tutorials > Database-related
Apr 1, 2007
Coxeh
send email to Coxeh
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
Other links owned by this user
PHP Penetration Test is a program for performing simple form based security tests. Securing the internet is upon to developers to create proper forms and applications. This is a tool for testing individual fields and values from various attacks. How to use this program:
Category:
2. PicturePush
Do you want to offer a great photo and video sharing website? In your own language? With a special theme? Within your organisation? MovingLabs offers a hosted service that allows you to create your own photo and video sharing website without programming. The service is based on the proven technology of PicturePush, a high quality photo and video sharing site.
Category:
A new download is available in the download section.
The SRDownload script is a basic download script that list files from a download directory to be downloaded, along with a text file to give more information about the downloadable file.
The SRDownload script is a basic download script that list files from a download directory to be downloaded, along with a text file to give more information about the downloadable file.
Category:
With this powerful script you can start your own search engine service for a rapidshare, badongo, sendspace, mediafire and 4shared download links as the huge sites around the web.
Category:
The script will watermark image using another image. A simple approach to put your company logo or copyright notice on the image, thus protect it from stealing.
Package contains example for watermarking all the jpg images in a folder. Can be easily changed to process gif and png images.
How to use:
Unpack files, and save them on the server where you have images for watermarking.
Update watermark_image_example.php to match your requirements: set images folder and watermarked images folder.
Open the file in browser, and it will generate watermarked images according to your settings.
Package contains example for watermarking all the jpg images in a folder. Can be easily changed to process gif and png images.
How to use:
Unpack files, and save them on the server where you have images for watermarking.
Update watermark_image_example.php to match your requirements: set images folder and watermarked images folder.
Open the file in browser, and it will generate watermarked images according to your settings.
Category:
Often people find it difficult to manage their resources or fail to manage their income and expenditure leading to a life which no longer lead their family or society in a happy and healthy situation. It can grow up as a social problem."
Category:
To successfuly recover your lost e-mails, download and run our SoftAmbulance 4 Outlook Express.
Category:
Managing large dynamic websites has always been a difficult task for several webmasters, we have developed Article Publisher Pro keeping you in mind. By using this system one can easily manage their news and/or articles quite easily. You can easily update your content with almost all web based browsers easily.
Category:
FlashCam is a Flash-based, enterprise Web application that supports live text and audio/video communication. This is the next generation of Multi-User Chat software; beyond text messages, it provides rich communication through compressed streaming Audio and Video. FlashCam lets your users interact easily in an elegant, multi-room chat environment. Utilizing Macromedia’s new Flash Communication Server technology, this chat tool allows people in corporate, community, dating, or collaborative web environments to see and hear each other, increasing communication and understanding.
Category:
brownrecluse is an internet programmable spider. lets you write your own scripts, or download already made scripts from our web site. the sbl (spider bot language) was designed by softbyte labs which is a very easy to understand (and use) programming language. it uses a variety of features found in pascal, vb, c++ and javascript to allow any programs to quickly master the language. brownrecluse lets you pull web pages (or files etc.) and save them to your hd (or display them) in just a few lines of simple code. but this isn't it. brownrecluse lets you scan and manipulate the data in every way possible. unlike normal spiders, brownrecluse does not need filters, options and plugins to accomplish a task. you program it to make it do just what you want the language was designed for internet spidering programs. this means, you do not need to worry about making functions to access the internet, pull web pages or files etc. the language already include everything you need. for example, if you wish to pull a web page and display its source code in the output window, you only need 4 statements. one to create a url object, one to assign the actual url to pull, one to get the data, and finally, one to display the data. it is also used to scan web sites and process the information retrieved, and optionally, create databases of the processed information.
Category:
We put together this site because of costs. Many jobs sites costs 100's of dollars for employers to list their jobs and for job seekers miss out on some great jobs out there. We will bring more job listings and offering as employers can search RESUMES to find employees.
Category:
An easy way of building a personalized homepage as a Standalone service or Integrate with any third party CMS, Blog, Bulletin Board applications, so members of those systems do not need to register again to start Personalizing their homepage.
Category:
13. ajax im v3.1
ajax im ("asynchronous javascript and xml instant messenger") is a browser-based instant messaging client. It uses the XMLHTTPRequest object in JavaScript to send and receive commands to and from the server. No refreshing of the page is ever needed for this "web application" to work, as everything is updated in real-time via JavaScript.
Category:
14. Earn REAL money
Kwikcontent quickly turns any domain name into a portal full of thousands of pages of highly Search Engine Optimized content. Search engines will LOVE your new website and send you plenty of organic traffic daily. That’s FREE traffic coming to your website. There is no catch... we have quite simply built a wonderful piece of software that allows any domainer to turn his or her domain names into revenue earning machines that will out-perform any cash-parking program.
Category:
A very smart practice in coding is to test if the function will have the ability to perform in a particular browser. This is especially true in Ajax-based websites as developers have to face constant browser incompatibilities. Objects could easily be a problem when everything is in place for a particular browser but it will just falter since development of the program has not considered other browsers.
Category:
Very often web reports needs input parameters. For example, this can be period of report (i.e. start date and end date). Hopefully we all have built-in calendars for this. But what to do when we need to select just month and year for our report?
Category:
REST is short for Representational State Transfer. I'd place that into the category of names that makes more sense once you understand what REST is, but isn't quite so helpful in terms of explaining it. REST is often heard in the context of web services. When it was suggested as a topic for me to write about it was described to me as a web service but doing "the query string thing" to pass it parameters. That's not really what it's about, though.
Category:
Using this lesson, You will see how to create simple, but in the same time very modern text animation which you can use for any flash header, presentation, animation...
Category:
This tool will help you to analyze your domain with Google search to detect if the domain is banned. It check for your domain indexed in google server.
This tool does not work properly if domain is expired. There are some limitations for this script.
This tool does not work properly if domain is expired. There are some limitations for this script.
Category:
20. Social Media
Social Media is the perfect solution to create your own video sharing and uploading community just like Youtube, Myspace and Metacafe.... this premium package includes the most advanced features on the market today at an extremely affordable price while offering the potential for you to reach maximum rewards.
Category:
Other links at ASP > Tips and Tutorials > Database-related
Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software. Hopefully, you would find it useful
Category:
This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.
Category:
This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement.
Category:
DSN Connections
In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel spread sheet etc.
I will now skip the steps of creating and assigning DSN to a database, you can see them by clicking here. Once you are done creating a DSN for your data source ( database lets say ), you can connect to it using following code
In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel spread sheet etc.
I will now skip the steps of creating and assigning DSN to a database, you can see them by clicking here. Once you are done creating a DSN for your data source ( database lets say ), you can connect to it using following code
Category:
We can use several providers to open DBF files usind ADODB. Basic way is to use ODBC data source (DSN or DSNless), there is several samples published on web. But how to open DBF files without ODBC? There are two other OLEDB providers, using which you can work with DBF files. One of them is Microsoft.Jet.OLEDB.
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Category:
Main Category
165
2028
756
275
169
1801
1074
892
1127
7088
70
874
58
2145
170
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 18673
Categories: 1275
Registered Users: 533
Mailing List Subscribers: 2031
Unique Outgoing Hits: 192435
Pagerank Statistics
PHP News