Decrypting MD5

2015-03-12 Thread Rick Sanders

Hey all sorry if this has been asked before. I did Google and didn't come up 
with a result.

I want to know if I can decrypt passwords stored as MD5 in a SQL Server 
database using the Decrypt function? There are online tools out there that 
decrypt MD5 so I'm hoping that I can do this in CF. Thanks.

Kind regards,

Rick


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360234
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Decrypting MD5

2015-03-12 Thread Rick Sanders

So basically MD5 is useless if you can't decrypt the value! That sucks.

Kind regards,

Rick 

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Thursday, March 12, 2015 9:57 AM
To: cf-talk
Subject: Re: Decrypting MD5


 I want to know if I can decrypt passwords stored as MD5 in a SQL 
 Server database using the Decrypt function? There are online tools out there 
 that decrypt MD5 so I'm hoping that I can do this in CF.

There are no tools that actually decrypt MD5 hashes, to the best of my 
knowledge. MD5 is a hashing algorithm, not an encryption algorithm. It lets you 
take a plaintext value and generates a hashed value, which cannot be decrypted.

These online tools don't decrypt MD5 hashes. Instead, they have large databases 
of plaintext values and their corresponding MD5 hashes. When you hash a value, 
you should always get the same hash, so these tools compare the hash you 
provide against their database of existing hash values, and then lookup the 
corresponding plaintext value.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business
(SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized 
instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360236
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Sending SMS

2014-11-18 Thread Rick Sanders

Hey guys,

Does anyone know a service I can use for sending sms messages from cold fusion? 
I want to make an app that notifies someone by sms when their product is ready.

Kind Regards,

Rick Sanders

Canada:  USA:
171 Main St   1205 N. Second Ave
Dartmouth, NS  Siler City, NC
T: 902-401-7689   T: 919-799-9076
W: www.webenergy.cahttp://www.webenergy.ca/  W: 
www.webenergyusa.comhttp://www.webenergyusa.com/



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359660
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Sending SMS

2014-11-18 Thread Rick Sanders

Thanks Bryan,

So it's like online payment. You need a gateway then a payment processor.

-Original Message-
From: Bryan Stevenson [mailto:br...@electricedgesystems.com] 
Sent: Tuesday, November 18, 2014 7:32 PM
To: cf-talk
Subject: Re: Sending SMS


Hey Rick,

I'd say the answer depends on your situation.

A big determining factor is what carrier are the folks on that you would be 
sending to?  I ask because if only one carrier you can go low cost and failry 
easy.

If multiple carriers, you may want to consider using an SMS aggregator as they 
know how to connect and send SMS messages through all the various carrier 
networks (for a fee per text message - those fees vary wildly depending on the 
various APIs you have to choose from).  I use Clickatel for SMS aggregation 
services in the state of Maryland and I think we are talking pennies per text 
(you load account with credits and they get consumed - can notify as you get 
low etc).

Once you have the carrier details sorted, then it's HOW you send (there is an 
SMS gateway in CF, but you can also just call APIs with say Clickatel using 
their HTTP API (one of 3-5 they offer). SOme APIs are meant fo super high 
volume - some for lowsome offer different feautures.

So there is a simple primer to aid in some core decision making - I'll keep an 
eye on this thread - ask away! ;-)

Take care

-Bryan

*Bryan Stevenson*B.Comm.
President  CEO
Electric Edge Systems Group Inc. - makers of FACTS^(TM)
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com
web: www.electricedgesystems.com http://www.electricedgesystems.com
and www.fisheryfacts.com http://www.fisheryfacts.com


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359667
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Sending SMS

2014-11-18 Thread Rick Sanders

That's great but what about sending to different carriers? I'm guessing you 
have to know what carrier the customer you're sending a sms is on right?

Kind Regards,

Rick Sanders

Canada:  USA:
171 Main St   1205 N. Second Ave
Dartmouth, NS  Siler City, NC
T: 902-401-7689   T: 919-799-9076
W: www.webenergy.ca  W: www.webenergyusa.com


-Original Message-
From: richpaul7 . [mailto:richpa...@gmail.com] 
Sent: Tuesday, November 18, 2014 8:26 PM
To: cf-talk
Subject: Re: Sending SMS


I added SMS support using email.  for example, for Verizon, it's the 
phonenum...@vtext.com I googled it and found eahc carriers domain for 
email-to-text and then added a dropdown list for the carriers when my users 
enter their phone number to receive texts.

I don't use any service at all, it's a simple cfmail



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359672
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: HMail server

2014-05-12 Thread Rick Sanders

We use mailenable for our regular email services.

Kind Regards,

Rick Sanders, CEO

Canada:  USA:
T: 902-401-7689   T: 919-799-9076
W: www.webenergy.ca  W: www.webenergyusa.com


-Original Message-
From: Al Musella, DPM [mailto:muse...@virtualtrials.com] 
Sent: Monday, May 12, 2014 12:38 PM
To: cf-talk
Subject: Re: HMail server


   Which email server do you guys use?


 
  I mention it here becuase it is one of the common mail servers to 
  use for cf.
 
 
It is? I have never heard of hmail until about 2 minutes ago.


--




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358620
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFML tags was: The long tail of ColdFusion fail

2014-03-18 Thread Rick Sanders

I come from the days of Everyware and Pervasive using the Tango technology. 
Same idea as CF being a tag-based language with an application server. 
Tag-based is easier to learn and has many benefits.
When Macromedia bought CF, it was a God-send to integrate CF and Dreamweaver 
together without having to use Homesite or the bulky Allaire CF editor. 
Unfortunately, Macromedia bombed when it came to marketing Cold Fusion. 
Remember Ultradev? Macromedia's response to a WYSIWYG java, html, database 
application which was supposed to replace Dreamweaver? Macromedia focused too 
much on Ultradev and ignored the much needed CF marketing.

Fast forward to Adobe (The document and printing solutions company) with 
failing web products to buy Macromedia. Like everyone, I was hoping for a 
re-brand of CF. Nothing happened. They never marketed it. At a trade show in 
New York (Internet World) I went to the Adobe booth. No one wanted to talk 
about CF, and there was one brochure with a paragraph mentioning CF that's it.
Adobe came out with Cold Fusion Builder which is sort of nifty, but not nearly 
as good as Dreamweaver for building CF websites. Now Adobe is pushing their 
Creative Cloud (copying Office 365 are we?) which I would never use because of 
the continuous hacks to Adobe's servers and private information breaches.

So what are the alternatives? PhP. Not secure, messy code, can't load 
balance between multiple servers unless you BUY an app server for it. Most PhP 
hosters throw the web server, database server and email server on the same box 
and call it a day. I programmed PhP code for a year and will never do it again. 
The problems with hacking, SQL injection attacks, URL hacks etc... take up time 
to fix at the developer's expense. PhP, Linux, MYSQL, Cpanel, Wordpress Joomla 
and many others are free. You get what you pay for. A proper coded CF site 
won't get hacked if the code is well written and the server is configured 
properly.

There's ASP.net but personally I don't want to program something for 3 months 
in .NET that takes 3 weeks in CF. Plus Microsoft changes things around way too 
much, and Visual Studio is stupid expensive. Sure there's Expression web (does 
anyone really use it?) and some plugins for Dreamweaver. There's Dot Net Nuke 
if you have lots of time on your hands too. Most of my clients don't want to 
wait. And .NET developers are the snobs of the development community expecting 
high hourly rates. Content Management Server was a nice touch if you had deep 
pockets and lots of staff to maintain multiple servers but Microsoft did away 
with that too.

Is CF dying? It is dying a slow death in my opinion. Adobe has dropped the ball 
with marketing. Heck, they don't even use it on their own site! PhP is the 
internet king for programming, and Wordpress is keeping developers making 
thousands of plugins for it. In the technical colleges and universities they 
teach PhP, Java, and .NET. New developers aren't even exposed to CF anymore. 
When you say Adobe, the first 2 things that come to mind are PDF and 
Photoshop.

I'll continue to use CF for as long as I can, then just leave the web 
development game since the only player is PhP and I don't have the time nor 
desire to get into that technology.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca



-Original Message-
From: Jon Clausen [mailto:jon_clau...@silowebworks.com] 
Sent: Tuesday, March 18, 2014 11:32 AM
To: cf-talk
Subject: Re: CFML tags was: The long tail of ColdFusion fail


On Mar 18, 2014, at 10:17 AM, Adam Cameron dacc...@gmail.com wrote:
 
 Tag-based code is godawful anywhere other than in a view, or some 
 other situation in which text-processing is needed. Which does not 
 describe an awful lot of CFML code out there.
 
 That Macromedia/Adobe pushed the tag side of CFML over the script side 
 is probably the worst strategic move they ever made.

Agree, now.  I think at that moment in webdev history, it served a purpose, 
which was ease of entry in to development.  Now, it's a liability, seems 
antiquated, and is unnecessarily verbose - especially if you are coming from a 
different programming language.  I do like wrapping an entire content block 
with cfoutput and just double escaping the pound symbols, as necessary, 
compared to having to deal with ?php echo $variable? or PHP short tags ?= 
$variables ?.   I haven't written a tag-based component in a long while 
though, as I can build something out faster in script - especially when I'm 
coming back to CF after using a different language for a bit.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358031
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http

Twitter feed

2014-03-14 Thread Rick Sanders

Hey guys n' gals!

I want to put a Twitter live feed on a CF site like Wordpress. Is there 
anything like that already out there or do I need to code it from scratch?

If I need to code it, has anyone done it? Is it difficult? Thanks!

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357939
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Twitter feed

2014-03-14 Thread Rick Sanders

Thanks Russ! That's exactly what I want! Control!

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca



-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Friday, March 14, 2014 8:11 PM
To: cf-talk
Subject: Re: Twitter feed


this is what you want
http://monkehtweet.riaforge.org/


On Fri, Mar 14, 2014 at 9:44 PM, Rob Parkhill robert.parkh...@gmail.comwrote:


 Why not just use what Twitter provides? dev.twitter.com

 You can embed a bunch of stuff straight from Twitter, no muss, no fuss.


 On Fri, Mar 14, 2014 at 5:36 PM, Rick Sanders r...@webenergy.ca wrote:

 
  Hey guys n' gals!
 
  I want to put a Twitter live feed on a CF site like Wordpress. Is 
  there anything like that already out there or do I need to code it 
  from
 scratch?
 
  If I need to code it, has anyone done it? Is it difficult? Thanks!
 
  Kind Regards,
 
  Rick Sanders
  T: 902-401-7689
  W: www.webenergy.cahttp://www.webenergy.ca/
 
 
 
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357942
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Cold Fusion source code stolen from Adobe in Cyber attack

2013-10-04 Thread Rick Sanders

Not sure if you guys heard about this yet:

http://www.cbc.ca/news/technology/adobe-customer-data-stolen-in-cyberattack-1.1912301

The hackers took source code for Adobe Acrobat, which is used to create 
electronic documents in the PDF format, as well as ColdFusion and ColdFusion 
Builder, used to create internet applications, Adobe said

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356882
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfmail Exchange 2010

2013-09-06 Thread Rick Sanders

Dave I want to thank you for your help. I resolved the issue.

Because my Exchange server and CF server are on different machines I had to 
create a new receive connector allowing relay from the IP address of my CF 
server. Out of the box, Exchange doesn't allow any relay from a remote machine.

Your note made me realize this and I was able to resolve it:
 That doesn't mean that any server can relay through your Exchange 
 server (I hope!). Typically, you have to enable relay for each 
 individual IP address that you want to allow.

Have a great weekend.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, September 04, 2013 8:33 PM
To: cf-talk
Subject: Re: cfmail  Exchange 2010


 OK, this is weird. I can send fine to any email address from the 
 account I set up t...@mycompany.com mailto:t...@mycompany.com

 I'm doing a cfoutput query=emails and sending an email out to the 
 people in my query. The emails are valid.
 However, only the people on the local Exchange server receive them.
 Anyone outside doesn't get them. I tested with my gmail account and 
 I don't receive the email. But I get it on my exchange account. I 
 tested and can send to my gmail account from the 
 t...@mycompany.commailto:t...@mycompany.com directly no problems.

 My Cold Fusion server is on a different server than my Exchange 
 server. I've tested the mail settings in the Cold fusion admin and tried 
 with and without TLS and the settings are fine.

 By default, your Exchange server won't proxy SMTP messages. You have 
 to specifically configure it to do so. Messages to Exchange mailboxes on 
 that server don't need to be proxied, so they get delivered.

 Thanks for the info, but my Exchange server is set up to send to the 
 outside world. My send connector type is SMTP. I even tried relaying 
 through my ISP as a smart host and still no sending to outside addresses 
 from my Cold fusion Server.

 That doesn't mean that any server can relay through your Exchange 
 server (I hope!). Typically, you have to enable relay for each 
 individual IP address that you want to allow.

In any case, you can verify this easily enough yourself. Open a telnet 
connection to your Exchange server from your CF server's console, and try to 
send an email that way. Google smtp telnet for more information on how to do 
that.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and 
provides the highest caliber vendor-authorized instruction at our training 
centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356720
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfmail Exchange 2010

2013-09-04 Thread Rick Sanders

OK, this is weird. I can send fine to any email address from the account I set 
up t...@mycompany.commailto:t...@mycompany.com

I'm doing a cfoutput query=emails and sending an email out to the people in 
my query. The emails are valid.
However, only the people on the local Exchange server receive them. Anyone 
outside doesn't get them. I tested with my gmail account and I don't receive 
the email. But I get it on my exchange account. I tested and can send to my 
gmail account from the t...@mycompany.commailto:t...@mycompany.com directly 
no problems.

