Re: ColdFusion Hosting Recommendations
most sites I use do the email validation rule, it is pretty well tried and tested and is the only way to ensure the email address used is real and valid. The other methods I mentioned are also fairly common practices, On Sat, Nov 5, 2011 at 2:02 AM, Maureen mamamaur...@gmail.com wrote: Sites like Trip Adviser have the best model. Every review is held in abeyance until a member of the staff approves it On Fri, Nov 4, 2011 at 6:44 PM, Steve Bryant st...@bryantwebconsulting.comwrote: Russ, That is certainly a concern and I do have some steps in place to combat that. At the same time, I am really torn with how to balance fraud checks with making it painless to post a review. Anyone else have any thoughts on this? (more thoughts from you, Russ, are welcome as well of course) 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:348467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Hosting Recommendations
Try authenticating the user using their LinkedIn or their Twitter userid. That often deters 'phony' users from creating accounts with self-serving or malicious intentions that'll skew your data. On Nov 4, 2011, at 6:44 PM, Steve Bryant st...@bryantwebconsulting.com wrote: Russ, That is certainly a concern and I do have some steps in place to combat that. At the same time, I am really torn with how to balance fraud checks with making it painless to post a review. Anyone else have any thoughts on this? (more thoughts from you, Russ, are welcome as well of course) Thanks, Steve I would like to suggest that you put some checks in place to stop hosts from reviewing themselves or posting bad reviews of the competition, as some hosts are really bad for this. require all reviewers to complete some basic details (name, address, email,website hosted with this host, time with host), and send out a validation link via email. Ideally the email address should be using the domain they listed as their website. record the hosts IP address when they sign up and do not allow any reviews from the IP or from the domain of any listed host. that should put a stop to most of the dodgy reviews :-) ~| 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:348468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Hosting Recommendations
or google, windows live logins On Sat, Nov 5, 2011 at 1:16 PM, Michael E. Carluen mecarl...@gmail.com wrote: Try authenticating the user using their LinkedIn or their Twitter userid. That often deters 'phony' users from creating accounts with self-serving or malicious intentions that'll skew your data. On Nov 4, 2011, at 6:44 PM, Steve Bryant st...@bryantwebconsulting.com wrote: Russ, That is certainly a concern and I do have some steps in place to combat that. At the same time, I am really torn with how to balance fraud checks with making it painless to post a review. Anyone else have any thoughts on this? (more thoughts from you, Russ, are welcome as well of course) Thanks, Steve I would like to suggest that you put some checks in place to stop hosts from reviewing themselves or posting bad reviews of the competition, as some hosts are really bad for this. require all reviewers to complete some basic details (name, address, email,website hosted with this host, time with host), and send out a validation link via email. Ideally the email address should be using the domain they listed as their website. record the hosts IP address when they sign up and do not allow any reviews from the IP or from the domain of any listed host. that should put a stop to most of the dodgy reviews :-) ~| 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:348469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
On 11/4/2011 11:39 PM, Torrent Girl wrote: On 11/4/2011 8:59 AM, Torrent Girl wrote: Hi All. I need to give users the ability to download a CSV and TAB file. While I found a neat little function to create a CVS file (http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a problem with dates values. the problem is the file will be created on the fly by remote users who will import the data and won't have time to manipulate it by hand. Do you need the time? If not, just send the -mm-dd format and see if that will open up automatically in Excel as date. I don't know a way to specify a date time automatically in Excel from a CSV file opening. If someone knows, please let us know. -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Google+: https://plus.google.com/117357905892731200369 ~| 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:348470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Running CF on 2008
Would permissions issues cause a 500 or a 401? Usually, permissions issues cause 401 errors. But if the share or drive is completely unavailable to the IIS user, it's possible you'd get some other error entirely. 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:348471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Running CF on 2008
Oh... and the D: drive is a drive physically ON the server right? It's not some sort of a network share that you happen to see when YOU log into the server. If it's a share then your drive mapping isn't going to help at all. You will need a UNC path (\\server\sharename\path\www) -mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Saturday, November 05, 2011 1:55 PM To: cf-talk Subject: Re: Running CF on 2008 Would permissions issues cause a 500 or a 401? Usually, permissions issues cause 401 errors. But if the share or drive is completely unavailable to the IIS user, it's possible you'd get some other error entirely. 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:348472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Dynamic query help.
I'm writing an app. for an auto repair shop that has a Flash cfgrid containing quantity, description, price and total cost (the quantity times the price). Right now, the initial total cost is being calculated in a view in the database. I've created a dynamic query (using queryNew) to hold all of the initial data from the database and it's creating and populating the dynamic query just fine. I need to be able to have the dynamic query updated as the cfgrid is edited. (for instance if the quantity or price is changed or if rows are added or removed) Then I plan on refreshing the grid using an onChange event to update the grid with the new dynamic query data which would give me the new total costs. Normally I would use one of the existing scripts out there to do all of this for me, but although the grid is in Flash format, the form itself isn't and can't be because of the design layout of the page. (in fact, I tried using the Adding the values of a cfgrid column technique posted on ASFusion website, but it will only work if I use a Flash form which I can't do for this client) Also, this is currently being hosted via shared hosting, so when I try to make the Flash grid an html grid, I get a permissions error. (shared hosting locks out some action script commands such as CreateObject, etc.) I know how to write queries to update a physical database table, but I'm not sure how to update the dynamic query. (I can't use the standard cfquery command because it requires a datasource and will only update a physical database table) Can anyone please help me out here? I've been trying to resolve this for 4 days now and my client is getting impatient. ~| 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:348473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WEBDAV Put using CFHTTP
Hi Charles, I just ran into the same problem as you described but in my case the webdav server is tied to the port 8086. Meaning, I am getting the Status code issue. Did you get to solve the issue? I am using CFMX 9.0 Thank you, Thanks, I was using the CFHTTPPARAM to put a file which is on the local file system to the WEBDAV host. This right now is not a web form just a simple cfm page. Thanks, - Charles I seem to be getting closer. I'm now getting a 409 Conflict. I really dont know much about the WEBDAV protocol. Does anyone know what a 409 Conflict is. It means that there's some reason why WebDAV can't accept the file. Maybe it's older than the one already there. Maybe you're providing incorrect parameters. Is there a reason why the name attribute of your CFHTTPPARAM contains the value base.xml? Typically, this contains the name of the formfield that contains the file the server's expecting to receive. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:348474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Output columns from a query that have been formatted as 2 words
Hi All How do you output columns from a query that have been formatted as 2 words i.e. First Name? The query is returned by a stored proc that can't be edited. ~| 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:348475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output columns from a query that have been formatted as 2 words
queryName[Column Name][rowNumber] On 11/5/11 9:38 PM, Torrent Girl wrote: Hi All How do you output columns from a query that have been formatted as 2 words i.e. First Name? The query is returned by a stored proc that can't be edited. ~| 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:348476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output columns from a query that have been formatted as 2 words
queryName[Column Name][rowNumber] On 11/5/11 9:38 PM, Torrent Girl wrote: Hi All How do you output columns from a query that have been formatted as 2 words i.e. First Name? The query is returned by a stored proc that can't be edited. Worked. 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:348477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
On 11/4/2011 11:39 PM, Torrent Girl wrote: the problem is the file will be created on the fly by remote users who will import the data and won't have time to manipulate it by hand. Do you need the time? If not, just send the -mm-dd format and see if that will open up automatically in Excel as date. I don't know a way to specify a date time automatically in Excel from a CSV file opening. If someone knows, please let us know. -- Thanks I was able to format the data. It works now. Any suggestions on creating a TAB file in CF? ~| 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:348478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
Modify http://cflib.org/udf/QueryToCSV2 to use or chr(9) (a tab
literal) as the list delimiter.
Alternately, add delimiter as an additional argument, then you can use
it for both CSV and TAB.
Cheers,
.jonah
Here's the one I'm using:
/**
* Convert the query into a CSV format using Java StringBuffer Class.
*
* @param query The query to convert. (Required)
* @param headers A list of headers to use for the first row
of the CSV string. Defaults to all the columns. (Optional)
* @param cols The columns from the query to transform.
Defaults to all the columns. (Optional)
* @return Returns a string.
* @author Qasim Rasheed (qasimrash...@hotmail.com)
* @version 1, March 23, 2005
* Modified by jBlossom 08/2011 to create tab delimited output
instead of comma.
*/
function QueryToTAB2(query){
var csv = createobject( 'java', 'java.lang.StringBuffer');
var i = 1;
var j = 1;
var cols = ;
var headers = ;
var endOfLine = chr(13) chr(10);
if (arraylen(arguments) gte 2) headers = arguments[2];
if (arraylen(arguments) gte 3) cols = arguments[3];
if (not len( trim( cols ) ) ) cols = query.columnlist;
if (not len( trim( headers ) ) ) headers = cols;
headers = listtoarray( headers, );
cols = listtoarray( cols, );
for (i = 1; i lte arraylen( headers ); i = i + 1)
csv.append( headers[i] '' );
csv.append( endOfLine );
for (i = 1; i lte query.recordcount; i= i + 1){
for (j = 1; j lte arraylen( cols ); j=j + 1){
if (isNumeric( query[cols[j]][i] ) )
csv.append( query[cols[j]][i] '' );
else
csv.append(replace(query[cols[j]][i], '', ' ',
'all') '' );
}
csv.append( endOfLine );
}
return csv.toString();
}
On 11/5/11 10:26 PM, Torrent Girl wrote:
On 11/4/2011 11:39 PM, Torrent Girl wrote:
the problem is the file will be created on the fly by remote
users who will import the data and won't have time to manipulate
it by hand.
Do you need the time? If not, just send the -mm-dd format
and see if that will open up automatically in Excel as date.
I don't know a way to specify a date time automatically in Excel
from a CSV file opening. If someone knows, please let us know.
--
Thanks I was able to format the data. It works now.
Any suggestions on creating a TAB file in CF?
~|
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:348479
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output columns from a query that have been formatted as 2 words
queryName[Column Name][rowNumber] On 11/5/11 9:38 PM, Torrent Girl wrote: Hi All How do you output columns from a query that have been formatted as 2 words i.e. First Name? The query is returned by a stored proc that can't be edited. How would I select these 2 word columns in a sub query? ~| 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:348480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output columns from a query that have been formatted as 2 words
Query of queries? Doesn't look like you can. Google says: http://www.dreamincode.net/forums/topic/156610-query-of-queries-column-names-with-spaces/ On 11/5/11 10:41 PM, Torrent Girl wrote: queryName[Column Name][rowNumber] On 11/5/11 9:38 PM, Torrent Girl wrote: Hi All How do you output columns from a query that have been formatted as 2 words i.e. First Name? The query is returned by a stored proc that can't be edited. How would I select these 2 word columns in a sub query? ~| 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:348481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
