Re: WAY OT DTS PACKAGE

[cf refactoring]

SQL 2000's DTS package allows you to run any Win32
process or batch file via a "Execute Process Task".
You can use this to run the unzip program before you
import the data. I don't think this is available for
SQL 7.

--- Joshua Tipton <[EMAIL PROTECTED]> wrote:
> Does anyone know via DTS how to open a zip file so
> that I can attach to a
> dbf file that is in the zip file?
> 
> Josh
> 
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

checkout exit survey

[cf refactoring]

Our marketing department wants to know why people
abandon the checkout process, so they've tasked IT
with creating a survey which pops up when people
abandon their cart.

I'm thinking what I'll do is to capture the onunload
event for each page of the checkout process, and that
on unload I'll check to see if the user is leaving the
page via one of the links/forms on the page, or by
some other method. If it's by some other method, I'll
pop up the survey. I'll also disable the back button.

This won't capture all the abandonment, but it seems
to me to be the least intrusive = least likely to
popup when it's not supposed to.

I'd appreciate any alternatives and any suggestions to
make this less intrusive.



=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I like CFMX

[cf refactoring]

Generally, in OOP, objects should have four
properties:

Abstraction
Polymorphism
Inheritance
Encapsulation

Are you saying CFC's do more than Encapsulation?

> > -Original Message-
> > From: Neil Clark - =TMM=
> [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 29, 2002 1:55 PM
> > To: CF-Talk
> > Subject: RE: I like CFMX
> > 
> > I have to disagree, CFC's are a perfect
> implementation of OOP . in
> > ColdFusion.
> > 
> > Remember that CFC's are geared toward the
> ColdFusion developer, not
> the
> > Java Developer, so I reckon they hit the nail on
> the head - hard.
> > 
> > N
> > 
> > 
> > 
> > 
>

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Systematic diagnosis of CF memory use

[cf refactoring]

[double post]
I've inherited a CF app with an apparent memory leak.
Does anyone have a systematic plan to diagnose and
eliminate possible causes?

The Macromedia Knowledge Base article
http://www.macromedia.com/v1/Handlers/index.cfm?ID=15014&Method=Full
is helpful, but doesn't provide a plan of attack.

Of the list of causes on that page, the application
has possible causes (that I know about) -- unlocked
shared-scope variables, large cached queries, large
record sets, and COM objects. I strongly suspect that
it's the unlocked shared-scope variables, but it's a
big undertaking to correct this and I need to show the
boss that I've eliminated other causes before
undertaking this effort.

Any suggestions?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Getting Files from a Remote Server via a custom program...

[cf refactoring]

Jeff,

There's a "lo-tech" method that works with any
application that works within a window. What you can
do is use VB's SendKey command which can simulate keys
being typed in a window. And you can even use VBA to
do it. I've seen an Excel macro which opened up a
window to an as400 mainframe app and then download
data through 8 screens by screen scraping.


--- Jeffry Houser <[EMAIL PROTECTED]> wrote:
>   It is an executable.
>   If it were web based, I could probably work
> something out with cfhttp (is 
> that were you were going?)
> 
> At 10:58 AM 4/24/2002 -0400, you wrote:
> >When you are talking about the GUI program,
> >
> >is it an executable (an app written in VB or some
> such, and run as an .exe)
> >
> >or
> >
> >is it a web app, where you go to a web page, choose
> which graphics to 
> >download, and they magically appear?
> >
> >Jerry Johnson
> >
> >
> > >>> [EMAIL PROTECTED] 04/24/02 10:29AM >>>
> >Hi All,
> >
> >   Here is my dilemma.
> >
> >   I'm working with a client in the real-estate
> industry.  They plan to
> >download MLS (Multi-Listing Service) data from the
> local MLS provider,
> >including images.
> >
> >   The data files are located on an FTP server, so
> downloading them and
> >performing a mass import into a database is no
> problem.
> >
> >   To get the photos the client uses a GUI
> interface.  They enter a sign-in
> >and the photos automatically download to the
> specified location.
> >
> >   We want to be able to automate the photo
> download process.  We were told
> >that the photos were not available on FTP and that
> the GUI program was the
> >only way to get them; there was no command line
> version.  My client thinks
> >he was told a mistruth.
> >   I do believe that the GUI program has to go out
> to some type of server
> >(even if it isn't FTP) on the internet to download
> the files.
> >
> >   Question 1: Are there any utilities that allow
> me to monitor the outgoing
> >traffic on my machine?  Something along the lines
> of "The machine sent X
> >request to X IP / port."  I figure I can run the
> program and see where it
> >is going.
> >
> >   Question 2: Is there a way to automate a GUI
> program?  ( Doesn't that
> >defeat the purpose of a GUI program in the first
> place? ).
> >
> >
> >--
> >Jeffry Houser | mailto:[EMAIL PROTECTED]
> >Need a Web Developer?  Contact me!
> >AIM: Reboog711  | Fax / Phone: 860-223-7946
> >--
> >My Books: http://www.instantcoldfusion.com
> >My Band: http://www.farcryfly.com
> >
> >
> >
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: IsDefined and brackets

[cf refactoring]

Thanks to everyone who replied.

I knew I could use isdefined("aStruct.aField") but
I was just wondering what the rationale was behind
invalid syntax error for
isdefined("aStruct['aField']"). Dave's explanation
that I should really think of it as two separate tests
was pretty good.

Also, I don't like to use isdefined("aStruct.aField")
because sometimes I might have spaces in "aField" and
that would cause IsDefined to choke, so
StructKeyExists() is the way to go for me.

--- stas <[EMAIL PROTECTED]> wrote:
> Why not simply
> 
>  ?
> 
> 
> - Original Message -
> From: "Dave Watts" <[EMAIL PROTECTED]>
> 
> You could rewrite this test to look like this:
> 
>  StructKeyExists(aStruct, "aField")>
> 
> This clearly describes the two tests you're running.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: stored procedure - Ambiguous column name

[cf refactoring]

Try renaming your stored proc input parameter
CategoryJobDescrID to something else so it doesn't
have the same name as a database column.

--- Greg Jordan <[EMAIL PROTECTED]> wrote:


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

IsDefined and brackets

[cf refactoring]

The following code throws a syntax error:




aStruct[aField] is defined


Is this just some CF quirk that IsDefined doesn't like
brackets or is there some good reason for this?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfset vs using cfscript

[cf refactoring]

I just optimized some templates which were written in
cf tag syntax by rewriting as cfscript. In my
experience, cfscript can be up to 2-3x as fast. But in
my opinion, the performance isn't worth rewriting
unless you're inside a loop. In my case, I rewrote all
the cfset statements inside a cfquery loop of 1000+
and achieved a whopping speed increase, but I didn't
bother with the tag statements outside.

In general, you'll get the most improvement for your
effort if you rewrite statements within loops.

--- Clint Tredway <[EMAIL PROTECTED]> wrote:
> I have a question...
> 
> Lets say that I have about 10 variables being set
> locally on 20 or so cfm
> pages..
> 
> How much faster is using cfscript over using cfset
> to set the values of
> these local variables?
> 
> Clint Tredway


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: premature session timeout

[cf refactoring]

Didn't think about trusted cache, but no, it isn't
enabled.

--- Dave Watts <[EMAIL PROTECTED]> wrote:
> > I'm having a problem with premature session
> timeout in
> > a legacy application.
> > 
> > I've set the CF administrator value to 3 hours,
> and
> > the sessiontimeout attribute of the cfapplication
> tag
> > also to 3 hours, but it still seems to be timing
> out
> > at the default of 20 min.
> > 
> > I've also checked to see that I don't have other
> > application.cfm files scattered around.
> > 
> > Anybody have any ideas where the problem might be?
> 
> This might be a silly question, but is Trusted Cache
> enabled?
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

premature session timeout

[cf refactoring]

I'm having a problem with premature session timeout in
a legacy application.

I've set the CF administrator value to 3 hours, and
the sessiontimeout attribute of the cfapplication tag
also to 3 hours, but it still seems to be timing out
at the default of 20 min.

I've also checked to see that I don't have other
application.cfm files scattered around.

Anybody have any ideas where the problem might be?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: tracing email distribution lists

[cf refactoring]

Does anyone know how to contact commercial email
distribution lists? I received some spam which said
they got my email off these two lists:

itslmazing
geckooffers

but a search on Google turned up nothing. Also, does
anyone know what other similar type of direct-email
list organizations are?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Where is the best place to put business rules?

[cf refactoring]

I'm going to go off on a different tack here than the
discussion that's been going on.

It's important to note the difference between logical
tiers and physical tiers. It sounds like you want to
implement a logical 3-tier system on top of a physical
2-tier system and you're wondering where to put the
middle logical tier.

Well, it's not an either-or choice, because there's no
absolute reason why logical tier boundaries and
physical tier boundaries have to align, but it DOES
make it easier to enforce tier separation when the
boundaries align. It is logically possible to split
the middle tier between both the CF and database to
take advantage of both, but in that case, you have to
really know what you're doing.

One last comment -- be careful of a common design
mistake of thinking that just because the tiers are
PHYSICALLY separated then they are LOGICALLY
separated. A lot of people make the mistake of saying
"our application has CF and a database so it's a
two-tier system" when their CF code and database code
have so many interdependencies that the LOGICAL tier
boundary is blurred.

The following link from a chapter I just read has a
good discussion about these kinds of design
considerations:

http://www.apress.com/books/sampleChapters/1893115585.pdf
> 
> So at the bottom line, we have two questions:
> 1) Where is the best place to put the business
> rules?  CF Templates (using
> CFTransaction), or Stored Procedures (using SQL
> Transactions).  We realize
> that some business rules need to reside on the
> templates, such as client
> side data validation.  But processing pages are a
> different story.
> 2) What is more likely to need clustering - the
> Web/CF Server, or the SQL
> Server.  This is expected to be a high volume site.
> 
> Thank you for your time and responses.
> 
> Shawn Grover
> 
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF & DTS Packages

