nathfy.com

Byte Order mark (BOM) woes

2010-06-15T10:52:00.000-07:00

PHP seems to suffer from the BOM problem on windows more than most - here is some code I found that will look through your files and tell you which ones have the evil mark...

http://pastebin.com/dHbqjUNy

define('STR_BOM', "\xEF\xBB\xBF");
$file = null;
$directory = getcwd();

$rit = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($directory), RecursiveIteratorIterator::CHILD_FIRST);
try {
foreach ($rit as $file) {
if ($file->isFile()) {
$path_parts = pathinfo($file->getRealPath());

if ('php' == $path_parts['extension']) {
$object = new SplFileObject($file->getRealPath());

if (false !== strpos($object->getCurrentLine(), STR_BOM)) {
print $file->getRealPath()."\n";
}
}
}
}

} catch (Exception $e) {
die ('Exception caught: '. $e->getMessage());
}

remember to wrap it in php tags - they are being removed by blogger so i can't show them.

retrieve emails as plain text from exchange webservices

2010-02-24T09:33:00.000-08:00

basically create a new propertyset with the schema you need to retrieve, and then set the 'RequestedBodyType' of the 'propertyset' to 'BodyType.Text'

code example:

PropertySet myPropertySet = new PropertySet(
ItemSchema.Importance,
ItemSchema.Subject,
ItemSchema.Body,
ItemSchema.DateTimeReceived,
ItemSchema.HasAttachments,
EmailMessageSchema.From,
EmailMessageSchema.ToRecipients,
EmailMessageSchema.DisplayTo

);
myPropertySet.RequestedBodyType = BodyType.Text;
service.LoadPropertiesForItems(findResults.Items, myPropertySet);

foreach (Item myItem in findResults.Items)
{
//etc
}

MySQL server has gone away Error on restore from backup

2009-08-06T07:36:00.000-07:00

when you are restoring from a backup of a large db you get this strange error from mysql: "MySQL server has gone away Error"

to cure it open mysql admin>startup variables>advanced networking and change the max_allowed_packet to 16M (or higher)

restart mysql and try the restore again.

MSSQL Linked server to MySQL

2009-07-31T07:46:00.000-07:00

First download the connector:
http://dev.mysql.com/downloads/connector/odbc/5.1.html
Then the MySQL GUI tools
http://dev.mysql.com/downloads/gui-tools/5.0.html
install both on the MSSQL server

Go to the MySQL server a create a user:
mssqllink
Give them permissions to access, update etc the tables you need. To make sure they have remote access from another ip or hostname, right click on the user in the administrator and "add hostname". Fill in the hostname or IP of the MSSQL server.

Go back to the MSSQL server and connect to the MySQL server via MySQL Administrator. Use the username and the password you set for that user. If you can't connect then go back and check the user details on the MySQL server. No connection here, no connection from MSSQL

Go to the windows control panel>administrative tools>ODBC datasource and click on the system DSN tab. Click 'Add' and choose the MySQL ODBC driver - fill in the details with the username and password you used to connect from MySQL Administrator. Click test and it should come back ok. Save the datasource name so you can use it below.

Open SQL server management studio and go to Server objects>linked servers
Add a new linked server, choose the microsoft OLE DB provider for ODBC drivers Provider and fill in the details.

NOTE if this isn't present then you'll need to install it, for 64 bit servers MS has released it as a hotfix:

http://blogs.msdn.com/data/archive/2008/04/07/64-bit-oledb-provider-for-odbc-msdasql-is-now-available-for-windows-server-2003.aspx

Now on to the connection string. The connection string for MySQL connector 5.1 is:
Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
more info here: connectionstrings.com

Replace the myServerAddress, myUsername and myPassword as before for MySQL. Note i found that adding the database parameter caused it to fail, so if you have problems try omitting that one ("Database=;"). Finally add the name of the system DSN you created.

Phew! click ok and it will all work as expected. if not then check all the connections and things and make sure you can connect via MySQL administrator using that username and password.

to select data from the tables on the MySQL server you must use the
select * from OPENQUERY(LINKNAME,'Select * from x')
syntax as the connector doesn't support the 4 part name access. Get around this by using views in your MSSQL db of the MySQL tables.

Coldfusion query error - INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'

2009-06-18T06:59:00.000-07:00

You can avoid this by setting your database options.
1. Right click your database
2. Click Properties
3. Click Options on the Left pane
4. Turn "Arithmetic Abort Enabled" to "True"

Execute your cfm page again and it should work properly

