Can you bind to a subquery result?
Ok, I could use some help on this as I can't seem to make it work and cannot find any topics on this either. I have a cfquery that I am using to populate a cfgrid. I also have 3 cfinputs that I am using to bind and filter that cfgrid. The problem is, that 2 of the fields I am trying to filter through are gotten using a subquery to return names. But when I try to filter via text, it pulls no values, and when I type in the numeric id value instead it is filtering. So is there any way to bind results based on the subquery result? Thanks in advance ~| 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:345111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Weird problem with CFPDF addheader/image
Ok, so I am hoping someone out there has some kind of insight on this issue as I cannot find anything on this. We are having an issue with CF9 with images not printing. We do a ton of pdf generation each day, and right now have a clients code updated to cf9. Its very simple code, and below is what is used: cfpdf action=addheader source=#ID# destination=#path#/#doc_id#.pdf pages=1 overwrite=yes image=images/thelogo.jpg align=right topmargin=1.25 The problem is that it is in fact inserting the header image into the pdf file, but when you randomly print some of these pdfs the image will not print. This doesn't happen to ever one, but maybe 50%. I cannot find any rhyme or reason to this, nor can I find anything over the internetz. If anyone has seen this issue or has any insight, it would be GREATLY appreciate! Thanks, Ryan ~| 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:338767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problems with SpreadSheetFormat Columns??
Hi all, I could use a little help with this one as I can't seem to find a solution for this anywhere, and I have definitely been wasting too much of my time on something so small! Anyways, I am wondering if there are any known issues with the SpreadsheetFormatColumns function in regards to formatting datetime fields from sql? I have searched and searched, and tried every variation I could think of with the following code, but cannot get it to format the dates. I would definitely appreciate any feedback on this one, or if anyone knows of any issues with this. Here is one of my code versions: cfset sObj=SpreadsheetNew() cfset SpreadsheetAddRow(sObj, Client,Leave Owner,Leave Number,Request Date,Leave Reason,Elig Confirmed Date,Packet Mailed Date) cfset SpreadsheetAddRows(sObj, drilldowns)cfset SpreadsheetFormatColumns(sObj, {dataformat=mm/dd/}, 4,6-7)cfset SpreadsheetFormatRow(sObj, {bold=TRUE, alignment=center}, 1) cfspreadsheet action=write name=sObj filename=filename#dateformat(now(), 'mmdd')#.xls overwrite=true I could very easily write this differently, or convert the fields in sql, but since I started this to try out some of the CFSpreadsheet stuff, I wanted to see if there was a solution while still using it this way. Th ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Having problems with cffeed and rsslink/linking
Hi, I am new to all this RSS stuff, and have been looking at the new cffeed tag in creating rss feeds for my company's website. I am currently testing all this on my local machine using the developer edition. I seem to be able to create the feed just fine using the query method but my problem is that I cannot get the feeds to link back to the website. It seems to be leaving off the page name, and script info. I have searched high and low, and have not been able to find any solutions to this problem. I would really appreciate if anyone had any ideas for me! I have attached my code. As you can see using the meta.link, and then the rsslink from the query, the link should be going to: http://www.spirent.com/news/news.cfm?id=#id#, however it is going to: http://www.spirent.com/news/#id# Also, since I am doing this locally I have just been using the firefox rss ticker, and built in reader to test. I have also noticed, then using firefox built in reader it doesnt link the items at all?? Attach Code cfset columnMapStruct = StructNew() cfset columnMapStruct.publisheddate = DDATE cfset columnMapStruct.content = VLONGDESC cfset columnMapStruct.title = VHEADLINE cfset columnMapStruct.rsslink = ID !--- Set the feed metadata. --- cfset meta.title = Spirent Press Releases cfset meta.link = http://www.spirent.com/news/news.cfm?id=; cfset meta.description = Recent Company News cfset meta.version = rss_2.0 !--- Create the feed. --- cffeed action=create query=#getpress# properties=#meta# columnMap=#columnMapStruct# outputfile=spirss.xml overwrite=true xmlvar=rssXML Thanks in advance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Having problems with cffeed and rsslink/linking
If you want to reply to me with any responses, please reply to [EMAIL PROTECTED], and not the email that the list is showing. [EMAIL PROTECTED] is not a valid address at this time. Sorry, and 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:296384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Having problems with cffeed and rsslink/linking
Thanks Mr. C, I actually did read the docs on cffeed, and I did not see anywhere there that the rsslink, had to be matched to a full url. As a matter of fact, their example (granted , a very simple one) used the ID field as well for the rsslink column. I also checked your blog as well, and did not find anything that addressed this particular issue. Guess I probably missed it or browsed over by mistake. So, in the end if I do not have a column in the database that contains the full url, then I cannot use the query method to create a rss feed? Thanks for the help. :) You are a bit off. The RSSLINK column in your query should be a full url, not a partial URL. So you need to modify your query so that you have a column with the full link, and then pass it to CFFEED. Don't feel too bad - it's not like you could have the CFFEED chapter in the Developer's Guide. ;) You should search my blog too - I've written about a number of CFFEED issues folks should be aware of. On Jan 10, 2008 3:19 PM, Ryan Bentley [EMAIL PROTECTED] wrote: ~| 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:296387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4