New line character for SMS sent via Clickatell HTTP API

2012-07-09 Thread Bryan Stevenson

Hi All,

I have tried MANY characters to force a new line in a text message sent
via Clickatell's HTTP API using CFHTTP

Their docs say to use 0%A which is of course the urlEncodedFormat() for
a new line

...when I send that it just shows in the message as a string (when
viewing on Android phone).have tried  tagshave tried \r
\n.have tried HEXalways just show as strings

...and there are many more opinions online and in Clickatell's docs

Has anyone out there successfully done this?  If so, please share some
code ;-)

Thanks in advance

Cheers

-- 
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc. - makers of FACTS™
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com
web: www.electricedgesystems.com and www.fisheryfacts.com 




Please consider the environment before printing this e-mail

-CONFIDENTIALITY--
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.



~|
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:351874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Re-Factoring

2012-07-09 Thread Brett Davis

Alan it's 375 files that need to be changed and I'm almost done doing it 
manually. However, I never would have thought to effectively merge the header 
and footer files and use the start/ end on the module. 
See this is why I love House of Fusion always can get a awesome answer on weird 
questions.
Thanks Alan! 


~|
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:351873
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Re-Factoring

2012-07-09 Thread .jonah

IntelliJ IDEA seems to get the best rep for refactoring.


On 7/10/12 2:15 PM, Brett Davis wrote:
> Question: Has anyone ever had to do code re-factoring that involved taking 
> attributes from one set of tags and moving them to a different set of tags 
> within the same template? For example taking the attributes from the 
> following tag  useJQuery='true'> and moving them to this tag .
>
> Client has switched to using Boilerplate for JS stuff and wanted all the tags 
> that referenced a set of attributes from the site wide header file to be 
> moved to the footer file. My first thought was to write up some ColdFusion 
> code to parse through all the files and use RegEx to manipulate the code in 
> the templates. Then as I thought through all the variables, the amount of 
> code it would take to do it, and the fact that ColdFusion doesn't like 
> parsing thought thousands of files [read that as request time out setting 
> would be very high], I decided to just cut and paste by hand. However I was 
> just wondering if anyone else has had to tackle this problem previously and 
> what if any was your different solution to the problem.
>
> Side note: My quick search for GREP/ RegEx software to do it for me turned up 
> nothing useful.
>
>
> 

~|
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:351872
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Re-Factoring

2012-07-09 Thread Alan Rother

How many #header# and #footer# files are there? If it's not hundreds this
might work:

You COULD - just bind the two together - cfmodule tags were created for
this exact type of thing

So, instead of having a



BUNCH O HTML AND CF HERE



You'd have


BUNCH O HTML AND CF HERE



To combine the #header# and #footer# cfmodules to each other - simply add
the footer CF/html to the header cf/html in this

header content here
footer content here


Then the values from the opening cfmodule tag will be available to all of
your closing footer tags as well.

Feel free to ping me off list with any specific questions

alan dot rother at gmail dot com

-- 
Alan Rother
Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org
Twitter: @AlanRother


~|
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:351871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Code Re-Factoring

2012-07-09 Thread Brett Davis

Question: Has anyone ever had to do code re-factoring that involved taking 
attributes from one set of tags and moving them to a different set of tags 
within the same template? For example taking the attributes from the following 
tag  and moving 
them to this tag . 

Client has switched to using Boilerplate for JS stuff and wanted all the tags 
that referenced a set of attributes from the site wide header file to be moved 
to the footer file. My first thought was to write up some ColdFusion code to 
parse through all the files and use RegEx to manipulate the code in the 
templates. Then as I thought through all the variables, the amount of code it 
would take to do it, and the fact that ColdFusion doesn't like parsing thought 
thousands of files [read that as request time out setting would be very high], 
I decided to just cut and paste by hand. However I was just wondering if anyone 
else has had to tackle this problem previously and what if any was your 
different solution to the problem.

Side note: My quick search for GREP/ RegEx software to do it for me turned up 
nothing useful. 


~|
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:351870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: coldfusion 10 Host My Site SQL permission

2012-07-09 Thread Randy Messer

HMS has updated setting for my account on server to enable CREATE, ALTER, etc.
Consider issue resolved

> > HMS moved site to CF10 server. For the past 5+ years I've used 
> scripting quite often to create and alter tables
> > for this site. Now when running script I receive error: Executing 
> the SQL statement is not allowed.
> >
> > I can confirm datasource, username, password, dbtype are all correct.
> 
> >
> > HMS reviewed code and CF Server setting and respond that everything 
> is set up properly and should work.
> 
> I suspect that the CF datasource is not configured to allow execution
> of CREATE and ALTER statements - there's an option right in the
> datasource settings for 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.


