Category: General Dev

http://plugins.jquery.com/project/history

this rocks and is better than (and probably inspired by) rsh

Summary – In Access, select your table and then do File->Export->ODBC Option (The last one)

I was missing the mysql table dumps that you can do from phpmysqladmin when my task at hand was to import an access table of postal codes (with their corresponding lat/long coordinates) into a SQL Server database. I decided to go nuts and attempt the task blitzkrieg style with no googling or research first. After only a minute or two looking at save and export options I found the following gem:

File->Export->ODBC Option (The last one)

If your access database is on the same machine as your SQL Server just blast through the ODBC setup menu choosing localhost, and then choose the default database as the database where you want the exported table to appear.

Or if you want to the exported table to appear in a remote sql server database (or any kind of ODBC compatible database I suppose), I think you can specify the ip or host name for that database. Then you choose a table name for your exported table and the thing will appear in your default database!

Fortunately, a few weeks ago I had needed to figure out how to set up an ODBC connection on a server box. Info: ODBC sources are like middlemen for apps to connect to a database. Set these guys up in Admin Tools->ODBC in windows if you are using about any language to access a database. So if the language requires a database connection and there aren’t any built in andd fast easy functions, you can set up connections using ODBC functions.

So I had an image that was not loading, and could not figure out why, in Firefox 3. Turns out it was a plugin, mos tlikely adBlock plus. When all plugins were disabled, the image loaded fine. Here were the URLs which the plugins blocked, and the one it let by.  Looks like the plugin blocks certain URLs based on specific words.

Always worked:

<img src="http://mydomain.com/comm/cmainpromo.jpg" alt="test">

Only worked with plugins disabled:

<img src="http://mydomain.com/comm/ads/siteads/cmainpromo.jpg" alt="test">
<img src="http://mydomain.com/comm/ads/cmainpromo.jpg" alt="test">

So if you have

<cfmail to=””

an error occurs

but apparently when you have

<cfmail to=” ”

It just completes successfully without sending an email to anyone and doesn’t throw errors

This may be one of those things where I am the real cause of this error is totally unrealted to how I perceive the problem, but right now it seems like the folder name ‘bin’ causes problems with webDAV folders.

With a virtual folder on an IIS server that uses webdav, if you create a folder called ‘bin’ you get the following error when trying to access the folder or modify.

Many other folder names worked fine. May be related to the following issue:

http://kbalertz.com/895248/receive-folder-error-message-folder-hosted-Internet-Information-Services.aspx

ALTER TABLE Project DROP FOREIGN KEY FK_Project_Template;
GO

SHOULD BE

ALTER TABLE Project DROP CONSTRAINT FK_Project_Template;
GO

Note: To set up webDAV, here is a good article (If your using IIS 5.0 it is most likely already up and running):
http://www.windowsnetworking.com/articles_tutorials/WebDAV-IIS.html

The following article was good, but I thought it would be better to just use multiple virtual directories rather than multiple IIS sites.

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19095

What I did:
1)make a virtual directory imagesUploads that requires SSL and windows authentication and points to the uploads/images folder on the server. Allow write/modify/etc. in IIS.
2)make a virtual directory images, which points to the same uploads/images folder, but does not require SSL or windows login, just anonymous user read access in IIS.
3)On the uploads/images physical folder, give the upload users all the write/modify access they may need. Give the IUSR anonymous internet user account read only rights.
4)Users upload using webDAV and the URL yourdomain.com/imagesUploads, but your stuff will all point yourdomain.com/images

The retarded thing is, that is a user tries to access the non-ssl upload site, windows will still prompt for a login, and will deny them no-matter what, because it is not SSL. but I wonder if the uname/pw text is being sent, because that would make network sniffers pickup the credentials.

Modify Relationships (foreign keys?)
Select the relationship
Under Table Designer expand ‘Insert and Update Specific.
Set update rule to cascading