and info here: http://support.microsoft.com/kb/305333

ASP.NET control referencing in jquery

2009-03-24T04:56:00.000-07:00

ASP.NET controls often render with client-side IDs different than what's declared in your aspx code.

If your using jquery the easiest way is to use the [attribute$=value] method - an example to get the aspx made link id, from your coded id:

//include jquery.js then:
$(document).ready(function(){$("a[id$='login_link']").click(function(event){tester(event,this)});});
function tester(event, el){
event.preventDefault();
alert($(el).attr("id"));
}

//for element:

Prototype.js get checked elements

2008-03-05T05:03:00.000-08:00

To get the checked elements from a group of checkboxes you can use the select and css3 selectors shortcut:

var checked_el=surrounding_el.select('input:checked').each(function(checked_el) {
//do something with only the selected elements
alert("checked_element: "+checked_element.id);
});

/*
checked_el is a array holding the found elements
surrounding_el is a fieldset or div that encloses the checked boxes
select('input:checked') - select all with a CSS3 seletor type
of checked (http://www.w3.org/TR/css3-selectors/)
.each(function(checked_el) - loops on all the ones that are found
*/

google maps marker z index

2008-02-20T09:46:00.000-08:00

Google have now prevented access to marker.setZIndex() (which was undocumented method anyway) A work around to get your marker to the top is:

function add_marker(){
var marker = new GMarker(point,{zIndexProcess:importanceOrder});
marker.importance = 2; //higher importance = higher marker z index
the_map.addOverlay(marker);
}

function importanceOrder (marker,b) {
return GOverlay.getZIndex(marker.getPoint().lat()) + marker.importance*1000000;
}

which moves the marker higher up - note you'll need to do this after you've added all the markers to the map. Otherwise the next z-index will continue after the last one you added (effectively cancelling out your increase in z-index)

Coldfusion query column to array

2008-01-24T03:06:00.000-08:00

The normal method of converting Coldfusion query column to array is to use a valuelist and list to array:

the_array=listtoarray("#valueList(the_query.the_column)#")

But this strips out any cells with empty strings in. To get around this use:

the_array=duplicate(the_query[column_name]);
ArrayPrepend(the_array,the_query[column_name][1]);

why the ArrayPrepend() call afterwards? Because CF arrays start at 1 and Java (the underlying language) starts at 0, so the duplicate function misses off the first row of the column.

nice.

stop event bubbling in js and prototype.js

2007-11-07T04:08:00.000-08:00

Prototype.js has the stop() function, which also stops the default behaviour of an action. sometimes you want to just stop the bubble rather than the default action (for example on checkboxes)

so cross browser function to do it:

function cancel_bubble_event(event) {
//cancel the bubble but not the default action
if (event.stopPropagation){
event.stopPropagation();
}else{
event.cancelBubble = true;
}
}

called by:

window.cancel_bubble_event(event);

Update multiple rows from a query

2007-10-24T04:14:00.000-07:00

use the following SQL as an example:

UPDATE the_table
SET a_column=a.other_column
FROM (
select other_id,other_column from other_table
)as a

WHERE
the_table.id = a.other_id

Create PDF forms and documents for free

2007-08-07T02:24:00.000-07:00

Use Openoffice (http://download.openoffice.org/2.2.1/index.html) to create a document, adding any form fields you need then export as PDF.

Note: form fields in PDF forms shouldn't contain any underscore (_) characters, or else the values aren't sent to the processing webserver. Or at least that is the case with PDF forms created via Openoffice - so avoid anything other than normal letters and numbers in form field names

Table of contents can be created on OpenOffice, as well as specifying the default opening mode of PDF files.

Multiple images as multipage pdf

2007-08-07T02:18:00.000-07:00

Install PDFcreator (http://www.pdfforge.org/products/pdfcreator/download) then open the image in the windows picture and fax viewer - usually the default viewer when you double click it.

If all the images are in the same folder you'll be able to select them all on the printing wizard, then choose PDFcreator as the printer and save the output - Multiple images as multipage pdf.

Edit setup image with Orca.exe

2007-08-07T01:26:00.000-07:00

To edit the setup image of an .msi in ORCA.exe use the binary table then edit the DefBannerBitmap key, by double clicking on it. This will show the 'Edit binary stream' screen. Navigate to the .bmp file you saved earlier and click 'OK' to update it, then save the new MSI file. You can also write the original to file here to, in order to edit it in PS or where-ever.

Note the .bmp must be a 500px (wide) by 70px (heigh) image, saved as index colour (8 bit) bmp file.