RE: Repeat Question still needing help
The file uploading and transfering to another site can be handled with CFFTP. The querying of a remote datasource could be handled with XML, WDDX, and possibly CFHTTP if you can load a script onto the remote server with CFFTP (or whatever). ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: ibtoad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 9:05 PM > To: CF-Talk > Subject: RE: Repeat Question still needing help > > > I want to upload files at a particular website but store them at > a seperate > server where we have additional storage space. We would also like to be > able to query that database through our main site. So how can write a > query to a datasource that is on a seperate server? > > Rich > > -Original Message- > From: Warrick, Mark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 6:16 PM > To: CF-Talk > Subject: RE: Repeat Question still needing help > > > I'm curious. What does CFFILE have to do with a remote database? > > Perhaps you could explain the problem in more detail? > > Maybe you've even got a technical spec? (crosses his fingers) > > ---mark > > -- > Mark Warrick > Phone: (714) 547-5386 > Efax.com Fax: (801) 730-7289 > Personal Email: [EMAIL PROTECTED] > Personal URL: http://www.warrick.net > Business Email: [EMAIL PROTECTED] > Business URL: http://www.fusioneers.com > ICQ: 346566 > -- > > > > -Original Message- > > From: ibtoad [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 27, 2000 12:50 PM > > To: CF-Talk > > Subject: RE: Repeat Question still needing help > > > > > > Access Database. I want to be able to upload files using cffile on our > > website and store them on a seperate server. > > > > Rich > > > > -Original Message- > > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 27, 2000 3:22 PM > > To: CF-Talk > > Subject: Re: Repeat Question still needing help > > > > > > What kind of database? In general you can access a desktop or > > SQL database > > if you configure it properly in ODBC. For desktop DBs I'm pretty > > sure that > > the ColdFusion service needs to be logged in as a user with > rights to the > > other server. > > > > Regards, > > > > Howie > > > > - Original Message - > > From: "ibtoad" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, December 27, 2000 3:05 PM > > Subject: Repeat Question still needing help > > > > > > > Can I query a database from a different > > > server if I have the datasource name and the full server root? > > > > > > Any suggestions would be great, > > > Rich > > > > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: brain dead easy ?
try: mid(string, start, count) -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 December 2000 2:31 PM To: CF-Talk Subject: brain dead easy ? I need to remember how to find out what the third character of a given string is. Thanks, then I can goto bed. Eric J. Hoffman Director of Internet Development Small Dog Design www.smalldogdesign.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: brain dead easy ?
duh, thanks. Eric J. Hoffman Director of Internet Development Small Dog Design www.smalldogdesign.com -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 12:34 AM To: CF-Talk Subject: RE: brain dead easy ? mid(string, 3, 1) should do the trick for you :) Allan Pichler Machine Dreams Inc. -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 10:31 PM To: CF-Talk Subject: brain dead easy ? I need to remember how to find out what the third character of a given string is. Thanks, then I can goto bed. Eric J. Hoffman Director of Internet Development Small Dog Design www.smalldogdesign.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: brain dead easy ?
mid(string, 3, 1) should do the trick for you :) Allan Pichler Machine Dreams Inc. -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 10:31 PM To: CF-Talk Subject: brain dead easy ? I need to remember how to find out what the third character of a given string is. Thanks, then I can goto bed. Eric J. Hoffman Director of Internet Development Small Dog Design www.smalldogdesign.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
brain dead easy ?
I need to remember how to find out what the third character of a given string is. Thanks, then I can goto bed. Eric J. Hoffman Director of Internet Development Small Dog Design www.smalldogdesign.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repeat Question still needing help
The data source needs to be configured on the server that you are doing the queries from. I would just automate configuring the datasource to the other server and make sure that cf has permissions to that server. Regards, Howie - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 28, 2000 12:05 AM Subject: RE: Repeat Question still needing help > I want to upload files at a particular website but store them at a seperate > server where we have additional storage space. We would also like to be > able to query that database through our main site. So how can write a > query to a datasource that is on a seperate server? > > Rich > > -Original Message- > From: Warrick, Mark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 6:16 PM > To: CF-Talk > Subject: RE: Repeat Question still needing help > > > I'm curious. What does CFFILE have to do with a remote database? > > Perhaps you could explain the problem in more detail? > > Maybe you've even got a technical spec? (crosses his fingers) > > ---mark > > -- > Mark Warrick > Phone: (714) 547-5386 > Efax.com Fax: (801) 730-7289 > Personal Email: [EMAIL PROTECTED] > Personal URL: http://www.warrick.net > Business Email: [EMAIL PROTECTED] > Business URL: http://www.fusioneers.com > ICQ: 346566 > -- > > > > -Original Message- > > From: ibtoad [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 27, 2000 12:50 PM > > To: CF-Talk > > Subject: RE: Repeat Question still needing help > > > > > > Access Database. I want to be able to upload files using cffile on our > > website and store them on a seperate server. > > > > Rich > > > > -Original Message- > > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 27, 2000 3:22 PM > > To: CF-Talk > > Subject: Re: Repeat Question still needing help > > > > > > What kind of database? In general you can access a desktop or > > SQL database > > if you configure it properly in ODBC. For desktop DBs I'm pretty > > sure that > > the ColdFusion service needs to be logged in as a user with rights to the > > other server. > > > > Regards, > > > > Howie > > > > - Original Message - > > From: "ibtoad" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, December 27, 2000 3:05 PM > > Subject: Repeat Question still needing help > > > > > > > Can I query a database from a different > > > server if I have the datasource name and the full server root? > > > > > > Any suggestions would be great, > > > Rich > > > > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repeat Question still needing help
I want to upload files at a particular website but store them at a seperate server where we have additional storage space. We would also like to be able to query that database through our main site. So how can write a query to a datasource that is on a seperate server? Rich -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 6:16 PM To: CF-Talk Subject: RE: Repeat Question still needing help I'm curious. What does CFFILE have to do with a remote database? Perhaps you could explain the problem in more detail? Maybe you've even got a technical spec? (crosses his fingers) ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: ibtoad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 12:50 PM > To: CF-Talk > Subject: RE: Repeat Question still needing help > > > Access Database. I want to be able to upload files using cffile on our > website and store them on a seperate server. > > Rich > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 3:22 PM > To: CF-Talk > Subject: Re: Repeat Question still needing help > > > What kind of database? In general you can access a desktop or > SQL database > if you configure it properly in ODBC. For desktop DBs I'm pretty > sure that > the ColdFusion service needs to be logged in as a user with rights to the > other server. > > Regards, > > Howie > > - Original Message - > From: "ibtoad" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, December 27, 2000 3:05 PM > Subject: Repeat Question still needing help > > > > Can I query a database from a different > > server if I have the datasource name and the full server root? > > > > Any suggestions would be great, > > Rich > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LOST
which upgrade? -Original Message- From: Mike Weaver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 7:59 PM To: CF-Talk Subject: LOST Is it me or does anyone else not recognize the interface after installing the new upgrade?? A warning would have been nice!! Mike ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
LOST
Is it me or does anyone else not recognize the interface after installing the new upgrade?? A warning would have been nice!! Mike ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Audience Profiling
It's less programming and a lot of back end crunching at the end. For every page view, record the cgi.http_referr string, the current cgi.querystring and/or cgi.scriptname, and/or other additional parameters such as the userid/ip address, time, etc...as much unique data as you will need in the long run... once you have the 2gig database sitting idle on the server, use some other environment, not cf, to access the databse and crunch the data and spit out classifications of the user and other stats and possiblity back to another "personalization" database. Also, you have tried weblog analyzers? If all you need is tracking general movement then just crunch the weblogs. xing - Original Message - From: "Roger Lim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 6:48 PM Subject: Audience Profiling > Hi, > > I'm currently planning a project that requires Audience Profiling. Basically > the administrator of the website will be able to track the user's movement, > like the most frequent visited pages of the site, number of times the user > used a certain facility, etc. > > Any idea how do I go about doing that using CF ? > > Thanks, > Roger > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dr. Laura & CF-Talk
Hello, I must say that this service has been so beneficial that, like Dr. Laura, I tend to have resolved the situation by the time I worry about presenting it without sounding like an idiot!! I want to Thank You All for taking the time to share your experience and insight to benefit the progression of Newbies and the CF Code. Mike Weaver Happy Holidays BLOCKBUSTER VIDEO ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Audience Profiling
Depends on what do you really want. BTW you can see www.atg.com about Dynamo server. It has "personalisation" server. Regards - Original Message - From: "Roger Lim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 28, 2000 1:48 PM Subject: Audience Profiling > Hi, > > I'm currently planning a project that requires Audience Profiling. Basically > the administrator of the website will be able to track the user's movement, > like the most frequent visited pages of the site, number of times the user > used a certain facility, etc. > > Any idea how do I go about doing that using CF ? > > Thanks, > Roger > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Audience Profiling
Hi, I'm currently planning a project that requires Audience Profiling. Basically the administrator of the website will be able to track the user's movement, like the most frequent visited pages of the site, number of times the user used a certain facility, etc. Any idea how do I go about doing that using CF ? Thanks, Roger ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Select Distinct problems
On 12/27/00, W Luke penned: >I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am >trying to select 2 columns from 2 different tables, as follows, to obtain x >unique email address from the columns "email" and "email2", part of the >tables "EMAILS" and "EMAILS2" respectively. > > >SELECT distinct email,email2 FROM EMAILS,EMAILS2 > Sounds like a problem. Is there a NEED to have both tables? If not, I'd merge them into one. If so, then you'd probably be best creating a separate table for the e-mail addresses, with an ID field and making the existing e-mail fields ID fields and relate them to the ID field in the new email table. You are going to need some sort of relation selecting from 2 tables anyway or you're going to return a zillion records. I thought I told you that once Will. LOL If it's just something you need to do quick or don't have access to the database, you could run 2 queries and do: Then loop through emaillist for the output. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT: IP-traffic-analyzer]
its in your log files. analog is good webalizer is good webtrends "cf-talk" <[EMAIL PROTECTED]> wrote: Hi list, is there a good SW-tool to view the IP-traffic of a server ? Thanks. Uwe Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IP-traffic-analyzer
Hi list, is there a good SW-tool to view the IP-traffic of a server ? Thanks. Uwe Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail and aol addresses
Is it possible you've been banned from sending email to the AOL network? Try sending someone on AOL an email with a normal email client. See what happens. It's also highly probable that the messages are actually getting there - just very slowly. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 1:20 PM > To: CF-Talk > Subject: cfmail and aol addresses > > > For some reason the mail generated by CFMAIL tags on a web site I'm > buidling are not being delivered to AOL addresses. Any ide why? > > TIA - > Jonathan Karlen > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repeat Question still needing help
I'm curious. What does CFFILE have to do with a remote database? Perhaps you could explain the problem in more detail? Maybe you've even got a technical spec? (crosses his fingers) ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: ibtoad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 12:50 PM > To: CF-Talk > Subject: RE: Repeat Question still needing help > > > Access Database. I want to be able to upload files using cffile on our > website and store them on a seperate server. > > Rich > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 3:22 PM > To: CF-Talk > Subject: Re: Repeat Question still needing help > > > What kind of database? In general you can access a desktop or > SQL database > if you configure it properly in ODBC. For desktop DBs I'm pretty > sure that > the ColdFusion service needs to be logged in as a user with rights to the > other server. > > Regards, > > Howie > > - Original Message - > From: "ibtoad" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, December 27, 2000 3:05 PM > Subject: Repeat Question still needing help > > > > Can I query a database from a different > > server if I have the datasource name and the full server root? > > > > Any suggestions would be great, > > Rich > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Select Distinct problems
SELECT DISTINCT EMail FROM (SELECT EMail FROM EMAILS UNION SELECT email2 as email FROM EMAILS2) -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:39 PM To: CF-Talk Subject: Select Distinct problems Hi, I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am trying to select 2 columns from 2 different tables, as follows, to obtain x unique email address from the columns "email" and "email2", part of the tables "EMAILS" and "EMAILS2" respectively. SELECT distinct email,email2 FROM EMAILS,EMAILS2 After a lot of crunching from my server, it just timed out, and I needed to restart CF App server to operate the comp again as it had tied up all the resources. I suppose I'm using the wrong SQL - could someone explain what I have to do? Cheers Will ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repeat Question still needing help
It is possible to setup a datasource on your local CF server to a remote database so long as you somehow have access to it. For example, if the remote server is a SQL server, then you simply enter in the connection string into the datasource options & there you go - it'll work (with some performance degradation) as though it was on the same box. Let's say that a remote server has an Access database on it. Well, in this case, you would have to have a UNC path to the remote drive and then you could setup the remote MDB file as a local datasource. I'm certain that there's a way to exchange data with XML or WDDX but I'll leave those tutorials up to the experts in those areas. I'd be curious to know how one would connect to a remote MDB file without a UNC connection. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: ibtoad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 12:05 PM > To: CF-Talk > Subject: Repeat Question still needing help > > > Can I query a database from a different > server if I have the datasource name and the full server root? > > Any suggestions would be great, > Rich > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP and problems with spaces in WDDX packet
Ryan Try this as you CFHTTPPARAM: Thanks, David Sparkman Application Development Team Leader Weberize, Inc. http://www.weberize.com -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 3:57 PM To: CF-Talk Subject: CFHTTP and problems with spaces in WDDX packet I am trying to pass a WDDX packet to another page through CFHTTP. I keeps throwing errors on a space in the data. One of the strings in one of the variables in the WDDX packet has a string in it. This is user entered data, it could have lots of string in it. I try to pass it over like this: (At this point Attributes.signuppkt is a base64 encoded WDDX packet) Then on the called page I try to de-serialize it with But I get this error: XML parsing error: not well-formed (error code 4, line 1, column 56, buffer offset 56) This is because its hitting that space in the data. I've tried running ToString(ToBinary(Attributes.signuppkt)) before I pass it over, just to pass it over as a plain text WDDX packet. It is truncated at the first space. I am displaying the value I'm using in the CFHTTPPARAM tag on the screen, so I know the data I'm passing over is OK. I've tried using URLEncodedFormat on it too. When I compare the before and after data (this is before I un-base64 it) the only difference is where there are pluses in the before data, the after data has actual spaces! I've been working on this for hours. All I need to do is pass a WDDX packet between servers. Big headache now... Thanks, Ryan ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Select Distinct problems
> are you trying to get emails from table 1 that are not in table 2? > if so use a WHERE NOT EXISTS clause No - table 1 and table 2 are just lists of jumbled up emails, with duplicates (of which one might be in table 1 and another in table 2). It's very irritating that they exist in 2 tables, but that's the way it is, unfortunately! Will ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Net Tanking?
It actually came of the cf-jobs list, it may even be little OT for that :) - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 9:30 PM Subject: Re: RE: Net Tanking? > This was not meant for this list I dont believe, but please tell me which. > I'd love to give this John Wilker a piece of my mind. > As a high school dropout, I believe the opposite is true. > Classes teach you syntax not solutions. Most college educated computer > "professionals" I know, know far fewer whys about computers in general than > most of my non educated friends who just played with computers when we were > young... > > jon > - Original Message - > From: "Judith Taylor" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, December 27, 2000 3:23 PM > Subject: Fwd: RE: Net Tanking? > > > > I believe this was to go to the list... ;o) > > > > Judith > > > > >From: Nick Baker <[EMAIL PROTECTED]> > > >Subject: RE: Net Tanking? > > > > > >John I would ask you to consider if you painted with too broad of a > brush? > > >Judith is right. Formal training allows the same person to become > > >proficient at a faster pace. One cannot extend that logic to say that > > >anyone with formal training is better everyone with out formal training. > > >If that were true then everyone who ever graduated from a University > would > > >be more successful than Bill Gates who dropped out of (I believe) > Harvard. > > > > > >Nick > > > > > >>You know, not everyone can afford to take the CF Classes. Some of us > > >>"people who work from [their] our 'bedrooms' do so not because we really > > >>want to, but because circumstances have made it so we have to. I live in > an > > >>area that is not 'overflowing' with CF opportunitiesand because of > > >>personal involvements, I have no wish to move. > > >> > > >>I have been working with CF only since version 3.1, I have a college > degree > > >>in fine arts and come from a non-programming background. Does this make > me > > >>less of a professional? I have worked as a UNIX account > > >>assistant/consultant (a step or so below full UNIX administration - > taking > > >>care of those problems that sys admins shouldn't need to worry about) > and > > >>as a CF developer. All my computer skills I learned on my own...starting > > >>with Macintosh, working through UNIX, learning Windows 3.1, 95, 98 and > NT4, > > >>and Linux (RedHat 6.2). > > >> > > >>Some day, I would love to be able to afford to get some 'formalized > > >>training' if only to have that piece of paper that "proves my worth" to > > >>people who, when they don't see a CIS or MIS degree listed in my resume, > > >>dismiss my abilities - to do or to learn. > > >> > > >>I proudly call myself a professional. > > >> > > >>Judith Taylor > > >>A Freelance 'bedroom' CF Developer > > >> > > >>At 12:27 PM 2000-12-27, John Wilker wrote: > > >> >[snip] > > >> >That's a very common theme, in any industry, the professional people > who > > >> >have honed their skills taken classes and such have to contend with > people > > >> >who work from their bedrooms and call themselves professionals, who > flood > > >> >the market and cast a bad light on the industry as a whole. > > >> > > > >> >That being said (just a gripe I've had for a long time :-)) > > >> > > >>Judith Taylor > > >>ICQ: 67460562 > > >>Freelance ColdFusion Developer > > > > > >Judith Taylor > > >ICQ: 67460562 > > >Freelance ColdFusion Developer > > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: Select Distinct problems]
are you trying to get emails from table 1 that are not in table 2? if so use a WHERE NOT EXISTS clause "W Luke" <[EMAIL PROTECTED]> wrote: > I'm gusing you want something like this: > > A > B > 1 > 2 > 3 > > right? I think so...for example, here's the problem I'm faced with: TABLE 1TABLE 2 - -- [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] What I need to return is: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Each table has 1600-2000 member address from my site, and even at a glance I can see lots of duplicates, making it 8000 at least. How can I do this? Cheers Will ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail and aol addresses
On 12/27/00, Jonathan Karlen penned: >For some reason the mail generated by CFMAIL tags on a web site I'm >buidling are not being delivered to AOL addresses. Any ide why? It wouldn't be hosted on virtualscape, would it? Have had terrible problems in the past with that on their server. Not sure if it's an IMail thing, a CF 4.51 thing, or a blocked mail server thing. My guess is the latter. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Select Distinct problems
> I'm gusing you want something like this: > > A > B > 1 > 2 > 3 > > right? I think so...for example, here's the problem I'm faced with: TABLE 1TABLE 2 - -- [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] What I need to return is: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Each table has 1600-2000 member address from my site, and even at a glance I can see lots of duplicates, making it 8000 at least. How can I do this? Cheers Will ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repeat Question still needing help
- Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 4:45 PM Subject: Re: Repeat Question still needing help > On 12/27/00, Howie Hamlin penned: > You can't use cf administrator and use UNC paths to the database file? > No, you can - it's just easier to set them up when you're logged in to make sure that the path works. Then if it doesn't work in CF then it's a permissions problem. I do it this way to make my life a bit easier... > > > Access Database. I want to be able to upload files using cffile on our > > > website and store them on a seperate server. > > I'm not sure where the database comes into play here. I would think > if you have access rights to the other server, you could just set the > destination parameter in cffile with the UNC path to the directory on > the other server where the files will be stored. I'm too poor to have > 2 servers so I'm just guessing. LOL Well, you still need to configure the file in ODBC as that is the only way for cf to use the access db. I think there are tags floating around that allow you to create ODBC datasources on the fly. Regards, Howie > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP and problems with spaces in WDDX packet
I am trying to pass a WDDX packet to another page through CFHTTP. I keeps throwing errors on a space in the data. One of the strings in one of the variables in the WDDX packet has a string in it. This is user entered data, it could have lots of string in it. I try to pass it over like this: (At this point Attributes.signuppkt is a base64 encoded WDDX packet) Then on the called page I try to de-serialize it with But I get this error: XML parsing error: not well-formed (error code 4, line 1, column 56, buffer offset 56) This is because its hitting that space in the data. I've tried running ToString(ToBinary(Attributes.signuppkt)) before I pass it over, just to pass it over as a plain text WDDX packet. It is truncated at the first space. I am displaying the value I'm using in the CFHTTPPARAM tag on the screen, so I know the data I'm passing over is OK. I've tried using URLEncodedFormat on it too. When I compare the before and after data (this is before I un-base64 it) the only difference is where there are pluses in the before data, the after data has actual spaces! I've been working on this for hours. All I need to do is pass a WDDX packet between servers. Big headache now... Thanks, Ryan ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail and aol addresses
Possible...did the previous adminstrators of the site do any spamming? -Kev > -Original Message- > From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 4:34 PM > To: CF-Talk > Subject: Re: cfmail and aol addresses > > > Just one at a time. Order confirmations and "I forgot my > password" e-mails. We're taking over development of an existing > site. Do you think the domain name is blocked? > > Jonathan Karlen > > Kevin Langevin wrote: > > > How many are you sending at once? A company I previously > worked for sent > > mass-e-mails out to registered newsletter subscribers, and AOL > throttled the > > incoming mail automatically until we went through some hoops to get the > > throttle lifted from our IP address specifically. > > > > > > -Kev > > > > > > > -Original Message- > > > From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, December 27, 2000 4:20 PM > > > To: CF-Talk > > > Subject: cfmail and aol addresses > > > > > > > > > For some reason the mail generated by CFMAIL tags on a web site I'm > > > buidling are not being delivered to AOL addresses. Any ide why? > > > > > > TIA - > > > Jonathan Karlen > > > > > > > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail and aol addresses
Is your mail server on the ORBS list? Check at orbs.org. I had a similar problem with AOL. They wouldn't accept any Cold Fusion (or other email) from one of the mail servers because the Open Mail Relay option was not off. Just a possibility... craig -Original Message- From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 4:20 PM To: CF-Talk Subject: cfmail and aol addresses For some reason the mail generated by CFMAIL tags on a web site I'm buidling are not being delivered to AOL addresses. Any ide why? TIA - Jonathan Karlen ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail and aol addresses
Have a look in your CFMAIL logs. These are under: \Mail\Log You may get some idea from there... HTH, Howie - Original Message - From: "Jonathan Karlen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 4:20 PM Subject: cfmail and aol addresses > For some reason the mail generated by CFMAIL tags on a web site I'm > buidling are not being delivered to AOL addresses. Any ide why? > > TIA - > Jonathan Karlen > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repeat Question still needing help
On 12/27/00, Howie Hamlin penned: >Then you should create the ODBC from the CF Server (don't use the cf >administrator for this). The ODBC connection points to the other server via >UNC paths. Make sure that the connection verifies from the ODBC setup. >Once the connection is verified you need to configure the CF service to log >in as a user with rights to the other server. You can't use cf administrator and use UNC paths to the database file? > > Access Database. I want to be able to upload files using cffile on our > > website and store them on a seperate server. I'm not sure where the database comes into play here. I would think if you have access rights to the other server, you could just set the destination parameter in cffile with the UNC path to the directory on the other server where the files will be stored. I'm too poor to have 2 servers so I'm just guessing. LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail and aol addresses
I just checked AOL's site, and saw nothing indicating that their network should be blocking your mail (this doesn't mean they aren't). You're probably just sending too much traffic from a single address or domain, and their firewall, Mail Server, or anti-spam software is throwing up a red flag. Try sending one e-mail and see if that goes through... experiment with the numbers until you find whatever works best for you. You can e-mail aol in the meantime, but don't hold your breath waiting for a reply. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 4:20 PM To: CF-Talk Subject: cfmail and aol addresses For some reason the mail generated by CFMAIL tags on a web site I'm buidling are not being delivered to AOL addresses. Any ide why? TIA - Jonathan Karlen ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail and aol addresses
Just one at a time. Order confirmations and "I forgot my password" e-mails. We're taking over development of an existing site. Do you think the domain name is blocked? Jonathan Karlen Kevin Langevin wrote: > How many are you sending at once? A company I previously worked for sent > mass-e-mails out to registered newsletter subscribers, and AOL throttled the > incoming mail automatically until we went through some hoops to get the > throttle lifted from our IP address specifically. > > > -Kev > > > > -Original Message- > > From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 27, 2000 4:20 PM > > To: CF-Talk > > Subject: cfmail and aol addresses > > > > > > For some reason the mail generated by CFMAIL tags on a web site I'm > > buidling are not being delivered to AOL addresses. Any ide why? > > > > TIA - > > Jonathan Karlen > > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail and aol addresses
Quoting Jonathan Karlen <[EMAIL PROTECTED]>: > For some reason the mail generated by CFMAIL tags on a web site I'm > buidling are not being delivered to AOL addresses. Any ide why? This may be unrelated, but one of my friends recently had an issue where his personal mail was not being delivered to AOL addresses. It was being blocked as coming from a spammer address. AOL was not the only domain giving him problems, but the others were relatively small domains. Try sending a message from an accessible account on the domain that cfmail is sending from to a test address at AOL and see what happens. - This mail sent through IMP: sparky.drule.org ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Select Distinct problems
What you may wish to do is perform a UNION query and alias each subquery's column to the same name. That's worked for me in the past. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, December 27, 2000 3:05 PM Subject: Re: Select Distinct problems >Are these tables related in any way? > >What the SQL server is doing is returning every distinct row it can make up. > >Say you have table 1 contains A and B and table 2 conatins 1, 2, and 3. >With your query you end up with this > >A 1 >A 2 >A 3 >B 1 >B 2 >B 3 > >As you can see .. all of these are indeed distinct rows, but probably not >what you wanted. > >I'm gusing you want something like this: > >A >B >1 >2 >3 > >right? > >Todd Ashworth > >- Original Message - >From: "W Luke" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, December 27, 2000 2:38 PM >Subject: Select Distinct problems > > >| Hi, >| >| I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am >| trying to select 2 columns from 2 different tables, as follows, to obtain >x >| unique email address from the columns "email" and "email2", part of the >| tables "EMAILS" and "EMAILS2" respectively. >| >| >| SELECT distinct email,email2 FROM EMAILS,EMAILS2 >| >| >| After a lot of crunching from my server, it just timed out, and I needed >to >| restart CF App server to operate the comp again as it had tied up all the >| resources. I suppose I'm using the wrong SQL - could someone explain what >I >| have to do? >| >| Cheers >| >| Will >| >| >| > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail and aol addresses
How many are you sending at once? A company I previously worked for sent mass-e-mails out to registered newsletter subscribers, and AOL throttled the incoming mail automatically until we went through some hoops to get the throttle lifted from our IP address specifically. -Kev > -Original Message- > From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 4:20 PM > To: CF-Talk > Subject: cfmail and aol addresses > > > For some reason the mail generated by CFMAIL tags on a web site I'm > buidling are not being delivered to AOL addresses. Any ide why? > > TIA - > Jonathan Karlen > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Net Tanking?
This was not meant for this list I dont believe, but please tell me which. I'd love to give this John Wilker a piece of my mind. As a high school dropout, I believe the opposite is true. Classes teach you syntax not solutions. Most college educated computer "professionals" I know, know far fewer whys about computers in general than most of my non educated friends who just played with computers when we were young... jon - Original Message - From: "Judith Taylor" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 3:23 PM Subject: Fwd: RE: Net Tanking? > I believe this was to go to the list... ;o) > > Judith > > >From: Nick Baker <[EMAIL PROTECTED]> > >Subject: RE: Net Tanking? > > > >John I would ask you to consider if you painted with too broad of a brush? > >Judith is right. Formal training allows the same person to become > >proficient at a faster pace. One cannot extend that logic to say that > >anyone with formal training is better everyone with out formal training. > >If that were true then everyone who ever graduated from a University would > >be more successful than Bill Gates who dropped out of (I believe) Harvard. > > > >Nick > > > >>You know, not everyone can afford to take the CF Classes. Some of us > >>"people who work from [their] our 'bedrooms' do so not because we really > >>want to, but because circumstances have made it so we have to. I live in an > >>area that is not 'overflowing' with CF opportunitiesand because of > >>personal involvements, I have no wish to move. > >> > >>I have been working with CF only since version 3.1, I have a college degree > >>in fine arts and come from a non-programming background. Does this make me > >>less of a professional? I have worked as a UNIX account > >>assistant/consultant (a step or so below full UNIX administration - taking > >>care of those problems that sys admins shouldn't need to worry about) and > >>as a CF developer. All my computer skills I learned on my own...starting > >>with Macintosh, working through UNIX, learning Windows 3.1, 95, 98 and NT4, > >>and Linux (RedHat 6.2). > >> > >>Some day, I would love to be able to afford to get some 'formalized > >>training' if only to have that piece of paper that "proves my worth" to > >>people who, when they don't see a CIS or MIS degree listed in my resume, > >>dismiss my abilities - to do or to learn. > >> > >>I proudly call myself a professional. > >> > >>Judith Taylor > >>A Freelance 'bedroom' CF Developer > >> > >>At 12:27 PM 2000-12-27, John Wilker wrote: > >> >[snip] > >> >That's a very common theme, in any industry, the professional people who > >> >have honed their skills taken classes and such have to contend with people > >> >who work from their bedrooms and call themselves professionals, who flood > >> >the market and cast a bad light on the industry as a whole. > >> > > >> >That being said (just a gripe I've had for a long time :-)) > >> > >>Judith Taylor > >>ICQ: 67460562 > >>Freelance ColdFusion Developer > > > >Judith Taylor > >ICQ: 67460562 > >Freelance ColdFusion Developer > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail and aol addresses
For some reason the mail generated by CFMAIL tags on a web site I'm buidling are not being delivered to AOL addresses. Any ide why? TIA - Jonathan Karlen ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need some sql sever 2000 help
Art, Start here: http://msdn.microsoft.com/default.asp and do a search for SQL Server 2000 or go here: http://msdn.microsoft.com/library/default.asp and browse/search the library. You can also visit the SQL Server home at http://www.microsoft.com/sql/ and check out the links for Learning Resources or Technical Info. Hope that helps. Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 > -Original Message- > From: Art Broussard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 2:17 PM > To: CF-Talk > Subject: OT: Need some sql sever 2000 help > > > I am going to be using Cold Fusion and SQL Sever 2000 and I need some > resources on SQL Sever 2000. > > Does anyone know of some good sites to go to for info, docs, > > I tried Microsoft but I couldn't find anything there to help me. > They just > want to sell me books. like I need more of those right now. > > Any info would ba a big help. > > Thanks > > Art ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repeat Question still needing help
Then you should create the ODBC from the CF Server (don't use the cf administrator for this). The ODBC connection points to the other server via UNC paths. Make sure that the connection verifies from the ODBC setup. Once the connection is verified you need to configure the CF service to log in as a user with rights to the other server. If you need more detail then let me know. Regards, Howie - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 3:49 PM Subject: RE: Repeat Question still needing help > Access Database. I want to be able to upload files using cffile on our > website and store them on a seperate server. > > Rich > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SmackDown
> Are the opponents Figleaf employees? One of them looks a lot like > Dave Watts.;-) Might that be the ornery one with grey hair and dentures? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> Some would argue that having a 60kb image-mapped graphic that > serves as the > entire content of your home page isn't effective, either, but > that's another > topic altogether. ;) Oh yes... And I would be one of them... If someone out there could please inform the Vice President of Development here, and somehow make it stick, I would be very much in your debt! Dr. Marcus Kiel Director of Development, but not VP! ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repeat Question still needing help
Access Database. I want to be able to upload files using cffile on our website and store them on a seperate server. Rich -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 3:22 PM To: CF-Talk Subject: Re: Repeat Question still needing help What kind of database? In general you can access a desktop or SQL database if you configure it properly in ODBC. For desktop DBs I'm pretty sure that the ColdFusion service needs to be logged in as a user with rights to the other server. Regards, Howie - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 3:05 PM Subject: Repeat Question still needing help > Can I query a database from a different > server if I have the datasource name and the full server root? > > Any suggestions would be great, > Rich > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Collection and Indexing question
Yes, a site can have multiple collections (actually, fewer smaller collections are better if you have a really large site). For dynamic pages, you index the collection from a query. Yes it can work with fusebox. -Original Message- From: mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 5:39 PM To: CF-Talk Subject: Collection and Indexing question 1.) Can a site have more than one collection? 2.) How does collection work with dynamic pages ? 3.) Does it work with fusebox ? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repeat Question still needing help
What kind of database? In general you can access a desktop or SQL database if you configure it properly in ODBC. For desktop DBs I'm pretty sure that the ColdFusion service needs to be logged in as a user with rights to the other server. Regards, Howie - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 3:05 PM Subject: Repeat Question still needing help > Can I query a database from a different > server if I have the datasource name and the full server root? > > Any suggestions would be great, > Rich > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fwd: RE: Net Tanking?
I believe this was to go to the list... ;o) Judith >From: Nick Baker <[EMAIL PROTECTED]> >Subject: RE: Net Tanking? > >John I would ask you to consider if you painted with too broad of a brush? >Judith is right. Formal training allows the same person to become >proficient at a faster pace. One cannot extend that logic to say that >anyone with formal training is better everyone with out formal training. >If that were true then everyone who ever graduated from a University would >be more successful than Bill Gates who dropped out of (I believe) Harvard. > >Nick > >>You know, not everyone can afford to take the CF Classes. Some of us >>"people who work from [their] our 'bedrooms' do so not because we really >>want to, but because circumstances have made it so we have to. I live in an >>area that is not 'overflowing' with CF opportunitiesand because of >>personal involvements, I have no wish to move. >> >>I have been working with CF only since version 3.1, I have a college degree >>in fine arts and come from a non-programming background. Does this make me >>less of a professional? I have worked as a UNIX account >>assistant/consultant (a step or so below full UNIX administration - taking >>care of those problems that sys admins shouldn't need to worry about) and >>as a CF developer. All my computer skills I learned on my own...starting >>with Macintosh, working through UNIX, learning Windows 3.1, 95, 98 and NT4, >>and Linux (RedHat 6.2). >> >>Some day, I would love to be able to afford to get some 'formalized >>training' if only to have that piece of paper that "proves my worth" to >>people who, when they don't see a CIS or MIS degree listed in my resume, >>dismiss my abilities - to do or to learn. >> >>I proudly call myself a professional. >> >>Judith Taylor >>A Freelance 'bedroom' CF Developer >> >>At 12:27 PM 2000-12-27, John Wilker wrote: >> >[snip] >> >That's a very common theme, in any industry, the professional people who >> >have honed their skills taken classes and such have to contend with people >> >who work from their bedrooms and call themselves professionals, who flood >> >the market and cast a bad light on the industry as a whole. >> > >> >That being said (just a gripe I've had for a long time :-)) >> >>Judith Taylor >>ICQ: 67460562 >>Freelance ColdFusion Developer > >Judith Taylor >ICQ: 67460562 >Freelance ColdFusion Developer ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Need some sql sever 2000 help
I am going to be using Cold Fusion and SQL Sever 2000 and I need some resources on SQL Sever 2000. Does anyone know of some good sites to go to for info, docs, I tried Microsoft but I couldn't find anything there to help me. They just want to sell me books. like I need more of those right now. Any info would ba a big help. Thanks Art ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SmackDown
Are the opponents Figleaf employees? One of them looks a lot like Dave Watts.;-) -- ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Convert HTM to PDF
Hi, Is there a custom tag or program that I can call to convert html file into PDF file? Thank you very much YC ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
Hey Marcus, > There is a very good reason for a user to type the "www." on my > URL. If they > don't, they will not arrive at my sites! I got to http://adtelusa.com/ just fine. Whew. :) > Do I register every possible misspelling just in case they are > dyslexic? NO! That's right. Just two lines of code will do: adtelusa.comIN A 207.252.224.130 (you've got this one) *.adtelusa.com IN A 207.252.224.130 > Eventually I have to work to make my sites more effective, rather then > making it easier to find. Some would argue that having a 60kb image-mapped graphic that serves as the entire content of your home page isn't effective, either, but that's another topic altogether. ;) -ron ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Collection and Indexing question
-Original Message- From: mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:39 PM To: CF-Talk Subject: Collection and Indexing question 1.) Can a site have more than one collection? Yes. Just create a collection for each that you need in the administrator or create a new one with CFCOLLECTION. 2.) How does collection work with dynamic pages ? Yes. You may create select boxes, radio buttons or checkboxes for choosing the collections to search through. You may use multiple selects or checks to search through multiple collections. You may do the same for the search criteria such as radio buttons for "All Words", " Any words" "On or Before". 3.) Does it work with fusebox ? Yes. Just use "fuseaction=search" to point to the proper fuseaction. ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
they can enter a full url anytime. Like I said, I agree that forcing a user to type 'www' can annoy or deter people, but I don't personally think it's that big a deal. As I and others have pointed out, a site running multiple domains, subdomains, or clustered machines may or may not have issues with dns prefixing. This entire thread began when somebody discovered that they couldn't type in a site name without the 'www' prefix. If it bothers you as a browser personally, then modify you 'hosts' file. If you run a site, then do as you will. That's all. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:55 PM To: CF-Talk Subject: RE: figleaf.com > having to specify the "www." isn't all that silly what if a > site is also > running an ftp server gopher server, etc. for a domain then you'd want > to force the www If a user wants to get your ftp or gopher server, then they can enter the full URL. This is just a simple DNS issue we're talking about. Forcing users to enter the "www." when all they want is your website causes many, many people to think your site is either broken or gone. Witness all the big-league sites that advertise their domain withOUT the www these days, and you'll understand why more and more users are leaving it off. Anyone here go to ebay.com? Yahoo.com? Microsoft.com? How often do you type the www. for sites like that? I'd hazard a guess that at least 1/3rd of the general population leaves it off, and at least half of them won't know to try the "www." when the first attempt fails. -ron ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> www.figleaf.com comes up for me, but figleaf.com does not. > Probably just an oversight, if it's a DNS thing. Thanks for pointing out this oversight. The A record for figleaf.com was pointing at the old host address. We recently changed our ISP, and this was a leftover. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MOD math function?
Thanks...I must have not had enough caffeine yet. jon - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 2:42 PM Subject: Re: MOD math function? > On 12/27/00, Jon Hall penned: > >Maybe I should have paid attention in math, but here is my problem. > > > >I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 > >/ 4) has a remainder. > > > >For some reason, (40 MOD 4) does not seem to be working. > > Two ways you could write a cfif: > No RemainderYes Remainder > or > Yes RemainderNo Remainder > > And then there's this: > #evaluate(40 mod 4)# > > which will return 0. > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Repeat Question still needing help
Can I query a database from a different server if I have the datasource name and the full server root? Any suggestions would be great, Rich ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Select Distinct problems
Are these tables related in any way? What the SQL server is doing is returning every distinct row it can make up. Say you have table 1 contains A and B and table 2 conatins 1, 2, and 3. With your query you end up with this A 1 A 2 A 3 B 1 B 2 B 3 As you can see .. all of these are indeed distinct rows, but probably not what you wanted. I'm gusing you want something like this: A B 1 2 3 right? Todd Ashworth - Original Message - From: "W Luke" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 2:38 PM Subject: Select Distinct problems | Hi, | | I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am | trying to select 2 columns from 2 different tables, as follows, to obtain x | unique email address from the columns "email" and "email2", part of the | tables "EMAILS" and "EMAILS2" respectively. | | | SELECT distinct email,email2 FROM EMAILS,EMAILS2 | | | After a lot of crunching from my server, it just timed out, and I needed to | restart CF App server to operate the comp again as it had tied up all the | resources. I suppose I'm using the wrong SQL - could someone explain what I | have to do? | | Cheers | | Will | | | ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
Ehh, just a personal preference but I like the load balancer setup to all be coming to one IP and *then* being rerouted not forcing someone to type "www3.xyz.com" I realize some aliases are useful but for only the main portion of the companies site. I guess I should have pointed out I think of it as silly both ways. I just think for redundancy you should map a very common thing such as the root domain, to each their own I know to check both but some people may and do get a lil misdirected at times, as evidenced on the reason this thread was started. Jeremy Allen elliptIQ Inc. >-Original Message- >From: Dylan Bromby [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 27, 2000 2:32 PM >To: CF-Talk >Subject: RE: figleaf.com > > >a lot of companies do in fact do this on purpose. some companies route the >3rd level www component to a server or farm on a specific segment of their >network. it can be done using just the second level domain; my >point is some >companies use only the 3rd level prefix for security reasons. > >-Original Message- >From: Jay Jennings [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 27, 2000 11:25 AM >To: CF-Talk >Subject: RE: figleaf.com > > >> I know this may sound a little silly, but a lot of companies >> like to force you to use the www alias for their websites. > >I can't believe that's done on purpose. About 1/3 of my traffic comes in >without the www part. Do those companies think people will keep searching >until they find the site? No, they'll probably go somewhere else. > >Why should you (a generic you, not a specific you) force the user to do >something like that? Because you can? Because it makes you feel like a god? >Because stupid users should know that if they want to access a site on the >world wide web they should include www in the address? If I could make >people come to my site by wishing I'd do that -- anything that gets the >traffic to you faster and with less hassle is GOOD. > > Jay > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> having to specify the "www." isn't all that silly what if a > site is also > running an ftp server gopher server, etc. for a domain then you'd want > to force the www If a user wants to get your ftp or gopher server, then they can enter the full URL. This is just a simple DNS issue we're talking about. Forcing users to enter the "www." when all they want is your website causes many, many people to think your site is either broken or gone. Witness all the big-league sites that advertise their domain withOUT the www these days, and you'll understand why more and more users are leaving it off. Anyone here go to ebay.com? Yahoo.com? Microsoft.com? How often do you type the www. for sites like that? I'd hazard a guess that at least 1/3rd of the general population leaves it off, and at least half of them won't know to try the "www." when the first attempt fails. -ron ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
>having to specify the "www." isn't all that silly. But it's mostly counterproductive. www.domain.com and domain.com A records both return the the same ip, WTF else do you want to at port 80 of that ip? Having an A record lookup of www and domain.com return different ip's serves what purpose? esp when it has become fairly conventional that public internet web service be there? >... what if a site is also >running an ftp server gopher server, etc. for a domain then you'd want >to force the www No "you" wouldn't. I run serv-U on machine that also has www.domain.com and domain.com resolving to the same ip. I ftp to www.domain.com and domain.com and serv-U answers at port 21 of that ip just fine. It is always advisable, even for one ip initially, to use a different hostname for each service: $ORIGIN domain.com. @ A ip.ad.re.ss www A ip.ad.re.ss ; the above two are customarily welded ftp A ip.ad.re.ss pop A ip.ad.re.ss mailA ip.ad.re.ss smtpA ip.ad.re.ss webmail A ip.ad.re.ss gopher A ip.ad.re.ss When you get bigger and move the services to separate machines (eg., the mail-related services), you only have to change the ip address, not add/change hostnames: @ A ip.ad.re.ss www A ip.ad.re.ss ftp A ip.ad.re.ss ; pop A ip.ad.re.s2 mailA ip.ad.re.s2 smtpA ip.ad.re.s2 webmail A ip.ad.re.s3 ; gopher A ip.ad.re.s4 Len http://BIND8NT.MEIway.com : Binary for ISC BIND 8.2.3 T9B for NT4 & W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-spam mail gateways ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail error
> Can someone help me out? > What the heck does the following cfmail error mean? It means the allaire programmers need to spend more time stress testing their DLL's? :-) I'm guessing it's something either in their winsock send routines or the routine that prepares the text for sending that crashed. --min > unknown exception condition > > TagCFMail::sendMessage > > The error occurred while processing an element with a general > identifier of > (CFMAIL), occupying document position (79:1) to (79:121) in the template > file > > Thanks > Jason Larson > [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MOD math function?
On 12/27/00, Jon Hall penned: >Maybe I should have paid attention in math, but here is my problem. > >I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 >/ 4) has a remainder. > >For some reason, (40 MOD 4) does not seem to be working. Two ways you could write a cfif: No RemainderYes Remainder or Yes RemainderNo Remainder And then there's this: #evaluate(40 mod 4)# which will return 0. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MOD math function?
-Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:27 PM To: CF-Talk Subject: MOD math function? Maybe I should have paid attention in math, but here is my problem. I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 / 4) has a remainder. For some reason, (40 MOD 4) does not seem to be working. jon ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MOD math function?
This works: divisible! not divisible! HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 2:27 PM Subject: MOD math function? > Maybe I should have paid attention in math, but here is my problem. > > I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 > / 4) has a remainder. > > For some reason, (40 MOD 4) does not seem to be working. > > jon > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
a fellow employee here also pointed out that the www differentiates a company from its site. I don't know what the legal or ethical signifigance of this is but I suppose somebody out there is concerned with such things. It's also worth mentioning that most users out there are not real "up" on internet architecture and are most familiar with the "www.whatever.com" url format. Anyway, companies should just register their domain name on DNS tables the way they want, and should advertise and register the same domain name on search engines, if they're concerned with such things. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:30 PM To: CF-Talk Subject: RE: figleaf.com > having to specify the "www." isn't all that silly what if a > site is also > running an ftp server gopher server, etc. for a domain then you'd want > to force the www Ooooh, one of my pet peeves and you guys just keep pushing my buttons. :) There is no _good_ reason to force a user to type "www." on your URL. None. Period. If you require it, it's a geek thing, not a user thing. Of course, if you don't care about users, then that's another matter. jay PS - I usually don't make blanket statements like the above because as soon as I do someone comes back and proves me wrong. But in this case I'll gamble. :) ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> There is no _good_ reason to force a user to type "www." on your > URL. None. > Period. If you require it, it's a geek thing, not a user thing. Of course, > if you don't care about users, then that's another matter. There is a very good reason for a user to type the "www." on my URL. If they don't, they will not arrive at my sites! This isn't a control issue as you contend. I just don't have the time to modify my DNS for every possible entry that a user MIGHT hit just to access my site. Do I register every possible misspelling just in case they are dyslexic? Do I register everything in .com, .net. .org, and even all the other domain suffix's? NO! Why? Because as I make my site more and more idiot proof, the universe keeps creating better and better idiots! Eventually I have to work to make my sites more effective, rather then making it easier to find. Marcus ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Select Distinct problems
Hi, I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am trying to select 2 columns from 2 different tables, as follows, to obtain x unique email address from the columns "email" and "email2", part of the tables "EMAILS" and "EMAILS2" respectively. SELECT distinct email,email2 FROM EMAILS,EMAILS2 After a lot of crunching from my server, it just timed out, and I needed to restart CF App server to operate the comp again as it had tied up all the resources. I suppose I'm using the wrong SQL - could someone explain what I have to do? Cheers Will ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Collection and Indexing question
1.) Can a site have more than one collection? 2.) How does collection work with dynamic pages ? 3.) Does it work with fusebox ? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Re: figleaf.com
Yeah, but it just makes sense to default the plain tld to *something* (I prefer the web server), otherwise clueless users will just assume the site is down and never visit again. This is easily done in the DNS records. If the user wants anything besides the web server, they need to specify the machine name too (ftp, gopher, news, mail, bob, whatever). Todd Ashworth - Original Message - From: "Simon Horwith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 2:20 PM Subject: RE: figleaf.com | having to specify the "www." isn't all that silly what if a site is also | running an ftp server gopher server, etc. for a domain then you'd want | to force the www | | ~Simon | | > Simon Horwith | > Allaire Certified ColdFusion Instructor | > Certified ColdFusion Developer | > Fig Leaf Software | > 1400 16th St NW, # 220 | > Washington DC 20036 | > 202.797.6570 (direct line) | > www.figleaf.com | > | | | -Original Message- | From: Jeremy Allen [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, December 27, 2000 2:06 PM | To: CF-Talk | Subject: RE: figleaf.com | | | I know this may sound a little silly, but a lot of companies | like to force you to use the www alias for their websites. | | so just "http://figleaf.com" will not open up.. you should | use "http://www.figleaf.com" | | Least, thats how it is from here, YMMV | | Jeremy Allen | elliptIQ Inc. | | >-Original Message- | >From: Dylan Bromby [mailto:[EMAIL PROTECTED]] | >Sent: Wednesday, December 27, 2000 1:59 PM | >To: CF-Talk | >Subject: RE: figleaf.com | > | > | >working fine from here. | > | >-Original Message- | >From: Jay Patton [mailto:[EMAIL PROTECTED]] | >Sent: Wednesday, December 27, 2000 10:57 AM | >To: CF-Talk | >Subject: figleaf.com | > | > | >Hey Dave, | >Whats up with figleaf.com? i wanted to play some smackdown durring | >lunch and | >the site wont come up? | > | >Jay Patton | >Web Pro USA | >406.549.3337 ext. 203 | >1.888.5WEBPRO | >www.webpro-usa.com | > | ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> having to specify the "www." isn't all that silly what if a > site is also > running an ftp server gopher server, etc. for a domain then you'd want > to force the www Well, grouping the dns's so "www.figleaf.com" and "figleaf.com" map to the same thing wouldn't really be an issue. The services run by port numbers. dns's doesn't care about port numbers. Most browsers, etc make automatic assumptions about the port to use based on those host names however. But you would name the web site "ftp.figleaf.com" and still browse an http server so long as you used the port numbers, and protocols etc. It's actually a very good way to determine how good a hosting company you're thinking about using really is. If they don't by default map both, I wouldn't trust them. :) --min ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
a lot of companies do in fact do this on purpose. some companies route the 3rd level www component to a server or farm on a specific segment of their network. it can be done using just the second level domain; my point is some companies use only the 3rd level prefix for security reasons. -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:25 AM To: CF-Talk Subject: RE: figleaf.com > I know this may sound a little silly, but a lot of companies > like to force you to use the www alias for their websites. I can't believe that's done on purpose. About 1/3 of my traffic comes in without the www part. Do those companies think people will keep searching until they find the site? No, they'll probably go somewhere else. Why should you (a generic you, not a specific you) force the user to do something like that? Because you can? Because it makes you feel like a god? Because stupid users should know that if they want to access a site on the world wide web they should include www in the address? If I could make people come to my site by wishing I'd do that -- anything that gets the traffic to you faster and with less hassle is GOOD. Jay ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
I never gave it that much thought. I also can't think of any GOOD reason to do it, but hey, to each their own. If a company is concerned with people possibly accidentally trying to browse their other protocol (or subnet) servers or just like the way it looks that's their call. I agree though, it is a silly restriction to place on potential browsers. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:25 PM To: CF-Talk Subject: RE: figleaf.com > I know this may sound a little silly, but a lot of companies > like to force you to use the www alias for their websites. I can't believe that's done on purpose. About 1/3 of my traffic comes in without the www part. Do those companies think people will keep searching until they find the site? No, they'll probably go somewhere else. Why should you (a generic you, not a specific you) force the user to do something like that? Because you can? Because it makes you feel like a god? Because stupid users should know that if they want to access a site on the world wide web they should include www in the address? If I could make people come to my site by wishing I'd do that -- anything that gets the traffic to you faster and with less hassle is GOOD. Jay ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> having to specify the "www." isn't all that silly what if a > site is also > running an ftp server gopher server, etc. for a domain then you'd want > to force the www Ooooh, one of my pet peeves and you guys just keep pushing my buttons. :) There is no _good_ reason to force a user to type "www." on your URL. None. Period. If you require it, it's a geek thing, not a user thing. Of course, if you don't care about users, then that's another matter. jay PS - I usually don't make blanket statements like the above because as soon as I do someone comes back and proves me wrong. But in this case I'll gamble. :) ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> I know this may sound a little silly, but a lot of companies > like to force you to use the www alias for their websites. I can't believe that's done on purpose. About 1/3 of my traffic comes in without the www part. Do those companies think people will keep searching until they find the site? No, they'll probably go somewhere else. Why should you (a generic you, not a specific you) force the user to do something like that? Because you can? Because it makes you feel like a god? Because stupid users should know that if they want to access a site on the world wide web they should include www in the address? If I could make people come to my site by wishing I'd do that -- anything that gets the traffic to you faster and with less hassle is GOOD. Jay ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MOD math function?
Maybe I should have paid attention in math, but here is my problem. I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 / 4) has a remainder. For some reason, (40 MOD 4) does not seem to be working. jon ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
having to specify the "www." isn't all that silly what if a site is also running an ftp server gopher server, etc. for a domain then you'd want to force the www ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:06 PM To: CF-Talk Subject: RE: figleaf.com I know this may sound a little silly, but a lot of companies like to force you to use the www alias for their websites. so just "http://figleaf.com" will not open up.. you should use "http://www.figleaf.com" Least, thats how it is from here, YMMV Jeremy Allen elliptIQ Inc. >-Original Message- >From: Dylan Bromby [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 27, 2000 1:59 PM >To: CF-Talk >Subject: RE: figleaf.com > > >working fine from here. > >-Original Message- >From: Jay Patton [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 27, 2000 10:57 AM >To: CF-Talk >Subject: figleaf.com > > >Hey Dave, >Whats up with figleaf.com? i wanted to play some smackdown durring >lunch and >the site wont come up? > >Jay Patton >Web Pro USA >406.549.3337 ext. 203 >1.888.5WEBPRO >www.webpro-usa.com > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
I know this may sound a little silly, but a lot of companies like to force you to use the www alias for their websites. so just "http://figleaf.com" will not open up.. you should use "http://www.figleaf.com" Least, thats how it is from here, YMMV Jeremy Allen elliptIQ Inc. >-Original Message- >From: Dylan Bromby [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 27, 2000 1:59 PM >To: CF-Talk >Subject: RE: figleaf.com > > >working fine from here. > >-Original Message- >From: Jay Patton [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 27, 2000 10:57 AM >To: CF-Talk >Subject: figleaf.com > > >Hey Dave, >Whats up with figleaf.com? i wanted to play some smackdown durring >lunch and >the site wont come up? > >Jay Patton >Web Pro USA >406.549.3337 ext. 203 >1.888.5WEBPRO >www.webpro-usa.com > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
> Hey Dave, > Whats up with figleaf.com? i wanted to play some smackdown > durring lunch and the site wont come up? www.figleaf.com comes up for me, but figleaf.com does not. Probably just an oversight, if it's a DNS thing. -ron ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: figleaf.com
yeah its up now thanks Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: "Dylan Bromby" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 11:59 AM Subject: RE: figleaf.com > working fine from here. > > -Original Message- > From: Jay Patton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 10:57 AM > To: CF-Talk > Subject: figleaf.com > > > Hey Dave, > Whats up with figleaf.com? i wanted to play some smackdown durring lunch and > the site wont come up? > > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
try http://www.figleaf.com/smackdown/splash.cfm -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 1:57 PM To: CF-Talk Subject: figleaf.com Hey Dave, Whats up with figleaf.com? i wanted to play some smackdown durring lunch and the site wont come up? Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT Flash Uplift... was Java Letdown
A while ago I posted an item of how disappointed I was with Java as a cross-browser/cross platform client-side solution to augment html and JavaScript. What I am trying to accomplish is a form for content editing that includes several textarea-like input fields where the user can create/display WYSWIG text (multiple font faces, styles, sizes, colors, etc.) Dave Watts, the elder, &-)> pointed me in the direction of Flash 5. Thanks Dave! I have been fooling around with a trial version... Flash is great, if a little difficult to learn (at least for my purposes). I haven't completely figured out the textarea solution (its still WYGIWYW) but i can see that a solution is possible: Flash allows you to detect/manipulate the *selection* in a textarea A Flash textarea honors some html tags , , etc. So, though I haven't done it yet, it can be done. An added (unheralded) benefit of Flash is in the use of forms. When you submit a page containing a Flash form, CF gets the variables as expected. What is different is that when you send data back to the Flash page. You don't need to send the entire page of static html/Flash and dynamic variables. You just send the variables you want to change in name/value pairs ala a URL. For example: Field1=#Field1#&Field2=Whatever&Field2=Happens will refresh only the content of Fields 1-3 in the form... the entire form is *not* redisplayed. Great potential savings in bandwidth & improvement in performance! Not only that, you get great looking forms, buttons, etc. Animation/sound/graphics are an added bonus. Anyway, I am jazzed... in the same way I was when I first found CF. Anyone know of a good book or tutorial of how to interface CF & Flash? If none, anyone of the excellent authors out there interested in writing one? TIA Dick ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
working fine from here. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 10:57 AM To: CF-Talk Subject: figleaf.com Hey Dave, Whats up with figleaf.com? i wanted to play some smackdown durring lunch and the site wont come up? Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: figleaf.com
I just checked the site and it looks completely different. I bet you hit it during the update. What I _really_ want to know is the name of the techno song used during the intro??? :> === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Jay Patton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 27, 2000 1:57 PM > To: CF-Talk > Subject: figleaf.com > > > Hey Dave, > Whats up with figleaf.com? i wanted to play some smackdown > durring lunch and the site wont come up? > > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
figleaf.com
Hey Dave, Whats up with figleaf.com? i wanted to play some smackdown durring lunch and the site wont come up? Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMail error
Can someone help me out? What the heck does the following cfmail error mean? unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (79:1) to (79:121) in the template file Thanks Jason Larson [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
there isn't a known problem nesting CFIFs if that's what you mean. do this: try placing some characters (i use x's) around the CF statements and see if they even show up when you execute the page. if the x's don't show then the statement they surround isn't being processed. with some debugging, i'm sure you'll figure it out. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:40 AM To: CF-Talk Subject: RE: CFIF not working The thing is with the ZIP1.zip and ZIP2.zip if they are the same it sets a zero value which is good, then it loops again so when they are different is when it goes to the formula section. So once it is in the formula section that is where I am having a problem. CF is acting as though it doesn't even exist. Is there a known problem with nesting these? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:23 PM To: CF-Talk Subject: RE: CFIF not working maybe try: 1) make sure your ZIP1.zip and ZIP2.zip are values you expect 2) use TYPE=ANY in CFCATCH just to make sure you're not missing some error -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:13 AM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
Ok got it working this is what I had to do: notice where bob = formula + 1 so it should be 2. Which is saying the same thing as formula eq 1 but it works so I am happy. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:40 PM To: CF-Talk Subject: RE: CFIF not working The thing is with the ZIP1.zip and ZIP2.zip if they are the same it sets a zero value which is good, then it loops again so when they are different is when it goes to the formula section. So once it is in the formula section that is where I am having a problem. CF is acting as though it doesn't even exist. Is there a known problem with nesting these? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:23 PM To: CF-Talk Subject: RE: CFIF not working maybe try: 1) make sure your ZIP1.zip and ZIP2.zip are values you expect 2) use TYPE=ANY in CFCATCH just to make sure you're not missing some error -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:13 AM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
you might try using IS or IS NOT in place of EQ or NEQ respectively if you're not dealing with integers...at least to see if that will process. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:55 AM To: CF-Talk Subject: RE: CFIF not working Ok here is what I have found. isnumeric(formula) is yes, there are no space, puttin an is in there doesn't help it. But everytime it skips it. I changed it to cfscript to see if that would help it, it hasn't. What the heck could be causing that code to mess up. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:40 PM To: CF-Talk Subject: RE: CFIF not working The thing is with the ZIP1.zip and ZIP2.zip if they are the same it sets a zero value which is good, then it loops again so when they are different is when it goes to the formula section. So once it is in the formula section that is where I am having a problem. CF is acting as though it doesn't even exist. Is there a known problem with nesting these? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:23 PM To: CF-Talk Subject: RE: CFIF not working maybe try: 1) make sure your ZIP1.zip and ZIP2.zip are values you expect 2) use TYPE=ANY in CFCATCH just to make sure you're not missing some error -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:13 AM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
Are you able to covert that number before it is returned exp (number), so that you never encounter the error, or would this totally ruin the results? I would wrap some conditional logic around that portion of processing that traps errors when you are returned a number with E in it (either before it becomes exponential or after with a stringcontains function. Other than that I don't know I am new at this, maybe a more experienced developer would know the answer right away. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:27 PM To: CF-Talk Subject: RE: CFIF not working Yes positive, see the thing is it goes to the next part, it calculates the formula thing is when formula eq 1 it gives me a floating point integer with an E in it and CF sees this as an error since an e isn't numeric. The author of the tag knew this which is why it skips it if it is a 1, but it isn't skipping thereby causing an error. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Andrew Middleton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:19 PM To: CF-Talk Subject: RE: CFIF not working Sounds like your problem is in the evaluation of the expression , are you sure that ZP1.zip and ZP2.zip are returning values? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:13 PM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
Ok here is what I have found. isnumeric(formula) is yes, there are no space, puttin an is in there doesn't help it. But everytime it skips it. I changed it to cfscript to see if that would help it, it hasn't. What the heck could be causing that code to mess up. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:40 PM To: CF-Talk Subject: RE: CFIF not working The thing is with the ZIP1.zip and ZIP2.zip if they are the same it sets a zero value which is good, then it loops again so when they are different is when it goes to the formula section. So once it is in the formula section that is where I am having a problem. CF is acting as though it doesn't even exist. Is there a known problem with nesting these? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:23 PM To: CF-Talk Subject: RE: CFIF not working maybe try: 1) make sure your ZIP1.zip and ZIP2.zip are values you expect 2) use TYPE=ANY in CFCATCH just to make sure you're not missing some error -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:13 AM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
The thing is with the ZIP1.zip and ZIP2.zip if they are the same it sets a zero value which is good, then it loops again so when they are different is when it goes to the formula section. So once it is in the formula section that is where I am having a problem. CF is acting as though it doesn't even exist. Is there a known problem with nesting these? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:23 PM To: CF-Talk Subject: RE: CFIF not working maybe try: 1) make sure your ZIP1.zip and ZIP2.zip are values you expect 2) use TYPE=ANY in CFCATCH just to make sure you're not missing some error -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:13 AM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
Yes positive, see the thing is it goes to the next part, it calculates the formula thing is when formula eq 1 it gives me a floating point integer with an E in it and CF sees this as an error since an e isn't numeric. The author of the tag knew this which is why it skips it if it is a 1, but it isn't skipping thereby causing an error. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Andrew Middleton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:19 PM To: CF-Talk Subject: RE: CFIF not working Sounds like your problem is in the evaluation of the expression , are you sure that ZP1.zip and ZP2.zip are returning values? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:13 PM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: it wont loop back!....
This should help: - Original Message - From: "Jay Patton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 11:48 AM Subject: it wont loop back! > here is my problem, when the code below gets ran it runs fine all accept when it gets to the end of the list of images it keeps going with blank pages with just a back and next button. my question is how do i get it to loop back to the beginning of the list when it gets to the end or last image? can anyone help? ive been stuck on this for some time now > > datasource="catlingalleries" > dbtype="ODBC"> > Select * > >From ImageManager > > > > > Early Work > > > > > > Click Image to order and to view larger picture. > > > > > > > > #RealName# > > > > > Back | &nbs p;Next 8 > > > Thanks much, > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is it possible to use Rand() in a CFQUERY?
Well, I was thinking of other Query tags there, but I just now happened to notice one titled CF_QueryRandomize at: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34760F-2830-11D4-AA9700508B94F380&method=Full best, paul At 11:52 AM 12/27/00 -0500, you wrote: >How does one 'reorder the result query'? Seems like I would have to run a >query for each and every dealer every time and then randomly choose which >to output. > >> >>Some tags in the developer exchange might help on this. ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
maybe try: 1) make sure your ZIP1.zip and ZIP2.zip are values you expect 2) use TYPE=ANY in CFCATCH just to make sure you're not missing some error -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 9:13 AM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
sign me up. (note: token Dave Watts quote in Sig) Eric Dawson (various companies and projects) Looking for free beer really easy contracts and sleep Work hard, play harder! "You could try another approach." My token Dave Watts quote (just trying to fit in. :) From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: The +.htr bug strikes again Date: Wed, 27 Dec 2000 15:04:23 - > As far as being an "older" internet worker, how old do you think I am? I'm > kind of curious. I'll grant that I can be annoying and dull. Hey, I've met Dave and I have no idea how old he is... I respect him because of his knowledge, not because he's older than me (he probably isn't, but there you go) - we're not saying respect him because he's older than you, but listen to him because he probably knows a damn site more than most on this sort of topic... The queue for the "Dave Watts Fan Club" starts somewhere around here Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: showing up as gray Java block
> Do you know which classes are needed for the cfgrid applet? > Can the classes be placed anywhere in the URL space? You'll want all of the classes in the /cfide/classes directory to resolve correctly; different browsers may potentially use different files. You need to make sure that this URL resolves correctly: http://www.yourserver.com/cfide/classes/ Of course, you'll need to put your server name in. Also, you may well get an error about not being able to browse the directory. Here's a setup tip. You generally don't want to allow access to the CF Administrator through all your virtual servers, but you generally do want to be able to use the Java applets and the wddx.js file. The way I usually set this up is to have two CFIDE directories. The first one is placed within a secure virtual server used for administration, and it has the Administrator and Main subdirectories which are required by the CF Administrator and RDS, respectively. The second CFIDE directory is added to all the other virtual servers as a virtual directory, and only has the classes and scripts subdirectories. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
Sounds like your problem is in the evaluation of the expression , are you sure that ZP1.zip and ZP2.zip are returning values? -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 12:13 PM To: CF-Talk Subject: RE: CFIF not working Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: it wont loop back! Thanks
Thank you Johan it works great. Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: "Johan Coens" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 10:16 AM Subject: RE: it wont loop back! > try > > > href="javascript:history.go(-1)">Back | &nbs > p; > > > > Next 8 > > > Best regards, > Johan Coens > > -Original Message- > From: Jay Patton [mailto:[EMAIL PROTECTED]] > Sent: woensdag 27 december 2000 17:48 > To: CF-Talk > Subject: it wont loop back! > > > here is my problem, when the code below gets ran it runs fine all accept > when it gets to the end of the list of images it keeps going with blank > pages with just a back and next button. my question is how do i get it to > loop back to the beginning of the list when it gets to the end or last > image? can anyone help? ive been stuck on this for some time now > > datasource="catlingalleries" > dbtype="ODBC"> > Select * > >From ImageManager > > > > > Early Work > > > > > >color="White">Click Image to order and to view larger picture. > > > > > >color="White"> src="ImageManager/WebImages/#GetImages.ImageName#" > border="0"> > >color="White">#RealName# > > > >color="White"> > href="javascript:history.go(-1)">Back | &nbs > p;Next 8 > > > Thanks much, > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF not working
Tried that, didn't work either. It's as though the cfif that is nested isn't working at all. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:20 AM To: CF-Talk Subject: Re: CFIF not working instead of use - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 27, 2000 8:08 AM Subject: CFIF not working > Can anyone see as to why the cfif after the cfelse wouldn't be working. I > am using cf_ziprad which was purchased, and I can not get those cfif's to > work. Formula is 1 and it won't set miles to 0 which of course erros > everyhting out. I am using 4.5.1 sp1 > > > > > > > > * COS(ZP2.lat) * COS(ZP2.lon - ZP1.lon)> > > > formula + 1)) + 2 * ATN(1))> > > > > > > > > > > > Robert Everland III > Web Developer > Dixon Ticonderoga > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