[cf refactoring]

I just learned how to do DTS transformations two weeks
ago, and I figured out most of it just by playing
around with the SQL Server Enterprise Manager. A good
reference is "DTS Transformations" from WROX. But you
don't need all of that. You can just use "SQL Server
2000 programming," also from WROX.

It's much better to schedule it through SQL Server. CF
isn't really made for this and it's really, really
slow (compared to SQL 2K).

--- "Bosky, Dave" <[EMAIL PROTECTED]> wrote:
> I have a user that uploads an Access database every
> 2 weeks and I want to
> create a DTS package to automatically 
> Import the data into sql server. What are some good
> references for creating
> Access->SQL DTS packages? 
>  
> Would you schedule the package to run through sql
> server or should I setup a
> scheduled task in CF to connect to the package and
> run it every two weeks?
>  
> Thanks,
> Dave


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: One call for two pages?

[cf refactoring]

Try this



  

  ...


  



  

  ... do your processing

  
  

  





--- Dave Carabetta <[EMAIL PROTECTED]> wrote:
> I'm trying to do something here that I don't think
> is possible, but thought 
> I'd throw it out there to confirm.
> 
> Quick Overview:
> I'm building an app that has a frames-based module.
> The frames are split 
> 50-50 horizontally -- nothing complex. In the top
> frame, the user makes any 
> appropriate modifications to data. On submission,
> the lower frame (which 
> contains an ongoing report) auto-refreshes to
> reflect the new data.
> 
> The problem:
> On submission, both the top frame and the bottom
> frame make the same exact 
> call to the server to get the new data. I know that
> may sound strange, but 
> believe me, it does make sense for me. I'm wondering
> if it's possible to 
> make this call to the server and have the resulting
> record set available to 
> both pages in the frame set so that I only have to
> make the call once 
> instead of twice per refresh?
> 
> Any ideas? I've been thinking along the lines of a
> hidden frame that makes 
> the call, but I can't quite put my finger on how
> that helps my situation 
> any.
> 
> Thanks in advance,
> Dave.
> 
>
_
> Send and receive Hotmail on your mobile device:
> http://mobile.msn.com
> 
>

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: SQL indexing

[cf refactoring]

--- Jeff Beer <[EMAIL PROTECTED]> wrote:
> Is there any benefit to indexing a "tinyint" field
> that is used as a boolean
> (either 1 or 0)?  I have four fields that work this
> way and I use them
> heavily in queries for reporting.  They are used in
> aggregate functions
> (count and sum) as well as in the where clauses for
> various queries.

Indexing isn't helpful unless you have a large number
of distinct values (relative to total database
entries) and may even be harmful. In the case of a
boolean field, it's a definite no no.


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Join (o8i)

[cf refactoring]

Troy,

Sorry for the late reply, but you can use this:
select
b.bid,
b.isbn,
b.title,
a.aid,
a.firstname,
a.lastname
from
book b,
author_book ab,
author a
where
b.bid = ab.bid
and
ab.aid = a.aid
and ab.aid = (
select min(aid) 
from author_book ab2
where ab2.bid = ab.bid)

This will not list both authors, however. It'll only
list the one with the lowest aid.

--- Troy Simpson <[EMAIL PROTECTED]> wrote:
> Problem: I perform a Join and I get two records for
> a book with two
> authors.  I do not really want two records.  I would
> like to have one
> record for the book with both(or more) authors on
> the same row.
> 
> Anyone run into something like this before?  If so,
> how did you resolve
> it?
> 
> Here is more information:
> There are two tables called AUTHOR and BOOK with a
> many-to-many
> relationship. The third table is an associative
> table called
> AUTHOR_BOOK. The table definitions are as follows:
>
/*==*/
> /* Database name: PHYSICALDATAMODEL_1 */
> /* DBMS name: ORACLE Version 8i2 (8.1.6) */
> /* Created on: 1/9/2002 6:24:16 PM */
>
/*==*/
>
/*==*/
> /* Table : AUTHOR */
>
/*==*/
> create table AUTHOR (
> AID NUMBER not null,
> FIRSTNAME VARCHAR2(35),
> LASTNAME VARCHAR(35),
> constraint PK_AUTHOR primary key (AID)
> )
> /
>
/*==*/
> /* Table : BOOK */
>
/*==*/
> create table BOOK (
> BID NUMBER not null,
> ISBN VARCHAR2(14),
> TITLE VARCHAR(50),
> constraint PK_BOOK primary key (BID)
> )
> /
>
/*==*/
> /* Table : AUTHOR_BOOK */
>
/*==*/
> create table AUTHOR_BOOK (
> BID NUMBER not null,
> AID NUMBER not null,
> constraint PK_AUTHOR_BOOK primary key (AID, BID),
> constraint FK_AUTHOR_B_REFERENCE_AUTHOR foreign key
> (AID)
> references AUTHOR (AID),
> constraint FK_AUTHOR_B_REFERENCE_BOOK foreign key
> (BID)
> references BOOK (BID)
> )
> /
> //
> I run the following SQL statement:
> select
> b.bid,
> b.isbn,
> b.title,
> a.aid,
> a.firstname,
> a.lastname
> from
> book b,
> author_book ab,
> author a
> where
> b.bid = ab.bid
> and
> ab.aid = a.aid
> 
> And I get the following results:
> 
>BID ISBN   TITLE 
>AID
> FIRSTNAME  LASTNAME
> -- --
> -- --
> -- ---
>  1 0-07-212188-2  Oracle8i DBA Handbook 
>  1
> Kevin  Loney
>  1 0-07-212188-2  Oracle8i DBA Handbook 
>  2
> MarleneTheriault
>  2 1-56592-578-5  Oracle SQL*Plus: The
> Definitiv  3
> Jonathan   Gennick
>   e Guide
> 
>  3 1-56592-243-3  Perl Cookbook 
>  4
> TomChristiansen
>  3 1-56592-243-3  Perl Cookbook 
>  5
> Nathan Torkington
> 
> 
> 
> I really want to list one book with both(all)
> authors as one record.  As
> you can see, if a book has two authors, I get two
> records for each
> author.  Is this possible and if so how would I
> approach this.
> 
> 
> Thanks for your time and consideration.


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFContent (and other options)

[cf refactoring]

Hi Justin,

This sounds really interesting. Can you point me to a
reference where I can learn how to build an apache
module like the one you made?

--- Justin Greene <[EMAIL PROTECTED]>
wrote:
> We created an apache module for doing this.  We
> intecept the .CFM request,
> check if it is the  page and if not, pass
> the request to Cold
> Fusion, if so, we handle the user authentication and
> return of data in the
> module.  This allowed us the flexibility of building
> in Cold Fusion with the
> performance of using a C++ module when we needed the
> speed.  Our throughput,
> including a single database call, went from about 23
> connections/sec in CF
> to 160 connections/sec with the module.
> 
> Justin
> 
> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 11, 2001 4:36 PM
> To: CF-Talk
> Subject: RE: CFContent (and other options)
> 
> 
> What do you use instead?  I've been doing some
> testing with the different
> tags and this is what I came up with:
> 
> meta tag is very difficult to backup from.  The
> users look/print the pdf
> then have to double click the back button.  And
> after making a few reports
> the thing locks up/won't back up and they have to
> log in again.
>  works great on the PC, but not for the mac
> or on our wireless.  On
> the mac you can't read the pdf in the browser and
> then it prints out funny
> (ie: losing it's landscape formatting). Also it
> wouldn't pull up the bulk
> pdfs (over 20pgs)just the individual ones (we're
> doing report cards-it'll
> pull up individual ones but not for a whole class).
> It doesn't work on the
> wireless either.
> 
>  works on almost everything, but the
> wireless and the few
> machines. On the wireless we get a msg about the
> index24  
> 
> What's the better thing to use
> 
> 
> -Original Message-
> From: Mark Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 11, 2001 4:09 PM
> To: CF-Talk
> Subject: RE: CFContent
> 
> 
> I've run into the same problem and oddly enough, it
> was with a 98
> machine. My solution, and I don't know if this is
> the right answer but
> it worked, I told the user to uninstall their
> current version of Acrobat
> Reader and re-install Acrobat Reader 5. This worked
> for anyone who had
> the problem. I've since gone away from cfcontent as
> I experienced
> inconsistent results with that bastard of a tag.
> 
> Mark
> 
> 
> 
> 
> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 11, 2001 4:00 PM
> To: CF-Talk
> Subject: CFContent
> 
> 
> I'm using CFCONTENT to call a pdf form- It does fine
> on MAC IE and most
> pc
> IE and Netscape.
> However, on one browser a 98 machine with IE5.5 I
> can't get the pdf to
> show.
> Instead there is the box and the msg says Error
> Locating Object Handler
> There is no viewer available for the type of object
> you are trying to
> open.
> The following informantion is available about this
> object.
> Address:  http://blahblah
> Content type:  text/html
> Possible location of viewer: Microsoft
> ActiveXGallery
> 
> I took the Ben Forta advice and checked the Folder
> Options in Tools of
> Windows Explorer.  I went over it piece by piece
> comparing it to the
> settings of a browser that worked- I didn't see any
> differences.
> This browser has opened pdfs when I used the meta
> tag and the embed tag
> so I
> know that it does open pdfs...any suggestions?
> Thanks in advance,
> 
> 
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: A little RegEx help . . .

[cf refactoring]

Dave H,

Your answer 
do
something

isn't correct because you will get a TRUE for the
string "012". You should use one of the many
suggestions involving mid().

--- Dave Hannum <[EMAIL PROTECTED]> wrote:
> I figured it out:
> 
> do
> something
> 
> Dave
> 
> 
> - Original Message -
> From: "Dave Hannum" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 05, 2001 12:42 PM
> Subject: A little RegEx help . . .
> 
> 
> I need to look and see if the second character of a
> three character string
> is a "0" (zero).  How would I do that?
> 
>  do something
> 8-)
> 
> Thanks,
> Dave
> 
> 
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Menu Problem

