Good Morning
I have created a form that updates multiple rows with the help of the formum. In the form I have numeric data that is of type float. The current situation is if I try to update one record and another on the form is over 999.99
then I get an error indicating trouble with the...
I'm using this method to load a date in a insert query.
<cfif IsDefined("Form.goodThrough") AND len(trim(Form.goodThrough))>
<cfqueryparam value="#DateFormat(Form.goodThrough, "mm/dd/yyyy")#" cfsqltype="CF_SQL_DATE"><cfelse>NULL</cfif>
so that I don't get 1/1/1900
The problem...
I'm in need of help as I'm not a javascript person. I need to be able to check a checkbox and fill in a text field with the ODBCDateTime. Can anyone help me? I'm sure that there is a script already that does this type of thing.
I'm sure this has been addressed before but what I'm looking for is a way to calculate amount based on the number of days * perday amount. My fields are dynamic on the form as I do multiple updates with one submit.
This script was written with hardcoded fieldname and I need it to read the...
Can any of you lend a hand. I have a form that displays multiple records from one table and need to be able to update one or more record from that form. I have written the query to update the table. With one record it works fine. With two or more I bomb. I have a loop but it acts like it's...
I have a query that I converted a date field to a varchar so I could eliminate the time stamp but when I use the cf_csv_to_file csv_query custom tag the date gets changed from
6/6/05 to 6/06/2005 in the csv file. Can anyone help me with this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.