Re: Possible thread issue?

2009-12-08 Thread Andre Kapp
Ok - changed the pk id field returned to the following: cfset theTransID = trans_insert_res.GENERATED_KEY Still the same issue. Here is the complete cfc module sorry for it being a bit long... cfcomponent displayname=TransDAO cffunction name=init access=public

C:\ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss
So this AM, my production server had not sent me my usual batch of emails (via cfmail). I went to Server Settings Mail, checked Verify mail server connection, clicked Submit Changes, and received Connection Verification Successful. I stopped and restarted my SMTP server and then noticed that

RE: \ColdFusion8\Mail\Spool

2009-12-08 Thread Dave Phillips
John, Anything revealing in your mail log? I've seen this behavior before, but not with CF 8. It was with older versions. We ended up scheduling a nightly restart of the service to alleviate things like this occurring. Dave Phillips -Original Message- From: John M Bliss

Re: \ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss
Nothing since Oct 16. On Tue, Dec 8, 2009 at 7:30 AM, Dave Phillips experiencedcfdevelo...@gmail.com wrote: John, Anything revealing in your mail log? I've seen this behavior before, but not with CF 8. It was with older versions. We ended up scheduling a nightly restart of the service

Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread Cutter (ColdFusion)
See if this might help you: http://blog.cutterscrossing.com/index.cfm/2006/12/10/ColdFusion-Mail-Spool-Lock Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book

Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss
Typically you'll see an error in your ColdFusion mail.log file that will state that the connection to your mail server failed at some point. That didn't happen in this case. On Tue, Dec 8, 2009 at 8:04 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: See if this might help

Check Boxes

2009-12-08 Thread Damo Drumm
Hi can someone help me out here, Im trying to have a check box for each invoice so when its ticked and you press submit all the ticked invoices will be sent to the revelant email address, I'm trying to have it so the check boxes will be defaulted to ticked if the customer Number for the

Re: Check Boxes

2009-12-08 Thread Charlie Griefer
Showing code would be a good first step... On Tue, Dec 8, 2009 at 6:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Hi can someone help me out here, Im trying to have a check box for each invoice so when its ticked and you press submit all the ticked invoices will be sent to the

Re: Check Boxes

2009-12-08 Thread Won Lee
On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Hi can someone help me out here, Im trying to have a check box for each invoice so when its ticked and you press submit all the ticked invoices will be sent to the revelant email address, I'm trying to have it so

Re: Check Boxes

2009-12-08 Thread Damo Drumm
Heres the code im using cfquery name=qgetcustomer datasource=#request.dsn# SELECT invoice.*, customer.CUSTOMER_Name FROM invoice left join customer on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum; /cfquery /select

Re: Check Boxes

2009-12-08 Thread Won Lee
cfquery name=qgetinvoices datasource=#request.dsn# select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name from INVOICE I, COMPANY C, CUSTOMER CU where I.COMPANY_Number = C.COMPANY_Number AND I.COMPANY_Number =

Re: Check Boxes

2009-12-08 Thread Damo Drumm
This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere cfif isdefined(url.invoice) cfquery name=qgetcompanyno datasource=#request.dsn# select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum from INVOICE

Re: Check Boxes

2009-12-08 Thread Won Lee
On Tue, Dec 8, 2009 at 10:35 AM, Damo Drumm damien.dr...@quinn-group.comwrote: This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere cfif isdefined(url.invoice) cfquery name=qgetcompanyno datasource=#request.dsn#

cfselect url bind

2009-12-08 Thread Sean Sekora
I have the following cfselect cfselect name=type bind=url:lookup.cfc?method=getTypeyear={year}make={make}model={model} bindonload=false / Is there a way to prevent the lookup from being executed until all the required values have been set?

Re: cfselect url bind

2009-12-08 Thread Won Lee
On Tue, Dec 8, 2009 at 11:00 AM, Sean Sekora seansek...@gmail.com wrote: I have the following cfselect cfselect name=type bind=url:lookup.cfc?method=getTypeyear={year}make={make}model={model} bindonload=false / Is there a way to prevent the lookup from being executed until all the

