validate w/ regular expressions in cftextarea cf9 not working

2014-07-07 Thread andy mann
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','B

searching between 2 date fields with "where" in cfquery

2012-12-02 Thread Andy Mann
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

Re: problem with cfinput tag - when validation on, field requires an entry

2009-02-24 Thread andy mann
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 Arc

problem with cfinput tag - when validation on, field requires an entry

2009-02-19 Thread andy mann
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_

iframe to cause a seperate iframe to refresh

2009-01-19 Thread andy mann
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 -

Re: cfcontent - excel - numbers beginning with 0

2007-09-13 Thread andy mann
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

Re: cfcontent - excel - numbers beginning with 0

2007-09-13 Thread andy mann
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

Re: cfcontent - excel - numbers beginning with 0

2007-09-13 Thread andy mann
>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.

cfcontent - excel - numbers beginning with 0

2007-09-13 Thread andy mann
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