Friday, 25 April 2008
|
| Faulting application jrun.exe faulting module jvm.dll .... what???????? Ryan Duckworth 20:45:11 |
| | We are having this problem on a Win 2003 Web Edition box running CF MX
6.1 updater 1 + hot fixes. It will simply post this message to the
Application log and restart itself once every few days. Anyone else
solve this problem or have any insights?
Error Message:
Faulting application jrun.exe, version 4.0.3.10455, faulting module
jvm.dll, version 0.0.0.0, fault address 0x0017353f.
Note: This box has a fresh install of everything by our SysAdmin
including OS and CF.
Log Entry:
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: 8/10/2005
Time: 3:01:41 PM
User: N/A
Computer: WEBSTAGING
Description:
Application Failure jrun.exe 4.0.3.10455 in jvm.dll 0.0.0.0 at 0040:
6f 66 66 73 65 74 20 30 offset 0017353f
Data:
0000: 41 70 70 6c 69 63 61 74
0008: 69 6f 6e 20 46 61 69 6c
0010: 75 72 65 20 20 6a 72 75
0018: 6e 2e 65 78 65 20 34 2e
0020: 30 2e 33 2e 31 30 34 35
0028: 35 20 69 6e 20 6a 76 6d
0030: 2e 64 6c 6c 20 30 2e 30
0038: 2e 30 2e 30 20 61 74 20
0048: 30 31 37 33 35 33 66
Thanks,
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options |  2 answer | Add comment |
Wednesday, 23 April 2008
Friday, 14 March 2008
|
| Bush Dana Tierney 15:21:29 |
| | A New Year's Prayer (Rosh Hashona)
Got this from a friend who got it from a Jewish friend... Bush is my shepherd, I shall be in want. He maketh me to lie down on park benches. He leadeth me beside the still factories. He restoreth my doubts in the Republican Party. He leadeth me in the paths of unemployment for his cronies' sake. Yea, though no weapons of mass destruction have been found, he maketh me continue to fear evil. His tax cuts for the rich and his deficit spending discomfort me. He anointeth me with never-ending debt. Verily my days of savings and assets are kaput. Surely poverty and hard living shall follow me all the days of his administration, And my jobless child shall dwell in my basement forever.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:128768
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 20 answers | Add comment |
Friday, 15 February 2008
|
| NY Times op-ed piece by Neal Stephenson on Star Wars Rob Munn 22:12:58 |
| | The author of Snow Crash, Cryptonomicon, etc. has a great op-ed piece
on Star Wars as a reflection of our culture, and how normal people
depend on the geeks (the Jedi) to sustain their way of life, but just
like with the Jedi, the normal people don't necessarily like us all
that much. here's an excerpt:<br />
<br />
"Concentrate on the moment. Feel, don't think. Trust your instincts,"
says a Jedi to the young Anakin in Episode I, immediately before a pod
race in which Anakin is likely to get killed. It is distinctly odd
counsel coming from a member of the Jedi order, the geekiest people in
the universe: they have beards and ponytails, they dress in army
blankets, they are expert fighter pilots, they build their own laser
swords from scratch.<br />
<br />
And (as is made clear in the "Clone Wars" novels) the masses and the
elites both claim to admire them, but actually fear and loathe them
because they hate being dependent upon their powers.<br />
<br />
http://www.nytimes.com/2005/06/17/opinion/17stephenson.html<br />
<br />
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:161165
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 12 answers | Add comment |
Wednesday, 16 January 2008
|
| OT: Live Chat Russ 10:17:18 |
| | Can anyone recommend some live chat software (preferably something that
integrates with CF). We need something that works sort of like the ESPN
chat, which allows visitors to ask questions and after the moderator
approves it, the question would show up, and then the host can answer the
question.
Any suggestions will be appreciated,
Russ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197309
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 4 answer | Add comment |
Wednesday, 19 December 2007
|
| 500 null James Smith 12:57:23 |
| | Every now and again, often on pages that take a while to execute but not
always I receive a "500 null" in big black letters. The code looks like
this.
<head><title>JRun Servlet Error</title></head><h1>500 null</h1><body>
</body>
Does anyone know what is causing it and how to avoid it as it is becoming a
real problem for us.
--
Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199083
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 9 answers | Add comment |
Thursday, 13 December 2007
|
| Fw: Breaking News - Anti-war protester Cindy Sheehan arrested outside White House Howie Hamlin 18:39:33 |
| | ------------------------------------------------------
MSNBC Breaking News
------------------------------------------------------
Anti-war protester Cindy Sheehan arrested outside White House -
Police arrested Cindy Sheehan during an anti-war protest in front of
White House on Monday.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:175033
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 108 answers | Add comment |
|
| Re: XML / XSLT / XPath Tiziana e Federica Massimo 18:39:24 |
| | Anyone have any book recommendations for XML/XSLT/Xpath ?
That's a pretty huge range of topics 
I have a few small reviews available on my website. See under Book Reviews >
XML
Please feel free to ask more questions about a specific book or topic
----------------------------
Massimo Foti
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
----------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218545
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 4 answer | Add comment |
|
| CF MX Problem techsoldaten-/E1597aS9LQAvxtiuMwx3w @ public . gmane . org techsoldaten-/E1597aS9LQAvxtiuMwx3w @ public . gmane . org 18:39:15 |
| | Having to deal with a complicated problem, wondering if anyone has any advice.
Here's the situation: we have a development server that appears to be broken, it has ActivePDF installed and it will not generate PDF documents using code we know works.
The person responsible for maintaining the server asked that my team test the application locally before he looks into the problem. We downloaded a copy of CF MX from Macromedia.com, installed it, and the whole application broke.
The version of CF installed on the dev server is 6,1,0,63958, which is CF MX 6.1. The version of CF we downloaded from MM's site is 6,0,0,48097, which is plain CF MX. In order to get the application to run, I took a lot of var statements out of CFSCRIPT tags within functions and had to do a couple of other things.
Now the problem is the local install of CF will not generate PDF documents either. We are using code that has previously been tested and is known to work properly (i.e. it was generating PDF documents). There have been no changes to any data the application touches, and (except for the CF version) the dev server and the local server use identical software.
I am wondering if there could be some difference between the way CF MX and CF MX 6.1 function that could be preventing the creating of PDF documents? It will take some doing to get the actual CF server install disk (which appears to be my only way to upgrade to CF MX 6.1) and I would rather avoid the hassle if I do not have to go through it.
Below is a sample of the code that generates the PDF, and thanks in advance for everyone's thoughts:
<snip>
<cfscript>
lookup = CreateComponent("com.lookup.Lookup");
obj = CreateComponent("com.travel.TrkReq");
stCond = StructNew();
stCond.TRKEY = Attributes.ReqID;
qryRow = obj.getData(0,0,stCond);
cr = "#CHR(10)##CHR(13)#";
PDF = CreateObject("COM","APToolkit.Object");
r = PDF.OpenOutputFile("MEMORY");
r = PDF.OpenInputFile(Application.Config.BaseDirectory & "templates/travel_request_form.pdf");
// Lots and lots of business logic
PDF.CloseOutputFile();
bArr = PDF.binaryImage;
</cfscript>
<cfheader name="content-disposition" value="inline; filename=temp.pdf">
<cfsetting enablecfoutputonly="yes" showdebugoutput="no">
<cfcontent type="application/pdf" reset="yes">
<cfoutput>#ToString(bArr)#</cfoutput>
<cfsetting enablecfoutputonly="no">
<cfabort>
</snip>
M
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area.
http://www.houseoffusion.com/banners/view.cfm?bannerid=44
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:177773
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 2 answer | Add comment |
|
| RE: OT-javascript-Solved Eric Creese 18:39:06 |
| | Like I said i am an idiot
-----Original Message-----
From: G [mailto:brian.grant-AeP5+ZH0GCsd1K/UYSjSdw@public.gmane.org]
Sent: Tuesday, December 07, 2004 11:43 AM
To: CF-Talk
Subject: Re: OT-javascript
Eric, just add <script> on the line before the code you posted, and it works
great. do not have firefox -----Original Message----- From: Pascal Peters [mailto  peters-K/7iIdndLkw@public.gmane.org] Sent: Tuesday, December 07, 2004 11:15 AM To: CF-Talk Subject: RE: OT-javascript Debug JS with firefox. You will (probably) get more accurate info on the error
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186496
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | Add comment |
|
| Re: Brochure Designs... Brobborb 18:38:57 |
| | www.zombo.com
----- Original Message -----
From: Bailey, Neal
To: CF-Community
Sent: Monday, May 24, 2004 9:15 AM
Subject: OT: Brochure Designs...
Morning All...
Does anyone know of a good resource to view brochure designs ether to
purchase or for whatever. I just need to view some professional brochure
designs to get a little inspiration.
Thanks...
Neal Bailey
Internet Marketing Manager
E-mail: <mailto:nbailey@ugaais.com> nbailey@ugaais.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:113640
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
|
| Options | 4 answer | Add comment |
|
| CFX Tag development in Visual C++.NET 2003? Gregory Harris 18:38:48 |
| | Hi there, after a lengthy absence from the CF Community it looks like I'm back to developing CF Pages, and hence have my first question to CF-Talk in a few years probably.
I need to develop a CFX tag that will work with ColdFusion 5.0. My C++ development is done in Visual Studio .NET 2003. Is there any way to get the ColdFusion 5 custom tag wizard working in Visual Studio.NET 2003? Anyone out there attempted it? Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:176641
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | Add comment |
|
| RE: Javacript Onclick Question Barney Boisvert 18:38:39 |
| | You'll need to get a reference to the link object, and then you can add a
custom onClick handler to the object. If the A tag has an id attribute,
then it's simple, just use document.getElementById(id_of_anchor) to get the
object. If it doesn't, then you'll have to us document.links (I don't know
how portable that is), or do a parse of the node tree and identify the link
from the mess, probably by checking the href or innerHTML property.
Cheers,
barneyb -----Original Message----- From: Casey C Cook [mailto:ccook22-SmukeSwxQOQ@public.gmane.org] Sent: Friday, May 21, 2004 9:33 AM To: CF-Talk Subject: SOT: Javacript Onclick Question I would like to know if this is possible, I know very little about javascript, but if if someone could point me in the right direction I can do the research. Heres what Im trying to do. I have my main display page which calls a custom header. This custom header has an <a href> link that logs the user off when clicked. What I want to do now is to add a pop-up box that prompts the user to confirm that they are logging off. Heres the kicker, I cant modify the customer header, so how do I write javascript from my main display page to add the pop-up box on the link in the custom header? Casey Cook
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:163982
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
|
| Options | Add comment |
|
| (Admin) Please test Michael Dinowitz 18:38:30 |
| | All HoF resources are now 100% Blackstone. If you can do me a favor and test out various links and sections, I'd appreciate it. I think I've done them all, but there may be something I've missed.
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 7 answers | Add comment |
|
| CFFTP - ListDir not working, but everything else run fine Jennifer Drechsler 18:38:21 |
| | We have a cold fusion 5.0 server processing and loading all of our files via an ftp server into an Oracle database.
We use the following to get all the files in the directory, and then compare the date stamp on the files to previous days to see if the files have changed.
<cfftp action="LISTDIR" directory="PAYROLLPERSONNEL" name="QryDir" connection="PNFTP" stoponerror="Yes">
We can open and close the ftp connection, move files around, and everything runs fine. When we try to list the directory, we get the error:
Unknown exception in CFFtp.
The error occurred while processing an element with a general identifier of (CFFTP), occupying document position (75:3) to (75:142) in the template file c:\inetpub\wwwroot\tebatchprd\testftp.cfm.
We can also run the exact same file on a different Cold fusion 5.0 installation without any problem. There has been not changes on the box for months; there have been no updates or patches installed recently.
Any ideas or suggestions?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203122
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | Add comment |
|
| Dumb CFUN Question C. Hatton Humphrey 18:37:54 |
| | I'm packing for the event and have two dumb questions as this is my
first conference -
1. What's typical dress code / atire for the event?
2. Should I bother brining the laptop to the hotel or would it be
better left elsewhere?
Hatton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:117479
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 2 answer | Add comment |
|
| RE: Windows 2003 Error Dave Watts 18:37:36 |
| | I am getting the following error in Windows 2003 and it shuts down the IIS web services until I manually go restart them. I have searched everywhere I can think of and cannot find a resolution to this. Has anybody seen this error or have any idea how I could fix it? This error has been happening randomly for quite some time now. The box has been restarted several times and nothing appears to effect this error. I have several other Windows 2003 boxes, loaded and configured exactly the same that are not having this issue.
I suggest you post the text of the actual error message.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:179548
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 5 answers | Add comment |
|
| RE: SQL Issue James Smith 18:37:28 |
| | Never mind, found it.
SELECT s.StockID,(s.Qty - sum(IFNULL(o.Qty,0))) AS Quantity
FROM Stock s
LEFT JOIN Orders o ON (s.StockID = o.StockID)
Does the trick.
--
Jay -----Original Message----- From: James Smith [mailto:james-95I7LX3TmnpWk0Htik3J/w@public.gmane.org] Sent: 30 December 2004 12:13 To: CF-Talk Subject: SQL Issue They have to be joined with an outer join, one contains stock, the other pending sales. Clearly not all items will have pending sales so the join must be outer. SELECT s.StockID,(s.Qty - sum(o.Qty)) AS Quantity FROM Stock s LEFT JOIN Orders o ON (s.StockID = o.StockID) The problem I have is that if an item has no orders, then "sum(o.Qty)" returns as NULL, and anoyingly this makes "(s.Qty - sum(o.Qty))" also NULL. What I need is for 20-NULL to be 20 so that the query returns available stock, ie: all stock not allocated to an order. This is "MySQL 4.1.4-gamma-nt" as I am sure that makes a diference. Go on, tell me that MSSQL behaves diferently and that once again MySQL is performing against standards. Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188988
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 1 answer | Add comment |
|
| XML Guest Book Tom Kitta 18:37:19 |
| | Some time ago there was some talk about an XML based guest book, or any guest book for that matter written in coldfusion. Well, after a very long time working on it, I did it, and through the answer to the original post is like 6 months late, here is the link to the download page:
http://www.tomkitta.com/coldfusion/gb/index.cfm
Its open source guest book that uses XML for storage.
TK
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:172160
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | 2 answer | Add comment |
|
| RE: Flash on Pocket PC Dave Watts 18:37:08 |
| | THE SCENARIO: We have a Flash "animation" (well images with an audio track). After viewing a section of this animation, the user taps a button to move onto the next section. Each section is a seperate SWF that gets loaded into the main movie. We have an intermittent issue with one of the sections. This particular section is roughly twice the size of any of the other sections (file size wise...about 5.5 MB). It seems that mabye the file is too large and is either causing the Flash movie to die (doesn't freeze...screen goes black) or is actually killing the Pocket PC (Dell Axim X3). We can recover by rebooting the Pocket PC or pressing one of the device buttons to break the Flash movie out of full screen mode (full screen player provided Ant Mobile - Flash Assist). So does anybody know anything about mpossible memory leaks or issues with loading large SWFs that could cause Flash (or mabye the Ant Mobile player) to crap out?
I don't know about a Flash-specific problem, but loading a single 5.5 MB
Flash file is going to hurt most PPCs, especially if you're loading it from
another file that's already loaded. That's just too big. You might try
fiddling with memory (storing content and applications on external memory,
and devoting more internal memory to use for running applications).
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:176829
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | Add comment |
|
| Using cfcontent tag Chad McCue 18:37:00 |
| | I am trying to use the <cfcontent> tag but want the results to be put in my <td> not to rewrite the screen. Is this possible?
What I am doing is running a jpeg resize tag and it uses the <cfcontent> tag so I can delete the image after it is displayed. The problem is the image gets displayed on the entire page not in its <td>.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:176742
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| Options | Add comment |
|
