For a dealer locator. The idea was to randomize the results of the query. Users tend to pick the link at or near the top of the list returned. We want an easy to give everyone some chance at the top of the list. Looking up some code on the Internet gave me the solution of using “SET QUOTED_IDENTIFIER OFF” at the top of the query, and Order BY newid() at the end. We wanted users that may live on the border of say North and South Dakota to be able to choose both states from a list to search. This query worked great until we attempted to upgrade to ColdFusion 10. Then it brings the entire server down. Any page that runs a query will return an error similar to this:

Here is what I know.

This is the setup of the wherestring. I see how it could be more efficient, but it isn’t what is killing the server so let stay for now.

<cfif listLen(arguments.statelist,",") GT 1>
    <cfloop list="#arguments.statelist#" delimiters="," index="i">
      <cfset statevar = listgetat(arguments.statelist,i,",")>
      <cfif len(trim(i)) EQ 2>
      <cfif whereString NEQ "">
        <cfset whereString = whereString & " OR ibos.billSTATE = " & " '" & statevar & "'">
        <cfelse>
        <cfset whereString = " ibos.billSTATE = " & " '" &  statevar & "' ">
      </cfif>
      <cfelse>
          <cflocation url="/index.cfm"><!--- don't try and hack me bro, states should only be 2 characters. --->
      </cfif>
    </cfloop>
    <cfelse>
    <cfset statevar = left(trim(arguments.statelist),2)>
    <cfset whereString = " ibos.billSTATE = " & " '" &  statevar & "' ">
  </cfif>

This query used to work:

<cftry>    
<cfquery name="qGetIbosByStates" datasource="#request.dsn#">      
SET QUOTED_IDENTIFIER OFF
            SELECT
               ibos.agreeToTerms 
               ,ibos.billAddress1
               ,ibos.billAddress2
               ,ibos.billCity  
               ,ibos.billCompany 
               ,ibos.billEmail 
               ,ibos.billFName 
               ,ibos.billLName  
               ,ibos.billPhone  
               ,ibos.billState 
               ,ibos.billZip  
               ,ibos.cbwActive 
               ,ibos.email 
               ,ibos.homepage 
               ,ibos.homepageFolder 
               ,ibos.iboStatus 
               ,ibos.latitude  
               ,ibos.longitude  
               ,ibos.MemberID  
               ,ibos.Phone  
               ,ibos.startDate  
               ,ibos.tollfree 
               ,ibos.url  
               ,ibos.ContractType  
           FROM ibos  
           WHERE   #preservesinglequotes(whereString)#<!--- This does not play well with Quoted id and newID()'  --->
             AND (ibos.IBOstatus = 'a'  OR ibos.IBOstatus = 'i')
             AND ibos.ContractType != '30'
             AND ibos.ContractType != '32'
             AND ibos.ContractType != '18' 
             AND ibos.contractType != 'EM'
             AND ibos.contractType != '23'
            <cfif arguments.WebsiteOwners EQ "yes">AND ibos.cbwActive = '1'</cfif>
            <cfif arguments.WebsiteOwners EQ "no">AND ibos.cbwActive != '1'</cfif>
             Order BY newid()
        </cfquery>    
<cfcatch type="any">      
<cfdump var="#cfcatch#" label="Query error line516">      
<cfabort>    
</cfcatch>  
</cftry>

So to find out what the issue is I took out the multi-state option. You now can only choose one state at a time from a drop down menu.

This query does works and returns randomly ordered results.

 <cfquery name="qGetIbosByStates" datasource="#request.dsn#">
        SET QUOTED_IDENTIFIER OFF
            SELECT 
                ibos.agreeToTerms
                ,ibos.billAddress1
                ,ibos.billAddress2
                ,ibos.billCity
                ,ibos.billCompany
                ,ibos.billEmail
                ,ibos.billFName
                ,ibos.billLName
                ,ibos.billPhone
                ,ibos.billState
                ,ibos.billZip
                ,ibos.cbwActive
                ,ibos.email
                ,ibos.homepage
                ,ibos.homepageFolder
                ,ibos.iboStatus
                ,ibos.latitude
                ,ibos.longitude
                ,ibos.MemberID
                ,ibos.Phone
                ,ibos.startDate
                ,ibos.tollfree
                ,ibos.url
                ,ibos.ContractType            
            FROM ibos 
            WHERE  ibos.billSTATE = <cfqueryparam cfsqltype="cf_sql_varchar" value="#statelist#"><!--- this works with Quoted ID off and newid() ---> 
            AND (ibos.IBOstatus = 'a'
            OR ibos.IBOstatus = 'i') 
            AND ibos.ContractType != '30' 
            AND ibos.ContractType != '32' 
            AND ibos.ContractType != '18'
            AND ibos.contractType != 'EM'
            AND ibos.contractType != '23'            
             <cfif arguments.WebsiteOwners EQ "yes">AND ibos.cbwActive = '1'</cfif>
             <cfif arguments.WebsiteOwners EQ "no">AND ibos.cbwActive != '1'</cfif> 
            Order BY newid()
        </cfquery>

