RE: Using CFMX to generate Static HTML pages

2003-01-13 Thread Matt Robertson
Hi Dick, Use CFHTTP. I pulled the following straight out of my CMPro cms: There's literally nothing to it. This routine queries my own site from my own server, so connectivity across the web really sin't an issue. My whole site is built on this, although I built in stuff that lets the syste

RE: Another Locking Question

2003-01-13 Thread Matt Robertson
Dave Watts wrote >In general, I'm not a big fan of this approach, Me neither, especially since not locking the session var in the isdefined() as was shown in the original post is improper. You would have to lock the whole thing, cfif isdefined and all. Client vars are, for my money, the Holy Gra

Re: Using CFMX to generate Static HTML pages

2003-01-13 Thread Info
What you have to do is wrap your content with HTML content here then write the html doc using cffile ie: - Original Message - From: "Dick Applebaum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 10:47 PM Subject: Using CFMX to generate St

Re: XML-type Syntax with CF Tags

2003-01-13 Thread Sean A Corfield
On Monday, Jan 13, 2003, at 19:31 US/Pacific, Dave Carabetta wrote: > On the one hand, since CFML looks so much like HTML's tag-based > syntax, I'm > guessing people do it for consistency to comply with XHTML standards. Yes, I do it so that my source files look consistent with XHTML. > Further,

Using CFMX to generate Static HTML pages

2003-01-13 Thread Dick Applebaum
What is the easiest way to use CFMX to generate static HTML pages from dynamic content. I want to store the pages as .html pages in the web server root, rather than in the CFMX server root. The static site will be accessed with no load on the CFMX server. TIA Dick ~~

RE: Another Locking Question

2003-01-13 Thread Dave Watts
> I got a tip previously on cf-talk that advised me to do > this in my application.cfm: > > > > > > > > > > > > > > Is this good or bad? (My sites typically have between 10 > and 200 connections.) In general, I'm not a big fan of this approach, which

RE: web beacons

2003-01-13 Thread Dave Watts
> I use an "off-the-radar", licensed shareware email > client. Although the client will display properly > formatted html email, I rarely allow it. I love my > mail client. :) You can do all of that with Outlook 2000 or 2002, for that matter, with a little bit of work. If you don't want to view

RE: Why does ( Not True) if CF5.0 Single User return NO instead o f False???

2003-01-13 Thread Dave Watts
> Has anyone else had CF 5.0 return NO for Not True instead > of False? Is this fixable? > > I've had to put in iif's when I'd prefer to do Boolean > operations. CF accepts True/False or Yes/No as Boolean values, and typically returns Yes/No if you output a Boolean value directly. I'm not sure

RE: Need insights into best high load CFMX install

2003-01-13 Thread Dave Watts
> This will be a high demand app so I would like to get > any feedback as to what you think is the best CFMX set > up for this situation. It looks like Macromedia are > touting CFMX on J-Run as a good combination and I read > the recent article on MM's Website and although some of > you pointe

RE: CFMX for J2EE (JRun)

2003-01-13 Thread Dave Watts
> Yup, nslookup works fine, we can ping and resolve the name. > I followed all of the mentioned docs on configuring as well. > Any other ideas for this? Are you able to browse static content on any of the named sites? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5

RE: RE: web beacons

2003-01-13 Thread Jim Davis
Thanks, I'll forward it on to my host... I don't know if they'll do anything about it, but they can't claim there's nothing TO do. ;^) Jim Davis > -Original Message- > From: Lee Fuller [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 7:53 PM > To: CF-Talk > Subject: RE: RE: w

Why does ( Not True) if CF5.0 Single User return NO instead of False???

2003-01-13 Thread Andy Ousterhout
Has anyone else had CF 5.0 return NO for Not True instead of False? Is this fixable? I've had to put in iif's when I'd prefer to do Boolean operations. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subs

RE: XML-type Syntax with CF Tags

2003-01-13 Thread Dave Watts
> Over at least the last year or so, I have seen more and > more CF code samples where people choose to use XML-type > syntax when coding CFML. My is: Why? > > For those who might not know what I'm talking about, here's > a trivial example: > > > > > On the one hand, since CFML looks so muc

XML-type Syntax with CF Tags

