RE: Where're PLUM????
Damn; I thought I had the best excuse on record with, the ferret was pregnant. Oh well. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, 3 November 2004 3:19 To: CF-Talk Subject: Re: Where're PLUM AS far as genuine excuses for lateness in a prokect... that is the most valid one I have ever heard! ~| 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:183234 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forcing text to wrap in table cell
On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote: Well if the longest word in the English language is 28 chars... Not by a long shot. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183235 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forcing text to wrap in table cell
and the british have supercalifragilisticexpealidous -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 3 Nov 2004 08:46:43 + On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote: Well if the longest word in the English language is 28 chars... Not by a long shot. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183236 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forcing text to wrap in table cell
What if you live in Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ? - Original Message - From: dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 10:05 AM Subject: Re: Forcing text to wrap in table cell and the british have supercalifragilisticexpealidous -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 3 Nov 2004 08:46:43 + On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote: Well if the longest word in the English language is 28 chars... Not by a long shot. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183237 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forcing text to wrap in table cell
Allan Cliff - CFUG Spain wrote: What if you live in Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ? - Original Message - From: dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 10:05 AM Subject: Re: Forcing text to wrap in table cell and the british have supercalifragilisticexpealidous -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 3 Nov 2004 08:46:43 + On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote: Well if the longest word in the English language is 28 chars... Not by a long shot. http://www.fact-index.com/l/lo/longest_word_in_english.html ~| 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:183238 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfencode problems
On Tuesday 02 Nov 2004 20:38 pm, Stan Winchester wrote: c:\cfusionmx\bin\cfencode f:\websites\[path]\*.cfm f:\websites\[path]\*.cfm /r Path too long, or contains funny chars ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183239 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verity not installed?
This is driving me up the wall now... I have installed the hotfix for 6.1 and Verity/Linux: http://www.macromedia.com/support/coldfusion/ts/documents/hotfix_verity_linux.htm This made no difference. I then installed the 6.1 updater and this has made no difference. Any other ideas? Andrew. On Tue, 2 Nov 2004 10:34:47 -0700, Figy, Kam [EMAIL PROTECTED] wrote: http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:855/forumid: 14 This was related to RedHat 7.2, but the same dependency issues might relate in Fedora. HTH Kam -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 3:19 AM To: CF-Talk Subject: Verity not installed? Hi Everyone. I have just installed a new system with CFMX6.1 on a Linux (done it lots of time before) and it all installed ok. I then started to do some configuration for my application in CF Admin and when I got to the bit to set up Verity collections I clicked the 'Verity Collections' click on the right and in the window on the left, instead of showing me the collections interface it says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I have never had this before and I have looked the the Installing and Using ColdFusion MX document on the MM website and I can't see any mention of this. Anyone have any ideas what is going on and how I can fix the problem? Best Regards Andrew. ~| 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:183240 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
MS SQL problem
Hi all, I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the data of the softwares used in the companies like; COMPANY TABLE COMPANY_ID COMPANY_NAME -- 10 My Company COMPANY SOFTWARES TABLE COMPANY_ID SOFTWARE_ID -- -- 10 1 10 2 10 3 SOFWARES TABLE SOFTWARE_ID SOFTWARE_NAME --- - 1 X 2 Y 3 Z I need a result like; COMPANY_ID COMAPNY_NAME SOFTWARES -- - 10 My Company X, Y, Z I've used a query like; SELECT COMPANY_ID, COMPANY_NAME, ( SELECT SOFTWARE_NAME FROM COMPANY_SOFTWARES COS, SOFTWARES S WHERE S.SOFTWARE_ID=CS.SOFTWARE_ID AND COS.COMPANY_ID = C.COMPANY_ID ) AS SOFWARE_NAMES FROM COMPANY C WHERE AND C.COMPANY_ID = 10 But I get an error message; Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , = , , = or when the subquery is used as an expression. I've read that in MySQL there is CONCAT function for the result I want but I couldn't find any solution in MSSQL server, any solutions, suggestions? Thanks in advance. ~| 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:183241 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: inetinfo.exe Memory Leak After 6.1 Updater
Please please let me know the solution!!! This is bringing my server to it's knees constantly, the JRun locks a processor (Dual Xeons, so 1 of the 4 virtual chips and runs 25% of my system process) and the VMem goes out of control. Really need to know what to do! (can you hear the panic in my voice!) cassady at lopedia dot com Still happening. I called Macromedia (we just got their bronze support), so I'll let you all know if they can resolve this. I just uninstalled the connectors and reinstalled them (and left jrunsvc.exe alone). I'll let you know what happens tomorrow... - Sung Is re-running the connectors necessary or can I just replace the jrunsvc. exe? ~| 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:183242 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS SQL problem
I don't think it is possible (but I don't use M$SQL that often, so I may be mistaken). If it is for CF, use grouped output: cfquery datasource=#request.dsn# name=qCompanySoftware SELECT C.COMPANY_ID, C.COMPANY_NAME, S.SOFTWARE_NAME FROM COMPANY C COMPANY_SOFTWARES COS, SOFTWARES S WHERE S.SOFTWARE_ID = CS.SOFTWARE_ID AND COS.COMPANY_ID = C.COMPANY_ID AND C.COMPANY_ID = 10 ORDER BY C.COMPANY_NAME /cfquery cfoutput query=qCompanySoftware group=COMPANY_NAME ID: #qCompanySoftware.COMPANY_ID#br Name: #qCompanySoftware.COMPANY_NAME#br Softwares: cfoutput #qCompanySoftware.SOFTWARE_NAME#, /cfoutput brbr /cfoutput If you are filtering on a unique ID, you can also do: cfoutput ID: #qCompanySoftware.COMPANY_ID#br Name: #qCompanySoftware.COMPANY_NAME#br Softwares: #ValueList(qCompanySoftware.SOFTWARE_NAME)# /cfoutput Pascal -Original Message- From: Nurettin Omer Hamzaoglu [mailto:[EMAIL PROTECTED] Sent: 03 November 2004 11:29 To: CF-Talk Subject: MS SQL problem Hi all, I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the data of the softwares used in the companies like; I need a result like; COMPANY_ID COMAPNY_NAME SOFTWARES -- - 10 My Company X, Y, Z ~| 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:183243 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Can someone Explain this Error Message
I am getting an error message which states: Branch target offset too large for short The first line of the stack trace reads org.apache.bcel.generic.ClassGenException: Brnach target offset too large for short The error message will appear when I include the following line and if I comment out this line I will not get the above error message. cffile action=Append file=C:\#Variables.Filename# output=\cell\pard\plain \intb1\1trpar\s1\qc{\*hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rt1ch\af5\afs20\lang1025\ltrch\dbch\af3\afs20\langfe255\loch\f5\fs20\lang1033 addnewline=yes I have also copied this line above from another section which is identical as I am creating an RTF File which contains a School Report Card which is apart of my Coldfusion Based Student Information System. Anyone have any ideas? -- [] ~| 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:183244 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS SQL problem
The following will do what you need, although it is a little long-winded. -- Prepare blank list declare @list varchar(4000) set @list = '' -- Get SOFTWARE list for COMPANY select @list = @list + ',' + SOFTWARE.SOFTWARE_NAME fromSOFTWARE inner join COMPANY_SOFTWARES ON COMPANY_SOFTWARES.SOFTWARE_ID = SOFTWARE.SOFTWARE_ID where COMPANY_SOFTWARES.COMPANY_ID = 10 -- Removes Extraneous , at beginning select @list = substring( @list , 2, len( @list ) ) -- Final Returned Query select COMPANY.COMPANY_ID, COMPANY.COMPANY_name, @list as SOFTWARES fromCOMPANY where COMPANY_ID = 10 The other option is do it through ColdFusion as suggested, which may be a tidier way. Gavin -Original Message- From: Nurettin Omer Hamzaoglu [mailto:[EMAIL PROTECTED] Sent: 03 November 2004 10:29 To: CF-Talk Subject: MS SQL problem Hi all, I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the data of the softwares used in the companies like; ~| 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:183245 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Odd SQL Behaviour, errors generated by values I am not trying to use!
I am looping over a result set to insert the results into a new table. Select Query cfquery name=Select2 datasource=Intranet SELECT Barcode, ItemID, Title FROM stockitemdetails ORDER BY Barcode /cfquery Insert Query cfloop query=Select2 cfoutput#Select2.ItemID# - #Select2.Barcode# - #Select2.Title#/cfoutputbr cfquery name=Insert1 datasource=Intranet INSERT INTO barcodes (Barcode, ItemID) VALUES (#Select2.Barcode#,#Select2.ItemID#) /cfquery /cfloop It should also be noted that the barcodes table includes an ID column which is an Auto Increment primary key, and the barcode column is INT(13) zerofill indexed as unique. When this template is executed the first 4 values are inserted correctly, however the 5th inserts the barcode wrong (as 0004294967295 where the output is 0008811171629) and the 6th then errors by trying to insert this same wrong value again even though the output is unique (0008811953928). The error generated is... Invalid argument value: Duplicate entry '0004294967295' for key 2 However the error box lists the SQL statement in question as... INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? NOTE: If I remove the requirement for the barcode column to be unique then almost all of the barcodes are inserted as this same wrong number, and by almost all I mean only 20 or so work correctly out of about 10,000 total rows. -- James Smith [EMAIL PROTECTED] ~| 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:183246 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can someone Explain this Error Message
On Wednesday 03 Nov 2004 12:04 pm, Graham Pearson wrote: Branch target offset too large for short Is the file very large ? Can you test it with a less evil path ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183247 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Odd SQL Behaviour, errors generated by values I am not trying to use!
James Smith wrote: However the error box lists the SQL statement in question as... INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? Because it is 2^32. Instead of throwing an error MySQL just rounds your value to the maximum that fits in the field. Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183248 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Odd SQL Behaviour, errors generated by values I am not trying to use!
I'm not seeing why it happens, but you could simplify your code: cfquery datasource=Intranet INSERT INTO barcodes (Barcode, ItemID) SELECT Barcode, ItemID FROM stockitemdetails /cfquery Pascal -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 03 November 2004 14:01 To: CF-Talk Subject: Odd SQL Behaviour, errors generated by values I am not trying to use! I am looping over a result set to insert the results into a new table. Select Query cfquery name=Select2 datasource=Intranet SELECT Barcode, ItemID, Title FROM stockitemdetails ORDER BY Barcode /cfquery Insert Query cfloop query=Select2 cfoutput#Select2.ItemID# - #Select2.Barcode# - #Select2.Title#/cfoutputbr cfquery name=Insert1 datasource=Intranet INSERT INTO barcodes (Barcode, ItemID) VALUES (#Select2.Barcode#,#Select2.ItemID#) /cfquery /cfloop It should also be noted that the barcodes table includes an ID column which is an Auto Increment primary key, and the barcode column is INT(13) zerofill indexed as unique. When this template is executed the first 4 values are inserted correctly, however the 5th inserts the barcode wrong (as 0004294967295 where the output is 0008811171629) and the 6th then errors by trying to insert this same wrong value again even though the output is unique (0008811953928). The error generated is... Invalid argument value: Duplicate entry '0004294967295' for key 2 However the error box lists the SQL statement in question as... INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? NOTE: If I remove the requirement for the barcode column to be unique then almost all of the barcodes are inserted as this same wrong number, and by almost all I mean only 20 or so work correctly out of about 10,000 total rows. -- James Smith [EMAIL PROTECTED] ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183249 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Odd SQL Behaviour, errors generated by values I am not trying to use!
INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? Because it is 2^32. Instead of throwing an error MySQL just rounds your value to the maximum that fits in the field. But the field is INT(13), why would a 13 digit number not fit? -- Jay ~| 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:183250 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Odd SQL Behaviour, errors generated by values I am not trying to use!
I'm not seeing why it happens, but you could simplify your code: cfquery datasource=Intranet INSERT INTO barcodes (Barcode, ItemID) SELECT Barcode, ItemID FROM stockitemdetails /cfquery Thanks, I was doing that originally but modified it so I could output some values to screen for debug reasons. -- Jay ~| 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:183251 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can someone Explain this Error Message
On Wednesday 03 Nov 2004 12:23 pm, Thomas Chiverton wrote: less evil path ? or, indeed, string ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183252 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Bluedragon Server
Hello, I posted the following to the Bluedragon mailing list over at New Atlanta, but would also love to have the insight of the members of this site. *We are a small outfit that runs a PHP-based content site. I would really like to move to cfml, as my job description includes webmaster, web developer, content co-editor and promotions guy... cfml's ease of use could really save me some time and allow me to do more advanced things than PHP would, as with PHP these things would presumably take more time to learn - time I don't have. On Ben Forta's blog, Vince Bonfanti of New Atlanta made the following claim: * *///The free BlueDragon Server edition is being offered directly as an alternative to PHP to keep people using CFML instead./ Will Bluedragon Server really offer me everything PHP does? I have also read horror stories about how cfml is nice, but that the servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? *Thank you, Ryan Jones ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183253 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session Management
That is correct with our current implementation. In our computer labs, we strongly instruct that students log completely out of the computer, in effect closing the browser. In administrative or faculty offices, users lock their computers when they walk away and, being a small university, we have the luxury of knowing when a stranger is around. Without going into large security discussions, it's been this way for over two years and there has never been an issue with it. In fact, I always leave my computer unlocked, but I have an office with a lockable door. However, I have been considering adding a timeout so that users must log back in when their sessions expire. It would sure make my coding much easier. BTW, all the boozers our in our IT dept. ;-) _ From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tue 11/2/2004 9:30 PM To: CF-Talk Subject: Re: Session Management Michael, does this mean if a logged-in user goes off to lunch without logging out, their machine is still logged in (in effect) all day (if it's a long lunch with the sales department booze-heads) or even all night too? Isn't that a security risk? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year On Tue, 2 Nov 2004 20:35:13 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: I just store login information in a cookie. Then, if the session has timed out, I reload the session using the login information that is stored in the cookie. The user never knows they lost their session due to inactivity. ~| 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:183254 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Odd SQL Behaviour, errors generated by values I am not trying to use!
James Smith wrote: INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? Because it is 2^32. Instead of throwing an error MySQL just rounds your value to the maximum that fits in the field. But the field is INT(13), why would a 13 digit number not fit? Because display padding has got nothing to do with physical storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html Jochem ~| 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:183255 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Hello there, You could check here for some comparison info... http://www.newatlanta.com/products/bluedragon/product_info/cfml_tag_support.cfm http://www.newatlanta.com/products/bluedragon/product_info/features.cfm#FCMatrix I believe that the free version does have certain license restrictions... I'm sure there are some BD people on the list who may answer any questions. Hope that helps a bit.. Yves On Wed, 03 Nov 2004 15:30:11 +0200, Ryan Jones [EMAIL PROTECTED] wrote: Hello, I posted the following to the Bluedragon mailing list over at New Atlanta, but would also love to have the insight of the members of this site. *We are a small outfit that runs a PHP-based content site. I would really like to move to cfml, as my job description includes webmaster, web developer, content co-editor and promotions guy... cfml's ease of use could really save me some time and allow me to do more advanced things than PHP would, as with PHP these things would presumably take more time to learn - time I don't have. On Ben Forta's blog, Vince Bonfanti of New Atlanta made the following claim: * *///The free BlueDragon Server edition is being offered directly as an alternative to PHP to keep people using CFML instead./ Will Bluedragon Server really offer me everything PHP does? I have also read horror stories about how cfml is nice, but that the servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? *Thank you, Ryan Jones ~| 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:183256 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote: Will Bluedragon Server really offer me everything PHP does? Yes. And more. Did you have something specific in mind ? servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? I expect a full J2EE app like CF will use more resources than PHP embeded in Apache's httpd. But if you are that close to your hardware limits, you have other problems :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183257 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Well Tom, at this point I guess my primary concern is this: Say along the way I decide to do something with our site that is not directly handled by one of the currently available cfml tags... With PHP I am basicly open and free to code and make the language do just about anything I want it to. With cfml, I could find myself at a place where I need to call on java. However, if I understand correctly, the free version of Bluedragon does not support calls to java nor the parsing of jsp code. I may be wrong...? On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote: Will Bluedragon Server really offer me everything PHP does? Yes. And more. Did you have something specific in mind ? servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? I expect a full J2EE app like CF will use more resources than PHP embeded in Apache's httpd. But if you are that close to your hardware limits, you have other problems :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183258 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Well Tom, at this point I guess my primary concern is this: Say along the way I decide to do something with our site that is not directly handled by one of the currently available cfml tags... With PHP I am basicly open and free to code and make the language do just about anything I want it to. With cfml, I could find myself at a place where I need to call on java. However, if I understand correctly, the free version of Bluedragon does not support calls to java nor the parsing of jsp code. I may be wrong...? On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote: Will Bluedragon Server really offer me everything PHP does? Yes. And more. Did you have something specific in mind ? servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? I expect a full J2EE app like CF will use more resources than PHP embeded in Apache's httpd. But if you are that close to your hardware limits, you have other problems :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183259 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Actually, I have another concern: mass mailing. We run a newsletter with over 3,000 subscribers. With PHP I sent out to this list on a daily basis using phpmailer class sending via smtp. Works great. I am afraid of using the cfmail tag for such mailings based on the fact that php's mail() function should NEVER be used to send out bulk mail. I may be way off base here though... maybe the cfmail tag is capable of handling thousands of addresses. But even if it is, Bluedragon itself is a concern for me here. I say this because on the Macromedia site, their feature matrix for CF notes that while CF Enterprise has High-Performance Email Delivery, the Standard Server version does not. I am assuming that the Bluedragon Server is comparable to Coldfusion MX Standard, meaning that I am also assuming it does NOT feature High-Performance Email Delivery. Am I wrong here too? On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote: Will Bluedragon Server really offer me everything PHP does? Yes. And more. Did you have something specific in mind ? servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? I expect a full J2EE app like CF will use more resources than PHP embeded in Apache's httpd. But if you are that close to your hardware limits, you have other problems :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183260 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
When to use cachedwithin
I have a web site that uses CFMX 6.1 and MS SQL for data handling. This question is probably because I don't know as much about MS SQL as I should, so bear with me. Is it efficient to use cachedwithin on a query that only returns a row or two in the recordset? Keep in mind that this query is accessed quite a bit. A colleague says that the OS/RDBMS probably caches the small recordset anyway, so I should only use cachedwithin on queries that use complex joins, return large datasets, use unions, etc. Thanks for your help! Chris ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183261 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
On Wednesday 03 Nov 2004 13:49 pm, Ryan Jones wrote: may be way off base here though... maybe the cfmail tag is capable of handling thousands of addresses. Certainly is, failing that there is the CFML that powers this very list :-) Standard, meaning that I am also assuming it does NOT feature High-Performance Email Delivery. I wouldn't call 3000/day high. With cfml, I could find myself at a place where I need to call on java. Only in the same way that if PHP doesn't do it, you need to call on C. Drop the BD sales people a line, they are very responsive and helpful. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183262 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Odd SQL Behaviour, errors generated by values I am not trying to use!
INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? Because it is 2^32. Instead of throwing an error MySQL just rounds your value to the maximum that fits in the field. But the field is INT(13), why would a 13 digit number not fit? Because display padding has got nothing to do with physical storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html Bigint fixed it, thanks. Any idea why the DB allows an INT(13)? -- Jay ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183263 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Some of you might find this a little weird But I once looped a cfmail to test BlueDragon' 3.x version and my mail server I can't remember how many emails I was (and had) set to receive, but I had no problem what so ever And the loop was several 10s of thousand... probably about 50 000 emails.. This was done on a Linux platform. PS, this server was in production at the time of the test... Yves On Wed, 3 Nov 2004 14:59:51 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 03 Nov 2004 13:49 pm, Ryan Jones wrote: may be way off base here though... maybe the cfmail tag is capable of handling thousands of addresses. Certainly is, failing that there is the CFML that powers this very list :-) Standard, meaning that I am also assuming it does NOT feature High-Performance Email Delivery. I wouldn't call 3000/day high. With cfml, I could find myself at a place where I need to call on java. Only in the same way that if PHP doesn't do it, you need to call on C. Drop the BD sales people a line, they are very responsive and helpful. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183264 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Ryan, My suggestion is to use a blend of tools. CFML, IMO, will provide you with faster application turnaround but that doesn't mean that you should abandon tools that aren't built in it. Use what's best for the specific task at hand and don't rewrite something for the sake of doing it. If you have PHP code that already handles your mailings, just continue to use it. Rey... - Original Message - From: Ryan Jones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 8:49 AM Subject: Re: Bluedragon Server Actually, I have another concern: mass mailing. We run a newsletter with over 3,000 subscribers. With PHP I sent out to this list on a daily basis using phpmailer class sending via smtp. Works great. I am afraid of using the cfmail tag for such mailings based on the fact that php's mail() function should NEVER be used to send out bulk mail. I may be way off base here though... maybe the cfmail tag is capable of handling thousands of addresses. But even if it is, Bluedragon itself is a concern for me here. I say this because on the Macromedia site, their feature matrix for CF notes that while CF Enterprise has High-Performance Email Delivery, the Standard Server version does not. I am assuming that the Bluedragon Server is comparable to Coldfusion MX Standard, meaning that I am also assuming it does NOT feature High-Performance Email Delivery. Am I wrong here too? On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote: Will Bluedragon Server really offer me everything PHP does? Yes. And more. Did you have something specific in mind ? servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? I expect a full J2EE app like CF will use more resources than PHP embeded in Apache's httpd. But if you are that close to your hardware limits, you have other problems :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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:183265 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: inetinfo.exe Memory Leak After 6.1 Updater
On Wed, 3 Nov 2004 03:58:17 -0700, Stephen Cassady [EMAIL PROTECTED] wrote: Please please let me know the solution!!! This is bringing my server to it's knees constantly, the JRun locks a processor (Dual Xeons, so 1 of the 4 virtual chips and runs 25% of my system process) and the VMem goes out of control. Really need to know what to do! Perhaps either of these TechNotes might help you along? Sorry, I don't work with Windows, so I have no personal experience: http://www.macromedia.com/support/coldfusion/ts/documents/iis6_slow_perf.htm http://www.macromedia.com/support/coldfusion/ts/documents/siteminder_filter_hang.htm Regards, Dave. ~| 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:183266 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bluedragon Server
Ryan, In my past life, working for an ISP that was a CF house, we had several high subscriber e-newsletter clients. One technique that we employed, which greatly reduced server load and errors, was to send out these newsletters in batches of 500. Fairly easy to script, did not drag out system resources, easy to troubleshoot in an error situation, and definitely doable on BD. Cutter Ryan Jones wrote: Actually, I have another concern: mass mailing. We run a newsletter with over 3,000 subscribers. With PHP I sent out to this list on a daily basis using phpmailer class sending via smtp. Works great. I am afraid of using the cfmail tag for such mailings based on the fact that php's mail() function should NEVER be used to send out bulk mail. I may be way off base here though... maybe the cfmail tag is capable of handling thousands of addresses. But even if it is, Bluedragon itself is a concern for me here. I say this because on the Macromedia site, their feature matrix for CF notes that while CF Enterprise has High-Performance Email Delivery, the Standard Server version does not. I am assuming that the Bluedragon Server is comparable to Coldfusion MX Standard, meaning that I am also assuming it does NOT feature High-Performance Email Delivery. Am I wrong here too? On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote: Will Bluedragon Server really offer me everything PHP does? Yes. And more. Did you have something specific in mind ? servers take up huge amounts of memory, and tend to crash often once the traffic starts increasing. Are these stories true, or rumors? I expect a full J2EE app like CF will use more resources than PHP embeded in Apache's httpd. But if you are that close to your hardware limits, you have other problems :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183267 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Problem with Access driver and Windows 2003 Server
All, The server I'm on just recently was upgraded to Windows2003. While everything else seems to be running fine, the one thing that didn't make the transition very well as that the Access and Access w/ Unicode drivers don't seem to be working. I can't get any datasource using those drivers to verify. And when you hit the sites that they are running, I get the following error: Error Executing Database Query. coldfusion.sql.DatabaseConnectionException: Timed out trying to establish connection I know, Access is not great but it should at least be working. And there has been no code change, no DB change, nothing. We have the latest MX version on the server, the latest Access Jet drivers. Anyone heard of this? If so, how do I fix?? Help!! Thanks! Jake ~| 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:183268 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
jrun.security.NTAuth question
Hello, If you log someone in using jrun.security.NTAuth, how do you log them out? Sincerely, Andrew ~| 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:183269 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When to use cachedwithin
Whether or not the RDBMS caches it CF will still have to go to the dB server and get it. If you use cachedwithin (or cachedafter) then it stays in CF's memory, and no trips to the dB are required, so i'd say cache it. And don't forget you could put it in a persistent scope (either application or server in this case) by using cfquery name=application.myquery etc..., and only running the query when you start up the application. There are pluses and minuses for bother cachedwithin/after and persistent scope caching - it depends on the individual case... Bert On Wed, 03 Nov 2004 10:01:21 -0400, Chris Peters [EMAIL PROTECTED] wrote: I have a web site that uses CFMX 6.1 and MS SQL for data handling. This question is probably because I don't know as much about MS SQL as I should, so bear with me. Is it efficient to use cachedwithin on a query that only returns a row or two in the recordset? Keep in mind that this query is accessed quite a bit. A colleague says that the OS/RDBMS probably caches the small recordset anyway, so I should only use cachedwithin on queries that use complex joins, return large datasets, use unions, etc. Thanks for your help! Chris ~| 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:183270 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session Management
hello there, at our college, we made it a policy to have the sessions for our portal appllcation expire after 3 minutes of inactivity. This is to address security and privacy issues. Portal built using PHP and implemented Novell's iChain for single signon ability across any applications that involves authenticating the user. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183271 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars stored in database?
What Barney said is dead-on. I am a total zero on clusters, but isn't there a way -- outside of CF -- to handle sessions so they remain sticky despite the application? i.e. an external application of some sort. Would that be db-related? Systems guys at that level usually aren't so ignorant so I'm wondering if he is taking something non-CF into account. And even there was such a thing in play, I can't see how proper locking practices would be mitigated in any meaningful way. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.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:4:183272 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Access driver and Windows 2003 Server
On Wednesday 03 Nov 2004 16:02 pm, Jake wrote: And when you hit the sites that they are running, I get the following error: Error Executing Database Query. coldfusion.sql.DatabaseConnectionException: Timed out trying to establish connection Does it verify in the administrator ? Are the relavent ports open in the FireWall ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183273 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query Help Needed
Okay, I see what you mean but I'm not sure how to define since they are passed from selects instead of a db field? Thank you for your help, ~ Donna On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Donna French wrote: Should this code work if I only pass the StartDate, EndDate and Param1Val? No. cfparam name=Param2Val default=null cfparam name=Param3Val default=null cfinclude template=Connections/wdv.cfm cfquery name=rsReport datasource=#MM_wdv_DSN# username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD# SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Form.StartDate# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Form.EndDate# cfsqltype=cf_sql_date AND #Form.Param1# = cfqueryparam value=#Form.Param1Val# null=no This will throw an error because form.param1 is undefined. AND #Form.Param2# = cfqueryparam value=#Form.Param2Val# null=yes Here both form.param2 and form.param2val are undefined. Remember that your cfparam is for param2val, not form.param2val. (CF might skip past the param2val issue though since it is essentially a constant and the compiler might recognize it as such.) AND #Form.Param3# = cfqueryparam value=#Form.Param3Val# null=yes; Same issue. /cfquery Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183274 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: How do I print out a directory listing in XP
I need to print out a directory listing for a disk I am sending to a printer. Can someone tell me how to do this? Thanks, Andy ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183275 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How to use Request scope?!
can you set a request scope variable in an include? ex. -index.cfm --include1.cfm -- set request.test --include2.cfm -- read request.test can this be done? -- -- Ian Sheridan http://www.savagevines.com -- ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183276 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: How do I print out a directory listing in XP
http://www.rohanclan.com/library/printdirlist.cfm On Wed, 3 Nov 2004 11:18:56 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: I need to print out a directory listing for a disk I am sending to a printer. Can someone tell me how to do this? Thanks, Andy ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183277 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query Help Needed (Solved)
Got it working with this code: SELECT COUNT(*) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Trim(Form.StartDate)# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Trim(Form.EndDate)# cfsqltype=cf_sql_date AND #Trim(Form.Param1Select)# = cfqueryparam value=#Trim(Form.Param1Val)# cfif Form.Param2Select NEQ AND #Trim(Form.Param2Select)# = cfqueryparam value=#Trim(Form.Param2Val)# /cfif cfif Form.Param3Select NEQ AND #Trim(Form.Param3Select)# = cfqueryparam value=#Trim(Form.Param3Val)# /cfif ; On Wed, 3 Nov 2004 11:25:16 -0600, Donna French [EMAIL PROTECTED] wrote: Okay, I see what you mean but I'm not sure how to define since they are passed from selects instead of a db field? Thank you for your help, ~ Donna On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Donna French wrote: Should this code work if I only pass the StartDate, EndDate and Param1Val? No. cfparam name=Param2Val default=null cfparam name=Param3Val default=null cfinclude template=Connections/wdv.cfm cfquery name=rsReport datasource=#MM_wdv_DSN# username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD# SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Form.StartDate# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Form.EndDate# cfsqltype=cf_sql_date AND #Form.Param1# = cfqueryparam value=#Form.Param1Val# null=no This will throw an error because form.param1 is undefined. AND #Form.Param2# = cfqueryparam value=#Form.Param2Val# null=yes Here both form.param2 and form.param2val are undefined. Remember that your cfparam is for param2val, not form.param2val. (CF might skip past the param2val issue though since it is essentially a constant and the compiler might recognize it as such.) AND #Form.Param3# = cfqueryparam value=#Form.Param3Val# null=yes; Same issue. /cfquery Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183278 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How to use Request scope?!
Sure, as long as you set it before you call it of course -Original Message- From: Ian Sheridan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 12:38 PM To: CF-Talk Subject: How to use Request scope?! can you set a request scope variable in an include? ex. -index.cfm --include1.cfm -- set request.test --include2.cfm -- read request.test can this be done? -- -- Ian Sheridan http://www.savagevines.com ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183279 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How do I print out a directory listing in XP
You can redirect the listing to a text file C:\DIR C:\MYDIRECTORY listing.txt then print the text file -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 12:19 PM To: CF-Talk Subject: OT: How do I print out a directory listing in XP I need to print out a directory listing for a disk I am sending to a printer. Can someone tell me how to do this? Thanks, Andy ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183280 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How do I print out a directory listing in XP
dir /og dirlist.txt -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 12:19 PM To: CF-Talk Subject: OT: How do I print out a directory listing in XP I need to print out a directory listing for a disk I am sending to a printer. Can someone tell me how to do this? Thanks, Andy ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183281 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars stored in database?
He could be talking about a custom session management scheme. I have used rsession (http://vfive.com/rsession/index.html)in previous (CF5) projects in order to avoid having to lock session vars and to support non-sticky sessions in clusters. -Phil What Barney said is dead-on. I am a total zero on clusters, but isn't there a way -- outside of CF -- to handle sessions so they remain sticky despite the application? i.e. an external application of some sort. Would that be db-related? Systems guys at that level usually aren't so ignorant so I'm wondering if he is taking something non-CF into account. And even there was such a thing in play, I can't see how proper locking practices would be mitigated in any meaningful way. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183282 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfencode problems
c:\cfusionmx\bin\cfencode f:\websites\[path]\*.cfm f:\websites\[path]\*.cfm /r Path too long, or contains funny chars ? The path uses no spaces or funny chars, just alpha characters. It worked before, but does not now, which is strange. I've even logged on as administrator and it still does not work (this is on a Windows 2003 server installation). ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183283 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars stored in database?
You can do sticky sessions in a cluster, but that means that a given session always ends up on the same server, not than the session data is shared across the cluster to whatever machine needs it. That's done with the load balancing hardware/software. Still RAM-only session vars, becuase they're never needed on multiple servers in the cluster. If you're using J2EE sessions, you can do session replication across the cluster as well, but that's still RAM-only. The servers just broadcast the data direct to the other servers, not going through an external store (a DB), as I understand it. Never seen it in action, so I don't know for sure. cheers, barneyb On Wed, 3 Nov 2004 08:36:37 -0800, Matt Robertson [EMAIL PROTECTED] wrote: What Barney said is dead-on. I am a total zero on clusters, but isn't there a way -- outside of CF -- to handle sessions so they remain sticky despite the application? i.e. an external application of some sort. Would that be db-related? Systems guys at that level usually aren't so ignorant so I'm wondering if he is taking something non-CF into account. And even there was such a thing in play, I can't see how proper locking practices would be mitigated in any meaningful way. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183284 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
well that's the thing I am setting it in include not the index.cfm file. so I created it in the index.cfm file NOT the included file and it now works. Ian On Wed, 3 Nov 2004 12:41:26 -0500, Ewok [EMAIL PROTECTED] wrote: Sure, as long as you set it before you call it of course -Original Message- From: Ian Sheridan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 12:38 PM To: CF-Talk Subject: How to use Request scope?! can you set a request scope variable in an include? ex. -index.cfm --include1.cfm -- set request.test --include2.cfm -- read request.test can this be done? -- -- Ian Sheridan http://www.savagevines.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:4:183285 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
It sounds like it wasn't always being set in the first include. Regardless of what file a request variable is set in, it is available to all subsequent code. I may be off a bit with regard to CFCs, but that's how I understand it. --Ben Ian Sheridan wrote: well that's the thing I am setting it in include not the index.cfm file. so I created it in the index.cfm file NOT the included file and it now works. Ian Sure, as long as you set it before you call it of course -Original Message- can you set a request scope variable in an include? ex. -index.cfm --include1.cfm -- set request.test --include2.cfm -- read request.test can this be done? ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183286 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: How do I print out a directory listing in XP
Thanks. Exactly what I needed. -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 11:39 AM To: CF-Talk Subject: Re: OT: How do I print out a directory listing in XP http://www.rohanclan.com/library/printdirlist.cfm On Wed, 3 Nov 2004 11:18:56 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: I need to print out a directory listing for a disk I am sending to a printer. Can someone tell me how to do this? Thanks, Andy ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183287 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bluedragon Server
From: Ryan Jones wrote: With PHP I am basicly open and free to code and make the language do just about anything I want it to. With cfml, I could find myself at a place where I need to call on java. However, if I understand correctly, the free version of Bluedragon does not support calls to java nor the parsing of jsp code. I may be wrong...? The free version of BlueDragon does not support JSP, but does support calls to Java via CFOBJECT/CreateObject(). So you can either call the built-in Java APIs or Java classes that your write yourself. The free version of BlueDragon also support Java and C++ CFX tags. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183288 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian On Wed, 03 Nov 2004 13:05:25 -0500, Ben Doom [EMAIL PROTECTED] wrote: It sounds like it wasn't always being set in the first include. Regardless of what file a request variable is set in, it is available to all subsequent code. I may be off a bit with regard to CFCs, but that's how I understand it. --Ben Ian Sheridan wrote: well that's the thing I am setting it in include not the index.cfm file. so I created it in the index.cfm file NOT the included file and it now works. Ian Sure, as long as you set it before you call it of course -Original Message- can you set a request scope variable in an include? ex. -index.cfm --include1.cfm -- set request.test --include2.cfm -- read request.test can this be done? ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183289 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: How do I print out a directory listing in XP
http://www.rohanclan.com/library/printdirlist.cfm Very Cool! ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183290 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: XML Spy error when going to Schema view on XML file
I'm attempting to go into Schema view in XML Spy Home 2005 on the enclosed XML file when it gives the error Unable to show schema. Schema has to begin with a schema-element!. Anyone have any ideas what I'm missing in my files? Thanks. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Why are you wearing that stupid man suit? - Frank TLCircle.xml: ?xml version=1.0 encoding=UTF-8? TLCircle xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=TLCircle.xsd Member MemberID=1234 ShowPicture=yes NameJoe Blogs/Name LocationTexas/Location Biography/ /Member /TLCircle TLCircle.xsd: ?xml version=1.0 encoding=UTF-8 standalone=no? !--W3C Schema generated by XMLSpy v2005 U (http://www.xmlspy.com)-- !--Please add namespace attributes, a targetNamespace attribute and import elements according to your requirements-- xs:schema xmlns:xs=http://www.w3.org/2001/XMLSchema; elementFormDefault=qualified xs:element name=TLCircle xs:complexType xs:sequence xs:element ref=Member maxOccurs=unbounded/ /xs:sequence /xs:complexType /xs:element xs:element name=Member xs:complexType xs:sequence xs:element ref=Name/ xs:element ref=Location/ xs:element ref=Biography minOccurs=0 maxOccurs=unbounded/ /xs:sequence xs:attribute name=MemberID type=xs:integer use=required/ xs:attribute name=ShowPicture use=required xs:simpleType xs:restriction base=xs:NMTOKEN xs:enumeration value=yes/ xs:enumeration value=no/ /xs:restriction /xs:simpleType /xs:attribute /xs:complexType /xs:element xs:element name=Name type=xs:string/ xs:element name=Location type=xs:string/ xs:element name=Biography type=xs:string/ /xs:schema ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183291 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben Ian Sheridan wrote: Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian ~| 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:183292 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
A request scope can be set anywere and is available anywhere during a request. However its bad coding practice to use it in CFCs and what not but as far as I can tell it can be done. Adam On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom [EMAIL PROTECTED] wrote: Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben Ian Sheridan wrote: Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183293 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
getting CF version, other details
Isn't there a script that one can run to find this out when you don't have access to the administrator? I know that you can do this in other languages, but not sure for CF. I am working on a potential client, and would like to find this stuff out without having to ask. Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:183295 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
Oh it is passing the right info but maybe it's because I am doing this on a 6.0 machine Ian On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom [EMAIL PROTECTED] wrote: Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben Ian Sheridan wrote: Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183294 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfexecute problems
I am having trouble running a Visual FoxPro Executable via CFEXECUTE to do some DBF maniupations on the Server -- the EXE is loaded as a service and then is not released upon execution timeout as specified in the CFEXECUTE statement (20 seconds) -- I included reference to an outputfile but no output is actually generated by the program so the file generated is empty. JasonOU reported to Macromedia that he fixed the problem by running dcomcnfg. He then went to the Default Security tab, clicked on Edit Default under Access Permissions, and added the account which the IIS service uses to execute anonymously (this is generally IUSR_machinename). Since I am running XP Home (without IIS), I am using CF's Internal equivalent of IIS and am wondering what fix works that may be similar to the one suggested by JasonOU to get the EXE released. You might be able to fix this using DCOMCNFG. Within that, you can allow access to the security principle running CF (SYSTEM by default). 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=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183296 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Online Presentations
Looking for LIVE demonstrations Macromedia Breeze Live is very, very good for this. I think MM just introduced a pay-per-use option for hosted Breeze. 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=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183297 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: getting CF version, other details
cfdump var=#server# if the cfdump doesn't work, you're pre-CF 5 :) On Wed, 03 Nov 2004 13:34:37 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Isn't there a script that one can run to find this out when you don't have access to the administrator? I know that you can do this in other languages, but not sure for CF. I am working on a potential client, and would like to find this stuff out without having to ask. Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183298 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Odd SQL Behaviour, errors generated by values I am not trying to use!
James Smith wrote: INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? Because it is 2^32. Instead of throwing an error MySQL just rounds your value to the maximum that fits in the field. But the field is INT(13), why would a 13 digit number not fit? Because display padding has got nothing to do with physical storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html Bigint fixed it, thanks. Any idea why the DB allows an INT(13)? I have no idea why MySQL does things the way it does. I can rant a long time about why what MySQL is doing is wrong :-) You might want to read http://sql-info.de/mysql/gotchas.html Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183299 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Access driver and Windows 2003 Server
Does not verify in CF Admin under the Access or Access w/Unicode drivers. SQL Server DSNs seem to be working fine. As far as the ports, yes, everything is open that should be open. Thanks, Jake On Wednesday 03 Nov 2004 16:02 pm, Jake wrote: And when you hit the sites that they are running, I get the following error: Error Executing Database Query. coldfusion.sql.DatabaseConnectionException: Timed out trying to establish connection Does it verify in the administrator ? Are the relavent ports open in the FireWall ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183300 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How to use Request scope?!
Same here... I set all my request variables in one file then include it via Application.cfm. the request vars are available anywhere and everywhere throughout the entire application this way. If you have these two files... !--- Request.cfm--- cfset request.testvar = request variable !--- index.cfm --- cfinclude template=request.cfm cfoutput#request.testvar#/cfoutput Index.cfm should just display request variable This SHOULD definitely work. If it's not, then there is something wrong somewhere else. Were you getting test not defined in request scope errors? Or any kind of error for that matter... -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 1:26 PM To: CF-Talk Subject: Re: How to use Request scope?! Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben Ian Sheridan wrote: Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183301 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: getting CF version, other details
Try dumping the server variables cfdump var=#server# Should get you everything you need to know about the server -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 1:35 PM To: CF-Talk Subject: getting CF version, other details Isn't there a script that one can run to find this out when you don't have access to the administrator? I know that you can do this in other languages, but not sure for CF. I am working on a potential client, and would like to find this stuff out without having to ask. Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:183302 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
It shouldn't matter what version. Request variables worked the way documented in 5, I know from experience. They should work in 6.0 just fine. But that raises the question of why you're running 6.0 instead of 6.1 with updaters. Is there are reason? If not, you should definately update -- there are a number of security and performance fixes. --Ben Ian Sheridan wrote: Oh it is passing the right info but maybe it's because I am doing this on a 6.0 machine Ian On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom [EMAIL PROTECTED] wrote: Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben ~| 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:183303 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: getting CF version, other details
Cool - thanks. Ray At 02:10 PM 11/3/2004, you wrote: Try dumping the server variables cfdump var=#server# Should get you everything you need to know about the server -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 1:35 PM To: CF-Talk Subject: getting CF version, other details Isn't there a script that one can run to find this out when you don't have access to the administrator? I know that you can do this in other languages, but not sure for CF. I am working on a potential client, and would like to find this stuff out without having to ask. Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183304 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can someone Explain this Error Message
The File when generated is approx 2 Meg in size. What have I done is learned the RTF File Format and is 60 Pages long. At 07:23 AM 11/3/2004, you wrote: On Wednesday 03 Nov 2004 12:04 pm, Graham Pearson wrote: Branch target offset too large for short Is the file very large ? Can you test it with a less evil path ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183305 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
I was getting the actionpasser not defined in the Request scope. This is basicly what I am doing: !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm On Wed, 3 Nov 2004 14:08:51 -0500, Ewok [EMAIL PROTECTED] wrote: Same here... I set all my request variables in one file then include it via Application.cfm. the request vars are available anywhere and everywhere throughout the entire application this way. If you have these two files... !--- Request.cfm--- cfset request.testvar = request variable !--- index.cfm --- cfinclude template=request.cfm cfoutput#request.testvar#/cfoutput Index.cfm should just display request variable This SHOULD definitely work. If it's not, then there is something wrong somewhere else. Were you getting test not defined in request scope errors? Or any kind of error for that matter... -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 1:26 PM To: CF-Talk Subject: Re: How to use Request scope?! Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben Ian Sheridan wrote: Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183306 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: inetinfo.exe Memory Leak After 6.1 Updater
FYI, after many tests, we have isolated the problem as a memory leak in jrun.dll. I've replaced the current jrun.dll with the one in JRun 4 Updater 4 (build 84683), and it has brought down the memory usage, which, mind you, was going over 250MB easy a day, to a measly 19MB. It's a workaround, though; they'll be sending me a properly-patched connector soon. But for those suffering from this issue right now (and it is a burden), you might want to give this a shot. ~| 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:183307 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Another data type question
Okay, so I've got a SELECT menu that allows the user to choose which DB field they'd like to see results on, then a text box to allow them to enter the appropriate data for the SELECT choice. Now I'm wondering if I should add some sort of CFIF to show the appropriate SELECT for the 2nd portion instead of the text box b/c I'm having problems with it recognizing the datatype on my query to show results. Or is there a way to detect which datatype within my query - possibly CFIF datatype1 use this code, etc. Some of the SELECT drop downs are text in my db, some are checkboxes and some True/False. Any insight or feedback would be greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183308 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: inetinfo.exe Memory Leak After 6.1 Updater
I wonder why this would only be happening to some people (myself included). How did you extract the jrun.dll from the Updater 4? Brook At 10:38 AM 11/3/2004, you wrote: FYI, after many tests, we have isolated the problem as a memory leak in jrun.dll. I've replaced the current jrun.dll with the one in JRun 4 Updater 4 (build 84683), and it has brought down the memory usage, which, mind you, was going over 250MB easy a day, to a measly 19MB. It's a workaround, though; they'll be sending me a properly-patched connector soon. But for those suffering from this issue right now (and it is a burden), you might want to give this a shot. ~| 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:183309 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Another data type question
Donna, Here's an old code snippet from CF4/SQL7 days - may still work - if you're using MSSQL. Just an example of how to get at datatypes. Mark !--- using the sp_columnlist proc built into SQL Server --- CFSET TableName = #TableName# CFSTOREDPROC PROCEDURE=sp_columns DATASOURCE=#DataSource# CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=@table_name VALUE=#TableName# NULL=No CFPROCRESULT NAME=First RESULTSET=1 /CFSTOREDPROC TABLE CFOUTPUT QUERY=First TRTD#Column_Name#/TD TD#Type_Name#/TD TD#Length#/TD TD#Nullable#/TD TD#Column_def#/TD /TR /CFOUTPUT Donna French [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] om cc: Subject: Another data type question 11/03/2004 03:06 PM Please respond to cf-talk Okay, so I've got a SELECT menu that allows the user to choose which DB field they'd like to see results on, then a text box to allow them to enter the appropriate data for the SELECT choice. Now I'm wondering if I should add some sort of CFIF to show the appropriate SELECT for the 2nd portion instead of the text box b/c I'm having problems with it recognizing the datatype on my query to show results. Or is there a way to detect which datatype within my query - possibly CFIF datatype1 use this code, etc. Some of the SELECT drop downs are text in my db, some are checkboxes and some True/False. Any insight or feedback would be greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183310 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: inetinfo.exe Memory Leak After 6.1 Updater
One thing I forgot to mention -- it only happens if you use SSL. We use 128-bit SSL encryption for all our stuff. So that might be the distinction... I didn't extract it from the updater -- the Macromedia rep sent it to me. He says it isn't the final solution, so once I have the real thing, I'll update you guys on it. ~| 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:183311 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Odd SQL Behaviour, errors generated by values I am not trying to use!
At 01:54 PM 11/3/2004, you wrote: James Smith wrote: INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870) Could anyone tell me why the number 0004294967295 is causing an error when the SQL statement doesn't even show it being used? Because it is 2^32. Instead of throwing an error MySQL just rounds your value to the maximum that fits in the field. But the field is INT(13), why would a 13 digit number not fit? Because display padding has got nothing to do with physical storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html Bigint fixed it, thanks. Any idea why the DB allows an INT(13)? I would never imagine that INT(13) is a 13 digit number. I would assume that INT(13) is a 13 BIT number. So it would have a limit of 8192. Why allow a INT(13)? So you can allow an INT(1). If you have True/false, why not use just one bit for it? Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ ~| 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:183312 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How to use Request scope?!
ThatÂ’s pretty strange. I've never seen or heard of it happening before. Everything seems right to me. What happens when you unscope it? Make it just actionpasser instead of request.actionpasser. This would work just the same as it SHOULD when scoped as request. Are you having nay problems with the request scope anywhere else? -Original Message- From: Ian Sheridan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 2:19 PM To: CF-Talk Subject: Re: How to use Request scope?! I was getting the actionpasser not defined in the Request scope. This is basicly what I am doing: !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm On Wed, 3 Nov 2004 14:08:51 -0500, Ewok [EMAIL PROTECTED] wrote: Same here... I set all my request variables in one file then include it via Application.cfm. the request vars are available anywhere and everywhere throughout the entire application this way. If you have these two files... !--- Request.cfm--- cfset request.testvar = request variable !--- index.cfm --- cfinclude template=request.cfm cfoutput#request.testvar#/cfoutput Index.cfm should just display request variable This SHOULD definitely work. If it's not, then there is something wrong somewhere else. Were you getting test not defined in request scope errors? Or any kind of error for that matter... -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 1:26 PM To: CF-Talk Subject: Re: How to use Request scope?! Except that I do exactly what you said didn't work all the time. I routinely create request or variable scoped vars in one include to be used in another. The includes are serial, not nested. So I don't know what your original problem was, but I'd be careful to check and make sure that the value being used in the second include is actually what's being set in the first, not in the index. --Ben Ian Sheridan wrote: Well let me be a little bit more descriptive. I have an index.cfm page that includes two files. I was then setting the REQUEST variable *in* the first include. In the second include I would then look for it. This did not work. I now set the REQUEST variable in the index.cfm file first. Then set it in the first include and read it in the second include. This works. So I gather from this experience that request is *inherited* from the parent document. Application.cfm - index.cfm -- include.cfm It only gets inherited. there is no creating it in a child include/file. Ian ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183313 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfqueryparam oddity
This query was working fine, with the arguments.case_id variable being 30026 (and the function it is in is set to receive the case_id as numeric. Bottom line is it IS numeric. cfquery datasource=#request.datasource# name=getExpenseRecord select payment_mode from expense where case_id = cfqueryparam cfsqltype=cf_sql_integer value=#val(arguments.case_id)# /cfquery Now all of a sudden I get this error unless I remove the cfqueryparam and do it without. So its not a big deal, I'm just curious as to what the hecks happening: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Is this a bug? Brook D. logiforms.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183314 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Another data type question
And in Access... You'll have to run a query that selects the column you want first... cfquery name=MyQuery datasource=MyDSN maxrows=1 SELECT MyColumn From table /cfquery then... cfset MetaData = QueryName.getMetaData() cfset ColumName = MyColumn cfset DataType = QueryName.getColumnTypeName(MetaData.GetColumnType(QueryName.findColumn(Colu mnName))) -Original Message- From: Mark Wimer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 4:42 PM To: CF-Talk Subject: Re: Another data type question Donna, Here's an old code snippet from CF4/SQL7 days - may still work - if you're using MSSQL. Just an example of how to get at datatypes. Mark !--- using the sp_columnlist proc built into SQL Server --- CFSET TableName = #TableName# CFSTOREDPROC PROCEDURE=sp_columns DATASOURCE=#DataSource# CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=@table_name VALUE=#TableName# NULL=No CFPROCRESULT NAME=First RESULTSET=1 /CFSTOREDPROC TABLE CFOUTPUT QUERY=First TRTD#Column_Name#/TD TD#Type_Name#/TD TD#Length#/TD TD#Nullable#/TD TD#Column_def#/TD /TR /CFOUTPUT Donna French [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] om cc: Subject: Another data type question 11/03/2004 03:06 PM Please respond to cf-talk Okay, so I've got a SELECT menu that allows the user to choose which DB field they'd like to see results on, then a text box to allow them to enter the appropriate data for the SELECT choice. Now I'm wondering if I should add some sort of CFIF to show the appropriate SELECT for the 2nd portion instead of the text box b/c I'm having problems with it recognizing the datatype on my query to show results. Or is there a way to detect which datatype within my query - possibly CFIF datatype1 use this code, etc. Some of the SELECT drop downs are text in my db, some are checkboxes and some True/False. Any insight or feedback would be greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183315 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam oddity
do you need the val() function? is the value coming in as a string or numeric? what happens if you simply cfoutput#val(arguments.case_id)#/cfoutput? On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies [EMAIL PROTECTED] wrote: This query was working fine, with the arguments.case_id variable being 30026 (and the function it is in is set to receive the case_id as numeric. Bottom line is it IS numeric. cfquery datasource=#request.datasource# name=getExpenseRecord select payment_mode from expense where case_id = cfqueryparam cfsqltype=cf_sql_integer value=#val(arguments.case_id)# /cfquery Now all of a sudden I get this error unless I remove the cfqueryparam and do it without. So its not a big deal, I'm just curious as to what the hecks happening: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Is this a bug? Brook D. logiforms.com ~| 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:183316 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
Have you checked that o.param contains a valid value? On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan [EMAIL PROTECTED] wrote: I was getting the actionpasser not defined in the Request scope. This is basicly what I am doing: !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm ~| 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:183317 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
oh yeah it works I am getting the expected value in o.param. On Wed, 3 Nov 2004 15:15:46 -0800, Sean Corfield [EMAIL PROTECTED] wrote: Have you checked that o.param contains a valid value? On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan [EMAIL PROTECTED] wrote: I was getting the actionpasser not defined in the Request scope. This is basicly what I am doing: !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm -- -- Ian Sheridan http://www.savagevines.com -- ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183318 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam oddity
Actually, I added the val function AFTER getting the error - it makes no difference... At 03:09 PM 11/3/2004, you wrote: do you need the val() function? is the value coming in as a string or numeric? what happens if you simply cfoutput#val(arguments.case_id)#/cfoutput? On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies [EMAIL PROTECTED] wrote: This query was working fine, with the arguments.case_id variable being 30026 (and the function it is in is set to receive the case_id as numeric. Bottom line is it IS numeric. cfquery datasource=#request.datasource# name=getExpenseRecord select payment_mode from expense where case_id = cfqueryparam cfsqltype=cf_sql_integer value=#val(arguments.case_id)# /cfquery Now all of a sudden I get this error unless I remove the cfqueryparam and do it without. So its not a big deal, I'm just curious as to what the hecks happening: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Is this a bug? Brook D. logiforms.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183319 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Update on CFMX daily server crashing with no log entries
After trying everything under the sun to figure out why our CFMX 6.1 updater 1 server was crashing every day we decided to try a new JRE. We were previously using JavaSoft 1.3.1_09 and changed to Java's j2re1.4.2_06 and the server has been stable for over a week with memory usage MUCH better. I think originally we went to the JavaSoft JRE after some issues with CFHHTP and HTTPS but I can not remember exactly.. You have no idea how happy I am that our server is finally stable omg ... I can sleep through the night without getting paged!! Brook ~| 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:183320 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update on CFMX daily server crashing with no log entries
oops, I meant Sun's j2re1.4.2_06 At 03:38 PM 11/3/2004, you wrote: After trying everything under the sun to figure out why our CFMX 6.1 updater 1 server was crashing every day we decided to try a new JRE. We were previously using JavaSoft 1.3.1_09 and changed to Java's j2re1.4.2_06 and the server has been stable for over a week with memory usage MUCH better. I think originally we went to the JavaSoft JRE after some issues with CFHHTP and HTTPS but I can not remember exactly.. You have no idea how happy I am that our server is finally stable omg ... I can sleep through the night without getting paged!! Brook ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183321 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam oddity
what's the exact datatype of the field in the database? On Wed, 03 Nov 2004 15:31:59 -0800, Brook Davies [EMAIL PROTECTED] wrote: Actually, I added the val function AFTER getting the error - it makes no difference... At 03:09 PM 11/3/2004, you wrote: do you need the val() function? is the value coming in as a string or numeric? what happens if you simply cfoutput#val(arguments.case_id)#/cfoutput? On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies [EMAIL PROTECTED] wrote: This query was working fine, with the arguments.case_id variable being 30026 (and the function it is in is set to receive the case_id as numeric. Bottom line is it IS numeric. cfquery datasource=#request.datasource# name=getExpenseRecord select payment_mode from expense where case_id = cfqueryparam cfsqltype=cf_sql_integer value=#val(arguments.case_id)# /cfquery Now all of a sudden I get this error unless I remove the cfqueryparam and do it without. So its not a big deal, I'm just curious as to what the hecks happening: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Is this a bug? Brook D. logiforms.com ~| 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:183322 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Suite sale
OK, tonight the community suite is open till late so come on over. Tomorrow we open at 9 and will be auctioning off a huge amout of cool books at 10. After that we're raffling off the xbox w/ games. (about 11 or so). If your in the area, come on over. If your not, we are allowing raffle tickets to be purchased over the net. 1 for $1.50 4 for $5.00 We'll cover the shipping in the continental US and partially for outside the US. Again, the room info is Hampton Inn and Suites right across from the conference center (center E) room 213 Food and drink are free for all so come and enjoy. ~| 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:183323 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jrun.security.NTAuth question
I have only ever used it as an authentication method, i.e. rather than checking against say a database I used this to authenticate the user against the domain, if true set the appropriate session variables and that was that. So to log out simply cleared the session. You don't necessarily have to store anything in the session scope but you could use this access method on a page by page basis as well if there were sections of your site you wanted to exclusively protect. Hope this helps. G. On Wed, 3 Nov 2004 10:05:34 -0600, Peterson, Andrew S. [EMAIL PROTECTED] wrote: Hello, If you log someone in using jrun.security.NTAuth, how do you log them out? Sincerely, Andrew ~| 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:183324 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan [EMAIL PROTECTED] wrote: oh yeah it works I am getting the expected value in o.param. Where is o.param set? You didn't show that in your cut-down code... !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 1 invite If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:183325 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How to use Request scope?!
Either way, it had to be set or the error he would get would be PARAM not defined in O. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 8:02 PM To: CF-Talk Subject: Re: How to use Request scope?! On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan [EMAIL PROTECTED] wrote: oh yeah it works I am getting the expected value in o.param. Where is o.param set? You didn't show that in your cut-down code... !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 1 invite If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:183326 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to use Request scope?!
o.param is a string that I get out of a CFPROCEDURE it's there and avaiable. I have focused it down to the setting the request variable. when I dump and abort the o.param it's there. Ian On Wed, 3 Nov 2004 17:02:11 -0800, Sean Corfield [EMAIL PROTECTED] wrote: On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan [EMAIL PROTECTED] wrote: oh yeah it works I am getting the expected value in o.param. Where is o.param set? You didn't show that in your cut-down code... !--- include1.cfm --- cfset request.actionpasser = o.param !--- include2.cfm --- cfoutput#request.actionpasser#/cfoutput !--- index.cfm --- cfinclude template=include1.cfm cfinclude template=include2.cfm -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 1 invite If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:183327 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
File size
Is it possible to determine the size of a file in CFML? TIA!! ++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| 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:183328 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File size
I am not sure about cffile or cfdirectory, however using some native Java classes, I am confident that you can get this information. On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin [EMAIL PROTECTED] wrote: Is it possible to determine the size of a file in CFML? TIA!! ++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| 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:183329 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File size
Here's two methods, one with pure CFML, and one using Java. cfset filename = /my/path/to/file.txt / cfdirectory action=list directory=#getDirectoryFromPath(filename)# filter=#getFileFromPath(filename)# name=fileinfo / cfoutput#fileinfo.size#/cfoutput cfoutput#createObject(java, java.io.File).init(filename).length()#/cfoutput cheers, barneyb On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin [EMAIL PROTECTED] wrote: Is it possible to determine the size of a file in CFML? TIA!! ++ Kevin Parker Web Services Manager WorkCover Corporation -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183330 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam oddity
i have the same problem, its new, never happened before, and is now happening, same kind of code, almost exact actually. but same problem. what gives? ps. its works in s... (bla**st**) just fine, just not in cfmx 6.1 tw On Wed, 3 Nov 2004 17:21:40 -0700, Charlie Griefer [EMAIL PROTECTED] wrote: what's the exact datatype of the field in the database? On Wed, 03 Nov 2004 15:31:59 -0800, Brook Davies [EMAIL PROTECTED] wrote: Actually, I added the val function AFTER getting the error - it makes no difference... At 03:09 PM 11/3/2004, you wrote: do you need the val() function? is the value coming in as a string or numeric? what happens if you simply cfoutput#val(arguments.case_id)#/cfoutput? On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies [EMAIL PROTECTED] wrote: This query was working fine, with the arguments.case_id variable being 30026 (and the function it is in is set to receive the case_id as numeric. Bottom line is it IS numeric. cfquery datasource=#request.datasource# name=getExpenseRecord select payment_mode from expense where case_id = cfqueryparam cfsqltype=cf_sql_integer value=#val(arguments.case_id)# /cfquery Now all of a sudden I get this error unless I remove the cfqueryparam and do it without. So its not a big deal, I'm just curious as to what the hecks happening: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Is this a bug? Brook D. logiforms.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183331 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54