CFHTTP question
Is there a way to actually extract information from URL's, like only the information you want, instead of the other stuff that you don't want? Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Free Hosting
Hi.. Do any of the hosting providers provide Free Cold Fusion hosting.. i basically want it for Testing my site Regards Vikram __ FREE voicemail, email, and fax...all in one place. Sign Up Now! http://www.onebox.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP question
On 9/3/00, [EMAIL PROTECTED] penned: Is there a way to actually extract information from URL's, like only the information you want, instead of the other stuff that you don't want? If you view the source of the page you want, then say there is a section that always changes dynamically and that is what you are trying to get, and if you can find something before that that never changes then you would do a "find()" for that string, then add the number of characters to the position where you want to start your extraction. Same thing for the end. Then your subtract the start position from the end position and that would be the mid() function you would run on it. Example on a block of test that happens to be in a preformmated tag block: cfset begin = Find("pre", CFHTTP.FileContent) cfset end = Find("/pre", CFHTTP.FileContent) cfset return = end - begin + 6 We add the begin + 6 so it includes the end pre tag. The find on /pre returns the starting position of the and we want the starting position of the . So what you have is, if the first pre tag starts at position 400 and the end pre tag starts at position 600, then we want to extract (600 - 400 + 6) or 206 characters starting at position 400, or: cfoutput#mid(CFHTTP.FileContent, begin, return)#/cfoutput Which in reality is: cfoutput#mid(CFHTTP.FileContent, 400, 206)#/cfoutput You can basically search for any text that is never going to change and always be in the same position relative to the text you're trying to extract. If the beginning search string is before the text you want to extract, then add the number of characters (view the source, count the line breaks also) to the content you want to extract. Then you can add to the begin variable like this: cfset begin = Find("some html code", CFHTTP.FileContent) + 35 Of course, if the code you are trying to search on has quotes or pound signs in it, then I like to create a variable called searchstring using the ascii code for the special characters. Example, looking for table width="95%" bgcolor="#ff" cfset searchstring = "table width=" chr(34) "95% bgcolor=" chr(34) chr(35) "ff" chr(34) "" Then: cfset begin = Find(searchstring, CFHTTP.FileContent) Simple, huh? LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(OT) SQL Server?
hi all, how do we store .mpeg or .dat to be exact movies in SQL server?? wat would be the data type for it?? any ideas? thanx in advance akbar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Is it to be expected that a server may be down for 24 hours once in a while?
Hi, Is it to be expected that a server may be down for 24 hours? The server I use has been down since yesterday, and I'm trying to decide whether to should shift to a different server. It is true that this is the first time it has been down so long, but as I need to use it to do business on the Net, it is rather unsettling. However, I don't want to move if it is a situation that may normally happen on most servers from time to time. Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Online Sale: http://cfwarrior.homeip.net/hubert/onlinesales/ebay_links_page.htm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Holding On To DSN
That did not help, any other ideas? -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 02, 2000 11:56 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN put cflock tags around the query. you might even try cftransaction. Fred - Original Message - From: "Miriam Hirschman" [EMAIL PROTECTED] To: "CF Forum" [EMAIL PROTECTED] Sent: Saturday, September 02, 2000 11:55 PM Subject: CF Holding On To DSN I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFObjects v FuseBox
Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Javascript - Cold Fusion.
I thought I'd share my current solution to the 'getting the screen resolution problem' I posted a few days ago. Thanks to Peter Sharon... index.cfm: script language="JavaScript" function SetRez (form) { document.form.xrez.value = window.screen.width; document.form.yrez.value = window.screen.height; } /script ... form method="post" name="form" action="http://www.deliveru.com/public/index.cfm" onsubmit="javascript:SetRez(this.form);" ... Then in my app_globals, I just test the existance of the form VARs and set them up in client scope. It is not as good as I would like it to be, since I still have to do this form submit, but it works. If anyone can suggest a way to pass it via a URL instead, it would make me very happy. ;) Bill, This is untested, but should get you close. Put it in your app_globals (watch for line wrap): cfif NOT isDefined("Session.xrez") cfif NOT isDefined("URL.xrez") script language="JavaScript"!-- var myURL = "http://www.deliveru.com/public/index.cfm?" myURL += "xrez=" + window.screen.width; myURL += "yrez=" + window.screen.height; self.location.href = myURL; // -- /script cfelse cfset Session.xrez=URL.xrez cfset Session.yrez=URL.yrez /cfif /cfif Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFObjects v FuseBox
I think is what do you want to work with. I have looked in to a lot of coding methods for CF and really haven't seen anything that has made me really comfortable to work with. They all have merit and some people find them really helpful. If you're code right now is clean, can be easily distributed, and works fine and error free, why bother yourself with learning a coding specification. It's up to you, both communities have a lot of insight. Bob Everland -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 11:56 AM To: '[EMAIL PROTECTED]' Subject: CFObjects v FuseBox Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFObjects v FuseBox
Do u have your own coding policies? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: 03 September 2000 17:23 To: [EMAIL PROTECTED] Subject: RE: CFObjects v FuseBox I think is what do you want to work with. I have looked in to a lot of coding methods for CF and really haven't seen anything that has made me really comfortable to work with. They all have merit and some people find them really helpful. If you're code right now is clean, can be easily distributed, and works fine and error free, why bother yourself with learning a coding specification. It's up to you, both communities have a lot of insight. Bob Everland -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 11:56 AM To: '[EMAIL PROTECTED]' Subject: CFObjects v FuseBox Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFObjects v FuseBox
Not really. I just kind of lay my code out with how I want it. Comment it all over the place. Break up the queries. I have borrowed some things from Fusebox which is what a lot of people have done. I just never saw the point in calling everything from index.cfm. Breaking up the queries does make a lot of sense that way they are easier to mess with. Other than that you just kind of go with the flow. Bob Everland -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 12:19 PM To: '[EMAIL PROTECTED]' Subject: RE: CFObjects v FuseBox Do u have your own coding policies? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: 03 September 2000 17:23 To: [EMAIL PROTECTED] Subject: RE: CFObjects v FuseBox I think is what do you want to work with. I have looked in to a lot of coding methods for CF and really haven't seen anything that has made me really comfortable to work with. They all have merit and some people find them really helpful. If you're code right now is clean, can be easily distributed, and works fine and error free, why bother yourself with learning a coding specification. It's up to you, both communities have a lot of insight. Bob Everland -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 11:56 AM To: '[EMAIL PROTECTED]' Subject: CFObjects v FuseBox Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Holding On To DSN
On 9/2/00, Miriam Hirschman penned: I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Javascript - Cold Fusion.
thanks Ron. This looks like it should work. -Bill /intraget - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 03, 2000 12:07 PM Subject: RE: Javascript - Cold Fusion. I thought I'd share my current solution to the 'getting the screen resolution problem' I posted a few days ago. Thanks to Peter Sharon... index.cfm: script language="JavaScript" function SetRez (form) { document.form.xrez.value = window.screen.width; document.form.yrez.value = window.screen.height; } /script ... form method="post" name="form" action="http://www.deliveru.com/public/index.cfm" onsubmit="javascript:SetRez(this.form);" ... Then in my app_globals, I just test the existance of the form VARs and set them up in client scope. It is not as good as I would like it to be, since I still have to do this form submit, but it works. If anyone can suggest a way to pass it via a URL instead, it would make me very happy. ;) Bill, This is untested, but should get you close. Put it in your app_globals (watch for line wrap): cfif NOT isDefined("Session.xrez") cfif NOT isDefined("URL.xrez") script language="JavaScript"!-- var myURL = "http://www.deliveru.com/public/index.cfm?" myURL += "xrez=" + window.screen.width; myURL += "yrez=" + window.screen.height; self.location.href = myURL; // -- /script cfelse cfset Session.xrez=URL.xrez cfset Session.yrez=URL.yrez /cfif /cfif Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: trimming value???
crap I should have known that... It totally slipped my mind. Thank you very much. Chris Straight -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 1:57 AM To: [EMAIL PROTECTED] Subject: Re: trimming value??? #NumberFormat(myValue, 99.99)# Dave - Original Message - From: "Chris Straight" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 02, 2000 12:42 PM Subject: trimming value??? ok so I have calculated a percentage of a number and now I need to trim the number to 5 characters including the decimal point. it doesn't seem as if I can modify the values in an array without inserting a new value. I may be way off and I hope I am but does anyone know of how I could do this with ColdFusion? Chris Straight -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
State-County-City DB needed
If anyone has a State-County-City Database, could you please send it to me or a url where I could get it. Thank you, Don Sparks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Holding On To DSN
What host are you using? Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, September 03, 2000 2:10 PM Subject: RE: CF Holding On To DSN Hi. Thanks for responding. The tables that are referred to as well as the DSn have to be right because no matter which one I try the first one always works. It's just that when I link from one to the other or put the address in manually-that's when I get the error. Also, it is not my own servwer. Would that make a difference? -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN On 9/2/00, Miriam Hirschman penned: I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Holding On To DSN
It's a gov. server. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 2:46 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN What host are you using? Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, September 03, 2000 2:10 PM Subject: RE: CF Holding On To DSN Hi. Thanks for responding. The tables that are referred to as well as the DSn have to be right because no matter which one I try the first one always works. It's just that when I link from one to the other or put the address in manually-that's when I get the error. Also, it is not my own servwer. Would that make a difference? -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN On 9/2/00, Miriam Hirschman penned: I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RDS and services with batch-functionality ?
Hi, I have only RDS-access to a certain CF-server. Is there a possibility with the CF-RDS for move files via RDS on this machine other than load every file local and then say "Save as" to the remote server which is very uncomfortable ? Thank you. Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Notation help
I want to be able to save a query to a dynamically named Application variable and then refer to it. I can't figure out the correct notation to make it work. cfset x = 3 cfquery name="Application.ShowEvents#x#" datasource="calendar" SELECT Name, Date FROM EVENTS /cfquery This is the part I can't figure out. cfoutput#Application.ShowEvents.Date[1]#/cfoutput How do I notate it so I can refer to the dynamic Application variable? Any suggestions? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Notation help
I want to be able to save a query to a dynamically named Application variable and then refer to it. I can't figure out the correct notation to make it work. cfset x = 3 cfquery name="Application.ShowEvents#x#" datasource="calendar" SELECT Name, Date FROM EVENTS /cfquery This is the part I can't figure out. cfoutput#Application.ShowEvents.Date[1]#/cfoutput How do I notate it so I can refer to the dynamic Application variable? Use the Evaluate function: cfoutput#Evaluate("Application.ShowEvents#URL.x#.Date[1]")#/cfoutput Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [RE: How to display across a row instead of down?]
AH!! THAT's the solution I was looking for. I had seen it a long time ago, and foolishly believing I'd never need it, I discarded it, then when I was presented with the need for it, I couldn't remember how it went. Thanks Dan, that's just what I needed. Cheers, Mike Kear AFP Web Development Windsor, NSW, Australia On Sun, 3 Sep 2000, Dan Haley wrote: Yes, I'm hoping Mike realized he could ignore my answer . . . instead of thinking about how simple it was, I just modified my code that outputs a query in vertical rows. Go with the simplest solution Mike! table cfoutput query="myquery" cfif myquery.currentrow mod 3 eq 1 tr /cfif td#myquery.myfield#/td cfif myquery.currentrow mod 3 eq 0 /tr /cfif /cfoutput /table Dan -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/1/2000 10:29 AM Subject: Re: [RE: How to display across a row instead of down?] use MOD 3 in output Dan Haley [EMAIL PROTECTED] wrote: cf_untested confidence_level="medium" but="you get the idea" cfset variables.num_cols = 3 cfset variables.col_len = int((query.recordcount - 1) / variables.num_cols) + 1 cfloop from="1" to="#variables.col_len#" index="variables.i" cfloop from="1" to="#variables.num_cols#" index="variables.j" cfoutput #query.field[((variables.i - 1) * variables.num_cols) + variables.j]# /cfoutput /cfloop /cfloop /cf_untested Dan -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 11:12 PM To: [EMAIL PROTECTED] Subject: How to display across a row instead of down? I want to display the results of my query in 3 columns instead of one. I know the method is something to do with mod3, but I'm dashed if i can figure it out. What I want to get is: [record1] [record2] [record3] [record4] [record5] [record6] etc Can anyone help me please with how to code it? Cheers, Mike Kear AFP Web Development Windsor, NSW, Australia -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Filemaker on a MAC
Hi all, I've got a client who wants to use their MAC version of a Filemaker Pro database as the back end for their site. I've never gone anywhere near Filemaker before (or MACS for that matter). Leaving aside the client v server based differences arguments, which I've aleady made to the client... I'm very interested in finding out if anyone has used a MAC Filemaker database to drive a site and if there are any compatibility issues with our hosting platform (We have NT4 SP5 servers running MIIS4 and CF4.5 Ent). Or if it just can't be done? And, is working with a filemake file the same as working sith Access (i.e. just upload the file, make the connection and way you go?). Any tips/advice/comments/warnings are very very very welcome. Craig Harcombe Danaclese -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Filemaker on a MAC
There is a company called Boardtown (www.boardtown.com) that makes ISP billing systems. The data store is NT SQL Server, but some of the application is built with Filemaker. It is a really great application, so I would ask them for an opinion. They are pretty freindly folks over there. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 eMail: [EMAIL PROTECTED] Phone: 302-736-5515 Fax: 302-736-5945 -Original Message- From: Craig Harcombe [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 9:42 PM To: [EMAIL PROTECTED] Subject: Filemaker on a MAC Hi all, I've got a client who wants to use their MAC version of a Filemaker Pro database as the back end for their site. I've never gone anywhere near Filemaker before (or MACS for that matter). Leaving aside the client v server based differences arguments, which I've aleady made to the client... I'm very interested in finding out if anyone has used a MAC Filemaker database to drive a site and if there are any compatibility issues with our hosting platform (We have NT4 SP5 servers running MIIS4 and CF4.5 Ent). Or if it just can't be done? And, is working with a filemake file the same as working sith Access (i.e. just upload the file, make the connection and way you go?). Any tips/advice/comments/warnings are very very very welcome. Craig Harcombe Danaclese -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: (OT) SQL Server?
Hellow Akbar Use image data type to that field Thanx Ramesh -Original Message- From: Akbar [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 7:44 PM To: CF Talk (E-mail) Subject: (OT) SQL Server? hi all, how do we store .mpeg or .dat to be exact movies in SQL server?? wat would be the data type for it?? any ideas? thanx in advance akbar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFFILE DESTINATION question
I want to upload an image to a remote location. For example, a .JPG to my website which is hosted offsite. How would I phrase the destination CFFILE DESTINATION="c:\temp\" ACTION="upload" FILEFIELD="FileName" Thank you! -L -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using COM with CF
Hi Dave, Unfortunately CFSET does not work either. I can get at the object's public properties, but running the method does not work. I've tried using MSWord as a COM object and that did work. I'm at a loss. Thanks for the suggestion though. --Tom Unfortunately, using COM objects can be problematic with CF occasionally. Instead of doing what you're doing within a CFSCRIPT, you might have better luck doing it within CFSET tags: cfset rs = oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data") cfset rs = oASIWeb.SetDatabase("sdweb") cfset RetVal = oASIWeb.NewID("USERS") That usually works for me. To be honest, I've never used COM objects within CFSCRIPT, but I wouldn't be surprised if they're not supported within CFSCRIPT as well as they should be. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFILE DESTINATION question
You would need to know the "physical" location of the virtual web server your site is located at. They would need to advise you of this. Consider also that many CF hosts disable the use CFFILE in the administrator for security reasons. Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: LH Rothman [mailto:[EMAIL PROTECTED]] Sent: Monday, 4 September 2000 12:56 To: CF Talk Subject: CFFILE DESTINATION question I want to upload an image to a remote location. For example, a .JPG to my website which is hosted offsite. How would I phrase the destination CFFILE DESTINATION="c:\temp\" ACTION="upload" FILEFIELD="FileName" Thank you! -L -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: State-County-City DB needed
Hello Don, Email this guy... he sells db's for ZIP Codes.. etc. [EMAIL PROTECTED] Name is "Bud". Lee -Original Message- From: Donald Sparks [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 11:33 AM To: [EMAIL PROTECTED] Subject: State-County-City DB needed If anyone has a State-County-City Database, could you please send it to me or a url where I could get it. Thank you, Don Sparks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.