RE: SQL HELP!
Ascension day. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 mei 2004 3:07 To: CF-Talk Subject: RE: SQL HELP! what holiday? tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
XPath Help
Hi, I'm trying to get some XPath to work with respect to a navigation tree. ?xml version=1.0 encoding=utf-8 ? tree node objectid=3456 title=Informationa node objectid=2134 title=Contact / node objectid=5656 title=Top 1.2 / node objectid=5672 title=Top 1.3 / node objectid=123 title=Top 1.4 / node objectid=8357 title=Top 1.5 / /node node objectid=9834 title=Banks circuit=banks / node objectid=2245 title=Corporates circuit=corporates node objectid=45688 title=Top 3.1 / node objectid=9567 title=Top 3.2 / node objectid=4633 title=Top 3.3 / /node node objectid=1554 title=Managers / node objectid=6734 title=Library / /tree I can use Xpath to return all the child nodes within a node using //[EMAIL PROTECTED]3] However, how can I do this in reverse?How can I retrieve the node that is the parent of a particular node?How can I get the objectid of the parent of 2134? Any help you could share would be great! Thanks Tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Homesite Resource Window
My resource window in homesite became undocked somehow.. anyone know how to dock it? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite Resource Window
Try View Resource Tab? -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:08 PM To: CF-Talk Subject: Homesite Resource Window My resource window in homesite became undocked somehow.. anyone know how to dock it? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Selecting by row or CurrentRow
Could someone remind me of the syntax to select by row? I don't remember where to find that. Thanx Select * From qProduct Where CurrentRow = #theRowIWant# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite Resource Window
My resource window in homesite became undocked somehow.. anyone know how to dock it? Double clicking the title bar works in CF Studio if you undock any of tabs, if that helps -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite Resource Window
Nope... That won't re-dock it.:-( It is so annoying. It would be nice if you dragged it to the edge and it snapped in place, but that is just wishful thinking. Mike -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:09 AM To: CF-Talk Subject: RE: Homesite Resource Window Try View Resource Tab? -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:08 PM To: CF-Talk Subject: Homesite Resource Window My resource window in homesite became undocked somehow.. anyone know how to dock it? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite Resource Window
Double clicking the title bar works in CF Studio if you undock any of tabs, if that helps Nope. That does not work either.:-( [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite Resource Window
It's happened to me several times ... i got it back somehow. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:17 PM To: CF-Talk Subject: RE: Homesite Resource Window Nope... That won't re-dock it.:-( It is so annoying. It would be nice if you dragged it to the edge and it snapped in place, but that is just wishful thinking. Mike -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:09 AM To: CF-Talk Subject: RE: Homesite Resource Window Try View Resource Tab? -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:08 PM To: CF-Talk Subject: Homesite Resource Window My resource window in homesite became undocked somehow.. anyone know how to dock it? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
Could you give an example? On Thu, 20 May 2004 15:08:40 -0400, Philip Arnold wrote: From: Nathan R. Jessop I don't want to use a database because of oeverhead. In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Homesite Resource Window (SOLVED)
Left click in the floating window. Hold down shift while right clicking... Select the move to option (top, bottom, left, right). Do that for each resource tab What a stupid way of doing it!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list Jumping in here so ignore if this does help you cfset noDupsList = cfloop list=dupsList index=anything cfif not listFindNoCase(noDupsList, anything) cfset noDupsList = listAppend(noDupsList,anything) /cfif /cfloop -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CSS 'focus' in IE
IE6 doesn't support focus in CSS.However Dean Edwards Beta of IE7 (Internet Extensions) which is a set of behaviors for IE6 to make it more CSS 2 compliant does support it.You can find the behaviors at http://dean.edwards.name/IE7/ _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 11:51 AM To: CF-Talk Subject: OT: CSS 'focus' in IE Hello I've been looking at http://www.w3.org/TR/CSS21/selector.html#pseudo-elements and the pseudo-class 'focus' When I've got style type=text/css .input { background: #CC; color: #00; } .input:focus { background: #FF; color: #FF; } /style input type=text size=20 maxchar=20 class=input / It works in Firebird 0.8 ok... but not in IE 6... anybody know a hack to achieve it keeping it all in the CSS for IE 6?Or do we need to wait for IE 7? I've had a root about google but can't see anything that would help me. (it's a external development done in UNIFACE so got no control over the generation of the HTML code of the input elements) Cheers if anyone can help. -- David Collie _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT - Last nights NYCFUG meeting.
This is a bit unfair to those of us who live in remote enough locations that there are no close MMUGs and our seasonal work environments don't allow much travel during this time of year... Cutter Ben Forta wrote: No, that was not specifically mentioned. I can't comment on this feature specifically, but I do plan on discussing this on tour stops. --- Ben _ From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 12:37 PM To: CF-Talk Subject: Re: SOT - Last nights NYCFUG meeting. I didn't sign an NDA ;) If NYCFUG was in on the MM Breeze presentation, it was basically a high level overview of MM's plans for the rest of the year and into next. Some teaser demos of BlackStone, including very nifty CFFORM FLASH integration. Also CFDOCUMENT TYPE=PDF (or something to that effect). ~ Ubqtous ~ I missed it last night.Talking about BlackStone, anything about code protection? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CSS 'focus' in IE
IE6 doesn't support focus in CSS.However Dean Edwards Beta of IE7 (Internet Extensions) Cheers, will look into it... users wanting the input boxes to change color and you know how it goes, gotta get it working for them Cheers everyone :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF in montreal (quebec) ?
Hi there, does anyone of you knows if there is a big community of CF programmer in montreal... I always see on this list conference and stuff in the States and in Toronto for Canada.. Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XPath Help
I found this site to be an excellent eye opener for xPath. http://www.zvon.org/xxl/XPathTutorial/General/examples.html Ian - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ian Sheridan [EMAIL PROTECTED] http://www.savagevines.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XPath Help
I shot that off to fast here is a more focused link. the site is a little confusing. http://www.zvon.org/xxl/XPathTutorial/Output/example1.html On May 21, 2004, at 7:56 AM, Ian Sheridan wrote: I found this site to be an excellent eye opener for xPath. http://www.zvon.org/xxl/XPathTutorial/General/examples.html Ian - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ian Sheridan [EMAIL PROTECTED] http://www.savagevines.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT - Last nights NYCFUG meeting.
We're planning an online Breeze based sessions for user groups not visited, but I don't have the details yet. I'll post them as soon as I do. --- Ben _ From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:50 AM To: CF-Talk Subject: Re: SOT - Last nights NYCFUG meeting. This is a bit unfair to those of us who live in remote enough locations that there are no close MMUGs and our seasonal work environments don't allow much travel during this time of year... Cutter Ben Forta wrote: No, that was not specifically mentioned. I can't comment on this feature specifically, but I do plan on discussing this on tour stops. --- Ben _ From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 12:37 PM To: CF-Talk Subject: Re: SOT - Last nights NYCFUG meeting. I didn't sign an NDA ;) If NYCFUG was in on the MM Breeze presentation, it was basically a high level overview of MM's plans for the rest of the year and into next. Some teaser demos of BlackStone, including very nifty CFFORM FLASH integration. Also CFDOCUMENT TYPE=PDF (or something to that effect). ~ Ubqtous ~ I missed it last night.Talking about BlackStone, anything about code protection? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XPath Help
At 07:04 AM 5/21/2004, you wrote: Hi, I'm trying to get some XPath to work with respect to a navigation tree. ?xml version=1.0 encoding=utf-8 ? tree node objectid=3456 title=Informationa node objectid=2134 title=Contact / node objectid=5656 title=Top 1.2 / node objectid=5672 title=Top 1.3 / node objectid=123 title=Top 1.4 / node objectid=8357 title=Top 1.5 / /node node objectid=9834 title=Banks circuit=banks / node objectid=2245 title=Corporates circuit=corporates node objectid=45688 title=Top 3.1 / node objectid=9567 title=Top 3.2 / node objectid=4633 title=Top 3.3 / /node node objectid=1554 title=Managers / node objectid=6734 title=Library / /tree I can use Xpath to return all the child nodes within a node using //[EMAIL PROTECTED]3] Couple of things here, Tony. 1) You can chain xpaths together. 2) Learn all of the Xpaths Axes (sp?)! In this case, you could grab the objectID of the node element with an objectID of 2134 like this: //[EMAIL PROTECTED]/parent::node Notice the reference to the exact node, and then a reference to the parent axis, asking for a node element. Hope this helps. -- Alex Sherwood PHS Collection Agency THE COLLECTORS P:813-283-4579 F:301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: oracle unique id or identity
Daniel, Can you create the sequence and then just run a test on it outside the trigger. In other words, just try this: SELECT uniqueNum_s.nextval FROM dual; Does this work? Here's an example of a trigger that I use for updates/inserts. On insert, it auto-increments the id field. On update, it checks to make sure someone isn't trying to change the primary key and raises an error if they do. -- Start of DDL script for TRG_CFS_BREAKFASTDATAID -- Generated 21-May-047:31:40 am -- from t817a-FLPWEB:1 -- Trigger TRG_CFS_BREAKFASTDATAID CREATE OR REPLACE TRIGGER flpweb.trg_cfs_breakfastdataid BEFORE INSERTOR UPDATE ON flpweb.cfs_breakfastdata REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE iCounter cfs_breakfastdata.breakfastdataid%TYPE; cannot_change_counter EXCEPTION; BEGIN IF INSERTING THEN Select SEQ_cfs_breakfastdataid.NEXTVAL INTO iCounter FROM Dual; :new.breakfastdataid := iCounter; END IF; IF UPDATING THEN IF NOT (:new.breakfastdataid = :old.breakfastdataid) THEN RAISE cannot_change_counter; END IF; END IF; EXCEPTION WHEN cannot_change_counter THEN raise_application_error(-2, 'Cannot Change Counter Value'); END; / -- End of DDL script for TRG_CFS_BREAKFASTDATAID - Original Message - From: daniel kessler well I still can't get it to work.I am trying to auto-increment the id field in the table hhp_calendar, using: I get an error stating that dpch: uniqueNum_s is invalid and can't be initialized. Any thoughts getting this to work or can anyone recommend a more appropriate forum? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
new member: web fetching
Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.How would one fetch content from another webpage on the server. For example, grab a weather map from weather.com and cache it on my server.I can figure out the display and updating part.Just not sure how to grab the file to save it in the first place. I'm running MX 6 if it makes any difference. -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
I added the list attribute to my cfloop and now I get an error. What am I doing wrong? Here is my code: select name=filelistselect size=15 multiple class=dirlinks cfloop LIST=duplist INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupsList = listAppend(noDupsList,i) /cfif /cfloop /select On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote: In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list Jumping in here so ignore if this does help you cfset noDupsList = cfloop list=dupsList index=anything cfif not listFindNoCase(noDupsList, anything) cfset noDupsList = listAppend(noDupsList,anything) /cfif /cfloop -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new member: web fetching
cfhttp. Pat -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:39 AM To: CF-Talk Subject: new member: web fetching Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.How would one fetch content from another webpage on the server. For example, grab a weather map from weather.com and cache it on my server.I can figure out the display and updating part.Just not sure how to grab the file to save it in the first place. I'm running MX 6 if it makes any difference. -mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Selecting records from form fields
Hi all our application have an form with dynamic fields... like this... After user choices that options i need to select Form Fields: CHECK_QUESTIONID=8,11,10 STEP=1 FIELDNAMES=STEP2,CHECK_QUESTIONID,SELECT_ATRIB_8,SELECT_ATRIB_11,SELECT_ATRIB_10,SUBMIT SELECT_ATRIB_10=4 SELECT_ATRIB_11=5 SELECT_ATRIB_8=2 In the action page i need to show the Question Description from the CHECK_QUESTIONID and SELECT the SELECT_ATRIB_X, where X is the user choice (QUESTIONID = 10 ; SELECT_ATRIB = 4)... Any tips? Comments? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new member: web fetching
More specifically please... :) -Original Message- From: Whittingham, P [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: new member: web fetching cfhttp. Pat -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:39 AM To: CF-Talk Subject: new member: web fetching Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.How would one fetch content from another webpage on the server. For example, grab a weather map from weather.com and cache it on my server.I can figure out the display and updating part.Just not sure how to grab the file to save it in the first place. I'm running MX 6 if it makes any difference. -mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
What error are you getting? -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: Ignoring duplicates in select I added the list attribute to my cfloop and now I get an error. What am I doing wrong? Here is my code: select name=filelistselect size=15 multiple class=dirlinks cfloop LIST=duplist INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupsList = listAppend(noDupsList,i) /cfif /cfloop /select On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote: In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list Jumping in here so ignore if this does help you cfset noDupsList = cfloop list=dupsList index=anything cfif not listFindNoCase(noDupsList, anything) cfset noDupsList = listAppend(noDupsList,anything) /cfif /cfloop -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
Actually now I look at it when you do a LIST the syntax is: CFLOOP INDEX=Z LIST=#MyListName# There is no from and to attributes -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: Ignoring duplicates in select I added the list attribute to my cfloop and now I get an error. What am I doing wrong? Here is my code: select name=filelistselect size=15 multiple class=dirlinks cfloop LIST=duplist INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupsList = listAppend(noDupsList,i) /cfif /cfloop /select On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote: In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list Jumping in here so ignore if this does help you cfset noDupsList = cfloop list=dupsList index=anything cfif not listFindNoCase(noDupsList, anything) cfset noDupsList = listAppend(noDupsList,anything) /cfif /cfloop -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new member: web fetching
A good link to bookmark is that of the livedocs at Macromedia's website. It comes in very handy and even has examples, although I'd take them with a grain of salt.:-) http://livedocs.macromedia.com/coldfusion/6.1/index.html Welcome aboard and I think you will find this list more useful than cf-community. Mike More specifically please... cfhttp. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF in montreal (quebec) ?
Hi there, does anyone of you knows if there is a big community of CF programmer in montreal... YEHHH ! ;-) -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
CFLOOP INDEX=i LIST=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupList = listAppend(noDupList,i) /cfif /CFLOOP After making the change to the CFLOOP I get the following error: An error occurred while evaluating the _expression_. not listFindNoCase(i, duplist) On Fri, 21 May 2004 08:53:05 -0400, Adkins, Randy wrote: What error are you getting? -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: Ignoring duplicates in select I added the list attribute to my cfloop and now I get an error. What am I doing wrong? Here is my code: select name=filelistselect size=15 multiple class=dirlinks cfloop LIST=duplist INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupsList = listAppend(noDupsList,i) /cfif /cfloop /select On Fri, 21 May 2004 12:43:36 +0100, [EMAIL PROTECTED] wrote: In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list Jumping in here so ignore if this does help you cfset noDupsList = cfloop list=dupsList index=anything cfif not listFindNoCase(noDupsList, anything) cfset noDupsList = listAppend(noDupsList,anything) /cfif /cfloop -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new member: web fetching
I thought cfhttp would be the correct route, but was skeptical after reading the man page for it.. -mike -Original Message- From: Monique Boea [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Fri, 21 May 2004 08:51:52 -0400 Subject: RE: new member: web fetching More specifically please... :) -Original Message- From: Whittingham, P [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: new member: web fetching cfhttp. Pat -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:39 AM To: CF-Talk Subject: new member: web fetching Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.How would one fetch content from another webpage on the server. For example, grab a weather map from weather.com and cache it on my server.I can figure out the display and updating part.Just not sure how to grab the file to save it in the first place. I'm running MX 6 if it makes any difference. -mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
You are looping over an array, you will need to set your values within the loop, it would be something like this cfset noDupList = CFLOOP INDEX=i LIST=#ArrayLen(arPages)# cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP I haven't ran it but it _should_ work. -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
From: Nathan R. Jessop CFLOOP INDEX=i LIST=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupList = listAppend(noDupList,i) /cfif /CFLOOP The LIST attribute loops over a delimited list, ArrayLen returns one number, so you're looping over one item If you're going to loop over an Array, you have to use FROM and TO [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Ignoring duplicates in select
Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP was more concerned with what was going on in the loop rats :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
excel files
Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: excel files
I don't know if this would help, but if you can export the files to a csv file via Excel, you could then read the file using cffile (read) - no datasource But, you would have to change the file, and I don't know if that is possible for you or not. Ray At 09:20 AM 5/21/2004, George Abraham wrote: Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Ignoring duplicates in select
It's now displaying my list but its still duplicating. I think it has something to do with the extra lines of code that I stripped out before I posted this. Something is conflicting. I'm reading in an external file that looks like this: 001folio:2201 . . . 274.00 points free 002folio:2251 . . . 021.00 points free 003folio:2252 . . . 001.00 points free 004folio:2253 . . . 011.00 points free 005folio:2254 . . . 001.00 points free 006folio:2201 . . . 006.50 points free 007folio:2251 . . . 230.50 points free 008folio:2252 . . . 000.00 points free 009folio:2253 . . . 001.00 points free 010folio:2254 . . . 202.50 points free Here is ALL the code in the CFLOOP cfset noDupList = cfloop INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset sValNoComma = arPages[i] cfset sVal = Trim(ListFirst(arPages[i], )) cfset sDisp = Trim(ListLast(arPages[i], )) cfset sValNoComma = NumberFormat(sVal, 99) cfset sVal = NumberFormat(sVal) cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /cfloop This is the output I'm getting now: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 Seq: 6Folio:2201 Seq: 7Folio:2251 Seq: 8Folio:2252 Seq: 9Folio:2253 Seq: 10Folio:2254 I want it to about like this. Ignoring the duplicates: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote: Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP was more concerned with what was going on in the loop rats :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: excel files
I toyed with that idea, but the users really shouldn't be saddled with something like that. Besides, the querying of Excel files using SQL is easier to code and debug. George At 09:26 AM 5/21/2004, Ray Champagne wrote: I don't know if this would help, but if you can export the files to a csv file via Excel, you could then read the file using cffile (read) - no datasource But, you would have to change the file, and I don't know if that is possible for you or not. Ray At 09:20 AM 5/21/2004, George Abraham wrote: Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: excel files
George Abraham wrote: Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? There may be an easier solution, but the Jakarta POI project allows you to read and write Excel files in Java.I'm sure you could use it within CFMX. http://jakarta.apache.org/poi/ - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: excel files
Rick, Ultimately that is probably what I will end up doing. Before asking the forum, I did some research into POI and decided as a long-term solution, that is probably what is best for manipulating Word and Excel Files. I was hoping for an easier solution though, as you said. :-) By the way, is there any URL that details how exactly to use POI within a CFMX environment? George At 09:31 AM 5/21/2004, you wrote: George Abraham wrote: Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? There may be an easier solution, but the Jakarta POI project allows you to read and write Excel files in Java.I'm sure you could use it within CFMX. http://jakarta.apache.org/poi/ - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
What causes this sporadic error?
Hi all, This appears every once in a while when clicking a link or using the browser's back button.I have cookies enabled on my Win XP machine, using IE 6.Do I have a setting wrong in the cfapplication tag?I presently do not have a #URLSessionFormat()# or other similar function on the links, and the error appears when just clicking a normal a href="" tag. = Error Occurred While Processing Request CFID, CFTOKEN contains invalid characters. This exception is caused by either broken links, or security attacks. The invalid id is 2847bbb19bdbaac9-9a÷N466-3048-282E-34D24869A0974CAC The error occurred in C:\Inetpub\mysite\Application.cfm: line 16 14 : clientmanagement=No 15 : sessionmanagement=Yes 16 : setclientcookies=Yes 17 : sessiontimeout=#CreateTimeSpan(0,0,20,0)# 18 : applicationtimeout=#CreateTimeSpan(2,0,0,0)# Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Ignoring duplicates in select
I just noticed the matching is being done on the ValNoComma but it should be on the sDisp On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote: Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP was more concerned with what was going on in the loop rats :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
That's because you're checking on the Seq number, not the Folio cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) Should be cfif not listFindNoCase(noDupList, sDisp) cfset noDupList = listAppend(noDupList,sDisp) -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: 21 May 2004 09:32 To: CF-Talk Subject: Re: Ignoring duplicates in select It's now displaying my list but its still duplicating. I think it has something to do with the extra lines of code that I stripped out before I posted this. Something is conflicting. I'm reading in an external file that looks like this: 001folio:2201 . . . 274.00 points free 002folio:2251 . . . 021.00 points free 003folio:2252 . . . 001.00 points free 004folio:2253 . . . 011.00 points free 005folio:2254 . . . 001.00 points free 006folio:2201 . . . 006.50 points free 007folio:2251 . . . 230.50 points free 008folio:2252 . . . 000.00 points free 009folio:2253 . . . 001.00 points free 010folio:2254 . . . 202.50 points free Here is ALL the code in the CFLOOP cfset noDupList = cfloop INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset sValNoComma = arPages[i] cfset sVal = Trim(ListFirst(arPages[i], )) cfset sDisp = Trim(ListLast(arPages[i], )) cfset sValNoComma = NumberFormat(sVal, 99) cfset sVal = NumberFormat(sVal) cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /cfloop This is the output I'm getting now: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 Seq: 6Folio:2201 Seq: 7Folio:2251 Seq: 8Folio:2252 Seq: 9Folio:2253 Seq: 10Folio:2254 I want it to about like this. Ignoring the duplicates: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote: Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP was more concerned with what was going on in the loop rats :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
Doh...yea...I got it to work. On Fri, 21 May 2004 09:54:37 -0400, Philip Arnold wrote: That's because you're checking on the Seq number, not the Folio cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) Should be cfif not listFindNoCase(noDupList, sDisp) cfset noDupList = listAppend(noDupList,sDisp) -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: 21 May 2004 09:32 To: CF-Talk Subject: Re: Ignoring duplicates in select It's now displaying my list but its still duplicating. I think it has something to do with the extra lines of code that I stripped out before I posted this. Something is conflicting. I'm reading in an external file that looks like this: 001folio:2201 . . . 274.00 points free 002folio:2251 . . . 021.00 points free 003folio:2252 . . . 001.00 points free 004folio:2253 . . . 011.00 points free 005folio:2254 . . . 001.00 points free 006folio:2201 . . . 006.50 points free 007folio:2251 . . . 230.50 points free 008folio:2252 . . . 000.00 points free 009folio:2253 . . . 001.00 points free 010folio:2254 . . . 202.50 points free Here is ALL the code in the CFLOOP cfset noDupList = cfloop INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset sValNoComma = arPages[i] cfset sVal = Trim(ListFirst(arPages[i], )) cfset sDisp = Trim(ListLast(arPages[i], )) cfset sValNoComma = NumberFormat(sVal, 99) cfset sVal = NumberFormat(sVal) cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /cfloop This is the output I'm getting now: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 Seq: 6Folio:2201 Seq: 7Folio:2251 Seq: 8Folio:2252 Seq: 9Folio:2253 Seq: 10Folio:2254 I want it to about like this. Ignoring the duplicates: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote: Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP was more concerned with what was going on in the loop rats :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What causes this sporadic error?
You generally get this error if you have the CFID and CFTOKEN in your URL querystring twice. This can happen if you have not set addtoken=no in a cflocation and you are manually adding the CFID and CFTOKEN to your url eg cflocation url="" - can cause this problem cflocation url="" addtoken=yes should work OK cflocation url="" addtoken=no - should work OK Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: excel files
How many people will be querying the excel file? Could you create an Excel DSN with a file of a given name, but copy the active file to the DSN file and name as it was being used? Somebody else may be able to jump in here, but I think there is a way to stop and restart a DSN programmatically, so perhaps you could stop the DSN, copy the file and then access the DSN... Maybe you've already been down this road? -Nate -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:20 AM To: CF-Talk Subject: excel files Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: excel files
I did the DSN thing, but I was not aware that you could restart a DSN programmatically. If that is possible, whew, it would save me some work for the time being at least! George At 10:00 AM 5/21/2004, you wrote: How many people will be querying the excel file? Could you create an Excel DSN with a file of a given name, but copy the active file to the DSN file and name as it was being used? Somebody else may be able to jump in here, but I think there is a way to stop and restart a DSN programmatically, so perhaps you could stop the DSN, copy the file and then access the DSN... Maybe you've already been down this road? -Nate -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:20 AM To: CF-Talk Subject: excel files Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in montreal (quebec) ?
- Montreal !!:) -Stace _ From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:53 AM To: CF-Talk Subject: CF in montreal (quebec) ? Hi there, does anyone of you knows if there is a big community of CF programmer in montreal... I always see on this list conference and stuff in the States and in Toronto for Canada.. Thanks Pat _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT - Last nights NYCFUG meeting.
Thanks, this is good to know.If you've tried BD yourself probably you would have an idea about the following questions: *) Could BD co-exist with CFMX and/or preCFMX on a same win OS box for dev? *) Does BD support both CFMX and preCFMX or only CFMX? Of course, I'll look into more detail about BD via its own web site as well.But these questions seems high level and it would be beneficial to know asap. TIA. Not to put a damper on anything in the new version of CF, but Blue Dragon does offer very good code protection.It seems as though the CFML templates can be precompiled and encrypted. The templates are no longer human readable.There is no way to return the COML. templates to there original COML. form.They also state that they run faster since they are pre-complied?? It seems to be key based and the key is specific to your application and if some tries to run your app on another installation of Blue Dragon, it will fail since it does not have the key. Seems like this is a pretty cool feature. Mario -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 12:37 PM To: CF-Talk Subject: Re: SOT - Last nights NYCFUG meeting. I missed it last night.Talking about BlackStone, anything about code protection? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
Oh no...another problem. If my imput file list looks likes this (arrows just indicate extra folios) 001folio:2201 . . . 274.00 points free 002folio:2251 . . . 021.00 points free 003folio:2252 . . . 001.00 points free 004folio:2253 . . . 011.00 points free 005folio:2254 . . . 001.00 points free 006folio:2201 . . . 006.50 points free 007folio:2202 . . . 006.50 points free -- 008folio:2203 . . . 006.50 points free -- 009folio:2251 . . . 230.50 points free 0010folio:2252 . . . 000.00 points free 011folio:2253 . . . 001.00 points free 010folio:2254 . . . 202.50 points free When I run it through the code I get this: 001folio:2201 . . . 006.50 points free 002folio:2251 . . . 230.50 points free 003folio:2252 . . . 000.00 points free 004folio:2253 . . . 001.00 points free 005folio:2254 . . . 202.50 points free 006folio:2202 . . . 006.50 points free -- 007folio:2203 . . . 006.50 points free -- How can I get it to output in the correct order? -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: 21 May 2004 09:32 To: CF-Talk Subject: Re: Ignoring duplicates in select It's now displaying my list but its still duplicating. I think it has something to do with the extra lines of code that I stripped out before I posted this. Something is conflicting. I'm reading in an external file that looks like this: 001folio:2201 . . . 274.00 points free 002folio:2251 . . . 021.00 points free 003folio:2252 . . . 001.00 points free 004folio:2253 . . . 011.00 points free 005folio:2254 . . . 001.00 points free 006folio:2201 . . . 006.50 points free 007folio:2251 . . . 230.50 points free 008folio:2252 . . . 000.00 points free 009folio:2253 . . . 001.00 points free 010folio:2254 . . . 202.50 points free Here is ALL the code in the CFLOOP cfset noDupList = cfloop INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset sValNoComma = arPages[i] cfset sVal = Trim(ListFirst(arPages[i], )) cfset sDisp = Trim(ListLast(arPages[i], )) cfset sValNoComma = NumberFormat(sVal, 99) cfset sVal = NumberFormat(sVal) cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /cfloop This is the output I'm getting now: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 Seq: 6Folio:2201 Seq: 7Folio:2251 Seq: 8Folio:2252 Seq: 9Folio:2253 Seq: 10Folio:2254 I want it to about like this. Ignoring the duplicates: Seq: 1Folio:2201 Seq: 2Folio:2251 Seq: 3Folio:2252 Seq: 4Folio:2253 Seq: 5Folio:2254 On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote: Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option /cfif /CFLOOP was more concerned with what was going on in the loop rats :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Executing an ASX file on ColdFusion Server?
Hello. I have an issue with getting an ASX file to properly execute on a CF server (MX) ... on the same machine using apache's web server the ASX file execute in the browser causing it to stream the media as expected. However, when running it throught the CF server it pulls up a blank page in the browser. Viewing source on the blank page you see all of the ASX code sitting there - but the browser seems to not want anything to do with it. Has anyone out there ran accross an issue like this - if so, have you found a solution? I can send example links if anyone wants to see it happening. Thanks, Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ignoring duplicates in select
From: Nathan R. Jessop How can I get it to output in the correct order? What does your data look like? Can you sort it with ArraySort()? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What causes this sporadic error?
But what I don't understand is why this is happening in normal a href tags, I'm not using or clicking a cflocation tag?? Thanks, Mark _ From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:00 AM To: CF-Talk Subject: RE: What causes this sporadic error? You generally get this error if you have the CFID and CFTOKEN in your URL querystring twice. This can happen if you have not set addtoken=no in a cflocation and you are manually adding the CFID and CFTOKEN to your url eg cflocation url="" - can cause this problem cflocation url="" addtoken=yes should work OK cflocation url="" addtoken=no - should work OK Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: excel files
So I did some quick looking around and here is something that could be helpful: http://www.macromedia.com/support/coldfusion/ts/documents/dynamic_dsn_cfmx.htm George At 10:00 AM 5/21/2004, you wrote: How many people will be querying the excel file? Could you create an Excel DSN with a file of a given name, but copy the active file to the DSN file and name as it was being used? Somebody else may be able to jump in here, but I think there is a way to stop and restart a DSN programmatically, so perhaps you could stop the DSN, copy the file and then access the DSN... Maybe you've already been down this road? -Nate -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:20 AM To: CF-Talk Subject: excel files Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with CFC web service Flash
I've got a web service that I use to authorize users against our DB2 Mainframe, and I recently changed it up to return an array of CFC datatypes instead of a structure. The WSDL generates fine... I can call the methods from the browser directly.But when Flash tries to access it, it simply says there was an error accessing the URL. There is nothing logged in any of the coldfusion logs that I can find.. all I can find is a 500 server error in the web server's access logs. this is making things difficult to debug =) Any suggestions? - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Executing an ASX file on ColdFusion Server?
I run CFMX 6.1 and Windows Media services without any problems, send some more information and I'll see what I can do to help. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Passing a webservice a file
My understanding of webservices are weak but is it possible to pass a webservice a file (as opposed to a string) and have it processed and returned? I am not concerned about how it is processed or returned but whether or not a webservice accepts binary files. Thanks in advance. DA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Passing a webservice a file
an xml file? sure. tw -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:33 AM To: CF-Talk Subject: Passing a webservice a file My understanding of webservices are weak but is it possible to pass a webservice a file (as opposed to a string) and have it processed and returned? I am not concerned about how it is processed or returned but whether or not a webservice accepts binary files. Thanks in advance. DA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What causes this sporadic error?
Sorry, I missed out an important point when I looked at your error The CFID and CFTOKEN that you give in your example are definately corrupt... The first place I look when I see errors like this is page and server enconding settings... Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: ColdFusion MX 6.1: IBM WebSphe re 5.1 support
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/was51_support.htm Intro: IBM WebSphere Application Server (WAS) 5.1 is generally supported with ColdFusion MX 6.1; however, there are certain configurations that are not. WAS 5.1 Base Edition is supported with ColdFusion MX 6.1. WAS 5.1 Network Deployment clusters are not supported with ColdFusion MX 6.1. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Active Directory
I'm not sure why you wouldn't be able to take off the OUs...but maybe there's something above the OUs you can use? My queries I'm playing with to use AD based authentication look like this ***first query to connect to ldap and query the username entered*** CFLDAP NAME=ServConnect SERVER=server PORT=389 ACTION=""> ATTRIBUTES=samaccountname START=CN=Users,DC=root,DC=domain,DC=com SCOPE=subtree FILTER=samaccountname=#user# USERNAME=[EMAIL PROTECTED] PASSWORD=password ***then a second query to connect as the user and test password*** CFLDAP NAME=AuthUser SERVER=server PORT=389 ACTION=""> ATTRIBUTES=samaccountname START=CN=Users,DC=root,DC=domain,DC=com SCOPE=subtree FILTER=samaccountname=#user# username=[EMAIL PROTECTED] password=#password# I don't know if the first query is really needed, but if the first query fails, you know its not a valid username and if the second fails you know its not a valid password I used this tool to see more into ldap and copied out some of the DN stuff it found to get my start string http://www.iit.edu/~gawojar/ldap/ -Original Message- From: Ray Hamann [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 8:17 AM To: CF-Talk Subject: Active Directory I need to use CFLDAP to match a form submitted username and password to Active Directory not knowing what OU's the user may be in. I have to use a special account to bind to AD with so the username and password attributes are already utilized. I can successfully pull back a users information using the code below, however, I must know the entire OU already, as there doesn't seem to be a wildcard search, AND, I can not filter on username and password. This works: cfldap name=authenticate server=myschoolsad.edu action="" attributes=cn,sn,givenName,mail start=OU=department,OU=group,DC=branch,DC=ad,DC=school,DC=edu filter=cn=JohnSmith sort=sn sortcontrol=nocase maxrows=100 username=bindAccountUsername password=bindAccountPassword However, I can not drop the OU references from the start or it fails and I can not add a filter like: ((cn=#attributes.username#)(Password=#attributes.password Is anyone doing this or can anyone offer a possible direction. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Don't mean to be picky
In the quest for the separation of business logic layer and presentation layer, went to fusebox.org site, interesting stuff, just for the heck of it, tried an invalid value for a parameter, fuse threw a cf error, it's sort of interesting that fuse threw its err msg, however, it also included CF server native error msg that revealed full template path, I would hope that wasn't intended. Agree 100% framework and methodology is extremely important, meantime, if there's a better/systematic approach to Data Validation in addition to what's already available(try/catch/throw etc.), that would improve application security alot well, imho. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: excel files
I don't know if anyone would be interested in this but I'm doing something right now using CF and Excel but I'm using XML and SOAP rather than DSNs (my questions in this list earlier were regarding this little effort of mine).I created a CFMX web service that would pass an XML string via SOAP to an Excel spreadsheet and the XML would be parsed by VBA to populate a worksheet. I figured the benefits to this method are: 1 - You can output the results to anything that's SOAP-enabled 2 - Access to the data using this WS can be restricted to only registered users of my associated portal 3 - I wanted to see if it could be done :) I'd be happy to share what I've got so far if anyone's interested. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with CFC web service Flash
Rick Root wrote: I've got a web service that I use to authorize users against our DB2 Mainframe, and I recently changed it up to return an array of CFC datatypes instead of a structure. The WSDL generates fine... I can call the methods from the browser directly.But when Flash tries to access it, it simply says there was an error accessing the URL. There is nothing logged in any of the coldfusion logs that I can find.. all I can find is a 500 server error in the web server's access logs. I invoked the web service using coldfusion and got the world's ugliest error. Dependent CFC(s) have been modified?seems to be a key issue... Anyone want to take a stab at this? - Rick Error,jrpp-202,05/21/04,10:54:16,ADSWEB,Could not perform web service invocation authByUsername because AxisFaultfaultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]]; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]]faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: AxisFaultfaultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.Inco... The specific sequence of files included or processed is: E:\Inetpub\wwwroot\components\authorization\authtest.cfm coldfusion.xml.rpc.ServiceProxy$ServiceInvocationException: Could not perform web service invocation authByUsername because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]]; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]] faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modifie... at coldfusion.xml.rpc.ServiceProxy.invokeImpl(ServiceProxy.java:219) at coldfusion.xml.rpc.ServiceProxy.invoke(ServiceProxy.java:132) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:372) at cfauthtest2ecfm225933356.runPage(E:\Inetpub\wwwroot\components\authorization\authtest.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: excel files
Definitely share. I am not well-versed in XML, SOAP or VBA, but for a long-term solution, I could be persuaded to get my butt in gear. George At 10:54 AM 5/21/2004, Joe Tseng wrote: I don't know if anyone would be interested in this but I'm doing something right now using CF and Excel but I'm using XML and SOAP rather than DSNs (my questions in this list earlier were regarding this little effort of mine).I created a CFMX web service that would pass an XML string via SOAP to an Excel spreadsheet and the XML would be parsed by VBA to populate a worksheet. I figured the benefits to this method are: 1 - You can output the results to anything that's SOAP-enabled 2 - Access to the data using this WS can be restricted to only registered users of my associated portal 3 - I wanted to see if it could be done :) I'd be happy to share what I've got so far if anyone's interested. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How does Amazon do that?
Assuming you have an orders table and an orderDetails table (containing orderID and productID of each item in the order) it would be simple.Query the orderDetails table for any order containing the product ID of the item that the customer is looking at.At the same time, pull the other items in those orders that are in the same category.You'd might also want to pull a count of the number of times that product was bought at the same time so you can rank them from most to least often bought. --Jeff Qasim Rasheed wrote: I guess they have some sort of Recommendation and Referralmechanism in place. It could be an attributes-based, item-to-item correlation and person-to-person correlation (Collaborative Filtering). Thanks Qasim -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 5:22 AM To: CF-Talk Subject: RE: How does Amazon do that? When you look around Amazon.com, and show an interest in something, there's always a part of the page that says people who bought this also bought that .. The solution I came up with uses two tables - the product table (guess what that is?) and a product_link table.The product_link allows me to store, well, links between products in an arbitrary way. The link table has a 3-way PK of product ID, associated product ID and product link type - the type is just a numeric field which represents the type of link between the products which in my case includes similar too, related too, cross sell with and also bought.The first three are set via the admin. The final field in the link table is a generic data field, which in the case of the also bought type is a count.In this way I can grab the most popular also bought products with a nice simple query by ordering by the data field. The also bought data is not generated on-the-fly - it could take wy too long to increment the appropriate counters for each product link when someone checks out, so instead it's done nightly (or whenever) on a schedule. That's just one solution though... Tim. -- --- CF_CodingContest mode=judging newentries=false Maze Solver - http://tech.badpen.com/cfcontest/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Passing a webservice a file
I am thinking more of a image or doc file. Is this possible or am I confusing the concept of web services? an xml file? sure. tw -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:33 AM To: CF-Talk Subject: Passing a webservice a file My understanding of webservices are weak but is it possible to pass a webservice a file (as opposed to a string) and have it processed and returned? I am not concerned about how it is processed or returned but whether or not a webservice accepts binary files. Thanks in advance. DA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Extracting an email address out of a text file
I have about 1800 text files that I exported from outlook that are all bounced emails. I need to extract the email addresses that were bounced back. Unfortunately not all mail servers bounce messages that look alike. I was thinking I could just read through each text file and find where the email address is but in a lot of the files there will be the email address of the person who the email was originally from, the email address of the server that bounced the email and the email address who it was originally sent to. The only time these files are consistent is when they were bounced by the same mail server software. I was thinking maybe I will loop through the ones that are in the same format, i.e. the email address that was bad looks like ([EMAIL PROTECTED]) and strip out everything but the email address. That's the only method I can come up with at the moment, has anyone done something similar or maybe have a better solution? I really don't want to manually go through each text file and copy and paste the email address. Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Active Directory
I'm not sure why you wouldn't be able to take off the OUs...but maybe there's something above the OUs you can use? My queries I'm playing with to use AD based authentication look like this ***first query to connect to ldap and query the username entered*** CFLDAP NAME=ServConnect SERVER=server PORT=389 ACTION=""> ATTRIBUTES=samaccountname START=CN=Users,DC=root,DC=domain,DC=com SCOPE=subtree FILTER=samaccountname=#user# USERNAME=[EMAIL PROTECTED] PASSWORD=password ***then a second query to connect as the user and test password*** CFLDAP NAME=AuthUser SERVER=server PORT=389 ACTION=""> ATTRIBUTES=samaccountname START=CN=Users,DC=root,DC=domain,DC=com SCOPE=subtree FILTER=samaccountname=#user# username=[EMAIL PROTECTED] password=#password# I don't know if the first query is really needed, but if the first query fails, you know its not a valid username and if the second fails you know its not a valid password I used this tool to see more into ldap and copied out some of the DN stuff it found to get my start string http://www.iit.edu/~gawojar/ldap/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Extracting an email address out of a text file
I really don't want to manually go through each text file and copy and paste the email For this I would try to use CF_REextract to extract the address in its context. The address is variable, but the context is not. See CF_REextract at http://www.contentbox.com/claude/customtags/tagstore.cfm -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Extracting an email address out of a text file
I can vouch for cf_reextract. I use it as a spider for a web cvs I wrote and it works wonderfully. Claude Schneegans wrote: I really don't want to manually go through each text file and copy and paste the email For this I would try to use CF_REextract to extract the address in its context. The address is variable, but the context is not. See CF_REextract at http://www.contentbox.com/claude/customtags/tagstore.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Don't mean to be picky
Yeah, IMHO FB 4/MVC is the ultimate in business logic/presentation later separation. I just finished my first FB4/MVC project, and I'm very happy with the way it turned out. A widely adapted methodology. Great support community. You're right, that error on fusebox.org is careless. Greg -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:54 AM To: CF-Talk Subject: Don't mean to be picky In the quest for the separation of business logic layer and presentation layer, went to fusebox.org site, interesting stuff, just for the heck of it, tried an invalid value for a parameter, fuse threw a cf error, it's sort of interesting that fuse threw its err msg, however, it also included CF server native error msg that revealed full template path, I would hope that wasn't intended. Agree 100% framework and methodology is extremely important, meantime, if there's a better/systematic approach to Data Validation in addition to what's already available(try/catch/throw etc.), that would improve application security alot well, imho. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Comma in price
I'm using dollarformat to convert prices. However, if I user inputs a large price with a comma, such as 1,200.00 it generates a cannot convert number error. To save time, what is the best way to allow a user to enter a comma and still be able to calculate the price against a quantity. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Don't mean to be picky
A widely adapted methodology. adapted = great typo/pun! Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
'Select' statement question!
The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.asstetID IN (select distinct Employee.callNo from Employee where Employee.asst_id IN (select Assets.asst_id from Assets where bar_code = ' + char(39) + @asset + char(39) + '))' Thanks in advance __ Do you Yahoo!? Yahoo! Domains Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Comma in price
Just remove any comma from the string first: CFSET price = replace(price, ,, , all) -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Comma in price
Robert Orlini wrote: I'm using dollarformat to convert prices. However, if I user inputs a large price with a comma, such as 1,200.00 it generates a cannot convert number error. To save time, what is the best way to allow a user to enter a comma and still be able to calculate the price against a quantity. How about: #Replace(inputVarALL)# Just remove the commas - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 'Select' statement question!
At 11:42 AM 5/21/2004, you wrote: The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.asstetID IN (select distinct Employee.callNo from Employee where Employee.asst_id IN (select Assets.asst_id from Assets where bar_code = ' + char(39) + @asset + char(39) + '))' Thanks in advance May not be able to nest sub-queries. You using MS SQL Server? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Extracting an email address out of a text file
Ben Densmore wrote: I have about 1800 text files that I exported from outlook that are all bounced emails. I need to extract the email addresses that were bounced back. Unfortunately not all mail servers bounce messages that look alike. I was thinking I could just read through each text file and find where the email address is but in a lot of the files there will be the email address of the person who the email was originally from, the email address of the server that bounced the email and the email address who it was originally sent to. The only time these files are consistent is when they were bounced by the same mail server software. I was thinking maybe I will loop through the ones that are in the same format, i.e. the email address that was bad looks like ([EMAIL PROTECTED]) and strip out everything but the email address. That is indeed the way to go. In some cases it is easy, for instance if you want to get all AOL bounces you can do a simple regex replace on your email: REReplaceNoCase(email,^.*- The following addresses had permanent fatal errors -(.+)- Transcript of session follows -.*$,\1) Simple patterns like these should find you most of the addresses, just look for 5xx (permanent) error codes next to an email address. But it is a case of diminishing returns and at some point it is easier to do the rest by hand. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 'Select' statement question!
Sorry, I made a typo mistake. This is the correct sql SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.callNo IN (select distinct Employee.callNo from Employee where Employee.asst_id IN (select Assets.asst_id from Assets where bar_code = ' + char(39) + @asset + char(39) + '))' I'll try and explain what I'm trying to do I have two tables. Employee and Assets The Employee Table has two columns: CallNo and Asst_id The Assets table contains all the asset information, the primary key being Asst_ID. I want to return distinct Employee records. The CallNo column in the employee table can more than one callNo with the same value. Ex: Employee Table: Asst_IDCallNo 10BRC 20BRC 30BRC0001 I want to only return distince employee records. Hope this is making sense The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.asstetID IN (select distinct Employee.callNo from Employee where Employee.asst_id IN (select Assets.asst_id from Assets where bar_code = ' + char(39) + @asset + char(39) + '))' Thanks in advance __ Do you Yahoo!? Yahoo! Domains Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 'Select' statement question!
yes I am using MS SQL Server [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
retreive the FORM name?
Hi, Any one knows if it is possible to retreive the form name from the template fired by a form? -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 'Select' statement question!
cf coder wrote: The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.asstetID IN (select distinct Employee.callNo from Employee where Employee.asst_id IN (select Assets.asst_id from Assets where bar_code = ' + char(39) + @asset + char(39) + '))' I don't think it is valid because the use of Employee in the predicate of the subquery is ambiguous. Further the DISTINCT is superfluous. Try something like: SELECT * FROM Employee E1 WHERE E1.asstetID IN ( SELECT E2.callNo FROM Employee E2 WHERE E2.asst_id IN ( SELECT Assets.asst_id FROM Assets WHERE bar_code =' + char(39) + @asset + char(39) + ' ) ) I have no idea about all the + and char() functions because that obviously is not standard SQL and you didn't tell which DBMS you are using. But I would flatten out the subqueries and rewrite the whole thing as: SELECT E1.* FROM Employee E1 INNER JOIN Employee E2 ON E1.AsstetID = E2.callNo INNER JOIN Assets A ON E2.asst_id = A.asst_id WHERE A.bar_code =' + char(39) + @asset + char(39) + ' Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: retreive the FORM name?
not via CF.you'd need to put it in a hidden form field. just out of curiousity...why would you need the form name? - Original Message - From: Claude Schneegans [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:56 AM Subject: retreive the FORM name? Hi, Any one knows if it is possible to retreive the form name from the template fired by a form? -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Comma in price
Thanks Rick and Claude. It worked. RO -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 11:44 AM To: CF-Talk Subject: Re: Comma in price Just remove any comma from the string first: CFSET price = replace(price, ,, , all) -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: retreive the FORM name?
Try this, just a thought. cfif isDefined('form.submit') cfdump var=#form# /cfif script function checkForm(theForm) { document.forms[theForm.name].theFormsName.value=theForm.name; return true; } /script form action="" method=post name=formName checkForm(this) input type=hidden name=theFormsName value= input type=submit name=submit value=submit /form Claude Schneegans wrote: Any one knows if it is possible to retreive the form name from the template fired by a form? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Extracting an email address out of a text file
There's also a tag on the DevEx, StripEmail - you pass it a string and it'll pull out email addresses and return them as a list. Works great for me. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: retreive the FORM name?
Claude, Since only one form can post per request it is presumed that you will know because of the form's linkage to the ACTION. If you are using one uber ACTION handler then create a hidden INPUT that contains the name of the form.This can lead to problems though and it not the better choice.If your uber ACTION handler is handling so much stuff that such a thing matters then you should consider breaking it out into multiple templates. rish -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:56 AM To: CF-Talk Subject: retreive the FORM name? Hi, Any one knows if it is possible to retreive the form name from the template fired by a form? -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Extracting an email address out of a text file
Thanks Claude, I bought the tag and it seems to work ok. I'm wondering if someone can help me with a reg ex. Just playing around with the tag I was trying: CF_REextract INPUTMODE=File INPUT=c:\cfusionmx\wwwroot\email_blast\#name# OUTPUTMODE=output RE1=([[:alnum:]_\.\-]+@([[:alnum:]_\.\-])) RE2=\.+[[:alpha:]]{2,4} Which I thought would extract email addresses but it doesn't seem to be working. Since I suck at them I'm sure I'm doing something wrong with it. Can anyone modify this reg ex a little for me? Thanks, Ben -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 11:19 AM To: CF-Talk Subject: Re: Extracting an email address out of a text file I really don't want to manually go through each text file and copy and paste the email For this I would try to use CF_REextract to extract the address in its context. The address is variable, but the context is not. See CF_REextract at http://www.contentbox.com/claude/customtags/tagstore.cfm -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with CFC web service Flash
Here is my WSDL: https://www.ads.duke.edu/components/authorization/authorize.cfc?WSDL and a sample HTTP invocation... https://www.ads.duke.edu/components/authorization/authorize.cfc?method=authByUsernameUNAME=fooPWORD=fooSPECIFICLOGINS=SPECIFICGROUPS=APPNAME=ENTITY_LOOKUP But it will NOT invoke via CFINVOKE or via Flash HELP! Rick Root wrote: Rick Root wrote: I've got a web service that I use to authorize users against our DB2 Mainframe, and I recently changed it up to return an array of CFC datatypes instead of a structure. The WSDL generates fine... I can call the methods from the browser directly.But when Flash tries to access it, it simply says there was an error accessing the URL. There is nothing logged in any of the coldfusion logs that I can find.. all I can find is a 500 server error in the web server's access logs. I invoked the web service using coldfusion and got the world's ugliest error. Dependent CFC(s) have been modified?seems to be a key issue... Anyone want to take a stab at this? - Rick Error,jrpp-202,05/21/04,10:54:16,ADSWEB,Could not perform web service invocation authByUsername because AxisFaultfaultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is:coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]]; nested exception is:coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]]faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: AxisFaultfaultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.Inco... The specific sequence of files included or processed is: E:\Inetpub\wwwroot\components\authorization\authtest.cfm coldfusion.xml.rpc.ServiceProxy$ServiceInvocationException: Could not perform web service invocation authByUsername because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]]; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modified. Please refresh your web service client.]] faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [org.apache.axis.AxisFault : ; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.IncompatibleClassChangeError : Dependent CFC type(s) have been modifie... at coldfusion.xml.rpc.ServiceProxy.invokeImpl(ServiceProxy.java:219) at coldfusion.xml.rpc.ServiceProxy.invoke(ServiceProxy.java:132) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:372) at cfauthtest2ecfm225933356.runPage(E:\Inetpub\wwwroot\components\authorization\authtest.cfm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at
Re: retreive the FORM name?
Since only one form can post per request it is presumed that you will know because of the form's Sure, but a template can contain several forms which all call the same template, even if only one is submitted. My question is then to detect the one that fired the template. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with CFC web service Flash
More info... this definately has something to do with my CFC datatypes.. Here's the code where I'm invoking the CFC datatypes: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 'Select' statement question!
Thanks Jochem, but your sql returns duplicate callNo's. I tried both your queries. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: retreive the FORM name?
Try this, just a thought. Ok, but it is precisely what I'm looking a simpler solution for. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Javacript Onclick Question
I would like to know if this is possible, I know very little about _javascript_, but if if someone could point me in the right direction I can do the research. Heres what Im trying to do. I have my main display page which calls a custom header. This custom header has an a href link that logs the user off when clicked. What I want to do now is to add a pop-up box that prompts the user to confirm that they are logging off. Heres the kicker, I cant modify the customer header, so how do I write _javascript_ from my main display page to add the pop-up box on the link in the custom header? Thanks for you help! Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Extracting an email address out of a text file
I bought the tag Congratulations: you're on the right track ! ;-) if someone can help me with a reg ex. Just playing around with the tag I was trying: Sure, try the REWizard, same author, same address, and this one is on line and free. Make sure you work with the CF syntax, not the _javascript_. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: retreive the FORM name?
What if you give the submit buttons unique names.That way you can check which form you are processing by the name of the submit button that was pressed. Jim Audette Website Administrator Garrison Forest School 300 Garrison Forest Road Owings Mills, MD 21117 [EMAIL PROTECTED] 410-559-3128 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javacript Onclick Question
You'll need to get a reference to the link object, and then you can add a custom onClick handler to the object.If the A tag has an id attribute, then it's simple, just use document.getElementById(id_of_anchor) to get the object.If it doesn't, then you'll have to us document.links (I don't know how portable that is), or do a parse of the node tree and identify the link from the mess, probably by checking the href or innerHTML property. Cheers, barneyb -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 9:33 AM To: CF-Talk Subject: SOT: Javacript Onclick Question I would like to know if this is possible, I know very little about _javascript_, but if if someone could point me in the right direction I can do the research. Heres what Im trying to do. I have my main display page which calls a custom header. This custom header has an a href link that logs the user off when clicked. What I want to do now is to add a pop-up box that prompts the user to confirm that they are logging off. Heres the kicker, I cant modify the customer header, so how do I write _javascript_ from my main display page to add the pop-up box on the link in the custom header? Thanks for you help! Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Selecting by row or CurrentRow
qProduct.field[theRowIWant] -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 mei 2004 13:11 To: CF-Talk Subject: Selecting by row or CurrentRow Could someone remind me of the syntax to select by row? I don't remember where to find that. Thanx Select * From qProduct Where CurrentRow = #theRowIWant# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]