CFMAIL query

2005-07-05 Thread Parker, Kevin
Can anyone advise me when the replyto attribute was introduced into CFMAIL, Ver 5, 6 or 7. TIA! ++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ **

Re: Ebay SOAP API

2005-07-05 Thread Prem Bhawnani
Hi Umer, I'm just getting my hands dirty with this stuff.. I'm using Cold Fusion MX 6.1. Running the same code with my own auth headers, causes the JRun server to crash. It seems like the first line itself. Any idea what's causing this? Prem > Just an update.. got it working.. needed a good ni

Re: find_string in db

2005-07-05 Thread James Holmes
That's unlikely to work in Oracle ;-) On 7/6/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote: > Daniel, > > Included below is a stored procedure that you can use to search any or all > columns in all tables. ~| Find out how CFTi

RE: Query help

2005-07-05 Thread Dave Watts
> Personally, I'm not very versed in execution plans, but how > would the query shown result in 2 execution plans? There were two queries in my example. Both were identical save for the literal value of emp.id. I suspect that the methods used by various databases to determine whether execution pl

1&1 dedicated hosting for CF apps

2005-07-05 Thread Rey Bango
Has anyone used 1&1 dedicated hosting for CF apps? I'm contemplating getting a dedicated server over there for my CF apps and wanted to get impressions and experiences. Rey... -- http://www.ReyBango.com ~| Find out how CFTic

RE: Jrun connection closing for no reason

