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...
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 = ...
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...
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...
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....
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...
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?
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...
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...
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...
Hi All,
Think my brain might be a bit fried but is there an easy way to add on a url variable (ie searchresults.cfm?variable=1) when you want to submit a form to itself or do you have to pa...
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...
I would like to be able to do this, without refreshing page and without submitting to a new form.
After user fills in color type via radio button, have a JS to query a database and find all...
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 ...
Hi,
Is there any way to convert a form value to a number?
I've tried <cfoutput>#Val(FORM.numOfFields)#</cfoutput>
<cfoutput>#Int(FORM.numOfFields)#</cfoutput>
and CF said ...
Hi,
How can I delete the first two characters from this string.
c_2
c_25
c_20
I want to just be left with the numeric part of the string. Or everything to the right of the undersco...
I have values that are in Unicode. Is there a straight forward way to convert this to Ascii? TIA.
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...
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...
How can i get past the annoying "The page cannot be refreshed without resending the informationetc.. hit RETRY or Cancel "??
On some pop windows after they are closed the parent page refres...
