Modal Color of CFWindow
I am trying to figure out how to change the color of the background when you open a new cfwindow in modal mode. I want to make it darker so you cannot see the stuff behind it as well. How can I do that? Any help would be great. ~| 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:343874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Javascript not working inside of cflayoutarea
Got it now. Thanks guys for all of the help.
I really appreciate it.
-Steve
1) in your main page change this:
$(document).ready(function() {
$(#accordion).accordion();
});
to this:
doAccordion = function() { $(#accordion).accordion(); });
2) make html code in your test.cfm standards-compliant (add doctype,
html, head, body, etc tags) and then add this as the last line before
the closing /body tag:
cfset ajaxonload('doAccordion')
Azadi
On 13/04/2011 11:09 , Steve Sequenzia wrote:
~|
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:343696
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion.Window.Create with variable from cfselect
I am trying to use the code below to open a new window but I need the value of
the select passed to the window. Is this possible to do like this?
cfselect name=itemID bind=cfc:_root.data.items.getItems({itemGroupID})
display=itemDescription bindonload=yes value=itemID selected=0
queryPosition=below onchange=ColdFusion.Window.create('ItemDetails', 'Item
Details',
'/modules/pos/sales/new/new_sale_items_details.cfm?itemID={itemID}')/cfselect
~|
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:343711
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Javascript not working inside of cflayoutarea
Thanks guys. Any idea how to make this jquery work in cflayout?
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titleMAMBA - Martial Arts Management Business Automation/title
link href=style.css rel=stylesheet type=text/css /
link
href=http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css;
rel=stylesheet type=text/css/
script
src=http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js;/script
script
src=http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js;/script
script
$(document).ready(function() {
$(#accordion).accordion();
});
/script
/head
body
cfajaximport tags=cflayout-accordion, cfdiv, cfpod, cfinput-autosuggest,
cfwindow, cfform, cfgrid, cflayout-border, cftree, cfinput-datefield
cflayout type=border fittowindow=yes
cflayoutarea name=top position=top style=background:##414144;
height:90px; source=top.cfm/cflayoutarea
cflayoutarea name=left position=left style=width:200px;
splitter=false collapsible=false source=test.cfm/cflayoutarea
cflayoutarea name=main position=center style=background:##E8E8E8;
height:100%; source=main.cfm/cflayoutarea
/cflayout
/body
/html
Test.cfm
div id=accordion
h3a href=#Section 1/a/h3
div
p
/p
/div
h3a href=#Section 2/a/h3
div
p
/p
/div
h3a href=#Section 3/a/h3
div
p
/p
ul
liList item one/li
liList item two/li
liList item three/li
/ul
/div
/div
Steve
cfajaximport scriptsrc=... is only for cf's built-in scripts - you
do not use it to load anything else. and you only need to use it if you
do not have access to default cf's scripts folder or if you have moved
the default cf scripts to another folder.
to load jquery or any other js scripts, you just use your regular
script tags in the head section of your page.
specifically for dealing with scripts in pages loaded into cf's ajax
containers i found this approach working best:
- include your js library (jquery) in the main page (the one that has
cflayout tags in you case)
- include any js code that needs to run after pages have been loaded
into ajax containers as separate js functions in the main page's head
section as well.
- in the pages loaded inside ajax containers add cfset
ajaxonload('name-of-your-js-function-to-execute-here') as the last line
before the closing /body tag: this will run the specified js function
after the page has been loaded inside the container
Azadi
On 11/04/2011 22:31 , Steve Sequenzia wrote:
~|
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:343690
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Javascript not working inside of cflayoutarea
Andrew,
Thanks for the response.
I fixed the functions to this format - funcName = function() {};. All of the
scripts are in separate files. Do I need to use cfajaximport scriptSrc or can I
just put the scripts into the CFIDE/scripts folder? I am confused how all that
works.
Thanks again.
-Steve
How is you JavaScript written?
Is it like this
Function funcName() {
}
Or is it written like
funcName = function() {};
This is important, and as per the nodes in the documentation there are
issues with JS not working, if you are not following the latter method. If
however you are doing this, can you confirm with me that it is loaded in the
page, or is it included as a separate file in the loading page.
By going to FireFox and using firebug you can confirm that the pages are
loading, after that you can either debug the script and see if it is being
run or not.
Regards,
Andrew Scott
http://www.andyscott.id.au/
I have a index page that has a cflayout and a cflayoutarea with a source
to
another cfm page. The cfm page that the cflayoutarea uses as the source
has
a jquery menu in it. When it loads all of the javascript that powers the
jquery
menu is not loading.
I made sure that the javascript source files were being loaded on the
index
page. I have also been trying to get them to load with cfajaximport
scriptSrc
~|
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:343642
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Javascript not working inside of cflayoutarea
Andrew,
I understand what you are saying. I would rather import the files. I just can't
seem to get the syntax right. I am trying this - cfajaximport
scriptsrc=\CFIDE\scripts\jquery\
When I do that all the other ajax stuff on the page does not load. Do I need to
redirect all the files?
Thanks again.
-Steve
From my experience it is always that people forget that these new UI
features, all created div and other elements in the current page to do what
they need.
Ok having said that, I am betting my bottom dollar that with what you are
returning to be displayed, doesn't contain any htmlbody etc html tags.
This is important because the ColdFusion underneath the hood, needs these
tags to include the extra files etc that they need. And because the main
page is already loaded, ColdFusion can't add them to the current page, from
the page that is being loaded.
I hope that makes sense, there are two options you can try here and option 2
is my preferred method.
Option 1: return the html tags htmlbody etc, this would ensure that the
import the tag on the page, ColdFusion while generating the page can place
the needed code in the header of the page. Downside to this is that you end
up with a malformed dom, and will fail validators.
Option 2: Just place the import on the main page, this might seem overkill
if you are only going to use it once or twice. But the upside is that you
are generating valid html.
Regards,
Andrew Scott
http://www.andyscott.id.au/
Andrew,
Thanks for the response.
I fixed the functions to this format - funcName = function() {};. All of
the
scripts are in separate files. Do I need to use cfajaximport scriptSrc or
can I
just put the scripts into the CFIDE/scripts folder? I am confused how all
that
works.
Thanks again.
-Steve
~|
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:343645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript not working inside of cflayoutarea
I have a index page that has a cflayout and a cflayoutarea with a source to another cfm page. The cfm page that the cflayoutarea uses as the source has a jquery menu in it. When it loads all of the javascript that powers the jquery menu is not loading. I made sure that the javascript source files were being loaded on the index page. I have also been trying to get them to load with cfajaximport scriptSrc but that is not working. Here is some code: cflayout type=hbox cflayoutarea name=nav source=nav_pos.cfm /cflayoutarea /cflayout The nav_pos.cfm has the jquery on it that is not working. Any help on this would be great. Thanks! ~| 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:343640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Date format in HTML cfgrid
I am trying to format dates in an HTML cfgrid. I cannot seem to make it work in CF when using HTML as the grid type. I have also tried doing it in MSSQL by using - CONVERT(VARCHAR(10), startDate, 101) AS startDate. When I do that it shows up right in the grid but the grid will not sort on the date properly. Anyone know of a way to make it show up in the grid in a mm/dd/ format and also sort on the date properly? Any help would be great. 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:341824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Calculate next Tuesday 3 weeks from date
Got it. Thanks Andrew. Use the DayOfWeek(now) to get the day number, find out the difference to Tuesday and to a dateAdd for day to either go back in time. Then use the DateAdd of 3 weeks to get your result. Regards, Andrew Scott http://www.andyscott.id.au/ I need a little help with a ColdFusion function. I need to calculate the date of the next Tuesday 3 weeks from the current date. I am assuming that I need to use the dateadd but I am not really sure how to ~| 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:336836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ajax file upload.
I am trying to make this http://www.webtoolkit.info/ajax-file-upload.html work in ColdFusion. I can get it to work as long as I don't make the form a cfform. I need to make it work with a cfform though. When I change the form to cfform it just submits to the action page I created but it loses the ajax functionality. Any one know how to make it work with cfform? Thanks ~| 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:336837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ajax file upload.
No, I have action=formRes.cfm. Then on the formRes.cfm it does a file upload. Again, it works with a html form but not with a cfform. should I have the action be a .cfc file? Thanks for the help. You have it like this? CFFORM NAME=foo ACTION=bar.cfc METHOD=POST enctype=multipart/form-data ~| 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:336840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ajax file upload.
I am trying to make this http://www.webtoolkit.info/ajax-file-upload. html work in ColdFusion. I can get it to work as long as I don't make the form a cfform. I need to make it work with a cfform though. When I change the form to cfform it just submits to the action page I created but it loses the ajax functionality. Any one know how to make it work with cfform? Thanks Yes, enctype=multipart/form-data is in the cfform ~| 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:336844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Calculate next Tuesday 3 weeks from date
I need a little help with a ColdFusion function. I need to calculate the date of the next Tuesday 3 weeks from the current date. I am assuming that I need to use the dateadd but I am not really sure how to figure out the day thing. Any help with this would be great. -Steve ~| 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:336799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFWindow not working in CF9
For some reason I cannot use CFWindow. When I do just a basic cfwindow width=500 height=500 initshow=true/cfwindow it does not work. I get the following error in firebug: Ext.Window is not a constructor anonymous(cf_window1267811011254, Object name=url, Object modal=false closable=true)cfwindow.js (line 140) anonymous(cf_window1267811011254, Object name=_121, Object name=url, Object modal=false closable=true)cfwindow.js (line 51) anonymous()test.cfm (line 27) anonymous()cfajax.js (line 1101) anonymous(load )cfajax.js (line 1205) [Break on this error] _13e=new Ext.Window(_13d);\ncfwindow.js (line 140) I've tested other ajax functions like cfpod and it works fine. Anyone have any idea what the problem could be? Thanks in advance for any help ~| 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:331378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Passing variable to page with javascript:ColdFusion.Window.show
I am trying to open a cfwindow using a
href=javascript:ColdFusion.Window.show('window')/a but in need to pass a
variable to the page that it opens. I have tried a few ways of doing it but I
cannot get it to work.
Any help on this would be great.
Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320155
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Passing variable to page with javascript:ColdFusion.Window.show
I am trying to open a cfwindow using a
href=javascript:ColdFusion.Window.show('window')/a but in need to pass a
variable to the page that it opens. I have tried a few ways of doing it but I
cannot get it to work.
Any help on this would be great.
Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320156
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Create PDF from hyperlink
Gerald - Thanks for this info. I works but I am having another issue with it. For some reason any div tags that are floated left in the savecontent are not showing up when the pdf is created. All of the data in the div tag is just not there. Any idea or anyone else have any ideas. Any help would be great. Thanks. Put this on the page you are working on. Put the content that you want in the pdf in the cfsavecontent block. cfoutput a href=#Script_Name#?action=gimmie/a /cfoutput cfsavecontent variable=MyContent Your content goes here /cfsavecontent cfoutput #MyContent# /cfoutput cfif URL.Action EQ gimmie cfdocument format = PDF overwrite = yes encryption = none fontembed = yes backgroundvisible = no margintop =0.20 marginleft=0.20 marginright=0.20 #MyContent# /cfdocument /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Create PDF from hyperlink
I am looking for some help getting on creating a pdf from a hyperlink. I need to it to use content on the same page for the pdf. I do not want the entire page created as a pdf just a section of the page. Can someone please point me in the right direction for this. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WSE 3.0 Coldfusion
I am trying to use ColdFusion to consume a web service and I am having issuses. I really don't know much about web services so please bear with me. Here is what I have been trying to do: cfsavecontent variable=soap ?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body ZNAIsClaimValid xmlns=http://claimsws.zurichna.com/ERCClaims; ClaimNumber9110011636/ClaimNumber ClaimSubNumber001/ClaimSubNumber ValIDPRMBI/ValID /ZNAIsClaimValid /soap:Body /soap:Envelope /cfsavecontent cfhttp url=https://dev.claimsws.zurichna.com/ERCClaims/ZNAERCClaims.asmx; method=post cfhttpparam type=header name=content-type value=text/xml cfhttpparam type=header name=SOAPAction value=http://claimsws.zurichna.com/ERCClaims/ZNAIsClaimValid; cfhttpparam type=header name=content-length value=#len(soap)# cfhttpparam type=header name=charset value=utf-8 cfhttpparam type=xml name=message value=#trim(soap)# /cfhttp cfdump var=#cfhttp.FileContent# When I run this I get an error taking about the wsa:To. When I spoke with support from the company that created the web service they said I need to use WSE 3.0 instead of 2.0. Is that possible? I don't know how to specify the version or WSE at all for that matter. Any help on this would be great. Thanks in advance. -Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Consuming a Web Service with CF8
Just to get this out of the way. I am pretty much brand new to web services so please excuse my lack of knowledge. I have been working on a real small web app that allows the customer to input an invoice then it kicks out a csv of the invoices. My problem is that the vendor just added an additional step that requires that I check the invoice against a web service that will tell me if it is valid. The vendor gave me a basic document that lays out the web services. There are 2 web services one is just a ping and the other actually checks the invoice. I cannot get either of them to work and I am not sure why. Here is the info for the ping web service that they sent: ZNAPing Purpose:This web service was created to give an external customer an opportunity to verify availability of the ZNA Claims Web Services before calling in with actual request. Signature:string ZNAPing( void ); Input:NONE Result:string. Note:Successful return will contain an XML fragment with the following information ZNAPingResult timeStamp9/24/2004 8:24:58 AM/timeStamp Version0.61/Version /ZNAPingResult Client can parse this string to extract some information - timeStamp element contains date and time of the call, Version element â contains the version of the web services. I have been trying to consume it using cfinvoke like this: cfinvoke webservice = https://devurl.asmx; method = ZNAPing returnVariable = getBack username=username password=password cfoutput#getBack#/cfoutput I am getting this error when I run it: Unable to parse WSDL as an XML document. Parsing error: Fatal Error: URI=null Line=69: The element type p must be terminated by the matching end-tag Again, I am very new to web services so I am sure I am doing something wrong. If anyone could help point me in the right direction that would be very helpful. Thanks in advance for any help. Thanks for all the help with this but I am still having issues. I am just not sure if it is something I am doing wrong or if there is something wrong with the web service. That is because I am just simply not that knowledgeable with web services. Here is where I am: I have tried it using cfinvoke, cfhttp, and cfscript. They are pretty much give me the same results. I tried it this way: cfinvoke webservice = https://dev.claimsws.zurichna.com/ERCClaims/ZNAERCClaims.asmx?wsdl; method=ZNAping username=FirstChoice password=Vend0r04 And I get this error here - http://dev.thinksys.com/zurich/ws1.cfm I also tried it this way (without the ?wsdl): cfinvoke webservice = https://dev.claimsws.zurichna.com/ERCClaims/ZNAERCClaims.asmx; method=ZNAping username=FirstChoice password=Vend0r04 And I get this error here - http://dev.thinksys.com/zurich/ws2.cfm I am just not sure what I am doing wrong. The document that the vendor provided says that it has to be done using HTTP SOAP method invocation. I am not sure how to do that. Any more help on this would be great. Thanks! ~| 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:309946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Consuming a Web Service with CF8
Just to get this out of the way. I am pretty much brand new to web services so please excuse my lack of knowledge. I have been working on a real small web app that allows the customer to input an invoice then it kicks out a csv of the invoices. My problem is that the vendor just added an additional step that requires that I check the invoice against a web service that will tell me if it is valid. The vendor gave me a basic document that lays out the web services. There are 2 web services one is just a ping and the other actually checks the invoice. I cannot get either of them to work and I am not sure why. Here is the info for the ping web service that they sent: ZNAPing Purpose:This web service was created to give an external customer an opportunity to verify availability of the ZNA Claims Web Services before calling in with actual request. Signature:string ZNAPing( void ); Input:NONE Result:string. Note:Successful return will contain an XML fragment with the following information ZNAPingResult timeStamp9/24/2004 8:24:58 AM/timeStamp Version0.61/Version /ZNAPingResult Client can parse this string to extract some information - timeStamp element contains date and time of the call, Version element â contains the version of the web services. I have been trying to consume it using cfinvoke like this: cfinvoke webservice = https://devurl.asmx; method = ZNAPing returnVariable = getBack username=username password=password cfoutput#getBack#/cfoutput I am getting this error when I run it: Unable to parse WSDL as an XML document. Parsing error: Fatal Error: URI=null Line=69: The element type p must be terminated by the matching end-tag Again, I am very new to web services so I am sure I am doing something wrong. If anyone could help point me in the right direction that would be very helpful. Thanks in advance for any help. ~| 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:309539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Producing a cXML file
I am working on a fairly simple solution that allows users to input information from an invoice and it then drops the data in a MSSQL database. I need to then be able to pop out cXML files that can be uploaded to a billing vendor. Does anyone out there have any experience with cXML and how to produce a file using ColdFusion? Any help on this would be great. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JavaScript cftextarea with rich text
Thanks guys for all the help.
I ended up getting it to work with a combination of responses. Here is the code:
function check()
{
var text1 = ColdFusion.RichText.getEditorObject('theBody');
var text2 = text1.GetXHTML(true);
if (text2==0)
{
alert('Body is required');
}
}
Works like a champ. Thanks again!
I am trying to check whether or not a rich text textarea has a value
in JavaScript. On a normal textarea box I can just use the elementname.
value == '' but that is not working when I have rich text turned on.
Anyone have any ideas how to check it when rich text is on?
Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Writing content to a cfwindow from JavaScript
I am creating a cfwindow from JS with this:
ColdFusion.Window.create('testwindow', 'This is a test');
I also need to be able to write content to the window from JavaScript. That
will include JavaScript variables. I have tried doing it with this:
elementName_body.innerHTML='This is the body';
I cannot get it to work at all. It pops the window up but noting in the content.
Anyone have any ideas?
Thanks in advance for any help.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304024
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
JavaScript cftextarea with rich text
I am trying to check whether or not a rich text textarea has a value in JavaScript. On a normal textarea box I can just use the elementname.value == '' but that is not working when I have rich text turned on. Anyone have any ideas how to check it when rich text is on? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Remove everything but numbers and letters from a string
I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Remove everything but numbers and letters from a string
Thanks for the help. I am trying to do it like this: cfset d2 = rereplace(lcase(d1) , '[A-Za-z0-9 ]', '','all') / but (understandably) it is doing the reverse of what I want. It is replacing all the numbers and letters. How do I change it so it only picks characters that are not numbers and letters? Thanks The regex to use would look like this [A-Za-z0-9 ] -Mike Chabot On Sun, Apr 20, 2008 at 5:17 PM, Mike Chabot [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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Remove everything but numbers and letters from a string
Got it now. Thanks guys for the help. I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Remove everything left of a substring in a string
I am trying to figure out the best way to remove all text that is left of a substring in a string. Sting Example - ColdFusion is an application server and software development framework used for the development of computer software Substring Example - software development framework I need to figure out a function that returns - software development framework used for the development of computer software Any help on this would be great. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Issues with cfhttp and redirect
I am having issues with cfhttp returning 302 Moved Temporarily on some of the pages that I am hitting. I know that there are redirects happening and I am assuming that it is going past the threshold of 4 redirects. Does anyone know a way around this? Any help would be great. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about cfeed
@James Thanks for the info, that makes sense. Do you know if there is any way to use cffeed or anything else in CF to read the description then or do I need to manually? Thanks Again. Firefox is using its own XSLT to show you the feed - it's displaying the description, not the content. IE is showing the feed with the XSLT that comes with the feed, which shows the content. On Sat, Mar 29, 2008 at 3:58 PM, Steve Sequenzia [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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about cfeed
@James Actually when I look at the dump of the cffeed the content is the truncated version. So I guess I am confused because IE shows the entire article but when I use cffeed it only shows the truncated version. Any ideas? @James Thanks for the info, that makes sense. Do you know if there is any way to use cffeed or anything else in CF to read the description then or do I need to manually? Thanks Again. Firefox is using its own XSLT to show you the feed - it's displaying the description, not the content. IE is showing the feed with the XSLT that comes with the feed, which shows the content. On Sat, Mar 29, 2008 at 3:58 PM, Steve Sequenzia [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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Question about cfeed
Hey Ray, Thanks for the response. Yeah it is strange if you look at the feed directly in FF it shows it truncated but in IE it shows all the full articles. Also, other readers like Goolge Reader show the full article not the truncated version. Any ideas why this would be different? I will checkout ColdFusionBloggers.org and look at the code. Thanks! Eh? When I viewed http://feeds.feedburner.com/Techcrunch directly, I saw this for the first entry: Update: More details of the scheme are here. Musicians themselves may just be crazy, but the music labels are dangerously stupid, and need to be stopped before they can do any further damage to the music industry. Case in point: Warner Music, fully aware that the days of charging for recorded music are coming to an [...] Notice the [...]. This is exactly what I saw in your app as well. Also, I am wondering if it is possible to read some feeds ever so often and insert the results in a DB. I Check out cfschedule and Scheduled Tasks. Also don't forget that the entire code base to ColdFusionBloggers.org is available for download. You can use that for help. I also have code that works around a lot of CFFEEDs issues. On Thu, Mar 27, 2008 at 11:40 PM, Steve Sequenzia [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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Question about cfeed
I am experimenting with building a very simple feed reader but I am hiving issues with cffeed not reading all the contents of the feed on certain sites. I have this very basic reader setup that reads the feeds and then does a dump on the page. Here it is http://dev.thinksys.com/feeds/1.cfm Most feeds that you put in there are fine but the contents field on certain sites are getting truncated. For instance TechCrunch.com. This is the feed URL http://feeds.feedburner.com/Techcrunch. You will notice that the contents is truncated but if you look directly at the feed it is not truncated. Anyone have any idea why? Also, I am wondering if it is possible to read some feeds ever so often and insert the results in a DB. I want this process to work even without anything happening on the site. Anyone have any idea how to do that? Thanks for any help 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Datadiff and years, months, days
I posted this yesterday but I don't see any trace of it hitting the list, so if it is a double post I apologize. I am trying to use the Datediff function to determine the years, months, days between to days. Example - from 1/1/08 to 2/9/08 is 1 years 2 months 8 days. I am trying to figure out how to do that programmatically. Right now I can only come up with the totals months and the total days between two dates. I cannot figure out how to get it in the format I need. Any help on this would be great. 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:298676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Years, Months and Days from a date
I am trying to figuring how to determine the year, months and days from a date. Like from 1/1/2007 to 2/9/2008 it is 1 year 1 month and 8 days. I am trying to figure out how to do that programmatically. I have been trying to do it with datediff but I cannot figure out how. Any help would be great. 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:298658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Submitting a form inside of cfdiv
Yeah, I got it working by changing my cfform to a normal html form. That makes sense, thanks Azadi for the insight. that is only true for CFFORM tag, not FORM tag read here: http://www.coldfusionjedi.com/index. cfm/2007/8/5/Reminder-about-forms-and-ColdFusion-8-Ajax-Containers --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Cutter (CFRelated) wrote: Either way really. Here's the blurb out of the LiveDocs The ColdFusion Ajax container tags, cfdiv, cflayoutarea, cfpod, and cfwindow, automatically submit any forms that they contain asynchronously. When the form is submitted, the result returned by the action page replaces the contents of the container, but has no effect on the rest of the page. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Azadi Saryev wrote: i think you will find that using form ... instead of cfform ... (or is it the other way around?) will do the trick. using one submits the form to cfdiv, the other replaces the main page --- 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Submitting a form inside of cfdiv
I am trying to be submit a form from within a cfdiv on a parent page. What I mean is I have a page that has the entire layout and everything in it but the for itself is actually on another page that is showing by using a cfdiv with a bind to the URL. All of the form variables are on one page so it submits fine but I cannot figure out how to break out of the cfdiv after the form is submitted. Normally I submit to an action page and handle all my database inserts/updates then from there then just do a cflocation to the page I want it to land on. When I do that from the form that is inside of the cfdiv the landing page shows up inside of the original page. It makes sense that it would do that but does anyone have any idea how to get around this? Any help would be great. 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:296294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Dynamic Dropdowns
Hi All, Can I get some help figuring out how to connect two dropdowns dynamically? I am working a shoe database and I need to allow the user to select a size from a dropdown and then from there I need to have another dropdown called quantity updated with the amount of quantity based on the size that is selected. All the data is coming from a MSSQL Database and I am using ColdFusion 8. I would like to do this via Ajax and not refresh the entire page. I know how to do it by refreshing the entire page but not the Ajax way. Any help on this would be great. Thanks in advance. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Determing last record in a loop
I have a loop that uses a cfquery with a start and end for paging. I am trying to figure out if there is a way for me to know if the current record in the loop is the last record. I know how to tell based on the query but I am not sure how to know based on the loop. Any help on the would be great. Thanks in advance ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Replace spaces with dashes
I need to take a string and replace all the spaces with dashes. I tried using the replace function but I am having issues with strings that have multiple spaces next to each other and/or a space or spaces at the end. Here is what I have: cfset dirName = #Replace(String, , -, ALL)# Any suggestions on a better way to do this? Thanks in advance for any help. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replace spaces with dashes
@Everyone - Thanks for the help. @Charlie - The regex worked perfect. Thanks for the help. I need to take a string and replace all the spaces with dashes. I tried using the replace function but I am having issues with strings that have multiple spaces next to each other and/or a space or spaces at the end. Here is what I have: cfset dirName = #Replace(String, , -, ALL)# Any suggestions on a better way to do this? Thanks in advance for any help. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Current directory of page
I am trying to figure out if it is possible to tell the name of the directory that the viewed page is in. I have been playing with cfdirectory and I cannot figure it out. What I mean if this is the file c:\inpub\wwwroot\website\about-us\index.cfm I want to read the about-us and make it a variable on the page. Anyone know if this is possible? Thanks! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exporting from ColdFuion to a Excel file
I have tried a few ways to export from CF to Excel. I tried a basic query and used cfcontent to download the file. I tried cfreport. They both seem to work fine but a security warning pops up on the client computer when the file is opened. It seems to only come up on computers running Office 07. Here is the message: The file you are trying to open, 'dataFile.xls' is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? If you hit yes it opens fine. I am just concerned that this will confuse users and they will not open it. Any suggestions on how to stop this besides client side security settings in Excel? Thanks. __ Steve Sequenzia Thinksys Incorporated 1613 E Livingston St Orlando, FL 32803 866.633.3000 x305 407.459.1305 Direct 866.892.3000 Help Desk 407.895.3338 Fax -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 10:11 PM To: CF-Talk Subject: Exporting from ColdFuion to a Excel file Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Exporting from ColdFuion to a Excel file
Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exporting from ColdFuion to a Excel file
@Jerry - I have been trying that way but I am getting an error when the file opens. It says The file you are trying to open, 'dataFile.xls' is in a different format than specified by the file extension. For some reason it is trying to use the .cfm file. @Ben - Thanks for the help. I did not realize that excel was an option for cfreport. I will check that out. __ Steve Sequenzia Thinksys Incorporated 1613 E Livingston St Orlando, FL 32803 866.633.3000 x305 407.459.1305 Direct 866.892.3000 Help Desk 407.895.3338 Fax -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:43 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Or, if the data is query data, use cfreport which can output to Excel. --- Ben -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:26 PM To: CF-Talk Subject: Re: Exporting from ColdFuion to a Excel file cfcontent type=application/vnd.ms-excel cfheader name=Content-Disposition value=filename=#filename#.xls cfoutput#pageContent#/cfoutput I assume this will still work on 8 Jerry On 10/11/07, Steve Sequenzia [EMAIL PROTECTED] wrote: Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exporting from ColdFuion to a Excel file
William, Sorry for not being more descriptive. I just need to export a really basic query from SQL to Excel. It only has like for fields and no formulas. Thanks __ Steve Sequenzia Thinksys Incorporated 1613 E Livingston St Orlando, FL 32803 866.633.3000 x305 407.459.1305 Direct 866.892.3000 Help Desk 407.895.3338 Fax -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 10:29 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Steve, Like skinning a cat, there are several ways to have a web document end up in Excel. Can you describe your scenario? What are you trying to accomplish? William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 7:11 PM To: CF-Talk Subject: Exporting from ColdFuion to a Excel file Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Isssues with cfselect
I cannot seem to figure this out. I have a table called dirs. It has columns named: dirID, dirPath and parentDirID. The parentDirID handles the hierarchy. All I need to do is have a cfselect that lists all the dirPaths but defaults to the parentDirID of the selected dir. Here is the code: cfquery name=getAll datasource=pcap SELECT dirID, dirPath FROM dirs WHERE status = '1' ORDER BY dirPath /cfquery cfquery name=getCurrent datasource=pcap SELECT parentDirID FROM dirs WHERE dirID = '#url.dirID#' /cfquery cfform cfselect name=parentID query=getAll display=dirPath value=dirID selected=#getCurrent.parentDirID#/cfselect /cfform I know I have done stuff like this before but I think it is getting confused (or I am getting confused) because it is in the same table. Any help on this would be great. Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Alt tag or tooltip on cftreeitem
Anyone no if it is possible to do a alt tag or tooltip on a cftreeitem. I just need a little description to pop up when a user rolls over the cftreeitem. Any help on this would be great. Thanks in advance. Anyone?? ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Alt tag or tooltip on cftreeitem
Anyone no if it is possible to do a alt tag or tooltip on a cftreeitem. I just need a little description to pop up when a user rolls over the cftreeitem. Any help on this would be great. Thanks in advance. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Numberformat and cfgrid
Ray Camden has blogged about column rendring, maybe you check that out. On 9/21/07, Steve Sequenzia [EMAIL PROTECTED] wrote: I just need to add commas to a grid column that are displaying numbers. I think I need to use numberformat but I am not sure how to use it. Any help would be great. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Numberformat and cfgrid
I just need to add commas to a grid column that are displaying numbers. I think I need to use numberformat but I am not sure how to use it. Any help would be great. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Am I the only one who thinks Flex 2 isn't
Hey Brian, quick question about this. If you use a CFC to create a web service and do not convert it to XML what data format does the CFC respond to requests in? I mean, if I have a backend in CF that uses CFC to access the database and feed it to the front end (or other users front ends) where is the data format specified? I might be asking this question wrong because my knowledge of web services is pretty limited but if you could give me an idea of how this works that would be great. Thanks! A CFC will respond to web service requests and AMF without you having to do anything. Further, if custom XML is being generated, it has to come from somewhere. So the XML generation could stay in place but the underlying CFC supplying the data could easily be exposed for AMF calls, allowing you to do AMF, raw XML, and web services. The bottom line is that however else you want to expose the data, there is no reason not to use AMF to feed a Flex app. portabilityyou could use any client technology to consume your service if it uses xml versus amf. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Am I the only one who thinks Flex 2 isn't
Hey Brian, quick question about this. If you use a CFC to create a web service and do not convert it to XML what data format does the CFC respond to requests in? I mean, if I have a backend in CF that uses CFC to access the database and feed it to the front end (or other users front ends) where is the data format specified? I might be asking this question wrong because my knowledge of web services is pretty limited but if you could give me an idea of how this works that would be great. Thanks! A CFC will respond to web service requests and AMF without you having to do anything. Further, if custom XML is being generated, it has to come from somewhere. So the XML generation could stay in place but the underlying CFC supplying the data could easily be exposed for AMF calls, allowing you to do AMF, raw XML, and web services. The bottom line is that however else you want to expose the data, there is no reason not to use AMF to feed a Flex app. portabilityyou could use any client technology to consume your service if it uses xml versus amf. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Am I the only one who thinks Flex 2 isn't
Hey Brian, quick question about this. If you use a CFC to create a web service and do not convert it to XML what data format does the CFC respond to requests in? I mean, if I have a backend in CF that uses CFC to access the database and feed it to the front end (or other users front ends) where is the data format specified? I might be asking this question wrong because my knowledge of web services is pretty limited but if you could give me an idea of how this works that would be great. Thanks! A CFC will respond to web service requests and AMF without you having to do anything. Further, if custom XML is being generated, it has to come from somewhere. So the XML generation could stay in place but the underlying CFC supplying the data could easily be exposed for AMF calls, allowing you to do AMF, raw XML, and web services. The bottom line is that however else you want to expose the data, there is no reason not to use AMF to feed a Flex app. portabilityyou could use any client technology to consume your service if it uses xml versus amf. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Am I the only one who thinks Flex 2 isn't
Brian, thanks for the info. It makes more sense to me now. You control the format based on the invoke not necessarily in the CFC. For some reason I thought that you had to convert the data to XML in the CFC. Thanks for clearing that up. Sorry everyone for the double (I mean triple) posts. If you invoke the CFC as a web service (using ?wsdl on the URL), you get the result back as a SOAP response (XML). If you invoke a CFC method via a URL without specifying ?wsdl, you get the returned value as WDDX. If you invoke it from Flash, the response is in AMF. Also, in CF8 you can specify returnFormat on the URL with values for JSON, WDDX, and plain. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UI recommendations needed
Andy, Can you share the code you used for the iframe? Thanks Just an update. It seems like it is working. :) I need to tweak it some more to get the result I want but at least the file is being uploaded... within a CFWINDOW. So IFRAME is the answer. Thanks DAN! Thanks Dan, I haven't really used IFRAME much except to display external sites, so I haven't played with the JS interaction between them. I should give it a try and see if I can get it to solve the upload problem. Will tell you how it goes. Andy Andy, Interesting... I wonder. I used IFRAME to display a PDF file within a CFLAYOUT (pushing data one way). However I am not sure of the level of interactivity possible with IFRAME (data going both ways). It might work if you just want to pass the form information one way to the IFRAME. What I've done in the past is set the target attribute of the form / tag to point to the iframe /. Then whatever script your posting to in the iframe / you can just use a JS callback function to notify the main page when the upload is complete. That's a technique that I've used since 1998. -Dan ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cflocation to cflayout
Anyone know if it is possible to use cflocation to redirect a page inside of a cflayout to a cflayoutarea? I don't want it to break the page out. Thanks in advance for any help. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfwindow refreshes main page
Larry,
What is the error you are getting when it loads?
Here is a similar demo I did using a grid and a pod. It might be helpful:
http://demo.thinksys.com/cf8/cfgrid/contacts.cfm
I am a bit confused as to why this is occurring, but I am sure it is
something I have done wrong. I am attempting to have a cfgid, that
displays a list of issues that users have submitted on our intranet to
the IT department. When you load the page, the first row of the cfgrid
is selected and the cfwindow refreshes. It gives me an error, but once
you click ok, it then loads the page and you can do anything including
updating the information, but when you click on another row of the
cfgrid, it starts to refresh the cfwindow, but then the entire parent
page refreshes, but nothing loads. The parent page just hangs and you
just see a white page.
he following code is on one page in this order.
- cfgrid -
cfform name=step1
cfgrid colheaders=yes format=html pagesize=15
bind=cfc:helpdesk.IssueDisplay({cfgridpage},{cfgridpagesize},
{cfgridsortcolumn},{cfgridsortdirection}) name=unresissues
striperows=yes
cfgridcolumn display=no width=40 name=helpdesk_id
header=Request
cfgridcolumn display=no name=it_member_id header=AssignID
width=0
cfgridcolumn display=yes width=80 name=helpdesk_fname
header=First Name
cfgridcolumn display=yes width=80 name=helpdesk_lname
header=Last Name
cfgridcolumn display=yes width=90 name=class_type
header=Classification
cfgridcolumn display=yes mask=MM/DD/
name=helpdesk_date_created header=Date Submitted width=100
cfgridcolumn display=yes name=assign_it_name header=Assigned
To
/cfgrid
cfinput type=button name=GO value=View Request
onClick=ColdFusion.Window.show('helpdeskdata') /
/cfform
-- cfwindow tag -
cfwindow name=helpdeskdata title=Helpdesk Data initShow=true
width=500 height=885 x=700 y=0 refreshonshow=true
source=windowresult.cfm?id={unresissues.
helpdesk_id}act=1itmemid={unresissues.
it_member_id}classtype={unresissues.class_type} cfajaximport
tags=cfform, cftextarea, cfwindow scriptsrc=/CFIDE/scripts
/cfwindow
Any assistance would be appreciated
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287543
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UI recommendations needed
Andy, Yes, I am having the exact same problem. When a form is in a Ajax UI element (like cflayout and cfdiv) it is submitted asynchronous. The encoding type is set to application/x-www-form-urlencoded and it needs to be multipart/form-data. According to Ray Camden there is no way around this and it is not possible to use cffile to upload a file asynchronous. I have had some suggestions to use a JavaScript or a flash based upload but I have not had a chance to try anything. I think that if you try to use cfwindow you will have the same problem because it is still part of the page and will submit asynchronous. I think it is kind of crazy to think that with CF8 we have these new tags to help with UI development (like cflayout and cfdiv) but you cannot upload a file when using them. I understand that it is because it is asynchronous, but I think there should be some way to do it. Who knows. -Steve ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UI recommendations needed
Yeah I tried to change the encoding with JS and it do not work. It just still
errors out with this message:
Invalid content type: application/x-www-form-urlencoded. The cffile
action=upload requires forms to use enctype=multipart/form-data.
I think that CF overrides it because it is in a AJAX UI Element. I tested it
using a normal HTML form instead of cfform and it works. But I need to use a
cfform for some other reasons.
-Steve
What if you change the encoding type using javascript?
script
UploadButton.Attributes.Add('onclick','javascript:document.forms[0].enco
ding = multipart/form-data;')
/script
http://delphi.about.com/od/adptips2004/a/bltip0704_4.htm
M!ke
Andy,
Yes, I am having the exact same problem. When a form is in a Ajax UI
element (like cflayout and cfdiv) it is submitted asynchronous. The
encoding type is set to application/x-www-form-urlencoded and it needs
to be multipart/form-data. According to Ray Camden there is no way
around this and it is not possible to use cffile to upload a file
asynchronous.
I have had some suggestions to use a JavaScript or a flash based upload
but I have not had a chance to try anything.
I think that if you try to use cfwindow you will have the same problem
because it is still part of the page and will submit asynchronous.
I think it is kind of crazy to think that with CF8 we have these new
tags to help with UI development (like cflayout and cfdiv) but you
cannot upload a file when using them. I understand that it is because it
is asynchronous, but I think there should be some way to do it.
Who knows.
-Steve
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287487
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UI recommendations needed
I am currently working on a small web app and I am struggling with some UI issues. I have in the past liked to use frames (I know) for the general layout. Here is a simple sample of a layout using frames that I have used in the past: http://demo.thinksys.com/ui/frames/ On this project I wanted to utilize some of the new CF8 AJAX UI tags. So I designed a layout like this: http://demo.thinksys.com/ui/cflayout/ using cflayout. I really like the general layout and the fact that it is asynchronous but I am running into some issue. One major problem I am having now is uploading files (I posted about this). Being that all the forms submit asynchronous cffile does not work. I am also running into some other strange things that are making me rethink this strategy. I guess what I am looking for is some feedback about what other people are doing for UI development. I know that Flex is very popular but I really don't know much about it and have never used it. Any guidance on this would be greatly appreciated. Thanks ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UI recommendations needed
Chris, thanks for the insight. You are correct the frames way is quicker to develop in but the AJAX way is a nicer user experience. Thing is I still have some issues doing it with cflayouts. I guess I just need to make a decision which way to go. I really want to get into Flex, I am just not sure how long it will take to get up to speed with it enough to pop out a small app. Thanks again! My $.02: The Ajax is going to be far more user-friendly, but about 50 - 100% more work The frames work fine, and its easy to target links / forms to it. If your admin is going to be used by tons of folks, I would spend the extra time on the Ajax version, if its gonna be 2 - 5 people, don't waste time and go with the frame approach. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer I am currently working on a small web app and I am struggling with some UI issues. I have in the past liked to use frames (I know) for the general layout. Here is a simple sample of a layout using frames that I have used in the past: http://demo.thinksys.com/ui/frames/ On this project I wanted to utilize some of the new CF8 AJAX UI tags. So I designed a layout like this: http://demo.thinksys.com/ui/cflayout/ using cflayout. I really like the general layout and the fact that it is asynchronous but I am running into some issue. One major problem I am having now is uploading files (I posted about this). Being that all the forms submit asynchronous cffile does not work. I am also running into some other strange things that are making me rethink this strategy. I guess what I am looking for is some feedback about what other people are doing for UI development. I know that Flex is very popular but I really don't know much about it and have never used it. Any guidance on this would be greatly appreciated. Thanks ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem uploading file from form in cfdiv
Yeah I was thinking about doing it with a pop window but I was trying to avoid doing that, I might have to though. Thanks for the help. Anyone else have any ideas? I hate to suggest it- but the only thought that comes to mind is a popup window. PLEASE know that I bet there is a better solution - I just don't know it. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Importing CSV into
I actually used SQL to do it because I was having issues with the CFM code. I
still need to come up with a way for end users to do it from a web page. I need
to look into it some more.
Why not use dts? Put the work on the db server, not the cf server.
MUCH faster too.
-Original Message-
From: Steve Sequenzia [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: 8/24/07 2:32 PM
Subject: Importing CSV into
I am trying to write some code that takes a .csv file and inserts it
into SQL.
I am having issues with it reading the header. I would like to be able
to leave the header on the file and not have it insert the header data
into the DB.
When I try to run it without a header I am having issues with it
reading the number of elements wrong. It is getting confused when a
line has blank data for the element.
So it see following line as only having 8 elements when it should have
13:
,
Zachary,Abbott,D.O.,,1720 Northbrook Drive,,Ann Arbor,MI,48103,
[EMAIL PROTECTED],,
Here is my code:
cffile action=read file=#file1# variable=fileData
cfloop list=#fileData# delimiters=#Chr(10)##Chr(13)#
index=record
cfquery name=qryInsert datasource=physleads
INSERT INTO contacts (prefix, firstName, lastName, suffix, companyName,
address, address2, city, state, zipCode, phone, fax, email)
values (
#listgetat('#record#',1, ',')#'
#listgetat('#record#',2, ',')#'
#listgetat('#record#',3, ',')#'
#listgetat('#record#',4, ',')#'
#listgetat('#record#',5, ',')#'
#listgetat('#record#',6, ',')#'
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287237
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem uploading file from form in cfdiv
I am having issues with trying to upload a file when the form that has the
cfinput in it is nested inside of a cfdiv. Here is a simple version of the
problem:
cfif isDefined('cmd')
cffile action=upload destination=#application.photoPath# filefield=file1
/cfif
cfdiv
cfform name=form1 enctype=multipart/form-data
cfinput name=file1 type=file
cfinput name=cmd type=submit value=Add
/cfform
/cfdiv
This errors out with this error:
Invalid content type: application/x-www-form-urlencoded. The cffile
action=upload requires forms to use enctype=multipart/form-data.
As you can see I am setting the content type to multipart/form-data but it is
ignoring it. I guess it has something to do with the way the form is submitted
when it is in the cfdiv. This same code works with without the cfdiv, but I
need it inside of the cfdiv.
Any ideas?
Thanks.
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287240
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Importing CSV into
Crow, Thanks for the info, that is very helpful. I am using SQL 05 DTS is not really an option anymore. I had to use Integration Services to do it. I am guessing you can save the package and call it like you do a DTS package. Any ideas if it will function the same way. Thanks again for the help. Here's what I do, start to finish: 1) provide a file upload form 2) upload the file to the file system via CF. Be sure to put it in the folder that you specified in the DTS pkg you created, also making sure that the file is named the same as the file you specified in the DTS pkg. 3) run the DTS via a stored procedure - a complete tutorial on hoew to do that with CF can be found here: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS (thanks Dan) 4) delete the file, or archive it, or whatever. That's about all there to it. The hardest part is setting up the SP call from CF, and that is pretty easy too, thanks to the handy-dandy tutorial. Let me know if I left anything out. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem uploading file from form in cfdiv
Ray, Thanks for the help. That makes sense, but I have a pretty big issue. I am using Ajax UI elements (cflayout and cfdiv) for my interface and I need to have the ability to upload files in it. Are there any work arounds that you can think of. I am wondering if I can use a separate JavaScript upload utility to do it. Any ideas, if not I may have to redo my whole UI. Thanks again. cfform posts that are within an Ajax UI element are posted asynch. You can't do file uploads asynch. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Importing CSV into
I am trying to write some code that takes a .csv file and inserts it into SQL.
I am having issues with it reading the header. I would like to be able to leave
the header on the file and not have it insert the header data into the DB.
When I try to run it without a header I am having issues with it reading the
number of elements wrong. It is getting confused when a line has blank data for
the element.
So it see following line as only having 8 elements when it should have 13:
,Zachary,Abbott,D.O.,,1720 Northbrook Drive,,Ann Arbor,MI,48103,[EMAIL
PROTECTED],,
Here is my code:
cffile action=read file=#file1# variable=fileData
cfloop list=#fileData# delimiters=#Chr(10)##Chr(13)# index=record
cfquery name=qryInsert datasource=physleads
INSERT INTO contacts (prefix, firstName, lastName, suffix, companyName,
address, address2, city, state, zipCode, phone, fax, email)
values (
#listgetat('#record#',1, ',')#'
#listgetat('#record#',2, ',')#'
#listgetat('#record#',3, ',')#'
#listgetat('#record#',4, ',')#'
#listgetat('#record#',5, ',')#'
#listgetat('#record#',6, ',')#'
#listgetat('#record#',7, ',')#'
#listgetat('#record#',8, ',')#'
#listgetat('#record#',9, ',')#'
#listgetat('#record#',10, ',')#'
#listgetat('#record#',11, ',')#'
#listgetat('#record#',12, ',')#'
#listgetat('#record#',13, ',')#'
)
/cfquery
/cfloop
Any help with this would be great.
Thanks.
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfimage resize running very slow
I am trying to figure out if it is normal for the cfimage resize to be very slow. I am reading photos from a database then resizing them and writing them to a directory. The the process works fine but it gets through about 17 pictures and then errors out with this error The request has exceeded the allowable time limit Tag: CFLOOP Am I missing something here? Here is some of the code: cfloop query=getPhotos cfimage source=#photoPath#/#photoName# name=ph cfif imageGetWidth(ph) GTE imageGetHeight(ph) cfset widthT = '150' cfset heightT = '112' cfset widthF = '600' cfset heightF = '450' cfelse cfset heightT = '150' cfset widthT = '112' cfset heightF = '600' cfset widthF = '450' cfimage action=resize height=#heightT# width=#widthT# name=nImage source=#photoPath#/#photoName# destination=#application.viewPhotoDir#/thumbnails/#photoName# overwrite=yes cfimage action=resize height=#heightF# width=#widthF# name=nImage2 source=#photoPath#/#photoName# destination=#application.viewPhotoDir#/full/#photoName# overwrite=yes /cfloop Any help on this would be great. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Uploading multiple files
I am trying to figure out how to use cfinput type=file to upload multiple files at once. I can only seem to get it to accept one file at a time. Any help on this would be great. BTW - I am on CF8. Thanks. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Metadata from picture
Thanks Jayesh... That is exactly what I was looking for. Thanks again. Hi ImageInfo() function is doesn't provide the metadata information. It's about the Image File properties. If you need to extract the Metadata, you can use the following functions. ImageGetIPTCMetadata() ImageGetIPTCTag() ImageGetExifMetadata() ImageGetEXIFTag() Thanks Jayesh Viradiya Adobe CF Team ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Metadata from pitcure
I am trying to figure out if it is possible to read the date picture taken of a picture in CF8. I would like to read it and write it into a DB. I know in CF8 you can use ImageInfo to get some of the metadata off a picture but I don't see anything for date picture taken. I have heard of services like Flickr reading metadata off of the uploaded pictures and storing it. Any ideas if I can do this with ColdFusion? Thanks in advance. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SelectOnLoad
Works for me... selectOnLoad=false Here is a demo with it: http://demo.thinksys.com/cf8/cfgrid/contacts.cfm Are you still on a beta or the release? Hi all, Anyone dealt with selectOnLoad in CFGRID -- in the docs, it's there, plain as day, but when I try to use it, I get this: Attribute validation error for tag CFGRID.The tag does not allow the attribute(s) SELECTONLOAD. This is CF8 -- Charles Sheehan-Miles | http://www.sheehanmiles.com Author of Republic: A Novel of America's Future ...Sparse, clean narrative... Pay attention to this new book... -- Pulitzer Prize winning journalist John Hanchette, Niagara Falls Reporter This novel ...may be prophetic...It will disturb you...It should. -- DailyKos ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How would I go by doing this?
If you are using cfwindow than the window is on the same page. You should be able to use JS to control the value on the original form. Like: document.formName.name.value; Check out this demo I did: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm I think the concept is kind of the same. Click the new company link and a cfwindow opens. After the new company is inserted there is a close button that uses JS to update the company picklist on the original form. It then closes the window. I hope this helps. The only way I know of doing what you've indicated below is to use a JavaScript. You can reference the parent or opener window by using the opener keyword: opener.document.parentForm.pf1.value = document.childForm.cf1.value; A good example of how to do this from a JavaScript can be seen here: http://www.rgagnon.com/jsdetails/js-0066.html -- Original message -- From: Andy Chen [EMAIL PROTECTED] Here's a situation: Basically there is a form (CFFORM) which there are various fields. One of the field would be a basic CFINPUT text field where an image ID can be entered. The user will be able to click on a button to preview available images (CFWINDOW). Whatever image they select in the Window (via radio button or drop down), it will populate the main form with the value. I can't figure out how to pass a variable from the Window back to the parent form. To use some of the UI features, the Window will need to have a CFFORM also. I tried binding but it would only work if it is in the same form (or section). Most commands support FORMNAME.FORMFIELD naming to apply a function but is there a WINDOW.FORMNAME.FORMFIELD naming scheme? I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for pointers but I can't seem to find out what to use. It seem pretty straight forward so I figure I must be missing something obvious... please help. Thanks, Andy ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How would I go by doing this?
Andy,
Move the JS to the form_test1.cfm page. It works when you do that.
Here it is:
http://demo.thinksys.com/cf8/cfwindow/form_test1.cfm
Are you using Firebug? As Ray Camden has told me many times, use Firebug. It is
really great for this stuff. You would see that the actual error was updateit()
is not defined.
But just move the JS to form_test1.cfm and you should be good.
-Steve
Steve, that is it. Similar to what I want to do but something is weird.
I still get the Javascript: Object Expected error. This means I did
something stupid like typed something wrong however I don't see it,
and I simplified it a lot already. This test is just to copy what is
typed in the Window onto the main form.
(form_test1.cfm)
cfif isDefined(form.submit)
cfdump var=#form#
/cfif
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titleInput Test/title
/head
body
cfajaximport tags=cfform,cfwindow
cfform name=mainform action=form_test1.cfm
cfinput name=test1 size=10 type=text
cfinput type=submit name=submit value=submit
/cfform
cfwindow name=win1 source=form_test1_win.cfm initshow=true /
/body
/html
(form_test1_win.cfm)
script
function updateit() {
document.mainform.test1.value = document.winform.wintxt.value;
}
/script
cfform name=winform
TYPE SOMETHING: cfinput type=text name=wintxt size=10
onkeyup=javascript: updateit();
/cfform
If you are using cfwindow than the window is on the same page. You
should be able to use JS to control the value on the original form.
Like:
document.formName.name.value;
Check out this demo I did:
http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm
I think the concept is kind of the same. Click the new company link
and a cfwindow opens. After the new company is inserted there is a
close button that uses JS to update the company picklist on the
original form. It then closes the window.
I hope this helps.
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with cfgrid and binding to a cfc
I am trying to set a cfgrid to bind to a cfc but for some reason it is not
showing any data. The grid is loaded and it does not error out or anything it
just does not show any data in the grid. Here is the code:
Display Page -
cfform name=productsForm
cfgrid name=productsGrid format=HTML pagesize=10 selectmode=row
bind=cfc:data.getProducts({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})
cfgridcolumn name=sku header=SKU width=300
cfgridcolumn name=style header=Style width=300
/cfgrid
/cfform
CFC Page:
cfcomponent
cffunction name=getProducts access=remote
cfargument name=page required=yes
cfargument name=pageSize required=yes
cfargument name=gridsortcolumn required=yes
cfargument name=gridsortdirection required=yes
cfquery name=queryProducts datasource=atc
SELECT sku, style
FROM products
cfif gridsortcolumn neq ''
order by #gridsortcolumn# #gridsortdirection#
/cfif
/cfquery
cfreturn queryconvertforgrid(queryProducts,page,pagesize)
/cffunction
/cfcomponent
Any help on this would be great.
Thanks!
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285602
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cfgrid and binding to a cfc
Ray, Yes I a using Firebug. Here is what the query string looks like: http://dev.thinksys.com/atc/portal/modules/inventory/data.cfc?method=getproductsreturnFormat=jsonargumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=9DD5A34E600C2D12C2BC77ACEDE990C8_cf_rc=0 It makes sense to me up to the argumentCollection part but I am not really sure what it is suppose to look like after that. Here a live link of what it is doing: http://dev.thinksys.com/atc/portal/modules/inventory/viewInventory.cfm Thanks for the help! The number one tip in the world for stuff like this - Firebug. Are you using Firebug to see if your Ajax call is having issues? Maybe yourquery isn't returning anything for example. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cfgrid and binding to a cfc
Ray, I tried to make the names upper case and no change. I cannot remove the cfgridcolumn because it errors out without at least one when using the bind. Here is the error: The cfgrid tag for HTML format using bind attribute requires at least one cfgridcolumn. I don't know what the problem is with this. Thanks again. Hey - try renaming your columns to be upper case. Or try removing them and just let the grid lay out th ecolumns. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cfgrid and binding to a cfc
It is still not working for me. I can see the data in JSON format when I run the query string from Firebug, but there is just still no data showing up in the grid? Oh duh. Hmmm. You lost me there then. Outside of being pretty slow, the code seemed ok. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cfgrid and binding to a cfc
I guess I am confused (what's new, right). The link to the actual grid is:
http://dev.thinksys.com/atc/portal/modules/inventory/viewInventory.cfm
That does not load any data in the. The only update I have made to that is I
made the column names upper case.
The query string from Firebug when that page loads is:
http://dev.thinksys.com/atc/portal/modules/inventory/data.cfc?method=getproductsreturnFormat=jsonargumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=9DD5A34E600C2D12C2BC77ACEDE990C8_cf_rc=0
That displays the JSON data string in the browser when it is clicked it.
It seems to me like the grid is just not reading the data string for some
reason. Maybe my code is wrong but I cannot seem to find where.
Again here is the code:
viewInventory.cfm -
cfform name=productsForm method=get
cfgrid name=productsGrid format=html pagesize=7 selectmode=row
bind=cfc:data.getproducts({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})
cfgridcolumn name=SKU header=SKU width=300
cfgridcolumn name=STYLE header=Style width=300
/cfgrid
/cfform
data.cfc -
cffunction name=getProducts access=remote
cfargument name=page required=yes
cfargument name=pageSize required=yes
cfargument name=gridsortcolumn required=yes
cfargument name=gridsortdirection required=yes
cfquery name=queryProducts datasource=atc
SELECT sku, style
FROM products
cfif gridsortcolumn neq ''
order by #gridsortcolumn# #gridsortdirection#
/cfif
/cfquery
cfreturn queryconvertforgrid(queryProducts,page,pagesize)
/cffunction
Thanks Again.
Did you update the copy you pointed me to? Cuz that copy still has the
link in the response.
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285634
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cfgrid and binding to a cfc
Got it. Works now. I was looking right at that and I did not see it. Thanks Ray, you rock! No, what I mean is - go here: http://dev.thinksys.com/atc/portal/modules/inventory/data. cfc?method=getproductsreturnFormat=jsonargumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%7D_cf_nodebug=true_c f_nocache=true_cf_clientid=9DD5A34E600C2D12C2BC77ACEDE990C8_cf_rc=0 View source. See the link tag? That is breaking your response. On 8/7/07, Steve Sequenzia [EMAIL PROTECTED] wrote: I guess I am confused (what's new, right). The link to the actual grid is: http://dev.thinksys.com/atc/portal/modules/inventory/viewInventory. cfm That does not load any data in the. The only update I have made to that is I made the column names upper case. The query string from Firebug when that page loads is: http://dev.thinksys.com/atc/portal/modules/inventory/data. cfc?method=getproductsreturnFormat=jsonargumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%7D_cf_nodebug=true_c f_nocache=true_cf_clientid=9DD5A34E600C2D12C2BC77ACEDE990C8_cf_rc=0 That displays the JSON data string in the browser when it is clicked it. It seems to me like the grid is just not reading the data string for some reason. Maybe my code is wrong but I cannot seem to find where. Again here is the code: -- == = Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
href in cfgrid to Ajax UI layout
Ok, I think I have been asking more than the allotted amount of questions
lately (and Ray has been answering them all) but I have another question.
Anyone know how to have the hyperlink in a cfgrid open the linked page in a
cflayout or a cfdiv
I have tried href=javaScript:ColdFusion.navigate('page.cfm', 'results').
That does not work and it will not take a onclick.
Any ideas?
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285657
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
If cfwindow exists
Anyone know the syntax to tell whether a cfwindow by name exists on a page. I am having issues with it trying to reload a new window with same name. I need to figure out the syntax to tell whether it is defined. Any ideas? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
One form with two submit buttons in cflayoutarea
I have this little bit of code that I am testing with inside of a
cflayoutarea:
cfform name=form1
cfinput name=sku type=text
cfinput type=submit name=cmd1 value=1
cfinput type=submit name=cmd2 value=2
/cfform
cfif isDefined('cmd1')
cfoutput#cmd1#/cfoutput
/cfif
cfif isDefined('cmd2')
cfoutput#cmd2#/cfoutput
/cfif
When inside the cflayoutarea and the form is submitted it always returns a
value for cmd1 no matter which submit button is clicked to submit the form and
no value for cmd2. See example: http://demo.thinksys.com/cf8/cflayout/
When not in the cflayoutarea it functions like I think it should. See
Example: http://demo.thinksys.com/cf8/cflayout/1.cfm
Anyone have any idea why. I am sure I am just confusing something because I am
really not sure about a lot of the new CF8 stuff.
Thanks in advance for any help.
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285434
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One form with two submit buttons in lt;cflayoutareagt;
Ray,
Thanks for the help again.
Yeah it is confusing me. I have tried submitting to the same page and to a
different page and it always has the same result. The second button is ignored.
I don't know what the deal is. At least it is not just me, if it surprised you
then there must really be something wrong.
Thanks again, you are the man.
I have this little bit of code that I am testing with inside of a
cflayoutarea:
cfform name=form1
cfinput name=sku type=text
cfinput type=submit name=cmd1 value=1
cfinput type=submit name=cmd2 value=2
/cfform
cfif isDefined('cmd1')
cfoutput#cmd1#/cfoutput
/cfif
cfif isDefined('cmd2')
cfoutput#cmd2#/cfoutput
/cfif
When inside the cflayoutarea and the form is submitted it always
returns a value for cmd1 no matter which submit button is clicked to
submit the form and no value for cmd2. See example: http://demo.
thinksys.com/cf8/cflayout/
When not in the cflayoutarea it functions like I think it should.
See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm
Anyone have any idea why. I am sure I am just confusing something
because I am really not sure about a lot of the new CF8 stuff.
Thanks in advance for any help.
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285439
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: One form with two submit buttons in amp;lt;cflayoutareaamp;gt;
My need for it is pretty similar to what Ray explained. My buttons are Save and
Save New. So both buttons submit the form, I just know what the next step is
based on the button. I agree, it can be done with a drop down or a check box I
have always just liked doing it with two buttons.
Thanks.
Ray,
Thanks for the help again.
Yeah it is confusing me. I have tried submitting to the same page and
to a different page and it always has the same result. The second
button is ignored.
I don't know what the deal is. At least it is not just me, if it
surprised you then there must really be something wrong.
Thanks again, you are the man.
I have this little bit of code that I am testing with inside of a
cflayoutarea:
cfform name=form1
cfinput name=sku type=text
cfinput type=submit name=cmd1 value=1
cfinput type=submit name=cmd2 value=2
/cfform
cfif isDefined('cmd1')
cfoutput#cmd1#/cfoutput
/cfif
cfif isDefined('cmd2')
cfoutput#cmd2#/cfoutput
/cfif
When inside the cflayoutarea and the form is submitted it always
returns a value for cmd1 no matter which submit button is clicked to
submit the form and no value for cmd2. See example: http://demo.
thinksys.com/cf8/cflayout/
When not in the cflayoutarea it functions like I think it should.
See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm
Anyone have any idea why. I am sure I am just confusing something
because I am really not sure about a lot of the new CF8 stuff.
Thanks in advance for any help.
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285445
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One form with two submit buttons in amp;lt;cflayoutareaamp;gt;
Ok, so I am taking Ray's advice and changing a hidden form variable and
submitting the form with JS. Thing is when I use the normal submit() in JS it
breaks the page out of the original cflayout.
Anyone know how to keep the form in the layout when submitting with JS?
Thanks.
Ray,
Thanks for the help again.
Yeah it is confusing me. I have tried submitting to the same page and
to a different page and it always has the same result. The second
button is ignored.
I don't know what the deal is. At least it is not just me, if it
surprised you then there must really be something wrong.
Thanks again, you are the man.
I have this little bit of code that I am testing with inside of a
cflayoutarea:
cfform name=form1
cfinput name=sku type=text
cfinput type=submit name=cmd1 value=1
cfinput type=submit name=cmd2 value=2
/cfform
cfif isDefined('cmd1')
cfoutput#cmd1#/cfoutput
/cfif
cfif isDefined('cmd2')
cfoutput#cmd2#/cfoutput
/cfif
When inside the cflayoutarea and the form is submitted it always
returns a value for cmd1 no matter which submit button is clicked to
submit the form and no value for cmd2. See example: http://demo.
thinksys.com/cf8/cflayout/
When not in the cflayoutarea it functions like I think it should.
See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm
Anyone have any idea why. I am sure I am just confusing something
because I am really not sure about a lot of the new CF8 stuff.
Thanks in advance for any help.
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285450
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: General UI Question
Just thought I would share a pretty cool way to do this in CF8: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm It is dummy data so feel free to play with it. I have a general question about how people are handling new records to select boxes. I mean if you have a form with a select box that displays values from a database but when the user is filling out the form they need to add a new record to that list. --Example-- Description: textbox Data: datapicker Company: cfselect Details: textbox On this example the user wants to add a new company that is not in the list. They need to be able add a new company. They will need to be able to add the name and all data (like address and phone) that goes with company. I don't have any issues handling the insert part of this. I am just not sure the best way to handle the interface. I have tried lots different ways to do this but I have never really figured out a good way to handle it. Anyone out there have any pointers for me about this. Thanks in advance. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cflayout question in CF 8
Here is a little code I am working on: cflayout type=border cflayoutarea name=top position=top size=50 nbsp; /cflayoutarea cflayoutarea name=left position=left title=Menu collapsible=true splitter=true size=200 cflayout type=vbox cfform name=left_menu cftree name=left_menu vscroll=no hscroll=no border=no cftreeitem display=Link 1 value=1 parent=left_menu expand=no cftreeitem display=Link 2 value=2 parent=left_menu expand=no cftreeitem display=Link 3 value=3 parent=left_menu expand=no /cftree /cfform /cflayout /cflayoutarea cflayoutarea name=main position=center source=main.cfm /cflayoutarea /cflayout What I am trying to do is to have the links in the cftreeitems (link 1, link 2, link 3) change the contents of the cflayoutarea main. I am not sure if using source is the best way to do it. So when link 1 is clicked the main cflayoutarea is changed to link1.cfm and so on. I would like to have the update happen via ajax so the page does not need to be reloaded. Any help on this would be great. Thanks ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflayout question in CF 8
Email never went out for this. Can anyone help? Here is a little code I am working on: cflayout type=border cflayoutarea name=top position=top size=50 nbsp; /cflayoutarea cflayoutarea name=left position=left title=Menu collapsible=true splitter=true size=200 cflayout type=vbox cfform name=left_menu cftree name=left_menu vscroll=no hscroll=no border=no cftreeitem display=Link 1 value=1 parent=left_menu expand=no cftreeitem display=Link 2 value=2 parent=left_menu expand=no cftreeitem display=Link 3 value=3 parent=left_menu expand=no /cftree /cfform /cflayout /cflayoutarea cflayoutarea name=main position=center source=main.cfm /cflayoutarea /cflayout What I am trying to do is to have the links in the cftreeitems (link 1, link 2, link 3) change the contents of the cflayoutarea main. I am not sure if using source is the best way to do it. So when link 1 is clicked the main cflayoutarea is changed to link1. cfm and so on. I would like to have the update happen via ajax so the page does not need to be reloaded. Any help on this would be great. Thanks ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: General UI Question
I also like to have a separate interface for managing the records. So they can add/edit the records. I do however like to give them the ability to add it right on the current page. I have tried many of the ways mentioned to do this but I always seem to get frustrated by them for some reason or another. Thanks for the help! I have a general question about how people are handling new records to select boxes. I mean if you have a form with a select box that displays values from a database but when the user is filling out the form they need to add a new record to that list. --Example-- Description: textbox Data: datapicker Company: cfselect Details: textbox On this example the user wants to add a new company that is not in the list. They need to be able add a new company. They will need to be able to add the name and all data (like address and phone) that goes with company. I don't have any issues handling the insert part of this. I am just not sure the best way to handle the interface. I have tried lots different ways to do this but I have never really figured out a good way to handle it. Anyone out there have any pointers for me about this. Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: General UI Question
In a related question to this, can anyone please help me get started on the best way to do a popup page that inserts the new record and then updates the cfselect on the original page without having to reload the original page. I know how to do the popup and the insert without any issues. I can also send back an ID to the original page of the new record. What I am not sure about is how to update the cfselect value to reflect the newly inserted record without reloading the original page. I am assuming that httprequest will have to be used someway but I am not really sure where to start. Any guidance on this would be great. I have a general question about how people are handling new records to select boxes. I mean if you have a form with a select box that displays values from a database but when the user is filling out the form they need to add a new record to that list. --Example-- Description: textbox Data: datapicker Company: cfselect Details: textbox On this example the user wants to add a new company that is not in the list. They need to be able add a new company. They will need to be able to add the name and all data (like address and phone) that goes with company. I don't have any issues handling the insert part of this. I am just not sure the best way to handle the interface. I have tried lots different ways to do this but I have never really figured out a good way to handle it. Anyone out there have any pointers for me about this. Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
General UI Question
I have a general question about how people are handling new records to select boxes. I mean if you have a form with a select box that displays values from a database but when the user is filling out the form they need to add a new record to that list. --Example-- Description: textbox Data: datapicker Company: cfselect Details: textbox On this example the user wants to add a new company that is not in the list. They need to be able add a new company. They will need to be able to add the name and all data (like address and phone) that goes with company. I don't have any issues handling the insert part of this. I am just not sure the best way to handle the interface. I have tried lots different ways to do this but I have never really figured out a good way to handle it. Anyone out there have any pointers for me about this. Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query in a function
I am not sure if this is possible but here is what I am trying to do. I have a function that queries the database (MSSQL) for all users: cffunction name=getUsers returntype=query access=remote cfquery name=queryUsers datasource=#application.ds# SELECT userID, userType, userAccessLevel, userName, firstName, lastName FROM Users WHERE active = '1' /cfquery cfreturn queryUsers /cffunction I was going to add an argument to it for userID and change the where clause to (WHERE active = '1' and userID = '#arguments.userID#'). That should work fine but what I would like to do is still use the same function to retrive all the users not just the one with the selected userID. I would like to keep it all in the same function without having to use an if clause. The end result would be that if I pass the userID to it I get back a query with just the one record that matches the userID but if I do not pass the userID to it, it returns all of the records. Like I said, I am not sure if this is even possible. Any help on this would be great. Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Submitting form to .cfc page
I am pretty new to using ColdFusion components but I am trying to start doing all my inserts and queries with them. In the past I would always submit my forms to another .cfm page (usually called action). On that page I would do my SQL inserts or whatever and then put a cflocation at the bottom that directed the browser to the proper destination page. I am not really sure if this is best practice coding but it always worked for me. When using components it seems like I should be submitting the form to the .cfc by making it the action page of the form. That all works fine and the database inserts are working but the browser ends up on the .cfc page. I am not sure the best way to redirect to the proper .cfm destination page. Normally the destination page will be different depending on the source page. I hope this all makes sense. Any help on this would be greatly appreciated. Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283510 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Submitting form to .cfc page
Thanks for the help everyone. It all makes sense. I was actually doing it that way but then I read somewhere about submitting directly to the cfc. I am pretty new to using ColdFusion components but I am trying to start doing all my inserts and queries with them. In the past I would always submit my forms to another .cfm page (usually called action). On that page I would do my SQL inserts or whatever and then put a cflocation at the bottom that directed the browser to the proper destination page. I am not really sure if this is best practice coding but it always worked for me. When using components it seems like I should be submitting the form to the .cfc by making it the action page of the form. That all works fine and the database inserts are working but the browser ends up on the . cfc page. I am not sure the best way to redirect to the proper .cfm destination page. Normally the destination page will be different depending on the source page. I hope this all makes sense. Any help on this would be greatly appreciated. Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283516 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