[cf refactoring]

1. Did you remember to enable client variables in your
cfapplication tag?
2. If you menu is the same for all users, why not
store it in an application scope variable?

--- Shahzad Butt <[EMAIL PROTECTED]> wrote:
>   
> Hi all
>  
> My menu is created by calling lot of custom tags and
> stored procedures. So
> its execution time is almost 1100 ms. Now if i make
> a custom tag of menu and
> call this tag in each page then definitely execution
> time of each page would
> be increase by this time. So all i want to do is
> store this menu template in
> variable using CFSaveContent or CF_BodyContent in
> Home Page. Give this
> variable a scope and call that variable on top of
> each page. If i give this
> variable session scope it works fine and execution
> time is 10 ms. But we are
> not using session variables. So i've to use client
> variable. If i convert
> this variable to wddx packet and give this wddx
> packet client scope
> (Client.MenuInWDDX) in home page. Now in each page i
> just deserialise this
> wddx packet (Client.MenuInWDDX) and display output
> variable (MenuVar). It
> should work. But problem is each page wont recoginse
> Client scoped variable.
> So either this should be in app_local.cfm of root?
> But if so then problem is
> still same cos i've to call custom tag of menu in
> app_local.cfm of root. So
> by default execution time would be 1100ms. I am
> developing this application
> using FB3. Below is code what I am doing or trying
> to do.
>  
> Home.cfm
> 
>   Fuseaction="Menu"> (Forget what
> is in this file, crazy stored procedures and custom
> tags)
> 
>  output="Client.MenuInWDDX"> 
>  
> In each page
>  input="#Client.MenuInWDDX#" output="MenuVar">
> (error wont recognise Client.MenuInWDDX)
> #MenuVar#
>  
> Can some give me any suggetion what should I do. 
>  
> Thanks a lot
> Regards
> Shahzad Butt


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: brain fart: some simple SQL

[cf refactoring]

John,

>From my knowledge of SQL, I don't think this can be
easily done. SQL can easily combine output from
different columns from either the same table or
different table, but what you're trying to do is to
combine output from the same column in different ROWS
in the same table.

That being said, what you can do is use a self-join.
One self-join will allow you to pull out two
serviceIDs per user, two self-joins will pull out 3
serviceIDs per user, etc, but as you can see, it
quickly gets unwieldy.

I'd have to have your table structure to offer a more
concrete answer.

--- John Quarto-vonTivadar <[EMAIL PROTECTED]> wrote:
> hello everyone,
> well, it's 1 am and I'm having a brainfart on
> something that is relatively
> simple:
> 
> I've got a simple LEFT JOIN, where i retrieve the
> UserID and the ServiceID's
> of Services that User needs. Since they are realted
> through a many-2-many
> relationship, I get something like
> 
> 
> UserID  ServiceID
> 1   402
> 1   417
> 1533
> 2   200
> 2   201
> 3   {null}
> 
> ok, no problem. What I *REALLY* want in the result
> set is for the ServiceID
> to be turned into a list, something like:
> 
> UserID  ServiceIDs
> 1402,417,533
> 2200,201
> 3{null}
> 
> Yeah, it's easy, but inefficient, to do with CF but
> how can I make SQL do
> this for me (esp with the {null})?  It's gonna turn
> out to be something easy
> that I've seen before, but I haven't had to write
> something like this for
> like a year and now I'm drawing a one in the morning
> blank. Is it a GROUP BY
> thing? or a sub-query thing?


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Show Running Requests Redux

[cf refactoring]

To expand on what Max said:

In application.cfm
1) if there is no structure, create a structure in the
application scope named application.requests 
2) Generate a UUID for this request
3) store request info which you want to track into
application.requests[UUID]
4) Store the time of request

In onrequestend.cfm
1) delete the struct entry for UUID

You will also need to perform cleanup of
application.requests in case of erroring out. You may
do this in two ways:
1) delete the struct entry for UUID in your
error-handling page
2) arbitrarily decide that all requests greater than
some preset length of time are invalid, and just clear
out those entries.


> You can also generate a unique ID (a UUID for
> instance, or a random number) in the application.cfm
> and log that to the DB with the request data.  The
> unique ID is then available throughout the request
> for identifying that request "thread" and is
> available in onRequestEnd.cfm to delete/close out
> that log entry in the DB.
> 
> -Max
> 
> 
> -
> Maxim Paperno, CTO
> World Design Group, Inc.
> [ CF Development and Hosting since 1996 ]
> 


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Is name locking sufficient for session vars?

[cf refactoring]

There's something that's been buggin me:

Is NAME LOCKING sufficient for session variables?

A best practice in CF is to always lock session
variable access, but it's not really clear whether
  1) NAME locking is sufficient or 
  2) should we always lock with SCOPE=SESSION?

To me, the answer seems to depend on how shared memory
is managed in CF. If session scope memory is managed
as an entire block, then we have to use SCOPE=SESSION,
because different user sessions can corrupt each
other. On the other hand, if session scope memory is
managed variable by variable, then we only need to
worry that a single variable is not simultaneously
accessed by two different threads, in which case a
NAME lock would be sufficient.

Are there any MACROMEDIA folks out there who know
enough about CFAS internals to answer this?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Any Oracle Experts on the List ???? Errors

[cf refactoring]

Sorry for the late reply. Just got back from lunch.
I've made the change to BeginDate in your code as an
example. You'll have to do the same thing to your
other dates

> 
> 