2005-07-05 Thread Russ
I think we've had a similar issue (basically server was dying under heavy load.) Still not sure what it was, but we've tightened up some code (put in some CFLOCKS, and patched to the latest cf version, MX 6.1, updater 1 and a few hotfixes (I believe one of them is CF stops responding to requests).

RE: Query help

2005-07-05 Thread Russ
Personally, I'm not very versed in execution plans, but how would the query shown result in 2 execution plans? Where can I read up more about this? Russ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 7:53 PM To: CF-Talk Subject: RE: Query help

RE: Oh..my...god!

2005-07-05 Thread Ben Forta
Wow, deep, and I thought it was just a cupcake. I'm going to forward your insight to the design team. :-) --- Ben -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 11:23 PM To: CF-Talk Subject: RE: Oh..my...god! > -Original Message- > Fr

RE: Oh..my...god!

2005-07-05 Thread Jim Davis
> -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 05, 2005 11:03 PM > To: CF-Talk > Subject: RE: Oh..my...god! > > Ok, I am laughing so hard that I just have to share this one with you ... > > When that banner was created by our graphics guys they circ

RE: Oh..my...god!

2005-07-05 Thread Ben Forta
Ok, I am laughing so hard that I just have to share this one with you ... When that banner was created by our graphics guys they circulated it to several of us for review. I liked it, I thought it was simple and elegant and kinda classy. Others felt the same way. But one reviewer commented saying

RE: Oh..my...god!

2005-07-05 Thread Jim Davis
> -Original Message- > From: Connie DeCinko [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 05, 2005 7:02 PM > To: CF-Talk > Subject: RE: Oh..my...god! > > Hey, why does none of the confetti fall upon the cupcake? Is that a > conspiracy too? And why does ColdFusion only get a cupcake? A

RE: Query help

2005-07-05 Thread Dave Watts
> You're right. Maybe the example SQL I gave was not a good one. The > bottom line is, whenever you have a "static SQL" that does not change > across your application, using bind variables in that SQL (through > cfqueryparam) is not necessary. That's my understanding. I think your understanding is

Re: Jrun connection closing for no reason

2005-07-05 Thread Jennifer Larkin
I've encountered this error when the server is in the process of starting and when the database is internally deadlocked. Not sure if that helps. On 6/30/05, Andy Jarrett <[EMAIL PROTECTED]> wrote: > Hi there, > > at the moment we are getting a few of the following errors > > Server Error > The

Re: Query help

2005-07-05 Thread Eddie
On 7/5/05, Dave Watts <[EMAIL PROTECTED]> wrote: > In this particular case, viewed alone, there's no reason to do this. > However, you might have another query somewhere else like this: > > select emp.name, emp.salary > from emp > where emp.id = 325 > > I think this would generally result in two

Re: Oh..my...god!

2005-07-05 Thread S . Isaac Dealey
The combination of ColdFusion and the placement of the MM home page banner ad... There have been continual occasional complaints from people on the mailing lists that these two things never coincide, even when the "best" Macromedia can produce in terms of non-CF related banners for their home page

RE: securing WSDL files

2005-07-05 Thread Dave Watts
> OK...so you need the Admin or RDS password to view a WSDL > file...makes sense... > > The situation I find myself in is that remote developers will > need access to the WSDL files, but giving them the CF Admin > password is not an optionand RDS is pretty insecure...so > I'd prefer to lea

RE: Query help

2005-07-05 Thread Dave Watts
> Right, but my point was that if you did not pass variables into your > cfquery, why would you need a cfqueryparam? for example, consider this > select statement: > > select emp.name, emp.salary > from emp > where emp.id = 324 > > would you use a cfqueryparam in the above query? like this: > >

Re: Oh..my...god!

2005-07-05 Thread Mike Tangorre
Connie DeCinko wrote: > Hey, why does none of the confetti fall upon the cupcake? Is that a > conspiracy too? And why does ColdFusion only get a cupcake? After ten > years, you'd think it would desert at least a regular size cake! If you were at CFUNITED you could have had a nice piece of the C

RE: Query help

2005-07-05 Thread Ian Skinner
When I posed this question to the group some time ago, the consensus was basically your point, but the one counter point the struck me was, "well it's not a variable now, but might it become one in the future?" So, depends on how malleable you feel the code may be over its lifetime. -

Re: Query help

2005-07-05 Thread Eddie
On 7/5/05, Russ <[EMAIL PROTECTED]> wrote: > I believe SQL (and probably oracle) will cache the execution path if you > use a cfqueryparam.. Right, but my point was that if you did not pass variables into your cfquery, why would you need a cfqueryparam? for example, consider this select statement

Re: Oh..my...god!

2005-07-05 Thread Matt Robertson
On 7/5/05, Mike Soultanian <[EMAIL PROTECTED]> wrote: > What's weird about it? Nothing. There was just a kind of zany thread here a few months back about CF banners on the home page of MM.com. One of those 50-post jihads that was a real head-shaker at the time :D . Lacking all discipline on a q

RE: Oh..my...god!

2005-07-05 Thread Connie DeCinko
Hey, why does none of the confetti fall upon the cupcake? Is that a conspiracy too? And why does ColdFusion only get a cupcake? After ten years, you'd think it would desert at least a regular size cake! ~| Logware (www.logwa

Re: Oh..my...god!

2005-07-05 Thread Mike Soultanian
What banner are you talking about? The one with the cupcake? What's weird about it? mike Matt Robertson wrote: > Guess whats on the home page of macromedia.com A ColdFusion banner! > > I can't wait to hear all of the dire predictions this will stir up. > Here's mine: Macromedia was taken ov

Re: Oh..my...god!

2005-07-05 Thread Ray Champagne
Yea, Ben blogged about this the other day. I thought it was pretty cool. http://forta.com/blog/index.cfm?mode=e&entry=1673 Bryan Stevenson wrote: > I was wondering who would be the first to bring this uplet the games > begin and the thread banning that shall soon follow ;-) > > Cheers > >

OT: hosted Exchange/Blackberry/Sharepoint

2005-07-05 Thread Russ
Hi all, Can anyone suggest any good providers for hosted Exchange with Blackberry Enterprise Server 4.0 functionality that also offers sharepoint? I've seen a couple, but so far only one sticks out that provides all 3, and that's intermedia. Has anyone had any experience working with them?

RE: Query help

2005-07-05 Thread Russ
I believe SQL (and probably oracle) will cache the execution path if you use a cfqueryparam.. -Original Message- From: Eddie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 5:51 PM To: CF-Talk Subject: Re: Query help On 7/5/05, Jann E. VanOver <[EMAIL PROTECTED]> wrote: > AND is

Re: Oh..my...god!

2005-07-05 Thread Bryan Stevenson
I was wondering who would be the first to bring this uplet the games begin and the thread banning that shall soon follow ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail

Oh..my...god!

2005-07-05 Thread Matt Robertson
Guess whats on the home page of macromedia.com A ColdFusion banner! I can't wait to hear all of the dire predictions this will stir up. Here's mine: Macromedia was taken over by aliens and this banner is proof that some insidious, as-yet-unknown plot is afoot. :D -- --mattRobertson-- Janitor

Re: securing WSDL files

2005-07-05 Thread Bryan Stevenson
Thanks Kamthat would do the trick to a certain degree (I may not be able to reply on outside folks being able to parse the XMLno matter how simple it is...hehe). Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 f

RE: securing WSDL files

2005-07-05 Thread Figy, Kam
Add ?wsdl to the CFC URL; e.g. http://your.server/foo.cfc?wsdl It's raw XML, but there are a large number of parsers out there. You only need the CFAdmin/RDS passwords to use the CFC explorer, which displays methods that are not marked remote. /k -Original Message- From: Bryan Stevenson

securing WSDL files

2005-07-05 Thread Bryan Stevenson
Hey All, OK...so you need the Admin or RDS password to view a WSDL file...makes sense... The situation I find myself in is that remote developers will need access to the WSDL files, but giving them the CF Admin password is not an optionand RDS is pretty insecure...so I'd prefer to leave tha

Re: Query help

2005-07-05 Thread Eddie
On 7/5/05, Jann E. VanOver <[EMAIL PROTECTED]> wrote: > AND isNull(cs_price,'') <> value=""> Why would you want to use in this case? since there is no "query parameter" here, just a literal value ("" or NULL). -- Eddie. http://awads.net/ ~~

Re: Query help

2005-07-05 Thread Jann E. VanOver
Eddie wrote: >On 7/5/05, Daniel Kessler <[EMAIL PROTECTED]> wrote: > > >>an empty string. So I've adjusted the query so that if the store = >>'convenience' then the price must not equal empt string. >> >>AND cs_price <> >> >> > >AND cs_price IS NOT NULL > > > or as I often co

Re: Coldfusion Crashing!

2005-07-05 Thread Matt Robertson
The issues Jennifer and Steven brought up were pretty much spot on. If you have something hanging a request and you pile on simultaneous requests that will do nothing to address the bottleneck. I would do things a little differently but the same basic principles apply. First of all, I'm going to

Re: OT: SQL COUNT Help

2005-07-05 Thread Jochem van Dieten
Charles Heizer wrote: > No, the database is Oracle. Well, oid is a system column in PostgreSQL that is often used as a primary key. Hence my idea you were using PostgreSQL. Jochem ~| Find out how CFTicket can increase your comp

Re: Query help

2005-07-05 Thread Eddie
On 7/5/05, Daniel Kessler <[EMAIL PROTECTED]> wrote: > an empty string. So I've adjusted the query so that if the store = > 'convenience' then the price must not equal empt string. > > AND cs_price <> AND cs_price IS NOT NULL -- Eddie. http://awads.net/ ~~~

Re: OT: SQL COUNT Help

2005-07-05 Thread Charles Heizer
No, the database is Oracle. I just tried what you suggested and it works great! Thanks! On 7/5/05 1:09 PM, "Jochem van Dieten" <[EMAIL PROTECTED]> wrote: > Charles Heizer wrote: >> >> SELECT >> COUNT(a.userid) AS Localusers, >> (COUNT(a.winadmingroup) = 'YES') AS IsAdmin, >> a.userid >>

Re: Query help

2005-07-05 Thread daniel kessler
>Have you tried > >AND cs_price != '' I did and then went to be sure it was ok. I found a note saying that it was ok in some implementations of sql and they recommended the < > so I adjusted to that with no change. I just tried it again with no change, dangit. ~~

Re: Proper way to refer to form objects

2005-07-05 Thread Adam Haskell
> query > arguments > variables (local) > CGI > URL > form > cookie > client its a little screwy inside of a loop If you are pushing to the output stream query takes top spot but if you are inside of a cfset variables (maybe arguments) takes top spot. Its a little wacky so its always good to jus

Re: Query help

2005-07-05 Thread Charles Heizer
Have you tried AND cs_price != '' On 7/5/05 12:57 PM, "Daniel Kessler" <[EMAIL PROTECTED]> wrote: > I am on Oracle and I'm trying to do a fairly simple query and I just > don't see the problem with it. I've stared now for way to long. > > I am trying to differentiate between grocery store

Re: Coldfusion Crashing!

2005-07-05 Thread Douglas Knudsen
seefusion works on cfmx though, this is a CF5 issue for shahzad DK On 7/5/05, Russ <[EMAIL PROTECTED]> wrote: > > I can't believe nobody's mentioned SeeFusion yet... It's not perfect (if > the > server crashes, you don't really know what happened, although I believe > the > enterprise version

Re: find_string in db

2005-07-05 Thread Chris Terrebonne
Daniel, Included below is a stored procedure that you can use to search any or all columns in all tables. Once you have installed the SP, call it as follows: exec spDBSearch @value='MySearchString' You can also specify a specific column, table or datatype. Let me know if you have any questio

Re: OT: SQL COUNT Help

2005-07-05 Thread Jochem van Dieten
Charles Heizer wrote: > > SELECT > COUNT(a.userid) AS Localusers, > (COUNT(a.winadmingroup) = 'YES') AS IsAdmin, > a.userid > > FROM #Session.Schema#.r_localuserlist a, #Session.Schema#.adminsubnet b > > WHERE replace(a.userid,'_','~') like replace(b.subnet,'_','~') and > b.o

Query help

2005-07-05 Thread Daniel Kessler
I am on Oracle and I'm trying to do a fairly simple query and I just don't see the problem with it. I've stared now for way to long. I am trying to differentiate between grocery store items and convenience store items and this is done by the cs_price column being an empty string. So I've adju

Cannot disable JSP functionality for CFMX 7

2005-07-05 Thread wolf2k5
Hi, I am running ColdFusion MX 7 (server configuration) on Red Hat Enterprise Linux 3 with Apache 2. I was running ColdFusion MX 6.1, before the upgrade to version 7 this week, and Tomcat was processing JSP files just fine (since I disabled the JSP functionality for CFMX 6.1). After the upgrade

RE: Coldfusion Crashing!

2005-07-05 Thread Russ
I can't believe nobody's mentioned SeeFusion yet... It's not perfect (if the server crashes, you don't really know what happened, although I believe the enterprise version supports odbc logging). The nice thing about it though is that you can go to a page that lists all your running CF pages, and

RE: Altering db causes error with perpaired statements

2005-07-05 Thread S . Isaac Dealey
> Lol - boy that wasen't so bad > Thanks isaac Glad to help. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~

Re: find_string in db

2005-07-05 Thread daniel kessler
>If it's something that's going to be done regularly, I'd look into >oracle's full text searches. (You're using oracle, right?) I am. >If you want to be lazy I'd do select * from mytable in a cfquery, then >dump myquery.columnlist, loop through that and and build your like >statements, then use t

Re: OT: SQL COUNT Help

2005-07-05 Thread Charles Heizer
Opps, I did not notice during my copy I did not include the filter. The adminsubnet table is to filter based on who has rights to a subnet. - Charles SELECT COUNT(a.userid) AS Localusers, (COUNT(a.winadmingroup) = 'YES') AS IsAdmin, a.userid FROM #Session.Schema#.r_localuserlist a, #S

Re: OT: SQL COUNT Help

2005-07-05 Thread Jochem van Dieten
Charles Heizer wrote: > > I have a table which contains local user info short name and uid and if it's > an admin account. > > SELECT > COUNT(a.userid) AS Localusers, > (COUNT(a.winadmingroup) = 'YES') AS IsAdmin, > a.userid > FROM #Session.Schema#.r_localuserlist a, #Session.Schema#.adminsubne

Re: OT: SQL COUNT Help

2005-07-05 Thread Charles Heizer
When I do this it it only returns a total of 2 even for the local users. - charles On 7/5/05 12:21 PM, "Qasim Rasheed" <[EMAIL PROTECTED]> wrote: > Have you tried something like this > > > SELECT > COUNT(a.userid) AS Localusers, > COUNT(a.winadmingroup) AS IsAdmin, > a.userid > > FROM #Sessi

RE: Altering db causes error with perpaired statements

2005-07-05 Thread gabriel l smallman
Lol - boy that wasen't so bad Thanks isaac gabe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 3:17 PM To: CF-Talk Subject: Re: Altering db causes error with perpaired statements > This has long irk'd me without a simple solution. When

Re: OT: SQL COUNT Help

2005-07-05 Thread Qasim Rasheed
Have you tried something like this SELECT COUNT(a.userid) AS Localusers, COUNT(a.winadmingroup) AS IsAdmin, a.userid FROM #Session.Schema#.r_localuserlist a, #Session.Schema#.adminsubnet b WHERE b.oid like '#Session.Username#' and a.winadmingroup = 'YES' group BY a.userid On 7/5/05, Charles

Re: Altering db causes error with perpaired statements

2005-07-05 Thread S . Isaac Dealey
> This has long irk'd me without a simple solution. When > altering the db (add > column) all the queries with prepared statements (aka > cfqueryparam) that > touch that table will toss an error about data types not > right. Hey Gabe... The simple solution (you'll love this) is to disable the stat

OT: SQL COUNT Help

2005-07-05 Thread Charles Heizer
Hello, I'm trying to do a count and I have never needed to really do this before, so here it goes. I have a table which contains local user info short name and uid and if it's an admin account. SELECT COUNT(a.userid) AS Localusers, (COUNT(a.winadmingroup) = 'YES') AS IsAdmin, a.userid

RE: Coldfusion Crashing!

2005-07-05 Thread Connie DeCinko
Could this be a case of a DoS attempt? Have you tried taking the server offline for awhile? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on

Re: Coldfusion Crashing!

2005-07-05 Thread Jennifer Larkin
Not to disagree greatly with someone who clearly knows what he's talking about better than I do, but there are some problems in tracing log running requests through the log in CF 5. One problem is that if the requests get killed by the "restart after x unresponsive requests" they don't show up in t

Altering db causes error with perpaired statements

2005-07-05 Thread gabriel l smallman
This has long irk'd me without a simple solution. When altering the db (add column) all the queries with prepared statements (aka cfqueryparam) that touch that table will toss an error about data types not right. Now that is expected, but purging them is the trick. As of right now the only way I

Re: Coldfusion Crashing!

2005-07-05 Thread Steven Erat
On 7/5/05, Connie DeCinko <[EMAIL PROTECTED]> wrote: > Also check for a hung outgoing email message. This was a big problem in > CF5. Or a zero length email. > ColdFusion 4.5.1 SP2, specifically, had the problem where memory corruption (usually traced back to no locking or improper locking of s

Re: Coldfusion Crashing!

2005-07-05 Thread Steven Erat
On 7/5/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > Looks like your system has reached the maximum # of simultaneous requests - > try upping it via the CFIDE. This is almost never the appropriate solution to "Request canceled or ignored by server Server busy or unable to fulfill requ

Re: CF 7 Server Startup question

2005-07-05 Thread Steven Erat
On 7/5/05, Burns, John D <[EMAIL PROTECTED]> wrote: > I have a dev copy of CF 7 running > to it. The strange thing (in my opinion) is that CF actually wouldn't > start and the error that i saw in the logs was that it couldn't connect > to the DB (because the desktop app was open and had a co

RE: Coldfusion Crashing!

2005-07-05 Thread Connie DeCinko
Also check for a hung outgoing email message. This was a big problem in CF5. Or a zero length email. -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 7:42 AM To: CF-Talk Subject: Re: Coldfusion Crashing! take a look at your logs for long

Re: receive a raw xml post?

2005-07-05 Thread Steven Erat
On 7/5/05, Anthony Prato <[EMAIL PROTECTED]> wrote: > (MX7/Win2K/IIS) > There are a number of ways to post XML over http, such as the MSXML > object. How can I setup a coldfusion page to receive these posts? To > my knowledge the xml comes in as a different content type (in > comparison to a standa

Re: receive a raw xml post?

2005-07-05 Thread Eddie
On 7/5/05, Anthony Prato <[EMAIL PROTECTED]> wrote: > There are a number of ways to post XML over http, such as the MSXML > object. How can I setup a coldfusion page to receive these posts? To consume XML posted to a CF page, use the CF function GetHttpRequestData() > On a side note, what is the

RE: receive a raw xml post?

2005-07-05 Thread Dave Watts
> (MX7/Win2K/IIS) > There are a number of ways to post XML over http, such as the MSXML > object. How can I setup a coldfusion page to receive these posts? To > my knowledge the xml comes in as a different content type (in > comparison to a standard form) so #Form.Somevar# won't work. In asp > you

receive a raw xml post?

2005-07-05 Thread Anthony Prato
(MX7/Win2K/IIS) There are a number of ways to post XML over http, such as the MSXML object. How can I setup a coldfusion page to receive these posts? To my knowledge the xml comes in as a different content type (in comparison to a standard form) so #Form.Somevar# won't work. In asp you would do thi

CFMX7 Server Log

2005-07-05 Thread Mark Leder
I have std edition running. Looking at the server.log, I keep getting this message: "Invalid/Incomplete Multicast Message Received" How do I stop this from occuring? Thanks, Mark ~| Find out how CFTicket can increase yo

Re: find_string in db

2005-07-05 Thread Deanna Schneider
If it's a 1 time request, I'd say just write the sql. If it's something that's going to be done regularly, I'd look into oracle's full text searches. (You're using oracle, right?) If you want to learn something new, you could probably write some pl/sql to look up the column names from the data d

RE: Recommendation - email list

2005-07-05 Thread Michael T. Tangorre
http://email.exacttarget.com/ http://www.bluehornet.com/site/index.htm?flash > From: Kurt Kaptein [mailto:[EMAIL PROTECTED] > Buy backend only ~| Find out how CFTicket can increase your company's customer support efficiency

RE: Recommendation - email list

2005-07-05 Thread Kurt Kaptein
Buy backend only Sincerely, Kurt Kaptein Spectrum Net Designs, Inc PO Box 806 Grandville, MI 49468 Toll Free: 866-773-2638 Fax: 616-538-5691 Website: www.spectrumnetdesigns.com Email: [EMAIL PROTECTED] Did you see our NEW website?? www.spectrumnetdesigns.com -Original Message-

Re: Recommendation - email list

2005-07-05 Thread Michael Dinowitz
Do you want to buy or roll your own? Do you want backend only or public archives? > some important things > > 1 multiple lists > 2. auto dedupe before sending > 3. easy editor > 4. scalable to 50,000 users > > Any suggestions > > Sincerely, > > Kurt Kaptein > Spectrum Net Designs, Inc > PO Box

RE: Recommendation - email list

2005-07-05 Thread Michael T. Tangorre
> From: SStewart [mailto:[EMAIL PROTECTED] > http://www.realmagnet.com I hope that was a joke! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/vi

RE: Recommendation - email list

2005-07-05 Thread SStewart
http://www.realmagnet.com Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Kurt Kaptein [mailto:[EMAIL PROTECTED] Sent: W

CF 7 Server Startup question

2005-07-05 Thread Burns, John D
I have a dev copy of CF 7 running on a small server that I am using to test some things out before upgrading to 7. I had a strange problem the other day and when I found the problem, I was thoroughly confused. I have a small web app (2 or 3 pages) that just queries some data from an access databa

Recommendation - email list

2005-07-05 Thread Kurt Kaptein
some important things 1 multiple lists 2. auto dedupe before sending 3. easy editor 4. scalable to 50,000 users Any suggestions Sincerely, Kurt Kaptein Spectrum Net Designs, Inc PO Box 806 Grandville, MI 49468 Toll Free: 866-773-2638 Fax: 616-538-5691 Website: www.spectrumnetdesigns.

Re: Proper way to refer to form objects

2005-07-05 Thread Aaron Rouse
If it could possibly come in through some other scope then probably best to always copy it in from where it could come from and then reference that. For instance we have some pages that can refer to variables from the Form or URL scope. So we do something like this: http://Form.ID>" default="0

Re: Proper way to refer to form objects

2005-07-05 Thread Claude Schneegans
>>#form.email# or #email# >>Are they interchangeable? If you use the first, it will work only if values are passed from a form, if it is the case, it will be more efficient. With the second option, the template can also accept values passed in the URL, which can be useful in some cases. -- _

RE: Spam:Re: Proper way to refer to form objects

2005-07-05 Thread Robert Redpath
Very helpful - Thanks to all From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tue 7/5/2005 12:18 PM To: CF-Talk Subject: Spam:Re: Proper way to refer to form objects if you don't scope a variable, you force CF to have to 'hunt' through the various scopes t

Re: CF & Localization

2005-07-05 Thread Claude Schneegans
>>Structure... use a structure... much better to have Probabily; my code comes from old times when CF didn't have structures. But it still works. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any

Re: Proper way to refer to form objects

2005-07-05 Thread Charlie Griefer
if you don't scope a variable, you force CF to have to 'hunt' through the various scopes to find a variable with the given name. this is generally considered to be a bad practice, as it's less efficient than explicitly scoping the variable (thus telling CF exactly where to look), and you could end

RE: Proper way to refer to form objects

2005-07-05 Thread Michael T. Tangorre
> From: Robert Redpath [mailto:[EMAIL PROTECTED] > What is the proper way to refer to form objects? > > #form.email# or #email# > > Are they interchangeable? Can I call use name="form.email" default="">, but still refer to it as #email#? The proper way is to always scope your variables, so

Re: Proper way to refer to form objects

2005-07-05 Thread Joe Rinehart
Bob, You should always address it as "form.email" - ColdFusion will search various scopes (url, form, cookie, etc.) looking for something named "email," but it's likely you'll eventually wind up with something different than you expect if both url.email and form.email exist ;) -Joe On 7/5/05, R

Re: CF & Localization

2005-07-05 Thread S . Isaac Dealey
> >>I suppose I could set a language session variable > Yeah, better than in a database. Use text files with lines > of text, one > file for English, one for French. > However, just put the language in the session variable, > ie. the index of > the language, and put all strings > in an array in a

Proper way to refer to form objects

2005-07-05 Thread Robert Redpath
What is the proper way to refer to form objects? #form.email# or #email# Are they interchangeable? Can I call use , but still refer to it as #email#? Many thanks, Bob ~| Logware (www.logware.us): a new and convenient

CF connecting to datasource problem (SQL)

2005-07-05 Thread Stuart Kidd
Hi guys, I've set up a servder in sql called mytest and have the sql server running in my services.  I am having a problem connecting the datasource in CF Administrator. The error i'm getting back is: Connection verification failed for data source: user020 java.sql.SQLException: [Macrome

RE: Developer's edition of MS-SQL with CFMX7

2005-07-05 Thread Damien McKenna
Its also worth mentioning that MS SQL Server 2005 will have an "Express" edition for IIRC circa $50 that *will* include some sort of Enterprise Manager-alike tool. Go take a look on MS's site for beta downloads. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.

Re: find_string in db

2005-07-05 Thread Claude Schneegans
>>This is a one-time request to see if any bad data was entered during the updating process. Ah okaaay, excuse me for the "bad design" ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam

Re: find_string in db

2005-07-05 Thread daniel kessler
>If you really have to do this, I would say that the database was very poorly >designed >at the first place. The database was not poorly designed or rather it may be but this request does not show it. This is a one-time request to see if any bad data was entered during the updating process.

Re: cfdocument and page orientation

2005-07-05 Thread mike hanson
Thanks for that. What I need to do is a number of pages in one orientation, change to the other and then change back depending on the output. This would create a single document with some landscape pages and some portrait. Mike ~~~

Re: Coldfusion Crashing!

2005-07-05 Thread Douglas Knudsen
take a look at your logs for long running requests too. Possibly you have some page running long SQL queries causing all your threads to back up. DK On 7/5/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > Go higher - if you open up a windows performance monitor and look at what > t

Re: find_string in db

2005-07-05 Thread Claude Schneegans
>>I can loop through the columnList with a set of LIKE commands, but is >>there a way to search all columns without making 50 LIKE commands? If you really have to do this, I would say that the database was very poorly designed at the first place. However, you could try an SQL expression that wo

Re: CF & Localization

2005-07-05 Thread Claude Schneegans
>>I have never used UTF-8, just ISO-8859-1 If you only need French, or even any european laguage, and the rest of your data is not Unicode, don't bother with Unicode/UTF-8. Use ISO-8859-1 just as before. If you need many different languages supported by different ISO standards, or you already

Re: Server names

2005-07-05 Thread Larry Lyons
>On 6/29/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: >> You named your server Inferno? I name mine after philosophers... > >Transformers here :) > >OptimusPrime for internal... Megatron for the Windows hosting server... > >:) > >-- >Kay Smoljak >http://kay.smoljak.com/ Given that we are a bio

CFCHART in CFFORM

2005-07-05 Thread Mark Drew
Hi there I dont seem to be able to get a cfchart within a cfformgroup. I basically have a two tabs in a tabnavigator and in one of them I want to place a chart. Is this not possible? or do I just have to seek errors in my code? (which is minimal at the moment) Thanks in advance Mark Drew

find_string in db

2005-07-05 Thread Daniel Kessler
I have a table that has about 50 columns. I want to be able to search ALL columns for the string "***". I can loop through the columnList with a set of LIKE commands, but is there a way to search all columns without making 50 LIKE commands? -- Daniel Kessler Department of Public and Community

Re: CF & Localization

2005-07-05 Thread Claude Schneegans
>>I suppose I could set a language session variable Yeah, better than in a database. Use text files with lines of text, one file for English, one for French. However, just put the language in the session variable, ie. the index of the language, and put all strings in an array in an Application

Re: Developer's edition of MS-SQL with CFMX7

2005-07-05 Thread Saturday (Stuart Kidd)
Thanks to everyone for their help. I downloaded the one down below and somehow managed to get it to work and also downloaded sqlbuddy and got that working too. Now next i will try and get my ms-sql backup from my hosting company onto my machine and test it by setting a datasource with cfmx7!

Re: cfdocument and page orientation

2005-07-05 Thread Pete Ruckelshaus
I've been playing with cfdocument as well, trying to get around its shortcomings. It's a great addition to CF, but I sure hope that the first positive sign (for CF developers, at least) we see from the Adobe buyout will be greatly improved PDF generation. I know some have mentioned Section 508 co

Javascript prompt() and CF form processing question

2005-07-05 Thread Pete Ruckelshaus
On the project that I'm working on I want to allow users to select "folders" (think more along the lines of a shopping cart) that they can put "documents" into. The folder selection will be via a dropdown list. I also want to allow users to send documents to a new folder, and use JavaScript's pro

Re: cfdocument and page orientation

2005-07-05 Thread Matthew Blatchley
I've been playing with CFdocument lately. What sort problems have you been experiencing? It took a while to figure it out but I did get it working. I used the pageheight and pagewidth to change the size of the document, and so far it seems to work ok. Had some issues with the fonts and had

  1   2   >