So what is the issue? It seems to be with “SET QUOTED_IDENTIFIER OFF” because this query works and returns random results:

 <cfquery name="qGetIbosByStates" datasource="#request.dsn#">
        <!---  SET QUOTED_IDENTIFIER OFF---><!--- commented out --->
            SELECT 
                ibos.agreeToTerms
                ,ibos.billAddress1
                ,ibos.billAddress2
                ,ibos.billCity
                ,ibos.billCompany
                ,ibos.billEmail
                ,ibos.billFName
                ,ibos.billLName
                ,ibos.billPhone
                ,ibos.billState
                ,ibos.billZip
                ,ibos.cbwActive
                ,ibos.email
                ,ibos.homepage
                ,ibos.homepageFolder
                ,ibos.iboStatus
                ,ibos.latitude
                ,ibos.longitude
                ,ibos.MemberID
                ,ibos.Phone
                ,ibos.startDate
                ,ibos.tollfree
                ,ibos.url
                ,ibos.ContractType            
            FROM ibos 
            WHERE  
            #preservesinglequotes(whereString)#<!--- This does not play well with 'Quoted id --->
            AND (ibos.IBOstatus = 'a'
            OR ibos.IBOstatus = 'i') 
            AND ibos.ContractType != '30' 
            AND ibos.ContractType != '32' 
            AND ibos.ContractType != '18'
            AND ibos.contractType != 'EM'
            AND ibos.contractType != '23'            
             <cfif arguments.WebsiteOwners EQ "yes">AND ibos.cbwActive = '1'</cfif>
             <cfif arguments.WebsiteOwners EQ "no">AND ibos.cbwActive != '1'</cfif> 
            Order BY newid()
        </cfquery>

So what does SET QUOTED_IDENTIFIER OFF do anyhow? Doesn’t seem necessary. This is one of those things where someone copies and pastes off the Internet and doesn’t really understand what they are doing.

Ok so after reading this: http://ranjithk.com/2010/01/10/understanding-set-quoted_identifier-onoff/ I just don’t think I need that at all. Someone must have been trying to do something that was solved by the use of preservesinglequotes?

So why does it bring the ColdFusion service down for the entire website? This is the first time I have been able to something like that.

