validate w/ regular expressions in cftextarea cf9 not working
Hi CFers, i am trying to make the form super secure and have added regular expression that works fine in cfinput to cftextarea and it doesn't work...? this is in the head function FCKeditor_OnComplete(editorInstance) { editorInstance.Config["ToolbarSets"]["BasicPlus"] = [ ['SpecialChar','Bold','Italic','Underline','StrikeThrough','Link', 'Unlink','-','Cut','Copy','Paste', 'Find','Replace', '-','FontFormat','FontName','FontSize','TextColor'] ]; editorInstance.EditorWindow.parent.FCK.ToolbarSet.Load('BasicPlus') ; } tnx in advance andy ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
searching between 2 date fields with "where" in cfquery
i have a table that has two date fields (dateinx and dateoutx) and i need to find all the results for todays date that both fall between and on that date for a given customer: cID. database is msSQL2005 cfserver is 7 if todays date is 12/2/2012examples of vialable entries: - dateinx=12/2/2012 and dateoutx = 12/5/2012 - dateinx=11/2/2012 and dateoutx = 12/2/2012 - dateinx=11/2/2012 and dateoutx = 12/25/2012 i am using "smalldatetime" in msSQL2005 and also would like to create a mask so that only date: 1/1/2012 would be saved. same for time: 1:30AM in a seperate field. msSQL is saving now as 1/1/2012 01:30:00AM or some such... cfquerey at this point looks like: SELECT * FROM schdl WHERE (cID = #cID#) AND tnx in advance andy ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with cfinput tag - when validation on, field requires an entry
Bliss and Fisher... Thank you very much. the "?" did it andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with cfinput tag - when validation on, field requires an entry
i have a cfform input tag for email address. it is not required that they enter one. on the script below, it works fine when they enter something in field but opens an invalid entry popup if field is left empty. i have required="no"... also there are 4 email fields in the form: blm_eml1, blm_eml2.so on ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
iframe to cause a seperate iframe to refresh
i have a page that has 2 iframes... "iframe1" is a form "pstpg.cfm" that posts to itself and writes to table... when a visitor submits form in "iframe1" need it to tell "dsppg.cfm" in "iframe2" to refresh. i know not a cf issue but driving me nuts - note --- i use script below which has the correct function on a page that has frames and iframes where "top" is a frame name. new site has no frames so all pages load in index.cfm what i need is to just tell iframe2's file to refresh when iframe1's file is acted upon. --- tnx in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfcontent - excel - numbers beginning with 0
bb, tnx problem is that field must remain numeric... also anyone know how to reset default col width when excel file generated? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfcontent - excel - numbers beginning with 0
tnx bb, as the visitor will be importing excel file into their acctg software, field must remain numeric... also anyone know how to apply col width as seems to default to 48px tnx again >Within Excel itself, prefixing a numberish value with an apostrophe >will make it render as a string (and be absolved from zero-trimming). >Did you try that? > >cheers, >barneyb > > > >-- >Barney Boisvert >[EMAIL PROTECTED] >http://www.barneyb.com/ > >Got Gmail? I have 100 invites. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfcontent - excel - numbers beginning with 0
>Within Excel itself, prefixing a numberish value with an apostrophe >will make it render as a string (and be absolved from zero-trimming). >Did you try that? > >cheers, >barneyb > > > >-- >Barney Boisvert >[EMAIL PROTECTED] >http://www.barneyb.com/ > >Got Gmail? I have 100 invites. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfcontent - excel - numbers beginning with 0
I am creating an excel file in cf7 and all works well except when a part number begins with a 0 - i need the number to always have 5 digits as in 01234 or 12345. i have tried doing a Numberformat(partnum, '0') to no avail. can i force using "TabChar" or something? noticed the the field in the created excel file will not accept a 0 even typed in manually. thanks in advance ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4