Re: CF 4.5 on Win2K SBS & ISA

[Kay Smoljak]

On Wed, 13 Jun 2001 18:47:09 +0200, "Michael Lugassy" <[EMAIL PROTECTED]>
wrote:

>I had a BIG ISSUE with cookies about a week ago.
>If the problem occurs in all of your pages (i.e - each page terminates the
>cookie)
>there must be something wrong with your application.cfm file.
>
>try deleting all rows in it (and I mean each row)!
>your problem maybe lie between a custom tag or code block.

It's not the code... it's something to do with the firewall or proxy, or
maybe CF. It's happening on old applications that were working on the old
NT4 server, and have not been touched for months.

K.

>> Hi all,
>>
>> Our internal network was recently rebuilt with Win2k Small Business
Server
>> 2000. It seems that ISA is trashing cookies, with code that was
previously
>> working.
>>
>> I have a page that sets some client vars. In the Application.cfm cookies
>are
>> set to on and storage to the database, which is set up and actually
>working
>> fine. The client vars are visible on the page on which they are set, but
>> when you move to another page they are undefined. There are no
cflocations
>> or other cookie crunching munsters... as I said, the code was working
>> perfectly before the rebuild.
>>
>> Does anyone have any clues as to what this may be? A setting somewhere
>> within CF or ISA? Our network admin (also the MD, LOL) has no clue what
it
>> could be, and the book is on order. But I need it running tomorrow to
show
>a
>> client!



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

Allaire Software Gets a Boost from Mozquito TechnologiesNew Xhtml-Fml Tags Bring Extensibility to Allaire's Homesite

[Jon Hall]

http://www.xml.org/xml/newsreport_article.shtml?SMContentIndex=3&SMContentSet=0

Very cool stuff, the future of web design I imagine. If not their 
product in particular, at least the technology behind it.
Their site is very cool too, especially the tutorials.

jon


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

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

RE: WYSIWYG editors

[Eric Dawson]

i think it just shows a textarea field - rather than a wysiwyg editor field. 
if you wanted to get into the code, I imagine you could swap something else 
for that case. Not sure what works though ... but I do know there are a few 
options ...

In fact, you got me curious ... if I find the time, I'll try to post a list 
of different editors


From: Sean McCarthy <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: WYSIWYG editors
Date: Wed, 13 Jun 2001 18:46:49 -0400

Thanks Mike I like that one too but unfortunately they (ezedit) require IE 5
and our corp standard is IE 4.  Im curious as to what hell would break loose
if it was used with IE 4 but have no way of testing it at the moment.

Sean


 > Check out www.siteobject.com They have a free editor and it
 > is pretty cool
 >
 > Michael Bruce
 > Fig Leaf Software
 >
 > -Original Message-
 > From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
 > Sent: Wednesday, June 13, 2001 2:05 PM
 > To: CF-Talk
 > Subject: WYSIWYG editors
 >
 >
 > Hi,
 >  I am in search of a WYSIWYG editor that will allow a
 > user to enter a
 > news article and have it display in HTML format.  I have
 > looked at several
 > different ones but am looking for some feedback as to what is most
 > preferred, affordable (free), and easy for the user.
 >  I have looked at EasyEdit
 > http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I
 > really liked the
 > interface on this one but it has to work with IE 4.0 and
 > unfortunately this
 > CF tag needs at least IE 5.0.
 >  ActiveEdit
 > http://www.cfdev.com/activedit2/executive.cfm also looks
 > good but is kinda awkward how you have to click the link
 > after updating to
 > see your results.  Thanks for your feedback.
 >
 > -Sean McCarthy
 > ---
 > HealthObjects
 > 410-895-0379
 >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Reservation System

[admin]

Thanks Mark- Just trying to keep my job !
- Original Message -
From: "Mark Warrick" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 6:51 PM
Subject: RE: Reservation System