>  MonthsToDisplay,now()))#/#DaysInMonth(DateAdd("m",
> MonthsToDisplay,now()))#/#Year(DateAdd("m",
> MonthsToDisplay, now()))#">
> 
>  datasource="events"> 
> SELECT eventid, eventdate, to_char(eventdate,'')
> AS eventYear, to_char(eventdate,'MM') AS eventMonth,
> longtitle, location 
> FROM whatson 
> WHERE eventdate BETWEEN
#CreateODBCDate(BeginDate)# AND
> trunc(#CreateODBCDate(EndDate)#) 
> ORDER BY eventdate asc 
>  

--- [EMAIL PROTECTED] wrote:
> Do you have a code example of the process you have
> just specified?
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Any Oracle Experts on the List ???? Errors

[cf refactoring]

Instead of building a string for your date and
applying CreateODBCDate() to it, try building a CF
Date object using CreateDate() and applying
CreateODBCDate() to it.

If I recall correctly, CreateODBCDate() works on a
date object, not a string.
--- [EMAIL PROTECTED] wrote:
> Hi
> 
> I am getting the following Oracle error message when
> trying to run the query below, any ideas on the
> possible cause would be most appreciated
> 
> --
> 
> 
>  MonthsToDisplay,now()))#/#DaysInMonth(DateAdd("m",
> MonthsToDisplay,now()))#/#Year(DateAdd("m",
> MonthsToDisplay, now()))#">
> 
>  datasource="events"> 
> SELECT eventid, eventdate, to_char(eventdate,'')
> AS eventYear, to_char(eventdate,'MM') AS eventMonth,
> longtitle, location 
> FROM whatson 
> WHERE eventdate BETWEEN
> trunc(#CreateODBCDate(BeginDate)#) AND
> trunc(#CreateODBCDate(EndDate)#) 
> ORDER BY eventdate asc 
>  
> -
> 
>

> 
> Error Occurred While Processing Request
> Error Diagnostic Information
> Oracle Error Code = 911
> 
> ORA-00911: invalid character 
> 
> 
> The error occurred while processing an element with
> a general identifier of (CFQUERY), occupying
> document position (12:1) to (12:54).


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: AUTO TABLE WIDTH

[cf refactoring]

I believe you're looking for the CSS2 table-layout
property. As indicated on this page, it only works in
IE.
http://www.w3schools.com/css/css_reference.asp

--- William J Wheatley <[EMAIL PROTECTED]> wrote:
> :) not enough coffee
> 
> A  will now SHOW on the browser screen until 
> it reaches the 
> Because it has to read through the whole table to
> generate Widths and such
> but on large tables that can slow down the display
> of tables by a few
> seconds.
> 
> Now there is a CODE you put into the page or the
> table tag that lets the
> Browser know this is a PREDEFINED size and to
> display it on the fly
> I forget what that code is any idea?
> 
> Thanks all,
> 
> 
> Bill Wheatley
> Director of Development
> Certified Advanced ColdFusion 5 Developer
> AEPS INC
> Allaire ColdFusion Consulting Partner
> www.aeps.com
> www.aeps2000.com
> 954-472-6684 X303
> ICQ: 417645
> - Original Message -
> From: "Bud" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, November 20, 2001 10:35 AM
> Subject: Re: AUTO TABLE WIDTH
> 
> 
> > On 11/20/01, William J Wheatley penned:
> > >Whats the Code to AUTOSET the table size of a
>  so that the table
> > >does not have to get to the  before the
> table can be displayed?
> >
> > What? LOL
> > --
> >
> > Bud Schneehagen - Tropical Web Creations
> >
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development
> > [EMAIL PROTECTED]
> > http://www.twcreations.com/


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Testing SQL statements

[cf refactoring]

Oracle (or is it SQL+ ?) has a parameter which
specifies the format for dates. If you have not reset
the default, it is '30-SEP-01'

--- Angel Stewart <[EMAIL PROTECTED]> wrote:
> How in the HECK do you enter dates into Oracle?
> 
> I have tried several variations of a simple date in
> SQL Plus, and
> nothing seems to work. I keep getting an error
> saying Not a valid month.
> This is with raw SQL, not going through CF.
> 
> SELECT * FROM tblMainEntry,TblDetailEntry
> WHERE tblMainEntry.EmpID = 60597 
> AND tblDetailEntry.REcordDate = '11-30-2001';
> 
> 
> DAMMIT to HELLS!
> 
> -Gel
> 
> 
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Studio/FB question

[cf refactoring]

Studio can be scripted with VBA just like Microsoft
Office applications, so you could do that. I'm not
sure what the DOM looks like, though.

--- Bill Killillay <[EMAIL PROTECTED]> wrote:
> I use Fusebox for just about everything and I often
> find myself reusing a
> qry, or act files, etc.  I was wondering if there
> was a way to change
> ColdFusion Studio so that when you drag a file out
> to a page like fbx_switch
> that instead of it creating a hyperlink it creates a
> cfinclude?  Can this be
> done with some scripting?  Or is this something that
> needs to go to
> Macromedia?
> 
> Thanks,
> Bill
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: commas in lists

[cf refactoring]

The problem with using ListChangeDelims in this case
is that it will treat the commas within quotes the
same way as it treats the commas outside the quotes.
That's part of the original problem.

--- Raymond Camden <[EMAIL PROTECTED]> wrote:
> Instead of the Replace, don't forget you can use
> ListChangeDelims.
> 
> /CFDOCS/CFML_Reference/Functions137.html#1107244
> 
>
===
> Raymond Camden, Principal Spectra Compliance
> Engineer for Macromedia
> 
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." -
> Yoda 
> 
> > -Original Message-
> > From: cf refactoring
> [mailto:[EMAIL PROTECTED]] 
> > Sent: Friday, November 02, 2001 9:32 AM
> > To: CF-Talk
> > Subject: RE: commas in lists
> > 
> > 
> > Try this strategy:
> > 
> > // default delimiter is a comma
> > cfset myDelimiter=","
> > //if
> > If Find(yourList,'","')
> >   // replace "," by an unprintable character
> >   yourList = Replace(yourList,'","',CHR(7))
> >   // Remove opening and closing "
> >   Replace(yourList,'"',"")
> >   // Change your delimiter to CHR(7)
> >   cfset myDelimiter=CHR(7)
> > end if
> > 
> > Now pass in myDelimiter along with your list
> whenever
> > you use CF's list manipulation functions
> > 
> > P.S. I don't feel that this is a particular
> deficiency
> > of CF. I think making it "smart" enough to not
> ignore
> > quotes would be a bad thing. You just have to deal
> > with it properly.
> > 
> > > > > Well, this didn't work.  CF ignors the
> quotes
> > > and treats all
> > > > > commas it finds as delimiters
> > > > >
> > > > > Any ideas how I can allow a comma in the
> list?
> > > > 
> > > > CF is "stupid" about commas in lists, so,
> here's
> > > an idea...
> > > > 
> > > > put ", in front of the list ," at the end and
> use
> > > "," as the delimiter


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: commas in lists

[cf refactoring]

Try this strategy:

// default delimiter is a comma
cfset myDelimiter=","
//if
If Find(yourList,'","')
  // replace "," by an unprintable character
  yourList = Replace(yourList,'","',CHR(7))
  // Remove opening and closing "
  Replace(yourList,'"',"")
  // Change your delimiter to CHR(7)
  cfset myDelimiter=CHR(7)
end if

Now pass in myDelimiter along with your list whenever
you use CF's list manipulation functions

P.S. I don't feel that this is a particular deficiency
of CF. I think making it "smart" enough to not ignore
quotes would be a bad thing. You just have to deal
with it properly.

> > > Well, this didn't work.  CF ignors the quotes
> and treats all
> > > commas it finds as delimiters
> > >
> > > Any ideas how I can allow a comma in the list?
> > 
> > CF is "stupid" about commas in lists, so, here's
> an idea...
> > 
> > put ", in front of the list ," at the end and use
> "," as the delimiter
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: QUESTION: Oracle returning multi referential cursors

[cf refactoring]

Is it a problem with overall performance or individual
cfm templates? Is it the CF that's slow or the Oracle
queries? If it's Oracle, it may be poorly structured
queries, inefficient design of database tables, lack
of or misuse of table indexes, Oracle configuration
mistakes?

I think that before you go about trying to solve the
performance problem, you need to identify the part of
your system that's the bottleneck.

--- "Emily C. Grossman" <[EMAIL PROTECTED]> wrote:
> I have re-written an app using all stored procedures
> and it still runs too 
> slow (it's a series of parent-child query loops) so
> I'd like to move all 
> conditional processing to the db and run it all in
> one sproc...
> 
> is this at all possible using referential cursors?
> Can I return conditional 
> cursors? Basically either one result set, two result
> sets or four would return 
> for each major record...
> 
> Or am I going about this all wrong?
> 
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Generating reports in the background (update)

[cf refactoring]

Aidan,

  The key is not to do an immediate redirect. If you
do that, it's just running the CF page all over again.
Let the invisible frame run the .cfm report and notify
the visible frame when it's done.
  After being notified, the visible page doesn't load
the reports page directly (this would run the report
all over again). Instead, it load the variable into
which the reports page has stored all its processed
results.

--- Aidan Whitehall <[EMAIL PROTECTED]>
wrote:
> > I'd suggest the following
> > 
> > 
> >This displays "Your report is
> being
> > generated". It contains javascript that reloads
> itself
> > every 15 seconds and checks to see whether a
> variable
> > session.reportDone EQ TRUE. If yes, it returns the
> > contents of session.reportResults
> >this calls your report.cfm page.
> > report.cfm starts by setting
> session.reportDone=FALSE.
> > When it finishes, it writes its output into a
> variable
> > session.reportResults and sets
> session.reportDone=TRUE
> > (Make sure you write to reportResults before you
> write
> > to reportDone)
> > 
> 
> I've tried several variations on the frames theme
> 
>  - visible frame loads "your report is being
> created" page
>  - invisible frame triggers the report generation
> page
> This works, but to remove the frames, there's a link
> in the display page
> with TARGET="_top". However, when you click that
> link, it takes *forever* to
> go to the next page.
> 
>  - visible frame redirects with JavaScript to the
> "your report is being
> created" page
>  - invisible frame triggers the report generation
> page
> This works, but takes an age to do the JS redirect.
> 
> My next thought was to try using CFX_HTTP with
> VERB="head" instead of CFHTTP
> on the trigger template. Presumably that will start
> the process without
> having to wait for the body to be returned.
> 
> And until I can get a copy of CFX_HTTP, I'll give
> Alistair's suggestion a
> go.
> 
> 
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Macromedia ColdFusion Developer
> Fairbanks Environmental +44 (0)1695 51775


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Generating reports in the background (update)

[cf refactoring]

I'd suggest the following


   This displays "Your report is being
generated". It contains javascript that reloads itself
every 15 seconds and checks to see whether a variable
session.reportDone EQ TRUE. If yes, it returns the
contents of session.reportResults
   this calls your report.cfm page.
report.cfm starts by setting session.reportDone=FALSE.
When it finishes, it writes its output into a variable
session.reportResults and sets session.reportDone=TRUE
(Make sure you write to reportResults before you write
to reportDone)


--- Aidan Whitehall <[EMAIL PROTECTED]>
wrote:
> I'm trying to trigger a ColdFusion template that
> generates a report in the
> background. I want to start the process and then
> redirect the browser to a
> "your report is being created" page. Try as I might,
> I can't get the report
> started without the browser being forced to wait at
> some point for the
> report to be finished.
> 
> The report generation needs to be triggered
> on-demand. Updating a CFSCHEDULE
> and then running it straight away doesn't seem to
> work (I guess because it
> must be set at least 15 minutes in the future).
> 
> Calling the report making template via CFHTTP before
> using CFLOCATION
> doesn't work, as the page sits there until the
> report is finished before
> redirecting.
> 
> Using CFHTTP at the end of the "your report is being
> created" also makes
> that page take forever to be rendered. If I was
> using CF5, I guess I could
> CFFLUSH the page before doing CFHTTP last, but we're
> stuck with v4.0.1.
> 
> I can't call CFML.EXE via a URL and CFEXECUTE is
> only 4.5+.
> 
> 
> Any ideas? I've run out...
> 
> Thanks.
> 
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Macromedia ColdFusion Developer
> Fairbanks Environmental +44 (0)1695 51775


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cf excel formatting problem

[cf refactoring]

Are you on an IE-only platform?

If yes, you can try try sending an HTML table to Excel
instead of a .csv. Excel will read in an HTML table
and preserve formatting information so you can get
really fancy if you want.

--- Nathan Shaw <[EMAIL PROTECTED]> wrote:
> This is all being done dynamically. Yes, if I bring
> it
> in manually into Excel, it is not a problem at all.
> 
> What I need to know is:
> 1) how to tell Excel to treat the zip code as a text
> field OR 
> 2) how to trick Excel into thinking the zip code is
> a
> text field.
> 
> Nate
> 
>
---
> thinking aloud.
> 1) export / import as a text field
> 2) single quote at the front of the field
> 
> How are you importing / exporting?
> 
> Eric Dawson
> 
> From: Nathan Shaw <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: cf to excel formatting problem
> Date: Mon, 29 Oct 2001 10:48:29 -0800 (PST)
> 
> I am exporting some data to Excel and one of the
> fields is zip code. Excel is stripping all leading
> 0's
> (zeros) off of the zip codes. I need it to leave the
> zip code alone, i.e. treat it as text instead of a
> number. Any ideas anyone?
> 
> So far, I have tried:
> 1) Using an obscure ASCII char in front of the zip.
> RESULT: Excel puts in a box when it encounters an
> ASCII char it does not understand
> 
> 2) Enclosing the zip in both single quotes and
> double
> quotes.
> RESULT: Excel leaves the quotes in instead of
> treating
> them as a text qualifier
> 
> 3) Looked at the Allaire forums, where I saw the
> same
> question asked but not answered.
> 
> 4) Read up on Excel at cfcomet, but most things
> there
> are a little overkill for what I am trying to do.
> 
> TIA,
> 
> Nate
> 
> =
> 
> Nathan Shaw
> Senior Web Applications Developer
> iaffect, Inc.
> http://www.iaffectonline.com


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Custom tag validation error in CF Studio 5

