Evidia Ltd

Insert from another table where record does not exist

admin — Tue, 27 Sep 2011 20:48:14 +0000

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

Loop Variables

admin — Mon, 19 Sep 2011 14:41:07 +0000

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

DomainKeys / DKIM

admin — Mon, 01 Aug 2011 03:26:28 +0000

Why is this such a mystery?

It took a lot of digging, but I will outline the steps I took for a linux/apache system to setup SPF and DomainKeys. DKIM is still in the mystery mode, not sure I have that right. I will update this if anything changes.

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

Remove blank lines

admin — Tue, 31 May 2011 19:41:28 +0000

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

clean up spaces in field data

admin — Thu, 07 Apr 2011 20:33:09 +0000

update mytable set field = trim(field)

Clean out non-breaking space from data

admin — Thu, 07 Apr 2011 20:32:28 +0000

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

Javascript parseInt – buggy

admin — Wed, 23 Mar 2011 23:56:47 +0000

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.

Mailing List feature on Hosting

admin — Wed, 16 Mar 2011 17:35:47 +0000

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.

Dreamweaver CS3 crash when Copy/Paste

admin — Sun, 28 Nov 2010 03:42:30 +0000

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

Removing duplicate entries

admin — Fri, 22 Oct 2010 13:58:22 +0000

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.