My Cold Fusion server is on a different server than my Exchange server. I've 
tested the mail settings in the Cold fusion admin and tried with and without 
TLS and the settings are fine.

Any help would be appreciated.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356704
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfmail Exchange 2010

2013-09-04 Thread Rick Sanders

Thanks for the info, but my Exchange server is set up to send to the outside 
world. My send connector type is SMTP. I even tried relaying through my ISP as 
a smart host and still no sending to outside addresses from my Cold fusion 
Server.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, September 04, 2013 5:18 PM
To: cf-talk
Subject: Re: cfmail  Exchange 2010


 OK, this is weird. I can send fine to any email address from the 
 account I set up t...@mycompany.com mailto:t...@mycompany.com

 I'm doing a cfoutput query=emails and sending an email out to the people 
 in my query. The emails are valid.
 However, only the people on the local Exchange server receive them. 
 Anyone outside doesn't get them. I tested with my gmail account and I 
 don't receive the email. But I get it on my exchange account. I tested and 
 can send to my gmail account from the 
 t...@mycompany.commailto:t...@mycompany.com directly no problems.

 My Cold Fusion server is on a different server than my Exchange 
 server. I've tested the mail settings in the Cold fusion admin and tried with 
 and without TLS and the settings are fine.

By default, your Exchange server won't proxy SMTP messages. You have to 
specifically configure it to do so. Messages to Exchange mailboxes on that 
server don't need to be proxied, so they get delivered.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and 
provides the highest caliber vendor-authorized instruction at our training 
centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356706
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Syntax is driving me nuts!

2013-08-20 Thread Rick Sanders

Hey guys,

I'm trying to add multiple items to a database based on if a check box is 
checked.

