RE: Javascript Onclick Question
Of course in CF! That worked well. Thanks. -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 30, 2007 2:24 PM To: CF-Talk Subject: Re: Javascript Onclick Question [EMAIL PROTECTED] wrote: > I have a form that has the following javascript next to a date input > text input. When the button is pressed it simply clears the date input > box. How would I get it to populate the box with today's date instead? > > Assuming you're doing this in CF... :D onClick="document.yourFormName.form_date_signed.value='#DateFormat(Now() , "mm/dd/")#';" is one way. I'm sure there's a way to pull the current date via JS, I just don't know it off the top of my head. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Javascript Onclick Question
I have a form that has the following javascript next to a date input text input. When the button is pressed it simply clears the date input box. How would I get it to populate the box with today's date instead? 'form_date_signed' being the name of the date input text area. Lee Surma Applications Systems Engineer Wells Fargo Corporate Trust [EMAIL PROTECTED] 612-667-4066 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Regular Expression Help
How would you do numbers under one hundred with a limit of 7 decimals? Lee Surma Applications Systems Engineer Wells Fargo Corporate Trust [EMAIL PROTECTED] 612-667-4066 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Number to currency words
Is there anything out there that will take a number and convert it to words like you would have on a check? Example 12.45 would become "twelve dollars and forty five cents". Lee ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL 2000
Go into Enterprise Manager, pull down on Tools to Data Transformation Services and select import or export. Go through the wizard. You may have to set up DNS etc to get to the other database. You will also need to play around with the mappings etc. within the wizard. You probably won't nail it first shot. At the end of the wizard save it in case you need to go back and tweak it. A visual version of the DTS will be available under Data Transformation Services local packages. Lee -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: CF-Talk Subject: RE: MS SQL 2000 I believe SQL has an import utility that does just that. > -Original Message- > From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 15, 2006 12:55 PM > To: CF-Talk > Subject: OT: MS SQL 2000 > > Does anyone know of a good util (or if it can be done in SQL 2000 as i > can't see how) to import data from one database into another and allowing > fields to be mapped? (Something free would be good!) > > Thanks, Jenny > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.405 / Virus Database: 268.10.10/418 - Release Date: > 14/08/2006 > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Export text
Is there a way to get a header row on the example below? I tried putting one above the with no luck. Otherwise it works like a charm. The file gets fairly large. Does creating a 15 meg file with 110,000 records put a major load on the server? I tried the other java examples but could not get them to work with an automatic file prompt. Lee -Original Message- From: Tanguy Rademakers [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 2:39 PM To: CF-Talk Subject: Re: Export text select ID, ITEM_CONTENT_ID, REFERS_TO_ITEM_ID, EXTERNAL_REFERENCE from SC_ITEM_REFERS_TO where id < 135000 #ID#,#ITEM_CONTENT_ID#,#REFERS_TO_ITEM_ID#,#EXTERNAL_REF ERENCE# posting this from the website, so watch the formatting: it should be #col1#,[EMAIL PROTECTED] all on one line][hard return] /t ..houseoffusion.com/tiny.cfm/54 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Export text
I need to do a simple download of 100,000 plus records out of SQL. I would like the user to get prompted to save a .txt file They will be using recent versions of IE. I've been playing around with CFHeader and CFContent. It works OK if specify Application/msexcel. Does anyone have any code examples dumping to a text file? Lee ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL DateTime conversion
>Can I ask what DBMS you ae using? and also what you then need to do with >the date field? SQL Server 2000. I'm doing an insert from one table to another. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SQL DateTime conversion
I need to convert a Date Time (9/15/2006 11:05:38 AM) to a date (9/15/2006 ) within an SQL statement. The source of the data is from within the SQL statement and I don't want to do any looping so your standard CF functions don't apply. Is this possible? Lee ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243658 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Hype 2.0
Just tell them that Web 2.0 is old school and Flex is Web 3.0. Lee ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240400 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Regex Dash
Is there a remove dash(-) element in this statement? REReplaceNoCase(acc_number,"[^a-zA-Z[:space:]'0-9_&:,!()/]","","ALL") Lee Surma ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240212 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: shopping cart suggestions
> I really hate the HoF search, I never seem to find what I'm looking for. I'll second that. It must be that "Powered by Google" thing. Lee ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Evaluate vs ?
>Not sure what you're going for here, the above could be used in about the >same way or something like this: My example was altered and simplified. It goes to 12. Variables worked and speeded the page load slightly. Some of the other object type examples are intriguing. Lee Surma ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Evaluate vs ?
How would you "fix" this one? Lee Surma ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can I change query results?
I have a question related to this. When you get into a situation where you have numerous joins in one query, are you better off breaking the mess into several database Views and simplifying the query? Could you realize speed gains? Lee Surma -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:26 PM To: CF-Talk Subject: Re: Can I change query results? The query is a massive query involving an inner and a few outer joins with several conditionals around the joins. Because of new requirements, I have to add four more tables to this beast of a query so that I could let the DB do the math. If you have ever dealt with a query that involves inner and outer joins, you would understand the nightmare that is involved with guaranteeing the query always returns the data you want. So I need to do math on a column based on that specific columns needs. Since adding more joined tables to the mix cause massive problems, I want to do it after the fact. The only other choice is to rewrite the query as a stored proc but my skills are limited in that area. Phil On 3/24/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: > I'm more interested in why you "can't" do the calcs in your original > query. Why don't you post the query and tell us what the calcs you'd > like to do look like. I'll bet we can figure a way to get it done in the > query. > > --Ferg ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236159 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Date Validation Three Digit Year
I've got an interesting form date validation problem. I'm using the standard built in cfinput date validation code. I'm also using CreateODBCDate and cfQueryParam in the query End_Date <= My problem is that if a user enters a year less than 1000 (01/01/500), it gets through the CF validation but errors at the SQL level. The SQL Server settings are not available to me. I wan't to avoid adding JavaScript or doing anything server side. Are there any other possibilities? Lee Surma ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234487 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54