What am I missing?
I am quering the database in the following and getting the average of feedback received. I pass the memberID to the function which I have verified to exist and I get nothing back. If I run the same query in the query analyzer I get a result of 2. Can anyone see a problem? select avg(rating) AS ratings from #APPLICATION.DBPRE#memberRatings where TAuthorID = Then my invocation Where I want to use it Doug B. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What am I missing???
This should not be hard to do... I've got a form with some checkboxes that are dynamically created from a query. I use cfoutput query = "get_unregistered" to build the form. The checkboxes are build like this: I would expect that to translate into rendered HTML as: But the values for the checkboxes are rendered as: shooter_1: 891011 shooter_2: 91011 shooter_3: 1011 shooter_4: 11 Why would the values be combining like that for the checkboxes? And what should I use to separate them? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311534 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfcontent - what am I missing?
I have searched the archives here, books, and forums at MM. My client says that the download I gave her works for maybe half of her customers. Others are getting .cfm files, or possibly something else that they can't use. That is just not acceptable, you know? Here's the relevant code: Am I missing an important clue, or is CF just the wrong thing to use for downloads? My client is selling downloadable products, so this is crucial. Thanks, Carol Chandler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Solved (What am I missing?)
Solved!!! Doug B. - Original Message - From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Saturday, January 13, 2007 6:53 AM Subject: What am I missing? > I am quering the database in the following and getting the average of feedback received. I pass the memberID to the function which I have verified to exist and I get nothing back. If I run the same query in the query analyzer I get a result of 2. Can anyone see a problem? > > > > > > > > > > select avg(rating) AS ratings > from #APPLICATION.DBPRE#memberRatings > where TAuthorID = > > > > > > Then my invocation > > method = "returnAverage" >memberID = "#Val(attributes.memberID)#" >returnvariable = "RatingAverage"> > > > Where I want to use it > > > > > Doug B. > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What am I missing?
Doug, Are you using InitAvgFeedback as a UDF or as part of a CFC? If it's used as a UDF, which looks like it based on what you've sent, all you need to do is use #InitAvgFeedback(memberID)#. No need for . Hth, Michael > -Original Message- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 13, 2007 5:53 AM > To: CF-Talk > Subject: What am I missing? > > returntype="string" hint="Output the average rating for all feedback per > member"> > > > > > password="#APPLICATION.PW#"> > select avg(rating) AS ratings > from #APPLICATION.DBPRE#memberRatings > where TAuthorID = value="#ARGUMENTS.MEMBERID#"> > > > > > > Then my invocation > > method = "returnAverage" >memberID = "#Val(attributes.memberID)#" >returnvariable = "RatingAverage"> > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What am I missing???
~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What am I missing???
Not quite following that. Can you paste the exact HTML being produced. Also, dump the query to make sure the shooter_id column contains what you think it does. Are you by chance doing any nested loops or cfoutputs? ~Brad - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, August 25, 2008 7:52 PM Subject: What am I missing??? > This should not be hard to do... > But the values for the checkboxes are rendered as: > > shooter_1: 891011 > shooter_2: 91011 > shooter_3: 1011 > shooter_4: 11 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What am I missing???
Matt's suggestion should work, but it really shouldn;t be necessary... do you have your cfoutput inside a cfloop or the other way around? what if you properly scope both recordcount and shooter_id with a query name? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What am I missing???
I thought I had tried that, but I had tried it with value="#shooter_id[currentRow]#". The 's around the value was causing the values to append because I was already using Nested 's... bad boy. But now I realize that I've got to figure out how to specify the names of the checkboxes which are checked for the insert query. The problem is with specifying which dynamic formfield has been checked. Perhaps I can run a cfloop on the "get_unregistered.recordcount" value and run a check to see if form.shooter_#index# is in the fieldnames... (or something like that...) insert into registrations ( shooter_id, tournament_id ) values ( , ) Problems with that? Suggestions? Rick > -Original Message- > From: Matt Quackenbush [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2008 8:57 PM > To: CF-Talk > Subject: Re: What am I missing??? > > value="#shooter_id[currentRow]#"> > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311541 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What am I missing???
why not name the checkboxes the same, which will result in a comma-delimited list. then you only have to check for one checkbox. INSERT INTO Registrations ( shooter_id , tournament_id ) VALUES ( , ) On Mon, Aug 25, 2008 at 6:37 PM, Rick Faircloth <[EMAIL PROTECTED]>wrote: > I thought I had tried that, but I had tried it with > value="#shooter_id[currentRow]#". > > The 's around the value was causing the > values to append because I was already using > Nested 's... bad boy. > > But now I realize that I've got to figure out how to specify > the names of the checkboxes which are checked for the insert query. > The problem is with specifying which dynamic formfield has been checked. > Perhaps I can run a cfloop on the "get_unregistered.recordcount" value > and run a check to see if form.shooter_#index# is in the fieldnames... > > > > (or something like that...) > > > > insert into registrations > ( shooter_id, tournament_id ) > values ( value="#form.shooter_#">, > value="#session.tournament_id#"> ) > > > > > > > > Problems with that? Suggestions? > > Rick > > > > > > > -Original Message- > > From: Matt Quackenbush [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 25, 2008 8:57 PM > > To: CF-Talk > > Subject: Re: What am I missing??? > > > > > value="#shooter_id[currentRow]#"> > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What am I missing???
accidentally hit 'send' :\ that should have read: form page: action page: INSERT INTO Registrations ( shooter_id , tournament_id ) VALUES ( , ) -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What am I missing???
The problem turned out to be nested cfoutput's... And the solution for the insert query for the dynamic checkboxes that I've got working is: (The page submits back to itself, hence the session variables...) insert into registrations ( shooter_id, tournament_id ) values ( , ) This is working, but suggestions for improvements are always welcome! Thanks! Rick > -Original Message- > From: Azadi Saryev [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2008 9:20 PM > To: CF-Talk > Subject: Re: What am I missing??? > > Matt's suggestion should work, but it really shouldn;t be necessary... > > do you have your cfoutput inside a cfloop or the other way around? > what if you properly scope both recordcount and shooter_id with a query > name? > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What am I missing???
I'll probably go back to your approach, Charlie. I was working on that...looping the list from the shooter formfield...but figured something was wrong because my values were being combined in the HTML output. I was certain that should work, but the problem I didn't notice at the time was the nested cfoutput's, so I thought I was just wrong about the formfields with the same name become a list automatically. Thanks, Charlie and everyone! :o) Rick > -Original Message- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2008 9:50 PM > To: CF-Talk > Subject: Re: What am I missing??? > > accidentally hit 'send' :\ > > that should have read: > > form page: > > > value="#get_unregistered.shooter_id#" /> > > > action page: > > > > >INSERT INTO Registrations ( > shooter_id > , tournament_id >) VALUES ( > /> > , cfsqltype="cf_sql_integer" /> >) > > > > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought > you looked a bit off." > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311547 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 - what am I missing?
Carol: A few things... 1) You don't need the tags around your and tags. Attribute values within CF tags always parse variables without the need for a tag. 2) In your tag, change the VALUE attribute from "attachment; #variables.attach#" to "attachment; filename=#variables.attach#". Note the addition of the "filename=" portion. And, you didn't say it in your email, but I'm assuming that the "variables.attach" variable contains the filename that you would like the user to see. HTH -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Carol Chandler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 11:45 AM To: CF-Talk Subject: cfcontent - what am I missing? I have searched the archives here, books, and forums at MM. My client says that the download I gave her works for maybe half of her customers. Others are getting .cfm files, or possibly something else that they can't use. That is just not acceptable, you know? Here's the relevant code: deletefile="no"> Am I missing an important clue, or is CF just the wrong thing to use for downloads? My client is selling downloadable products, so this is crucial. Thanks, Carol Chandler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent - what am I missing?
Any particular reason there are tags around those? It's possible that those tags are adding unecessary white space to the output, and confusing some browsers as to if they're getting a web page or a file. Has your client been able to ask her customers what browsers they're using, etc? Version numbers? OS's? Knowing that information would be exctremely helpful in figuring out what the problem is. HTH, Jordan Carol Chandler wrote: > I have searched the archives here, books, and forums at MM. My client > says that the download I gave her works for maybe half of her > customers. Others are getting .cfm files, or possibly something else > that they can't use. That is just not acceptable, you know? Here's > the relevant code: > > > > deletefile="no"> > > Am I missing an important clue, or is CF just the wrong thing to use > for downloads? My client is selling downloadable products, so this is > crucial. > > Thanks, > Carol Chandler -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent - what am I missing?
> I have searched the archives here, books, and forums at > MM. My client says that the download I gave her works for > maybe half of her customers. Others are getting .cfm > files, or possibly something else that they can't use. > That is just not acceptable, you know? Here's the > relevant code: > > VALUE="attachment; #variables.attach#"> > > FILE="#form.userfile#" deletefile="no"> > Am I missing an important clue, or is CF just the wrong > thing to use for downloads? My client is selling > downloadable products, so this is crucial. that's pretty much the way I've done it, but then not all browsers adhere to the standards... I'm pretty sure the cfheader is a standardized mechanism. Anyway... try adding ?/#filename# or &/#filename# to the end of the download url, that might trick those browsers which don't comply into seeing the end of the url as the name of the file. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent - what am I missing?
Okay, I added the "filename=" and took off the , and gave my client a list of questions for her customers. :) Thanks! >> I have searched the archives here, books, and forums at >> MM. My client says that the download I gave her works for >> maybe half of her customers. Others are getting .cfm >> files, or possibly something else that they can't use. >> That is just not acceptable, you know? Here's the >> relevant code: > >> >> VALUE="attachment; #variables.attach#"> >> >> FILE="#form.userfile#" deletefile="no"> > >> Am I missing an important clue, or is CF just the wrong >> thing to use for downloads? My client is selling >> downloadable products, so this is crucial. > >that's pretty much the way I've done it, but then not all browsers >adhere to the standards... I'm pretty sure the cfheader is a >standardized mechanism. Anyway... try adding ?/#filename# or >&/#filename# to the end of the download url, that might trick those >browsers which don't comply into seeing the end of the url as the name >of the file. > >s. isaac dealey 954.927.5117 > >new epoch : isn't it time for a change? > >add features without fixtures with >the onTap open source framework >http://www.sys-con.com/story/?storyid=44477&DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent - what am I missing?
Don't overlook the other responses btw -- I was in a hurry earlier. Definately remove the cfoutput tags, and the cfheader value should read attachment; filename=#filename# (you're missing the "filename=" portion) good luck! :) > Okay, I added the "filename=" and took off the , > and gave my client a list of questions for her customers. > :) Thanks! >>> I have searched the archives here, books, and forums at >>> MM. My client says that the download I gave her works >>> for >>> maybe half of her customers. Others are getting .cfm >>> files, or possibly something else that they can't use. >>> That is just not acceptable, you know? Here's the >>> relevant code: >> >>> >>> VALUE="attachment; #variables.attach#"> >>> >>> FILE="#form.userfile#" deletefile="no"> >> >>> Am I missing an important clue, or is CF just the wrong >>> thing to use for downloads? My client is selling >>> downloadable products, so this is crucial. >> >>that's pretty much the way I've done it, but then not all >>browsers >>adhere to the standards... I'm pretty sure the cfheader is >>a >>standardized mechanism. Anyway... try adding ?/#filename# >>or >>&/#filename# to the end of the download url, that might >>trick those >>browsers which don't comply into seeing the end of the url >>as the name >>of the file. >> >>s. isaac dealey 954.927.5117 >> >>new epoch : isn't it time for a change? >> >>add features without fixtures with >>the onTap open source framework >>http://www.sys-con.com/story/?storyid=44477&DE=1 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent - what am I missing?
On Thu, 08 Jul 2004 11:45:09 -0400, Carol Chandler <[EMAIL PROTECTED]> wrote: > I have searched the archives here, books, and forums at MM. My client says that > the download I gave her works for maybe half of her customers. Others are getting .cfm > files, or possibly something else that they can't use. I had an experience with a Perl script once, where IE6 wouldn't use the correct file name unless the content-length header was set. Might be something else to try -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
MD5 Hmac - What am I missing here?
For some odd reason I took it upon myself to write an HMAC generator in cfml/java on MX 6.1 (don't ask, I'm masochistic like that) - and so far I believe I've gotten to this point: keyString = "myKey"; dataString = "HelloWorld"; messageDigest = createObject("java","java.security.MessageDigest"); messageDigest = messageDigest.getInstance("MD5"); messageDigest.update(keyString.getBytes()); outputDigest = messageDigest.digest(dataString.getBytes("UTF-16LE")); Now, the var outputDigest gives me a byteArray, which I hit with the CF-Lib Bin2Hex UDF. my result is as such: b2aec7d67de6f0b74cd965a5aa87af58 Now when I compare this to the old CF_HMAC tag (which works peachy, its just that I think I could do the same in 6-12 lines as opposed to a massive custom tag) I get the digest of: 78BD9886C78FA6D8F0C70CD943883010 Clearly I'm a bit off here - anyone have any ideas? Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220160 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
What am I missing with this code? (Javascript)
Hi, guys... With all the chatter about Homesite and the reminiscing about the "good ole days" of programming, I thought I'd give you something more up-to-date to think about. This is part of a larger CF/jQuery application that I just can't figure how to get running properly. I'm sure it's how I'm handling variables, but I've rewritten this probably 100 times to get a variation that works. Why do I get this error: "slidePosition is not defined" line: "delay = setTimeout('nextSlide(slidePosition)', 12000); } When I run this jQuery/Javascript: $(document).ready(function() { var slidePosition = 0; playTrack(slidePosition); }); function playTrack(slidePosition) { $.sound.play('slideshow0' + (slidePosition + 1) + '.mp3', {timeout:12000}); if ( slidePosition < 6 ) { delay = setTimeout('nextSlide(slidePosition)', 12000); } }; function nextSlide(slidePosition) { slidePosition++; playTrack(slidePosition); }; Thanks for any feedback! Rick ~| 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:345209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MD5 Hmac - What am I missing here?
Try this: messageDigest = createObject("java","java.security.MessageDigest"); messageDigest = messageDigest.getInstance("MD5"); messageDigest.reset(); messageDigest.update(keyString.getBytes()); HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion and BlueDragon applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm iMS-Lite - the completely free mail server solution for applications and application servers http://www.coolfusion.com/iMSLite --- On Wednesday, October 05, 2005 4:27 PM, Short Fuse Media scribed: --- > > For some odd reason I took it upon myself to write an HMAC generator > in cfml/java on MX 6.1 (don't ask, I'm masochistic like that) - and > so far > I believe I've gotten to this point: > > > keyString = "myKey"; > dataString = "HelloWorld"; > > messageDigest = createObject("java","java.security.MessageDigest"); > messageDigest = messageDigest.getInstance("MD5"); > messageDigest.update(keyString.getBytes()); > > outputDigest = messageDigest.digest(dataString.getBytes("UTF-16LE")); > > > Now, the var outputDigest gives me a byteArray, which I hit with the > CF-Lib Bin2Hex UDF. > > my result is as such: > > b2aec7d67de6f0b74cd965a5aa87af58 > > Now when I compare this to the old CF_HMAC tag (which works peachy, > its > just that I think I could do the same in 6-12 lines as opposed to a > massive custom tag) I get the digest of: > > 78BD9886C78FA6D8F0C70CD943883010 > > Clearly I'm a bit off here - anyone have any ideas? > > Erik Yowell > Short Fuse Media, Inc. > [EMAIL PROTECTED] > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220166 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MD5 Hmac - What am I missing here?
Hmm, didn't seem to affect it... question, would even Bin2Hex be apropriate in this instance? Or would it be better to loop through the byte array itself and make the hex string per byte? Which leads me to my next question - how would one accomodate this byte to hex conversion in cf w/out the byte datatype? -Erik Howie Hamlin wrote: >Try this: > >messageDigest = createObject("java","java.security.MessageDigest"); >messageDigest = messageDigest.getInstance("MD5"); >messageDigest.reset(); >messageDigest.update(keyString.getBytes()); > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220169 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MD5 Hmac - What am I missing here?
Unless you must use java, CF6.1's hash() function does MD5. -Original Message- From: Short Fuse Media [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 2:54 PM To: CF-Talk Subject: Re: MD5 Hmac - What am I missing here? Hmm, didn't seem to affect it... question, would even Bin2Hex be apropriate in this instance? Or would it be better to loop through the byte array itself and make the hex string per byte? Which leads me to my next question - how would one accomodate this byte to hex conversion in cf w/out the byte datatype? -Erik Howie Hamlin wrote: >Try this: > >messageDigest = createObject("java","java.security.MessageDigest"); >messageDigest = messageDigest.getInstance("MD5"); >messageDigest.reset(); >messageDigest.update(keyString.getBytes()); > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MD5 Hmac - What am I missing here?
I need to create an MD5 HMAC Digest for authentication - alas, CF6.1 doesn't do this - it only creates a one way MD5 hash. Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] Figy, Kam wrote: >Unless you must use java, CF6.1's hash() function does MD5. > >-Original Message- >From: Short Fuse Media [mailto:[EMAIL PROTECTED] >Sent: Wednesday, October 05, 2005 2:54 PM >To: CF-Talk >Subject: Re: MD5 Hmac - What am I missing here? > >Hmm, didn't seem to affect it... question, would even Bin2Hex be >apropriate in this instance? Or would it be better to loop through the >byte array itself and make the hex string per byte? Which leads me to my > >next question - how would one accomodate this byte to hex conversion in >cf w/out the byte datatype? > >-Erik > >Howie Hamlin wrote: > > > >>Try this: >> >>messageDigest = createObject("java","java.security.MessageDigest"); >>messageDigest = messageDigest.getInstance("MD5"); >>messageDigest.reset(); >>messageDigest.update(keyString.getBytes()); >> >> >> >> > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Whitespace from seemingly nowhere, what am I missing?!
Using CF8 & CF7, when directly outputting the result of a function or method call, I see whitespace (it is actually some sort of special character) before the string. If I place the result in a variable and then output it, I don't see the whitespace... I'm assuming people must have come across this before, the following code demonstrates the problem: Example 1: =#Silly()#= Output: = billy= Example 2: =#foo#= Output: =billy= Anyone have any clues as to why this happens and what to do about it? Thanks in advance, Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 cfselect ajax features - what am I missing?
Hi, Have been away from CF for a long time. Retooling a site to use more modern features and I would like to use the CFSELECT bind features to link to select lists. I followed the example by Forta on the Adobe site, but it is just not working. have uploaded a page with the code here: http://www.sihrhockey.org/cfc_tester.cfm Any help appreciated. James ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What am I missing with this code? (Javascript)
You declared slidePosition as a local variable inside the ready() function, so it doesn't exist for the other functions. Try making it global, like this: var slidePosition = 0; $(document).ready(function() { playTrack(slidePosition); }); On 6/12/2011 2:52 PM, Rick Faircloth wrote: > > > $(document).ready(function() { > >var slidePosition = 0; >playTrack(slidePosition); > > }); > > ~| 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:345210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What am I missing with this code? (Javascript)
Thanks, Jason... that seemed to solve that problem. (Did I mention I hate JS variables :o) Now, for some reason I can't fathom, The code: slidePosition++; increments slidePosition from 1 to 2 on the first iteration, but after that it won't increment to 3 or beyond... simply repeats at 2. Why? Is the global variable becoming a local variable or something when being passed from function to function? var slidePosition = 1; $(document).ready(function() { playTrack(slidePosition); }); function playTrack(slidePosition) { alert('1: slidePosition = ' + slidePosition); $.sound.play('slideshow0' + slidePosition + '.mp3', {timeout:12000}); if ( slidePosition < 6 ) { delay = setTimeout('nextSlide(slidePosition)', 12000); } }; function nextSlide(slidePosition) { slidePosition++; alert('2: slidePostion = ' + slidePosition); playTrack(slidePosition); }; -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Sunday, June 12, 2011 3:06 PM To: cf-talk Subject: Re: What am I missing with this code? (Javascript) You declared slidePosition as a local variable inside the ready() function, so it doesn't exist for the other functions. Try making it global, like this: var slidePosition = 0; $(document).ready(function() { playTrack(slidePosition); }); ~| 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:345215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What am I missing with this code? (Javascript)
Not sure, but now that I look at it, you don't need to pass slidePosition around at all now that it's a global variable. Try this: var slidePosition = 1; $(document).ready(function() { playTrack(); }); function playTrack() { alert('1: slidePosition = ' + slidePosition); $.sound.play('slideshow0' + slidePosition + '.mp3', {timeout:12000}); if ( slidePosition< 6 ) { delay = setTimeout('nextSlide()', 12000); } }; function nextSlide() { slidePosition++; alert('2: slidePostion = ' + slidePosition); playTrack(); }; ~| 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:345219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What am I missing with this code? (Javascript)
Excellent! Thanks! -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Sunday, June 12, 2011 4:42 PM To: cf-talk Subject: Re: What am I missing with this code? (Javascript) Not sure, but now that I look at it, you don't need to pass slidePosition around at all now that it's a global variable. Try this: var slidePosition = 1; $(document).ready(function() { playTrack(); }); function playTrack() { alert('1: slidePosition = ' + slidePosition); $.sound.play('slideshow0' + slidePosition + '.mp3', {timeout:12000}); if ( slidePosition< 6 ) { delay = setTimeout('nextSlide()', 12000); } }; function nextSlide() { slidePosition++; alert('2: slidePostion = ' + slidePosition); playTrack(); }; ~| 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:345221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Syntax error (missing operator) What am I missing here???
This is a multi-part message in MIME format. --=_NextPart_000_0005_01BFAFA6.45CCE0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you can see the problem, a solution would be greatly appreciated! = I'm new at this. This is the error message: ODBC Error Code =3D 37000 (Syntax error or access violation)=20 [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing = operator) in query expression ''Laptop' SET ProductID=3D'123' SET = Product=3D'testt' SET UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET = DescShort=3D'df''.=20 The error occurred while processing an element with a general identifier = of (CFQUERY),=20 This is my code, with the variables passed from a form: UPDATE Products2=20 SET ProdType=3D'#ProdType#' SET ProductID=3D'#ProductID#' SET Product=3D'#Product#' SET UnitPrice=3D'#UnitPrice#' SET Manufacturer=3D'#Manufacturer#' SET DescShort=3D'#DescShort#' WHERE Code=3D#Code# Thanks a lot,=20 Britta --=_NextPart_000_0005_01BFAFA6.45CCE0F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you can see the problem, a solution = would be=20 greatly appreciated! I'm new at this. This is the error=20 message: ODBC Error Code =3D 37000 (Syntax error = or access=20 violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing = operator) in=20 query expression ''Laptop' SET ProductID=3D'123' SET Product=3D'testt' = SET=20 UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET DescShort=3D'df''.=20 The error occurred while processing an element with a general = identifier of=20 (CFQUERY), This is my code, with the variables passed from a form:UPDATE Products2 SET ProdType=3D'#ProdType#' SET=20 ProductID=3D'#ProductID#' SET = Product=3D'#Product#' SET=20 UnitPrice=3D'#UnitPrice#' SET = Manufacturer=3D'#Manufacturer#' SET=20 DescShort=3D'#DescShort#' WHERE = Code=3D#Code# Thanks a lot, Britta --=_NextPart_000_0005_01BFAFA6.45CCE0F0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Whitespace from seemingly nowhere, what am I missing?!
>>Do you have the component set to suppress whitespace? The problem is not about white space not suppressed. Some white space is actually *added*. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Whitespace from seemingly nowhere, what am I missing?!
Silly indeed! And it is as silly under CF6 Note that if you =#len(Silly())#= you get = 5=, thus the extra space is not actually returned by the function call, but is inherent to any function call inside However =#len("Silly")#= outputs =5= correctly. And if the function is defined in CFSCRIPT, no problem Definitely a bug, and it has been there for a long time. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Whitespace from seemingly nowhere, what am I missing?!
Do you have the component set to suppress whitespace? I am pretty sure you only need to do it at the component level but if it was set to true there you could control it on a per function basis as well Dan On Jan 5, 2008 5:11 PM, Dominic Watson <[EMAIL PROTECTED]> wrote: > Using CF8 & CF7, when directly outputting the result of a function or > method > call, I see whitespace (it is actually some sort of special character) > before the string. If I place the result in a variable and then output it, > I > don't see the whitespace... I'm assuming people must have come across this > before, the following code demonstrates the problem: > > Example 1: > > > > > > > =#Silly()#= > > Output: = billy= > > Example 2: > > > > > > > > > =#foo#= > > Output: =billy= > Anyone have any clues as to why this happens and what to do about it? > > Thanks in advance, Dominic > > -- > Blog it up: http://fusion.dominicwatson.co.uk > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Whitespace from seemingly nowhere, what am I missing?!
Yeh and this happens outside of components (for me at least). The code I posted was from a plain ol .cfm file. Try it and see :) Dominic On 05/01/2008, Dan Vega <[EMAIL PROTECTED]> wrote: > > Do you have the component set to suppress whitespace? > > > > > I am pretty sure you only need to do it at the component level but if it > was > set to true there you could control it on a per function basis as well > > Dan > > > On Jan 5, 2008 5:11 PM, Dominic Watson <[EMAIL PROTECTED]> > wrote: > > > Using CF8 & CF7, when directly outputting the result of a function or > > method > > call, I see whitespace (it is actually some sort of special character) > > before the string. If I place the result in a variable and then output > it, > > I > > don't see the whitespace... I'm assuming people must have come across > this > > before, the following code demonstrates the problem: > > > > Example 1: > > > > > > > > > > > > > > =#Silly()#= > > > > Output: = billy= > > > > Example 2: > > > > > > > > > > > > > > > > > > =#foo#= > > > > Output: =billy= > > Anyone have any clues as to why this happens and what to do about it? > > > > Thanks in advance, Dominic > > > > -- > > Blog it up: http://fusion.dominicwatson.co.uk > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Whitespace from seemingly nowhere, what am I missing?!
> > Silly indeed! > And it is as silly under CF6 Aha, not just my code then! I've noticed that it also happens when accessing a value in a query using array notation, i.e.: =#myQuery[col][row]#= Can't believe that's been around for so long and not fixed in CF8! I guess my only solution is to assign to a variable first - pain in the arse, but at least I know I have to do it. Thank you, Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Whitespace from seemingly nowhere, what am I missing?!
>>Can't believe that's been around for so long and not fixed in CF8! Must be in the same agenda as correcting the empty list element bug ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 cfselect ajax features - what am I missing?
for some reason - maybe to do with data type of underlying db column - the values of options in your letterList cfselect have trailing spaces. hence the arguments passed to your getTeamsByLetter() cfc method look like this: |{"letter":"M|| ||"}|, and thus 'M %' is what your query tries to match. add trim() around arguments.letter and that should solve the problem: select * from teams where team_name like '#trim(Arguments.letter)#%' order by team_name asc Azadi On 21/03/2010 20:15, James Milks wrote: > Hi, > Have been away from CF for a long time. Retooling a site to use more modern > features and I would like to use the CFSELECT bind features to link to select > lists. > > I followed the example by Forta on the Adobe site, but it is just not > working. have uploaded a page with the code here: > http://www.sihrhockey.org/cfc_tester.cfm > > Any help appreciated. > > James > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF8 cfselect ajax features - what am I missing?
First place I'd look is your query. Try spoofing it up outside the ajax scenario, send it some values and see what comes back. -Original Message- From: James Milks [mailto:jamesmi...@noncubicle.com] Sent: 21 March 2010 12:16 To: cf-talk Subject: CF8 cfselect ajax features - what am I missing? Hi, Have been away from CF for a long time. Retooling a site to use more modern features and I would like to use the CFSELECT bind features to link to select lists. I followed the example by Forta on the Adobe site, but it is just not working. have uploaded a page with the code here: http://www.sihrhockey.org/cfc_tester.cfm Any help appreciated. James ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfselect ajax features - what am I missing?
oh wow that was weird... all those | in my pasted firebug output... in any case, look at the generated html source of your page and you will see the options in first cfselect all have lots of trailing whitespace. Azadi On 21/03/2010 20:40, Azadi Saryev wrote: > for some reason - maybe to do with data type of underlying db column - > the values of options in your letterList cfselect have trailing spaces. > hence the arguments passed to your getTeamsByLetter() cfc method look > like this: |{"letter":"M|| ||"}|, and thus 'M %' is what your query > tries to match. > > add trim() around arguments.letter and that should solve the problem: > select * from teams where team_name like '#trim(Arguments.letter)#%' > order by team_name asc > > Azadi > > > On 21/03/2010 20:15, James Milks wrote: > >> Hi, >> Have been away from CF for a long time. Retooling a site to use more modern >> features and I would like to use the CFSELECT bind features to link to >> select lists. >> >> I followed the example by Forta on the Adobe site, but it is just not >> working. have uploaded a page with the code here: >> http://www.sihrhockey.org/cfc_tester.cfm >> >> Any help appreciated. >> >> James >> >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF8 cfselect ajax features - what am I missing?
Thank you - I was sure I tried trimming, but I guess not. James -Original Message- From: Azadi Saryev [mailto:azadi.sar...@gmail.com] Sent: March 21, 2010 8:41 AM To: cf-talk Subject: Re: CF8 cfselect ajax features - what am I missing? for some reason - maybe to do with data type of underlying db column - the values of options in your letterList cfselect have trailing spaces. hence the arguments passed to your getTeamsByLetter() cfc method look like this: |{"letter":"M|| ||"}|, and thus 'M %' is what your query tries to match. add trim() around arguments.letter and that should solve the problem: select * from teams where team_name like '#trim(Arguments.letter)#%' order by team_name asc Azadi On 21/03/2010 20:15, James Milks wrote: > Hi, > Have been away from CF for a long time. Retooling a site to use more modern features and I would like to use the CFSELECT bind features to link to select lists. > > I followed the example by Forta on the Adobe site, but it is just not > working. have uploaded a page with the code here: > http://www.sihrhockey.org/cfc_tester.cfm > > Any help appreciated. > > James > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfselect ajax features - what am I missing?
Well, I got the cfselect to work, but when I placed the code into a page displayed in a lightbox (facebox actually) it doesn't work. I suspect there is an Ajax call in the generated JS that is failing. Is this a question for cf-talk or the ajax list? James >Thank you - I was sure I tried trimming, but I guess not. > > >On 21/03/2010 20:15, James Milks wrote: >> Hi, >> Have been away from CF for a long time. Retooling a site to use more >modern features and I would like to use the CFSELECT bind features to link >to select lists. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfselect ajax features - what am I missing?
Firebug is essential for debugging this sort of thing. It will show you every ajax call and let you see if anything is failing. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 22 March 2010 05:31, James Milks wrote: > > Well, I got the cfselect to work, but when I placed the code into a page > displayed in a lightbox (facebox actually) it doesn't work. > > I suspect there is an Ajax call in the generated JS that is failing. Is > this a question for cf-talk or the ajax list? > > James > > >Thank you - I was sure I tried trimming, but I guess not. > > > > > > >On 21/03/2010 20:15, James Milks wrote: > >> Hi, > >> Have been away from CF for a long time. Retooling a site to use more > >modern features and I would like to use the CFSELECT bind features to link > >to select lists. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfselect ajax features - what am I missing?
Looks like you've made progress but the change is happening without any user notification. You need the fancy web 2.0 ajax icon. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Calling CFCs with wget or curl -- What am I missing?
I can successfully call a remote (ws) cfc method with curl or wget, but I am unable to pass parameter data to the cfc. What's the secret? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Syntax error (missing operator) What am I missing here???
UPDATE TableName SET ColumnName1 = value1, SET ColumnName2 = value2, . . . SET ColumnNamwn = valuen the value van be a variable: #variableName# any values for non-numneric columns must be enclosed in single quotes: '#NonNumericVariaqbleName#' a comma follows each SET clause except the last. Dick At 5:38 PM -0700 4/26/2000, Britta Wingenroth \(Design Department\) wrote: >This is a multi-part message in MIME format. > >--=_NextPart_000_0005_01BFAFA6.45CCE0F0 >Content-Type: text/plain; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > >If you can see the problem, a solution would be greatly appreciated! = >I'm new at this. This is the error message: > >ODBC Error Code =3D 37000 (Syntax error or access violation)=20 > >[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing = >operator) in query expression ''Laptop' SET ProductID=3D'123' SET = >Product=3D'testt' SET UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET = >DescShort=3D'df''.=20 > > > >The error occurred while processing an element with a general identifier = >of (CFQUERY),=20 > >This is my code, with the variables passed from a form: > > > >UPDATE Products2=20 > SET ProdType=3D'#ProdType#' > SET ProductID=3D'#ProductID#' > SET Product=3D'#Product#' > SET UnitPrice=3D'#UnitPrice#' > SET Manufacturer=3D'#Manufacturer#' > SET DescShort=3D'#DescShort#' > WHERE Code=3D#Code# > > >Thanks a lot,=20 > >Britta > > >--=_NextPart_000_0005_01BFAFA6.45CCE0F0 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > > >http-equiv=3DContent-Type> > > > > >If you can see the problem, a solution = >would be=20 >greatly appreciated! I'm new at this. This is the error=20 >message: > >ODBC Error Code =3D 37000 (Syntax error = >or access=20 >violation) > >[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing = >operator) in=20 >query expression ''Laptop' SET ProductID=3D'123' SET Product=3D'testt' = >SET=20 >UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET DescShort=3D'df''.=20 > > >The error occurred while processing an element with a general = >identifier of=20 >(CFQUERY), >This is my code, with the variables passed from a form: >dbtype=3D"ODBC"> >UPDATE Products2 SET ProdType=3D'#ProdType#' SET=20 >ProductID=3D'#ProductID#' SET = >Product=3D'#Product#' SET=20 >UnitPrice=3D'#UnitPrice#' SET = >Manufacturer=3D'#Manufacturer#' SET=20 >DescShort=3D'#DescShort#' WHERE = >Code=3D#Code# >Thanks a lot, >Britta > >--=_NextPart_000_0005_01BFAFA6.45CCE0F0-- > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal >k or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
calling CFC in with dynamic variable - what am I missing here?
Hi All, Despite all my attempts, I cannot for the life of me figure this one out. I have a CFC method (Display_Table in the application.MessagesCFC) that displays a table of error message (don't ask - employer!). Display_Tables takes two arguments - Function and Error_List. Function is a name of another method in MessagesCFC that Display_Table will call. application.MessageCFC.Display_Tables("Get_Phone_Messages", "1,2,3"); I want Display_Table to call whatever function I pass to it in arguments and I also want to pass the list of errors. I.e. Get_Phone_Messages("1,2,3") I want the function I pass to be dynamic - what I am I missing? arguments.Function(arguments.Error_List); Help...? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling CFCs with wget or curl -- What am I missing?
> I can successfully call a remote (ws) cfc method with curl or > wget, but I am unable to pass parameter data to the cfc. > > What's the secret? You should be able to pass parameters within the URL of the CFC request: http://yourserver/your.cfc?param=value For obvious reasons, this will only work with simple values. Honestly, I've never tried this approach, since my use of CFCs has been limited to more traditional components and SOAP web services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Calling CFCs with wget or curl -- What am I missing?
On Aug 9, 2004, at 9:09 AM, Dave Watts wrote: > > I can successfully call a remote (ws) cfc method with curl or > > wget, but I am unable to pass parameter data to the cfc. > > > > What's the secret? > > You should be able to pass parameters within the URL of the CFC > request: > > http://yourserver/your.cfc?param=value > That's just the point: http://localhost/cfusion/mycfmxapps/myWS.cfc? method=echoString&input=Hello works from a browser but, wget http://localhost/cfusion/mycfmxapps/myWS.cfc? method=echoString&input=Hello does not work from the command line: Here's the cfc: access="remote" > "hh:mm:ss:lll")/> TIA Dick > For obvious reasons, this will only work with simple values. > Honestly, I've > never tried this approach, since my use of CFCs has been limited to > more > traditional components and SOAP web services. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling CFCs with wget or curl -- What am I missing?
> That's just the point: > > http://localhost/cfusion/mycfmxapps/myWS.cfc? > method=echoString&input=Hello > > works from a browser > > but, > > wget > http://localhost/cfusion/mycfmxapps/myWS.cfc? > method=echoString&input=Hello > > does not work from the command line If it can be done from a browser, it can be done using wget. Perhaps your server is configured to require host headers, or something like that? When you say it doesn't work, what exactly happens? Are you unable to capture output? If you're running wget on Windows, you'd have to use the -O parameter to specify an output file, since "myWS.cfc?method=echoString&input=Hello" isn't a valid file name, I suspect, but you shouldn't have that problem on Unix systems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Calling CFCs with wget or curl -- What am I missing?
On Aug 9, 2004, at 10:28 AM, Dave Watts wrote: > > That's just the point: > > > > http://localhost/cfusion/mycfmxapps/myWS.cfc? > > method=echoString&input=Hello > > > > works from a browser > > > > but, > > > > wget > > http://localhost/cfusion/mycfmxapps/myWS.cfc? > > method=echoString&input=Hello > > > > does not work from the command line > > If it can be done from a browser, it can be done using wget. Perhaps > your > server is configured to require host headers, or something like that? > I'll have a look at httpd.conf and see if I can spot anything. > When you say it doesn't work, what exactly happens? Are you unable to > capture output? Thanks Dave -- in trying to document the response I was getting, I figured out the problem. 1) the CLI was recognizing the & in the URL instead of passing them -- enclosing the URL in quotes, resolves this 2) -O filename is required in wget (not needed in curl) so: Richard:/ richard$ wget -O myfile 'http://localhost/cfusion/mycfmxapps/myWS.cfc? method=echoString&input=Hello' --11:32:49-- http://localhost/cfusion/mycfmxapps/myWS.cfc? method=echoString&input=Hello => `myfile' Resolving localhost... 127.0.0.1 Connecting to localhost[127.0.0.1]:80... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] [ <=> ] 100 --.--K/s 11:32:49 (976.56 KB/s) - `myfile' saved [100] Richard:/ richard$ cat myfile Hello 11:32:49:893Richard:/ richard$ Richard:/ richard$ Dick > If you're running wget on Windows, you'd have to use the -O > parameter to specify an output file, since > "myWS.cfc?method=echoString&input=Hello" isn't a valid file name, I > suspect, > but you shouldn't have that problem on Unix systems. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
This will do the trick: On Sat, 17 Jul 2004 17:56:01 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > Hi All, > > Despite all my attempts, I cannot for the life of me figure this one out. > > I have a CFC method (Display_Table in the application.MessagesCFC) that displays a table of error message (don't ask - employer!). Display_Tables takes two arguments - Function and Error_List. Function is a name of another method in MessagesCFC that Display_Table will call. > > > application.MessageCFC.Display_Tables("Get_Phone_Messages", "1,2,3"); > > > I want Display_Table to call whatever function I pass to it in arguments and I also want to pass the list of errors. I.e. Get_Phone_Messages("1,2,3") > > I want the function I pass to be dynamic - what I am I missing? > > arguments.Function(arguments.Error_List); > > Help...? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Thanks Paul - I thought of that - should of mentioned that. Anyway of passing in the variables by position? callmefunction(1, 3, 4) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Why? You need to explain a little more then. On Sat, 17 Jul 2004 18:50:17 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > Thanks Paul - > > I thought of that - should of mentioned that. > > Anyway of passing in the variables by position? > > callmefunction(1, 3, 4) > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
I was wanting to do it in cfscript as well - however I cannot figure that one out. The reason why I wanted to do it by position, is that the methods I'm passing to all of one cfargument but each argument name is different. I guess I could go back and ask for them to be changed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Can you show an example of this? I don't think I'm following. On Sat, 17 Jul 2004 19:24:48 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > I was wanting to do it in cfscript as well - however I cannot figure that one out. > > The reason why I wanted to do it by position, is that the methods I'm passing to all of one cfargument but each argument name is different. > > I guess I could go back and ask for them to be changed. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Paul, application.FooCFC.fooFunction("Peter", "Pizza"); I passed the arguments to the function by position. I don't have to state an explicit argument name - only the position. If I did: application.FooCFC.fooFunction( "Pizza","Peter"); My first name would be "Pizza" and my fav. food would be "Peter". Does this make sense? The reason why I only want to pass by position is that each method I could possibly be passing to has a different argument name for the argument in position one. I'd either have to change that all or pass my argument by position instead of: application.FooCFC.fooFunction(Fav_Food="Pizza",First_Name="Peter"); I don't know if there is a way I could make the method I want a variable and still pass it by position. Otherwise I'll get out of cfscript and use cfinvoke and change all the first position argument to the same name. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Ok, Get_Phone_Messages() takes a single argument. Are there other dynamically called methods that take multiple arguments? On Sat, 17 Jul 2004 17:56:01 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > Hi All, > > Despite all my attempts, I cannot for the life of me figure this one out. > > I have a CFC method (Display_Table in the application.MessagesCFC) that displays a table of error message (don't ask - employer!). Display_Tables takes two arguments - Function and Error_List. Function is a name of another method in MessagesCFC that Display_Table will call. > > > application.MessageCFC.Display_Tables("Get_Phone_Messages", "1,2,3"); > > > I want Display_Table to call whatever function I pass to it in arguments and I also want to pass the list of errors. I.e. Get_Phone_Messages("1,2,3") > > I want the function I pass to be dynamic - what I am I missing? > > arguments.Function(arguments.Error_List); > > Help...? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
No, not from the Display_table method. -pjf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Ok, I'm taking this step by step, So bear with me... Display_Tables() is a public method that has two arguments: method and values. "method" is a string, "values" is a string. Display_Tables() then calls the method specified by the "method" argument and passes the string specified in "values" as its only argument, In this case, the method called is Get_Phone_Messages(). It has one argument, which I will call "messageIDs". It is a string. Does Get_Phone_Messages() call any other methods? On Sun, 18 Jul 2004 00:06:50 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > No, not from the Display_table method. > -pjf > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
No, Get_Phone_Messages() does not call any other method/functions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Ok, so what other methods does Display_Tables() call? On Sun, 18 Jul 2004 12:00:54 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > No, Get_Phone_Messages() does not call any other method/functions. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
well, no other methods [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Also, I found my question about calling methods via dynamic variable names. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/buildi20.htm I never saw this in livedocs. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
So, the only method that Display_Tables() calls is "Get_Phone_Messages". What methods do you have then that are dynamically called with positional arguments? On Sun, 18 Jul 2004 18:32:15 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > well, no other methods > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: calling CFC in with dynamic variable - what am I missing here?
Oh, and who calls them? On Sun, 18 Jul 2004 18:32:15 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > well, no other methods > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]