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...
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 = ...
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?
I have a site with a login screen written in Coldfusion 7 MX. The login screen collects username and password in a form. Then it looks up the informaiton in the database. If found, the perso...
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="...
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...
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...
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.
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 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...
How can I modify the following query to ignore disabled users in Active Directory?
<cfldap action="query"
name="PhoneList"
start="#Portal.LDAPOUStart#"
attributes="cn,sn,give...
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 need validation javscript which check user enter dd-mmm-yyyy.
thanks
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,
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'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...
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 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...
Hi,
How do I clear all of session variables once the user has closed the browser window ???
Many thanks.
I can disable the checkboxes but I can't make them read only.
I am able to do this, so I know it works:
<SCRIPT LANGUAGE="JavaScript">
function disableform(staff_access_allowed_add_r...
How does one send an email with an audio file that plays automatically when the user opens the e-mail message? I have received numerous emails from friends that play audio when you open the e...
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 ...