This code works fine:
cfif IsNumeric(#form['qty_'  upd]#)

But I want to make sure the box is checked or not. When I do this:
cfif IsDefined(#form['rel_'  ar]#)
I get: Element rel_1 is undefined in a Java object of type class 
coldfusion.filter.FormScope.

If I do this:
cfif IsDefined(form['rel_'  ar])
I get: Parameter 1 of function IsDefined, which is now form['rel_'  ar], must 
be a syntactically valid variable name.

I'm doing all this in a loop. The form's check boxes are defined as: 
rel_#currentrow#. Then I'm looping around them:
cfloop index=ar from=1 to=#form.numrows#
Numrows comes from the recordcount of the hidden form variable output query 
displaying the checkboxes.

All I need to know is what the right syntax I need to use for IsDefined?

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356502
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Syntax is driving me nuts!

2013-08-20 Thread Rick Sanders

Thanks a lot guys. I still have a lot to learn about CF.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca



-Original Message-
From: DURETTE, STEVEN J [mailto:sd1...@att.com] 
Sent: Tuesday, August 20, 2013 12:56 PM
To: cf-talk
Subject: RE: Syntax is driving me nuts!


Try structkeyexists

cfif structKeyExists(Form, rel_  ar)

If you really need to use isdefined, it would be:
cfif isDefined(form.rel_  ar)

Steve


-Original Message-
From: Rick Sanders [mailto:r...@webenergy.ca] 
Sent: Tuesday, August 20, 2013 11:49 AM
To: cf-talk
Subject: Syntax is driving me nuts!


Hey guys,

I'm trying to add multiple items to a database based on if a check box is 
checked.

This code works fine:
cfif IsNumeric(#form['qty_'  upd]#)

But I want to make sure the box is checked or not. When I do this:
cfif IsDefined(#form['rel_'  ar]#)
I get: Element rel_1 is undefined in a Java object of type class 
coldfusion.filter.FormScope.

If I do this:
cfif IsDefined(form['rel_'  ar])
I get: Parameter 1 of function IsDefined, which is now form['rel_'  ar], must 
be a syntactically valid variable name.

I'm doing all this in a loop. The form's check boxes are defined as: 
rel_#currentrow#. Then I'm looping around them:
cfloop index=ar from=1 to=#form.numrows#
Numrows comes from the recordcount of the hidden form variable output query 
displaying the checkboxes.

All I need to know is what the right syntax I need to use for IsDefined?

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/









~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356507
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Pausing a loop or query

2013-08-19 Thread Rick Sanders

Here's the situation. A client of mine has an email list he sends a flyer to 
once a month to about 5000 addresses. I need to pause after sending 250 so the 
server doesn't get flagged for spamming. What's the best way to do this?

It's easy to do multiple queries of 250 rows each, but how can I pause for say 
5 or 10mins in between?

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356493
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Pausing a loop or query

2013-08-19 Thread Rick Sanders

OK thanks guys. So similar to doing a cron job.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca



-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: Monday, August 19, 2013 12:13 PM
To: cf-talk
Subject: Re: Pausing a loop or query


Kinda hacky, but:

Use a db table/column for misc crap, or hell, even a server variable, and save 
something called:

lastRow, 1

Do a SQL to get 250 addresses starting at row lastRow.

Process your mail.

When done, set lastRow to lastRow + 250.

All of the above would be a CFM hit via cfschedule.



On Mon, Aug 19, 2013 at 9:55 AM, Rick Sanders r...@webenergy.ca wrote:


 Here's the situation. A client of mine has an email list he sends a 
 flyer to once a month to about 5000 addresses. I need to pause after 
 sending 250 so the server doesn't get flagged for spamming. What's the 
 best way to do this?

 It's easy to do multiple queries of 250 rows each, but how can I pause 
 for say 5 or 10mins in between?

 Kind Regards,

 Rick Sanders
 T: 902-401-7689
 W: www.webenergy.cahttp://www.webenergy.ca/



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356496
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


C-Panel

2013-07-10 Thread Rick Sanders

Hi Folks. I run a hosting company and need an interface like C-Panel. I was 
wondering if there were and snippets of code out there that have an interface 
to manage Windows accounts since my servers are windows based.

Since I'm developing this myself I may be asking questions here, but I'm 
willing to share my work with you folks here in the community.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: C-Panel

2013-07-10 Thread Rick Sanders

Hi again Brian,

I agree with you about windows. However, I haven't had enough experience with 
Linux servers in order to set one up for web hosting. I've been working with 
windows servers since NT 3.5. Windows can host Wordpress, PhP and any other web 
technology today. Until I absolutely have to set up a Linux server, my limited 
time is best served in other areas.

WebSitePanel looks to be a good solution for what I need. I don't need billing, 
only file management.

Thanks for the info on webhostingtalk.com too!

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca




-Original Message-
From: Byron Mann [mailto:byronos...@gmail.com] 
Sent: Wednesday, July 10, 2013 11:22 AM
To: cf-talk
Subject: Re: C-Panel


Having supported home-grown provisioning code for several years my suggestion 
would be to use something off the shelf.  We implemented Parallels Automation 
and Billing last year and have drastically reduced our costs across the board, 
development, support, operations.  We now only have one additional developer 
supporting our legacy applications, instead of 5, and most of his time is spent 
on new work.

Next question is do you need billing and automation or just automation?

WHMCS is a nice all in one solution a lot of smaller hosts seem to use for both 
provisioning and billing.  It integrates with various control panels on the 
servers. Pretty inexpensive, limited a bit on services you can offer however.  
Windows and Linux should you decide to offer Linux in the future.

WebSitePanel, OpenSource, .NET, backed by Microsoft.  Windows Only, might be a 
bit difficult to implement Linux. Simple billing. Seems like it is not a very 
active project however. We started using this a while back just for 
provisioning and had to customize things quite a bit for how we wanted to do 
things. So a bit restrictive.  We no longer use it.

Parallels has taken Plesk to the next level and can now centrally manage Plesk 
servers: http://www.parallels.com/products/plesk-automation/, we are actually 
going to start offering this to our resellers.  Windows and Linux.
Provisioning only.  Just need the Plesk management node actually, can connect 
to existing Plesk servers and can add new servers without Plesk.
There is just an agent that runs on the remote machines. No Billing, Parallels 
has a new billing thing coming out next year specifically for this.

Parallels Automation  Billing, this is what we use for provisioning. This is 
their most comprehensive product and will provision just about everything a web 
host would probably need. You can just get the Automation component without 
billing.  Expensive and does require Parallels implementation (and I would 
suggest training) as part of the purchase. Can also do fully branded resellers.

If you stick with an in-house solution, use powershell scripts.  I've found it 
to be the most flexible and reliable thing out there, plus there are a ton of 
scripts floating out there already.

Windows hosting is shrinking with the advent of more good Control Panels that 
make Linux a no brainer. Not sure what your business model is, but I would 
consider this a future possibility.

webhostingtalk.com is an excellent resource for hosters as well, if you aren't 
part of that community already.


Byron Mann
Lead Engineer  Architect
HostMySite.com


On Wed, Jul 10, 2013 at 7:38 AM, Rick Sanders r...@webenergy.ca wrote:


 Hi Folks. I run a hosting company and need an interface like C-Panel. 
 I was wondering if there were and snippets of code out there that have 
 an interface to manage Windows accounts since my servers are windows based.

 Since I'm developing this myself I may be asking questions here, but 
 I'm willing to share my work with you folks here in the community.

 Kind Regards,

 Rick Sanders
 T: 902-401-7689
 W: www.webenergy.cahttp://www.webenergy.ca/





 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356158
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: C-Panel

2013-07-10 Thread Rick Sanders

Thanks for your input Ross. I'm installing it now on a test machine then I will 
implement it on our live server.

Kind Regards,

Rick Sanders
T: 902-401-7689
W: www.webenergy.ca




-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Wednesday, July 10, 2013 12:14 PM
To: cf-talk
Subject: Re: C-Panel


Fyi websitepanel is more active now, 2.0 released this year and 2.1 currently 
in beta, supports Windows 2012.
Do not use its ecommerce system though it is awful, but the rest of it works 
really well.
We use it for all our Windows hosting and I also use it for cfmldeveloper.com

Russ Michaels
www.michaels.me.uk
 On 10 Jul 2013 15:21, Byron Mann byronos...@gmail.com wrote:


 Having supported home-grown provisioning code for several years my 
 suggestion would be to use something off the shelf.  We implemented 
 Parallels Automation and Billing last year and have drastically 
 reduced our costs across the board, development, support, operations.  
 We now only have one additional developer supporting our legacy 
 applications, instead of 5, and most of his time is spent on new work.

 Next question is do you need billing and automation or just automation?

 WHMCS is a nice all in one solution a lot of smaller hosts seem to use 
 for both provisioning and billing.  It integrates with various control 
 panels on the servers. Pretty inexpensive, limited a bit on services 
 you can offer however.  Windows and Linux should you decide to offer Linux in 
 the future.

 WebSitePanel, OpenSource, .NET, backed by Microsoft.  Windows Only, 
 might be a bit difficult to implement Linux. Simple billing. Seems 
 like it is not a very active project however. We started using this a 
 while back just for provisioning and had to customize things quite a 
 bit for how we wanted to do things. So a bit restrictive.  We no longer use 
 it.

 Parallels has taken Plesk to the next level and can now centrally 
 manage Plesk servers: 
 http://www.parallels.com/products/plesk-automation/, we are actually going to 
 start offering this to our resellers.  Windows and Linux.
 Provisioning only.  Just need the Plesk management node actually, can 
 connect to existing Plesk servers and can add new servers without Plesk.
 There is just an agent that runs on the remote machines. No Billing, 
 Parallels has a new billing thing coming out next year specifically 
 for this.

 Parallels Automation  Billing, this is what we use for provisioning. 
 This is their most comprehensive product and will provision just about 
 everything a web host would probably need. You can just get the 
 Automation component without billing.  Expensive and does require 
 Parallels implementation (and I would suggest training) as part of the 
 purchase. Can also do fully branded resellers.

 If you stick with an in-house solution, use powershell scripts.  I've 
 found it to be the most flexible and reliable thing out there, plus 
 there are a ton of scripts floating out there already.

 Windows hosting is shrinking with the advent of more good Control 
 Panels that make Linux a no brainer. Not sure what your business model 
 is, but I would consider this a future possibility.

 webhostingtalk.com is an excellent resource for hosters as well, if 
 you aren't part of that community already.


 Byron Mann
 Lead Engineer  Architect
 HostMySite.com


 On Wed, Jul 10, 2013 at 7:38 AM, Rick Sanders r...@webenergy.ca wrote:

 
  Hi Folks. I run a hosting company and need an interface like 
  C-Panel. I was wondering if there were and snippets of code out 
  there that have an interface to manage Windows accounts since my servers 
  are windows based.
 
  Since I'm developing this myself I may be asking questions here, but 
  I'm willing to share my work with you folks here in the community.
 
  Kind Regards,
 
  Rick Sanders
  T: 902-401-7689
  W: www.webenergy.cahttp://www.webenergy.ca/
 
 
 
 
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356160
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Weird attack

2011-11-24 Thread Rick Sanders

Looks as if to me someone is using a javascript in the url of your sites to 
generate their own url. Either that or you have a virus, malware, proxy 
redirection or your DNS has been changed on your machine. It's worth it to do a 
scan at http://housecall.trendmicro.com even if you have an antivirus. Good 
luck.

Kind Regards,

Rick Sanders
Webenergy Software
902-401-7689
http://www.webenergy.ca

-Original Message-
From: Paul Stewart [mailto:p...@whichfranchise.com] 
Sent: Thursday, November 24, 2011 8:13 AM
To: cf-talk
Subject: Re: Weird attack


On 24/11/2011 11:10, Russ Michaels wrote:
 or give Fuseguard a try

 http://foundeo.com/security/

 On Thu, Nov 24, 2011 at 10:56 AM, Paul Stewartp...@whichfranchise.com  
 wrote:
 On 18/11/2011 16:57, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote:
 Hi,

 Since a few days, I have all my sites receiving requests in which a string 
 like /**/or/**/1=@@version)-- is added in the URL.

 Has someone any idea what this guy is actually trying to do ?



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Outputting telephone numbers

2011-10-06 Thread Rick Sanders

Sorry for the newbie question. For the life of me I can't see anywhere how to 
output a telephone number from a database that stores a number like 2125551212 
to display as (212) 555-1212.

Thanks.

Kind Regards,

[WebLogomailsig]
Rick Sanders
Webenergy Software
902-401-7689
http://www.webenergy.cahttp://www.webenergy.ca/



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347984
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Outputting telephone numbers

2011-10-06 Thread Rick Sanders

Thanks Andrew

Kind Regards,


Rick Sanders
Webenergy Software
902-401-7689
http://www.webenergy.ca

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Thursday, October 06, 2011 12:52 PM
To: cf-talk
Subject: Re: Outputting telephone numbers


If this format is fixed use NumberFormat with the mask.


On Fri, Oct 7, 2011 at 2:48 AM, Rick Sanders r...@webenergy.ca wrote:


 Sorry for the newbie question. For the life of me I can't see anywhere how
 to output a telephone number from a database that stores a number like
 2125551212 to display as (212) 555-1212.

 Thanks.

 Kind Regards,

 [WebLogomailsig]
 Rick Sanders
 Webenergy Software
 902-401-7689
 http://www.webenergy.cahttp://www.webenergy.ca/



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Timing out a webpage

2011-06-23 Thread Rick Sanders

Thank you for your reply. This looks like a great solution on top of the
java script.

Have a good day.

Rick Sanders
Webenergy
www.webenergy.ca

-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Wednesday, June 22, 2011 4:10 PM
To: cf-talk
Subject: Re: Timing out a webpage


...but note that Javascript can be turned off.  So, in addition, you'd want
to do something like this on page load (including first page where timer
should start and last page that processes test):

cfparam name=session.starttime default=#now()#
cfif datediff(n, session.starttime, now()) GT 15
!--- run some test timed out code ---
/cfif

On Wed, Jun 22, 2011 at 2:02 PM, Russ Michaels r...@michaels.me.uk wrote:


 well you have 2 options.

 set your session timeout to 15 minutes, this will then mean they cannot
sit
 on a page doing nothing for more than 15 minutes.
 If you want to time them for 15 minutes regardless of how many pages they
 load or refresh then you could create a Javascript timer, Google will
 garnish you with one of these.

 Russ


 On Wed, Jun 22, 2011 at 7:39 PM, John M Bliss bliss.j...@gmail.com
 wrote:

 
  Can the timeout check happen on a page load?  Or do you need to have it
  happen while page is displayed?
 
  On Wed, Jun 22, 2011 at 1:32 PM, Rick Sanders r...@webenergy.ca wrote:
 
  
   Hey all. I have an online test that I want to timeout after 15mins.
 Does
   ColdFusion have a feature built-in to do this? It's my first time
doing
   this
   sort of thing. Thanks.
  
  
  
   Kind Regards,
  
  
  
   WebLogomailsig
  
   Rick Sanders
  
   Webenergy Software
  
   902-401-7689
  
   http://www.webenergy.ca http://www.webenergy.ca/
  
  
  
  
  
  
  
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345564
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Timing out a webpage

2011-06-22 Thread Rick Sanders

Hey all. I have an online test that I want to timeout after 15mins. Does
ColdFusion have a feature built-in to do this? It's my first time doing this
sort of thing. Thanks.

 

Kind Regards,

 

WebLogomailsig

Rick Sanders

Webenergy Software

902-401-7689

http://www.webenergy.ca http://www.webenergy.ca/ 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345538
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


decimals and variables

2011-02-10 Thread Rick Sanders

Hey all,

 

I'm pulling up an integer from the database which is 15.

 

This is a tax rate, so I need to get the tax on the subtotal. Say the
#subtot# is 100 and #tx# is 15.

cfset tax = #subtot# * .#tx#

This should bring back the number 15. However, cf is throwing an error
because of the decimal in front of the #tx#.

 

cfset tax = #subtot# * .15

This works. However I need to pull from the database in case the tax rate
changes.

 

Rick

 

 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342097
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: decimals and variables

2011-02-10 Thread Rick Sanders

Thank you. this worked great. I didn't realize you had to convert it to a
decimal in cf.

-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] 
Sent: Thursday, February 10, 2011 10:24 AM
To: cf-talk
Subject: RE: decimals and variables


You need to do this:

cfset tax = subtot * (tx / 100) /

This actually converts the tx to a decimal.

Also you don't need the #s in the cfset. :)

Steve

-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: Thursday, February 10, 2011 9:14 AM
To: cf-talk
Subject: decimals and variables


Hey all,

 

I'm pulling up an integer from the database which is 15.

 

This is a tax rate, so I need to get the tax on the subtotal. Say the
#subtot# is 100 and #tx# is 15.

cfset tax = #subtot# * .#tx#

This should bring back the number 15. However, cf is throwing an error
because of the decimal in front of the #tx#.

 

cfset tax = #subtot# * .15

This works. However I need to pull from the database in case the tax
rate
changes.

 

Rick

 

 

 








~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342104
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: decimals and variables

2011-02-10 Thread Rick Sanders

Yup, I certainly am! Paying the highest taxes in North America! lol!

-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Thursday, February 10, 2011 10:33 AM
To: cf-talk
Subject: Re: decimals and variables


Does this mean you are in Nova Scotia?


On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote:


 Hey all,



 I'm pulling up an integer from the database which is 15.



 This is a tax rate, so I need to get the tax on the subtotal. Say the
 #subtot# is 100 and #tx# is 15.

 cfset tax = #subtot# * .#tx#

 This should bring back the number 15. However, cf is throwing an error
 because of the decimal in front of the #tx#.



 cfset tax = #subtot# * .15

 This works. However I need to pull from the database in case the tax rate
 changes.



 Rick










 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342107
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: decimals and variables

2011-02-10 Thread Rick Sanders

I used to live in Kitchener back in 2006. You gas prices are cheaper than
ours though! The gov didn't mention how long temporary was!

-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Thursday, February 10, 2011 10:43 AM
To: cf-talk
Subject: Re: decimals and variables


I come a close second. I'm in ON.
Damn you Harper!
Remember in the 80's when the GST was a temporary measure?


On Thu, Feb 10, 2011 at 9:38 AM, Rick Sanders c...@webenergy.ca wrote:


 Yup, I certainly am! Paying the highest taxes in North America! lol!

 -Original Message-
 From: Michael Grant [mailto:mgr...@modus.bz]
 Sent: Thursday, February 10, 2011 10:33 AM
 To: cf-talk
 Subject: Re: decimals and variables


 Does this mean you are in Nova Scotia?


 On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote:

 
  Hey all,
 
 
 
  I'm pulling up an integer from the database which is 15.
 
 
 
  This is a tax rate, so I need to get the tax on the subtotal. Say the
  #subtot# is 100 and #tx# is 15.
 
  cfset tax = #subtot# * .#tx#
 
  This should bring back the number 15. However, cf is throwing an error
  because of the decimal in front of the #tx#.
 
 
 
  cfset tax = #subtot# * .15
 
  This works. However I need to pull from the database in case the tax
rate
  changes.
 
 
 
  Rick
 
 
 
 
 
 
 
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342111
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Parsing RSS feeds

2011-01-25 Thread Rick Sanders

Hey all,

 

I have code for parsing feeds that works very well on several feeds.

  cfhttp
url=http://rss.cbc.ca/lineup/canada-novascotia.xml  method=get/cfhttp

  cfset objRSS = xmlParse(cfhttp.filecontent)

cfoutput#objRSS#/cfoutput

cfdump var=#objRSS#

 

However, when I use the same code to parse the following feed it causes an
error:

  cfhttp
url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp

  cfset objRSS = xmlParse(cfhttp.filecontent)

cfoutput#objRSS#/cfoutput

cfdump var=#objRSS#

 

The error:


Content is not allowed in prolog. 



The error occurred in E:\Websites\ConnectNS\testrss.cfm: line 11

 

9 : pEmpire Theatres RSS:/p

10 :   cfhttp
url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp

11 :   cfset objRSS = xmlParse(cfhttp.filecontent)

12 : cfoutput#objRSS#/cfoutput

13 : cfdump var=#objRSS#

 

Can anyone help point me in the right direction? I'm perplexed! Google,
Yahoo, and the browser parse the feed fne!

 

Thanks,

 

Rick

Webenergy

www.webenergy.ca




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341286
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Parsing RSS feeds

2011-01-25 Thread Rick Sanders

I found the answer after some trial and error and digging around!

It turns out, this character which is creating problem is something called
as Byte-Order-Mark and in an XML document, it is used to flag the encoding
type of the XML. Unfortunately, ColdFusion does not appreciate the use of
this Byte-Order-Mark, or BOM. In order to get this kind of XML feed to play
nicely with ColdFusion, we have to remove the BOM before we parse the
document. Luckily, getting rid of this requires nothing more than a simple
regular expression that strips out all characters before the first bracket.
Source and credit goes to:
http://blog.webvirtue.com/2009/05/coldfusion-xml-parsing.html

Finally here is the code that worked:
cfhttp url=http://www.empiretheatres.com/rss/showtimes/43;
method=get/cfhttp
cfset RSS = REReplace( cfhttp.filecontent, ^[^]*, , all )
cfset objRSS = xmlParse(RSS)

Rick
Webenergy
www.webenergy.ca

-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: Tuesday, January 25, 2011 10:57 PM
To: cf-talk
Subject: Parsing RSS feeds


Hey all,

 

I have code for parsing feeds that works very well on several feeds.

  cfhttp
url=http://rss.cbc.ca/lineup/canada-novascotia.xml  method=get/cfhttp

  cfset objRSS = xmlParse(cfhttp.filecontent)

cfoutput#objRSS#/cfoutput

cfdump var=#objRSS#

 

However, when I use the same code to parse the following feed it causes an
error:

  cfhttp
url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp

  cfset objRSS = xmlParse(cfhttp.filecontent)

cfoutput#objRSS#/cfoutput

cfdump var=#objRSS#

 

The error:


Content is not allowed in prolog. 



The error occurred in E:\Websites\ConnectNS\testrss.cfm: line 11

 

9 : pEmpire Theatres RSS:/p

10 :   cfhttp
url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp

11 :   cfset objRSS = xmlParse(cfhttp.filecontent)

12 : cfoutput#objRSS#/cfoutput

13 : cfdump var=#objRSS#

 

Can anyone help point me in the right direction? I'm perplexed! Google,
Yahoo, and the browser parse the feed fne!

 

Thanks,

 

Rick

Webenergy

www.webenergy.ca






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341296
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Writing cfml content to an html file

2010-10-21 Thread Rick Sanders

Hey all,

I'm trying to take some cfml content and write it to an html file using
cffile. The cfml content has queries etc I'm getting all kinds of
errors. Is there any way I can just get the cffile tag to write exactly what
I want to the file parsing the cfml content?

Error example:

Invalid CFML construct found on line 18 at column 303.  
ColdFusion was looking at the following text: 
#
The CFML compiler was processing: 
*   A cffile tag beginning on line 1, column 2. 

The error occurred in E:\Websites\nscomputers\emailquote.cfm: line 18   
16 :   /tr
17 : cfquery name=sys datasource=nscomputers
18 : SELECT
S1.SystemID,S1.SessionID,S1.CPU,S1.RAM,S1.RAMqty,S1.MB,S1.HD,S1.HDqty,S1.Tow
er,S1.Optical,S1.Video,S1.OS,S1.Keyboard,S1.Mouse,S1.Monitor,S1.Printer,S1.S
peaker,S1.acc1,S1.acc2,S1.acc3,S1.acc4,S1.acc5,S1.acc6,S1.acc7,S1.acc8,S1.Su
bTotal,S1.CreatedBy FROM dbo.SystemBuilder S1 WHERE
(S1.SessionID='#cookie.sid#')
19 : /cfquery 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338424
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Writing cfml content to an html file

2010-10-21 Thread Rick Sanders

Sorry, I am writing to a cfm file. I tried escaping the # with ##variable##
and it still throws the same error.

-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Thursday, October 21, 2010 11:31 AM
To: cf-talk
Subject: Re: Writing cfml content to an html file


Right.  Also, if you use cffile to write CFML to a file, then the file
you're writing to should be a .cfm file (unless you have your server
configured to pass .htm files to the CF server).

On Thu, Oct 21, 2010 at 9:27 AM, Andy Matthews
li...@commadelimited.comwrote:


 You shouldn't have any problems writing CFML code to a page. The error
 you're getting is likely from your hashmarks not being escaped.


 andy

 -Original Message-
 From: Rick Sanders [mailto:c...@webenergy.ca]
 Sent: Thursday, October 21, 2010 9:23 AM
 To: cf-talk
 Subject: Writing cfml content to an html file


 Hey all,

 I'm trying to take some cfml content and write it to an html file using
 cffile. The cfml content has queries etc I'm getting all kinds of
 errors. Is there any way I can just get the cffile tag to write exactly
 what
 I want to the file parsing the cfml content?

 Error example:

 Invalid CFML construct found on line 18 at column 303.
 ColdFusion was looking at the following text:
 #
 The CFML compiler was processing:
 *   A cffile tag beginning on line 1, column 2.

 The error occurred in E:\Websites\nscomputers\emailquote.cfm: line 18
 16 :   /tr
 17 : cfquery name=sys datasource=nscomputers
 18 : SELECT


S1.SystemID,S1.SessionID,S1.CPU,S1.RAM,S1.RAMqty,S1.MB,S1.HD,S1.HDqty,S1.Tow


er,S1.Optical,S1.Video,S1.OS,S1.Keyboard,S1.Mouse,S1.Monitor,S1.Printer,S1.S


peaker,S1.acc1,S1.acc2,S1.acc3,S1.acc4,S1.acc5,S1.acc6,S1.acc7,S1.acc8,S1.Su
 bTotal,S1.CreatedBy FROM dbo.SystemBuilder S1 WHERE
 (S1.SessionID='#cookie.sid#')
 19 : /cfquery







 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338430
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Writing cfml content to an html file

2010-10-21 Thread Rick Sanders

Perfect, thanks! This is exactly what I was looking for. Still haven't
totally got used to Cold Fusion yet. I was using Tang (Witango), and the
file write action didn't require additional formatting because it doesn't
use ## symbols.

Rick

-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: Thursday, October 21, 2010 11:33 AM
To: cf-talk
Subject: RE: Writing cfml content to an html file


Break this down into steps.

1. Get you code and queries correct to the can generate output to the screen

2. Then move that code inside a savecontent tag and write the content to a
variable

cfcontent reset=truecfsavecontent
variable=my_variable_nameMY CODE TO MAKE THE OUTPUT HERE/cfsavecontent

3. Then write the variable content to a file:

cffile action=write file=MYPATH\MYFILENAME output=#
my_variable_name #

That should help.


Robert B. Harrison
Director of Interactive Services
Austin  Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be .

Plug in to our blog: AW Unplugged
http://www.austin-williams.com/unplugged


-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: Thursday, October 21, 2010 10:23 AM
To: cf-talk
Subject: Writing cfml content to an html file


Hey all,

I'm trying to take some cfml content and write it to an html file using
cffile. The cfml content has queries etc I'm getting all kinds of
errors. Is there any way I can just get the cffile tag to write exactly what
I want to the file parsing the cfml content?

Error example:

Invalid CFML construct found on line 18 at column 303.  
ColdFusion was looking at the following text: 
#
The CFML compiler was processing: 
*   A cffile tag beginning on line 1, column 2. 

The error occurred in E:\Websites\nscomputers\emailquote.cfm: line 18   
16 :   /tr
17 : cfquery name=sys datasource=nscomputers
18 : SELECT
S1.SystemID,S1.SessionID,S1.CPU,S1.RAM,S1.RAMqty,S1.MB,S1.HD,S1.HDqty,S1.Tow
er,S1.Optical,S1.Video,S1.OS,S1.Keyboard,S1.Mouse,S1.Monitor,S1.Printer,S1.S
peaker,S1.acc1,S1.acc2,S1.acc3,S1.acc4,S1.acc5,S1.acc6,S1.acc7,S1.acc8,S1.Su
bTotal,S1.CreatedBy FROM dbo.SystemBuilder S1 WHERE
(S1.SessionID='#cookie.sid#')
19 : /cfquery 









~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Totaling items in a recordet

2010-10-19 Thread Rick Sanders

Hey all. I am pulling prices from a database and want to total them. Is
there a function like #total(query.column)# ?

Kind Regards,

 
Rick Sanders
Webenergy Software
902-401-7689
http://www.webenergy.ca





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


totaling items in a recordset

2010-10-19 Thread Rick Sanders

Hey all. I am pulling prices from a database and want to total them. Is
there a function like #total(query.column)# ?

Kind Regards,

 
Rick Sanders
Webenergy Software
902-401-7689
http://www.webenergy.ca






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338326
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: totaling items in a recordset

2010-10-19 Thread Rick Sanders

Thanks!

I'm used to another programming language where the db query is actually
stored in a temporary array, then I can easily total the array with a
built-in function.

The example you gave is helpful and I've used it before when totaling
something. This works for my current application!

Thanks,

Rick

-Original Message-
From: David McGraw [mailto:david.mcg...@gmail.com] 
Sent: Tuesday, October 19, 2010 4:24 PM
To: cf-talk
Subject: Re: totaling items in a recordset


Actually... the best way would be to use a query of queries...

cfquery name=priceTotal dbtype=querySELECT SUM(prices) as result FROM
query/cfquery

cfoutput#priceTotal.result#/cfoutput

Again this is all assuming you don't want just the total and still need the
individual items from the DB.

Regards,
David McGraw
Oyova Software, LLC
http://www.oyova.com


On Tue, Oct 19, 2010 at 3:18 PM, Rick Sanders c...@webenergy.ca wrote:


 Hey all. I am pulling prices from a database and want to total them. Is
 there a function like #total(query.column)# ?

 Kind Regards,


 Rick Sanders
 Webenergy Software
 902-401-7689
 http://www.webenergy.ca






 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338331
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Totaling items in a recordet

2010-10-19 Thread Rick Sanders

This is something along the lines of what I was looking for. Now, is there a
way to display the full array and have the totaled column as well?

Kind regards,

Rick

-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Tuesday, October 19, 2010 4:26 PM
To: cf-talk
Subject: Re: Totaling items in a recordet


The best way would be to sum() it in the query itself. Failing that you can
get the list of values, set it to an array, then sum it.

#arraysum(listtoarray(valuelist(query.column)))#



On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders r...@webenergy.ca wrote:


 Hey all. I am pulling prices from a database and want to total them. Is
 there a function like #total(query.column)# ?

 Kind Regards,


 Rick Sanders
 Webenergy Software
 902-401-7689
 http://www.webenergy.ca





 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338332
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfif contains

2010-10-17 Thread Rick Sanders

How can I do a cfif contains?

Error I am getting:

You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members.   


The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6

4 : cfif #Trim(cpu.description)# contains AMD
5 : cfset cpu = AMD
6 : cfif #Trim(cpu.description)# contains AM2   


I hope someone can shed some light on this. thanks!

Rick





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338258
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfif contains

2010-10-17 Thread Rick Sanders

Thanks!

I realized what I did afterwards. Just coping and pasting code isn't the
best way to do things always. I re-coded it and it works great thanks!

Rick

-Original Message-
From: Phillip Vector [mailto:vec...@mostdeadlygame.com] 
Sent: Sunday, October 17, 2010 6:06 PM
To: cf-talk
Subject: Re: cfif contains


1. No need for # inside the cfif. :)

2. You shouldn't need to trim it if you use a contains.

3. You set CPU to a single value of AMD. Therefore, cpu.description
doesn't exist anymore.

On Sun, Oct 17, 2010 at 2:03 PM, Rick Sanders c...@webenergy.ca wrote:

 How can I do a cfif contains?

 Error I am getting:

 You have attempted to dereference a scalar variable of type class
 java.lang.String as a structure with members.


 The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6

 4 : cfif #Trim(cpu.description)# contains AMD
 5 : cfset cpu = AMD
 6 :     cfif #Trim(cpu.description)# contains AM2


 I hope someone can shed some light on this. thanks!

 Rick





 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338260
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Reading text files

2010-10-01 Thread Rick Sanders

Nice to see some people still have a sense of humor!

Rick Sanders
Webenergy
www.webenergy.ca

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Friday, October 01, 2010 2:34 PM
To: cf-talk
Subject: Re: Reading text files


 what about make coffee, and bring my slippers and the morning paper. If it
could do that CF would truly rock.

I don't know if CF can do that. Java can do that, but if you're not
extremely careful, you'll end up drinking the outflow from the toilet,
getting your feet cut off and having the paper stuffed up your ass.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337750
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Chat or IM program

2010-09-17 Thread Rick Sanders

Hey all,

I was wondering if there is a chat or IM program out there in CF similar to
Facebook. It's for a dating website.

Coding this from scratch would take awhile so if someone knows of anything
let me know.

Thanks,

Rick



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337174
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Chat or IM program

2010-09-17 Thread Rick Sanders

Thanks, but if there's something out there already that I can build on it
would be much quicker. There's alot of open source PhP and .net stuff out
there so I was hoping for something in CF. I'm on a time constraint with a
project.

Rick

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Friday, September 17, 2010 9:21 AM
To: cf-talk
Subject: RE: Chat or IM program


I have to say that these are the easiest of things to program, especially
with Enterprise and gateways. But just as easy with ExtJS or JQuery in
standard editions.

The basics are sending and receive, and who receives. The client is this
easiest part and the server side is not as hard and just needs to know who
to push the info too.


Regards,
Andrew Scott
http://www.andyscott.id.au/


 -Original Message-
 From: Rick Sanders [mailto:c...@webenergy.ca]
 Sent: Friday, 17 September 2010 10:10 PM
 To: cf-talk
 Subject: Chat or IM program
 
 
 Hey all,
 
 I was wondering if there is a chat or IM program out there in CF similar
to
 Facebook. It's for a dating website.
 
 Coding this from scratch would take awhile so if someone knows of anything
 let me know.
 
 Thanks,
 
 Rick
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-
 Dinowitz/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:337174
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337176
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Chat or IM program

2010-09-17 Thread Rick Sanders

Thanks but I don't want a third party hosting the chat for me. I want to
host it and link it with my database of existing users so when they login to
the site, they get logged in to the chat as well.

I already looked on Google and all I found was thousands of companies that
offer chat software but they host it. Some are Java, some are not.

If anyone has a better direction to point me in, please let me know.

Rick

-Original Message-
From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] 
Sent: Friday, September 17, 2010 10:25 AM
To: cf-talk
Subject: Re: Chat or IM program