Alabama  Ala. AL Montgomery 36101 32.361538 -86.279118
Alaska  Alaska AK Juneau 99801 58.301935 -134.419740
Arizona  Ariz. AZ Phoenix 85001 33.448457 -112.073844
Arkansas  Ark. AR Little Rock 72201 34.736009 -92.331122
California  Calif. CA Sacramento 94203 38.555605 -121.468926
Colorado  Colo. CO Denver 80201 39.7391667 -104.984167
Connecticut  Conn. CT Hartford 6101 41.767 -72.677
Delaware  Del. DE Dover 19901 39.161921 -75.526755
Florida  Fla. FL Tallahassee 32301 30.4518 -84.27277
Georgia  Ga. GA Atlanta 30301 33.76 -84.39
Hawaii  Hawaii HI Honolulu 96801 21.30895 -157.826182
Idaho  Idaho ID Boise 83701 43.613739 -116.237651
Illinois  Ill. IL Springfield 62701 39.783250 -89.650373
Indiana  Ind. IN Indianapolis 46201 39.790942 -86.147685
Iowa  Iowa IA Des Moines 50301 41.590939 -93.620866
Kansas  Kans. KS Topeka 66601 39.04 -95.69
Kentucky  Ky. KY Frankfort 40601 38.197274 -84.86311
Louisiana  La. LA Baton Rouge 70801 30.45809 -91.140229
Maine  Maine ME Augusta 4330 44.323535 -69.765261
Maryland  Md. MD Annapolis 21401 38.972945 -76.501157
Massachusetts  Mass. MA Boston 2108 42.2352 -71.0275
Michigan  Mich. MI Lansing 48901 42.7335 -84.5467
Minnesota  Minn. MN St. Paul 55101 44.95 -93.094
Mississippi  Miss. MS Jackson 39201 32.320 -90.207
Missouri  Mo. MO Jefferson City 65101 38.572954 -92.189283
Montana  Mont. MT Helena 59601 46.595805 -112.027031
Nebraska  Nebr. NE Lincoln 68501 40.809868 -96.675345
Nevada  Nev. NV Carson City 89701 39.160949 -119.753877
New Hampshire  N.H. NH Concord 3301 43.220093 -71.549127
New Jersey  N.J. NJ Trenton 8601 40.221741 -74.756138
New Mexico  N.M. NM Santa Fe 87501 35.667231 -105.964575
New York  N.Y. NY Albany 12201 42.659829 -73.781339
North Carolina N.C. NC Raleigh 27601 35.771 -78.638
North Dakota  N.D. ND Bismarck 58501 48.813343 -100.779004
Ohio  Ohio OH Columbus 43201 39.962245 -83.000647
Oklahoma  Okla. OK Oklahoma City 73101 35.482309 -97.534994
Oregon  Ore. OR Salem 97301 44.931109 -123.029159
Pennsylvania  Pa. PA Harrisburg 17101 40.269789 -76.875613
Rhode Island  R.I. RI Providence 2901 41.82355 -71.422132
South Carolina S.C. SC Columbia 29201 34.000 -81.035
South Dakota  S.D. SD Pierre 57501 44.367966 -100.336378
Tennessee  Tenn. TN Nashville 37201 36.165 -86.784
Texas  Tex. TX Austin 73301 30.266667 -97.75
Utah  Utah UT Salt Lake City 84101 40.7547 -111.892622
Vermont  Vt. VT Montpelier 5601 44.26639 -72.57194
Virginia  Va. VA Richmond 23218 37.54 -77.46
Washington  Wash. WA Olympia 98501 47.042418 -122.893077
West Virginia  W.Va. WV Charleston 25301 38.349497 -81.633294
Wisconsin  Wis. WI Madison 53701 43.074722 -89.384444
Wyoming  Wyo. WY Cheyenne 82001 41.145548 -104.802042

This is the canoe I pulled out of the dumpster at City cleanup. I wish I had taken a picture prior to this. It must have been used as a duck boat as it was an awful camo brown. It was almost broken in half and had many holes that needed patching.

I spent some time fiber glassing the holes and painted it up. It has been our favorite canoe ever since. It tracks very straight and is very stable. I went up to the BWCA with us this summer of 2009. It may never see those lakes again as it is way too heavy at probably 90lbs. It also doesn’t travel well as it is very wide making it hard to position on most car tops. This last ride it took we noticed that it would flex in the middle making it a challenge to strap down tight enough without feeling like it may crack in half or crush.

This summer I also started building my own Cedar strip canoe. Originally I had hopes of getting it done in time for our BWCA trip however it quickly became apparent that wasn’t going to happen. I purchased these plans and got started in May.

This is the complex and important part of the plans: Make sure you do a good job laying out and cutting your forms. I missed the line a few times and it made it harder as my cedar strips didn’t quite follow the form. I would actually take the page into photo shop and enlarge them and find some way to slicing them up and printing them actual size and taping the sheets together. The way explained in the plans didn’t work for this guy so well, mostly because I didn’t take enough time getting the lines right.

This is the forms bolted to the strongback. None of this stuff becomes any part of the canoe when it is finished. These are the guides that will help form the canoe shape, and are removed after it is all glued in place.

After you have ripped a bunch of cedar strips on a table saw you can start attaching them to the form and each other. I used staples to hold the first ones to the form. In the future I would attempt to use as few staples as possible as they leave holes in the cedar that hopefully will swell shut and hide themselves. I found that I could skip the staples quite a bit and use a combination of tape and clamps.