2003-01-13 Thread Dave Carabetta
Over at least the last year or so, I have seen more and more CF code samples where people choose to use XML-type syntax when coding CFML. My is: Why? For those who might not know what I'm talking about, here's a trivial example: On the one hand, since CFML looks so much like HTML's tag-based s

Re: web beacons

2003-01-13 Thread Chris Montgomery
Monday, January 13, 2003, 12:23:55 PM, Lee Fuller wrote: > Yep.. One of the ways that spammers, these days, collect info on valid > email addresses when using HTML email campaigns. You simply view the > email, and BAM.. they know your email address is good. Easily remedied by using The Bat! email

x posted: SCCFUG Winter 2002 Technical Conference

2003-01-13 Thread John Wilker
Hi all, Not sure if this got posted, I didn't see it. Just wanted to let all the SoCal'ers know if they didn't already that the SCCFUG is having our 2nd annual Tech Conference. Last year was a blast, Ben Forta was there, plus 6-7 other really really good presentations. We had raffles, lunch is p

like phpmyadmin?

2003-01-13 Thread Dave Lyons
I know some of you were going to try and come up with something similar. I just ran into this http://utenti.lycos.it/Gianluigi_2/Extension.html Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscr

RE: CF MX and attributes variables

2003-01-13 Thread Robert Bailey
Yeah, worked fine on the dev box, was not sure what was happening Robert Bailey [EMAIL PROTECTED] "Famous for nothing!" http://www.tinetics.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 5:52 PM To: CF-Talk Subject: Re: CF

Macromedia Government Training Day invitation

2003-01-13 Thread Peter Bagnato
FREE Training Macromedia Government Training Day Thursday, Jan. 30, 2003 Washington, D.C. Register today > Learn the latest tools and strategies for building and deploying enterprise-leve

RE: StoreProc Driver question

2003-01-13 Thread James Ang
Change: CF_SQL_DATE To: CF_SQL_TIMESTAMP And make sure that you pass in ODBC formatted datetime strings OR you set the Null attribute to True/yes, like this: Before calling CFSTOREDPROC ... If (IsDate(request.start_date)) { request.start_date = CreateODBCDateTime(request.start_date);

Re: CF MX and attributes variables

2003-01-13 Thread brook
I use CFMX and fusebox without any problems. Everything IS Attribute Scoped. No special config needed. Brook At 03:53 PM 1/13/2003 -0800, you wrote: >What a headache! One of my clients recently upgraded to CF MX from CF >5.0. Here is a problem that we had, I was wondering if anyone else has >see

RE: StoreProc Driver question

2003-01-13 Thread Owens, Howard
OK, follow up to my previous post ... I ran a test procedure that stripped it down to just a bare select query ... and it ran, so it's not a "driver problem" per se. There must be an error in my code ... if anybody has any tips to pass along ... here's my code: >

RE: Database Results - Quick DB --> CFOUTPUT Tutorial

2003-01-13 Thread Ezine
Well, Then you are going to like Coldfusion :) In ColdFusion.. it is much simpler(and less wordy).. more so then ASP because ColdFusion handles the details of the record set. For example... lets say that you have a table called 'names' with two fields in it; FirstName and LastName. And

StoreProc Driver question

2003-01-13 Thread Owens, Howard
I'm trying to use CFSTOREDPROC for the first time, and I'm getting this error: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented I'm running SQL Server 2000 Developers Edition on a Win2K machine ... Can't I use storedprocs with the developer edition? Am I missing some driver

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread Paris Lundis
Sure Oracle has lots of extras... Undoubtedly... that's also part of the problem... it is expensive, expensive to maintain, expensive to run machines for, etc. Very few people can stomach the cost. Only the dotcomer suiciders with other folks money and the fortune 500 or less.. Paris Lundis F

RE: RE: web beacons

2003-01-13 Thread Lee Fuller
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&threadi d=468954 Just FYI | -Original Message- | From: Jim Davis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 4:47 PM | To: CF-Talk | Subject: RE: RE: web beacons | | | That's been happening since I sw

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread ksuh
Well, I could certainly use Oracle where I am now. In a serious way. There's no way mySQL even comes close to what our team needs. - Original Message - From: Paris Lundis <[EMAIL PROTECTED]> Date: Monday, January 13, 2003 5:23 pm Subject: Re: WOT: MySQL in the Enterprise > Oh no I agre

