RE: CFEclipse 1.2
Cute pup tho.. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 02:53 pm To: CF-Talk Subject: RE: CFEclipse 1.2 Importance: Low sorry guys.. meant to send that offlist. Ugh. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 2:46 PM To: CF-Talk Subject: RE: CFEclipse 1.2 From: Ray Champagne [mailto:[EMAIL PROTECTED] MT, you have links for more pics? send 'em offline to me! Ray Sorry Ray, meant to send this to ya over the weekend! http://www.cfreloaded.com/herbie/new%20baby/index.html Now, if I could get some sleep :-) Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215312 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: stupid simple piece of javascript code
Thanks all.. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 04:54 pm To: CF-Talk Subject: RE: stupid simple piece of javascript code Importance: Low if ((theForm.send_email.value != theForm.v_sendemail.value)||(theForm.ecs_email.value != theForm.v_ecsName.value))**ERROR**;**ERROR* You don't put a ; at the end of the if clause. It end the entire if/else block leaving the rest flapping in the wind. Most likely a typo, but of archive sake added an explanation. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214541 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
stupid simple piece of javascript code
Can somebody debug this? The Netscape javascript console says there's a syntax
error at else
function checkEmail() {
if ((theForm.send_email.value !=
theForm.v_sendemail.value)||(theForm.ecs_email.value !=
theForm.v_ecsName.value));
{
window.alert(The emails don\'t match!);
return false;
}
else
{
return true;
}
}
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 10, 2005 04:47 pm
To: CF-Talk
Subject: RE: Fetching a website?
Importance: Low
I still maintain that a well-written CF app can still beat a
crappily written pure Java app.
Absolutely. However, part of writing a well-written application is choosing
the appropriate language for the task.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214470
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
CFflie and multiple uploads
Can cffile accept multiple uploads? I'm building an upload widget and one of the features is the ability to upload more than one file at a time. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.1/64 - Release Date: 08/04/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213897 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: CFflie and multiple uploads
H what the boss wants is something similar to the DotNetNuke file upload. Click the browse button, find the file click add and it creates a list of files in a new field, the it uploads the list sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, August 05, 2005 02:11 pm To: CF-Talk Subject: RE: CFflie and multiple uploads Importance: Low No cffile does not accept multiple file uploads, but I have created the ability to create multiple input type=file... tags, that each tag runs a separate cffile operation. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213902 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
Using db drivers other than what's provided
Is there any way to change the JDBC driver that ColdFusion uses. IE: Microsoft has come out with a new JDBC Driver (in beta) for SQL 2000/2005. I'd like to uses this instead of the SQL Server Driver that comes with CF to see if it'll solve some of the problems we've been having. Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 04:11 pm To: CF-Talk Subject: Re: Creating Windows GUIDs with Cold Fusion Importance: Low Sorry, gmail hiccup. On 5/9/05, Marlon Moyer [EMAIL PROTECTED] wrote: Like this? http://www.cflib.org/udf.cfm?ID=54 or do you mean something else... On 5/9/05, SStewart [EMAIL PROTECTED] wrote: All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 05/09/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213582 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
SEQUELink error with Foxpro
We've gotten this error randomly on all 24 of our CF installations. It's trying
to make a socket call to an ODBC Instance to a FoxPro freetable directoy.
Any ideas as to the root cause?
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The error occurred in D:\Docwf\Navigation\qry_RptsbyStatusDate.cfm: line 51
Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 27
Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 17
Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 1
Called from D:\Docwf\fbx_fusebox30_CF50.cfm: line 241
Called from D:\Docwf\fbx_fusebox30_CF50.cfm: line 1
Called from D:\Docwf\fbx_fusebox30_CF50.cfm: line 1
Called from D:\Docwf\index.cfm: line 37
Called from D:\Docwf\Navigation\qry_RptsbyStatusDate.cfm: line 51
Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 27
Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 17
Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 1
Called from D:\Docwf\fbx_fusebox30_CF50.cfm: line 241
Called from D:\Docwf\fbx_fusebox30_CF50.cfm: line 1
Called from D:\Docwf\fbx_fusebox30_CF50.cfm: line 1
Called from D:\Docwf\index.cfm: line 37
49 : FROM reports
50 : WHERE DTOS(date_cast)+project+set_letter BETWEEN
'#DateFormat(mintestDT,mmdd)#'
51 : AND '#DateFormat(DateAdd('d',1,now()),mmdd)#'
52 : Order by maxtestdat
53 : /cfquery
SQL
SELECT distinct key as CWHKEY, date_cast as maxtestdat, apk_repid FROM reports
WHERE DTOS(date_cast)+project+set_letter BETWEEN '20050725' AND '20050729'
Order by maxtestdat
DATASOURCE
DocWF_VFP
Please try the following:
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 07/27/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213236
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: Working with OPC (Other People's Code)
Yeah, when I first started in CF, I had to deal with the code of my predecessor, he surrounded very page with a single set of cfoutput tags and left justified everything, no indentation at all. It would take me hours just to read it. I took his name in vain more than a few times Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 11:30 am To: CF-Talk Subject: Working with OPC (Other People's Code) Importance: Low rant I took over this job from another guy about almost 3 years ago. Many of the things he built I have rewritten. In many cases, I found it easier to rewrite them from scratch than to fix them or enhance them. For example, here is a snippet of his code that exemplifies that type of programming that he did: CFIF #FindNoCase(http://;, EVENTURL)# OR #FindNoCase(https://;, EVENTURL)# CFELSEIF #Trim(EVENTURL)# IS CFSET EVENTURL = EVENTURL CFELSE CFSET EVENTURL = http://; EVENTURL /CFIF Here is my version, rewritten: cfif EVENTURL neq and reFindNoCase(https?://,EVENTURL) eq 0 cfset EVENTURL = http://; EVENTURL /cfif Life is grand, ain't it? /rant Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212568 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: Working with OPC (Other People's Code)
Who's down with OPC Sorry, it was there, had to be done Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/55 - Release Date: 07/21/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212626 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: Working with OPC (Other People's Code)
I had to pull the variable bitch out of someone's code once the boss wasn't pleased when he found it. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 03:02 pm To: CF-Talk Subject: RE: Working with OPC (Other People's Code) Importance: Low No lie - I *just* came across this in the code I'm maintaining: input type=hidden name=stupid value=42 / NO LIE! Okay, I'm done with this thread. Wow, talk about true to life! Dave -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 2:58 PM To: CF-Talk Subject: Re: Working with OPC (Other People's Code) Definitely been there. I distributed the first thing I ever wrote on CF-Talk and about 3 years later I got a support request. I hadn't even looked at it in two years, so I opened the file to look something up and OH MY GOD THE POUND SIGNS! Pound signs everywhere. On 7/22/05, Al Everett [EMAIL PROTECTED] wrote: Been there. On 7/22/05, Matt Osbun [EMAIL PROTECTED] wrote: Unless, of course, you're currently updating code you wrote during your humble beginnings... I wrote *what*? -- You can't destroy EVERYthing. Where would you sit? The Tick Now blogging http://www.blivit.org/blog/index.cfm http://www.blivit.org/mr_urc/index.cfm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212634 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: Working with OPC (Other People's Code)
Hehehe, Nope, the developer who's code I was fixing didn't like the client. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 04:45 pm To: CF-Talk Subject: Re: Working with OPC (Other People's Code) Importance: Low SStewart wrote: I had to pull the variable bitch out of someone's code once the boss wasn't pleased when he found it. Was it for an animal shelter? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212659 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
Data Access in Flash... more
I'm digging through the Flash Pro MX 2004 help docs and it mentions using a function called CF.query so I drop this into my flash doc and get the following **Error** Screen=data, layer=Layer 1, frame=1:Line 1: ')' or ',' expected CF.query(datasource:DocWf_SQL_Test, sql:EXEC GetConcreteStatus, username:sa, password:password), **Error** Screen=data, layer=Layer 1, frame=1:Line 3: Syntax error. Total ActionScript Errors: 2 Reported Errors: 2 I'm not sure what the syntax error is or exactly hw the function is to be used. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212006 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: Data Access in Flash... more
I encapsulated it within a function and it doesn't return any errors, now I
need to find out if it's actuall passing the data and get it into a data grid.
function getConcrete(){
result = CF.query({datasource:DocWf_SQL_Test, sql:EXEC
GetConcreteStatus});
return result;
}
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 01:22 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low
The function in question is for Server side Actionscript. This form of
scripting is normally used with Flash communication server applications.
There are no DB drivers included within the plug-in, so direct DB calls
aren't there to use.
Cheers,
Kevin
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212021
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: Data Access in Flash... more
Thanks,
I kinda thought that's what I was doing.. like I said I'm VERY new to this...
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 02:06 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low
Unless this is in a CF page or a FlashComm app, it simply won't work. Flash
doesn't have the capabilities or the integrated drivers to handle making
direct DB calls.
The reason your script isn't throwing an error is because Flash assumes that
there's a custom class object named CF with a method called Query. I'd
strongly suggest looking at remoting for your middleware as this is easily
the best way to get dynamic data into flash.
Here's some instructions on CF.Query and other SSAS functions for future
reference:
http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentationfile=1496.htm
Cheers,
Kevin
-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED]
Sent: July 15, 2005 11:47 AM
To: CF-Talk
Subject: RE: Data Access in Flash... more
I encapsulated it within a function and it doesn't return any errors, now I
need to find out if it's actuall passing the data and get it into a data
grid.
function getConcrete(){
result = CF.query({datasource:DocWf_SQL_Test, sql:EXEC
GetConcreteStatus});
return result;
}
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
.. the Scottish Rogues
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 01:22 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low
The function in question is for Server side Actionscript. This form of
scripting is normally used with Flash communication server applications.
There are no DB drivers included within the plug-in, so direct DB calls
aren't there to use.
Cheers,
Kevin
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212024
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: Data Access in Flash... more
Thanks, I kinda thought that's what I was doing.. like I said I'm VERY new to this... sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rogues -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Friday, July 15, 2005 02:06 pm To: CF-Talk Subject: RE: Data Access in Flash... more Importance: Low Unless this is in a CF page or a FlashComm app, it simply won't work. Flash doesn't have the capabilities or the integrated drivers to handle making direct DB calls. The reason your script isn't throwing an error is because Flash assumes that there's a custom class object named CF with a method called Query. I'd strongly suggest looking at remoting for your middleware as this is easily the best way to get dynamic data into flash. Here's some instructions on CF.Query and other SSAS functions for future reference: http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentationfile=1496.htm Cheers, Kevin -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212027 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
Playing with Flash Data Access
I'm just in the beginning stages of playing with Flash as a UI builder. I've
set up a web services datasource and a data grid, when I run the data grid I
get the following errors. There doesn't seem to be anyplace to correct them
ideas/
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 6: '}' or ','
expected
{component: application.data.Concrete Field
ReportsReceiveWebServiceConnector, property: results, event: [result]},
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 7: '}' or ','
expected
{component: application.data.Concrete Field ReportsDataSet, property:
dataProvider},
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 9: Syntax error.
false);
Total ActionScript Errors: 3 Reported Errors: 3
Error opening URL http://localhost/docwf/navigation/qry_RptsbyStatusDate.cfc
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211908
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: Playing with Flash Data Access
Because I'm just starting to dig into this. and I didn't set the servers up
so I'm not sure if remoting is even installed...
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 04:01 pm
To: CF-Talk
Subject: Re: Playing with Flash Data Access
Importance: Low
I have to ask... why not use Flash Remoting, much faster than using
web services...
On 7/14/05, SStewart [EMAIL PROTECTED] wrote:
I'm just in the beginning stages of playing with Flash as a UI builder. I've
set up a web services datasource and a data grid, when I run the data grid I
get the following errors. There doesn't seem to be anyplace to correct them
ideas/
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 6: '}' or ','
expected
{component: application.data.Concrete Field
ReportsReceiveWebServiceConnector, property: results, event: [result]},
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 7: '}' or ','
expected
{component: application.data.Concrete Field ReportsDataSet, property:
dataProvider},
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 9: Syntax error.
false);
Total ActionScript Errors: 3 Reported Errors: 3
Error opening URL http://localhost/docwf/navigation/qry_RptsbyStatusDate.cfc
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born
the Scottish Rogues
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211912
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
Calling .net data grid as a cfobject
I'm running CFMX Standard. Is there any way to call the .net data grid as a cfobject? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born the Scottish Rouges -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211745 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
Differnet type of multi select
I have a list of line items in an invoicing app. Within the line item is a check box for Do not print. Is there any way to do a highlight and select, in the same way that you can do in a desktop app. IE Click on multiple line items to perform a single task Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date: 07/06/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211318 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: producing a .tif-file
You should also be able to feed PDF's or Postscript (.ps) files to the fax gateway. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 12:50 pm To: CF-Talk Subject: Re: producing a .tif-file Importance: Low TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Something like a GIF or JPG should be more than adequate... Kevin - Original Message - From: Uwe Degenhardt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 07, 2005 9:57 AM Subject: OT: producing a .tif-file Hi list, I have a few data stored in a my-sql-db. I want to build a word formular based on this data. Then I want to produce a ..tif-file and send it via a fax-gateway to the receipient. Any clues how to produce a .tif-file with or without ColdFusion ? Uwe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211342 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: producing a .tif-file
The output is a .tif. But the input could be almost anything as long as the server/software can read it. And yes, you're right the .tif format uses LZW compression Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 02:11 pm To: CF-Talk Subject: Re: producing a .tif-file Importance: Low TIFs are mainly uncompressed and I'm curious why you can't use another format considering the minimal quality you need to send a fax? Because the fax format is a TIFF format. And yes, TIFF is compressed, not as much as other formats, but compression is provided in TIFF format. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211357 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: Recommendation - email list
http://www.realmagnet.com Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Kurt Kaptein [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 12:35 pm To: CF-Talk Subject: Recommendation - email list Importance: Low some important things 1 multiple lists 2. auto dedupe before sending 3. easy editor 4. scalable to 50,000 users Any suggestions Sincerely, Kurt Kaptein Spectrum Net Designs, Inc PO Box 806 Grandville, MI 49468 Toll Free: 866-773-2638 Fax: 616-538-5691 Website: www.spectrumnetdesigns.com http://www.spectrumnetdesigns.com/ Email: [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211157 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: FarCry CMS install error...
Your passing a variable that's too big for the field size. You could find column 'userID' and change the size to something larger. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Buntin, Seth - KATE [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 10:52 am To: CF-Talk Subject: FarCry CMS install error... Importance: Low I am getting this error on install: Data truncation: Data truncated; out of range for column 'userId' at row 1 Has anyone had this issue? Thanks, Seth Buntin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211029 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
Embedded urls in CFGRID
Im using cfform to create a tabbed interface based in flash. Within the first tab I have a CFgrid (also in flash) can I embed a url, such that if someone clicks on the value in the grid field it will take them to another page based on that field/ I hope this makes sense. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.7/34 - Release Date: 06/29/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210976 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: coldfusion and asp.net
We've been running both for a while, I haven't seen any performance issues. Shoot.. Blue Dragon even runs with and can take advantage of .net You can't easily pass variables between the two, except in the case of BD. But they can coexist on the same box. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Jon Scherdin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 04:38 pm To: CF-Talk Subject: coldfusion and asp.net Importance: Low I need some help. Is anyone out there using asp.net and coldfusion on the same server in a production environment? The reason I ask is that my company has multiple servers, a dev server running iis, .net, and cf, an app server running iis and cf, and a .net server running iis and .net. I really want to consolidate things and bring all the servers together but I am getting resistance from some people who say that coldfusion and asp.net do not play well together and that there are performance issues when they are on the same box. Does anyone have any data that supports either side of this argument? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210171 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
CMS Systems
Aside from CommonSpot are there any other for sale CF-based CMS systems out there. I've looked at FarCry and CF_Extreme and they take a lot of modification to do what we want. We're using DotnetNuke for our Intranet and we don't have an on staff .net developer. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.3/15 - Release Date: 06/14/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209727 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 - Cannot Find Stored Procedure
Turn off maintain connection across requests in CF Admin under
Datasources = Your DB Name = Advanced.
This could be the problem.
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 10:07 am
To: CF-Talk
Subject: MS SQL - Cannot Find Stored Procedure
Importance: Low
I've created the stored procedure in the Enterprise Manager on our Dev Server.
Its the same code that's used on our live site so I know it works. However,
Coldfusion returns an error that says the stored procedure cannot be found.
Another thing : is that when I go to run the stored procedure again ( see code
below ), it tells me that it cannot find it in the system catalog. ( whatever
that means ). But it DOES appear in the stored procedure list.
Checked permissions and they seem fine as well.
Code at top of the stored procedure...
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Get_Adverts' AND uid =
user_id('myuid') AND type = 'P') DROP PROCEDURE Get_Adverts
GO
.. remaining code in here
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209397
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: MS SQL - Cannot Find Stored Procedure
I've always seen it as a best practice I've seen no performance hits. I have to deal with FoxPro tables along with SQL Server, and this seems to work when the FoxPro guys make table changes. The only other suggestion I can make is to stop and restart the ODBC service.and check yer spelling :) sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 10:28 am To: CF-Talk Subject: RE: MS SQL - Cannot Find Stored Procedure Importance: Low Turn off maintain connection across requests in CF Admin under Datasources = Your DB Name = Advanced. thanks, but that didn't seem to work. As a side note, what are the performance implications for setting this value true or false? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209402 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 - Cannot Find Stored Procedure
Elaborate please... I'll swear that MM used to recommend this as a best practice.. I need all the SQL Server performance I can get, If I'm doing something wrong I'd like to correct it.. Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 11:02 am To: CF-Talk Subject: RE: MS SQL - Cannot Find Stored Procedure Importance: Low I've always seen it as a best practice I've seen no performance hits. I have to deal with FoxPro tables along with SQL Server, and this seems to work when the FoxPro guys make table changes. That's about as far from a best practice as you can get, with MS SQL Server. It's a terrible thing to do if you're using SQL Server, in most cases. There's quite a bit of overhead in creating and destroying database connections unnecessarily. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209411 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 - Cannot Find Stored Procedure
Cool, I'll experiment, it may be what's causing some other issues sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 11:11 am To: CF-Talk Subject: RE: MS SQL - Cannot Find Stored Procedure Importance: Low Elaborate please... I'll swear that MM used to recommend this as a best practice.. I need all the SQL Server performance I can get, If I'm doing something wrong I'd like to correct it.. To the best of my knowledge, Macromedia has never recommended this. I can see why you might want to do it if you're using FoxPro, but not with MS SQL Server or any other enterprise database server. I don't know how much I can elaborate beyond that, without specific questions, other than to say that creating new database connections unnecessarily is expensive - that's why connection pooling is provided. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209415 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: Source control
Just to backpedal for a second, didn't someone metion one that integrates with Dreamweaver. I'm just discovering that I should've paid attention to this thread Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 06/08/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209094 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: Source control
There is this widget, that I found on the Macromedia site http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn120#loc=en_usview=sn106viewName=Exchange%20Search%20Detailsauthorid=26221page=0scrollPos=0subcatid=0snid=sn106itemnumber=0extid=1019143catid=0 Its SVN Lite, for Dreaweaver. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, June 09, 2005 01:43 pm To: CF-Talk Subject: Re: Source control Importance: Low I hope so... It seems to me if they used the API, then the tool would more easily, if not out of the box, work with SC systems that support the SCCI interface. Of course, if anyone else feels like this is a worthy suggestion, http://www.macromedia.com/go/wish ! - Calvin On 6/9/05 1:16 PM, Damien McKenna [EMAIL PROTECTED] wrote: For that matter, I think the only SC system that is out of the box supported is VSS, but not the SCCI interface (which products like Clearcase seem to support). Correct - DW is I think the only development tool I know of that works *directly* with the VSS *database* instead of using the API (SCCI), and its mighty frustrating. Maybe they'll change that in DWMX2006? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209138 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
Equivalent to Server.MapPath
In ASP, the variable Server.MapPath can extrapolate the path of a given file is there an equivalent CF call? Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 06/08/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208974 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: Viewing files in another server/directory outside CF server
UNC: universal network connection, or something like that. Basically it's Windows Shared folder/or drive. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 12:45 pm To: CF-Talk Subject: Re: Viewing files in another server/directory outside CF server Importance: Low Thanx Dave. .and that your clients have network logon rights to that machine and read access to the share in question... it's impossible! What's UNC? How to setup? Thanx once more again. 2005/5/24, Dave Watts [EMAIL PROTECTED]: CF lives in CA_LA_WS server and all docs lives in CA_LA_Fresno server. How to show for our users docs stored in CA_LA_Fresno server with IE? It's possible? For IE I need to store my files in CF server? You have all sorts of options. You can allow direct access via UNC path to the server in question, although you will also have to ensure that your clients can resolve the NetBIOS name correctly (via WINS, LMHOSTS or AD DNS) and that your clients have network logon rights to that machine and read access to the share in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207538 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: Anyone know of a more elegant way to do this?
Ewok... This works, Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 06:03 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low Sorry, first one didnÂ’t come through I guess... here it is again This doesnÂ’t take into account that you may reach ZZ will you actually have that many on one project? It seems like it would throw your whole numbering out of whack if so anyway. I definitely agree with Claude (Im sure you do too) but if you can manage to start with a new schema it would save a lot of future headache... like actually having 01000AA - 01000ZZ and needing another since the number seems to be more of a main project indicator and the letters revisions or changes/updates... anyway... This will increment the letters AA - AZ and roll AZ to BA. It's by no means perfect either but it's not 1000 lines of code :) cfquery name=jobnum datasource=mydsn maxrows=1 select * from q order by jobid desc /cfquery cfset alpha = A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z cfset LastJobNumber = jobnum.jobnumber cfset FirstLetter = ucase(left(right(LastJobNumber, 2), 1)) cfset LastLetter = ucase(right(ucase(LastJobNumber), 1)) cfset NumberPrefix = rereplace(LastJobNumber, [^0-9], , ALL) cfif LastLetter is Z cfset NewLastLetter = A cfset IncrementFirst = true cfelse cfset LastLetterPosition = ListFind(alpha, LastLetter) cfset NewFirstLetter = FirstLetter cfset NewLastLetter = ListGetAt(alpha, LastLetterPosition+1) cfset IncrementFirst = false /cfif cfif IncrementFirst cfset FirstLetterPosition = ListFind(alpha, FirstLetter) cfset NewFirstLetter = ListGetAt(alpha, FirstLetterPosition+1) /cfif cfoutput#NumberPrefix##NewFirstLetter##newLastLetter#/cfoutput -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207136 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: Anyone know of a more elegant way to do this?
Hopefully it'll be after my shelf-life is long gone :P sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 02:41 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low No problem (and good luck) Let us know if you shut the doors when you hit 99ZZ :^O -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 9:11 AM To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Ewok... This works, Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 06:03 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low Sorry, first one didnÂ’t come through I guess... here it is again This doesnÂ’t take into account that you may reach ZZ will you actually have that many on one project? It seems like it would throw your whole numbering out of whack if so anyway. I definitely agree with Claude (Im sure you do too) but if you can manage to start with a new schema it would save a lot of future headache... like actually having 01000AA - 01000ZZ and needing another since the number seems to be more of a main project indicator and the letters revisions or changes/updates... anyway... This will increment the letters AA - AZ and roll AZ to BA. It's by no means perfect either but it's not 1000 lines of code :) cfquery name=jobnum datasource=mydsn maxrows=1 select * from q order by jobid desc /cfquery cfset alpha = A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z cfset LastJobNumber = jobnum.jobnumber cfset FirstLetter = ucase(left(right(LastJobNumber, 2), 1)) cfset LastLetter = ucase(right(ucase(LastJobNumber), 1)) cfset NumberPrefix = rereplace(LastJobNumber, [^0-9], , ALL) cfif LastLetter is Z cfset NewLastLetter = A cfset IncrementFirst = true cfelse cfset LastLetterPosition = ListFind(alpha, LastLetter) cfset NewFirstLetter = FirstLetter cfset NewLastLetter = ListGetAt(alpha, LastLetterPosition+1) cfset IncrementFirst = false /cfif cfif IncrementFirst cfset FirstLetterPosition = ListFind(alpha, FirstLetter) cfset NewFirstLetter = ListGetAt(alpha, FirstLetterPosition+1) /cfif cfoutput#NumberPrefix##NewFirstLetter##newLastLetter#/cfoutput -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207204 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: Anyone know of a more elegant way to do this?
Hopefully it'll be after my shelf-life is long gone :P sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 02:41 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low No problem (and good luck) Let us know if you shut the doors when you hit 99ZZ :^O ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207209 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
Anyone know of a more elegant way to do this?
I'm incrementing a project number, it's an alpha-numeric number (001000A or 001000AA) if it's a new project I just grab the first six numbers and increment, if it's an extended project I have to increment the letter with the next one. My code works but it's kind of a battering ram approach, is there a more elegant way to do this? Thanks sas cfif Right(qry_getLastPnum.lPnum,2) CONTAINS A cfset lPnum = Left(qry_getLastPNum.lPnum,6)B cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS B cfset lPnum = Left(qry_getLastPNum.lPnum,6)C cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS c cfset lPnum = Left(qry_getLastPNum.lPnum,6)D cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS D cfset lPnum = Left(qry_getLastPNum.lPnum,6)E cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS E cfset lPnum = Left(qry_getLastPNum.lPnum,6)F Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:08 am To: CF-Talk Subject: RE: Good Site Stats Tag Recommendation Importance: Low I like the look of Statistex however, I was going to obtain The full version but the wellmanweb site does not exist any Longer. I know awstats is off of sourceforge and is free, just never Was able to get mine to work. Sorry.. My 2 cents -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:05 AM To: CF-Talk Subject: Good Site Stats Tag Recommendation Anyone have a good site stats tag recommendation? Thanks Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207061 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: Anyone know of a more elegant way to do this?
I don't think it's HEX, the formula is Job (1) First Level Job(1 A-Z) (1A, 1B, 1C etc) when you hit Z it becomes a Second Level Job (1 A(1-9, A-Z)) (1A1, 10A2) when you run out of numbers... 1AA, 1AB etc, etc. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 02:46 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low Looks like the second part of the number is hex... Perhaps this would work? cfset myStr=qry_getLastPnum.lPnum Cfset myIdx=#REFind(myStr,[A-Z])# cfset NumericString=left(mystr,myIdx) CFSET alphaString=right(mystr,len(mystr)-myIdx) Cfset NumericString=NumericString+1 Cfset alphaString= FormatBaseN(InputBaseN(alphaString,16)+1,16) -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 2:34 PM To: CF-Talk Subject: Anyone know of a more elegant way to do this? I'm incrementing a project number, it's an alpha-numeric number (001000A or 001000AA) if it's a new project I just grab the first six numbers and increment, if it's an extended project I have to increment the letter with the next one. My code works but it's kind of a battering ram approach, is there a more elegant way to do this? Thanks sas cfif Right(qry_getLastPnum.lPnum,2) CONTAINS A cfset lPnum = Left(qry_getLastPNum.lPnum,6)B cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS B cfset lPnum = Left(qry_getLastPNum.lPnum,6)C cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS c cfset lPnum = Left(qry_getLastPNum.lPnum,6)D cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS D cfset lPnum = Left(qry_getLastPNum.lPnum,6)E cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS E cfset lPnum = Left(qry_getLastPNum.lPnum,6)F Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:08 am To: CF-Talk Subject: RE: Good Site Stats Tag Recommendation Importance: Low I like the look of Statistex however, I was going to obtain The full version but the wellmanweb site does not exist any Longer. I know awstats is off of sourceforge and is free, just never Was able to get mine to work. Sorry.. My 2 cents -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:05 AM To: CF-Talk Subject: Good Site Stats Tag Recommendation Anyone have a good site stats tag recommendation? Thanks Steve ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207070 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: Anyone know of a more elegant way to do this?
And... I haven't written the second level yet... I wanted to see if a more elegant approach would save me from several thousand lines of code... sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 02:46 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low Looks like the second part of the number is hex... Perhaps this would work? cfset myStr=qry_getLastPnum.lPnum Cfset myIdx=#REFind(myStr,[A-Z])# cfset NumericString=left(mystr,myIdx) CFSET alphaString=right(mystr,len(mystr)-myIdx) Cfset NumericString=NumericString+1 Cfset alphaString= FormatBaseN(InputBaseN(alphaString,16)+1,16) -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 2:34 PM To: CF-Talk Subject: Anyone know of a more elegant way to do this? I'm incrementing a project number, it's an alpha-numeric number (001000A or 001000AA) if it's a new project I just grab the first six numbers and increment, if it's an extended project I have to increment the letter with the next one. My code works but it's kind of a battering ram approach, is there a more elegant way to do this? Thanks sas cfif Right(qry_getLastPnum.lPnum,2) CONTAINS A cfset lPnum = Left(qry_getLastPNum.lPnum,6)B cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS B cfset lPnum = Left(qry_getLastPNum.lPnum,6)C cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS c cfset lPnum = Left(qry_getLastPNum.lPnum,6)D cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS D cfset lPnum = Left(qry_getLastPNum.lPnum,6)E cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS E cfset lPnum = Left(qry_getLastPNum.lPnum,6)F Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:08 am To: CF-Talk Subject: RE: Good Site Stats Tag Recommendation Importance: Low I like the look of Statistex however, I was going to obtain The full version but the wellmanweb site does not exist any Longer. I know awstats is off of sourceforge and is free, just never Was able to get mine to work. Sorry.. My 2 cents -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:05 AM To: CF-Talk Subject: Good Site Stats Tag Recommendation Anyone have a good site stats tag recommendation? Thanks Steve ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207071 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: Anyone know of a more elegant way to do this?
Yeah, no kidding, BUT, I'm stepping into this after this system was established. I'm putting a web face on a set of Foxpro 5 freetables. I don't know why it's done that way but I'm stuck with it. :P sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 04:41 pm To: CF-Talk Subject: Re: Anyone know of a more elegant way to do this? Importance: Low I don't think it's HEX, the formula is Job (1) First Level Job(1 A-Z) (1A, 1B, 1C etc) when you hit Z it becomes a Second Level Job (1 A(1-9, A-Z)) (1A1, 10A2) when you run out of numbers... 1AA, 1AB etc, etc. I don't know if there a more elegant way to write the code, but I swear I could find a far much more elegant way to assign job numbers! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207083 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
Looping over Form.Fieldnames
Yeah, I know “He’s back again” :-)
Anyways, IÂ’m trying loop over a set of form fields, stopping the loop when I
hit a specific blank field. (This field is automatically populated from another
form for each record the user wants to insert, it could be 1 it could be as
many as 9.
There are check box fields that may or may not show up. Which is why the
IsDefined is there. However I get the error at the bottom.
Any suggestions?
cfinclude template=../common/CreateGUID.cfm
cfset i = 0
cfloop condition=#attributes[clientID i]# neq ''
cfset guid= #CreateGUID()#
cfinclude template=qry_getClientinfo.cfm
cfquery name= datasource=#application.dsrc1#
INSERT INTO projpart
(apk_pptid
,fk_clnid
,fk_prjid
,client
,company
,ecs_office
cfif
IsDefined(attributes[invoice i]) eq Yes,invoice/cfif
,part
,concrete
,medfr)
VALUES
('#guid#'
,'#qry_getClientInfo.apk_clnid#'
,'#cookie.PRJID#'
,'#attributes[clientID i]#'
,'#attributes[coName i]#'
,
'#qry_getClientInfo.ecs_office#'
cfif
IsDefined(attributes[invoice i]) eq Yes,#attributes[invoice
i]#/cfif
,#attributes[part i]#
,'#attributes[concrete i]#'
,'#attributes[medfr i]#')
/cfquery
cfset i=i+1
/cfloop
Invalid CFML construct found on line 15 at column 62.
ColdFusion was looking at the following text:pinvoice/ppThe CFML compiler
was processing:ullian expression beginning with IsDefined, on line 15,
column 39.This message is usually caused by a problem in the expressions
structure.lia cfif tag beginning on line 15, column 34.lia cfif tag
beginning on line 15, column 34./ul
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.9 - Release Date: 05/12/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206596
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: Looping over Form.Fieldnames
That worked, Thanks Joe sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 01:26 pm To: CF-Talk Subject: Re: Looping over Form.Fieldnames Importance: Low Maybe give: cfif structKeyExists(attributes, invoice i),#attributes[invoice i]#/cfif a whirl? Cheers, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206630 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: Man, this is so OT...
Black, long sleeve, usually with the name of some obscure European metal band. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 03:22 pm To: CF-Talk Subject: Man, this is so OT... Importance: Low Don't attack me for posting this question. Just trust me. What color teeshirts do most of you like to wear? And if you had a choice of black or white, which would you prefer? Thanks! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206648 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
Looping over submitted form fields
There's a method for doing multiple record inserts from a form, and I've completely forgotten how to do it Help Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 12:48 pm To: CF-Talk Subject: RE: usability question involving a sort. Importance: Low I wouldn't, it just confuses what should be a simple action. Of course if the customer wants it that way then change it :O) Ade -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 17:36 To: CF-Talk Subject: usability question involving a sort. I have data that looks something like this. Tran Service Product CPT RBC 004350P9016 FFP 034361P9017 102199 102199 86999 102131 102131 86808 There are contols to sort each column in either ascending or descending order. My question involves the blank values when sorting by either the Service or Product columns. Is it good, bad or indifferent that when these columns are sorted in asscending order, the blank values appear first. Since there can be several dozen rows like this, they seem to be kind of in the way to me. But maybe that is just me. Would it be worth my time to somehow progamatically ignore these columns in the sort order basically always relegating them to the bottom of the list? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206549 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: Looping over submitted form fields
Bingo I have multiple form fields in the insert input name=name_1 type=text / input name=name_2 type=text / input name=name_3 type=text / input name=company_1 type=text / input name=company_2 type=text / input name=company_3 type=text / I think this should work Thanks Ade.. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 12:59 pm To: CF-Talk Subject: RE: Looping over submitted form fields Importance: Low Is there? If you have for example: input name=name_1 type=text / input name=name_2 type=text / input name=name_3 type=text / Then on the action page: cfloop from=1 to=3 index=i query INSERT #FORM[name_ i]# /query cfloop Is that what you mean? Ade -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 17:56 To: CF-Talk Subject: Looping over submitted form fields There's a method for doing multiple record inserts from a form, and I've completely forgotten how to do it Help Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206552 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
Foxpro Queries
I'm trying to write insert queries to a Foxpro Free table, every field is set to not accept null values. Apparently there's a Foxpro call that'll write in FP acceptable values. Anyone know what that call is or how to get around the nulls Note: I didn't create the table, and I don't have access to Visual Foxprom and I can't change the table structure. Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 05/10/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206465 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
Dynamic Javascript Question
IÂ’m hacking at Javascript, what this script is supposed to do is pass form
values back to another form (click on a button, select a record, and the record
data is posted back to the previous form etc.). The selection form is based on
a query, so itÂ’ll change based on how many records it returns.
The error IÂ’m getting is as follows:
Error: document.clientSearch.client_id has no properties
Source File:
http://localhost/project05/index.cfm?fuseaction=Navigation.ClientList
Line: 16
script
function clientRecPop() {
for (i=1;
icfoutput#qry_getClient.recordcount#/cfoutput;i++)
clid = document.clientSearch.client_id[i].value
compName = document.clientSearch.company[i].value
self.opener.document.forms[0].clientID.value = clid
self.opener.document.forms[0].coName.value = compName
window.close()
}
/script
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 05/10/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206230
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: Dynamic Javascript Question
I'm still getting the same errors
Here's the code (html generated from CF)
The size of the form is dictated by a cfoutput query.
script
var i = null;
var compName = null;
var clid = null;
function clientRecPop(i) {
clid = document.forms.clientSearch.client_id[i];
compName = document.forms.clientSearch.company[i];
self.opener.document.forms.NewJob.clientID.value = clid;
self.opener.document.forms.newJob.coName.value = compName;
//window.close()
}
/script
/head
body id=clientSearch
table width=100% border=0 cellpadding=0
tr bgcolor=#CC
tdspan class=style5*/span/td
tdspan class=style5Client #/span/td
tdspan class=style5Client Company Name/span/td
tdspan class=style5Contact Name/span/td
tdspan class=style5Phone#/span/td
tdnbsp;/td
/tr
form action= method=post name=clientSearch id=clientSearch
tr
tdinput name=Status1 type=text value=A size=2
/td
tdinput name=client_id1 type=text value=158903 size=10/td
tdinput name=company1 type=text value=Wal-Mart Stores, Inc
/td
tdinput name=contact1 type=text value=Mohsen Ghadimkhani
/td
tdinput name=phone1 type=text value= size=10/td
tdinput name=recID1 type=button onClick=clientRecPop(1)
value=Select/td
/tr
tr
tdinput name=Status2 type=text value=A size=2
/td
tdinput name=client_id2 type=text value=158904 size=10/td
tdinput name=company2 type=text value=Wal-Mart Stores, Inc.
/td
tdinput name=contact2 type=text value=Wayne Cox
/td
tdinput name=phone2 type=text value= size=10/td
tdinput name=recID2 type=button onClick=clientRecPop(2)
value=Select/td
/tr
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 02:56 pm
To: CF-Talk
Subject: Re: Dynamic Javascript Question
Importance: Low
IÂ’m hacking at Javascript, what this script is supposed to
do is pass form values back to another form (click on a
button, select a record, and the record data is posted
back to the previous form etc.). The selection form is
based on a query, so itÂ’ll change based on how many
records it returns.
You really ought to name your form in the parent document rather than
using forms[0] which is liable to bite you in the ass later.
form name=specialformname
self.opener.document.forms.specialformname.clientID.value = clid;
You're missing { and } around your loop code... and you should add
semicolons to each line -- intepreters allow you to get away with not
including the semicolon, but that's sloppy. The variables compName and
clid should be declared with the var keyword... so should the variable
i. It's the same as ColdFusion functions -- it'll bite you in the ass
later if you don't.
var compName = null;
var clid = null;
for (var i=1; icfoutput#qry_getClient.recordcount#/cfoutput;i++)
{
clid = document.clientSearch.client_id[i].value;
compName = document.clientSearch.company[i].value;
self.opener.document.forms.myform.clientID.value = clid;
self.opener.document.forms.myform.coName.value = compName;
}
More importantly I don't think this function will do what you want...
Unless what you want is to set the value of a single company and
clientID input elements in the parent window several times in rapid
succession before finally bringing them to rest with a single value.
:P In other words, this code would produce the same end-result as if
you had removed the loop all-together and simply set the value of i
to #qry_getClient.recordcount# and only populate the form with the
values from the last record. So if you want to get the values from an
item in the list by using links in the list to determine which item
was selected, you want to add an argument or two to your function. Try
this:
function clientRecPop(i) {
var compName = null;
var clid = null;
clid = document.clientSearch.client_id[i].value;
compName = document.clientSearch.company[i].value;
self.opener.document.forms.myform.clientID.value = clid;
self.opener.document.forms.myform.coName.value = compName;
}
The error you're getting specifically has nothing to do with these
problems btw... it can't find your clientSearch.client_id object,
either because you left out the word form or mis-spelled the form
name or some other reason... you might try
document.forms.clientSearch.client_id
hth
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
RE: Dynamic Javascript Question
I'm still getting the same errors
Here's the code (html generated from CF)
The size of the form is dictated by a cfoutput query.
script
var i = null;
var compName = null;
var clid = null;
function clientRecPop(i) {
clid = document.forms.clientSearch.client_id[i];
compName = document.forms.clientSearch.company[i];
self.opener.document.forms.NewJob.clientID.value = clid;
self.opener.document.forms.newJob.coName.value = compName;
//window.close()
}
/script
/head
body id=clientSearch
table width=100% border=0 cellpadding=0
tr bgcolor=#CC
tdspan class=style5*/span/td
tdspan class=style5Client #/span/td
tdspan class=style5Client Company Name/span/td
tdspan class=style5Contact Name/span/td
tdspan class=style5Phone#/span/td
tdnbsp;/td
/tr
form action= method=post name=clientSearch id=clientSearch
tr
tdinput name=Status1 type=text value=A size=2
/td
tdinput name=client_id1 type=text value=158903 size=10/td
tdinput name=company1 type=text value=Wal-Mart Stores, Inc
/td
tdinput name=contact1 type=text value=Mohsen Ghadimkhani
/td
tdinput name=phone1 type=text value=5012734940 size=10/td
tdinput name=recID1 type=button onClick=clientRecPop(1)
value=Select/td
/tr
tr
tdinput name=Status2 type=text value=A size=2
/td
tdinput name=client_id2 type=text value=158904 size=10/td
tdinput name=company2 type=text value=Wal-Mart Stores, Inc.
/td
tdinput name=contact2 type=text value=Wayne Cox
/td
tdinput name=phone2 type=text value=5012734734 size=10/td
tdinput name=recID2 type=button onClick=clientRecPop(2)
value=Select/td
/tr
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 05/10/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206260
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
Creating Windows GUIDs with Cold Fusion
All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 05/09/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206107 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: Creating Windows GUIDs with Cold Fusion
Yeah, I just saw that... That should do exactly what I need Thanks again This list rules all sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 03:43 pm To: CF-Talk Subject: Re: Creating Windows GUIDs with Cold Fusion Importance: Low Like this? http://www.cflib.org/udf.cfm?ID=54 or do you mean something else... On 5/9/05, SStewart [EMAIL PROTECTED] wrote: All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 05/09/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206114 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: JDBC out of memory error
It's CF V.6.1 running on Windows Server 2003 Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 04:47 am To: CF-Talk Subject: Re: JDBC out of memory error Importance: Low On Wednesday 27 Apr 2005 18:45 pm, SStewart wrote: IÂ’m returning a huge FoxPro dataset and I get a JDBC: Out of memory error. Is there a way to increase the JDBC memory size? I think you want to raise the max. mem for the JVM, assuming CF =6. What application server are you using, in that case ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204893 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: JDBC out of memory error
94000 Records, I'm trying to reproduce a Foxpro app on the web. Although it looks like I can get around it by limiting the number of records shown at any one time, and use a back/next link to scroll through them. Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 05:04 am To: CF-Talk Subject: RE: JDBC out of memory error Importance: Low How huge? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 28 April 2005 09:47 To: CF-Talk Subject: Re: JDBC out of memory error On Wednesday 27 Apr 2005 18:45 pm, SStewart wrote: I'm returning a huge FoxPro dataset and I get a JDBC: Out of memory error. Is there a way to increase the JDBC memory size? I think you want to raise the max. mem for the JVM, assuming CF =6. What application server are you using, in that case ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204895 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
JDBC out of memory error
IÂ’m returning a huge FoxPro dataset and I get a JDBC: Out of memory error. Is there a way to increase the JDBC memory size? Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.3 - Release Date: 04/25/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204776 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: Capturing Mac's SmartQuotes
Does this follow for MS Word Smart quotes also?
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]
Sent: Monday, February 14, 2005 09:51 am
To: CF-Talk
Subject: RE: Capturing Mac's SmartQuotes
Hi Talk,
I figured out that the smart quotes have a very high ASCII code. Here's
what I did to remove them:
function RemoveSmartQuotes (st) {
st = replace(st, chr(8220), chr(34), all);
st = replace(st, chr(8221), chr(34), all);
st = replace(st, chr(8216), chr(39), all);
st = replace(st, chr(8217), chr(39), all);
return st;
}
I thought you'd like to know.
- Matt Small
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194528
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
Questio nabout CF7 and generating Acrobat files
We attended a webinar yesterday, concerning CF7 and had questions that they didn't get to, so I figured I toss them out to the list and see what I get. When using cfform type=pdf does this programmatically expose acrobat so that other features (security, digital signatures) can be used. Can we save a cfdocument to a UNC? Lastly does CF7 offer any better support (read:drivers) for Foxpro? Thanks in advance for any answers Sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 02/10/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194242 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: Questio nabout CF7 and generating Acrobat files
I meant, cfdocument (DOH!!!) sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 10:23 am To: CF-Talk Subject: Re: Questio nabout CF7 and generating Acrobat files When using cfform type=pdf does this programmatically expose acrobat so that other features (security, digital signatures) can be used. No, infact i would guess that cfform type=pdf would blow up since as far as I remeber that is not a vaild attribute/value pair for cfformdid you mean cfdocument? cfdocument information: http://livedocs.macromedia.com/coldfusion/7/htmldocs/0235.htm Can we save a cfdocument to a UNC? as far as I remeber no, this may have changed, download the dev version and test it if no one else has a more difinative answer. Lastly does CF7 offer any better support (read:drivers) for Foxpro? You can use an odbc connection it works quite well, we used it in our CMS worked like a champ. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194253 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
MX7 and MX6 side by side install
I'm running MX6 for development, can I install MX 7 beside it for eval... sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 12:38 pm To: CF-Talk Subject: CFMX 7: Maximum number of simultaneous requests Maximum number of simultaneous requests defaults to 25 in CFMX 7, are there changes in recommendations from CFMX 6.1? Thanks, Calvin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193423 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: im feeling this way today
Yeah it does, but it was still pretty damn funny... sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 03:23 pm To: CF-Talk Subject: RE: im feeling this way today All off topic and 'fun' posts belong on CF-Community. CF-Talk is for technical only. Thank you ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192643 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
Error using MSXMLDOM
I'm experimenting with using the MSXMLDOM. I getting an error I cant get around.. Here's the code !--- create instance of MSXMLDOM and load Referencedata.xml File --- cfobject type=com name=objXMLDOM class=Microsoft.XMLDOM action=create cfset objXMLDOM.async = false cfset objXMLDOM.Load(c:\inetpub\wwwroot\xmledit\ReferenceDataWorking.xml) !--- delete nodes in question --- CFSET del_node = objXMLDOM.SelectSingleNode(/VFPData/r_stdpara[stdid=#attributes.stdid#]) CFSET para_node = objXMLDOM.SelectSingleNode(/VFPData) CFSET para_node.removeChild(del_node) CFSET objXMLDOM.SAVE(c:\inetpub\wwwroot\xmledit\ReferenceDataWorking.xml) !--- end XML Delete --- And here's the error Invalid CFML construct found on line 20 at column 89. ColdFusion was looking at the following text: p#/p pThe CFML compiler was processing:ullian expression beginning with objXMLDOM.SelectSingleNode, on line 20, column 35.This message is usually caused by a problem in the expressions structure. lia CFSET tag beginning on line 20, column 18./ul The error occurred in C:\inetpub\wwwroot\Docwf\StandardParagraphs\act_KillPG.cfm: line 20 Called from C:\inetpub\wwwroot\Docwf\StandardParagraphs\fbx_Switch.cfm: line 55 Called from C:\inetpub\wwwroot\Docwf\fbx_fusebox30_CF50.cfm: line 241 Called from C:\inetpub\wwwroot\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from C:\inetpub\wwwroot\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from C:\inetpub\wwwroot\Docwf\index.cfm: line 37 18 :cfset objXMLDOM.Load(c:\inetpub\wwwroot\xmledit\ReferenceDataWorking.xml) 19 : !--- delete nodes in question --- 20 :CFSET del_node = objXMLDOM.SelectSingleNode(/VFPData/r_stdpara[stdid=#attributes.stdid#]) 21 :CFSET para_node = objXMLDOM.SelectSingleNode(/VFPData) 22 :CFSET para_node.removeChild(del_node) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.0 - Release Date: 01/27/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191949 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: CF4J2EE unnecessary JARs
Xalan is the XML processor I believe. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 03:17 pm To: CF-Talk Subject: CF4J2EE unnecessary JARs I'm attempting to get CFMX running on our JBoss installation and we need to get the footprint of ColdFusion as small as possible. After eliminating the patently obvious files and directories, I'm left with the LIB directory. There are several large JARs in there and before I started hours of testing by eliminating them one at a time, I was hoping that someone on this list had done this before. Here's are the largest culprits. If anyone has information on the purpose and/or criticality of these, it would be vastly appreciated. - msapps.jar - tools.jar - cfusion.jar - xalan.jar - wc50.jar Now, it's obvious that cfusion.jar is a keeper, and most likely tools.jar. I'm taking a guess that msapps.jar allows integration with Word, Excel and the like. Not sure if that needs to stay if it isn't used in the application. As far as xalan.jar and wc50.jar, I have no idea what these are. TIA, Steve ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190127 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
Flash Paper.. Dynamic
I'm looking at Flash Paper as a possible solution for printable dynamic reports. Can Flash Paper documents be generated dynamically, and can it be done in CFMX (or do I HAVE to wait for Blackstone) Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.8 - Release Date: 01/03/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189511 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: Flash Paper.. Dynamic
What I'd like to do is pre build a Flash Paper document and populate it from database records... sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 10:51 am To: CF-Talk Subject: RE: Flash Paper.. Dynamic You can indeed generate Flashpaper and CFMX together now BUT you can only convert DOC and other information to PDF/SWF on the fly. You cannot convert HTML/HTM as this uses the MSHTML utility which requires you to manually select the FlashPaper printer driver before it will convert. You can use CFMX and Flashpaper together thus : cfobject type=com name=FlashPaper class=flashpaperconnect2.object.2 action=create cfset FlashPaper.BeginConversion(convertme.doc',converted.pdf',0,210,297) I am unsure on how CFMX gets around the MSHTML issue but it must be doing something which Flashpaper isn't doing at present! HTH N -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 January 2005 15:37 To: CF-Talk Subject: Flash Paper.. Dynamic I'm looking at Flash Paper as a possible solution for printable dynamic reports. Can Flash Paper documents be generated dynamically, and can it be done in CFMX (or do I HAVE to wait for Blackstone) Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.8 - Release Date: 01/03/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189519 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
One more off the wall question
Is there a way to dump the returned HTML (from a CF template) into a variable? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.8 - Release Date: 01/03/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189571 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
In line Spell Checkers
I have an application where I need to spell check the contents of a text box any cheap (or free) widgets out there? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186894 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
Spectra
Is anyone writing 3rd Party plugins for Spectra, similar to the stuff that's available for PHP Nuke and dot net nuke? Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184739 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: Spectra
I'm evaluating cheap/free CMS systems and one of the criteria is 3rd part modules sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 10:30 am To: CF-Talk Subject: Re: Spectra I would think not.. I think all the spectra bods moved to FarCry, I on the other hand am stuck with a badly implemented one :S MD On Thu, 18 Nov 2004 10:24:49 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is anyone writing 3rd Party plugins for Spectra, similar to the stuff that's available for PHP Nuke and dot net nuke? Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184743 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 Email Newsletter Services
Real Magnet: http://www.realmagnet.com
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Jeffrey Fongemie [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 01:36 pm
To: CF-Talk
Subject: OT: Online Email Newsletter Services
Hi everyone,
Sorry for the off topic post.
Anyone have any good experiences with any of the online
email-bulk-newsletter services? Can anyone recommend a good service?
Thanks!
Jeff
-{
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184297
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
Exposing the operating system
One of our other developers has a weird project The jist of which is gathering document s to burn to CD. Has anyone worked with operating system components , in this case exposing IMAPI? Thanks all sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183776 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: Free CF Mass mailer?
http://www.realmagnet.com Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 03:11 pm To: CF-Talk Subject: Free CF Mass mailer? Anyone know of a free/affordable CF massmail/newsletter distribution tool??? KP Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf ~| 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:182646 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: Newsletter system...
http://www.realmagnet.com Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 05:24 pm To: CF-Talk Subject: Newsletter system... Hello everyone, I am looking for a good newsletter system with full stats and reporting. Something with double opt-in features and runs on MSSQL with the ability to import and export our current MSSQL database. We had been using http://www.enewsletterpro.com/ http://www.enewsletterpro.com/ but they want too much to upgrade to their new system. We have well over a 1,000,000 entry's and need something that can handle this many records. Though keep in mind we never send a million at one time only about 20,000. Thanks.. Neal Bailey ~| 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:182661 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
CF Version Number
I'm trying to survey my in-house (OK remote locations but behind our firewall) CF Server farm, I have varying access depending on the machine, but I need to get the version number. Where is that value stored? Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 ~| 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:182385 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
Stand Alone CF Runtime
A while back someone was discussing a standalone CF Runtime app, anyone remember the name and url? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 03:08 pm To: CF-Talk Subject: ColdFusion and J2EE Framework... Anyone understand much about the J2EE Framework like *.ear files, *.war files, etc. and how it all relates to one another? I was considering deploying multiple ColdFusion Applications under one JRun Server.For example: \WebApps \WebApps\app1-ear \WebApps\app1-ear\cfusion1-war \WebApps\app1-ear\cfusion2-war \WebApps\app2-ear \WebApps\app2-ear\cfusion-war etc. I would presume that all these coldfusion applications would remain autonomous and would have individual CFAdministrators. Do I have this correct? Thanks, Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
More XML Issues
First off: huge mad props to Ian Skinner for helping me muddle my way
through this...
I'm trying a slightly different approach:
Heres my CF Code
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
http://www.w3.org/TR/html4/loose.dtd
html
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
titleUntitled Document/title
/head
body
cffile action="">
file=c:\inetpub\wwwroot\docwf\StandardParagraphs\ReferenceDataWorking.xml
variable=RefFile
cfset RefXML = XmlParse(RefFile)
cfdump var=#RefXML# label=ReferenceData
cffile action="">
file=c:\inetpub\wwwroot\docwf\StandardParagraphs\para.xslt
variable=RefTrans
cfset RefXSLT = XmlParse(RefTrans)
cfdump var=#RefXSLT# label=Transforming XSLT
!--- Parse file into xml variarable ---
cfset Combined = XMLtransform(RefXML,RefXSLT)
cfdump var=#Combined#
/body
/html
Here's the XSLT style sheet
xsl:stylesheet xmlns:xsl=http://www.w3.org/1999/XSL/Transform
version=2.0
xsl:output method=xml indent=yes/
!--load the merge file --
xsl:variable name=newParagraphs
select=document('c:\inetpub\wwwroot\docwf\StandardParagraphs\StandardParagr
aph.xml')/
!-- combine the files --
xsl:template match=/
VFPdata
!-- select all the child
nodes of the VFPData tag in the main file --
xsl:for-each
select=VFPData/child::*
!-- copy the
member tag --
xsl:copy-of
select=./
/xsl:for-each
!-- and all the child nodes
of the VFPData tag in the merge file --
xsl:for-each
select=$newParagraphs/VFPData/child::*
!-- copy the
member tag --
xsl:copy-of
select=./
/xsl:for-each
/VFPdata
/xsl:template
/xsl:stylesheet
and here's the error
xsl:stylesheet
XmlText
XmlAttributes
struct
version
2.0
xmlns:xsl
http://www.w3.org/1999/XSL/Transform
xsl:output
XmlText
XmlAttributes
struct
indent
yes
method
xml
xsl:variable
XmlText
XmlAttributes
struct
name
newParagraphs
select
document('c:\inetpub\wwwroot\docwf\StandardParagraphs\StandardParagraph.xml'
)
xsl:template
XmlText
XmlAttributes
struct
match
/
VFPdata
XmlText
xsl:for-each
XmlText
XmlAttributes
struct
select
VFPData/child::*
xsl:copy-of
XmlText
XmlAttributes
struct
select
.
xsl:for-each
XmlText
XmlAttributes
struct
select
$newParagraphs/VFPData/child::*
xsl:copy-of
XmlText
XmlAttributes
struct
select
.
Error Occurred While Processing Request
javax.xml.transform.TransformerConfigurationException:
javax.xml.transform.TransformerException: org.xml.sax.SAXParseException:
Document root element is missing.
A [Transformer] object cannot be created that satisfies the configuration
requested. This could be due to a failure in compiling the [XSL] text.
javax.xml.transform.TransformerConfigurationException:
javax.xml.transform.TransformerException: org.xml.sax.SAXParseException:
Document root element is missing.
The error occurred in
C:\inetpub\wwwroot\Docwf\StandardParagraphs\combinedif.cfm: line 21
19 : !--- Parse file into xml variarable ---
20 :
21 : cfset Combined = XMLtransform(RefXML,RefXSLT)
22 : cfdump var=#Combined#
23 : /body
I've also attached the two XML files
Does the XSLT processor not support variables?
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 11:52 am
To: CF-Talk
Subject: Re: Slightly OT: Name top 5 CF developers you know one way or
another
Pics?
g
- Original Message -
From: Adrocknaphobia
To: CF-Talk
Sent: Wednesday, October 06, 2004 10:48 AM
Subject: Re: Slightly OT: Name top 5 CF developers you know one way or
another
Also, I would like to post my vote for Rachel Maxim as the hottest CF
developer. ;-)
-Adam
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: More XML Issues
I get the same error using V.1.0 sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 12:08 pm To: CF-Talk Subject: Re: More XML Issues xsl:stylesheet xmlns:xsl=http://www.w3.org/1999/XSL/Transform version=2.0 Are you sure you really want/need to use XSLT 2.0? I don't think CF's XSLT parser support it yet Massimo Foti DW tools: http://www.massimocorner.com CF tools:http://www.olimpo.ch/tmt/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Fun in New Orleans
You MUST go to Mothers, it's probably the best authentic Cajun cuisine in New Orleans, you'll understand why they call it Mothers the first time you visit. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 01:11 pm To: CF-Talk Subject: OT: Fun in New Orleans So has anyone done any research on things to do in New Orleans?My coworkers and I are all flying in Saturday, and I'm hoping to find a good jazz club Saturday night. Last year in Salt Lake City, we went skiing one night... gotta take advantage of free trips when you can! - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: More XML Issues
I get the same error using V.1.0 sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 12:08 pm To: CF-Talk Subject: Re: More XML Issues xsl:stylesheet xmlns:xsl=http://www.w3.org/1999/XSL/Transform version=2.0 Are you sure you really want/need to use XSLT 2.0? I don't think CF's XSLT parser support it yet Massimo Foti DW tools: http://www.massimocorner.com CF tools:http://www.olimpo.ch/tmt/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: More XML Issues
Ian, Thanks for responding, I did change the root to VFPData, I ran the XSLT by itself in an editor and it works and consistently I'm kinda at a loss here... sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 03:42 pm To: CF-Talk Subject: RE: More XML Issues The first thing I notice is that you did not parse the combined xml string. After you run the xlmtransform function the result is a large string.If you then want that to be a ColdFusion XML structure you would want to parse it.This actually may not be necessary in you app, if you are just going to write that back to a file, because the string is what you want to write. But to the error you reported, unless you have changed the StandardParagraph.xml from the one you sent me.You are using the wrong root for it in the XSLT code.In the StandardParagraph.xml file you sent me, the root is stdpg.So in this line of the xslt file: xsl:for-each select=$newParagraphs/VFPData/child::* you need to provide the correct root of the StandardParagraph.xml file.It would read xsl:for-each select=$newParagraphs/stdpg/child::* for the version of the StandardParagraph.xml file you provided me. PS.The HOF lists do not allow attachments.So you can not provide the list code examples that way. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Editing XMl
I've generated an XML template with Cold Fusion. This template is a subset of a larger XML document that is used by several different applications in the suite. What I need to do is delete and replace my section of the XML document, with the XML that I've generated. I've been digging for a couple of days now. Does anyone know of a methodology to do this? Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, October 01, 2004 02:35 pm To: CF-Talk Subject: Re: National Weather Service XML Web Service Issues Does it have to be with the National Weather Service?I wrote up something for XML with Weather.com ... 10 day forcast ect... Let me know if you want it. It is inside of a page, but you can strip out the outside to get to the goodies. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Dawson, Michael To: CF-Talk Sent: Friday, October 01, 2004 1:27 PM Subject: RE: National Weather Service XML Web Service Issues I tried and failed as well.:'-( _ From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Fri 10/1/2004 1:47 PM To: CF-Talk Subject: National Weather Service XML Web Service Issues Has anyone successfully retrieved the data from this Web Service using ColdFusion? I've tried every permuation of data types for weatherParameters but nothing seems to work. The documentation online calls it an array of booleans.It looks like a custom datatype to me by looking at the WSDL... Anyone have any luck with this? WSDL URL: http://www.nws.noaa.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl NWS Information Page: http://nws.noaa.gov/forecasts/xml/ Thanks, Jeff Garza _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL Query to XML
Here's one where I'm not really sure where to start I have a SQL query that I need to run and append the results to a node in a pre-formatted XML template. The XML template is used by several other apps in the suite and carries information from different apps. I'll be doing updates and inserts to the section of the template that deals with my sub app. Thanks in advance for any input sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Query to XML Addendum
I'm able to write my data to am XML Template in the proper format. now I need to be able to find the corresponding node in the parent document and overwrite it without Destroying the other nodes in the document. Halp!!! sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 02:10 pm To: CF-Talk Subject: SQL Query to XML Here's one where I'm not really sure where to start I have a SQL query that I need to run and append the results to a node in a pre-formatted XML template. The XML template is used by several other apps in the suite and carries information from different apps. I'll be doing updates and inserts to the section of the template that deals with my sub app. Thanks in advance for any input sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Converting query to comma separated list
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for
object 'clearsoftware_visitors' in database 'clearsoftware_net_01' because
the 'PRIMARY' filegroup is full.
The error occurred in
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc: line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
Called from D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc:
line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
19 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.firstName# /
20 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.lastName# /
21 : cfprocresult name=result maxrows=1 /
22 :/cfstoredproc
23 :
_
SQL
{call clearsoftware_createVisitor( (param 1) , (param 2) , (param 3) ,
(param 4) , (param 5) , (param 6) )}
DATASOURCE
clearsoftware_glass
VENDORERRORCODE
1105
SQLSTATE
HY000
Please try the following:
* Check the ColdFusion http://www.macromedia.com/go/proddoc_getdoc
documentation to verify that you are using the correct syntax.
* Search the Knowledge http://www.macromedia.com/support/coldfusion/
Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address
65.242.127.130
Referrer
Date/Time
23-Sep-04 09:21 AM
Stack Trace (click to expand) _javascript_:;
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called queryTool to my site (http://clearsoftware.net
- downloads - queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays, and structures.Perfectly free, seems
to work pretty well.
Cheers,
Joe
- Original Message -
From: Mark Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works
cfdirectory
name=getAllFolders
action="">
directory=#serverdir#
sort=name ASC
cfloop query = getAllFolders
cfdirectory
name=getAllFiles
action="">
directory=#serverdir##name#
sort=name ASC
cfquery dbtype=query name=getAllFiles_#name#
SELECT *
FROM getAllFiles
/cfquery
/cfloop
adieu
Mark
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Converting query to comma separated list
No problem Joe,I saw that you're CFC will do something that I need, and
when the page choked
But I downloaded it from CFZone, I'll let ya know how it works out.
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 01:37 pm
To: CF-Talk
Subject: Re: Converting query to comma separated list
Thanks Scott,
This pops up every 24-36 hours until I run a script to empty some
logs, as CF-Dynamics still hasn't completed a help desk ticket I left
with them a while back...
I'll be moving to a completely new service over the next few weeks,
and this should all go away.
Cheers,
Joe
- Original Message -
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 10:18:25 -0400
Subject: RE: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for
object 'clearsoftware_visitors' in database 'clearsoftware_net_01' because
the 'PRIMARY' filegroup is full.
The error occurred in
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc: line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
Called from D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc:
line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
19 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.firstName# /
20 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.lastName# /
21 : cfprocresult name=result maxrows=1 /
22 :/cfstoredproc
23 :
_
SQL
{call clearsoftware_createVisitor( (param 1) , (param 2) , (param 3) ,
(param 4) , (param 5) , (param 6) )}
DATASOURCE
clearsoftware_glass
VENDORERRORCODE
1105
SQLSTATE
HY000
Please try the following:
* Check the ColdFusion http://www.macromedia.com/go/proddoc_getdoc
documentation to verify that you are using the correct syntax.
* Search the Knowledge http://www.macromedia.com/support/coldfusion/
Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address
65.242.127.130
Referrer
Date/Time
23-Sep-04 09:21 AM
Stack Trace (click to expand) _javascript_:;
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called queryTool to my site (http://clearsoftware.net
- downloads - queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays, and structures.Perfectly free, seems
to work pretty well.
Cheers,
Joe
- Original Message -
From: Mark Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works
cfdirectory
name=getAllFolders
action="">
directory=#serverdir#
sort=name ASC
cfloop query = getAllFolders
cfdirectory
name=getAllFiles
action="">
directory=#serverdir##name#
sort=name ASC
cfquery dbtype=query name=getAllFiles_#name#
SELECT *
FROM getAllFiles
/cfquery
/cfloop
adieu
Mark
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Test (ignore)
Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
