I need help converting a modal jqgrid to an inline jqgrid

2014-10-20 Thread Ray Meade

I'm a jquery/jqgrid newbie here and I have a client that is using a jqgrid to 
list the job details on auto repairs. Right now, they're using the modal method 
of editing and adding new job details, but they'd rather use the inline 
functions. I've managed to convert the grid the best I can, but I can't seem to 
get it working properly. Right now, they can edit rows and delete rows using 
the inline function but when they go to add a new row, it still pops up the 
modal dialog box for adding the row. I suspect that the problem is somewhere in 
the $(#list).navGrid( code so I tried changing navGrid to inline but then 
the buttons for adding and deleting a row disappear. I've tried to simply take 
the tutorial example for inline grids and customize it to our data structure 
and sources, but since I also have auto complete and text resizing scripts 
running on the grid, it's difficult to customize the example code with these 
features without breaking the grid altogether. (I'm not even sure h
 ow I got it all to work in the first place since this was my first foray into 
the world of jquery or jqgrid...I just kept trying different things until I got 
it working...lol) Anyway, here's the code for the grid as it stands now. Any 
help would be greatly appreciated.
 
script
function autocomplete_element(value, options) {
// creating input element
var $ac = $('input type=text/');
// setting value to the one passed from jqGrid
$ac.val(value);
// creating autocomplete
$ac.autocomplete({source: editGrid.cfc?method=fnAutocomplete});
// returning element back to jqGrid
return $ac;
}
function autocomplete_value(elem, op, value) {
if (op == set) {
$(elem).val(value);
}
return $(elem).val();
}
$(document).ready(function() {
var mkinline
$(#list).jqGrid(
{
url:'editGrid.cfc?method=getUsers', //CFC that will return the users
datatype: 'json', //We specify that the datatype we will be using will be JSON
colNames:['DetailID', 'ProjectID','Qty.','Description','Unit Price','Total 
Cost'], //Column Names
/*
The Column Model to define the data. Note you can make columns non sortable, 
specify width, alignment, etc.
We also specify the editoptions, edittype=text shows a nice textbox for inline 
edit.
We have also specified Edit Rules, to say which fields are required/not 
required for add/edit
*/
colModel :[
{name:'DetailID', index:'DetailID', align:'right', hidden:true, editable:true},
{name:'ProjectID', index:'ProjectID', width:25, hidden:true, editable:true},
{name:'Quantity', index:'Quantity', editable:true, width:50, align:'right', 
edittype:'text', editoptions: {defaultValue:'1'}},
{name:'TaskName', index:'TaskName', editable:true, width:450, align:'left', 
edittype: 'custom', editoptions: {'custom_element' : autocomplete_element, 
'custom_value' : autocomplete_value}},
{name:'UnitPrice', index:'UnitPrice', editable:true, width:100, align:'right'},
{name:'ExtendedPrice', index:'ExtendedPrice', editable:false, width:100, 
align:'right'}
],
onSelectRow: function(id){
if(id  id!==mkinline){
jQuery('#list').saveRow(mkinline);
jQuery('#list').editRow(id,true);
mkinline=id;
}
},
pager: $('#pager'), //The div we have specified, tells jqGrid where to put the 
pager
rowNum:20, //Number of records we want to show per page
rowList:[], //Row List, to allow user to select how many rows they want to see 
per page
sortorder: asc, //Default sort order
sortname: DetailID, //Default sort column
jqModal: false,
viewrecords: false, //Shows the nice message on the pager
imgpath: '/js/jquery/css/start/images', //Image path for prev/next etc images
caption: 'Project Details', //Grid Name
height:'auto', //I like auto, so there is no blank space between. Using a fixed 
height can mean either a scrollbar or a blank space before the pager
width:823,
mtype:'GET',
recordtext:'', //On the demo you will notice 7 Total Records - The Total 
Reocrds text comes from here
pgtext:'', //You notice the 1/3, you can change the /. You can make it say 1 of 
3
editurl:editGrid.cfc?method=addeditUser, //The Add/Edit function call
toolbar:[false,top], //Shows the toolbar at the top. We will use it to 
display user feedback
//Things to do when grid is finished loading
loadComplete:function(){
//We get the Userdata for the grid.
var recorddata = $(#list).getUserData();
//show the msg in the toolbar
$(#t_list).html(recorddata.MSG);
},
//The JSON reader. This defines what the JSON data returned from the CFC should 
look like
jsonReader: {
root: ROWS, //our data
page: PAGE, //current page
total: TOTAL, //total pages
records:RECORDS, //total records
userdata:USERDATA, //Userdata we will pass back for feedback
cell: , //Not Used
id: 0 //Will default to first column
}
}
);
//Set toolbar text color to blue
$(#t_list).css(color,blue);

//Here we use the navGrid to display the Search button with label Filter, and 
enable the add/edit/delete buttons.
$(#list).navGrid(
#pager,{add:true,edit:false,addtext:,deltext:,del:true,search:false,refresh:true},//We
 will specify custom

Re: need help with two sites - willing to pay $45/hour

2014-07-23 Thread Byron Mann

Matthew,

The site seemed to be responsive this morning, so I took a look at things
and have fixed the basic errors that were happening and the home page now
loads properly.

I've done the following.

Implemented an error handler in Application.cfm. So on error a full dump of
the error is shown using /error.cfm template.  It is a very basic handler.
You may want to edit this to present something better to end users when
error occur, and maybe email the error detail to your self.

Fixed the cfquery(s) in /cfcs/qry-todatabase.cfc.  Look like you were
attempting to use a standard connection string.  cfquery uses the
datasource attribute which is configured in the CFAdmin (which you already
provided as fatcat111).

The rest of the database calls in that file were using
#request.datasource#, so I did the same.  This variable was missing, so I
set this in the /fbx_settings.cfm (see line 24). There was also an
additional syntax error and this was resolved as well.

Let me know of anything further.

How would you like to handle payment.  I usually use PayPal, would this
suffice?  In all I've spent ~2 hours on this.

Regards,
Byron






On Wed, Jul 23, 2014 at 1:05 AM, Rakesh Prasad rkprasa...@gmail.com wrote:


 Hi,

 We have excellent experience in Coldfusion based website and web
 application development as mentioned below, Also we have a team of well
 experienced developers in Coldfusion technology.

 Experience : around 15 years
 Projects: 200 web application and website.

 We can provide help you to troubleshoot your website issues.

 Thanks  Regards
 RK Prasad





 On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith chedders...@gmail.com
 wrote:

 
  I have two sites with minor issues I need help with.
 
  http://www.theartoflovingcatsanddogs.com
  http://www.fatcate-juice.com
 
  The first is an image reference issue and the second has to do with a cfc
  issue.
 
  Please let me know if anyone is interested.
 
  Thanks.
 
  --
  Regards,
  chedder is bedder
 
 
 

 

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


Re: need help with two sites - willing to pay $45/hour

2014-07-23 Thread Scott Stewart

Byron, no offense but did you really mean to send this out to the enitre
CF-Talk list?


On Wed, Jul 23, 2014 at 9:14 AM, Byron Mann byronos...@gmail.com wrote:


 Matthew,

 The site seemed to be responsive this morning, so I took a look at things
 and have fixed the basic errors that were happening and the home page now
 loads properly.

 I've done the following.

 Implemented an error handler in Application.cfm. So on error a full dump of
 the error is shown using /error.cfm template.  It is a very basic handler.
 You may want to edit this to present something better to end users when
 error occur, and maybe email the error detail to your self.

 Fixed the cfquery(s) in /cfcs/qry-todatabase.cfc.  Look like you were
 attempting to use a standard connection string.  cfquery uses the
 datasource attribute which is configured in the CFAdmin (which you already
 provided as fatcat111).

 The rest of the database calls in that file were using
 #request.datasource#, so I did the same.  This variable was missing, so I
 set this in the /fbx_settings.cfm (see line 24). There was also an
 additional syntax error and this was resolved as well.

 Let me know of anything further.

 How would you like to handle payment.  I usually use PayPal, would this
 suffice?  In all I've spent ~2 hours on this.

 Regards,
 Byron






 On Wed, Jul 23, 2014 at 1:05 AM, Rakesh Prasad rkprasa...@gmail.com
 wrote:

 
  Hi,
 
  We have excellent experience in Coldfusion based website and web
  application development as mentioned below, Also we have a team of well
  experienced developers in Coldfusion technology.
 
  Experience : around 15 years
  Projects: 200 web application and website.
 
  We can provide help you to troubleshoot your website issues.
 
  Thanks  Regards
  RK Prasad
 
 
 
 
 
  On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith chedders...@gmail.com
  wrote:
 
  
   I have two sites with minor issues I need help with.
  
   http://www.theartoflovingcatsanddogs.com
   http://www.fatcate-juice.com
  
   The first is an image reference issue and the second has to do with a
 cfc
   issue.
  
   Please let me know if anyone is interested.
  
   Thanks.
  
   --
   Regards,
   chedder is bedder
  
  
  
 
 

 

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


Insite Help on CF Hanging?

2014-07-23 Thread Les Mizzell

Had a site go down in the early morning hours the last two days - 
Coldfusion hangs -  requiring a restart to get it back up again.

Running CF 10 on Windows Server 2008 R2

1. No major errors in the log files.
2. Log files are set to relatively small size limits
3. Something seems to be eating a LOT of memory. Even at idle, CFServer 
is using almost half a gig memory
4. What's is Client Purge and why could this possibly hang CF ( this 
appears to have run approximately around the time of the outage) - and 
why now after over a year with zero outages?

That's about all I've got so far. Still researching
Any other things I should be looking at/for?

TIA


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


Re: need help with two sites - willing to pay $45/hour

2014-07-23 Thread Byron Mann

Apologies to all, result of too many open windows and not enough coffee.


On Wed, Jul 23, 2014 at 9:44 AM, Scott Stewart webmas...@sstwebworks.com
wrote:


 Byron, no offense but did you really mean to send this out to the enitre
 CF-Talk list?


 On Wed, Jul 23, 2014 at 9:14 AM, Byron Mann byronos...@gmail.com wrote:

 
  Matthew,
 
  The site seemed to be responsive this morning, so I took a look at things
  and have fixed the basic errors that were happening and the home page now
  loads properly.
 
  I've done the following.
 
  Implemented an error handler in Application.cfm. So on error a full dump
 of
  the error is shown using /error.cfm template.  It is a very basic
 handler.
  You may want to edit this to present something better to end users when
  error occur, and maybe email the error detail to your self.
 
  Fixed the cfquery(s) in /cfcs/qry-todatabase.cfc.  Look like you were
  attempting to use a standard connection string.  cfquery uses the
  datasource attribute which is configured in the CFAdmin (which you
 already
  provided as fatcat111).
 
  The rest of the database calls in that file were using
  #request.datasource#, so I did the same.  This variable was missing, so I
  set this in the /fbx_settings.cfm (see line 24). There was also an
  additional syntax error and this was resolved as well.
 
  Let me know of anything further.
 
  How would you like to handle payment.  I usually use PayPal, would this
  suffice?  In all I've spent ~2 hours on this.
 
  Regards,
  Byron
 
 
 
 
 
 
  On Wed, Jul 23, 2014 at 1:05 AM, Rakesh Prasad rkprasa...@gmail.com
  wrote:
 
  
   Hi,
  
   We have excellent experience in Coldfusion based website and web
   application development as mentioned below, Also we have a team of well
   experienced developers in Coldfusion technology.
  
   Experience : around 15 years
   Projects: 200 web application and website.
  
   We can provide help you to troubleshoot your website issues.
  
   Thanks  Regards
   RK Prasad
  
  
  
  
  
   On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith chedders...@gmail.com
   wrote:
  
   
I have two sites with minor issues I need help with.
   
http://www.theartoflovingcatsanddogs.com
http://www.fatcate-juice.com
   
The first is an image reference issue and the second has to do with a
  cfc
issue.
   
Please let me know if anyone is interested.
   
Thanks.
   
--
Regards,
chedder is bedder
   
   
   
  
  
 
 

 

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


Re: need help with two sites - willing to pay $45/hour

2014-07-23 Thread Matthew Smith

'
ok I got the pathing issue sorted.  I am having a weird issue with the home
page formatting.  I have a br and the page layout it putting the test to
the right, and the two last images are missing.  Not sure what is going on.
 Please download the latest files before you make any changes, I have added
text to the home page.

thanks.


On Wed, Jul 23, 2014 at 8:14 AM, Byron Mann byronos...@gmail.com wrote:


 Matthew,

 The site seemed to be responsive this morning, so I took a look at things
 and have fixed the basic errors that were happening and the home page now
 loads properly.

 I've done the following.

 Implemented an error handler in Application.cfm. So on error a full dump of
 the error is shown using /error.cfm template.  It is a very basic handler.
 You may want to edit this to present something better to end users when
 error occur, and maybe email the error detail to your self.

 Fixed the cfquery(s) in /cfcs/qry-todatabase.cfc.  Look like you were
 attempting to use a standard connection string.  cfquery uses the
 datasource attribute which is configured in the CFAdmin (which you already
 provided as fatcat111).

 The rest of the database calls in that file were using
 #request.datasource#, so I did the same.  This variable was missing, so I
 set this in the /fbx_settings.cfm (see line 24). There was also an
 additional syntax error and this was resolved as well.

 Let me know of anything further.

 How would you like to handle payment.  I usually use PayPal, would this
 suffice?  In all I've spent ~2 hours on this.

 Regards,
 Byron






 On Wed, Jul 23, 2014 at 1:05 AM, Rakesh Prasad rkprasa...@gmail.com
 wrote:

 
  Hi,
 
  We have excellent experience in Coldfusion based website and web
  application development as mentioned below, Also we have a team of well
  experienced developers in Coldfusion technology.
 
  Experience : around 15 years
  Projects: 200 web application and website.
 
  We can provide help you to troubleshoot your website issues.
 
  Thanks  Regards
  RK Prasad
 
 
 
 
 
  On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith chedders...@gmail.com
  wrote:
 
  
   I have two sites with minor issues I need help with.
  
   http://www.theartoflovingcatsanddogs.com
   http://www.fatcate-juice.com
  
   The first is an image reference issue and the second has to do with a
 cfc
   issue.
  
   Please let me know if anyone is interested.
  
   Thanks.
  
   --
   Regards,
   chedder is bedder
  
  
  
 
 

 

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


Re: Insite Help on CF Hanging?

2014-07-23 Thread Scott Stewart

Client purge means that you have client variables turned on in the CF
admin. The purge routine attempts to clear out stored variables either in
the registry or in a database.

If you're not using client variables turn this off, if you are, make sure
that you're not storing them in the registry


On Wed, Jul 23, 2014 at 9:52 AM, Les Mizzell lesm...@bellsouth.net wrote:


 Had a site go down in the early morning hours the last two days -
 Coldfusion hangs -  requiring a restart to get it back up again.

 Running CF 10 on Windows Server 2008 R2

 1. No major errors in the log files.
 2. Log files are set to relatively small size limits
 3. Something seems to be eating a LOT of memory. Even at idle, CFServer
 is using almost half a gig memory
 4. What's is Client Purge and why could this possibly hang CF ( this
 appears to have run approximately around the time of the outage) - and
 why now after over a year with zero outages?

 That's about all I've got so far. Still researching
 Any other things I should be looking at/for?

 TIA


 

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


Re: need help with two sites - willing to pay $45/hour

2014-07-23 Thread Matthew Smith

Understandable.  Mornings can be a bear.  No worries.


On Wed, Jul 23, 2014 at 8:54 AM, Byron Mann byronos...@gmail.com wrote:


 Apologies to all, result of too many open windows and not enough coffee.


 On Wed, Jul 23, 2014 at 9:44 AM, Scott Stewart webmas...@sstwebworks.com
 wrote:

 
  Byron, no offense but did you really mean to send this out to the enitre
  CF-Talk list?
 
 
  On Wed, Jul 23, 2014 at 9:14 AM, Byron Mann byronos...@gmail.com
 wrote:
 
  
   Matthew,
  
   The site seemed to be responsive this morning, so I took a look at
 things
   and have fixed the basic errors that were happening and the home page
 now
   loads properly.
  
   I've done the following.
  
   Implemented an error handler in Application.cfm. So on error a full
 dump
  of
   the error is shown using /error.cfm template.  It is a very basic
  handler.
   You may want to edit this to present something better to end users when
   error occur, and maybe email the error detail to your self.
  
   Fixed the cfquery(s) in /cfcs/qry-todatabase.cfc.  Look like you were
   attempting to use a standard connection string.  cfquery uses the
   datasource attribute which is configured in the CFAdmin (which you
  already
   provided as fatcat111).
  
   The rest of the database calls in that file were using
   #request.datasource#, so I did the same.  This variable was missing,
 so I
   set this in the /fbx_settings.cfm (see line 24). There was also an
   additional syntax error and this was resolved as well.
  
   Let me know of anything further.
  
   How would you like to handle payment.  I usually use PayPal, would this
   suffice?  In all I've spent ~2 hours on this.
  
   Regards,
   Byron
  
  
  
  
  
  
   On Wed, Jul 23, 2014 at 1:05 AM, Rakesh Prasad rkprasa...@gmail.com
   wrote:
  
   
Hi,
   
We have excellent experience in Coldfusion based website and web
application development as mentioned below, Also we have a team of
 well
experienced developers in Coldfusion technology.
   
Experience : around 15 years
Projects: 200 web application and website.
   
We can provide help you to troubleshoot your website issues.
   
Thanks  Regards
RK Prasad
   
   
   
   
   
On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith 
 chedders...@gmail.com
wrote:
   

 I have two sites with minor issues I need help with.

 http://www.theartoflovingcatsanddogs.com
 http://www.fatcate-juice.com

 The first is an image reference issue and the second has to do
 with a
   cfc
 issue.

 Please let me know if anyone is interested.

 Thanks.

 --
 Regards,
 chedder is bedder



   
   
  
  
 
 

 

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


RE: Insite Help on CF Hanging?

2014-07-23 Thread Mark A Kruger

Client purge is removing client vars that are too old. If you have client
variables set to default they will be stored in the registery (win) or a big
XML file. The purge process removes them. To fix this:

A) Verify that you need client vars. If you don't adjust your application
settings accordingly.
B) if you DO need them I recommend that you
1) store them in a DB
2) do not set global variables unless you are using them (hitcount
and last access) because this results in additional DB connection updates.

As for you memory - at Idle a well tuned CF Server might indeed use half a
gig or more. On a 64 bit installation half a gig is pretty close to the
minimum required. Moreover I recommend that you set your min/max heap sizes
to the same value so what would see (even at idle) is a large and fairly
static memory footbpring - particallary if you are looking at the commit
size in task manager.

-Mark


Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Wednesday, July 23, 2014 8:52 AM
To: cf-talk
Subject: Insite Help on CF Hanging?


Had a site go down in the early morning hours the last two days - 
Coldfusion hangs -  requiring a restart to get it back up again.

Running CF 10 on Windows Server 2008 R2

1. No major errors in the log files.
2. Log files are set to relatively small size limits
3. Something seems to be eating a LOT of memory. Even at idle, CFServer 
is using almost half a gig memory
4. What's is Client Purge and why could this possibly hang CF ( this 
appears to have run approximately around the time of the outage) - and 
why now after over a year with zero outages?

That's about all I've got so far. Still researching
Any other things I should be looking at/for?

TIA




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


RE: Insite Help on CF Hanging?

2014-07-23 Thread Mark A Kruger

Tia,

FYI - storing client vars in the registry and locking up during the purge is
a fairly common trouble spot. I would not be surprised if that is your
problem. It can show up after a while too - because the client vars
persist for 30 days, so you can suddenly see problems 30 days after an
increase in traffic as the system tries to remove a boatload of client vars.

-Mark


-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Wednesday, July 23, 2014 8:52 AM
To: cf-talk
Subject: Insite Help on CF Hanging?


Had a site go down in the early morning hours the last two days - 
Coldfusion hangs -  requiring a restart to get it back up again.

Running CF 10 on Windows Server 2008 R2

1. No major errors in the log files.
2. Log files are set to relatively small size limits
3. Something seems to be eating a LOT of memory. Even at idle, CFServer 
is using almost half a gig memory
4. What's is Client Purge and why could this possibly hang CF ( this 
appears to have run approximately around the time of the outage) - and 
why now after over a year with zero outages?

