insert into rosternspc(NSPid,`First`,Last,Region) select summary2010.NSPid,summary2010.`First`,summary2010.Last,summary2010.Region from summary2010 where not exists (select * from rosternspc where rosternspc.nspid = summary2010.NSPid) order by nspid

function validate(this)
{
for(i=0; i<this.elements.length; i++)
{
document.write(“The field name is: ” + this.elements[i].name + ” and it’s value is: ” + this.elements[i].value + “.<br />”);
}
}

Create Public and Private keys on the server:

$ openssl genrsa -out rsa.private 768

then Create the Public key

$ openssl rsa -in rsa.private -out rsa.public -pubout -outform PEM

. Setup a SPF record. This is probably the easiest part. On the account you control your DNS Zone, add the following:

yourdomain.com. IN TXT “v=spf1 a:mail.giviton.com a:server1.giviton.com a:giviton.com -all; p=[INSERT PUBLIC KEY HERE]”

DomainKey DNS Entries:

_domainkey IN TXT “t=n; o=-” ….where t is ‘test’, set to ‘y’ if you want in test mode

default._domainkey IN TXT “k=rsa; t=n;p=[INSERT PUBLIC KEY HERE]” …where default is defined in the exim config file for DK_SELECTOR

edit exim/configure file

look for dk_selector – make sure to update DNS entry accordingly, or add dk_selector to config file

look for dk_private_key and look for location where private key file is suppose to reside. Copy those files to that location, or create the dk_private_key entry

if applicable, save and restart exim

Testing:

Send email to dk@dk.crynwr.com – will return with validation that SPF and domainkeys are ok
Send email to check-auth@verifier.port25.com – will return validation for domainkey setup

Other references

http://wiki.exim.org/DomainKeys

http://domainkeys.sourceforge.net/

SpinnakerPro video – http://www.youtube.com/watch?v=fPrfZWbXGi0

1. Open the file
2. Click CTRL + F
3. Select “Current document” in “Find in” (You can also select the folder if you have multiple files)
4. Search in “Source code”
5. Tick “Use regular expression”
6. Type “[\r\n]{2,}” (without quotes) in “Find”
7. Type “\n” (without quotes) in “Replace”
8. Press “Replace All”

update mytable set field = trim(field)

update mytable set field = replace(field,char(160),”")

There is a known issue where passing in a value with a leading zero can result in bad results.  For example, if you parseInt(“09″), it will return 0 (zero).  The common way to get this to work is to use the ‘base number’ parameter.  In the case, we are talking base ten, so the corrective call to the javascript function is parseInt(“09″,10)….this will return the correct ’9′ value.

Not all mailing list programs are created equal.  What I run into is user management basically sucks.  One non-feature is the ability to delete all users easily (assuming you don’t keep an external list that was loaded in the first place).  Here is how to do it:

• Set maximum shown users to something big in the general options
• go to the user page, highlight and copy
• Using excel 2010, I can paste special using (Match Destination Formatting)
• This creates a column of your membership email addresses
• You can copy and paste this into a text document and upload it for the unsubscribe.

This keeps you from deleting the entire list, and then having to reconfigure it all.

This a occurs when editing a file and you try to copy/paste, and boom…crash.  It seems to be related to when the daylight savings time is adjusted.  Here is the ‘fix’…..

Delete WinFileCache-AD76BB20.dat from the dreamweaver user configuration folder.  On XP it is located at C:\Documents and Settings\[username]\Application Data\Adobe\Dreamweaver 9\Configuration

A way to purge duplicate table entries based on duplicate columns(>1).  Assuming no index is yet defined…

alter IGNORE table MyTable add unique key (DUP-ROW-1,DUP_ROW-2)

This will add an index made up of dup-row-1 and dup-row-2 and will automatically purge those duplicates out of the table.  If you can leave the index definition, delete it and this same command at a later time when you need to purge the table again.