Wondering if something like this might be up your alley...

http://www.forta.com/blog/index.cfm/2007/2/12/ColdFusion-IM-Gateways-Power-I
Mified
http://www.imified.com/
IMified http://www.imified.com/ is an IM based productivity tool that
works across all the major networks and offers access to a number of popular
web applications, as well as tools like notes, reminders, and to-do's all in
your favorite IM client. The service just launched on February 5th, and has
been adding lots and lots of users, and getting lots of positive feedback.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337184
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Chat or IM program

2010-09-17 Thread Rick Sanders

Russ, I am actually waiting for the confirmation email to activate my
account to try the IM bot.

Thanks,

Rick

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Friday, September 17, 2010 1:55 PM
To: cf-talk
Subject: Re: Chat or IM program


Rick, did you actually look at the coldfusion solution I gave ?

On Fri, Sep 17, 2010 at 4:06 PM, Rick Sanders c...@webenergy.ca wrote:


 Thanks but I don't want a third party hosting the chat for me. I want to
 host it and link it with my database of existing users so when they login
 to
 the site, they get logged in to the chat as well.

 I already looked on Google and all I found was thousands of companies that
 offer chat software but they host it. Some are Java, some are not.

 If anyone has a better direction to point me in, please let me know.

 Rick

 -Original Message-
 From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com]
 Sent: Friday, September 17, 2010 10:25 AM
 To: cf-talk
 Subject: Re: Chat or IM program


 Wondering if something like this might be up your alley...



http://www.forta.com/blog/index.cfm/2007/2/12/ColdFusion-IM-Gateways-Power-I
 Mified
 http://www.imified.com/
 IMified http://www.imified.com/ is an IM based productivity tool that
 works across all the major networks and offers access to a number of
 popular
 web applications, as well as tools like notes, reminders, and to-do's all
 in
 your favorite IM client. The service just launched on February 5th, and
has
 been adding lots and lots of users, and getting lots of positive feedback.




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337189
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Chat or IM program

2010-09-17 Thread Rick Sanders

Thanks James. I didn't think to search coldfusion chat. I searched up
hundereds of java ones.

Rick

-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com] 
Sent: Friday, September 17, 2010 12:58 PM
To: cf-talk
Subject: Re: Chat or IM program


Fourth link down searching for coldfusion chat room on Google:

http://www.opensourcecf.com/cfopenchat/

--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/



On 17 September 2010 23:06, Rick Sanders c...@webenergy.ca wrote:

 Thanks but I don't want a third party hosting the chat for me. I want to
 host it and link it with my database of existing users so when they login
to
 the site, they get logged in to the chat as well.

 I already looked on Google and all I found was thousands of companies that
 offer chat software but they host it. Some are Java, some are not.

 If anyone has a better direction to point me in, please let me know.

 Rick

 -Original Message-
 From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com]
 Sent: Friday, September 17, 2010 10:25 AM
 To: cf-talk
 Subject: Re: Chat or IM program


 Wondering if something like this might be up your alley...


http://www.forta.com/blog/index.cfm/2007/2/12/ColdFusion-IM-Gateways-Power-I
 Mified
 http://www.imified.com/
 IMified http://www.imified.com/ is an IM based productivity tool that
 works across all the major networks and offers access to a number of
popular
 web applications, as well as tools like notes, reminders, and to-do's all
in
 your favorite IM client. The service just launched on February 5th, and
has
 been adding lots and lots of users, and getting lots of positive feedback.




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337190
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Extracting part of a string

2010-07-20 Thread Rick Sanders

Hey All,

 

What I need is simple, but I'm struggling with how to do it. I want to
extract everything between [y] and [/y] example:

[y] http://www.youtube.com/watch?v=uBV00ZGkRJ0[/y]

 