That's about all I've got so far. Still researching
Any other things I should be looking at/for?

TIA




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


Re: Insite Help on CF Hanging?

2014-07-23 Thread Les Mizzell

Just read that one again.
30 days? Approx 30 days ago the site was hit with a SQL Injection 
attack. Wasn't 2000+ attempts like some of the previous attacks, but 
still, a couple hundred hits in a 15 minute period or so.
Don't know if that means anything.


On 7/23/2014 10:03 AM, Mark A Kruger wrote:
 Tia,

 FYI - storing client vars in the registry and locking up during the purge is
 a fairly common trouble spot. I would not be surprised if that is your
 problem. It can show up after a while too - because the client vars
 persist for 30 days, so you can suddenly see problems 30 days after an
 increase in traffic as the system tries to remove a boatload of client vars.

 -Mark


 -Original Message-
 From: Les Mizzell [mailto:lesm...@bellsouth.net]
 Sent: Wednesday, July 23, 2014 8:52 AM
 To: cf-talk
 Subject: Insite Help on CF Hanging?


 Had a site go down in the early morning hours the last two days -
 Coldfusion hangs -  requiring a restart to get it back up again.

 Running CF 10 on Windows Server 2008 R2

 1. No major errors in the log files.
 2. Log files are set to relatively small size limits
 3. Something seems to be eating a LOT of memory. Even at idle, CFServer
 is using almost half a gig memory
 4. What's is Client Purge and why could this possibly hang CF ( this
 appears to have run approximately around the time of the outage) - and
 why now after over a year with zero outages?

 That's about all I've got so far. Still researching
 Any other things I should be looking at/for?

 TIA




 

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


Re: Insite Help on CF Hanging?

2014-07-23 Thread Byron Mann

Are the client variables in a database?  If so, I would run a query on the
CF tables to get a count of records.  It could be your attack was worse
than you think and have a boat load of records.  An attack like that would
likely result in a set of client variables for each request.

The query to purge the database will lock the tables. Any application using
client variables would basically have to wait until that is done and keep
chewing up memory. I know this was an issue in CF8, not sure if it's still
a linger issue in newer versions, as that is around the time we stopped
using client variables.

@Mark,  I want to say both CF 9  10 install with Cookie as the default
client storage. This could just be how we provision our servers however. I
remember the days of CF taking an hour to start if your client var registry
was out of control. We had the oops moment on our shared servers long ago.

Regards,
Byron Mann
Lead Engineer  Architect
HostMySite


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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-22 Thread Claude Schnéegans

 maybe he's a bot?

If he is, sure he didn't programed it himself.


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


RE: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-22 Thread Mark A Kruger

I hope the art of loving cats and dogs is painting or crafts or something
:D

-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Tuesday, July 22, 2014 8:49 AM
To: cf-talk
Subject: Re: Having trouble with cfcI have removed all references to
site_theartoflovingcatsanddogs_com and deleted the template cache. No luck.
Any help?


 maybe he's a bot?

If he is, sure he didn't programed it himself.




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


RE: Regex help maybe

2014-07-22 Thread UXB

Thanks to everyone. I managed to come up with one similar to Byron's example
and then tweaked it further (No spaces) so I could use it in JS on the
client and CF on the server.  I knew I could do it in 2 or three steps but
wanted one step so I could hand off the regex to the client for validation.

Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.com

 So like this in the second variant:

^(?=.*\d.*\d.*\d)(?=.*[\~\!\@\#\$\%\^\\*\(\)\_\+]+)[\d\~\!\@\#\$\%\^\\*\(\
)\_\+]{10,20}$



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


Re: need help with two sites - willing to pay $45/hour

2014-07-22 Thread Rakesh Prasad

Hi,

We have excellent experience in Coldfusion based website and web
application development as mentioned below, Also we have a team of well
experienced developers in Coldfusion technology.

Experience : around 15 years
Projects: 200 web application and website.

We can provide help you to troubleshoot your website issues.

Thanks  Regards
RK Prasad





On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith chedders...@gmail.com
wrote:


 I have two sites with minor issues I need help with.

 http://www.theartoflovingcatsanddogs.com
 http://www.fatcate-juice.com

 The first is an image reference issue and the second has to do with a cfc
 issue.

 Please let me know if anyone is interested.

 Thanks.

 --
 Regards,
 chedder is bedder


 

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


Regex help maybe

2014-07-21 Thread UXB

I am terrible at Regex's. I looked all over and am going blind.  Is there
anyone here that can shorted my search?  I need one to test true for:

10 to 20 Characters in length
3 numeric characters in any order
1 special character from basic list ~!@#$%^*()_+


Any help is appreciated.


Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.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:358937
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Regex help maybe

2014-07-21 Thread Duane Boudreau

Can't really help you with the regex, but regexlib.com might help you with 
future ones. I use it whenever I need a regular expressions

-Original Message-
From: UXB [mailto:denn...@uxbinternet.com] 
Sent: Monday, July 21, 2014 6:30 PM
To: cf-talk
Subject: Regex help maybe


I am terrible at Regex's. I looked all over and am going blind.  Is there 
anyone here that can shorted my search?  I need one to test true for:

10 to 20 Characters in length
3 numeric characters in any order
1 special character from basic list ~!@#$%^*()_+


Any help is appreciated.


Dennis Powers
UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 
06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.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:358938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Regex help maybe

2014-07-21 Thread Michael Dinowitz

