Prevent duplicate Inserts

Posted At : March 16, 2005 1:46 PM | Posted By : Steve
Related Categories: SQL

I frequently need to insert a record that relates to tables to each other (or relates one table to external data) and I cannot have a duplicate record. Here is my method for doing this in case it helps anyone and as a convenient reference for myself.

Let's suppose that you have three tables: Users, Classes and Students. Classes has a primary key of ClassID (int). Users has a primary key of UserID (int). Students has a two-column primary key of ClassID and UserID which relate to the corresponding columns in Classes and Users respectively.

[More]

Comments (1) | Print | del.icio.us | Digg It! | Linking Blogs

Web Services Guru Needed

Posted At : March 16, 2005 5:59 AM | Posted By : Steve
Related Categories:

I am working on two projects that need to share data and it looks like web services will be the best option. These projects may influence the standards of other similar projects.

I want to make sure that the web services are written in a manner that will be viable for future use across any projects of this type (which will likely be written in differing programming languages). Since I don't yet have any production experience with web services, I would certainly like to have someone available for (paid) consulting.

If anyone has a solid foundation in web services and might be available for some consulting work, please let me know. You can contact me using my contact form, or you can send me an email (my first name at my domain name).

Comments (0) | Print | del.icio.us | Digg It! | Linking Blogs
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.