ColdFusion Forum

<h3>Wrap Example</h3> <cfset inputText1="Inserts line break at the location of the first white space character (such as a space, tab, or new line) before the specified limit on a line. If a line has no whitespace characters before the limit, inserts a line break at the limit. Uses the operating-system specific line break: newline for UNIX,...

Hi there I am trying to figure out how I can pass variables from a PHP file to a CF file. I need to create the admin part of my project website in Coldfusion and the public part in PHP. I tried passing it through the url but then if someone were to guess that they'd just be able to directly input the variable and the value into the address bar. Do...

Is it possible recurring payment using PayPal Pro? How to use paypal.cfc? Is paypal java sdk needed for this? can anyone gve detail description to applay paypal in coldfusion?

Hello, I have never done any web page tracking in CFM, and now I have been asked to. I can create a table in my database to hold the information but as a newbie can someone tell me how I start? An overview would be great as I really don't have a clue beyond creating a table to hold whatever data (and I think I know how to create the query to...

Hi, I need to produce a report in CF that extracts a range of values repeatedly from a database and displays the record count. For example I need to extract the recordcount where a record has a PowerRating value of between 0 - 2.9, and 3 - 7.4 and so on. I can create multiple queries: select ClientFK, ResponseLevelFK,

Hi, My database user has just decided that a recent text field in my database needs to be numeric so that some calculations can be run. I've changed it to a double so I can keep the point formatting (ie. 4.1). I have changed the data types and altered my variables to insert numbers. I have added a default value of 0 to new records added to...

How hard is it if you already have the site setup as access as the datasource to then take that same site to start using sql server 2005 db? Not the actual process of moving the database, but as far as making the site work with sql server opposed to the access db. a bit more info: I don't know anything about coldfusion. But we have someone...

Hi, My CF query script isn't bringing up the same result in Access, and I think it's the way zeroes are handled that's the problem. My Access query has three query fields - two for text and one for a number range when the number is >=0 And <=2.9 Access brings a result of 16. CF brings a result of 42! <cfquery name="KWBand1S"...

So, how do I count the number of days between two dates? I have set my variables to carry dates: <cfset dtFrom = #CreateODBCDate(dateFormat(form.Pump_FromDate, 'dd/mm/yyyy'))# /> <cfset dtTo = #CreateODBCDate(dateFormat(form.Pump_ToDate, 'dd/mm/yyyy'))# /> <cfset dtDiff = (dtTo - dtFrom) /> But can't output the number of days between...

Greetings - I saw somewhat similar code (pls see link below) that does mupltiple files upload. It works fine, but I wanted to populate the database with the same files that are uploaded to mydirectory, but for some reason, I am getting different file names on the database. Here is the full code: please do serach on kewword "database" to...

Greetings - I have a CF Form that uploads news articles, at times, I like to paste Youtube Videos with my articles. I noticed that on one server, it works fine, but on a different hosting company, my Youtube videos don't work. After I checked the database, I can see that the youTube code did get uploaded, but the Embed tag turned to InvalidTag...

Greetings - I used this code on the link below to trap IP addresses, it worked very nicely. http://www.scandicweb.com/coldfusion/tutorials/tutorial45.cfm Here is a sample output of my report: (note: I removed the real data in purpose) Tracking_Client_Address: 999.99.99.99 Tracking_Client_Host: www.xyz.com Tracking_Referrer: ...

I have a feedback Form from which my visitors send their views. At times, I see very long URLs get submitted via my Form and get entered into my database. But, when displaying the URL, my page gets distorted.. Is there a way I can script this so I can automatically convert this long URL to a small url using TinyURLcom for instance - like what...

Hi, I have created several queries which produce the same data based on a slightly difference set of variables: <cfquery name="KWBand1S" dbtype="query"> select ClientFK, ResponseLevelFK, PowerRating, WORecDate, ActualCompDate,

How to find an dpi of an image using coldfusion? is there any way to modify an images dpi using coldfusion?

am having problems formatting my table, its to contain top 15 data from a database with 5 row and 3 columns when i use the <cfoutput query="get"></cfoutput> to populate the table, it doesn't give me the desired 5x3 table format thanks

Hello, I've written a script which returns the admin rights of users in a table - their access level, and their priviledges. The priviledge are returned to a check box and the admin rights to a drop down list. I want this list to have more than one value so that it can be altered. I've created a loop to run through the drop down options...

The error seems to be error due to space or character set ========================================== Error Executing Database Query. Incorrect string value: '\xC2\x96 Jan...' for column 't61' at row 1 The error occurred in C:\ColdFusion8\wwwroot\JJ8\1_mmm\3mmm_add2_readhtml_action3===.cfm: line 79 77 : (type1, t61, add, JJ1) 78...

Hi, I'm trying to extract records for this month and output the count as a figure. I also want to do this for last month. Obviously this will be dynamic so the months update themselves with the system clock. I have written the code below but it doesn't seem to pull the correct records from my db - I only have records in there for August...

I would like to learn ColdFusion and would like to know about the best way to do that, any suggestions? John D

Hi there, Does anyone know of a decent chained selects script in CF? I'd like one that can still accept query values from the database. I found an excellent script on EasyCFM but because it uses a form I can't get it to work with my existing form on the page - clicking the dropdown executes the onSubmit action of my form and it errors out. ...

hello everyone, am having trouble creating dynamically populated XML files using data from a database. i wouldn't mind coldfussion script that can do that. thanks ya'll

I am saving a value ID using sessions on this feedback Form, but at times, if the visitor takes too long to type a a feedback, the session times out and the user received an error message. Please note, my session is set to 20 mn on the application.cfm, I do not want to increase its value because of other issues that might arise. I'd like to...

hello everyone am really having problems sending mails with coldfussion i configured my cf administrator > mail as follows server: smtp.mail.yahoo.co.uk username ***.***@yahoo.co.uk password: after verification iit gave a message: Connection Verification Successful but my mails dont leave my system the follow code sends the mail

Hi I have one website -A in which there is an Iframe. 1. If i call another website -B inside the iframe in A then cookie is not getting created. 2. If the same website B is directly opened on browser the cookie is created. 3. If i go for 1. scenario and reduce the privacy setting of the browser (IE 7) by selecting "Allow session...