X{10,20} means that X should exist at least 10 times but no more than 20
times
[0-9] means any single number from 0 till 9
[0-9]{3} means any 3 numbers of 0-9 one after the other
[~!@#$%^*()_+] means a single character from the set of characters defined
between the brackets

Now do you want 3 numbers one after the other or that there should be 3
numbers in the string total? Can you send a few example strings or talk
about how it will be used? Also, do you want a single regex to do it all or
can be it be in 2-3 steps (easiest)?



On Mon, Jul 21, 2014 at 5:29 PM, UXB denn...@uxbinternet.com wrote:


 I am terrible at Regex's. I looked all over and am going blind.  Is there
 anyone here that can shorted my search?  I need one to test true for:

 10 to 20 Characters in length
 3 numeric characters in any order
 1 special character from basic list ~!@#$%^*()_+


 Any help is appreciated.


 Dennis Powers
 UXB Internet - A website Design and Hosting Company
 P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
 W: http://www.uxbinternet.com
 W: http://www.ctbusinesslist.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:358940
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread Matthew Smith

 Could not find the ColdFusion component or interface
site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
name is correct and that the component or interface exists.  The error
occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
*Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line 48
*Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
line 191
*Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
line 33
*Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
line 1
*Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
*Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line 61

162 :   cfargument name=app_user_id type=numeric required=no default=0
163 :   cfargument name=cfuserid type=string required=no
default=*164 :   cfobject
component=#request.cfcpath#qrystodatabase name=qry /*
165 :   cfset qry_unlock_items_for_paypal =
qry.qry_unlock_items_for_paypal(
app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
) /
166 : /cffunction





-- 
Regards,
chedder is bedder


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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread Matt Quackenbush

I am trying really, really, really, really hard to not be rude here, but
there's no way you can have 15 years of CF experience as you've claimed in
other threads. Each thread you've posted recently has displayed an absolute
dearth of information with which we can even attempt to help you, but
they've also displayed an absolute clear lack of any troubleshooting effort
of your own. We **WANT** to help people; it's why we are on these mailing
lists. However, you ___must___ be willing to help yourself, first. We are
not your own personal help desk.

Please review the following links and then report back.

http://www.catb.org/esr/faqs/smart-questions.html
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html

My apologies if I've incorrectly remembered the CF version you're using; I
believe you previously said CF9, so that's the link I provided. If it's
another version, links to the documentation are readily available by
Googling CF {version number} documentation.

Thanks.



On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith chedders...@gmail.com
wrote:


  Could not find the ColdFusion component or interface
 site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
 name is correct and that the component or interface exists.  The error
 occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
 http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line 48
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 191
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 33
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 1
 *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
 *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line 61

 162 :   cfargument name=app_user_id type=numeric required=no
 default=0
 163 :   cfargument name=cfuserid type=string required=no
 default=*164 :   cfobject
 component=#request.cfcpath#qrystodatabase name=qry /*
 165 :   cfset qry_unlock_items_for_paypal =
 qry.qry_unlock_items_for_paypal(
 app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
 ) /
 166 : /cffunction





 --
 Regards,
 chedder is bedder


 

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


Re: Regex help maybe

2014-07-21 Thread Claude Schnéegans

 I need one to test true for:

I doubt you can do this with only one test, but using 3 tests is easy:

 10 to 20 Characters in length
 3 numeric characters in any order
 1 special character from basic list ~!@#$%^*()_+

This should do it:
CFSET stringOK = (len(form.text) GTE 20 AND len(form.text) LTE 30
   AND arrayLen(ReMatch (\d, form.text)) EQ 3
   AND arrayLen(ReMatch ([~!@##$%^*()_+], form.text)) EQ 1)

Adjust the logical operator depending what ou need is at least or exactly.


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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread M.A. Kruger

Matt Q and everyone. I think it might be time to cut matt loose I think he's 
mostly pulling our chain. he certainly doesn't engage with the list in any way 
that makes me think he's trying. I'm perfectly fine helping beginners but 
this is a bit much. perhaps we should ask Mike D to remove him?

Sent from my iPhone

 On Jul 21, 2014, at 6:53 PM, Matt Quackenbush quackfu...@gmail.com wrote:
 
 
 I am trying really, really, really, really hard to not be rude here, but
 there's no way you can have 15 years of CF experience as you've claimed in
 other threads. Each thread you've posted recently has displayed an absolute
 dearth of information with which we can even attempt to help you, but
 they've also displayed an absolute clear lack of any troubleshooting effort
 of your own. We **WANT** to help people; it's why we are on these mailing
 lists. However, you ___must___ be willing to help yourself, first. We are
 not your own personal help desk.
 
 Please review the following links and then report back.
 
 http://www.catb.org/esr/faqs/smart-questions.html
 http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
 
 My apologies if I've incorrectly remembered the CF version you're using; I
 believe you previously said CF9, so that's the link I provided. If it's
 another version, links to the documentation are readily available by
 Googling CF {version number} documentation.
 
 Thanks.
 
 
 
 On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith chedders...@gmail.com
 wrote:
 
 
 Could not find the ColdFusion component or interface
 site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
 name is correct and that the component or interface exists.  The error
 occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
 http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line 48
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 191
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 33
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 1
 *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
 *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line 61
 
 162 :   cfargument name=app_user_id type=numeric required=no
 default=0
 163 :   cfargument name=cfuserid type=string required=no
 default=*164 :   cfobject
 component=#request.cfcpath#qrystodatabase name=qry /*
 165 :   cfset qry_unlock_items_for_paypal =
 qry.qry_unlock_items_for_paypal(
 app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
 ) /
 166 : /cffunction
 
 
 
 
 
 --
 Regards,
 chedder is bedder
 
 

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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread Russ Michaels

I think I would have to agree.
He is just posting every single error here and expecting everyone to just
fix his code for him


On Tue, Jul 22, 2014 at 1:32 AM, M.A. Kruger mkru...@cfwebtools.com wrote:


 Matt Q and everyone. I think it might be time to cut matt loose I think
 he's mostly pulling our chain. he certainly doesn't engage with the list in
 any way that makes me think he's trying. I'm perfectly fine helping
 beginners but this is a bit much. perhaps we should ask Mike D to
 remove him?

 Sent from my iPhone

  On Jul 21, 2014, at 6:53 PM, Matt Quackenbush quackfu...@gmail.com
 wrote:
 
 
  I am trying really, really, really, really hard to not be rude here, but
  there's no way you can have 15 years of CF experience as you've claimed
 in
  other threads. Each thread you've posted recently has displayed an
 absolute
  dearth of information with which we can even attempt to help you, but
  they've also displayed an absolute clear lack of any troubleshooting
 effort
  of your own. We **WANT** to help people; it's why we are on these mailing
  lists. However, you ___must___ be willing to help yourself, first. We are
  not your own personal help desk.
 
  Please review the following links and then report back.
 
  http://www.catb.org/esr/faqs/smart-questions.html
  http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
 
  My apologies if I've incorrectly remembered the CF version you're using;
 I
  believe you previously said CF9, so that's the link I provided. If it's
  another version, links to the documentation are readily available by
  Googling CF {version number} documentation.
 
  Thanks.
 
 
 
  On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith chedders...@gmail.com
  wrote:
 
 
  Could not find the ColdFusion component or interface
  site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
  name is correct and that the component or interface exists.  The error
  occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
  http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line
 48
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 191
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 33
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 1
  *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
  *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line
 61
 
  162 :   cfargument name=app_user_id type=numeric required=no
  default=0
  163 :   cfargument name=cfuserid type=string required=no
  default=*164 :   cfobject
  component=#request.cfcpath#qrystodatabase name=qry /*
  165 :   cfset qry_unlock_items_for_paypal =
  qry.qry_unlock_items_for_paypal(
  app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
  ) /
  166 : /cffunction
 
 
 
 
 
  --
  Regards,
  chedder is bedder
 
 

 

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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread M.A. Kruger

maybe he's a bot? he has no follow through. 

Sent from my iPhone

 On Jul 21, 2014, at 7:37 PM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 I think I would have to agree.
 He is just posting every single error here and expecting everyone to just
 fix his code for him
 
 
 On Tue, Jul 22, 2014 at 1:32 AM, M.A. Kruger mkru...@cfwebtools.com wrote:
 
 
 Matt Q and everyone. I think it might be time to cut matt loose I think
 he's mostly pulling our chain. he certainly doesn't engage with the list in
 any way that makes me think he's trying. I'm perfectly fine helping
 beginners but this is a bit much. perhaps we should ask Mike D to
 remove him?
 
 Sent from my iPhone
 
 On Jul 21, 2014, at 6:53 PM, Matt Quackenbush quackfu...@gmail.com
 wrote:
 
 
 I am trying really, really, really, really hard to not be rude here, but
 there's no way you can have 15 years of CF experience as you've claimed
 in
 other threads. Each thread you've posted recently has displayed an
 absolute
 dearth of information with which we can even attempt to help you, but
 they've also displayed an absolute clear lack of any troubleshooting
 effort
 of your own. We **WANT** to help people; it's why we are on these mailing
 lists. However, you ___must___ be willing to help yourself, first. We are
 not your own personal help desk.
 
 Please review the following links and then report back.
 
 http://www.catb.org/esr/faqs/smart-questions.html
 http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
 
 My apologies if I've incorrectly remembered the CF version you're using;
 I
 believe you previously said CF9, so that's the link I provided. If it's
 another version, links to the documentation are readily available by
 Googling CF {version number} documentation.
 
 Thanks.
 
 
 
 On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith chedders...@gmail.com
 wrote:
 
 
 Could not find the ColdFusion component or interface
 site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
 name is correct and that the component or interface exists.  The error
 occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
 http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line
 48
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 191
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 33
 *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
 line 1
 *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
 *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line
 61
 
 162 :   cfargument name=app_user_id type=numeric required=no
 default=0
 163 :   cfargument name=cfuserid type=string required=no
 default=*164 :   cfobject
 component=#request.cfcpath#qrystodatabase name=qry /*
 165 :   cfset qry_unlock_items_for_paypal =
 qry.qry_unlock_items_for_paypal(
 app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
 ) /
 166 : /cffunction
 
 
 
 
 
 --
 Regards,
 chedder is bedder
 
 

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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread Russ Michaels

a bot ? your just being too kind now :-)


On Tue, Jul 22, 2014 at 1:52 AM, M.A. Kruger mkru...@cfwebtools.com wrote:


 maybe he's a bot? he has no follow through.

 Sent from my iPhone

  On Jul 21, 2014, at 7:37 PM, Russ Michaels r...@michaels.me.uk wrote:
 
 
  I think I would have to agree.
  He is just posting every single error here and expecting everyone to just
  fix his code for him
 
 
  On Tue, Jul 22, 2014 at 1:32 AM, M.A. Kruger mkru...@cfwebtools.com
 wrote:
 
 
  Matt Q and everyone. I think it might be time to cut matt loose I think
  he's mostly pulling our chain. he certainly doesn't engage with the
 list in
  any way that makes me think he's trying. I'm perfectly fine helping
  beginners but this is a bit much. perhaps we should ask Mike D to
  remove him?
 
  Sent from my iPhone
 
  On Jul 21, 2014, at 6:53 PM, Matt Quackenbush quackfu...@gmail.com
  wrote:
 
 
  I am trying really, really, really, really hard to not be rude here,
 but
  there's no way you can have 15 years of CF experience as you've claimed
  in
  other threads. Each thread you've posted recently has displayed an
  absolute
  dearth of information with which we can even attempt to help you, but
  they've also displayed an absolute clear lack of any troubleshooting
  effort
  of your own. We **WANT** to help people; it's why we are on these
 mailing
  lists. However, you ___must___ be willing to help yourself, first. We
 are
  not your own personal help desk.
 
  Please review the following links and then report back.
 
  http://www.catb.org/esr/faqs/smart-questions.html
  http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
 
  My apologies if I've incorrectly remembered the CF version you're
 using;
  I
  believe you previously said CF9, so that's the link I provided. If it's
  another version, links to the documentation are readily available by
  Googling CF {version number} documentation.
 
  Thanks.
 
 
 
  On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith chedders...@gmail.com
  wrote:
 
 
  Could not find the ColdFusion component or interface
  site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that
 the
  name is correct and that the component or interface exists.  The error
  occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
  http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm:
 line
  48
  *Called from* D:/home/
 fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 191
  *Called from* D:/home/
 fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 33
  *Called from* D:/home/
 fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 1
  *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
  *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line
  61
 
  162 :   cfargument name=app_user_id type=numeric required=no
  default=0
  163 :   cfargument name=cfuserid type=string required=no
  default=*164 :   cfobject
  component=#request.cfcpath#qrystodatabase name=qry /*
  165 :   cfset qry_unlock_items_for_paypal =
  qry.qry_unlock_items_for_paypal(
  app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
  ) /
  166 : /cffunction
 
 
 
 
 
  --
  Regards,
  chedder is bedder
 
 

 

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


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread Matthew Smith

What is the issue?  I think you are being a bit harsh.  I try to get this
done on my own.  I don't think it is your call to have someone remove from
the list.


On Mon, Jul 21, 2014 at 7:32 PM, M.A. Kruger mkru...@cfwebtools.com wrote:


 Matt Q and everyone. I think it might be time to cut matt loose I think
 he's mostly pulling our chain. he certainly doesn't engage with the list in
 any way that makes me think he's trying. I'm perfectly fine helping
 beginners but this is a bit much. perhaps we should ask Mike D to
 remove him?

 Sent from my iPhone

  On Jul 21, 2014, at 6:53 PM, Matt Quackenbush quackfu...@gmail.com
 wrote:
 
 
  I am trying really, really, really, really hard to not be rude here, but
  there's no way you can have 15 years of CF experience as you've claimed
 in
  other threads. Each thread you've posted recently has displayed an
 absolute
  dearth of information with which we can even attempt to help you, but
  they've also displayed an absolute clear lack of any troubleshooting
 effort
  of your own. We **WANT** to help people; it's why we are on these mailing
  lists. However, you ___must___ be willing to help yourself, first. We are
  not your own personal help desk.
 
  Please review the following links and then report back.
 
  http://www.catb.org/esr/faqs/smart-questions.html
  http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
 
  My apologies if I've incorrectly remembered the CF version you're using;
 I
  believe you previously said CF9, so that's the link I provided. If it's
  another version, links to the documentation are readily available by
  Googling CF {version number} documentation.
 
  Thanks.
 
 
 
  On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith chedders...@gmail.com
  wrote:
 
 
  Could not find the ColdFusion component or interface
  site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
  name is correct and that the component or interface exists.  The error
  occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
  http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc: line 164*
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line
 48
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 191
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 33
  *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
  line 1
  *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
  *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line
 61
 
  162 :   cfargument name=app_user_id type=numeric required=no
  default=0
  163 :   cfargument name=cfuserid type=string required=no
  default=*164 :   cfobject
  component=#request.cfcpath#qrystodatabase name=qry /*
  165 :   cfset qry_unlock_items_for_paypal =
  qry.qry_unlock_items_for_paypal(
  app_user_id=#arguments.app_user_id#, cfuserid=#arguments.cfuserid#
  ) /
  166 : /cffunction
 
 
 
 
 
  --
  Regards,
  chedder is bedder
 
 

 

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


need help with two sites - willing to pay $45/hour

2014-07-21 Thread Matthew Smith

I have two sites with minor issues I need help with.

http://www.theartoflovingcatsanddogs.com
http://www.fatcate-juice.com

The first is an image reference issue and the second has to do with a cfc
issue.

Please let me know if anyone is interested.

Thanks.

-- 
Regards,
chedder is bedder


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


Re: Regex help maybe

2014-07-21 Thread Byron Mann

This would do one special, 3 consecutive numbers: ajfds123jdfs#

^(?=.*\d{3})(?=.*[\~\!\@\#\$\%\^\\*\(\)\_\+]+).{10,20}$

This would do one special, 3 numbers any position: a#bcdef2k3#4^

^(?=.*\d.*\d.*\d)(?=.*[\~\!\@\#\$\%\^\\*\(\)\_\+]+).{10,20}$

And if your restricting to just numbers and the special chars outline,
replace the last . in either to this.

[\d\~\!\@\#\$\%\^\\*\(\)\_\+]

So like this in the second variant:

^(?=.*\d.*\d.*\d)(?=.*[\~\!\@\#\$\%\^\\*\(\)\_\+]+)[\d\~\!\@\#\$\%\^\\*\(\)\_\+]{10,20}$

Plenty of online regex testers as well so you don't have to keep coding it
up to tweak.

I use this one a bit. http://regexpal.com/

Byron Mann
Lead Engineer  Architect
HostMySite







On Mon, Jul 21, 2014 at 5:29 PM, UXB denn...@uxbinternet.com wrote:


 I am terrible at Regex's. I looked all over and am going blind.  Is there
 anyone here that can shorted my search?  I need one to test true for:

 10 to 20 Characters in length
 3 numeric characters in any order
 1 special character from basic list ~!@#$%^*()_+


 Any help is appreciated.


 Dennis Powers
 UXB Internet - A website Design and Hosting Company
 P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
 W: http://www.uxbinternet.com
 W: http://www.ctbusinesslist.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:358953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: need help with two sites - willing to pay $45/hour

2014-07-21 Thread Mike K

I can help you.   I've been building coldfusion sites for about 15 years
now.  I have 39 sites I look after,  some of my own,   and all coldfusion
based.

I have some time available now to take on new projects. Let me know if
you are interested.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month



On Tue, Jul 22, 2014 at 11:26 AM, Matthew Smith chedders...@gmail.com
wrote:


 I have two sites with minor issues I need help with.

 http://www.theartoflovingcatsanddogs.com
 http://www.fatcate-juice.com

 The first is an image reference issue and the second has to do with a cfc
 issue.

 Please let me know if anyone is interested.

 Thanks.

 --
 Regards,
 chedder is bedder


 

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


Re: help

2014-07-18 Thread Matthew Smith

\taolcad_images\products\resize\qry_latest24items.largepic1

Still doesn't work...?
 On Jul 17, 2014, at 23:09, Maureen mamamaur...@gmail.com wrote:
 
 
 As I told you four days ago:
 Instead of a physical path like C:\magedirector\imagename.ext  you
 need a url like http://domainname.com/imagedirectory/imagename.ext
 
 You use the physical path to determine if the file exists, but you
 need the url to display it.
 
 On Thu, Jul 17, 2014 at 10:37 PM, Matthew Smith chedders...@gmail.com 
 wrote:
 
 Anyone?
 
 On Jul 15, 2014, at 1:59, Matthew Smith chedders...@gmail.com wrote:
 
 Does anyone know what path I should use?  Stuck...
 
 On Jul 13, 2014, at 10:40, Matthew Smith chedders...@gmail.com wrote:
 
 what path should i use?
 
 
 On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote:
 
 Yes, this code is broken. You have a logic error.  The code inside the
 CFCATCH will only execute of the code in the CFTRY fails.  The syntax
 on the CFCATCH tag is wrong as you have no type declared, and the code
 on the first line inside the CFCATCH is the same as what you just
 tried.  So if it fails on the TRY it will fail inside the CFCATCH.
 
 This is all very accurate except for one portion. CFCATCH doesn't
 require a type. It's generally recommended that you specify a type,
 but in the absence of that attribute it'll simply catch any exception
 thrown by the CFTRY.
 
 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 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:358900
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-18 Thread Dave Watts

  Instead of a physical path like C:\magedirector\imagename.ext  you
  need a url like http://domainname.com/imagedirectory/imagename.ext
 
  You use the physical path to determine if the file exists, but you
  need the url to display it.

 \taolcad_images\products\resize\qry_latest24items.largepic1

 Still doesn't work...?

That's still not a URL, is it?

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
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:358901
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-18 Thread mac jordan

On Fri, Jul 18, 2014 at 2:21 PM, Dave Watts dwa...@figleaf.com wrote:

  Still doesn't work...?

 That's still not a URL, is it?


​It's like pulling teeth …​



-- 
mac jordan
www.kestrel.org | www.reactivecooking.com |  www.jordan-cats.org
twitter: @ramtops


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


Re: help

2014-07-18 Thread Matt Quackenbush

Defies logic, especially given certain claims.
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358850



On Fri, Jul 18, 2014 at 8:26 AM, mac jordan mac.jor...@gmail.com wrote:


 On Fri, Jul 18, 2014 at 2:21 PM, Dave Watts dwa...@figleaf.com wrote:

   Still doesn't work...?
 
  That's still not a URL, is it?
 

 ​It's like pulling teeth …​



 --
 mac jordan
 www.kestrel.org | www.reactivecooking.com |  www.jordan-cats.org
 twitter: @ramtops


 

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


Re: help

2014-07-18 Thread M.A. Kruger

Matt, 

you need to make a stromger effort to understand what you are being told. we 
can't solve your
problem. we can only help point you in the right direction. 

Sent from my iPhone

 On Jul 18, 2014, at 6:35 AM, Matthew Smith chedders...@gmail.com wrote:
 
 
 \taolcad_images\products\resize\qry_latest24items.largepic1
 
 Still doesn't work...?
 On Jul 17, 2014, at 23:09, Maureen mamamaur...@gmail.com wrote:
 
 
 As I told you four days ago:
 Instead of a physical path like C:\magedirector\imagename.ext  you
 need a url like http://domainname.com/imagedirectory/imagename.ext
 
 You use the physical path to determine if the file exists, but you
 need the url to display it.
 
 On Thu, Jul 17, 2014 at 10:37 PM, Matthew Smith chedders...@gmail.com 
 wrote:
 
 Anyone?
 
 On Jul 15, 2014, at 1:59, Matthew Smith chedders...@gmail.com wrote:
 
 Does anyone know what path I should use?  Stuck...
 
 On Jul 13, 2014, at 10:40, Matthew Smith chedders...@gmail.com wrote:
 
 what path should i use?
 
 
 On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote:
 
 Yes, this code is broken. You have a logic error.  The code inside the
 CFCATCH will only execute of the code in the CFTRY fails.  The syntax
 on the CFCATCH tag is wrong as you have no type declared, and the code
 on the first line inside the CFCATCH is the same as what you just
 tried.  So if it fails on the TRY it will fail inside the CFCATCH.
 
 This is all very accurate except for one portion. CFCATCH doesn't
 require a type. It's generally recommended that you specify a type,
 but in the absence of that attribute it'll simply catch any exception
 thrown by the CFTRY.
 
 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 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:358905
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-18 Thread M.A. Kruger

wow I never would have guessed. maybe just a bad communicator - trouble really 
describing his problem?

Sent from my iPhone

 On Jul 18, 2014, at 8:30 AM, Matt Quackenbush quackfu...@gmail.com wrote:
 
 
 Defies logic, especially given certain claims.
 http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358850
 
 
 
 On Fri, Jul 18, 2014 at 8:26 AM, mac jordan mac.jor...@gmail.com wrote:
 
 
 On Fri, Jul 18, 2014 at 2:21 PM, Dave Watts dwa...@figleaf.com wrote:
 
 Still doesn't work...?
 
 That's still not a URL, is it?
 
 ​It's like pulling teeth …​
 
 
 
 --
 mac jordan
 www.kestrel.org | www.reactivecooking.com |  www.jordan-cats.org
 twitter: @ramtops
 
 

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


Re: help

2014-07-17 Thread Matthew Smith

Anyone?

 On Jul 15, 2014, at 1:59, Matthew Smith chedders...@gmail.com wrote:
 
 Does anyone know what path I should use?  Stuck...
 
 On Jul 13, 2014, at 10:40, Matthew Smith chedders...@gmail.com wrote:
 
 what path should i use?
 
 
 On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote:
 
  Yes, this code is broken. You have a logic error.  The code inside the
  CFCATCH will only execute of the code in the CFTRY fails.  The syntax
  on the CFCATCH tag is wrong as you have no type declared, and the code
  on the first line inside the CFCATCH is the same as what you just
  tried.  So if it fails on the TRY it will fail inside the CFCATCH.
 
 This is all very accurate except for one portion. CFCATCH doesn't
 require a type. It's generally recommended that you specify a type,
 but in the absence of that attribute it'll simply catch any exception
 thrown by the CFTRY.
 
 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 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:358897
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-17 Thread Maureen

As I told you four days ago:
Instead of a physical path like C:\magedirector\imagename.ext  you
need a url like http://domainname.com/imagedirectory/imagename.ext

You use the physical path to determine if the file exists, but you
need the url to display it.

On Thu, Jul 17, 2014 at 10:37 PM, Matthew Smith chedders...@gmail.com wrote:

 Anyone?

 On Jul 15, 2014, at 1:59, Matthew Smith chedders...@gmail.com wrote:

 Does anyone know what path I should use?  Stuck...

 On Jul 13, 2014, at 10:40, Matthew Smith chedders...@gmail.com wrote:

 what path should i use?


 On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote:

  Yes, this code is broken. You have a logic error.  The code inside the
  CFCATCH will only execute of the code in the CFTRY fails.  The syntax
  on the CFCATCH tag is wrong as you have no type declared, and the code
  on the first line inside the CFCATCH is the same as what you just
  tried.  So if it fails on the TRY it will fail inside the CFCATCH.

 This is all very accurate except for one portion. CFCATCH doesn't
 require a type. It's generally recommended that you specify a type,
 but in the absence of that attribute it'll simply catch any exception
 thrown by the CFTRY.

 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 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:358898
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-14 Thread Maureen

Yeah...my bad. I have never used CFCATCH without a type, so I forgot
it was optional.

On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote:


 This is all very accurate except for one portion. CFCATCH doesn't
 require a type. It's generally recommended that you specify a type,
 but in the absence of that attribute it'll simply catch any exception
 thrown by the CFTRY.

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


help

2014-07-13 Thread Matthew Smith

I have uploaded the images to:

 /site_ttheartoflovingcatsanddogs_com/toalcad_images
/taolcad_images/
/site_ttheartoflovingcatsanddogs_com/main/taolcad_images

I have tried:
/taolcad_images/
../../taolcad_images
This code is broke:

 !---Read the image into an object ---

  cftry
cfimage action=read name=myImage
source=../taolcad_images/products/resize/#qry_latest24items.largepic1#
cfcatch
  cfimage action=read name=myImage
source=../taolcad_images/products/#qry_latest24items.largepic1#
  !--- Set the square size of the thumb ---
  cfset sq_size = 133
  !--- Write the result to a file. ---
  cfset ImageSetAntialiasing(myImage,on)
  cfset ImageScaleToFit(myImage,sq_size,sq_size)
  !--- Calculate the x and y position to paste the
image ---
  cfif myImage.width GTE myImage.height
cfset x = 0
cfset y = ceiling((myImage.width -
myImage.height)/2)
cfelse
cfset x = ceiling((myImage.height -
myImage.width)/2)
cfset y = 0
  /cfif
  cfset newimg = ImageNew(,sq_size, sq_size, rgb,
c4cba9)
  cfset ImagePaste(newimg, myImage, x, y)
  cfset
ImageWrite(newimg,../taolcad_images/products/resize/#qry_latest24items.largepic1#)
/cfcatch
  /cftry
  cfset qry_latest24items.name = replace(
qry_latest24items.name, '', 'quot;', all)
  cfset qry_latest24items.productDescription =
replace(qry_latest24items.productDescription, '', 'quot;', all)
  cfif len(qry_latest24items.productDescription) gt 310
cfset qry_latest24items.productDescription =
mid(qry_latest24items.productDescription, 1, 310)
  /cfif
  cfset variables.item_url = /art-item/ 
lcase(rereplace(rereplacenocase(qry_latest24items.name, [^a-z|\ ], ,
all), [[:space:]]+, -, all))  -  qry_latest24items.productid 
/index.cfm
  cfset qry_latest24items.productDescription =
qry_latest24items.productDescription  ... a
href='#variables.item_url#'read more/a
  a href=#variables.item_url# title=#name#img
src=/taolcad_images/products/resize/#qry_latest24items.largepic1#
alt=#name# width=177 //a/td
td/td
tda href=#variables.item_url# title=#name#span
class=frontpageitems#qry_latest24items.name# -
#DollarFormat(qry_latest24items.unitPrice)#/span/abr /
  span
class=frontpageitemstext#qry_latest24items.productDescription#/span/td
  /tr

-- 
Regards,
chedder is bedder


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


Re: help

2014-07-13 Thread Maureen

Yes, this code is broken. You have a logic error.  The code inside the
CFCATCH will only execute of the code in the CFTRY fails.  The syntax
on the CFCATCH tag is wrong as you have no type declared, and the code
on the first line inside the CFCATCH is the same as what you just
tried.  So if it fails on the TRY it will fail inside the CFCATCH.

Also, to display images in a browser, you need that url path to the
image, not the physical path.

On Sun, Jul 13, 2014 at 8:18 AM, Matthew Smith chedders...@gmail.com wrote:

 I have uploaded the images to:

  /site_ttheartoflovingcatsanddogs_com/toalcad_images
 /taolcad_images/
 /site_ttheartoflovingcatsanddogs_com/main/taolcad_images

 I have tried:
 /taolcad_images/
 ../../taolcad_images
 This code is broke:

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


Re: help

2014-07-13 Thread Dave Watts

 Yes, this code is broken. You have a logic error.  The code inside the
 CFCATCH will only execute of the code in the CFTRY fails.  The syntax
 on the CFCATCH tag is wrong as you have no type declared, and the code
 on the first line inside the CFCATCH is the same as what you just
 tried.  So if it fails on the TRY it will fail inside the CFCATCH.

This is all very accurate except for one portion. CFCATCH doesn't
require a type. It's generally recommended that you specify a type,
but in the absence of that attribute it'll simply catch any exception
thrown by the CFTRY.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
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:358862
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-13 Thread Matthew Smith

what path should i use?


On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote:


  Yes, this code is broken. You have a logic error.  The code inside the
  CFCATCH will only execute of the code in the CFTRY fails.  The syntax
  on the CFCATCH tag is wrong as you have no type declared, and the code
  on the first line inside the CFCATCH is the same as what you just
  tried.  So if it fails on the TRY it will fail inside the CFCATCH.

 This is all very accurate except for one portion. CFCATCH doesn't
 require a type. It's generally recommended that you specify a type,
 but in the absence of that attribute it'll simply catch any exception
 thrown by the CFTRY.

 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 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:358863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Need someone to help with site

2014-07-08 Thread David Phelan

Looks like there is a missing closing tag.  If you're still having the issue 
I'd be glad to take a look.

David Phelan
Web Developer
IT Security  Web Technologies

Emerging Health
Montefiore Information Technology
3 Odell Plaza, Yonkers, NY 10701
914-457-6465 Office
dphe...@emerginghealthit.com
www.emerginghealthit.com
www.montefiore.org


From: Phillip Vector vec...@mostdeadlygame.com
Sent: Sunday, July 6, 2014 9:45 PM
To: cf-talk
Subject: Re: Need someone to help with site

Brian, refer to
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358715




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


Need someone to help with site

2014-07-06 Thread Matthew Smith

I need someone to help with a site that has been down for a month. Will pay $50 
hour via Paypal. Please email info if you are interested.

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


Re: Need someone to help with site

2014-07-06 Thread Brian Cain

Hi Matthew,

What is the site?  Any specifics as to why the site is down?

Regards,
Brian Cain

Sent from my iPhone

 On Jul 6, 2014, at 8:18 PM, Matthew Smith chedders...@gmail.com wrote:
 
 
 I need someone to help with a site that has been down for a month. Will pay 
 $50 hour via Paypal. Please email info if you are interested.
 
 

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


Re: Need someone to help with site

2014-07-06 Thread Phillip Vector

Brian, refer to
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358715


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


Need help to configure SMS with CF application

2014-04-29 Thread Sathyanarayanan Ramanathan

Dear Friends,

I have been provided with below details. I don't know how to configure SMS with 
CF application. Your valuable time  help is really appreciated.

SMS short code details:
Action: Provide
ShortCode: (4 digit no)
Sender ID: Admin
Throughput: 5
Classification: Normal

SMS Connectivity details:
IP address: 
Action: Provide

Thanks,
Sathya
(sathya0...@gmail.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:358453
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need help to configure SMS with CF application

2014-04-29 Thread John M Bliss

Perhaps helpful...?  http://smsgateway.riaforge.org


On Tue, Apr 29, 2014 at 3:17 AM, Sathyanarayanan Ramanathan 
sathya0...@gmail.com wrote:


 Dear Friends,

 I have been provided with below details. I don't know how to configure SMS
 with CF application. Your valuable time  help is really appreciated.

 SMS short code details:
 Action: Provide
 ShortCode: (4 digit no)
 Sender ID: Admin
 Throughput: 5
 Classification: Normal

 SMS Connectivity details:
 IP address: 
 Action: Provide

 Thanks,
 Sathya
 (sathya0...@gmail.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:358454
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Patch/update 9.0 help

2014-03-25 Thread Pete Ruckelshaus

Yeah, I was able to restore the VM backup that was made earlier in the day.


On Mon, Mar 24, 2014 at 12:33 PM, Carl Von Stetten
vonner.li...@vonner.netwrote:


 Did you do a backup of your computer before the upgrade so you can
 revert?  If so, take a look at the Unofficial Updater 2
 http://www.uu-2.info/ to make the patching process a bit easier.

 -Carl V.

 On 3/21/2014 4:49 PM, Pete Ruckelshaus wrote:
  Awesome.  Ran the 9.01 updater and the CF service won't restart now.
  This
  is why I don't update unless I have to.
 
 
  On Fri, Mar 21, 2014 at 6:56 PM, Russ Michaels r...@michaels.me.uk
 wrote:
 
 


 

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


Re: Patch/update 9.0 help

2014-03-24 Thread Carl Von Stetten

Did you do a backup of your computer before the upgrade so you can 
revert?  If so, take a look at the Unofficial Updater 2 
http://www.uu-2.info/ to make the patching process a bit easier.

-Carl V.

On 3/21/2014 4:49 PM, Pete Ruckelshaus wrote:
 Awesome.  Ran the 9.01 updater and the CF service won't restart now.  This
 is why I don't update unless I have to.


 On Fri, Mar 21, 2014 at 6:56 PM, Russ Michaels r...@michaels.me.uk wrote:




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


Patch/update 9.0 help

2014-03-21 Thread Pete Ruckelshaus

The recent issues with security have led me to abandon my previous
psychology of if it ain't broke, don't fix it.  I'm running CF 9.0, is
there a single patch/installer that I can run to bring my installation up
to date, or do I need to update from 9.0 to 9.01 and then from 9.01 to
9.02?  I'm just trying to determine whether the hotfixes are cumulative
withing minor version, or inclusive of all versions, and I don't want to
risk borking my install.

Thanks,

Pete Ruckelshaus


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


Re: Patch/update 9.0 help

2014-03-21 Thread Russ Michaels

You need to update to 9.0.1 and then inststall the 901 patches.
9.0.2 is not and update it is a separate version without verity which is no
longer supported.

Russ Michaels
www.michaels.me.uk
cfmldeveloper.com
cflive.net
cfsearch.com
On 21 Mar 2014 22:42, Pete Ruckelshaus pruckelsh...@gmail.com wrote:


 The recent issues with security have led me to abandon my previous
 psychology of if it ain't broke, don't fix it.  I'm running CF 9.0, is
 there a single patch/installer that I can run to bring my installation up
 to date, or do I need to update from 9.0 to 9.01 and then from 9.01 to
 9.02?  I'm just trying to determine whether the hotfixes are cumulative
 withing minor version, or inclusive of all versions, and I don't want to
 risk borking my install.

 Thanks,

 Pete Ruckelshaus


 

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


Re: Patch/update 9.0 help

2014-03-21 Thread Pete Ruckelshaus

Awesome.  Ran the 9.01 updater and the CF service won't restart now.  This
is why I don't update unless I have to.


On Fri, Mar 21, 2014 at 6:56 PM, Russ Michaels r...@michaels.me.uk wrote:


 You need to update to 9.0.1 and then inststall the 901 patches.
 9.0.2 is not and update it is a separate version without verity which is no
 longer supported.

 Russ Michaels
 www.michaels.me.uk
 cfmldeveloper.com
 cflive.net
 cfsearch.com
 On 21 Mar 2014 22:42, Pete Ruckelshaus pruckelsh...@gmail.com wrote:

 
  The recent issues with security have led me to abandon my previous
  psychology of if it ain't broke, don't fix it.  I'm running CF 9.0, is
  there a single patch/installer that I can run to bring my installation up
  to date, or do I need to update from 9.0 to 9.01 and then from 9.01 to
  9.02?  I'm just trying to determine whether the hotfixes are cumulative
  withing minor version, or inclusive of all versions, and I don't want to
  risk borking my install.
 
  Thanks,
 
  Pete Ruckelshaus
 
 
 

 

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


Re: Patch/update 9.0 help

2014-03-21 Thread Claude Schnéegans

 9.0.2 is not and update it is a separate version without verity which is no
longer supported.

Exact, and since I've never been able to get Solr to work under 9.0.1, no 
chance I ugrade to 9.0.2 !


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


Help me with some statistics gathering, if you have a moment

2014-01-02 Thread Adam Cameron

G'day:
i'm just gathering some information about people's opinions of some mooted
CFML syntax. If you could complete this survey (one multi-choice, one
optional comment), that'd be really cool:
http://cfmlblog.adamcameron.me/2014/01/a-quick-survey-about-tags-script-in.html

Cheers.

-- 
Adam


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


RE: Need help with decryption from C#

2013-11-05 Thread Paul Vernon

 I've done encryption before, and have been able to successfully send
 the encrypted data to third parties for decryption; but I've never been
 on the other side of the transfer, and the initialization vector has me
 especially confused.
 

Using CF's Decrypt(encrypted_string, key[, algorithm, encoding, IVorSalt,
iterations])

You should be able to do something like this...

Note, this is off the top of my head for TripleDES and I've not tested it in
the slightest. The only thing that really concerns me though is the chr(0)
in the middle of the StringBuffer append sequence. You may have to
experiment with how you build that ByteArray.

sb = createObject(java, java.lang.StringBuffer);
sb.append(chr(27));
sb.append(chr(9));
sb.append(chr(45));
sb.append(chr(27));
sb.append(chr(0));
sb.append(chr(72));
sb.append(chr(171));
sb.append(chr(54));

IVector = sb.toString().getBytes();  // convert the StringBuffer to a
ByteArray

outputString = Decrypt(inputString, Hash(Key, MD5), DESEDE, Base64,
IVector);

Paul



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


RE: Need help with decryption from C#

2013-11-05 Thread Patti, Michael

Thanks Paul, I hadn't considered diving into Java to construct the IVector, but 
that seems like a good approach, and produces a valid ByteArray.  You might be 
right about that chr(0) causing problems, though.  When I attempt to decrypt, 
Coldfusion is throwing this error:

An error occurred while trying to encrypt or decrypt your input string: 
Given final block not properly padded.

That's happening whether I set the Algorithm to just 'DESEDE' or to 
'DESEDE/ECB/PKCS5Padding'.  I'll keep plugging away, and thanks again for the 
pointer about the IVector construction.

-Michael

-Original Message-
From: Paul Vernon [mailto:paul.ver...@web-architect.co.uk] 
Sent: Tuesday, November 05, 2013 4:01 AM
To: cf-talk
Subject: RE: Need help with decryption from C#


 I've done encryption before, and have been able to successfully send 
 the encrypted data to third parties for decryption; but I've never 
 been on the other side of the transfer, and the initialization vector 
 has me especially confused.
 

Using CF's Decrypt(encrypted_string, key[, algorithm, encoding, IVorSalt,
iterations])

You should be able to do something like this...

Note, this is off the top of my head for TripleDES and I've not tested it in 
the slightest. The only thing that really concerns me though is the chr(0) in 
the middle of the StringBuffer append sequence. You may have to experiment with 
how you build that ByteArray.

sb = createObject(java, java.lang.StringBuffer); sb.append(chr(27)); 
sb.append(chr(9)); sb.append(chr(45)); sb.append(chr(27)); sb.append(chr(0)); 
sb.append(chr(72)); sb.append(chr(171)); sb.append(chr(54));

IVector = sb.toString().getBytes();  // convert the StringBuffer to a ByteArray

outputString = Decrypt(inputString, Hash(Key, MD5), DESEDE, Base64, 
IVector);

Paul





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


Need help with decryption from C#

2013-11-02 Thread Patti, Michael

I've been tasked with decrypting 3-DES encrypted strings provided by a 
programmer who is using C#.  He provided me with a sample of how he performs 
decryption in C#, and I've been banging my head against the wall trying to 
figure out how to translate this into CF.  I've changed the details of the key 
he provided.


private string Key = N@5q;
private readonly byte[] IVector = new byte[8] { 27, 9, 45, 27, 0, 72, 171, 54 };

  private string Decrypt(string inputString)
  {
try
{
byte[] buffer = Convert.FromBase64String(inputString);
TripleDESCryptoServiceProvider tripleDes = new 
TripleDESCryptoServiceProvider();
MD5CryptoServiceProvider MD5 = new MD5CryptoServiceProvider();
tripleDes.Key = MD5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(Key));
tripleDes.IV = IVector;
ICryptoTransform ITransform = tripleDes.CreateDecryptor();
return 
Encoding.ASCII.GetString(ITransform.TransformFinalBlock(buffer, 0, 
buffer.Length));
}
catch (Exception ex)
{ return ; }

}


I've done encryption before, and have been able to successfully send the 
encrypted data to third parties for decryption; but I've never been on the 
other side of the transfer, and the initialization vector has me especially 
confused.  

Any help would be much appreciated.

Thanks,
Michael


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


datasoure-other-oracle problems -urgent help needed

2013-07-30 Thread Debbie Eddy

I have client using Oracle 11 (I do not have Oracle) and I am trying to create 
a datasource in CF8 admin using the data they gave me via vpn.

I entered :
JDBC URL exactly as they gave me
Driver Class: oracle.jdbc.OracleDriver
and un / pw they gave me

I downloaded to C:\ColdFusion8\runtime\lib 2 files:
 ojdbc6.jar and ojdbc14.jar  (not sure which one I need)

Tried to connect and get a 'refuse' error

Client not responding to helping me debug and I am stuck

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


Re: datasoure-other-oracle problems -urgent help needed

2013-07-30 Thread Pradeep Viswanathan Rajasekaran

Debbie,

A quick search reveals does not give any hint other than this to me -
http://stackoverflow.com/questions/15501832/oracle-xe-stopped-working-tns-listener-refused-connection

Could you give us the exact error message and possibly the oracle error
code which would be something like ORA-X


On Wed, Jul 31, 2013 at 12:37 AM, Debbie Eddy eddy...@gmail.com wrote:


 I have client using Oracle 11 (I do not have Oracle) and I am trying to
 create a datasource in CF8 admin using the data they gave me via vpn.

 I entered :
 JDBC URL exactly as they gave me
 Driver Class: oracle.jdbc.OracleDriver
 and un / pw they gave me

 I downloaded to C:\ColdFusion8\runtime\lib 2 files:
  ojdbc6.jar and ojdbc14.jar  (not sure which one I need)

 Tried to connect and get a 'refuse' error

 Client not responding to helping me debug and I am stuck

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


Re: Adobe help viewer for ColdFusion broken

2013-07-03 Thread Russ Michaels

They should have open sourced it, it was a great editor

Russ Michaels
www.michaels.me.uk
 On 3 Jul 2013 04:02, Michael Dinowitz mdino...@houseoffusion.com wrote:


 The older help viewer gave more than just standard docs and I used it while
 using builder.

 As for Homesite, it still loads and runs faster than CF Builder and has
 more features than any of the 'super' notepads like sublime text. I use CF
 Builder all the time but when I want to hack a fast parser or the like,
 Homesite is just more efficient for me.



 On Tue, Jul 2, 2013 at 10:31 PM, Casey Dougall - Uber Website Solutions 
 ca...@uberwebsitesolutions.com wrote:

 
  On Tue, Jul 2, 2013 at 2:45 PM, Michael Dinowitz 
  mdino...@houseoffusion.com
   wrote:
 
   Does anyone know of a fix to allow me to view the various CF docs
 locally
   without having to use a PDF? Can the CF docs be added to the Adobe Help
   Viewer 2? (a different app)
  
 
 
  coldfusion builder...
 
  Stop using hostsite Michael...
 
 
 

 

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


Adobe help viewer for ColdFusion broken

2013-07-02 Thread Michael Dinowitz

There was an air application that allowed me to view the ColdFusion docs,
search them locally, etc. I tried to open it today and it failed. I updated
air and the app and now I get the Adobe Help Manager which says it has the
docs but gives me no way to view them.

Does anyone know of a fix to allow me to view the various CF docs locally
without having to use a PDF? Can the CF docs be added to the Adobe Help
Viewer 2? (a different app)

If there is no fix then can someone explain to me what the Adobe Help
Manager actually does/is used for? If it's junk I'll delete it.

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


Re: Adobe help viewer for ColdFusion broken

2013-07-02 Thread Casey Dougall - Uber Website Solutions

On Tue, Jul 2, 2013 at 2:45 PM, Michael Dinowitz mdino...@houseoffusion.com
 wrote:

 Does anyone know of a fix to allow me to view the various CF docs locally
 without having to use a PDF? Can the CF docs be added to the Adobe Help
 Viewer 2? (a different app)



coldfusion builder...

Stop using hostsite Michael...


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


Re: Adobe help viewer for ColdFusion broken

2013-07-02 Thread Michael Dinowitz

The older help viewer gave more than just standard docs and I used it while
using builder.

As for Homesite, it still loads and runs faster than CF Builder and has
more features than any of the 'super' notepads like sublime text. I use CF
Builder all the time but when I want to hack a fast parser or the like,
Homesite is just more efficient for me.



On Tue, Jul 2, 2013 at 10:31 PM, Casey Dougall - Uber Website Solutions 
ca...@uberwebsitesolutions.com wrote:


 On Tue, Jul 2, 2013 at 2:45 PM, Michael Dinowitz 
 mdino...@houseoffusion.com
  wrote:

  Does anyone know of a fix to allow me to view the various CF docs locally
  without having to use a PDF? Can the CF docs be added to the Adobe Help
  Viewer 2? (a different app)
 


 coldfusion builder...

 Stop using hostsite Michael...


 

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


List Manager Help

2013-06-18 Thread Robert Harrison

Hi,

I'm having a problem making a change to my list member account. It doesn't seem 
to be something I can fix on this end.  

Can someone who has access to the HOF list manager contact me off list so I can 
explain the problem I'm encountering off-list and get my account fixed?

Thanks,
Robert Harrison


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


Need RegEx help for unknown/odd characters.

2013-05-17 Thread Che Vilnonis

Good afternoon. Occasionally when parsing a RSS feed, I get RSS data I
cannot parse. Click for screenshot below (text highlighted in green). In
this example, Montreal should return Montréal but does not. What regex
could I use to remove or replace such odd characters?

http://www.asitv.com/images/_funkychar.jpg

Thanks, Che



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


Re: Need RegEx help for unknown/odd characters.

2013-05-17 Thread Nathan Strutz

How about deAccent() ?
http://cflib.org/udf/deAccent


nathan strutz
[www.dopefly.com] [hi.im/nathanstrutz]


On Wed, May 15, 2013 at 9:20 AM, Che Vilnonis ch...@asitv.com wrote:


 Good morning. Occasionally when parsing a RSS feed, I get RSS data I cannot
 parse. Click for screenshot below (text highlighted in green). In this
 example, Montreal should return Montréal but does not. What regex could I
 use to remove or replace such odd characters?

 http://www.asitv.com/images/_funkychar.jpg

 Thanks, Che




 

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


RE: Need RegEx help for unknown/odd characters.

2013-05-17 Thread Che Vilnonis

Nathan, the problem is that within the feed itself, the characters don't
have accents. When output to a browser, they funky chars display on screen
with odd geometric shapes like an upright rectangle. They're like odd ascii
chars that I have only seen a few time before. In the end, I can't insert
them into the MySQL db.

Ché

-Original Message-


How about deAccent() ?
http://cflib.org/udf/deAccent


On Wed, May 15, 2013 at 9:20 AM, Che Vilnonis ch...@asitv.com wrote:


 Good morning. Occasionally when parsing a RSS feed, I get RSS data I 
 cannot parse. Click for screenshot below (text highlighted in green). 
 In this example, Montreal should return Montréal but does not. What 
 regex could I use to remove or replace such odd characters?

 http://www.asitv.com/images/_funkychar.jpg




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


Re: Need RegEx help for unknown/odd characters.

2013-05-17 Thread Kris Jones

How about making sure the charset is set properly. I have seen this kind of
thing when not setting to UTF-8. This can be a problem either on the
ingesting, or when the feed is written.



On Fri, May 17, 2013 at 2:25 PM, Che Vilnonis ch...@asitv.com wrote:


 Nathan, the problem is that within the feed itself, the characters don't
 have accents. When output to a browser, they funky chars display on screen
 with odd geometric shapes like an upright rectangle. They're like odd ascii
 chars that I have only seen a few time before. In the end, I can't insert
 them into the MySQL db.

 Ché

 -Original Message-


 How about deAccent() ?
 http://cflib.org/udf/deAccent


 On Wed, May 15, 2013 at 9:20 AM, Che Vilnonis ch...@asitv.com wrote:

 
  Good morning. Occasionally when parsing a RSS feed, I get RSS data I
  cannot parse. Click for screenshot below (text highlighted in green).
  In this example, Montreal should return Montréal but does not. What
  regex could I use to remove or replace such odd characters?
 
  http://www.asitv.com/images/_funkychar.jpg




 

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


Need RegEx help for unknown/odd characters.

2013-05-16 Thread Che Vilnonis

Good morning. Occasionally when parsing a RSS feed, I get RSS data I cannot
parse. Click for screenshot below (text highlighted in green). In this
example, Montreal should return Montréal but does not. What regex could I
use to remove or replace such odd characters?

http://www.asitv.com/images/_funkychar.jpg

Thanks, Che




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


Re: Code Design help

2013-05-09 Thread Marty Franklin

Hello,

It appears my posts do not appear on this list? I am curious why?

Martin Franklin
ma...@assetresearch.com

Thanks

On 5/6/2013 2:50 PM, Russ Michaels wrote:
 It seems form what you have said that any user can have multiple invoices
 with payments due, in which case would it not be better to just have a
 single make payment at the bottom which they fill in with the amount they
 want to pay which is then taken off their total balance.
 But allowing users to enter amounts is prone to error, so how about have a
 checkbox at the end of each row for the user to specify which invoices they
 want to pay, then submit the form and click through to payment
 page which totals up  all the checked invoices.


 On Mon, May 6, 2013 at 7:46 PM, Chester Austin chesteraus...@gmail.comwrote:

 I was going to post this on StackOverflow but felt that it might not be
 the right type of question to ask there, so I shall post it here.

 I am tasked to create a payment form from a balance sheet.  I have a
 created a balance sheet, which is basically an HTML table that has a row
 item detail of that item.  In our case, each line is an event code and the
 total issues, payments, returns and balance (issues minus payments minus
 returns) is on each line.  Each HTML row is actually a form with a More
 Info submit button to drilldown on that specific event code with details
 passed to that form as hidden inputs.

 I am looking to extend the functionality of this report by adding a new
 column, Pay amount and, if the user has 75 to pay off of their balance,
 they can add a number (let's say 50) and they can pay for 50.

 Ideally, my train of thought is that the text field will do an AJAX submit
 to a CFC where the value and eventcode will be posted to a session
 structure, and once the user is done, the structure can be processed to do
 what it needs to.

 Am I on the right track in this?  Is there a better way to do this?  I am
 concerned about a couple things. 1) I don't want the user to have to press
 Save or Submit after each entry.  There would be at least 100 row items
 they would have to go through, it would a large wall of text, and am trying
 to help them out with at least that aspect. 2) I would like the data to be
 saved at least in the session scope. In case the user has to move to a
 different page, the information they entered would still be there.
   Ideally, I would like to save the data and recall / fill in the values so
 that they can come back, let's say the next day, and continue where they
 left off.  I have attached a screen shot of the HTML table as viewed from
 the browser: a href=
 https://dl.dropboxusercontent.com/u/6212377/sample.JPG;
 https://dl.dropboxusercontent.com/u/6212377/sample.JPG/a

 Any resources or tutorials is 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:355665
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Design help

2013-05-09 Thread Bruce Sorge

I see it just fine.
On May 9, 2013, at 10:51 AM, Marty Franklin ma...@assetresearch.com wrote:

 
 Hello,
 
 It appears my posts do not appear on this list? I am curious why?
 
 Martin Franklin
 ma...@assetresearch.com
 
 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:355666
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Design help

2013-05-09 Thread Nathan Strutz

Marty,
Depending on your mail provider and client, often you will not get a copy
of the message you sent. I got one email on this thread from you that
started If this application is multi-user consider that the [...] and of
course this one that I am replying to.

If you reply to a large thread, often the HoF mail server will let you know
that you sent a large post and it didn't appreciate it, but it by no means
blocks it.

nathan strutz
[www.dopefly.com] [hi.im/nathanstrutz]


On Thu, May 9, 2013 at 7:51 AM, Marty Franklin ma...@assetresearch.comwrote:


 Hello,

 It appears my posts do not appear on this list? I am curious why?

 Martin Franklin
 ma...@assetresearch.com

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


Re: Code Design help

2013-05-09 Thread Marty Franklin

Thanks guys appreciate responses. I recalled a different behavior so I 
assumed I was blocked. As always thanks for the education.

Marty

On 5/9/2013 7:59 AM, Nathan Strutz wrote:
 Marty,
 Depending on your mail provider and client, often you will not get a copy
 of the message you sent. I got one email on this thread from you that
 started If this application is multi-user consider that the [...] and of
 course this one that I am replying to.

 If you reply to a large thread, often the HoF mail server will let you know
 that you sent a large post and it didn't appreciate it, but it by no means
 blocks it.

 nathan strutz
 [www.dopefly.com] [hi.im/nathanstrutz]


 On Thu, May 9, 2013 at 7:51 AM, Marty Franklin ma...@assetresearch.comwrote:

 Hello,

 It appears my posts do not appear on this list? I am curious why?

 Martin Franklin
 ma...@assetresearch.com

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


Re: Code Design help

2013-05-07 Thread Marty Franklin

If this application is multi-user consider that the session scope is not 
shared. Why not trigger an ajax call on blur. You could tack this event 
all your input fields really easily using jQuery.

Good Luck!

Marty


On 5/6/2013 2:50 PM, Russ Michaels wrote:
 It seems form what you have said that any user can have multiple invoices
 with payments due, in which case would it not be better to just have a
 single make payment at the bottom which they fill in with the amount they
 want to pay which is then taken off their total balance.
 But allowing users to enter amounts is prone to error, so how about have a
 checkbox at the end of each row for the user to specify which invoices they
 want to pay, then submit the form and click through to payment
 page which totals up  all the checked invoices.


 On Mon, May 6, 2013 at 7:46 PM, Chester Austin chesteraus...@gmail.comwrote:

 I was going to post this on StackOverflow but felt that it might not be
 the right type of question to ask there, so I shall post it here.

 I am tasked to create a payment form from a balance sheet.  I have a
 created a balance sheet, which is basically an HTML table that has a row
 item detail of that item.  In our case, each line is an event code and the
 total issues, payments, returns and balance (issues minus payments minus
 returns) is on each line.  Each HTML row is actually a form with a More
 Info submit button to drilldown on that specific event code with details
 passed to that form as hidden inputs.

 I am looking to extend the functionality of this report by adding a new
 column, Pay amount and, if the user has 75 to pay off of their balance,
 they can add a number (let's say 50) and they can pay for 50.

 Ideally, my train of thought is that the text field will do an AJAX submit
 to a CFC where the value and eventcode will be posted to a session
 structure, and once the user is done, the structure can be processed to do
 what it needs to.

 Am I on the right track in this?  Is there a better way to do this?  I am
 concerned about a couple things. 1) I don't want the user to have to press
 Save or Submit after each entry.  There would be at least 100 row items
 they would have to go through, it would a large wall of text, and am trying
 to help them out with at least that aspect. 2) I would like the data to be
 saved at least in the session scope. In case the user has to move to a
 different page, the information they entered would still be there.
   Ideally, I would like to save the data and recall / fill in the values so
 that they can come back, let's say the next day, and continue where they
 left off.  I have attached a screen shot of the HTML table as viewed from
 the browser: a href=
 https://dl.dropboxusercontent.com/u/6212377/sample.JPG;
 https://dl.dropboxusercontent.com/u/6212377/sample.JPG/a

 Any resources or tutorials is 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:355658
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Code Design help

2013-05-06 Thread Chester Austin

I was going to post this on StackOverflow but felt that it might not be the 
right type of question to ask there, so I shall post it here.

I am tasked to create a payment form from a balance sheet.  I have a created 
a balance sheet, which is basically an HTML table that has a row item detail of 
that item.  In our case, each line is an event code and the total issues, 
payments, returns and balance (issues minus payments minus returns) is on each 
line.  Each HTML row is actually a form with a More Info submit button to 
drilldown on that specific event code with details passed to that form as 
hidden inputs.

I am looking to extend the functionality of this report by adding a new column, 
Pay amount and, if the user has 75 to pay off of their balance, they can add 
a number (let's say 50) and they can pay for 50.

Ideally, my train of thought is that the text field will do an AJAX submit to a 
CFC where the value and eventcode will be posted to a session structure, and 
once the user is done, the structure can be processed to do what it needs to.

Am I on the right track in this?  Is there a better way to do this?  I am 
concerned about a couple things. 1) I don't want the user to have to press 
Save or Submit after each entry.  There would be at least 100 row items 
they would have to go through, it would a large wall of text, and am trying to 
help them out with at least that aspect. 2) I would like the data to be saved 
at least in the session scope. In case the user has to move to a different 
page, the information they entered would still be there.  Ideally, I would like 
to save the data and recall / fill in the values so that they can come back, 
let's say the next day, and continue where they left off.  I have attached a 
screen shot of the HTML table as viewed from the browser: a 
href=https://dl.dropboxusercontent.com/u/6212377/sample.JPG;https://dl.dropboxusercontent.com/u/6212377/sample.JPG/a

Any resources or tutorials is 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:355656
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Design help

2013-05-06 Thread Russ Michaels

It seems form what you have said that any user can have multiple invoices
with payments due, in which case would it not be better to just have a
single make payment at the bottom which they fill in with the amount they
want to pay which is then taken off their total balance.
But allowing users to enter amounts is prone to error, so how about have a
checkbox at the end of each row for the user to specify which invoices they
want to pay, then submit the form and click through to payment
page which totals up  all the checked invoices.


On Mon, May 6, 2013 at 7:46 PM, Chester Austin chesteraus...@gmail.comwrote:


 I was going to post this on StackOverflow but felt that it might not be
 the right type of question to ask there, so I shall post it here.

 I am tasked to create a payment form from a balance sheet.  I have a
 created a balance sheet, which is basically an HTML table that has a row
 item detail of that item.  In our case, each line is an event code and the
 total issues, payments, returns and balance (issues minus payments minus
 returns) is on each line.  Each HTML row is actually a form with a More
 Info submit button to drilldown on that specific event code with details
 passed to that form as hidden inputs.

 I am looking to extend the functionality of this report by adding a new
 column, Pay amount and, if the user has 75 to pay off of their balance,
 they can add a number (let's say 50) and they can pay for 50.

 Ideally, my train of thought is that the text field will do an AJAX submit
 to a CFC where the value and eventcode will be posted to a session
 structure, and once the user is done, the structure can be processed to do
 what it needs to.

 Am I on the right track in this?  Is there a better way to do this?  I am
 concerned about a couple things. 1) I don't want the user to have to press
 Save or Submit after each entry.  There would be at least 100 row items
 they would have to go through, it would a large wall of text, and am trying
 to help them out with at least that aspect. 2) I would like the data to be
 saved at least in the session scope. In case the user has to move to a
 different page, the information they entered would still be there.
  Ideally, I would like to save the data and recall / fill in the values so
 that they can come back, let's say the next day, and continue where they
 left off.  I have attached a screen shot of the HTML table as viewed from
 the browser: a href=
 https://dl.dropboxusercontent.com/u/6212377/sample.JPG;
 https://dl.dropboxusercontent.com/u/6212377/sample.JPG/a

 Any resources or tutorials is 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:355657
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


A little help with jquery/cfm

2013-02-12 Thread Bruce Sorge

Hey all,
I have an app that is running great. User enters a code into a form field, and 
it checks the db to see if it's valid. If not they can't move on. Problem is 
that now the customer wants to be able to enter either the 2-5 character code 
OR the long name. For instance, you could enter AS or Adaptive Sports. I am not 
sure how to add this functionality into this code below as I did not write the 
query, I found it on-line and modified it for my site.

JQuery:

script src=js/jquery.js type=text/javascript/script
script type=text/javascript
pic1 = new Image(16, 16); 
pic1.src = images/loader.gif;

$(document).ready(function(){

$(#orgname).change(function() { 

var usr = $(#orgname).val();

if(usr.length = 2)
{
$(#status).html('img align=absmiddle src=images/loader.gif / Checking 
Code...');

$.ajax({ 
type: POST, 
url: checkcode.cfm, 
data: orgname=+ usr, 
success: function(msg){ 

$(#status).ajaxComplete(function(event, request, settings){ 

if(msg == 'OK')
{ 
$(#orgname).removeClass('object_error'); // if necessary
$(#orgname).addClass(object_ok);

$(this).html(' img align=absmiddle src=images/accepted.png / ');
} 
else 
{ 
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
$(this).html(msg);


}});}});}
else
{
$(#status).html('The Code should have at least 2 characters.');
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
}});});

//--

/script

Here is the check code.cfm page:

cfsetting showdebugoutput=false
 !--- Set the orgname to blank first ---
cfparam name=orgname default=

!--- Query the organizations table for all of the org names ---
cfquery name=checkName datasource=#request.dataSource#
   SELECT orgname, orglongname
   FROM organizations
/cfquery

 !--- put the names into a list ---
cfset orgnamelist = valueList(checkname.orgname, ,)

!--- Check the list against the name entered. If there is a match, then code 
is valid, otherwise conde is invalid ---
cfif listFindNoCase(orgnamelist, orgname)
cfset available = 'span style=color: Green;Code is valid./span'
cfelse
cfset available = 'span style=color: red;The Code b #orgname#/b is an 
invalid code. br /Please re-enter your code./span'
/cfif
cfoutput#available#/cfoutput 

Hopefully someone can help. The client put out a huge email blast today and 
then as an afterthought wanted the added functionality since someone already 
tried to enter the long name rather than the code as instructed.

Thanks,

Bruce

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


Re: A little help with jquery/cfm

2013-02-12 Thread Brian Cain

You should move your check into the WHERE clause of the query (WHERE  orgname = 
'#orgname#' or orglongname ='#orgname#') and change the listfindnocase 
condition to checkname.recordcount GT 0.  There is no need to return the entire 
record set and then convert it to a list.  Get rid is the orgnamelist variable 
all together.  That is a waste of resources.

To be on the safe side you should also use cfqueryparam to wrap the variables 
in your SQL statement to prevent SQL injection attacks.

Brian Cain

On Feb 12, 2013, at 7:25 PM, Bruce Sorge sor...@gmail.com wrote:

 
 Hey all,
 I have an app that is running great. User enters a code into a form field, 
 and it checks the db to see if it's valid. If not they can't move on. Problem 
 is that now the customer wants to be able to enter either the 2-5 character 
 code OR the long name. For instance, you could enter AS or Adaptive Sports. I 
 am not sure how to add this functionality into this code below as I did not 
 write the query, I found it on-line and modified it for my site.
 
 JQuery:
 
 script src=js/jquery.js type=text/javascript/script
 script type=text/javascript
 pic1 = new Image(16, 16); 
 pic1.src = images/loader.gif;
 
 $(document).ready(function(){
 
 $(#orgname).change(function() { 
 
 var usr = $(#orgname).val();
 
 if(usr.length = 2)
 {
 $(#status).html('img align=absmiddle src=images/loader.gif / Checking 
 Code...');
 
 $.ajax({ 
 type: POST, 
 url: checkcode.cfm, 
 data: orgname=+ usr, 
 success: function(msg){ 
 
 $(#status).ajaxComplete(function(event, request, settings){ 
 
 if(msg == 'OK')
 { 
 $(#orgname).removeClass('object_error'); // if necessary
 $(#orgname).addClass(object_ok);
 
 $(this).html(' img align=absmiddle src=images/accepted.png / ');
 } 
 else 
 { 
 $(#orgname).removeClass('object_ok'); // if necessary
 $(#orgname).addClass(object_error);
 $(this).html(msg);
 
 
 }});}});}
 else
 {
 $(#status).html('The Code should have at least 2 characters.');
 $(#orgname).removeClass('object_ok'); // if necessary
 $(#orgname).addClass(object_error);
 }});});
 
 //--
 
 /script
 
 Here is the check code.cfm page:
 
 cfsetting showdebugoutput=false
 !--- Set the orgname to blank first ---
 cfparam name=orgname default=
 
 !--- Query the organizations table for all of the org names ---
 cfquery name=checkName datasource=#request.dataSource#
   SELECT orgname, orglongname
   FROM organizations
 /cfquery
 
 !--- put the names into a list ---
 cfset orgnamelist = valueList(checkname.orgname, ,)
 
 !--- Check the list against the name entered. If there is a match, then code 
 is valid, otherwise conde is invalid ---
 cfif listFindNoCase(orgnamelist, orgname)
 cfset available = 'span style=color: Green;Code is valid./span'
 cfelse
 cfset available = 'span style=color: red;The Code b #orgname#/b is 
 an invalid code. br /Please re-enter your code./span'
 /cfif
 cfoutput#available#/cfoutput 
 
 Hopefully someone can help. The client put out a huge email blast today and 
 then as an afterthought wanted the added functionality since someone already 
 tried to enter the long name rather than the code as instructed.
 
 Thanks,
 
 Bruce
 
 

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


Re: A little help with jquery/cfm

2013-02-12 Thread Bruce Sorge

The think is that the check is not done when they post, it's done when they 
enter the code, then shift the focus form the form field. 

Bruce
On Feb 12, 2013, at 8:42 PM, Brian Cain bcc9...@gmail.com wrote:

 
 You should move your check into the WHERE clause of the query (WHERE  orgname 
 = '#orgname#' or orglongname ='#orgname#') and change the listfindnocase 
 condition to checkname.recordcount GT 0.  There is no need to return the 
 entire record set and then convert it to a list.  Get rid is the orgnamelist 
 variable all together.  That is a waste of resources.
 
 To be on the safe side you should also use cfqueryparam to wrap the variables 
 in your SQL statement to prevent SQL injection attacks.
 
 Brian Cain
 
 
 


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


Re: A little help with jquery/cfm

2013-02-12 Thread Brian Cain

Yes.  You are checking on checkcode.cfm.  That is the page that needs to be 
modified.

Brian Cain

On Feb 12, 2013, at 7:47 PM, Bruce Sorge sor...@gmail.com wrote:

 
 The think is that the check is not done when they post, it's done when they 
 enter the code, then shift the focus form the form field. 
 
 Bruce
 On Feb 12, 2013, at 8:42 PM, Brian Cain bcc9...@gmail.com wrote:
 
 
 You should move your check into the WHERE clause of the query (WHERE  
 orgname = '#orgname#' or orglongname ='#orgname#') and change the 
 listfindnocase condition to checkname.recordcount GT 0.  There is no need to 
 return the entire record set and then convert it to a list.  Get rid is the 
 orgnamelist variable all together.  That is a waste of resources.
 
 To be on the safe side you should also use cfqueryparam to wrap the 
 variables in your SQL statement to prevent SQL injection attacks.
 
 Brian Cain
 
 
 

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


Re: A little help with jquery/cfm

2013-02-12 Thread Bruce Sorge

Yeah, I had a brain fart. This fixed it:

 cfsetting showdebugoutput=false
 !--- Set the orgname to blank first ---
cfparam name=form.orgname default=

!--- Query the organizations table for all of the org names ---
cfquery name=checkName datasource=#request.dataSource#
   SELECT orgname, orglongname
   FROM organizations
   WHERE orgname = cfqueryparam value=#form.orgname# 
cfsqltype=cf_sql_varchar OR orglongname = cfqueryparam 
value=#form.orgname# cfsqltype=cf_sql_varchar

/cfquery

!--- Check the list against the name entered. If there is a match, then code 
is valid, otherwise code is invalid ---

cfif LEN(checkName.orgname) OR LEN(checkName.orglongname)

cfset available = 'span style=color: Green;Code is valid./span'
cfelse
cfset available = 'span style=color: red;The Code b #orgname#/b is an 
invalid code. Please re-enter your code./span'
/cfif
cfoutput#available#/cfoutput 

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


Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

First off, happy new year all!

I'm sure the answer to this is really simple but I've been banging my head
against a wall for a few hours so thought I'd ask my friendly neighbourhood
gurus.

I have a database table that needs to store currency symbols both as HTML
chars (%pound;), text code (ie. GBP) and the symbol (£)

The database table has the fields as UNICODE (nvarchar) and when I manually
paste the rows in via windows and SMSS I can put in currency symbols and
every other strange character I could find including japanese chars and
other stuff. They are all stored by SQL just fine and I can return the data
in a cfquery without any issues.

However when I try and run an insert query via CF, for example:

insert into currencies
(title,code,symbol,htmlsymbol)
values
('Pounds','GBP','£','pound;')

The £ gets converted to ??

When I insert it as N'£' I still get question marks but these have black
diamond shaped boxes around them.

I thought it was the database collation or something but as I said I can
type these characters into the table in my SMSS console and they are saved
without a problem.

We're running a linux CF server and windows database server, could that be
the problem? If so is there anyway I can get it working? I'm really
struggling to understand this problem so if anyone has encountered it
before and knows a solution or can point me in the right direction for some
reference material then I would be most grateful.

Thanks in advance ;

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


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Russ Michaels

If memory serves there is a setting in your dsn you need to change to
enable utf8

Regards
Russ Michaels
www.michaels.me.uk
www.cfmldeveloper.com - Free CFML hosting for developers
www.cfsearch.com - CF search engine
On Jan 4, 2013 10:35 AM, Edward Chanter firew...@cc.uk.com wrote:


 First off, happy new year all!

 I'm sure the answer to this is really simple but I've been banging my head
 against a wall for a few hours so thought I'd ask my friendly neighbourhood
 gurus.

 I have a database table that needs to store currency symbols both as HTML
 chars (%pound;), text code (ie. GBP) and the symbol (£)

 The database table has the fields as UNICODE (nvarchar) and when I manually
 paste the rows in via windows and SMSS I can put in currency symbols and
 every other strange character I could find including japanese chars and
 other stuff. They are all stored by SQL just fine and I can return the data
 in a cfquery without any issues.

 However when I try and run an insert query via CF, for example:

 insert into currencies
 (title,code,symbol,htmlsymbol)
 values
 ('Pounds','GBP','£','pound;')

 The £ gets converted to ??

 When I insert it as N'£' I still get question marks but these have black
 diamond shaped boxes around them.

 I thought it was the database collation or something but as I said I can
 type these characters into the table in my SMSS console and they are saved
 without a problem.

 We're running a linux CF server and windows database server, could that be
 the problem? If so is there anyway I can get it working? I'm really
 struggling to understand this problem so if anyone has encountered it
 before and knows a solution or can point me in the right direction for some
 reference material then I would be most grateful.

 Thanks in advance ;

 

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


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

Thanks Russ, I was using the JTDS driver which doesn't have that setting so
I changed it to the MS SQL driver and ticked the relevant box. It's still
not working though. Given that I deleted and recreated the DSN should I
restart the server?


On 4 January 2013 10:41, Russ Michaels r...@michaels.me.uk wrote:


 If memory serves there is a setting in your dsn you need to change to
 enable utf8

 Regards
 Russ Michaels
 www.michaels.me.uk
 www.cfmldeveloper.com - Free CFML hosting for developers
 www.cfsearch.com - CF search engine
 On Jan 4, 2013 10:35 AM, Edward Chanter firew...@cc.uk.com wrote:

 
  First off, happy new year all!
 
  I'm sure the answer to this is really simple but I've been banging my
 head
  against a wall for a few hours so thought I'd ask my friendly
 neighbourhood
  gurus.
 
  I have a database table that needs to store currency symbols both as HTML
  chars (%pound;), text code (ie. GBP) and the symbol (£)
 
  The database table has the fields as UNICODE (nvarchar) and when I
 manually
  paste the rows in via windows and SMSS I can put in currency symbols and
  every other strange character I could find including japanese chars and
  other stuff. They are all stored by SQL just fine and I can return the
 data
  in a cfquery without any issues.
 
  However when I try and run an insert query via CF, for example:
 
  insert into currencies
  (title,code,symbol,htmlsymbol)
  values
  ('Pounds','GBP','£','pound;')
 
  The £ gets converted to ??
 
  When I insert it as N'£' I still get question marks but these have black
  diamond shaped boxes around them.
 
  I thought it was the database collation or something but as I said I can
  type these characters into the table in my SMSS console and they are
 saved
  without a problem.
 
  We're running a linux CF server and windows database server, could that
 be
  the problem? If so is there anyway I can get it working? I'm really
  struggling to understand this problem so if anyone has encountered it
  before and knows a solution or can point me in the right direction for
 some
  reference material then I would be most grateful.
 
  Thanks in advance ;
 
 

 

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


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Paul Hastings

On 1/4/2013 5:34 PM, Edward Chanter wrote:
 When I insert it as N'�' I still get question marks but these have black
 diamond shaped boxes around them.

either the data input isn't unicode in the first place (ie. from a form on a 
page that's not UTF-8 encoding) or its that the data isn't being displayed 
properly (ie you're not using the correct font, more likely).

btw you should be using cfqueryparam  set the appropriate options in cfadmin 
for that DSN (ie under the advanced menu turn on the Enable High ASCII 
characters and Unicode for data sources configured for non-Latin characters 
option).




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


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

Thanks Paul, the data isn't coming from a form it's being manually entered
in the CFM and will only be run once hence the lack of cfqueryparams, I
suspect that the problem is something to do with the fonts which was why I
was thinking that the linux CF and windows DB might be the problem.
Interestingly your reply to this thread shows on my system with my £
replaced with a �. That suggests fonts somewhere along the line...


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


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Paul Hastings

On 1/4/2013 6:08 PM, Edward Chanter wrote:

 Thanks Paul, the data isn't coming from a form it's being manually entered

you mean from a static cf page? and is that page UTF-8? where's the pound 
symbol 
coming from?

if you're not using cfqueryparam, make sure to use unicode hinting (N'text').

 Interestingly your reply to this thread shows on my system with my £
 replaced with a �. That suggests fonts somewhere along the line...

that's the way it came thru the mail servers.


if you want to short circuit this, use the unicode codepoints for those symbols

ie, N'#chr(163)#' for the pound sterling symbol.
N'#chr(8364)#' for the euro, etc.


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


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

The short-circuit worked like a dream Paul, problem solved. Thank you very
much for the assistance :)


On 4 January 2013 11:18, Paul Hastings p...@sustainablegis.com wrote:


 On 1/4/2013 6:08 PM, Edward Chanter wrote:
 
  Thanks Paul, the data isn't coming from a form it's being manually
 entered

 you mean from a static cf page? and is that page UTF-8? where's the pound
 symbol
 coming from?

 if you're not using cfqueryparam, make sure to use unicode hinting
 (N'text').

  Interestingly your reply to this thread shows on my system with my £
  replaced with a �. That suggests fonts somewhere along the line...

 that's the way it came thru the mail servers.


 if you want to short circuit this, use the unicode codepoints for those
 symbols

 ie, N'#chr(163)#' for the pound sterling symbol.
 N'#chr(8364)#' for the euro, etc.


 

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


RE: Need help finding new CF Hosting

2012-12-19 Thread Russ Michaels

No you will just need to create a new dsn in the cfadmin as usual.

Regards
Russ Michaels
www.michaels.me.uk
www.cfmldeveloper.com - Free CFML hosting for developers
www.cfsearch.com - CF search engine
On Dec 19, 2012 4:10 AM, Dave Long d...@northgoods.com wrote:


 You are correct in assuming I've been using CF5. If I move to a newer
 version will my MySQL DBs stop working?

 Dave

 -Original Message-
 From: Russ Michaels [mailto:r...@michaels.me.uk]
 Sent: Tuesday, December 18, 2012 12:28 PM
 To: cf-talk
 Subject: Re: Need help finding new CF Hosting



 But that's a bridge from jdbc to odbc, not native odbc.
 If you simply create an odbc dsn in windows, you wont be able to use it
 without a bridge.

 Regards
 Russ Michaels
 www.michaels.me.uk
 www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com-
 CF search engine On Dec 18, 2012 5:51 PM, Dave Watts dwa...@figleaf.com
 
 wrote:

 
   If your using odbc them ypu must be on coldfusion 5 or older, as cf
   runs
  on
   java since cf6 and java uses jdbc.
 
  CF includes a JDBC-ODBC bridge, called SequeLink, licensed from
  DataDirect Technologies. I believe that CF 10 still includes this, and
  know that CF 9 does.
 
  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:353543
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Need help finding new CF Hosting

2012-12-18 Thread Dave Long

I'm trying to find a CF Hosting provider with 24/7 support and allows code
such as CFILE plus access to the CF Administrator so I can add ODBC sources
timely.

Any suggestions?

Dave Long
NorthGoods Merchant Services


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


Re: Need help finding new CF Hosting

2012-12-18 Thread anene . quorium

Hostek.com
--Original Message--
From: Dave Long
To: cf-talk@houseoffusion.com
ReplyTo: cf-talk@houseoffusion.com
Subject: Need help finding new CF Hosting
Sent: Dec 18, 2012 4:32 PM


I'm trying to find a CF Hosting provider with 24/7 support and allows code
such as CFILE plus access to the CF Administrator so I can add ODBC sources
timely.

Any suggestions?

Dave Long
NorthGoods Merchant Services




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


Re: Need help finding new CF Hosting

2012-12-18 Thread Russ Michaels

no host will give you access to the cfadmin on shared hosting, if you want
this then you need dedicated server/vps or use Railo instead which gives
you Railo Web admin to do everything.
ODBC data sources can be added in any hosting control panel, but they do
not work with ColdFusion anyway, you must use a ColdFusion (JDBC) DSN.

If you are in USA, then hostek.com are popular, as are viviotech and
EdgeWebHosting.
If your in UK/Europe try www.bluethunder.co





On Tue, Dec 18, 2012 at 3:32 PM, Dave Long d...@northgoods.com wrote:


 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.

 Any suggestions?

 Dave Long
 NorthGoods Merchant Services


 

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


Re: Need help finding new CF Hosting

2012-12-18 Thread Matt Quackenbush

I would highly recommend a VPS with Viviotech. They also have shared plans,
although I'm not certain what is allowed/disallowed under those plans.


On Tue, Dec 18, 2012 at 9:32 AM, Dave Long d...@northgoods.com wrote:


 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.

 Any suggestions?

 Dave Long
 NorthGoods Merchant Services


 

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


Re: Need help finding new CF Hosting

2012-12-18 Thread Kelly Matthews

I second that. Viviotech is awesome! 

On Dec 18, 2012, at 10:52 AM, Matt Quackenbush wrote:

 
 I would highly recommend a VPS with Viviotech. They also have shared plans,
 although I'm not certain what is allowed/disallowed under those plans.
 
 
 On Tue, Dec 18, 2012 at 9:32 AM, Dave Long d...@northgoods.com wrote:
 
 
 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.
 
 Any suggestions?
 
 Dave Long
 NorthGoods Merchant Services
 
 
 
 
 

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


Re: Need help finding new CF Hosting

2012-12-18 Thread Bruce Sorge

I are daily razor. They are good and allow you to set up dsn's via their 
administrator file. And they allow cffile. Their support is fast as well. 

Sent from my iPhone 4S. 

On Dec 18, 2012, at 10:32 AM, Dave Long d...@northgoods.com wrote:

 
 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.
 
 Any suggestions?
 
 Dave Long
 NorthGoods Merchant Services
 
 
 

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


Re: Need help finding new CF Hosting

2012-12-18 Thread Anthony Doherty

flinthosts.co.uk are great in the UK and their support is very quick also


On 18 December 2012 15:32, Dave Long d...@northgoods.com wrote:


 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.

 Any suggestions?

 Dave Long
 NorthGoods Merchant Services


 

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


RE: Need help finding new CF Hosting

2012-12-18 Thread Dave Long

Thanks to everyone for such a quick response. Now comes the hard part...
Making a choice.

I'm just a bit confused when Russ said ODBC datasources don't work with CF.
I've been using them for more than 10 years. 

Thanks again.

Dave

-Original Message-
From: Anthony Doherty [mailto:anthony...@gmail.com] 
Sent: Tuesday, December 18, 2012 9:58 AM
To: cf-talk
Subject: Re: Need help finding new CF Hosting



flinthosts.co.uk are great in the UK and their support is very quick also


On 18 December 2012 15:32, Dave Long d...@northgoods.com wrote:


 I'm trying to find a CF Hosting provider with 24/7 support and allows 
 code such as CFILE plus access to the CF Administrator so I can add 
 ODBC sources timely.

 Any suggestions?

 Dave Long
 NorthGoods Merchant Services


 



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


Re: Need help finding new CF Hosting

2012-12-18 Thread Brian Thornton

Hostmysite has a odbc manager.
On Dec 18, 2012 10:45 AM, Dave Long d...@northgoods.com wrote:


 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.

 Any suggestions?

 Dave Long
 NorthGoods Merchant Services


 

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


  1   2   3   4   5   6   7   8   9   10   >