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 Guys!
I have installed MS SQL Express on my machine with a Server Administrator ("sa") password. I have also installed ColdFusion MX 7 Developers Edition server on my machine. When I go ...
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 = ...
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...
Hi,
How do I clear all of session variables once the user has closed the browser window ???
Many thanks.
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...
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....
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...
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...
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 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 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 want to disable print screen and right click or print the webpage
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...
I would like to import a large amount of data into my database on my website by uploading a csv file into the database file, as opposed to inputting each record, one by one.
I have a subst...
Hi!
I have a form on a CF page that depending on the value of field Layout (a value from 1-4) the user will be taken to a different page. I know it cann be done through javascript and I thi...
I have values that are in Unicode. Is there a straight forward way to convert this to Ascii? TIA.
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...
The specified module could not be found
After installed/ reinstalled ColdFusion MX 6.0 over and over on my WinXP Pro, it keep showing me the above error, i don't know how to solve it, just ...
Hi,
I wanted to find out how I can find the difference between two dates... not just the result using DateDiff, but I need to run a query and in my where clause I have:
WHERE thedate bet...
