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','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

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

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

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

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

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

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

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

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. 

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

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