CF8 Settings: Large upload failure

2009-12-08 Thread Robert Harrison
We just moved our site from one CF8 server to a new CF8 server. We have an extranet and upload some very large files (up to 1Gb). We keep getting the message below. We already changed set the CFsettings to: Maximum size of post data 1500 MB Request Throttle Threshold 4 MB Request

CFLDAP SSL

2009-12-08 Thread Jake Churchill
I'm working on an SSL integration of CFLDAP for a client and am consistently getting Connection to LDAP server failed. All attributes are correct and for testing I'm attempting a simple query with * for attributes and maxrows of 10. Snippet below. Everything is straight from the IT staff that

Re: Check Boxes

2009-12-08 Thread Damo Drumm
The company table represents the seller, and the Customer table represents the individual Buyers. Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table ~| Want to reach the ColdFusion community with

Re: Check Boxes

2009-12-08 Thread Won Lee
On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm damien.dr...@quinn-group.comwrote: The company table represents the seller, and the Customer table represents the individual Buyers. Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table If that is the case then the query

CF8 Settings: Large upload failure

2009-12-08 Thread Robert Harrison
/or.  It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4670 (20091208) __ The message was checked by ESET Smart Security. http://www.eset.com

Re: CFLDAP SSL

2009-12-08 Thread Dave Watts
All attributes are correct and for testing I'm attempting a simple query with * for attributes and maxrows of 10.  Snippet below.  Everything is straight from the IT staff that controls the LDAP server.  I read this article: http://kb2.adobe.com/cps/191/tn_19139.html#enableCF which stated

cfdocument not working in ie