September now and I better get this finished before it starts getting dark and cold.

There is much sanding to do. The belt sander saved me some serious time. Consistent thickness on your cedar strips will also save some sanding. My little table saw isn’t exactly the professional model and our strips would get thick and thin until we figured out how to get a consistent cut. My boat has cedar with knots in it. I hope this looks ok when it is finished I notice that all the pictures in the book do not have any knots. Well I wasn’t going to toss that much wood out to accomplish that feat with the cedar from the local Menards. I would have been nice to find cedar board with less knots in them.

At this point I have a bunch of work in front of me.

I need to finish sanding the outside and then stain/varnish it before applying a layer of fiberglass, sanding and varnishing again.

Then the forms can be removed so the inside can be sanded, varnished and fiber glassed. After the inside is finished the gun wales, deck and seats. I really hope that I can use it next summer.

Things I think you will want will include a belt sander like this one, and lots of those spring clamps like those holding the dust bag shut. Hopefully you won’t loose your dust bag clip, but you will like the clamps for holding the cedar strips in place.

A band saw helps with the last little pieces that have long angles or curves.

The glue however, check out that stuff. I used several types and brand, this is the stuff. It is exterior gel. Dripping glue is an issue here and the gel sticks to the wood even upside down, and that is very helpful.

When it is done it should look something like this:

More of the building process:

Draping the fiberglass cloth over the outside.

The fiberglass is an epoxy resin and hardener. When you mix them you have a limited time to get it on before it starts to gel up and get hard. It creates noticeable bit of heat as it cures.

Wetting the fiberglass with the resin

Remove from form and clean and sand the inside.

Apply fiber glass to the inside.

Getting fiberglass in the tips of the canoe is a challenge.

Complete the gunwales, then you can do the seat and thwarts.

Complete and ready for the maiden voyage.

We have had great asparagus

I had to put up a fence to keep the bunnies out this year. We had very nice looking Swiss Chard one day and the next it looked like it was all chewed down to the stems. I am sure it will come back if I can keep that rabbit out.

The garden as of June 4th 2012

This year we have:
Tomatos
Egg plant
Green and hot peppers
Peas
Carrots
3 different beans
Broccoli
Rootabegi (sp?)
Two different lettuces
Two different Spinach
Radishes
Corn
Celery
Strawberries
Blue berries
Rhubarb
Chives
Garlic (multiple kinds)
Squash (multiple kinds)
Cantaloupe
Musk melon
Onions
Turnips
Sunflowers

The sail and mast are in great shape. The guy we got it from had it in the back of this truck with the mast in place. As he back towards the dock he forgot about the tree branches overhead. This broke the two fiberglass halves apart. It was originally stapled together. We ground out all the old staples and have glue it together with fiberglass epoxy.

We are now looking for a few free days with nice weather to bondo, sand and paint it up. However it does sail as is. We took it out on the lake and got some looks from people appearing to say “you sure that is going to float?”.

We have a vendor that is on using them anyhow. Maybe I don’t know what I am talking about but couldn’t they just use an underscore or camelCase? So far they have ignored my request. The show must go on.

The XML we get from the soap request:

<?xml version=”1.0″ encoding=”UTF_8″?><PurchaseTokensResponse xmlns=”https://www.vendornamehidden.com/MsServices”><s-gensym3 xmlns:xsi=”http://www.w3.org/2001/XMLSchema_instance” xsi:type=”xsd:string”>SUCCESS</s-gensym3></PurchaseTokensResponse>

My work around in ColdFusion:

<cfif find( “200″, httpResponse.statusCode )>

<!— Parse the XML SOAP response. —>
<cfset soapResponse = xmlParse( httpResponse.fileContent ) />
<cfset msResponseNodes = xmlSearch(
soapResponse,
“//*[ local-name() = 'PurchaseTokensResponse' ]”
) />
<cfset respon = msResponseNodes[1]>

<!— Convert the XML to a string so we can do a replace —>
<cfset xmlString = toString(respon)>
<cfset replaceddashXML = replace(xmlString,”-”,”_”,”ALL”)>
<!— Convert the string back  to XML  —>
<cfxml variable=”backToXML”>
<cfoutput>#replaceddashXML#</cfoutput>
</cfxml>
<!—Now we can carry on as if nothing happened —>
<cfset msResponse = backToXML[1].PurchaseTokensResponse.s_gensym3.xmlText>
Purchase token response:<cfoutput>#msResponse#</cfoutput>
<cfelse>
<cfset msResponse = “fail”>
</cfif>