[cf refactoring]

If you leave tag validation on, then either just
ignore the alert that CFStudion produces, or write a
vtm file so CFStudio can recognize the tag

--- Tom Jacobs <[EMAIL PROTECTED]> wrote:
> When I insert a custom tag in CF Studio 5, I'm
> getting this error:
> The tag name "CF_TagName" not found in currently
> active versions.
> However, the tag is, in fact, being found by CF 5;
> the browser 
> generates no errors and the code executes just fine.
> This problem 
> apparently started happening when I installed CF
> Studio 5. Turning 
> off Tag Validation eliminates the error. Any ideas?
> 
> Tom


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: problem

[cf refactoring]

Did you transfer over your Server >> Java Settings in
CF Administrator from your old machine to the new?
That's what your problem sounds like

--- Sima Lee <[EMAIL PROTECTED]> wrote:
> Hi All,
> 
> I am trying to figure out a problem related to
> . When in CF4.5
> everything works well.
> 
> After upgraded from CF4.5 to CF5.0, a 
> generates a
> "java.lang.ClassNotFoundException" error .
> 
>  
> The java class which is used in the  is
> contained in a .jar
> file. If use a java class which is not in a .jar
> file , the 
> seems working OK. 
> 
> 
> 
> Any help will be greatly appreciated!
> 
> 
> Sima


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: HELP! IIS 5 and Access with Netscape browser 4.75

[cf refactoring]

As far as I know, NT authentication requires that you
have IE. Even the newest version of Netscape won't do
it.

--- S V <[EMAIL PROTECTED]> wrote:
> I have removed Anonymous access in IIS5 thru
> Directory Security tab for each 
> website. Now accessing thru IE requires NT
> authentication, which is great 
> and I connect; But when I use Netscape 4.75 it does
> not accept the NT 
> login/pwd. It seems to me that Netscape is not
> allowing or screwing up 
> something, while IE has no such problem.
> 
> Is there any setup on the browser that is required
> so that a netscape 
> browser can access the website? I want to avoid
> upgrading to an newer 
> version of Netscape browser.
> 
> Any help would be GREATLY appreciated.


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT IIS question

[cf refactoring]

for IIS4 go to

http://support.microsoft.com/support/iis/install/install_iis4.asp

--- David Green <[EMAIL PROTECTED]> wrote:

> We have a very small shop and I'm trying to figure
> out how to upgrade 
> IIS to 4 or 5.I thought this happened when we
> loaded SP6 on the NT40 
> but when I go to IIS server manager help it tells me
> am running IIS 3.   

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Using CFLoop to delete from an Array

[cf refactoring]

Then you'll need to do

 "desc")>

before your loop
--- [EMAIL PROTECTED] wrote:
> That's what I was trying to do with the ListSort()
> function.
> 
> 
> H.
> 
> 
> -Original Message-
> From: Hanz Zarcovic
> [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 30, 2001 1:46 PM
> To: CF-Talk
> Subject: Re: Using CFLoop to delete from an Array
> 
> 
> I think what you are describing is a common problem.
> The problem is that when you start your loop the
> array is 7 elements long,
> you delete the first and the array is now only 6
> long , but your loop still
> thinks the array has 7 items.
> 
> The trick is to loop in reverse, from the end of
> your array *down to* the
> first item.  This way you are never trying to delete
> an item that dosen't
> exist.
> 
> Hope this helps.
> -eric
> 
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, September 30, 2001 4:08 PM
> Subject: Using CFLoop to delete from an Array
> 
> 
> > I have a form that will allow users to randomly
> select items to remove
> from
> > a form.  All of the items in the form are an Array
> of Structures.
> >
> > By clicking "remove" the number of the array
> position is identified. More
> > than remove checkbox can be checked. They can be
> checked in any order.
> >
> > Currently, if only one item is check and the
> submit button is clicked, the
> > item is removed from the Array without a problem.
> >
> > The problem comes in when there is an attempt to
> remove two or more items
> > simultaneously.
> >
> > An error such as this is displayed:
> >
> > "ArrayDeleteAt(Array, Position): Cannot delete
> element at position 7.
> > The array has only 6 elements.
> >
> > "The error occurred while evaluating the
> expression:
> > #ArrayDeleteAt(session.cart, i)#"
> >
> > I've tried various ways to get this to work, so as
> sorting the array
> (which
> > didn't work because the first element isn't a
> simple variable), and trying
> > to get the cfloop to remove the bottom item before
> the top item.  That
> isn't
> > working.
> >
> > Below is my current code, but my question is ...
> how can I loop through
> the
> > array and remove all of the items I want?
> >
> > Current Code:
> >
> >
> > #ListSort(form.remove, "numeric",
> "desc")#
> >
> > 
> >
> > 
> > #ArrayDeleteAt(session.cart, i)#
> > #ArrayResize(session.cart, 1)#
> > 
> >
> > 
> >

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFCASE Issue

[cf refactoring]

The syntax of cfswitch/cfcase is


  
  ...
  
  
  ...
  
  
  ...
  


