Re: Multiple Messages
Is anyone else getting multiple copies of the same messages? Seems to only have started in the last hour or two... Sometimes... seems to be very intermittent. Its been happing for a few days though. I don't know if the sender is somehow posting twice or if the list server is goofing up. I've been thinking that its the list server because I've seen duplicate messages from some pretty computer savvy people (Dave Watts, for example) who I wouldn't think would accidentally send duplicate posts. Its been so infrequent though that I haven't paid it much thought. If I start getting duplicates of *every* message I'll start to get concerned g. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk 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: Allaire at Internet World -anyone going or there Friday??
Stephen, Went with our team on Wednesday. No allaire. We heard there was going to be a runway show on Wednesday though. Aaron -Original Message- From: Stephen M. Aylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 9:11 PM To: [EMAIL PROTECTED] Subject: Allaire at Internet World -anyone going or there Friday?? Anyone going to Internet World tomorrow - Friday?? Off List Is allaire there? Stephen M. Aylor Aylor Insurance Agency, Inc. "Specialized Insurance for IT - We Cover IT" [EMAIL PROTECTED] 949.581.2333 (v) 949.581.2814 (f) -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Grrr ##'s agin
I think that this should work for you and no pound signs :-) cfset mydate = createdatetime(year(Evaluate("application." session.cName "_bidstopdate")), month(Evaluate("application." session.cName "_bidstopdate")), day(Evaluate("application." session.cName "_bidstopdate")), hour(Evaluate("application." session.cName "_bidstoptime")), minute(Evaluate("application." session.cName "_bidstoptime")), second(Evaluate("application." session.cName "_bidstoptime"))) cfif Evaluate("application." session.cName "bidstatus") EQ "On" Good luck with it, -Michael Michael Imhoff www.omnicypher.com icq: 10495667 [EMAIL PROTECTED] (home) (320) 255-4447 (home) [EMAIL PROTECTED] (cell) (612) 247-8159 (cell) Allaire Alliance Consulting Partner - Original Message - From: "Brian L. Wolfsohn" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 12:11 AM Subject: Grrr ##'s agin This was working fine, until i tried sticking session.cname synamically into the creation of mydate. I can't seem to get the correct combination of "'s, #'s, etc etc etc... Of course, maybe it was just that i couldn't find the eye of a newt for the magic potion that makes all this clear!!! Of course, if there's a simple function that i'm missing that eliminates this need, please point out which day's class i slept through... many thanks.. cfset mydate=createdatetime(#year("#application.#session.cName#_bidstopdate#")#,#m onth("#application.#session.cName#_bidstopdate#")#,#day("#application.#sessi on.cName#_bidstopdate#")#,#hour("#application.#session.cName#_bidstoptime#") #,#minute("#application.#session.cName#_bidstoptime#")#,#second("#applicatio n.#session.cName#_bidstoptime#")#) I haven't gotten to this line of code yet, BUT, i'm sure i'll need help with this one also.. cfif application.#session.cName#bidstatus EQ "On Brian L. Wolfsohnhttp://www.cus.com CUS Business Systems Ft.Lauderdale,FL Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
MSSQL to Oracle
How do you transfer data and sql queries from mssql to oracle. Is there a easy way. Appreciate. A. Bajaria __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk 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.
Netscape! Hidden fields?
Hair torn out - ready to kill... it must be a normal day at work. So does anyone else have problems using hidden form fields in Netscape? Why won't they pass the values to the next template? Why? Why? Why??? Taz -- Archives: http://www.eGroups.com/list/cf-talk 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: Security holes revisited
operations, such as man-in-the-middle attacks, but denial of service attacks don't require anything other than the attacker have more bandwidth than the target. Dave Watts, CTO, Fig Leaf Software True. The particular high-publicity attacks of a month or so back though used a technique that amplified their attacks generating more load than pure bandwidth alone could produce. Sort of like what enriching an atomic bomb with a deutrium shell does for an h-bomb. ;-) --min -- Archives: http://www.eGroups.com/list/cf-talk 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: Netscape! Hidden fields?
You sure you have the closing /form tag - Original Message - From: Chris Tazewell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 10:23 AM Subject: Re: Netscape! Hidden fields? This is the resolved source in the Nutscrape browser, the values are from 2 CF variables but as you can see they are resolved. FORM NAME="SearchForCars" ACTION="../cfm/body_car_details.cfm" TARGET="body" METHOD=POST INPUT TYPE="HIDDEN" NAME="Username" VALUE="test" INPUT TYPE="HIDDEN" NAME="UserID" VALUE="-2035698287" The receiving template is pretty much irrelavent because all Im trying to do for debug is test the presence of the two values, just an IsDefined. But it's not that code because the debug info on the end of the page shows no values (wheareas it does in IE)... all the other form values (not hidden) are fine. Debug info: ___IE___ Form Fields: MILEAGE=Mileage FORMSBUTTON2.X=32 FORMSBUTTON2.Y=18 MODEL=Model USERNAME=test USERID=-2035698287 FIELDNAMES=USERNAME,USERID,MAKE,MODEL,YEAR,MILEAGE,FORMSBUTTON2.X,FORMSBUTTO N2.Y YEAR=Year MAKE=Make ___Netscape___ Form Fields: MILEAGE=Mileage FORMSBUTTON2.X=39 FORMSBUTTON2.Y=15 MODEL=Model FIELDNAMES=MAKE,MODEL,YEAR,MILEAGE,FORMSBUTTON2.X,FORMSBUTTON2.Y YEAR=Year MAKE=Make Now if anyone can explain this phenomenom (baring in mind I've done this a hundred times before without trouble) Ill be chuffing happy. Any issues with frames? Any bizarre bugs? Cheers Taz I've never seen a problem like that. How about some sample code for the form and the action page? Howie Hamlin -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Speed of CFMAIL
On a good day I can have my box spit out 2.000 mails per minute, That's just queued to disk? or delivered from queue to smtp destination? Howie needs to how many mails / hour delivered OUT OF THE CF BOX (to his next hop MTA). 30 ms/msg is pretty darn good, anyway. 3,000,000 / day ... queued to disk! LOL "dans queue" for that info, Dirk. Len on a queued day, you can wait forever! -- Archives: http://www.eGroups.com/list/cf-talk 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: Netscape! Hidden fields?
Chris, Make sure your form has an ending /FORM tag. Netscape really has problems when this isn't present. IE will still pass the form's content though... -Dan ++---+ | name | Dan G. Switzer, II| |company | PengoWorks.com| |www | http://www.pengoworks.com | | mailto | [EMAIL PROTECTED] | ++---+ -Original Message- From: Chris Tazewell [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 5:23 AM To: [EMAIL PROTECTED] Subject: Re: Netscape! Hidden fields? This is the resolved source in the Nutscrape browser, the values are from 2 CF variables but as you can see they are resolved. FORM NAME="SearchForCars" ACTION="../cfm/body_car_details.cfm" TARGET="body" METHOD=POST INPUT TYPE="HIDDEN" NAME="Username" VALUE="test" INPUT TYPE="HIDDEN" NAME="UserID" VALUE="-2035698287" The receiving template is pretty much irrelavent because all Im trying to do for debug is test the presence of the two values, just an IsDefined. But it's not that code because the debug info on the end of the page shows no values (wheareas it does in IE)... all the other form values (not hidden) are fine. Debug info: ___IE___ Form Fields: MILEAGE=Mileage FORMSBUTTON2.X=32 FORMSBUTTON2.Y=18 MODEL=Model USERNAME=test USERID=-2035698287 FIELDNAMES=USERNAME,USERID,MAKE,MODEL,YEAR,MILEAGE,FORMSBUTTON2.X,FORMSBUTTO N2.Y YEAR=Year MAKE=Make ___Netscape___ Form Fields: MILEAGE=Mileage FORMSBUTTON2.X=39 FORMSBUTTON2.Y=15 MODEL=Model FIELDNAMES=MAKE,MODEL,YEAR,MILEAGE,FORMSBUTTON2.X,FORMSBUTTON2.Y YEAR=Year MAKE=Make Now if anyone can explain this phenomenom (baring in mind I've done this a hundred times before without trouble) Ill be chuffing happy. Any issues with frames? Any bizarre bugs? Cheers Taz I've never seen a problem like that. How about some sample code for the form and the action page? Howie Hamlin -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Alphabetical Order
Aslam, If you have control of your query, then use the ORDER BY clause to sort your data in a specific manor-this is the best approach. Let the database do what it does best. For example: CFQUERY NAME="GetServices" DATASOURCE="SomeDSN" SELECT ServiceID, Description FROM Services ORDER BY Description /CFQUERY CFOUTPUT QUERY="GetServices"#Description#BR /CFOUTPUT NOTE: To sort by "descending" order, add "DESC" after the column name. You can also sort by multiple columns. -Dan ++---+ | name | Dan G. Switzer, II| |company | PengoWorks.com| |www | http://www.pengoworks.com | | mailto | [EMAIL PROTECTED] | ++---+ -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 05, 2000 2:53 PM To: [EMAIL PROTECTED] Subject: Alphabetical Order I have a drop down list that is filled in with the data from a query. Is there a way to alphabetically arrange the list. It looks really ugly and difficult to read when it is not in the alphabetical order. Is there a built in function in CF for that. Appreciate. AB __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Speed of CFMAIL
To the disk. I missed the bit about getting the message to the client. So first the messages are queued locally, then I deliver them to a smart host at my provider, this will be typically at 150 to 300 msg per minute, obviously depending on numerous factors such as local server load, remote server load, bandwidth. To actually get them delivered to the client is not my concern at this point, not until my ISP starts complaining. I guess this will takes a couple of hours to get the last one out. - Original Message - From: "Len Conrad" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 05, 2000 8:52 PM Subject: Re: Speed of CFMAIL On a good day I can have my box spit out 2.000 mails per minute, That's just queued to disk? or delivered from queue to smtp destination? Howie needs to how many mails / hour delivered OUT OF THE CF BOX (to his next hop MTA). 30 ms/msg is pretty darn good, anyway. 3,000,000 / day ... queued to disk! LOL "dans queue" for that info, Dirk. Len on a queued day, you can wait forever! -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
CFTREE problem
This is a strange one. I have an application that has been running on the client server for months with no problem. Then the client decided to upgrade the CF server from 3 to 4.5. Of course, problems popped up, but most were easily fixed. The one I can't figure out is the CFTREE. On one of the branches of the tree (there are three main branches that work fine), the links give users a "not able to access server" message, so I tried it and those links are trying to access the localhost 127.0.0.1. All links on the tree are coded with a path variable declared in the application.cfm file. Anyone have any ideas? Thanks, Larry -- Archives: http://www.eGroups.com/list/cf-talk 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.
CFOBJECT error, but not using tag
Has anyone ever seen this problem. We are running CF Pro NT 4.0. We are getting this error but aren't using any CFOBJECT tags. ERROR MESSAGE: Error trying to create object specified in the CFOBJECT tag. P COM error 0x80040154. Class not registered PP Ryan Thompson James Tower Media Design Websites, Multimedia, Videos, Catalogs, e-Catalogs and more. http://www.jtmd.com phone:507.386.9311 mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.
cfinsert cfquery
cfthanks I have 1 database on a mssql , 2 tables, i need to insert user_id and password in dbo.usere and the user details in dbo.userdetails with one how can i do this with one cfinsert cfquery . cftahanks -- Archives: http://www.eGroups.com/list/cf-talk 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: cfinsert cfquery
you can't, not without a stored procedure. you might want to look into doing it in two CFQUERYs, wrapped in a CFTRANSACTION. IE, CFTRANSACTION CFQUERY INSERT username, password... /CFQUERY CFQUERY INSERT userdetails /CFQUERY /CFTRANSACTION this way if one blows up, the entire transaction gets rolled back, and you avoid ugly data consistency problems. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 9:52 AM To: Cf-Talk@Houseoffusion. Com Subject: cfinsert cfquery cfthanks I have 1 database on a mssql , 2 tables, i need to insert user_id and password in dbo.usere and the user details in dbo.userdetails with one how can i do this with one cfinsert cfquery . cftahanks -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
CFTREE problem - resolved:error in database
Sorry folks. Someone hardcoded the localhost path into a database table. Larry -- Archives: http://www.eGroups.com/list/cf-talk 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.
Highlighting single item in SELECT
Anyone know how to change the color of a single item in a SELECT tag? For example, SELECT NAME="XXX" CFOUTPUT QUERY="GetStuff" cfif GetStuff.highlight IS "Y" OPTION VALUE="#GetStuff.name#" font color="Red"#GetStuff.name#/font cfelse OPTION VALUE="#GetStuff.name#" #GetStuff.name# /cfif /CFOUTPUT /SELECT Tom -- Archives: http://www.eGroups.com/list/cf-talk 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: Special character question:
#9; = TAB (horizontal tab) Bookmark this: http://www.asciitable.com/ Or, you can always try this on any special character: cfoutput #Chr(9)# /cfoutput Ye -Original Message- From: Pecora, James [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 2:49 PM To: CF Talk (E-mail) Subject: Special character question: What is this?? #9; -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: cfinsert cfquery
how about something like CFQUERY NAME="AddUser" DATASOURCE="sqlswidata" INSERT INTO Users,UserDetails (Users.UserID,Users.Password,UserDetails.FirstName,UserDetails.LastName,User Details.Company,UserDetails.Address1,Address2,UserDetails.City,UserDetails.S tate,UserDetails.Country,UserDetails.Zip,UserDetails.PhoneHome,UserDetails.P honeWork,UserDetails.PhoneFax,UserDetails.Email) VALUES ('#Form.UserID#', '#Form.Password#','#Form.FirstName#' etc etc.etc) /CFQUERY -Original Message- From: Olive, Christopher M Mr USACHPPM [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 6:57 AM To: '[EMAIL PROTECTED]' Subject: RE: cfinsert cfquery you can't, not without a stored procedure. you might want to look into doing it in two CFQUERYs, wrapped in a CFTRANSACTION. IE, CFTRANSACTION CFQUERY INSERT username, password... /CFQUERY CFQUERY INSERT userdetails /CFQUERY /CFTRANSACTION this way if one blows up, the entire transaction gets rolled back, and you avoid ugly data consistency problems. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 9:52 AM To: Cf-Talk@Houseoffusion. Com Subject: cfinsert cfquery cfthanks I have 1 database on a mssql , 2 tables, i need to insert user_id and password in dbo.usere and the user details in dbo.userdetails with one how can i do this with one cfinsert cfquery . cftahanks -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Using CFX_Excel
Your right I haven't used the tag. Depending on how you want the layout to look though, what can be easier or have less overhead than having CF output query results to an HTML file and simply saving it with *.xls on the end instead of *.htm or *.html You obviously didn't try it, either. :) Do whatever works for you and gets the job done the way you want it. Fred Sanders Galveston, Texas Having a bad day? Imagine this... You are in total seclusion from that hectic place called "The World". The soothing sound of a gentle waterfall fills the air with a cascading serenity. The water is clear. You can easily make out the face of the person you are holding underwater. Feeling better? - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 8:05 AM Subject: Re: Using CFX_Excel Hi Fred, I think we have solved the problem. First, I put the tag in a CFLOCK to prevent attempts at multi-threading. Then, there was another problem. I was not aware that our SysAdmin had made the https directory a little different structure than the http directory. There were some added characters in the path so here is what was happening. Excel was generating the spreadsheet (Sheet 1), but because it could not find the directory, it kept sitting there with the message "Do you want to save Sheet 1?". These were stacking up and I think this was what was really causing the problem. As for the CFX_Excel, I can't imagine that you've used the tag if you suggested I first save the file as HTML and doing all that formatting. CFX_Excel makes it Sooo much simpler. Dave = "Technology" is stuff that was invented after you were born. David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: Fred Sanders [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 2:57 PM Subject: Re: Using CFX_Excel Why bother with the tag. If your wanting to output nice looking spreadsheets and don't mind having to make painful amount nested tables you can have professional looking Excel97/2K spreadsheets by creating them as HTML files and saving them with an .xls extension before allowing the user to download them. I don't think it will work with anything below Excel 97 though, but the results in the end are worth the trouble your going to go through getting the layout perfect. Fred Sanders Galveston, TX Having a bad day? Imagine this... You are in total seclusion from that hectic place called "The World". The soothing sound of a gentle waterfall fills the air with a cascading serenity. The water is clear. You can easily make out the face of the person you are holding underwater. Feeling better? - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 11:11 AM Subject: Using CFX_Excel Anybody got a clue on this??? 8-) + Original Message Sent 7:47am ET + Good Morning, Are there any known issues surrounding the use of the CFX_Excel tags? I'm using it for several applications now, and I was wondering if there are any issues to be aware of - like, how many concurrent calls to Excel can it handle? The reason I've asked is that two days in a row, Excel on our server caused a "kernel32.dll" error and locked the server. Now, assuming that nothing is hosed up in Windows NT (we all know that never happens) and the Excel install is A-OK (which it seems to have been to the point the problems started) - what are the possibilities? I'm wondering if too much traffic on the tag/application combo might be the culprit? Also, can you do a CFLOCK to avoid this problem? Any thoughts? Thanks, Dave = "Technology" is stuff that was invented after you were born. David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
HELP Getting Identity Field Accurately
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFA09D.4F0AFC20 Content-Type: text/plain; charset="iso-8859-1" In referring to this article: http://www.defusion.com/articles/index.cfm?ArticleID=72 The method below of inserting a record is not a reliable way to get the corresponding record id in Cold Fusion: Is this article correct in stating this method does not work, even if the code is wrapped in a CFTRANSACTION?? What is the best, scalable method for retrieving the identity field from the database, in the anticipation of heavy traffic? Thanks, Heres the code: cftransaction cfquery name="my_insert" datasource="whatever" INSERT INTO myTable ... /cfquery cfquery name="get_id" datasource="whatever" SELECT MAX(myTable.ID) as new_id FROM myTable /cfquery /cftransaction Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com --_=_NextPart_001_01BFA09D.4F0AFC20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEHELP Getting Identity Field Accurately/TITLE /HEAD BODY PFONT SIZE=3D2 FACE=3D"Arial"In referring to this article: /FONT BRFONT SIZE=3D2 FACE=3D"Arial"A = HREF=3D"http://www.defusion.com/articles/index.cfm?ArticleID=3D72" = TARGET=3D"_blank"http://www.defusion.com/articles/index.cfm?ArticleID=3D= 72/A /FONT /P PFONT SIZE=3D2 FACE=3D"Arial"The method below of inserting a record = is not a /FONT BRFONT SIZE=3D2 FACE=3D"Arial"reliable way to get the corresponding = record id /FONT BRFONT SIZE=3D2 FACE=3D"Arial"in Cold Fusion:/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Is this article correct in stating = this method does /FONT BRFONT SIZE=3D2 FACE=3D"Arial"not work, even if the code is wrapped = in a /FONT BRFONT SIZE=3D2 FACE=3D"Arial"CFTRANSACTION?? /FONT /P PFONT SIZE=3D2 FACE=3D"Arial"What is the best, scalable method for = retrieving /FONT BRFONT SIZE=3D2 FACE=3D"Arial"the identity field from the database, = in the /FONT BRFONT SIZE=3D2 FACE=3D"Arial"anticipation of heavy traffic? = /FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Thanks, Heres the code:/FONT BRFONT SIZE=3D2 = FACE=3D"Arial"/FONT BRFONT SIZE=3D2 FACE=3D"Arial"lt;cftransactiongt;/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"lt;cfquery = name=3Dquot;my_insertquot; = datasource=3Dquot;whateverquot;gt;/FONT BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp; INSERT INTO = myTable/FONT BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = .../FONT BRFONT SIZE=3D2 FACE=3D"Arial"lt;/cfquerygt;/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"lt;cfquery name=3Dquot;get_idquot; = datasource=3Dquot;whateverquot;gt;/FONT BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp; SELECT = MAX(myTable.ID) as new_id/FONT BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp; FROM myTable/FONT BRFONT SIZE=3D2 FACE=3D"Arial"lt;/cfquerygt;/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"lt;/cftransactiongt;/FONT /P PBFONT COLOR=3D"#80" SIZE=3D2 FACE=3D"Verdana"Scott = Becker/FONT/B BRFONT COLOR=3D"#00" SIZE=3D1 FACE=3D"Verdana"Web Developer : = ConnectWise, Inc./FONT BRIFONT COLOR=3D"#00" SIZE=3D1 = FACE=3D"Verdana"www.ConnectWise.com/FONT/I /P /BODY /HTML --_=_NextPart_001_01BFA09D.4F0AFC20-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT (longish) Tango??
The item (below) was included in a posting to another UG... ...the author is an employee of Pervasive (Developer of Tango) It's claims caught my attention. Anyone have any thoughts/experiences with Tango vs CF. Dick I am a senior software engineer for Pervasive Software (the maker of Tango). I work in the developer solutions group and I was responsible for writing the StoreFront demo that comes with package. I can tell you that Tango handles "all" of the above. As I write this, I am in the middle of a multi-developer/multi-site development effort for the largest project I've ever been involved with - all built completely around Tango. We are using SourceSafe for source control and Tango directly connects to this package from within the IDE (as well others) - key to survival here! Tango is very XML centric, the application files Tango generates are XML and Tango has a full set of XML/DOM interfaces - including the ability to retrieve and send XML over HTTP which allows things like WML (http://www.pervasive.com/news/pr/pr00apr05.html), SOAP, and other XML standards to be used. Tango is a GUI driven "action" based development environment that also includes an extensible "Mark-up language" as well as object oriented design capabilities (Tango class files) and the ability to directly use both COM and Java Beans - and even other extensibility features (DLL, command line, apple script). All this, and not mention that Tango is available on Window, UNIX, Linux and Mac platforms. We find many users preferring to develop on the Mac platform and deploy on NT or UNIX. Tango also has the ability, unlike CF, to separate the Tango server from the Web Server allowing a higher level of security to be implemented by placing a firewall between Tango and your web server - this is very critical when your database also needs to be behind the firewall yet doesn't use TCP/IP as a transport mechanism! Tango can connect to any data store that supports ODBC, and can also directly connect to Oracle (via OCI) and Pervasive.SQL. I can go on, but I don't need to - I can say what ever I want, only you can decide for yourself if the tool is right for you, so don't take my word for it, try it yourself: http://www.pervasive.com/tango/. Also, be sure to visit some sites built on Tango: http://www.theglobe.com http://www.colleges.com http://www.jokes.com http://componentzone.pervasive.com Thanks, Ritchie *** Thoughts on Cold Fusion *** In CF, there is no action based GUI like Tango's, it has only a page-based layout. The CF Editor is just Allaire's HomeSite product with CF tags thrown in. Although CF has project wizards, it still takes hours to days to do what Tango's Search Builder can do in four minutes. The graphical structure of Tango makes it much easier to use for big projects, and easy source control integration and Tango-based objects means that it is easy to split a project between many people. *** Key Tango Features *** - Intuitive, visual application development environment-the Tango Development Studio. - 26 built-in actions for implementing business logic. - Object extensibility with COM objects and JavaBeans. - Tango's own object model-robust reusability with Tango class files. - State-of-the-art personalization and content management. - Full XML implementation for accurate business-to-business communication. - Cross-platform development on Windows or Mac OS. - Multi-platform deployment on Windows NT/95/98, Solaris, Linux and Macintosh. - A robust Application Server that scales to meet increasing demands. - Team-based development features, such as source code control mechanisms for secure development. - Native Oracle support and bundled ODBC drivers for advanced database connectivity. - Pervasive.SQL 2000 database bundled with Windows, Solaris and Linux versions. - Online tutorials, demos and sample code to jumpstart development and cut the learning curve. *** Usability Highlights *** - Able to separate application logic from presentation logic. This makes it MUCH easier to modify someone else's' code. - Able to break down presentation code into smaller bite size pieces. - Search/Update/Delete Database Actions are very fast to setup and useful for integrating data rapidly into web applications. -Original Message- Sent: Thursday, April 06, 2000 2:23 AM Subject: RE: Popularity Cold Fusion Can you explain "Not good for big projects with different coder. No structure enough." One of the Key features that we are looking for in Cold Fusion is Distributed Development/Remote Development of applications, We need good project management capablities like Source Control Integration, Remote team development etc.Also,being a offshore software development company catering to the US markets it becomes all the more critical. One more feature we are looking hard is CFML and XML integration. How does Tango handle the above? Does Tango have its own server side Mark-up language? I would appreciate your
RE: Storage Fees
Store it? Well, a 30gig IDE drive will run you about $250 these days. What are they wanting to do with the data? Are you providing access to it via your internet connection? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 5:50 PM To: [EMAIL PROTECTED] Subject: OT: Storage Fees A good customer of mine asked me today what I would charge to store 4GB of data? I'd appreciate any ideas of the going rate. best, paul -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Highlighting single item in SELECT
option style="color: red;"#GetStuff.Name#/option -Original Message- From: Thomas Soraoka [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 6:22 PM To: CF-Talk (E-mail) Subject: Highlighting single item in SELECT Anyone know how to change the color of a single item in a SELECT tag? For example, SELECT NAME="XXX" CFOUTPUT QUERY="GetStuff" cfif GetStuff.highlight IS "Y" OPTION VALUE="#GetStuff.name#" font color="Red"#GetStuff.name#/font cfelse OPTION VALUE="#GetStuff.name#" #GetStuff.name# /cfif /CFOUTPUT /SELECT Tom -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Netscape 6 Eats Microsoft PWS...Story at 11
This is a bit OT but, my impression so far is underwhelming. There are some nice additions, such as the cookie viewer, enhancements to Messenger, and more efficient screen space. Under Win98 I have had it crash on me a couple of times in the 3 days that I have had it installed. Others who are running it under NT haven't experienced this. Also, as far as I've found, there aren't (m)any plugins that work with it yet. On install you can choose to have a Flash/Shockwave plugin included but, I have yet to find a site that recognizes this. I understand that this is a preview release which was motivated by political events, i.e. M$'s problems, but, that doesn't make it any easier to evaluate. One annoyance I found is that if you don't choose to include the Messenger product then you can't use 'maito:' links. Also, there the address bar doesn't include the traditional pull-down capability and the 'Go' menu, which acts as a substitute, blanks out some of it's entries although you can still click on these blank areas and be taken to the respective site. I guess this provides a surprise! kind of feel :) Auto-complete in the location bar doesn't work either :( Lastly, page loads are a bit slower than IE 5.x. It's enough to be noticeable. On the other hand, CSS support is much better and I am getting to like the widget set. It's nice to see something other than the default MS widgets. I hope they work it all out quickly 'cause IE 5.5 is just around the corner and I want to see the Netscape browser succeed. After all, our infrastructure standardized on it several years ago and I'd hate to have to use a 3 year old browser. Steve -Original Message- From: Stephen M. Aylor [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 1:03 AM To: [EMAIL PROTECTED] Subject: Re: Netscape 6 Eats Microsoft PWS...Story at 11 Damn... and I was s looking forward to those killer new useful features... instant email "chat" and "designer skins". Anyway to install it with just the browser and mail client without all the "high school" AOL-ness? Steve -- Archives: http://www.eGroups.com/list/cf-talk 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.
nesting queries??
Hello all, I would like to know how you guys are nesting queries? i have to "Nest" multiple queries like cfoutput query="query1" cfoutput query="query2" --- cfoutput query="query3" -- /cfoutput /cfoutput /cfoutput How can i do this? Thanks inadvance Joe -- Archives: http://www.eGroups.com/list/cf-talk 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. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk 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.
Oracle CLOB Data Type
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFA09F.83953060 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hi, =A0I can't figure out how to select=A0the CLOB data type = using=A0CFQUERY from an Oracle database and display it in a table using CFOUTPUT.=A0 Does = anyone have the solution?=A0 =A0 Thank you very much =A0 Yungchih=A0 =A0 --_=_NextPart_001_01BFA09F.83953060 Content-Type: text/html; charset="ISO-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1" META content="MSHTML 5.00.2614.3500" name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff BLOCKQUOTE style="MARGIN-RIGHT: 0px" DIV align=left class=OutlookMessageHeader dir=ltrFONT face=Tahoma/DIV/FONT DIVBRFONT size=2SPAN class=800124515-07042000FONT color=#ff face=ArialHi,/FONT/SPAN/FONT/DIV DIVFONT size=2SPAN class=800124515-07042000nbsp;/SPANI can't figure out how to selectnbsp;the CLOB data type usingnbsp;CFQUERY from an Oracle database and display it in a table using CFOUTPUT.nbsp; Does anyone have the solution?nbsp;BRFONT color=#ff face=ArialSPAN class=800124515-07042000/SPAN/FONT/FONT/DIV DIVFONT size=2FONT color=#ff face=ArialSPAN class=800124515-07042000/SPAN/FONT/FONTnbsp;/DIV DIVFONT size=2FONT color=#ff face=ArialSPAN class=800124515-07042000Thank you very much/SPAN/FONT/FONT/DIV DIVFONT size=2FONT color=#ff face=ArialSPAN class=800124515-07042000/SPAN/FONT/FONTnbsp;/DIV DIVFONT size=2FONT color=#ff face=ArialSPAN class=800124515-07042000Yungchihnbsp;/SPAN/FONT/FONT/DIV DIVnbsp;/DIV DIVFONT size=2BR/FONT/DIV/BLOCKQUOTE/BODY/HTML --_=_NextPart_001_01BFA09F.83953060-- -- Archives: http://www.eGroups.com/list/cf-talk 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: Indiana time (EST) -- Michigan time (DST)
Well, if I read his post correctly, the server resides in a location that is on EST all year without ever switching to daylight savings time and back again. The client site is on EST but does use daylight savings time. Therefore, once the client site goes to DST he'll need to add an hour so that the viewed time at the client is (EST + 1). Once the client 'falls back' to normal EST the posted time on the server will still be (EST + 1), which is wrong. Steve -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 1:02 AM To: [EMAIL PROTECTED] Subject: Re: Indiana time (EST) -- Michigan time (DST) If I understand you correctly, you just use DateAdd("h", "1", Now()). This would add 1 hour to the current time. Don't forget to add logic which monitors the current date otherwise you'll be an hour off for half the year If DateAdd("h", "1", Now()) adds 1 hour to the current time, how do you figure it would be off half the year? Steve -- Archives: http://www.eGroups.com/list/cf-talk 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.
NSlookup on email domains
Hi! Is there a way that we could get Cold Fusion to do an NSLookup of an e-mail address domain? I was thinking of mabe using the WHOIS query from networksolutions. http://www.networksolutions.com/cgi-bin/whois/whois?STRING=yahoo.com Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk 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 retrieve from this list
You can retrieve the part number using Mid function: CFSET partno= Mid(Fieldname,5,Len(Fieldname)-5) CFSET quantity = Evalaute(Fieldname) You can loop through the FIELDNAMES list to get each value and quantity. Depending on what you want to do with these, you could create a structure, or an array, or a query, or whatever. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Jim Kellow [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 3:49 PM To: [EMAIL PROTECTED] Cc: Jim Kellow Subject: How do I retrieve from this list From the data below I need to extract the partno and qty i.e.partno 019000202 qty 2. I have looked/tried and read but I can find no examples, lots of single fields passed but not multiples. Thanks JimK :) Parameters Form Fields: FIELDNAMES=PQTY019000202,PQTY019000250,PQTY019000254,PQTY019000275,PQTY01900 0276,PQTY019000278,PQTY019000280,PQTY019000311,PQTY019000363,PQTY019001059,P QTY019001062,PQTY019001063,PQTY019001066,PQTY019001067,PQTY019001068,PQTY019 001069,PQTY019001073,PQTY019001080,PQTY019001096 PQTY019000202=2 PQTY019000250= PQTY019000254= PQTY019000275=3 PQTY019000276= PQTY019000278= -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Parsing NNTP dates?
Reuben, Where are you getting the dates from? Fuseware's CFX_NNTP handles this automatically. The only way I know to do it would be to break the date into a space delimited list. You would then have to loop through checking values to see what date part it consisted of, and then building a valid date object from that. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Reuben King [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 6:12 PM To: [EMAIL PROTECTED] Subject: Parsing NNTP dates? ParseDateTime() is choking on this.. NNTP posts have a date/time in the format of "Mon Mar 13 21:19:03 CST 2000" .. Anyone know of a quick and dirty way to get this into a CF date/time object? TIA, -R -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
CFLOOP list=Query.Value ??
I have a list of comma seperated numbers in a field in my database. I would like to retrieve this list of numbers, which are primary keys to other tables) and loop through them, running a query for each number(key). Here's what I have: - snip - CFQUERY name="qryGetKidsFromParentsID" datasource="Gymtime" SELECT emer_ref FROM contact WHERE contact_id = #URL.sel# /cfquery - snip - CFLOOP index="varLoopKidIDFromParentRelationships" list="qryGetKidsFromParentsID.emer_ref" delimiters="," - snip - The error I am getting is this: - - ODBC Error Code = S0002 (Base table not found) [Sybase][ODBC Driver][Adaptive Server Anywhere] Table or view not found: Correlation name 'qryGetKidsFromParentsID' not found - - The list="Query.Value" sounds good in theory, but I'm sure I'm doing it way wrong. Any suggestions? Thanks, Todd Ashworth - Saber Corporation Web Application Development www.sabersite.com (803) 327-0137 [111] (803) 328-2868 (fax) -- Archives: http://www.eGroups.com/list/cf-talk 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: IE JavaScript problem
David, Thanks...that was a good idea and solved my problem! Chris -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 1:05 AM To: [EMAIL PROTECTED] Subject: Re: IE JavaScript problem Chris, I'm not sure why you're getting the error (Jeff, where are you?), but I recommend that you move the SelectEntity function from the frame #1 document into the frame #2 document, and call it from the frame #1 document. -David On Thu, 6 Apr 2000 Lomvardias, Christopher writes: I'm having a browser compatibility problem. Each time I click on a record (from an a href onclick in frame #1), it fires off the SelectEntity() function and is supposed to add the selected record to a select box named "avlList" in frame #2. Anyone have any idea why this won't work in IE5 but does in NS4.7? //clear select box on page load parent.RightSide.document.DataForm.avlList.options.length = 0; //populate select box when user selects records from record list function SelectEntity(UCode,UValue) { var target = parent.RightSide.document.DataForm.avlList.options.length-1; NewOpt = new Option; NewOpt.value = UCode; NewOpt.text = UValue; parent.RightSide.document.DataForm.avlList.options[target+1] = NewOpt; } YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Netscape! Hidden fields?
In Netscape, you don't need to rebuild an entire form to associate two select boxes. I have done this several times. What code are using in your JS? Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Chris Tazewell [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 7:25 AM To: [EMAIL PROTECTED] Subject: Re: Netscape! Hidden fields? So. ... please shoot me in the head. I was just pasting the code into an email when all at once I was hit by a startling revelation! I AM STUPID!!! My template is a bunch of dynamically created drop downs, where depending on what's clicked in one - another is populated via a series of javascript funcs. In IE, this is a relatively easy thing becuase all you need to do is delete the option values and renew them. But Netscape the pain in the arse which is Netscape... the 'please kill me now, I have to get this to work with' Netscape! With Netscape you have to rebuild the whole form... EVERTHING! which is a page of javascript. And what did I forget to do? I didn't add the two hidden form elements to the javascript functions - so it appeared in the page source, but not in the regenerated page. Please, somebody, shoot me in the head. Thank you to everyone who replied. Taz -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT PCAnywhere on Port???
Are my messages not getting through? Or are they encrypted? ·!÷¬Ûiÿü0Áá«¢êlr¿+-ýÇíjY¡Iì¹»®Þ¾+"¶m§ÿðÃhºÇ¨}û¬Ü¢oâ×±qù¬×j¹b²Û¡Ü¥ËlýÇíjY(®Ç§u©²Æ zÚ~Ö¥·ª¹ë-¬zߺȨÊÂ+aº{.nÇ+·¢Ø^nr
Re: nesting queries??
You could use cfloop instead of the two inner cfoutput tags. HTH, Curt Curtis C. Layton Web Applications Developer Words In Progress, Inc. (410) 667-4986 [EMAIL PROTECTED] http://www.wordsinprogress.com Wu-Tang Alias: 100-Watt Warlock - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 10:43 AM Subject: nesting queries?? Hello all, I would like to know how you guys are nesting queries? i have to "Nest" multiple queries like cfoutput query="query1" cfoutput query="query2" --- cfoutput query="query3" -- /cfoutput /cfoutput /cfoutput How can i do this? Thanks inadvance Joe -- Archives: http://www.eGroups.com/list/cf-talk 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. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT (longish) Tango??
Dick did you check the price of this thing OMG!! $ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 7:28 AM To: [EMAIL PROTECTED] Subject: OT (longish) Tango?? The item (below) was included in a posting to another UG... ...the author is an employee of Pervasive (Developer of Tango) It's claims caught my attention. Anyone have any thoughts/experiences with Tango vs CF. Dick I am a senior software engineer for Pervasive Software (the maker of Tango). I work in the developer solutions group and I was responsible for writing the StoreFront demo that comes with package. I can tell you that Tango handles "all" of the above. As I write this, I am in the middle of a multi-developer/multi-site development effort for the largest project I've ever been involved with - all built completely around Tango. We are using SourceSafe for source control and Tango directly connects to this package from within the IDE (as well others) - key to survival here! Tango is very XML centric, the application files Tango generates are XML and Tango has a full set of XML/DOM interfaces - including the ability to retrieve and send XML over HTTP which allows things like WML (http://www.pervasive.com/news/pr/pr00apr05.html), SOAP, and other XML standards to be used. Tango is a GUI driven "action" based development environment that also includes an extensible "Mark-up language" as well as object oriented design capabilities (Tango class files) and the ability to directly use both COM and Java Beans - and even other extensibility features (DLL, command line, apple script). All this, and not mention that Tango is available on Window, UNIX, Linux and Mac platforms. We find many users preferring to develop on the Mac platform and deploy on NT or UNIX. Tango also has the ability, unlike CF, to separate the Tango server from the Web Server allowing a higher level of security to be implemented by placing a firewall between Tango and your web server - this is very critical when your database also needs to be behind the firewall yet doesn't use TCP/IP as a transport mechanism! Tango can connect to any data store that supports ODBC, and can also directly connect to Oracle (via OCI) and Pervasive.SQL. I can go on, but I don't need to - I can say what ever I want, only you can decide for yourself if the tool is right for you, so don't take my word for it, try it yourself: http://www.pervasive.com/tango/. Also, be sure to visit some sites built on Tango: http://www.theglobe.com http://www.colleges.com http://www.jokes.com http://componentzone.pervasive.com Thanks, Ritchie *** Thoughts on Cold Fusion *** In CF, there is no action based GUI like Tango's, it has only a page-based layout. The CF Editor is just Allaire's HomeSite product with CF tags thrown in. Although CF has project wizards, it still takes hours to days to do what Tango's Search Builder can do in four minutes. The graphical structure of Tango makes it much easier to use for big projects, and easy source control integration and Tango-based objects means that it is easy to split a project between many people. *** Key Tango Features *** - Intuitive, visual application development environment-the Tango Development Studio. - 26 built-in actions for implementing business logic. - Object extensibility with COM objects and JavaBeans. - Tango's own object model-robust reusability with Tango class files. - State-of-the-art personalization and content management. - Full XML implementation for accurate business-to-business communication. - Cross-platform development on Windows or Mac OS. - Multi-platform deployment on Windows NT/95/98, Solaris, Linux and Macintosh. - A robust Application Server that scales to meet increasing demands. - Team-based development features, such as source code control mechanisms for secure development. - Native Oracle support and bundled ODBC drivers for advanced database connectivity. - Pervasive.SQL 2000 database bundled with Windows, Solaris and Linux versions. - Online tutorials, demos and sample code to jumpstart development and cut the learning curve. *** Usability Highlights *** - Able to separate application logic from presentation logic. This makes it MUCH easier to modify someone else's' code. - Able to break down presentation code into smaller bite size pieces. - Search/Update/Delete Database Actions are very fast to setup and useful for integrating data rapidly into web applications. -Original Message- Sent: Thursday, April 06, 2000 2:23 AM Subject: RE: Popularity Cold Fusion Can you explain "Not good for big projects with different coder. No structure enough." One of the Key features that we are looking for in Cold Fusion is Distributed Development/Remote Development of applications, We need good project management capablities like Source Control Integration, Remote team development etc.Also,being a offshore software development company
RE: HELP Getting Identity Field Accurately
In referring to this article: http://www.defusion.com/articles/index.cfm?ArticleID=72 The method below of inserting a record is not a reliable way to get the corresponding record id in Cold Fusion: cftransaction cfquery name="my_insert" datasource="whatever" INSERT INTO myTable ... /cfquery cfquery name="get_id" datasource="whatever" SELECT MAX(myTable.ID) as new_id FROM myTable /cfquery /cftransaction Is this article correct in stating this method does not work, even if the code is wrapped in a CFTRANSACTION?? Yes, this method doesn't guarantee that you'll retrieve the correct identity column value. Here's why. Transactions use locking to prevent problems caused by concurrent requests. The database locks all the resources used by the transaction until that transaction has completed; if it fails, the database can then roll back the changes because it has locked those resources. Different databases implement locking differently. They have different scopes, so to speak. For example, some databases lock individual rows. Others lock not only the row being used, but other rows immediately before and/or after that row. Some lock entire tables! In a database that locks individual rows, the above transaction can't guarantee that you'll get the desired result. The first query inserts a record, and locks that row. No other rows are locked, so someone else inserts a row right after that. The second query then retrieves that row's identity, instead of the one you've inserted. The transaction still completes, but you get the wrong identity value. This could even happen in situations where you don't have row-level locking; that just makes it more likely. What is the best, scalable method for retrieving the identity field from the database, in the anticipation of heavy traffic? Use stored procedures, or failing that, triggers, to retrieve the identity column. Within a stored procedure, you can reference the @@IDENTITY variable (in SQL Server). Within a trigger, you can reference the specific record inserted using INSERTED. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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: Netscape! Hidden fields?
I actually saw a problem like this a year or so ago. This may sound silly, but try moving your hidden field down to the bottom of the form just before the submit button. I know this sounds ridiculous but I actually had this problem and this is what fixed it. Please let me know if this works At 11:15 AM 07/04/00 +0100, Chris Tazewell wrote: A couple of ideas... No closing form tag ? Closing tag, check! Hidden fields on a different layer ? Same layer, check! Tested it without setting target ? have to have a target because it's in a frame. but Ill have a crack at that to find out.. Ill post back if it changes anything. Quote the word POST - shouldn't make any difference, but worth a shot. Just tried it, check! What version netscape what platform ? currently 4.7 and prev versions. still no luck, thanks anyway. Taz -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Using CFX_Excel
Fred, Well, while it's true that I did not write and HTML file for this app, I have indeed written HTML files before, and I have to say, at least for me, writing the HMTL file is more work. That's just from my experience. I agree 100%+ with your observation to, "Do whatever works for you and gets the job done the way you want it." - There are always multiple ways to accomplish ever task. If we all did it the same, this earth would be rather boring would it. Thanks for responding though. Sometimes I think I've been black balled because I ask questions and nobody responds. But usually it's that I ask questions that nobody understands - LOL Have a good day 8-) Dave - Original Message - From: Fred Sanders [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 9:12 AM Subject: Re: Using CFX_Excel Your right I haven't used the tag. Depending on how you want the layout to look though, what can be easier or have less overhead than having CF output query results to an HTML file and simply saving it with *.xls on the end instead of *.htm or *.html You obviously didn't try it, either. :) Do whatever works for you and gets the job done the way you want it. Fred Sanders Galveston, Texas Having a bad day? Imagine this... You are in total seclusion from that hectic place called "The World". The soothing sound of a gentle waterfall fills the air with a cascading serenity. The water is clear. You can easily make out the face of the person you are holding underwater. Feeling better? - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 8:05 AM Subject: Re: Using CFX_Excel Hi Fred, I think we have solved the problem. First, I put the tag in a CFLOCK to prevent attempts at multi-threading. Then, there was another problem. I was not aware that our SysAdmin had made the https directory a little different structure than the http directory. There were some added characters in the path so here is what was happening. Excel was generating the spreadsheet (Sheet 1), but because it could not find the directory, it kept sitting there with the message "Do you want to save Sheet 1?". These were stacking up and I think this was what was really causing the problem. As for the CFX_Excel, I can't imagine that you've used the tag if you suggested I first save the file as HTML and doing all that formatting. CFX_Excel makes it Sooo much simpler. Dave = "Technology" is stuff that was invented after you were born. David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: Fred Sanders [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 2:57 PM Subject: Re: Using CFX_Excel Why bother with the tag. If your wanting to output nice looking spreadsheets and don't mind having to make painful amount nested tables you can have professional looking Excel97/2K spreadsheets by creating them as HTML files and saving them with an .xls extension before allowing the user to download them. I don't think it will work with anything below Excel 97 though, but the results in the end are worth the trouble your going to go through getting the layout perfect. Fred Sanders Galveston, TX Having a bad day? Imagine this... You are in total seclusion from that hectic place called "The World". The soothing sound of a gentle waterfall fills the air with a cascading serenity. The water is clear. You can easily make out the face of the person you are holding underwater. Feeling better? - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 11:11 AM Subject: Using CFX_Excel Anybody got a clue on this??? 8-) + Original Message Sent 7:47am ET + Good Morning, Are there any known issues surrounding the use of the CFX_Excel tags? I'm using it for several applications now, and I was wondering if there are any issues to be aware of - like, how many concurrent calls to Excel can it handle? The reason I've asked is that two days in a row, Excel on our server caused a "kernel32.dll" error and locked the server. Now, assuming that nothing is hosed up in Windows NT (we all know that never happens) and the Excel install is A-OK (which it seems to have been to the point the problems started) - what are the possibilities? I'm wondering if too much traffic on the tag/application combo might be the culprit? Also, can you do a CFLOCK to avoid this problem? Any thoughts? Thanks, Dave = "Technology" is stuff that was invented after you were born. David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524
Re: Using CFX_Excel
Yes, this works well for visual things. But it does not allow for SpreadSheet kinds of things, like macros, data validation, formulas, named ranges,etc,etc that many people want to have. Steve At 02:57 PM 4/6/2000 -0500, Fred Sanders wrote: Why bother with the tag. If your wanting to output nice looking spreadsheets and don't mind having to make painful amount nested tables you can have professional looking Excel97/2K spreadsheets by creating them as HTML files and saving them with an .xls extension before allowing the user to download them. I don't think it will work with anything below Excel 97 though, but the results in the end are worth the trouble your going to go through getting the layout perfect. Fred Sanders Galveston, TX Having a bad day? Imagine this... You are in total seclusion from that hectic place called "The World". The soothing sound of a gentle waterfall fills the air with a cascading serenity. The water is clear. You can easily make out the face of the person you are holding underwater. Feeling better? - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 11:11 AM Subject: Using CFX_Excel Anybody got a clue on this??? 8-) + Original Message Sent 7:47am ET + Good Morning, Are there any known issues surrounding the use of the CFX_Excel tags? I'm using it for several applications now, and I was wondering if there are any issues to be aware of - like, how many concurrent calls to Excel can it handle? The reason I've asked is that two days in a row, Excel on our server caused a "kernel32.dll" error and locked the server. Now, assuming that nothing is hosed up in Windows NT (we all know that never happens) and the Excel install is A-OK (which it seems to have been to the point the problems started) - what are the possibilities? I'm wondering if too much traffic on the tag/application combo might be the culprit? Also, can you do a CFLOCK to avoid this problem? Any thoughts? Thanks, Dave = "Technology" is stuff that was invented after you were born. David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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. -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT (longish) Tango??
CF CAN do this (and has been able to since 4.0 I think)! Tango also has the ability, unlike CF, to separate the Tango server from the Web Server allowing a higher level of security to be implemented by placing a firewall between Tango and your web server - this is very critical when your database also needs to be behind the firewall yet doesn't use TCP/IP as a transport mechanism! _ Chris Chambers ICQ: 40311211 AIM: CTC HOME VOX: 757-896-6393 FAX: 757-896-0774 _ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 10:28 AM To: [EMAIL PROTECTED] Subject: OT (longish) Tango?? The item (below) was included in a posting to another UG... ...the author is an employee of Pervasive (Developer of Tango) It's claims caught my attention. Anyone have any thoughts/experiences with Tango vs CF. Dick -- Archives: http://www.eGroups.com/list/cf-talk 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: Storage Fees
Gee it sort of depends. Is he planning to bring it over in a U-Haul and boxes or a hard drive. Are you just planning to put the drive on a shelf or is it 4GB of data that he wants to put on the Internet. My guess is no more than $200 a month plus what ever bandwidth he needs. Why $200? Because that is what some places charge for collocation services so it means he could locate an entire computer for $200 a month in a rack. Hope this helps. Good Luck, - Steve -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 5:50 PM To: [EMAIL PROTECTED] Subject: OT: Storage Fees A good customer of mine asked me today what I would charge to store 4GB of data? I'd appreciate any ideas of the going rate. best, paul -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: nesting queries??
Why do you have to nest them??? If you are looking to loop over the results do this... cfloop query="query1" cfoutput#query1_info#/cfoutput cfloop query="query2" ---cfoutput#query2_info#/cfoutput cfloop query="query3" --cfoutput#query3_info#/cfoutput /cfloop /cfloop /cfloop Ther probably is a more graceful way to handle what your trying to do - but witout more information on what that is... this is th only solution.. More info needed... James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 9:44 AM To: [EMAIL PROTECTED] Subject: nesting queries?? Hello all, I would like to know how you guys are nesting queries? i have to "Nest" multiple queries like cfoutput query="query1" cfoutput query="query2" --- cfoutput query="query3" -- /cfoutput /cfoutput /cfoutput How can i do this? Thanks inadvance Joe -- Archives: http://www.eGroups.com/list/cf-talk 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. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: NSlookup on email domains
Here's a freeware tag that does MX lookups: http://www.coolfusion.com/CFX_ODSMXLookup.htm HTH, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 === Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** === Check out inFusion Mail Server - the world's most configurable email server *** inFusion Authenticator for IIS is now released! (download from CoolFusion.com) *** http://www.teletrends.com and http://www.coolfusion.com Software and utilities for ColdFusion, iHTML, Website, NTMail Latest versions available from our web site (inFusion Authenticator version 2.0 for WebSite and NTMail is now released) - Original Message - From: Michel Gagnon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 10:51 AM Subject: NSlookup on email domains Hi! Is there a way that we could get Cold Fusion to do an NSLookup of an e-mail address domain? I was thinking of mabe using the WHOIS query from networksolutions. http://www.networksolutions.com/cgi-bin/whois/whois?STRING=yahoo.com Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: cfquery vs. cftransaction
Best way to do it would be in a Stored Procedure, wrapped in a SQL transaction. -J -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 7:56 AM To: Cf-Talk@Houseoffusion. Com Subject: cfquery vs. cftransaction Let me try this again please. Is this the best way to handle a 2 table insert ? cftransaction cfquery name="AddUser" datasource="sqlswidata" INSERT INTO Users (Users.UserID,Users.Password) VALUES ('#Form.UserID#', '#Form.Password#') /cfquery CFQUERY NAME="AddUserDetails" DATASOURCE="sqlswidata" INSERT INTO Users,UserDetails (UserDetails.FirstName,UserDetails.LastName,UserDetails.Company,UserDetails. Address1,Address2,UserDetails.City,UserDetails.State,UserDetails.Country,Use rDetails.Zip,UserDetails.PhoneHome,UserDetails.PhoneWork,UserDetails.PhoneFa x,UserDetails.Email) VALUES ('#Form.FirstName#', '#Form.LastName#', '#Form.Company#', '#Form.Address1#', '#Form.Address2#', '#Form.City#', '#Form.State#', '#Form.Country#', '#Form.Zip#', '#Form.PhoneHome#', '#Form.PhoneWork#', '#Form.PhoneFax#', '#Form.Email#') /CFQUERY /cftransaction Jim Taylor ICQ 47640391 -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: NSlookup on email domains
There's a tag to do this: cfx_odsmxlookup Forgot where I got it. best, paul At 11:51 AM 4/7/00 -0300, you wrote: Hi! Is there a way that we could get Cold Fusion to do an NSLookup of an e-mail address domain? I was thinking of mabe using the WHOIS query from networksolutions. http://www.networksolutions.com/cgi-bin/whois/whois?STRING=yahoo.com Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
ColdFusion and SQL
Is there a way in CF to alter a table and add/remove a column. Appreciate A.B. __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk 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: NSlookup on email domains
I believe there is a CFX tag that does nsloopup... All you would have to do is strip the characters before and including the @ symbol in the address. ___ Pete Freitag CFDEV.COM Cold Fusion Developer Resources http://www.cfdev.com/ -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 10:52 AM To: [EMAIL PROTECTED] Subject: NSlookup on email domains Hi! Is there a way that we could get Cold Fusion to do an NSLookup of an e-mail address domain? I was thinking of mabe using the WHOIS query from networksolutions. http://www.networksolutions.com/cgi-bin/whois/whois?STRING=yahoo.com Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Expiring Pages in IE
Thanks Mark. This does seem to work for Internet Explorer 5, but what can I do for Internet Explorer 3.0 people? As far as I can tell, its not working on that browser. So right now I'm doing these meta tags: META HTTP-EQUIV="expires" CONTENT="0" META HTTP-EQUIV="Pragma" CONTENT="no-cache" meta http-equiv="cache-control" content="no-cache" Eron -Original Message- From: Mark Jones [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 11:33 AM To: '[EMAIL PROTECTED]' Subject: RE: Expiring Pages in IE Try these lines of code meta http-equiv="pragma" content="nocache" meta http-equiv="cache-control" content="no-cache" -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Fri, 07 Apr 2000 15:44 To: Cf-Talk Subject:Expiring Pages in IE Can anyone tell me if there is a reliable way (such as a meta tag or CFHEADER) that will cause a page not to be cached by the typical 3.0 and above browsers. It needs to work in Netscape and IE. I want the pages to be reloaded automatically from the web server every time the user visits the page. Thanks, Eron -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: cfquery vs. cftransaction
On 4/7/00, Jim Taylor penned: Let me try this again please. Is this the best way to handle a 2 table insert ? The main reason to run a cftransaction is if the results from one query are going effect the entry into another. For instance: 1. Someone places and order and the order is written to the orders table with an insert query in and the order id is incremented in an autonumber field. 2. Now you need to write the individual items purchased into a line items table. You pick up the order id from the orders table doing a max(order_id) in your select query. By placing the two queries inside a cftransaction tag, it will assure that someone else doesn't insert an order in the instant between when you insert yours and pick up the max(order_id). Otherwise, you would place their order number into the line items record of the previous order. If you do it the other way, checking the max(order_id) and then adding 1 and entering the order id into the orders table (in other words, incrementing yourself as opposed to an autonumber field) then it wouldn't be necessary as you'd pass that same number into the line items table also. HTH Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk 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: NSlookup on email domains
CFX_NSLookup http://www.desertraven.com/codemodules.php It's a Java CFX, so you will need CF 4.5 or CFX_J to run it. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 07:52 To: [EMAIL PROTECTED] Subject: NSlookup on email domains Hi! Is there a way that we could get Cold Fusion to do an NSLookup of an e-mail address domain? I was thinking of mabe using the WHOIS query from networksolutions. http://www.networksolutions.com/cgi-bin/whois/whois?STRING=yahoo.com Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
CF Developer in utah needed
We are looking for a freelance developer or a CF dev house to help out on a project. If you are interested, Please contact me. Thanks George Loch Stephen Hales Creative -- Archives: http://www.eGroups.com/list/cf-talk 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: CFLOOP list=Query.Value ??
On 4/7/00, Todd Ashworth penned: The list="Query.Value" sounds good in theory, but I'm sure I'm doing it way wrong. Any suggestions? Try using the good ol' pound symbols: CFLOOP index="varLoopKidIDFromParentRelationships" list="#qryGetKidsFromParentsID.emer_ref#" delimiters="," Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk 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.
Cold Fusion - ASP Together
I am attempting to send information to an ASP page in the form of a [httpparam]. I know absolutely nothing about ASP and am still learning Cold Fusion. I am placing a piece of my code below. Can anyone tell me if there is anything different I have to do to send this info to an ASP page? cfhttp method=post url="https://secure.internetclearing.com/iccnet12/userinfo.asp" resolveurl="yes" cfhttpparam type=formfield value="#Logon#" name="Logon" /cfhttp 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFENCODE???
From: Bill Killillay [EMAIL PROTECTED] Ok, is there any known bugs with CFENCODE.exe which used to be CFCRYPT.exe in CF 4. I have been trying to make it work for an hour now and no luck. I even tried copying the exe file into the dir of the files I want to encrypt and ran it from there, still no luck. I know my syntax is correct, at least according to the help dialog that pops up. This is a sample of what I am type in to try and run it. cfencode myfile.cfm myoutfile.cfm /q /h "A disclaimer message" Hmmm.. this is a RTFM. You're missing/v "2" at the end of your cli string. -- Archives: http://www.eGroups.com/list/cf-talk 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: Annoying CF Studio 4.5a Interface problems
Nevermind. It's always nice when Allaire updates the forums to indicate that a new release is out. Chris -Original Message- From: William James [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 1:07 PM To: [EMAIL PROTECTED] Subject: Re: Annoying CF Studio 4.5a Interface problems Forgot to mention, this goes for Studio and Server. It's been fixed since 4.5.1 RC1, but now the full versions are available from the Allaire site, so it soundsl ike today is upgrade day for you ;) - Original Message - From: "Kent Runyan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 3:05 PM Subject: RE: Annoying CF Studio 4.5a Interface problems I have another on for you related to windows 2000 Pro. With 4.5a I can't connect to my existing projects and I can't create new ones. When I navigate to where I want the projects to be, it seems to lose the path and only lists the current directory and says it can't find the RDS server. Studio 4.0.1 works fine on the same machine. -Original Message- From: Mike Hughes [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 1:02 PM To: Reuben King Subject: Re: Annoying CF Studio 4.5a Interface problems Hello Reuben, Thursday, Thursday, April 06, 2000, you wrote to me: RK I have Win 2000 on a Compaq Armada 1750.. I just recieved a Compaq Presario 1800 with Windows 2000 RK In CF Studio 4.5a (also tried 4.5.1rc2) Currently using 4.5a What mouse are you using? Touch pad? I use a Logitech Mouse Man Plus with a wheel, I do not use the Touch Pad RK Double clicking on a word doesn't select the word like normal -- it selects everything to RK the left of the cursor and to the beginning of the word. Always has worked for me this way (I like it), from Studio 3 I believe - but I know 4 work like this RK The mouse wheel doesn't work inside CF Studio.. Other such RK annoying behavior. My logitech works great in Studio RK The mouse works great in every other app on the system, its just CF RK Studio that acts like this. Maybe look at the driver for the mouse RK These may seem like minor whines but they can become quite irritating RK when working full time inside CF Studio. I know I would hate it. Thanks, Mike Hughes Web Applications Developer mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
stupid cfx tag question
If I need to use a CFX tag on a site hosted by a remote CF ISP, is the only way to use such a tag to have it registered directly in the administrator? Is there any other way to use them? (ie, if they say "we don't do custom tags for you" then am I outta luck?) c -- Chris Lott [EMAIL PROTECTED], Technical Manager p907.474.5122 | f907.474.5402 | PGP Key ID: 0x8687E87E -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT - SQL 7 to Oracle Data Migration
I haven't worked with SQL 7 yet, by our dba says some of the tools that come with SQL 7 can work with other databases, including Oracle. Might be worth investigating. -Original Message- From: Scott Rowe [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 2:34 PM To: CF-Talk Subject: OT - SQL 7 to Oracle Data Migration I'm looking for an easy way to migrate our sql server 7 data to Oracle 8i. Also, I'd love to have something that can connect and visually show the data like SQL 7 can and even possibly create the code to automatically create this database. Is there anything that can do that out there? Scott -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: CFLOOP list=Query.Value ??
Actually, ValuList() worked. (thanks Dave), so I think you are both right, but if anyone has a better, more streamlined solution than the hack job I'm doing, I would love to hear it. Todd Ashworth -- Saber Corporation Web Application Development www.sabersite.com (803) 327-0137 [111] (803) 328-2868 (fax) - Original Message - From: "Sean Daniels" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 2:38 PM Subject: RE: CFLOOP list="Query.Value" ?? I may be wrong on this, but my interpretation of his situation was that the field contents *was* in fact a comma delim list. Presumably he would be selecting only one row at a time so the valuelist function wouldn't do anything, right? It's not the ideal, normalized situation, but I think all he's missing are the #'s. - Sean Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 -- Archives: http://www.eGroups.com/list/cf-talk 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: CFLOOP list=Query.Value ??
I may be wrong on this, but my interpretation of his situation was that the field contents *was* in fact a comma delim list. Presumably he would be selecting only one row at a time so the valuelist function wouldn't do anything, right? That is certainly a possibility. It wouldn't be the first time I've misunderstood something. It's not the ideal, normalized situation, but I think all he's missing are the #'s. I guess I just assume that everyone normalizes their tables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT PCAnywhere on Port???
Looks encrypted to me. What are you using? Steve -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 11:47 AM To: [EMAIL PROTECTED] Subject: RE: OT PCAnywhere on Port??? Are my messages not getting through? Or are they encrypted? ·!÷¬Ûiÿü0Áá«¢êlr¿+-ýÇíjY¡Iì¹»®Þ¾+"¶m§ÿðÃhºÇ¨}û¬Ü¢oâ×±qù¬×j°Ë nX¶Ï~Özwëj¡ÇjYz«²ØºÇ}û¢l¶²ær¸z) æ -- Archives: http://www.eGroups.com/list/cf-talk 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: CFLoop w/Insert Into??
You are doing multiple inserts so you should do multiple queries... Try something like: cfset listregion = "Africa,Africa,Africa" cfset Cats = "5, 10, 15" cfset listmonth = "May, May, May" cfloop index="loopinx" from="1" to="#listlen(listregion)#" cfquery datasource="GOE" INSERT INTO Testgoe(Region, ExpenseID); VALUES ('#listgetat(listregion,loopinx)#', #listgetat(cats,loopinx)#) /cfquery /cfloop HTH, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 === Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** === Check out inFusion Mail Server - the world's most configurable email server *** inFusion Authenticator for IIS is now released! (download from CoolFusion.com) *** http://www.teletrends.com and http://www.coolfusion.com Software and utilities for ColdFusion, iHTML, Website, NTMail Latest versions available from our web site (inFusion Authenticator version 2.0 for WebSite and NTMail is now released) - Original Message - From: Harper, Laura [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 3:21 PM Subject: CFLoop w/Insert Into?? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFA0C6.7E6C9FC0 Content-Type: text/plain; charset="iso-8859-1" Hello everyone, I have a looping problem that I can't quite get! I have 5 lists as follows: region = "Africa, Africa, Africa" ID = "5, 10, 15" month = "May, May, May" proj_amt = "120, 200, 4000" budget_amt = "200, 230, 5000" This data is coming from user input from a previous page and then gets inserted into a DB. So, each record will be region, ID, month, proj_amt, budget_amt. There is logic as to why region and month have the same elements. To make it easier I'm showing my code for the first three lists: cfset listregion = "Africa,Africa,Africa" cfset Cats = "5, 10, 15" cfset listmonth = "May, May, May" cfquery name="Insert_Budget" datasource="GOE" cfloop index="a" list="#variables.listregion#" cfloop index="b" list="#variables.Cats#" INSERT INTO Testgoe(Region, ExpenseID); VALUES ('#Evaluate('a')#', #Evaluate(b)#) /cfloop /cfloop /cfquery And the erroe I get is: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. SQL = "INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 5) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 10) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 15) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 5) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 10) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 15) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 5) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 10) INSERT INTO Testgoe(Region, ExpenseID); VALUES ('Africa', 15)" Data Source = "GOE" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (29:1) to (29:47). And why is it looping twice? I've tried millions of variations. cf-tThis is driving me nuts!! But I'm sure you've heard that before. Your help is greatly appreciated. Laura --_=_NextPart_001_01BFA0C6.7E6C9FC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75" TITLECFLoop w/Insert Into??/TITLE /HEAD BODY PFONT COLOR=3D"#80" FACE=3D"Arial Narrow"Hello everyone,/FONT /P PFONT COLOR=3D"#80" FACE=3D"Arial Narrow"I have a looping = problem that I can't quite get!nbsp; /FONT /P PFONT COLOR=3D"#80" FACE=3D"Arial Narrow"I have 5 lists as = follows:/FONT BRFONT COLOR=3D"#80" FACE=3D"Arial Narrow"region =3D = quot;Africa, Africa, Africaquot;/FONT BRFONT COLOR=3D"#80" FACE=3D"Arial Narrow"ID =3D quot;5, 10, = 15quot;/FONT BRFONT COLOR=3D"#80" FACE=3D"Arial Narrow"month =3D quot;May, = May, Mayquot;/FONT BRFONT COLOR=3D"#80" FACE=3D"Arial Narrow"proj_amt =3D = quot;120, 200, 4000quot;/FONT BRFONT COLOR=3D"#80" FACE=3D"Arial Narrow"budget_amt =3D = quot;200, 230, 5000quot; /FONT /P PFONT COLOR=3D"#80" FACE=3D"Arial Narrow"This data is coming = from user input from a previous page and then gets inserted into a = DB.nbsp; So, each record will be region, ID, month, proj_amt, = budget_amt.nbsp; /FONT/P PFONT COLOR=3D"#80" FACE=3D"Arial Narrow"There is logic as to = why region and month have the same elements./FONT /P
No Subject
Fellow CF scriptors -- I am using the following code to "pour" search query results into a three column layout. I can't for the life of me figure out how to deliver a "no matching items found" when there are no matching items found. I've tried IFs and SWITCHES and others, but it's no use. What I am missing? TIA, David -- !--RowBreak is number of columns per row--- CFSET RowBreak = 3 TABLE BORDER=0 CELLPADDING=5 CELLSPACING=0 WIDTH="98%" TR CFOUTPUT QUERY = "results" CFSET ModValue = results.CurrentRow MOD RowBreak TD WIDTH="25%" ALIGN=center A HREF="stone.cfm?ID=#ID#"img src = "#smallimage#" border = "0"/ABR A HREF="stone.cfm?ID=#ID#"#name#/ABR CFIF #ceramicseries# IS "NOT CERAMIC" CFELSE#ceramicseries#BR /CFIF CFIF #material# IS "Ceramic Tiles" CFELSE #material#BR /CFIF #finish# /TD CFIF ModValue IS 0 /TRTR CFELSE /CFIF /CFOUTPUT /TR /TABLE David Ryan - Minister of Information and Culture CRUMBLING EMPIRE PRODUCTIONS 134 W.26th St. 12th Floor New York, NY 10001 (212) 247-0296 -- Archives: http://www.eGroups.com/list/cf-talk 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: Cold Fusion - ASP Together
i don't think he would want to pass a password as a URL parameter. the CFHTTP tag looks fine to me. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Eddie Shipman [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 3:50 PM To: [EMAIL PROTECTED] Subject: RE: Cold Fusion - ASP Together Why not pass it as a URL parameter and rewrite your ASP to parse the URL? cfhttp method=post url="https://secure.internetclearing.com/iccnet12/userinfo.asp?logon=#Logon# " resolveurl="yes" /cfhttp I am attempting to send information to an ASP page in the form of a [httpparam]. I know absolutely nothing about ASP and am still learning Cold Fusion. I am placing a piece of my code below. Can anyone tell me if there is anything different I have to do to send this info to an ASP page? cfhttp method=post url="https://secure.internetclearing.com/iccnet12/userinfo.asp" resolveurl="yes" cfhttpparam type=formfield value="#Logon#" name="Logon" /cfhttp This message has been scanned for viruses using Sophos. The opinions stated in this message do not necessarily represent the opinions of e-MDs, its management or staff. -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: CFLoop w/Insert Into??
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFA0CF.9CA2C290 Content-Type: text/plain; charset="iso-8859-1" Howie, I never would have thought to use the listgetat function. Thank you so much!! Laura --Original Message Date: Fri, 7 Apr 2000 15:59:37 -0400 From: "Howie Hamlin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: CFLoop w/Insert Into?? Message-ID: 01fa01bfa0cb$d0be4940$[EMAIL PROTECTED] You are doing multiple inserts so you should do multiple queries... Try something like: cfset listregion = "Africa,Africa,Africa" cfset Cats = "5, 10, 15" cfset listmonth = "May, May, May" cfloop index="loopinx" from="1" to="#listlen(listregion)#" cfquery datasource="GOE" INSERT INTO Testgoe(Region, ExpenseID); VALUES ('#listgetat(listregion,loopinx)#', #listgetat(cats,loopinx)#) /cfquery /cfloop Laura --_=_NextPart_001_01BFA0CF.9CA2C290 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2651.75" TITLERe: CFLoop w/Insert Into??/TITLE /HEAD BODY PFONT COLOR="#80" FACE="Arial Narrow"Howie,/FONT /P PFONT COLOR="#80" FACE="Arial Narrow"I never would have thought to use the listgetat function.nbsp; Thank you so much!!/FONT /P PFONT COLOR="#80" FACE="Arial Narrow"Laura/FONT /P PFONT COLOR="#80" FACE="Arial Narrow"--Original Message/FONT BRFONT SIZE=2 FACE="Courier New"Date: Fri, 7 Apr 2000 15:59:37 -0400/FONT BRFONT SIZE=2 FACE="Courier New"From: quot;Howie Hamlinquot; lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=2 FACE="Courier New"To: lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=2 FACE="Courier New"Subject: Re: CFLoop w/Insert Into??/FONT BRFONT SIZE=2 FACE="Courier New"Message-ID: lt;01fa01bfa0cb$d0be4940$[EMAIL PROTECTED]gt;/FONT /P PFONT SIZE=2 FACE="Courier New"You are doing multiple inserts so you should do multiple queries.../FONT /P PFONT SIZE=2 FACE="Courier New"Try something like:/FONT /P PFONT SIZE=2 FACE="Courier New"lt;cfset listregion = quot;Africa,Africa,Africaquot;gt;/FONT BRFONT SIZE=2 FACE="Courier New"lt;cfset Cats = quot;5, 10, 15quot;gt;/FONT BRFONT SIZE=2 FACE="Courier New"lt;cfset listmonth = quot;May, May, Mayquot;gt;/FONT /P PFONT SIZE=2 FACE="Courier New"lt;cfloop index=quot;loopinxquot; from=quot;1quot; to=quot;#listlen(listregion)#quot;gt;/FONT BRFONT SIZE=2 FACE="Courier New"nbsp;nbsp; lt;cfquerynbsp; datasource=quot;GOEquot;gt;/FONT BRFONT SIZE=2 FACE="Courier New"nbsp;nbsp;nbsp;nbsp; INSERT INTO Testgoe(Region, ExpenseID);/FONT BRFONT SIZE=2 FACE="Courier New"nbsp;nbsp;nbsp;nbsp; VALUES ('#listgetat(listregion,loopinx)#', #listgetat(cats,loopinx)#)/FONT BRFONT SIZE=2 FACE="Courier New"nbsp;nbsp; lt;/cfquerygt;/FONT BRFONT SIZE=2 FACE="Courier New"lt;/cfloopgt;/FONT /P BR PBIFONT COLOR="#800080" SIZE=2 FACE="Arial"Laura/FONT/I/BI/I /P /BODY /HTML --_=_NextPart_001_01BFA0CF.9CA2C290-- -- Archives: http://www.eGroups.com/list/cf-talk 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: Most efficeint validation
This can be optimized as ... CFIF NOT IsDefined("ATTRIBUTES.Request_Time") OR NOT Trim(ATTRIBUTES.Request_Time) ... Request_Time is not available CFELSE ... Request_Time is available /CFIF Regards, Steve -Original Message- From: Ben Lowndes [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 2:24 PM To: [EMAIL PROTECTED] Subject: Most efficeint validation Hello, I've just been trying to figure out the most efficent way to check for a passed (form or url) variables pesence and value. The code I've been using is: CFIF (IsDefined("ATTRIBUTES.Request_time") IS "No") OR (Trim(ATTRIBUTES.Request_time) IS "") Request_time is not defined CFELSE Request_time is defined /CFIF But is this the best way, it must be a common problem. I also thought about using : CFPARAM NAME="ATTRIBUTES.Request_Time" DEFAULT="0" CFIF Trim(RequestTime) IS "0" Request_time is not defined CFELSE Request_time is defined /CFIF but that doesn't work as it doesn't apply the value 0 if Request_time is passed but not defined... So is the first method the best? Thanks Ben -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: CFLOOP list=Query.Value ??
It's not the ideal, normalized situation, but I think all he's missing are the #'s. I guess I just assume that everyone normalizes their tables. Please explain how I could normalize this table? Database designs is not my forte, but unfortunately, I have the joy of learning that hard way. What I have is a list of relationships. For each contact in my database, I have a field in the contact table that contains the comma delimited list of numbers. These numbers are the primary key values for other contacts in the contact table that this person has set up a relationship to. Is this not the best way to handle this? Todd Ashworth -- Archives: http://www.eGroups.com/list/cf-talk 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: Cold Fusion - ASP Together
OOPS, I didn't really thin about that one. Hey, it's Friday so give me a break, I'm thinkin' 'bout the weekend... i don't think he would want to pass a password as a URL parameter. the CFHTTP tag looks fine to me. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Eddie Shipman [mailto:[EMAIL PROTECTED]] Why not pass it as a URL parameter and rewrite your ASP to parse the URL? cfhttp method=post url="https://secure.internetclearing.com/iccnet12/userinfo.asp? logon=#Logon# " resolveurl="yes" /cfhttp This message has been scanned for viruses using Sophos. The opinions stated in this message do not necessarily represent the opinions of e-MDs, its management or staff. -- Archives: http://www.eGroups.com/list/cf-talk 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:
do a check before outputting the data: cfif results.recordcount your current code cfelse Sorry - no records found matching x /cfif - Original Message - From: "David Ryan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 4:11 PM Fellow CF scriptors -- I am using the following code to "pour" search query results into a three column layout. I can't for the life of me figure out how to deliver a "no matching items found" when there are no matching items found. I've tried IFs and SWITCHES and others, but it's no use. What I am missing? TIA, David -- !--RowBreak is number of columns per row--- CFSET RowBreak = 3 TABLE BORDER=0 CELLPADDING=5 CELLSPACING=0 WIDTH="98%" TR CFOUTPUT QUERY = "results" CFSET ModValue = results.CurrentRow MOD RowBreak TD WIDTH="25%" ALIGN=center A HREF="stone.cfm?ID=#ID#"img src = "#smallimage#" border = "0"/ABR A HREF="stone.cfm?ID=#ID#"#name#/ABR CFIF #ceramicseries# IS "NOT CERAMIC" CFELSE#ceramicseries#BR /CFIF CFIF #material# IS "Ceramic Tiles" CFELSE #material#BR /CFIF #finish# /TD CFIF ModValue IS 0 /TRTR CFELSE /CFIF /CFOUTPUT /TR /TABLE David Ryan - Minister of Information and Culture CRUMBLING EMPIRE PRODUCTIONS 134 W.26th St. 12th Floor New York, NY 10001 (212) 247-0296 -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: stupid cfx tag question
If they won't install it, you're outta luck. Sorry. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 12:44 To: [EMAIL PROTECTED] Subject: stupid cfx tag question If I need to use a CFX tag on a site hosted by a remote CF ISP, is the only way to use such a tag to have it registered directly in the administrator? Is there any other way to use them? (ie, if they say "we don't do custom tags for you" then am I outta luck?) c -- Chris Lott [EMAIL PROTECTED], Technical Manager p907.474.5122 | f907.474.5402 | PGP Key ID: 0x8687E87E -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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:
David ahhh, your crafty ploy of posting without a subject has sparked my curiosity and forced me to read your message! ;) If you are concerned about your query not returning any records - resulting in an empty table - do something like the following: cfif results.recordcount GT 0 ---do all your table stuff here --- cfelse Sorry, your search returned no records...etc.etc. /cfif A couple extra notes - added at no extra cost to the consumer: -You don't need #'s in your CFIF's Example: cfif CeramicSeries IS "NOT CERAMIC"... -You can use NOT within a CFIF to reverse the test and avoid a CFELSE Example: cfif NOT material IS "Ceramic Tiles" #material# /cfif hth, Kevin At 04:11 PM 4/7/00 -0400, you wrote: Fellow CF scriptors -- I am using the following code to "pour" search query results into a three column layout. I can't for the life of me figure out how to deliver a "no matching items found" when there are no matching items found. I've tried IFs and SWITCHES and others, but it's no use. What I am missing? TIA, David snip David Ryan - Minister of Information and Culture CRUMBLING EMPIRE PRODUCTIONS 134 W.26th St. 12th Floor New York, NY 10001 (212) 247-0296 -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.eGroups.com/list/cf-talk 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:
Have you tried: CFIF results.RecordCount GT 0 Blah blah - 3 column table...yes I actually found information CFELSE Sorry, I didn't find anything.wow /CFIF Hopefully that will work for you. Scott - Original Message - From: David Ryan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 4:11 PM Fellow CF scriptors -- I am using the following code to "pour" search query results into a three column layout. I can't for the life of me figure out how to deliver a "no matching items found" when there are no matching items found. I've tried IFs and SWITCHES and others, but it's no use. What I am missing? TIA, David -- !--RowBreak is number of columns per row--- CFSET RowBreak = 3 TABLE BORDER=0 CELLPADDING=5 CELLSPACING=0 WIDTH="98%" TR CFOUTPUT QUERY = "results" CFSET ModValue = results.CurrentRow MOD RowBreak TD WIDTH="25%" ALIGN=center A HREF="stone.cfm?ID=#ID#"img src = "#smallimage#" border = "0"/ABR A HREF="stone.cfm?ID=#ID#"#name#/ABR CFIF #ceramicseries# IS "NOT CERAMIC" CFELSE#ceramicseries#BR /CFIF CFIF #material# IS "Ceramic Tiles" CFELSE #material#BR /CFIF #finish# /TD CFIF ModValue IS 0 /TRTR CFELSE /CFIF /CFOUTPUT /TR /TABLE David Ryan - Minister of Information and Culture CRUMBLING EMPIRE PRODUCTIONS 134 W.26th St. 12th Floor New York, NY 10001 (212) 247-0296 -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: stupid cfx tag question
If I need to use a CFX tag on a site hosted by a remote CF ISP, is the only way to use such a tag to have it registered directly in the administrator? Is there any other way to use them? (ie, if they say "we don't do custom tags for you" then am I outta luck?) If you put the custom tag in the same directory as the page that references it, they should work just fine for you and you might just get away with it ;) I don't know if it works on _all_ custom tags, but I use this technique with 2 tags on one of my sites, because it's easier than fooling with having someone install them. Todd Ashworth - Saber Corporation Web Application Development www.sabersite.com (803) 327-0137 [111] (803) 328-2868 (fax) -- Archives: http://www.eGroups.com/list/cf-talk 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.
getting fields of a table(sql)
Hello All, Is there a way/sql statement that would get me all the fields in the table? and store it in a variable ? something like cfset x=Select Field_Names from Table_Name so now x will have the values of the fields in the table. Appretiate all comments, thanks inadvance! Joe This message has been scanned for viruses using Sophos. The opinions stated in this message do not necessarily represent the opinions of e-MDs, its management or staff. -- Archives: http://www.eGroups.com/list/cf-talk 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. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT PCAnywhere on Port???
On 7 Apr 2000, at 15:51, Steve Bernard wrote: Looks encrypted to me. What are you using? Steve -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 11:47 AM To: [EMAIL PROTECTED] Subject: RE: OT PCAnywhere on Port??? Are my messages not getting through? Or are they encrypted? ·!÷¬Ûiÿü0Áá«¢êlr¿+-ýÇíjY ¡Iì¹»®Þ¾+"¶m§ÿðÃhºÇ¨}û¬Ü¢oâ×±qù¬×j°Ë nX¶Ï~Özwëj¡ÇjYz«²ØºÇ}û¢l¶²ær¸z) æ I had been using outlook 2000, but now I've switched over to Pegasus mail to see if it will handle what I need better. Marcus -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: getting fields of a table(sql)
Joe, SELECT syscolumns.name FROMsyscolumns INNER JOIN sysobjects ON sysobjects.id = syscolumns.id WHERE sysobjects.name = "Your_Table_Name" HTH, Sean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 5:05 PM To: [EMAIL PROTECTED] Subject: getting fields of a table(sql) Hello All, Is there a way/sql statement that would get me all the fields in the table? and store it in a variable ? -- Archives: http://www.eGroups.com/list/cf-talk 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: stupid cfx tag question
This only works for CF_ custom tags, not for CFX_ Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 15:02 To: [EMAIL PROTECTED] Subject: Re: stupid cfx tag question If I need to use a CFX tag on a site hosted by a remote CF ISP, is the only way to use such a tag to have it registered directly in the administrator? Is there any other way to use them? (ie, if they say "we don't do custom tags for you" then am I outta luck?) If you put the custom tag in the same directory as the page that references it, they should work just fine for you and you might just get away with it ;) I don't know if it works on _all_ custom tags, but I use this technique with 2 tags on one of my sites, because it's easier than fooling with having someone install them. Todd Ashworth - Saber Corporation Web Application Development www.sabersite.com (803) 327-0137 [111] (803) 328-2868 (fax) -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: getting fields of a table(sql)
Much easier Joe after you query, call query variable 'queryname.ComlumnList'. Will give you a comma delimited list of the queries column names -J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 2:05 PM To: [EMAIL PROTECTED] Subject: getting fields of a table(sql) Hello All, Is there a way/sql statement that would get me all the fields in the table? and store it in a variable ? something like cfset x=Select Field_Names from Table_Name so now x will have the values of the fields in the table. Appretiate all comments, thanks inadvance! Joe This message has been scanned for viruses using Sophos. The opinions stated in this message do not necessarily represent the opinions of e-MDs, its management or staff. -- Archives: http://www.eGroups.com/list/cf-talk 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. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: stupid cfx tag question
ahh .. knew it was too good to be true for all of them ;) - Original Message - From: Mike Sheldon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 5:13 PM Subject: RE: stupid cfx tag question This only works for CF_ custom tags, not for CFX_ Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -- Archives: http://www.eGroups.com/list/cf-talk 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.
Select lists, need options
I've searched Allaire's custom tag gallery and can't seem to find a tag to do this... I am looking for a control tag similar to CF_Select, but as multiple items are selected in the list, I want a text item on the same page to reflect the currently selected items. OR if anyone knows how to get or simulate a modal dialog with a selectable list in it, I would appreciate it. I found a DHTML way to do this, but it was WAY too complicated, didn't work x-platform, and butt-ugly on top of everything else. Rob -- Archives: http://www.eGroups.com/list/cf-talk 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.
4.01 and 2000
Hi gang, Was wondering if anyone knew if 4.01 would work on W2K Advanced Server? If it can, has anyone tried it out? Anything to watch out for? Thanks, Greg -- Archives: http://www.eGroups.com/list/cf-talk 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.
Semi OT: Passing JavaScript variables to other CF/JS templates
I am trying to find a way to pass a JavaScript variable into a that would use it in another JavaScript code. I am using a JavaScript/CF page that, when the user clicks a button, a JavaScript popup window appears that has a CF calendar in it (thanks to Selena). Users then click on a date and that is pushed back into the main page, populating the date field. I have several fields on the page that use dates and I want this to work for the users. The tag Selena wrote is hard coded for a particular field. I want to pass the field name of the date field the user is currently selecting INTO the CF popup calendar template. That way, when the User clicks on a date, the code passes it back into the right date field. This would keep me from 10 different hard coded calendars templates. Any ideas or even good resources that might do this. Thanks. PS - Anyone interested in the code please contact me off list. Gary McNeel, Jr. Project Manager - DAC-Net, Research Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein -- Archives: http://www.eGroups.com/list/cf-talk 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.
AOL Server and CF
Anyone have any experience with this server? Good or bad. Know issues. Thanks. Gary McNeel, Jr. Project Manager - DAC-Net, Research Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein -- Archives: http://www.eGroups.com/list/cf-talk 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: Session Variables and Time Outs
..Sorry my eariler post was so messy (HTML formatted)... Hello everyone, I am posting to this list for the first time. I have a question concerning Session, Client, and Application Variables. I was wondering if anyone knows a place where I can find a DEFINITIVE source on the useage of these CF Elements. What controls them, the application file, or the Server, what their scope is, and their true lifecycle in an application (mine seem to exist after the session is over and I restart it again.) I am developing a site that depends greatly on session variables in particular and I seem to get a lot of unexpected activity from the usage of these session variables. (exist when they shouldn't, die unexpectedly, etc.) Also, I would like, instead of my users getting an ugly, indecipherable CF message, to get a clean (I'm sorry, but you're received an unexpected error, and have the CF system send the ugly CF code back to me in an email so I can proactively respond to the problem.) Thanks in advance for your help, Gregory L. Weiss Web Development Project Leader Trapezoid, Inc. 4107 Laguna Street Coral Gables, Florida 33146 (305) 442-8060 x230 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.01 and 2000
Was wondering if anyone knew if 4.01 would work on W2K Advanced Server? If it can, has anyone tried it out? Anything to watch out for? It worked fine on my laptop, although my laptop doesn't get that much traffic. It will break MDAC 2.5, which can be fixed by "upgrading" your Win2K install after you install CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT (longish) Tango??
Since my beginner development with web base data base connectivity started on the Mac platform years ago with File Maker Pro and File Maker Pro Web Companion. Tango was there. It was my understanding then, Tango gave you the ability to do things File Maker Pro an/or with Web Companion, that Web Companion couldn't do by itself. From the Mac developer standpoint at the time it was the leader in data base / web connectivity. I moved to CF because of greater base usage of the Windows OS platform and the availability of work. I didn't know that they had Ideas of ported it over to other OS platforms. If you are a ripened CF developer, Tango will be a breeze to pick up. And now the Mac OS base is growing like a wild fire. Consider this; Apple has take the Apache Server, BSD Unix and Java and wrapped the Apple GUI functionality around the advanced Mach Kernel in Mac OS X Server. Add the Darwin video streaming capability and QuickTime 4 the standard in nonlinear editing format. (Media 100, Premiere, Final Cut Pro and Avid nonlinear editing systems are based on this format, just to name a few. Also, Apple's huge financial investment in Akami. Akami's rapidly growing network infrastructure of QuickTime streaming severs all over the US and the world. Oracle has developed a QuickTime serving data base that will be released soon. With bandwidth growing from the likes of DSL cable modems. Nobody can't stop the telecommunication companies ATT, Sprint, Time Warner/ / AOL from buying up ISP's and TV cable providers. I can safely assume that Tango isn't going anywhere. Tango was the industry standard for the Mac OS platform. Apple is selling more computers now, then ever in the history of Apple Computer. Mac OS isn't going anywhere. If you can take your skills that you have learned with CF, spend a couple of weeks getting familiar with Tango. It will only expand you as a developer, your value in the work force and marketability within this industry. I do not work for Apple or Tango. KM -- Archives: http://www.eGroups.com/list/cf-talk 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: Semi OT: Passing JavaScript variables to other CF/JS templates
Selene Bainum has a nifty popup calendar at: http://www.webtricks.com/SourceCode/ -Original Message- From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 5:45 PM To: Cf-Talk Subject: Semi OT: Passing JavaScript variables to other CF/JS templates I am trying to find a way to pass a JavaScript variable into a that would use it in another JavaScript code. I am using a JavaScript/CF page that, when the user clicks a button, a JavaScript popup window appears that has a CF calendar in it (thanks to Selena). Users then click on a date and that is pushed back into the main page, populating the date field. I have several fields on the page that use dates and I want this to work for the users. The tag Selena wrote is hard coded for a particular field. I want to pass the field name of the date field the user is currently selecting INTO the CF popup calendar template. That way, when the User clicks on a date, the code passes it back into the right date field. This would keep me from 10 different hard coded calendars templates. Any ideas or even good resources that might do this. Thanks. PS - Anyone interested in the code please contact me off list. Gary McNeel, Jr. Project Manager - DAC-Net, Research Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
CF, MSSQL and Oracle
I am trying to transfer the queries and stored procedures from MSSQL to Oracle. Is there a utility in CF that will make it easy? Appreciate. AB __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk 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: Semi OT: Passing JavaScript variables to other CF/JS templates
Oops. I finally figured it out. Sorry for the bother folks. -Gary -Original Message- From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 4:45 PM To: Cf-Talk Subject: Semi OT: Passing JavaScript variables to other CF/JS templates I am trying to find a way to pass a JavaScript variable into a that would use it in another JavaScript code. I am using a JavaScript/CF page that, when the user clicks a button, a JavaScript popup window appears that has a CF calendar in it (thanks to Selena). Users then click on a date and that is pushed back into the main page, populating the date field. I have several fields on the page that use dates and I want this to work for the users. The tag Selena wrote is hard coded for a particular field. I want to pass the field name of the date field the user is currently selecting INTO the CF popup calendar template. That way, when the User clicks on a date, the code passes it back into the right date field. This would keep me from 10 different hard coded calendars templates. Any ideas or even good resources that might do this. Thanks. PS - Anyone interested in the code please contact me off list. Gary McNeel, Jr. Project Manager - DAC-Net, Research Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.01 and 2000
- Original Message - From: "Dave Watts" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 10:55 PM Was wondering if anyone knew if 4.01 would work on W2K Advanced Server? If it can, has anyone tried it out? Anything to watch out for? It worked fine on my laptop, although my laptop doesn't get that much traffic. It will break MDAC 2.5, which can be fixed by "upgrading" your Win2K install after you install CF. Yes - I can confirm Dave's comments relative to a full blown Windows 2000 Advanced Server machine as well. I had identical configurations on both NT Server 4 and Windows 2000 AS - as Dave says - installing CF 4.01 on Win2K breaks MDAC 2.5 to the point where some ODBC instructions won't work anymore, and it seems to destroy the SQLOLEDB provider almost completely. I certainly won't be upgrading my Win2K until I have to for the sake of CF 4.01 Enterprise, but I do expect Allaire to fix what I regard as a very serious bug. I don't think Allaire should provide and install MDAC anyway with the install - MDAC is a matter for system administrators to manage on their own setups as they see fit IMO. Adrian Cooper. -- Archives: http://www.eGroups.com/list/cf-talk 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: CFLOOP list=Query.Value ??
Please explain how I could normalize this table? Database designs is not my forte, but unfortunately, I have the joy of learning that hard way. If you want to build database applications, it's a good idea to spend some time learning about designing data schemas. I can't overemphasize this. I see quite a few CF applications, and the biggest problems with those applications aren't the CF coding itself, but either the database design or the actual SQL used to query. What I have is a list of relationships. For each contact in my database, I have a field in the contact table that contains the comma delimited list of numbers. These numbers are the primary key values for other contacts in the contact table that this person has set up a relationship to. Is this not the best way to handle this? It sounds like each contact has one or more relationships with other contacts in the same table. This is essentially the same as a many-to-many relationship, except that both sides of the relationship are stored in the same table. You can create a linking table, which might have two fields: Contact_Relationship: Contact_ID - integer Relationship_Contact_ID - integer The table should have both fields related to the Contact_ID field within the Contact table, and should use both fields to define its primary key, and shouldn't have any identity column Instead of writing the list of numbers into a field within the contact table, loop over the list of numbers and insert each one as a relationship contact ID. For example, let's say that Contact 47 has relationships with 12, 15 and 92. You could then insert each of these relationships into your Contact_Relationship table: !--- Contact_ID = 47, ListOfRelationships = "12,15,92" --- CFLOOP INDEX="i" LIST="#ListOfRelationships#" CFQUERY NAME="qInsRelationship" ... INSERT INTO Contact_Relationship (Contact_ID, Relationship_Contact_ID) VALUES (#Contact_ID#, #i#) /CFQUERY /CFLOOP This should be enough to get you started. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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: stupid cfx tag question
If they won't install it, you're outta luck. I had a feeling that was the case. So the second question is, how can I convince an ISP that a CFX tag, like CFX_checkemail is safe? Is there good reason for their reluctance? c -- Chris Lott [EMAIL PROTECTED], Technical Manager p907.474.5122 | f907.474.5402 | PGP Key ID: 0x8687E87E -- Archives: http://www.eGroups.com/list/cf-talk 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: stupid cfx tag question
If they won't install it, you're outta luck. I had a feeling that was the case. So the second question is, how can I convince an ISP that a CFX tag, like CFX_checkemail is safe? Is there good reason for their reluctance? c -- Chris Lott [EMAIL PROTECTED], Technical Manager p907.474.5122 | f907.474.5402 | PGP Key ID: 0x8687E87E -- Archives: http://www.eGroups.com/list/cf-talk 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.01 and 2000
I had identical configurations on both NT Server 4 and Windows 2000 AS - as Dave says - installing CF 4.01 on Win2K breaks MDAC 2.5 to the point where some ODBC instructions won't work anymore, and it seems to destroy the SQLOLEDB provider almost completely. I certainly won't be upgrading my Win2K until I have to for the sake of CF 4.01 Enterprise, but I do expect Allaire to fix what I regard as a very serious bug. I don't think Allaire should provide and install MDAC anyway with the install - MDAC is a matter for system administrators to manage on their own setups as they see fit IMO. CF 4.5.1 RTM doesn't break MDAC on Win2K. In any case, it's a very simple process to fix the problem with earlier versions; it's just a little tedious. Lots of applications, not just CF, will modify some or all MDAC parts; SQL Server 7, for example, forces MDAC 2.0, because it won't work with earlier versions. Microsoft, on the other hand, changed how MDAC upgrades are handled in Win2K, which is the bigger problem from a compatibility standpoint. MDAC in Win2K isn't a separate component, but part of the OS, which means that you won't be able to install new MDACs, but will change MDAC through Win2K service packs and updates. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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 anyone advise? How to define an application variable?
So I created an application.cfm file and placed it in the same directory as all my other .cfm files. In it I did a bunch of named CFQUERYs to retrieve the legal values as part of application initialization. Then in my regular .cfm templates I refered to something like #Application.query_name.column_name# (where Application is literal). I got an error message when the referring template was launched telling me that it didn't know about my applications variable. My question is: Am I doing this right? Is this the way to define and then use application level variables? Is it true that these queries will be executed only once in the application or will they be executed whenever any template is launched (when the automatic inclusion of Application.cfm occurs)? Do I need some CFIF in the Application.cfm template to make sure they are executed only once? If so, what should the condition be? etc. etc. etc. Without seeing your code, I can only make assumptions about what exactly you're doing. Here goes. 1. You'll need a CFAPPLICATION tag in application.cfm to use Application or Session variables. It might look like this: CFAPPLICATION NAME="myapp" SESSIONMANAGEMENT="TRUE" 2. You'll only want to execute the queries if they're not already stored as application variables, so you'll need to wrap them in conditional logic to check for their non-existence. You'll probably want to do all this within application.cfm: CFIF NOT IsDefined("Application.MyQuery") CFQUERY NAME="Application.MyQuery" ... ... /CFQUERY /CFIF 3. You'll have to use "Application." or "Session." in your query name to place it within the Application or Session scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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.01 and 2000
- Original Message - From: Dave Watts [EMAIL PROTECTED] Sent: 07 April 2000 23:24 Subject: RE: 4.01 and 2000 CF 4.5.1 RTM doesn't break MDAC on Win2K. In any case, it's a very simple process to fix the problem with earlier versions; it's just a little tedious. Lots of applications, not just CF, will modify some or all MDAC parts; SQL Server 7, for example, forces MDAC 2.0, because it won't work with earlier versions. Microsoft, on the other hand, changed how MDAC upgrades are handled in Win2K, which is the bigger problem from a compatibility standpoint. MDAC in Win2K isn't a separate component, but part of the OS, which means that you won't be able to install new MDACs, but will change MDAC through Win2K service packs and updates. I have never known a higher MDAC level be physically downgraded to a lower MDAC level - AFAIK M$ do version checking on these things. I recent example is NT MDAC 2.5 RTM where SQL Server 7 SP2 has, I believe (I haven't checked) a higher level SQL ODBC driver included. This leads me to believe that CF 4.01 was doing something more fundamental - on a machine with the highest level MDAC it tried to do something which plain broke it. The point I am making is that I don't think Allaire should include MDAC in the install at all - they should simply state the minimum server requirements for any given version of CF as they do for other hardware and software, and state minimum levels of MDAC required if necessary - it is up to the system adminstrator then to comply. This is particularly true of Win2k install, where, as you say, MDAC is a fundamental part of the O/S installation. Adrian Cooper. -- Archives: http://www.eGroups.com/list/cf-talk 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.
FW: cfhttp internal networks
i got a message this got bounced so I am resending. thanks -Original Message- From: Eisenhauer, James [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 12:57 PM To: [EMAIL PROTECTED] Subject: cfhttp internal networks We have two web servers on internal networks divided by a firewall. I can not get cfhttp to work. Get connection failure. I can no problem do www.yahoo.com or any other internet site. I was wondering if anybody could explain to me a little more detail of how cfhttp works(ports, actions,.) this way I can have something to go to our firewall people with. thanks IKE -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
Best Chat Solution
I need to add a chat facility to a site - something I have not done before. What is the best and easiest one to implement? I cannot find any on the Allaire site. The only normal chat facility I found had broken links. Paul Burgess -- Archives: http://www.eGroups.com/list/cf-talk 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: Best Chat Solution
IRCd for windows is excellent. I have a port from a friend of mine and I am sure he would hook you up. You can see a simple Java interface for it here: http://irc.simplematter.com Please be kind to the site, its still in early beta. Hence the reason the IRC server is set to so few connections. Also, with IRCd, you are able to connect to it like a man/woman should. With mIRC, or any other IRC client. Feel free to email me with any questions or comments Mike - Original Message - From: "Paul's Mail" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 07, 2000 7:13 PM Subject: Best Chat Solution I need to add a chat facility to a site - something I have not done before. What is the best and easiest one to implement? I cannot find any on the Allaire site. The only normal chat facility I found had broken links. Paul Burgess -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.