RE: Replacement for Replace

[David Shadovitz]

Duane,

Jason's advice is good.  In MS Access, use IIF and IsNull, like this:
   IIF(IsNull(Department),'N/A',Department)
where IIF's syntax is: IIF(expr, truepart, falsepart)

-David

On Saturday, March 10, 2001 3:12 PM, Jason Aden [SMTP:[EMAIL PROTECTED]] 
wrote:
> Why not try using a database function for it? Something like:
>
> 
>   select replace(discountList,NULL,0) AS discountList
>   from discounts
> 
>
> That way the database can handle doing the replacement, which is a lot
> faster than having CF do it in a list.
>
> HTH,
>
> Jason
>
> 
> Jason Aden
> Allaire Certified Developer
> [EMAIL PROTECTED]
> www.wwstudios.com
>
> > -Original Message-
> > From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, March 10, 2001 3:39 PM
> > To: CF-Talk
> > Subject: Replacement for Replace
> >
> >
> > Hi all,
> >
> > I have a list that I am working on that is 4000+ items plus. The list
> > unfortunately contains several "empty" items. Is there a way, other than
> > using Replace() to replace the empty items with a 0?
> >
> > This is what I have to deal with, but it is talking 1200 ms to process and
> > there is two more function calls just like it.
> >
> >  > ";"), ";;", ";0;", "ALL")>
> >
> > PS, this is not my code. This is code I am trying to optimize.
> >
> > Thanks,
> > Duane

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dates in OLEDB

[Richard Meredith-Hardy]

Hum

This works. Thanks, what a pain!  

This immediately makes a migration to OLEDB a waste of time.  (Might
look at it for future apps)

It also makes me think there should be a set of new functions in CF:

createDBdate(mydate,"theDB")
createDBdatetime(mydatetime,"theDB")

Where theDB could be "Access", "SQLServer","ODBC"(!) etc.