> You're right.  It is rather bold to ask someone to do something for you
for
> free that you're going to profit off of.
>
> Have you considered slave labor?  I hear in some countries that's still
> legal.
>
> Take my message lightly.  I'm playing with you.  But you might want to
pass
> along the message to your boss.
>
> ---mark
>
> 
> Mark Warrick - Fusioneers.com
> Personal Email: [EMAIL PROTECTED]
> Business Email: [EMAIL PROTECTED]
> Phone: 714-547-5386
> Efax: 801-730-7289
> Personal URL: http://www.warrick.net
> Business URL: http://www.fusioneers.com
> ICQ: 125160 / AIM: markwarric
> 
>
> > -Original Message-
> > From: admin [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 6:10 PM
> > To: CF-Talk
> > Subject: Reservation System
> >
> >
> > I know this is a bit bold, but a customers has asked me to knock
> > up a site for him in a hurry. What he needs is a reservation
> > system for his four rental properties. I was just wondering if
> > any one has done anything similar and has some code I could plagiarize.
> >
> > Many thanks in advance
> >
> > Richard
> > Y2K Internet Technologies
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: URL Hacks

[Rey Bango]

Don,

I can sympathize man. Check out the CF_Scriptkill tag in the Allaire
developer's exchange. It should help out.

Rey Bango
Team Allaire...

- Original Message -
From: "Don Vawter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 7:10 PM
Subject: URL Hacks


> Having recently suffered (not too much fortunately) through an attempt of
a
> hacker to corrupt a database by embedding sql in url paramaters I have put
> together a few tips on preventing these attacks from being successful. I
> realize that this is not new (I first heard of if at least 2 years ago)
but
> sometimes a little reminder doesn't hurt because obviously the hackers are
> still out there.
>
> If anyone has any interest it is at: http://www.vawter.com/urlhack.cfm
>
> HTH
>
> Don Vawter
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Mutiple Select

[David Shadovitz]

Please explain exactly what you're after.
-David

On Wednesday, June 13, 2001 7:31 PM, David Clay [SMTP:[EMAIL PROTECTED]] 
wrote:
> Need Help. I am looking for code to be able reselect the options on a 
multiple
> select form field for and edit page.

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

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

Mutiple Select

[David Clay]

Need Help. I am looking for code to be able reselect the options on a multiple select 
form field for and edit page.

Thank you for your time. It is appreciated.

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
   
   
   
   
   
   
   



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

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

Re: Reservation System

[Rey Bango]

Here ya go, bud. It'll cost you $500 bucks.

http://www.cfhosting.com/RentalGuide.cfm

Rey Bango
Team Allaire...


- Original Message -
From: "admin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 9:09 PM
Subject: Reservation System


> I know this is a bit bold, but a customers has asked me to knock up a site
for him in a hurry. What he needs is a reservation system for his four
rental properties. I was just wondering if any one has done anything similar
and has some code I could plagiarize.
>
> Many thanks in advance
>
> Richard
> Y2K Internet Technologies
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: WYSIWYG editors

[lists]

Josh,

We have never charged anything for ezEdit, other than custom integration
contracts.  You must be confused.  Being the developer and sole
supporter of this product, I don't recall ever being contacted by you.

If you did indeed purchase our ezEdit product
(http://www.siteobjects.com/examples/ezedit_scratchpad.cfm) I would like
to know where you purchased it from.  We strictly prohibit the resale of
this this component in our license, and this would make me quite upset.


You are though, correct in the fact that we are not supporting this
product(ezEdit) anymore, I only have a finite amount of time and I am
very busy working on version 2.0 (soEditor currently in beta).  Please
understand, this is a free product, and support really takes up a lot of
time.

soEditor is a much more solid product and our next beta release will
really bring things together.  I am happily accepting enhancement
requests as well as taking care of any bug fixes in soEditor.  So feel
free to join the team.

Information, downloads & _support_ can be had here:
http://forums.siteobjects.com

On another note, if anyone is doing any SOAP/Webservice work, I would
like to hear from you.  I have some tags that I am finishing up that
facilitates this, (much like soXML is for XML) and I need some informed
testers, before I release it publicly.

Happy Coding,

Brett Suwyn
mailto:[EMAIL PROTECTED]


 ||   -Original Message-
 ||   From: JoshMEagle [mailto:[EMAIL PROTECTED]] 
 ||   Sent: Wednesday, June 13, 2001 4:34 PM
 ||   To: CF-Talk
 ||   Subject: RE: WYSIWYG editors
 ||   
 ||   
 ||   I really like ezEdit, but I paid for a version about a 
 ||   year ago (it's free now), and now they won't respond to 
 ||   my emails when I have trouble with the tag - they're 
 ||   working on a new version so they're not really supporting 
 ||   the old version (even though a lot of us paid for it).
 ||   
 ||   Joshua Miller
 ||   Web Development
 ||   Eagle Technologies Group
 ||   Technology Solutions for the Next Generation
 ||   www.eagletgi.com
 ||   [EMAIL PROTECTED]
 ||   
 ||   -Original Message-
 ||   From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
 ||   Sent: Wednesday, June 13, 2001 2:05 PM
 ||   To: CF-Talk
 ||   Subject: WYSIWYG editors
 ||   
 ||   
 ||   Hi,
 || I am in search of a WYSIWYG editor that will allow a 
 ||   user to enter a news article and have it display in HTML 
 ||   format.  I have looked at several different ones but am 
 ||   looking for some feedback as to what is most preferred, 
 ||   affordable (free), and easy for the user.
 || I have looked at EasyEdit 
 ||||   http://www.siteobjects.com/examples/ezedit_scrat ||
chpad.cfm 
 ||   
 ||   I really liked the interface on this one but 
 ||   it has to work with IE 4.0 and unfortunately this CF tag 
 ||   needs at least IE 5.0.
 || ActiveEdit 
 ||||   http://www.cfdev.com/activedit2/executive.cfm  ||   also
looks 
 ||   
 ||   good but is kinda awkward how you have to click the link 
 ||   after updating to see your results.  Thanks for your feedback.
 ||   
 ||   -Sean McCarthy
 ||   ---
 ||   HealthObjects
 ||   410-895-0379
 ||
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Reservation System

[Mark Warrick]

You're right.  It is rather bold to ask someone to do something for you for
free that you're going to profit off of.

Have you considered slave labor?  I hear in some countries that's still
legal.

Take my message lightly.  I'm playing with you.  But you might want to pass
along the message to your boss.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: admin [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 6:10 PM
> To: CF-Talk
> Subject: Reservation System
>
>
> I know this is a bit bold, but a customers has asked me to knock
> up a site for him in a hurry. What he needs is a reservation
> system for his four rental properties. I was just wondering if
> any one has done anything similar and has some code I could plagiarize.
>
> Many thanks in advance
>
> Richard
> Y2K Internet Technologies
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: What is January in French? German? CF knows it already

[Ben Forta]

It's a UDF (User Defined Function), you must be using CF5.

--- Ben


-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 7:24 PM
To: CF-Talk
Subject: RE: What is January in French? German? CF knows it already


I just get this:

Just in time compilation error

Invalid parser construct found on line 10 at position 10. ColdFusion was
looking at the following text:

LSMonthAsString
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was a CFSCRIPT tag occupying
document position (9:1) to (9:10).

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Raymond
Camden
Sent: Thursday, 14 June, 2001 4:07 AM
To: CF-Talk
Subject: What is January in French? German? CF knows it already


I was having a conversation with Ben Forta about the UDF library project and
he suggested I add a function that would print the locale version of a
month. For example, the French (Standard) version of January. Well, I pinged
him back and said that as far as I know, I'd have to manually enter the
strings.

It turns out CF does this for you.

Check out the following example:


function LSMonthAsString(month_number)
{
VAR d=CreateDate(2000, month_number, 1);
return LSDateFormat(d, "");
}




#locale#

#LSMonthAsString(X)#




This will loop through all the supported locales and return the name of each
month. Maybe this is something everyone knew about it but it sure surprised
the heck out of me. I knew CF had good locale functionality, but this rocks.

Anyway, thanks go to Ben Forta for the idea. I'm going to be modifying this
UDF and using it at www.cflib.org.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Comparing value against a list of values

[jeff]

Ooops. That won't work.
Don't delete the old tableID field. Just add to the old tableID.
Say the old ids went from 1 to 9,999 add 10,000 so that the new ids go from
10,001 to 19,999.

Sorry I answered too quick.







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

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

Re: Comparing value against a list of values

[Paul Smith]

Which database?  SQL7 doesn't appear to have this problem.

best,  paul

At 07:30 PM 6/13/01 -0500, you wrote:
>I had the same situation with about 200,000 record table. Of course the
>first identity
>number was 1 thru something like 400,000(after deletions):o))
>The query was something like:
>select *
>from theTable
>where tableID in(select tableID from theTable where field like 'blah')
>
>If the tableid list in the in()  statement happened to contain 1.
>One just happens to be contained in a lot of bigger numbers.


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

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

Reservation System

[admin]

I know this is a bit bold, but a customers has asked me to knock up a site for him in 
a hurry. What he needs is a reservation system for his four rental properties. I was 
just wondering if any one has done anything similar and has some code I could 
plagiarize.

Many thanks in advance

Richard
Y2K Internet Technologies


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

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

RE: What is January in French? German? CF knows it already

[Dave Watts]

> I just get this:
> 
> Just in time compilation error
> 
> Invalid parser construct found on line 10 at position 10. 
> ColdFusion was looking at the following text:
> 
> LSMonthAsString
> Invalid expression format. The usual cause is an error in the 
> expression structure. The last successfully parsed CFML construct 
> was a CFSCRIPT tag occupying document position (9:1) to (9:10).

My guess is that you're trying this on CF 4.5.x. Because LSMonthAsString is
a user-defined function, it'll only work on CF 5.  I haven't actually tried
Ray's function myself, but I'm guessing that he has.

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

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

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

Re: SQL VS ACCESS

[Don Vawter]

Concerning Oracle (and I don't have a lot of experience) you can set up
autincrementing fields I don't remember the details because it has been
about a year but "select from dual" or something similiar will get the next
value. You can also reset the starting pt etc.

- Original Message -
From: "Mark Warrick" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 5:44 PM
Subject: RE: SQL VS ACCESS


> Costas,
>
> Your point is well taken, but I never meant to imply that I would allow a
> primary key field to be anything other than a number (INT).
>
> The name of the primary key field doesn't matter, however I typically do
> what you do and prefix (or suffix) the primary key field name with "ID".
>
> I setup one table in the database called KEYS.  (Very simple: ID_KEY (INT)
&
> USED_DATETIME (date/time).  Whenever I need a unique key, I call the
> following template:
>
> 
> 
> 
> 
>
> 
> SELECT max (ID_KEY) as maxid
> FROM KEYS
> 
>
> 
>
> 
> INSERT INTO KEYS (ID_KEY, USED_DATETIME) VALUES (#id_key#,
> #CreateODBCDateTime(Now())#)
> 
>
> 
> 
> 
>
> If I was using Oracle as the DB, I would call a stored procedure to have
the
> DB create a unique key for me.
>
> One of the benefits of this is that all numbers used for primary keys in
all
> tables are unique.  So you never have to worry about the "scope" (persay -
> that's not the right term for that) of the number because you know it
could
> have only come from one of the tables in the system.
>
> The issue about joins is true as well.  I'll RARELY join text fields.
>
> Your point about upsizing as an INT field and then changing it back to an
> INT PK SEED {n} field is also absolutely valid - if the database supports
> autonumbering.  Last I checked, Oracle does not support autonumber fields.
> (I could be wrong about that.)
>
> ---mark
>
> 
> Mark Warrick - Fusioneers.com
> Personal Email: [EMAIL PROTECTED]
> Business Email: [EMAIL PROTECTED]
> Phone: 714-547-5386
> Efax: 801-730-7289
> Personal URL: http://www.warrick.net
> Business URL: http://www.fusioneers.com
> ICQ: 125160 / AIM: markwarric
> 
>
> > -Original Message-
> > From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 2:24 PM
> > To: CF-Talk
> > Subject: RE: SQL VS ACCESS
> >
> >
> > Great, but what happens when you wish to change the name of a field in a
> > lookup table?
> >
> > Do you run update statements on EVERY foreign key field?
> >
> > Wouldn't it be easier to just change a value in the database?
> >
> > Further, requesting that user's supply indeces isn't the best way to
work;
> > user's have a tendancy to want to change the value of their indices from
> > time to time.  For example, If I have table a:
> >
> > CustomerID int
> > AccountingID char
> > CompanyName char
> >
> > And I want to change the accounting ID (for whatever reason), I'd be
okay.
> > However, if I were to omit the customerID field and stick with the
> > Accounting ID Field, the change would be acceptable.
> >
> > Further, joins on integer fields work much faster than joins on
character
> > fields.  The database has that much less to work with matching up.
> >
> > You are right though, autonumber fields can be a real pain.  What
> > you should
> > usually do in a migration from access to sql server is first go
> > into all of
> > your tables, turn off autonumber, and leave the field as an integer
field,
> > when you upsize, go back in and revert to autonumber.
> >
> >
> >
> >
> > -Original Message-
> > From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 11:27 AM
> > To: CF-Talk
> > Subject: RE: SQL VS ACCESS
> >
> >
> > I've learned to avoid using autonumber fields whenever possible.  It
makes
> > the job of moving databases between platforms simple.  At worst, I have
to
> > put the primary key constraints back on the index fields of each table -
> > which is no big deal.
> >
> > ---mark
> >
> > 
> > Mark Warrick - Fusioneers.com
> > Personal Email: [EMAIL PROTECTED]
> > Business Email: [EMAIL PROTECTED]
> > Phone: 714-547-5386
> > Efax: 801-730-7289
> > Personal URL: http://www.warrick.net
> > Business URL: http://www.fusioneers.com
> > ICQ: 125160 / AIM: markwarric 
> >
> > > -Original Message-
> > > From: Bud [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, June 13, 2001 4:02 AM
> > > To: CF-Talk
> > > Subject: RE: SQL VS ACCESS
> > >
> > >
> > > On 6/12/01, Norman Elton penned:
> > > >Make sure all your fields that should be indexed are indexed. I think
> > > >the upsizing wizard forgets about this.
> > >
> > > The upsizing wizard does a pretty good job of rebuilding the indexes
> > > and relationships. It's DTS that loses that stuff.
> > > --
> > >
> > > Bud Schneehagen - Tropical Web Creations
> > >
> > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > > Co

Re: Comparing value against a list of values

[jeff]

Paul,
Question? Is this list a list if your identity field numbers?
If that is the case read on otherwise LMK.

Jeff Craig

I had the same situation with about 200,000 record table. Of course the
first identity
number was 1 thru something like 400,000(after deletions):o))
The query was something like:
select *
from theTable
where tableID in(select tableID from theTable where field like 'blah')

If the tableid list in the in()  statement happened to contain 1.
One just happens to be contained in a lot of bigger numbers.
My solution for that was to drop the tableid field. Reset the tableid field
in SQL 7 with a seed value of 100. It gets a little tricker when you
have a bunch of relational tables that
are dependent on this identity. I had to go to all the related tables and
add 100 to the
tableid field in the related tables.





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

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

RE: SQL VS ACCESS

[Mark Warrick]

Costas,

Your point is well taken, but I never meant to imply that I would allow a
primary key field to be anything other than a number (INT).

The name of the primary key field doesn't matter, however I typically do
what you do and prefix (or suffix) the primary key field name with "ID".

I setup one table in the database called KEYS.  (Very simple: ID_KEY (INT) &
USED_DATETIME (date/time).  Whenever I need a unique key, I call the
following template:







SELECT max (ID_KEY) as maxid
FROM KEYS





INSERT INTO KEYS (ID_KEY, USED_DATETIME) VALUES (#id_key#,
#CreateODBCDateTime(Now())#)






If I was using Oracle as the DB, I would call a stored procedure to have the
DB create a unique key for me.

One of the benefits of this is that all numbers used for primary keys in all
tables are unique.  So you never have to worry about the "scope" (persay -
that's not the right term for that) of the number because you know it could
have only come from one of the tables in the system.

The issue about joins is true as well.  I'll RARELY join text fields.

Your point about upsizing as an INT field and then changing it back to an
INT PK SEED {n} field is also absolutely valid - if the database supports
autonumbering.  Last I checked, Oracle does not support autonumber fields.
(I could be wrong about that.)

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 2:24 PM
> To: CF-Talk
> Subject: RE: SQL VS ACCESS
>
>
> Great, but what happens when you wish to change the name of a field in a
> lookup table?
>
> Do you run update statements on EVERY foreign key field?
>
> Wouldn't it be easier to just change a value in the database?
>
> Further, requesting that user's supply indeces isn't the best way to work;
> user's have a tendancy to want to change the value of their indices from
> time to time.  For example, If I have table a:
>
> CustomerIDint
> AccountingID  char
> CompanyName   char
>
> And I want to change the accounting ID (for whatever reason), I'd be okay.
> However, if I were to omit the customerID field and stick with the
> Accounting ID Field, the change would be acceptable.
>
> Further, joins on integer fields work much faster than joins on character
> fields.  The database has that much less to work with matching up.
>
> You are right though, autonumber fields can be a real pain.  What
> you should
> usually do in a migration from access to sql server is first go
> into all of
> your tables, turn off autonumber, and leave the field as an integer field,
> when you upsize, go back in and revert to autonumber.
>
>
>
>
> -Original Message-
> From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 11:27 AM
> To: CF-Talk
> Subject: RE: SQL VS ACCESS
>
>
> I've learned to avoid using autonumber fields whenever possible.  It makes
> the job of moving databases between platforms simple.  At worst, I have to
> put the primary key constraints back on the index fields of each table -
> which is no big deal.
>
> ---mark
>
> 
> Mark Warrick - Fusioneers.com
> Personal Email: [EMAIL PROTECTED]
> Business Email: [EMAIL PROTECTED]
> Phone: 714-547-5386
> Efax: 801-730-7289
> Personal URL: http://www.warrick.net
> Business URL: http://www.fusioneers.com
> ICQ: 125160 / AIM: markwarric 
>
> > -Original Message-
> > From: Bud [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 4:02 AM
> > To: CF-Talk
> > Subject: RE: SQL VS ACCESS
> >
> >
> > On 6/12/01, Norman Elton penned:
> > >Make sure all your fields that should be indexed are indexed. I think
> > >the upsizing wizard forgets about this.
> >
> > The upsizing wizard does a pretty good job of rebuilding the indexes
> > and relationships. It's DTS that loses that stuff.
> > --
> >
> > Bud Schneehagen - Tropical Web Creations
> >
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]
> > http://www.twcreations.com/
> > 954.721.3452
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: WYSIWYG editors

[Peter Tilbrook]

Er, that should be 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Michael
Bruce
Sent: Thursday, 14 June, 2001 6:09 AM
To: CF-Talk
Subject: RE: WYSIWYG editors


Check out www.siteobject.com They have a free editor and it is pretty cool

Michael Bruce
Fig Leaf Software

-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 2:05 PM
To: CF-Talk
Subject: WYSIWYG editors


Hi,
I am in search of a WYSIWYG editor that will allow a user to enter a
news article and have it display in HTML format.  I have looked at several
different ones but am looking for some feedback as to what is most
preferred, affordable (free), and easy for the user.
I have looked at EasyEdit
http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the
interface on this one but it has to work with IE 4.0 and unfortunately this
CF tag needs at least IE 5.0.
ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks
good but is kinda awkward how you have to click the link after updating to
see your results.  Thanks for your feedback.

-Sean McCarthy
---
HealthObjects
410-895-0379
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: What is January in French? German? CF knows it already

[Peter Tilbrook]

I just get this:

Just in time compilation error

Invalid parser construct found on line 10 at position 10. ColdFusion was
looking at the following text:

LSMonthAsString
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was a CFSCRIPT tag occupying
document position (9:1) to (9:10).

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Raymond
Camden
Sent: Thursday, 14 June, 2001 4:07 AM
To: CF-Talk
Subject: What is January in French? German? CF knows it already


I was having a conversation with Ben Forta about the UDF library project and
he suggested I add a function that would print the locale version of a
month. For example, the French (Standard) version of January. Well, I pinged
him back and said that as far as I know, I'd have to manually enter the
strings.

It turns out CF does this for you.

Check out the following example:


function LSMonthAsString(month_number)
{
VAR d=CreateDate(2000, month_number, 1);
return LSDateFormat(d, "");
}




#locale#

#LSMonthAsString(X)#




This will loop through all the supported locales and return the name of each
month. Maybe this is something everyone knew about it but it sure surprised
the heck out of me. I knew CF had good locale functionality, but this rocks.

Anyway, thanks go to Ben Forta for the idea. I'm going to be modifying this
UDF and using it at www.cflib.org.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: WYSIWYG editors

[Peter Tilbrook]

Minh Hoang recently posted a tag called JS-Edit to the DevEx.

Might be worth a look at:



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Sean
McCarthy
Sent: Thursday, 14 June, 2001 4:05 AM
To: CF-Talk
Subject: WYSIWYG editors


Hi,
I am in search of a WYSIWYG editor that will allow a user to enter a
news article and have it display in HTML format.  I have looked at several
different ones but am looking for some feedback as to what is most
preferred, affordable (free), and easy for the user.
I have looked at EasyEdit
http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the
interface on this one but it has to work with IE 4.0 and unfortunately this
CF tag needs at least IE 5.0.
ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks
good but is kinda awkward how you have to click the link after updating to
see your results.  Thanks for your feedback.

-Sean McCarthy
---
HealthObjects
410-895-0379
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Body and Subject of my messages not arriving

[Peter Tilbrook]

I had the same problem for a while. It only seemed to occur if the message
was HTML based (like the CNET news, etc).

Not sure how I fixed it but I recently installed the latest service pack
from officeupdate.microsoft.com and everything seems fine.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Larry
Juncker
Sent: Thursday, 14 June, 2001 12:32 AM
To: CF-Talk
Subject: Body and Subject of my messages not arriving


HELP Please -

I know this sis for another list, however - I am receiving my messages from
JS-Jive, but my subject and body are empty on all of them.  Has anyone run
into this before and is there a way for me to fix it?  I am using Outlook
2000.  Just started the other day.

Thanks

Larry Juncker
Senior ColdFusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

URL Hacks

[Don Vawter]

Having recently suffered (not too much fortunately) through an attempt of a
hacker to corrupt a database by embedding sql in url paramaters I have put
together a few tips on preventing these attacks from being successful. I
realize that this is not new (I first heard of if at least 2 years ago) but
sometimes a little reminder doesn't hurt because obviously the hackers are
still out there.

If anyone has any interest it is at: http://www.vawter.com/urlhack.cfm

HTH

Don Vawter


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

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

OT: Macromedia misses its mark?

[Peter Tilbrook]

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

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

RE: WYSIWYG editors

[Sean McCarthy]

Thanks Mike I like that one too but unfortunately they (ezedit) require IE 5
and our corp standard is IE 4.  Im curious as to what hell would break loose
if it was used with IE 4 but have no way of testing it at the moment. 

Sean

 
> Check out www.siteobject.com They have a free editor and it 
> is pretty cool
> 
> Michael Bruce
> Fig Leaf Software
> 
> -Original Message-
> From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 2:05 PM
> To: CF-Talk
> Subject: WYSIWYG editors
> 
> 
> Hi,
>   I am in search of a WYSIWYG editor that will allow a 
> user to enter a
> news article and have it display in HTML format.  I have 
> looked at several
> different ones but am looking for some feedback as to what is most
> preferred, affordable (free), and easy for the user.   
>   I have looked at EasyEdit
> http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I 
> really liked the
> interface on this one but it has to work with IE 4.0 and 
> unfortunately this
> CF tag needs at least IE 5.0.  
>   ActiveEdit 
> http://www.cfdev.com/activedit2/executive.cfm also looks
> good but is kinda awkward how you have to click the link 
> after updating to
> see your results.  Thanks for your feedback.
> 
> -Sean McCarthy
> ---
> HealthObjects
> 410-895-0379
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT: External Images in Flash

[John Dowdell]

At 4:32 AM 6/13/1, Michael Lugassy wrote:
> Will it be possible to call a Movie via a URL but instead of
> specifying absolute name (like: mymovie.swf) to specify
> getmovie.cfm?parm1=value  and on the getmovie.cfm page to
> use cfcontent to "send" the file automaticlly?

Whew, I'm not sure... it sounds as if you're asking whether ColdFusion
Server can return a SWF, which I don't think I see a scenario for... you
could certainly invoke a template with query terms to have a new HTML or
similar document returned... hmm, maybe you're think of a serverside
redirect..? Sorry, I'm not sure of the full situation there.

Taking a step backwards from it, I'd guess you may be asking "How can I
load movie clips into a SWF if their identity is determined only by actions
taken by the visitor?" If so, then it's pretty easy to handle that
branching in the client itself, and construct URLs in the client rather
than ask the server to construct the URLs.

But as you can see, I may be looking at something very different than what
you're looking at... sorry, I'm not sure of the design situation.

jd






John Dowdell, Macromedia Tech Support, San Francisco CA US
Search technotes: http://www.macromedia.com/support/search/
Offlist email risks capture by the spam filters. I may not see your
email if it's not on the list. Private one-on-one email options are
available via Priority Access: http://www.macromedia.com/support/



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

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

RE: WYSIWYG editors

[Mark Warrick]

I think you meant http://www.siteobjects.com

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Michael Bruce [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 1:09 PM
> To: CF-Talk
> Subject: RE: WYSIWYG editors
>
>
> Check out www.siteobject.com They have a free editor and it is pretty cool
>
> Michael Bruce
> Fig Leaf Software
>
> -Original Message-
> From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 2:05 PM
> To: CF-Talk
> Subject: WYSIWYG editors
>
>
> Hi,
>   I am in search of a WYSIWYG editor that will allow a user to enter a
> news article and have it display in HTML format.  I have looked at several
> different ones but am looking for some feedback as to what is most
> preferred, affordable (free), and easy for the user.
>   I have looked at EasyEdit
> http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I
> really liked the
> interface on this one but it has to work with IE 4.0 and
> unfortunately this
> CF tag needs at least IE 5.0.
>   ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks
> good but is kinda awkward how you have to click the link after updating to
> see your results.  Thanks for your feedback.
>
> -Sean McCarthy
> ---
> HealthObjects
> 410-895-0379
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Session time out = never ? Bad?

[Mark Warrick]

I'm thinking: Impossible.

I mean, I've heard of servers running for months at a time, but 10 years?
Yeah RIGHT!

HOWEVER, so long as all the session vars don't suck up the server's memory
and crash it, I guess you're OK, right?

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 12:51 PM
> To: CF-Talk
> Subject: Session time out = never ? Bad?
>
>
>
> Would it be "bad" to set a session timeout to 10 years in the future?  I
> have a client that wants to never time out if he or his office workers are
> coming to the site from their office.
>
> I am thinking this would be "bad".  Possible server registry blot?
>
>
> "I'm a little fuzzy on the whole good-bad thing. What do you mean bad?" -
> Peter Venckman - Ghostbusters
>
> Mark W. Breneman
> -Cold Fusion Developer
> -Network Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
>
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 11:53 AM
> To: CF-Talk
> Subject: Re: Re:Verity & SQL
>
>
> Won't work with multiple users seaching on the same time because of the
> collection "on the fly"
> creation latency - both trying to use OntheFlyCollection which is alright
> (for the first user) at second
> number 1 but it's not updated for second user (or first user,
> depending who
> run what and where
> first...)
>
> but If you can create a collection that will sure to be unique, again -
> ontheflyCollection,
> it might work, but will involve some major maintance..
>
> again, I personally don't see any point nor success to this.
>
> Thanks,
>
> Michael
> - Original Message -
> From: "Jason Blum" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 13, 2001 4:52 PM
> Subject: Re:Verity & SQL
>
>
> > Steve!
> >
> > Finally something I can contribute to this wonderful list!
> >
> > I am in fact working right now on the code to do just this.
> >
> > I am assuming you already have a Verity collection with SomeName.  Then
> you need
> > to make a kind of on-the-fly collection out of a normal db
> query and call
> it
> > Dbquery
> >
> > So on the search page, here is your Dbquery:
> >
> > 
> > 
> > SELECT Field1, Field2, Field3, Field4
> > FROM SomeTable
> > 
> >
> > 
> >  > COLLECTION="OntheFlyCollection"
> > KEY="Field1"
> > URL="Field2"
> > TYPE="custom"
> > TITLE="Field3"
> > BODY="Field4"
> > QUERY="GetSomeData">
> >
> > Then on the search results page,
> >
> >  > name = "GetResults"
> > collection = "SomeCollection, OntheFlyCollection"
> > criteria = "#Form.Criteria#">
> >
> > And that's it.  Two things to note, you actually have to create a
> collection
> > called OntheFlyCollection first, so that you can be refreshing
> it here on
> the
> > search page.
> >
> > Also, notice that in the  you are telling Verity which fields
> should be
> > considered what Verity values, so Field2 is your URL for instance - kind
> of
> > limiting, but don't forget you can make two custom tags!
> >
> > HOpe this helps - got it all from p.733 of Forta and
> > http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
> >
> > -Jason
> >
> >
> > ___Reply Separator
> > Subject:Verity & SQL
> > Author: [EMAIL PROTECTED]
> > Date:   6/13/01 4:00 PM
> >
> > Is there any way to combine the results of a CFSEARCH and a standard SQL
> > search into the same CFOUTPUT ... basically merge two queries?
> >
> > Thanks
> > Steve
> >
> >
> > Development Manager
> > Vardus Internet Solutions (SA)
> >
> > Tel: (+27) 21 670 9880
> > Fax: (+27) 21 674 4549
> >
> > Email: [EMAIL PROTECTED]
> > Website: www.vardus.com
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Mark Warrick]

Dude - bite the bullet and redesign the database.  Seriously.

I mean, why duck-tape a prop back on a plane when you know it's going to
crash eventually anyway?

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 10:56 AM
> To: CF-Talk
> Subject: RE: Comparing value against a list of values
>
>
> Dylan,
>
> Thanks for this suggestion. This doesn't do what is needed though I don't
> think. My trouble is I am comparing one list of values against
> another list
> of values. Take the following situation:
>
> 1. The string I want to compare against is this: 1,3,5
>
> 2. The field (FLD) I am comparing it against contains this value: 2,4,10
>
> If I use IN, it would look like this:
>
> WHERE '2,4,10' IN('1,3,5')
>
> What I _WANT_ to do is this (in layman's terms):
>
> get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 =
> 10) OR (5 = 2 or 5 = 4 or 5 = 10)
>
> I'm comparing discrete values in the comparison list against
> discrete values
> in the the field value list. Only if one of the discrete values
> matches do I
> want to the record.
>
> Any ideas on how to accomplish this?
>
> Thanks for ideas!
>
> Paul Sinclair
>
>
> > -Original Message-
> > From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 11:01 AM
> > To: CF-Talk
> > Subject: RE: Comparing value against a list of values
> >
> >
> > Paul,
> >
> > You should use the IN operator in your WHERE clause. I'm not
> clear on your
> > data structure from your post, but try something like the
> following (make
> > sure the list is in parentheses);
> >
> > SELECT
> > *
> > FROM
> > tbl
> > WHERE
> > csvList IN (10,11,21,100)
> >
> > -Original Message-
> > From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 7:17 AM
> > To: CF-Talk
> > Subject: SQL: Comparing value against a list of values
> >
> >
> > I have a table with a field that contains a comma delimited list
> > of values,
> > such as:
> >
> > 10,11,21,100
> >
> > In doing a  against the table, I want to select
> records where one
> > or more of the values in this list of values matches a value in
> the WHERE
> > clause of my sql query. For example:
> >
> > select *
> > from tbl
> > where csvList = '%1%'
> >
> > The problem is that the above select statement will select ANY
> record that
> > has '1' in the field no matter what the "true" values in the field are
> > (i.e., 1 is "LIKE" 10,11,21,100).
> >
> > How do I make the select query compare '1' against '10', and '1' against
> > '11' and '1' against '21', and '1' against '100'.
> >
> > Thank you for help.
> >
> > Regards,
> > Paul Sinclair
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFSTAT on NT

[Deb Dickerson]

As long as CFSTAT is working in general from the command line, your batch
file should be fine. It's probably just a matter of patience. :-)

It will only write to the text file after it has ~4K of data stored up,
which at 1 second intervals, takes about a minute or so.

Deb


> -Original Message-
> From: McCabe, Kevin [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 7:06 AM
> To: CF-Talk
> Subject: CFSTAT on NT
>
>
> Guys,
>
> Is it possible to get CFSTAT to output to a file?
>
> I have tried:
>
> cfstat -n 1 >cfstat.txt
>
> and it creates and empty text file.
>
> Any Ideas?
>
> Can you send any replies to me directly and to the list as i'm on the
> digest.
>
> Cheers
>
> ---
> Kev McCabe
> Intranet Team Leader
> Telephone: +44 (0) 20 7941 5502
> Mobile: +44 (0) 7711 172 730
> Mobex: 123 5502
> ---
>
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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

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

Re: unbalanced in cfmail

[Gordon Burns]

Missing < or "  or even two of them I suspect.

Gordon




At 14:26 13/06/01 -0500 Alex said
>anyone know what unbalanced error when running a cfmail tag from a query
>means?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: unbalanced in cfmail

[Jann VanOver]

Nope.  Can you post the full error message and the code that you think is
throwing it?

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:27 PM
To: CF-Talk
Subject: unbalanced in cfmail


anyone know what unbalanced error when running a cfmail tag from a query
means?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL VS ACCESS

[Costas Piliotis]

Great, but what happens when you wish to change the name of a field in a
lookup table?

Do you run update statements on EVERY foreign key field?

Wouldn't it be easier to just change a value in the database?

Further, requesting that user's supply indeces isn't the best way to work;
user's have a tendancy to want to change the value of their indices from
time to time.  For example, If I have table a:

CustomerID  int
AccountingIDchar
CompanyName char

And I want to change the accounting ID (for whatever reason), I'd be okay.
However, if I were to omit the customerID field and stick with the
Accounting ID Field, the change would be acceptable.

Further, joins on integer fields work much faster than joins on character
fields.  The database has that much less to work with matching up.

You are right though, autonumber fields can be a real pain.  What you should
usually do in a migration from access to sql server is first go into all of
your tables, turn off autonumber, and leave the field as an integer field,
when you upsize, go back in and revert to autonumber.




-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, June 13, 2001 11:27 AM
To: CF-Talk
Subject: RE: SQL VS ACCESS


I've learned to avoid using autonumber fields whenever possible.  It makes
the job of moving databases between platforms simple.  At worst, I have to
put the primary key constraints back on the index fields of each table -
which is no big deal.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric 

> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:02 AM
> To: CF-Talk
> Subject: RE: SQL VS ACCESS
>
>
> On 6/12/01, Norman Elton penned:
> >Make sure all your fields that should be indexed are indexed. I think 
> >the upsizing wizard forgets about this.
>
> The upsizing wizard does a pretty good job of rebuilding the indexes 
> and relationships. It's DTS that loses that stuff.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT SQL Server (OK 1 More ?)

[Howarth, Craig (IBK-NY)]

No, the 4 refers to 4 bytes required to store the value, not the number of characters 
in the value.  The range that can be stored in an int is -2^31 to 2^31-1.

Craig

> -Original Message-
> From: ibtoad [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 12:32 PM
> To:   CF-Talk
> Subject:  RE: OT SQL Server (OK 1 More ?)
> 
> OK I got it. Now that I have the primary key set with datatype int, the
> length is limited to 4. Is this correct and will this limit the table to
>  records?
> 
> Thanks,
> Rich
> 
> -Original Message-
> From: Craig Bowes [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 11:30 AM
> To: CF-Talk
> Subject: RE: OT SQL Server
> 
> 
> You must set a field to be identity and not null.  You can set its seed to
> any number (start autonumbering at 1000 for example.)
> 
> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 9:37 AM
> To: CF-Talk
> Subject: OT SQL Server
> 
> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a choice
> but don't see how to do it with SQL Server 2000.
> 
> Thanks,
> Rich
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Paul Smith]

My understanding of your database (which might be wrong) is that you have 
unique records, each of which has a column with a comma-delimited list of 
numerals in it.  The length of each list varies.

The simplest solution is to create the small table I suggested:

MainTableID   ListElement
1 29
1 40
1 3141
2 80
2 121
3 35
3 99
3 1024
etc.

You can populate this table using a ColdFusion query that gets the ID and 
IDList from each row, with a outer loop over the Query, and an inner loop 
over the List, with a  But I am probably missing something as another posting suggested you 
want to compare one list to another...

At 02:44 PM 6/13/01 -0400, you wrote:
>Paul,
>
>Thanks for this note. I realize the table design needs normalization and
>that is the long term solution. Right now I need a short-term fix until we
>can get around to redesigning the db. Unfortunately, we've got several
>tables with tens of thousands of records each that require normalization!
>
>I've been trying to figure out a simple way to extract the field contents
>from the non-normalized table and move the contents to a new, normalized
>table with a single record for each. Is there a good way to do this?
>
>Regards,
>Paul Sinclair
>
>
> > -Original Message-
> > From: Paul Smith [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 12:45 PM
> > To: CF-Talk
> > Subject: RE: Comparing value against a list of values
> >
> >
> > Since the list is in a column in the database table, the IN below won't
> > work.  I believe you'll have to normalize your table, or better create
> > another table.  In the latter case, for example, assuming the list
> > 10,11,21,100 is in a row with ID = 89, the new table for these
> > data would be:
> >
> > 89 10
> > 89 11
> > 89 21
> > 89 100
> >
> > Then you would do a join between this new table and the old one
> > to find the
> > records of interest.
> >
> > best,  paul
> >
> >
> > At 08:00 AM 6/13/01 -0700, you wrote:
> > >Paul,
> > >
> > >You should use the IN operator in your WHERE clause. I'm not
> > clear on your
> > >data structure from your post, but try something like the following (make
> > >sure the list is in parentheses);
> > >
> > >SELECT
> > > *
> > >FROM
> > > tbl
> > >WHERE
> > > csvList IN (10,11,21,100)
> > >
> > >-Original Message-
> > >From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> > >Sent: Wednesday, June 13, 2001 7:17 AM
> > >To: CF-Talk
> > >Subject: SQL: Comparing value against a list of values
> > >
> > >
> > >I have a table with a field that contains a comma delimited list
> > of values,
> > >such as:
> > >
> > >10,11,21,100
> > >
> > >In doing a  against the table, I want to select records
> > where one
> > >or more of the values in this list of values matches a value in the WHERE
> > >clause of my sql query. For example:
> > >
> > >select *
> > >from tbl
> > >where csvList = '%1%'
> > >
> > >The problem is that the above select statement will select ANY
> > record that
> > >has '1' in the field no matter what the "true" values in the field are
> > >(i.e., 1 is "LIKE" 10,11,21,100).
> > >
> > >How do I make the select query compare '1' against '10', and '1' against
> > >'11' and '1' against '21', and '1' against '100'.
> > >
> > >Thank you for help.
> > >
> > >Regards,
> > >Paul Sinclair
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Dick Applebaum]

Just read my post... lotsa tipos, er, ah typos...

Here's a better one
OK

To simplify things let's say the search variable is named LookingFor 
and contains a single value (10)

the rccords in the db contain:

  #SearchField
---   ---
1 1,2,3,4,9,100
2 210,310,410
3 10,11,12
4 8,9,10
5 10
6 2,10,200

Records 3, 4, 5, and 6 are matches

So, the query is:

   ... WHERE
SearchField ='10'   -- Match Only Element of field
 OR SearchField LIKE '10,%' -- Match Beginning Element of Field
 OR SearchField LIKE '%,10,%'   -- Match Middle Element of Field
 OR SearchField LIKE '%,10' -- Match Last Element of Field

OK, If that works, then in CF you must build a similar set of 4 tests 
for each list element in the LookingFor variable, by looping over it 
as a list:

If you have a value in LookingFor of (1,10,100), your CF-generated 
statement would look like this:

   ... WHERE
SearchField ='1' -- Match Only Element of field
 OR SearchField LIKE '1,%'   -- Match Beginning Element of Field
 OR SearchField LIKE '%,1,%, -- Match Middle Element of Field
 OR SearchField LIKE '%,1'   -- Match Last Element of Field

 OR SearchField ='10'-- Match Only Element of field
 OR SearchField LIKE '10,%'  -- Match Beginning Element of Field
 OR SearchField LIKE '%,10,%'-- Match Middle Element of Field
 OR SearchField LIKE '%,10'  -- Match Last Element of Field

 OR SearchField ='100'   -- Match Only Element of field
 OR SearchField LIKE '100,%' -- Match Beginning Element of Field
 OR SearchField LIKE '%,100,%'   -- Match Middle Element of Field
 OR SearchField LIKE '%,100' -- Match Last Element of Field

Now, all this garbage is the penalty you pay, again and again, for 
not having a normalized db... SearchField is not atomic.

What I would suggest is that you add another child table to contain 1 
record for each SearchField element.

The search will be simple and fast (done entirely in the indexes).

You can keep the composite field around if needed for other 
purposes(denormalized fields are acceptable if you use them as 
information fields & don't need to search on them...

This would would be a similar, practical, denormalization as carrying 
the total in the order record, rather than computing the sum of all 
the line items.

HTH

Dick





At 1:55 PM -0400 6/13/01, Paul Sinclair wrote:
>Dylan,
>
>Thanks for this suggestion. This doesn't do what is needed though I don't
>think. My trouble is I am comparing one list of values against another list
>of values. Take the following situation:
>
>1. The string I want to compare against is this: 1,3,5
>
>2. The field (FLD) I am comparing it against contains this value: 2,4,10
>
>If I use IN, it would look like this:
>
>WHERE '2,4,10' IN('1,3,5')
>
>What I _WANT_ to do is this (in layman's terms):
>
>get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 =
>10) OR (5 = 2 or 5 = 4 or 5 = 10)
>
>I'm comparing discrete values in the comparison list against discrete values
>in the the field value list. Only if one of the discrete values matches do I
>want to the record.
>
>Any ideas on how to accomplish this?
>
>Thanks for ideas!
>
>Paul Sinclair
>
>
>>  -Original Message-
>>  From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
>>  Sent: Wednesday, June 13, 2001 11:01 AM
>>  To: CF-Talk
>>  Subject: RE: Comparing value against a list of values
>>
>>
>>  Paul,
>>
>>  You should use the IN operator in your WHERE clause. I'm not clear on your
>>  data structure from your post, but try something like the following (make
>>  sure the list is in parentheses);
>>
>>  SELECT
>>  *
>>  FROM
>>  tbl
>>  WHERE
>>  csvList IN (10,11,21,100)
>>
>>  -Original Message-
>>  From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
>>  Sent: Wednesday, June 13, 2001 7:17 AM
>>  To: CF-Talk
>>  Subject: SQL: Comparing value against a list of values
>  >
>>
>>  I have a table with a field that contains a comma delimited list
>>  of values,
>>  such as:
>>
>>  10,11,21,100
>>
>>  In doing a  against the table, I want to select records where one
>>  or more of the values in this list of values matches a value in the WHERE
>>  clause of my sql query. For example:
>>
>>  select *
>>  from tbl
>>  where csvList = '%1%'
>>
>>  The problem is that the above select statement will select ANY record that
>>  has '1' in the field no matter what the "true" values in the field are
>>  (i.e., 1 is "LIKE" 10,11,21,100).
>>
>>  How do I make the select query compare '1' against '10', and '1' against
>>  '11' and '1' against '21', and '1' against '100'.
>>
>>  Thank you for help.
>>
>>  Regards,
>>  Paul Sinclair
>>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fus

RE: Sending MP3's Through CF

[Zachary S. Bedell]

> Hmmm. Interesting. Didn't really consider that. 
> 
> How severe of a resource hit is it? Is CF working throughout 
> the streaming of the song? Or just the beginning? 
> 
> Regardless, while it may take up threads, how severe of a CPU 
> hit is it? It's not like CF is doing heavy computations. It's 
> just passing along a file with a particular header. 


It's not really taking any amount of CPU.  It's just that when your CF
Server runs out of worker threads, it stops dead.  The usual rule of
thumb is no more than 8 worker threads per processor.  So even if you've
got a dual P-III Zeon 900MHz monster of a server, when user number 17
makes his request, he'll sit queued up waiting until one of the 16
worker threads is freed up.  The CPUs would probably be idling at less
than 5% at that point, but CF wouldn't be able to do any more work.

Now...  That scenario only applies if you're feeding the actual MP3
stream itself through CF.  If you only feed the meta file, then you'd be
okay.  Winamp or whatever would just retrieve the meta file, disconnect
from your CF Server, and *then* start getting the MP3 streams.  Under
that scenario, assuming your MP3 streams were coming from outside the CF
Server somewhere, you could support thousands of users with no problems.
As soon as you start involving CF for the actual streams, then you're in
trouble.  Thus, using ShoutCAST for the MP3 streams would be a
GoodThing(tm)! ;-)

If the CF Server in question is owned & admin'd by you, you can
certainly up the number of worker threads beyond 8 per processor, but I
have no idea what kind of side effects you might see.  In any case, the
number of worker threads is the maximum number of users you could
support.  However...  Let's say you set the number of threads to 100.
If you've got 100 people listening to music, then nobody else could even
view your web pages (assuming you use CF for them) since all the threads
would be taken by MP3 streams.


If you absolutely need to do this over an HTTP interface, then ASP might
be a better option for you, tho you'd probably need Soft Artisans's
SAFileUp COM component to access the binary files from the server's hard
disk.  ASP, at least, doesn't have a hard thread limit -- the ASP engine
will spawn more threads as needed until all requests are handled *or*
until the server is overloaded.

In any case, neither ASP nor CF was intended to stream large files like
this, and I can't imagine you could get them to do it reliably on
anything but the smallest of scales.  ShoutCAST servers can be had for
nothing, and I thing they'd be a better solution.  Failing that, I
*think* Microsoft Media Services can be made to stream MP3's, so there's
another option.


I hope at least some of that is helpful.  Feel free to pick my brain
further.


Best regards,
Zac Bedell


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

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

CF2001 early-bird discount ends Friday 6/15/01

[Michael Smith]

The early bird discount on CF2001 ends Friday 6/15/01. That is just 3 
days away... Sign up now!

CF2001 is a ColdFusion info packed 2 day conference Saturday 7/28/01 
and Sunday 7/29/01
   http://www.cfconf.org/2001CF_Odyssey/

Get TeraTech upto CF full speed ahead "warp factor nine" with CF2001 - 
The Third Annual TeraTech ColdFusion Conference with MDCFUG and CPCUG.

July 28th - 29th at NIH, Bethesda, MD
Two days of ColdFusion Fun!

Early Bird registration $129.00 
After June 15th, registration will be $149.00

* Charlie Arehart "Going from CF to Java"

* Matt Brown "Future of CF Studio, UltraDev and the Macromedia 
community"

* Mark Chambers "Flash and ColdFusion"

* Steve Drucker "CF 5 js and DHTML tricks and tips"

* April Fleming "Responsible Coding"

* Shlomy Gantz "Cool CF debugging"

* Hal Helms "XFB revealed"

* Matt Liotta "CF on Linux"

* Steve Nelson "The UN-Mythical Man Month"

* Robi Sen "CF and big iron"

* Dave Watts "Extreme TBA"

Seats are going fast...  Please tell your ColdFusion friends so they 
can be there too! Thanks!

Come learn CF info unavailable elsewhere in a fun way with CF 
2001. Eleven famous CF speakers! Network with your CF 
friends in a relaxed enviroment.


 Get ready for fun and excitement
-- ColdFusion style --
 courtesy of TeraTech and MDCFUG

Yes we are repeating the fun and learning from last 
year's CFUN2k! 

   * CF Programming!
   * CF talk!
   * CF fun!


Speaker bios are at

http://www.cfconf.org/2001cf_odyssey/speakerbios.cfm

Previous attendee quotes:
-

"... the CF community owes you a tremendous thanks for putting
 such a nigh calibur event together and then making sure that
 our collective thoughts are transmitted to the appropriate
 parties at Allaire."
 
"Happy New Year. I want to thank you for being such a great 
events sponsor. I have certainly learned things from your workshops
 that I would not have been able to learn anywhere else." 
   
CFUG bargin Registration fee: $149 ($129 before 6/15/01)

Seating is limited - register now 
   http://www.cfconf.org/2001cf_odyssey/


- CF Help --
Need expert ColdFusion, SQL and Access Programming? Project stuck and 
need help? Call TeraTech 800-447-9120 or email 
mailto:[EMAIL PROTECTED]. We will get you moving fast!

- CF Help --
-- 
Michael Smith, TeraTech Inc - Tools for Programmers(tm)
CF/ASP Web, VB, Telephony, Math, Access programming tools and consulting
12221 Parklawn Dr Ste 200, Rockville MD 20852 USA 
Please check out http://www.teratech.com/ - email
mailto:[EMAIL PROTECTED],
or call us for more information; in the USA at 1-800-447-9120,
+1-301-881-1440 International, Fax 301-881-3586  Thanks!

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

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

RE: WYSIWYG editors

[JoshMEagle]

I really like ezEdit, but I paid for a version about a year ago (it's free
now), and now they won't respond to my emails when I have trouble with the
tag - they're working on a new version so they're not really supporting the
old version (even though a lot of us paid for it).

Joshua Miller
Web Development
Eagle Technologies Group
Technology Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]

-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 2:05 PM
To: CF-Talk
Subject: WYSIWYG editors


Hi,
I am in search of a WYSIWYG editor that will allow a user to enter a
news article and have it display in HTML format.  I have looked at several
different ones but am looking for some feedback as to what is most
preferred, affordable (free), and easy for the user.
I have looked at EasyEdit
http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the
interface on this one but it has to work with IE 4.0 and unfortunately this
CF tag needs at least IE 5.0.
ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks
good but is kinda awkward how you have to click the link after updating to
see your results.  Thanks for your feedback.

-Sean McCarthy
---
HealthObjects
410-895-0379
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Dick Applebaum]

OK

To simplify things let's say the search variable is named LookingFor 
and contains a single value (10)

the rccords in the db contain:

  #SearchField
---   ---
1 1,2,3,4,9,100
2 210,310,410
3 10,11,12
4 8,9,10


So, the query is:

   ... WHERE
SearchField ='10'   -- Match Only Element of field
 OR SearchField LIKE '10,%' -- Match Beginning Element of Field
 OR SearchField LIKE '%,10,%'   -- Match Middle Element of Field
 OR SearchField LIKE '%,10' -- Match Last Element of Field

OK, If that works, then if CF you must build a similar set of 4 tests 
for each list element in the LookingFor variable, by looping over it 
as a list:

If yoy have a value in LookingFor of (1,10,100), cour CF-generated 
statement would look like this:

   ... WHERE
SearchField ='0' -- Match Only Element of field
 OR SearchField LIKE '1,%'   -- Match Beginning Element of Field
 OR SearchField LIKE '%,1,%, -- Match Middle Element of Field
 OR SearchField LIKE '%,1'   -- Match Last Element of Field

 OR SearchField ='10'-- Match Only Element of field
 OR SearchField LIKE '10,%'  -- Match Beginning Element of Field
 OR SearchField LIKE '%,10,%'-- Match Middle Element of Field
 OR SearchField LIKE '%,10'  -- Match Last Element of Field

 OR SearchField ='100'   -- Match Only Element of field
 OR SearchField LIKE '100,%' -- Match Beginning Element of Field
 OR SearchField LIKE '%,100,%'   -- Match Middle Element of Field
 OR SearchField LIKE '%,100' -- Match Last Element of Field

Now, all this garbage is the penalty you pay, again and again, for 
not having a normalized db... SearchField is not atomic.

What I would suggest is that you add another child table to contain 1 
record for each SearchField element.

The search will be simple and fast (done entirely in the indexes).

You can keep the composite field around if needed for other purposed 
(denormalized fields are acceptable if you use them as information 
fields & don't need to search on them...

This would would be a similar, practical, denormalization as carring 
the total in the order record, rather than computing the sum of all 
the line items.

HTH

Dick





At 1:55 PM -0400 6/13/01, Paul Sinclair wrote:
>Dylan,
>
>Thanks for this suggestion. This doesn't do what is needed though I don't
>think. My trouble is I am comparing one list of values against another list
>of values. Take the following situation:
>
>1. The string I want to compare against is this: 1,3,5
>
>2. The field (FLD) I am comparing it against contains this value: 2,4,10
>
>If I use IN, it would look like this:
>
>WHERE '2,4,10' IN('1,3,5')
>
>What I _WANT_ to do is this (in layman's terms):
>
>get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 =
>10) OR (5 = 2 or 5 = 4 or 5 = 10)
>
>I'm comparing discrete values in the comparison list against discrete values
>in the the field value list. Only if one of the discrete values matches do I
>want to the record.
>
>Any ideas on how to accomplish this?
>
>Thanks for ideas!
>
>Paul Sinclair
>
>
>>  -Original Message-
>>  From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
>>  Sent: Wednesday, June 13, 2001 11:01 AM
>>  To: CF-Talk
>>  Subject: RE: Comparing value against a list of values
>>
>>
>>  Paul,
>>
>>  You should use the IN operator in your WHERE clause. I'm not clear on your
>>  data structure from your post, but try something like the following (make
>>  sure the list is in parentheses);
>>
>>  SELECT
>>  *
>>  FROM
>>  tbl
>>  WHERE
>>  csvList IN (10,11,21,100)
>>
>>  -Original Message-
>>  From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
>>  Sent: Wednesday, June 13, 2001 7:17 AM
>>  To: CF-Talk
>>  Subject: SQL: Comparing value against a list of values
>>
>>
>>  I have a table with a field that contains a comma delimited list
>>  of values,
>>  such as:
>  >
>>  10,11,21,100
>>
>>  In doing a  against the table, I want to select records where one
>>  or more of the values in this list of values matches a value in the WHERE
>>  clause of my sql query. For example:
>>
>>  select *
>>  from tbl
>>  where csvList = '%1%'
>>
>>  The problem is that the above select statement will select ANY record that
>>  has '1' in the field no matter what the "true" values in the field are
>>  (i.e., 1 is "LIKE" 10,11,21,100).
>>
>>  How do I make the select query compare '1' against '10', and '1' against
>>  '11' and '1' against '21', and '1' against '100'.
>>
>>  Thank you for help.
>>
>>  Regards,
>>  Paul Sinclair
>>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusio

RE: WYSIWYG editors

[Michael Bruce]

Check out www.siteobject.com They have a free editor and it is pretty cool

Michael Bruce
Fig Leaf Software

-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 2:05 PM
To: CF-Talk
Subject: WYSIWYG editors


Hi,
I am in search of a WYSIWYG editor that will allow a user to enter a
news article and have it display in HTML format.  I have looked at several
different ones but am looking for some feedback as to what is most
preferred, affordable (free), and easy for the user.   
I have looked at EasyEdit
http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the
interface on this one but it has to work with IE 4.0 and unfortunately this
CF tag needs at least IE 5.0.  
ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks
good but is kinda awkward how you have to click the link after updating to
see your results.  Thanks for your feedback.

-Sean McCarthy
---
HealthObjects
410-895-0379
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Protect CF from SQL/Oracle errors?

[Chris Norloff]

Thanks for the reply.  The problem isn't that the error message is passed to the user 
(it should be since this is the Development machine).  The problem is that the errors 
are killing the CFserver.

I can work to reduce the errors, of course, but errors are kind of expected on a 
Development machine.

Maybe crashing and restarting is not unreasonable given the circumstances(?)

thx
Chris Norloff

-- Original Message --
From: "Paul Johnston" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 12 Jun 2001 16:58:38 +0100

>I am not sure if what you want is something to stop CF being brought down
>(ie crashing) or it just returning errors.  If it's just errors, try this:
>
>
>
>
>... do whatever you want in here ...
>
>
>
>Otherwise, check your Oracle and CF installs...
>
>Paul
>
>-Original Message-
>From: Chris Norloff <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Date: 12 June 2001 16:49
>Subject: Protect CF from SQL/Oracle errors?
>
>
>>I've got a Solaris server with CF 4.5.2 that's being brought down by
>multiple "Oracle Error Code = 936 . missing expression" errors in the SQL
>statements passed to Oracle.  It's a Development box, so it's going to get
>lots of errors.
>>
>>Maybe the Developers could ease up on this, but I sure would like to
>protect the CF server.
>>
>>Any ideas?
>>
>>thx
>>Chris Norloff
>>
>>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: setup HTTPS on local PC

[Tony Schreiber]

Yes, equifax is a great alternative. They have a fast turnaround as well.
Verisign are a bunch of nazis.

However, for a local machine, your webserver (er, SSL package) should be
able to generate it's own certificate for your use. You don't need to buy
anything.

> Check out www.equifaxsecure.com
> You can get an SSL certificate from them for $79 which is alot cheaper than
> Verisign.
>
>
> Dan Phillips
> www.cfxhosting.com
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 12:16 PM
> To: CF-Talk
> Subject: RE: setup HTTPS on local PC
>
>
> Hi Duane:
>
> Where can I get an SSL key for my local PC?  from a company like Verisign?
>
> thanks
>
> Sandy
>
>
>
> <[EMAIL PROTECTED]>
>
> To get the https protocal working locally you have to install an ssl key on
> your machine
>
> Duane
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: setup HTTPS on local PC

[Garza, Jeff]

Do you have access to a WinNT/2K Server that has Certificate Services
installed?  If so, genrerate your own cert.  For a local machine shouldn't
be much of a problem.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, June 13, 2001 9:16 AM
To: CF-Talk
Subject: RE: setup HTTPS on local PC


Hi Duane:

Where can I get an SSL key for my local PC?  from a company like Verisign?

thanks

Sandy



<[EMAIL PROTECTED]>

To get the https protocal working locally you have to install an ssl key on
your machine

Duane


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

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

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

Session time out = never ? Bad?

[Mark W. Breneman]

Would it be "bad" to set a session timeout to 10 years in the future?  I
have a client that wants to never time out if he or his office workers are
coming to the site from their office.

I am thinking this would be "bad".  Possible server registry blot?


"I'm a little fuzzy on the whole good-bad thing. What do you mean bad?" -
Peter Venckman - Ghostbusters

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:53 AM
To: CF-Talk
Subject: Re: Re:Verity & SQL


Won't work with multiple users seaching on the same time because of the
collection "on the fly"
creation latency - both trying to use OntheFlyCollection which is alright
(for the first user) at second
number 1 but it's not updated for second user (or first user, depending who
run what and where
first...)

but If you can create a collection that will sure to be unique, again -
ontheflyCollection,
it might work, but will involve some major maintance..

again, I personally don't see any point nor success to this.

Thanks,

Michael
- Original Message -
From: "Jason Blum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:52 PM
Subject: Re:Verity & SQL


> Steve!
>
> Finally something I can contribute to this wonderful list!
>
> I am in fact working right now on the code to do just this.
>
> I am assuming you already have a Verity collection with SomeName.  Then
you need
> to make a kind of on-the-fly collection out of a normal db query and call
it
> Dbquery
>
> So on the search page, here is your Dbquery:
>
> 
> 
> SELECT Field1, Field2, Field3, Field4
> FROM SomeTable
> 
>
> 
>  COLLECTION="OntheFlyCollection"
> KEY="Field1"
> URL="Field2"
> TYPE="custom"
> TITLE="Field3"
> BODY="Field4"
> QUERY="GetSomeData">
>
> Then on the search results page,
>
>  name = "GetResults"
> collection = "SomeCollection, OntheFlyCollection"
> criteria = "#Form.Criteria#">
>
> And that's it.  Two things to note, you actually have to create a
collection
> called OntheFlyCollection first, so that you can be refreshing it here on
the
> search page.
>
> Also, notice that in the  you are telling Verity which fields
should be
> considered what Verity values, so Field2 is your URL for instance - kind
of
> limiting, but don't forget you can make two custom tags!
>
> HOpe this helps - got it all from p.733 of Forta and
> http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
>
> -Jason
>
>
> ___Reply Separator
> Subject:Verity & SQL
> Author: [EMAIL PROTECTED]
> Date:   6/13/01 4:00 PM
>
> Is there any way to combine the results of a CFSEARCH and a standard SQL
> search into the same CFOUTPUT ... basically merge two queries?
>
> Thanks
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFSearch

[Dave Watts]

> How do I set it CF's Search using Verity for our Intranet 
> site independent of our Internet search page? How would it  
> access only files pertaining to the Intranet directory and 
> not the Internet site.

You can create as many separate collections as you need, or want. Each of
these collections may contain the text of the files that you specify, or the
resultsets from queries that you run. Then, you can build search interfaces
that reference only the collections you want to use.

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

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

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

Cold Fusion, IE 5.5, IP Address URLs and CF Session Cookies

[Russel Madere]

Has anyone run into the problem of CF 4.5.2 not setting the CF ID and CF
Session cookies with IE 5.5 and a URL with an IP address instead of a domain
name?

We are running into that problem when we try to test our software using IE
5.5 and a IP address in the URL.  IT works fine in IE 5.0 and Nutscrape.
When we use the domain name (www.turbosquid.com) it works fine in IE 5.5 as
well.

I nailed this down because it is not setting Client variables in our
database storage for the IE 5.5 clients when they use the IP address it
access the site.  The rest of the Cold Fusion behaves like the Client
variables are set, but they are not.

Russel

  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.






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

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

RE: Security in a multiple server environment

[Dave Watts]

> (b)   The hosting company has a fetish for security and has 
> closed off CFRegistry, CFFile, CFDirectory etc, so I can't 
> imagine they'll let me use the registry for storing client 
> variables. (I've asked but not had a reply yet)

I'd hope they'd say no - you don't want to store variables there in any
case.

> Therefore I'll need to be storing client variables in the 
> SQLServer7 database - should I use the central datasource 
> for it or my own datasource? Are there issues here I need 
> to take into account?

Not really. It doesn't make any difference that I've noticed. I prefer to
have separate databases for application data, but there's nothing to stop
you from using one database for both application data and client variables.

> ( c )   aside from these issues,  if I just change all my 
> session. scope variables to client scope, is that going to 
> take care of most of the issues involved in keeping security 
> and tracking users round the site? Or are there other matters 
> I need to take into account now too?

If you're storing lots of data in the session scope, you might run into
problems when you use the client scope instead, because that means more
traffic between the app server and the database server. If you're storing
any complex objects, for example, you might think that you could simply
convert them to WDDX, then store that in the client scope - and you can do
that, but it may very well drag your performance down to an intolerable
level.

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

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

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

unbalanced in cfmail

[Alex]

anyone know what unbalanced error when running a cfmail tag from a query
means?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF Hit Counter

[Mark Warrick]

James,

I'm sure we could all roll our own for you in about 5 minutes, but why in
the heck would you want one?  They don't provide you with any more
meaningful data than WebTrends could.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: James Lathem [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 9:45 AM
> To: CF-Talk
> Subject: CF Hit Counter
>
>
> Hey Gang,
>
> Does anyone have any experience with a ColdFusion hit counter? I
> have found
> several in the development area of Coldfusion.com and was wondering if one
> is better than another.
>
> I know this is asking for preferences and one persons opinion is just that
> their opinion. However, if you have had some experience with the
> hit counter
> you have had more than I have. THANKS!
>
> Regards,
> James Lathem
> Web Developer and
> Certified Allaire ColdFusion Developer
>
> McRae Communications
> Office: 770.460.7277 Ext. 227
> Fax: 770.460.0963
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Paul Sinclair]

Mark,

Yep - I realize that SQL isn't set up to do this. I'm trying to do a work
around using some kind of CF magic. Will get around to normalizing the db
but until that is done, I'm hoping to find a workaround.

Best,
Paul

> -Original Message-
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 1:13 PM
> To: CF-Talk
> Subject: RE: Comparing value against a list of values
>
>
> Let me get this right...
> You want to do a "SQL list contains" function on a field with a comma
> delimited list of values (csvList)?  You want to return all the
> records that
> contain the value "1" (not "100" or "11") in a field (csvList)
> that contains
> comma delimited lists? Correct?
>
> I don't think that can be done in simple SQL.  Maybe with a bit of SQL
> Magic.
>
> If anyone knows how to do this I would be very very interested!
>
> As a work around you could break your "csvList" field off to a relational
> table.  Each value in the comma delimited list would get its own
> record with
> an id of the parent record.
>
> Mark W. Breneman
> -Cold Fusion Developer
> -Network Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
>
> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 10:01 AM
> To: CF-Talk
> Subject: RE: Comparing value against a list of values
>
>
> Paul,
>
> You should use the IN operator in your WHERE clause. I'm not clear on your
> data structure from your post, but try something like the following (make
> sure the list is in parentheses);
>
> SELECT
>   *
> FROM
>   tbl
> WHERE
>   csvList IN (10,11,21,100)
>
> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 7:17 AM
> To: CF-Talk
> Subject: SQL: Comparing value against a list of values
>
>
> I have a table with a field that contains a comma delimited list
> of values,
> such as:
>
> 10,11,21,100
>
> In doing a  against the table, I want to select records where one
> or more of the values in this list of values matches a value in the WHERE
> clause of my sql query. For example:
>
> select *
> from tbl
> where csvList = '%1%'
>
> The problem is that the above select statement will select ANY record that
> has '1' in the field no matter what the "true" values in the field are
> (i.e., 1 is "LIKE" 10,11,21,100).
>
> How do I make the select query compare '1' against '10', and '1' against
> '11' and '1' against '21', and '1' against '100'.
>
> Thank you for help.
>
> Regards,
> Paul Sinclair
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Passing empty form var to SQL WHERE

[Sutton Yamanashi]

Try this:


Select *
from products
where  type = '#form.type#'
AND finish1 = '#form.finish1#'
AND finish2 = '#form.finish2#'
AND system = '#form.system#' 


Just make sure that the default (selected) option in the drop down has a 
value of "" ((select one))



Original Message Follows
From: Chad Gray <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Passing empty form var to SQL WHERE
Date: Wed, 13 Jun 2001 12:45:45 -0400


OK im making a search application where people can use pull down menus to
select what to search on.

In my action template im making a CFQUERY like this:


Select *
from products
where  type = '#form.type#' AND finish1 = '#form.finish1#' AND
finish2 = '#form.finish2#' AND system = '#form.system#' 


My problem is if the person only selects one drop down from the form page
and leaves the others blank then i get a SQL statement like this:

search (Records=0,
Time=47ms)
SQL = 
Select *
from products
where   type = 'laminate' AND finish1 = '' AND
finish2 = '' AND system = ''

So no records are found.  BTW I would like to use AND's not
OR's so the search is narrowed, and not broadened.

I have tried some  statements to figure out if the user
selected a drop down, but then i run into SQL problems where i have ANDs
next to each other.

search (Records=0,
Time=47ms)
SQL = 
Select *
from products
where   type = 'laminate' AND AND AND
  

Then i tried to put the AND SQL inside of the CFIFs, but then i run into
problems where if the first one is not selected or the last one is not
selected the AND's are all screwed up also.

Any ideas how to make this SQL WHERE statement work for empty form
variables?

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

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

RE: Compacting .cfm files

[Zachary S. Bedell]

While I agree with other posters on this thread that redesigning your
form might be your best bet, there is some hope in the compression
department...

I worked up a tag a while ago that will GZIP page content and send it to
the browser.  The tag detects all browsers that are able to handle the
GZIP encoded content and compresses for those browsers while sending
uncompressed content to browsers than can't handle GZIP.  I'm sure
you'll find info on the tag if you search the list archives.  There was
a bit of lively discussion on-list as it was developed, and I drew from
ideas of some folks who posted.  (I tried to give credit where due in
the tag, but if anyone thinks I blatently ripped off your idea, I'd be
happy to ammend the credits.  Just lemme know! ;-)

I just submitted the tag (CF_GZipPage) to the Tag Gallery, and it should
appear in a day or so.  If you absolutely can't break your form into
multiple pages, then this might be a solution.

If you're in a hurry, email me directly ([EMAIL PROTECTED]), and
I'll send you a copy of the tag I just submitted.

Best regards,
Zac Bedell

> -Original Message-
> From: Brian Fox [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, May 25, 2001 11:28 AM
> To: CF-Talk
> Subject: Compacting .cfm files
> 
> 
> Sorry if this is beating a dead horse.  A search of the 
> archives brought up similar questions, but didn't really 
> approach a solution.
> 
> I have a form that contains as many as 200 select boxes with 
> about 6 options each and 200 more input boxes.  I guess that 
> there is some type of resource crunch (memory, widget 
> handles, who knows) that causes the following error: when 
> scrolling a large form, the select boxes begin to smear 
> vertically. They become clumped together and function oddly 
> (some still seem to work, although I can't tell what 'line' 
> they belong to).
> 
> It's in the project specs that I cannot break the form up... 
> which throws out the 'display records 1-20 21-40' type solutions.
> 
> The only thing I can think to do is tighten the cfm code up.  
> Our shop is indent happy for readability.  The indenting 
> produces a LOT of whitespace (perhaps bloating the code as 
> much as 100%).  I've already added  tags to squash 
> output on custom tags, queries, etc.  But there is still a 
> lot of whitespace in the other 'normal' code.
> 
> Are there any utilities to obliterate whitespace in cfm 
> files?  Er, something along the lines of turning an indented 
> file into a really long single string?  Is there a code 
> beautifier to do the opposite?  Is this approach worthwhile?
> 
> Thanks,
> Brian
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT SQL Server WOW THIS LIST IS SLOW!

[Angél Stewart]

You're right.
>From now on we'll all assume that someone *else* answered your question and
not bother.
^_^

-Gel


-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]

This list is a bit slow, no?
about 3490853 peopls have answered pretty simple question...


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

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

RE: OT SQL Server (OK 1 More ?)

[Michael Bruce]

I think a lot of people are going to reply on this but here goes...

4 is not the length but the amount of space that is allowed.

If it where a varchar or char then yes, only 4 characters could be added. 

But it is 4 bytes and can store numbers from
-2,147,483,647 to 2,147,483,647. I suppose that you might run into a problem
if you have more than 2.1 billion records on that table.

Mike Bruce
Fig Leaf Software

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:32 PM
To: CF-Talk
Subject: RE: OT SQL Server (OK 1 More ?)


OK I got it. Now that I have the primary key set with datatype int, the
length is limited to 4. Is this correct and will this limit the table to
 records?

Thanks,
Rich

-Original Message-
From: Craig Bowes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:30 AM
To: CF-Talk
Subject: RE: OT SQL Server


You must set a field to be identity and not null.  You can set its seed to
any number (start autonumbering at 1000 for example.)

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server

I have a simple question.  How do you set the primary key field to
autonumber in SQL server?  I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.

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

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

RE: Comparing value against a list of values

[Paul Sinclair]

Paul,

Thanks for this note. I realize the table design needs normalization and
that is the long term solution. Right now I need a short-term fix until we
can get around to redesigning the db. Unfortunately, we've got several
tables with tens of thousands of records each that require normalization!

I've been trying to figure out a simple way to extract the field contents
from the non-normalized table and move the contents to a new, normalized
table with a single record for each. Is there a good way to do this?

Regards,
Paul Sinclair


> -Original Message-
> From: Paul Smith [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 12:45 PM
> To: CF-Talk
> Subject: RE: Comparing value against a list of values
>
>
> Since the list is in a column in the database table, the IN below won't
> work.  I believe you'll have to normalize your table, or better create
> another table.  In the latter case, for example, assuming the list
> 10,11,21,100 is in a row with ID = 89, the new table for these
> data would be:
>
> 89 10
> 89 11
> 89 21
> 89 100
>
> Then you would do a join between this new table and the old one
> to find the
> records of interest.
>
> best,  paul
>
>
> At 08:00 AM 6/13/01 -0700, you wrote:
> >Paul,
> >
> >You should use the IN operator in your WHERE clause. I'm not
> clear on your
> >data structure from your post, but try something like the following (make
> >sure the list is in parentheses);
> >
> >SELECT
> > *
> >FROM
> > tbl
> >WHERE
> > csvList IN (10,11,21,100)
> >
> >-Original Message-
> >From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, June 13, 2001 7:17 AM
> >To: CF-Talk
> >Subject: SQL: Comparing value against a list of values
> >
> >
> >I have a table with a field that contains a comma delimited list
> of values,
> >such as:
> >
> >10,11,21,100
> >
> >In doing a  against the table, I want to select records
> where one
> >or more of the values in this list of values matches a value in the WHERE
> >clause of my sql query. For example:
> >
> >select *
> >from tbl
> >where csvList = '%1%'
> >
> >The problem is that the above select statement will select ANY
> record that
> >has '1' in the field no matter what the "true" values in the field are
> >(i.e., 1 is "LIKE" 10,11,21,100).
> >
> >How do I make the select query compare '1' against '10', and '1' against
> >'11' and '1' against '21', and '1' against '100'.
> >
> >Thank you for help.
> >
> >Regards,
> >Paul Sinclair
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT SQL Server (OK 1 More ?)

[Garza, Jeff]

>From the SQL BOL...

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1
(2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is
integer.

It only takes up 4 bytes of space for storage.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, June 13, 2001 9:32 AM
To: CF-Talk
Subject: RE: OT SQL Server (OK 1 More ?)


OK I got it. Now that I have the primary key set with datatype int, the
length is limited to 4. Is this correct and will this limit the table to
 records?

Thanks,
Rich

-Original Message-
From: Craig Bowes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:30 AM
To: CF-Talk
Subject: RE: OT SQL Server


You must set a field to be identity and not null.  You can set its seed to
any number (start autonumbering at 1000 for example.)

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server

I have a simple question.  How do you set the primary key field to
autonumber in SQL server?  I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.

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

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

CFForm File Upload and MacIntosh IE bug fix

[Sutton Yamanashi]

Hello all!

I have a cfform with a file upload field, so the enctype attribute has to be 
set to ="multipart/form-data".




It works fine on PC IE browser, but when testing it on MacIntosh, none of 
the form fields are getting passed.  I have tried using the trim() function 
in the update query, as well creating a hidden form field with the same 
field name and a value of "0".  On the update page I have a script that 
checks if the value is 0, and if it is it sets the value to "-1" (This was 
my interpretation of a 'solution' to this problem posted on a thread at 
Allaire.com, but I don't understand how it is supposed to work).


if (new_newsletter.nlt_filename.value.length == 0){
new_newsletter.nlt_filename.value = '-1';
}


Can anyone please help me and my comrads solve this problem?

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

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

Re: OT SQL Server (OK 1 More ?)

[Derek Hamilton]

That means 4 bytes.  This will limit the number but more like around 30,000.
I don't remember the exact number, anyone...?

Derek
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 9:32 AM
Subject: RE: OT SQL Server (OK 1 More ?)


> OK I got it. Now that I have the primary key set with datatype int, the
> length is limited to 4. Is this correct and will this limit the table to
>  records?
>
> Thanks,
> Rich
>
> -Original Message-
> From: Craig Bowes [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 11:30 AM
> To: CF-Talk
> Subject: RE: OT SQL Server
>
>
> You must set a field to be identity and not null.  You can set its seed to
> any number (start autonumbering at 1000 for example.)
>
> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 9:37 AM
> To: CF-Talk
> Subject: OT SQL Server
>
> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL VS ACCESS

[Mark Warrick]

I've learned to avoid using autonumber fields whenever possible.  It makes
the job of moving databases between platforms simple.  At worst, I have to
put the primary key constraints back on the index fields of each table -
which is no big deal.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:02 AM
> To: CF-Talk
> Subject: RE: SQL VS ACCESS
>
>
> On 6/12/01, Norman Elton penned:
> >Make sure all your fields that should be indexed are indexed. I think the
> >upsizing wizard forgets about this.
>
> The upsizing wizard does a pretty good job of rebuilding the indexes
> and relationships. It's DTS that loses that stuff.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Body and Subject of my messages not arriving

[Larry Juncker]

Thanks Tim - Checked that and it is not checked.  Any other ideas?
This seems to only be effecting my mail from JS-Jive.

-Original Message-
From: Tim Painter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:15 AM
To: CF-Talk
Subject: Re: Body and Subject of my messages not arriving


Larry,
  I have seen this a lot when you set Word as your email editor.   Try
turning that option off in Mail Format options and see if that fixes it. (if
that is the case)

Tim P.


- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:32 AM
Subject: Body and Subject of my messages not arriving


> HELP Please -
>
> I know this sis for another list, however - I am receiving my messages
from JS-Jive, but my subject and body are empty on all of them.  Has anyone
run into this before and is there a way for me to fix it?  I am using
Outlook 2000.  Just started the other day.
>
> Thanks
>
> Larry Juncker
> Senior ColdFusion Developer
> Heartland Communications Group, Inc.
> [EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

What is January in French? German? CF knows it already

[Raymond Camden]

I was having a conversation with Ben Forta about the UDF library project and
he suggested I add a function that would print the locale version of a
month. For example, the French (Standard) version of January. Well, I pinged
him back and said that as far as I know, I'd have to manually enter the
strings.

It turns out CF does this for you.

Check out the following example:


function LSMonthAsString(month_number)
{
VAR d=CreateDate(2000, month_number, 1);
return LSDateFormat(d, "");
}




#locale#

#LSMonthAsString(X)#




This will loop through all the supported locales and return the name of each
month. Maybe this is something everyone knew about it but it sure surprised
the heck out of me. I knew CF had good locale functionality, but this rocks.

Anyway, thanks go to Ben Forta for the idea. I'm going to be modifying this
UDF and using it at www.cflib.org.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


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

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

WYSIWYG editors

[Sean McCarthy]

Hi,
I am in search of a WYSIWYG editor that will allow a user to enter a
news article and have it display in HTML format.  I have looked at several
different ones but am looking for some feedback as to what is most
preferred, affordable (free), and easy for the user.   
I have looked at EasyEdit
http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the
interface on this one but it has to work with IE 4.0 and unfortunately this
CF tag needs at least IE 5.0.  
ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks
good but is kinda awkward how you have to click the link after updating to
see your results.  Thanks for your feedback.

-Sean McCarthy
---
HealthObjects
410-895-0379


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

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

RE: Comparing value against a list of values

[Paul Sinclair]

Dylan,

Thanks for this suggestion. This doesn't do what is needed though I don't
think. My trouble is I am comparing one list of values against another list
of values. Take the following situation:

1. The string I want to compare against is this: 1,3,5

2. The field (FLD) I am comparing it against contains this value: 2,4,10

If I use IN, it would look like this:

WHERE '2,4,10' IN('1,3,5')

What I _WANT_ to do is this (in layman's terms):

get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 =
10) OR (5 = 2 or 5 = 4 or 5 = 10)

I'm comparing discrete values in the comparison list against discrete values
in the the field value list. Only if one of the discrete values matches do I
want to the record.

Any ideas on how to accomplish this?

Thanks for ideas!

Paul Sinclair


> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 11:01 AM
> To: CF-Talk
> Subject: RE: Comparing value against a list of values
>
>
> Paul,
>
> You should use the IN operator in your WHERE clause. I'm not clear on your
> data structure from your post, but try something like the following (make
> sure the list is in parentheses);
>
> SELECT
>   *
> FROM
>   tbl
> WHERE
>   csvList IN (10,11,21,100)
>
> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 7:17 AM
> To: CF-Talk
> Subject: SQL: Comparing value against a list of values
>
>
> I have a table with a field that contains a comma delimited list
> of values,
> such as:
>
> 10,11,21,100
>
> In doing a  against the table, I want to select records where one
> or more of the values in this list of values matches a value in the WHERE
> clause of my sql query. For example:
>
> select *
> from tbl
> where csvList = '%1%'
>
> The problem is that the above select statement will select ANY record that
> has '1' in the field no matter what the "true" values in the field are
> (i.e., 1 is "LIKE" 10,11,21,100).
>
> How do I make the select query compare '1' against '10', and '1' against
> '11' and '1' against '21', and '1' against '100'.
>
> Thank you for help.
>
> Regards,
> Paul Sinclair
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: setup HTTPS on local PC

[Dan Phillips]

Sandy,

Check out www.equifaxsecure.com
You can get an SSL certificate from them for $79 which is alot cheaper than
Verisign.


Dan Phillips
www.cfxhosting.com

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:16 PM
To: CF-Talk
Subject: RE: setup HTTPS on local PC


Hi Duane:

Where can I get an SSL key for my local PC?  from a company like Verisign?

thanks

Sandy



<[EMAIL PROTECTED]>

To get the https protocal working locally you have to install an ssl key on
your machine

Duane


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


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

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

Re:RE: Verity & SQL

[Jason Blum]

Hmmm...

I don't know - because I have been able to do just what you are describing.  My
first suspicion is whether you are accidentally refreshing a different
collection than that which you are searching?  (Don't get me wrong - this is
just what I did last week and spent all day mystified by it)  

The other two things I am thinking are did you just add data to existing columns
or did you perhaps create a new column and then not tell CFINDEX about it or
what to do with it?

And then the third thought is are you joining tables? - because there was
something in the book about indexing data from two tables which have a
master-servant relationship (I know the word is not servant - just can't
remember)

-J



Reply Separator
Subject:RE: Verity & SQL
Author: [EMAIL PROTECTED]
Date:   6/13/01 6:03 PM

Hi Jason,

Thanks for the help. This is a great solution - which I've already tried
(also from pg 733 :-) ... but to no avail.

Basically, I've inherited a database from an existing site and when I index
the data everything works fine. Then when I add new records and re-index,
they are not included. The query that I use to get the data I want to index
has been tried in SQL query analyzer, and the new records show up - so they
*should* be included in the indexing.

I've tried absolutely everything - but nothing seems to work.

So now I'm trying to combine my standard SQL query with another Verity
query, without having to create a Verity collection from the database query.

Dave Watts has suggested "building a query object using the CF query
functions, and populating the query by looping over the two source
queries" - but as he suggested, this may be too slow.

DOH!






> -Original Message-
> From: Jason Blum [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:52 PM
> To: CF-Talk
> Subject: Re:Verity & SQL
>
>
> Steve!
>
> Finally something I can contribute to this wonderful list!
>
> I am in fact working right now on the code to do just this.
>
> I am assuming you already have a Verity collection with SomeName.
>  Then you need
> to make a kind of on-the-fly collection out of a normal db query
> and call it
> Dbquery
>
> So on the search page, here is your Dbquery:
>
> 
> 
> SELECT Field1, Field2, Field3, Field4
> FROM SomeTable
> 
>
> 
>  COLLECTION="OntheFlyCollection"
> KEY="Field1"
> URL="Field2"
> TYPE="custom"
> TITLE="Field3"
> BODY="Field4"
> QUERY="GetSomeData">
>
> Then on the search results page,
>
>  name = "GetResults"
> collection = "SomeCollection, OntheFlyCollection"
> criteria = "#Form.Criteria#">
>
> And that's it.  Two things to note, you actually have to create a
> collection
> called OntheFlyCollection first, so that you can be refreshing it
> here on the
> search page.
>
> Also, notice that in the  you are telling Verity which
> fields should be
> considered what Verity values, so Field2 is your URL for instance
> - kind of
> limiting, but don't forget you can make two custom tags!
>
> HOpe this helps - got it all from p.733 of Forta and
> http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
>
> -Jason
>
>
> ___Reply Separator
> Subject:Verity & SQL
> Author: [EMAIL PROTECTED]
> Date:   6/13/01 4:00 PM
>
> Is there any way to combine the results of a CFSEARCH and a standard SQL
> search into the same CFOUTPUT ... basically merge two queries?
>
> Thanks
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Verity & SQL

[Paul Smith]

Assuming we're talking about searching a database here, what I did (before 
I went to SQL Server Full Text) was to perform the Verity search to find a 
list of IDs whose records matched the Verity Search query, and then perform 
a standard SQL search, a la:



to match the SQL requirements.

It was not as fast as SQL7 full text on the same data.  (Don't know about 
CF5 K2)

best,  paul

At 06:48 PM 6/13/01 +0200, you wrote:
>Even if there would, It'll be inefficient because in order to use CFSEARCH
>you will need
>to rebuild the Verity Index to match the last SQL query, but if you don't
>plan to change
>the original SQL content (i.e - the first query result set) - you absolutly
>can do it.
>
>just create a new collection and index the result set -
>I think the whole process is called search... ;-)
>
>Thanks,
>
>Michael
>- Original Message -
>From: "Steve Vosloo" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, June 13, 2001 4:00 PM
>Subject: Verity & SQL
>
>
> > Is there any way to combine the results of a CFSEARCH and a standard SQL
> > search into the same CFOUTPUT ... basically merge two queries?
> >
> > Thanks
> > Steve
> >
> >
> > Development Manager
> > Vardus Internet Solutions (SA)
> >
> > Tel: (+27) 21 670 9880
> > Fax: (+27) 21 674 4549
> >
> > Email: [EMAIL PROTECTED]
> > Website: www.vardus.com
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFSearch

[Robert Orlini]

How do I set it CF's Search using Verity for our Intranet site independent
of our Internet search page? How would it  access only files pertaining to
the Intranet directory and not the Internet site.

Thanks.

Robert O.
Webteam
HWW


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

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

Re[2]: Re:Verity & SQL

[Jason Blum]

Michael,

Hmmm...  I think you may be right - however, the onthefly collection is not
aptly named because in fact, the collection is just refreshed (based on the SQL
query) every night and unless the db has been significantly modified, there's no
reason to refesh it again throughout the day.

As for maintaining it, couldn't I just have all the code for refreshing in some
page that gets HTTP requested in Administrator's scheduled tasks?

-J

Reply Separator
Subject:Re: Re:Verity & SQL
Author: [EMAIL PROTECTED]
Date:   6/13/01 6:52 PM

Won't work with multiple users seaching on the same time because of the
collection "on the fly"
creation latency - both trying to use OntheFlyCollection which is alright
(for the first user) at second
number 1 but it's not updated for second user (or first user, depending who
run what and where
first...)

but If you can create a collection that will sure to be unique, again -
ontheflyCollection,
it might work, but will involve some major maintance..

again, I personally don't see any point nor success to this.

Thanks,

Michael
- Original Message -
From: "Jason Blum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:52 PM
Subject: Re:Verity & SQL


> Steve!
>
> Finally something I can contribute to this wonderful list!
>
> I am in fact working right now on the code to do just this.
>
> I am assuming you already have a Verity collection with SomeName.  Then
you need
> to make a kind of on-the-fly collection out of a normal db query and call
it
> Dbquery
>
> So on the search page, here is your Dbquery:
>
> 
> 
> SELECT Field1, Field2, Field3, Field4
> FROM SomeTable
> 
>
> 
>  COLLECTION="OntheFlyCollection"
> KEY="Field1"
> URL="Field2"
> TYPE="custom"
> TITLE="Field3"
> BODY="Field4"
> QUERY="GetSomeData">
>
> Then on the search results page,
>
>  name = "GetResults"
> collection = "SomeCollection, OntheFlyCollection"
> criteria = "#Form.Criteria#">
>
> And that's it.  Two things to note, you actually have to create a
collection
> called OntheFlyCollection first, so that you can be refreshing it here on
the
> search page.
>
> Also, notice that in the  you are telling Verity which fields
should be
> considered what Verity values, so Field2 is your URL for instance - kind
of
> limiting, but don't forget you can make two custom tags!
>
> HOpe this helps - got it all from p.733 of Forta and
> http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
>
> -Jason
>
>
> ___Reply Separator
> Subject:Verity & SQL
> Author: [EMAIL PROTECTED]
> Date:   6/13/01 4:00 PM
>
> Is there any way to combine the results of a CFSEARCH and a standard SQL
> search into the same CFOUTPUT ... basically merge two queries?
>
> Thanks
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: RealAudio and ColdFusion

[Zachary S. Bedell]

Since I'm assuming your RealAudio show is a live stream, then there
won't be any file on the server for you to check.  So CFFILE and
FileExists are useless for this case.

Now...  To the best of my memory, REAL uses an HTTP-like protocol for
requesting streams.  Once the stream is setup, it jumps over to a
completely different protocol (RTSP -- there's an RFC for it).  What you
may be able to do is use CFHTTP to connect to the standard RealServer
request port.  If the stream doesn't exist, I *think* you'll get
something like a 404 not found error that CFHTTP may be able to
recognize.  No guarantees, tho; and chances are if CFHTTP doesn't like
what it sees, it might take your server out

Your safest bet would be to use CFX_TCPClient as mentioned by someone
else on this thread.  

Honestly, tho...  I'd look into different web designs that wouldn't
include this functionality.  What you're trying to do, no matter how you
accomplish it, will add a huge amount of overhead and a good chance for
server instability for a rather small feature.

I'm assuming you want your web design to show a "Click Here to Listen"
type link only when there's actually a show in progress, right?  Since
your show probably runs on some sort of regular schedule, why not keep
that schedule in a database and use that information to display the link
when appropriate?  Trying to connect to your RealServer for every single
request to the page with this link would probably have very bad effects
on both your RealServer and your CFServer.

Best regards,
Zac Bedell

> -Original Message-
> From: David Grabbe [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, May 29, 2001 3:57 PM
> To: CF-Talk
> Subject: RealAudio and ColdFusion
> 
> 
> Howdy folks,
> 
> I'm running CF 4.5.1.  The organization I work for has a 
> weekly program which we stream via RealAudio.  The RealAudio 
> aspect is working just fine, but I'm wondering if there is a 
> way for CF to detect whether or not the RealAudio stream is 
> active or not (i.e. check for the existence of the .rm file). 
>  I looked into using CFHTTP, but couldn't get that to work -- 
> probably because of the media type.  I'm not actually wanting 
> to download, just see if the stream exists.  If there an easy 
> way to do this?  Are there any RA gurus out there  :)
> 
> Thanks in advance!
> 
> Cheers,
> David
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Mark W. Breneman]

Let me get this right...
You want to do a "SQL list contains" function on a field with a comma
delimited list of values (csvList)?  You want to return all the records that
contain the value "1" (not "100" or "11") in a field (csvList) that contains
comma delimited lists? Correct?

I don't think that can be done in simple SQL.  Maybe with a bit of SQL
Magic.

If anyone knows how to do this I would be very very interested!

As a work around you could break your "csvList" field off to a relational
table.  Each value in the comma delimited list would get its own record with
an id of the parent record.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 10:01 AM
To: CF-Talk
Subject: RE: Comparing value against a list of values


Paul,

You should use the IN operator in your WHERE clause. I'm not clear on your
data structure from your post, but try something like the following (make
sure the list is in parentheses);

SELECT
*
FROM
tbl
WHERE
csvList IN (10,11,21,100)

-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 7:17 AM
To: CF-Talk
Subject: SQL: Comparing value against a list of values


I have a table with a field that contains a comma delimited list of values,
such as:

10,11,21,100

In doing a  against the table, I want to select records where one
or more of the values in this list of values matches a value in the WHERE
clause of my sql query. For example:

select *
from tbl
where csvList = '%1%'

The problem is that the above select statement will select ANY record that
has '1' in the field no matter what the "true" values in the field are
(i.e., 1 is "LIKE" 10,11,21,100).

How do I make the select query compare '1' against '10', and '1' against
'11' and '1' against '21', and '1' against '100'.

Thank you for help.

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

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

OT - Access Count() question

[Diana Nichols]

I'm implementing Joe Celko's nested set functionality to store an employee
tree...the wrinkle is that I have several trees (representing different
companies) stored in the same table...with a companyID identifier.

Everything works great except for the count(*) included with each
rowit's not coming up the way it should, and I'm not even sure exactly
how it's messing up - some people who are on level 1 are listed at level 7,
some at level 2, etc. I can't figure the pattern.

(Here's my query)

select child.userID, child.username, count(*) as thislevel, 
child.leftno,
child.rightno
from salesroles as parent, salesroles as child
where child.companyID = #companyID# and child.leftno between 
parent.leftno
and parent.rightno
group by child.leftno, child.userID, child.username, child.rightno


(DB is currently in Access, but will move to SQL 2000 within a week -
assuming I get it to work - so any wrinkles that differ between them would
also be a great help.)

I'm lostany help would be greatly appreciated!

D

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long


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

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

RE: Sending MP3's Through CF

[Zachary S. Bedell]

One small thing you might want to take into account here...  I don't
know how many users you're planning on supporting w/ the script, but
ColdFusion does have a limited number of threads per server.

They way you're doing it now -- creating the streaming metafile w/ CF
and allowing their MP3 player to grab the file from the webserver
without involving CF -- is okay.  If you went ahead with your plans to
eliminate the webserver mapping, you'd be in trouble.  Since playing an
MP3 obviously takes some time (the length of the song), your users would
be connected to your CF server and consuming one of your precious worker
threads the entire time they're playing.  God forbid they hit 'Pause'
and walked away from their machine!

Also, if your CF Server has a max execution time out set (and it
should!), then your users would only be able to play the song for as
long as the time out value.  After that, the server would drop the
connection, drop a log entry in your server.log, and free up the thread.

In short, CF probably isn't the best solution for streaming MP3's.  You
should probably look into the ShoutCAST server protocol.  Poke around
Winamp.com, and I'm fairly certain you'll find GPL'd freeware to act as
an MP3 server.


Now...  If you *really* want to stream the files directly from your CF
server, it would look something like this:




#EXTM3U
#EXTINF:-1,#title#
http://my.server/GetStream.cfm?File=#StreamFile#









But like I said...  Don't do it that way.  Your server would be brought
to its knees!

Best regards,
Zac Bedell

> -Original Message-
> From: Rich Z [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, June 04, 2001 11:19 PM
> To: CF-Talk
> Subject: Sending MP3's Through CF
> 
> 
> I figured out a way to send mp3's through a web server on 
> demand (pseudo-streaming by using CFCONTENT w/ a mime-type of 
> audio/mpegurl. The page that does the sending looks like this:
>  
> 
> 
> #EXTM3U
> #EXTINF:-1,#title#
> http://my.server/mp3/#streamurl#
> 
>  
> My question: I'd like to still do the above without mapping 
> my mp3 folder on the web server and referring to my own 
> server. As it is - people can snoop around the /mp3 folder on 
> the web server. Any suggestions on how to get around this?
>  
> Thanks,
> Rich
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT SQL Server WOW THIS LIST IS SLOW!

[Michael Lugassy]

This list is a bit slow, no?
about 3490853 peopls have answered pretty simple question...


Thanks,

Michael
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 5:32 PM
Subject: RE: OT SQL Server


> > I have a simple question. How do you set the primary key field
> > to autonumber in SQL server?  I have always used Access where
> > this is a choice but don't see how to do it with SQL Server 2000.
>
> In SQL Server, it's called an identity column.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Security in a multiple server environment

[Mike Kear]

I'm sorry if this is going over old ground, but I never had to face this
situation before and to tell the truth, I didn't really grasp the
implications of session vs client variables before .

I'm moving a site to a load-balanced multiple server environment that has
been working fine on a single-server setup.

No problem until I came to do the login part of the admin section.  Of
course the session variables that were fine in the old setup won't work
here.  I have to use client variables.  Now I have some choices I've never
had to face before   I'd like the opinions of the group here please ...

(a)  Should I set client cookies and if so should they be session only?
The people accessing the admin section are a wide variety of users, with a
variety of browsers, but I don't have a problem with insisting they sllow
cookies if that's the best way to go.  The cookies are only going to be
necessary for access to the admin area of the site anyway.

(b)   The hosting company has a fetish for security and has closed off
CFRegistry, CFFile, CFDirectory etc, so I can't imagine they'll let me use
the registry for storing client variables.  (I've asked but not had a reply
yet)Therefore I'll need to be storing client variables in the SQLServer7
database - should I use the central datasource for it or my own datasource?
Are there issues here I need to take into account?

( c )   aside from these issues,  if I just change all my session. scope
variables to client scope, is that going to take care of most of the issues
involved in keeping security and tracking users round the site?   Or are
there other matters I need to take into account now too?


Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks






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

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

Passing empty form var to SQL WHERE

[Chad Gray]

OK im making a search application where people can use pull down menus to
select what to search on.

In my action template im making a CFQUERY like this:


Select *
from products
where  type = '#form.type#' AND finish1 = '#form.finish1#' AND
finish2 = '#form.finish2#' AND system = '#form.system#' 


My problem is if the person only selects one drop down from the form page
and leaves the others blank then i get a SQL statement like this:

search (Records=0,
Time=47ms)
SQL = 
Select *
from products
where   type = 'laminate' AND finish1 = '' AND
finish2 = '' AND system = ''

So no records are found.  BTW I would like to use AND's not
OR's so the search is narrowed, and not broadened.

I have tried some  statements to figure out if the user
selected a drop down, but then i run into SQL problems where i have ANDs
next to each other.

search (Records=0,
Time=47ms)
SQL = 
Select *
from products
where   type = 'laminate' AND AND AND
  

Then i tried to put the AND SQL inside of the CFIFs, but then i run into
problems where if the first one is not selected or the last one is not
selected the AND's are all screwed up also.

Any ideas how to make this SQL WHERE statement work for empty form
variables?

Thanks in advanced!
Chad


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

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

RE: Verity & SQL

[Paul Smith]

This is one of the reasons I went to SQL Server 7 full text search.
It's easy and faster to combine full text search with standard SQL.

best,  paul

At 11:19 AM 6/13/01 -0400, you wrote:
> > Is there any way to combine the results of a CFSEARCH and a
> > standard SQL search into the same CFOUTPUT ... basically merge
> > two queries?
>
>You can do that very easily with the query-a-query functionality in CF 5. In
>CF 4.x, you can do this by building a query object using the CF query
>functions, and populating the query by looping over the two source queries.
>I'll bet there's a custom tag on the developer's exchange for this. It's
>going to be relatively slow to do that, though.


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

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

CF Hit Counter

[James Lathem]

Hey Gang,

Does anyone have any experience with a ColdFusion hit counter? I have found
several in the development area of Coldfusion.com and was wondering if one
is better than another.

I know this is asking for preferences and one persons opinion is just that
their opinion. However, if you have had some experience with the hit counter
you have had more than I have. THANKS!

Regards,
James Lathem
Web Developer and
Certified Allaire ColdFusion Developer

McRae Communications
Office: 770.460.7277 Ext. 227
Fax: 770.460.0963



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

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

RE: Comparing value against a list of values

[Paul Smith]

Since the list is in a column in the database table, the IN below won't 
work.  I believe you'll have to normalize your table, or better create 
another table.  In the latter case, for example, assuming the list 
10,11,21,100 is in a row with ID = 89, the new table for these data would be:

89 10
89 11
89 21
89 100

Then you would do a join between this new table and the old one to find the 
records of interest.

best,  paul


At 08:00 AM 6/13/01 -0700, you wrote:
>Paul,
>
>You should use the IN operator in your WHERE clause. I'm not clear on your
>data structure from your post, but try something like the following (make
>sure the list is in parentheses);
>
>SELECT
> *
>FROM
> tbl
>WHERE
> csvList IN (10,11,21,100)
>
>-Original Message-
>From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 13, 2001 7:17 AM
>To: CF-Talk
>Subject: SQL: Comparing value against a list of values
>
>
>I have a table with a field that contains a comma delimited list of values,
>such as:
>
>10,11,21,100
>
>In doing a  against the table, I want to select records where one
>or more of the values in this list of values matches a value in the WHERE
>clause of my sql query. For example:
>
>select *
>from tbl
>where csvList = '%1%'
>
>The problem is that the above select statement will select ANY record that
>has '1' in the field no matter what the "true" values in the field are
>(i.e., 1 is "LIKE" 10,11,21,100).
>
>How do I make the select query compare '1' against '10', and '1' against
>'11' and '1' against '21', and '1' against '100'.
>
>Thank you for help.
>
>Regards,
>Paul Sinclair
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT:SQL Full Text

[Paul Hastings]

> 3. when the database is updated with the files and files
> information and on OFFHOURS, A Replication Job start at the
> LOCAL DEVELOPING sql server, using PUSH - to the PRODUCTION
> SERVER in Europe.

replication is essentially vodoo ;-) have you tested this thoroughly?
www.mssqlserver.com has some decent replication info.

> 4. after which, the production server updates the full text catalog, using
incremental update.

make sure you have a timestamp (datatype) on the table, it makes incremental
updates faster.




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

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

RE: OT SQL Server

[Aidan Whitehall]

> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.

Open Design Table view:
 - clear the Null column on your PK field
 - check Identity and
 - make sure you've specified it as the Primary Key.


-- 
Aidan Whitehall <[EMAIL PROTECTED]>
ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT SQL Server (OK 1 More ?)

[ibtoad]

OK I got it. Now that I have the primary key set with datatype int, the
length is limited to 4. Is this correct and will this limit the table to
 records?

Thanks,
Rich

-Original Message-
From: Craig Bowes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:30 AM
To: CF-Talk
Subject: RE: OT SQL Server


You must set a field to be identity and not null.  You can set its seed to
any number (start autonumbering at 1000 for example.)

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server

I have a simple question.  How do you set the primary key field to
autonumber in SQL server?  I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.

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

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

Re: Body and Subject of my messages not arriving

[Tim Painter]

Larry,
  I have seen this a lot when you set Word as your email editor.   Try
turning that option off in Mail Format options and see if that fixes it. (if
that is the case)

Tim P.


- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:32 AM
Subject: Body and Subject of my messages not arriving


> HELP Please -
>
> I know this sis for another list, however - I am receiving my messages
from JS-Jive, but my subject and body are empty on all of them.  Has anyone
run into this before and is there a way for me to fix it?  I am using
Outlook 2000.  Just started the other day.
>
> Thanks
>
> Larry Juncker
> Senior ColdFusion Developer
> Heartland Communications Group, Inc.
> [EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[mherbene]

As you've realized, SQL is not inherently designed for this problem.  There
may be a workaround but it would be (I think) product-dependent.  What's the
database engine?

-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 10:17 AM
To: CF-Talk
Subject: SQL: Comparing value against a list of values


I have a table with a field that contains a comma delimited list of values,
such as:

10,11,21,100

In doing a  against the table, I want to select records where one
or more of the values in this list of values matches a value in the WHERE
clause of my sql query. For example:

select *
from tbl
where csvList = '%1%'

The problem is that the above select statement will select ANY record that
has '1' in the field no matter what the "true" values in the field are
(i.e., 1 is "LIKE" 10,11,21,100).

How do I make the select query compare '1' against '10', and '1' against
'11' and '1' against '21', and '1' against '100'.

Thank you for help.

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

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

RE: setup HTTPS on local PC

[SRetsky]

Hi Duane:

Where can I get an SSL key for my local PC?  from a company like Verisign?

thanks

Sandy



<[EMAIL PROTECTED]>

To get the https protocal working locally you have to install an ssl key on
your machine

Duane


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

Re: OT SQL Server

[Tim Painter]

If you are using SQL Enterprise Manager, in design mode, click on the
Identity option and set it to Yes.  Optionally, you can set the seed as
well.
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject: OT SQL Server


> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Comparing value against a list of values

[Dylan Bromby]

hmm. wonder why the double post? i didn't submit twiceoh well. ;)

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 8:01 AM
To: CF-Talk
Subject: RE: Comparing value against a list of values


Paul,

You should use the IN operator in your WHERE clause. I'm not clear on your
data structure from your post, but try something like the following (make
sure the list is in parentheses);

SELECT
*
FROM
tbl
WHERE
csvList IN (10,11,21,100)

-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 7:17 AM
To: CF-Talk
Subject: SQL: Comparing value against a list of values


I have a table with a field that contains a comma delimited list of values,
such as:

10,11,21,100

In doing a  against the table, I want to select records where one
or more of the values in this list of values matches a value in the WHERE
clause of my sql query. For example:

select *
from tbl
where csvList = '%1%'

The problem is that the above select statement will select ANY record that
has '1' in the field no matter what the "true" values in the field are
(i.e., 1 is "LIKE" 10,11,21,100).

How do I make the select query compare '1' against '10', and '1' against
'11' and '1' against '21', and '1' against '100'.

Thank you for help.

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

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

RE: Verity & SQL

[Steve Vosloo]

Hi Jason,

Thanks for the help. This is a great solution - which I've already tried
(also from pg 733 :-) ... but to no avail.

Basically, I've inherited a database from an existing site and when I index
the data everything works fine. Then when I add new records and re-index,
they are not included. The query that I use to get the data I want to index
has been tried in SQL query analyzer, and the new records show up - so they
*should* be included in the indexing.

I've tried absolutely everything - but nothing seems to work.

So now I'm trying to combine my standard SQL query with another Verity
query, without having to create a Verity collection from the database query.

Dave Watts has suggested "building a query object using the CF query
functions, and populating the query by looping over the two source
queries" - but as he suggested, this may be too slow.

DOH!






> -Original Message-
> From: Jason Blum [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:52 PM
> To: CF-Talk
> Subject: Re:Verity & SQL
>
>
> Steve!
>
> Finally something I can contribute to this wonderful list!
>
> I am in fact working right now on the code to do just this.
>
> I am assuming you already have a Verity collection with SomeName.
>  Then you need
> to make a kind of on-the-fly collection out of a normal db query
> and call it
> Dbquery
>
> So on the search page, here is your Dbquery:
>
> 
> 
> SELECT Field1, Field2, Field3, Field4
> FROM SomeTable
> 
>
> 
>  COLLECTION="OntheFlyCollection"
> KEY="Field1"
> URL="Field2"
> TYPE="custom"
> TITLE="Field3"
> BODY="Field4"
> QUERY="GetSomeData">
>
> Then on the search results page,
>
>  name = "GetResults"
> collection = "SomeCollection, OntheFlyCollection"
> criteria = "#Form.Criteria#">
>
> And that's it.  Two things to note, you actually have to create a
> collection
> called OntheFlyCollection first, so that you can be refreshing it
> here on the
> search page.
>
> Also, notice that in the  you are telling Verity which
> fields should be
> considered what Verity values, so Field2 is your URL for instance
> - kind of
> limiting, but don't forget you can make two custom tags!
>
> HOpe this helps - got it all from p.733 of Forta and
> http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
>
> -Jason
>
>
> ___Reply Separator
> Subject:Verity & SQL
> Author: [EMAIL PROTECTED]
> Date:   6/13/01 4:00 PM
>
> Is there any way to combine the results of a CFSEARCH and a standard SQL
> search into the same CFOUTPUT ... basically merge two queries?
>
> Thanks
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Re:Verity & SQL

[Michael Lugassy]

Won't work with multiple users seaching on the same time because of the
collection "on the fly"
creation latency - both trying to use OntheFlyCollection which is alright
(for the first user) at second
number 1 but it's not updated for second user (or first user, depending who
run what and where
first...)

but If you can create a collection that will sure to be unique, again -
ontheflyCollection,
it might work, but will involve some major maintance..

again, I personally don't see any point nor success to this.

Thanks,

Michael
- Original Message -
From: "Jason Blum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:52 PM
Subject: Re:Verity & SQL


> Steve!
>
> Finally something I can contribute to this wonderful list!
>
> I am in fact working right now on the code to do just this.
>
> I am assuming you already have a Verity collection with SomeName.  Then
you need
> to make a kind of on-the-fly collection out of a normal db query and call
it
> Dbquery
>
> So on the search page, here is your Dbquery:
>
> 
> 
> SELECT Field1, Field2, Field3, Field4
> FROM SomeTable
> 
>
> 
>  COLLECTION="OntheFlyCollection"
> KEY="Field1"
> URL="Field2"
> TYPE="custom"
> TITLE="Field3"
> BODY="Field4"
> QUERY="GetSomeData">
>
> Then on the search results page,
>
>  name = "GetResults"
> collection = "SomeCollection, OntheFlyCollection"
> criteria = "#Form.Criteria#">
>
> And that's it.  Two things to note, you actually have to create a
collection
> called OntheFlyCollection first, so that you can be refreshing it here on
the
> search page.
>
> Also, notice that in the  you are telling Verity which fields
should be
> considered what Verity values, so Field2 is your URL for instance - kind
of
> limiting, but don't forget you can make two custom tags!
>
> HOpe this helps - got it all from p.733 of Forta and
> http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
>
> -Jason
>
>
> ___Reply Separator
> Subject:Verity & SQL
> Author: [EMAIL PROTECTED]
> Date:   6/13/01 4:00 PM
>
> Is there any way to combine the results of a CFSEARCH and a standard SQL
> search into the same CFOUTPUT ... basically merge two queries?
>
> Thanks
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Verity & SQL

[Michael Lugassy]

Even if there would, It'll be inefficient because in order to use CFSEARCH
you will need
to rebuild the Verity Index to match the last SQL query, but if you don't
plan to change
the original SQL content (i.e - the first query result set) - you absolutly
can do it.

just create a new collection and index the result set -
I think the whole process is called search... ;-)

Thanks,

Michael
- Original Message -
From: "Steve Vosloo" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:00 PM
Subject: Verity & SQL


> Is there any way to combine the results of a CFSEARCH and a standard SQL
> search into the same CFOUTPUT ... basically merge two queries?
>
> Thanks
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.com
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF 4.5 on Win2K SBS & ISA

[Michael Lugassy]

I had a BIG ISSUE with cookies about a week ago.
If the problem occurs in all of your pages (i.e - each page terminates the
cookie)
there must be something wrong with your application.cfm file.

try deleting all rows in it (and I mean each row)!
your problem maybe lie between a custom tag or code block.

My problem was that I used Allaire's CF_INPUTFILTER that cleand the
cookie


Thanks,

Michael
- Original Message -
From: "Kay Smoljak" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:00 PM
Subject: CF 4.5 on Win2K SBS & ISA


> Hi all,
>
> Our internal network was recently rebuilt with Win2k Small Business Server
> 2000. It seems that ISA is trashing cookies, with code that was previously
> working.
>
> I have a page that sets some client vars. In the Application.cfm cookies
are
> set to on and storage to the database, which is set up and actually
working
> fine. The client vars are visible on the page on which they are set, but
> when you move to another page they are undefined. There are no cflocations
> or other cookie crunching munsters... as I said, the code was working
> perfectly before the rebuild.
>
> Does anyone have any clues as to what this may be? A setting somewhere
> within CF or ISA? Our network admin (also the MD, LOL) has no clue what it
> could be, and the book is on order. But I need it running tomorrow to show
a
> client!
>
> Thanks,
> K.
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT SQL Server

[Saidi; Marwan]

SQL does not have autonumber, but you can set the field to Identity, then
set the Identity seed and Identity increment to whatever you wish. (Seed is
your start number, increment, well, that should be obvious.


Rich sat down, thought things over, and said

~~
I have a simple question.  How do you set the primary key field to
autonumber in SQL server?  I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.

Thanks,
Rich
~~


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

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

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

Re: Comparing value against a list of values

[Michael Lugassy]

Not sure I got you right, but look:


select *
from tbl
where 
#csvList# Like '%#searchstring#%' OR
 1=2



The last 1=2 is to "seal" the cfquery's last OR
1=2 will produce no other results..


Thanks,

Michael

- Original Message -
From: "Paul Sinclair" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:17 PM
Subject: SQL: Comparing value against a list of values


> I have a table with a field that contains a comma delimited list of
values,
> such as:
>
> 10,11,21,100
>
> In doing a  against the table, I want to select records where one
> or more of the values in this list of values matches a value in the WHERE
> clause of my sql query. For example:
>
> select *
> from tbl
> where csvList = '%1%'
>
> The problem is that the above select statement will select ANY record that
> has '1' in the field no matter what the "true" values in the field are
> (i.e., 1 is "LIKE" 10,11,21,100).
>
> How do I make the select query compare '1' against '10', and '1' against
> '11' and '1' against '21', and '1' against '100'.
>
> Thank you for help.
>
> Regards,
> Paul Sinclair
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT SQL Server

[Michael Lugassy]

Set the field as identity (in the lower table)
incremental, and seed are also avaialbe for configuration.

Thanks,

Michael
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:36 PM
Subject: OT SQL Server


> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT SQL Server

[Bill Davidson]

It's the identity check box.  Make sure you have allow Nulls deselected.

-Bill
www.brainbox.tv


- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject: OT SQL Server


> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT SQL Server

[net_man]

You set identity seed and identity increment to 1 in the design of the
table.  As well make sure that the Identity box is checked.

Robert Filipovich


- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject: OT SQL Server


> I have a simple question.  How do you set the primary key field to
> autonumber in SQL server?  I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT SQL Server

[Dave Watts]

> I have a simple question. How do you set the primary key field 
> to autonumber in SQL server?  I have always used Access where 
> this is a choice but don't see how to do it with SQL Server 2000.

In SQL Server, it's called an identity column.

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

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

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

Re: OT SQL Server

[Dick Applebaum]

Identity

At 10:36 AM -0400 6/13/01, ibtoad wrote:
>I have a simple question.  How do you set the primary key field to
>autonumber in SQL server?  I have always used Access where this is a choice
>but don't see how to do it with SQL Server 2000.
>
>Thanks,
>Rich

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

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

RE: OT SQL Server

[Michael Bruce]

In design view of Enterprise manager for the table, check on identity and
you see what to do next.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 10:37 AM
To: CF-Talk
Subject: OT SQL Server


I have a simple question.  How do you set the primary key field to
autonumber in SQL server?  I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.

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

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

RE: OT SQL Server

[Andy Ewings]

Select the field to be of type int and also select it to not allow Nulls and
to be a identity field.  You can then select the seed (first value) and the
increment step for every new record.

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 13 June 2001 15:37
To: CF-Talk
Subject: OT SQL Server


I have a simple question.  How do you set the primary key field to
autonumber in SQL server?  I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.

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

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