The Dev Pages

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.

THIS FIX DIDN’T WORK FOR FF ON A MAC. I’m still baffled about how to fix this. I think put a link for a firefox update may be the best solution.

When you select an input in FF <= 2, the blinking cursor wasn’t showing up on a form that was buried in a few layers of divs. No cursor was showing up at all, though some inputs had a half cursor (like it was pushed up off the input).

Looks like FF 3 is okay, but the older versions were acting funny. I guess this is a bug in firefox. I don’t know exactly how the bug works, or what the fixes are, are even what the different causes of the bugs are. There are tons of variations on those 3 items. All I know for me is that by doing the following it fixed the problem:

Wrap each input in <div style=”overflow:auto”></div>.

That fixed it for me. overflow:visible also worked. Overflow hidden has been mentioned as working too, but that broke it again for me. Not sure what the implications of these stylings are on how the inputs display, but they seemed to work fine for me.

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

So I’ve discovered the power of brushes and symbols in Photoshop and Illustrator (CS3). Seriously, if you’re looking for some great graphics that are totally scalable (look photo realistic, but are vectorized) you had to familiarize yourself with brushes and symbols. Just google for some tutorials, or just use the Adobe Help, which is amazing. I love Adobe’s documentation for the most part. Even with work and developing in Coldfusion and Flex, the adobe livedocs, etc. are great.

Here’s a site with some cool brushes. I was amazed at the water drops, trees, and even the guns. It looks like a lot of people are starting to use http://www.deviantart.com too. Here’s the link I was talking about:

http://www.psbrushes.net/