There is probably an easier way.

Gallery

Make sure you have plenty of table space with good light

My 1982 Yamaha Seca 750 Carbs were completely sludged up. The previous owner didn’t take care of the bike at all and it sat for what I can only guess was many years outside. The gas tank was full of rusty gas. I wish I had thought to take a picture of the gas as I poured it out it was brown rusty with chunks of flaky rust. It was beyond bad and it all flowed into these carbs and packed the jets with rusty paste. It then was allowed to dry and become so varnished up that a person could not twist the throttle. I figured the cable was rusted up from the winter(s) it sat outside. That was not the case the cable was free.

As I took the carbs apart I noticed that someone else had taken them out and managed to strip out the screw heads and loose the little lock washers and other ‘un-needed parts’. The guy I purchased the bike swore it ran only 6 short months ago. It only needed a new starter switch on the handle bar. I am pegging the guy and an absolute liar. I probably should have really thought twice at attempting to clean these carbs.

So here are my tips for this project.

1. Buy and read the Haynes owners workshop manual.

Wear gloves the solvents are not good for your skin. I liked the white ones in the following images. They were tighter fitting and allowed me to pick up little parts easier, however the green ones held up much better. It also helps to lotion your hands, it fills the pores in your skin with lotion rather than oil and solvent. It washes off much easier.

Wear some safety glasses. I hate them but every time I take them off I flick some solvent in my eyes or when using the air compressor to blow something off I get a faceful

These float bowl drain screws are not a bolt you can pick up at Menards

Use a Dremmel tool to cut a new slot. You may want to get these out later.

Use the right size screw driver. It should fit snugly across the entire radius of of the jet.

Use the right size screw driver on the jets. Use a clean screw driver with a good sharp tip. Buy yourself a new one or grind it flat. These brass jets will take some force to remove and easily strip out if you are careless.

some handy items

Don’t use wire to clean out the jets. The brass and aluminum scratch easily.

If you feel you must poke – and I usually do. Use a nylon bristle from a scrub brush. Use an air compressor, it works 99% of the time.

The plastic bristle won't be likely to scratch your brass jet

Here is a picture of the green gloves that hold up much better to the solvents and work.

When you are blowing out the jets with an air compressor watch your eyes. The jets sometimes blow back in unexpected ways.

The manual recommends you take the carbs apart one at a time. I agree. You will use one assembled carb as a guide to where the jets in the disassembled carb will go back. The book is only so good as it is black and white. However you may want to remove the larger rubber/plastic parts so you can dip the whole set of carbs as a unit. I found it impossible to get one carb at a time clean. So I took the big obvious parts apart and kept them separate. Use the float bowl – fill it with carb cleaner and place the parts (the parts you KNOW the location of) in it to soak.  Things like the diaphragm/piston shouldn’t be soaked in the solvent. I once left a tooth brush in the solvent overnight, it kind of partially melted. Once all the vulnerable plastic parts are removed you can get that carb cleaner all over it and avoid the whole dirty carb getting the clean one dirty. It goes much faster if you don’t have to do one at a time.

The book says not to touch the pilot jet. I felt I just had to. The trick is putting it back the way it was. Screw it in as far as it goes while counting the turns. Mine was 3.5 turns before it hit bottom. Unscrew it all the way – clean it out. Then screw it all the way in again and back it off 3.5 turns.