The only place where other statements should go is in
the ...
If you place statements anywhere else within the
cfswitch/cfcase construct, then the interpreter
doesn't really know how to interpret it and you'll get
an error message (if you're lucky)

Even though your cfcase and cftransaction appear
properly nested, you should think of the cfcase and
cfswitch together as a complex tag, and inserting the
cftransaction in the middle between the two messes up
the nesting.

--- Bruce Sorge <[EMAIL PROTECTED]> wrote:
> OK.This error message is pretty straightforward:
> CFCASE 
> 
> CFCASE tag cannot appear after a CFDEFAULTCASE tag. 
> 
> The error occurred while processing an element with
> a general identifier 
> of (CFCASE), occupying document position (24:2) to
> (24:28).
> 
> However the issue is that I do NOT have a
> CFDEFAULTCASE tag ANYWHERE in 
> the application. My code is as follows:
> 
> 
>   
> 
>procedure="DeleteBCON">
> cfsqltype="CF_SQL_INTEGER"
> value="#Form.Autonumber#">
>   
>   
>procedure="ReInsertOldTest">
> cfsqltype="CF_SQL_INTEGER"
> value="#Form.Autonumber#">
>   
>   
>procedure="DeleteBCONOld">
> cfsqltype="CF_SQL_INTEGER"
> value="#Form.Autonumber#">
>   
>
> 
> 
> So what I did was to switch the CFTRANSACTION and
> the CFCASE tags 
> around, and the application worked. Could someone
> please tell me what 
> gives? I am happy that it worked, but I am just
> curious why I was told 
> that there was a problem with a tag when that tag is
> not present.
> 
> Thanks,
> 
> Bruce


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Problem with CFFILE

[cf refactoring]

Coming into this thread late
But I suggest that the two segments of problematic
code in the parent window and the child window both be
enclosed within a named cflock like name="arexcelr" 
(if you haven't already done this)

--- Jack Tumlin <[EMAIL PROTECTED]> wrote:
> Try your suggestion and still having the same
> results.
> 
> The error message I'm getting is:
> 
> "The process cannot access the file because it is
> being used by another 
> process. (error 32)"
> 
> 
> Jack Tumlin
> Vice President Business Development
> Millennium Software, Inc.
> The Software Solutions Company
> [EMAIL PROTECTED]
> www.millsoftinc.com
> 
> 
> At 04:36 PM 9/20/2001 -0500, you wrote:
> >Renaming a file takes some time.  I'm not sure how
> the internals of CF
> >work - does it send the renaming command off to
> Windows and then carry
> >on it merry way?  If so, it may be trying to delete
> a file that doesn't
> >exist *yet* at that point in time.
> >
> >An idea: let a custom tag do the deleting - if the
> file exists, it gets
> >deleted; otherwise, it trys again.
> >
> > timeout="10">
> > is "Yes">
> >  source="e:\inetpub\wwwroot\app\junk.txt"
> >
> >destination="e:\inetpub\wwwroot\app\junk.del">
> >  file="e:\inetpub\wwwroot\app\junk.del">
> >
> >
> >
> >The file, deleteFile.cfm:
> >
> >  file="e:\inetpub\wwwroot\app\junk.del">
> >
> > 
> >
> >
> >
> >---
> >Billy Cravens
> >Web Development, EDS
> >[EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >From: Jack Tumlin
> [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, September 20, 2001 3:01 PM
> >To: CF-Talk
> >Subject: Problem with CFFILE
> >
> >
> >I having a problem with a piece of code that checks
> for the existence of
> >a
> >file, renames the file, and then deletes the file.
> The code is run in a
> >child window after the user clicks the submit
> button on the parent
> >window.
> >The problem occurs when a user closes the child
> window while the thread
> >is
> >running and then clicks the submit button on the
> parent window again.
> >
> >The message appears on the NT Server saying that
> the file is missing. I
> >have tracked it down to the cffile action="RENAME"
> statement in the code
> >
> >below. It appears that the first thread is still
> processing the delete
> >when
> >the second thread is checking for the existence of
> the file. The first
> >thread then finishes and the second thread tries to
> rename the now
> >non-existence file and the error occurs.
> >
> >Is there something I'm missing with the CFLOCK
> statement. Also, this is
> >not
> >happening all the time. There is some sort of
> timing issue. I have read
> >where a delete on a NT Server does not happen right
> away. So, my
> >question
> >has anybody run into a similar problem and came up
> with a fix?
> >
> >Here is the code:
> >
> > timeout="10">
> > is "Yes">
> >  source="e:\inetpub\wwwroot\app\junk.txt"
> >
> >destination="e:\inetpub\wwwroot\app\junk.del">
> >  file="e:\inetpub\wwwroot\app\junk.del">
> >
> >
> >
> >
> >Thanks,
> >
> >Jack Tumlin
> >Vice President Business Development
> >Millennium Software, Inc.
> >The Software Solutions Company
> >[EMAIL PROTECTED]
> >www.millsoftinc.com


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfparam on dynamically numbered checkboxes

[cf refactoring]

OK, Sorry about that.

But I see your problem now


needs to be changed to 

or


Your original was checking for the existence of a
variable named "str" rather than named the contents of
str.

--- Kay Smoljak <[EMAIL PROTECTED]> wrote:
> On Thu, 20 Sep 2001 07:09:33 -0700 (PDT), cf
> refactoring
> <[EMAIL PROTECTED]> wrote:
> 
> >According to the http protocol, unchecked control
> >items such as checkboxes and radios are not sent at
> >all. Therefore, your action page will get no clue
> that
> >they exist. It's just one of those things with
> forms.
> >
> >You'll have to remember what control items you have
> in
> >your program. One common way of dealing with it is
> to
> >do 's for all your checkboxes in your
> action
> >page.
> 
> Thanks, but if you look at the code I posted with my
> question, you'll
> see that's exactly what I am doing. Any ideas what
> else could be wrong.
> 
> >--- Kay Smoljak <[EMAIL PROTECTED]> wrote:
> 
> >> I have a dynamically generated form, with
> numbered
> >> fields. I have the
> >> following code on my action page to set all
> >> checkboxes to 0 by default
> >> (the hardcoded 50 is for testing purposes):
> >> 
> >> 
> >> >> "#numberformat(p,"00_")#"> 
> >>
> >>#str#
> >> 
> >> 
> >> The cfoutput bit at the end is displaying the
> >> correct formfield names:
> >> form.include001, form.include002 etc etc. These
> are
> >> the same as the
> >> formfields on the form page. 
> >> 
> >> Later down in the action page, however, trying to
> >> display the values of
> >> the formfields is throwing an "Error resolving
> >> parameter
> >> FORM.INCLUDE001" if the checkbox on the form is
> not
> >> checked. It's got me
> >> completely stumped. If it is checked it all works
> >> fine. So it looks like
> >> there is something wrong with the cfparam
> statement.
> >> Any ideas?
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Please Help: Parsing URL into Array and structure

[cf refactoring]

MaintenanceEditTable.cfm?table=tlkpStatus&tableCols=Statno,

Status&ColOptions=name:Statno;width:100,
name:Status;width:300

Jason,

If the above was the URL you sent to the script, then
it should barf on array element 2. There's a space
between "," and "name" that will cause problems

--- "Snyder, Jason" <[EMAIL PROTECTED]> wrote:
> I am working on parsing a URL string and storing it
> in an array of structures.  I am to the point where
> it works to a certain extent, but not to the point
> where I need it.  To be more specific I am passing a
> string that should be parsed into two structure
> elements in the array.  The data seems to be
> inserted, but but when I try to access the structure
> key 'name' in array element 1 it comes up while
> array element 2 does not.  Here is the Query string
> that I am passing:
> 
>
MaintenanceEditTable.cfm?table=tlkpStatus&tableCols=Statno,
> Status&ColOptions=name:Statno;width:100,
> name:Status;width:300
> 
> In this URL string I pass the database table name. 
> Then I pass table columns.  The I pass column
> options in the following format:
> 1. Comma delimits columns.
> 2. Semicolon delimits options for a column.
> 3. Colon delimits option / value pair.
> 4. Name option is required.  (Specifies name of
> column.)
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfparam on dynamically numbered checkboxes

[cf refactoring]

Kay,

According to the http protocol, unchecked control
items such as checkboxes and radios are not sent at
all. Therefore, your action page will get no clue that
they exist. It's just one of those things with forms.

You'll have to remember what control items you have in
your program. One common way of dealing with it is to
do 's for all your checkboxes in your action
page.

--- Kay Smoljak <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> I have a dynamically generated form, with numbered
> fields. I have the
> following code on my action page to set all
> checkboxes to 0 by default
> (the hardcoded 50 is for testing purposes):
> 
> 
>"#numberformat(p,"00_")#"> 
>   
>   #str#
> 
> 
> The cfoutput bit at the end is displaying the
> correct formfield names:
> form.include001, form.include002 etc etc. These are
> the same as the
> formfields on the form page. 
> 
> Later down in the action page, however, trying to
> display the values of
> the formfields is throwing an "Error resolving
> parameter
> FORM.INCLUDE001" if the checkbox on the form is not
> checked. It's got me
> completely stumped. If it is checked it all works
> fine. So it looks like
> there is something wrong with the cfparam statement.
> Any ideas?
> 
> Thanks,
> Kay.
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cflocation/javascript

[cf refactoring]

Reply follows...
--- Garry Red 5 <[EMAIL PROTECTED]> wrote:

> We have a problem involving cflocation. In our code
> we have a user-intensive
> form, and when this is processed various
> (complicated) checks are performed
> to ensure data validity. If the numbers entered do
> not meet certain
> conditions, the page uses cflocation to redirect to
> a standard error page.
> However we have received emails suggesting that
> sometimes when this happens,
> and the user pressed back on their browser, their
> inputted data is lost and
> they have to enter it all again.

Some browsers will clear formfields upon a back
button. There's nothing simple that you can do about
that unless you want to rearchitect how you handle
forms.

One way you can rearchitect is to 
1. when the form submit button is pressed, disable the
submit and send data to a validation script in a
hidden frame.
2. after validating using the hidden frame,
if OK,
  send back javascript which submits the form in the
original form frame
if not OK,
  send back javascript which opens a small window
informing the user what validation was not used.

Since the original form frame isn't actually submitted
until it has been validated, then the browser never
clears the form fields and the user retain his/her
data.

By the way, your cflocation code should not work
because of the client/server issue you cited.

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Listcontains question

[cf refactoring]

You should use ListFind rather than ListContains

--- "van Wyk, Carlo" <[EMAIL PROTECTED]>
wrote:

> 
>   
>   
>   
>   #application.securityerror#
>   
> 
> 
> Regards
> Carlo

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Format Tables (Was RE: CF to excel)

[cf refactoring]

Janine,

There seems to be an error in your posted code, as you
have 3 s to 2 . I'm surprised CF
didn't give you an error message.

It looks to me like you need to take the
#Skill# 
outside so it isn't nested inside 


I'd do something like


#Skill# 

...

Also, there's a place where it reads



where the  should go inside of 

--- Janine Jakim <[EMAIL PROTECTED]> wrote:
> Ok I answered question 2.  I found that using
> #Skill# will go
> through all the skills so that
> I don't need to do Skill1, Skill2, Skill3
> Now I still have the issue of my headers showing up
> before each student.
> This is my code:
>   
>   
>   
>   
>  #Skill#
>  
>   
>   
>   #LASTNAME#, #FIRSTNAME#
>   
> 
>#Grade#
>
>   
>   
>   
> 
> -Original Message-
> From: cf refactoring
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 18, 2001 10:38 AM
> To: CF-Talk
> Subject: Re: Format Tables (Was RE: CF to excel)
> 
> 
> Can you show us the looping code? It's probably an
> error in reusing too much of the sample code
> 
> --- Janine Jakim <[EMAIL PROTECTED]> wrote:
> > Thanks for all the input. Now for the next
> question.
> >  I am having a hard
> > time formatting my html table correctly. I am
> using
> > #Skill[1]#
> > #Skill[2]# in the heading (I have also
> > tried making it just a
> > regular .  But unfortunately it
> is
> > giving each student a
> > heading.
> > ie: Reading MathSpelling
> > JSmith  A   A   A
> > Reading MathSpelling
> > SJones  B   B   B
> > 
> > So I have 2 questions:
> > 1. Is there a way to get the heading to be for the
> > whole page when I am
> > using a variable?
> > 2.  Is there a way to make the #skill[1]#
> > #Skill[2]#, etc. expand/constrict
> > accordingly.
> > (ie: 5th grade Math has 3 skills/ reading has 16
> > skills whereas 1st grade
> > math has 21 skills and 19 reading skills) I
> > don't want to have to make a
> > different page for each subject/grade.  If I just
> > put #Skill# in the header
> > it only gives me the 1st skill... Any ideas???
> > 
> > -Original Message-
> > From: John Anderson [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 17, 2001 4:00 PM
> > To: CF-Talk
> > Subject: RE: CF to excel
> > 
> > 
> > You can create an html table and output that is an
> > excel file as follows:
> > 
> > 
> > 
> > 
> > 
> > 
> > First Name">
> > Last
> > Name">
> > Office
> > Phone">
> > Mobile
> > Phone">
> >  > &"Pager">
> > 
> >  >
>
&"#empfirstname##emplastname##officep##ce
> > ll##pager#">
> > 
> > ">
> > 
> > 
> > 
> >  VALUE="inline;
> > filename=download.xls">
> > 
> > #excelstring#
> > 
> > 
> > 
> > This output string that you have built will come
> > across as an excel file.
> > 
> > The key is in the cfcontent tag and cfheader tag.
> > 
> > John Anderson
> > aloha-webdesign.com
> > 
> > -Original Message-
> > From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 17, 2001 12:40 PM
> > To: CF-Talk
> > Subject: CF to excel
> > 
> > 
> > How flexible is the process of generating excel
> > files?
> > I need to have an output that is dynamic for the
> > columns and rows.
> > For example:
> > 
> > #student#   #student#   #student#   #student#
> > #Skill# #grade# #grade# #grade# #grade#
> > #Skill# #grade# #grade# #grade# #grade#
> > #Skill# #grade# #grade# #grade# #grade#
> > 
> > Translating into:
> > JohnSmith   JanSmithSamJonessandyJones
> > Reading C  A   A   B
> > MathB  A

Re: Format Tables (Was RE: CF to excel)

[cf refactoring]

Can you show us the looping code? It's probably an
error in reusing too much of the sample code

--- Janine Jakim <[EMAIL PROTECTED]> wrote:
> Thanks for all the input. Now for the next question.
>  I am having a hard
> time formatting my html table correctly. I am using
> #Skill[1]#
> #Skill[2]# in the heading (I have also
> tried making it just a
> regular .  But unfortunately it is
> giving each student a
> heading.
> ie:   Reading MathSpelling
> JSmithA   A   A
>   Reading MathSpelling
> SJonesB   B   B
> 
> So I have 2 questions:
> 1. Is there a way to get the heading to be for the
> whole page when I am
> using a variable?
> 2.  Is there a way to make the #skill[1]#
> #Skill[2]#, etc. expand/constrict
> accordingly.
> (ie: 5th grade Math has 3 skills/ reading has 16
> skills whereas 1st grade
> math has 21 skills and 19 reading skills) I
> don't want to have to make a
> different page for each subject/grade.  If I just
> put #Skill# in the header
> it only gives me the 1st skill... Any ideas???
> 
> -Original Message-
> From: John Anderson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 4:00 PM
> To: CF-Talk
> Subject: RE: CF to excel
> 
> 
> You can create an html table and output that is an
> excel file as follows:
> 
> 
> 
> 
>   
>   
>   First Name">
>   Last
> Name">
>   Office
> Phone">
>   Mobile
> Phone">
>&"Pager">
>   
>   
&"#empfirstname##emplastname##officep##ce
> ll##pager#">
>   
>   ">
>   
> 
> 
> 
> 
> #excelstring#
> 
> 
> 
> This output string that you have built will come
> across as an excel file.
> 
> The key is in the cfcontent tag and cfheader tag.
> 
> John Anderson
> aloha-webdesign.com
> 
> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 12:40 PM
> To: CF-Talk
> Subject: CF to excel
> 
> 
> How flexible is the process of generating excel
> files?
> I need to have an output that is dynamic for the
> columns and rows.
> For example:
> 
>   #student#   #student#   #student#   #student#
> #Skill#   #grade# #grade# #grade# #grade#
> #Skill#   #grade# #grade# #grade# #grade#
> #Skill#   #grade# #grade# #grade# #grade#
> 
> Translating into:
>   JohnSmith   JanSmithSamJonessandyJones
> Reading   C  A   A   B
> Math  B  A   B   A
> English   B  B   A   C
> 
> My tables are normalized. There are many tables that
> make this info.
> 1.  One reference table that lists all the skills. 
> 2.  One table that shows student information.
> 3.  One table that lists the studentID/skillID/Grade
> (hooks the student info
> with the skills reference table).
> 4.  One reference table that lists the quarter and
> dates of the quarter so
> only the current quarter prints out.
> Is this possible?
> What are the steps to making it so?  Do I need to
> make the information into
> an array(s) first?
> I've read the how to from Ben's CF5 book and the
> tutorial from cfcomet.com-
> but of course I want to make things more difficult.
> Thanks in advance.
> 
> 
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF to excel

[cf refactoring]

Excel can read the following kinds of files:

comma delimited files
tab delimited files
HTML tables

I prefer HTML tables as you get to keep all the
formatting information.

For example, if you cut and paste the following table
code into a file


  
heading
italic
colored
  
  
data
one
two
  


You can open it with excel and see the result.

This doesn't exactly answer your question as I'm not
sure exactly how dynamic you need your data to be.

--- Janine Jakim <[EMAIL PROTECTED]> wrote:
> How flexible is the process of generating excel
> files?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Application security

[cf refactoring]

You might try token-based security:

When the user logs in, they're given a set of security
tokens. When the user takes action on a page, the page
checks to see if they have the tokens before
proceeding.

Tokens can be hierarchical, e.g.

App1 = general user token for app1
App2 = general user token for app2
App1.production = app1 token for user from production
App1.production.admin1 = app1 token for admin from
production with level 1 admin rights
App1.production.admin2 = app1 token for admin from
production with level 2 admin rights

so you might have someone log in and get a


to indicate their permissions.

--- Aidan Whitehall <[EMAIL PROTECTED]>
wrote:
> > We use a Security structure like this:
> > 
> > SecLevel.Admin = 1
> > SecLevel.Update = 2
> > SecLevel.Public = 3
> > [ snip ]
> 

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Question - SUM weirdness

[cf refactoring]

OT observation: this doesn't directly relate to your
problem, but you have no table join condition on
tblUsers in your query.
> 
> Query:
> SELECT
>   u.first_nm
> , u.last_nm
> , c.category_nm
> , c.category_id
> , c.dataType
> , c.department_id
> , SUM(dn.quantity_nb)AS totalForMonth
> , g.goal_nb
> FROM
>   tblcategories c
> , tblDailyNumbers dn
> , tblUsers u
> , tblGoals g
> WHERE
>   c.department_id = 1
> AND
>   DatePart("mm", dn.date_dt) = 9
> AND
>   DatePart("yy", dn.date_dt) = 2001
> AND
>   c.Category_id   *= g.Category_id
> AND
>   c.category_id *= dn.category_id
> GROUP BY
>   u.last_nm
> , c.category_nm
> , c.category_id
> , c.department_id
> , g.goal_nb
> , c.dataType
> , u.first_nm


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Reg Exp help

[cf refactoring]

You don't really need a regexp for this:
Either the GetToken function or ListGetAt will do




month=#month# year=#year#

--- John Barleycorn <[EMAIL PROTECTED]> wrote:
> Gang, given the date 8/8/2001, how would i use a
> regular expression to set 
> the variables for month, day, and year. I know what
> i need to do, but i'm 
> just not sure how to do it with a Reg Exp


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: filled up a client var

[cf refactoring]

On a previous project, one of the developers wrote a
script to cut up the serialized client variables into
4K chunks, and then put them back together when he
pulled them out of the database. Of course, he had to
forego the use of CF's client variables.
--- Chris Norloff <[EMAIL PROTECTED]> wrote:
> Thanks.  Yes, that's pretty much what's happening
> here.  I think what we'll do is create a table to
> insert items one at a time, so we don't go over the
> 4000 character limit when the client variables are
> all inserted at once.
> 
> thanks,
> Chris Norloff
> 
> 
> -- Original Message
> --
> from: "Mike Townend" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Thu, 13 Sep 2001 17:56:56 +0100
> 
> >Depends on what you are doing... I recently had the
> same problem.. I was
> >saving the results of a db search to a wddx packet
> in a client var...
> >Till it got too big.
> >
> >My work around was to save the search params in the
> client var and
> >requery the database to reget the same results
> >
> >
> >
> >-Original Message-
> >From: Chris Norloff [mailto:[EMAIL PROTECTED]] 
> >Sent: Thursday, September 13, 2001 16:41
> >To: CF-Talk
> >Subject: filled up a client var
> >
> >
> >Hi, I've just filled up a client variable - what
> now?
> >
> >Though the "Long" data field in the CDATA table can
> handle up to 2GB,
> >we're getting an Oracle error (no. 1704) that the
> "string literal too
> >long" - apparently there's a 4000-character
> limitation.  I've exceeded
> >that with my 6500-character WDDX packet stored in a
> client variable. 
> >
> >To use a longer string we need to use bind
> variables in Oracle - the
> >database guys are working on that now.
> >
> >Anybody else deal with this?
> >
> >thanks,
> >Chris Norloff
> >
> >
> >
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Left Outer Join Question

[cf refactoring]

Kamie,

You'll need four separate queries for this.

When you JOIN(c.company_id=srl.company_id) and SELECT 
Count(srl.company_id), you get a count of all the srl
matches with a certain company id.

When you JOIN(c.company_id=srl.company_id) AND JOIN
(c.company_id=el.company_id), you get all the srl
matches, and then FOR EACH OF THOSE MATCHES, you also
get all el matches with the company id. Hence there's
a multiplier effect.

--- Kamie Curfman <[EMAIL PROTECTED]> wrote:
> I know this is more SQL than CF, but this list is so
> responsive...
> 
> I'm trying to do a query that counts how many times
> a particular company
> showed up in the search results log table, how many
> times its URL was
> clicked on, etc.  So, I'm left outer joining all the
> log tables, on the
> chance that the company wasn't returned in any of
> the searches, its URL
> was never clicked on, etc.  I thought the below
> logic was sound, but
> instead of getting "14" for search_count, "4" for
> enhanced_count, "1"
> for click_through_count, and "1" for
> contact_me_count, I'm getting "56"
> for all.  In other words, 14*4*1*1.  Why is this
> happening?  Why aren't
> I getting separate counts for each?
> 
> Here is the query.  Thank you so much in advance.
> 
>  name="get_company">
>SELECT c.company, COUNT(srl.company_id) AS
> search_count,
> COUNT(el.company_id) AS enhanced_count,
> COUNT(ctl.company_id) AS
> click_through_count, COUNT(cfl.company_id) AS
> contact_me_count
>FROM dbo.Companies c
>   LEFT OUTER JOIN dbo.Search_Results_Log srl ON
> (c.company_id=srl.company_id)
>   LEFT OUTER JOIN dbo.Enhanced_Log el ON
> (c.company_id=el.company_id)
>   LEFT OUTER JOIN dbo.Click_Through_Log ctl ON
> (c.company_id=ctl.company_id)
>   LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON
> (c.company_id=cfl.company_id)
>WHERE c.company_id= value="#attributes.report_company#"
> cfsqltype="cf_sql_integer">
>GROUP BY company
>  
> 
> Kamie
> 
> --
> Kamie B. Curfman
> Matrix Group International, Inc.
> 801 N. Fairfax Street, Suite 205
> Alexandria, VA 22314
> Phone: (703) 838-9777 x3014
> Fax: (703) 838-9799
> [EMAIL PROTECTED]
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

experience with cfm-resources

[cf refactoring]

Has anyone had any experience with cfm-resources.com's
free or low-cost accounts? I tried to register but am
having problems and getting no email responses.

Or, can anyone recommend some cf hosting at less than
$30 a month?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: RegEx for searching in Studio

[cf refactoring]

try 
2]+(sometemplate\.cfm)([^2>]|([^e]2)|([^t]e2))*>
(Make sure 'match case' is not clicked)

I've tested this in studio. This will find all
instances of CFMODULE where the string
'sometemplate.cfm' occurs but where the string 'te2'
does not occur (I've taken your problem literally to
mean that you don't want 'Attribute2', because there
is no general regexp expression which will work with
every choice of name of the parameter attribute2).

--- Aidan Whitehall <[EMAIL PROTECTED]>
wrote:
> I need to add an attribute to a tag within an
> application so (and this is a
> very over-simplified example, BTW) I can find all
> instances of
> 
> TEMPLATE="sometemplate.cfm"
>Attribute1="#session.Attribute1#">
> 
> and make them:
> 
> TEMPLATE="sometemplate.cfm"
>Attribute1="#session.Attribute1#"
>Attribute2="#session.Attribute2#">
> 
> Is there a RegEx which says "Find all instances of
> the string
> 'sometemplate.cfm' where the string 'Attribute2'
> doesn't appear before the
> next '>'"?
> 
> 
> 
> Thanks
> 
> 
> Aidan
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Macromedia ColdFusion Developer
> Fairbanks Environmental +44 (0)1695 51775
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session Variables and directories

[cf refactoring]

Did you check for a  tag in your sales
directory? it might very well be in your
Application.cfm file.

--- Ben Densmore <[EMAIL PROTECTED]> wrote:
> I am currently working on an order entry app and
> created a login screen 
> before a user can get to the actual app. When they
> login in I am 
> creating several session variables which work, but
> once a person is 
> logged in successfully they get taken to a page
> which is in another 
> directory. So if the user is part of the sales dept
> they go to the sales 
> directory, the problem I am having is once they go
> into that directory I 
> can't read any session variables. Shouldn't these
> session variables be 
> kept throughout the entire app even if it some of
> the pages are in 
> different direcotries.
> 
> Thanks,
> Ben Densmore



=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: case sensitive sql query

[cf refactoring]

>SQL Queries ARE NOT case sensitive when doing a WHERE
>that involves a varchar.  
They should be unless there's been a nonstandard
implementation of SQL. I'm not familiar with SQL
Server, so I don't know about that, but on Oracle it
doesn't matter whether the underlying column type is
CHAR or VARCHAR -- it's always case sensitive.

--- Alex Santantonio <[EMAIL PROTECTED]> wrote:
> SQL Queries ARE NOT case sensitive when doing a
> WHERE that involves a
> varchar.  The way to do a Case sensitive WHERE
> clause depends largely on the
> database that you are using.  If you are using SQL
> Server 7/2000 then it is
> quite simple.  It is even more simple if you are
> using Stored Procedures to
> perform this task.  Just use CAST to force your
> value to binary data and
> then compare based on the returned binary data. 
> CAST(ColumnName AS
> VARBINARY(ColumnLength)) = CAST('Test Query' AS
> VARBINARY(ColumnLength)) in
> your WHERE within your Stored Procedure.  Once you
> have that set, just make
> the 'Test Query' string in your Stored Procedure
> into a @sp_variable and
> pass in the value you are searching on.  CAST is
> preferred over CONVERT.
> 
> Alex Santantonio, 
> Lead Developer
> Macromedia Coldfusion 5 Certified Professional
> Macromedia Certified Web Site Developer
> [EMAIL PROTECTED] 
> www.doceus.com
> 
> -Original Message-
> From: cf refactoring
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 31, 2001 9:11 AM
> To: CF-Talk
> Subject: Re: case sensitive sql query
> 
> SQL SELECT queries ARE  case sensitive.
> 
> The problem is in your data -- you're using
> columnames
> from your tables as data. Depending on the database,
> this information is stored in auxiliary tables (in
> Oracle, it would be in a table like
> "all_tab_columns"), and may be in a case-insensitive
> form. For example, in Oracle, if I run
> 
> select column_name, table_name from all_tab_columns
> 
> then I see that all the column_names and table_names
> are all uppercase even though when I created the
> tables, I had mixed case for the table and column
> names
> 
> 
> --- Bernd VanSkiver <[EMAIL PROTECTED]> wrote:
> > Is there a way to do a case sensitive SELECT
> query?
> > Don't want to make a
> > server wide change, just want to specify a single
> > query to do a case
> > sensitive search.
> >
> > SELECT ColumnName
> > FROM tableName
> > WHERE ColumnName = 'Test Query'
> >
> > Want this to do a case sensitive search on the
> WHERE
> > clause.
> >
> > Bernd VanSkiver
> > [EMAIL PROTECTED]
> > ColdFusion Developer
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: adding counts

[cf refactoring]

I think you just need to add something to your WHERE
clause.

For example, if you just want to count U+E, use

WHERE ((T_ABS.ABSDATE >= T_Quarter.BegQuarter) AND
  (T_ABS.ABSDATE <= T_Quarter.EndQuarter)) 
AND   (
(T_ABS.ABSType = 'U') 
OR
(T_ABS.ABSType = 'E') 
  )

--- Janine Jakim <[EMAIL PROTECTED]> wrote:
> ABSType is the column being counted. In it there are
> several different codes
> that are used depending on what is appropriate for
> the student.  They
> include:
> T=Tardy
> U=Unexcused Absence
> E=Excused Absence
> So my query does fine in the sense that it counts
> how many T/E/U each
> student has.  The next step is to add E+U= Total
> Absences
> I assume it needs to happen outside the query?
> 
> -Original Message-
> From: cf refactoring
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 30, 2001 4:31 PM
> To: CF-Talk
> Subject: Re: adding counts
> 
> 
> Can you show your table structure? 
> I need to know how do you distinguish absent from
> tardy from excused from unexcused? Where in the
> table
> is it located and how is the information
> represented?
> 
> --- Janine Jakim <[EMAIL PROTECTED]> wrote:
> > I've got a query that counts how many times a
> > student is absent/tardy.  It
> > outputs fine  BUT i need it to do things slightly
> > differently- I need to
> > combine a couple of the codes to make a total (For
> > example 3 Excused +2
> > Unexcused= 5 absences).  What is the best way to
> do
> > this?
> > 
> > 
> > SELECT T_ABS.QUARTER, T_ABS.ID,
> Count(T_ABS.ABSType)
> > AS CountOfABSType,
> > T_ABS.DAYTITLE
> > FROM T_ABS, T_Quarter 
> > WHERE ((T_ABS.ABSDATE >= T_Quarter.BegQuarter) AND
> > (T_ABS.ABSDATE <=
> > T_Quarter.EndQuarter)) 
> > GROUP BY T_Quarter.QUARTER, T_ABS.ID,
> T_ABS.DAYTITLE
> >  
> > 
> > So how do I get my CountOfABSType to do this?
> > Thanks in advance.
> > j
> > 
> >


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: case sensitive sql query

[cf refactoring]

SQL SELECT queries ARE  case sensitive.

The problem is in your data -- you're using columnames
from your tables as data. Depending on the database,
this information is stored in auxiliary tables (in
Oracle, it would be in a table like
"all_tab_columns"), and may be in a case-insensitive
form. For example, in Oracle, if I run

select column_name, table_name from all_tab_columns

then I see that all the column_names and table_names
are all uppercase even though when I created the
tables, I had mixed case for the table and column
names


--- Bernd VanSkiver <[EMAIL PROTECTED]> wrote:
> Is there a way to do a case sensitive SELECT query? 
> Don't want to make a
> server wide change, just want to specify a single
> query to do a case
> sensitive search.
> 
> SELECT ColumnName
> FROM tableName
> WHERE ColumnName = 'Test Query'
> 
> Want this to do a case sensitive search on the WHERE
> clause.
> 
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: adding counts

[cf refactoring]

Can you show your table structure? 
I need to know how do you distinguish absent from
tardy from excused from unexcused? Where in the table
is it located and how is the information represented?

--- Janine Jakim <[EMAIL PROTECTED]> wrote:
> I've got a query that counts how many times a
> student is absent/tardy.  It
> outputs fine  BUT i need it to do things slightly
> differently- I need to
> combine a couple of the codes to make a total (For
> example 3 Excused +2
> Unexcused= 5 absences).  What is the best way to do
> this?
> 
> 
> SELECT T_ABS.QUARTER, T_ABS.ID, Count(T_ABS.ABSType)
> AS CountOfABSType,
> T_ABS.DAYTITLE
> FROM T_ABS, T_Quarter 
> WHERE ((T_ABS.ABSDATE >= T_Quarter.BegQuarter) AND
> (T_ABS.ABSDATE <=
> T_Quarter.EndQuarter)) 
> GROUP BY T_Quarter.QUARTER, T_ABS.ID, T_ABS.DAYTITLE
>  
> 
> So how do I get my CountOfABSType to do this?
> Thanks in advance.
> j
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists