Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamic Field validation=float ??
I'll give it a try and let you know. Thanks -
Dynamic Field validation=float ??
The database takes it. Because if I go to the line thats over 1000 and take the comma out it works. It's only erroring on the comma. Error in POCAmount_sectionid text Remove the comma and it works fine. Plus its an established database set to be a float field -
Dynamic Field validation=float ??
Oddly enough if I don't use cfform some of the other things don't work. I will play around with it and see what other combinations I can try and maybe I can get it to work. It just seems odd to me that it works if its under 1,000.00 and doesn't if over. Thanks for your effort. -
Dynamic Field validation=float ??
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... -
Update of a date
I got this to work when doing an update: Goodthrough = <cfif IsDefined("Form.goodThrough") AND #Form.goodThrough# NEQ "">'#DateFormat(Form.goodThrough, "mm/dd/yyyy")#'<cfelse>NULL</cfif>, -
Update of a date
If that were the case why would it work on the add? Notice the error message where it says goodthrough = ' ?' error I get: "Error","1020","08/08/05","12:13:28",,"ODBC Error Code = S1C00 (Driver not capable)<P> [Microsoft][ODBC SQL Server Driver]Optional feature not implemented<P><P> SQL =... -
Update of a date
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... -
How do I use a check box to fill in a Date in text field.
Thank you. Like I said Javascript is not my area. But sometimes am able to modify to suit my needs. Again thank you for your help.- Katiris
- Post #9
- Forum: Javascript
-
How do I use a check box to fill in a Date in text field.
Hello again. I've done more testing and the script GUJUModel doesn't work correctly. It doesn't leave the box checked. And in both cases I need it to be conditional If checked display date if check removed(off) remove the date. So if I can get falconseye to display the date It would be...- Katiris
- Post #7
- Forum: Javascript
-
How do I use a check box to fill in a Date in text field.
The script for GUJUModel works but displays more information than I want. I want date time only not the day etc. THe script from falconseye - I can't get to display the createodbcdateTime - it literally outputs createodbcdateTime. So I need just a bit more help on this if you can indulge me...- Katiris
- Post #6
- Forum: Javascript
-
How do I use a check box to fill in a Date in text field.
This is in a coldfusion page- Katiris
- Post #4
- Forum: Javascript
-
How do I use a check box to fill in a Date in text field.
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.- Katiris
- Thread
- Replies: 9
- Forum: Javascript
-
Dynamic Fields calc newfield data
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...- Katiris
- Thread
- Replies: 0
- Forum: Javascript
-
Updating Multiple Records
Thank you once again. Your solutions have resolved all open issues. -
Updating Multiple Records
That's not me that is the log file thats doing that. -
Updating Multiple Records
Thank you very much, that narrowed it down. The only problem I'm having is with the amount fields. But after 3 days of hair pulling what a giant improvement "Error","1016","07/11/05","14:01:07",,"10.1.1.17, Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322), <P>An error... -
Updating Multiple Records
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... -
-
cf_csv_to_file csv_query
As I indicated to you I'm new to this area. We are still only using CF4.5. That's why I used the tag. If there is another way please feel free to share. Up until this time I never had to do this type of thing. I'm open to learning. Thanks...K -
cf_csv_to_file csv_query
Yes I can have excel format the file. The object of the whole processes is so that no one has to do anything expect import the file into MAS200. At this point I can send the data over from the database like 6/06/05. I need to get the format to be 6/6/05 to be correct. You can't for some...