I just want to extract the URL between the opening and closing y tags.

 

Thanks!

 

Rick Sanders

www.webenergy.ca

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335527
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Extracting part of a string

2010-07-20 Thread Rick Sanders

Thank you Andy, this was most helpful!

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com] 
Sent: Tuesday, July 20, 2010 11:49 AM
To: cf-talk
Subject: RE: Extracting part of a string


Assuming there's nothing more to your search, then this regex would do you
fine:

\[y\](.+)\[/y\] 

-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: Tuesday, July 20, 2010 9:23 AM
To: cf-talk
Subject: Extracting part of a string


Hey All,

 

What I need is simple, but I'm struggling with how to do it. I want to
extract everything between [y] and [/y] example:

[y] http://www.youtube.com/watch?v=uBV00ZGkRJ0[/y]

 

I just want to extract the URL between the opening and closing y tags.

 

Thanks!

 

Rick Sanders

www.webenergy.ca

 








~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335544
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Facebook Connect and coldfusion

2010-07-19 Thread Rick Sanders

Awesome! Thank you for posting this!

Rick Sanders
Webenergy
www.webenergy.ca

-Original Message-
From: Jeff Gladnick [mailto:jeff.gladn...@gmail.com] 
Sent: Monday, July 19, 2010 8:16 PM
To: cf-talk
Subject: Re: Facebook Connect and coldfusion


I finally got this roughly working using some different code:

http://facebookgraph.riaforge.org/ 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335509
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Remove html characters

2010-05-18 Thread Rick Sanders

Hey all,

 

What's the best way to remove html characters and make something plain text?
reReplace?

 

Thanks,

 

Rick

Webenergy

 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333773
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Remove html characters

2010-05-18 Thread Rick Sanders

That's what I thought. I would have to put all the tags in there I want to
remove like div, strong, font, etc...

Thanks.

-Original Message-
From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
Sent: Tuesday, May 18, 2010 10:57 AM
To: cf-talk
Subject: RE: Remove html characters


Try this...

cfset html = 'pa href=test with link/a /p' 
 
cfset withoutHtml = REReplaceNoCase(html,a .*(href=[']?)([^' ]+)['
][^]+([^]+)/a,\3: \2,all) 
cfset withoutHtml = REReplaceNoCase(withoutHtml,p[^]*,Chr(10),all) 
cfset withoutHtml = REReplaceNoCase(withoutHtml,[^]+,,all) 
cfoutput#withoutHtml#/cfoutput

Paul Alkema
http://Paulalkema.com/



-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: Tuesday, May 18, 2010 9:38 AM
To: cf-talk
Subject: Remove html characters


Hey all,

 

What's the best way to remove html characters and make something plain text?
reReplace?

 

Thanks,

 

Rick

Webenergy

 

 








~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333775
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Error trapping

2010-05-18 Thread Rick Sanders

Hey all,

 

I've tried using the cferror tag and having the error emailed to me but
instead it throws an http 500 error and the error doesn't get emailed.

 

What's the easiest way to have an error on a cfm page trapped, emailed, and
then redirected to an error page?

 

Thanks,

 

Rick

 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Joomla?

2010-04-19 Thread Rick Sanders

I am curious to know if there's any Open-source free ColdFusion CMS out
there like Joomla?

 

Joomla is the latest craze in CMS making it easy for people to manage their
own websites. I'm wondering if there's anything comparable in CF? Currently
I build my own CMS depending on the site I'm doing for my client.

 

Thanks

Rick

Webenergy

 

 




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333014
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Joomla?

2010-04-19 Thread Rick Sanders

Hey thanks for the link!

I just don't like losing to Joomla because of the fact it's free and many
not for profits use it.

-Original Message-
From: Jordan Michaels [mailto:jor...@viviotech.net] 
Sent: Monday, April 19, 2010 9:40 PM
To: cf-talk
Subject: Re: Joomla?


+1 for Mura. Great CMS system and a great price too! (free)

http://www.getmura.com/



Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Open BlueDragon Steering Committee
Railo Community Distributions


Rick Mason wrote:
 Take a look at Mura. Not as full featured yet but its only a little over a
 year old.
 
 On Apr 19, 2010 8:00 PM, Rick Sanders c...@webenergy.ca wrote:
 
 
 I am curious to know if there's any Open-source free ColdFusion CMS out
 there like Joomla?
 
 
 
 Joomla is the latest craze in CMS making it easy for people to manage
their
 own websites. I'm wondering if there's anything comparable in CF?
Currently
 I build my own CMS depending on the site I'm doing for my client.
 
 
 
 Thanks
 
 Rick
 
 Webenergy
 
 
 
 
 
 
 
 
 
 
 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333018
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


http header

2010-04-05 Thread Rick Sanders

I need to assign the http header to export a document to excel from the web.

 

Here's an example from another programming language. I assign a variable
called httpHeader and it changes the http header to an excel document. How
can I do the same thing in Cold Fusion?

 

HTTP/1.0 200 OK@CRLFContent-Disposition:
attachment;filename=mydoc.xls@CRLFContent-Type:
application/msexcel@CRLFCache-control: private@CRLF@CRLF

 

Thanks,

 

Rick Sanders

Webenergy

www.webenergy.ca

 




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332568
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: http header

2010-04-05 Thread Rick Sanders

Thank you!

This was very helpful for me to get the proper syntax!

-Original Message-
From: Wil Genovese [mailto:jugg...@visi.com] 
Sent: Monday, April 05, 2010 11:59 AM
To: cf-talk
Subject: Re: http header


I normally push MP3 files including sending the filesize so the browser
knows how much there is to download and can display the status correctly.
So I just swapped out the values for your excel file and this should work
for you.

cfset filename = mydoc.xls
cfset foldername = [path to file]
cfdirectory action=list directory=#foldername# filter=#filename#
name=fileSize

cfheader name=Content-Disposition value=Attachment;
filename=#filename#
cfheader name=Expires value=#Now()#
cfheader name=Content-Length value=#fileSize.size#
cfcontent type=application/msexcel file=#foldername##filename#
deletefile=No

Wil Genovese
http://www.trunkful.com



On Mon, Apr 5, 2010 at 8:53 AM, Dave Watts dwa...@figleaf.com wrote:


  I need to assign the http header to export a document to excel from the
 web.
 
  Here's an example from another programming language. I assign a variable
  called httpHeader and it changes the http header to an excel document.
 How
  can I do the same thing in Cold Fusion?
 
  HTTP/1.0 200 OK@CRLFContent-Disposition:
  attachment;filename=mydoc.xls@CRLFContent-Type:
  application/msexcel@CRLFCache-control: private@CRLF@CRLF

 You can use the CFCONTENT and CFHEADER tags to do this.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332582
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


java.lang.String as a structure with members

2010-04-05 Thread Rick Sanders

I've done this a dozen times before, and now the following code gives me
this error:

You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members.

 

This is the line throwing the error:

cfset logo1 = #Trim(t1.Logo)#

 

The logo being pulled from the database is just the image name logo.jpg

 

cfquery name=Games datasource=hockey

SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games where
(GameID=#url.gameid#)

/cfquery

cfset team1 = #Games.Team1#

cfquery name=t1 datasource=hockey

SELECT Team,Logo FROM Teams WHERE (TeamID=#team1#)

/cfquery

cfset t1 = #Trim(t1.Team)#

cfset logo1 = #Trim(t1.Logo)#

 

Thanks,

 

Rick

Webenergy

www.webenergy.ca

 




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: java.lang.String as a structure with members

2010-04-05 Thread Rick Sanders

Thanks,

I realized it after I saw I didn't have the cfoutput tags after the queries!

Rick

-Original Message-
From: Tony Bentley [mailto:cascadefreehee...@gmail.com] 
Sent: Monday, April 05, 2010 4:34 PM
To: cf-talk
Subject: Re: java.lang.String as a structure with members


Your query assumes that there is only one row expected. What happens when
you put the cfset inside of a cfoutput query tag? How many records are
there? See my modified markup below.


cfquery name=Games datasource=hockey

SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games
where
(GameID=#url.gameid#)

/cfquery


cfoutput query=Games


cfset team1 = #Games.Team1#



cfquery name=t1 datasource=hockey

SELECT Team,Logo FROM Teams WHERE (TeamID=#team1#)

/cfquery



cfoutput query=Games

cfset t1 = #Trim(t1.Team)#

cfset logo1 = #Trim(t1.Logo)#

/cfoutput


/cfoutput




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332607
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: IE8 is killing my website

2010-02-02 Thread Rick Sanders

This seems to only be a problem on Windows XP. Myself nor my clients have
problems with IE8 on Vista or Windows 7.

Are your users on a network on an Active Directory domain with a domain
policy? If the Server hasn't been updated with the new IE8 policies, then it
defaults to the IE7 policies which are different than IE8.

In the Internet options, particularly the Privacy tab, the Medium setting
restricts 1st party cookies that save information that can be used to
contact you without consent. This setting is default in IE8.

If you're using an older version of CF server than 8, it may be time to
think about upgrading. I have not had any issues with IE8 on any Windows
platform with 1st party cookies.

Rick Sanders
Canada: 902-431-7279
USA: 919-799-9076
www.webenergy.ca

-Original Message-
From: subscripti...@advantex.net [mailto:subscripti...@advantex.net] 
Sent: Tuesday, February 02, 2010 1:34 PM
To: cf-talk
Subject: IE8 is killing my website


The curse of the Microsoft browsers continues.  This time, it's not even a
design issue, it's a functional issue, and it's ruining our user experience.
 
Plainly put, a certain subset of IE8 users are unable to log in to our site.
Mind you, this is a signup/login process that has worked, literally for
years.  Along comes IE8, and suddenly there has to be a problem.
 
It appears that IE8 is not storing our cookies, that track a successful
login.  Every other browser works fine.  Some group of IE8 users, however,
get our successful login screen, but when they click to go to a members
area of the site, they are NOT logged in.
 
We've done everything, including the setup of a P3P policy.  This should
work, for everyone, but it does not.  I'm at my wits end here, and
embarrassed as hell that I can't figure out what this issue is.  I can't
even reproduce it here, but I've seen it happen via remote desktop on some
(gracious) member's PCs.
 
We've tried telling them to check their security settings, clear cache,
clear cookies, and more.  But damn, they shouldn't HAVE to do all this
stuff.  Not this many people (and growing).  They can accept cookies and
view other sites (presumably), just not ours.
 
I need ideas... fast.  Can I solicit the help of the CF community on this?
I have no idea where else to look.
 
Thanks,
 
Marc 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330367
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: hosting

2010-01-14 Thread Rick Sanders

We also host CF:
http://host.webenergy.ca/plans.htm

Executive Plan is for CF

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: January-14-10 11:01 AM
To: cf-talk
Subject: Re: hosting


http://hostek.com/
Plans start $5

I have hosted with them on a couple of sites. Over all I was pleased. They
have good support for the price. Much better than I expected. They will work
to keep your business (or did with me) They also have CF 9.

HTH

On Thu, Jan 14, 2010 at 9:40 AM, Scott Stewart
sstwebwo...@bellsouth.netwrote:


 Ray,

 I appreciate the sentiment, but right now cheap is all I can do

 -Original Message-
 From: Raymond Camden [mailto:rcam...@gmail.com]
 Sent: Thursday, January 14, 2010 9:20 AM
 To: cf-talk
 Subject: Re: hosting


 Please consider how cheap you want to go. Your host is like the
 foundation of your business. Would you set up your store on top of a
 volcano? Quicksand? Cheap isn't always the way you want to go for
 hosts.

 On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com
 wrote:
 
  I've used atoz before, and it was just an aweful experience all around.
 I'd
  vote no to atoz.
 
 



 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329668
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Load-balancing servers

2009-12-10 Thread Rick Sanders

I have 2 Cold Fusion Enterprise servers. What I would like to do is balance
the load between 2 machines, and maybe more in the future. I have a very
large and demanding portal app that is going live soon. I've looked over the
documentation and it doesn't seem to cover much about it. Can anyone offer
some insight on this?

 

I know I'll have to change any absolute paths to UNC paths and set up any
ODBC databases, but is there anything else from the app side I need to do?

 

Thanks!

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329036
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Load-balancing servers

2009-12-10 Thread Rick Sanders

Thanks Shannon but I'm running on Windows Server.

Rick

-Original Message-
From: Shannon Peevey [mailto:spee...@stolaf.edu] 
Sent: December-10-09 12:26 PM
To: cf-talk
Subject: Re: Load-balancing servers


Here is a couple of Clustering FAQs that I wrote back in 2007, which may
have some points of interest for you:
http://speeves.erikin.com/2007/02/how-to-setup-apache-2-with-coldfusion-7.ht
ml
http://speeves.erikin.com/2007/01/coldfusion-clustering-faq.html

speeves


On Thu, Dec 10, 2009 at 9:52 AM, WebSite CFTalk cft...@website.no wrote:


 Maybe something like:

 - Hardware load balancer in front of web/app servers, or NLB load
balancing
 between web/app servers (Windows)
 - Instead of UNC path to shared folders synchronize web folders/content
 folders using DFS Replication (Windows 2003 R2 - Windows 2008)
 - If windows 2008, IIS 7.5 with shared config.

 Clustering CF is covered many places, this one is good and thorough:
 http://www.bpurcell.org/viewContent.cfm?ContentID=121


 -Helge



 -Original Message-
 From: Rick Sanders [mailto:r...@webenergy.ca]
 Sent: 10. desember 2009 15:59
 To: cf-talk
 Subject: Load-balancing servers


 I have 2 Cold Fusion Enterprise servers. What I would like to do is
balance
 the load between 2 machines, and maybe more in the future. I have a very
 large and demanding portal app that is going live soon. I've looked over
 the
 documentation and it doesn't seem to cover much about it. Can anyone offer
 some insight on this?



 I know I'll have to change any absolute paths to UNC paths and set up any
 ODBC databases, but is there anything else from the app side I need to do?



 Thanks!



 Rick Sanders

 Webenergy

 Canada: 902-431-7279

 USA:   919-799-9076

 Canada: www.webenergy.ca

 USA:   www.webenergyusa.com









 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329056
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Load-balancing servers

2009-12-10 Thread Rick Sanders

Hi Mark,

I only use cookies for client sessions. I've had too many issues with people
stealing sessions. As for files, I keep the files on one server and will
just convert the absolute paths to unc paths. I'm running full 1gb on the
internal network and the servers are brand-new so I don't forsee an issue
with speed or bandwidth. The only thing the cf server does is serve the
website. Database, email, and load-balancing servers are all separate
machines.

Rick 

-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com] 
Sent: December-10-09 12:05 PM
To: cf-talk
Subject: RE: Load-balancing servers


Rick,

The questions to ask are - what are you doing with session variabls and
client variables, and .. What are the capabilities of your chosen load
balancing method. Remember that the potential here is for a user to bounce
back and forth between your servers while surfing your site - so you have to
be able to imagine the impact of that on the user. Will he lose his session?
Will that matter?  Etc. If you are using a hardware load balancer they
typically come with choices to help mitigate these issues (like sticky
sessions for example).

As for files - you have to be able to either sync files between the servers
or use a shared file storage - and there are trade offs to each of these
approaches.

-mark
 


Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Rick Sanders [mailto:r...@webenergy.ca] 
Sent: Thursday, December 10, 2009 8:59 AM
To: cf-talk
Subject: Load-balancing servers


I have 2 Cold Fusion Enterprise servers. What I would like to do is balance
the load between 2 machines, and maybe more in the future. I have a very
large and demanding portal app that is going live soon. I've looked over the
documentation and it doesn't seem to cover much about it. Can anyone offer
some insight on this?

 

I know I'll have to change any absolute paths to UNC paths and set up any
ODBC databases, but is there anything else from the app side I need to do?

 

Thanks!

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 









~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329058
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Load-balancing servers

2009-12-10 Thread Rick Sanders

Thank you!

This is very helpful! 

Rick

-Original Message-
From: WebSite CFTalk [mailto:cft...@website.no] 
Sent: December-10-09 11:53 AM
To: cf-talk
Subject: RE: Load-balancing servers


Maybe something like:

- Hardware load balancer in front of web/app servers, or NLB load balancing
between web/app servers (Windows)
- Instead of UNC path to shared folders synchronize web folders/content
folders using DFS Replication (Windows 2003 R2 - Windows 2008) 
- If windows 2008, IIS 7.5 with shared config.

Clustering CF is covered many places, this one is good and thorough:
http://www.bpurcell.org/viewContent.cfm?ContentID=121


-Helge



-Original Message-
From: Rick Sanders [mailto:r...@webenergy.ca] 
Sent: 10. desember 2009 15:59
To: cf-talk
Subject: Load-balancing servers


I have 2 Cold Fusion Enterprise servers. What I would like to do is balance
the load between 2 machines, and maybe more in the future. I have a very
large and demanding portal app that is going live soon. I've looked over the
documentation and it doesn't seem to cover much about it. Can anyone offer
some insight on this?

 

I know I'll have to change any absolute paths to UNC paths and set up any
ODBC databases, but is there anything else from the app side I need to do?

 

Thanks!

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 









~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329057
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Custom scopes

2009-09-21 Thread Rick Sanders

Hey All. Quick question, can I define custom scopes for my variables in CF?

 

Example:

cfset myscope.var = myvar

 

I've searched the documentation and didn't see anything on it.

 

Thanks,

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326456
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Custom scopes

2009-09-21 Thread Rick Sanders

Thanks. Makes sense I have to create the scope before assigning a var to it!

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: September-21-09 1:50 PM
To: cf-talk
Subject: Re: Custom scopes


In other words, you're implicitly creating a structure called 'myscope' with
a key called 'var' (and then that structure gets put into the
local/variables scope anyways).

On Mon, Sep 21, 2009 at 9:46 AM, Alan Rother alan.rot...@gmail.com wrote:


 Of course.
 However... what you have really done is create a variable called

 variables.myscope.var


 =]

 --
 Alan Rother
 Adobe Certified Advanced ColdFusion MX 7 Developer
 Manager, Phoenix Cold Fusion User Group, AZCFUG.org


 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326460
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Custom scopes

2009-09-21 Thread Rick Sanders

I have 2 forums I want to host in CF on one server and the vars are shared.
So if I put both forums on the server, the vars will interchange between the
2 forums even if they are on different domains. So instead of going and
changing all the names of the vars in the application scope, I would just
assign the vars to a new scope and call them from there. Easy find/replace
in DW that takes a minute and fixes the issue. It's cfbb.

Rick

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: September-21-09 2:43 PM
To: cf-talk
Subject: Re: Custom scopes


No, you don't have to create the 'scope' first.  Just saying:

cfset myScope.name = Charlie /

will implictly create a struct called myScope with a key of name.

but, as Cameron points out... referring to this as a custom scope will
likely lead to confusion.

Might be a good idea to back up a step or two and ask why you're looking to
do this?

On Mon, Sep 21, 2009 at 10:30 AM, Rick Sanders c...@webenergy.ca wrote:


 Thanks. Makes sense I have to create the scope before assigning a var to
 it!

 -Original Message-
 From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
 Sent: September-21-09 1:50 PM
 To: cf-talk
 Subject: Re: Custom scopes


 In other words, you're implicitly creating a structure called 'myscope'
 with
 a key called 'var' (and then that structure gets put into the
 local/variables scope anyways).

 On Mon, Sep 21, 2009 at 9:46 AM, Alan Rother alan.rot...@gmail.com
 wrote:

 
  Of course.
  However... what you have really done is create a variable called
 
  variables.myscope.var
 
 
  =]
 
  --
  Alan Rother
  Adobe Certified Advanced ColdFusion MX 7 Developer
  Manager, Phoenix Cold Fusion User Group, AZCFUG.org
 
 
 



 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326466
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Replacing characters in a string

2009-08-19 Thread Rick Sanders

Hey all,

 

I'm trying to replace a hyperlink and just display the text. I need to
remove the a href=http://www.google.ca;www.google.ca
http://www.google.ca%3c/a /a from text within fckeditor and just display
the text www.google.ca I tried finding a setting for the editor so it
doesn't automatically create hyperlinks when you type www. Or http:// but
didn't see such a setting.

 

Here's what I have so far:

cfset ad = Replace(#form.addesc#, http://,;)

cfset ad2 = Replace(#ad#, a href=#chr(34)#,)

cfset ad3 = Replace(#ad2#, #chr(34)#,)

cfset ad4 = Replace(#ad3#, /a,)

cfoutput#ad4#/cfoutput

 

It works, but it duplicates the link. How can I remove the duplicate?

 

Thanks,

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325545
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Replacing characters in a string

2009-08-19 Thread Rick Sanders

Hello Andy  Jason,

Thank you so much, this worked well. I wasn't sure of the syntax so this
really helped.

Kind regards,

Rick

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com] 
Sent: August-19-09 6:19 PM
To: cf-talk
Subject: RE: Replacing characters in a string


Just so you know, this is what that expression is doing:

/ - literal string
? - zero or one
a - literal string
[^] - character set which says everything BUT 
* - zero or more times
 - literal string

So the expression says
1) Look for a 
2) With zero or one /
3) Followed by a
4) Any character (but ) any number of times
5) Followed by a 

This wouldn't match anchor tags with upper case, but could be changed like
so:

/?[a|A][^]*

And I think it might be best to use a lazy match:

/?[a|A][^]+

The plus says one or more rather than zero or more like the kleene star.


Andy matthews


 

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: Wednesday, August 19, 2009 2:38 PM
To: cf-talk
Subject: re: Replacing characters in a string


Try this:

cfset ad = reReplace(form.addesc, (/?a[^]*), , all) /
 






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325553
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Invalid parameter binding - again!

2009-07-28 Thread Rick Sanders

Hey all,

 

I've tried adding params on all fields, then only some. I've changed the
type from clob to varchar to char.. I still get the same error. Help
please, thanks!

 

cfquery name=bus datasource=ConnectNS