No I am just kidding about that. The engine is blown on it and all the junk yard would pay this kid for it was $200 so I told him I would buy it for that and I could use the parts off of it for our other 98 Contour. But I had no idea it was in such good shape. (No it really doesn’t smell) It has four wheel disk brakes and a sun roof. I am thinking “how hard could it be to take the engine out of the blue car and put in the one from the junk yard? Heh This car with a running engine would be worth about $3000.So I calls up the salvage yard and asks them how much they want for a used motor. Only $500 some bucks. . I have been fixing my cars and trucks for a while now and I have done alternators, starters and even the transmission on my truck. So I go buy this engine. -oh….. now what have I gotten myself into. This thing is REALLY heavy. Look at all this stuff hanging from it. Can I do this? I am going to do it now -I think. Well the dude and the junk yard says his computer says it is an 11 hour job. Honestly it is going to take me that long to find my tools. But I am going to tear into and try. The worst that can happen is I get frustrated and return the new motor and sell the car to the junk yard for $200 and just be out the time I spent.  Time log 7/7/2004 3 hours -Pick up motor from Viking Auto Salvage, Remove hood, Set up my work area and organized my sockets and wrenches. Drained some fluids out of engine.  Disconnected hoses and removed the top engine mount.. oppps I don’t think I should have done that yet. Dumped leaves and rocks out of my toolbox. Lost 2 quarts of blood to savage mosquitoes and contracted some rare form of west nile and lime disease and oil poisoning. I am having fun so far. Feb 12th 2005 -6 hours It was remarkably nice out. The calm before the storm. The neighbor Donny helped me with his hoist to lift the car off of the front end. Unbelievable. Why did I think I could do this? I thought that I would pull the engine out of the car -Not that I would have to pull the car off of the engine. Well. That is the only way to take this thing apart. Fun! One thing that I did notice is that they only way to change the alternator is to do this -pull the car off the body thing. Wonderful! I think I will bring the alternator in to get it checked out as long as I am at it here. Perhaps I might just buy a new one. How ridiculous! I have changed the alternator 4 times on my wonderful Ford ranger. I can just imagine how pissed I would be doing that with this car. “hello Viking auto salvage?”. Yes the engine tipped over spilling oil on the lawn. I bet the procedure is to drain the oil before taking the engine out. It is starting to rain now. Here is a better shot of the whole mess in my back yard. I tarped it over and hung it up for today. I am cold dirty and wet and sick of banging my knuckles for today.  Don’t ya just Love Minnesota! I was wearing a T-shirt yesterday.I might get at this again in the Spring? or next week? June 24th 2005. It has almost been an entire year since I started this project. I have two weeks before I want to take this car to Camp Tomahawk. If I don’t finish it I have to either take the bus or drive that nice brown 78′ F150 that gets about 5mpg. (I will be taking the bus if I fail).  Moving the engine around on the lawn is a big chore. We hoist it up and put it in the truck, we then drive it around to the other side of the car and hoist it back out. The hoist sinks
in the soft dirt and is almost impossible to push into position. Frank come and helps get it into position with Cody and I. My Sons Cody and Matthew were great help as I pretty much didn’t feed them for these two weeks because I was totally focused on getting this car put back together. Here is Cody lifting the engine out. Here is a picture of where that motor needs to go. Notice the Trans-axel in this picture. It is that shaft that is conected to the passenger side wheel. Yeah ahh that needs to get slid on the motor and then into the transmission as it is
all going back together. Well we figured that really wasn’t possible as we are doing this and it turns out to be a bunch more work on the Weds night before we leave. I ended up taking the wheel off and pulling the whole axel out and putting it back on.This is about how far Cody and I got on this day. Frank came over the next day and gave us a hand getting the motor and transmission together. After Frank helps me jocky the motor and transmission into place, Donny gives us a hand with his crane. Donny’s Truck has this wonderful crane that made the hole project possible at all. I can’t thank him enough for his help here. Donny, Tim and Frank were awesome help at this point in the fun. I am not really working as fast as it looks here. It is back together! I feel that if I want to give
up now I can, because it could be towed down to some mechanics garage
in one peice. See that wiring harness there? Yeah ahh that should have been put on BEFORE the engine and car went together. What a bear it was to get back behind the engine. There is a serious lack of room between the engine and the firewall. A few more parts to put on yet here. The “work shop” A storm came up and blew a tree down on top of me and
the project.
Last minute projects Monday Eve. The Trans-axel mounting to the engine Tuesday Wiring harnesses Thursday morning -The steering column hook up Friday The transmission shift linkage
Done at 11:30 pm! We GOT TO PACK for a week of camping. I am good and tired the next day driving to northern Wisconsin. Sat. We drive the car to Tomahawk!
The tailpipe come apart between the engine and the muffler. We come into Scout camp sounding like some kind of stock car racer. It drives all the way home perfectly. What a trip and what a sense of accomplishment. Now I have to get to work on all that stuff I ignored for two weeks