RE: Escaping Pound Signs in a CF Query....
I gave that a shot last night, to no avail... It just doesnt seem to like the pound sign(#) in the sql query. I'm trying to get the new db guy to change the field name, but it's going to take a while, so i'd like to create a workaround.. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Friday, September 01, 2000 12:04 AM To: '[EMAIL PROTECTED]' Subject: RE: Escaping Pound Signs in a CF Query Yes. Either change it Cust ## or something else like Cust num. This also applies to using the hex colour codes - eg: ##ff intead of the usual #ff - within CFOUTPUT. The double pound signs cancel out the usual CFOUTPUT requirement. 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: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 September 2000 5:00 To: Cf-Talk Subject: Escaping Pound Signs in a CF Query For some strange and utterly inconvenient reason, our former Access Database guy had created a form field named Cust#. I imagine this stands for CustNumber, but CF doesn't seem to agree. Is there a way to escape a # (pound sign) so i can query the table? I've tried doing a "Cust# As CustNum" as well as Cust##. Nothing seems to work. Anyone know of anything? Thanks In Advance!! Mark Armendariz Righteous Design -- 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.
Escaping Pound Signs in a CF Query....
For some strange and utterly inconvenient reason, our former Access Database guy had created a form field named Cust#. I imagine this stands for CustNumber, but CF doesn't seem to agree. Is there a way to escape a # (pound sign) so i can query the table? I've tried doing a "Cust# As CustNum" as well as Cust##. Nothing seems to work. Anyone know of anything? Thanks In Advance!! Mark Armendariz Righteous Design -- 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.
Can I get the Client's Time instead of the Server's?
Is there a way to do a Now() of some sorts in CF to get the client's present time instead of the server's? Thanks in Advance Mark Armendariz -- 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: Can I get the Client's Time instead of the Server's?
perfect... justin, i appreciate the example. and thanks to dave watts for the js explanation... Mark -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 11:48 AM To: [EMAIL PROTECTED] Subject: Re: Can I get the Client's Time instead of the Server's? You need to use a little Javascript on the client to pass the uses timezone to the server The following will write a hidden field containing the offset in minute between the locale time and GMT script n = new Date(); str = "input type='hidden' value='" + n.getTimezoneOffset() + "' name='offset'"; document.write(str); /script or you chould write it to a cookie for later use.. You can store the offset in a session var ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Monday, August 28, 2000 4:28 PM Subject: Can I get the Client's Time instead of the Server's? Is there a way to do a Now() of some sorts in CF to get the client's present time instead of the server's? Thanks in Advance Mark Armendariz -- 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: How do I get my Current URL
You are king!! (I had done it with javascript, but prefer the CF way...) Thanks... -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 5:28 PM To: [EMAIL PROTECTED] Subject: RE: How do I get my Current URL The following works within a CF page: Current URL is http://#CGI.SERVER_NAME##CGI.PATH_INFO# Hope this helps H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division ] -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:58 AM To: Cf-Talk Subject: How do I get my Current URL I've done this 100's of times, and I've drawn a blank. How do I get the current URL of the page I'm working on (full URL with parameters) within a variable? I'm trying to do a "Print This Page" button which will, with an additional parameter of Print=1, kill the menus and titles and print the page. I have all the javascript and other functionality in place, I just need the link that refers to the currentpage with the added parameter. Thanks... Mark Armendariz Righteous Design www.sorighteous.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. -- 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: Access 97 and 2000
Taken from the MS Knowledge Base (I had this same issue) at: http://support.microsoft.com/support/kb/articles/Q241/1/41.ASP?LN=EN-USSD=g nFR=0 --- One error message you may receive is: Microsoft Access can't start because there is no license for it on this machine. To resolve this behavior, follow these steps: Click Start, point to Find, and then click Files or Folders. In the Named box, type Hatten.ttf. In the Look In box, type C:\Windows\Fonts or the path to the Fonts folder on your computer. If you are not sure of the font folder's location, open Windows explorer and verify the directory where Windows is installed. Note: If you are on Windows NT 4.0, the path may be C:\WINNT\Fonts Click Find Now to start the search. Under Name, right-click the Hatten.ttf file, and on the menu that appears, click Rename. Change the name of the file to Hatten.sav. NOTE: You can find the Hatten.ttf file in the Fonts folder under the name, Haettenschweiler Insert your Access 97 or Office 97 CD into the CD-ROM or DVD-ROM drive. Click Start, and then click Run. Type the command to run the Microsoft Access Setup program and use the /y switch to reregister Access 97. For example, type: D:\Setup.exe /y In the Installation Maintenance Program dialog box, click Reinstall. The Setup program updates the system registry for Access. When Setup is finished, start Access. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 10:52 AM To: '[EMAIL PROTECTED]' Subject: RE: Access 97 and 2000 A miracle No really - I think you need to have them installed on a seperate drive, or partition - but I'm not 100% sure -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: 22 August 2000 18:55 To: [EMAIL PROTECTED] Subject: OT: Access 97 and 2000 What does it take to run both Access 97 and Access 2000 on the same machine? We have some small CF db's in Access 97. We have a development machine with Office 2000 and tried to install only the Access portion of Office 97 on the same machine. When we try to start either version of Access, we now get this message: "Microsoft Access can't start because there is no license for it on this machine." Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- 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: 4.5.1 memory leak? is this really a leak we are talking about ?
Well.. just to not feel left out, CF Studio 4.5 crashes about 3 to 5 times an evening on my Win 2000 system.. (192 MB Memory) -Original Message- From: Andrew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 15, 2000 2:51 PM To: [EMAIL PROTECTED] Subject: Re: 4.5.1 memory leak? is this really a leak we are talking about ? It's not just on his particular Win 98. I've heard quite a few complaints about it, in fact I had the same thing myself and it was immensely annoying. I upgraded to Win 2k and the problem completely dissappeared. Andrew Hewitt Web Application Developer webworld studios, inc. - Original Message - From: "Helge Hetland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 15, 2000 11:11 AM Subject: RE: 4.5.1 memory leak? is this really a leak we are talking about ? I'm sure that you'd be better off saying that CF Studio is crashing on your particular Win98 machine after a few minutes. You cannot make me believe that this is CF Studio's "default behaviour" on Win98 Sorry. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: 15. august 2000 17:01 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: 4.5.1 memory leak? is this really a leak we are talking about ? Actually, I was speaking of Cold Fusion Studio's memory leaks. It will crash Windows-98 in minutes. It's completely unusable. Windows-NT/2000 has better memory protection and will fare better. -- 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: Browser / desktop resolution
yeah!!! -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 11:22 PM To: [EMAIL PROTECTED] Subject: Re: Browser / desktop resolution What have you tried?? Ever looked into JavaScript?? I am going to be frank and apologize to everyone for this. I have been watching this list for 2 weeks and the mass of amounts of email being sent on a daily basis is annoying. There are some really good subjects in some of them but reading through them all is difficult to say the least. Maybe I will just look through the archives if I need anything. Now, comes my *whining*. -8--- snip ---8- Well, my take on it is this ... It was a legitimate ColdFusion question no matter how inappropriate or trivial it may have seemd to some. Your comment about "Ever looked into JavaScript??" was pointless. The question was, "Is it possible to do with ColdFusion?", not "Is it possible?". Maybe this person is new to ColdFusion and hasn't quite grasped the idea that it is strictly server-side. Or, maybe they do, but were still wondering if it could be detected server-side, etc. Maybe they were really asking if anyone has come up with a snazzy new way to do it. I understand that we should all mess around with the code and learn from trying new things and having to figure them out, but if we were expected to do that with every single thing we ever wanted to do, there would be absolutely no need for all those handy custom tags floating about. There also wouldn't be a need for fusebox or any structured, organized coding style of any sort. Besides, for the one person who asks a question on this list, there are probably 50 who are curious but have never bothered to ask, or are curious now that the question has been posed because they never even thought about it before. If someone answers the question, then everyone who is even remotely curious now knows the answer and can file it away for future use .. or at least remember if it is indeed possible so they will have a better idea where to and where not to look in the future if they need to. I thought we were all on this list to learn as much about the aspects related to ColdFusion as we can .. even the things we didn't think we wanted to know? As I have learned on this list every day, you can never have enough information. Todd -- 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.
From .exe to .dll
I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [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: From .exe to .dll
YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [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. -- 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: From .exe to .dll
I appreciate the quick reply... As for the cfx.h library. Would we just have to compile the code with an inclusion of cfx.h or is there any changes that would actually have to be made to the code itself? I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on Monday. THANKS!! -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll If you have the source code I would recommend wrapping the code in a cfx_tag. It's very simple. For example of cfx source code in C/C++ Have a look at the excellent www.intrafoundation.com . There is also some info in Ben's advanced book and plenty of help(!?!!?) on this list :-) If all that fails you chould use cfexecute ( or CFX_consoleCommand @ intrafoundation.com ) to capture the input from the dos program.. ~Justin MacCarthy - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 3:23 PM Subject: RE: From .exe to .dll YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [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. -- 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.
CFX_NNTP and Formatting
I'm using the CFX_NNTP tag from www.fuseware.com. Using the GetMessages Action, the output give the following variables from the newsgroup message headers: MessageID From Subject Date References Byte Count Line Count I've never built a newsgroup or forums application before, so I'm not really familiar with the 'standard' formatting. Do any of you guys/gals have any experience with properly formatting newgroup output within CF so it looks like 'the newsgroup look'. I'm just not to sure how to set up the groupings and such. Thanks!! Mark Armendariz Aspen Resreach Group [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: Need your help desperately...
With all due respect as a fellow CF developer, if you expect a certification to get you a job, then you are cheating yourself. Show good work and stay in the forefront and it doesn't matter who cheated and who studied for the test. I know a few people that had to cheat the MS exams just to get their foot in the door. Couldn't afford college, just enough money to cheat a certification. Now they are some of the finest network admins out there. An exam is nothing more than a review. If the piece of paper makes you more confident... good. That's all it's truly good for. And quite honestly, within the past year or so (disregard the years prior - the 'static' years), I haven't met a single successful developer / designer who didn't have any good work to show for it. But i HAVE met quite a few 'certified' unemployed 'developers'. CFX_HaveaGoodDay user="Mark" server="www.sorighteous.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: Multiple value Select
Sorry I couldn't get back in time.. i was on a road trip. thanks for the extra push Katrina, I was stumbling, there. -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 3:10 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select It works!!! Thank you so much to everyone who helped along the way. My goal is to one day be 1/10th as helpful to the list as the list has been to me. At this point (given how much I get and how little I now know), that's a huge goal. Thanks again. Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select I am using Outlook Express, and have it set up to reply to messages in their original format, which in this case is HTML, or to compose new messages in plain text. For some reason the list is not properly handling the mime conversion. To see if perhaps this is fixed, I have changed it to send in plain text only, regardless of the format of the incoming message. It has been annoying to me, because other messages besides mine have been turned to mush. DC - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 09, 2000 17:03 Subject: RE: Multiple value Select The 3D shouldn't be there. It's because a very bad David;) is sending messages in HTML format, or some format other than plain text. Just remove any 3D's you may have copied and it should work. --K -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 8:50 AM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I copied the code into the document. Now it's not liking the first quote in the CFSELECT statement: cfselect name=3D"NewPG" size=3D"3" multiple Did I just misunderstand what the 3D represented? Is there just a syntax error I'm not seeing. Tried to find some reference to it in the books I have (I assumed it stood for dimension?) with no luck. TIA, Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 7:42 AM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select This is a multi-part message in MIME format. --=_NextPart_000_00EF_01C001FF.3F8198C0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable RE: Multiple value SelectOk, now we have a bit of information. Try this: cfselect name=3D"NewPG" size=3D"3" multiple=20 CFOutput query=3D"GetPG" !--- OPENING CFOUTPUT ---=20 CFIF ListFindNoCase(EditNameQry.PracticeGroup,GetPG.PG)=20 CFSET PGSelected =3D "Selected"=20 CFELSE=20 CFSET PGSelected =3D ""=20 /cfif=20 Option #PGSelected# value=3D"#PG#"#PG#/option !--- NO=20 CFOUTPUTS ---=20 /cfoutput !--- CLOSING CFOUTPUT ---=20 /cfselect=20 Change the order of the parameters to the = Listfindnocase()/Listcontains() functions. If EditNameQry.PracticeGroup = is a comma seperated list and GETPG.PG is a single value, this should = work. DC - Original Message -=20 From: Gieseman, Athelene=20 To: '[EMAIL PROTECTED]'=20 Sent: Tuesday, August 08, 2000 21:36 Subject: RE: Multiple value Select No. That field would have multiple items in a comma-delimited format. = Not=20 even the first option is selected.=20 Athelene=20 -Original Message-=20 From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 4:33 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 This may be a stupid question but the query EditNameQry is only = pulling one=20 value for PracticeGroup. Right? If not I'm sure that when you "view=20 source" you'll see that more than one option is "SELECTED". That will = confuse the browser and it will stay on the first option.=20 --K=20 -Original Message-=20 From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 2:04 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 Yo may have a point.. try putting quotes around = EditNameQry.PracticeGroup.=20 Plus, if I replace=20 CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)=20 with=20 CFIF ListContains(GetPG.PG,"Agribusiness")=20 the Agribusiness option is selected. So I think I'm doing something = wrong=20 in how I'm using the second parameter of the ListContains.=20 -Original Message-=20 From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20 Sent:
RE: Multiple value Select
I did this sort of thing for an intranet i'm working on with selected company newsgroups... The best way to do it is with a database of your finance types. This will allow you to updae the select statement without changing the hard coding. So the form will always be right. Query that database and the user database. In the user database, you will want to save a comma delimited list of the finance types they are assigned for. When you bring up the select, you can scroll through all the finance types, and if the user had any in his/her list, they will set the FinanceSelected variable to 'selected.' if they're not in the list, FinanceSelected will be blank. Hope this helps... CFQuery Name="GetFinances" datasource="#Application.datasource#" SELECTFinanceName FROM tblFinances ORDER By FinanceName /CFQuery CFQuery Name="GetCustomer" datasource="#Application.datasource#" SELECTCustomerName, Address, Finances!--- This Field is a comma delimited list of the user's finances --- FROM tblCustomers WHERE CustomerID = #Attributes.CustomerID# /cfgquery Finances:br Select Name="Finances" size="#GetFinances.RecordCount#" multiple CFLoop query="Finances" CFIF ListContains(GetCustomer.Finances,#FinanceName#) CFSET FinanceSelected = "Selected" CFELSE CFSET FinanceSelected = "" /cfif Option #FiannceSelected# value="#FinanceName#"#FinanceName#/option /cfloop /select Mark Armendariz Righteous Design www.sorighteous.com [EMAIL PROTECTED] -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 6:34 PM To: [EMAIL PROTECTED] Subject: Multiple value Select I'm trying to set up a CFSELECT using the SELECTED option. I need to have the CFSELECT set up as multiple since more than one option is permitted. However, I can never seem to get the SELECTED option to properly highlight the options that are already stored in the record. (In other words, I want to create an edit screen where the previously stored values are preselected in this control.) Any thoughts on what I may be doing wrong? The code for my select follows: (Note that ViewGrid is a grid from which the user previously selected this record. I've also tried doing this from a query with the same result - nothing is selected.) cfselect name="FinanceType" size="2" selected="#ViewGrid.FinanceType#" multiple option value="Single Family Housing"Single Family Housing/option option value="501(c)(3)"501(c)(3)/option option value="Hospital Revenue"Hospital Revenue/option option value="Leasehold Revenue"Leasehold Revenue/option option value="Multifamily Housing"Multifamily Housing/option option value="General Obligation"General Obligation/option option value="NID"NID/option option value="Special Obligation"Special Obligation/option option value="Industrial Development"Industrial Development/option option value="TIF"TIF/option option value="TDD/TC"TDD/TC/option option value="Other"Other/option /cfselect -- 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: Multiple value Select
Try replacing the cfloop with cfoutput like so: cfquery datasource="FirmDirectory" name="EditNameQry" Select* FROM Employees WHERE ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select* FROM PracticeGroups ORDER BY PG /cfquery cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option /cfoutput /cfselect I had the CFLoop in there because i had cfoutputs around it in my code... this should do it for you, if not, let me know... -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I have another application where I do in fact use a table for the lookup. I've tried to use your example and apply it here. But nothing is selected. My code is as follows: cfquery datasource="FirmDirectory" name="EditNameQry" Select * from Employees where ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select * from PracticeGroups order by PG /cfquery cfselect name="NewPG" size="3" multiple CFLoop query="GetPG" CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"cfoutput#PG#/cfoutput/option /cfloop /cfselect Note that if I replace the : CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) with: CFIF ListContains(GetPG.PG,"Agribusiness") Then Agribusiness is in fact selected. So I'm assuming there's something wrong with that one line. Do you happen to see where I went wrong? TIA, Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 7:44 AM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select I did this sort of thing for an intranet i'm working on with selected company newsgroups... The best way to do it is with a database of your finance types. This will allow you to updae the select statement without changing the hard coding. So the form will always be right. Query that database and the user database. In the user database, you will want to save a comma delimited list of the finance types they are assigned for. When you bring up the select, you can scroll through all the finance types, and if the user had any in his/her list, they will set the FinanceSelected variable to 'selected.' if they're not in the list, FinanceSelected will be blank. Hope this helps... CFQuery Name="GetFinances" datasource="#Application.datasource#" SELECTFinanceName FROM tblFinances ORDER By FinanceName /CFQuery CFQuery Name="GetCustomer" datasource="#Application.datasource#" SELECTCustomerName, Address, Finances!--- This Field is a comma delimited list of the user's finances --- FROM tblCustomers WHERE CustomerID = #Attributes.CustomerID# /cfgquery Finances:br Select Name="Finances" size="#GetFinances.RecordCount#" multiple CFLoop query="Finances" CFIF ListContains(GetCustomer.Finances,#FinanceName#) CFSET FinanceSelected = "Selected" CFELSE CFSET FinanceSelected = "" /cfif Option #FiannceSelected# value="#FinanceName#"#FinanceName#/option /cfloop /select Mark Armendariz Righteous Design www.sorighteous.com [EMAIL PROTECTED] -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 6:34 PM To: [EMAIL PROTECTED] Subject: Multiple value Select I'm trying to set up a CFSELECT using the SELECTED option. I need to have the CFSELECT set up as multiple since more than one option is permitted. However, I can never seem to get the SELECTED option to properly highlight the options that are already stored in the record. (In other words, I want to create an edit screen where the previously stored values are preselected in this control.) Any thoughts on what I may be doing wrong? The code for my select follows: (Note that ViewGrid is a grid from which the user previously selected this record. I've also tried doing this from a query with the same result - nothing is selected.) cfselect name="F
RE: Multiple value Select
take the cfoutput tags out of the options and put them within the entire select tag: cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" !--- OPENING CFOUTPUT --- CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option !--- NO CFOUTPUTS --- /cfoutput !--- CLOSING CFOUTPUT --- /cfselect -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:44 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select Still no luck. I also added an rtrim function to each of the fields in that line. And I've tried David's suggestion of using listcontainsnocase. Still no luck. I also changed the code this way: CFIF listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup)) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "Not Selected" /cfif Option #PGSelected# value="#PG#"cfoutput#PG# #PGSelected#/cfoutput/option so that I would be able to see if the PGSelected was being set at all. When I use this code, the output on all of the options has "Not Selected" after it. So I believe the problem is that the listcontains never finds a match. I've changed the database from a char to a varchar (based on earlier posts about that issue), edited all of the records in the file to eliminate any extra spaces at the end, used the rtrim function. And still it's not ever finding a match. I appreciate the continuing help! This one is making me crazy (well, more crazy than usual.) Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select Try replacing the cfloop with cfoutput like so: cfquery datasource="FirmDirectory" name="EditNameQry" Select* FROM Employees WHERE ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select* FROM PracticeGroups ORDER BY PG /cfquery cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option /cfoutput /cfselect I had the CFLoop in there because i had cfoutputs around it in my code... this should do it for you, if not, let me know... -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I have another application where I do in fact use a table for the lookup. I've tried to use your example and apply it here. But nothing is selected. My code is as follows: cfquery datasource="FirmDirectory" name="EditNameQry" Select * from Employees where ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select * from PracticeGroups order by PG /cfquery cfselect name="NewPG" size="3" multiple CFLoop query="GetPG" CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"cfoutput#PG#/cfoutput/option /cfloop /cfselect Note that if I replace the : CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) with: CFIF ListContains(GetPG.PG,"Agribusiness") Then Agribusiness is in fact selected. So I'm assuming there's something wrong with that one line. Do you happen to see where I went wrong? TIA, Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 7:44 AM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select I did this sort of thing for an intranet i'm working on with selected company newsgroups... The best way to do it is with a database of your finance types. This will allow you to updae the select statement without changing the hard coding. So the form will always be right. Query that database and the user database. In the user database, you will want to save a comma delimited list of the finance types they are assigned for. When you bring up the select, you can scroll through all the finance types, and if the user had
RE: Multiple value Select
Yo may have a point.. try putting quotes around EditNameQry.PracticeGroup. Plus, if I replace CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) with CFIF ListContains(GetPG.PG,"Agribusiness") the Agribusiness option is selected. So I think I'm doing something wrong in how I'm using the second parameter of the ListContains. -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:18 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select No luck. I think there's a problem in that the listcontains isn't finding any matches. I can't figure out why. I display the previously selected items in another part of the form and it is identical to the options in the database. There is a comma separating the selected items. For example, the record viewed via SQL shows: "Agribusiness,Commercial Litigation" (less the quotes) in the field. Both of those practice groups are identically listed in the GetPG.PG list. Yet neither of them are showing up selected in the control. Plus, if I replace CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) with CFIF ListContains(GetPG.PG,"Agribusiness") the Agribusiness option is selected. So I think I'm doing something wrong in how I'm using the second parameter of the ListContains. Athelene -----Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:00 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select take the cfoutput tags out of the options and put them within the entire select tag: cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" !--- OPENING CFOUTPUT --- CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option !--- NO CFOUTPUTS --- /cfoutput !--- CLOSING CFOUTPUT --- /cfselect -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:44 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select Still no luck. I also added an rtrim function to each of the fields in that line. And I've tried David's suggestion of using listcontainsnocase. Still no luck. I also changed the code this way: CFIF listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup)) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "Not Selected" /cfif Option #PGSelected# value="#PG#"cfoutput#PG# #PGSelected#/cfoutput/option so that I would be able to see if the PGSelected was being set at all. When I use this code, the output on all of the options has "Not Selected" after it. So I believe the problem is that the listcontains never finds a match. I've changed the database from a char to a varchar (based on earlier posts about that issue), edited all of the records in the file to eliminate any extra spaces at the end, used the rtrim function. And still it's not ever finding a match. I appreciate the continuing help! This one is making me crazy (well, more crazy than usual.) Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select Try replacing the cfloop with cfoutput like so: cfquery datasource="FirmDirectory" name="EditNameQry" Select* FROM Employees WHERE ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select* FROM PracticeGroups ORDER BY PG /cfquery cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option /cfoutput /cfselect I had the CFLoop in there because i had cfoutputs around it in my code... this should do it for you, if not, let me know... -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I have another application where I do in fact use a table for the lookup. I've tried to use your example and apply it here. But nothing is selected. My code is as follows: cfquery datasource="FirmDirectory" name="EditNameQry" Select * from Employees where ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select
RE: Formatting Data
I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. 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.
RE: Studio replacing characters
hey.. you have an extra symbol in there... you have: option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option get rid of the after the value="3" it should be: option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:04 PM To: [EMAIL PROTECTED] Subject: RE: Studio replacing characters That's the point Kevin. It shouldn't but it is. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters option value="3" cfif getproduct.status is3 SELECTED /cfif Unavailable/option In this example it is in the HTML. It shouldn't replace it if it is part of a tag. - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:46 PM Subject: RE: Studio replacing characters But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- 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. -- 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: Quick Poll - What d you want in a host?
large selection of custom tags plus the liberty of adding my own and to have system dsn's added a.s.a.p -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Quick Poll - What d you want in a host? Okay guys, I would like to know what everyone considers important in a CF hosting environment. Are you looking for a development environment, or a place to host things for your customers? or both? what other requirements do you have for a host? In case you couldn't tell, we are considering opening our servers up to outside developers -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts I want whatever you have Will pay postage *** -- 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.
cfx's and dll's
This is a multi-part message in MIME format. --=_NextPart_000_0020_01C000A7.71853E70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit A software company client of mine has a password program that they use in order to generate monthly billing passwords for their software. They have converted this application into a dll for use with their current access database that they use company wide. I am currently building an intranet for them. I had been wondering if anyone could point me (and the programmers as well) in the right direction as to how to set the dll up so that it will take input from a cfm request and reply with readable output or variable for another cfm page. Thanks... Mark Armendariz Mark Armendariz Righteous Design www.sorighteous.com [EMAIL PROTECTED] --=_NextPart_000_0020_01C000A7.71853E70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4030.2400" name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2 DIVSPAN class=3D455463816-07082000FONT face=3DArial size=3D2A = software company=20 client of mine has a password program that they use in order to generate = monthly=20 billing passwords for their software.nbsp; They have converted this = application=20 into a dll for use with their current access database that they use = company=20 wide.nbsp; I am currently building an intranet for them.nbsp; I had = been=20 wondering if anyone could point me (and the programmers as well) in the = right=20 direction as to how to set the dll up so that it will take input from a = cfm=20 request and reply with readable output or variable for another cfm=20 page./FONT/SPAN/DIV DIVSPAN class=3D455463816-07082000FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D455463816-07082000FONT face=3DArial=20 size=3D2Thanks.../FONT/SPAN/DIV DIVSPAN class=3D455463816-07082000FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVFONT face=3DArial size=3D2Mark Armendariz/FONT/DIV DIVnbsp;/DIV/FONT/DIV DIV DIVFONT size=3D2SPAN class=3D094155602-31032000Mark=20 Armendariz/SPAN/FONT/DIV DIVFONT size=3D2SPAN class=3D094155602-31032000Righteous=20 Design/SPAN/FONT/DIV DIVFONT size=3D2SPAN class=3D094155602-31032000A=20 href=3D"http://www.sorighteous.com/"www.sorighteous.com/A/SPAN/FONT= /DIV DIVFONT size=3D2SPAN class=3D094155602-31032000A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/SPAN/FON= T/DIV/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0020_01C000A7.71853E70-- -- 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: Help with CFQUERY/Update
i may just be reaching, but is the Member_number field in your database a number field or a text field? -- 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: I need a host. Intermedia testimonials
paul... do you use shanje? how are they? -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 12:56 AM To: [EMAIL PROTECTED] Subject: Re: I need a host. Intermedia testimonials Check out http://www.shanje.com/ best, paul At 09:04 PM 8/7/00 -0500, you wrote: I need a host. and I gather from cftalk that Intermedia is the winner. I am interested in hearing testimonials or other alternatives. 1 client, 10 domains and growing. Thanks Eric Dawson -- 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: I need a host. Intermedia testimonials
I was pretty amazed when i checked out what they're offering. After i picked my chin up off my keyboard and backspaced over all the spaces it caused i had wondered about their reliability. Has anyone used these guys? How reliable are they? Being that all supportis via email, how good is the response time? -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:30 AM To: [EMAIL PROTECTED] Subject: RE: I need a host. Intermedia testimonials No I don't use them. But I will in the future. I am constantly impressed with Shiloh and the technology he's developed to deliver reliability. And the price is super. best, paul At 01:30 AM 8/8/00 -0400, you wrote: paul... do you use shanje? how are they? -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 12:56 AM To: [EMAIL PROTECTED] Subject: Re: I need a host. Intermedia testimonials Check out http://www.shanje.com/ best, paul At 09:04 PM 8/7/00 -0500, you wrote: I need a host. and I gather from cftalk that Intermedia is the winner. I am interested in hearing testimonials or other alternatives. 1 client, 10 domains and growing. Thanks Eric Dawson --- - -- 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: Help with updating a database
You could try to include the form into the cfoutput tags, so that each product would have it's own editing form. Here's a rough idea of what i'm saying: CFQuery name="GetProducts" datasource="#Application.ds#" SELECTProductID, CategoryID, ProductName, Description, Price, Weight FROM tblProducts /cfquery CFOutput query="GetProducts" Form method="post" action="UpdateProduct.cfm" Table TR TDProduct Name:/TD TDinput type="text" name="ProductName" value="#ProductID#" size=20/TD /tr TR TDDescription:/TD TDtextarea cols=30 rows=2 wrap="virtual" name="Description"#Description#/textarea/TD /tr TR TDPrice:/TD TDinput type="text" name="Price" value="#Price#" size=5/TD /tr TR TDinput type="hidden" name="ProductID" value="#ProductID#"/TD TDinput type="submit" value="Update #ProductName#"/TD /tr /table /form /cfoutput ...This way, whichever row you edit, once you hit enter, it will submit the contents of the form on that row only. That allows you to avoid the hassles of naming. The other oprion would be to include #GetProducts.CurrentRow# as part of the field names to produce a different field name for each row of the query... Hope this helps.. -Original Message- From: Chris Farrugia [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 11:40 PM To: [EMAIL PROTECTED] Subject: Help with updating a database Good day, I am creating the site for my computer store, where a user will be able to custom configure a new PC. Currently I am stuck creating an administration page where I can update the prices in my database. The table has fields (ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price, Weight). I want on the admin page for there to be all of the products listed in form text boxes. If I want to edit one, I can change the content of that text box and then hit the submit button and it edits the database. The problem I'm running into is that I can't name the form fields the same thing because then it won't know which to edit... Can anybody explain how I would do this? I am very new to coldfusion. Thank you for the help. Sincerely, Chris Farrugia -- 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: Hosting Solutions???
Powersurge.net is pretty good. 24-hour support, even though thgey usually answer an email within 5 - 10 minutes and some good rates. -Original Message- From: john ellard [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 6:42 PM To: [EMAIL PROTECTED] Subject: Re: Hosting Solutions??? This might open a debate that I would be very interested in :-) We are on the verge of abandoning shared CF servers in favour of pure colocation because of the hassles. I have made comments on this mail below but I'd really welcome views - my conclusions are (as they should be) at the end of that. At 14:34 04/08/00 -0400, you wrote: Ok I am looking for a GOOD hosting solution that will allow me to use CF 4.5 and SQL Server 7.0. I dont want a dedicated server, just shared server if possible, I am with Intermedia right now and for the last week their service has SUCKED because they 1. put too many people on each server Can't comment on any other hosting company, but just how is one supposed to know how many is too many?? It really depends on a myriad of factors, none of which are generally clear at site launch to either the hosting outfit or the client. 2. dont monitor sites for BAD CODE that could bring the server to a screeching halt so in the last week my site has been up and down DAILY. Which is UNACCEPTABLE, they just say "well there is nothing we can do about it" Bull CRAP! Now just precisely how do you monitor for 'bad code'? Obviously if CPU hits the roof for prolonged periods it's a symptom, but by then it's a bit late. There are plenty of so-called developers out there who are incompetent, but short of examining each template, each SQL statement in detail how does the hosting company adjudicate? Even then proving that a client is the culprit can be difficult and contentious. Anyway Media3 I was going to go with until they too FOREVER to set up my account, maybe they were just having a bad day? So if you use them has your experience been good? The things I am looking for are reliablity and support that is EASY to contact. For instance intermedia you can ONLY CONTACT by email which is RIDICULOUS when hosting BUSINESS applications. If anyone can recommend a reliable CF/SQL hosting solution for no more than 75/95 a month please let me know. So you want policing, code-checking, voice support, and all that for 75-95/month. Yet you don't want your own server, just to share. And you shout about the difficulty in finding such a service because you're talking about a business application? My own view is that you get what you pay for. If your 'business application' is that critical surely it merits a dedicated server. Overall I think you raise a number of issues that perplex both shared-server users and hosting companies, and these include: 1. How do hosting companies police CF developers? 2. What sanctions are reasonable where a site harms others on the same box? 3. Where does support end and free CF consultancy begin? We have plenty of 'naughty' users whose response to a complaint about the behaviour of their templates is to seek advice from our support desk on how to fix their bad code. My own views remain vague about these questions, and we're inclined to move to pure box-hosting since that way all we have to provide is bandwidth, electricity and rack space. And that increases revenue, simplifies support, and stops shouty emails :-) Does anyone out there have any (non-CAPITALISED) views? Thanks Kelly for focusing my mind on a current problem s John -- 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: Hosting Solutions???
yes they do allow cffiles, cfdirectories, and they also allow you to add your own custom tags and cfx's -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 9:34 PM To: [EMAIL PROTECTED] Subject: Re: Hosting Solutions??? Powersurge.net is pretty good. 24-hour support, even though thgey usually answer an email within 5 - 10 minutes and some good rates. Do you know if they have cffile and cfdirectory (or cfx_file and cfx_directory) and cfmail available? c -- Chris Lott [EMAIL PROTECTED], Technical Manager UAF Center for Distance Education p907.474.5122 | f907.474.5402 | PGP Key ID: 0x51046CFD -- 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.