INSERT INTO dbo.Businesses INSERT INTO dbo.Businesses
(CountyID,CityID,CategoryID,SubCatID,SubCat2ID,BusinessName,Address,Zip,Tele
phone,Fax,Email,Website,TypeID,DateListed,Paid) VALUES
(#county.countyid#,#form.city#,#form.combo0#,#form.combo1#,#form.combo2#,'c
fqueryparam value=#FORM.compname# cfsqltype=cf_sql_clob
maxlength=25','cfqueryparam value=form.address
cfsqltype=CF_SQL_VARCHAR','cfqueryparam value=form.zip
cfsqltype=CF_SQL_VARCHAR','#form.area#-#form.prefix#-#form.suffix#','#for
m.farea#-#form.fprefix#-#form.fsuffix#','cfqueryparam value=form.email
cfsqltype=CF_SQL_VARCHAR','cfqueryparam value=form.website
cfsqltype=CF_SQL_VARCHAR',2,'#today#','No')

/cfquery

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325052
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Invalid parameter binding - again! ignore

2009-07-28 Thread Rick Sanders

Hey all,

 

I found the problem. Seems just posting the question fixed it, lol!

 

Rick Sanders

 

 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325053
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Invalid parameter binding - again!

2009-07-28 Thread Rick Sanders

Thanks. I did have it right, but I was trying different things to get it to
work to the query got messed up. I did end up figuring it out though.

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: July-28-09 5:09 PM
To: cf-talk
Subject: re: Invalid parameter binding - again!


Don't put ' marks around CFQUERYPARAM ... it already handles that for you.  
Also, you were missing pound signs around several of the params.

INSERT INTO dbo.Businesses (
CountyID, 
CityID, 
CategoryID, 
SubCatID, 
SubCat2ID, 
BusinessName, 
Address, 
Zip, 
Tele
phone, 
Fax, 
Email, 
Website, 
TypeID, 
DateListed, 
Paid
) VALUES (
#county.countyid#, 
#form.city#, 
#form.combo0#, 
#form.combo1#, 
#form.combo2#, 
cfqueryparam value=#FORM.compname# cfsqltype=cf_sql_varchar 
maxlength=25, 
cfqueryparam value=#form.address# cfsqltype=CF_SQL_VARCHAR, 
cfqueryparam value=#form.zip# cfsqltype=CF_SQL_VARCHAR, 
'#form.area#-#form.prefix#-#form.suffix#', 
'#form.farea#-#form.fprefix#-#form.fsuffix#', 
cfqueryparam value=#form.email# cfsqltype=CF_SQL_VARCHAR, 
cfqueryparam value=#form.website# cfsqltype=CF_SQL_VARCHAR, 
2, 
'#today#', 
'No'
)

 




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325057
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Weird error

2009-07-14 Thread Rick Sanders

OK, I'm updating a record in my MSSQL database table. The column that's
causing the error is an ntext column.

 

The error I'm getting is:

[Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s).

 

Here's my SQL query:

cfquery name=upcourse datasource=cft

UPDATE dbo.Courses  SET
CourseName='#Trim(form.coursename)#',CourseDesc='cfqueryPARAM value =
#form.coursedesc# CFSQLType =
'CF_SQL_longvarchar'',Cost=#form.cost#,MaxStudents=#form.maxstudents# WHERE
(CourseID=#url.courseid#)

/cfquery  

 

I'm sending the data from FCK editor. I've done this before and never had a
problem.

 

Thanks,

 

Rick





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324488
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Weird error

2009-07-14 Thread Rick Sanders

When I do that I get this error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.

The only html tags in the content are p and br /.

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: July-14-09 4:00 PM
To: cf-talk
Subject: re: Weird error


Lose the single quotes around the CFQUERYPARAM ... it already handles that 
for you:

UPDATE dbo.Courses 
SET CourseName = '#Trim(form.coursename)#', 
CourseDesc = cfqueryPARAM value=#form.coursedesc# 
CFSQLType=CF_SQL_longvarchar /, 
Cost = #form.cost#, 
MaxStudents = #form.maxstudents#
WHERE CourseID = #url.courseid#

(and go ahead and use CFQUERYPARAM on all the variables :)
 




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324491
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Weird error

2009-07-14 Thread Rick Sanders

Tried and still getting the same error. [Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near ''.

cfquery name=upcourse datasource=cft
UPDATE dbo.Courses  SET CourseName=cfqueryPARAM value = #form.coursename#
CFSQLType = CF_SQL_varchar,CourseDesc=cfqueryPARAM value =
#form.coursedesc1# CFSQLType = CF_SQL_varchar,Cost=cfqueryPARAM value
= #form.cost# CFSQLType = CF_SQL_money,MaxStudents=cfqueryPARAM value
= #form.maxstudents# CFSQLType = CF_SQL_integer WHERE
(CourseID=#url.courseid#)
/cfquery  

I'm stumped!

-Original Message-
From: Matthew [mailto:a.matthe...@yahoo.com] 
Sent: July-14-09 4:13 PM
To: cf-talk
Subject: Re: Weird error


Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam
all the variables.  

Matt.

On 14 Jul 2009, at 20:06, Rick Sanders c...@webenergy.ca wrote:


When I do that I get this error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.

The only html tags in the content are p and br /.

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: July-14-09 4:00 PM
To: cf-talk
Subject: re: Weird error


Lose the single quotes around the CFQUERYPARAM ... it already handles that 
for you:

UPDATE dbo.Courses 
SET CourseName = '#Trim(form.coursename)#', 
   CourseDesc = cfqueryPARAM value=#form.coursedesc# 
CFSQLType=CF_SQL_longvarchar /, 
   Cost = #form.cost#, 
   MaxStudents = #form.maxstudents#
WHERE CourseID = #url.courseid#

(and go ahead and use CFQUERYPARAM on all the variables :)









~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324493
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Weird error

2009-07-14 Thread Rick Sanders

I found the error.

I changed my form to a cfform. I'm passing the coursed from the query in
the url: courseid=#courses.courseid#. When it was in the form tag I had to
wrap cfoutput around the variable. When I changed it to a cfform I
forgot to remove the cfoutput tags because it didn't need them.

Thanks for all your help!

-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: July-14-09 4:38 PM
To: cf-talk
Subject: RE: Weird error


Tried and still getting the same error. [Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near ''.

cfquery name=upcourse datasource=cft
UPDATE dbo.Courses  SET CourseName=cfqueryPARAM value = #form.coursename#
CFSQLType = CF_SQL_varchar,CourseDesc=cfqueryPARAM value =
#form.coursedesc1# CFSQLType = CF_SQL_varchar,Cost=cfqueryPARAM value
= #form.cost# CFSQLType = CF_SQL_money,MaxStudents=cfqueryPARAM value
= #form.maxstudents# CFSQLType = CF_SQL_integer WHERE
(CourseID=#url.courseid#)
/cfquery  

I'm stumped!

-Original Message-
From: Matthew [mailto:a.matthe...@yahoo.com] 
Sent: July-14-09 4:13 PM
To: cf-talk
Subject: Re: Weird error


Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam
all the variables.  

Matt.

On 14 Jul 2009, at 20:06, Rick Sanders c...@webenergy.ca wrote:


When I do that I get this error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.

The only html tags in the content are p and br /.

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: July-14-09 4:00 PM
To: cf-talk
Subject: re: Weird error


Lose the single quotes around the CFQUERYPARAM ... it already handles that 
for you:

UPDATE dbo.Courses 
SET CourseName = '#Trim(form.coursename)#', 
   CourseDesc = cfqueryPARAM value=#form.coursedesc# 
CFSQLType=CF_SQL_longvarchar /, 
   Cost = #form.cost#, 
   MaxStudents = #form.maxstudents#
WHERE CourseID = #url.courseid#

(and go ahead and use CFQUERYPARAM on all the variables :)











~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324495
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Values in a loop

2009-04-30 Thread Rick Sanders

Hey Jason,

Thanks! It worked after I moved it like you suggested.

Rick

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: April-30-09 8:17 AM
To: cf-talk
Subject: Re: Values in a loop


An unchecked checkbox doesn't exist in the subsequent form scope.  Move 
your CFIF up above your CFSET's:

cfloop index=pmt from = 1 to = #form.numrows#
cfif isDefined(form.paid_#pmt#) and Trim(pd) eq Confirmed

cfset pd=form['paid_'  pmt]

cfset rid=form['regid_'  pmt]


cfquery datasource=#dsn# name=upreg

UPDATE dbo.ShowRegistration  SET Payment='Confirmed' WHERE
(RegistrationID=#rid#)

/cfquery





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322076
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Values in a loop

2009-04-30 Thread Rick Sanders

OK, I'm a little stumped here.

 

I have a loop that has 17 rows. It's looping over results from the database
on a pervious page:

cfloop index=pmt from = 1 to = #form.numrows#

 

What I need to do is grab the form value from the previous page. It's a
checkbox:

input type=checkbox name=paid_#reg.currentrow# value=Confirmed cfif
#Trim(reg.payment)# eq Confirmedchecked/cfif

 

Next I want to store it in the database with the value:

cfloop index=pmt from = 1 to = #form.numrows#

cfset pd=#form['paid_'  pmt]#

cfset rid=#form['regid_'  pmt]#

cfif isDefined(form.paid_#pmt#) and #Trim(pd)# eq Confirmed

cfquery datasource=#dsn# name=upreg

UPDATE dbo.ShowRegistration  SET Payment='Confirmed' WHERE
(RegistrationID=#rid#)

/cfquery

 

When I try to run it I get the following error:

Element paid_1 is undefined in a Java object of type class
coldfusion.filter.FormScope.


The error occurred in E:\Websites\gmclubofns\forum\updpayment.cfm: line 10


8 : body

9 : cfloop index=pmt from = 1 to = #form.numrows#

10 : cfset pd=#form['paid_'  pmt]#

11 : cfif isDefined(form.paid_#pmt#) and #Trim(pd)# eq Confirmed

12 : cfset rid=#form['regid_'  pmt]#

 

 

What am I doing wrong? Am I referencing the values in a loop correctly?
Thank you for your help.

 

Rick

 

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322074
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


No SQL Update!

2009-02-03 Thread Rick Sanders

I've been trying to figure this one out. The query gets hit, but the
database isn't being updated from the values in the form. The columns seem
valid, and the table permissions are fine.

 

I'm using SQL Server 2005.

 

Here's the query:

 

UPDATE dbo.Vehicles  SET
StockNo='#form.stockno#',CarMake=#form.make#,CarModel='#form.model#',ModelTr
im='#form.trim#',CarYear=#form.caryear#,Category=#form.category#,Mileage='#f
orm.mileage#',unit='km',VIN='#form.vin#',EngineSize='#form.engine#',Transmis
sion='#form.trans#',Drivetrain='#form.drivetrain#',Price=#form.price#,Warran
ty='#form.warranty#',Description='#form.description#',Inspected='#form.mm#',
Financing='#form.financing#',Leasing='#form.leasing#',Active='#form.active#'
,Featured='#form.featured#',Pic1='#pic1#',Pic2='#pic2#',Pic3='#pic3#',Pic4='
#pic4#',thumb1='#pic1t#',thumb2='#pic2t#',thumb3='#pic3t#',thumb4='#pic4t#',
Sold='#form.sold#',SoldPrice=#form.soldamt#,VehicleCost=#form.cost#,MVIcost=
#form.mvicost#,Reconditioning='#form.reconditioning#',ReconditioningCost=#fo
rm.reconcost#,Parts='#form.parts#',PartsCost=#form.partscost#,Labour='#form.
labour#',LabourCost=#form.labourcost# WHERE (StockNo='#form.carid#')

 

Thanks for any help!

 

Rick Sanders

Webenergy





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318805
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: No SQL Update!

2009-02-03 Thread Rick Sanders

Here are the values being passed:

UPDATE dbo.Vehicles SET StockNo='012',CarMake=31,CarModel='ION ',ModelTrim='
',CarYear=2004,Category=1,Mileage='135,000 ',unit='km',VIN='
',EngineSize='4cyl',Transmission='Automatic',Drivetrain='Front Wheel
Drive',Price=4300.00,Warranty='Yes',Description=' 2004 Saturn Ion, 4
Cylinder 5 speed standard, that is fully loaded and is in excellent
condition. This car has Air conditioning, Power locks, windows, Keyless
entry, and more. This car has 135,00,000kms that has just been MVI''d, new
front brakes, 4 brand new tires with snows on the front.. This car works and
looks like new, a must drive, this car looks like new inside, non
smoker',Inspected='12/09
',Financing='No',Leasing='No',Active='Yes',Featured='Yes',Pic1='012_1.jpg',P
ic2='012_2.jpg',Pic3='012_3.jpg',Pic4='012_4.jpg',thumb1='012thumb_1.jpg',th
umb2='012thumb_2.jpg',thumb3='012thumb_3.jpg',thumb4='012thumb_4.jpg',Sold='
Yes',SoldPrice=0,VehicleCost=0,MVIcost=0,Reconditioning='N/A',Reconditioning
Cost=0,Parts='N/A',PartsCost=0,Labour='N/A',LabourCost=0 WHERE (StockNo='3')


No errors from CF or the database! SELECT statements work no problem either.
I can pull up anything from the DB.

This is a weird one!

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: February-03-09 8:39 PM
To: cf-talk
Subject: Re: No SQL Update!


 I've been trying to figure this one out. The query gets hit, but the
 database isn't being updated from the values in the form. The columns seem
 valid, and the table permissions are fine.

What does your debug output show?

Are you setting the form variable used in the WHERE clause?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318808
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: No SQL Update!

2009-02-03 Thread Rick Sanders

Problem fixed!

My dumb error! I was trying to update by vehicle ID using the stock number!
Vehicle ID's and stock numbers are different, so no  wonder why it didn't
update.

Time to step away from the puter. Thanks for listening!

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: February-03-09 9:02 PM
To: cf-talk
Subject: Re: No SQL Update!


StockNo is a char/varchar datatype?

On Tue, Feb 3, 2009 at 4:55 PM, b...@bradwood.com wrote:


 What do you get when you run:

 SELECT *
 FROM  dbo.Vehicles
 WHERE (StockNo='3')

 ~Brad

  Original Message 
 Subject: RE: No SQL Update!
 From: Rick Sanders c...@webenergy.ca
 Date: Tue, February 03, 2009 6:46 pm
 To: cf-talk cf-talk@houseoffusion.com




 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318811
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: No SQL Update!

2009-02-03 Thread Rick Sanders

Even a nickel and I'd be happy!

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: February-03-09 9:17 PM
To: cf-talk
Subject: Re: No SQL Update!


yeah, that's one of those if i only had a dollar for every time... things
:)

On Tue, Feb 3, 2009 at 5:14 PM, Rick Sanders c...@webenergy.ca wrote:


 Problem fixed!

 My dumb error! I was trying to update by vehicle ID using the stock
number!
 Vehicle ID's and stock numbers are different, so no  wonder why it didn't
 update.

 Time to step away from the puter. Thanks for listening!

 -Original Message-
 From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
 Sent: February-03-09 9:02 PM
 To: cf-talk
 Subject: Re: No SQL Update!


 StockNo is a char/varchar datatype?

 On Tue, Feb 3, 2009 at 4:55 PM, b...@bradwood.com wrote:

 
  What do you get when you run:
 
  SELECT *
  FROM  dbo.Vehicles
  WHERE (StockNo='3')
 
  ~Brad
 
   Original Message 
  Subject: RE: No SQL Update!
  From: Rick Sanders c...@webenergy.ca
  Date: Tue, February 03, 2009 6:46 pm
  To: cf-talk cf-talk@houseoffusion.com
 
 
 
 
 



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318817
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Random Numbers

2008-11-06 Thread Rick Sanders
I'm trying to do something simple here. How do I simply pull a random
number? I looked at rand, randomize, and randrange but they are for
mathematical calculations.

 

All I want to do is define a rang (1 - 10) and pull a number in that range.

 

Thanks in advance,

 

LogoSig

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314919
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Random Numbers

2008-11-06 Thread Rick Sanders
Thanks.

I realized as I hit the send button that was it. I was looking at something
more complicated, but it was as easy as RandRange. Time to step away from
the computer!

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: November-06-08 7:53 PM
To: cf-talk
Subject: Re: Random Numbers

randRange(1, 10)?

On Thu, Nov 6, 2008 at 3:51 PM, Rick Sanders [EMAIL PROTECTED] wrote:
 I'm trying to do something simple here. How do I simply pull a random
 number? I looked at rand, randomize, and randrange but they are for
 mathematical calculations.



 All I want to do is define a rang (1 - 10) and pull a number in that
range.



 Thanks in advance,



 LogoSig

 Rick Sanders

 Webenergy

 Canada: 902-431-7279

 USA:   919-799-9076

 Canada: www.webenergy.ca

 USA:   www.webenergyusa.com







 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314922
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Adding Updating empty values

2008-10-28 Thread Rick Sanders
Hey all,

 

In my form some values may be left empty. For example a form field named q1.

It's fine if it's empty because the user can go back and fill it in later if
they wish.

 

How do I get passed the q1 is not defined in Form CF error? All I want to
do is enter an empty value. How can I allow it to do that for insert and
updates?

 

Thanks!

 

LogoSig

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314457
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
Is that the only way?

It's a questionnaire form with 50 questions! You mean I have to do a cfif
for every question and assign it a blank value if there's no value!?

-Original Message-
From: Rob Parkhill [mailto:[EMAIL PROTECTED] 
Sent: October-28-08 4:42 PM
To: cf-talk
Subject: Re: Adding  Updating empty values

wrap it in a cfif so..
cfif isundefined(form.q1)
   cfset form.q1 = 
/cfif

Rob

On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote:

 Hey all,



 In my form some values may be left empty. For example a form field named
 q1.

 It's fine if it's empty because the user can go back and fill it in later
 if
 they wish.



 How do I get passed the q1 is not defined in Form CF error? All I want
to
 do is enter an empty value. How can I allow it to do that for insert and
 updates?



 Thanks!



 LogoSig

 Rick Sanders

 Webenergy

 Canada: 902-431-7279

 USA:   919-799-9076

 Canada: www.webenergy.ca

 USA:   www.webenergyusa.com







 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314467
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
I hear you, and already did that for checkboxes. But, I have text fields and
radio buttons in my form!


-Original Message-
From: Jason Fisher [mailto:[EMAIL PROTECTED] 
Sent: October-28-08 4:47 PM
To: cf-talk
Subject: Re: Adding  Updating empty values

The other option is to use yes and no radio buttons instead of
checkboxes, where the radio buttons default to no.  That way, the field
always exists, but you still get the difference between 1 and 0.  Checkbox
that is unchecked really doesn't exist in the POST, so the CFIF solution is
pretty much required otherwise, yes.



Is that the only way?

It's a questionnaire form with 50 questions! You mean I have to do a cfif
for every question and assign it a blank value if there's no value!?

wrap it in a cfif so..
cfif isundefined(form.q1)
   cfset form.q1 = 
/cfif

Rob



to 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314479
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
Yup, you're right.

It's the radio buttons that are giving me the hassle!

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: October-28-08 5:14 PM
To: cf-talk
Subject: Re: Adding  Updating empty values

text fields are defined even if they are empty.  the value is simply an
empty string.

On Tue, Oct 28, 2008 at 12:58 PM, Rick Sanders [EMAIL PROTECTED] wrote:

 I hear you, and already did that for checkboxes. But, I have text fields
 and
 radio buttons in my form!


 -Original Message-
 From: Jason Fisher [mailto:[EMAIL PROTECTED]
 Sent: October-28-08 4:47 PM
 To: cf-talk
 Subject: Re: Adding  Updating empty values

 The other option is to use yes and no radio buttons instead of
 checkboxes, where the radio buttons default to no.  That way, the field
 always exists, but you still get the difference between 1 and 0.  Checkbox
 that is unchecked really doesn't exist in the POST, so the CFIF solution
is
 pretty much required otherwise, yes.



 Is that the only way?
 
 It's a questionnaire form with 50 questions! You mean I have to do a
 cfif
 for every question and assign it a blank value if there's no value!?
 
 wrap it in a cfif so..
 cfif isundefined(form.q1)
cfset form.q1 = 
 /cfif
 
 Rob
 
 
 
 to



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314490
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
I agree, but I still have to enter all the form field names in the cfparam
anyways so I'm not really gaining anything.

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED] 
Sent: October-28-08 5:32 PM
To: cf-talk
Subject: RE: Adding  Updating empty values

 How do I get passed the q1 is not defined in Form CF error? All I want
to
 do is enter an empty value. How can I allow it to do that for insert 
 and updates?

Actually, you'd never want to have to deal with not defined errors in your
core code. That's what cfparam is for, all form fields should be defined
(default them to  if needed) higher up, along with form field validation,
and so on.

--- Ben



-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 28, 2008 4:10 PM
To: cf-talk
Subject: Re: Adding  Updating empty values

Write a code generator for it.


fill out the form, and loop over the #Form.FIELDNAMES#

Like so

pre
cfoutput
cfloop  list=#form.FIELDNAMES# index=GO
lt;cfif isundefined(form.#GO#)
 lt;cfset form.q#GO# = 
lt;/cfif
/cfloop
/cfoutput
/pre



On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders [EMAIL PROTECTED] wrote:

 Is that the only way?

 It's a questionnaire form with 50 questions! You mean I have to do a
cfif
 for every question and assign it a blank value if there's no value!?

 -Original Message-
 From: Rob Parkhill [mailto:[EMAIL PROTECTED]
 Sent: October-28-08 4:42 PM
 To: cf-talk
 Subject: Re: Adding  Updating empty values

 wrap it in a cfif so..
 cfif isundefined(form.q1)
   cfset form.q1 = 
 /cfif

 Rob

 On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote:

  Hey all,
 
 
 
  In my form some values may be left empty. For example a form field named
  q1.
 
  It's fine if it's empty because the user can go back and fill it in
later
  if
  they wish.
 
 
 
  How do I get passed the q1 is not defined in Form CF error? All I want
 to
  do is enter an empty value. How can I allow it to do that for insert and
  updates?
 
 
 
  Thanks!
 
 
 
  LogoSig
 
  Rick Sanders
 
  Webenergy
 
  Canada: 902-431-7279
 
  USA:   919-799-9076
 
  Canada: www.webenergy.ca
 
  USA:   www.webenergyusa.com
 
 
 
 
 
 
 
 



 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314499
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
Ah! Thank you! I've been looking for resources like this! Excellent! Thank
you!

-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED] 
Sent: October-28-08 6:27 PM
To: cf-talk
Subject: Re: Adding  Updating empty values

Rick,
It may be time to make yourself acquainted with the wonderful world of code
generators. Here is a partial list of the various offerings. I make heavy
use of cfcgenerator and cfcblaster. I rarely create CRUD's by hand.


http://code.google.com/p/cfcgenerator/
http://completecodegen.riaforge.org/
http://beanmachine.riaforge.org/
http://mrmx.blogspot.com/2006/09/cfcblaster-simple-code-generator.html
http://cfcstub.riaforge.org/


Happy coding.

~G~

On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders [EMAIL PROTECTED] wrote:

 Is that the only way?

 It's a questionnaire form with 50 questions! You mean I have to do a
cfif
 for every question and assign it a blank value if there's no value!?

 -Original Message-
 From: Rob Parkhill [mailto:[EMAIL PROTECTED]
 Sent: October-28-08 4:42 PM
 To: cf-talk
 Subject: Re: Adding  Updating empty values

 wrap it in a cfif so..
 cfif isundefined(form.q1)
   cfset form.q1 = 
 /cfif

 Rob

 On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote:

  Hey all,
 
 
 
  In my form some values may be left empty. For example a form field named
  q1.
 
  It's fine if it's empty because the user can go back and fill it in
later
  if
  they wish.
 
 
 
  How do I get passed the q1 is not defined in Form CF error? All I want
 to
  do is enter an empty value. How can I allow it to do that for insert and
  updates?
 
 
 
  Thanks!
 
 
 
  LogoSig
 
  Rick Sanders
 
  Webenergy
 
  Canada: 902-431-7279
 
  USA:   919-799-9076
 
  Canada: www.webenergy.ca
 
  USA:   www.webenergyusa.com
 
 
 
 
 
 
 
 



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314511
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Web Service Issue , pls help

2008-08-19 Thread Rick Sanders
Dude,

Read the top right of the page. The domain is expired!

flash-db.com expired on 07/26/2008 and is pending renewal or deletion

Rick Sanders
Webenergy
Canada: 902-431-7279
USA:   919-799-9076
Canada: www.webenergy.ca
USA:   www.webenergyusa.com

-Original Message-
From: vishnu prasad [mailto:[EMAIL PROTECTED] 
Sent: August-19-08 10:50 PM
To: CF-Talk
Subject: Re: Web Service Issue , pls help

Hi Dave

I dont have a web service code , i tried to access the public web serive
from xmethod  which return the image , but somehow its not working 

This is the web service 
http://www.xmethods.net/ve2/ViewListing.po?key=uuid:861CB6D3-1E2A-BA27-BDDE-
E9FEF283E518



You may be able to cfcontent it directly - or you may need to store it as
a file of the correct type and extension.

-mark 


Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

Hi 

We have a java webservice which will return the image as a soap attachment
and another web service which will return the image as a binary data 

How can we use the image return by the web service in coldfusion? 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311292
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF tags in CFFILE write

2008-06-25 Thread Rick Sanders
Well,

The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].

CFLOOP from=1 to=#toloop# index=Loop

var lat[Loop] = {latitude};

/CFLOOP


Within the cfsavecontent, how can I make the row number show up in the loop
when I define it?

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: June-24-08 10:05 PM
To: CF-Talk
Subject: Re: CF tags in CFFILE write

Build the output using cfsavecontent and write the result using the cffile
tag.

On Wed, Jun 25, 2008 at 8:37 AM, Rick Sanders [EMAIL PROTECTED] wrote:
 Hey everyone,



 I need to dynamically write a javascript file from Cold fusion. However,
it
 keeps giving me errors. Is there a way to write a file using cf tags in
the
 output?


-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF tags in CFFILE write

2008-06-25 Thread Rick Sanders
Hey Brad,

Thanks for the tip but I tried that already. It just outputs [#Loop#] in the
file I'm writing.

I am in a cfsavecontent block btw.

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: June-25-08 3:02 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write

In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.

cfoutput
CFLOOP from=1 to=#toloop# index=Loop

var lat[#Loop#] = {latitude};

/CFLOOP
/cfoutput

-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write

Well,

The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].

CFLOOP from=1 to=#toloop# index=Loop

var lat[Loop] = {latitude};

/CFLOOP


Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308139
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF tags in CFFILE write

2008-06-25 Thread Rick Sanders
Thanks Brad,

I should have known that, and I should have looked harder. Been looking at
this code for 9 hours straight now.

Thanks again.

Rick

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: June-25-08 3:20 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write

You'll notice my example also has cfoutput tags wrapped around it.

Does yours?

~Brad

-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 25, 2008 1:07 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write

Hey Brad,

Thanks for the tip but I tried that already. It just outputs [#Loop#] in
the
file I'm writing.

I am in a cfsavecontent block btw.

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: June-25-08 3:02 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write

In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.

cfoutput
CFLOOP from=1 to=#toloop# index=Loop

var lat[#Loop#] = {latitude};

/CFLOOP
/cfoutput

-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write

Well,

The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].

CFLOOP from=1 to=#toloop# index=Loop

var lat[Loop] = {latitude};

/CFLOOP


Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?







~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308142
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF tags in CFFILE write

2008-06-24 Thread Rick Sanders
Hey everyone,

 

I need to dynamically write a javascript file from Cold fusion. However, it
keeps giving me errors. Is there a way to write a file using cf tags in the
output?

 

Example:

cffile action = write 

file = {filepath} 

output =var map = null;

CFLOOP from=1 to=#toloop# index=Loop

var lat[loop] = {latitude};

var lon[loop] = {longitude}; 

var latLong[loop] = new VELatLong(lat[loop], lon[loop]);','var points[loop]
= [

new VELatLong(lat[loop], lon[loop] - 0.15),

new VELatLong(lat[loop] + 0.1, lon[loop] - 0.05),

new VELatLong(lat[loop] + 0.1, lon[loop] + 0.05),

new VELatLong(lat[loop], lon1 + 0.15),

new VELatLong(lat[loop] - 0.1, lon[loop] + 0.05),

new VELatLong(lat[loop] - 0.1, lon[loop] - 0.05)];','shape[loop]
= new VEShape(VEShapeType.Polygon, points[loop]);

/CFLOOP



 

I need to loop in the file to put all the points and latitude / longitude
for a map. So, I need to parse the cfloop code in the file, but only write
the results to the file. Please let me know if this can be done?

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308083
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF tags in CFFILE write

2008-06-24 Thread Rick Sanders
Hey James,

Thanks for the tip! I'll give it a shot!

Rick

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: June-24-08 10:05 PM
To: CF-Talk
Subject: Re: CF tags in CFFILE write

Build the output using cfsavecontent and write the result using the cffile
tag.

On Wed, Jun 25, 2008 at 8:37 AM, Rick Sanders [EMAIL PROTECTED] wrote:
 Hey everyone,



 I need to dynamically write a javascript file from Cold fusion. However,
it
 keeps giving me errors. Is there a way to write a file using cf tags in
the
 output?


-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Date parsing and formatting...

2008-06-18 Thread Rick Sanders
OK, here's the scoop...

 

I'm grabbing the date from an XML web service which is returning the date in
the following format: May 21, 2008

How can I change it to 05/21/2008 ?

 

Naturally I had to parse it to a string because Cold fusion won't parse an
XML child node.

I've tried dateformat, CreateDate, LSParseDateTime and they all return
errors telling me that May 21, 2008 is an invalid date format.

Please help and let me know if there is a way to convert this date type in
to a date string.

 

Thanks,

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307685
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Date parsing and formatting...

2008-06-18 Thread Rick Sanders
Hello James,

I certainly did and the error I get is: May 21, 2008 is an invalid date or
time string

My code:
cfset myDoc=XMLParse(XMLResult)
cfset xdate = #ToString(myDoc.michiganMasons.event_begin_date[1])#
cfset cdate = #ParseDatetime(xdate)#

Rick

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: June-18-08 10:36 PM
To: CF-Talk
Subject: Re: Date parsing and formatting...

Di you try ParseDateTime() ?

On Thu, Jun 19, 2008 at 9:26 AM, Rick Sanders [EMAIL PROTECTED] wrote:
 OK, here's the scoop...



 I'm grabbing the date from an XML web service which is returning the date
in
 the following format: May 21, 2008

 How can I change it to 05/21/2008 ?



 Naturally I had to parse it to a string because Cold fusion won't parse an
 XML child node.

 I've tried dateformat, CreateDate, LSParseDateTime and they all return
 errors telling me that May 21, 2008 is an invalid date format.

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307697
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Live Chat

2008-03-31 Thread Rick Sanders
Hello helpful people!

 

I'm just wondering if there's a chat module anywhere that's been built
already?

 

Thanks,

 

Rick

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302355
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Live Chat

2008-03-31 Thread Rick Sanders
Thanks!

-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED] 
Sent: March-31-08 3:59 PM
To: CF-Talk
Subject: Re: Live Chat

http://cfopenchat.riaforge.org/

On Mon, Mar 31, 2008 at 2:49 PM, Rick Sanders [EMAIL PROTECTED] wrote:

 Hello helpful people!



 I'm just wondering if there's a chat module anywhere that's been built
 already?



 Thanks,



 Rick







 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302361
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


  1   2   >