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,
How do I clear all of session variables once the user has closed the browser window ???
Many thanks.
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 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 ...
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...
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...
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....
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...
Please tell me how to exploit this query with a SQL injection attack!
I've been reading about such attacks and I want to lock down my code a bit better. But, for some reason I can't get my...
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...
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 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 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 have values that are in Unicode. Is there a straight forward way to convert this to Ascii? TIA.
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...
I want to disable print screen and right click or print the webpage
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...
Is there a way to export on the fly a csv file created from a sql query with a click of a button using cfm?
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...
