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.

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

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

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

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

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

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

2014-03-18 Thread Rick Sanders
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

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

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

Cold Fusion source code stolen from Adobe in Cyber attack

2013-10-04 Thread Rick Sanders
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

RE: cfmail Exchange 2010

2013-09-06 Thread Rick Sanders
. 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

cfmail Exchange 2010

2013-09-04 Thread Rick Sanders
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

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

Syntax is driving me nuts!

2013-08-20 Thread Rick Sanders
#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

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

Pausing a loop or query

2013-08-19 Thread Rick Sanders
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

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

C-Panel

2013-07-10 Thread Rick Sanders
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

RE: C-Panel

2013-07-10 Thread Rick Sanders
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

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

RE: Weird attack

2011-11-24 Thread Rick Sanders
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

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

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

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

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

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

RE: decimals and variables

2011-02-10 Thread Rick Sanders
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

RE: decimals and variables

2011-02-10 Thread Rick Sanders
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

RE: decimals and variables

2011-02-10 Thread Rick Sanders
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

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#

RE: Parsing RSS feeds

2011-01-25 Thread Rick Sanders
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

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:

RE: Writing cfml content to an html file

2010-10-21 Thread Rick Sanders
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

RE: Writing cfml content to an html file

2010-10-21 Thread Rick Sanders
-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

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

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

RE: totaling items in a recordset

2010-10-19 Thread Rick Sanders
(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

RE: Totaling items in a recordet

2010-10-19 Thread Rick Sanders
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

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

RE: cfif contains

2010-10-17 Thread Rick Sanders
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

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

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

RE: Chat or IM program

2010-09-17 Thread Rick Sanders
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

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

RE: Chat or IM program

2010-09-17 Thread Rick Sanders
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

RE: Chat or IM program

2010-09-17 Thread Rick Sanders
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

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

RE: Extracting part of a string

2010-07-20 Thread Rick Sanders
: \[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

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

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!

RE: Remove html characters

2010-05-18 Thread Rick Sanders
#/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

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

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

RE: Joomla?

2010-04-19 Thread Rick Sanders
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

http header

2010-04-05 Thread Rick Sanders
@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

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

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

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

RE: IE8 is killing my website

2010-02-02 Thread Rick Sanders
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

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

Load-balancing servers

2009-12-10 Thread Rick Sanders
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

RE: Load-balancing servers

2009-12-10 Thread Rick Sanders
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

RE: Load-balancing servers

2009-12-10 Thread Rick Sanders
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

RE: Load-balancing servers

2009-12-10 Thread Rick Sanders
://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

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

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

RE: Custom scopes

2009-09-21 Thread Rick Sanders
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

Replacing characters in a string

2009-08-19 Thread Rick Sanders
#/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

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

Invalid parameter binding - again!

2009-07-28 Thread Rick Sanders
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

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

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 -

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

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

RE: Weird error

2009-07-14 Thread Rick Sanders
...@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

RE: Weird error

2009-07-14 Thread Rick Sanders
. 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

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

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

No SQL Update!

2009-02-03 Thread Rick Sanders
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

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

RE: No SQL Update!

2009-02-03 Thread Rick Sanders
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

RE: No SQL Update!

2009-02-03 Thread Rick Sanders
, 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

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

RE: Random Numbers

2008-11-06 Thread Rick Sanders
: 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

Adding Updating empty values

2008-10-28 Thread Rick Sanders
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

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
: 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

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

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
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

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
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

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
/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

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

RE: CF tags in CFFILE write

2008-06-25 Thread Rick Sanders
- 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

RE: CF tags in CFFILE write

2008-06-25 Thread Rick Sanders
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

RE: CF tags in CFFILE write

2008-06-25 Thread Rick Sanders
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

CF tags in CFFILE write

2008-06-24 Thread Rick Sanders
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

RE: CF tags in CFFILE write

2008-06-24 Thread Rick Sanders
, 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

Date parsing and formatting...

2008-06-18 Thread Rick Sanders
, 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

RE: Date parsing and formatting...

2008-06-18 Thread Rick Sanders
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

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

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

  1   2   >