User Control - SQL level
i'm looking for tips, suggestions, examples, codes for User Control/Access Control. But in SQL level. Example: Table: News User: CEO Rights: God(insert/update/delete) User: Manager Rights: insert/update User: Editor Rights: update How to implement this? - Original Message - From: S.Isaac Dealey [EMAIL PROTECTED] Date: Tue, 6 Jan 2004 22:20:43 -0600 To: CF-Talk [EMAIL PROTECTED] Subject: Re: SQL formatting question I have a table with column of phone numbers. The phone numbers have been entered in a number of different formats some containing . or - or /. Some with area codes with (). What I want to do is get them all the same. Now I can take all the records and get them all in a simple 10 digit sequence but I then want to convert them all to (123)456-7890 format. The field that houses the phone number is a varchar(50) field. I'd create a udf to convert the values in your db to the format you want for phone numbers... probably something like function phoneformat(num) { num = rereplace(num,[^0-9],,AlL); return (#left(num,3)#)#mid(num,4,3)#-#mid(num,7,4)#; } Once you've got that you can apply it prior to inserting or updating records and then rifle through the existing numbers in the database and set them all once just to make them all uniform and then from that point the insert/update templates will handle formatting. hth s. isaac dealey 214-823-9345 team macromedia volunteerhttp://www.macromedia.com/go/team chief architect, tapestry cmshttp://products.turnkey.to onTap is open sourcehttp://www.turnkey.to/ontap [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help: UPDATED
did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service. The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking for duplicate @ signs
Another option is to replace(@', '', string) and then compare the new string with the old. teh difference in length is the number of characters found. You'll have to experiment which one works the best. Jesse -Original Message- From: Scott Weikert [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 06 Jan 2004 21:22:38 -0700 Subject: Re: Looking for duplicate @ signs One issue with that is that ListLen() doesn't work too well when the delimiter used shows up twice in a row. For example blah@@blah.com would, I believe, return ListLen() of 2 - it wouldn't see there being a list entry between the @'s. I've been having this same issue with a project, bogus emails getting past validation. I haven't yet fully tested this solution... basically the idea is, do a Find() for an @, then do another Find() for an @ from the position of the last find, plus 1. If the second Find() returns a value, there's one too many @'s. At 09:13 PM 1/6/2004, you wrote: How about this? Basically, an email address can be seen as a list using the @ as a delimiter. If the listlen is 2, then it's legal. If not, then it's illegal. How illegal is determined below but a simple CFIF on the listlen() should be enough. I think that's what I do in my spam checker, or used to before I parsed the entire email address into it's component parts. Let me see if I can send you that. CFSWITCH _expression_=#ListLen(address, '@')# CFCASE value=1No @, invalid email/CFCASE CFCASE value=21 @, good email/CFCASE CFDEFUALTCASEmore than 1 @, very bad email/CFDEFAULTCASE /CFSWITCH Can someone tell me if this should work? I'm trying to look for duplicate @ signs in some email addresses. I was using the following code but it doesn't seem to work. According to the docs that should find 2 - 4 occurrences of the @ symbol but it always returns 0 even though I know there is at least one email that has multiples. cfset getDupes = ReFind(@{2,4}, embl_email) Thanks, Ben -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looking for duplicate @ signs
Another option is to replace(@', '', string) and then compare the new string with the old. teh difference in length is the number of characters found. You'll have to experiment which one works the best. Of course, you'd have to use the Replace function's parameters in the right order Replace(string, @, , all) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looking for duplicate @ signs
In Fact, Try This - cfset getDupes = ReFindNocase([\w\-\.]*(@)+[\w\-\.]*(@)+(\w)*, embl_email) This should return 1 if there are multiple @ characters(invalid), and 0 if there is just one(valid). --Milan From: Ben Densmore [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Looking for duplicate @ signs Date: Tue, 6 Jan 2004 18:59:13 -0500 Can someone tell me if this should work? I'm trying to look for duplicate @ signs in some email addresses. I was using the following code but it doesn't seem to work. According to the docs that should find 2 - 4 occurrences of the @ symbol but it always returns 0 even though I know there is at least one email that has multiples. cfset getDupes = ReFind(@{2,4}, embl_email) Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Administration Best Practices on Production Servers
Also one other thing to note -try as you might - your development environment may not always exactly matchyour hosted account, which means in some circumstances it may be beneficial to be able to switch debugging on/off programmatically to ensure your application is doing what you think it is doing. Kola -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 02 January 2004 00:46 To: CF-Talk Subject: RE: CF Administration Best Practices on Production Servers The problem is that unless the hosting provider automatically provides a testing environment which is a duplicate of production, you have no choice but do a certain amount of debugging in production.I've asked for a testing environment with each of the providers I've used, and none so far maintain a separate environment dedicated to testing. Andy -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 3:36 PM To: CF-Talk Subject: RE: CF Administration Best Practices on Production Servers It would be considered a best practice to turn off debugging on production servers, correct? My host has it turned on to help developers test their code. They insist I must turn it off using cfsetting. I've been arguing, unsuccessfully, that they should not allow people to test/develop their sites on production servers. So, am I completely off-base or is this considered bad? I would agree that it's a best practice to turn off debugging on production servers. I'm not sure that a shared server is necessarily a production server, though. After all, the hosting provider is basically giving you a place to do more or less whatever you want, right? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looking for duplicate @ signs
ofcourse. I'm always battling with coldfusion on the order of the arguements :) Jesse -Original Message- From: Philip Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 7 Jan 2004 06:47:25 -0500 Subject: RE: Looking for duplicate @ signs Another option is to replace(@', '', string) and then compare the new string with the old. teh difference in length is the number of characters found. You'll have to experiment which one works the best. Of course, you'd have to use the Replace function's parameters in the right order Replace(string, @, , all) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Administration Best Practices on Production Servers
On Wednesday 07 Jan 2004 11:52 am, Kola Oyedeji wrote: Also one other thing to note -try as you might - your development environment may not always exactly matchyour hosted account, which means in some circumstances it may be beneficial to be able to switch debugging on/off programmatically to ensure your application is doing what you think it is doing. Which is where log4cf from devNet comes into it's own :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help: UPDATED
i get the result i should from coldfusion yep there's no application.cfm, and the code is exactly as i posted :) On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service. The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
OnRequestEnd.cfm prehaps? :O) -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED i get the result i should from coldfusion yep there's no application.cfm, and the code is exactly as i posted :) On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Spectrum WebDesign said: i'm looking for tips, suggestions, examples, codes for User Control/Access Control. But in SQL level. Example: Table: News User: CEO Rights: God(insert/update/delete) User: Manager Rights: insert/update User: Editor Rights: update How to implement this? Use the GRANT command. For details, check your database manual. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help: UPDATED
nope :) On 7 Jan 2004, at 12:08, Adrian Lynch wrote: OnRequestEnd.cfm prehaps? :O) -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED i get the result i should from coldfusion yep there's no application.cfm, and the code is exactly as i posted :) On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service. The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking for duplicate @ signs
On Wednesday 07 Jan 2004 12:00 pm, Jesse Houwing wrote: ofcourse. I'm always battling with coldfusion on the order of the arguements Now if MM had a decent coder orientated IDE, or the community had time to hack at [the|a] Eclipse plugin... :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I access COM Object properties in CF
If memory serves me correct the last time I used the CFObject tag all it does is create an instance of the object and assigns a reference to a variable.So cfobject action="" type=COM class=some.object name=objref will create the object and return the reference. To set a property just cfset objref.parm = some value and to read a value you cfset parmvalue = objref.parm.To call a method you can cfset result = objref.method() __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Sam komolafe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 6:48 PM To: CF-Talk Subject: How do I access COM Object properties in CF Hi, How do I access COM Object properties using CFObject tag? Thank Sam --- [This E-mail scanned for viruses.] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
Damn, then I'm out of ideas. Just to be sure that no app.cfm is running, create a new one that's empty!! :OD If you trace the details of the returned error (status.details) you'll see the stack trace from CF, one of them mentions something like end or empty tag, might be worth asking if anyone knows what this relates to. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:09 To: CF-Talk Subject: Re: flash remoting help: UPDATED nope :) On 7 Jan 2004, at 12:08, Adrian Lynch wrote: OnRequestEnd.cfm prehaps? :O) -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED i get the result i should from coldfusion yep there's no application.cfm, and the code is exactly as i posted :) On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Thanx Jochem how to do using CF Is possible??? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Wed, 7 Jan 2004 13:08:23 +0100 (CET) To: CF-Talk [EMAIL PROTECTED] Subject: Re: User Control - SQL level Spectrum WebDesign said: i'm looking for tips, suggestions, examples, codes for User Control/Access Control. But in SQL level. Example: Table: News User: CEO Rights: God(insert/update/delete) User: Manager Rights: insert/update User: Editor Rights: update How to implement this? Use the GRANT command. For details, check your database manual. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Spectrum WebDesign said: Thanx Jochem how to do using CF Is possible??? SQL level permissions are set in the database. You can set them from CF though. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help: UPDATED
if you got an error from flash too, then could you give me a bit of code that does work for you then? and i will test it? just something simple! On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service. The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Anyway like easyconsole.cfm(http://www.easyconsole.com/easyconsole.cfm?id=39) logging settings - Original Message - From: Spectrum WebDesign [EMAIL PROTECTED] Date: Wed, 07 Jan 2004 09:16:07 -0300 To: CF-Talk [EMAIL PROTECTED] Subject: Re: User Control - SQL level Thanx Jochem how to do using CF Is possible??? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Wed, 7 Jan 2004 13:08:23 +0100 (CET) To: CF-Talk [EMAIL PROTECTED] Subject: Re: User Control - SQL level Spectrum WebDesign said: i'm looking for tips, suggestions, examples, codes for User Control/Access Control. But in SQL level. Example: Table: News User: CEO Rights: God(insert/update/delete) User: Manager Rights: insert/update User: Editor Rights: update How to implement this? Use the GRANT command. For details, check your database manual. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
Here's the code I had in the fla: #include NetServices.as NetServices.setDefaultGatewayUrl( http://lightwillrise.com:27000/flashservices/gateway http://lightwillrise.com:27000/flashservices/gateway ); conn = NetServices.createGatewayConnection(); conn.getService(cfcremoting.sendMe,this).sayHello(); function sayHello_Result(result) { trace(result); } function sayHello_Status(status) { trace(status.description); trace(status.details); } This was the line that interested me: at coldfusion.compiler.cfml40.endOrEmptyTag(cfml40.java:411) not sure if it has any significance though. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:36 To: CF-Talk Subject: Re: flash remoting help: UPDATED if you got an error from flash too, then could you give me a bit of code that does work for you then? and i will test it? just something simple! On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help: UPDATED
yeah i get teh same stack trace... could you give me a simple bit of cfc code that works for you...? On 7 Jan 2004, at 12:50, Adrian Lynch wrote: Here's the code I had in the fla: #include NetServices.as NetServices.setDefaultGatewayUrl( http://lightwillrise.com:27000/flashservices/gateway http://lightwillrise.com:27000/flashservices/gateway ); conn = NetServices.createGatewayConnection(); conn.getService(cfcremoting.sendMe,this).sayHello(); function sayHello_Result(result) { trace(result); } function sayHello_Status(status) { trace(status.description); trace(status.details); } This was the line that interested me: at coldfusion.compiler.cfml40.endOrEmptyTag(cfml40.java:411) not sure if it has any significance though. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:36 To: CF-Talk Subject: Re: flash remoting help: UPDATED if you got an error from flash too, then could you give me a bit of code that does work for you then? and i will test it? just something simple! On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service. The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
This is about as simple as it gets. cfcomponent cffunction name=myFunction access=remote returntype=string cfreturn Hella cool / /cffunction /cfcomponent Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:55 To: CF-Talk Subject: Re: flash remoting help: UPDATED yeah i get teh same stack trace... could you give me a simple bit of cfc code that works for you...? On 7 Jan 2004, at 12:50, Adrian Lynch wrote: Here's the code I had in the fla: #include NetServices.as NetServices.setDefaultGatewayUrl( http://lightwillrise.com:27000/flashservices/gateway http://lightwillrise.com:27000/flashservices/gateway http://lightwillrise.com:27000/flashservices/gateway ); conn = NetServices.createGatewayConnection(); conn.getService(cfcremoting.sendMe,this).sayHello(); function sayHello_Result(result) { trace(result); } function sayHello_Status(status) { trace(status.description); trace(status.details); } This was the line that interested me: at coldfusion.compiler.cfml40.endOrEmptyTag(cfml40.java:411) not sure if it has any significance though. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:36 To: CF-Talk Subject: Re: flash remoting help: UPDATED if you got an error from flash too, then could you give me a bit of code that does work for you then? and i will test it? just something simple! On 7 Jan 2004, at 11:50, Adrian Lynch wrote: You mean you got a result from the cfc via CF? I just tried the code and I got the same error in flash. How about starting afresh with different code. Are yuo sure that no Application.cfm file is running? The cfc code you posted, are you using variables in place of anything or is the code exactly as you showed us? Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:00 To: CF-Talk Subject: Re: flash remoting help: UPDATED did that and it worked fine :( On 7 Jan 2004, at 10:57, Adrian Lynch wrote: Application.cfm will be run too, make sure there's no code in there that might be causing problems. You might also want to call the function from a cfm page to make sure it's working. cfscript obj = CreateObject(component, sendme); cfscript cfdump var=#obj.sayHello()# / Put it in the same directory as the cfc and then browse it. Ade -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 22:38 To: CF-Talk Subject: Re: flash remoting help: UPDATED Changed the appropriate bit to: function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); conn = NetServices.createGatewayConnection(); service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('blah'); } init(); stop(); And it made no difference!! On 6/1/04 10:40 pm, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/ flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Spectrum WebDesign said: Anyway like easyconsole.cfm(http://www.easyconsole.com/easyconsole.cfm?id=39) logging settings Depends on your database. Some support logging, others don't. Check your database manual. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 and com objects
Sure, no problem. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 6:45 PM To: CF-Talk Subject: RE: CF MX 6.1 and com objects Thanks Steven, I was looking at that yesterday. But couldn't figure out how to achieve that, I'll have a play around with it this week and see what I can do. If you don't mind me contacting you again if I run into trouble. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 12:53 AM To: CF-Talk Subject: RE: CF MX 6.1 and com objects You probably do indeed have it working but not natively. .NET is the replacement for COM. COM has a different internal architecture from .NET and thus they are not compatibility natively. That is why you have to use the RCW which translates specific calls from managed clients into COM specific invocation requests on unmanaged COM components. Basically this makes the .NET components think they are talking to another .NET component. This is how it is implemented: Create a RCW out of the COM component Ref. the metadata assembly Dl lint he project and use its methods and properties You can do the RCW step using the Type Library Importer utility or the VS.Net IDE. Ex.) This generates metadata assembly with the name IopExampleRCW.dll out of the COM IopExamlple.dll Command line: tlbimp IopExample.dll /output:IopExampleRCW.dll /verbose In VS.NET IDE you would go to Project -Add Reference-COM tab... All of this is based on the fact that you have already registered the original COM component as well. Unless you register the original COM component none of this will work at all. This will work in all .Net invocations from C#, VB.NET and ASP.NET (et al.) http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:49 PM To: CF-Talk Subject: RE: CF MX 6.1 and com objects .Net does support com, I have it working here now. Secondly I am creating code that can be used by Windows Applications as well as ASP applications and coldfusion applications that will share common business logic. Blacknight does not support what I am trying to achive, so I am correct when I say I am not looking for a wrapper solution. Further discovery shows that I need to setup a DLLRegistrerServer or something. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Server and App status checking
Hello ALL, I was wondering what tools people are using to tell if their apps/server are running? We have a prod control department and would like to provide some interface that gives a readout of various servers/systems/application. Is the server up? Is the dbase up? Is app server running correctly? We currently use NTMange but were looking for something different. Thanks! - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Server and App status checking
We are using Servers Alive. http://www.woodstone.nu/salive/ I haven't tested any other, but this one works pretty good. - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: DeMarco, Alex [mailto:[EMAIL PROTECTED] | Sent: Wednesday, January 07, 2004 14:17 | To: CF-Talk | Subject: OT: Server and App status checking | | Hello ALL, | | I was wondering what tools people are using to tell if their | apps/server are running? | | We have a prod control department and would like to provide | some interface that gives a readout of various | servers/systems/application. | Is the server up? Is the dbase up? Is app server running correctly? | | We currently use NTMange but were looking for something different. | Thanks! | | - Alex | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I access COM Object properties in CF
Instantiating the object: -- cfobjectaction="" type=com class=Cybersource.ICS.3name=oICS Setting a few properties: -- cfset oICS.Log = True cfset oICS.LogPath = e:\ cfset oICS.LogSize = 10 Calling a method that sets properties: -- cfset oICS.SetValue (customer_firstName, #firstname#) cfset oICS.SetValue (customer_lastname, #lastname#) cfset oICS.SetValue (bill_country, #country#) Another method: cfset oICS.Send() Dan -Original Message- From: Sam komolafe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 6:48 PM To: CF-Talk Subject: How do I access COM Object properties in CF Hi, How do I access COM Object properties using CFObject tag? Thank Sam --- [This E-mail scanned for viruses.] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFContent Excel design woes
Are you using an html table? I've always been able to just do a border=1 and have the borders show up. I think you may need to look into Microsoft's awful CSS. Basically, what I've done in the past is build the worksheet as I want it to look in Excel, then save it as html and copy all the terrible microsoft code. Eeek. But, it works. -d - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:27 PM Subject: SOT: CFContent Excel design woes Okay, this is only slightly off topic but I don't know where else to look for answers. I built a spreadsheet export that uses CFContent to create an Excel spreadsheet.I'm using CSS in that file to border some of the cells to create a cleaner output look to the sheet.We've been testing it on Excel 2000 and everything works perfectly.Today the client looks at it and asks for lines.Turns out they're running Excel 97, and a screenshot confirmed their comment, there are no lines (cell borders) in the file. Anyone hear anything like this before?Any suggestions to correct the issue? Thanks! Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looking for duplicate @ signs
Thanks guys. Here is another question. Why the hell doesn't CFMAIL in CFMX ignore bad email addresses instead of throwing an error and stop all processing? We just upgraded our production server last week to CFMX 6.1 and went to send out a new product announcement last night. This is the same list of emails we used when we were at CF 5 and never had a problem. Last night I go to send out the email to the list and it sends out about 300 emails and then gets to an email that has a space in it and CF throws an error. So I use a Regex to strip out all the spaces and try sending again. Now it throws another error because several people had more than one @ symbol in their email address. So I write another RegEx so I can get rid of those emails. I try one more and then it breaks because there was a [ in someone's email. It should just ignore those emails or put them in the undeliverable folder rather than break. Think this should be submitted as a bug? Ben -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 7:11 AM To: CF-Talk Subject: Re: Looking for duplicate @ signs On Wednesday 07 Jan 2004 12:00 pm, Jesse Houwing wrote: ofcourse. I'm always battling with coldfusion on the order of the arguements Now if MM had a decent coder orientated IDE, or the community had time to hack at [the|a] Eclipse plugin... :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFContent Excel design woes
Will the HTMLtoExcel tag fit your needs? Dan Okay, this is only slightly off topic but I don't know where else to look for answers. I built a spreadsheet export that uses CFContent to create an Excel spreadsheet.I'm using CSS in that file to border some of the cells to create a cleaner output look to the sheet.We've been testing it on Excel 2000 and everything works perfectly.Today the client looks at it and asks for lines.Turns out they're running Excel 97, and a screenshot confirmed their comment, there are no lines (cell borders) in the file. Anyone hear anything like this before?Any suggestions to correct the issue? Thanks! Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Credit Card Processing
I know someone on the list mentioned a couple of months ago that they worked for a credit card processing company and they would offer a free setup to anyone on the list.Does anyone remember who this is or have other credit card processing companies that are good to use and not too expensive?Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Credit Card Processing
We have a custom tag that utilized CDGCommerce whom we have used for many years ..they have free setup with a merchant account and good rates. http://www.quilldesign.com/cdg I hope this helps, good luck Paul Giesenhagen QuillDesign - Original Message - From: Burns, John To: CF-Talk Sent: Wednesday, January 07, 2004 8:17 AM Subject: Credit Card Processing I know someone on the list mentioned a couple of months ago that they worked for a credit card processing company and they would offer a free setup to anyone on the list.Does anyone remember who this is or have other credit card processing companies that are good to use and not too expensive?Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFContent Excel design woes
Hatton, Excel 97 doesn't support css.You have to use font tags, table borders, etc. I believe (though I'm not positive) that all of the Office 97 products only support HTML 3 and earlier, but you will want to check Microsoft's website to verify this. Steve -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: SOT: CFContent Excel design woes Okay, this is only slightly off topic but I don't know where else to look for answers. I built a spreadsheet export that uses CFContent to create an Excel spreadsheet.I'm using CSS in that file to border some of the cells to create a cleaner output look to the sheet.We've been testing it on Excel 2000 and everything works perfectly.Today the client looks at it and asks for lines.Turns out they're running Excel 97, and a screenshot confirmed their comment, there are no lines (cell borders) in the file. Anyone hear anything like this before?Any suggestions to correct the issue? Thanks! Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looking for duplicate @ signs
Ben Densmore said: Thanks guys. Here is another question. Why the hell doesn't CFMAIL in CFMX ignore bad email addresses instead of throwing an error and stop all processing? Because somebody choose the current behaviour. It should just ignore those emails or put them in the undeliverable folder rather than break. Think this should be submitted as a bug? No. I much prefer this behaviour over the previous behaviour. Just cftry/cfcatch them and remove them from your database. Especially for hosted sites this works much better. Let the customer deal with his own bad data instead of having the hoster parse everything that ends up in the undeliverable folder. It is better for all involved. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Random scheduled page
I need to have a CF page run at a random time between 8 and 10 a.m. once a day. Any suggestions on how to do this? Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Random scheduled page
Schedule a page to run daily at 7 AM. This page will schedule a new event for the random time. Before making the new event, though, you would delete yesterday's random event. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Random scheduled page
Write the page to do what you need, then update the schedule with cfschedule and make the start time random within the next 24 hours. Just a thought mind. Ade -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 14:43 To: CF-Talk Subject: Random scheduled page I need to have a CF page run at a random time between 8 and 10 a.m. once a day. Any suggestions on how to do this? Phillip B. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Random scheduled page
You could set up a scheduled task to run at say 7am, all this task would do would be to generate the random time between 8 and 10am and then update the actual task using cfschedule to next run at the time that has just been generated. Alex -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 14:43 To: CF-Talk Subject: Random scheduled page I need to have a CF page run at a random time between 8 and 10 a.m. once a day. Any suggestions on how to do this? Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
fancy multipart email
howdy folks! I'm looking at sending mulitpart emails, ones that include images mime encoded (base 64) within the email.I'm using CFMX 6.1.From what I have read around already, this appears to be impossible to do.(see Jochem's notes on his email custom tag)Has anyone got anywher on this? It appears this can be doen using Java, but then this by-passes the fancy CF email engine.Thoughts anyone? -- Douglas Knudsen Alltel ACI IT Rapid Response Team ole0.bmp ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:flash remoting help: UPDATED
rant maybe you could edit your reply so we dont get the infinite-scroll page :) /rant well I copy/pasted your code and it works just fine... it came to me to give it a test via CFM with web services (any CFC with access = remoteis a webservice)... so I typed: http://lightwillrise.com:27000/cfcremoting/sendMe.cfc?wsdl and I get: Invalid CFML construct found on line 23 at column 17. The error occurred in D:\WWWRoot\DefaultSite\www\CFIDE\administrator\cfcremoting\sendMe.cfc: line 23 21 : 22 : cfset s = blah 23 : cfreturn s 24 : 25 : /cffunction I believe that line 23 should read cfset s = blah Missing a ? Mauricio [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: BD 6.1 and mySQL
When you do Verify Datasources from the BlueDragon admin console, what is the error message you get back? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:46 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL OK, but how do I do that. I'm sorry if I sound dumb, but I've had to mess with command line utilities 3 times since windows was release so I am more than a little rusty (it took me 4.5 hours to get mySQL online). As I said before, I am able to connect to the db server from my machine using mySQL-Front (graphic db admin tool), so I must have allowed the remote access when I did my original install. Cutter Steven Erat wrote: MySQL has default security restrictions that typically don't allow remote hosts to connect.A quick and dirty test would be to modify the mysql start script and add an argument for --skip-grant-tables such as: $bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . .Then restart mysqld. If that works, then the more graceful solution is to first remove that argument then adjust the grant tables on the databases used from the remote host. HTH _ From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:16 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faq Id=216 http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?fa qId=216 Can you connect using the MySQL command line tool from the same host using the same parameters? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Wait, wait please. All users for my application will need to create in MySQL DB Server User Manager? It's so difficult?? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Wed, 7 Jan 2004 13:18:28 +0100 (CET) To: CF-Talk [EMAIL PROTECTED] Subject: Re: User Control - SQL level Spectrum WebDesign said: Thanx Jochem how to do using CF Is possible??? SQL level permissions are set in the database. You can set them from CF though. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Random scheduled page
*smacks forehead* This is why I don't write books about ColdFusion. Thanks :-) Phillip B. Raymond Camden wrote: Schedule a page to run daily at 7 AM. This page will schedule a new event for the random time. Before making the new event, though, you would delete yesterday's random event. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Random scheduled page
FYI, Phillip, this is like my suggestion, except I forgot you could update a task. Don't do what I said and delete/readd, just update the random scheduled task. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Flash Remoting with Blue Dragon
Is it possible to use Flash Remoting with Blue Dragon?I know there is a remoting gateway install for asp and the default one comes with CFMX, but is this something that Blue Dragon cannot replicate due to licensing or will one of the Macromedia ones work with it?I'm just curious if Blue Dragon can only be used with standard CFML or if you'll be able to integrate into Flash.Any thoughts would be helpful. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: User Control - SQL level
Spectrum WebDesign said: Wait, wait please. All users for my application will need to create in MySQL DB Server User Manager? It's so difficult?? If you wish to control them at that level, you need to configure them at that level. If you wish to control them in the application layer, you need to configure them in the application layer. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: BD 6.1 and mySQL
Verifying [insert db name here] General SQL Error Any help is greatly appreciated. Cutter Vince Bonfanti wrote: When you do Verify Datasources from the BlueDragon admin console, what is the error message you get back? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:46 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL OK, but how do I do that. I'm sorry if I sound dumb, but I've had to mess with command line utilities 3 times since windows was release so I am more than a little rusty (it took me 4.5 hours to get mySQL online). As I said before, I am able to connect to the db server from my machine using mySQL-Front (graphic db admin tool), so I must have allowed the remote access when I did my original install. Cutter Steven Erat wrote: MySQL has default security restrictions that typically don't allow remote hosts to connect.A quick and dirty test would be to modify the mysql start script and add an argument for --skip-grant-tables such as: $bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . .Then restart mysqld. If that works, then the more graceful solution is to first remove that argument then adjust the grant tables on the databases used from the remote host. HTH _ From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:16 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faq Id=216 http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?fa qId=216 Can you connect using the MySQL command line tool from the same host using the same parameters? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help: UPDATED
you are a star! the problem wasnt with the script as such, i had fixed that error earlier, but i had set teh default mapping / to a directory other than that, and as such thought that i should put the script in the place the mapping specified... i guess not after all! On 7 Jan 2004, at 13:52, Mauricio Giraldo wrote: rant maybe you could edit your reply so we dont get the infinite-scroll page :) /rant well I copy/pasted your code and it works just fine... it came to me to give it a test via CFM with web services (any CFC with access = remote is a webservice)... so I typed: http://lightwillrise.com:27000/cfcremoting/sendMe.cfc?wsdl and I get: Invalid CFML construct found on line 23 at column 17. The error occurred in D:\WWWRoot\DefaultSite\www\CFIDE\administrator\cfcremoting\sendMe.cfc: line 23 21 : 22 : cfset s = blah 23 : cfreturn s 24 : 25 : /cffunction I believe that line 23 should read cfset s = blah Missing a ? Mauricio [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cold Fusion Web Developer/Programmer Position - Kansas City Area
Cold Fusion Web Developer/Programmer Position - Kansas City Area Uhlig Communications, Inc., is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please email resume to [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_Image
Can anyone point me to the web-site of the Author of CFX_Image?My hosting company needs to download the copy itself to verify and approve it's use. Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: fancy multipart email
I am using CFMX Version 6,1,0,63958 and have been sending Multipart Email Messages through Coldfusion for the past 3 months without any problems. Now one thing that I do which is different than everyone else, is I do not use cfmail to handle this task. I have been using a Freeware piece of software created by Intrafoundation Software which does ALL of my POP3/SMTP Routines and can do HTTP, IMAP, NNTP, FTP, WHOIS, FINGER, etc. At one point I had issues like alot of others with cfmail and moved to this piece of software almost 2 years now and have had no problems since. I have just recently configured a cfm page to send multipart emails with this software. URL: www.introfoundation.com/tcpclient.asp On Wed, 7 Jan 2004 08:49:45 -0600, Douglas.Knudsen wrote howdy folks! I'm looking at sending mulitpart emails, ones that include images mime encoded (base 64) within the email. I'm using CFMX 6.1. From what I have read around already, this appears to be impossible to do. (see Jochem's notes on his email custom tag) Has anyone got anywher on this? It appears this can be doen using Java, but then this by-passes the fancy CF email engine. Thoughts anyone? -- Douglas Knudsen Alltel ACI IT Rapid Response Team ole0.bmp ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion Web Developer/Programmer Position - Kansas City Area
Justin Hansen said: Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Has it even been that long? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_Image
http://www.kolumbus.fi/jukka.manner/ -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 15:21 To: CF-Talk Subject: CFX_Image Can anyone point me to the web-site of the Author of CFX_Image? My hosting company needs to download the copy itself to verify and approve it's use. Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_Image
I'm not sure of the original site but I have the tag and full docs on my site. The developer's info should be in there. http://relativepath.net/cfximage/ Dan Phillips CFXHosting.com 866.239.4678 x112 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:21 AM To: CF-Talk Subject: CFX_Image Can anyone point me to the web-site of the Author of CFX_Image?My hosting company needs to download the copy itself to verify and approve it's use. Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with returning/rendering large-ish recordsets
Hi folks, I'm attempting to troubleshoot a problem that is occurring on one, and only one, of two similarly configured servers. I say similarly, because one (the Development server) is running Windows Server 2003 and the other (the Testing server) is running W2K. Both are running MX 6.1 and SQL Server 2000 with the latest service packs. The production environment naturally splits the database and Web/CF stuff into two machines, but the Dev and Test servers are combos. Here's what's happening: I run a stored procedure to retrieve records; when there are few records returned (50-100), all is well on both machines. However, when there are a few hundred (or a few thousand) matches, there's a problem on the Test server. The rendered page never comes back, and eventually I get a Cannot find server or DNS error message from the browser. On the Dev server, the page returns fine, and relatively quickly. I am seeing the same behavior when running other procs/pages which return larger recordsets. The databases and procedures on both machines are precisely the same, as is the CF code. When I run sample parameters to the proc in Query Analyzer which result in some 5800 records being returned, the query actually returns results on the Test server (where the problem occurs) twice as quickly as on the Dev machine. So I assume the bottleneck is not in the database operation, but somewhere further along. Datasources are set up identically in both CF Admins. Has anyone run into this problem of difficulty in displaying large recordsets, or can someone please suggest a path along which I might begin troubleshooting? I've tried searches in the MM KnowledgeBase and on Google with no luck -- but it's hard to be specific enough with search terms in this case. -- Thanks, Tom Tom McNeer MediumCool A Marketing, Creative and Construction Company for the World Wide Web 530 Means St NW, Suite 110 Atlanta, GA 30318 404-589-0560 FAX 404-589-0510 http://www.mediumcool.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cold Fusion Web Developer/Programmer Position - Kansas City Area
No, but you get the idea. I'm looking for CFC experienced developers. LOL: I got the same response form the local user group. Give a guy a break. Justin Hansen Project Manager Uhlig Communications _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:28 AM To: CF-Talk Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City Area Justin Hansen said: Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Has it even been that long? Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: fancy multipart email
Graham, On 1/7/2004 at 10:27, you wrote: GP URL: www.introfoundation.com/tcpclient.asp http://intrafoundation.com/tcpclient.asp ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: fancy multipart email
it's doable via CFMail.I have a page that works for me built off the old emailer in CF.I'm not sure it will work for ten of thousand emails at a time since I only send out a couple thousand at a time max. see below: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
Just curious, OOP doesn't really apply to CF so why the OOP stuff? I have read all the crud where people say CFC's are like OOP but it just isn't true. Now OOP concepts may have been a better choice of words because that would imply the ability to understand the reasons why but not necessarily the implementation of such concepts. I suppose people could say that CFC's make you think about reuse but to be honest when I programmed in C (well before C++ caught on) I was using code reuse and nobody called it OOP. I had libraries built for all kinds of off the wall crud. But what do I knownot meant to diss the post just a thought I had as I glanced over it. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:18 AM To: CF-Talk Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area Cold Fusion Web Developer/Programmer Position - Kansas City Area Uhlig Communications, Inc., is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please email resume to [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_Image
Dan, This looks different from the one that I have.Mine is called cfx_image_mx.dll and is about half the size.Does yours work well?If so, perhaps I'll switch because yours has a documented and accessible author that HostCentric should accept. Andy -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:29 AM To: CF-Talk Subject: RE: CFX_Image I'm not sure of the original site but I have the tag and full docs on my site. The developer's info should be in there. http://relativepath.net/cfximage/ Dan Phillips CFXHosting.com 866.239.4678 x112 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:21 AM To: CF-Talk Subject: CFX_Image Can anyone point me to the web-site of the Author of CFX_Image?My hosting company needs to download the copy itself to verify and approve it's use. Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion Web Developer/Programmer Position - Kansas City Area
If you are looking for Excellent organizational, communication, and interpersonal skills perhaps you would better impress potential candidates by paying closer attention to the requirement of Qualified individuals will have 3+ years experience developing: ColdFusionMX applications.The product has not been out that long, therefore no one would be qualified for your offered position.. Inaccurate job announcements tend to get you applicants who are either not qualified or have to lie on their application.That is not a good thing, IMHO I would assume you are looking for a CF developer of 3+ years, AND with CFMX experience, huh? Coding being such an exact science, I personally tend to look at job announcements in a literal sense, and If I were looking, I probably would not respond to your post. == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == Aspire to Inspire before you Retire or Expire! - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:17 AM Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area : Cold Fusion Web Developer/Programmer Position - Kansas City Area : : : : Uhlig Communications, Inc., is an advanced-technology publishing company : specializing in variable-data printing. : : : : We are offering an outstanding career opportunity for a Web : Developer/Programmer with exceptional Programming and Application : Development experience. As a Developer, you will take part in the : design, programming, testing and implementation of highly innovative, : new publishing concepts. : : : : Qualified individuals will have 3+ years experience developing : ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML : OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus. : : : : : Excellent organizational, communication, and interpersonal skills. Must : be team player, able to work independently (manage own work effectively, : show initiative, able to focus and prioritize) but seek assistance : readily when needed. A strong record of delivering projects on schedule : is key. : : : : We offer competitive compensation and benefits including 401(k) with : matching and a culture that fosters business and professional growth. We : work in a modern, high-technology office environment, and offer generous : opportunities for continuing work-related education and career : advancement. EOE : : : : Qualified individuals please email resume to [EMAIL PROTECTED] : : : : : [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: BD 6.1 and mySQL
Can you send me (privately, not to the list), the following: - bluedragon.xml (from the config directory) - bluedragon.log (from the work directory) - the error page that's generated when you try to run a CFML page that contains a CFQUERY that references your MySQL datasource; you'll be able to find this in the work\temp\rtelogs directory; make sure you don't have your own error page configured via CFERROR, so that BlueDragon will generate a complete error page Vince Bonfanti v mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:03 AM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL Verifying [insert db name here] General SQL Error Any help is greatly appreciated. Cutter Vince Bonfanti wrote: When you do Verify Datasources from the BlueDragon admin console, what is the error message you get back? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:46 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL OK, but how do I do that. I'm sorry if I sound dumb, but I've had to mess with command line utilities 3 times since windows was release so I am more than a little rusty (it took me 4.5 hours to get mySQL online). As I said before, I am able to connect to the db server from my machine using mySQL-Front (graphic db admin tool), so I must have allowed the remote access when I did my original install. Cutter Steven Erat wrote: MySQL has default security restrictions that typically don't allow remote hosts to connect.A quick and dirty test would be to modify the mysql start script and add an argument for --skip-grant-tables such as: $bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . .Then restart mysqld. If that works, then the more graceful solution is to first remove that argument then adjust the grant tables on the databases used from the remote host. HTH _ From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:16 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faq Id=216 http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?fa qId=216 Can you connect using the MySQL command line tool from the same host using the same parameters? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
Since they're using MX, then they may likely be looking at writing supporting framework(s) in J2EE, which would certainly benefit from a developer with Object-Oriented development experience. - Jim Schuster, Steven wrote: Just curious, OOP doesn't really apply to CF so why the OOP stuff? I have read all the crud where people say CFC's are like OOP but it just isn't true. Now OOP concepts may have been a better choice of words because that would imply the ability to understand the reasons why but not necessarily the implementation of such concepts. I suppose people could say that CFC's make you think about reuse but to be honest when I programmed in C (well before C++ caught on) I was using code reuse and nobody called it OOP. I had libraries built for all kinds of off the wall crud. But what do I knownot meant to diss the post just a thought I had as I glanced over it. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:18 AM To: CF-Talk Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area Cold Fusion Web Developer/Programmer Position - Kansas City Area Uhlig Communications, Inc., is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please email resume to [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_Image
Thanks. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:22 AM To: CF-Talk Subject: RE: CFX_Image http://www.kolumbus.fi/jukka.manner/ -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 15:21 To: CF-Talk Subject: CFX_Image Can anyone point me to the web-site of the Author of CFX_Image? My hosting company needs to download the copy itself to verify and approve it's use. Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_Image
Yeah there are a few different versions floating around there. I pretty much stick to that one since I have all the docs on it. Seems that everytime someone starts to use that tag, conflicting info gets thrown around because of the different versions so CFX just sticks with that one. We have that tag installed on all of our servers. Dan Phillips CFXHosting.com 866.239.4678 x112 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:45 AM To: CF-Talk Subject: RE: CFX_Image Dan, This looks different from the one that I have.Mine is called cfx_image_mx.dll and is about half the size.Does yours work well?If so, perhaps I'll switch because yours has a documented and accessible author that HostCentric should accept. Andy -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:29 AM To: CF-Talk Subject: RE: CFX_Image I'm not sure of the original site but I have the tag and full docs on my site. The developer's info should be in there. http://relativepath.net/cfximage/ Dan Phillips CFXHosting.com 866.239.4678 x112 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:21 AM To: CF-Talk Subject: CFX_Image Can anyone point me to the web-site of the Author of CFX_Image?My hosting company needs to download the copy itself to verify and approve it's use. Andy Ousterhout O'My Goodness Cookies www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Best Practices for configuration file dependencies?
Hi, In my current development environment we have 4 levels of deploying apps: - actual coding takes place on the developer's workstation - daily builds are deployed to a development server - testing builds are deployed to a testing cluster - production builds are deployed to the production cluster What I'm running into is that we have some interdependencies between apps that run on different domains. An action by a user in foo.com may redirect them to bar.com. What I would like is that when I'm viewing dev.foo.com (an Apache virtual host on the development server) the action would send the user to dev.foo.com rather than the production foo.com. I dimly remember that in the Java world, Ant can be used to change deployment settings like this. Has anyone done anything similar in CF? One solution I've been contemplating is a global config file that would list local, development, testing, and production settings for each website. These would be loaded into Application.cfm. Then when a script needed to redirect somewhere it would pull the appropriate variable from the loaded config file. I could either set the appropriate configration data set according to a variable in Application.cfm, or hard code the data set choice to be dependent on the machine name. Any other ideas? -- Howard Fore, [EMAIL PROTECTED] The basic tool for the manipulation of reality is the manipulation of words.If you can control the meaning of words, you can control the people who must use the words. (Philip K. Dick) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
Ahh, if that is the case they will need to add JAVA and JSP to the list as well then. But it wasn't mentioned. If I was looking for a .NET developer I would expect them to know the framework, C#, VB, etc. But if all I wanted was a C# coder I would only expect them to know the framework and C#. I guess it's all just semantics Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:50 AM To: CF-Talk Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A rea Since they're using MX, then they may likely be looking at writing supporting framework(s) in J2EE, which would certainly benefit from a developer with Object-Oriented development experience. - Jim Schuster, Steven wrote: Just curious, OOP doesn't really apply to CF so why the OOP stuff? I have read all the crud where people say CFC's are like OOP but it just isn't true. Now OOP concepts may have been a better choice of words because that would imply the ability to understand the reasons why but not necessarily the implementation of such concepts. I suppose people could say that CFC's make you think about reuse but to be honest when I programmed in C (well before C++ caught on) I was using code reuse and nobody called it OOP. I had libraries built for all kinds of off the wall crud. But what do I knownot meant to diss the post just a thought I had as I glanced over it. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:18 AM To: CF-Talk Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area Cold Fusion Web Developer/Programmer Position - Kansas City Area Uhlig Communications, Inc., is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please email resume to [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFX_Image
http://www.kolumbus.fi/jukka.manner/ == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == Aspire to Inspire before you Retire or Expire! - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:21 AM Subject: CFX_Image : Can anyone point me to the web-site of the Author of CFX_Image?My hosting : company needs to download the copy itself to verify and approve it's use. : : Andy Ousterhout : O'My Goodness Cookies : www.omygoodness.com : 910 Sherwood Drive, Unit 19 : Lake Bluff, IL 60044 : : Phone 847.735.9890 : Fax847.735.9910 : Yahoo IM:andy_ousterhout : : : [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Dreamweaver oddity
For some odd reason, when I click the button to add td/td on a page it doesn't add the closing on the closing td td/td. Is there an easy way to fix this? I'm using Dreamweaver MX 04. Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cfqueryparam bug and finding it globally.
Hi all, I wrote a directory spider that recursively finds all pages on my server in all sites that have the cfqueryparam bug with using functions in the value attributes value. What I want to do is be able to determine the line number of the offending cfqueryparam tag. Does anyone have any thoughts? It doesn't have to be a CF solution another solution is fine also. I want to find the line numbers of all cfqueryparams that have a function in the value attribute. Thanks Bryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with returning/rendering large-ish recordsets
Same ODBC driver and version? Jamie On Wed, 7 Jan 2004 10:30:52 -0500, in cf-talk you wrote: Hi folks, I'm attempting to troubleshoot a problem that is occurring on one, and only one, of two similarly configured servers. I say similarly, because one (the Development server) is running Windows Server 2003 and the other (the Testing server) is running W2K. Both are running MX 6.1 and SQL Server 2000 with the latest service packs. The production environment naturally splits the database and Web/CF stuff into two machines, but the Dev and Test servers are combos. Here's what's happening: I run a stored procedure to retrieve records; when there are few records returned (50-100), all is well on both machines. However, when there are a few hundred (or a few thousand) matches, there's a problem on the Test server. The rendered page never comes back, and eventually I get a Cannot find server or DNS error message from the browser. On the Dev server, the page returns fine, and relatively quickly. I am seeing the same behavior when running other procs/pages which return larger recordsets. The databases and procedures on both machines are precisely the same, as is the CF code. When I run sample parameters to the proc in Query Analyzer which result in some 5800 records being returned, the query actually returns results on the Test server (where the problem occurs) twice as quickly as on the Dev machine. So I assume the bottleneck is not in the database operation, but somewhere further along. Datasources are set up identically in both CF Admins. Has anyone run into this problem of difficulty in displaying large recordsets, or can someone please suggest a path along which I might begin troubleshooting? I've tried searches in the MM KnowledgeBase and on Google with no luck -- but it's hard to be specific enough with search terms in this case. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cfqueryparam bug and finding it globally.
Not sure how to go after the line numbersbut what's the bug? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Wednesday, January 07, 2004 8:15 AM Subject: Cfqueryparam bug and finding it globally. Hi all, I wrote a directory spider that recursively finds all pages on my server in all sites that have the cfqueryparam bug with using functions in the value attributes value. What I want to do is be able to determine the line number of the offending cfqueryparam tag. Does anyone have any thoughts? It doesn't have to be a CF solution another solution is fine also. I want to find the line numbers of all cfqueryparams that have a function in the value attribute. Thanks Bryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
if you are using homesite, then you could do a find in files and point it to the root directory and include subdirs? HTH -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 7, 2004 16:16 To: CF-Talk Subject: Cfqueryparam bug and finding it globally. Hi all, I wrote a directory spider that recursively finds all pages on my server in all sites that have the cfqueryparam bug with using functions in the value attributes value. What I want to do is be able to determine the line number of the offending cfqueryparam tag. Does anyone have any thoughts? It doesn't have to be a CF solution another solution is fine also. I want to find the line numbers of all cfqueryparams that have a function in the value attribute. Thanks Bryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: fancy multipart email
If you're on 6.1, Why aren't you using CFMAILPART? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb3.htm#wp27 32354 Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cfqueryparam bug and finding it globally.
Just a thought, but you could probably look at MX's Code Analyzer in the CFMX Administrator, if it isn't encrypted or some kind of Java CFX. - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Wednesday, January 07, 2004 11:15 AM Subject: Cfqueryparam bug and finding it globally. Hi all, I wrote a directory spider that recursively finds all pages on my server in all sites that have the cfqueryparam bug with using functions in the value attributes value. What I want to do is be able to determine the line number of the offending cfqueryparam tag. Does anyone have any thoughts? It doesn't have to be a CF solution another solution is fine also. I want to find the line numbers of all cfqueryparams that have a function in the value attribute. Thanks Bryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Nested CFLoop problem
I can't seem to make the 1st loop to move to the next record. Am I missing something? Below is the code snippet. cfloop query=GetExample startrow=1endrow=#GetExample.recordcount# cfloop query=translation_liststartrow=1 endrow=#translation_list.recordcount# cfif GetExample.kod_gt eq translation_list.dept_code cfoutput#GetExample.kod_gt#nbsp;nbsp;#translation_list.nalis_code#br/ cfoutput /cfif /cfloop /cfloop The ouput I'm getting is TLR100test1 TRL100test1 Thanks in advance. Nyon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cfqueryparam bug and finding it globally.
Look into grep on unix, findstr on windows. Finstr's regex isn't as good as unix's, of course, so you may want to pipe the results of findstr to a file, and use some CF regex on that. Jamie On Wed, 7 Jan 2004 11:15:42 -0500, Bryan F. Hogan [EMAIL PROTECTED] wrote: Hi all, I wrote a directory spider that recursively finds all pages on my server in all sites that have the cfqueryparam bug with using functions in the value attributes value. What I want to do is be able to determine the line number of the offending cfqueryparam tag. Does anyone have any thoughts? It doesn't have to be a CF solution another solution is fine also. I want to find the line numbers of all cfqueryparams that have a function in the value attribute. Thanks Bryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nested CFLoop problem
have ya done a cfdump on the first query to make sure your data is correct? I like to do this first just to make sure. then make the first loop work.then make the second loop work.do it in pieces to nail down the problem. tw -Original Message- From: YC Nyon [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:44 AM To: CF-Talk Subject: Nested CFLoop problem I can't seem to make the 1st loop to move to the next record. Am I missing something? Below is the code snippet. cfloop query=GetExample startrow=1endrow=#GetExample.recordcount# cfloop query=translation_liststartrow=1 endrow=#translation_list.recordcount# cfif GetExample.kod_gt eq translation_list.dept_code cfoutput#GetExample.kod_gt#nbsp;nbsp;#translation_list.nalis_code#br/ cfoutput /cfif /cfloop /cfloop The ouput I'm getting is TLR100test1 TRL100test1 Thanks in advance. Nyon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
Using functions inside the cfqueryparams that have the value of cf_sql_varchar, cf_sql_longvarchar causes single quotes to double up. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:20 AM To: CF-Talk Subject: Re: Cfqueryparam bug and finding it globally. Not sure how to go after the line numbersbut what's the bug? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
I'll try that. Thanks -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:24 AM To: CF-Talk Subject: RE: Cfqueryparam bug and finding it globally. if you are using homesite, then you could do a find in files and point it to the root directory and include subdirs? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
Nice. ;) -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:28 AM To: CF-Talk Subject: Re: Cfqueryparam bug and finding it globally. Just a thought, but you could probably look at MX's Code Analyzer in the CFMX Administrator, if it isn't encrypted or some kind of Java CFX. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
Interesting, I'll look into it. Thanks -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:38 AM To: CF-Talk Subject: Re: Cfqueryparam bug and finding it globally. Look into grep on unix, findstr on windows. Finstr's regex isn't as good as unix's, of course, so you may want to pipe the results of findstr to a file, and use some CF regex on that. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nested CFLoop problem
When you loop through 2 queries like this, when you refernce a row in the outer query from inside the inner query it will always use the first row! This is a known feature in CF. You can either set local variables: cfloop query=GetExample cfset this_kod_gt = GetExample.kod_gt cfloop query=translation_list cfif this_kod_gt eq translation_list.dept_code or use the array notation to explicitely reference the row: cfloop query=GetExample cfset outerloopRowNum = GetExample.currentrow cfloop query=translation_list cfif GetExample.kod_gt[outerloopRowNum] eq translation_list.dept_code HTH Bert ps in the secind example its possible you don't need to set a local var for the current row, but i can't check right now... -Original Message- From: YC Nyon [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:44 AM To: CF-Talk Subject: Nested CFLoop problem I can't seem to make the 1st loop to move to the next record. Am I missing something? Below is the code snippet. cfloop query=GetExample startrow=1endrow=#GetExample.recordcount# cfloop query=translation_liststartrow=1 endrow=#translation_list.recordcount# cfif GetExample.kod_gt eq translation_list.dept_code [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cfqueryparam bug and finding it globally.
hI use PreserveSingleQuotes() anyways due to SQL Serverguess I'm GTG ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Wednesday, January 07, 2004 8:51 AM Subject: RE: Cfqueryparam bug and finding it globally. Using functions inside the cfqueryparams that have the value of cf_sql_varchar, cf_sql_longvarchar causes single quotes to double up. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:20 AM To: CF-Talk Subject: Re: Cfqueryparam bug and finding it globally. Not sure how to go after the line numbersbut what's the bug? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
In cf5, you can do a search and then save it as a text file.Right click on your search and say save as.Then you could loop that list in coldfusion, do a cffile on that file, do a substring to the position given in the text file, then count the chr13s that occur in that substring.I think that would give you the line no. DRE -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:52 AM To: CF-Talk Subject: RE: Cfqueryparam bug and finding it globally. Interesting, I'll look into it. Thanks -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:38 AM To: CF-Talk Subject: Re: Cfqueryparam bug and finding it globally. Look into grep on unix, findstr on windows. Finstr's regex isn't as good as unix's, of course, so you may want to pipe the results of findstr to a file, and use some CF regex on that. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
er, studio 5 DRE -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:01 AM To: CF-Talk Subject: RE: Cfqueryparam bug and finding it globally. In cf5, you can do a search and then save it as a text file.Right click on your search and say save as.Then you could loop that list in coldfusion, do a cffile on that file, do a substring to the position given in the text file, then count the chr13s that occur in that substring.I think that would give you the line no. DRE -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:52 AM To: CF-Talk Subject: RE: Cfqueryparam bug and finding it globally. Interesting, I'll look into it. Thanks -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:38 AM To: CF-Talk Subject: Re: Cfqueryparam bug and finding it globally. Look into grep on unix, findstr on windows. Finstr's regex isn't as good as unix's, of course, so you may want to pipe the results of findstr to a file, and use some CF regex on that. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cfqueryparam bug and finding it globally.
On Wednesday 07 Jan 2004 16:38 pm, Jamie Jackson wrote: Look into grep on unix, findstr on windows. Finstr's regex isn't as good as unix's, Though there are many ways to get GNU grep onto Win32. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CMS Solutions (Friendly URL's)
While we're on the subject - does anyone know of any good resources/mailings lists - I've been out of the SEO loop for a while Thanks Kola -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 02 January 2004 21:02 To: CF-Talk Subject: Re: CMS Solutions (Friendly URL's) Good points all, John. I was indeed taking a very simplistic view of the length of the string. And something I haven't given a lot of thought to was the depth of the folders.Very interesting. p.s. it would also help if you repeat that info in the title tag as well as in a h1 near the top of the page. By and large we're doing that, but we've played around with alternatives on non-critical pages.It *seems* -- and take this single-source anecdotal experience for what its worth -- that keywords in the filename alone are the single largest determining factor in elevating placement. Maybe a top-10 ranking on that alone. Add in the meta title and you're a solid candidate for #1.Make it the title of the page as well (we use a named style rather than tying a style to h1, but thats a *great* idea) and, so far, we're hitting #1 consistently. And as I'm sure you know this won't happen for hotly contested keywords. ColdFusion, for example.The trick is of course to pick something attainable, useful to the client and searched-upon. Your points on SE marketing are right on.I think the marketing side gets short shrift from the tech side, but marketing is very often the reason a commercial site exists in the first place. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion Web Developer/Programmer Position - Kansas City Area
And as we all can tell, you're probably just a barrel of monkeys to work with too. Too bad for Uhlig Corp. On Wednesday 07 January 2004 10:44 am, you wrote: If you are looking for Excellent organizational, communication, and interpersonal skills perhaps you would better impress potential candidates by paying closer attention to the requirement of Qualified individuals will have 3+ years experience developing: ColdFusionMX applications.The product has not been out that long, therefore no one would be qualified for your offered position.. Inaccurate job announcements tend to get you applicants who are either not qualified or have to lie on their application.That is not a good thing, IMHO I would assume you are looking for a CF developer of 3+ years, AND with CFMX experience, huh? Coding being such an exact science, I personally tend to look at job announcements in a literal sense, and If I were looking, I probably would not respond to your post. == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == Aspire to Inspire before you Retire or Expire! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with returning/rendering large-ish recordsets
Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=29660forumid=4#148850 Same ODBC driver and version? Jamie Not ODBC at all. The database is accessed using the drivers supplied with MX, and yes, they are identical. On Wed, 7 Jan 2004 10:30:52 -0500, in cf-talk you wrote: Hi folks, I'm attempting to troubleshoot a problem that is occurring on one, and only one, of two similarly configured servers. I say similarly, because one (the Development server) is running Windows Server 2003 and the other (the Testing server) is running W2K. Both are running MX 6.1 and SQL Server 2000 with the latest service packs. The production environment naturally splits the database and Web/CF stuff into two machines, but the Dev and Test servers are combos. Here's what's happening: I run a stored procedure to retrieve records; when there are few records returned (50-100), all is well on both machines. However, when there are a few hundred (or a few thousand) matches, there's a problem on the Test server. The rendered page never comes back, and eventually I get a Cannot find server or DNS error message from the browser. On the Dev server, the page returns fine, and relatively quickly. I am seeing the same behavior when running other procs/pages which return larger recordsets. The databases and procedures on both machines are precisely the same, as is the CF code. When I run sample parameters to the proc in Query Analyzer which result in some 5800 records being returned, the query actually returns results on the Test server (where the problem occurs) twice as quickly as on the Dev machine. So I assume the bottleneck is not in the database operation, but somewhere further along. Datasources are set up identically in both CF Admins. Has anyone run into this problem of difficulty in displaying large recordsets, or can someone please suggest a path along which I might begin troubleshooting? I've tried searches in the MM KnowledgeBase and on Google with no luck -- but it's hard to be specific enough with search terms in this case. -- Thanks, Tom Tom McNeer MediumCool A Marketing, Creative and Construction Company for the World Wide Web 530 Means St NW, Suite 110 Atlanta, GA 30318 404-589-0560 FAX 404-589-0510 http://www.mediumcool.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cfqueryparam bug and finding it globally.
Bryan F. Hogan wrote: Hi all, I wrote a directory spider that recursively finds all pages on my server in all sites that have the cfqueryparam bug with using functions in the value attributes value. What I want to do is be able to determine the line number of the offending cfqueryparam tag. Does anyone have any thoughts? Loop over the template using something like: ListContains(page, REReplaceNoCase(page,.*(cfqueryparam[^]*value=[^]*\([^]*[^]*).*,\1), chr(13)) Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfqueryparam bug and finding it globally.
Thanks Jochem! Works Perfectly! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion Web Developer/Programmer Position - Kansas City Area
ROTFLMAO! - Original Message - From: Tim H [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 8:25 AM Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City Area : And as we all can tell, you're probably just a barrel of monkeys to work with : too. Too bad for Uhlig Corp. : [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CMS Solutions (Friendly URL's)
All in all, dynamic URLS should be mapped to static ones, and this mapping should be be done by your marketing department while I agree dynamic urls should be mapped to static ones and that search engine positioning is a whole other chapter, why would marketing be the ones to decide if it is mymag.com/issues/2003/november/19 instead of mymag.com/2004/11/19 or something else? do marketers do url usability? by the way, anyone knows of a good dynamic-to-static url mapping in cf (windows and linux) resource? mauricio [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Create PDF (without CFEXECUTE)
What's the best choice (maybe open source) to create PDF files on-the-fly with CF MX? -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: fancy multipart email
this does not appear to support content type of 'multipart/mixed'.Or am I missing something??? I am trying to send some MHTML mail as some call it with an image 'inline' not just an HTML email with an img tag pointing to an img on a server. DK -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:26 AM To: CF-Talk Subject: RE: fancy multipart email If you're on 6.1, Why aren't you using CFMAILPART? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb3.htm#wp27 32354 Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Studio MX 2004 with Flash Professional
You might want to do a search at any of the comparison shopping sites. Shopping.com and CNet come to mind. Christian -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 15:19 To: CF-Talk Subject: Studio MX 2004 with Flash Professional Does anyone know where to get Studio MX 2004 w/ Flash Professional for less than on Macromedia's site?I'm looking to purchase it and was curious if anyone had any leads on a cheaper source.Thanks! John Burns _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Create PDF (without CFEXECUTE)
What's the best choice (maybe open source) to create PDF files on-the-fly with CF MX? perhaps the java based iText might work. http://www.lowagie.com/iText/ i think there were some example code on this list last month. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]