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 = ...
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...
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,
How do I clear all of session variables once the user has closed the browser window ???
Many thanks.
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...
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....
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 values that are in Unicode. Is there a straight forward way to convert this to Ascii? TIA.
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 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 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 ...
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 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...
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 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...
Hello Experts,
Does anyone know the best way to read an excel file using coldfusion? I need to have the ability to read the FULL DATA contained within the xls file so keep in mind that the...
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...
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 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...