2009-12-08 Thread Richard White
hi we have a cfdocument and works fine in firefox but when trying to view in internet explorer it only shows characters e.g. �[�ˏ ���C��_�y�l�fS�6(������{�(D�.�X�1�������� we have tried in pdf and flashpaper with the same

Re: ColdFusion.Window.create set bodystyle attribute

2009-12-08 Thread Bruno Nunes
Same for me. No matter what i do the style is always ugly gray. did you find a solution for this? thanks Bruno Hmmm.. The background color is gray by default on my machine for whatever reason. Also, for some reason, the headerstyle attribute works, but the bodystyle attribute does not.

Re: cfselect url bind

2009-12-08 Thread Azadi Saryev
you can specify which event triggers the binding by including @[event-name] in the binding parameter: {y...@change} for example will trigger the binding when the value of year field changes. you can also specify @none to prevent the field triggering the binding, but still use the field's value

Re: cfdocument not working in ie

2009-12-08 Thread Claude Schneegans
thanks for your help You would have better help if you show us your CFDOCUMENT tag. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: cfdocument not working in ie

2009-12-08 Thread Dave Watts
we have a cfdocument and works fine in firefox but when trying to view in internet explorer it only shows characters e.g. � [�ˏ  �� �C��_�y�l�fS�6 (������{� ( D�.�X�1� ������� If you reload the page in IE immediately after this,

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-08 Thread Matthew Small
No, there are different 500 errors returned per application server. CF could handle any processing problems and return an HTTP 500 with its own custom messages if it wanted to, which would still be a normal processed request routed through IIS. An IIS 500 would be returned if the CF engine

SQL Server question re table names

2009-12-08 Thread Larry Soo
A client asked me to see if I could get a copy of his old web site up and running. I did a restore of the backed up database onto my PC. The problem is that all the table names have the name of the database prepended to them. When I view the tables in SQL Server Manager, the table, city, is

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Mike Purrington
Am I really the only one here with this configuration? I'm just wondering if it's been done before or if it's a lost cause. Should I just bite the bullet and upgrade to CF9 - I hesitate because our production environment is running all CF8 - I don't want to do that if there is just a

RE: CF8 Settings: Large upload failure

2009-12-08 Thread Josh Nathanson
be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4670 (20091208) __ The message was checked by ESET Smart Security. http://www.eset.com

RE: SQL Server question re table names

2009-12-08 Thread brad
I can't say I've ever seen that one before, but you could just do a loop over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER statement for each one. http://technet.microsoft.com/en-us/library/ms190273.aspx How many tables are there? If there are under 75, you might be just

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Matthew Small
What does the event viewer say about this error? I'm getting the The service started then stopped error when I try to start my CF 8 ODBC services in Windows 7 32-bit. I've done a lot of searching for this issue, and have found a number of people who have had issues with ODBC on Windows

RE: CF8 Settings: Large upload failure

2009-12-08 Thread Robert Harrison
http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4671 (20091208) __ The message was checked by ESET Smart Security. http://www.eset.com

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Dave Watts
Am I really the only one here with this configuration?  I'm just wondering if it's been done before or if it's a lost cause.  Should I just bite the bullet and upgrade to CF9 - I hesitate because our production environment is running all CF8 - I don't want to do that if there is just a

RE: SQL Server question re table names

2009-12-08 Thread Leigh
I have only seen that with exports from MS Access. Yes, +1 about using the information INFORMATION_SCHEMA views. Tapping into the system views is my favorite way to generate mass statements on-the-fly ;-) DECLARE @DBPrefix VARCHAR(50) SET @DBPrefix = 'oldabc.' SELECT 'exec sp_rename

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Mike Purrington
What does the event viewer say about this error? Here is the error form the event viewer... The description for Event ID 0 from source ColdFusion 8 ODBC Agent cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted.

Re: Possible thread issue?

2009-12-08 Thread Jaime Metcher
Andre, Is this DAO a singleton? I notice the queries aren't var scoped. If this is a singleton under load another thread could easily overwrite your trans_insert variable in between issuing the query and logging the generated key. Jaime On Tue, Dec 8, 2009 at 8:58 PM, Andre Kapp

Reading Microsoft smart quotes with CFFILE

2009-12-08 Thread Mosh Teitelbaum
All: I’m trying to read content from an XML file stored on disk, fiddle with it, and save it to a database. It all works fine except for when the content includes smart-quotes (the XML file is a spreadsheet exported from MS Excel to “XML Spreadsheet 2003” format). When I use CFFILE to read

RE: Reading Microsoft smart quotes with CFFILE

2009-12-08 Thread Robert Harrison
Replace them in a var before trying to do anything with them: #ReplaceList(trim(YOURCONTENT), ’,…,“,” ,'',...,, )# Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022

Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread Bobby
The same thing has happened to use before. I never found any logs indicating the cause and a service restart prompted the spooled emails to start sending again. It was just one of the few reasons we put all of our servers on a weekly reboot schedule. John M Bliss wrote: Typically you'll

Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss
Ug. OK. Thanks. On Tue, Dec 8, 2009 at 4:23 PM, Bobby bo...@acoderslife.com wrote: The same thing has happened to use before. I never found any logs indicating the cause and a service restart prompted the spooled emails to start sending again. It was just one of the few reasons we put

Re: CFWindow z-index with overlib

2009-12-08 Thread John Pullam
Just in case anyone comes looking at this post in the future, I discovered that cfwindows use a z-index in the 9000 range. I had set overlib at 1000 so it wasn't high enough. I changed it to 10,000 and it is now fine. ~| Want

Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread David
On Tue, Dec 8, 2009 at 8:16 AM, John M Bliss bliss.j...@gmail.com wrote: So this AM, my production server had not sent me my usual batch of emails (via cfmail).  I went to Server Settings Mail, checked Verify mail server connection, clicked Submit Changes, and received Connection

Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss
Thanks! On Tue, Dec 8, 2009 at 4:51 PM, David david.lak...@gmail.com wrote: On Tue, Dec 8, 2009 at 8:16 AM, John M Bliss bliss.j...@gmail.com wrote: So this AM, my production server had not sent me my usual batch of emails (via cfmail). I went to Server Settings Mail, checked Verify

Reading Microsoft smart quotes with CFFILE

2009-12-08 Thread Mosh Teitelbaum
All: I’m trying to read content from an XML file stored on disk, fiddle with it, and save it to a database. It all works fine except for when the content includes smart-quotes (the XML file is a spreadsheet exported from MS Excel to “XML Spreadsheet 2003” format). When I use CFFILE to read

cf9 packaging deployment

2009-12-08 Thread Tim Do
I just upgraded to 9 from 8 and I can't see the packaging deployment feature in cfadmin? Where can I find it? thx ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion

Using XML to Create schema/database

2009-12-08 Thread Tom Jones
Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. Thanks, tom

RE: cf9 packaging deployment

2009-12-08 Thread Tim Do
nevermind, I'm on standard... NOTE: This requires either an Enterprise or Developer Edition installation. If you have installed the Standard Edition, you can revert to the Developer Edition by removing the serial number. -Original Message- From: Tim Do [mailto:t...@wng.com] Sent:

Re: CFLDAP SSL

2009-12-08 Thread Tom Jones
Yes, you have to install the cert, and you have to restart the cfm service as well. The other thing I'm not seeing in your cfldap tag is the port. If it's missing it's will default to 389 not the standard 636 for ssl. tom On Dec 8, 2009, at 8:50 AM, Jake Churchill wrote: I'm working on an

ColdFusion Collaboration Chat Starting

2009-12-08 Thread s. isaac dealey
Hey guys, we've stared the collaboration chat at http://experts.na3.acrobat.com/collab/ Hope to see you there! :) -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog

Re: Possible thread issue?

2009-12-08 Thread Andre Kapp
Andre, Is this DAO a singleton? I notice the queries aren't var scoped. If this is a singleton under load another thread could easily overwrite your trans_insert variable in between issuing the query and logging the generated key. Jaime Tks Jaime. I have traced the code back to where this

Re: Possible thread issue?

2009-12-08 Thread Andre Kapp
Andre, Is this DAO a singleton? I notice the queries aren't var scoped. If this is a singleton under load another thread could easily overwrite your trans_insert variable in between issuing the query and logging the generated key. Jaime Tks Jaime. I have traced the code

Re: Possible thread issue?

2009-12-08 Thread Jaime Metcher
Andre, Yeah, looks like singleton, but you'd have to find where the service is instantiated to be sure. Throw it back to the guys who wrote the code anyway! They should be var scoping always. Don't know about the classid. You can of course get the hashcode - see

Re: Possible thread issue?

2009-12-08 Thread Leigh
It pretty much looks like a singleton design! Yep. I think Jaime has it right. It looks like few (if any) of the variables set within the DAO's functions are VAR scoped. So they will automatically be placed in the shared variables scope. Since you are working with a singleton, those

Re: Possible thread issue?

2009-12-08 Thread Leigh
but you'd have to find where the service is instantiated to be sure.  Based on the names, I took a leap of faith that it really is what it appears to be ;-) But Jaime is right. You should verify it. -Leigh ~| Want

Re: Possible thread issue?

2009-12-08 Thread Andre Kapp
It pretty much looks like a singleton design! Yep. I think Jaime has it right. It looks like few (if any) of the variables set within the DAO's functions are VAR scoped. So they will automatically be placed in the shared variables scope. Since you are working with a singleton, those

Re: Possible thread issue?

2009-12-08 Thread Jaime Metcher
I can't comment on whether for your app singleton is right or not. Just be aware that in CF singleton is much more common than in Java, largely due to the much higher object instantiation overhead. Jaime On Wed, Dec 9, 2009 at 3:28 PM, Andre Kapp kap...@gmail.com wrote: Tks Leigh I changed

Re: Using XML to Create schema/database

2009-12-08 Thread s. isaac dealey
Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. I've not done anything for performing the inserts/updates using XML,