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...? cftextarea name=mytxt value=#wrds# message=Text - Required. Letters, Numbers and .+()' allowed pattern=^[-a-zA-Z0-9_:+().' ']{1,100}$

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: -

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

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,

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

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

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.

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

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