Re: how to access a server that is behind a firewall with cfserver
One way is to put a stub program on the server behind the fw. Then have a CF program outside the fw pass SQL statements to the stub (CFHTTP). The stub issues the SQL statements against the db & passes the results to the caller. The data is all passed using WDDX. I use this technique all the time to move data between mutually inaccessable SQL servers. HTH Dick At 2:59 PM -0400 6/2/2000, Gilles Ratte wrote: >The problem I have is that that client database is on the same server than >the web root and I think it's not right. > >I would like to move that ms access database to the other server behind the >firewall and have access to the database via CF. > >Can somebody guide me on how to do it? > >Thanks in advance > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through form fields
(I posted this yesterday, seems to have gotten lost) Do the PROJECT_COMPONENTS bit outside of the loop and put a condition in the loop to ignore that field: PROJECT_COMPONENTS - #evaluate("PROJECT_COMPONENTS ")# #field#-#evaluate("#field#")# If you need output in a particular order you could start juggling string variables. Or set a count to do PROJECT_COMPONENTS once inside the loop, then ignore it all other times. HTH - Original Message - From: Steve Robson <[EMAIL PROTECTED]> To: House of Fusion (E-mail) <[EMAIL PROTECTED]> Sent: Friday, June 02, 2000 12:18 PM Subject: Looping through form fields > WinNT4, CF4.5 > > I am trying to loop through the formfields and send them to an email > address. One of the fields (PROJECT_COMPONENTS) allows the user to select > multiple entries, unfortunately when the user selects more than one option, > the loop outputs the list of selected entries for each entry selected: > > LEAD_CONSULTANT-dafhadf > > PROJECT_COST-dfh > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > PROJECT_COMPONENTS- > Hosting,E-Commerce,Security,Connectivity,Web_design,Development,CAG,BPR,Test > ing > > INITIAL_MEETING- > > INITIAL_PROPOSAL- > > . . . > > Does anyone have any ideas? > > Thanks > > Here is my code: > > > > > #field#-#evaluate("#field#")# > > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL auto-increment with trailing category identifier.
HELP! I've posted this twice. Does anyone know how to do this? - > Does anyone know the best way to create autonumbers using SQL 7.0 similar > to the following: > > First Document ever created in NY where NY = code "01", DocID = 901-01 > 2nd Document ever created in NY = DocID = 902-01 > > First Document created in MD (Code = "02"), DocID = 901-02 > 2nd Document created in MD = 902-02 > > First Drawing created in NY site = DocID = 801-01 > 2nd Drawing in NY = 802-01 > > So grab the doctype (drawing or doc) AND the site off the form, query > against some tables and determine next number, then assign it with the > trailing suffix. Can I use "01" or "02" as some sort of trailer and still > use an identity type field or do I have to define it as integer or alpha > type? I could also use ".02" and ".01" if that would make it easier > (i.e., I could use a number type versus alpha). Much thanks to any > insight anyone has to offer! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Sending an attachment vie email (CF Newbie)
Hi Lee, Amend your plan as: Upload the file to the server using CFFILE with the input type="file" form element, also gathering the recipient's e-mail address and possibly a message to go along with the file. Use CFMAIL to send the message with the file attached. Good luck! -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 04, 2000 6:03 PM To: [EMAIL PROTECTED] Subject: Sending an attachment vie email (CF Newbie) I've got a client, that against my advice, wishes to have a form on his site that a customer can use to email a file attachment (such as a Word or Excel file) to the intended recipient. No problem building the form or anything, but I'm not sure how to go about getting the file emailed. I suppose that it needs: 1. email file from customer to server 2. email file from server to recipient I do *NOT* have server access as it's shared hosting. Could somebody please point me in the correct direction to do this? Thanks in advance! Les Mizzell *** Who needs Intel? Athlon Inside!!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Shopping Cart Question (For Everyone)
I've had great success with cfwebstore. www.cfwebstore.com At $150.00 per license (cheaper the more you buy), it has more bang for the buck and is completely open source. Katie -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
List
Sorry for this off subject. But today is Tuesday and I have received approximately 30 #65 dated Saturday June 3, 2000. Is there something wrong? Thanks, Steve Doran -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Sending an attachment vie email (CF Newbie)
Look at CFFILE for the uploading of the file, then look at CFMAIL for the sending of the file. If you have studio use the help in there and look at both of those tags, CFFILE will let you upload and work with the file, i.e.. rename it or what ever, then CFMAIL will allow you to setup the email and send it. Just remember that as you allow people to upload those files for email that your using your shared hosting space up so you will need to probably do some routine maintenance and delete those files out. From experience though, don't delete them immediately, if the CFMAIL needs to spool, it will, and if you clean up to quickly you will delete your attachment before you get it emailed. If you need some code samples post back to the list and I will send you something. Or I am sure that 6 or 8 other nice CF'rs out there will also. Bill AKA CF_Warrior > -Original Message- > From: Les Mizzell [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 04, 2000 6:03 PM > To: [EMAIL PROTECTED] > Subject: Sending an attachment vie email (CF Newbie) > > > > I've got a client, that against my advice, wishes to have a form > on his site > that a customer can use to email a file attachment (such as a > Word or Excel > file) to the intended recipient. > > No problem building the form or anything, but I'm not sure how to go about > getting the file emailed. > > I suppose that it needs: > > 1. email file from customer to server > 2. email file from server to recipient > > I do *NOT* have server access as it's shared hosting. > > Could somebody please point me in the correct direction to do this? > > Thanks in advance! > > Les Mizzell > *** > Who needs Intel? > Athlon Inside!!! > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
File compare feature
Someone told me that there was a way to compare two files in Cold Fusion Studio, but they did not tell me how. Can anyone tell me if this is possible and if so how? I have looked at all of the docs and I can not find a way of doing this. What I am attempting to do is compare some changed files to some virgin files to see what changes have been made in order to fix some boo boos. Thank you in Advance H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Ultradev
Anybody used it? Anybody think its better than a Studio/Dreamweaver 3 combination? Adam Reynolds ColdFusion Consultant HJ Heinz Tel: 01344 397016 Fax: 01344 397010 Mobile: 07973 386620 Email: [EMAIL PROTECTED] ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
TO: CFers in Grand Rapids, MI
Hi, I had recently sent a note to the cf-talk list asking about a CFUG in Grand Rapids, MI. It appears that there isn't a CFUG in GR. I am writing to see how many CFers there are in the area to explore the possibility of starting one. Please respond to me directly with your thoughts and I will compile a summary of responses. If you know of CFers who may not be on the cf-talk list, please forward this message to them. Take care, Simha -- Simha R. Magal ([EMAIL PROTECTED]) Internet Commerce Solutions Placement Online dot com Voice: 419-353-6822 Fax: 353-3522 -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cookies in IE And Netscape
The problem I have is testing the code that uses cookies. The code is suppose to work wheter I am using Netscape or IE. Is there different code that is needed when using cookies for both Browers? Jim Ray Delta Program NT Administrator The Boeing Company (714) 896-2038 Email: [EMAIL PROTECTED] Website: http://deltaweb.lgb.cal.boeing.com/ -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 03, 2000 9:00 PM To: [EMAIL PROTECTED] Subject: Re: Cookies in IE And Netscape On Sat, 03 Jun 2000 02:05:41 Ben Densmore wrote: > Is it common for a cookie not to be recognized in Netscape if it's been = > set initially using IE? I'm doing some testing on an App I just = > finished, I originally used IE to test it and the cookie I am setting = > worked fine, I then wanted to make sure everything was working in = > Netscape and it didn't seem to recognize the cookie, once I filled out = > the form and the cookie was set using Netscape it works fine. Just = > curious as to whether this is normal or not. > > Thanks > > Ben Densmore > Webmaster > eSupport.com, Inc > TouchStone Software Corp. > Cookies are set per-browser, that is, NS doesn't know about cookies that IE has stored, IE doesn't know about cookies that NS has stored. Remember that cookies are stored in the browser (well, the browser stores them somewhere on disk) not on server. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Has the list gone buggy??
erm, Am I the only one getting the messages from the last few days delivered *again*?? Is there some weirdness happening with the list mail server? James Mathieson [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: test
The last time I ignored a test, I had to take the course again . . . . - Original Message - From: Joseph Eugene <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 04, 2000 9:44 PM Subject: test test, please ignore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Best Method
Greetings... What is the best method for reading ONLY the last five records in a database for display? I have a client that adds articles daily to a news database, and then displays them on a news page. There are hundreds of articles, and on his home page he just wants to display the 5 most recent. (which would be the last five in the database, I presume) Suggetstions??? and thanks as always for your help in advance... Jeffrey Cohen ImageWorks -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
JSPHTTP?
Does anyone know if there is a JSHTTP command like CFHTTP? For those interested in ASPHTTP, there is a module available from serverobjects.com but I have not tried it out myself yet. John -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
date functions on email headers
This is a multi-part message in MIME format. --=_NextPart_000_005F_01BFCF9E.44271E60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I sent this out yesterday but the list was 'broken'. Is there a = function that deals with dates coming from email headers? They are = usually in the format of=20 26-May-2000 10:55:16 -0500=20 but sometimes they can add a pst or est, or whatever else. It seems = that the common date functions won't touch that format unless I trim off = the end characters. I don't feel like sorting through rfc's to see what = the actual 'rule' is on time formats in the headers, so I figured I = would ask the good ol' cf-talk crowd if they have ever dealt with this = before. I appreciate any suggestions. --=_NextPart_000_005F_01BFCF9E.44271E60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I sent this out yesterday but = the list was=20 'broken'. Is there a function that deals with dates coming from = email=20 headers? They are usually in the format of 26-May-2000 10:55:16 -0500 = but sometimes they can add a pst or = est, or=20 whatever else. It seems that the common date functions won't touch = that=20 format unless I trim off the end characters. I don't feel like = sorting=20 through rfc's to see what the actual 'rule' is on time formats in the = headers,=20 so I figured I would ask the good ol' cf-talk crowd if they have ever = dealt with=20 this before. I appreciate any = suggestions. --=_NextPart_000_005F_01BFCF9E.44271E60-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
urgent! server down
Hello everyone, I need some quick help, our server just went down 30 mins ago - CF 4.01 on Solaris. When trying to restart CF service, it gives a message about not being able to initialize the registry and provides a command line to use. If we use that command line it does a core dump. HELP!!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Salary Expectations www?
Salary Expectations www? Is there a good web site that details how much a person should expect to be paid for a particular job in a particular region? Thx Eric Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[Fwd: [CFUGTALK] Increasing Speed {01}]
This is a multi-part message in MIME format. --828843FAEE0AE2025611 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit It also looks as though for each request, the browser looks for the proxy settings. ... Is this correct? --828843FAEE0AE2025611 Content-Type: message/rfc822 Content-Transfer-Encoding: 7bit Content-Disposition: inline Return-Path: <[EMAIL PROTECTED]> Received: from dns3.agouron.com ([10.0.7.236]) by il-postino.agouron.com (Netscape Messaging Server 3.6) with ESMTP id AAA176C for <[EMAIL PROTECTED]>; Mon, 5 Jun 2000 11:44:34 -0700 Received: from il-postino.agouron.com (mail.agouron.com [10.0.7.237]) by dns3.agouron.com (8.9.3/8.9.3) with ESMTP id LAA22511 for <[EMAIL PROTECTED]>; Mon, 5 Jun 2000 11:47:28 -0700 (PDT) Received: from dns3.agouron.com ([10.0.7.236]) by il-postino.agouron.com (Netscape Messaging Server 3.6) with ESMTP id AAA1769 for <[EMAIL PROTECTED]>; Mon, 5 Jun 2000 11:44:33 -0700 Received: from cerberus. ([10.0.252.2]) by dns3.agouron.com (8.9.3/8.9.3) with SMTP id LAA22508 for <[EMAIL PROTECTED]>; Mon, 5 Jun 2000 11:47:27 -0700 (PDT) Received: from gauntlet.agouron.com ([198.49.92.7]) by cerberus.agouron.com; Mon, 05 Jun 2000 11:44:49 + (PST) Received: from [216.98.135.65] by tbone-internal.agouron.com via smtpd (for relay.agouron.com [10.0.7.236]) with SMTP; 5 Jun 2000 18:44:33 UT Received: from tbone.agouron.com [198.182.177.3] by bluestarcorp.com [216.98.135.65] with SMTP (MDaemon.v2.7.SP5.R) for <[EMAIL PROTECTED]>; Mon, 05 Jun 2000 11:34:34 -0700 Received: from relay.agouron.com by tbone.agouron.com via smtpd (for [216.98.135.65]) with SMTP; 5 Jun 2000 18:40:01 UT Received: (private information removed) Message-ID: <[EMAIL PROTECTED]> Date: Mon, 05 Jun 2000 11:32:04 -0700 From: Lisa Greenberg <[EMAIL PROTECTED]> Organization: Agouron Pharmaceuticals X-Mailer: Mozilla 4.61 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: "CFUGTALK List Member" <[EMAIL PROTECTED]> Subject: [CFUGTALK] Increasing Speed {01} Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-MDaemon-Deliver-To: [EMAIL PROTECTED] X-Return-Path: [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] X-MDMailing-List: [EMAIL PROTECTED] X-MDSend-Notifications-To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Hi All, I have been running my CF applications locally on my laptop. All of a sudden there is a HUGE delay in running my applications via an IE browser. Each request to the server takes a lot of time, which it didn't prior to this morning. I have a presentation to give tomorrow and need to solve this problem that I didn't have until today. When I run the application, I get those nasty reminders as to whether I want to work off line etc. I've looked at the performance of my computer it is running at 90% free resource. Any suggestions? TIA, Lisa == SAN DIEGO ColdFusion USER GROUP: ListServ To unsubscribe, send an email message to [EMAIL PROTECTED] with 'unsubscribe CFUGTalk' in the message body. == --828843FAEE0AE2025611-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. Oracle Application Server
I find CF easier to use and there is less set up time to get the applications rolling... > -Original Message- > From: Troy Simpson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 01, 2000 3:04 PM > To: cf-talk > Subject: CF vs. Oracle Application Server > > > > We are trying to make a determination whether to use Oracle Application > Server or ColdFusion Application Server. > Does anyone know where I can find a comparison (pros/cons) between the > two products? > Any personal comments will also be appreciated. > > Sincerely, > Troy > > -- > Troy Simpson | North Carolina State University > NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina > ph.919.515.3855 | fax.919.515.2972 > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Remote SQL Server access
Has anyone installed the desktop version of SQL Server 7 on a workstation and dialed into an ISP to connect to a SQL Server. If so, how did you do that? I am trying to set up a telecommuting situation. I need to what steps I must take to get that desktop version to communicate with a server via ISP.) Any help offered is already appreciated. Thanks, Rob ___ Robert M. Saxon, Jr. (Rob), Senior Web Developer Mercer University Department of Web Management TSS // 1400 Coleman Avenue // Macon, GA 31207 912-301-5550 voice // 912-301-5314 fax [EMAIL PROTECTED] Philippians 4:13 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Automatically Start/Stop CF Server?
Hi Folks, I've searched archives and FAQs and can't find the answer to this one: How do you start & stop the cold fusion server automatically from your code? I know this was discussed not too long ago, and I'm kicking myself for not saving the answer. I know this had to do with the Cycle.bat (right?) but I'm not sure what it was exactly... Any help would be appreciated. TIA, Robyn -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Another question on performance -- better than lists?
>your tests suggest looping through lists performs slower than other data >structures. however, what about list functions like ListGetAt()? list >functions are a large reason why i choose lists over arrays most of the >time. And what about indexed arrays? How do they compare to the speed of structures? Is that even a valid comparison? Either way, it's still a cool hack. I was inordinately pleased with myself when I figured it out - of course, as I found out later, I was a Loonng way from being the first. :) THEY CAN HAVE MY { var = array[(listFind(array[1],"foo")+1)]; } WHEN THEY PRY IT FROM MY MOLTEN, SMOKING CPU!!!1! Hey, I was young...but really, anyone done any speed test on this sort of thing? Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore "I'm sorry, I can't hear you. God just sat on my Whoopee Cushion." - Kibo -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
DataViewer now called DataWiz2000
I have created a mailing list for DataWiz2000. Here is the link to sign up. [EMAIL PROTECTED] I will use this to announce updates, changes, and bug fixes. I would like to use this so that we don't tie up the user group list with unwanted/needed messages. Here are several links to download the latest beta of DataWiz2000. http://24.4.25.207/dataviewer/dataviewer_v1.zip http://216.91.204.214/dataviewer/download.cfm Note: The files do not refelct the name change. I will be updating the graphics tonight. I encourage anyone that is interested in this tool to join this list. Thanks, Clint Tredway -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: studio errors
Just to join the gripe session :) I often get "Out of system resources" type messages when running CFStudio 4.5.1. Not uncommon, but this workstation has 512 mb of memory. Whenever it does crash, I check free memory (running MemTurbo), and there's usually 250 mb or so free. Billy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Nothing but vacation responders and other echos
It's broke. Been getting nothing but reflected repeats of old postings and vacation responders. Agh! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
compacting access db
This is a multi-part message in MIME format. --=_NextPart_000__01BFCF07.40198C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit I have an access db that seems to be growing exponentially frequent changes are made to it if I manually compress it the file size is dramatically reduced, but I would like to automate this feature somehow any ideas? Im going through the db (not my design) to reduce un-necessary field size etc, but at one point (after 2,800 record imports from a text file) the db was over 800mb ouch 4mb after using the built in compacting feature. Thanks for any pointers je --=_NextPart_000__01BFCF07.40198C00 Content-Type: image/gif; name="image001.gif" Content-Transfer-Encoding: base64 Content-ID: <[EMAIL PROTECTED]> R0lGODlh+gCbAHcAACH/C01TT0ZGSUNFOS4wGAxtc09QTVNPRkZJQ0U5LjAQAiDF3gAh/wtN U09GRklDRTkuMBgMY21QUEpDbXAwNzEyB09tt6UALAD6AJsAhP///ykpKXt7e4SE hN7e3v+MjP8hIefn77W1vWNja87O/3Nz/0JCvSkp/wAA/wECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwT/EMhJq7046827/2AojmRpnih4EMSavnAsz3Qd rrit73zv1y3W4UcsGo+1w7ByUDSeC8DiqahMGw5HlOJ8NiTXJaD7BD/FZO92slhktRavfA1Qs59Z etrcELPdeSF2e1JnVoBwSCQrLRJKLIgEDFl9LAR1b28LYoBYBwiUFJ0On6FslJpCmJlanKgOWFFD U1kIAAdYrJtgqKWwcaytHrQOtqO+XxS5mbuKKkE4lgRvDYgICEKTsIibSrjU363ey3253Uq5DdcL 1y3L1t4ACIjVC6rpK53cLeGw4ee39L1BEG8DvmngzMV7N7CgMw7QhAThpumaRU3WsB1ABAtUFksb /zOpewOSm8V2CjBSwsZvTEWWvrQQ8KgF0QBIImmCbKKyoyoNKfMQ4Djyo5ADPdX9fMiBkVMW6XIx GGCRwDIE6dpZZaaNHctlWrpqzUr1pDWpWpVkrJpRW7Gs18AuEAvzbBYGaTVklEuXhVusd/MybSqR Bc1MAxJfzDPgzdTFjnOVvcaKgeSTjhMrpnzXZtUVmSfTxDu68V2qpiNnmcyC2RvWfpg4RiCg8uV2 jj23iz3YAg5GBBRwvCtA87yBbo27vXu67HIH2qY6H6i5rM3qxbVyM358NYK/yak+j765dWgB2TVm 8AwWevN1rzUXL9uod4Yg0hBmYpAgQXpqqTHwX/8w7x1W2WbBNDBZJggkhl55W8HCXYTqpNZAbcQN gCGBj41FDXrz7ZZBVhsG0yFgtTg4IW/2TfAUTqz05x9V3Lg14wDatOdAejkGkx2OJi7Y3IOsISKd dZkl4JiNxfXISogsHcbfZupdYCSQsPioWGoLVAchiy1GIw2BAfSn2DIDpDPjaJUloJhjbWYH4IMW oakhlO38VZ6e6aRJyYxw7ucmVRKBBWV9F1wVYJtnxsediC1SEI2YQxEoY1lLOjZfJ8+Z2V0DnQ5q pAA3cgadZU+wNlNoQkKnYaYZ5hjqZKgeVp4SGCB1mqwxummqgF5UtVSkt+AHnCQJynhNcssMiiL/ MXfdqE0CYPE3aJ8gIrkaWu1gcx19njH7xqDaCFDtmp/aKpiV1El1bnbiQpcWmL0ZKw2b4w4I3YYC vikhWP3JWQsrZQ6aGakI/vmasPop2CBugfHLr4MD9Zqdfl2GxpIGB79mMVXUZHQUsUzYC6N70WaH iLn5ihdYry672qubbmWr7amU0OftG3huV3OzTZ4GM3y11EwfvT4LnYmnK+e4rg+/fQCNmLBCt2Y6 bk2Z2EAlWgtyLSUWLABNDSSgdVyBOuCrh7U8jE2ffjKXYWq0CeorhaMm1kYzwKT4WteeLmP0Om3Q 0FIF+Pl2+AXAGWmjswSqrXJgSo7r33eBLXfp/3MSQrYflAqUptiqgaUWY9CuVp5FwBCzUvZ8lLBI U5fkaQ55kDTeRW8JTpWMK+Iu3McIYoKvTRR/IS6ctafULT+jjqTtTI3XVSk6mfXLgUrkZc6DG2di 2hD0+wR25oK61caLdHZXt+wuQjSOiPnbJY+4D9w1Gsp46Ul3Bpwe/5oJWHks4iAZ/a9Bdxpgg0hl wPQYBoEPuxcEqQKiS1EJgYkRIKEsQRsH0QkUDPhNbGaCv+ogkIEheiB6/HOonbgPBBF5yoseAQ0N 3G+B+huUaOYzH9YA0ITYAOAK8bTAD5IQfwx0VhCP+KUjPgw1XhINAb2kFRJ60DjVkMb4ioU/CP9i kIrdwqASq7i4G/iBhvaaIUhq6CIxMIJ/FbzgF6nEwS5CUVg/fFQJexhGDxLxgW7TyAoISEggnsSO XixMCS94xGG9MZBShNADDZmfMn6gd8XiR2EKI8M1LqF3x1okJQ8pmns58ST5IeUhf7hKUaoKkJ+h YSu7yLBZzmuQtCQjSxaHS1seMpW53GV+XniBGOLHWJPiZESMCYBlnvKXQVylJ1M5Ey1KUJq+rGMw helEFsSvkrDkJjV3+clwgnNjkgqlKbt1lEcy7JiIEsExnaLGo2xSmaqglGFOWc1rurB94MwnGgFZ SWkq8pfn3Mk3JXIsLXqjoSC5xUKHWcktOiL/oMfKwUQj+lBcEZNx9pynNxRAUgUogaTt8wYngwe/ gErjAQ9wqEUlOgSP1vSmLiUATHcK05ucEZ45HdlN4zFUh9D0pu2TVPweelSm+iapSI2qI9rIVDdK dBHzbGcTSLq3BQinDSUN6xolUiwKuPQAMG3mJUbQUYi+9AEBiGtc1+qbR4izom39KAxqSrINJFOE Q/gqtMjRVXaYdKz0wqQE0gqAAQQApgmgXwJgGoABTAABk31AAsTX08cGQHzAgWn9JjAAuJb2ARJw LGWF0FnNEkSTUesrU1oiv3YGBA+Ro0QbYoFTLRbrp8FbLGpLK1e4AuCxbnqsZRFA2cc+gCA7/40r XJcJ04g2Fq7OHW5zp6vT7QYgjTOVbRHQ+KKwclVH2yjsbrdh0sNSNLhsFC4ASGULAKQVprY4QGKO +wDLXve7+F2BaGmIVp4a97G2OO18NyvgmHb3taKF7bDEewRNGmsebWDAVyPn1ZIGhB4dJmlDg3tR PzC2QQlwLgAya1r5TkC0A+5uQ5tbJgHYF7Uupo10Y1pgS8S4fuGlMBGUuVssNKCkxKjH3qqBhiRX o6QZxQBjb/zfxJxYAM4NAJVf/IAeK2HA0ajuT6acVuJqSMzV/TKP5xdPIRuhfsFRgFvAKgHheAHJ ha3CGK7AZ7B+wptSjukt7otjKseVy/z1L/9xC4yDCIfWwYBGsDwIzYgIi1nG8guym3sAnNBNAgp6 FgVYv3peLejZznbWrUnRSdXMSjcBN05uWifrJlpPWrPOhe6a0+wUGsfVynDdaawFsFMW8NrRD23z pqEmEeHoNsQuEuyovcpn8lWDsBKQRjpZkGLIDoEAnkXAY7nt3AQsAbOQ5WyX1QycBhvYso79bFrB bVoEd5e1627rst8chNB1oh5PnoBwBMtVsLrhyE0YDnu5CGiAOlV4HX2GSncS0ZnUNK1tXSls930E ODNCzug9cp1JXVNnA7wm0KIEqPd8E3vS068vV8FfwXmAyVYWuZnEKD80zXEdMLQF3SGQyOv/TOcm 4IHatLh25J5s51uO1oYjkzmQ3WoJVwvArX/VaM/HK6ZULz3UCQ9sOvCM3mBQmwHssKa+C9JRZXdA pTMfZm91DuStIyEaKBK6V5V6h0AQvezMqELo0jI1uP/O8HoFHpvvac2KTm3nibd7DFbg9a9XIKyF qIYVAE+JKjSBYcksPNw1CYLKKqG0GsEy1V86Vh4zNPIa4Ol3F7uBQjPB1f4dTHAwl1tYhPrvp9b8 5Tnve5MO8vURySyD9evZFmTXv8TWbAX8cwtiX50A/Wl8JSHNwfkFWcsiKLRjaR97DFC/mZWVAPg7 QO/ISiD6Nkb/dN9+sqXvnQsD9/zvpd17/1gMHfTJF1kHQCoE4FgEQSpo5QfjdwABcHWkZW7g5lhf NgD6tH1Z9XjhZXsfYHs4poEW4IHkJwG0EYIc4CaNBWvjd1yW9VnysH5Ql3cc9nv412GXt2TEZ2q3 ICzex31d5iZvxIDjs1k5GAC/o1MCloA6xQKeRYEzEW46ZWZH2F+mpQQ2V1r8hVrw92LEVV8vRlrx 12LzZWM1J4Xm91lceIW3QGt0VQGFhlpCiH7HZQvixn6Vp3dAMQX3J3A3SA2eR0JqF4ARSFnXIF2z h1rekG/qh2IM2CBE6CYz4WCfpV8CoFPmJm5fhlYUKIH9IQGTRXsDAGsr5l/91YJsyFNr1f9foDh7 JmiFjKNamnWKnCiHoJgBn2hfFIBazLVaGfAbvJdbeXgBJHVnLpJy/cdkzUQfsMUIWLZZlHh6nyWA CJhvCegi/uGIGvKJK5A/6xZXx
RE: CFHTTP & IP checks
Dave, you're a genius! When I pass along a recognized user_agent, it lets me in via my account ... With this help, I was able to quickly daisy-chain 3 CFHTTP tags which zip me through 2 screens, parse out a dynamically-named download file, and download the file - automatically in ONE click without ever leaving my own site! I'm impressed! Thanks again... Gene Kraybill Dave Watts wrote: > I wouldn't be surprised if, instead of it being an IP address issue, it just doesn't > recognize your "browser" when you use CFHTTP. > > By default, CFHTTP describes itself to the target server as "ColdFusion". It > might be the case that the server is looking for a well-known browser type > like Netscape or IE. You can have CFHTTP tell the server it is one of those, > and see what happens. In CF 4.5.x, you can add a USERAGENT attribute; in > earlier versions, you'll have to add a CFHTTPPARAM tag... Gene Kraybill wrote > > I'm experimenting with the use of CFHTTP and CFHTTPPARAMS to > > log in to a large, unaffiliated web site I frequently use > > and which requires username/password. It appears the other site uses an IP check >of some kind, > > because it throws a vague error message that reports what > > my IP no. is (and blocks access). No doubt they've instituted > > this IP checking for security reasons. > > > > Without breaching the bounds of ethics, I'm wondering if > > there's any workaround... -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Duplicate messages
>As the guy said in Catch-22, "I see everything twice!" >-David That's it. I'm re-tooling my database front end to track and thread auto-reposts based on how many times the HouseOfFusion footer appears at the bottom of the page... Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore "I'm sorry, I can't hear you. God just sat on my Whoopee Cushion." - Kibo -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. Oracle Application Server
I have similar question. Our school uses the Exeter Student Information System (based on Oracle App. Forms)and is moving to web forms. Any feedback on this anyone? Gary McNeel > -Original Message- > From: Troy Simpson [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 02, 2000 4:20 PM > To: [EMAIL PROTECTED] > Subject: CF vs. Oracle Application Server > > > > We are trying to make a determination whether to use Oracle Application > Server or ColdFusion Application Server. > Does anyone know where I can find a comparison (pros/cons) between the > two products? > Any personal comments will also be appreciated. > > Sincerely, > Troy > > -- > Troy Simpson | North Carolina State University > NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina > ph.919.515.3855 | fax.919.513.3330 > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Input Type Fields
If you're talking about editing the data after it's been submitted to the db, check to be sure you've "populated" all fields by setting the values of each field to the appropriate database value. With the checkbox and radio fields, of course, this will be done a bit differently than with text fields, and comments fields are different again... Let me know if I can help further... Gene Kraybill Laura Rothman <[EMAIL PROTECTED] wrote: > I have a template which a person accesses by entering their PIN. At the > template they can view/modify their name, address and phone. They can > also enter data at a comment field and select various radio buttons. > After submitting the template the data IS appended to the database. > However if the person re-enters the template they can see the changes to > the text fields, but not to the comment, checkbox or radio fields (the > data IS definitely in the database though). Am I doing something wrong > or is that a behaviour of all input types except for text? - Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: error messages dictionary?
Yes this would be a great helpPlease reply to [EMAIL PROTECTED] if you have something -Original Message- From: Tom Rainey [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 5:06 PM To: [EMAIL PROTECTED] Subject: error messages dictionary? is there a good list of error messages and typical causes? -Original Message- From: Lee Surma [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 11:19 AM To: '[EMAIL PROTECTED]'; Steve Weiner Subject: Re: Is there a typical cause for this error message? >ODBC Error Code = 22001 (String data right truncation) You may have single quotes around a number or a date. -- Lee Surma Public Radio International [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newsgroups?
Newsgroups? As in, 'why aren't there any ColdFusion...'? There could be a whole Allaire group in the comp.* heirarchy... comp.lang.ColdFusion.server.linux comp.lang.ColdFusion.server.windows comp.lang.ColdFusion.studio.linux comp.lang.ColdFusion.studio.windows (etc.) ...I'd personally prefer to start 'em in the alt.* heirarchy, but let's not go there... ...Anyway, I was just wondering if this was something that someone had tried that Allaire smacked down, or if there's really so few people that access Usenet anymore that no one bothered... Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore "I'm sorry, I can't hear you. God just sat on my Whoopee Cushion." - Kibo -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
Hey there cold fusion people! Does anyone know of an app that allows visitors to your site sign up for a free email account. My mailserver is redhat runnin sendmail and php? I want this service hosted locally, not some 3rd party host that likes to sell out my customers email address' and my soul. Emmet designer beachin.net -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: UPS Shipping Costs
How many times are you going to send the exact same message? We're up to four at the moment. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Michael Chiu [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 16:22 To: CF-Talk Subject: UPS Shipping Costs My client registered as an end user, so I have access to the requirements for their different tools. I've run into a snag, and that also may be why you are getting the $0.00 returned. The tools require you to send it as url encoded type. I think it's something similar in function to the enctype you have to use when you use a browser for file uploads. Well, I had an example script, and I just use URLEncodedFormat on the fields that contained data that needed conversion, but that didn't satisfy the CGI script. It recognized that I wasn't sending an encoded format, so it stopped at that point. I've searched the documentation, and I can't see any way to use CFHTTP to pass the information properly. I don't know if this is a recent thing or not, but it bugs me. I had the UPS guy in a meeting, and he assured me that I wouldn't have any problems using Cold Fusion. At this point, I think I'm going to go the route of AbleShipper. The zones and rate tables are free on the UPS site, and it cannot be too hard to import those into a table once a year or so. Mike Chiu [EMAIL PROTECTED] http://yoyoman.insync.net "No one who believes in him will be put to shame." (Romans 10:11) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Post Time
I like to reply to all so the person asking gets a faster answer and the group will get it eventually.. -Original Message- From: Leyne, Sean [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 2:33 PM To: '[EMAIL PROTECTED]' Subject: RE: Post Time On busy servers with large numbers of members, it can take some time for posting to be sent out. I don't know all the details of the server and it's net connection (ISDN, DSL, T1, T3???) so I can't tell you which is being the limiting factor. (perhaps someone in the "know" can enlighten us). -Original Message- From: Shane Pitts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 12:23 PM To: Cf-Talk@Houseoffusion. Com Subject:OT: Post Time Just curious, is it a known fact that when you post something to this list, it doesn't show up for about 5 hours? or is it something else. Seems like every time I have posted anything in the past that is a reply to someone else, it shows up about 5-6 hours later Shane -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Has the list gone buggy??
No, it's not just you. From what I can see in the headers of a few messages, there's a REALLY nasty mail loop going on that is causing messages to be re-sent over and over. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: James Mathieson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 06, 2000 07:04 To: Cf-Talk Mailing List (E-mail) Subject: Has the list gone buggy?? erm, Am I the only one getting the messages from the last few days delivered *again*?? Is there some weirdness happening with the list mail server? James Mathieson [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Mall Applications
Is anybody aware of any off-the-shelf CF products that can be used to implement a shopping mall? i.e. multiple stores at one site with separate owner administration and separate control of the check out/billing functions. Thx -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: removing space between words being uploaded to a database
This code will do the trick efficiently: UPDATE Tablename SET SomeField = '#ReplaceNoCase(form.somefield, " ", "", "ALL")#' WHERE ID = #Val(form.id)# Note that ReplaceNoCase operates faster than Replace, so is preferred if character case does not matter. Chris Tweney Media Application Developer roundpeg www.roundpeg.com 1700 California Suite 260 San Francisco, CA. 94109 Ph. 415-437-3900 Fax 415-437-3904 > -Original Message- > From: AustralianAccommodation.com Pty. Ltd. > [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 03, 2000 10:46 PM > To: [EMAIL PROTECTED] > Subject: removing space between words being uploaded to a database > > > This is a multi-part message in MIME format. > > --=_NextPart_000_0021_01BFCE3C.048BE5A0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > can I ask what the code is to remove spaces between words so > that I can = > update the database with the values minus the blank spaces > > > Kind Regards > > Claude Raiola (Director) > AustralianAccommodation.com Pty. Ltd. > Website: www.AustralianAccommodation.com > Email: [EMAIL PROTECTED] > > --=_NextPart_000_0021_01BFCE3C.048BE5A0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > > can I ask what the code is > to remove = > spaces between=20 > words so that I can update the database with the values minus > the blank=20 > spaces > > > Kind Regards > > Claude Raiola=20 > (Director)AustralianAccommodation.com Pty. Ltd.Website: href=3D"http://www.AustralianAccommodation.com">www.Australian > Accommodati= > on.comEmail:=20 > href=3D"mailto:[EMAIL PROTECTED]">Director@ > AustralianA= > ccommodation.com > > --=_NextPart_000_0021_01BFCE3C.048BE5A0-- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Best Method
> What is the best method for reading ONLY the last five records in a > database for display? > > I have a client that adds articles daily to a news database, and then > displays them on a news page. There are hundreds of articles, and on his > home page he just wants to display the 5 most recent. (which would be > the last five in the database, I presume) > > Suggetstions??? Off the top of my head, why not invert the list with an Order By and select the Top 5 - they'd be in the wrong order when they come out, but with a sub-select, you can sort them however you want... select * from myTable where ID in (select top 5 ID from myTable order by ID desc) order by ID HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Studio 4.5.1 RDS sharing violation error...
Anyone else getting a big error dialog window in Studio when trying to open a remote file via RDS? It goes something like: "Error attempting to read data from D:\blah\blah\myfile.cfm. Error = There was a sharing violation... " and then about 30 lines of HTML and CGI variables, which makes no sense for a Studio error dialog. This started when I upgraded to Win2K. Since RDS uses MDAC (as I recall), could it be a conflict between the NT4 MDAC on the server and my newer MDAC on my laptop? Very frustrating problem, because it means I have to go to FTP mode to open the file. It usually only happens with files that have been accessed via the web... hitting old, stale files, RDS behaves just fine. Thinking it was an IIS file-locking issue, I temporarily stopped IIS on the website in question, but that didn't help. Any ideas? Thanks in advance, Ron Ron Allen Hornbaker Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to output fields of a table
> How do you output the names of the fields of a table > from SQL server and their values when you don't know > the names of the fields or the values of those fields. > Can you just have a query like: > > > select * > from ThatTable > Use GetTableData.ColumnList, this gives a comma separates list of the fields. BTW, doing "select *" is very slow compared to naming the fields, as the database has to grab the field names before it can run the query. If you're using SQL Server, then you can get the real column names by; select Column_Name from Information_Schema.Columns where Table_Name='myTable' Information_Schema.Columns also gives you Data_Type, Character_Maximum_Length, Is_Nullable, Numeric_Precision, and much more If you really know nothing about the table, you can find an awful lot from SQL Server just by querying the right built-in views BTW, if you want to find the Primary Key, then; select o.name as oName, c.name as cName from syscolumns c, sysobjects o where c.id=o.id and (c.status & 128)=128 and o.name='myTable' oName will be the table name, cName will be the column name HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Email authentication
> When someone signs up on my site, I would like to be able to verify that > their Email address is valid and, at the same time, make sure they are > really the person using that address. I would like to send some sort of > confirmation E-mail with a link they have to follow to activate their > registration, but I want the link to be different/random for each > person who > signs up. I've seen a lot of setups where you get sent a link with, > seemingly, random numbers in it. Has anyone had any experience with this > type of thing? Personally, I don't care how it does it, as long as it > works. Is there an easy way to create/process 'confirmation > emails' in CF? Why not put a CreateUUID() into the record with the email, send them the URL to go to which contains the ID, that way you know they've got the right one - although, this will allow for a certain amount of problems if people work-out how to activate other people's accounts Extending from this, you could use CreateUUID(), and then add a 4 or 5 digit random number onto the end, that way, you can guarantee that nobody will be able to break the numbering. Send a CFMAIL with the complete verification URL in it, i.e. insert into myTable (Email, LogID) values ('#Email#', '#myID#') To activate your account, please visit; http://www.myURL.com/confirm.cfm?LogID=#myID# Thank you Then when they return, check the ID exists and activate the account, it's a bit long to fake, as an example is; 1ABCDF70-3C64-11D4-B8380020186329371338 BTW, the reason to use CreateUUID() rather than just a random number is that they are all unique (UUID is Universally Unique Identifier) A bit excessive, but it should work. HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie seeks sage advice
I'm getting this error message while in a browser: -- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code=() Unable to instantiate environment for 'ODBC' The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (30:41) to (30:2074). Also getting errors with the CFQUERY command. The ODBC is linked to an Access Database. It doesn't seem limited to certain events, and when we reboot the NT server, everything works again. I've checked the ODBC connections and the database itself and couldn't find anything out of the ordinary. Do you think it's something in the code or something server related? Daniel Yoder US Bankrupty Court District of New Mexico -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Has the list gone buggy??
> > erm, > > Am I the only one getting the messages from the last few days delivered > *again*?? Is there some weirdness happening with the list mail server? For the last few days it seems to have been repeating a couple dozen posts several times aday. Over and over. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dynamic CFPARAM Statements
> I've got a form with a series of form fields whose names are dynamically > generated in an indexed loop. i.e. > > form.unit1_name > form.unit1_listed > > form.unit2_name > form.unit2_listed > > etc. > > One of these form fields is a checkbox and in the action template I want > to default the value to "0" using CFPARAM, but I keep getting undefined > variable errors. I've tried the following (i is the index of a for loop): > > > > > Any ideas how to do this? OK, now if you Evaluate the Name part of a CFParam, then it'll use the contents of that field as the variable name, so; Will set form.unit1_listed to 0 if it doesn't exist, while; Will set the value in the field form.unit1_listed to 0, i.e. form.unit1_listed="myValue", then myValue would be equal to 0 If you want to ensure that the fields (as listed) appear, then use the first one. Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire Spectra E-Business Construction Kit
Ben, I'm interested, but I haven't seen a table of contents. Can you share that? ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 02, 2000 1:31 PM > To: [EMAIL PROTECTED] > Subject: Allaire Spectra E-Business Construction Kit > > > This is a public service announcement (combined with some blatant > commercial > advertising ): > > The "Allaire Spectra E-Business Construction Kit" is finally available. > Copies have shipped and I am expecting that most online stores will start > shipping it next week. > > Here's a link to it on Amazon.com (although I cannot promise that > they'll be > the first to ship it): > http://www.amazon.com/exec/obidos/ISBN=0789723654/benfortascoldfusA/ > > --- Ben > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Detroit CFUG
Detroit now has a CFUG! The Detroit CFUG will hold it's first meeting on Wednesday June 28th at 7:00pm. (Food will be served at 6:30pm). The guest speaker for our first meeting is Ben Forta, and I'm making Ben bring copies of his new spectra book with him to give away. :-) The meeting will be held at: Stoneage.com 888 W Big Beaver Suite 1000 (10th Floor) Troy, MI 48084 800-786-6324 x124 If you are interested or have any questions, please feel free to e-mail me at [EMAIL PROTECTED] or [EMAIL PROTECTED] Thanks and I look forward to seeing everyone in the Detroit area on the 28th. -- Matt McDonald CIO - Chief Internet Officer Stoneage.com - HUNT, GATHER, DRIVE E-Mail: [EMAIL PROTECTED] Voice: (800) 786-6324 x124 Fax: (248) 269-7300 http://www.stoneage.com --- -- STONEAGE.COM is nationally ranked as one of the Top 10 Online Auto Sites, and was recently awarded an overall rating of EXCELLENT from PC Magazine. -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cf-talkemail list? anyone know?
[posted to newserver] Anyone know what's up with the cf_talk email list? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cookie hell
Hi all, I'm using client variables set in cookies. I want the following session variables to expire when the user's browser is closed, so i manually set them in cookies with no expiration date like this, overwriting the automatically generated cookie (this technqiue is from the Danesh "Mastering" book): I want my client variables to expire at the same time, so i rewrite that cookie as well: When I close my browser, and open up the cookie file, the CFID and CFTOKEN have disappeared like they were meant to. But the CFCLIENT_METS is still there. I've deleted the cookie files and tested repeatedly under both IE5 and NN4.7 but no joy. I've checked the cookie file and my CFCOOKIE is generating the same text string as the CF auto created cookie. There is a single CFLOCK around all three CFCOOKIE calls. Does anyone know what is happening? Is there a way around this? Thanks, K. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML Text Editor
Bridget: Try 1st Page 2000. It's decent, and free. http://www.evrsoft.com/1stpage2.zip Joel : Hello, : I am looking for a free downloadable html text editor. I thought had : bookmarked one that was mentioned in this forum, but I guess I didn't. : If anyone had any good suggestions, please let me know. : Thanks! : Bridget -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Encrypt problem
Hi there! I'm trying to encrypt the passwords of my users in an access database. As I don't need to cocern a lot with security issues, I'm using the #Encrypt()# function, but ... Here's a simple test: #pwd# #var# this code produces 2 diferents strings, the first one: (2U2@MEVV2ZX4 and the second one: (2U2@MEVV2ZZ, and whats most weird. If I press reload ... the second one becomes (2U2@MEVV2ZZ< So what can I do to encrypt my passwords? any other tag? Thanks Vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How do I pass a query in WDDX?
This is what I would LIKE to be able to do... and on next page, #products query# What is the very easiest way of doing this?? Does anyone have any code snippets they could send me to make this easier? I'd really appreciate any help on this Thanks for any help, Britta -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
trapping sql statement
Does anybody know a way to trap a sql statement so that it can be caught in a try/catch block? Is this supposed to be done when you select "show sql and datasource name" in the debug settings of CF Admin? It's not working for us, we only get the datasource name but no sql. thanks, Troy Johnson -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
MONEY PROBLEM IN SQL
I have a sql statement that is inputing 15000 into (example data) a money field in SQL When i run a query from sql advantage i see 15,.00 when i pull up the data from CF i get 6.442450944E+13 any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SOT: Aussies, daylight savings changes for Sydney 2000 Olympics
I guess this reply falls into the better-late-than-never category! Thanks for the notice about the DS change. My company (shameless plug: www.onProject.com, affordable web-based project management) has customers all over the world, and this will help us to plan ahead. My experience with the '96 Olympics in Atlanta was not bad at all. So many residents left that traffic was actually better than usual, at least where I lived (Decatur, about 6 mi/10 km from downtown). And there was certainly no shortage of food in the grocery stores! :) Of course, it all depends on where you live and work relative to the venues. -Original Message- From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 17, 2000 9:07 AM To: [EMAIL PROTECTED] Subject: RE: SOT: Aussies, daylight savings changes for Sydney 2000 Olympics It's all about money ... you're not alone, we have that problem too. Hope you survive :) Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Nick Slay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 17, 2000 3:06 AM To: [EMAIL PROTECTED] Subject: Re: SOT: Aussies, daylight savings changes for Sydney 2000 Olympics Hey... I hope you've booked your holidays for September.. and remember to get your bus/train passes in good time!! :^) Is there anything else that we're forgetting? Should we hoard food in case of shortages due to the influx of all the visitors in September? Should we stay out of the surf to make way for the Olympic Visitors? Maybe we should all move to Tassie for September so as not to be a burden on Sydney Sheesh!! I'll be glad when it's all over too At 16:40 17/05/00 +1000, you wrote: >BLOODY OLYMPICS!! This whole city is being turned up side down so rich >fat cats like the little spanish nazi** can strut about like potentates. > >** Sorry. His excellency >he-who-has-to-always-be-referred-to-by-his-middle-name > >I'll be glad when they're over and we can get back to living our lives > >Cheers, >Mike Kear >AFP Web Development >Windsor, NSW, Australia > > >On Wed, 17 May 2000, Peter Tilbrook wrote: > > > The Olympics 2000 are scheduled for September in Sydney and seven > Australian > > States and Territories will shift the Daylight Savings start date from the > > last Sunday in October forward two months to the last Sunday in August. > Find > > out how this time change affects Microsoft products and get the new time > > zone update for operating systems here: > > > > http://www.microsoft.com/australia/support/timezone/2000.htm > > > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with 'unsubscribe' > in the body. > > > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. === Nick Slay Technical Director Webbods Pty Ltd (ACN 086 160 189) PO Box 4047 Copacabana NSW 2251 Tel:02 4381 0284 Mob:0414 810284 === Join the BodNews mailing list for News/Announcements and Offers from Webbods. Send an email to [EMAIL PROTECTED] with 'subscribe bodnews' in the subject line. === Proud Sponsors of the Northern Eagles NRL Side 2000!!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Can CF generate a Pop-up Window w/o Javascript?????
First off, WHY can you not use javascript? Is it because you do not know javascript? or for some reason or the other cannot use it in this project? I have done somethign similar, and spent many hard minutes figuring out a solution to do just what you want. Its at www.opentelecom.com/selectcustomer.cfm You can use Angel Stewart as the name to test the paging functions. You will see that a seperate window opens with the Results from the form which are submitted, basically, and does some validation etc. I'll be glad to tell you how its done, and give you the sample code. Coding the Javascript string for the Open Window was a b. And don't worry, before this I never coded any javascript myself either. -Gel - Original Message - From: Richard Fascianella <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 05, 2000 10:21 AM Subject: Can CF generate a Pop-up Window w/o Javascript? > Hello, > > I joined this list with the hope someone can help me with an issue I am > having. > > I need to find out if CF can be used to generate a pop-up browser window > WITHOUT the use of javascript. > > What I am trying to do is validate a form, and have a pop-up box appear when > a field is not filled out, or when a field is a duplicate (using SQL to > check for dupes), informing the user of such. However, I am NOT able to use > javascript to generate the actual pop-up box. Will Cold Fusion be able to > gereate that pop-up box > > Im not a programmer, so please phrase your answers accordingly :) > > Thank you! > > Richard > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Bits & That
Hello! I've used 8 bit datatypes/record as flags in SQL7. So the 8 variables are stored in one byte. So far, so good. But I want to store the 8 variables, along with a couple of varchar datatypes in a CF Structure in RAM. Currently, the 8 bit vars are either 0 or 1. I elected not to allow nulls. I have a little over 100,000 records now, and doubt I'll go over 120,000. ColdFusion memory went to 300MB when I recently populated the Structure. I'll probably have less that 10,000 records with a non-zero bit var, and few of these will have more than 1 of the 8 bit vars non-zero. So my question is, would I save a lot of RAM if I allow NULLs in the bit vars in the DB? best, paul -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Shopping Cart Question (For Everyone)
Anyone interested in a full source unlimited store copy of AbleCommerce? I've never used it. Make me an offer off-list. best, paul At 07:39 AM 6/5/00 -0500, you wrote: >Able Commerce Builder > >Awesome - New format coming out later this fall that will be Fusebox, so I >have been assured by the company. > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Sunday, June 04, 2000 9:14 PM >To: [EMAIL PROTECTED] >Subject: Shopping Cart Question (For Everyone) > > >Well, I'm just wondering what is everyone's most recommended shopping cart >application that is OPEN SOURCE? > >Thanks > >Kevin > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Remote SQL Server access
Hi rob, All you gotta do is to configure the server with client connections via tcp/ip in the server network clients utility. Then ensure you use tcp/ip from your desktop to connect to the server (use either IP or FQDN of the server). Also make sure you set up valid user accounts. You can set up using either SQL security or if you want to add logging capabilities, use NT authentication (not totally sure how this is done just yet but am in the process of setting it up on one of our servers so will let you know once I've cracked it) To get further insightful info on this and virtually any other SQL 70 topics, I suggest you subscribe to the SQL7.0 mailing list over at swynk.com Hope this points you in the right direction, Dave Dave Wilson Internet Technology Manager, BizNet Solutions Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast BT9 6GE Tel: 02890 225 776 Fax: 02890 223 223 web: http://www.biznet-solutions.com email: [EMAIL PROTECTED] - Original Message - From: Robert M. Saxon, Jr. <[EMAIL PROTECTED]> To: Cf-Talk <[EMAIL PROTECTED]> Sent: Monday, June 05, 2000 8:18 PM Subject: OT: Remote SQL Server access > Has anyone installed the desktop version of SQL Server 7 on a workstation > and dialed into an ISP to connect to a SQL Server. If so, how did you do > that? I am trying to set up a telecommuting situation. I need to what steps > I must take to get that desktop version to communicate with a server via > ISP.) Any help offered is already appreciated. > > > Thanks, > Rob > > ___ > Robert M. Saxon, Jr. (Rob), Senior Web Developer > Mercer University > Department of Web Management > TSS // 1400 Coleman Avenue // Macon, GA 31207 > 912-301-5550 voice // 912-301-5314 fax > [EMAIL PROTECTED] > Philippians 4:13 > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
hey I can't see mine either RE Looping through form fields.
I have posted two replies to Steve Robson <[EMAIL PROTECTED]> RE Looping through form fields. I'm not going to repeat the message in case it is jinxed :-) Mail me Steve, if you've had no luck. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Remote SQL Server access
Yes. Dail-up is slooow. If you can, get DSL or faster. Use the Client Network Utiltiy under SQL 7 Create a server using TCP/IP library Add the server's ip address and port (1433) Register the new server in Enterprise Manager. Piece of cake. Email me if you have problems. Jacob At 03:18 PM 6/5/00 -0400, you wrote: >Has anyone installed the desktop version of SQL Server 7 on a workstation >and dialed into an ISP to connect to a SQL Server. If so, how did you do >that? I am trying to set up a telecommuting situation. I need to what steps >I must take to get that desktop version to communicate with a server via >ISP.) Any help offered is already appreciated. > > >Thanks, >Rob > >___ >Robert M. Saxon, Jr. (Rob), Senior Web Developer >Mercer University >Department of Web Management >TSS // 1400 Coleman Avenue // Macon, GA 31207 >912-301-5550 voice // 912-301-5314 fax >[EMAIL PROTECTED] >Philippians 4:13 > > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Automatically Start/Stop CF Server?
Create a bat file with: Net stop "Cold Fusion Application Server" Net start "Cold Fusion Application Server" Create a scheduled task to run this when you want. Jacob At 03:26 PM 6/5/00 -0400, you wrote: >Hi Folks, > >I've searched archives and FAQs and can't find the answer to this one: How >do you start & stop the cold fusion server automatically from your code? I >know this was discussed not too long ago, and I'm kicking myself for not >saving the answer. > >I know this had to do with the Cycle.bat (right?) but I'm not sure what it >was exactly... Any help would be appreciated. > >TIA, >Robyn > > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF to Excel
I just ran into this myself and heres what I came up with. The problem was with CFCOntent and NT SP6 and 6a. I hope can help someone... SELECT AdviserName, AdviserAspect, CoachName FROM UserInfo Click Here to open your report in Excel! -Original Message- From: Cary Gordon [mailto:[EMAIL PROTECTED]] Sent: Monday, June 05, 2000 7:22 AM To: [EMAIL PROTECTED] Subject: Re: CF to Excel The easiest way is to output an Excel readable text file, like a csv or tab delimited file. Cary At 02:01 PM 6/2/2000 -0700, you wrote: >How can I take the results of a Query and save it as an Excel file? > >This is what I though would work. > >Thanks all! > > > SELECT END_ITEM_ROOT_PN, END_ITEM_SN > FROM DSTS.B_V_DSTS_ASSEMBLY > ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN > > > >#END_ITEM_ROOT_PN# #END_ITEM_SN# > >Jim Ray >Delta Program NT Administrator >The Boeing Company >(714) 896-2038 >Email: [EMAIL PROTECTED] >Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF to Excel
I dont know if the last email I sent will reach you so here you go... SELECT AdviserName, AdviserAspect, CoachName FROM UserInfo Click Here to open your report in Excel! -Original Message- From: Cary Gordon [mailto:[EMAIL PROTECTED]] Sent: Monday, June 05, 2000 7:22 AM To: [EMAIL PROTECTED] Subject: Re: CF to Excel The easiest way is to output an Excel readable text file, like a csv or tab delimited file. Cary At 02:01 PM 6/2/2000 -0700, you wrote: >How can I take the results of a Query and save it as an Excel file? > >This is what I though would work. > >Thanks all! > > > SELECT END_ITEM_ROOT_PN, END_ITEM_SN > FROM DSTS.B_V_DSTS_ASSEMBLY > ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN > > > >#END_ITEM_ROOT_PN# #END_ITEM_SN# > >Jim Ray >Delta Program NT Administrator >The Boeing Company >(714) 896-2038 >Email: [EMAIL PROTECTED] >Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Best Method
your best bet is to attach a "date/time posted" field to the entry in the DB, and do a LAST(5) in your SQL statement. Chris Olive, DOEHRS Website Administrator -Original Message- From: Jeffrey Cohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 06, 2000 10:36 AM To: House OfFusion Subject: Best Method Greetings... What is the best method for reading ONLY the last five records in a database for display? I have a client that adds articles daily to a news database, and then displays them on a news page. There are hundreds of articles, and on his home page he just wants to display the 5 most recent. (which would be the last five in the database, I presume) Suggetstions??? and thanks as always for your help in advance... Jeffrey Cohen ImageWorks -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
There's something odd going on with this list...
Folks, Has anyone else experienced this: On June 3 at 11:07 AM I sent a message to the list entitled "Question about invoking Evaluate in a list attribute of a cfloop." The message didn't show up on the list until sometime Sunday. Then it has shown up again more than once. It's there today and Outlook lists it with a date of June 6, 2000 at 3:22 PM. Yet when I open it I see that it was really sent last Saturday. What gives? For a while I thought it was a dumb question (it still may be!) beacue I got no replies to it. But just in the last hour I got two helpful replies -- almost as if it appeared to others on the list today -- again even though I sent it Saturday. Is anything wrong with the list? Thanks, -- Tim Dempsey -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: rounding numbers with CF
> I have been using the round() function. It rounds up or down to > the nearest > whole number only. Am I wrong on this? how can I round up decimal > numbers. I > need to round a number like 1.41 to 1.50. I'm doing a timecard application > and I need to round to quarters .25 .50 .75 1.0 What would be a > good way to > do this with CF or what functions can help me with this problem. Here's an interesting solution, but maybe not the best... If you only want to round to the nearest half - double the number, Round() it, then halve it If you want to round to the quarter - quadrouple the number, Round() it, then quarter it This _should_ give you want you want... HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Download Question Using CFINCLUDE and Java Applets
I can't see why using CFINCLUDE should make any difference to its DL time. CFINCLUDE merely includes code in a page, once this is rendered client-side, the browser wouldn't "know" the difference between included code and any other. - Original Message - From: Double Down, Inc <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 05, 2000 7:51 AM Subject: Download Question Using CFINCLUDE and Java Applets > This is a multi-part message in MIME format. > > --=_NextPart_000__01BFCE7F.DED172A0 > Content-Type: text/plain; > charset="Windows-1252" > Content-Transfer-Encoding: 7bit > > I have a java applet menu that I want to use in a nested table. If the > applet is called from a CFINCLUDE tag will it still take a long time to > download? If it does, is there a better way to use this without using > frames on the page. > > TIA > > DDINC > > > --=_NextPart_000__01BFCE7F.DED172A0 > Content-Type: text/html; > charset="Windows-1252" > Content-Transfer-Encoding: quoted-printable > > xmlns:w=3D"urn:schemas-microsoft-com:office:word" = > xmlns=3D"http://www.w3.org/TR/REC-html40"> > > > charset=3Dwindows-1252"> > > > > cid:[EMAIL PROTECTED]"> > > > > > > > > > > > color=3Dblack > face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: > Arial'>I have a java applet menu that I want to use in a nested = > table. style=3D"mso-spacerun: yes">=A0 If the applet is called from a = > CFINCLUDE tag > will it still take a long time to download? If it does, style=3D"mso-spacerun: yes">=A0is there a better way to use this = > without > using frames on the page. > > color=3Dblack > face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: > Arial'> > > ont > size=3D2 color=3Dblack face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size: > 12.0pt;font-family:Arial;mso-bidi-font-family:Arial;color:black'>TIA n> size=3D2 color=3Dblack face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size: > 12.0pt;font-family:Arial;mso-bidi-font-family:Arial;color:black;mso-color= > -alt: > windowtext'> > > Roman"> style=3D'font-size:12.0pt;color:black'> color=3Dblack> style=3D'color:black;mso-color-alt:windowtext'><= > /p> > > style=3D'font-size: > 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;mso-bidi-font-family:A= > rial; > color:black'>DDINC face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;mso= > -bidi-font-family: > Arial;color:black;mso-color-alt:windowtext'>= > > > color=3Dblack> color=3Dblack> style=3D'color:black;mso-color-alt:windowtext'><= > /p> > > > > > > > > --=_NextPart_000__01BFCE7F.DED172A0-- > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Professional vs. Enterprise
Hi all, Assuming I'm not clustering, what's the difference between Professional and Enterprise? Portent Interactive http://www.portentinteractive.com Process, Design, Content -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What are Snippets?
Can someone tell me what are snippets, when are they used? I am a new CF user. Please help! Thanks __ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.