RE: RE: web beacons

2003-01-13 Thread Jim Davis
That's been happening since I switched to MX. CrystalTech says that it's the JRUN connector. I'm inclined to believe them but wich the damn thing would get fixed! ;^) Jim Davis > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 3

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread Paris Lundis
Oh no I agree, more features = more bloat... But how often do you see a car comparison and see a Porsche (100k+$) and a VW (20k) head-on dead heat race to the end line? It's truly encouraging to see open source and home brewed stuff pulling serious load... As far as I am concerned Oracle is a

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread Paul Hastings
> of robust SQL fancy database query stuff... The eWeek article was right > on I think about performance... having used both "fancy stuff"? triggers, stored procedures, etc. and at one time these fine fellows thought transactions were for the birds

RE: WOT: MySQL in the Enterprise

2003-01-13 Thread Tilbrook, Peter
But the Linux users aren't happy it seems: http://www.eweek.com/article2/0,3959,741132,00.asp == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: (02)

YET Another Locking Question

2003-01-13 Thread Haggerty, Mike
I heard someone mention temp variables, and I had some questions about best practices in using them. Anyone mind giving some peer review? I am serious about locking all application and session scope variables. In my application.cfm, I put a read-only lock around the application scope and duplicate

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread ksuh
Why are people surprised about the performance of mySQL versus whatever? Generally speaking, the more features an application has, the slower it will be. Thus, we can say that the more features a database has (seeing as how a database platform is actually just an application), the slower it wi

Re: Search engine spider

2003-01-13 Thread Dave Lyons
I think they are talking about wanting to build a search engine, such as google or something, correct? Wanting to hit it big, get rich then hit us with pay-per-clicks, lol - Original Message - From: "Tilbrook, Peter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, Janu

RE: Search engine spider

2003-01-13 Thread Tilbrook, Peter
CFMX has one built-in (using Verity) if that suits your purposes. == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: (02) 6213 6731 Mobile: 0439 40

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread Cutter (CF_Talk)
Huge article in this weeks E-Week regarding the use of mySQL for all of Rhode Island's inter/intranet sites Cutter Paris Lundis wrote: >Well I can't say I am enterprise.. even if I have a few tables with a >couple of million rows of data... > >Checkout the MySQL site and see their consulting ar

CF MX and attributes variables

2003-01-13 Thread Robert Bailey
What a headache! One of my clients recently upgraded to CF MX from CF 5.0. Here is a problem that we had, I was wondering if anyone else has seen this problem. We developed the site using Fusebox. When passing the variable attributes.fuseaction, it would refuse to notice that it was defined, even

Re: CF MX and Windows Server 2003 RC2

2003-01-13 Thread kay
James Alexander wrote: > Doh, I'd looked everyone for a work-around months ago and wasn't able to > find one. Do you know which key specifically that I need to edit? OK, found the page: http://phydiux.com/cfmx_and_IIS6/ HTH, Kay. ~~

RE: CF MX and Windows Server 2003 RC2

2003-01-13 Thread James Alexander
Great! Thanks! - James -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 6:48 PM To: [EMAIL PROTECTED] Cc: James Alexander James Alexander wrote: > Doh, I'd looked everyone for a work-around months ago and wasn't able to > find one. Do you kn

Re: Mx On The Rocks

2003-01-13 Thread Dave Lyons
again, if anyone needs a loft to rent for the conference, let me know ASAP, so I can get some lined up. If you're going, trust me, you want to stay in a loft downtown! - Original Message - From: "Mark Broner" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2

Application design question

2003-01-13 Thread lee
Matthew is right on the ball. You just have to have an entry (start and end date) for each time span. Then -- note his note about "distinct" -- you'll either have to pull back all records for, say boat A, during a given time span and print them all out, or use the CFOUTPUT GROUPBY tool to make

Re: How can I redirect a user?

2003-01-13 Thread Dave Lyons
fyi ~ i put a easy lil snippet on www.dwfaq.com that you add to your login that brings you back to the login page with any error display if the login is incorrect If you havent checked out the snippets there you should, great little resource - Original Message - From: "Bruce Sorge" <[EMAI

Mx On The Rocks

2003-01-13 Thread Mark Broner
MX ON THE ROCKS Sponsored by: Macromedia, ViaWest, Electric Rain, Department13, Breckenridge Communications EARLY REGISTRATION: Early registration ends this Friday, January 17. Sign up today and save by getting the early registration price of only $250 for a full two days of seminars. MX

RE: CF MX and Windows Server 2003 RC2

2003-01-13 Thread James Alexander
Doh, I'd looked everyone for a work-around months ago and wasn't able to find one. Do you know which key specifically that I need to edit? - James -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 6:30 PM To: CF-Talk James Alexander wrote: >

Re: CF MX and Windows Server 2003 RC2

2003-01-13 Thread Kay Smoljak
James Alexander wrote: > I'm getting ready to upgrade a test machine from RC1 to RC2 and was > curious if anyone know of the issue between CFMX and RC1 was resolved to > that I might finally be able to get MX on a 2K3 server. I've had CFMX running on RC1 for over 6 months now... You just have to t

RE: SmartCard Enabled Websites?

2003-01-13 Thread Joshua Miller
Interesting stuff Jochem, I'm getting ready to write a fairly large VoiceXML application - you've given me something to chew on for that application. For the more immediate use, I will recommend only the hardware smartcard - I was thinking that was really the only way, but I guess there's a lot mo

CF MX and Windows Server 2003 RC2

2003-01-13 Thread James Alexander
I'm getting ready to upgrade a test machine from RC1 to RC2 and was curious if anyone know of the issue between CFMX and RC1 was resolved to that I might finally be able to get MX on a 2K3 server. TIA - James ~| Archives:

Re: [OT?]: CFHTTPing to a Dominoe server

2003-01-13 Thread Jeffry Houser
At 06:21 PM 1/13/2003 -0500, you wrote: > This is off-list because it is. :-) Of course, it wasn't. It got bounced back to me, so I posted it publicly too without changing the text. :-) > Saying that Domino does everything automatically is a bit misleading. It >gave me a chuckle. >

Re: [OT?]: CFHTTPing to a Dominoe server

2003-01-13 Thread Jeffry Houser
This is off-list because it is. :-) Saying that Domino does everything automatically is a bit misleading. It gave me a chuckle. The other consultant probably meant that he builds Domino forms / views / Agents / etc.. using Domino Designer and that the Domino server automatically publish

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread Jochem van Dieten
Scott Mulholland wrote: > I am researching the use of MySQL in use with enterprise level > applications, looking for feedback both good and bad. > I have read all the articles on the mySQL site, as well as the manual > and the eWeek article comparing it with Oracle. > > Anyone on this list using

Re: WOT: MySQL in the Enterprise

2003-01-13 Thread Paris Lundis
Well I can't say I am enterprise.. even if I have a few tables with a couple of million rows of data... Checkout the MySQL site and see their consulting arm... I remember when I first started considering MySQL, their then cleint list and datawarehouse size was quite large.. fairly impressive amoun

Re: SmartCard Enabled Websites?

2003-01-13 Thread Jochem van Dieten
Joshua Miller wrote: > Is it possible to SmartCard enable a website? I've got a customer > requiring that we support SmartCard devices - I was under the impression > SmartCard website authentication happened at the workstation level using > software to control user access to specific sites. Is this

WOT: MySQL in the Enterprise

2003-01-13 Thread Scott Mulholland
I am researching the use of MySQL in use with enterprise level applications, looking for feedback both good and bad. I have read all the articles on the mySQL site, as well as the manual and the eWeek article comparing it with Oracle. Anyone on this list using it currently and have any success/ho

RE: Database Results

2003-01-13 Thread Mark A. Kruger - CFG
er... right... -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:54 PM To: CF-Talk Subject: RE: Database Results > You mean "RecordCount" And for CF newbie: ColdFusion can evaluate integers as boolean. Zero is false, non-zero is true. ~

[OT?]: CFHTTPing to a Dominoe server

2003-01-13 Thread Reed Powell
Hi all - here's an interesting one. I'm pushing some data out to an application belonging to another group in the company, which is a Dominoe application written for them by a third party/consultant. I do the same thing to other applications written in non-CF (CGI, ASP, etc) with absolutely no pr

RE: web beacons

2003-01-13 Thread S . Isaac Dealey
I use an "off-the-radar", licensed shareware email client. Although the client will display properly formatted html email, I rarely allow it. I love my mail client. :) > You don't even have to view the mail if the gif is near/at > the top and the > user has something like Eudora's "message preview

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Tilbrook, Peter
Heh! Don't think I could get away with that at work though :) >> Adam wrote: "Plus, everyone has their own preferred "home grown" method " AKA: FuseBastard H. > -Original Message- > From: Mark A. Kruger - CFG [SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 1:41 PM

Re: SmartCard Enabled Websites?

2003-01-13 Thread Jesse Houwing
Joshua Miller wrote: >Is it possible to SmartCard enable a website? I've got a customer >requiring that we support SmartCard devices - I was under the impression >SmartCard website authentication happened at the workstation level using >software to control user access to specific sites. Is this no

RE: web beacons (stop caching)

2003-01-13 Thread Mosh Teitelbaum
What if the same user hits more than one page? That's where the random number part comes in. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Costas Piliotis [mailto:[EMAIL PROTECTED]]

Re: Database Results

2003-01-13 Thread Bruce Sorge
Thanks for the correction. This is just further proof that proofreading is a good thing. - Original Message - From: "Everett, Al" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 3:53 PM Subject: RE: Database Results > > > > You mean "RecordCount" > >

RE: Design Pattern Question

2003-01-13 Thread John Quarto-vonTivadar
As Hal's business partner, I'm happy to confirm that Hal has not left Fusebox; he is simply no longer involved in the Fusebox organization's various committees. Real life beckons us all, particularly during recessions. :) John Quarto-vonTivadar -Original Message- From: A

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread John Quarto-vonTivadar
There are also books out on Fusebox "Discovering Fusebox 3" published by Techspedition (www.techspedition.com) which also has an eWorkbook that can be used with it to self-test your knowledge as you go along. "Fusebox: Developing ColdFusion applications" published by NewRiders. There is also "

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Owens, Howard
Adam wrote: "Plus, everyone has their own preferred "home grown" method " AKA: FuseBastard H. > -Original Message- > From: Mark A. Kruger - CFG [SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 1:41 PM > To: CF-Talk > Subject: RE: Fusebox was RE: Design Pattern

RE: Database Results

2003-01-13 Thread Everett, Al
> You mean "RecordCount" And for CF newbie: ColdFusion can evaluate integers as boolean. Zero is false, non-zero is true. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoff

RE: web beacons (stop caching)

2003-01-13 Thread Costas Piliotis
Shouldn't really cache though if UserID is different for each time the beacon is called should it? -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:29 PM To: CF-Talk Subject: RE: web beacons (stop caching) Make it unique. For example,

RE: InStr() Equivalent

2003-01-13 Thread Sicular, Alexander
If you are using cf5/mx check www.cflib.org for all kinds of extra udf stuff. Good luck, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]

RE: Database Results

2003-01-13 Thread Jerry Johnson
But if you really like treating recordsets like arrays, you can: #query['fieldname'][row]# Some other things to note: To get the list of fields returned in a query (recordSet), use query.columnList. And you cannot directly set the value of a query field You need to use the

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Mosh Teitelbaum
There's also cfObjects (http://www.cfobjects.com/). My IE Favorites list has gotten unmanageable again and I can't find the links to the others I've bookmarked. Sheesh. As for FuseBox info, check out their site http://www.fusebox.org. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301)

Re: Another Locking Question

2003-01-13 Thread Christian Cantrell
If you are going to put initialization code like this in your Application.cfm file, just be sure that you do not use any code that can generate another HTTP request for another CFM file (such as a cfhttp tag) as you may either create an infinite loop (with a readonly lock) or a deadlock (wi

RE: Database Results

2003-01-13 Thread Mosh Teitelbaum
Scott: You can determine how many record were returned by a particular query via the query results set's RecordCount attribute as in: ... The query returned #myQuery.RecordCount# results. You don't need to place the QRS into an array in order to loop ove

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Mark A. Kruger - CFG
Adam, There's one called "CF Objects" I believe. Plus, everyone has their own preferred "home grown" method - everyone who's done more than one project requiring high level CF code that is. -Mark -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, Jan

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Luce, Greg
The Fusebox methodology is created/modified/evolved by hundreds of people in the FB community. Throw your hat into the ring if you like! Greg -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 4:17 PM To: CF-Talk Subject: RE: Fusebox wa

RE: Database Results

2003-01-13 Thread Luce, Greg
Scott, You don't HAVE to put the query results into an array. Here's a simple example: SELECT * FROM users Name: #name# If the query didn't have any results it just wouldn't run any output loops. You can check by saying: See? Much simpler than that goofy ASP. :-) Greg -Original

Re: Database Results

2003-01-13 Thread Samuel R. Neff
To check if anything was returned check [query name].RecordCount. If it's more than zero, something was returned. You usually don't need to loop through and create an array. In CF it is already an array internally (exact structure depends on version of CF). At 03:56 PM 1/13/2003, you wrote:

RE: Database Results

2003-01-13 Thread Clint Tredway
Use this: Output my recordsdo this HTH Clint -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 2:56 PM To: CF-Talk Subject: Database Results When I used to work with ASP, I would run my SQL statement, check to see if the recordset is empty

Re: Database Results

2003-01-13 Thread Scott Brady
>When I used to work with ASP, I would run my SQL statement, check to see >if the recordset is empty or not, if it wasn't, I'd roll it up into an >array, and the loop through the array. If you're just trying to loop along the record set: (do whatever you want with each record here) If that's n

RE: web beacons (stop caching)

2003-01-13 Thread Mosh Teitelbaum
Make it unique. For example, add some unique value to it like: http://www.domain.dom/getWebBug.cfm?UserID=5&PageID=6&Random=52"; WIDTH="1" HEIGHT="1"> -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > ---

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Mike Brunt
There was actually a move to create something called Flashbox, those discussions took place around 6-8 months ago but in fairness did seem to fizzle out although there are still references to it here http://www.topica.com/lists/flashbox/. No doubts there is always talk in Fusebox circles about MVC

RE: Database Results

2003-01-13 Thread Adrocknaphobia Jones
Scott, You really need to buy the CF Application Book. In the meantime: SQL goes here queryName.recordCount = number of records You don't need to dump it into an array. You can loop over the query with: Good luck with CF. Buy the book. Ben needs the money. (j/k) Adam Wayne Lehman Web Sy

RE: Database Results

2003-01-13 Thread Mark A. Kruger - CFG
Scott, there are some variables that you should know about. First, "queryname.recordcount" - it contains an int representing the number of rows in your recordset. Ints can be evaluated as boolean in CF (any non-zero int is "true") so you can do .take action here. As far as an

Re: Database Results

2003-01-13 Thread Bruce Sorge
You can do a CFIF statement: Do stuff here Do something else Also, you do not need to loop through and put the query results in an array. You can just cfoutput the information: Output information goes here Or, you can do a cfloop with the query attribute. Output information goes

RE: Database Results

2003-01-13 Thread Everett, Al
> but how would I check to see if the result of the query contained results or > not, No results returned! We got #queryname.RecordCount# row(s) back! > and how would I put the results in an array, You can loop through the query result and put them in an array. Y

RE: Database Results

2003-01-13 Thread Dave Watts
> When I used to work with ASP, I would run my SQL > statement, check to see if the recordset is empty > or not, if it wasn't, I'd roll it up into an array, > and the loop through the array. > > I know how to do the SQL statement, and how to loop > through it, but how would I check to see if

RE: Database Results

2003-01-13 Thread Fuzion - CFTalk
I see if a recordset has any results, use recordsetname.recordcount To loop through a recordset simply use: Or You would then use the column name as a variable like this: #col1# #col2# You don't really need to put them into an array to loop over the recordset. Darryl -Original

RE: Application design question

2003-01-13 Thread Matthew Small
How about a table like this: Boatstartdate enddate A 4/18/2003 4/20/2003 A 4/26/2003 4/27/2003 A 5/17/2003 6/22/2003 B ... ... Startdate to enddate is the contiguous set of dates that the boat runs. You can select it like Select di

Re: Database Results

2003-01-13 Thread Jerry Johnson
Query.recordCount is the variable that indicates the number of rows returned with the query. Obviously 0 would be an empty set. Jerry Johnson >>> [EMAIL PROTECTED] 01/13/03 03:56PM >>> When I used to work with ASP, I would run my SQL statement, check to see if the recordset is empty or not, if i

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Adrocknaphobia Jones
" Fusebox is the most widely distributed Framework/Methodology for developing ColdFusion Applications" What other Framework/Methodologies exist for Cold Fusion? Is the fuseBox framework/methodology decided by a consortium? Or by a few elite people? Adam Wayne Lehman Web Systems Developer Johns H

RE: Fusebox was RE: Design Pattern Question

2003-01-13 Thread Haggerty, Mike
There is some interest in adopting Fusebox to Flash (the idea is called Flashbox), although the source of it seems to be existing CF Fusebox developers looking for a way of working with Flash. I can say there is not nearly the level of interest in Flashbox as there is in just straight OOP programm

RE: web beacons (stop caching)

2003-01-13 Thread Eric Dawson
How do you stop proxy servers and browsers from caching the beacon? e ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=

Database Results

2003-01-13 Thread Scott Wilhelm
When I used to work with ASP, I would run my SQL statement, check to see if the recordset is empty or not, if it wasn't, I'd roll it up into an array, and the loop through the array. I know how to do the SQL statement, and how to loop through it, but how would I check to see if the result of the

Re: Application design question

2003-01-13 Thread Scott Brady
>I see this working. What worries me the the trips table. I'm hoping to >avoid entering a new record for each trip, for each boat. Could I >somehow use a range? some of the trips run each day from June to >October. I'd love to find a way around entering hundreds of records >for each trip. But, I ca

Re: InStr() Equivalent

2003-01-13 Thread Samuel R. Neff
Find() At 03:35 PM 1/13/2003, you wrote: >What's the equivalent of (ASP's) InStr() in CF? > >Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.

RE: Search engine spider

2003-01-13 Thread Kris Pilles
Thanks -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:49 PM To: CF-Talk Subject: RE: Search engine spider If by 'index the links' you mean generate a list of them, it seems to me the following would work pretty well. Create an empty array.

RE: Search engine spider

2003-01-13 Thread Ben Doom
If by 'index the links' you mean generate a list of them, it seems to me the following would work pretty well. Create an empty array. Populate the first entry with your starting URL. Set a counter 'count' to 1. loop while count is less than or equal to the arraylen: cfhttp the url in the array a

RE: InStr() Equivalent

2003-01-13 Thread Everett, Al
Find() or FindNoCase(). > -Original Message- > From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 3:35 PM > To: CF-Talk > Subject: InStr() Equivalent > > > What's the equivalent of (ASP's) InStr() in CF? > > Scott > > ~~~

Re: Application design question

2003-01-13 Thread Jeff Fongemie
Hello Scott, On Mon, 13 Jan 2003, at 13:33:53 you carefully wrote: >>Boat A. >>April 18, 19, &20 >>April 26/27 >>May 17-June 22 >>June 25-october 19 SB> Just off the top of my head: SB> 1) A table for boats that has a record for each boat. SB> 2) A table for trips that includes the boat_id, the

RE: InStr() Equivalent

2003-01-13 Thread Raymond Camden
What does ASP's inStr do? Those of us who know CF but not ASP would be able to answer then. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yah

Re: InStr() Equivalent

2003-01-13 Thread charlie griefer
Scott Wilhelm writes: > What's the equivalent of (ASP's) InStr() in CF? http://livedocs.macromedia.com/cf50docs/CFML_Reference/Functions2.jsp#109988 7 list of cf string functions :) > > Scott > > ~| Archives: http://w

InStr() Equivalent

2003-01-13 Thread Scott Wilhelm
What's the equivalent of (ASP's) InStr() in CF? Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://w

Re: Application design question

2003-01-13 Thread Scott Brady
>Boat A. >April 18, 19, &20 >April 26/27 >May 17-June 22 >June 25-october 19 Just off the top of my head: 1) A table for boats that has a record for each boat. 2) A table for trips that includes the boat_id, the departure date, and the return date. To get the info for a certain date, you could

  1   2   3   >