Re: best way to store search terms entered on a website?
Create two data tables, one for terms (have an term_ID and search_term field) and one for search date/time (have a term_ID and date/time field). I know little about db design, sorry: why would you use 2 tables rather than one with 3 columns? Sure it's helpful. I want to know how many times people search for terms as it helps me figure out what people are searching for. But your description of the task didn't have a counter. Or would just keep adding repeat entries ad infinitum which can't be good. In any case, I don't see how the lastdate used helps me to do much. The term might not be used for a year, then once last week. Doesn't help to see what has been popular this month. My top 10 might be really old searches. I could query so lastdate must be within a recent period, but no more than that. I guess that's enough if no better solution. That's basically why I was asking what people have done and considered a file for each period. Am I missing anything obvious? The userid tip might be nice but we already have a custom bookmark page where the products are determined by users saving them to that page. ~| 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:287023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfform stuck on loading 40%
Hi there, What do you mean by peg? If you mean crash or bottle neck than the answers no because this issue happens 24/7. Any other ideas would be great! Cheers Matthew Does your server peg temporarily around the same time? Respectfully, Adam Phillip Churvis Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com Hi guys, Recently our flash forms stopped working, they keep getting stuck at Loading 40%. I've reversed all updates / changes which were made to the server when they stopped working. Anyone got any ideas? Cheers Matthew ~| 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:287024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL FullText search with CFQUERY?
Make Sure you have the Fields set as Fulltext
Eric
On 8/23/07, Les Mizzell [EMAIL PROTECTED] wrote:
We use MS SQL and utilize full text queries just like any other select
query. I suspect that MySQL will work the same.
So the below should be a valid query then?
cfquery
SELECT field1, field2
FROM myTABLE
WHERE MATCH (field1, field2)
AGAINST ('#form.searchINPUT#')
/cfquery
Will report back on what happens with this...
~|
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:287025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfform stuck on loading 40%
I believe the question related to the CPU usage at the time - if you watch the CPU stats, what happens when a flash form is requested? On 8/24/07, Matthew Chambers [EMAIL PROTECTED] wrote: Hi there, What do you mean by peg? If you mean crash or bottle neck than the answers no because this issue happens 24/7. Any other ideas would be great! Cheers Matthew Does your server peg temporarily around the same time? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:287026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What application platform is this? Could it be CF
[EMAIL PROTECTED] wrote: If someone has a link structure on their site of ... www.site.com/omapps/ContentServer?cid=1058290118806pagename=InvestorRelations%2FPage%2FIR_Standardc=Page What application platform is this? Look at the HTTP headers. Jochem ~| 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:287027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best way to store search terms entered on a website?
Actually, I wrote an article about this for CFDJ, which includes code for a cfc that reports on search terms, auto-mails a weekly (or other period) report, etc.: http://cfdj.sys-con.com/read/48234.htm I'll take a look, thanks for the tip! ~| 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:287028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best way to store search terms entered on a website?
Just have one table, do not worry about the size of the table, it's negligible. If it's a site that requires a login, save their login id, the search term and the date (it does not matter if you intend on using it now, you might later). You do not need a counter, you can count using the SQL query. Good grief. On 8/24/07, stylo stylo [EMAIL PROTECTED] wrote: Actually, I wrote an article about this for CFDJ, which includes code for a cfc that reports on search terms, auto-mails a weekly (or other period) report, etc.: http://cfdj.sys-con.com/read/48234.htm I'll take a look, thanks for the tip! ~| 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:287029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfform stuck on loading 40%
I believe the question related to the CPU usage at the time - if you watch the CPU stats, what happens when a flash form is requested? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ I don't know that this will be a lot of help, but I received that error once. The scenario was as follows: I have a shared hosting account with GoDaddy and a domain of myrootdomain.com. Under the root I had a subfolder to which I pointed another domain (mysubdomain.com). In the subfolder I had a flash form. When I would browse to the flash form like so: http://mysubdomain.com/flashform.cfm, I received the 40% error. However, when I did this: http://myrootdomain.com/mysubfolder/flashform.cfm, it would load normally. What that means, I'm not really sure. I assume it has something to do with the mapping settings for flash forms, but I'm not sure. Obviously, that's not really an answer for your problem, but perhaps it will help others brainstorm better about what could be happening. ~| 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:287030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFCs - no need for mappings
We often create a folder in our application root that contains all components used for the application. We then create a mapping to that folder so that we can invoke components from anywhere within the application. Not happy with this approach (prefer an application that just works when it moves server), I just wrote this little function that you can add to application.cfm that will let you invoke a component method from anywhere in the application. Has this been done before? Any thoughts? Anyways, here it is: cffunction name=GetComponent returntype=any hint=Returns the results of a given CFC method call cfargument name=name type=string required=true hint=Name of the component / cfargument name=method type=string required=false default=init hint=The name of the component method to invoke cfargument name=args type=struct required=false default= #StructNew()# hint=Structure containing invoke method arguments cfargument name=componentsFolder type=string required=false default=_components hint=Folder in root directory in which your components are stored cfinvoke component=#arguments.componentsFolder#.#arguments.name# method=#arguments.method# returnvariable=returnValue cfloop list=#StructKeyList(arguments.args)# index=thisArg cfinvokeargument name=#thisArg# value=#arguments.args[thisArg]# /cfloop /cfinvoke cfreturn returnValue /cffunction Example call: cfset o_myObject = GetComponent(myCFC) This example assumes the component, myCFC, has an init method which takes no arguments. -- Blog it up: http://blog.dominicwatson.co.uk ~| 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:287031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFCs - no need for mappings
On second thoughts, although it does work, I think it would be better to place the code into a file and save that file in the directory where your components live. Then you just get: cffunction name=GetComponent returntype=any hint=Returns the results of a given CFC method call cfargument name=name type= string required=true hint=Name of the component / cfargument name=method type= string required=false default= init hint=The name of the component method to invoke cfargument name=args type=struct required= false default= #StructNew()# hint=Structure containing invoke method arguments cfinvoke component=arguments.name# method= #arguments.method# returnvariable=returnValue cfloop list=#StructKeyList(arguments.args)# index= thisArg cfinvokeargument name= #thisArg# value=#arguments.args[thisArg]# /cfloop /cfinvoke cfreturn returnValue /cffunction ~| 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:287032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCs - no need for mappings
I just create 1 mapping, usually COM, then place things in sub-dirs based on where they came from, and further directories by function. Works good for me, and only 1 mapping. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 11:12 AM To: CF-Talk Subject: Re: CFCs - no need for mappings On second thoughts, although it does work, I think it would be better to place the code into a file and save that file in the directory where your components live. Then you just get: cffunction name=GetComponent returntype=any hint=Returns the results of a given CFC method call cfargument name=name type= string required=true hint=Name of the component / cfargument name=method type= string required=false default= init hint=The name of the component method to invoke cfargument name=args type=struct required= false default= #StructNew()# hint=Structure containing invoke method arguments cfinvoke component=arguments.name# method= #arguments.method# returnvariable=returnValue cfloop list=#StructKeyList(arguments.args)# index= thisArg cfinvokeargument name= #thisArg# value=#arguments.args[thisArg]# /cfloop /cfinvoke cfreturn returnValue /cffunction ~| 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:287033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
fckeditor custom folders
Does anyone know of an easy way to create custom folders for fckeditor? For example the default image folder is /Image Default file folder /File Is there no easy way to customize these folders? my default image folder should be images/images my default file folder should be /documents. I have been searching around but it looks like there is no easy way to do this without hacking away at the file manager templates. -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| 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:287034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFCs - no need for mappings
Java style packaging can solves this. Simply map COM and then you can have component paths similar to: com.mysite.util.StringUtil com.mysite.commerce.CommerceUtil com.shared.util.StringUtil com.myOtherSite.commerce.SomeOtherComponent HTH, Rich ~| 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:287035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFCs - no need for mappings
Do you create a COM mapping the same way as any other, i.e. in Coldfusion administrator? We use hosting and never have access to these things. The only mapping we usually create is the component path one. So, with the little function, there are no mappings at all. Thanks, Dominic On 24/08/07, Rich [EMAIL PROTECTED] wrote: Java style packaging can solves this. Simply map COM and then you can have component paths similar to: com.mysite.util.StringUtil com.mysite.commerce.CommerceUtil com.shared.util.StringUtil com.myOtherSite.commerce.SomeOtherComponent HTH, Rich ~| 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:287037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Link Generator Tool
I'm building a link generator tool that creates links to data driven
glossaries. The theory is the user can cut and paste the link into either
static text on the site, or into text areas on forms to update the data
base. I can handle the quotes, but the #'s are giving me a fit.
I can output a link like:
a href=#
onclick=openPopUp('http://mysite.com/glossary.cfm?glossary=3term=156',
'glossary', '410', '300', '110', '35')
This works fine when it's going into HTML text, but when it's going into a
cf form, the # throws off Cold Fusion. If I use a breaking ##, that work for
cf handling, but isn't right for HTML text.
So I thought I'd try,
a href=javascript:
openPopUp('http://mysite.com/glossary.cfm?glossary=3term=156', 'glossary',
'410', '300', '110', '35)
That works for cut and paste in both CF and HTML text, but it moves the
current page to [Object].
Is there something I can add to the last statement to make the href execute
the openPopUp but leave the current page alone; or is there another option?
Thanks
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be .
~|
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:287038
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reset Administrator Password for version 4.5
Can anybody point out still existing documentation that describes what registry settings one plays with to reset the administrator password for CF4.5? TIA Ian Skinner ~| 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:287036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFCs - no need for mappings
We do also 'package' the components by creating subfolders withing our components folder where neccessary. Is this what you mean? Apologies for the multiple post and thanks again, Dominic ~| 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:287039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform stuck on loading 40%
I have a shared hosting account with GoDaddy and a domain of myrootdomain.com. Under the root I had a subfolder to which I pointed another domain (mysubdomain.com). In the subfolder I had a flash form. When I would browse to the flash form like so: http://mysubdomain.com/flashform.cfm, I received the 40% error. However, when I did this: http://myrootdomain.com/mysubfolder/flashform.cfm, it would load normally. What that means, I'm not really sure. I assume it has something to do with the mapping settings for flash forms, but I'm not sure. Most likely, you did not have a virtual directory for /CFIDE for your mysubdomain.com virtual server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reset Administrator Password for version 4.5
Can anybody point out still existing documentation that describes what registry settings one plays with to reset the administrator password for CF4.5? I don't have any documentation handy, but it's in the vicinity of HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion. It should be pretty easy to find - there isn't much in there unless you're using client variables in the registry. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Link Generator Tool
This works fine when it's going into HTML text, but when it's going into a cf form, the # throws off Cold Fusion. If I use a breaking ##, that work for cf handling, but isn't right for HTML text. I'm not sure what you mean by a breaking ##, but if you simply use two hashes instead of one within your CFOUTPUT, you should have one hash in your generated HTML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update Flash Form Grid with Javascript
I have an involved flash form that I update using getURL() and Spry's loadURL() to update database records without page refreshing. Part of this form is a datagrid which binds its data to the user form. Is there a way, on a javascript callback event from the Spry loadURL(), to also refresh the datagrid data without page reload? BTW, I am using remote cfcs for both the db updating and query. Thanks for everyone's help. Joel Anybody have any ideas on this? ~| 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:287043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Link Generator Tool
if you simply use two hashes instead of one within your CFOUTPUT It's a little more complicated. It can be pasted into a form, which updates a data base that is queried for later output, or it can be pasted straight into HTML static copy. It needs to work for both. I think I've solved it by putting in four . That seems to do it and doesn't seem to mess up the HTML, but I still have to text in XHTML. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Link Generator Tool
Sounds like he's also outputting this straight to HTML as well though.
My suggestion is to completely abstract the linking with javascript. For
example, on my family blog I've got a js function which allows me to use
plain ole HREF links:
a href=slideshow.cfm?slide=58gid=19
onclick=popUp(this.href,'fixedScrolling',800,800);return false;
target=slideShowClick to see a larger photo/a
There's no pound signs in it at all. Here's the function:
function popUp(strURL,strType,strHeight,strWidth) {
var strOptions=;
if (strType==console)
strOptions=resizable,height=+strHeight+,width=+strWidth;
if (strType==fixed)
strOptions=status,height=+strHeight+,width=+strWidth;
if (strType==fixedScrolling)
strOptions=status,scrollbars,height=+strHeight+,width=+strWidth;
if (strType==elastic)
strOptions=toolbar,menubar,scrollbars,resizable,location,height=+strHeight
+,width=+strWidth;
window.open(strURL, 'newWin', strOptions);
}
Hope that helps.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, August 24, 2007 11:03 AM
To: CF-Talk
Subject: RE: Link Generator Tool
This works fine when it's going into HTML text, but when it's going
into a cf form, the # throws off Cold Fusion. If I use a breaking ##,
that work for cf handling, but isn't right for HTML text.
I'm not sure what you mean by a breaking ##, but if you simply use two
hashes instead of one within your CFOUTPUT, you should have one hash in your
generated HTML.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
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:287045
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Link Generator Tool
IIRC, you can return false in the JS call to fix this problem. But
that's a vague memory from years ago.
--Ben Doom
Robert Harrison wrote:
I'm building a link generator tool that creates links to data driven
glossaries. The theory is the user can cut and paste the link into either
static text on the site, or into text areas on forms to update the data
base. I can handle the quotes, but the #'s are giving me a fit.
I can output a link like:
a href=#
onclick=openPopUp('http://mysite.com/glossary.cfm?glossary=3term=156',
'glossary', '410', '300', '110', '35')
This works fine when it's going into HTML text, but when it's going into a
cf form, the # throws off Cold Fusion. If I use a breaking ##, that work for
cf handling, but isn't right for HTML text.
So I thought I'd try,
a href=javascript:
openPopUp('http://mysite.com/glossary.cfm?glossary=3term=156', 'glossary',
'410', '300', '110', '35)
That works for cut and paste in both CF and HTML text, but it moves the
current page to [Object].
Is there something I can add to the last statement to make the href execute
the openPopUp but leave the current page alone; or is there another option?
Thanks
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be .
~|
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:287046
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
replace carraige returns
How would I replace the carriage returns in a textarea entry with br? ~| 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:287047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Link Generator Tool
Here's another option. If I just use a onclick=domyactionThis Term/a That functions almost right. It doesn't move the base page, still does the action, creates a link, eliminates the # issue, etc. What it doesn't do is give me the cursor arrow on mouseover. I'm going to look for a way to force a cursor change on mouseover. That may just do it. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: replace carraige returns
#replace(myTextAreaText, '#chr(13)chr(10)#', 'br /', 'all')# On 8/24/07, Matthew Smith [EMAIL PROTECTED] wrote: How would I replace the carriage returns in a textarea entry with br? ~| 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:287049 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 carriage returns
How would I replace the carriage returns in a textarea entry with br? cfset newstring='#REREPLACE(#REREPLACE(#Trim(form.mystring)#,quot;,,all )#,#chr(13)#,br,all)#' This will do carriage returns and quotes to you can pass the data around in forms. Keep in mind, however, if you stick br into a DB and pull it back to a form for edits later, you need to convert the br back to carriage returns. The string below will do that: #REREPLACE(#myoutputstring#,br,#chr(13)#,all)# Hope that helps. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: replace carraige returns
For what it's worth I usually replace tabs with 5 spaces at the same time. Also, sometimes only a line feed is present with no carriage return, so I will replace carriage return/line feed combinations first, and then replace any remaining solitary line feeds. replacenocase(text,chr(13)chr(10),br /,all) replacenocase(text, chr(10),br /,all) replacenocase(text,chr(09),nbsp;nbsp;nbsp;nbsp;nbsp;,all) ~Brad -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 11:38 AM To: CF-Talk Subject: Re: replace carraige returns #replace(myTextAreaText, '#chr(13)chr(10)#', 'br /', 'all')# On 8/24/07, Matthew Smith [EMAIL PROTECTED] wrote: How would I replace the carriage returns in a textarea entry with br? ~| 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:287051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: replace carriage returns
Thank you, Robert. Exactly what I needed. -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 11:42 AM To: CF-Talk Subject: RE: replace carriage returns How would I replace the carriage returns in a textarea entry with br? cfset newstring='#REREPLACE(#REREPLACE(#Trim(form.mystring)#,quot;,, all )#,#chr(13)#,br,all)#' This will do carriage returns and quotes to you can pass the data around in forms. Keep in mind, however, if you stick br into a DB and pull it back to a form for edits later, you need to convert the br back to carriage returns. The string below will do that: #REREPLACE(#myoutputstring#,br,#chr(13)#,all)# Hope that helps. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCs - no need for mappings
Do you create a COM mapping the same way as any other, i.e. in Coldfusion administrator? We use hosting and never have access to these things. Sorry, I meant to create one mapping to the com folder, and package your other components under it. We do also 'package' the components by creating subfolders withing our components folder where neccessary. Is this what you mean? Exactly. ~| 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:287054 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 carriage returns
If you go that route, I'd offer up the suggestion of cleaning up the extra # signs a bit. cfset newstring = rereplace(rereplace(trim(form.mystring),quot;,, all),#chr(13)#,br,all) / just makes it a bit more readable (IMO). and also God kills a kitty every time you overuse pound signs :) FWIW, regarding the quotes... instead of the nested rereplace, you could just use HTMLEditFormat() to escape 'em on output... and if you're using cfqueryparam, there'd be no issues with them during the database operations (insert/update) :) On 8/24/07, Matthew Smith [EMAIL PROTECTED] wrote: Thank you, Robert. Exactly what I needed. -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 11:42 AM To: CF-Talk Subject: RE: replace carriage returns How would I replace the carriage returns in a textarea entry with br? cfset newstring='#REREPLACE(#REREPLACE(#Trim(form.mystring)#,quot;,, all )#,#chr(13)#,br,all)#' This will do carriage returns and quotes to you can pass the data around in forms. Keep in mind, however, if you stick br into a DB and pull it back to a form for edits later, you need to convert the br back to carriage returns. The string below will do that: #REREPLACE(#myoutputstring#,br,#chr(13)#,all)# Hope that helps. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Link Generator Tool / Problem solved
Problem solved. The trick was to get rid of the href altogether. This string
works in all browsers and passes around fine in CF and DBs or static HTML.
a
onclick=openPopUp('http://myurl.com/glossary.cfm?glossary=1term=2','glossa
ry','410','300','110','35') style=cursor: pointer;This Term /a
Of course, you need the OpenPopUp script as a global for the site... but
that's easy enough.
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be .
~|
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:287055
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 carriage returns
Ok, to make it a bit more difficult... :) How would I ignore inserting carriage returns is the carriage return comes after a ul, li, /li, or /ul? This is so that the site owner can edit the text on the front page of the website themselves. There is a ul in the current text. Thanks! -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 11:42 AM To: CF-Talk Subject: RE: replace carriage returns How would I replace the carriage returns in a textarea entry with br? cfset newstring='#REREPLACE(#REREPLACE(#Trim(form.mystring)#,quot;,, all )#,#chr(13)#,br,all)#' This will do carriage returns and quotes to you can pass the data around in forms. Keep in mind, however, if you stick br into a DB and pull it back to a form for edits later, you need to convert the br back to carriage returns. The string below will do that: #REREPLACE(#myoutputstring#,br,#chr(13)#,all)# Hope that helps. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: replace carriage returns
and also God kills a kitty every time you overuse pound signs :) E. Man, I knew there was a reason I worked so hard to get those # signs out of my glossary link. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287057 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 carriage returns
How would I ignore inserting carriage returns is the carriage return comes after a ul, li, /li, or /ul? If you're letting them enter HTML code, make them enter HTML with their own p tags and br /'s. Either you control it or they write html. It would be a nightmare to mix the two. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287058 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 carriage returns
you should probably start looking at FCKEditor or TinyMCE or the like. You're recreating the wheel here. On 8/24/07, Matthew Smith [EMAIL PROTECTED] wrote: Ok, to make it a bit more difficult... :) How would I ignore inserting carriage returns is the carriage return comes after a ul, li, /li, or /ul? This is so that the site owner can edit the text on the front page of the website themselves. There is a ul in the current text. Thanks! -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 11:42 AM To: CF-Talk Subject: RE: replace carriage returns How would I replace the carriage returns in a textarea entry with br? cfset newstring='#REREPLACE(#REREPLACE(#Trim(form.mystring)#,quot;,, all )#,#chr(13)#,br,all)#' This will do carriage returns and quotes to you can pass the data around in forms. Keep in mind, however, if you stick br into a DB and pull it back to a form for edits later, you need to convert the br back to carriage returns. The string below will do that: #REREPLACE(#myoutputstring#,br,#chr(13)#,all)# Hope that helps. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:287059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Encryption - CAST128(cast5)
Installed Saw the Adobe technote on installing it too. Seems to work. Now I am trying to match the encryption results to my expected results. They are different. I am guessing it a matter of getting apples to apples at this time and it probably has to do with key length or something... Cast5 is variable key up to 128bit encryption. and the tird party app maker needs straight 128. Thanks for your suggestions Jeff On 8/23/07, Tom Donovan [EMAIL PROTECTED] wrote: The Bouncy Castle encryption provider at: http://www.bouncycastle.org/latest_releases.html includes CAST5 and works fine with CF7 or CF8. You want the signed bcprov*.jar which goes with your version of Java. You will also need to get the Unlimited Encryption Strength Jurisdiction Policy files from the Sun download page at: http://java.sun.com/javase/downloads/index.jsp or http://java.sun.com/javase/downloads/previous.jsp (depending on your Java version). The TechNote at http://www.macromedia.com/go/e546373d explains how to install and use both the provider and the jurisdiction files with CF. If you're decrypting something encrypted by other (non-CF) software, you will probably want to read all the TechNote details about feedback modes, padding, IV and Salt. You'll also need the 128-bit key in Base64. If you have the key in hex, you can convert it with: cfset b64Key = ToBase64(BinaryDecode(hexKey, hex)) -tom- J W wrote: I have a project that I have been handed that needs a piece encrypted in CAST128 (Cast5). Has anyone here worked with that encryption method? If so what is the best way to integrate that into Coldfusion. Thanks! Jeff ~| 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:287060 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 carriage returns
You missed one. Wouldn't want to doom any kitten today :) rereplace(rereplace(trim(form.mystring),quot;,,all),chr(13),b r,all) -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 12:00 PM To: CF-Talk Subject: Re: replace carriage returns If you go that route, I'd offer up the suggestion of cleaning up the extra # signs a bit. cfset newstring = rereplace(rereplace(trim(form.mystring),quot;,, all),#chr(13)#,br,all) / ~| 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:287061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
can't log in with client variable on apache virtual host
I have several virtual hosts set up, one for each site. When I try to log into the admin section, which uses a client variable to set log in status, I just keep getting the log in page even after putting in the correct password. The login portion of code is simple: cfset client.adminloggedin = 1 Is there a problem with client variables if you are using virtual hosts? All the virtual hosts have a mapping in my hosts file to 127.0.0.1. ~| 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:287062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: can't log in with client variable on apache virtual host
Is there a problem with client variables if you are using virtual hosts? No. However, you may have some generic problem with cookies due to a misconfiguration of some sort. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: can't log in with client variable on apache virtual host
Are you using sub-domains? It could be a problem with domain cookies. Look in your debugging info or dump the client scope to determine if the adminloggedin variable is really getting set the way you expect. ~Brad -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 1:00 PM To: CF-Talk Subject: can't log in with client variable on apache virtual host I have several virtual hosts set up, one for each site. When I try to log into the admin section, which uses a client variable to set log in status, I just keep getting the log in page even after putting in the correct password. The login portion of code is simple: cfset client.adminloggedin = 1 Is there a problem with client variables if you are using virtual hosts? All the virtual hosts have a mapping in my hosts file to 127.0.0.1. ~| 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:287064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reset Administrator Password for version 4.5
Can anybody point out still existing documentation that describes what registry settings one plays with to reset the administrator password for CF4.5? TIA Ian Skinner My goodness. When I saw this thread, I figured it was a Rick Faircloth post. But I think he's CF4. :) ~| 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:287066 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
The trick here is CF's list functions don't register empty list spots. If you do a ListLen on 1,2,,3 which looks like four spots - it'll return 3. I tend to do a Replace() on strings like that - set ,, to , , - adding a space - and then that way, the list functions will sniff out that position as having a value. You really need to run that Replace() twice, back to back, though - as if you have a spot like it'll replace the first pair of commas, and the second pair of commas, i.e. , ,, , - leaving the middle one still as a 'dead' position. Running the same Replace a second time catches any holdouts. --Scott ~| 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:287067 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
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, ',')#'
~|
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:287069
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
Oh and something I forgot - you'll need to accomodate rows like you mentioned in your example, where what should be the first or last list positions are empty as well. Something like cfif left(string, 1) IS , cfset string = ' ' string /cfif so as to put something (even just a space) in there. ~| 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:287068 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
Re: fckeditor custom folders
I had the need to do this just yesterday. Hacking the files under filemanager/browser/default/connectors/cfm (config.cfm and connector.cfm) as well as filemanager/upload/cfm (config.cfm and upload.cfm) was the ONLY way I could figure out how to do it. Just remember to add this to both config files: config.configDirectories[File] = your directory name; config.configDirectories[Image] = your directory name; config.configDirectories[Flash] = your directory name; config.configDirectories[Media] = your directory name; Then in connector.cfm and upload.cfm replace url.type with this (or set it to that somewhere at the beginning): config.configDirectories[url.type] Worked like a charm for me. ~| 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:287070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Broadcast streaming and ColdFusion
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have done this same exact thing using Coldfusion and Flash Comminication Server which can be viewed at http://ipvideo.niesc.k12.in.us and if you click on Plymouth Community Schools you would be able to hear the Live Football Broadcast at 7:30PM EDT each Friday. I will be upgrading this application to CF7/Flex with FMS in the very near future. Mike Kear wrote: I have been asked to advise an FM radio station I work with on streaming their signal on the web.I dont know a whole lot about it, even though I have had a show of my own streamed for 2 years (i have never been involved in the IT aspect of that radio station. ) I am web master of this station though and we have a site built on CF7/Windows. We have Flash communication server available - is that suitable for streaming a FM broadcast signal out to the web? Last time i looked at this functionality, some years back, the only real way to do it was to use RealAudio Server, but i realise technology has developed a lot since then. Can anyone offer any pointers to where i should go to start learning about the current state of play in streaming an audio signal 24/7? Are there any gotchas related to streaming it through a CF7 site? (although i suspect it has nothing to do with CF and would go to the web server directly rather than through the CF server). -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (MingW32) Comment: GnuPT 2.6.2.1 by EQUIPMENTE.DE Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRs8vannjLHMPlkANAQJ5vAf/Rgyz6Pw4EyTdc2woIHinA1iYzaZhYlWA MJGCFHKWLKgzVQDlS6y+pto+Zss8+wqvK0dV8+frnmdwqvpz6go46AT+wNsI93lY 0a5iZCwdF6nUHFn6HBYIntyeoL03E3t1sqIlcyLCR/NLLk98AtfCbW3/2MMilbv2 1a6WzN7vaLeVzZbWkzTY2sB6PaYZP+rGGGJoQxdCeryEd7ugRmnbPk971/DBx41I D0cXJor16XvN+BlWDDhZERx1j5e3IbybM+mLo5bK+mBub1b0fHB9eWgUFOO78Nyr 4MlXgfSJlc1XCQPKsGUTF0QAbv8ngKXuVEaYi4R3ij8canLBrx8ngw== =kPQr -END PGP SIGNATURE- -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| 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:287071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Parameter 1 of function IsDefined must be a syntactically valid variable name?
I have a rather deeply nested structure set which at one level has an array
in it. I am trying to test that a value is defined with the following code:
isDefined('base.dataSets.user.dataElements.firstName.assertions[1].assertId'
)
However, I am getting the following error message:
Parameter 1 of function IsDefined, which is now
base.dataSets.user.dataElements.firstName.assertions[1].assertId, must be a
syntactically valid variable name.
The error appears to be because of the array element / notation, which
appears to be a valid variable name to me. Can anybody offer a suggestion
on how to test if this value really exists or what I might obviously be
missing here?
Thanks
-- Jeff
~|
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:287072
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: fckeditor custom folders
Dan, sorry, I may have misunderstood your question. Are you saying you want two separate folders in your root, or two separate folders within the same directory? The solution I posted is for the latter ... FCKEditor wants all your stuff in one default folder off the root. Then that default folder would have /images or /documents or /flash, etc. I'm sure using two separate folders off the root can be done -- it just may take a bit more finagling. I posted from the hip without paying attention to what you were asking -- sorry for that. ~| 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:287073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Reset Administrator Password for version 4.5
CF4! Not! I'm up to CF4.5! So there! :o) Rick -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 3:37 PM To: CF-Talk Subject: Re: Reset Administrator Password for version 4.5 Can anybody point out still existing documentation that describes what registry settings one plays with to reset the administrator password for CF4.5? TIA Ian Skinner My goodness. When I saw this thread, I figured it was a Rick Faircloth post. But I think he's CF4. :) ~| 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:287074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL FullText search with CFQUERY?
So the below should be a valid query then?
{deleted for brevity}
I am unfamiliar with the syntax of MySQL full text queries so I can not be
definite however this MSSQL full text query works just fine.
cfquery
SELECT (KEY_TBL.RANK * 1000) AS RANK, field1, field2
FROM myTable AS Sometable INNER JOIN
CONTAINSTABLE(myTable, *, '#SQLSearchString#' ) AS KEY_TBL ON
Sometable.ID = KEY_TBL.[KEY]
WHERE field3= 'A'
/cfquery
If the DB supports the Query syntax then it should run fine.
Best Regards,
Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT 06716
Tel: (203)879-2844
http://www.uxbinternet.com/
http://www.uxb.net/
~|
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:287075
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 Upgrade Install Hangs on Installing Web Connectors
I am trying to upgrade from CF7 to CF8 standard. I get all the way through the install process and it stays on Installing Web Server Connectors forever. I let it run for a few hours even to try it. So I have to kill the process. I then try it again and it will go all the way through but I get a message on the last page that says it was unable to configure my web server connectors and that I will need to do it manually. It says to check and make sure port 51380 or something (can't recall exact port number) is not blocked by a firewall (which it is not).When I try the Web Server Configuration tool it gives me an error about the dll is already being used by another process. So it seems no matter what I do it will not install. anybody run into this problem and found a way to get around 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:287076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Parameter 1 of function IsDefined must be a syntactically valid variable name?
This should work for you: structKeyExists(base.dataSets.user.dataElements.firstName.assertions[1],'assertId') Jake Pilgrim ~| 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:287077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Upgrade Install Hangs on Installing Web Connectors
I am trying to upgrade from CF7 to CF8 standard. I get all the way through the install process and it stays on Installing Web Server Connectors forever. I've noticed a problem when importing the DNS: the DNS is installed correctly, but the system seems to wait indefinitely, until a time limit occurs (apparently 1 min) for every DNS. If you have say 120 DSNs, the whole thing will take more than 2 hours. You can check some install logs (don't remember which one) for confirmation. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:287078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Parameter 1 of function IsDefined must be a syntactically valid variable name?
It does and it gets me around the issue, I just don't get why isDefined would say that is not a syntactically correct variable name. Thanks -- Jeff This should work for you: structKeyExists(base.dataSets.user.dataElements.firstName.assertions[1],'assertId') Jake Pilgrim ~| 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:287079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Passing List of Number to Query, I forget
I forget how to do this. ReturnedZIPs is a variable with comma delimted zip
codes.
I tried valuelist and got an error. Any help would be great thanks.
cfquery name=get_stores datasource=#datasource#
select *
from tblstores_import
where zip IN ('#ReturnedZIPs#')
/cfquery
~|
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:287080
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Passing List of Number to Query, I forget
Assuming zip in the database is number field then it should work without the
single quotes around the variable. I would use a cfqueryparam though:
WHERE ZIP IN (cfqueryparam value=#Variables.ReturnedZIPS#
cfsqltype=cf_sql_numeric list=yes /)
On 8/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
I forget how to do this. ReturnedZIPs is a variable with comma delimted
zip codes.
I tried valuelist and got an error. Any help would be great thanks.
cfquery name=get_stores datasource=#datasource#
select *
from tblstores_import
where zip IN ('#ReturnedZIPs#')
/cfquery
~|
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:287081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Passing List of Number to Query, I forget
I forget how to do this. ReturnedZIPs is a variable with comma delimted zip codes. where zip IN (#preserveSingleQuotes(listQualify(ReturnedZIPs, '))#) Not tested, but should either work or get you on the right track. -Justin Scott ~| 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:287082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Passing List of Number to Query, I forget
WHERE zip IN (#listQualify(returnedZips, ')#)
that second argument of listQualify is a single quote enclosed by double quotes.
On 8/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I forget how to do this. ReturnedZIPs is a variable with comma delimted zip
codes.
I tried valuelist and got an error. Any help would be great thanks.
cfquery name=get_stores datasource=#datasource#
select *
from tblstores_import
where zip IN ('#ReturnedZIPs#')
/cfquery
~|
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:287083
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parameter 1 of function IsDefined must be a syntactically val id variable name?
It does and it gets me around the issue, I just don't get why isDefined would say that is not a syntactically correct variable name. An array member is not a variable. The array itself is the variable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Passing List of Number to Query, I forget
ooh that's better than mine. cfqueryparam for the win.
On 8/24/07, Aaron Rouse [EMAIL PROTECTED] wrote:
Assuming zip in the database is number field then it should work without the
single quotes around the variable. I would use a cfqueryparam though:
WHERE ZIP IN (cfqueryparam value=#Variables.ReturnedZIPS#
cfsqltype=cf_sql_numeric list=yes /)
On 8/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
I forget how to do this. ReturnedZIPs is a variable with comma delimted
zip codes.
I tried valuelist and got an error. Any help would be great thanks.
cfquery name=get_stores datasource=#datasource#
select *
from tblstores_import
where zip IN ('#ReturnedZIPs#')
/cfquery
~|
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:287084
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
Using the list function with CSV files can be an issue since the List
stuff in CF doesn't recognize a blank column. So Something,,, only
returns 1 element.
The other thing is that excel does weird things with CSV files also.
There is a really nice java library called Ostermiller
http://ostermiller.org/utils/ExcelCSV.html
That has a great CSV reader that I have had no trouble getting it to
properly parse any CSV you throw at it.
J.J.
On 8/24/07, Steve Sequenzia [EMAIL PROTECTED] wrote:
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.
~|
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:287086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Parameter 1 of function IsDefined must be a syntactically val id variable name?
Okay, I guess that is an obvious enough answer. Is it quiting time yet? Thanks. -- Jeff It does and it gets me around the issue, I just don't get why isDefined would say that is not a syntactically correct variable name. An array member is not a variable. The array itself is the variable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid bind method with null values
Hey guys, I am having huge difficulty figuring this out. I am trying to get cfgrid to work with bind attriute, along with format=html. I am trying to pass some values to the function (name: get2) along with the required cfgridpage, cfgridpagesize, cfgridsortcolumn, cfgridsortdirection (code attached) I looked at the debugging output and it looks like bind attribute calls the function with GET method with my variables but the values are all set to null (see the debugging output) I can't figure out why. I did a cfdump of arguments before the cfgrid and all values are correct. Please help. Jaysheel ~| 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:287088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid bind method with null values
Are all the values null or only your custom ones? On 8/24/07, Jaysheel Bhavsar [EMAIL PROTECTED] wrote: Hey guys, I am having huge difficulty figuring this out. I am trying to get cfgrid to work with bind attriute, along with format=html. I am trying to pass some values to the function (name: get2) along with the required cfgridpage, cfgridpagesize, cfgridsortcolumn, cfgridsortdirection (code attached) I looked at the debugging output and it looks like bind attribute calls the function with GET method with my variables but the values are all set to null (see the debugging output) I can't figure out why. I did a cfdump of arguments before the cfgrid and all values are correct. Please help. Jaysheel ~| 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:287089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid bind method with null values
i could not get that to work with named attributes myself... i wound up doing it ordered. -jim On 8/24/07, Jaysheel Bhavsar [EMAIL PROTECTED] wrote: Hey guys, I am having huge difficulty figuring this out. I am trying to get cfgrid to work with bind attriute, along with format=html. I am trying to pass some values to the function (name: get2) along with the required cfgridpage, cfgridpagesize, cfgridsortcolumn, cfgridsortdirection (code attached) I looked at the debugging output and it looks like bind attribute calls the function with GET method with my variables but the values are all set to null (see the debugging output) I can't figure out why. I did a cfdump of arguments before the cfgrid and all values are correct. Please help. Jaysheel ~| 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:287090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Model Glue
Since I know we have a few Model Glue gurus here...I need to learn it for an upcoming project at work. Can an of you all suggest some books and other resources that are good? Thanks in advance. Eric ~| 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:287091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFUNITED News: Chicago early bird ends 8/31/07, Europe-08 speakers, Fusebox docs, Spry for Ajax
Here is ColdFusion and Fusebox news * CFUNITED/Express Chicago (aka CF_Underground) early bird ends 8/31/07 * CFUNITED/Europe-08 call for speakers ends 8/24/07 * Adobe's Damon Cooper on ColdFusion 8 and CFUNITED * CFUNITED podcasts - Simon Horwith - Object Think - Common Sense Software Architecture * Fusebox 5 documentation update * Fusebox core file help and bug reports * CFUNITED Interview - with Andrew Powell on Integrating Spry and ColdFusion. * CFUNITED/Express Chicago (aka CF_Underground) early bird ends 8/31/07 Ever experienced CF_Underground? The pre-MAX ColdFusion meeting held by TeraTech has renamed its event to CFUnited/Express Chicago-07 this year. We are holding this event in CFUnited fashion and we are bringing to you some great speakers and time to get to know other developers like you. Date: Sunday Sept 30th, 2007 Where: downtown Chicago Cost: $149 before 8/31/07 (and get a $50 discount as a user group member) Plus If you register for CFUnited Express Chicago before August 31st you can use 100% of your registration towards CFUnited 2008! After that you can only use 50% of your registration cost towards CFUnited 2008 Register now! Limited Seating. Great materials, goodies, free lunch, drinks, and more. http://cfunitedexpress.com/go/chicago/2007/ Speakers: * Charlie Arehart * Raymond Camden (Tentative) * Adam Howitt * Patrick Quinn * Michael Smith * CFUNITED/Europe-08 call for speakers ends 8/24/07 The call for speakers for CFUNITED Europe ends today 8/24/07. More info and how to suggest a topic or speaker at http://europe.cfunited.com/ CFUnited/Europe Date: March 12-13 2008 Location: Novotel London West, UK. Cost: $749 plus VAT until 10/31/07, after that it will be $849. ($749 USD is approximately UKP 374 or Euros 565) Registration: http://europe.cfunited.com/ * Adobe's Damon Cooper on ColdFusion 8 and CFUNITED Thanks Damon for your mention of your CFUNITED experience in your blog entry about the making of ColdFusion 8 Members of our team recently attended the CFUnited Conference, and after breakout session on Ajax,they were mobbed, recalled Cooper. Many of the 600 developers who attended those sessions, as well as others at the conference, wanted to know how ColdFusion 8 was built, how we did it. Some of our guys felt like rock stars. Full article at: http://www.dcooper.org/blog/client/index.cfm?mode=entryentry=22197BB5-4E22-1671-5276250EC40723FD * CFUNITED podcasts - Simon Horwith - Object Think - Common Sense Software Architecture Object Think is a technique for object modeling applications. It is the foundation for designing applications using S.A.M., a methodology that Simon adopted largely from the techniques taught in Streamlined Object Modeling and purist theories on OOP. Object Think is, in Simon's own words, the most important skill that a software architect could have at their disposal. Its goal is to demystify design patterns and lead to better software design by teaching architects how to think and by making common sense out of architectural best practices. http://cfunited.com/blog/index.cfm/2007/7/4/Simon-Horwith--Object-Think--Common-Sense-Software-Architecture * Fusebox 5 documentation update Thanks to volunteers including Joe Craven for updating the Fusebox 5 documentation on the wiki. If you want to read or contribute go to: http://fusebox.org/go/learning-fusebox/documentation * Fusebox core file help and bug reports Also if you want to contribute to the core files see http://trac.fuseboxframework.org/fusebox/wiki/FuseboxCoreFiles Although we believe that adding custom lexicons is the way to go because additions and/or changes to the core XML language should be rare and considered extremely carefully. Adding verbs or even attributes makes Fusebox more complex and harder to learn (as well as making the core files harder to maintain). That page also talks about contributing patches and what is involved in becoming a committer. You can also report bugs on the trac site. * CFUNITED Interview - with Andrew Powell on Integrating Spry and ColdFusion. Michael Smith: This time we are talking with Andrew Powell about his CFUNITED-07 talk Integrating Spry and ColdFusion. So why should a developer learn Spry Andrew? Andrew Powell: Anyone who wants to leverage the power of AJAX, but is JavaScript adverse, needs to learn about Spry. I will show developers how to leverage the Spry framework for AJAX to create dynamic new user interfaces for their ColdFusion applications with a minimal to no JavaScript required to be written by the developer. Developers will learn techniques that they can use as soon as they leave the session to enhance their user experiences and quickly bring the power of AJAX to their applications. MS: That is good as JavaScript can be a bit picky at times! What is AJAX and why would I want to use it in a web app? AP: AJAX (Asynchronous Javascript And XML) is nothing new. It
Re: Model Glue
there's a web site. with forums. and a mailing list. http://model-glue.com/ http://model-glue.com/forums/ http://groups.google.com/group/model-glue altho the forums aren't looking too terribly popular :) On 8/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Since I know we have a few Model Glue gurus here...I need to learn it for an upcoming project at work. Can an of you all suggest some books and other resources that are good? Thanks in advance. Eric ~| 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:287093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML to Excel
- permitinfo - permit - permitdetail statusApproved/status areanameNorthern Utah/areaname descriptionGarage/description numberHON07032905/number date03/29/2007/date value22000/value /permitdetail /permit - permit - permitdetail statusApproved/status areanameNorthern Utah/areaname descriptionGivens Home/description numberCC-07-004/number date03/20/2007/date value139000/value /permitdetail /permit /permitinfo Changing the dates to 4 digit years seemed to help the date field but some of the fields still show errors. In excel, you get a prompt: the specified xml source does not refer to a schema. Excel will create a schema based on the xml source data. Can I somewho provide that schema automatically? On 8/23/07, Dominic Watson [EMAIL PROTECTED] wrote: XMLTransorm() takes some XML and applies an XSLT Stylesheet to it, returning the transformed XML. An XSLT transformation will always output another XML document so XMLTransform() is not what you need. A schema is a set of rules for a particular flavour of XML for it to validate against. I.e. XHTML has a schema and when you validate your XHTML web pages on W3C or the like, you are validating against that schema. I'd say you're only problem is getting that date to appear correctly. I've never exported XML to excel so I'm curious as to what your XML looks like. Could you post a sample? Dominic On 23/08/07, Dave Watts [EMAIL PROTECTED] wrote: I want to make an xml file available to my clients that they can easily import into excel. I can generate the xml file no problem and it imports into excel pretty good, but some of the date fields give the little exclamation mark, because excel doesn't know them to be date fields. Do I use xmltransform to attach a stylesheet? I can use an xsd file and define the datatypes, but I am getting confused on the difference between a stylesheet and a schema and how to use xmltransform. This is my first foray into xml. What do you see if you export from Excel to XML? If you're generating the XML yourself, you don't need to transform it; just generate what you need in the first place. Stylesheets (CSS/XSL) are used to format or transform XML. Schemas are used to validate XML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfdiv query output
Can I gind a cfdiv to a query so that the div area will only show if there are query results. I want to bind it to a select box for instance. So if I choose a value from the select dropdown, then the div shows my nicely formatted cfoutput block with query results inside. I could pull in a different page with the cfselect value in the url, then the page would call the query with the URL value as the filter, but I would rather not have to create a seperate page. Possible? TIA, -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ~| 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:287095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML to Excel
In excel, you get a prompt: the specified xml source does not refer to a schema. Excel will create a schema based on the xml source data. Can I somewho provide that schema automatically? Sure: permitinfo xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=http://urlpath/to/yourexcelschema.xsd; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML to Excel
Dave, THank you. That is what I was looking for. I think I can figure it out from here. I need to learn xslt and all that, but I was stuck trying to figure out how to get that info in there using the CFXML tag. Easy as inserting it in my root element as per your example. Thanks again, off to play with this some more. On 8/24/07, Dave Watts [EMAIL PROTECTED] wrote: In excel, you get a prompt: the specified xml source does not refer to a schema. Excel will create a schema based on the xml source data. Can I somewho provide that schema automatically? Sure: permitinfo xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=http://urlpath/to/yourexcelschema.xsd; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:287097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid bind method with null values
i could not get that to work with named attributes myself... i wound up doing it ordered. -jim Hey Jim, I am not sure what you mean by this. ~| 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:287099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid bind method with null values
Yes, all my values were null, and for some reason one of the values passed showed more null values than what should have been there. So I changed all the variable names used in cfgrid tag. Now I don't get any error messages, but I don't get anything at all. Its just an empty grid. I ran the query in mysql directly with the values passed from the form, and I get 388 rows returned. I ran the page with query attribute in cfgrid instead of bind attribute and I get the right result (except that my header is all screwed up, but I will deal with it later.). But I don't get any result back with bind attribute, and no errors in the logs or in the AJAX debug window. I don't even see the query execution in regular cfdebug output either (but i guess thats because of the way bind calls my query). I have attached my code for both the query function and the display function. Please take a look and tell what is it that I am doing wrong. I don't see anything wrong. --- code for query cffunction name=get2 access=remote returntype=struct hint=Query database based on user input cfargument name=lib_id type=numeric default=0 required=false cfargument name=e_val type=numeric default=0.00 required=false cfargument name=b_db type=string default= required=false cfargument name=seq_name type=string default= required=false cfargument name=seq_desc type=string default= required=false cfargument name=organism type=string default= required=false cfargument name=page type=numeric required=yes cfargument name=pageSize type=numeric required=yes cfargument name=gridsortcolumn type=string required=no default= cfargument name=gridsortdir type=string required=no default= cfset dbLen = listLen(b_db) cfset orCount = 0 cfquery name=q datasource=#application.dsn# SELECT distinct s.sequenceName, s.sequenceId, s.sequenceLen, b.blastDb, h.hitDef, h.hitAccession, h.hitIdentification, hs.hspEvalue, (hs.hspPositive/hs.hspAlignLen)*100 as 'perPositive', (hs.hspIdentity/hs.hspAlignLen)*100 as 'perIdentity', hs.hspAlignLen, hs.hspBitScore FROMlibrary l inner join sequenceInfo s on l.libraryId = s.libraryId inner join blast b on s.sequenceId = b.sequenceId inner join hit h on b.blastId = h.blastId inner join hsp hs on h.hitId = hs.hitId WHERE hs.hspEvalue = #e_val# and b.orf = 0 and s.deleted = 0 and hs.tophitFlag = 1 cfif libraryId and l.libraryId = #lib_id# /cfif cfif blastDb.length() and ( cfloop index=idx list=#b_db# cfset orCount = orCount + 1 b.blastDb = cfqueryparam cfsqltype=cf_sql_varchar value=#idx# cfif orCount lt dbLenor/cfif /cfloop ) /cfif cfif seq_desc.length() and h.hitDef like '%#seq_desc#%' /cfif cfif seq_name.length() and s.sequenceName like '%#seq_name#%' /cfif cfif ARGUMENTS.gridsortcolumn NEQ and ARGUMENTS.gridsortdir NEQ ORDER BY #ARGUMENTS.gridsortcolumn# #ARGUMENTS.gridsortdir# /cfif /cfquery cfreturn QueryConvertForGrid(q, ARGUMENTS.page, ARGUMENTS.pageSize) /cffunction
Transfer Download
riaforge.org is down for me and I'm after a copy of the latest Transfer files, can anyone help out or point to an alternate download? Thanks. Adrian ~| 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:287100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Transfer Download
Adrian, Have you tried exporting from SVN: http://svn.riaforge.org/transfer It may work? Mark On 8/25/07, Adrian Lynch [EMAIL PROTECTED] wrote: riaforge.org is down for me and I'm after a copy of the latest Transfer files, can anyone help out or point to an alternate download? Thanks. Adrian ~| 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:287101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: best way to store search terms entered on a website?
You seriously just keep adding row upon (duplicate) row every day for years and years? That's a hell of a lot of rows because people search a lot. I'm surprised, but I'm no expert. If no one thinks that's a bad idea... Thanks again. ~| 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:287102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Transfer Download
Cheers Mark, but still no luck. Can anyone else not see riaforge.org in anyway? -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: 25 August 2007 02:13 To: CF-Talk Subject: Re: Transfer Download Adrian, Have you tried exporting from SVN: http://svn.riaforge.org/transfer It may work? Mark On 8/25/07, Adrian Lynch [EMAIL PROTECTED] wrote: riaforge.org is down for me and I'm after a copy of the latest Transfer files, can anyone help out or point to an alternate download? Thanks. Adrian ~| 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:287103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: best way to store search terms entered on a website?
Yes, but the rows are not (duplicate). The time, the search string. Potentially the IP address. in combination, always unique. On 8/24/07, stylo stylo [EMAIL PROTECTED] wrote: You seriously just keep adding row upon (duplicate) row every day for years and years? That's a hell of a lot of rows because people search a lot. I'm surprised, but I'm no expert. If no one thinks that's a bad idea... Thanks again. ~| 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:287104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Transfer Download
It is coming up for me. On 8/24/07, Adrian Lynch [EMAIL PROTECTED] wrote: Cheers Mark, but still no luck. Can anyone else not see riaforge.org in anyway? -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: 25 August 2007 02:13 To: CF-Talk Subject: Re: Transfer Download Adrian, Have you tried exporting from SVN: http://svn.riaforge.org/transfer It may work? Mark On 8/25/07, Adrian Lynch [EMAIL PROTECTED] wrote: riaforge.org is down for me and I'm after a copy of the latest Transfer files, can anyone help out or point to an alternate download? Thanks. Adrian ~| 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:287105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Transfer Download
Yup, it's back up for me too. Just got sent some files also. Thanks all. Adrian -Original Message- From: Aaron Rouse Sent: 25 August 2007 03:19 To: CF-Talk Subject: Re: Transfer Download It is coming up for me. On 8/24/07, Adrian Lynch [EMAIL PROTECTED] wrote: Cheers Mark, but still no luck. Can anyone else not see riaforge.org in anyway? -Original Message- From: Mark Mandel Sent: 25 August 2007 02:13 To: CF-Talk Subject: Re: Transfer Download Adrian, Have you tried exporting from SVN: http://svn.riaforge.org/transfer It may work? Mark On 8/25/07, Adrian Lynch [EMAIL PROTECTED] wrote: riaforge.org is down for me and I'm after a copy of the latest Transfer files, can anyone help out or point to an alternate download? Thanks. Adrian ~| 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:287106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 7 parse large EDI file
Hello,
I need to import a large 2 megs or so 271 EDI file into sql tables. EDI files
are not fun to parse, but I have it working fine. The problem is speed. It is
slow to me... 61 sec to parse 80k file (171 records).
Any ideas on how to improve it? This will be moved to a hosted site, I was
told that the site limits java calls.
BTW thanks Ray for a great udf..
Thanks in advance.
-David
Below is the code:
!--- Set the path from this template ---
cfset request.path = getDirectoryFromPath(GetBaseTemplatePath())
\download\
!--- Write the uploaded file from the form page to the path and as
uploadedfile.csv ---
!--- cffile action=UPLOAD destination=#request.path#271toparse.edi
nameconflict=OVERWRITE filefield=form.uploadfilename ---
cfscript
/**
* Fixes a list by replacing null entries.
* This is a modified version of the ListFix UDF
* written by Raymond Camden. It is significantly
* faster when parsing larger strings with nulls.
* Version 2 was by Patrick McElhaney ([EMAIL PROTECTED])
*
* @param list The list to parse. (Required)
* @param delimiter The delimiter to use. Defaults to a comma. (Optional)
* @param null Null string to insert. Defaults to NULL. (Optional)
* @return Returns a list.
* @author Steven Van Gemert ([EMAIL PROTECTED]@placs.net)
* @version 3, July 31, 2004
*/
function listFix(list) {
var delim = ,;
var null = NULL;
var special_char_list = \,+,*,?,.,[,],^,$,(,),{,},|,-;
var esc_special_char_list = \\,\+,\*,\?,\.,\[,\],\^,\$,\(,\),\{,\},\|,\-;
var i = ;
if(arrayLen(arguments) gt 1) delim = arguments[2];
if(arrayLen(arguments) gt 2) null = arguments[3];
if(findnocase(left(list, 1),delim)) list = null list;
if(findnocase(right(list,1),delim)) list = list null;
i = len(delim) - 1;
while(i GTE 1){
delim = mid(delim,1,i) _Separator_ mid(delim,i+1,len(delim) -
(i));
i = i - 1;
}
delim = ReplaceList(delim, special_char_list, esc_special_char_list);
delim = Replace(delim, _Separator_, |, ALL);
list = rereplace(list, ( delim )( delim ), \1 null \2,
ALL);
list = rereplace(list, ( delim )( delim ), \1 null \2,
ALL);
return list;
}
/cfscript
cfset filename = 271toparse.edi
!--- ---
cffile action=READ file=#request.path#271toparse.edi variable=edifile
!--- cffile action=READ file=#path##filename# variable=edifile ---
cfset edifile = replacenocase(edifile,~st,|,all)
cfset qryEdiData = queryNew(rectype,recnumber,segtype,segmentdata)
cfloop index=records list=#edifile# delimiters=|
cfif ListGetAt(listgetAt(records,1,~),1,*) EQ 271
cfloop index=segments from=2 to=#listLen(records,'~')#
cfset queryaddrow(qryEdiData,1)
cfset
querySetCell(qryEdiData,recType,trim(ListGetAt(listgetAt(records,1,~),1,*)))
cfset
querySetCell(qryEdiData,recnumber,trim(ListGetAt(listgetAt(records,1,~),2,*)))
cfset
querySetCell(qryEdiData,segtype,trim(ListGetAt(ListGetAt(records,segments,~),1,*)))
cfset
querySetCell(qryEdiData,segmentdata,trim(ListGetAt(records,segments,~)))
/cfloop
/cfif
/cfloop
cffunction name=InsertData access=private output=No returntype=void
cfargument name=patientProfileID required=Yes type=numeric
cfargument name=TransSetControlNumber required=Yes type=numeric
cfargument name=HLIDno required=Yes type=numeric default=0
cfargument name=segData required=Yes type=string
cfargument name=batchID required=Yes type=string
cfset var qryInsertData =
cfset var strSegType =
cfset var cfarr1 =
cfset strSegType = listfirst(arguments.segData,*)
cfswitch expression=#strSegType#
cfcase value=BHT
cfquery name=qryInsertData
datasource=mevs
insert into tbl_bht
(patientProfileID,TransSetControlNumber,SubScriberStrutCode,PurposeCode,SubmitterTransId,TransCreateDate,TransCreateTime)
values
(#arguments.patientProfileID#,'#arguments.TransSetControlNumber#',
cfloop index=fields
list=#arguments.segData# delimiters=*
cfif fields neq
listFirst(arguments.segData,*)
cfif isDate(fields)
'#dateformat(fields,'mm/dd/yy')#'
cfelse
'#fields#'
cfif fields neq listlast(arguments.segData,*),/cfif
Re: CF 7 parse large EDI file
oi... HIPAA docs. Good luck with that. Honestly, you'd likely be better off using GenTran, EXTOL, Sterling, whatever to do your translation. But then, I used to work with the EXTOL team, so I'm biased ;). I interviewed for a job in Pittsburgh for Northrop that used CF to manage several aspects of their operations, but still used a translator for their EDI. At least it's a smaller EDI doc. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:287108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Link Generator Tool / Problem solved
I'm a little late here, but you could also do
a href=javascript:; onClick=action()link/a
Problem solved. The trick was to get rid of the href altogether. This string
works in all browsers and passes around fine in CF and DBs or static HTML.
a
onclick=openPopUp('http://myurl.com/glossary.cfm?glossary=1term=2','glossa
ry','410','300','110','35') style=cursor: pointer;This Term /a
Of course, you need the OpenPopUp script as a global for the site... but
that's easy enough.
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be .
~|
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:287109
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