> Date: Sat, 10 Mar 2001 20:01:03 -
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: RE: Dates in OLEDB
> Message-ID: <[EMAIL PROTECTED]>
> 
> > I'm experimenting with a migration from ODBC to OLEDB --> access 2000
> >
> > This query works fine with an ODBC datasource:
> > (STORYDT is a datetime field)
> >
> > 
> > SELECT SREF, STORYSUBJ, STORYDT
> > FROM news
> > WHERE (STORYDT > #createodbcdatetime(dateadd("d",-7,now()))#)
> > 
> 
> OK, not surprisingly ODBC dates don't work in OLEDB, but do in ODBC
> 
> What you have to do is find a "native" version of the date that works in
> that database
> 
> One format that works in Access 2000 probably won't work in SQL Server
> 
> Try;
> SELECT fields
> FROM table
> WHERE dateField > ###DateFormat(DateValue,"d mmm ")#
> #TimeFormat(DateValue,"HH:mm:ss")###
> 
> I know Access 97 and 2000 are quite happy when you specify a date within #
> characters, while SQL Server wants them in apostrophies
> 
> Give that a bash and see if it works...
> 
> 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.
> **
> 
> 

--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Examples of Password protection

[David Hannum]

Try making a table in your database with a "level" field, username and pwd.
Set the levels, then query the table with your login.  Put your qualifiers
in your scripts and set session vars based on the level in the login.  Let
them see what they can based on the level of privileges they have.

Dave


- Original Message -
From: Michael <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 6:43 PM
Subject: Re: Examples of Password protection


> What I am looking for is if you have this password then you have access to
> all the information in the program/form/database,  and if NOT, then you
only
> see this much and thats IT..
>
>
>
> Thanks
>
>
> "Michael" <[EMAIL PROTECTED]> wrote in message
> 3aaa4a87$[EMAIL PROTECTED]">news:3aaa4a87$[EMAIL PROTECTED]...
> > Looking for some examples of password protection of certain pages or
> > view's
> >
> > Thanks
> >
> > Michael
> >
> >
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFObjects vs. FuseBox vs. Good CFML Code and SmartObjects

[Hal Helms]

I've used CFObjects. It's intriguing, but ultimately I find it unsatisfying
for exactly the reason Dave Watts gave. If you want to do OO development,
why would you not use a language like Java or Ruby that support OO
methodologies? Sure, you can roll your own with CF, but why?

Still, if you (a)already have a good grasp of OO fundamentals and (b)want to
use CF only, CFObjects is interesting; it's certainly worth a look.

Hal Helms
Team Allaire
[ See ColdFusionTraining.com for info on "Best Practices with ColdFusion &
Fusebox" training ]


-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 9:19 PM
To: CF-Talk
Subject: RE: CFObjects vs. FuseBox vs. Good CFML Code and SmartObjects


Thank you for the real world opinions on the fusebox, it does seem to be
something worth trying again, but has anybody out there ever used CFObjects
and/or SmartObjects? With all this Java hoopla and Object Oriented
programming we all like to use, why don't I hear anything about those two CF
methods?

Erika

-Original Message-
From: Maia, Eric [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 3:55 PM
To: CF-Talk
Subject: RE: CFObjects vs. FuseBox vs. Good CFML Code and SmartObjects


I'll second this - I'm still learning FuseBox methodology, but I've found
that as I implement it more fully, its much easier to make changes to my
code without a major headache. Sure, if you're already following good
programming practices (simplicity, eliminating duplication, code reuse) it
might not be a major improvement, but I've found it tends to enforce good
practices for those of us who sometimes shortcut them.

I guess one advantage of a Fusebox app over a really well-coded app with no
particular methodology is that another Fusebox developer can step in and
understand the architecture and details of your app more quickly due to
naming and organizational conventions.

eric

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 12:02 PM
To: CF-Talk
Subject: Re: CFObjects vs. FuseBox vs. Good CFML Code and SmartObjects


> I worked on one Fusebox
> application and it was a little tedious. But probably because I was not
used
> to the methodology.


I can't help on the other methodologies but, being a full-time FuseBox fan,
I can tell you that getting started with it can be a bit tedious. It's not
difficult at all but does require wrapping your mind around the concepts
(there's more to it than comments here usually suggest) and then expanding
them to suit your needs if desired. Once I really started taking advantage
of all it offers I found myself being a LOT more productive overall.

Ken
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Advanced ColdFusion, UK, March 12th

[Hal Helms]

Gavin, I'm working with some folks in UK to try to put together a Fusebox
class. No dates yet, but I'll keep you informed.

Hal Helms
Team Allaire
[ See ColdFusionTraining.com for info on "Best Practices with ColdFusion &
Fusebox" training ]


-Original Message-
From: Gavin Lilley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 8:50 AM
To: CF-Talk
Subject: RE: Advanced ColdFusion, UK, March 12th


Sorry I meant to reply to this thread!

Does anyone know anything about the Fusebox course in England? Last I heard
the price was going up and it may not happen at all.

--
Gavin Lilley
Internet / Intranet Developer
http://halesowen.ac.uk

-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 13:45
To: CF-Talk
Subject: RE: Advanced ColdFusion, UK, March 12th


Heh man - pay my air fare and hotel costs - and I'll be straight over...!

"probably won't be for a while" this year???

I'd be most interested...

-Original Message-
From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 13:26
To: CF-Talk
Subject: Re: Advanced ColdFusion, UK, March 12th


Hal and I are thinking about it, but it probably won't be for a while
because our current schedule is pretty full.

In the meantime, come on over to the Colonies!

Respectfully,

Adam Phillip Churvis
Productivity Enhancement, Inc.

Publishers of the CommerceBlocks line of
modular ColdFusion development tools

Website: http://www.commerceblocks.com
E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866
- Original Message -
From: "Daniel Lancelot" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 6:09 AM
Subject: RE: Advanced ColdFusion, UK, March 12th


> Anything like this in the uk???
>
> -Original Message-
> From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]]
> Sent: 07 March 2001 09:41
> To: CF-Talk
> Subject: Re: Advanced ColdFusion, UK, March 12th
>
>
> Take a look at the "Advanced Bootcamp for ColdFusion, Database, and
> Javascript" course being offered on www.ColdFusionTraining.com.
>
> Respectfully,
>
> Adam Phillip Churvis
> Productivity Enhancement, Inc.
>
> Publishers of the CommerceBlocks line of
> modular ColdFusion development tools
>
> Website: http://www.commerceblocks.com
> E-mail:  [EMAIL PROTECTED]
> Phone:   770-446-8866
> - Original Message -
> From: "Thomas Chiverton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 06, 2001 8:53 AM
> Subject: Advanced ColdFusion, UK, March 12th
>
>
> > In Kingston - anyone else from here attending ?
> >
> > Regards,
> >
> > Thomas Chiverton,
> > Intranet Architect and Desktop Analyst
> > Office: 01565 757 909
> > As a GUI, reality in useless...
> >
> >
> >
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: rs6000 - AS 400

[Joseph Eugene]

Successful usage of DB2 connect also depends on the AS400 OS you are
running. You should have the lastest version of the AS400
OS to run DB2 connect properly and the AS400 OS has to be
confirgured to get DB2 Connect working properly.
The lastest version of Client Access works good and IBM has
cleaned the ODBC drivers over the years...so i guess its the best choice.
The Lastest version if Client Access is Called "Client Access Express"
This product works fine for us and we havent had any problems.
Hope this helps
Joe



- Original Message -
From: "chris.white" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: "'Stewart McGowan'" <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 5:29 PM
Subject: Re: rs6000 - AS 400


> I have used Client Access Express.  The advantage is that you can call a
> stored procedure (RPG or Cobol program) and have the results returned as
a
> record set.  You can't do that with DB2 Connect.  As for Screensurfer, it
> works but it is expensive.  We choose Client Access Express.
>
> Chris White
>
>
> Date: Fri, 09 Mar 2001 18:13:14 -
> From: Stewart McGowan <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: CF - rs6000 - AS 400
> Message-ID: 
>
> hello all,
>
>
> has anyone any experience with attaching to DB2 on an RS2000 or an as400?
I
> had heard of a product for the AS400, but I can't remember the name.
>
> have a good weekend
>
>
> Stew
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Another FAQ:

[Michael Dinowitz]

Eventually I plan to absorb them all into mine. :)


> > Just thought I would pass this along, for interst sake.
> >
> > http://developer.irt.org/script/fusion.htm
>
> I might just assimilate some of their better questions, in a Borg-like
> fashion...
>
>
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
>
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Examples of Password protection

[Michael]

What I am looking for is if you have this password then you have access to
all the information in the program/form/database,  and if NOT, then you only
see this much and thats IT..



Thanks


"Michael" <[EMAIL PROTECTED]> wrote in message
3aaa4a87$[EMAIL PROTECTED]">news:3aaa4a87$[EMAIL PROTECTED]...
> Looking for some examples of password protection of certain pages or
> view's
>
> Thanks
>
> Michael
>
>



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Generator applications

[net_man]

I have seen Clint's app and it will be wanted by all and matched by none.

Robert

- Original Message -
From: "Clint Tredway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 8:54 PM
Subject: RE: CF Generator applications


> I have used and it is very buggy for a 'finished' product. When my app is
ready, there will be nothing like it.
>
> --
> Clint Tredway
> www.factorxsoftware.com
> --
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Replacement for Replace

[Jason Aden]

Why not try using a database function for it? Something like:


select replace(discountList,NULL,0) AS discountList
from discounts


That way the database can handle doing the replacement, which is a lot
faster than having CF do it in a list.

HTH,

Jason


Jason Aden
Allaire Certified Developer
[EMAIL PROTECTED]
www.wwstudios.com

> -Original Message-
> From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 10, 2001 3:39 PM
> To: CF-Talk
> Subject: Replacement for Replace
>
>
> Hi all,
>
> I have a list that I am working on that is 4000+ items plus. The list
> unfortunately contains several "empty" items. Is there a way, other than
> using Replace() to replace the empty items with a 0?
>
> This is what I have to deal with, but it is talking 1200 ms to process and
> there is two more function calls just like it.
>
>  ";"), ";;", ";0;", "ALL")>
>
> PS, this is not my code. This is code I am trying to optimize.
>
> Thanks,
> Duane
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

oops was Re: Replacement for Replace

[Dick Applebaum]

Tag should be





I think that the

speed of my brain < speed of my fingers < speed of my mouth



At 3:52 PM -0700 3/10/01, Dick Applebaum wrote:
>Why not:
>
>   Replace(GetDiscountList. DiscountList, ";;", ;0; "ALL")>
>
>
>HTH
>
>Dick
>
>
>At 3:38 PM -0500 3/10/01, Duane Boudreau wrote:
>>Hi all,
>>
>>I have a list that I am working on that is 4000+ items plus. The list
>>unfortunately contains several "empty" items. Is there a way, other than
>>using Replace() to replace the empty items with a 0?
>>
>>This is what I have to deal with, but it is talking 1200 ms to process and
>>there is two more function calls just like it.
>>
>>>";"), ";;", ";0;", "ALL")>
>>
>>PS, this is not my code. This is code I am trying to optimize.
>>
>>Thanks,
>  >Duane
>

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: stored procedure and resultset

[Dave Watts]

> Did you use that in Oracle before? The reason I asked is that 
> in ColdFusion knowledge base, for article # 8353, it said that 
> 
> "Oracle stored procedures do not return result sets in the 
> traditional sense. Consequently, it is not possible to generate 
> a query in ColdFusion using an Oracle stored procedure."

This is no longer the case. CF now supports the retrieval of recordsets from
Oracle stored procedures as long as the stored procedure returns a reference
cursor (as described by Vani Kolli earlier in this thread) and as long as
you use CFSTOREDPROC to call the stored procedure.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Replacement for Replace

[Dick Applebaum]

Why not:

   


HTH

Dick


At 3:38 PM -0500 3/10/01, Duane Boudreau wrote:
>Hi all,
>
>I have a list that I am working on that is 4000+ items plus. The list
>unfortunately contains several "empty" items. Is there a way, other than
>using Replace() to replace the empty items with a 0?
>
>This is what I have to deal with, but it is talking 1200 ms to process and
>there is two more function calls just like it.
>
>";"), ";;", ";0;", "ALL")>
>
>PS, this is not my code. This is code I am trying to optimize.
>
>Thanks,
>Duane

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF and Interland Price Increase

[chris.white]

I have been using Digi-wave for over a year.  Their cheapest ColdFusion plan
is $22.95 and corp. account is $49.95.
For more info:  http://www.digi-wave.com/webhostingplans.html

Ask for Phalon and tell him that I sent you.

~~~
Chris White
Experienced Designs
[EMAIL PROTECTED]
www.experienced-designs.com
~~~

This document contains confidential information of Experienced Designs, Inc.
In consideration of the receipt of this document, the recipient agrees
not to reproduce, copy, use or transmit this document and/or the information
contained herein, in purpose except with written permission, first obtained,
of Experienced Designs, Inc. and further agrees to surrender the same to
Experienced Designs, Inc. upon demand.




Date: Fri, 09 Mar 2001 15:31:33 +1100 (EST)
From: Michael Kear <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: CF and Interland Price Increase
Message-ID: <[EMAIL PROTECTED]>

I'm sure they are well aware they're going to lose business.   They'll be
betting the business that walks out the door will be much less than the
increased revenue from the people who just have too much inertia or don't
care.

Remember that for some of us, tripling of any cost is an outrage, but for
many of their customers, $150 a month or even $1500 a month is chickenfeed
and at those site owners, noone will give a damn.

Frankly, I hope Interland continue to think like that - it's all the more
business for the rest of us.

I think Interland will profit greatly from this move.   But I wouldn't
have any of my sites there, that's certain.

Cheers,
Mike Kear
Windsor, NSW, Australia
www.afpwebworks.com



On Thu, 8 Mar 2001, dennis baldwin wrote:

> the interland price increase is complete bullshit.  we host two e-commerce
> sites with them and will be looking to move servers soon.  i wouldn't be
> suprised if this caused them to lose a lot of business.  check out their
> review on RateAHost.com
>
> http://www.rateahost.com/review.cfm?CID=1821&ReviewType=1&ReviewFull=True
>
> -Original Message-
> From: Ken Wilson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 08, 2001 2:37 PM
> To: CF-Talk
> Subject: Re: CF and Interland Price Increase
>
>
> > I know that some of us are hosting some cf websites with Interland, I
just
> > want to make everyone aware that Interland raised there prices last week
> on
> > all there cf plans from $50/month to $150/month. All there accounts will
> be
> > effected with this price change new and old. My salesperson stated that
> the
> > price increase is due to the power rate increases, and something in the
> > effect that allaire is charging them more.
>
>
> 
>
> Or, perhaps it's time for Microsoft's cash investment in Interland to pay
> off in increased ASP market share. What better way to try to drive people
to
> ASP than to price CF at an unbearable level while leaving ASP pricing low.
>
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

--


~~~
Chris White
Experienced Designs
[EMAIL PROTECTED]
www.experienced-designs.com
~~~

This document contains confidential information of Experienced Designs, Inc.
In consideration of the receipt of this document, the recipient agrees
not to reproduce, copy, use or transmit this document and/or the information
contained herein, in purpose except with written permission, first obtained,
of Experienced Designs, Inc. and further agrees to surrender the same to
Experienced Designs, Inc. upon demand.



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Generator applications

[Peter Theobald]

I'm dying to try out CommerceBlocks but they don't support Sybase yet. Everyone who is 
using Sybase please send them a note asking them to make that first on their list! :-)

At 05:40 AM 3/9/01 -0500, Tony Schreiber wrote:
>http://www.commerceblocks.com/
>
>> Anyone knows a program that generates CF code for comercial 
>> applications (add,update,delete,search forms)? 
>> 
>> == 
>> IMPRESION EXPRESS  Tel.(8)363-0888  Fax(8) 363-7199
>> Ave. Real San Agustin #222 - H3E-mail: [EMAIL PROTECTED]
>> Residencial San Agustin
>> Garza Garcia, N.L.  MEXICO
>> 
>>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: rs6000 - AS 400

[chris.white]

I have used Client Access Express.  The advantage is that you can call a
stored procedure (RPG or Cobol program) and have the results returned as a
record set.  You can't do that with DB2 Connect.  As for Screensurfer, it
works but it is expensive.  We choose Client Access Express.

Chris White


Date: Fri, 09 Mar 2001 18:13:14 -
From: Stewart McGowan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: CF - rs6000 - AS 400
Message-ID: 

hello all,


has anyone any experience with attaching to DB2 on an RS2000 or an as400? I
had heard of a product for the AS400, but I can't remember the name.

have a good weekend


Stew

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Linux/CF and MYSQL vs. Win2k/CF and SQL2k

[Peter Theobald]

Cold Fusion on Linux is great. We use it exclusively. We find NT to be less reliable, 
and difficult to remotely administer (especially a large server farm of them). We have 
no experience with Win2K.

MySQL is very very fast, but is not a full featured RDBMs.  For a heavily trafficked 
site or a site doing financial transactions I would recommend using a full featured 
RDBMS like MS-SQL, Oracle, or Sybase.

You can mix and match these. In other words, you can use Linux Cold Fusion with MSSQL 
on an NT box, or any combination of Cold Fusion servers with Database servers.  
We happen to use Sybase on Linux (again, since we like Linux so much). Oracle would 
also be an excellent choice (probably a better database, but much more expensive). 
MSSQL is not available on Linux.


At 09:36 AM 3/8/01 -0700, Jay Patton wrote:
>Hello All,
>quick question about linux, CF,MYSQL vs. Win 2k, CF, SQL 2k.
>how does ColdFusion on Linux using MySQL differ from CF on win2K using SQL 2K? And 
>are there any draw backs on MySQL or Linux version of CF? (bugs ect... )
>
>Anyone with info on this would be helpful!
>
>Thanks,
>
>Jay Patton
>Web Design / Application Design
>Web Pro USA
>406.549.3337 ext. 203
>1.888.5WEBPRO
>www.webpro-usa.com
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfhttpparam results in a popup window

[Philip Arnold - ASP]

> At the top of the new page, include
>
> 
>   opener.location.href = "";
> 

Actually, to be 100% correct on this (when dealing with older browsers)




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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfhttpparam results in a popup window

[Hayes, David]

The html 4.0  element allows a "target" attribute; if you set it to
"_blank", the action page will open in a new window.

At the top of the new page, include


opener.location.href = "";


-Original Message-
From: Mark Smeets [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 9:06 PM
To: CF-Talk
Subject: RE: cfhttpparam results in a popup window


Sorry for not clarifying, they activate it via form.

Maybe you can elaborate on the solution, my javascript knowledge is somewhat

lacking.

Thanks

Date: Fri, 09 Mar 2001 09:17:30 -0600
From: "Hayes, David" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: cfhttpparam results in a popup window
Message-ID: 
<[EMAIL PROTECTED]>

How is the user activating the search of the other site?  If it's a link (or
a form post), you can set the target to a new window.

In the page that loads in the new window, you could include some javascript
like

opener.location.href = "successpage.cfm".

-Original Message-
From: Mark Smeets [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 9:11 PM
To: CF-Talk
Subject: cfhttpparam results in a popup window


Here's what I want to do but I'm having no luck doing this.

I have a page which searches another website and returns its results in my
own website (gotta love that cfhttp) now unfortunately the design for this
site (the site I am searching) doesn't fit in my website at all, so I want
to return the results in a popup window.

This hasn't proven to be easy, in fact after messing with it, I'm pretty
much lost.

Basically 2 things have to happen. The results are returned in a popup
window and then you're taken to a "success" page, or something like a
success page (haven't decided on it's content but it's a page none the less)

Any solution is appreciated.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query crashes server?

[Philip Arnold - ASP]

> I may be having the same problem.

The other "solution" that I use when it's not in Identity order is to pass a
complete list of the IDs through in a form field (yes, I know this gets big
when it hits the thousands) and then pull out the block I'm looking at, the
ID list must be in the correct order, obviously...


IDarray=ListToArray(form.IDlist);
NewIDlist="";
for (i=1; i lte 20; i=i+1)
{   if((i + form.StartPosn) gt ArrayLen(IDarray))
break;
NewIDlist=ListAppend(NewIDlist,IDarray[i + form.StartPosn]);
}


select *
from table
where ID in (#NewIDlist#)
order by OrderField


This code and method is very old (about 9 months now) and probably needs
re-writing...
I'll do it when I get the time :-/

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHTTP Problem

[Philip Arnold - ASP]

> On our production server and dev server (both running Apache and CF 4.5.1
> SP2) I call an application on an external server via CFHTTP with POST as
> the method and one form variable that contains XML.  I get the results
> back and take care of them accordingly. No problems.
>
> Here is the problem:
>
> On another dev server (this one running IIS 5 and CF 4.5.1 SP2) the CFHTTP
> throws an error indicating "the file is not in ASCII text format and
cannot
> be rendered" right after the POST operation.  Any ideas?

Are you sure the IIS machine is 4.5.1 SP2? It sounds like an issue that was
fixed in 4.5.1

I had the same problem a while back on a 4.0.1 machine, so I just switched
to the 4.5.1 machine and it worked fine

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query crashes server?

[Arden Weiss]

I may be having the same problem.

The system I have includes an Access database with Memo fields (went to 
access because of problems hanlding memo fields via the ODBC driver for 
FoxPro).

Queries and updates work fine on my local machine and a staging site 
(commercial host), but on my client's CF Server they hang. Same MDB, just 
FTP'd up.  The cause may be a CF setting difference. A previous post here 
about a related item suggestted rasing the page timeout to 1500 or so -- 
just a thought.

We will be bird-dogging this issue next week. Will post findings.

Also, we will be migrating to SQL Server 7 soon (not 2000) becaue of too 
many perceived or real uncertainties with MDAC, etc. (7 and MDAC 2.5 are 
known to be stable -- hope that eliminates these kind of problems.

Somehow I get the feeling the M$ has/is stacking the deck to force 
conversion to another one of their cash cows.
 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   W Luke [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, March 10, 2001 12:15 PM
To: CF-Talk
Subject:Re: Query crashes server?


> Initially it was working (including the new update) - so I'm going to try
> the old DB file to see if that helps :(

Well, the old DB works fine.  I also tried a "newly uploaded" version of 
the
new DB, but that crashes cfserver immediately.  Could it be the Memo field 
I
put in the new table? (does CF not like Memo fields?)

Thanks

Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Replacement for Replace

[Duane Boudreau]

Hi all,

I have a list that I am working on that is 4000+ items plus. The list
unfortunately contains several "empty" items. Is there a way, other than
using Replace() to replace the empty items with a 0?

This is what I have to deal with, but it is talking 1200 ms to process and
there is two more function calls just like it.



PS, this is not my code. This is code I am trying to optimize.

Thanks,
Duane


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Examples of Password protection

[Arden Weiss]

Agreed..

I lifted the entire application.cfm code dealing with session management 
and password/login from that chapter and embeded it into my first big app 
-- worked untouched like a charm. Also, good stuff on error handling in 
chapter 18.
 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   sebastian palmigiani [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, March 10, 2001 11:30 AM
To: CF-Talk
Subject:Re: Examples of Password protection

on 3/10/01 9:35 AM, Michael at [EMAIL PROTECTED] wrote:

> Looking for some examples of password protection of certain pages or
> view's

Near the end of chhapter 17 of the book Mastering ColdFusion 4.5 by Danesh
and Motlagh has a nice section on this.

Sebastian
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFHTTP Problem

[Kurt Ward]

Maybe you guys can help me out.

On our production server and dev server (both running Apache and CF 4.5.1
SP2)I
call an application on an external server via CFHTTP with POST as the method
and one
form variable that contains XML.  I get the results back and take
care of them accordingly. No problems.

Here is the problem:

On another dev server (this one running IIS 5 and CF 4.5.1 SP2) the CFHTTP
throws
an error indicating "the file is not in ASCII text format and cannot be
rendered"
right after the POST operation.  Any ideas?

Kurt


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dates in OLEDB

[Philip Arnold - ASP]

> I'm experimenting with a migration from ODBC to OLEDB --> access 2000
>
> This query works fine with an ODBC datasource:
> (STORYDT is a datetime field)
>
> 
> SELECT SREF, STORYSUBJ, STORYDT
> FROM news
> WHERE (STORYDT > #createodbcdatetime(dateadd("d",-7,now()))#)
> 

OK, not surprisingly ODBC dates don't work in OLEDB, but do in ODBC

What you have to do is find a "native" version of the date that works in
that database

One format that works in Access 2000 probably won't work in SQL Server

Try;
SELECT fields
FROM table
WHERE dateField > ###DateFormat(DateValue,"d mmm ")#
#TimeFormat(DateValue,"HH:mm:ss")###

I know Access 97 and 2000 are quite happy when you specify a date within #
characters, while SQL Server wants them in apostrophies

Give that a bash and see if it works...

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Dates in OLEDB

[Richard Meredith-Hardy]

I'm experimenting with a migration from ODBC to OLEDB --> access 2000

This query works fine with an ODBC datasource:
(STORYDT is a datetime field)


SELECT SREF, STORYSUBJ, STORYDT
FROM news
WHERE (STORYDT > #createodbcdatetime(dateadd("d",-7,now()))#)


but with the OLEDB Datasource I get the error 
OLEDB Error Code - -524553244
Malformed GUID. in query expression '(STORYDT >
#createodbcdatetime(dateadd("d",-7,now()))#)'

So, thinks I, it must be something to do with the createodbcdatetime()
or dateadd() functions

but all these WHERE clauses generate the same error:
WHERE (STORYDT > #createodbcdatetime(now())#)
WHERE (STORYDT > {ts '2001-03-10 18:48:02'})
WHERE (STORYDT > '2001-03-10 18:48:02')
WHERE (STORYDT > #now()#)

This works - obviously passing a function to the DB itself, but not
exactly very flexible
WHERE (STORYDT > now())

There must be a correct syntax - anyone help?

I really don't want to alter all my queries which involve time - is this
really necessary with OLEDB? 

This is weird! What's going on?

--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Jeffry Houser]

At 06:14 PM 03/10/2001 +, you wrote:
> > Allow me to modify my previous post then...
> >
> >   
> > 
> >   select top 20 * from mytable
> >   where mytableID > #lownum#
> > 
> > 
> > 
> >
> > 
> >
> > 
> >   
> > 
>
>OK, modifying what Jeffry's done;
>
>
>And get rid of that CFOutput loop

   Oh, good point...  I was (of course) assuming that other processing was 
going on in the CFOUTPUT loop.  But, if there isn't that's a much better 
way to do it.


Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
The best advice I can give you is to ignore everything I say


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: wddx server to server

[Stephen M Aylor]

www.wddx.org

Steve

- Original Message -
From: "nizam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 12:43 AM
Subject: wddx server to server


> Hi,
> What I can see the example coding is browser to server or server to
browser. How if I want to get the data from other server and save it in my
server. I want to create a page that will retrieve the data from SQL
database from other server and insert in my SQL database in my server using
WDDX. Can I get some coding example or any suggestion from you. For your
information I use Coldfusion 4.5.1. can I do likely as coding for retrive
data from browser to server or it not the same things.
> Please help me
>
>
> Thanks
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Philip Arnold - ASP]

> Allow me to modify my previous post then...
>
>   
> 
>   select top 20 * from mytable
>   where mytableID > #lownum#
> 
> 
> 
>
> 
>
> 
>   
> 

OK, modifying what Jeffry's done;


And get rid of that CFOutput loop

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Jeffry Houser]

   Allow me to modify my previous post then...

  

  select top 20 * from mytable
  where mytableID > #lownum#



   



  



  All the queries will return only 20.  And you're keeping track of the 
highest ID that was returned, and using that as the lowestID.  The next 
query (when hitting the next button) will return the first 20 rows greater 
than your previous...


At 09:39 AM 03/10/2001 -0800, you wrote:
>Al,
>
>Thanks for the quick response, but I can't count on the identity column
>being contiguous because entries have been deleted.
>
>-- Brett
>
>A 12:33 PM 3/10/2001 -0500, you wrote:
>
> >Have an autoincrement field in the database.
> >   use it as the key to get each group. For example, on the first round, you
> >would do:
> >
> >select whatever from whatever, where
> >ID > N1  and ID < N2
> >
> >Pass N1 and N2 back and forth between templates, and have a next group,
> >previous group manipulate N1 and N2 so it picks up the right records.
> >
> >
> >
> >Al
> >A1webs.com
> >
> > > > I've got a simple guestbook application that holds 250 guestbooks 
> so far.
> > > > Some of the guestbooks are have up to 13000 records.
> > > >
> > > > I am returning the entire recordset and looping through it 20
> > > > records at a
> > > > time (I didn't think that it would get to be so big), but the query 
> times
> > > > out on 13000 records. The database (Sybase)  is optimized like
> > > > butter and I
> > > > can hit it from 20 clients at the same time with no response 
> problems. I
> > > > would like to stay away from cursors, because the can get messy.
> > > >
> > > > I have already tried caching the query (which doesn't really help 
> because
> > > > there are always new records begin added) and converting it to a 
> session
> > > > variable (which doesn't help because it just eats the ram on the
> > > > boxes), so I need to rewrite.
> > > >
> > > > Does any one have any suggestions or know if there is a custom tag out
> > > > there that increments the number of records returned as you step 
> through
> > > > the result set? I have checked Allaires repository, but no luck :)
> > > >
> > > > If not, I will write one and share it with the group if anyone is
> > > > interested.
> > >
> > >Write the template intelligently so it's not bringing back 13,000 records
> > >when you only need 20 - that's just insane!
> > >
> > >The fastest way I can think of to do this is to find the last entry date,
> > >bring back 25 just in case there are several at exactly the same time, and
> > >pass through in the "next 20" button the date of the last entry and 
> the IDs
> > >of the entries shown on the previous page
> > >
> > >That way your db access is kept to a minimum, and speed will shoot through
> > >the roof
> > >
> > >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.
> > >**
> > >
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Philip Arnold - ASP]

> Thanks for the quick response, but I can't count on the identity column
> being contiguous because entries have been deleted.

Pass the highest entry through and do

Select top 20 *
from myTable
where ID > #passedID#

As long as ID's are in chronological order (which they should be)

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Dealing with Large Queries

[Jeffry Houser]

   To elaborate a little more on what Philip just said (I was about to say 
the same thing):





   select top 20 * from mytable
   where mytableID > #lownum# and mytableID < #highnum#







  (That's the general idea anyway)


At 08:50 AM 03/10/2001 -0800, you wrote:
>Hi!
>
>I've got a simple guestbook application that holds 250 guestbooks so far.
>Some of the guestbooks are have up to 13000 records.
>
>I am returning the entire recordset and looping through it 20 records at a
>time (I didn't think that it would get to be so big), but the query times
>out on 13000 records. The database (Sybase)  is optimized like butter and I
>can hit it from 20 clients at the same time with no response problems. I
>would like to stay away from cursors, because the can get messy.
>
>I have already tried caching the query (which doesn't really help because
>there are always new records begin added) and converting it to a session
>variable (which doesn't help because it just eats the ram on the boxes), so
>I need to rewrite.
>
>Does any one have any suggestions or know if there is a custom tag out
>there that increments the number of records returned as you step through
>the result set? I have checked Allaires repository, but no luck :)
>
>If not, I will write one and share it with the group if anyone is interested.
>
>-- Avrom
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Avrom]

Al,

Thanks for the quick response, but I can't count on the identity column 
being contiguous because entries have been deleted.

-- Brett

A 12:33 PM 3/10/2001 -0500, you wrote:

>Have an autoincrement field in the database.
>   use it as the key to get each group. For example, on the first round, you
>would do:
>
>select whatever from whatever, where
>ID > N1  and ID < N2
>
>Pass N1 and N2 back and forth between templates, and have a next group,
>previous group manipulate N1 and N2 so it picks up the right records.
>
>
>
>Al
>A1webs.com
>
> > > I've got a simple guestbook application that holds 250 guestbooks so far.
> > > Some of the guestbooks are have up to 13000 records.
> > >
> > > I am returning the entire recordset and looping through it 20
> > > records at a
> > > time (I didn't think that it would get to be so big), but the query times
> > > out on 13000 records. The database (Sybase)  is optimized like
> > > butter and I
> > > can hit it from 20 clients at the same time with no response problems. I
> > > would like to stay away from cursors, because the can get messy.
> > >
> > > I have already tried caching the query (which doesn't really help because
> > > there are always new records begin added) and converting it to a session
> > > variable (which doesn't help because it just eats the ram on the
> > > boxes), so I need to rewrite.
> > >
> > > Does any one have any suggestions or know if there is a custom tag out
> > > there that increments the number of records returned as you step through
> > > the result set? I have checked Allaires repository, but no luck :)
> > >
> > > If not, I will write one and share it with the group if anyone is
> > > interested.
> >
> >Write the template intelligently so it's not bringing back 13,000 records
> >when you only need 20 - that's just insane!
> >
> >The fastest way I can think of to do this is to find the last entry date,
> >bring back 25 just in case there are several at exactly the same time, and
> >pass through in the "next 20" button the date of the last entry and the IDs
> >of the entries shown on the previous page
> >
> >That way your db access is kept to a minimum, and speed will shoot through
> >the roof
> >
> >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.
> >**
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Al Musella, DPM]

Have an autoincrement field in the database.
  use it as the key to get each group. For example, on the first round, you 
would do:

select whatever from whatever, where
ID > N1  and ID < N2

Pass N1 and N2 back and forth between templates, and have a next group, 
previous group manipulate N1 and N2 so it picks up the right records.



Al
A1webs.com

> > I've got a simple guestbook application that holds 250 guestbooks so far.
> > Some of the guestbooks are have up to 13000 records.
> >
> > I am returning the entire recordset and looping through it 20
> > records at a
> > time (I didn't think that it would get to be so big), but the query times
> > out on 13000 records. The database (Sybase)  is optimized like
> > butter and I
> > can hit it from 20 clients at the same time with no response problems. I
> > would like to stay away from cursors, because the can get messy.
> >
> > I have already tried caching the query (which doesn't really help because
> > there are always new records begin added) and converting it to a session
> > variable (which doesn't help because it just eats the ram on the
> > boxes), so I need to rewrite.
> >
> > Does any one have any suggestions or know if there is a custom tag out
> > there that increments the number of records returned as you step through
> > the result set? I have checked Allaires repository, but no luck :)
> >
> > If not, I will write one and share it with the group if anyone is
> > interested.
>
>Write the template intelligently so it's not bringing back 13,000 records
>when you only need 20 - that's just insane!
>
>The fastest way I can think of to do this is to find the last entry date,
>bring back 25 just in case there are several at exactly the same time, and
>pass through in the "next 20" button the date of the last entry and the IDs
>of the entries shown on the previous page
>
>That way your db access is kept to a minimum, and speed will shoot through
>the roof
>
>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.
>**
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query crashes server?

[W Luke]

> Initially it was working (including the new update) - so I'm going to try
> the old DB file to see if that helps :(

Well, the old DB works fine.  I also tried a "newly uploaded" version of the
new DB, but that crashes cfserver immediately.  Could it be the Memo field I
put in the new table? (does CF not like Memo fields?)

Thanks

Will


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dealing with Large Queries

[Philip Arnold - ASP]

> I've got a simple guestbook application that holds 250 guestbooks so far.
> Some of the guestbooks are have up to 13000 records.
>
> I am returning the entire recordset and looping through it 20
> records at a
> time (I didn't think that it would get to be so big), but the query times
> out on 13000 records. The database (Sybase)  is optimized like
> butter and I
> can hit it from 20 clients at the same time with no response problems. I
> would like to stay away from cursors, because the can get messy.
>
> I have already tried caching the query (which doesn't really help because
> there are always new records begin added) and converting it to a session
> variable (which doesn't help because it just eats the ram on the
> boxes), so I need to rewrite.
>
> Does any one have any suggestions or know if there is a custom tag out
> there that increments the number of records returned as you step through
> the result set? I have checked Allaires repository, but no luck :)
>
> If not, I will write one and share it with the group if anyone is
> interested.

Write the template intelligently so it's not bringing back 13,000 records
when you only need 20 - that's just insane!

The fastest way I can think of to do this is to find the last entry date,
bring back 25 just in case there are several at exactly the same time, and
pass through in the "next 20" button the date of the last entry and the IDs
of the entries shown on the previous page

That way your db access is kept to a minimum, and speed will shoot through
the roof

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Dealing with Large Queries

[Avrom]

Hi!

I've got a simple guestbook application that holds 250 guestbooks so far. 
Some of the guestbooks are have up to 13000 records.

I am returning the entire recordset and looping through it 20 records at a 
time (I didn't think that it would get to be so big), but the query times 
out on 13000 records. The database (Sybase)  is optimized like butter and I 
can hit it from 20 clients at the same time with no response problems. I 
would like to stay away from cursors, because the can get messy.

I have already tried caching the query (which doesn't really help because 
there are always new records begin added) and converting it to a session 
variable (which doesn't help because it just eats the ram on the boxes), so 
I need to rewrite.

Does any one have any suggestions or know if there is a custom tag out 
there that increments the number of records returned as you step through 
the result set? I have checked Allaires repository, but no luck :)

If not, I will write one and share it with the group if anyone is interested.

-- Avrom


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

wddx server to server

[nizam]

Hi,
What I can see the example coding is browser to server or server to browser. How if I 
want to get the data from other server and save it in my server. I want to create a 
page that will retrieve the data from SQL database from other server and insert in my 
SQL database in my server using WDDX. Can I get some coding example or any suggestion 
from you. For your information I use Coldfusion 4.5.1. can I do likely as coding for 
retrive data from browser to server or it not the same things. 
Please help me


Thanks


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Finding the CF Administrator password

[Philip Arnold - ASP]

> Just a note on template encrypting: It's scarcly worth it as the server
> obviously needs a fixed key (as shown below) to make it portable
> and has to
> be an easy scheme to make the template run w/o much decryption overhead.
> Anyone w/ even basic knowledge of DES encryption and programming can sit
> down and reverse engineer the simplistic algorythm used. The proliferation
> of decryption binaries and the original key phrase now (I hadn't
> actual seen that before) makes it a waste of server resources.

Also, there is a website where you can decrypt templates - it takes a few
minutes to decrypt a whole bunch of templates

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Examples of Password protection

[sebastian palmigiani]

on 3/10/01 9:35 AM, Michael at [EMAIL PROTECTED] wrote:

> Looking for some examples of password protection of certain pages or
> view's

Near the end of chhapter 17 of the book Mastering ColdFusion 4.5 by Danesh
and Motlagh has a nice section on this.

Sebastian


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: drop down form

[Jones, Becky]

do you have any examples??

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 4:31 AM
To: CF-Talk
Subject: Re: drop down form


Can be done with Flash, DHTML, Java

HTH

Dick


At 7:50 PM -0500 3/9/01, Jones, Becky wrote:
>this may not be the right forum for this...but everyone seems to be pretty
>knowledgable here...
>i have a form on a page.  i want to be able to have like a "minimize"
>"maximize" button on the form. 
>so say the the the  was my form.  like off to the side it coul have an
>icon maybe a down arrow or something.  so when i clicked on that error, it
>would show the entire form and when i clicked on it again it would hide the
>form.  kinda like menus
>My menu (closed)
>My menu
>   +sub menu  (opened)
>i want to have my form just show the header...and then when you clicked on
>this icon it would show the entire form. 
>any ideas where to look for this?
>thanks alot.
>bec.
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Finding the CF Administrator password

[Raymond B.]

Go to the CF Admin, under 'Basic Security' is a list of tags you can
disable. That's of course just the first step towards securing the server.
If you're running a shared environ make sure to grab the Allaire path to
disable the CF Admin undocumented tags/functions as you can do all sorts of
fun stuff w/ them. There are of course thousands of other things to be done,
so have fun.

Just a note on template encrypting: It's scarcly worth it as the server
obviously needs a fixed key (as shown below) to make it portable and has to
be an easy scheme to make the template run w/o much decryption overhead.
Anyone w/ even basic knowledge of DES encryption and programming can sit
down and reverse engineer the simplistic algorythm used. The proliferation
of decryption binaries and the original key phrase now (I hadn't actual seen
that before) makes it a waste of server resources.


-Original Message-
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: March 10, 2001 07:57
To: CF-Talk
Subject: RE: Finding the CF Administrator password


How does one disable CFRegistry?

Thanks!

John

-Original Message-
From: CF [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 10:48 AM
To: CF-Talk
Subject: Re: Finding the CF Administrator password


Yeah .. someone sent me the key a little earlier and it worked like a
charm. Actually, this other peson also showed me how to find the key to
begin with ... it's amazingly simple.  I don't see why you should be
flamed .. people should not have CFRegistry active on a machine where
they wouldn't want people getting in and doing stuff like this anyway.
This is just another great example of why ;)

Todd Ashworth
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Dain Anderson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 12:07 AM
Subject: Re: Finding the CF Administrator password


> Todd,
>
> It's very easy to retrieve the admin password, and I'm sure I will get

> flamed for showing this, but what the hell:
>
> 
>
> 
>
Branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Se
rver
> "
>   Entry="AdminPassword"
>   Variable="AdminPassword">
>
> 
>   Registry Password: #CFusion_Decrypt(AdminPassword, CFKey)#
> 
>
> The key to decrypt it spells "4 Polaris" (Allaire inside joke?) --
> this isn't my doing; rather, I was sent this from an anonymous source
> via the [EMAIL PROTECTED] address. I hope this will show Allaire
> and ISPs that there is a need for encryption, not encoding, for things

> such as this. I
am
> against template encryption personally, but the administrator feature
should
> have much better security. We live and learn, strive and yearn.
>
> Dain Anderson
> Caretaker, CF Comet
> http://www.cfcomet.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Finding the CF Administrator password

[CF]

It's in the CFAdministrator under Basic Security.  Scroll down to the bottom
and uncheck what you don't need.  I would uncheck them all unless you have a
speciffic need for one of them.

Todd Ashworth
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "John Fix 3rd" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 10:57 AM
Subject: RE: Finding the CF Administrator password


> How does one disable CFRegistry?
>
> Thanks!
>
> John
>
> -Original Message-
> From: CF [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 10, 2001 10:48 AM
> To: CF-Talk
> Subject: Re: Finding the CF Administrator password
>
>
> Yeah .. someone sent me the key a little earlier and it worked like a
> charm. Actually, this other peson also showed me how to find the key to
> begin with ... it's amazingly simple.  I don't see why you should be
> flamed .. people should not have CFRegistry active on a machine where
> they wouldn't want people getting in and doing stuff like this anyway.
> This is just another great example of why ;)
>
> Todd Ashworth
> Web Application Developer
> Network Administrator
>
> Saber Corporation
> 314 Oakland Ave.
> Rock Hill, SC 29730
> (803) 327-0137 [111] (p)
> (803) 328-2868 (f)
>
> - Original Message -
> From: "Dain Anderson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, March 10, 2001 12:07 AM
> Subject: Re: Finding the CF Administrator password
>
>
> > Todd,
> >
> > It's very easy to retrieve the admin password, and I'm sure I will get
>
> > flamed for showing this, but what the hell:
> >
> > 
> >
> >  >
> >
> Branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Se
> rver
> > "
> >   Entry="AdminPassword"
> >   Variable="AdminPassword">
> >
> > 
> >   Registry Password: #CFusion_Decrypt(AdminPassword, CFKey)#
> > 
> >
> > The key to decrypt it spells "4 Polaris" (Allaire inside joke?) --
> > this isn't my doing; rather, I was sent this from an anonymous source
> > via the [EMAIL PROTECTED] address. I hope this will show Allaire
> > and ISPs that there is a need for encryption, not encoding, for things
>
> > such as this. I
> am
> > against template encryption personally, but the administrator feature
> should
> > have much better security. We live and learn, strive and yearn.
> >
> > Dain Anderson
> > Caretaker, CF Comet
> > http://www.cfcomet.com/
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Finding the CF Administrator password

[Philip Arnold - ASP]

> How does one disable CFRegistry?

In the Administrator - Basic Security
Along with CFDirectory, CFFile, CFExecute

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Finding the CF Administrator password

[John Fix 3rd]

How does one disable CFRegistry?

Thanks!

John

-Original Message-
From: CF [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, March 10, 2001 10:48 AM
To: CF-Talk
Subject: Re: Finding the CF Administrator password


Yeah .. someone sent me the key a little earlier and it worked like a
charm. Actually, this other peson also showed me how to find the key to
begin with ... it's amazingly simple.  I don't see why you should be
flamed .. people should not have CFRegistry active on a machine where
they wouldn't want people getting in and doing stuff like this anyway.
This is just another great example of why ;)

Todd Ashworth
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Dain Anderson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 12:07 AM
Subject: Re: Finding the CF Administrator password


> Todd,
>
> It's very easy to retrieve the admin password, and I'm sure I will get

> flamed for showing this, but what the hell:
>
> 
>
> 
>
Branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Se
rver
> "
>   Entry="AdminPassword"
>   Variable="AdminPassword">
>
> 
>   Registry Password: #CFusion_Decrypt(AdminPassword, CFKey)# 
> 
>
> The key to decrypt it spells "4 Polaris" (Allaire inside joke?) -- 
> this isn't my doing; rather, I was sent this from an anonymous source 
> via the [EMAIL PROTECTED] address. I hope this will show Allaire 
> and ISPs that there is a need for encryption, not encoding, for things

> such as this. I
am
> against template encryption personally, but the administrator feature
should
> have much better security. We live and learn, strive and yearn.
>
> Dain Anderson
> Caretaker, CF Comet
> http://www.cfcomet.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Finding the CF Administrator password

[CF]

Yeah .. someone sent me the key a little earlier and it worked like a charm.
Actually, this other peson also showed me how to find the key to begin with
... it's amazingly simple.  I don't see why you should be flamed .. people
should not have CFRegistry active on a machine where they wouldn't want
people getting in and doing stuff like this anyway.  This is just another
great example of why ;)

Todd Ashworth
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Dain Anderson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 12:07 AM
Subject: Re: Finding the CF Administrator password


> Todd,
>
> It's very easy to retrieve the admin password, and I'm sure I will get
> flamed for showing this, but what the hell:
>
> 
>
> 
>
Branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server
> "
>   Entry="AdminPassword"
>   Variable="AdminPassword">
>
> 
>   Registry Password: #CFusion_Decrypt(AdminPassword, CFKey)#
> 
>
> The key to decrypt it spells "4 Polaris" (Allaire inside joke?) -- this
> isn't my doing; rather, I was sent this from an anonymous source via the
> [EMAIL PROTECTED] address. I hope this will show Allaire and ISPs that
> there is a need for encryption, not encoding, for things such as this. I
am
> against template encryption personally, but the administrator feature
should
> have much better security. We live and learn, strive and yearn.
>
> Dain Anderson
> Caretaker, CF Comet
> http://www.cfcomet.com/



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Examples of Password protection

[Michael]

Looking for some examples of password protection of certain pages or
view's

Thanks

Michael



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Sorting an Array

[Philip Arnold - ASP]

> Been trying to sort a 2 dimensional array and am having trouble. The fisrt
> element is numeric, the 2nd is text. I'm trying to sort in
> numeric order on the 1st item and can't get it to work.

OK, please tell me you're not using ArraySort() - this only sorts one
dimensional arrays

You'd have to write a sort routine to re-build your array - many types of
sorting out there, so you have to choose the one you understand and can
re-write if it doesn't do exactly what you want (which is why most people
stick to Bubble sorts)

The simplest way to do it without much code is to put the output into a
database and let it sort it, but this demands database access and means
temporary tables...

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Warning: Page has Expired... How do I get around that??

[Philip Arnold - ASP]

> Something you might think about is putting the variables passed
> into hidden form fields and put a "Back" button on the page itself
> instead of having your user/visitor use the browser's buttons.

This would work as long as they didn't mind printing the "Back" button

I know I just mentioned this as a solution to another problem, but I think
it applies here;

How about putting the Back button in a Frame at the top of the browser and
have the bottom Frame as the printable results - you could also put a Print
button in the top frame and use JS to do the printing

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: how can I preiodically refresh cfgrid?

[Philip Arnold - ASP]

> I have to refresh a cfgrid from a database in every 10 seconds or so.
> If I reload the whole page, it's kind of ungly (flickering too).
> Any better way? (I know I could use an applet, but...)

Wouldn't that mean that it wouldn't be updatable?

If that's your intention (only displaying data) then I'd suggest putting it
in a Frame and refreshing that page in the FrameSet

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFCOOKIE

[Philip Arnold - ASP]

> Philip, can we get hold of the CF5 documentation without
> actually installing the beta? I've not come across it on Allaire's
> site and was wondering if it was available in advance of the
> product

Not as far as I know - in fact, the Docs that installed with my CF5 Beta are
pretty non-existant - they include the New Features, but apart from that,
they're not the complete Docs

Also, remember that we're still on Beta1, so new functionality is being
added all the time, so the documentation would be changing all of the time

I'm waiting for Beta2 which should be a big upgrade...

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.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Reseller Recommendations???

[net_man]

Check out www.atswebnet.com you can host domains for as low as $4.95 and
resell all you want.

Robert

- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 11:20 PM
Subject: Reseller Recommendations???


> I am intersted in becoming a CF web host reseller and am looking for some
> opinions, advise, or horror stories about companies you may have been
> involved with.  Feel free to send your opinions off list if you don't wish
> to talk bad about a particular company in an open forum.
>
> Thanks,
> Rich
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query crashes server?

[W Luke]

The update I did also included adding a new table to the DB.  Usually, I add
a "Site being updated" message and  to the application.cfm file -
but I forgot this time, and when I was uploading the DB I think it probably
became corrupt as CF tried to write to it.

Initially it was working (including the new update) - so I'm going to try
the old DB file to see if that helps :(

Cheers

Will


> I've found (the hard way) that a "simple" query, such as one that grabs
only
> 1 record from only 6 tables of a poorly designed database, is enough to
> bring a server down .. even under no load otherwise ;).  CF code /
database
> design can have a suprising affect on your server, so it's not impossible
> for you to experience problems, even with a simple query.  Maybe if you
> posted the 'suspect' code, someone here might be able to help more?
>
> Todd Ashworth
> Web Application Developer
> Network Administrator
>
> Saber Corporation
> 314 Oakland Ave.
> Rock Hill, SC 29730
> (803) 327-0137 [111] (p)
> (803) 328-2868 (f)
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 09, 2001 6:59 PM
> Subject: Re: Query crashes server?
>
>
> > Hehe, yup, all sorts of bad code can crash a server, including overly
> large
> > queries.
> >
> > I've done various bad things on production servers, until I made myself
do
> > all development on my personal system.
> > As a matter of fact my and the sysadmin at an isp got to know each other
> > very well when I was first learning CF. ;-)
> >
> > jon
> >
> > 
> > - Original Message -
> > From: "W Luke" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, March 09, 2001 6:43 PM
> > Subject: Query crashes server?
> >
> >
> > > Hi,
> > >
> > > Am pretty concerned as I think I've crashed my ISP's server.  I wrote
a
> > > small app today for my site - an admin panel to add News items to the
> > site,
> > > and a page to pull the News items back.  Both are using very basic
> > queries -
> > > no joins, or anything complicated.  But the coincidence is a bit
> worrying.
> > > I used to work for the ISP, and know the servers makeup, but I'm just
> > asking
> > > whether a query (basic) can crash a server?
> > >
> > > Thanks
> > >
> > > Will
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: drop down form

[Dick Applebaum]

Can be done with Flash, DHTML, Java

HTH

Dick


At 7:50 PM -0500 3/9/01, Jones, Becky wrote:
>this may not be the right forum for this...but everyone seems to be pretty
>knowledgable here...
>i have a form on a page.  i want to be able to have like a "minimize"
>"maximize" button on the form. 
>so say the the the  was my form.  like off to the side it coul have an
>icon maybe a down arrow or something.  so when i clicked on that error, it
>would show the entire form and when i clicked on it again it would hide the
>form.  kinda like menus
>My menu (closed)
>My menu
>   +sub menu  (opened)
>i want to have my form just show the header...and then when you clicked on
>this icon it would show the entire form. 
>any ideas where to look for this?
>thanks alot.
>bec.
>
>

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists