alun

I quite often get this error when looking at the Misc Aviation forum..... Error Executing Database Query. [Macromedia][sqlServer JDBC Driver][sqlServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The error occurred in D:\wwwroot\mooneyspace\forums\cfcs\cf4emPosts.cfc: line 232Called from D:\wwwroot\mooneyspace\forums\dsp\dsp_threads.cfm: line 160 Called from D:\wwwroot\mooneyspace\forums\cf4em.cfm: line 110 Called from D:\wwwroot\mooneyspace\index.cfm: line 91 Called from D:\wwwroot\mooneyspace\forums\cfcs\cf4emPosts.cfc: line 232 Called from D:\wwwroot\mooneyspace\forums\dsp\dsp_threads.cfm: line 160 Called from D:\wwwroot\mooneyspace\forums\cf4em.cfm: line 110 Called from D:\wwwroot\mooneyspace\index.cfm: line 91 230 : FROM cf4em_posts join cf4em_threads on cf4em_posts.threadID = cf4em_threads.threadID 231 : WHERE cf4em_threads.threadID = #arguments.threadID# 232 : and cf4em_posts.dateadded > (SELECT lastviewed FROM cf4em_newPosts WHERE cf4em_newPosts.UserID = #arguments.userID# AND cf4em_newPosts.threadID = #arguments.threadID#) 233 : ORDER BY cf4em_posts.dateadded asc 234 : </cfquery> SQLSTATE 21000 SQL SELECT TOP 1 PostID FROM cf4em_posts join cf4em_threads on cf4em_posts.threadID = cf4em_threads.threadID WHERE cf4em_threads.threadID = 330 and cf4em_posts.dateadded > (SELECT lastviewed FROM cf4em_newPosts WHERE cf4em_newPosts.UserID = 101 AND cf4em_newPosts.threadID = 330) ORDER BY cf4em_posts.dateadded asc VENDORERRORCODE 512 DATASOURCE mooneyspace Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Remote Address 87.244.98.244 Referrer http://www.mooneyspace.com/index.cfm?action=forums Date/Time 17-Sep-09 07:24 AM Stack Trace (click to expand)

jelousy coming from over this side of the pond!!!

well the inner o rings were replaced and so far a big improvement. hopefully that's the cure.

the 8 months is what killed it for me.

this was a reply i had from brittain recently when i was looking at alternates for my non functioninig cIIB. Alun, My apologies for taking so long to get back with you. I have attached a copy of our product brochure for our three axis B5 system and also of some more simple add-ons. The systems require left/right analog output from your navigationa aides and therefore should work nicely with your current set up. They are however on a backlog and we are currently quoting 8 months minimum lead time. Pricing is attached for the add-ons and the B5 system is currently priced at $4898.20. Like the add-ons this quote is for a yellow tagged serviceable system. Take a look at the attachments and let me know how we can be of further assistance. Regards, Cecilia Henderson Manager, BRITTAIN INDUSTRIES, INC

what do you recon the cost difference would be from a replacement IO360 then?

hi, my autopilot problem has been traced to a fault on the AI which is leaking anyway so i am looking for a replacement reconditioned job. i remember someone on here wanting to sell one. i did a search but couldn't find the post so if you are still looking please give me a shout. It needs an autopilot out - i don't know if all of them have that or not.... thanks! al

did you ever get an answer. i was wondering as i have a constant slip shown on my aspen and wandered if it was as a result of panel tilt?

i would be tempted looking at this. more power doesn't mean you have to use it but its there if needed. i don't get how having more power would impact on useful load - surely if anything it would increase it? aren't there other benefits too.. such as dual mags etc over the stock engine on my 78 J?

i had a problem with my altimeter with built in encoder was reading off by a several hundred feet. the solution was a seperate encoder not built into the altimeter that cost me £150 (about $250).

thanks Aaron. I will need to break the vent first and see what happens. If we get nothing then i guess we start pulling panels off!

i heard back from my maintainance guy today. they have only replaced the outer rings so hopefully that will cure it. thanks for all the help guys!

i had the most water ever yesterday when draining the left tank. the whole fuel tester was full with about a cm of fuel on the top. took about 7-8 goes at draining before it was clear. its not like we had a whole lot of rain either. any idea where this could be coming from? the fuel tanks caps were on propertly (as in flat), the plane is just back from annual and the rings were done in Feb before that. I just wonder if there is a way that something could be draining into the wing from somewhere else? thanks guys

I don't think there are any near me but we'll see what happens.

does anyone know the best place for any of the roof vent parts. i am going to pry my painted vent open and have a go at fixing it. thanks! alun

sweeeeeeet!

congratulations!!!

does anyone have one that works. mine looks like it was painted shut. it gets a bit hot with only the storm vent and the twirly air vent by pilots leg even with this typical british summer. a british summer.... i hear that they have been renamed muslim summers. occasionally sunni but mainly she-ite.

Excellent!!! (Only a 10 minute flight for me!)

ditto!

nice job. i have just had mine back from its first annual since purchase and i am now £4,871 (about $7,000!) poorer. feck me. good luck with the sale. i am sure you won't have any trouble with such a well cared for lady.

Hi guys, Thanks for all the replies. I am looking at the FAA route rather than the JAA route as I know that the UK require a Class I for a CPL which means good hearing within both ears. I thought that the FAA Class 1 was the same with a demonstrated max hearing loss at various frequencies in your better and worse ear. Ultimately what I would like to do is offer aerobatic flight experiences in a Pitts S2A but wasn't sure of the route (at least I know the destination!). In the UK these are mainly sold as a flying "lesson" but I guess that as most of the punters would be newbies with no flying license. With no class 1 I wouldn't be allowed to act as PIC so not sure which way to go... First step I think i will be the FAA CPL and go and see what comes out of the medical...... Cheers, al

i have one coupled with a waas 430 and have no issues with mine. i really like the unit, and having just done the IR i am really pleased with it as it does a lot more than i would have known before. i have a century iib autopilot and have been unable to get that working but its an autopilot issue rather than an aspen issue. it takes a little time to get used to but once you are familiar with it you will wander how you flew without it. all your scan info is all in one place. fantastic! i am hoping to get the mfd when it gets certified to go along side and had them wire it for the upgrade when they fitted this one so that it would be a quick job.. not sure when that will be as it only used to say Q2 2009 on the aspen website.

Hi, Having done my IR I am now thinking of doing the CPL (and hopefully at some point the CFI). Problem is that I am completely deaf in my left ear. Right ear is completely fine, but I believe this will preclude me from getting the Class 1 medical or am I wrong on this? Any advice? Thanks, al.

here's mine! "enjoying" a flight in the back seat of my baby.