Hi,
The database does not display my values correctly when i submit the details, this is what i do;
<cfset gtldate = CreateDateTime(form.gtlyear, form.gtlmon, form.gtldays, form.gtlhour,...
Okay, I've programmed ColdFusion for a few years now. I'm always replacing line breaks by doing:
-----
<cfset MyString = Replace(MyString, "
", "", "ALL")>
-----
Now I know you can d...
We do not have any clients running IE 6.0 within our organization, but I need to be able to test in IE 6. Is there any solution for this other than getting another PC with 6.0 installed?
Looking abit of advice on the best way to enable or disable form fields based on whether certain checkboxs have been ticked
For example if i have two checkboxes, I tick "check box one" whi...
Hello Folks
Looking for an SQL statement, or should I say an addition to an sql statement I already have working... note I am using Coldfusion MX7 with an Access database
<cfquery name="...
Hi all,
I am trying insert a record in to oracle table from cold fusion mx.One of the fields is a date/time field.It gives me an error.Below is the code.Please help.
<cfset submitdate = ...
How do I get the entire current URL from ColdFusion?
For example, if a user is at:
http://sub.mysite.com/somedir/thisfile.cfm?q=search&advanced=1&more=etc
Is there no easy way of gett...
Hi I need to retrive the id (primary key and auto increment) of the last inserted rowso that i can ue that reference thru the is and i know we could do it using max function. But its not a rel...
I have a parent window, spawning a child window with an onChange open() command to open a separate window when a textbox in a cfinput statement changes...
Parent Window:
<cfinput name="myi...
Okay, i have a table in which i want to display a DISABLED shortlist hyperlink by default for each looped row. The shortlist hyperlink can only be enabled when the user clicks on the viewdetai...
Hello,
Ok this one should be an easy one. I'm running an insert query and one of the fields is date/time.
When I DO NOT send a value to it, I want to insert is as <NULL>, but instead, i...
How to you do a date comparison to a datetime.
ie: Have a datetime in a database and want to get all records for a single date.
After much searching I have decided to join EE so I might be able to solve my problem.
I got some code from my fellow developers to read a Excel file in Coldfusion but it no longer works i...
Hi,
How do I clear all of session variables once the user has closed the browser window ???
Many thanks.
I am trying to submit some form values to the database
However i am getting an error when i insert something like (E. Jensen) or N/o . or such special characters in text fields like street....
I've spent an hour searching and I can't find a definite answer to my problem.
I have a Coldfusion variable which is a string of SQL that I use to build a recordset. The string & records...
Hi there!
I have the problem described here:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18331
When I for example want to insert the string 'This present costs 12,00...
If I do a query of a SQL 'smalldatetime' column, this is the format I get:
DateBegin -> 2004-06-21 08:51:00
Here are the form select fields to get the dates I will compare to it. These ...
Hello All,
I have a basic ColdFusion form with input boxes and combo boxes. The combo boxes are populated by CF queries. After submittal of the form, I do some server side error checking on...
I'm trying to login to yahoo mail using CFHTTP. I read and pass the cookies, yet i'm still not succesful. Any ideas?
Feel free to plug this code into a blank cfm page. It will produces a us...
I want to set a session variable when a user closes a particular template.
I tried
<cfset temp=structclear(session)>
cfif IsDefined("Cookie.CFID") AND IsDefined("Cookie.CFTOKEN")>
<c...
In my cold fusion application I have a multiple select list. Once data is select from the multiple select list it is passed to an oracle procedure as an in parameter and used in the IN clause ...
I have a Input Box that a user inputs a whole or decimal number..
i want to validate that a user can only: -
input a whole number eg.. 10, 20 etc..
OR
if a number is specified aft...
I have a simple xml file (which I create dynamically on the server using ColdFusion's CFFILE write function) that I would like to parse, and then populate form fields with. So far, I've tried ...
I'm using MySQL. I have a form with an HTML editor in two textarea fields. So the textareas output HTML code, which I want to store in the database. Here's the query i'm using to update the ta...