~|
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:351869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: coldfusion 10 Host My Site SQL permission

2012-07-09 Thread Byron Mann

Just to let everyone know, I believe I resolved this issue for Randy.

Appears the CF10 default for creating new DSNs on the server his new
site is on, only enables SELECT, INSERT, UPDATE and DELETE by default.
 So it's necessary to expand the additional settings and enable the
additional options.

I let our system admins know about this and they are going to look
into if this is a CF10 issue or something with that particular
installation.

I checked our internal CF10 servers and this does not seem to be the
case, so it may just be this particular instance.

Byron Mann
Lead Engineer & Architect | Hosting.com | Delaware





On Tue, Jul 10, 2012 at 3:15 PM, Randy Messer
 wrote:
>
> HMS moved site to CF10 server. For the past 5+ years I've used scripting 
> quite often to create and alter tables for this site. Now when running script 
> I receive error: Executing the SQL statement is not allowed.
>
> I can confirm datasource, username, password, dbtype are all correct.
>
> HMS reviewed code and CF Server setting and respond that everything is set up 
> properly and should work.
>
> Any ideas?
>
>
> 

~|
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:351868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: inserting a new row at the top of CSV file

2012-07-09 Thread John M Bliss





On Tue, Jul 10, 2012 at 1:57 PM, Akos Fortagh wrote:

>
> Unusual request I know, I have a CSV file with lots of rows but it has no
> headings, is there a way of inserting a new row at the top of the CSV file
> with some heading names?
> Any help would be greatly appreciated.
>
>
> 

~|
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:351867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


inserting a new row at the top of CSV file

2012-07-09 Thread Akos Fortagh

Unusual request I know, I have a CSV file with lots of rows but it has no 
headings, is there a way of inserting a new row at the top of the CSV file with 
some heading names?
Any help would be greatly appreciated.


~|
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:351866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


inserting a new row at the top of CSV file

2012-07-09 Thread Akos Fortagh

unusual request I know, I have a CSV file with lots of rows but it has no 
column headings.  Is there a way of inserting a row at the top of the file (1st 
row) with the heading names?
any help would be appreciated.  thanks 


~|
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:351865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: coldfusion 10 Host My Site SQL permission

2012-07-09 Thread Byron Mann

Randy,

What is the account number, domain or ticket number and I can take a
deeper look.

Feel free to contact me directly.

ma...@hostmysite.com


On Tue, Jul 10, 2012 at 3:15 PM, Randy Messer
 wrote:
>
> HMS moved site to CF10 server. For the past 5+ years I've used scripting 
> quite often to create and alter tables for this site. Now when running script 
> I receive error: Executing the SQL statement is not allowed.
>
> I can confirm datasource, username, password, dbtype are all correct.
>
> HMS reviewed code and CF Server setting and respond that everything is set up 
> properly and should work.
>
> Any ideas?
>
>
> 

~|
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:351864
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: coldfusion 10 Host My Site SQL permission

2012-07-09 Thread Russ Michaels

I hope you ASKED to be moved to CF10.

On Mon, Jul 9, 2012 at 8:37 PM, Dave Watts  wrote:

>
> > HMS moved site to CF10 server. For the past 5+ years I've used scripting
> quite often to create and alter tables
> > for this site. Now when running script I receive error: Executing the
> SQL statement is not allowed.
> >
> > I can confirm datasource, username, password, dbtype are all correct.
> >
> > HMS reviewed code and CF Server setting and respond that everything is
> set up properly and should work.
>
> I suspect that the CF datasource is not configured to allow execution
> of CREATE and ALTER statements - there's an option right in the
> datasource settings for 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.
>
> 

~|
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:351863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: coldfusion 10 Host My Site SQL permission

2012-07-09 Thread Dave Watts

> HMS moved site to CF10 server. For the past 5+ years I've used scripting 
> quite often to create and alter tables
> for this site. Now when running script I receive error: Executing the SQL 
> statement is not allowed.
>
> I can confirm datasource, username, password, dbtype are all correct.
>
> HMS reviewed code and CF Server setting and respond that everything is set up 
> properly and should work.

I suspect that the CF datasource is not configured to allow execution
of CREATE and ALTER statements - there's an option right in the
datasource settings for 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.

~|
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:351862
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


coldfusion 10 Host My Site SQL permission

2012-07-09 Thread Randy Messer

HMS moved site to CF10 server. For the past 5+ years I've used scripting quite 
often to create and alter tables for this site. Now when running script I 
receive error: Executing the SQL statement is not allowed. 

I can confirm datasource, username, password, dbtype are all correct.

HMS reviewed code and CF Server setting and respond that everything is set up 
properly and should work.  

Any ideas? 


~|
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:351861
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm