Coldfusion 7 - Flash Forms
Has anybody been working with the flash form type in Coldfusion 7? If so can anybody help me by explaining how I can use conditional statements within this type of form? i.e. do this. Can't seem to get these statements to work. Anybody know what I am doing wrong or can you point me to any good tutorials for these types of forms? Many thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFFILE & Coldfusion code
Hi, I am trying to dynamically create .cfm pages. I am using the CFFILE 'Write' attribute but I am having problems when trying to write Coldfusion code out to the file, it apears that the Coldfusion code is evaluated before the write takes place and I get an error. How can I write out Coldfusion code to a text file without getting these errors? Many thanks, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cflogin tag and the browser back button
Rebecca, I cannot really add any insight on this issue as I have a similar problem. I have looked at the Hal Helm's 'Kill your back button' article and I would like to implement it. I am using Fusebox 4.1 (newbie, just getting started!) and would be very interested in seeing how you adapted Hal's solution into the Fusebox 4 framework, could I trouble you to mail me the zip file that you mentioned? I have created a GMail account called [EMAIL PROTECTED] I would very much appreciate it. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ActionScript errors not returning anything?
>If I'm setting up a flash cfform and have ActionScript errors, I don't >get an error or anything at all. The entire form will just disappear >until I either fix or remove the bad ActionScript. I read somewhere >that you need to define the height attribute in the tag to >view the ActionScript errors, but that still just leaves me with a >blank page. The source code shows that it's embedding a flash .cfswf, >but nothing appears on the page. This happens on IE, Firefox and >Safari. Is there a setting I'm missing for this somewhere or is this >just how CF7 works at the moment? I know that there is a setting in CF7 admin for showing flash form errors, maybe that is what you need? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ActionScript errors not returning anything?
Something went wrong with my last post. In CF7 admin there is an option under debugging that allows Coldfusion to display actionscript errors in the browser when compiling flash forms. Don't suggest using this too much as it really slows down the pages but maybe this is the setting that need? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Web Based Mail Merge? (not email!)
Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; We have a web based product that a number of our clients use to store information specific to them. From time to time they want to be able to use that information to produce letters. The way that this is currently done is that they download the information that they require in a comma seperated file and then use Microsoft Word to perform a mail merge using the CSV as a data source, with me so far? What I need to know is if it is possible, and if so how, to be able to carry out this same type of mail merge on line and then have the choice of printing or downloading the completed word documents as a file, i.e. is it possible to run the same mail nmerge process on the web server? If so can anyone point me to a source of info for this? Alternatively would anyone know of any other way to acheive this whole letter/mail merge process efficiently? Any advice greatly apreciated, ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
Thanks, this looks interesting. This would be ideal if all of the word document formatting was converted also, i.e. page breaks, header, footer, etc. I could then run m y mailmerge against the HTML page and print that off! Maybe wishful thinking!. Would you be able to point me any resource that demonstrates how to do a word mail merge using ASP? Is it actually possible to execute an ASP page from Coldfusion? I would simply need to be able to pass a document template and datasource to word, do a mail merge and then save the result to a file that the user could download and print themselves as word documents, this would be ideal. You can tell it is a Saturday, plenty time to come up with these wish lists! > See this page how to convert a word document to html (as an example) > http://livedocs.macromedia. > com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. > htm?context=ColdFusion_Documentation&file=1585.htm > > Always remember that you have to have Word installed on the server > (obvious I know) > > MD > > On Apr 2, 2005 11:01 AM, James Holmes <[EMAIL PROTECTED] > au> wrote: > > A COM object may be able to do the same work directly in CF. > > > > -Original Message- > > From: Mark Drew [mailto:[EMAIL PROTECTED] > > Sent: Saturday, 2 April 2005 5:50 > > To: CF-Talk > > Subject: Re: Web Based Mail Merge? (not email!) > > > > Hya > > I know this isnt a LOT of help, but a while back I did some stuff > like this > > using ASP. > > > > Basicaly in ASP you can create a server object (like an instance of > MS > > Word) and then run commands against it. How that translates to CF I > dont > > know. > > > > If it cant be done with CF have a look at ASP and CF could trigger > an ASP > > page to do the merge and then pick up the results > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
I did something like this some time ago, I created the word document, put place holders in for my data, saved it as an rtf file. I then had to copy the RTF text into a .cfm page, process my place holders to put my text in and then save the RTF text back out to another file. This worked well. This was fine when I could control content of the document. Where this requirement now differs is that I want the user to create their own RTF documents and then upload them to our web server into a template directory. Let me run this idea by you, If I provide the user with a list of pre-defined merge field codes, i.e. the coldfusion code that maps to a required peice of data in the database, so that they can create their very own RTF documents, let them upload the document to the template directory on the server, I could then read the RTF file line by line to replace the merge fields with data and write out completed letters to another file. Does anybody see any problems with this idea? Are text file read & writes much of an overhead for the server? I envisage that anywhere between 1 - 300+ letters may need to be produced at any one time. you could generate RTF files on the files. add <> to a word document - save as RTF and us CF to generate RTF and make available for download. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Mystified about select box
shot in the dark, do you not have to close the tag i.e. selected>Yes From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Tue 05/04/2005 19:44 To: CF-Talk Subject: Mystified about select box I am mystified about this one: Part A: billable=#billable# print yes print no (billable is always yes or no) Part B: selected> Yes selected> No Part A works fine, indicating variables and data ok. Part B does not work, and I use the exact same method a little further down in the form. Can anyone see an error??? TNX if you can help. Richard Colman ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201566 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFGRIDCOLUMN - wrap text?
I am using a flash cfform that contains a cfgrid. Does anyone know how to get text to wrap inside of a cfgridcolumn? I cannot see anything that will control it, long lines of text simply run on one line and all of the text cannot be seen? help! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202162 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFGRIDCOLUMN - wrap text?
I was afraid that somebody would say that. If this is indeed the case then this will be enough to shelve the upgrade to CF7. Pretty pointless having a grid that does not wrap text don't ya think? May as well just use a table and save my money! From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Tue 12/04/2005 08:40 To: CF-Talk Subject: Re: CFGRIDCOLUMN - wrap text? On Apr 11, 2005 10:01 PM, Andy Mcshane <[EMAIL PROTECTED]> wrote: > I am using a flash cfform that contains a cfgrid. Does anyone know how to get > text to wrap inside of a cfgridcolumn? I cannot see anything that will > control it, long lines of text simply run on one line and all of the text > cannot be seen? help! I fought with this for a long time, and have come to the conclusion that it's not possible. I would love to be proven wrong though! -- Kay Smoljak http://kay.smoljak.com/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Javascript Question. JS Wizards needed!
I cannot believe this thread! If in your opinion you think that someone has been "lazy" and asked a question that you feel that they have not done any reasearch on then don't bother to reply to it! It's that simple. There has been more time spent flaming this poor guy than it actually took to answer the question in the first place. We all get code blind sometimes and even Google can add to the problem instead of helping you solve it so. It can be time saving to post the question to the forum, if only for someone to "kindly" point out the simple solution that may be staring you in the face! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Javascript Question. JS Wizards needed!
Yeah, let's all be friends again and move on :-) From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thu 14/04/2005 23:45 To: CF-Talk Subject: Re: Javascript Question. JS Wizards needed! c'mon people...micha was mean and now everyone's mad at him. we get it. let's move this over to cf-whogivesacrapanymore :) On 4/14/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > I agree as well. And this is coming from someone that probably holds the > HoF record on asking basic questions. > > Sometimes a berating is warranted, but not on this one. > > Will > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: translating websites
I have done exactly this using XML. All of the English text that appears on my site is held within tables in a SQL database. I have a Coldfusion interface for these tables that allows access to this text for translating into any language that I choose. From this same interface I then generate XML files for each language using the following naming convention, English.xml, Spanish.xml, etc. In my coldfusion page, where I want to display the relevant text I place a call to a translate function which does a search of the XML file that I specify and returns the appropriate text. This means that I have only one Coldfusion page that can be seen in many different languages. It is a little more complex than I have stated here but this is one method to do it. My site is a multi-lingual site and I display the required text based on the language that a user specifies. The only drawback that I have so far found with this method is that you sometimes get your text display screwed up depending on the size of the translated text, but this is a very small problem indeed, but I would suggest XML as a good solution to your requirements. From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Thu 21/04/2005 17:32 To: CF-Talk Subject: translating websites I don't know if CF has any native way to do this, but the company I work for is looking for a way to translate the website to Spanish. Surely you wouldn't have to do a page for page translation? If anyone has worked with doing this sort of stuff, let me know. Thanks, Brian ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203832 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: translating websites
Tommorrow when I am less tired (it's just after 9pm for me, long day!) I will gladly share some examples of how I solved my particular language issue. The main benefit that I see of the way that I have approached this problem makes it incredibly easy for me to add additional languages as required, all of the really hard work has already been done i.e. presentation, generation of XML files, etc. Because of the web based interface for translating the text it is very easy for me to get somebody to translate everything as required. From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thu 21/04/2005 18:43 To: CF-Talk Subject: RE: translating websites What I did was replaced all my DISPLAYED TEXT as variables And have a file with all the variables setup for the given language. Such as: If the locale is Spanish, then it calls the es-es.cfm file with all The Spanish Translations. If the locale is English, then it calls the en-us.cfm file with all The English Translations. This way I maintain ONE website and 2 language files. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, April 21, 2005 1:29 PM To: CF-Talk Subject: RE: translating websites Hi, Andy... I had a client ask about year ago if something like this could be done without creating multiple sites, each in a different language. I couldn't think of a way to do it. Seems like you've solved the problem nicely. Would you mind sharing some of your code / files / techniques...perhaps a small sample of how you do it? Unfortunately, I know very little about using XML, although I've read some about it, and haven't used it before. Any insight you'd be willing to give would be much appreciated! A first question would be...why would involving XML be helpful? Why not just have someone do that translations and put them into a database? Thanks, Rick -------- From: "Andy Mcshane" <[EMAIL PROTECTED]> Sent: Thursday, April 21, 2005 1:03 PM To: CF-Talk Subject: RE: translating websites I have done exactly this using XML. All of the English text that appears on my site is held within tables in a SQL database. I have a Coldfusion interface for these tables that allows access to this text for translating into any language that I choose. From this same interface I then generate XML files for each language using the following naming convention, English.xml, Spanish.xml, etc. In my coldfusion page, where I want to display the relevant text I place a call to a translate function which does a search of the XML file that I specify and returns the appropriate text. This means that I have only one Coldfusion page that can be seen in many different languages. It is a little more complex than I have stated here but this is one method to do it. My site is a multi-lingual site and I display the required text based on the language that a user specifies. The only drawback that I have so far found with this method is that you sometimes get your text display screwed up depending on t he size of the translated text, but this is a very small problem indeed, but I would suggest XML as a good solution to your requirements. From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Thu 21/04/2005 17:32 To: CF-Talk Subject: translating websites I don't know if CF has any native way to do this, but the company I work for is looking for a way to translate the website to Spanish. Surely you wouldn't have to do a page for page translation? If anyone has worked with doing this sort of stuff, let me know. Thanks, Brian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203900 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: translating websites
Yes Tony, exactly as I do it (with the exception of the application.cfc, not got round to using that yet!), works like a charm! :-) From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thu 21/04/2005 20:03 To: CF-Talk Subject: Re: translating websites i did the same exact thing, but rather than do the lookups/translations all the time, i do it once onApplicationStart (using the new application.cfc) read the translations into memory, and then whenever i need to display a label i make that call to the application variable structure that is the locale the user has selected. and just like andy, i have an english.xml and a spanish.xml, and could add any others to the mix. and rick... its as simple for me as... Hello and then a corresponding spanish one... Hola . tony On 4/21/05, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Not just in reference to language XML...but do you have something > that generates the XML for you or do you have to type out > the XML pages yourself? > > Rick > > > From: "Adkins, Randy" <[EMAIL PROTECTED]> > Sent: Thursday, April 21, 2005 2:10 PM > To: CF-Talk > Subject: RE: translating websites > > XML works just as fine. I did not decide to do a database table > for the translations. Might have been better but it works just > as good. > > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 21, 2005 1:50 PM > To: CF-Talk > Subject: RE: translating websites > > Sounds good...but why the XML files? Why not just translate the text and put > the translated phrases / sentences / paragraphs into a database and call them > out according to specified language? > > Rick > > > From: "Adkins, Randy" > Sent: Thursday, April 21, 2005 1:41 PM > To: CF-Talk > Subject: RE: translating websites > > What I did was replaced all my DISPLAYED TEXT as variables And have a file > with all the variables setup for the given language. > > Such as: > If the locale is Spanish, then it calls the es-es.cfm file with all The > Spanish Translations. > > If the locale is English, then it calls the en-us.cfm file with all The > English Translations. > > This way I maintain ONE website and 2 language files. > > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 21, 2005 1:29 PM > To: CF-Talk > Subject: RE: translating websites > > Hi, Andy... > > I had a client ask about year ago if something like this could be done > without creating multiple sites, each in a different language. I couldn't > think of a way to do it. > > Seems like you've solved the problem nicely. > > Would you mind sharing some of your code / files / techniques...perhaps a > small sample of how you do it? > > Unfortunately, I know very little about using XML, although I've read some > about it, and haven't used it before. > > Any insight you'd be willing to give would be much appreciated! > > A first question would be...why would involving XML be helpful? Why not just > have someone do that translations and put them into a database? > > Thanks, > > Rick > > > From: "Andy Mcshane" > Sent: Thursday, April 21, 2005 1:03 PM > To: CF-Talk > Subject: RE: translating websites > > I have done exactly this using XML. All of the English text that appears on > my site is held within tables in a SQL database. I have a Coldfusion > interface for these tables that allows access to this text for translating > into any language that I choose. From this same interface I then generate XML > files for each language using the following naming convention, English.xml, > Spanish.xml, etc. In my coldfusion page, where I want to display the relevant > text I place a call to a translate function which does a search of the XML > file that I specify and returns the appropriate text. This means that I have > only one Coldfusion page that can be seen in many different languages. It is > a little more complex than I have stated here but this is one method to do > it. My site is a multi-lingual site and I display the required text based on > the language that a user specifies. The only drawback that I have so far > found with this method is that you sometimes get your text display screwed up > depending on t he size of the translated text, but this is a very small > problem indeed, but I would suggest XML as a good solution to your > requirements. > > > From: Coleman, Brian [mailto:[EMAIL
RE: translating websites
Ok guy's, here is a description of how I solved this problem for me. Firstly I
have a site that contains approxiamately 1750 pages. These pages are all
grouped together inside Directories i.e. 'Players', 'Competitions', etc. Each
of these Directories also contain a Directory called 'Language'. The 'Language'
Directorycontains a number of XML files called 'English.xml', 'French.xml',
etc. One XML file per language. All of the text in my CFM pages is replaced
with the following;
#translate("LABEL_NAME","PAGE_NAME","FOLDER_NAME")#
The translate function lives in my application.cfm page and is as follows;
#onceonly#
Each of my users have a language preference specified that is held within the
session scope, this variable is used to decide which XML file to include. The
XML file is searched for the required label and the text is then returned to
the page. One CFM page, multiple languages.
This works perfectly for me and is very efficient however I wrote this some
time ago and I am in the process of redoing it to see if I can make it any
better by possibly using cached SQL queries or using the application scope, to
be decided.
Now the tricky part, maintaining the text. ALL of my English text is stored
inside of a SQL database. I have written an administration interface that
exposes all of the English text to the screen in small manageable chunks that
allows an interpreter to translate the text for me. Once the text is translated
then it is simply a click of a button and a CFC that I wrote generates all of
the Language XML files for a particular directory. Anytime that I want to add
new text I simply add it via my administration interface which then makes it
available for translation. If a translation for a certain piece of text doesn't
yet exist then the English version is displayed by default, if a piece of text
is missing completely then this is flagged on the site.The best part of all of
this is I can add new languages and generate XML files at a click of a button!
Unfortunately all of this code is packaged as part of a much larger
administration site and it will take me a long time to make it a seperate stand
alone interface but I do intend to do that one day.
With regards to the actual translation, this is where I am very lucky, all of
my translation is carried out by someone of the nationality that is required.
Therefore I always have interpreters on hand in places such as Spain, France,
Germany, etc who work for me to ensure that nothing gets lost/added in
translation!
This is just one way of doing it, I am very interested in this discussion as I
would like to try any new ideas/suggestions for improving this.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203932
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT Sorry
Not trying to hijack this thread but I am having problems logging into HoF. I login OK but everytime I try to post I am told that I need to log in, but I already have? Help please, I have a very important question to ask? From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thu 21/04/2005 18:29 To: CF-Talk Subject: RE: translating websites Hi, Andy... I had a client ask about year ago if something like this could be done without creating multiple sites, each in a different language. I couldn't think of a way to do it. Seems like you've solved the problem nicely. Would you mind sharing some of your code / files / techniques...perhaps a small sample of how you do it? Unfortunately, I know very little about using XML, although I've read some about it, and haven't used it before. Any insight you'd be willing to give would be much appreciated! A first question would be...why would involving XML be helpful? Why not just have someone do that translations and put them into a database? Thanks, Rick ---- From: "Andy Mcshane" <[EMAIL PROTECTED]> Sent: Thursday, April 21, 2005 1:03 PM To: CF-Talk Subject: RE: translating websites I have done exactly this using XML. All of the English text that appears on my site is held within tables in a SQL database. I have a Coldfusion interface for these tables that allows access to this text for translating into any language that I choose. From this same interface I then generate XML files for each language using the following naming convention, English.xml, Spanish.xml, etc. In my coldfusion page, where I want to display the relevant text I place a call to a translate function which does a search of the XML file that I specify and returns the appropriate text. This means that I have only one Coldfusion page that can be seen in many different languages. It is a little more complex than I have stated here but this is one method to do it. My site is a multi-lingual site and I display the required text based on the language that a user specifies. The only drawback that I have so far found with this method is that you sometimes get your text display screwed up depending on the size of the translated text, but this is a very small problem indeed, but I would suggest XML as a good solution to your requirements. From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Thu 21/04/2005 17:32 To: CF-Talk Subject: translating websites I don't know if CF has any native way to do this, but the company I work for is looking for a way to translate the website to Spanish. Surely you wouldn't have to do a page for page translation? If anyone has worked with doing this sort of stuff, let me know. Thanks, Brian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203939 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFFORM format="flash" Problems!
Hi all, I am just starting to get into using flash forms but I have a number of questions that I would like to ask. I would like to use a tab style form but I am stumped on a couple of things; 1. Is it possible to validate data on a tab before a user can move to the next tab? 2. Is it possible to switch tabs on and off i.e. control access to different tabs? 3. How do you know which tab you are on? 4. Can you validate the data entered on each tab and then submit the whole form at the end? If any/all of these can be done can somebody help point me in the right direction or offer any advice. By the way I am a complete novice when it comes to ActionScript but I am willing to learn. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203947 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFFORM format="flash" Problems!
Can any/all of this also be done with the accordian type? > Hi all, I am just starting to get into using flash forms but I have a > number of questions that I would like to ask. > > I would like to use a tab style form but I am stumped on a couple of > things; > > 1. Is it possible to validate data on a tab before a user can move to > the next tab? > > 2. Is it possible to switch tabs on and off i.e. control access to > different tabs? > > 3. How do you know which tab you are on? > > 4. Can you validate the data entered on each tab and then submit the > whole form at the end? > > If any/all of these can be done can somebody help point me in the > right direction or offer any advice. By the way I am a complete novice > when it comes to ActionScript but I am willing to learn. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203948 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IIS LockDown Tool UrlScan runs after/before Jrun.dll ISAPI?
This may be a daft question but how do you prevent/disable/uninstall the CFAdmin when installing Coldfusion? From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thu 05/05/2005 15:39 To: CF-Talk Subject: Re: IIS LockDown Tool UrlScan runs after/before Jrun.dll ISAPI? The most secure model is not to deploy the CFAdmin at all to production systems. -Adam On 5/5/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > To my knowledge it executes before. > > -Adam > > On 5/5/05, David Manriquez <[EMAIL PROTECTED]> wrote: > > hi ppl.. > > > > i hope someone has been on the same situation before.. > > > > i need to restrict for security reason the access to /CFIDE/main/ide.cfm > > for RDS in CF/IIS mixture :-) > > > > my question is URlScan runs after or before Jrun.dll ISAPI FILTER? > > > > anyone knows? > > > > Thanks in advance. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird problem logging in with IE 5.5
Could it possibly be to do with cookies? Do they have their browser setup to allow cookies? From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Mon 09/05/2005 13:38 To: CF-Talk Subject: Weird problem logging in with IE 5.5 Hi guys, For some time now users have been sending me mails saying that they can't log into my application. I try and all is fine. I am now trying it with IE5.5 and am having the same problem occur. Does anyone know of any straight-forward reason why this could be? I would have thought it was browser independent being CF. Perhaps it's something in the user's options with IE5.5? If anyone could shed some light on to this i would be very grateful. The app is quite simple where by a user types in their username and then password which are then checked in an MS-SQL database. The strange thing is that an error doesn't occur, it just sends the user back to the user/password form. All other browsers it works fine in. Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird problem logging in with IE 5.5
Excellent, glad to be of help. From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Mon 09/05/2005 23:05 To: CF-Talk Subject: Re: Weird problem logging in with IE 5.5 Hi Andy, Thanks, that seemed to be the problem! :) On 9/5/05 13:47, "Andy Mcshane" <[EMAIL PROTECTED]> wrote: > Could it possibly be to do with cookies? Do they have their browser setup to > allow cookies? > > > > From: Stuart Kidd [mailto:[EMAIL PROTECTED] > Sent: Mon 09/05/2005 13:38 > To: CF-Talk > Subject: Weird problem logging in with IE 5.5 > > > > Hi guys, > > For some time now users have been sending me mails saying that they can't log > into my application. I try and all is fine. > > I am now trying it with IE5.5 and am having the same problem occur. > > Does anyone know of any straight-forward reason why this could be? I would > have thought it was browser independent being CF. Perhaps it's something in > the user's options with IE5.5? > > If anyone could shed some light on to this i would be very grateful. > > The app is quite simple where by a user types in their username and then > password which are then checked in an MS-SQL database. > > The strange thing is that an error doesn't occur, it just sends the user back > to the user/password form. > > All other browsers it works fine in. > > Thanks, > > Saturday > > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206163 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
LSDateFormat & Locale's
Hi guy's, this is a problem that has been driving me mad for a while. I have recently converted my website to be multi-lingual so that it now displays in French, German, Spanish, Italian and English. It is written using Coldfusion MX 6.1 and has a SQL2000 database backend. My problems have started with the formatting and submitting of date fields. The main problem that I am having is with LSDateFormat. All of my date fields are stored in my database in the format MMDD. I have no problem reading the data and displaying it using LSDateFormat i.e. if my users locale is "German (Standard)" I read the date from SQL as "2004-12-31" #LSDateFormat(MyDate, "DD MMM ")# displays it as "31 Dez 2004", so far this is fine. When I click my save button to submit this data back to the database I have to first convert this date back to a format that SQL will understand, this is where the problem occurrs as the following code; #lsdateformat(mydate, "MMDD")# produces this error "31 Dez 2004" is an invalid date format. As you can see I am trying to format the date as "20041231" so I can insert it back into my database. I do not understand why I am getting the error message that the date is invalid anybody know? Also is it possible to convert dates between locale's such as converting the user input German date of "31 Dez 2004" to the English date of "31 Dec 2004"? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184108 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
LSDateFormat & Locale's
Hi guy's, this is a problem that has been driving me mad for a while. I have recently converted my website to be multi-lingual so that it now displays in French, German, Spanish, Italian and English. It is written using Coldfusion MX 6.1 and has a SQL2000 database backend. My problems have started with the formatting and submitting of date fields. The main problem that I am having is with LSDateFormat. All of my date fields are stored in my database in the format MMDD. I have no problem reading the data and displaying it using LSDateFormat i.e. if my users locale is "German (Standard)" I read the date from SQL as "2004-12-31" #LSDateFormat(MyDate, "DD MMM ")# displays it as "31 Dez 2004", so far this is fine. When I click my save button to submit this data back to the database I have to first convert this date back to a format that SQL will understand, this is where the problem occurrs as the following code; #lsdateformat(mydate, "MMDD")# produces this error "31 Dez 2004" is an invalid date format. As you can see I am trying to format the date as "20041231" so I can insert it back into my database. I do not understand why I am getting the error message that the date is invalid anybody know? Also is it possible to convert dates between locale's such as converting the user input German date of "31 Dez 2004" to the English date of "31 Dec 2004"? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]> Website: www.scout7.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184109 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: LSDateFormat & Locale's
>Andy Mcshane wrote: >> my date fields are stored in my database in the format MMDD. I have > >first off why aren't you using standard sql datetime datatypes? > >> #lsdateformat(mydate, "MMDD")# produces this error "31 Dez 2004" is > >maybe give lsParseDateTime(date/time-string) a spin. I am using the standard SQL datetime datatypes, The way I wrote it above is just to simply demonstrate the way the SQL stores the date. I handle all of my database access using stored procedures so I use CFStorerdProc & CFProcParam so I what I actually try to pass out to SQL is this, This is what produces the error message above. I am unfamiliar with LSParseDateTime, what does this actually do? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184115 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: LSDateFormat & Locale's
>Andy Mcshane wrote:
>
>> I am unfamiliar with LSParseDateTime, what does this actually do?
>
>Exactly what it says on the tin. It parses dates into CF's own
>internal datetime format. This works better with the likes of
>CFPROCPARAM, CFQUERYPARAM, &c.
>
>--
>Keith Gaughan, Developer
>Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
>http://digital-crew.com/
Thanks for your help, I am quite new to Coldfusion MX so am not totally
familiar with all of the functions available. I tried the following code in an
environment that has it's locale set to 'German (Standard)',
#LSParseDateTime("#lsdateformat("01 Dez 2004", "DD MMM ")#")#
And I still get the same error, what am I doing wrong?
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184141
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: LSDateFormat & Locale's
>Take out the inner #'s
>
>Ray
>
>At 10:50 AM 11/12/2004, you wrote:
>>
Did that and then get an error because of quotation marks!
Take out all of those and use this code instead;
#LSParseDateTime(lsdateformat("01 Dez 2004", "DD MMM "))#
Still get the same error message about it being an invalid date.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184146
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: LSDateFormat & Locale's
>You have to create the date first. > >Try this: > >#LSParseDateTime(LSDateFormat(CreateDate(2004,12,1)))# > >Ray > >At 11:02 AM 11/12/2004, you wrote: >> In reality the date is being passed in a form variable because this is the data that the user has entered so would the createdate not apply here? So my original code should have read; #LSParseDateTime(lsdateformat(MyFormFieldDate, "DD MMM "))# I hope I am not confusing this too much! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184149 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: LSDateFormat & Locale's
> Andy Mcshane wrote: > > I am using the standard SQL datetime datatypes, The way I wrote it > above is just to simply demonstrate the way the SQL stores the date. I > handle all of my database > access using stored procedures so I use CFStorerdProc & CFProcParam so > I > what I actually try to pass out to SQL is this, > > no, that's not how sql server stores dates. refer to your BoL. > > >value=#lsdateformat(mydate, "DD MMM ")# > > you've made up your own date format. in i18n work it's ALWAYS a good > rule to use standard date formats (standard as in java style), which > MX > also uses (for de_DE locale): > > "full" Samstag, 13. November 2004 > "long" 13. November 2004 > "medium" 13.11.2004 > "short" 13.11.04 > > these should be understandable to users & easily parsed (and if not, > you > can always blame sun). making up your own date formats requires actual > > locale research & for me, too much programming. and if you're doing > this > w/out doing any locale research, well OK, I am getting a little confused now, let me start again. I run a query that returns a date field from SQL, the format of that date is as follows; 2004-12-01 00:00:00.0 - returned from SQL Now when I want to display that date on the page I use the following code; #lsdateformat(MyQuery.MyDate, 'DD MMM ')# This formats the date correctly as '01 Dez 2004' and displays in a text form field which the user can change. The problem occurrs when I try to then manipulate that date field. The date gets formatted as I want it without any error when I format the original date from my SQL query but if I try to do anything else to that formatted date Coldfusion states that it is an invalid date format although I am using exactly the same code i.e. #lsdateformat(MyQuery.MyDate, 'DD.MMM.')# This where it is confusing as the LSDateFormat works the first time but then reports the date that it just formatted as now invalid! Maybe it's a bug .? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Query using 'FOR XML' & Coldfusion
Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to return the results of a stored procedure, called from Coldfusion using 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few problems; When I run the query in the SQL query window the results are exactly as I want, when I then call the stored procedure from Coldfusion app I get a recordset with multiple rows instead of one record containing a string and when I look at the 'ColumnList' property of the query I have mulitple columns with a naming convention as 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. Has anybody managed to use this SQL 'FOR XML' functionality in a Coldfusion app before? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query using 'FOR XML' & Coldfusion
Can you remember at all how you handled the column names? i.e. 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 17:42 To: CF-Talk Subject: Re: SQL Query using 'FOR XML' & Coldfusion Yes, you have to loop over the query columns and build a new string with the columns data. The way you go about it is pretty wacky and I forget the syntax, but I (and others) have posted how to do it to the list at one point so it should be in the archive (it was like a year ago though) On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to return the results of a stored procedure, called from Coldfusion using 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few problems; > > When I run the query in the SQL query window the results are exactly as I want, when I then call the stored procedure from Coldfusion app I get a recordset with multiple rows instead of one record containing a string and when I look at the 'ColumnList' property of the query I have mulitple columns with a naming convention as 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > Has anybody managed to use this SQL 'FOR XML' functionality in a Coldfusion app before? > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query using 'FOR XML' & Coldfusion
Thanks, I am definitely interested! This would be of a great help to me. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 12:58 To: CF-Talk Subject: RE: SQL Query using 'FOR XML' & Coldfusion The only way I found to do this is actually get an ADO stream, I wrote an SP that gets the result and stores it into a T-SQL variable. If you are interested I can post it when I find it..? Taco Fleur > -Original Message----- > From: Andy McShane [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 November 2004 8:27 PM > To: CF-Talk > Subject: RE: SQL Query using 'FOR XML' & Coldfusion > > > Can you remember at all how you handled the column names? > i.e. 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > -Original Message- > From: Rob [mailto:[EMAIL PROTECTED] > Sent: 17 November 2004 17:42 > To: CF-Talk > Subject: Re: SQL Query using 'FOR XML' & Coldfusion > > Yes, you have to loop over the query columns and build a new > string with the columns data. > > The way you go about it is pretty wacky and I forget the > syntax, but I (and others) have posted how to do it to the > list at one point so it should be in the archive (it was like > a year ago though) > > On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane > <[EMAIL PROTECTED]> wrote: > > Hi all. I am trying to utilise the SQL2000 'FOR XML' > functionality to > return the results of a stored procedure, called from > Coldfusion using 'CFStoredProc', as an XML string to my > Coldfusion app. I am having a few problems; > > > > When I run the query in the SQL query window the results > are exactly > > as I > want, when I then call the stored procedure from Coldfusion > app I get a recordset with multiple rows instead of one > record containing a string and when I look at the > 'ColumnList' property of the query I have mulitple columns > with a naming convention as > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > Has anybody managed to use this SQL 'FOR XML' functionality in a > Coldfusion app before? > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Xml from SQL 2k
> Thanx Mr.Dave > > > - Original Message - > From: "Dave Watts" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, October 11, 2001 12:24 PM > Subject: RE: Xml from SQL 2k > > > > > Can any one tell me where can i find an article related to > > > xml with CF The database is sql server 2000.And I want to > > > generate the xml from sql 2000. > > > > We had a CFUG presentation covering some of this, that you might > find > > useful. > > http://www.figleaf.com/figleafhome/cfug/2001/CFUGApr2001/sql2000xml. > zip > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > > ~~ > Your ad could be here. Monies from ads go to support these lists and > provide more resources for the community. http://www.fusionauthority. > com/ads.cfm I have been desperately searching for something similar to this. From my Coldfusion page I execute a stored procedure that extracts data from my SQL database into an XML format and returns it to my page. My problem is how do I handle back in CF? When I query my #query.recordcount# I have multiple records. When I do a of the query I can all of the XML data that I want. I would like to be able to loop through the recordset and rebuild all of the individual back into one string ready for XML parsing. When I try to do I notice that Each record has only 1 column with a wierd name like 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the value of this column using the column name I get an error '"18A1," on line 14, column 23, is not a valid identifer name.'. Does anybody know how I can loop through the results of my query and rebuild my single XML string, this problem is driving me mad!!! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Xml from SQL 2k
I have been desperately searching for something similar to this. From my Coldfusion page I execute a stored procedure that extracts data from my SQL database into an XML format and returns it to my page. My problem is how do I handle back in CF? When I query my #query.recordcount# I have multiple records. When I do a of the query I can all of the XML data that I want. I would like to be able to loop through the recordset and rebuild all of the individual back into one string ready for XML parsing. When I try to do I notice that Each record has only 1 column with a wierd name like 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the value of this column using the column name I get an error '"18A1," on line 14, column 23, is not a valid identifer name.'. Does anybody know how I can loop through the results of my query and rebuild my single XML string, this problem is driving me mad!!! > > Thanx Mr.Dave > > > > > > - Original Message - > > From: "Dave Watts" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, October 11, 2001 12:24 PM > > Subject: RE: Xml from SQL 2k > > > > > > > > Can any one tell me where can i find an article related to > > > > xml with CF The database is sql server 2000.And I want to > > > > generate the xml from sql 2000. > > > > > > We had a CFUG presentation covering some of this, that you might > > find > > > useful. > > > http://www.figleaf. > com/figleafhome/cfug/2001/CFUGApr2001/sql2000xml. > > zip > > > > > > Dave Watts, CTO, Fig Leaf Software > > > http://www.figleaf.com/ > > > voice: (202) 797-5496 > > > > > ~~ > > Your ad could be here. Monies from ads go to support these lists and > > > provide more resources for the community. http://www.fusionauthority. > > > com/ads.cfm > > I have been desperately searching for something similar to this. From > my Coldfusion page I execute a stored procedure that extracts data > from my SQL database into an XML format and returns it to my page. My > problem is how do I handle back in CF? When I query my #query. > recordcount# I have multiple records. When I do a of the > query I can all of the XML data that I want. I would like to be able > to loop through the recordset and rebuild all of the individual back > into one string ready for XML parsing. When I try to do I notice that > Each record has only 1 column with a wierd name like > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the > value of this column using the column name I get an error '"18A1," on > line 14, column 23, is not a valid identifer name.'. > Does anybody know how I can loop through the results of my query and > rebuild my single XML string, this problem is driving me mad!!! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query using 'FOR XML' & Coldfusion
anisation.telephoneCountryCode, organisation.telephoneAreaCode, organisation.telephone, organisation.faxCountryCode, organisation.faxAreaCode, organisation.fax, organisation.fkStatus, organisation.locked, contact_address.fkAddress, contact_address.buildingProperty, contact_address.levelFloor, contact_address.roomSuite, address.fkAddressType, address.addressType, address.boxPostal, address.buildingProperty, address.streetNumber, address.streetName, address.fkStreetType, address.streetType, address.fkCountry, address.country, address.fkState, address.state, address.fkSuburb, address.suburb, address.postalCode, address.fkStatus, address.locked FROMtblContact contact INNER JOIN tblPerson person ON contact.fkPerson = person.pkIDPerson INNER JOIN tblContact_Address contact_address ON contact.pkIDContact = contact_address.fkContact INNER JOIN tblOrganisation organisation ON contact.fkOrganisation = organisation.pkIDOrganisation INNER JOIN tblAddress address ON contact_address.fkAddress = address.pkIDAddress WHERE (contact.pkIDContact = 61548) FOR XML EXPLICIT' Taco Fleur > -Original Message- > From: Andy Mcshane [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 November 2004 11:08 PM > To: CF-Talk > Subject: RE: SQL Query using 'FOR XML' & Coldfusion > > > Thanks, I am definitely interested! This would be of a great > help to me. > > Andy McShane > Head of Development > Scout7 Ltd, > 324a Lichfield Road, > Mere Green, > Sutton Coldfield > West Midlands > United Kingdom > B74 2UW > > Telephone: +44 (0)121 323 2640 > Mobile : 07866 430783 > Fax: +44 (0)121 323 2010 > Email: mailto:[EMAIL PROTECTED] > Website: www.scout7.com > > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 12:58 > To: CF-Talk > Subject: RE: SQL Query using 'FOR XML' & Coldfusion > > The only way I found to do this is actually get an ADO > stream, I wrote an SP that gets the result and stores it into > a T-SQL variable. > > If you are interested I can post it when I find it..? > > Taco Fleur > > > > -Original Message- > > From: Andy McShane [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 18 November 2004 8:27 PM > > To: CF-Talk > > Subject: RE: SQL Query using 'FOR XML' & Coldfusion > > > > > > Can you remember at all how you handled the column names? > > i.e. 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > > > -Original Message- > > From: Rob [mailto:[EMAIL PROTECTED] > > Sent: 17 November 2004 17:42 > > To: CF-Talk > > Subject: Re: SQL Query using 'FOR XML' & Coldfusion > > > > Yes, you have to loop over the query columns and build a new > > string with the columns data. > > > > The way you go about it is pretty wacky and I forget the > > syntax, but I (and others) have posted how to do it to the > > list at one point so it should be in the archive (it was like > > a year ago though) > > > > On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane > > <[EMAIL PROTECTED]> wrote: > > > Hi all. I am trying to utilise the SQL2000 'FOR XML' > > functionality to > > return the results of a stored procedure, called from > > Coldfusion using 'CFStoredProc', as an XML string to my > > Coldfusion app. I am having a few problems; > > > > > > When I run the query in the SQL query window the results > > are exactly > > > as I > > want, when I then call the stored procedure from Coldfusion > > app I get a recordset with multiple rows instead of one > > record containing a string and when I look at the > > 'ColumnList' property of the query I have mulitple columns > > with a naming convention as > > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > > > Has anybody managed to use this SQL 'FOR XML' functionality in a > > Coldfusion app before? > > > > > > > > > > > > >
RE: SQL Query using 'FOR XML' & Coldfusion
This is excellent, can't believe it could be so simple! Why didn't I think of that? Many thanks. -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 19:14 To: CF-Talk Subject: Re: SQL Query using 'FOR XML' & Coldfusion http://216.239.57.104/search?q=cache:DCTbFs36U50J:www.houseoffusion.com/ cf_lists/index.cfm/method%3Dmessages%26threadid%3D19430%26forumid%3D4+%2 2for+xml%22+coldfusion+%22rob+rohan%22&hl=en ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184848 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query using 'FOR XML' & Coldfusion
Thanks for this, it is really a great help, I may get a good nights sleep now! -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 19:50 To: CF-Talk Subject: RE: SQL Query using 'FOR XML' & Coldfusion ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184849 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Query using 'FOR XML' & Coldfusion
>Thanks for this, it is really a great help, I may get a good nights >sleep now! > >-Original Message- >From: Taco Fleur [mailto:[EMAIL PROTECTED] >Sent: 18 November 2004 19:50 >To: CF-Talk >Subject: RE: SQL Query using 'FOR XML' & Coldfusion Rob, quick query, when I use the following code #xmltest[xmltest.columnlist][x]# If I then use '' I get the following error 'Document root element is missing' any idea why? It doesn't really matter if nobody knows because I can still extract the XML data that I require but I do like to parse all of my XML data before working with it, just habit I guess! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184850 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
What does this error mean?
Hi all, I keep this error message in my exception.log, can anyone tell what Coldfusion is trying to do here? "Error","jrpp-1696","11/19/04","15:02:57",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: X:\Inetpub\wwwroot\CFIDE\main\ide.cfm " coldfusion.runtime.TemplateNotFoundException: File not found: /CFIDE/main/ide.cfm Why is Coldfusion looking for this file, what is used for? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184885 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What does this error mean?
Now you have me worried, possibly someone probing my machine? Whilst RDS is disabled am I safe? -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 16:17 To: CF-Talk Subject: Re: What does this error mean? This is something to do with the RDS server service I believe. The file doesn't actually exist (at least not on 6.1, even if you have RDS enabled) but it is referred to in the web.xml configuration file. Don't think it is anything to wrong about, but it could be someone probing your machine to see if the RDS service is running. Andrew. On Fri, 19 Nov 2004 11:11:11 -0400, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Hi all, I keep this error message in my exception.log, can anyone tell what Coldfusion is trying to do here? > > "Error","jrpp-1696","11/19/04","15:02:57",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: X:\Inetpub\wwwroot\CFIDE\main\ide.cfm " > coldfusion.runtime.TemplateNotFoundException: File not found: /CFIDE/main/ide.cfm > > Why is Coldfusion looking for this file, what is used for? > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Datasource
Is Coldfusion on the same server as the database, if so, I usually just enter 'localhost' for servername. Have you checked that the login details in Coldfusion actually has permission to access the database on SQL server? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 17:10 To: CF-Talk Subject: Re: SQL Datasource still no luck on this. can anybody help me out? i've entered my local machine name & no luck??? On Thu, 18 Nov 2004 15:13:41 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > GOT THE SERVER NAME RIGHT? YOU MAY HAVE TO USE THE NAME OF YOUR LOCAL MACHINE > > > > -Original Message- > From: Donna French [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 18, 2004 3:05 PM > To: CF-Talk > Subject: SQL Datasource > > I'm trying to setup a SQL Server datasource and keep getting an error. > I've imported my database locally from the remote server using DTS, > and have named the datasource, database, appropriate datasource type. > Any suggestions welcome. > > TIA, > Donna > -- > > Donna French > [EMAIL PROTECTED] > > Blog: http://dgfrench.blogspot.com > Site: http://www.dgfrenchdesigns.com > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184899 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What does this error mean?
Interesting, when I try to use the filesystem browser to register CFX tags I get a server error, could these be connected. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 17:26 To: CF-Talk Subject: RE: What does this error mean? > I've been getting that error on one of my boxes too, i see it > only when I login to the CFAdmin tool. Oh, and this box has > RDS off. I think its related to the 6.1 updater cfadmin issue > maybe. The CF Administrator uses RDS for a couple of things, such as the Java filesystem browsing applet. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184907 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Datasource
You would have to check this in SQL server. There are different ways of configuring SQL access, personally I have created a user with limited rights that matches my Coldfusion login details i.e. Coldfusion login username = wibble Coldfusion login Password = wobble In SQL server I then create the following SQL server login username = wibble SQL server login password = wobble I then specify which databases that user has permission to access. Without knowing exactly how you have SQL access configured i.e. windows authentification or mixed mode access it is difficuly to advise. To check whether you have a user login in SQL that matches your Coldfusion details you will have to use the SQL Enterprise Manager, click on the the SQL instance under SQL server group, select security and click on logins. You will then be able to see what users exist and also add new ones if needed. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 17:54 To: CF-Talk Subject: Re: SQL Datasource How do I make sure CF has permission to access SQL server? On Fri, 19 Nov 2004 17:15:19 -, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Is Coldfusion on the same server as the database, if so, I usually just > enter 'localhost' for servername. Have you checked that the login > details in Coldfusion actually has permission to access the database on > SQL server? > > Andy McShane > Head of Development > Scout7 Ltd, > 324a Lichfield Road, > Mere Green, > Sutton Coldfield > West Midlands > United Kingdom > B74 2UW > > Telephone: +44 (0)121 323 2640 > Mobile : 07866 430783 > Fax: +44 (0)121 323 2010 > Email: mailto:[EMAIL PROTECTED] > Website: www.scout7.com > > > > > -Original Message- > From: Donna French [mailto:[EMAIL PROTECTED] > Sent: 19 November 2004 17:10 > To: CF-Talk > Subject: Re: SQL Datasource > > still no luck on this. can anybody help me out? i've entered my local > machine name & no luck??? > > On Thu, 18 Nov 2004 15:13:41 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > > GOT THE SERVER NAME RIGHT? YOU MAY HAVE TO USE THE NAME OF YOUR LOCAL > MACHINE > > > > > > > > -Original Message- > > From: Donna French [mailto:[EMAIL PROTECTED] > > Sent: Thursday, November 18, 2004 3:05 PM > > To: CF-Talk > > Subject: SQL Datasource > > > > I'm trying to setup a SQL Server datasource and keep getting an error. > > I've imported my database locally from the remote server using DTS, > > and have named the datasource, database, appropriate datasource type. > > Any suggestions welcome. > > > > TIA, > > Donna > > -- > > > > Donna French > > [EMAIL PROTECTED] > > > > Blog: http://dgfrench.blogspot.com > > Site: http://www.dgfrenchdesigns.com > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion & ASP.NET
Is it possible to use Coldfusion & ASP.NET together inside of the same of the application? Does anybody currently do this? Can anyone point me to any tutorials or examples on how well they work together, how you can pass form variables between them? Any help or pointers would be greatly appreciated. My reason for asking this is that I have been asked to try to convert one of our Coldfusion applications to ASP.NET but before commiting totally to it I would like to know if I could convert certain areas of it and still have the application running. Am I wishing for too much? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion & ASP.NET
Thanks, I will look into Bluedragon, however I already know that I will be asked why we need additional software. Is it at all possible to do what I want simply using IIS and Coldfusion server? -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 23 November 2004 09:44 To: CF-Talk Subject: Coldfusion & ASP.NET Is it possible to use Coldfusion & ASP.NET together inside of the same of the application? Does anybody currently do this? Can anyone point me to any tutorials or examples on how well they work together, how you can pass form variables between them? Any help or pointers would be greatly appreciated. My reason for asking this is that I have been asked to try to convert one of our Coldfusion applications to ASP.NET but before commiting totally to it I would like to know if I could convert certain areas of it and still have the application running. Am I wishing for too much? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185133 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion & ASP.NET
Thankfully, we are not converting to .NET as a company, this is a one off specifically requested trial. The main areas that I am looking at firstly are the data access and XML functionality. I have read a couple articles that suggest ASP.NET may have a performance gain over Coldfusion and I need to test this theory before committing to the initial request. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 23 November 2004 12:06 To: CF-Talk Subject: RE: Coldfusion & ASP.NET CFMX will install on a box with .NET without any significant issue (there is a 2k3 performance technote you may want to look at). The the question is how you want to them to talk together. What kind of bits are you looking at writing first in .NET? That might help in the conversation. Although converting to .NET probably isn't a favored topic on a CF discussion forum :P - Calvin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185140 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion & ASP.NET
That is what I was hoping for, but can process the form fields that each page created, i.e. post the ASP.NET form and refer to the form fields in CF? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 23 November 2004 12:44 To: CF-Talk Subject: Re: Coldfusion & ASP.NET I havent tried this but I am sure you can run ASP.net in the same dir as cf as all requests for .cfm will be directed to Coldfusion and all requests for .aspx will be directed to ASP.net (someone shout if I am wrong!) MD On Tue, 23 Nov 2004 12:28:21 -0000, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Thankfully, we are not converting to .NET as a company, this is a one > off specifically requested trial. The main areas that I am looking at > firstly are the data access and XML functionality. I have read a couple > articles that suggest ASP.NET may have a performance gain over > Coldfusion and I need to test this theory before committing to the > initial request. > > > > -Original Message- > From: Calvin Ward [mailto:[EMAIL PROTECTED] > Sent: 23 November 2004 12:06 > To: CF-Talk > Subject: RE: Coldfusion & ASP.NET > > CFMX will install on a box with .NET without any significant issue > (there is a 2k3 performance technote you may want to look at). The the > question is how you want to them to talk together. > > What kind of bits are you looking at writing first in .NET? That might > help in the conversation. Although converting to .NET probably isn't a > favored topic on a CF discussion forum :P > > - Calvin > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185142 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion & ASP.NET
Correct. I need to do the comparisons before a decision is made whether to try to convert. Bluedragon aside (couldn't justify further expense in server software) after comparing functions it would be ideal if I can get them to work together, I suppose webservices is the answer? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 23 November 2004 12:57 To: CF-Talk Subject: Re: Coldfusion & ASP.NET I dont see a problem with that, if you can post from an html page to asp or cfm there shouldnt be a probelm at all.. e.g. make a html page with javascript that changes the form.action to either go to process.asp or process.cfm I guess you are trying to compare the same function built in asp.net and cfmx right? MD On Tue, 23 Nov 2004 12:48:37 -0000, Andy Mcshane <[EMAIL PROTECTED]> wrote: > That is what I was hoping for, but can process the form fields that each > page created, i.e. post the ASP.NET form and refer to the form fields in > CF? > > Andy McShane > Head of Development > Scout7 Ltd, > 324a Lichfield Road, > Mere Green, > Sutton Coldfield > West Midlands > United Kingdom > B74 2UW > > Telephone: +44 (0)121 323 2640 > Mobile : 07866 430783 > Fax: +44 (0)121 323 2010 > Email: mailto:[EMAIL PROTECTED] > Website: www.scout7.com > > > > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 23 November 2004 12:44 > To: CF-Talk > Subject: Re: Coldfusion & ASP.NET > > I havent tried this but I am sure you can run ASP.net in the same dir > as cf as all requests for .cfm will be directed to Coldfusion and all > requests for .aspx will be directed to ASP.net > > (someone shout if I am wrong!) > > MD > > On Tue, 23 Nov 2004 12:28:21 -, Andy Mcshane <[EMAIL PROTECTED]> > wrote: > > Thankfully, we are not converting to .NET as a company, this is a one > > off specifically requested trial. The main areas that I am looking at > > firstly are the data access and XML functionality. I have read a > couple > > articles that suggest ASP.NET may have a performance gain over > > Coldfusion and I need to test this theory before committing to the > > initial request. > > > > > > > > -Original Message- > > From: Calvin Ward [mailto:[EMAIL PROTECTED] > > Sent: 23 November 2004 12:06 > > To: CF-Talk > > Subject: RE: Coldfusion & ASP.NET > > > > CFMX will install on a box with .NET without any significant issue > > (there is a 2k3 performance technote you may want to look at). The the > > question is how you want to them to talk together. > > > > What kind of bits are you looking at writing first in .NET? That might > > help in the conversation. Although converting to .NET probably isn't a > > favored topic on a CF discussion forum :P > > > > - Calvin > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185146 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion & ASP.NET
Who here uses BlueDragon .NET. I notice that they are currently in Beta with the .NET server, has anyone used/tried it? Goog/bad? Is it easy to configure/use? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 November 2004 10:45 To: CF-Talk Subject: RE: Coldfusion & ASP.NET BlueDragon .NET -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 23 November 2004 09:44 To: CF-Talk Subject: Coldfusion & ASP.NET Is it possible to use Coldfusion & ASP.NET together inside of the same of the application? Does anybody currently do this? Can anyone point me to any tutorials or examples on how well they work together, how you can pass form variables between them? Any help or pointers would be greatly appreciated. My reason for asking this is that I have been asked to try to convert one of our Coldfusion applications to ASP.NET but before commiting totally to it I would like to know if I could convert certain areas of it and still have the application running. Am I wishing for too much? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bug fix follow-up application
Hi, I like the look of this application, it appears to do almost everything that I to need. I have had no problems installing it and getting it running. For someone relatively new to Coldfusion the source code is very impressive & informative. Just one thing, I need to make a little change to get it to completely fullfill my needs but I cannot seem to get any debug information displayed for these pages even though I have debugging switched on. Is there a setting on one of the pages that prevents this? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 27 November 2004 15:10 To: CF-Talk Subject: Re: Bug fix follow-up application Paatrick, if James' suggestion doesn't help, you may want to contact me directly at [EMAIL PROTECTED] I have an update to Lighthouse coming out soon, but have yet to set up a forum for it like my other products. On Thu, 25 Nov 2004 10:22:30 -0500, CFDEV <[EMAIL PROTECTED]> wrote: > Thanks.. It looks good.. > > I installed it on my developper machine without any problem but when I put > it on our dev server which is confgirued differently with virtual directory > in IIS, I map the tracker and put the apps in a folder I can and when I try > to make it works it's kinda of in an infinity loop on index.cfm > > Any ideas? > > Thanks > > Patrick > > > > -Original Message- > From: Jon Austin [mailto:[EMAIL PROTECTED] > Sent: November 24, 2004 19:22 > To: CF-Talk > Subject: Re: Bug fix follow-up application > > Check out 'lighthouse' by Ray Camden. > http://www.camdenfamily.com/morpheus/blog/ > > > On Wed, 24 Nov 2004 16:41:14 -0500, CFDEV <[EMAIL PROTECTED]> wrote: > > > Does anyone knows a good open source project of following bugs for > > > software developement? preferably an application that is written in CF. > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185502 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bug fix follow-up application
>Hi, I like the look of this application, it appears to do almost >everything that I to need. I have had no problems installing it and >getting it running. For someone relatively new to Coldfusion the source >code is very impressive & informative. Just one thing, I need to make a >little change to get it to completely fullfill my needs but I cannot >seem to get any debug information displayed for these pages even though >I have debugging switched on. Is there a setting on one of the pages >that prevents this? > >Andy McShane >Head of Development >Scout7 Ltd, >324a Lichfield Road, >Mere Green, >Sutton Coldfield >West Midlands >United Kingdom >B74 2UW > >Telephone: +44 (0)121 323 2640 >Mobile : 07866 430783 >Fax: +44 (0)121 323 2010 >Email: mailto:[EMAIL PROTECTED] >Website: www.scout7.com > Please ignore this, Monday morning blues!. Trying to debug code on my local machine that is actually running on a different machine, doh! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Best way to access CFC's?
Starting to update a site by converting code to CFC's, anyone have any thoughts on what is the best or most efficient way to access a CFC? Is it better to use or should I use CreateObject? Which method is better and why? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185541 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Thanks Dave, I will take a look. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 17:47 To: CF-Talk Subject: Re: Best way to access CFC's? On Mon, 29 Nov 2004 12:39:35 -0400, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Starting to update a site by converting code to CFC's, anyone have any thoughts on what is the best or most efficient way to access a CFC? Is it better to use or should I use CreateObject? Which method is better and why? > They're effectively the same thing, except you'd use createObject if you're a cfscript fan and the tag-based cfinvoke if you're not. If you are new or relatively new to CFCs, be sure to check out this document which is a community-driven "best practices" document for working with them: http://www.dintenfass.com/cfcbestpractices/ Regards, Dave. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Are there any benefits of one over the other? Are there any performance issues to consider? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 18:29 To: CF-Talk Subject: Re: Best way to access CFC's? CFINVOKE and createObject are very different beasts. CFOBJECT and createObject are the same, but CFINVOKE creates and instance of the CFC, calls the specified method on it, and then lets the instance disappear, with no hope of holding on to it for future reuse. Here's two examples of creating an object instance: And here's two examples of calling a method on a CFC, without creating an instance: cheers, barneyb ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Thanks, that makes it a little clearer. Now for the newbie dumb question, how does the code know where to find the components? i.e. Do you have to create a mapping to a directory called component that contains all of the CFC's? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 19:16 To: CF-Talk Subject: Re: Best way to access CFC's? If you're component is stateful, you'll want to invoke methods on the same instance of the component instead of continually creating new instances. #sum# There's a few different ways to write thisI'd probably use: #myAdder.getSum()# -joe ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Great, got it. Many thanks for your help. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 13:19 To: CF-Talk Subject: Re: Best way to access CFC's? In that example, it will look in the directory of the calling template. The "component" part of the call tells it that you're creating an object of type "component." You can also have a mapping to a directory for components, and you can also use dot notation. For example: looks in current directory or looks in mapped cfc directory if it's at the root (but I doubt that) looks in root of directory mapped to /cfc ----- Original Message - From: "Andy Mcshane" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 30, 2004 4:28 AM Subject: RE: Best way to access CFC's? > Thanks, that makes it a little clearer. Now for the newbie dumb > question, how does the code know where to find the components? i.e. > > > > > Do you have to create a mapping to a directory called component that > contains all of the CFC's? > > Andy McShane > Head of Development > Scout7 Ltd, > 324a Lichfield Road, > Mere Green, > Sutton Coldfield > West Midlands > United Kingdom > B74 2UW > > Telephone: +44 (0)121 323 2640 > Mobile : 07866 430783 > Fax: +44 (0)121 323 2010 > Email: mailto:[EMAIL PROTECTED] > Website: www.scout7.com > > > -Original Message- > From: Joe Rinehart [mailto:[EMAIL PROTECTED] > Sent: 29 November 2004 19:16 > To: CF-Talk > Subject: Re: Best way to access CFC's? > > If you're component is stateful, you'll want to invoke methods on the > same instance of the component instead of continually creating new > instances. > > > > > >component="#myAdder#" > method="setNumberOne" > name="number" > value="2"> > > > >component="#myAdder#" > method="setNumberTwo" > name="number" > value="3"> > > > >component="#myAdder#" > method="getSum" > returnVariable="sum" > > > > #sum# > > There's a few different ways to write thisI'd probably use: > > > > > #myAdder.getSum()# > > -joe > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185652 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Two Selects
Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division & club, I am sure it could be useful for other things with a few more changes? ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188680 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Two Selects
I will upload the 4 selects tag that I have used but I am really interested in looking into qForms, didn't realise that there are so many different approaches to this problem. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 20:51 To: CF-Talk Subject: Re: Two Selects qForms is what I have used for this as well. I like being able to control the layout of my form more so than what could be done with the two or three selects tags. I put up some examples a long time ago doing n-selects with qForms, actually before pengoworks had any up. Maybe I should go through mine and make sure they are done "correctly" :) On Thu, 23 Dec 2004 12:59:16 -0500, Chris Stoner <[EMAIL PROTECTED]> wrote: > You also might want to look at the qForms implementation of this > concept. Its pretty easilly implemented. > > http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm > > > Tim Laureska wrote: > > >Andy... I'd sure be interested > >Tim > > > >-Original Message- > >From: Andy Mcshane [mailto:[EMAIL PROTECTED] > >Sent: Thursday, December 23, 2004 12:24 PM > >To: CF-Talk > >Subject: RE: Two Selects > > > >Slightly OT but I managed to alter the 3 selects and create a 4 selects > >related tag if that is of any help to anyone? It was a nightmare to do > >and I can't actually remember how I did it but it works great, I had to > >alter it to enable a user to select a region, country, division & club, > >I am sure it could be useful for other things with a few more changes? > > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: text formatting
Sorry guy's, a little off topic here. I notice that a few of you have had experience with FCKEditor and TinyMCE editor. I would just like to pick your brains about a specific problem that I have that maybe either of these editors could help resolve. I need to be able to allow users to create letter templates on line and then use those same templates in a mail merge situation. Are either of these editors able to save output in an RTF format? Another option is that the user creates the letter template in word and then cut & pastes it into the editor for final tweeking. In your experience how accurately do these editors handle content pasted from word? Is it esy to save & retrieve data from a database for editing in these editors? I know that I should really go and try these things out myself but as always I am really stuck for time. If any of you can give me any feedback on your usage of these editors I really would appreciate it. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: text formatting
You are correct, I have not yet had that 'pleasure' :-). Poor, unsuspecting me, I am still clutching at straws and live in the vain hope that one day I will found a method that will allow a user to take a completed Word document, copy it, paste it into an area in my webpage, allow me to save it as RTF(or some other reusable format) and then use that document to produce a mail merge upon request. I know I can do it manually myself using RTF but as my user base are expecting to have around 500-1500 different letter templates over time I cannot justify doing each one manually! Bugger!. Depressed and still searching :-(! From: dave [mailto:[EMAIL PROTECTED] Sent: Wed 18/05/2005 09:32 To: CF-Talk Subject: re: OT: text formatting Apparently you have never experienced the joys of working with data thats been copied and pasted from word or rtf. Maybe try that 1st and see if you want to allow that and once again be prepared to start swearing at Bill for screwing even more things up! ~Dave the disruptor~ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207009 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
