RE: CFHTTP

[Garza, Jeff]

Are you running behind a Proxy? A Firewall that requires Authentication?
These are the usual suspects... Post the code.

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


-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 12:34 PM
To: CF-Talk
Subject: CFHTTP


I can go to http://www.yahoo.com

When I try to do a  to http://www.yahoo.com I get a Connection
Failure message.

Any clues?

T


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

RE: Preventing SQL injection attacks...?

[Garza, Jeff]

There was a real good white paper from NGSSoftware.  It's called Advanced
SQL Injection and can be found near the bottom of this page.

http://www.nextgenss.com/research.html#papers

Frightening...

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


-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]] 
Sent: Friday, April 12, 2002 8:30 AM
To: CF-Talk
Subject: RE: Preventing SQL injection attacks...?


That's what I thought.

Man, you think you're an expert, and then some 13 year old somewhere makes
you feel like a punk again :)

Is there a good paper on Macromedia.com about this? I read some of the stuff
but nothing seemed really on-point...

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 8:30 AM
To: CF-Talk
Subject: RE: Preventing SQL injection attacks...?


> make sure you are at the latest MDAC and have all service pack applied 
> for SQL. I think that the latest MDAC prevents attacks like this, but 
> I could be wrong.

No, MDAC does nothing to prevent SQL injection attacks, which, after all,
use perfectly valid SQL statements.

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



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

RE: Big Record Set Return

[Garza, Jeff]

What we did to limit the resultset was use an initial search page with
wildcards and return the matching records in a paged format.  This worked
really well and avoided the select scrolling issues that my users hated so
much.  I try to "Just Say No" to dropdowns with more than 100 elements.
Now, if there was a good combobox out there that actually worked like a
combobox, I might rethink that number...

Jeff 

-Original Message-
From: Douglas Brown
To: CF-Talk
Sent: 4/8/02 11:17 PM
Subject: Re: Big Record Set Return

I would say so. I wouldnt even take the time to look through 500 items
in a dropdown
list.


"Success is a journey, not a destination!!"



Doug Brown
- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 11:00 PM
Subject: RE: Big Record Set Return


> You should really build some sort of "previous/next" functionality of
say
> 100 rows at a time - and perhaps a "search" feature also.
>
> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 9 April 2002 3:28 PM
> To: CF-Talk
> Subject: Re: Big Record Set Return
>
>
> > I have a query that returns 7,300 records (just two columns, and
> eventually
> > but the output is slow.  The results are written to a drop down
menu.  It
>
> rendering clientside will be a bear not to mention who's going to pull
> down a select of 7k rows? that will take patience of biblical
proportions.
>
> i think you need a re-think.
>
>
> 

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

RE: cfdirectory, etc., with CF running under own user account

[Garza, Jeff]

Yes.  You have to explicitly define permissions for the CF account to have
access to the files, unless you go with the default Everyone - Full
Control... (Bad.. Very bad...).  Also, CF has to have access to the
c:\cfusion (or whatever your coldfusion install directory is).

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


-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 08, 2002 12:00 PM
To: CF-Talk
Subject: cfdirectory, etc., with CF running under own user account


If we set up CF to run not as a system account but under its own user
account do we then have to give that user account permissions to access any
folders on which we want to use cfdirectory, cffile, etc.?

Thanks!

George
[EMAIL PROTECTED]

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

RE: reverse engineering database structure

[Garza, Jeff]

I think I remember being able to do this with Visio 2000 Enterprise version.
You can basically point it at a datasource and it will determine the
database structure and diagram it out...

I'm not sure if the newer versions also have this capability.

HTH,

Jeff Garza


-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 4:32 PM
To: CF-Talk
Subject: reverse engineering database structure


We're building a site for a company that uses a very complex inventory 
and accounting system that's based on SQL Server. We'd like to use only 
a few fields from the database maybe a dozen or so to display some items 
on the web. There are a lot of tables, a 100 or so. There aren't very 
many relationships; a table might have four foreign keys but only one 
realtionship. Lots of SPs and Views. There is no diagram.

How should I go about understanding this structure? Remember, I only 
need a few fields.

Reading the MCSE book, it looked as if maybe a trace would be the way to go.

As always, all suggestions are appreciated.

TIA,

Doug Jordon


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

RE: Win 2k patch question

[Garza, Jeff]

Best bet is to run hfnetchk...

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
tools/hfnetchk.asp
(Watch out for the wrap...)

This tool will go out and compare all the security patches available with
the ones installed on your machine.  You can then use qchain to do a one
time install of all the hotfixes you are missing (traditionally, each hotfix
typically required a reboot... With qchain, you can install them all and
reboot once).  I've found that for server security, Windows Update doesn't
cut it.

My .02

Jeff Garza


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 29, 2002 8:20 AM
To: CF-Talk
Subject: Re: Win 2k patch question


Click on Start, then go to the upper part of the menu and click on Windows
Update...

That will take you to Microsoft ... then click on the left menu item
"Product Updates" it will do a scan of your system and tell you what you
need!

Good Luck

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


- Original Message -
From: "Phillip Broussard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 29, 2002 9:19 AM
Subject: OT: Win 2k patch question


> Is there an easy way to tell what patches have been applied to a Win 
> 2k
server? I want to make sure I have everything I need on it but know of the
best way to check.
>
> TIA
>
>
>
> --
> Phillip Broussard
> Tracker Marine Group
> 417-873-5957
>
> --
> 

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

RE: SQL Server on XP Pro

[Garza, Jeff]

You'll need SQL Server Developer or MSDE.  The full versions of SQL server
will not install on XP Pro.

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


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 9:44 AM
To: CF-Talk
Subject: SOT: SQL Server on XP Pro


Hi All,

Has anyone here successfully set up SQLServer 2K on WinXP Pro yet? If so
what SP? version?

Thanks,
Duane


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

RE: Access Alter Table weirdness AHHH!

[Garza, Jeff]

Matt,

Drop the parentheses... 


ALTER TABLE cm_users ADD UserName text(10) NULL;


This query works in Access 2000.

HTH,

Jeff Garza


-Original Message-
From: Matt Robertson
To: CF-Talk
Sent: 3/23/02 7:56 PM
Subject: Access Alter Table weirdness AHHH!

I can't get the supposedly dirt-simple query below to work.  Can anyone
see anything wrong with my SQL?  No matter what I do I get this error:

ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE
statement.

The field adds fine in other platforms (different SQL of course); adds
fine if used in a CREATE TABLE where all other fields in the table are
defined at once, but won't work no matter what I alter below.  


ALTER TABLE cm_users (
ADD UserName text(10) NULL
);


Any ideas would be greatly appreciated.

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com



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

RE: CFHTTP POST - authentication issue - Resolved - well, not qui te

[Garza, Jeff]

Have you tried creating a dummy form and posting it to their site using
Netscape 4.x? This will force the basic authentication issue and might
return some additional information as to the failure.

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


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 9:46 AM
To: CF-Talk
Subject: CFHTTP POST - authentication issue - Resolved - well, not quite


OK, so they tell me they have enabled Basic Authentication, and I can hit
the script manually by entering username/password (through a
browser)...but when my CFHTTP hits it, I get a cfcatch message of "401
Unauthorized".

Of course I can't see what's happening on the receiving sideany ideas on
what to ask them to check?

Again, here's my tag:
https://theirserver.com/theirscript.asp"; METHOD="post"
THROWONERROR="Yes" TIMEOUT="30" COLUMNS="#get.columnlist#" PORT="443"
USERNAME="username" PASSWORD="password">

Yikes!
TIA!
D

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


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 11:34 AM
To: [EMAIL PROTECTED]
Subject: RE: CFHTTP POST - authentication issue - Resolved


You guys and this list are THE BEST! I learn so much more here than from
books!

Thanks to your ammunition, I just got this email from my client: "We are in
the process of setting our box up for Basic Authentication.  I will let you
know when that's ready."

Muchas gracias!
D


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


-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:55 AM
To: CF-Talk
Subject: RE: CFHTTP POST - authentication issue


It's time to do some explaining that basic authentication with SSL is just
as secure (probably more) as Microsoft's proprietary challenge/response
(NTLM) scheme, and that you are just as authenticated while using the
standards-based approach.

Kevin

>>> [EMAIL PROTECTED] 03/19/02 08:47AM >>>
That's the issuethey refuse to disable Windows authentication...the
connection worked perfectly when they didthe quote from my client:

"Windows NT Challenge/Response--in simplistic terms is the user id/password
that must be authenticated.  We cannot turn this off, as that is what
controls your authentication (entering your user id/password) to get to the
machine..This authentication must be in place, and your application must
be able to find a way to make it work"


Here's the CFHTTP statement I'm using:
https://theirserver.com/theirscript.asp"; METHOD="post"
THROWONERROR="Yes" TIMEOUT="30" COLUMNS="#get.columnlist#" PORT="443"
USERNAME="username" PASSWORD="password">

Ideas??

D


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


-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:38 AM
To: CF-Talk
Subject: RE: CFHTTP POST - authentication issue


HTTPS is no problem for CFHTTP.  Just make sure to include the correct port
number (443).  As for the authentication, make sure that they are only using
Basic Authentication.  ColdFusion cannot authenticate using Digest or
Windows authentication.  Perhaps you could show us your CFHTTP statement?

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



-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 9:00 AM
To: CF-Talk
Subject: CFHTTP POST - authentication issue


I am trying to post a form to a client's server (WIN2K,IIS) using CFHTTP.
The process works great - until they enable the login/password on their
server.

Is there any other method to do this transfer automatically utilizing CF? or
JS? (Must use SSL and authenticate via login/password to their server.)

TIA!
D


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






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

RE: String Magic: Extract initial character of words in a string

[Garza, Jeff]

Treat the string as a list with spaces as the delimiter...






#charlist#

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


-Original Message-
From: Edward McDermott [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 9:22 AM
To: CF-Talk
Subject: String Magic: Extract initial character of words in a string


I want to be able to take a string, for example a journal article title, and
parse out just the initial characters of each word.  For example: "This is a
Cold Fusion Article" becomes "TIACFA".  Thanks in advance.

Ed

Edward J. McDermott
Systems Librarian
Robert H. Goddard Library
Clark University
950 Main Street
Worcester, MA 01610
(508) 793-7651
(508) 793-8871 [FAX]
[EMAIL PROTECTED]


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

RE: CFHTTP POST - authentication issue

[Garza, Jeff]

Won't work...  They can continue to use Windows Authentication, they just
have to also enable basic authentication (IIS gives you the option to use
both at the same time).  The entire session is encrypted by SSL so there is
no disadvantage to using basic authentication as well If they absolutely
will not enable basic auth, you'll have to look into using the
MSXML.HTTPRequest object that is part of Microsoft's XML parser (I think
you'll need the 3.0 version...)


objXMLReq = CreateObject("COM", "MSXML2.ServerXMLHTTP.4.0");
objXMLReq.open("GET","http://www.google.com",false); 
objXMLReq.send();
strResponse = objXMLReq.responseText;


While this snippet doesn't include the username/password or HTTPS
attributes, it will handle both and can authenticate using Windows Auth.
There are some really nasty hoops to jump through to get it going, but it
will work... I'll dig around and see if I can find my scripts for this...

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



-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 19, 2002 9:47 AM
To: CF-Talk
Subject: RE: CFHTTP POST - authentication issue


That's the issuethey refuse to disable Windows authentication...the
connection worked perfectly when they didthe quote from my client:

"Windows NT Challenge/Response--in simplistic terms is the user id/password
that must be authenticated.  We cannot turn this off, as that is what
controls your authentication (entering your user id/password) to get to the
machine..This authentication must be in place, and your application must
be able to find a way to make it work"


Here's the CFHTTP statement I'm using:
https://theirserver.com/theirscript.asp"; METHOD="post"
THROWONERROR="Yes" TIMEOUT="30" COLUMNS="#get.columnlist#" PORT="443"
USERNAME="username" PASSWORD="password">

Ideas??

D


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


-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:38 AM
To: CF-Talk
Subject: RE: CFHTTP POST - authentication issue


HTTPS is no problem for CFHTTP.  Just make sure to include the correct port
number (443).  As for the authentication, make sure that they are only using
Basic Authentication.  ColdFusion cannot authenticate using Digest or
Windows authentication.  Perhaps you could show us your CFHTTP statement?

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



-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 9:00 AM
To: CF-Talk
Subject: CFHTTP POST - authentication issue


I am trying to post a form to a client's server (WIN2K,IIS) using CFHTTP.
The process works great - until they enable the login/password on their
server.

Is there any other method to do this transfer automatically utilizing CF? or
JS? (Must use SSL and authenticate via login/password to their server.)

TIA!
D


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




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

RE: CFHTTP POST - authentication issue

[Garza, Jeff]

HTTPS is no problem for CFHTTP.  Just make sure to include the correct port
number (443).  As for the authentication, make sure that they are only using
Basic Authentication.  ColdFusion cannot authenticate using Digest or
Windows authentication.  Perhaps you could show us your CFHTTP statement?

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



-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 19, 2002 9:00 AM
To: CF-Talk
Subject: CFHTTP POST - authentication issue


I am trying to post a form to a client's server (WIN2K,IIS) using CFHTTP.
The process works great - until they enable the login/password on their
server.

Is there any other method to do this transfer automatically utilizing CF? or
JS? (Must use SSL and authenticate via login/password to their server.)

TIA!
D


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


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

RE: textarea and cffile

[Garza, Jeff]

SiteObjects' SOEditor2.x will also do the job quite nicely.  They have a
freeware version as well.

We use it extensively for our intranet CMS.

Cheers,

Jeff Garza

-Original Message-
From: Gilbert Midonnet
To: CF-Talk
Sent: 3/15/02 10:12 PM
Subject: textarea and cffile

I would like to be able to have users in an intranet submit text for
others
to see via  and then use to create a
file.

The problem comes when users want to cut-and-paste from articles or from
word docs (which, I'm told, they do). The resulting file doesn't have
any of
the paragraph breaks.

I use wrap="physical" in the  and
#ParagraphFormat(Form.content)#

ParagraphFormat works well if people go back into the text and add
paragraph
breaks. However this is not acceptable to the users.

Is there anything else to use besides HTMLCodeFormat, HTMLEditFormat and
ParagraphFormat?

TIA

P.S. Now, of course, I'm greedy. In addition to keeping paragraph breaks
I
would love it if the formatting  could be kept too. hehehehe






---
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify
the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient.




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

RE: session variables and multiple servers

[Garza, Jeff]

Since Session variables reside in memory on each individual server, they
can't be shared across a cluster.  What you'll need to do is use client
variables instead and store them in a shared datasource.  This way all the
servers have access to the same information.  On a side note, I can't
remember if client variables can store complex datatypes like arrays or
structures or whether you will have to convert these to WDDX first...
Perhaps someone else on the list could elaborate on this!  If you are
storing simple data types then there are no problems.

HTH,

Jeff Garza

-Original Message-
From: S R
To: CF-Talk
Sent: 3/14/02 6:28 PM
Subject: session variables and multiple servers

We just changed our website from one being on one server to being on 3 
redundant web servers. The problem is, the web farm switches from server
to 
server every 15 minutes to whichever server has the least traffic, which

causes me and any other user to have to re-login to password protected
areas 
on the site every 15 minutes.

How can I make session variables span across all three servers? Or
should I 
look into other solutions?

Thank

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

RE: CFQUERYPARAM and dates

[Garza, Jeff]

Try using cfsqltype="CF_SQL_TIMESTAMP" with a value of 
CreateODBCDate(now()).  This should work properly.  Doesn't make much sense
does it? 

HTH,

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



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 14, 2002 3:14 PM
To: CF-Talk
Subject: CFQUERYPARAM and dates


Hey All,

I'm using CFQUERYPARAM to try and insert a date into SQL Server 2K and I'm
getting this error:

ODBC Error Code = S1C00 (Driver not capable)


[Microsoft][ODBC SQL Server Driver]Optional feature not implemented



The code looks like this:

 (I've also tried
#CreateODBCDate(Now())# for
value)

Any thoughts?



BTW CF 5 Enterprise on Win2K Prof.



TIA


Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com


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

NNTP interaction with CF

[Garza, Jeff]

Has anyone developed an interface to mirror an NNTP server (specifically the
Microsoft version) using ColdFusion.  It doesn't look like it would be very
hard based on the format of the messages, but I don't particularly want to
reinvent the wheel here.

Any help would be appreciated.

Thanks,

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


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF & IIS Virtual Directories

[Garza, Jeff]

What error message do you get when trying to view the .cfm files?

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



-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 12, 2002 10:58 AM
To: CF-Talk
Subject: CF & IIS Virtual Directories


I created a virtual directory that connects to share on another machine.
When I try to view some files in the virtual directory using a browser it
won't display cf files, it 
only shows html files.  
 
Any ideas what might be the cause?
 
Thanks,
Dave
 
 
 


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

RE: Intranet apps

[Garza, Jeff]

I've never gotten CFHTTP to work with our proxy.  I finally got the
sysadmins to put a rule in to allow the webserver passage without the proxy
(actually required a hole in the firewall for request traffic from the
server).  I think that the issue is that CFHTTP doesn't authenticate against
the proxy.  Username and Password are, I believe, for basic authentication
against a website, not the proxy.  If your proxy doesn't require
authentication then it might work.  If anyone has other insights into this
I'd love to hear them as well!

The other option you might want to look into if you are running on a Windows
platform, is the XML.HTTPRequest object.  It's part of the Microsoft XML
package in version 3.0 and greater.  It has better methods for navigating
proxies and firewalls and functions similarly to CFHTTP.  Although it won't
resolve URLs in the page.  You'll have to write a regex to add in the FQDN
to each relative link.  There is significant setup to get it working with
proxy servers and HTTPS connections, but you might have better luck with it?

Good Luck!

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



-Original Message-
From: Bruce Holm [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 08, 2002 10:02 AM
To: CF-Talk
Subject: Re: Intranet apps


I agree with Jeffry's observation.  We plan to make it relevant to the
user's location.
It will be small and non-intrusive, and a motivator for employees to make
the Intranet their browser Home.  Company stock quote is also planned for
displaying the company stock price thru-out the day.

I still can't get CFHTTP using proxyserver to get a page outside our
firewall.  Anyone have experience getting that situation to work?  I need
help.

Bruce

- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 08, 2002 8:50 AM
Subject: RE: Intranet apps


> At 09:49 AM 03/08/2002 -0600, you wrote:
> >Not to ruin the party or be overly nosey, but please don't put local
weather
> >information on your corporate intranet, that's just plain wrong in so
many
> >ways.
>
>   I don't understand what is so wrong about it, however your description
> below is obviously a flawed implementation.  I see no reason why you can't
> get local weather based on the user's sign in.  ( New York people see New
> York info, Chicago people see Chicago info, etc.. )
>
>
> >  When I worked for a global company based in Minneapolis, I would login
> >to their corporate intranet and 70% of the page was the local,
Minneapolis
> >weather forecast. I'm sure the intentions were good, but everyone from
New
> >York, Chicago, LA, UK, etc would get a nice big browser full of "26 and
> >heavy snow" each time they needed information about the actual company.
It's
> >probably good to let people stick to their own sources for weather
> >information (morning news, newspaper, weather.com, etc), and keep the
> >intranet specific to the actual company.
> >
> >Adam.
>
>
>
>
> --
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> Need a Web Developer?  Contact me!
> AIM: Reboog711  | Fax / Phone: 860-223-7946
> --
> My Books: http://www.instantcoldfusion.com
> My Band: http://www.farcryfly.com
>
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: auth_user

[Garza, Jeff]

What we typically do is define an admin list...



Then check if AUTH_USER is in the list using list find.


Show admin stuff, links to protected documents...

No admin stuff


CF has no native interface to the NT Groups that I know of at the
application level without using Advanced Security.  

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 07, 2002 4:12 PM
To: CF-Talk
Subject: auth_user


i want only users that are apart of an Admin group that i created to be a
ble to access a template i built.  i know that i can use AUTH_USER and sa
y if u are this list of people...you can access the template.  
but is there a way to say if you are apart of this GROUP u can access thi
s template?  
i hope i am being clear.  right not i declare a variable and set it to AU
TH_USER.  but can i set this variable equal to the Admin group somehow?
thanks for your help,
bec.


* 
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information. If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: whats wrong with DateFormat()

[Garza, Jeff]

Dateformat expects a full date.  If you try #dateformat("5", 'dd')#, 
which
is essentially what you are telling dateformat to work with, you'll get 
"4"
returned... not sure why... I would have it throw an error if it's not 
a
valid date.  Why not just use #dateformat(now(), 'dd')# to get the 
desired
result "5"?

Cheers,

Jeff Garza

-Original Message-
From: Phillip Broussard
To: CF-Talk
Sent: 3/5/02 9:33 AM
Subject: RE: whats wrong with DateFormat()

I can understand why the number 5 may not work but when I use
DateFormat(day(now()), 'dd') I still get a date of yesterday. This just
doesn't seem right.

Phillip

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 10:25 AM
> To: CF-Talk
> Subject: Re: whats wrong with DateFormat()
> 
> The function day() returns a simple number between 1 and 31.  It
> 
> expects a date/time object.  The number "5" is a date/time object,
>  but
> 
> it doesn't represent the day "4".
> 
> The function dateformat expects a date/time object, a string that
looks
> 
> 
> like a date, or a numeric representation of a date object.  I guess t
> he
> 
> number "5" has a day of "4".
> 
> 
> 
> - Original Message -
> From: Phillip Broussard <[EMAIL PROTECTED]>
> Date: Tuesday, March 5, 2002 9:15 am
> Subject: whats wrong with DateFormat()
> 
> > Ok I put DateFormat(day(now()), 'dd') on a page and instead of
> 
> > returning05 it gave me 04.
> 
> > If I put day(now()) on a page I get 5.
> > If I put day(5) on a page I get 4.
> > If I put DateFormat(now(), 'mmdd') on a page I get 20020305
> 
> >
> 
> > Why?
> 
> >
> 
> > TAI
> >
> 
> > Phillip Broussard
> > Tracker Marine Group
> > 417-873-5957
> >
> 
> >
> 
> > ___
> _
> __
> > Dedicated Windows 2000 Server
> >  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
> >  Instant Activation . $99/Month . Free Setup
> >  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
> 
> > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion
> com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
> ar=lists
> >
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: dynamic graphs.

[Garza, Jeff]

Yup... Using the CFGRAPH tag.  You can do pie, bar and line graphs and
present them in .jpg, .gif and flash formats.

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



-Original Message-
From: Ki Hong [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 04, 2002 4:33 PM
To: CF-Talk
Subject: dynamic graphs.


Does coldfusion 5 have dynamic graphics built in or do you have to use a 
3rd party addon to achieve this?  Haven't worked with coldfusion 5 since it 
came out and vaguely remember something about this.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF Certification for 5.0 rolling over to next version?

[Garza, Jeff]

I'm thinking of taking the plunge and getting certified, but I'm curious if
the certification for CF5.0 will carry over to the next version.  Or will a
completely separate test be needed.  I'd hate to waste the money now and
have to re-certify with the next version Anyone from Macromedia want to
chime in on this?

Jeff Garza
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: IIS 5 FTP Security Issue

[Garza, Jeff]

This isn't possible with the version of IIS that comes with Win2K
Professional.  You have to be on Win2K Server for that to be enabled...  I
think you may well be better off with Lee's suggestion of Serv-U...

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



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 04, 2002 1:18 PM
To: CF-Talk
Subject: OT: IIS 5 FTP Security Issue


Hi All,

Sorry for the OT post, but my head is getting sore from banging it against
my wall ;-)

I'm trying to restrict FTP access in IIS to 1 IP address.  Seems easy right
;-)

Well the whole dang directory security tab is grayed out (disabled) in IIS
which makes it quite
difficult to add an IP.

Thanks very very very much for any help anyone can give

BTW it's Win 2K Professional

Cheers

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

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

RE: value list of a timeformat

[Garza, Jeff]

Have you considered doing the time formatting on the database rather than in
CF?  What DB are you using?  This might be the easiest solution.  In SQL
Server try 

SELECT CONVERT(varchar(2), DATEPART(hh, report_time)) + ':' + 
CONVERT(varchar(2), DATEPART (n, report_time)) AS thetime

This should return the hour and minutes in 24 hour format...

This is probably not the most optimal SQL statement... But it will return
the properly formatted text.  Also note that it's returned as a varchar and
not a date/time...

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



-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 04, 2002 10:45 AM
To: CF-Talk
Subject: Re: value list of a timeformat


Recieve a JIT error this way.

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

(
Invalid expression format. The usual cause is an error in the expression
structure.

  



On Mon, 04 March 2002, "Douglas Brown" wrote:

> 
> Looks like your missing a closing  )
> 
> 
> 
> 
> 
> "Success is a journey, not a destination!!"
> 
> 
> 
> Doug Brown
> - Original Message - 
> From: "Joshua Tipton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 04, 2002 9:07 AM
> Subject: value list of a timeformat
> 
> 
> > What is wrong with this?
> > 
> > 
> >  "HH:MM"),',')#> 
> > 
> > 
> 

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

RE: a little about the future

[Garza, Jeff]

NET is the MS framework that exchanges information using SOAP, UDDI, and
WSDL.  It's built into the ASP.NET system as well as all the new MS
languages (C#, VisualBasic.NET, C++, etc...). It's completely XML based and
as such, can interface with any system that supports the above standards
regardless of the language used to create the system.  

I'm assuming that the next version of CF will be able to interact with .NET
web services.

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



-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 04, 2002 10:17 AM
To: CF-Talk
Subject: RE: a little about the future


I was actually wanting to know more about .NET and CF working together.

At 04:57 PM 3/4/2002 +, you wrote:
>http://www.microsoft.com/net/
>
>-Original Message-
>From: Nick McClure [mailto:[EMAIL PROTECTED]]
>Sent: 04 March 2002 16:57
>To: CF-Talk
>Subject: RE: a little about the future
>
>
>This .NET stuff you speak of, tell me more.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: value list of a timeformat

[Garza, Jeff]

There are a few questions on what columns you are working with...

I'm assuming that timeon.acd_total is the column, is this a computed column
from SQL?

What is report_time?

It appears that you have two separate columns that you are trying to put in
here...  

Try something like 



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



-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 04, 2002 10:08 AM
To: CF-Talk
Subject: value list of a timeformat


What is wrong with this?


 


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

RE: Verity Issue - Returning Incorrect Results?

[Garza, Jeff]

That version of the spider is limited to 10 sites, but they can be ANY site.
Additional "site packs" cost extra.   Did they quote you for the Silver
version of the K2 Enterprise system?  If so definitely check into the Gold,
shouldn't be too much more than the silver and you get a lot more (the
Security module which is way cool and the content categorization engine that
is cool as well).

Good Luck,

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



-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 1:24 PM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?


I called verity, 10K for the full... but as they said: "In the current state
of the market that price is... negotiable"

You can spider multiple sites on the same box though

Sean


-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:06 PM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?


Those documents are pretty cool. I had no idea there was an actual 
spider! I
don't need to use it now, but most of the sites I build are in Fusebox 
and I
would want to spider those sites instead of index them. 

The spider collection is limited to links on the localhost. Has anyone
worked with the more robust version that handles a full domain? If so, 
how
much does it cost?

Mike 

-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 1:15 PM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?


Do a search on the houseoffusion.com mail list there are a number of
examples.  The docs would reference it as the vspider.

Heres Jeffs examples:
http://www.spectrumastro.com/veritydemo/index.cfm

Ahh found it another good example:
http://www.daemon.com.au/navitron/display.cfm?objectid=DD870544-07B0-4

AF0-8B
67792653EDB5D4


Sean

-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:45 AM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?


At the risk of sounding lame, is there any documentation on the Verity
search engine that comes with CF?

My applications are full of includes, modules, etc. and I chose NOT to 
use
verity because it would always return only a partial page. 

Can I use it as a spider, I mean, follow links on the site and return
results based on the actual layout?

Mike



-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:19 AM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?


look into the verity spider

-Original Message-
From: phil e hebenstreit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:14 AM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?


Hi Mark,

I've determined this now.  Its returning the correct results, because 
some
of the articles are uploaded files (html) that were created in Word and
contain a bunch of excess html code at the type (one being style sheets 



that
contains the word "hybrid", which what the search word was).  So now 
I'm
trying to find out the best way to strip out all this "extra" and just 
index
the actual text of the uploaded file.

Thanks again,
Phil

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:05 AM
To: CF-Talk
Subject: Re: Verity Issue - Returning Incorrect Results?


On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote:
>Running CF 5.0 and when we run our search against the
 collection, it
>returns
>what from the surface appear to be inconsistent results.
>
>I will search on "hybrid" and first 7 articles will be "foreign
>text" and
>when I search the body that word does not appear.
>Next article will be in English and does contain the keyword in
 the
>body.
>But then next article in English does not contain the keyword in
 the
>body.
>
>Wondering if anyone could point me to where the mistake might
 be
>taking
>place.  During the index/update of the collection?  During the
>actual search
>call?
>
>Thanks in advance
>Phil E Hebenstreit
>
>
_

>_
>Get Your Own Dedicated Windows 2000 Server
>PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
>Instant Activation * $99/Month * Free Setup
>http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>Archives:
 http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe:
 http://www.houseoffusion.com/index.cfm?sidebar=lists
>

Hi Phil,
Is this a document search or a db search?  Did you set a specific

language in the CFIndex tag?

Mark
--
Mark Leder, [EMAIL PROTECTED] on 03/01/2002








__
Get Your Own Dedicated Windows 2000 Server
  PII

RE: MS-Access: nulls in numerics?

[Garza, Jeff]

Post your code.

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



-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 22, 2002 3:53 PM
To: CF-Talk
Subject: MS-Access: nulls in numerics?


I believe I am getting 'syntax error in SQL statement' type of error
messages because some of the rows in a numeric column in an Access database
have zero and others are blank, leading me to believe they are NULL.

Is there a way to test for a null value in a numeric field?

Thanks In Advance,

Ed Gordon

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE vs database for logging

[Garza, Jeff]

Kay, 

If you are using CF5 try using the new CFLOG tag.  automatically writes 
to a
log file for you.  Much faster than CFFILE as I beleive it's handled by 
a
servlet running under the built in JRUN server.  Otherwise, a db is 
your
best choice.  A simple insert query shoudn't take very long.  You'll
probably still want to performance test it yourself and see what works 
best
in your situation.

HTH,

Jeff Garza

-Original Message-
From: Kay Smoljak
To: CF-Talk
Sent: 2/21/02 8:15 PM
Subject: CFFILE vs database for logging

I'm working on a site where a number of protected pages will be served
up using CFCONTENT from outside the web root. Obviously these pages are
not going to show up in normal web site statistics programs.

I'm thinking of writing my own logs for these files. I figure I can
either write to the database every time a page is requested, or I could
append a text file every time. Which would be better from a performance
point of view? I think that the database would be faster than CFFILE,
but does CFFILE wait until the file operation is finished? If not
perhaps that would be quicker. Or is there any other way to do it? I've
thought about storing the data in an application variable, then dumping
it to the database (or a text file) at a specified interval. 

Any thoughts?
Kay.
__ 
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd 

http://developer.perthweb.com.au - Tools for Developers
cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcrypt


 
 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion code to decode binary base64 attachment

[Garza, Jeff]

I'm assuming that you are getting this information via CFHTTP? Yes?

If so, you can use a couple of attributes in the CFHTTP tag to write the
file automatically to your HD...

http://usps.gov/yourpdf.pdf";
   method="GET"
   port="80"
   resolveurl="false"
   path="D:\intepub\wwwroot\"
   file="newpdf.pdf">

This will properly write the pdf locally.  No translation needed.  I got
goofed when you said it's a binary base64 attachment?  If it's just a binary
document, this should work.  Let me know if this is not the case.  If it is
truly a base64 string from the USPS, then use the toBinary and CFFILE to
write it.  

HTH,

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



-Original Message-
From: Steven Salter [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 2:41 PM
To: CF-Talk
Subject: RE: Cold Fusion code to decode binary base64 attachment


>Try the toBase64(binaryvar) function built in to CF...  You should then be
>able to output the XML file as a string.
>
>Jeff Garza

Thanks Jeff,

hmmm, that definitely changed the binary content into something else. I
tried to save it as a pdf with cffile but it still looks like a string of
characters. :)

I suppose I should be more specific. My steps:

1) receive binary from usps as a result (this works)
2) extract binary string from result, let's call the variable 'binvar'
3) 
4) display #myvar# or write it to a file as a PDF.

am I on the right track? Sorry I am being so dense this afternoon, getting
late for me.

Thanks,
Steve




__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion code to decode binary base64 attachment

[Garza, Jeff]

Try the toBase64(binaryvar) function built in to CF...  You should then be
able to output the XML file as a string.

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



-Original Message-
From: Steven Salter [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 2:12 PM
To: CF-Talk
Subject: Cold Fusion code to decode binary base64 attachment


Greetings,

I am running CF4.5 on Redhat 6.x. I have subscribed to the USPS Electronic
Return service. When I shoot them an xml string I get back a response that
is supposed to be the return mailing label in pdf format. The response comes
back as binary that I will need to decode as base64 in order to view the
label.

Anyone have code or a custom tag that will decode the base64 binary?
Preferably, I want to just display it on the web page (cfcontent?), and not
write it to disk but anything that works would be wonderful.

Thanks,
Steve


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Using Replace() to replace "hard returns" on

[Garza, Jeff]

You'd have to grab the file using  first then you could do a replace
on the variable that you define in your cffile call.




HTH,

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



-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 19, 2002 9:37 AM
To: CF-Talk
Subject: Using Replace() to replace "hard returns" on 


Hello there, 

I have a text file that I want to include in a page, but I would like to
replace() all the hard returns in it first.  Can I do all in one line? for
example:

 #replace(http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple domains going to one webspace

[Garza, Jeff]

<% 'ASP Version ...
sname = Request.ServerVariables("SERVER_NAME")
sname = ucase(sname)
if InStr(sname,"DOMAIN1") <> 0 then
response.redirect "subdirectory to go to"
elseif InStr(sname,"DOMAIN2") <> 0 then
response.redirect "2nd subdirectory to go to"
elseif
end if %>




  

  

  ...

  


Hth,

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



-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 12:48 PM
To: CF-Talk
Subject: RE: Multiple domains going to one webspace


At 01:23 PM 2/18/02 -0600, Rick Eidson wrote:
>Tell IIS to forward all request to the main URL. Its in the same place
>you
>specify Home Directory.

I purchasing space from a host, so I don't think I have that option.  On 
their page, they suggest the following ASP code to do it:
"<%
sname = Request.ServerVariables("SERVER_NAME")
sname = ucase(sname)
if InStr(sname,"DOMAIN1") <> 0 then
response.redirect "subdirectory to go to"
elseif InStr(sname,"DOMAIN2") <> 0 then
response.redirect "2nd subdirectory to go to"
elseif
end if"

But I was wondering if it is possible to do in CF as well.

T

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

RE: Does this lock look right?

[Garza, Jeff]

Now your best bet might just be to lock it on the database... 

Wrap it up in a stored proc and manually set the transaction isolation
level... This is from the SQL Server BOL ...

SET TRANSACTION ISOLATION LEVEL 
{ READ COMMITTED 
| READ UNCOMMITTED 
| REPEATABLE READ 
| SERIALIZABLE 
}

I believe that serializable is the most stringent of the isloation blocks
and should restrict updates or inserts while the transaction is occuring.

Good luck,

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



-Original Message-
From: Phillip Broussard [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 10:09 AM
To: CF-Talk
Subject: RE: Does this lock look right?


I knew I forgot something. 

What is the best way to lock when it is load balanced on two servers?


> -Original Message-
> From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 18, 2002 10:53 AM
> To: CF-Talk
> Subject: RE: Does this lock look right?
> 
> I think you have to give it a name.  Otherwise how will CF know which
lock
> not to disturb?
> 
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
> 
> 
> 
> -Original Message-
> From: Phillip Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 18, 2002 9:53 AM
> To: CF-Talk
> Subject: Does this lock look right?
> 
> 
> 
> 
> 
>   delete from builder where buildtime < '#cleardate#'
> 
> 
> 
> 
> I just want to make sure nobody triggers this once it has started.
> 
> Thanks
> 
> Phillip Broussard
> Tracker Marine Group
> 417-873-5957
> 
> 
> 
> 

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

RE: Does this lock look right?

[Garza, Jeff]

I think you have to give it a name.  Otherwise how will CF know which lock
not to disturb?

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



-Original Message-
From: Phillip Broussard [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 9:53 AM
To: CF-Talk
Subject: Does this lock look right?





delete from builder where buildtime < '#cleardate#'




I just want to make sure nobody triggers this once it has started. 

Thanks

Phillip Broussard
Tracker Marine Group
417-873-5957



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

RE: Verity 97 (CF4.5) vs Verity K2 (CF 5)

[Garza, Jeff]

Significant inprovements.  Using K2 offloads the processing out of
ColdFusion...  It's faster (usually at leat 2x faster sometimes much more
depending on the size of the collection) at least in our tests (Win2k/NT)

When using K2 what I've found is that when the collection is refreshed or
reindexed it's best to restart the K2 service.  You can use a batch file
called with cfexecute to do this (either use the k2server.exe and
remove/replace  or do a net stop/start.. Either will work.) Otherwise, you
are ok to use the CF tools to manage your collections.

Good Luck,

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



-Original Message-
From: chris.alvarado [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 8:55 AM
To: CF-Talk
Subject: Verity 97 (CF4.5) vs Verity K2 (CF 5)


good morning all,

We have been having issues with the speed of our various verity 
collections, both searching against and re-indexing.

I was wondering if anyone has seen any noticeable improvements with 
moving to CF 5 and the K2 engine?

ALSO,

when reindexing (if files are added / deleted) we are doing the 
following:


 

is this the most efficient way to accomplish this?

Thanks for any and all help,


-chris.alvarado
[application developer]
4|Guys Interactive, Inc.

http://www.4guys.com


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

RE: delete last in the list

[Garza, Jeff]

TRY:


HTH,

Jeff Garza

-Original Message-
From: Claudia Hoag
To: CF-Talk
Sent: 2/17/02 3:02 AM
Subject: delete last in the list

What would be the best way to delete the last item in a list?

Thanks


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Strange Query of Query Behavior

[Garza, Jeff]

It would appear that you have found a bug.  I've reproduced your error 
as
well.  When computing a sum on a column it is missing the where clause.

I'd report it to macromedia and see what they have to say...

Now, to solve your problem... What database are you using?  Can you run 
this
as a stored proceedure?

Jeff Garza

-Original Message-
From: Daniel Quinones
To: CF-Talk
Sent: 2/14/02 5:24 PM
Subject: Strange Query of Query Behavior

Hello,

I am doing a query that extracts all sales info for an employee in a
particular time frame.

Then I am doing 2 querys of that query as seen:

SELECT SalesAmount AS Sales1Sum FROM 
SalesQuery Where BonusDeal=
1
SELECT SalesAmount AS Sales2Sum FROM 
SalesQuery Where BonusDeal=
0

This is working correctly, showing 2 different (correct) values for the
amounts.

Sales1Sum: 10,000
Sales2Sum: 15,000

But, when I want to use the SUM function in the SQL it shows totals for
both
as the same total.


SELECT SUM(SalesAmount) AS Sales1Sum FROM SalesQuery Where BonusDeal =
1

SELECT SUM(SalesAmount) AS Sales2Sum FROM SalesQuery Where BonusDeal =
0

Sales1Sum: 25,000
Sales2Sum: 25,000

So it appears that the Query of Query is not taking the WHERE clause
into
consideration..

Any Ideas on why?  Is this a Bug?  How should I proceed?

Thanks Everyone,

-Dan

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFStoredProc cfsqltype="cf_sql_Date" doesn't work with SmallD ateTime SQL Type...Why?

[Garza, Jeff]

Since you are using ODBC, try doing a CreateODBCDateTime(NewDueDate) and use
that as your date parameter.

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



-Original Message-
From: Gary Ashbaugh [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 12:38 PM
To: CF-Talk
Subject: CFStoredProc cfsqltype="cf_sql_Date" doesn't work with
SmallDateTime SQL Type...Why?


When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a
SmallDateTime SQL field, I get an error...why?


ERROR MESSAGE RECEIVED:

ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error,


COLDFUSION CODE:

   







   


SQL STORED PROCEDURE:

CREATE PROCEDURE [Add_FYSetup]
 (@FY nvarchar(4)=NULL,
 @Due_Date smalldatetime=NULL,
 @Contact_Person nvarchar(50)=NULL,
 @Contact_Phone nvarchar(14)=NULL,
 @RetVal int = NULL Output,
 @RetMsg nvarchar(100) = NULL Output)

AS...

Here is the database structure:

FY nvarchar(4)
Due_Date smalldatetime
Contact_Person nvarchar(50)
Contact_Phone nvarchar(14)



Gary


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion and Networks

[Garza, Jeff]

Look for the Intranet Hosting Tool Kit on www.intrafoundation.com.  It's a
series of CFX custon tags that should be able to achieve what you are
looking for.  Lewis Sellars released this as freeware awhile back...

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



-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 10:35 AM
To: CF-Talk
Subject: RE: Cold Fusion and Networks


I don't know of anybody who's done it, but I'm sure that it can be done
- write a custom tag in C++ or java that does the job.

- Matt Small

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 10:51 AM
To: CF-Talk
Subject: Cold Fusion and Networks

Sorry for the double post..I wasn't sure if the subject was descriptive
enough.  :-)

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of
names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Insert a list into a table - help!!!

[Garza, Jeff]

Roll this into a stored proceedure and pass your list to that

Change the insert queries to match your database and rem out the print
statements...

=
BEGIN STORED PROCEEDURE
=

CREATE PROCEEDURE usp_InsertList 
@myList nvarchar(255) -- this is the list!!!
@strIndex int
@findIndex int
@theName nvarchar(255)

--rem out the set list once you are passing the variable...
SET @mylist = 'joe,john,patty,bob'
SET @strIndex = 1
SET @findIndex = 1

WHILE (LEN(@myList) <> 0)
BEGIN
SET @findIndex = CHARINDEX(',', @mylist, @strIndex)
PRINT 'Found a Comma at: ' + Convert(nvarchar(10), @findIndex)
-- Deal with lists that have one member
  IF @findIndex = 0 -- single value list
  BEGIN
  SET @theName = @myList
  PRINT 'This is the Final List Item: ' + @myList
  --INSERT INTO mytable (myfield) VALUES (@theName)
  BREAK
  END
  --otherwise there are still elements...
  ELSE
  BEGIN
  SET @theName = SUBSTRING(@mylist, @strIndex, (@findIndex - @strIndex))
  PRINT 'This is the name we found ' + @theName
  --INSERT INTO mytable (myfield) VALUES (@theName)
  SET @mylist = RIGHT(@mylist, ((LEN(@mylist) - (@findIndex -
@strIndex))-1))
  PRINT
'==='
  END
END

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



-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 04, 2002 2:38 PM
To: CF-Talk
Subject: RE: Insert a list into a table - help!!!


MSSQL

-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 12:24 PM
To: CF-Talk
Subject: RE: Insert a list into a table - help!!!


What database are you using?

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



-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 04, 2002 1:20 PM
To: CF-Talk
Subject: Insert a list into a table - help!!!


I have a list with at least 3 items. And I want to insert it into 
table. 
right now, I'm looping through the list to insert them into db, but 
this is
like writing multiple cfquery's. and what happens if my list has 20 
items.
 
 http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Outputting issue

[Garza, Jeff]

Is the data in the second query related to the first? Or is it completely
disjointed from the first query?  

If it's unrelated, you could build the HTML outside the first CFOUTPUT block
and dump it to a variable for later.

If your data is related to the original query, you'll have to use nested
CFLOOPS or perhaps a custom tag...

HTH,

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



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 04, 2002 1:41 PM
To: CF-Talk
Subject: Re: Outputting issue


What if I cannot do an OUTPUT query="getitems" (already inside of an output)
.


- Original Message -
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 2:35 PM
Subject: RE: Outputting issue


> Try using the group attribute in your CFOUTPUT.
>
> 
> #Header#
> 
> #Type# -- #id# -- #Name#
> 
> 
>
> You should also use an order by clause in your select statement...
>
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 04, 2002 1:30 PM
> To: CF-Talk
> Subject: Outputting issue
>
>
> Ok, I have  a pretty basic question, but haven't used it much in the past
so
> I am needing alittle help.
>
> I have a query:
>
> 
> Select header,type,id,name
> from items
> 
>
> Each item coming from the above query has a header value, and I want to
> display the results as such:
>
> HEADER1
> ITEM 1
> ITEM 2
> ITEM 3
> HEADER2
> ITEM 4
> ITEM 5
> ITEM 6
> HEADER 3
> blah blah
>
> How do I do this without multiple queries...
>
> Thanks (I know it's basic)
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector - Commerce Builder
>
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Outputting issue

[Garza, Jeff]

Try using the group attribute in your CFOUTPUT.


#Header#

#Type# -- #id# -- #Name#



You should also use an order by clause in your select statement...

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



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 04, 2002 1:30 PM
To: CF-Talk
Subject: Outputting issue


Ok, I have  a pretty basic question, but haven't used it much in the past so
I am needing alittle help.

I have a query:


Select header,type,id,name
from items


Each item coming from the above query has a header value, and I want to
display the results as such:

HEADER1
ITEM 1
ITEM 2
ITEM 3
HEADER2
ITEM 4
ITEM 5
ITEM 6
HEADER 3
blah blah

How do I do this without multiple queries...

Thanks (I know it's basic)

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Insert a list into a table - help!!!

[Garza, Jeff]

What database are you using?

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



-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 04, 2002 1:20 PM
To: CF-Talk
Subject: Insert a list into a table - help!!!


I have a list with at least 3 items. And I want to insert it into table. 
right now, I'm looping through the list to insert them into db, but this is
like writing multiple cfquery's. and what happens if my list has 20 items.
 
 http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Getting the id of the row you just inserted...

[Garza, Jeff]

In SQL Server, write a stored proc and get @@identity.  Works everytime.

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



-Original Message-
From: Voris, Jim [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 29, 2002 1:12 PM
To: CF-Talk
Subject: Getting the id of the row you just inserted...


It seems to me that there are three basic ways to get the id of the row you
just inserted.
1)  @@identity
and
2)  cflocking the insert statement and the select max(id) statement.
and
3)  qualifying the select max(id) statement to avoid problems caused by
multiple threads.

I'm curious which method people use and which they find to be the best.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: where to find MS SQL Commands

[Garza, Jeff]

Download the Books Online (online help system for SQL Server) from the
microsoft site... 

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp 

HTH, 

Jeff 



-Original Message-
From: han peng
To: CF-Talk
Sent: 1/28/02 6:37 PM
Subject: where to find MS SQL Commands

Hihi.. i know this is not suppose to be here...
 but i just dunno where to find the list of SQL commands for MSSQL.

its so different from Oracle command..
sigh..

Thanx in advance..!!



Cheers
han



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

RE: Decrypting source code

[Garza, Jeff]

Here we go again  Do a search on google.com for cfdecrypt.  And put on
your flame retardant suit... 

Jeff Garza

-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 28, 2002 4:04 PM
To: CF-Talk
Subject: Decrypting source code


Does anyone know how to decrypt sorce code that has been encrypted with 
cold fusion?
Thanks,
Ray

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Check if sent

[Garza, Jeff]

Wrap the CFMAIL call in a try/catch block and have a second CFMAIL
afterwards that sends the error if there is one or a success message if it
goes...  After it leaves the ColdFusion server it's pretty much out of your
control.  

Another option is to send it using HTML mail format and set a web bug that
is a pipe gif (http://myserver/checkmail.cfm";>).  This way you'll
be able to see if they received it or not...

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



-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 28, 2002 3:57 PM
To: CF-Talk
Subject: Check if sent


I have a little CF script (CFMAIL tag executed by a scheduled task in CF
Server) running on a box that emails a file to a specified mail box each
day. I also get it to cc me so that I can keep an eye on it working but I
don't want a 500K file choking up my mail box each day. Is there a way I can
validate that its sent and just get some type of validation message.

TIA!


**

Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]
www.workcover.com

p: 08 82332548
f: 08 82332000
m: 0418 806 166

**




This e-mail is intended for the use of the addressee only. It may 
contain information that is protected by legislated confidentiality
and/or is legally privileged. If you are not the intended recipient you
are prohibited from disseminating, distributing or copying this e-mail.

Any opinion expressed in this e-mail may not necessarily be that of the
WorkCover Corporation of South Australia. Although precautions have
been taken, the sender cannot warrant that this e-mail or any files
transmitted with it are free of viruses or any other defect.

If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any
copies.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: database security

[Garza, Jeff]

With access that's about as good as you get.  You can always put a password
on the DB as well.  But that is truly trivial to crack once you get the
mdb.

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



-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 28, 2002 3:16 PM
To: CF-Talk
Subject: database security


Hi

I'm working with a database programmer (in access) who is paranoid about 
his databases.

He is very worried about the security of his database.

Currently I store the database in a non-web-accessible directory on a 
shared server, but that's it.

Is there anything else I can reasonably do? (the website is being done 
quite cheaply)

I have read some articles on security but they all seem to focus on 
encrypting a string rather than actually protecting the database as such.

Any clues please??

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Integrating the Full Verity K2 Server with CF

[Garza, Jeff]

Has anyone out there integrated the Full Verity K2 Server with ColdFusion?
We
are looking at purchasing the full version of Verity K2 to augment our
intranet
search/cataloging capabilities.  I am curious to hear about your
nightmares/success stories in the implementation.  Any issues wrapping the
COM objects provided? Or did you scrap using CF to interface with Verity and
go with their JSP/ASP prebuild pages.

Thanks in advance,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]
http://www.spectrumastro.com  
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Integrating the Full Verity with CF

[Garza, Jeff]

Has anyone out there integrated the Full Verity Server with ColdFusion?  We
are looking at purchasing the full Verity K2 server to augment our intranet
search/cataloging capabilities.  I am curious to hear about your
nightmares/success stories in the implementation.  Or did you scrap CF to
interface with Verity and go with their JSP/ASP prebuild pages.

Thanks,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: the Hacking Game (was Problems with CF Mail)

[Garza, Jeff]

This was one from CF-Community about a month and 1/2 ago... It's a website
with "hacking challenges" to complete.  Quite addictive once you get into
it.  I made it to level 6 and was stumped...

www.try2hack.nl -- don't let it eat all your time as it will...

Please don't perpetuate this thread as it's now quite off topic.

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



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 23, 2002 4:44 PM
To: CF-Talk
Subject: RE: problems with CF mail


> > How are things?  I gave up on the hacking game.
>
> Ooopss... I really need to check the TO: address

Yes, and now you'll have to tell us all about the hacking game.

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

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: problems with CF mail

[Garza, Jeff]

Ooopss... I really need to check the TO: address

Sorry for the post.

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



-Original Message-
From: Garza, Jeff 
Sent: Wednesday, January 23, 2002 4:06 PM
To: CF-Talk
Subject: RE: problems with CF mail


So, do I see correctly or do you have a new Padawan at Crescotech???

How are things?  I gave up on the hacking game. Had to get some real work
done.  Anyway, hope things are well.  Later.

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



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 23, 2002 4:01 PM
To: CF-Talk
Subject: RE: problems with CF mail


has your server been blocked by ORBS or some such?  is there anything in
mail.log?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 5:36 PM
To: CF-Talk
Subject: problems with CF mail


I have a simple SMTP mail server set-up that CF is configured to use as
SMTP. Everything worked fine for a year, but now it looks like the
messages
that CF is sending our going into the void. If I do "verify" in CF
Admin,
the mail server checks out - I can also see the communication between it
and
CF when I look at the mail server's real-time console. The messages just
don't get delivered. I would appreciate any pointers to isolate these
problems. I removed some message from the /Undeliverable folder, stopped
and
started both CF and the mail server without any results.

Thanks!






__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: problems with CF mail

[Garza, Jeff]

So, do I see correctly or do you have a new Padawan at Crescotech???

How are things?  I gave up on the hacking game. Had to get some real work
done.  Anyway, hope things are well.  Later.

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



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 23, 2002 4:01 PM
To: CF-Talk
Subject: RE: problems with CF mail


has your server been blocked by ORBS or some such?  is there anything in
mail.log?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 5:36 PM
To: CF-Talk
Subject: problems with CF mail


I have a simple SMTP mail server set-up that CF is configured to use as
SMTP. Everything worked fine for a year, but now it looks like the
messages
that CF is sending our going into the void. If I do "verify" in CF
Admin,
the mail server checks out - I can also see the communication between it
and
CF when I look at the mail server's real-time console. The messages just
don't get delivered. I would appreciate any pointers to isolate these
problems. I removed some message from the /Undeliverable folder, stopped
and
started both CF and the mail server without any results.

Thanks!





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

RE: ASP Equivalents?

[Garza, Jeff]

We need to build an app using ASP.  We'd rather use CF (of course!) but the
customer is adamant.

Anybody know a good source for getting "ASP equivalents" for:

1. creating and initializing server, client, application, and session scope
variables as we do in application.cfm

Global.asa

2. cfmodule (or passing variables to parameters in a given template)

COM Objects, included templates have access to globally available variables.

3. cfquery

Server.CreateObject("ADODB.Connection")
Server.CreateObject("ADODB.Recorset")

4. cfinclude

Server.execute or 

5. cfswitch/cfcase

Select/Case

6. cfparam

Dim, although you cannot define a default value.

7. isDefined() function

Option Explicit at the top of the page. Forces variable declaration prior to
use.

8. cfoutput, cfloop

While NOT rs.myrecordset  EOF

Rs.myrecordset.movenext

Looping is achieved via any of the accepted looping structures...
While...Wend, For Each...Next, For...Next, Do...Loop

9. List functions (particularly, ListGetAt())

Mid, left, right, len, etc... You'll have to roll your own.

10. Array functions (you don't have to go through all functions, just tell
us if there's anything outstanding that CF has that asp doesn't)
11. Structs (see 10)

You'll have to roll most of these yourself.

12. Can we embed conditional expressions in HTML tags in the same way that
CF allows us to? For instance, can we do something similar to a cfif
expression within an HTML tag? If so, how is this done? I use this a lot in
my select option tags for handling complex option lists.

Sure, just embed <% your asp stuff here %>...

13. Date functions like in CF?

Check the VBScript documentation

14. Administrative functions like those in CF Admin, like setting up a
datasource and debugging info?

Ha!!!  Try the command line or the Server console.

15. Installing and configuring an Index server for searching capabilities

MS indexing service.  Enjoy the documentation.

===
Do yourself a favor and buy a good book on ASP (I like the WROX professional
ASP 3.0 myself...).  Try to convert as much of your code to CFSCRIPT this
will make the conversion easier.  

Good Luck,

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

RE: Verity Question

[Garza, Jeff]

Not to my knowledge.  What you could do is on the search action page (where
you call CFSEARCH, do a simple DB insert of the search terms... Or use the
NIFTY CFLOG tag, which is new to CF5, to create a running log of all the
search terms that are tried... 

Speaking of that.. Thanks for reminding me that I've been wanting to do that
on my own site for quite some time

HTH,

Jeff


-Original Message-
From: Brian Scott Barnett [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 21, 2002 1:33 PM
To: CF-Talk
Subject: Verity Question


On CF Server 5, does Verity log the searches that people do, somewhere?  If
so, how can I get to them?

I'd like to see the search terms that people are using, so that I can
architect the site better.

Brian Barnett
[EMAIL PROTECTED]

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Using CFLDAP w/MS Exchange 5.5

[Garza, Jeff]

This has worked for us...  You'll need to know the Organization name as it's
stored in the Exchange directory





LDAP Test




  Common Name
  E-Mail Address
  UserName
  Company Name
  Distinguished Name Vars



usrname = listfirst(dn, ",");
usrname = Mid(usrname, (find("=", usrname) + 1), len(usrname));
company = listgetat(dn, "2", ",");
company = Mid(company, (find("=", company) + 1), len(company));


  #cn#
  #mail#
  #usrname#
  #company#
  #dn#






HTH,

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



-Original Message-
From: Dave Bosky [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 18, 2002 7:21 AM
To: CF-Talk
Subject: Using CFLDAP w/MS Exchange 5.5


Has anyone used the cfldap tag to query MS Exchange for a list of names?
I always receive one of two errors. --If I don't use username/password
attributes I get the error msg 'Protocol Error'. --If I use
username/password attributes I get the error msg 'Invalid Credentials'.
 
I even had our Network/Exchange admin use his account information and it
Returned Invalid Credentials.  
 
Any idea where the problem might be? 
 
Thanks,
Dave
 


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

RE: CF and ASP

[Garza, Jeff]

You can try the 15Seconds list, but beware... Make sure you've read through
the VBScript documentation and searched on MSDN/Technet to answer your
problems.  Most of the time they will reference a KB article and that's it.
They're not as friendly as we are here.

You can also ping me off-list.  I've done a significant amount of ASP
development and porting ASP to CF.

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



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 15, 2002 8:04 PM
To: CF-Talk
Subject: CF and ASP


Hello All,

I have a question a bit off topic.
Does anyone know of a list like this one but for ASP?
I need to ask a few questions there to help get this site converted to CF.

Thanks,
Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4



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

RE: Undocumented Functions and Tags

[Garza, Jeff]

There is a link to them on the houseoffusion home page.  Don't know if all
the new ones (are there any??) in CF5 are covered though...

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



-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 03, 2002 3:20 PM
To: CF-Talk
Subject: Undocumented Functions and Tags


Can anyone point me toward information about CF 5's undocumented functions
and tags?  I went searching for this information earlier today and all I
really came up with were security bulletins (circa CF 4.5) posted on Allaire
and a number of security sites.

Yeah, I know... that's why they're called 'undocumented'. :)

Thanks,
Jim

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Simple FORM Variable ERROR?????

[Garza, Jeff]

I don't think CF is what you want to use here... Since it is run server
side, what you are attempting to do would require a round trip to the
server.
Try checking out the TwoSelectsRelated tag at the Allaire Developers
Exchange.  This should do what you want.

Alternately you can roll your own using javascript.  I think I have a script
from one of my sites that I can send to you if you'd like.

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



-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 03, 2002 12:25 PM
To: CF-Talk
Subject: Simple FORM Variable ERROR?


Hello,

I am trying to create a simple form that depending on
which item is selected in one dropdown will determine
the contents of the next dropdown fieldit doesnt
to recognize my form variable though

here is my code:



*Outreach Method:
 
 --Select One--
 Telephone
 Home Visit
  


   





 
 


So depending on which value from the OutreachMethod1
drop down they choose will determine the cfif code
that follows...but it doesnt recognize #form.method1#
..do I need to have 2 forms and submit the first
part?

TIA



__
Do You Yahoo!?
Send your FREE holiday greetings online!

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: vspider --- help please

[Garza, Jeff]

Lucky Verity employees... 

They're off until the 7th...  I'll know more then.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.


-Original Message-
From: jon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 02, 2002 2:10 PM
To: CF-Talk
Subject: RE: vspider --- help please


I *may* have found a solution -- it's plugging away right now.

Basically, since the machine's actual IP is 206.239.147.xx I changed IIS to
serve the same site at 206.239.147.xx and www.epilepsyfoundation.org. It's
plugging away like it knows wassup, so apprently that solved the problem. We
shall see

Out of curiosity, how much was the full license?

-- jon

-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 4:12 PM
To: CF-Talk
Subject: RE: vspider --- help please


Ouch you just ran into the same problem I did I ended up scrapping the
vspider, may purchase the full blown one. You cannot, that I have found,
get the spider to do its thing on anything but the base IP of the server,
127.0.0.1, localhost, servername, or servername with a port number.  The
spider would not allow me to spider another IP even if it was on the same
server.  The port number was the only solution I found. Very disappointing.
Please let me know if you find a workaround.

Thanks
Sean

-Original Message-
From: jon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 3:50 PM
To: CF-Talk
Subject: RE: vspider --- help please


Ok... the spider is driving me friggin' insane.

The spectrum astro docs were good enough to get me started, but I'll be
darned if I can get it to spider my site.

Here's the issue -- we've got multiple IP addresses on a single machine. I
was able to create the collection alright, but I can't get it to spider the
site itself, as it thinks that it's going off site when I try to make it
spider the site by either IP address or URL.

Any tips? Can I make it start at my index.cfm and work from there somehow?

Thanks,
-- jon

-
jon roig
epilepsyfoundation.org



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:25 AM
To: CF-Talk
Subject: RE: vspider --- help please


Ben,

Try going to the online docs at the old allaire site...

http://www.allaire.com/developer/documentation/coldfusion.cfm

Download the Advanced ColdFusion Administration manual in .pdf format.
It
should have a complete section on the advanced Verity stuff (K2 Server
documentation, VSpider, etc...  It can be a bit cryptic but is for the
most
part complete.)

Also for a somewhat complete presentation about setting up the K2
Server and
VSpider, check out http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Ben Whalley
To: CF-Talk
Sent: 1/2/02 4:19 AM
Subject: RE: vspider --- help please

Can someone point me to some info on using vspider - does it come
bundled
with the CF? Sounds just like what I've been looking for.

Ben

> --
> From: Garza, Jeff
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, December 28, 2001 10:59 PM
> To:   CF-Talk
> Subject:  RE: vspider --- help please
>
> From what I've been able to find, it will only spider the localhost
> address
> space.  You'll have to set the site in question to respond to
localhost
> _and_ make sure that you are using only relative links...
>
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -Original Message-
> From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 2:51 PM
> To: CF-Talk
> Subject: RE: vspider --- help please
>
>
> Thank you.
> One more question, for the moment, has anyone had sucess using the
verity
> spider with multiple sites with different IP's on the same server?
Is
> this
> going to be possible or will it only allow the localhost, servername,

or
> 127.0.0.1.
>
> Thanks
>
> Sean
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 4:37 PM
> To: '[EMAIL PROTECTED]'
> Cc: Sean McCarthy
> Subject: RE: vspider --- help please
>
>
> > I thought I had it all working was I wrong.  The vspider
> > is great but... I have multiple sites on the same box with
> > different IP's. Technically in my eyes they are all "local"
> > but I cannot find a way to get the spider to go through the
> > site.  I even tried the same IP with different port numbers,
> > one works fine the other come back with the same error. Any
> > thoughts?

RE: vspider --- help please

[Garza, Jeff]

Your site must use relative links _and_ be addressable using the Localhost
address.

1) Configure your website so that the below address works...

http://localhost/index.cfm (using IIS just add the 127.0.0.1 IP and use the
Host Header of "Localhost")  Localhost is the only address I've been able to
get the spider to recognize.

2) ensure that all links from that page are relative ala:

 or 

Anylink with a FQDN (like www.mysite.com) in it will fail.

I must admit that this limitation makes using the spider a bear...

I'm currently investigating the purchase of the full spider from Verity as
what is included can't do very much...  We also run multiple sites and I'm
currently rotating which address responds to localhost manually when I
spider it (usually weekly), but this gets tedious...

Anyone else have other input???

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.


-Original Message-
From: jon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 02, 2002 1:50 PM
To: CF-Talk
Subject: RE: vspider --- help please


Ok... the spider is driving me friggin' insane.

The spectrum astro docs were good enough to get me started, but I'll be
darned if I can get it to spider my site.

Here's the issue -- we've got multiple IP addresses on a single machine. I
was able to create the collection alright, but I can't get it to spider the
site itself, as it thinks that it's going off site when I try to make it
spider the site by either IP address or URL.

Any tips? Can I make it start at my index.cfm and work from there somehow?

Thanks,
-- jon

-
jon roig
epilepsyfoundation.org



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:25 AM
To: CF-Talk
Subject: RE: vspider --- help please


Ben,

Try going to the online docs at the old allaire site...

http://www.allaire.com/developer/documentation/coldfusion.cfm

Download the Advanced ColdFusion Administration manual in .pdf format.
It
should have a complete section on the advanced Verity stuff (K2 Server
documentation, VSpider, etc...  It can be a bit cryptic but is for the
most
part complete.)

Also for a somewhat complete presentation about setting up the K2
Server and
VSpider, check out http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Ben Whalley
To: CF-Talk
Sent: 1/2/02 4:19 AM
Subject: RE: vspider --- help please

Can someone point me to some info on using vspider - does it come
bundled
with the CF? Sounds just like what I've been looking for.

Ben

> --
> From: Garza, Jeff
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, December 28, 2001 10:59 PM
> To:   CF-Talk
> Subject:  RE: vspider --- help please
>
> From what I've been able to find, it will only spider the localhost
> address
> space.  You'll have to set the site in question to respond to
localhost
> _and_ make sure that you are using only relative links...
>
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -Original Message-
> From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 2:51 PM
> To: CF-Talk
> Subject: RE: vspider --- help please
>
>
> Thank you.
> One more question, for the moment, has anyone had sucess using the
verity
> spider with multiple sites with different IP's on the same server?
Is
> this
> going to be possible or will it only allow the localhost, servername,

or
> 127.0.0.1.
>
> Thanks
>
> Sean
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 4:37 PM
> To: '[EMAIL PROTECTED]'
> Cc: Sean McCarthy
> Subject: RE: vspider --- help please
>
>
> > I thought I had it all working was I wrong.  The vspider
> > is great but... I have multiple sites on the same box with
> > different IP's. Technically in my eyes they are all "local"
> > but I cannot find a way to get the spider to go through the
> > site.  I even tried the same IP with different port numbers,
> > one works fine the other come back with the same error. Any
> > thoughts?
> >
> > Heres the error:
> > ...
> > Warn  2001/12/28 16:25:09 (ind022005) Authentication
> > scheme NTLM not
> > supported, URL [http://mybox.:76/].
> > Warn  2001/12/28 16:25:09 (ind022004) Authorization failed for
URL
> > [http://mybox.:76/], server mybox.:76, realm NTLM.
> > ...
> >
> > I can only assume the NTLM means "Not local machine"???
>
> No, NTLM refers to

RE: CFHTTP? Solution?

[Garza, Jeff]

Have you tried hitting that page from the server console (actually logging
into the server and firing up IE or Netscape)?  Perhaps it's a DNS issue on
your webserver.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 02, 2002 12:57 PM
To: CF-Talk
Subject: RE: CFHTTP? Solution?


Really weird but once I moved those text files to a different URL on the
same server, It works???  Anyone know why? Maybe CFhttp doesn't play well
with subdomains?

New file location:

www.careerlearn.org/KrisKart/courses.txt

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 02, 2002 2:40 PM
To: CF-Talk
Subject: RE: CFHTTP?


Ok...

Here is the link to the file:
http://webmaster.wsboces.org/courseinfo/courses.txt

The code is:

http://webmaster.wsboces.org/courseinfo/courses.txt";
method="Get"
delimiter=","
throwonerror="yes"
textqualifier="||"
columns="sname, Catalog_code, Catalog_name, Keywords"
name="buildcourses">




Insert into category (code, name, keyword)

values('#buildcourses.catalog_code#','#buildcourses.Catalog_name#','#buildco
urses.Keywords#')





Its really acting funny... I can't figure it out

-Original Message-
From: Paul Wille [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: CFHTTP?


Kris,

I'm getting a 500 Server Error.  Is the rest of the site working okay?
Perhaps you could post the code for us to take a look at.

Regards,

--Paul

Paul W. Wille[EMAIL PROTECTED]
--

--
ISITE Design, Inc. - Solutions Architect
www.isitedesign.com
503.221.9860 x110
888.269.9103
503.221.9865 fax
 
 
 
 
 

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 02, 2002 11:18 AM
To: CF-Talk
Subject: CFHTTP?

I AM HAVING AL SORTS OF PROBLEMS WITH CFHTTP...

HTTP://Webmaster.wsboces.org/test.cfm

Refresh the page multiple times and notice a bunch of different error
messages

Notice all the different errors anyone have any idea on how or why this




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

RE: vspider --- help please

[Garza, Jeff]

Ben,

Try going to the online docs at the old allaire site...

http://www.allaire.com/developer/documentation/coldfusion.cfm

Download the Advanced ColdFusion Administration manual in .pdf format.  
It
should have a complete section on the advanced Verity stuff (K2 Server
documentation, VSpider, etc...  It can be a bit cryptic but is for the 
most
part complete.)

Also for a somewhat complete presentation about setting up the K2 
Server and
VSpider, check out http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Ben Whalley
To: CF-Talk
Sent: 1/2/02 4:19 AM
Subject: RE: vspider --- help please

Can someone point me to some info on using vspider - does it come 
bundled
with the CF? Sounds just like what I've been looking for.

Ben

> --
> From:     Garza, Jeff
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, December 28, 2001 10:59 PM
> To:   CF-Talk
> Subject:  RE: vspider --- help please
> 
> From what I've been able to find, it will only spider the localhost
> address
> space.  You'll have to set the site in question to respond to 
localhost
> _and_ make sure that you are using only relative links...
> 
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
> 
> 
> 
> -Original Message-
> From: Sean McCarthy [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, December 28, 2001 2:51 PM
> To: CF-Talk
> Subject: RE: vspider --- help please
> 
> 
> Thank you.
> One more question, for the moment, has anyone had sucess using the 
verity
> spider with multiple sites with different IP's on the same server?  
Is
> this
> going to be possible or will it only allow the localhost, servername, 

or
> 127.0.0.1.
> 
> Thanks
> 
> Sean
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 4:37 PM
> To: '[EMAIL PROTECTED]'
> Cc: Sean McCarthy
> Subject: RE: vspider --- help please
> 
> 
> > I thought I had it all working was I wrong.  The vspider 
> > is great but... I have multiple sites on the same box with 
> > different IP's. Technically in my eyes they are all "local" 
> > but I cannot find a way to get the spider to go through the 
> > site.  I even tried the same IP with different port numbers, 
> > one works fine the other come back with the same error. Any
> > thoughts?
> > 
> > Heres the error:
> > ...
> > Warn  2001/12/28 16:25:09 (ind022005) Authentication 
> > scheme NTLM not
> > supported, URL [http://mybox.:76/].
> > Warn  2001/12/28 16:25:09 (ind022004) Authorization failed for 
URL
> > [http://mybox.:76/], server mybox.:76, realm NTLM.
> > ...
> > 
> > I can only assume the NTLM means "Not local machine"???
> 
> No, NTLM refers to the browser authentication required by that web 
server.
> With IIS, you can use Basic Authentication, which is a simple 
username and
> password, or you can use NTLM Authentication, which requires IE to 
take
> the
> username and password and send a password hash to the web server.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> 
> 


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: vspider --- help please

[Garza, Jeff]

>From what I've been able to find, it will only spider the localhost address
space.  You'll have to set the site in question to respond to localhost
_and_ make sure that you are using only relative links...

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



-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 28, 2001 2:51 PM
To: CF-Talk
Subject: RE: vspider --- help please


Thank you.
One more question, for the moment, has anyone had sucess using the verity
spider with multiple sites with different IP's on the same server?  Is this
going to be possible or will it only allow the localhost, servername, or
127.0.0.1.

Thanks

Sean

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 28, 2001 4:37 PM
To: '[EMAIL PROTECTED]'
Cc: Sean McCarthy
Subject: RE: vspider --- help please


> I thought I had it all working was I wrong.  The vspider 
> is great but... I have multiple sites on the same box with 
> different IP's. Technically in my eyes they are all "local" 
> but I cannot find a way to get the spider to go through the 
> site.  I even tried the same IP with different port numbers, 
> one works fine the other come back with the same error. Any
> thoughts?
> 
> Heres the error:
> ...
> Warn  2001/12/28 16:25:09 (ind022005) Authentication 
> scheme NTLM not
> supported, URL [http://mybox.:76/].
> Warn  2001/12/28 16:25:09 (ind022004) Authorization failed for URL
> [http://mybox.:76/], server mybox.:76, realm NTLM.
> ...
> 
> I can only assume the NTLM means "Not local machine"???

No, NTLM refers to the browser authentication required by that web server.
With IIS, you can use Basic Authentication, which is a simple username and
password, or you can use NTLM Authentication, which requires IE to take the
username and password and send a password hash to the web server.

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

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

RE: Why does htmlCodeFormat change font

[Garza, Jeff]

I beleive that when HTMLCodeFormat() is used the entire code block is
wrapped with  tags.  This would effectively negate your style 
sheets.
To show the code with fancy formatting, try using the HTMLEditFormat()
function.  

Cheers,

Jeff Garza

-Original Message-
From: Douglas Brown
To: CF-Talk
Sent: 12/22/01 12:12 AM
Subject: Why does htmlCodeFormat change font

I am outputting with htmlCodeFormat and it seems like when I do it 
ignores the stylesheet. Why is this and can it be corrected?


Thanks


Doug


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Xp, starbucks , and coldfusion

[Garza, Jeff]

As long as you are using XP Professional, you can install IIS (it's a
limited version similar to PWS).  No problems.

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



-Original Message-
From: jason kufner [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 21, 2001 11:00 AM
To: CF-Talk
Subject: Xp, starbucks , and coldfusion


This is a multi-part message in MIME format.

--=_NextPart_000_0004_01C18A06.3700CA00
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Okay here's my problem:
 
I use my laptop as a portable cold fusion design station. (You know  
For those afternoon trips to starbucks) Right now I have cold Fusion 
Studio, Cold fusion server 4.5 and Microsoft personal web server as  
My web server. (Remember it's on my laptop, all I have to do is check  
One page on at time while I sip my chai...)
 
My questions are: what is the personal web server equivalent for XP.  
Can I do the same thing on XP?
 
Thanks for your help

--=_NextPart_000_0004_01C18A06.3700CA00
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40";>








cid:[EMAIL PROTECTED]";>











Okay
here’s my problem:

 

I
use my laptop as a portable cold fusion design station. (You know  

For
those afternoon trips to starbucks) Right =
now I have
cold Fusion 

Studio,
Cold fusion server 4.5 and Microsoft personal web server as  

My web server.
(Remember it’s on my laptop, all I have to do is check  

One
page on at time while I sip my chai...)

 

My
questions are: what is the personal web server equivalent for XP.  

Can
I do the same thing on XP?

 

Thanks for your help







--=_NextPart_000_0004_01C18A06.3700CA00--


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

RE: simple HTML ?

[Garza, Jeff]

You could replace the href="javascript:void();" with a href="javascript://"
This should take care of it.  I noticed in another post (to another group)
that not all browsers recognize the void statement.  You might also try
putting a zero in the parentheses "(0)".  Sorry about the bad function.

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



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 20, 2001 3:52 PM
To: CF-Talk
Subject: Re: simple HTML ?


I tried your code, but get an error in the javascript:void(); It seems li
ke
it wants something between the () or something



Doug
- Original Message -
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 2:14 PM
Subject: RE: simple HTML ?


>  onclick="document.[formname].submit();">mylink
>
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 3:20 PM
> To: CF-Talk
> Subject: OT: simple HTML ?
>
>
> I want to pass the values of some hidden fields, but I am not using a
> submit button. I am using a text link. How would I pass the form and
> hidden fields?
>
>
> Thanks
>
>
> 

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

RE: simple HTML ?

[Garza, Jeff]

mylink

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



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 20, 2001 3:20 PM
To: CF-Talk
Subject: OT: simple HTML ?


I want to pass the values of some hidden fields, but I am not using a 
submit button. I am using a text link. How would I pass the form and 
hidden fields? 


Thanks


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Returning IDs off a query...

[Garza, Jeff]

If you are using sql server try this...


SET NOCOUNT ON
INSERT INTO [yourtable](field1, field2)
VALUES ('text', 'text')
SELECT @@Identity AS newID
SET NOCOUNT OFF


Should return the ID as 

#newID# 


/* This works on SQL Server 2000 */

HTH,

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



-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 20, 2001 1:31 PM
To: CF-Talk
Subject: Returning IDs off a query...


I've been saving this question for a rainy day, and while it's not rainy, it
could be getting a little stormy...what is the best way to return a freshly
submitted ID from a cfquery?  Should I use a getMax SQL function with
cftransaction tag pair around the insert and select queries or should I
retrieve the @@identity in a separate cfquery statement?  Any takers?

Tyler


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Quick Question

[Garza, Jeff]

800x600 although I've run across some that still have it set at 640x480.  

I don't know about you but I think that the MyComputer Icon on a 640x480
sized screen looks almost as big as the real thing...   This is not to
rag on the visually impaired since I know that resolutions like this help
them immensely, it just looks REALLY HUGE after working on a 21" at
1600x1200...

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



-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 3:12 PM
To: CF-Talk
Subject: RE: Quick Question


Keep in mind too that out of the box, most computers are set to 800x600 and
the average user does not know, or care about how to change his resolution.

Dan

-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:10 PM
To: CF-Talk
Subject: RE: Quick Question


800 x 600. Your boss is just too hip. Find a buncha ways to complimen
t him
on this and remind him regularly.

T

-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 1:44 PM
To: CF-Talk
Subject: Quick Question


I hope that you'll permit me to ask a non cf question here.  It is th
e only
list that I subscribe to and I know that all of the top web developer
s are
here.

I'm having a debate with my boss.  He likes to spend money and always
 has
the latest gadgets.  On his desk is a twenty-something inch flat pane
l
display and he sets the resolution as high as he can.  You could look
 at
most web sites on his screen using binoculars.

I'm still developing our sites using 800 X 600 and he tells me that I
'm
living in the stone ages.

My question:  Which screen resolution is everyone designing for nowad
ays?

Thanks,

Eric Homa


_
_
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation * $99/Month * Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cf passing form values as url params

[Garza, Jeff]

You forgot to set your form method="post" ???

By default I think that homesite/studio will set it to "get".

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



-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 18, 2001 2:47 PM
To: CF-Talk
Subject: Cf passing form values as url params


Has anyone ever seen CF pass form fields as url parameters?  I have this
happening on a test box, and I don't know what the cause is.  Is it a
security setting?

Thanks for your help,

Daron J. Smith
Web Developer
PSEA

[EMAIL PROTECTED]
717-255-7141 
1-800-944-PSEA (7732) x 7141
Please note new email address (old one with 'mail' will soon expire)

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

RE: Counting the number of words in a field

[Garza, Jeff]

Try the ListLen() function.  This should give you the number of elements
(words) in your field.

ListLen(List, ["delimiter"])

HTH,

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



-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 18, 2001 8:20 AM
To: CF-Talk
Subject: Counting the number of words in a field


Is there a way to accomplish this? 

I have a database field for which I want to know the number of words it
contains, I though that since a field could also be a list, I'll treat it as
such and try to find the number of white spaces, and that will give me an
approximation of how many words it contains (I trim() the field before
placing it on the DB), but somehow trying to find the number of occurrences
of the white space in the list does not work.  I used the:

ListFind(mylist, " ", " ")

Does anybody knows of a way this will work, in a list setting or through
another way?



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

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

RE: Bug I think

[Garza, Jeff]

Take the date that is passed and set the day to 1...


myDate = now();
FirstDayofMonth = CreateDate(year(myDate), month(myDate), "1");


If someone else has a better way I'm open...

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



-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 17, 2001 9:46 AM
To: CF-Talk
Subject: Re: Bug I think


I would like to get the first date of month(date).

I want the first date of month to do a dateadd in my recurring calendar app.
- Original Message -----
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 17, 2001 11:17 AM
Subject: RE: Bug I think


> This is how that function is supposed to operate.  Firstdayofmonth() will
> return a julian date (day of the year).  Dayofweek() requires a full date
> (mm-dd-).  Think of it this way, how would dayofweek() know what year
it
> is from a julian date?  What are you trying to accomplish from this?
>
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -Original Message-
> From: David Brown [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 17, 2001 9:12 AM
> To: CF-Talk
> Subject: Bug I think
>
>
>   Server Product ColdFusion Server
>  Version 4, 5, 1, SP2
>  Edition Professional
>
>
> Has anyone see this?
>
> I am trying to find the firstdayofmonth(date) and then find what
> dayofweek(FirstDayofMonth(date)) is.
>
> For example:
>
> 
> 
>
> #firstday# #Weekday# 
>
> This will give you:
> 335 for firstday (12/1/01)
> 6 for Weekday(11/30/1900)
>
> If you try to do a dateformat(firstday,"mm/dd/") you get 11/30/1900 .
> You don't get an error reporting that you can't do that.  You just get the
> wrong answer.
>
> So I think that is a bug with CF 4.5.
>
> Any ideas.
>
>
> 

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

RE: Bug I think

[Garza, Jeff]

This is how that function is supposed to operate.  Firstdayofmonth() will
return a julian date (day of the year).  Dayofweek() requires a full date
(mm-dd-).  Think of it this way, how would dayofweek() know what year it
is from a julian date?  What are you trying to accomplish from this?

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



-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 17, 2001 9:12 AM
To: CF-Talk
Subject: Bug I think


  Server Product ColdFusion Server
 Version 4, 5, 1, SP2
 Edition Professional


Has anyone see this?

I am trying to find the firstdayofmonth(date) and then find what
dayofweek(FirstDayofMonth(date)) is.

For example:




#firstday# #Weekday# 

This will give you:
335 for firstday (12/1/01)
6 for Weekday(11/30/1900)

If you try to do a dateformat(firstday,"mm/dd/") you get 11/30/1900 .
You don't get an error reporting that you can't do that.  You just get the
wrong answer.

So I think that is a bug with CF 4.5.

Any ideas.


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

RE: Hello everyone.. question on converting a tag

[Garza, Jeff]

Try the listToArray() function.  This will take a delimited list and convert
it to a one dimensional array.

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



-Original Message-
From: Troy Montour [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 17, 2001 9:00 AM
To: CF-Talk
Subject: Hello everyone.. question on converting a tag


Hello,
I'm trying to convert an asp page to CF and not sure which tag to 
use for the ASP split tag any one have any idea's??

Thanks for your help
Troy Montour


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

RE: Certificate expired?

[Garza, Jeff]

Yup... Me too.  If you click through the alert, the applet will still
load...  Thankfully I'm only using It internally for some admin
functions

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



-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 17, 2001 8:41 AM
To: CF-Talk
Subject: Certificate expired?


Just started getting a 'certificate expired' warning when you try to
download the CFTREE applet on all of our CF sites, on several different
servers. Anyone else seeing this?

Ian

Portent Interactive
Using Process, Design and Content to create great web sites since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com

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

RE: Verity with the vspider and K2

[Garza, Jeff]

I've had problems getting CFSEARCH to work on a K2 collection created
without using the VDK tools.  Perhaps it's because I wasn't restarting the
K2 server...  

Are you able to search your MKVDK created collections using CFSEARCH?   Or
are you using the command line tool rcvdk.exe to search the collection?

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



-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 13, 2001 2:22 PM
To: CF-Talk
Subject: RE: Verity with the vspider and K2


Thanks for the input Jeff.

I can get my collection made with the mdvdk to be recognized by the K2
server using the alias name I've defined in the k2server.ini.
This the code im using to pull back results from it.



The mdvdk created collection does show up on the page where you define the
K2 Server Host Name & K2 Server Port.  
The only place it does not show up is on the Verity Collections page.
This wont be a problem since Im using K2 and not VDK. Correct?

>>MKVDK won't create an entry in the registry, so CF really has no idea that
>>there is a collection there.  Since you are conducting your searches using
>> there has to be a registy setting there.
This is only if I need VDK right?


Thanks again

Sean



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 3:26 PM
To: CF-Talk
Subject: RE: Verity with the vspider and K2


Sean,

See my comments inline



> 1. Is there a reason I would be better off to use the  tag
to
> create my collection if I am not planning on using the VDK mode or
> ?
>   To me it seems it is creating unnecessary directory structures that
> will not be used by the vspider.  The custom and file path only get used
> when using the  tag.

The MKVDK utility would be the logical way to deal with K2 collections
wouldn't it!!!  I made that mistake myself.  Actually, the preferred way to
manage this is to create an empty collection using the VDK mode tools
( or the CF Admin).  Yes this will create the additional
"custom" folder but what can you do.  The issue at hand is the Registry.
MKVDK won't create an entry in the registry, so CF really has no idea that
there is a collection there.  Since you are conducting your searches using
 there has to be a registy setting there.  Kinda screwed up I
know

> 2. I have the vspider working on the site.  Its exclude features are a
nice
> addition.  Am I missing something though?  Is there a way to easily do
> excludes with ?

There are a number of attributes that don't seem to work with the localhost
version of the spider.  This may be one of them.  I personally haven't used
the indinclude switch so I can't say for sure.  One thing I'd recommend it
to put a link at the bottom of the page or something (use small white text
or a transparent gif to hold the link) and have that point to your pop ups
section.  Kinda cheesy but it'll work

> 3. This is the way I would like my -cmdfile file to work:  Does anyone see
> something that is syntactically wrong?
>
> -common d:\cfusion\verity\common 
> -collection d:\CFusion\Verity\collections\mycollection 
> -start http://localhost:98/
> -indinclude http://localhost:98/popupSection   (I've tried -include here
as
> well but no luck)
> -indexclude http://localhost:98/popupSection/pdfs/*

I don't see anything here that wouldn't work  You've got me.

> 4. Last question (for now) does the K2 server have to be restarted every
> time a collection is refreshed or only the first time it is created for
the
> new information to be available to the K2 Search.

>From what I've found, the answer is yes.  K2 Seems to get really squirrly if
it's not restarted on a collection refresh.  I've created batch files to
refresh the collection using the spider (works great) and subsequently
restart the K2 server.  There is virtually no downtime and it keeps things
running smooth.  I know it's probably not what you wanted to hear, but this
is what I've found to be pretty much bulletproof...

Also, I did a presentation about this.  You can find my presentation
materials and some batch files for updating collections and such here...

http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck!

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


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

RE: Verity with the vspider and K2

[Garza, Jeff]

Sean,

See my comments inline



> 1. Is there a reason I would be better off to use the  tag
to
> create my collection if I am not planning on using the VDK mode or
> ?
>   To me it seems it is creating unnecessary directory structures that
> will not be used by the vspider.  The custom and file path only get used
> when using the  tag.

The MKVDK utility would be the logical way to deal with K2 collections
wouldn't it!!!  I made that mistake myself.  Actually, the preferred way to
manage this is to create an empty collection using the VDK mode tools
( or the CF Admin).  Yes this will create the additional
"custom" folder but what can you do.  The issue at hand is the Registry.
MKVDK won't create an entry in the registry, so CF really has no idea that
there is a collection there.  Since you are conducting your searches using
 there has to be a registy setting there.  Kinda screwed up I
know

> 2. I have the vspider working on the site.  Its exclude features are a
nice
> addition.  Am I missing something though?  Is there a way to easily do
> excludes with ?

There are a number of attributes that don't seem to work with the localhost
version of the spider.  This may be one of them.  I personally haven't used
the indinclude switch so I can't say for sure.  One thing I'd recommend it
to put a link at the bottom of the page or something (use small white text
or a transparent gif to hold the link) and have that point to your pop ups
section.  Kinda cheesy but it'll work

> 3. This is the way I would like my -cmdfile file to work:  Does anyone see
> something that is syntactically wrong?
>
> -common d:\cfusion\verity\common 
> -collection d:\CFusion\Verity\collections\mycollection 
> -start http://localhost:98/
> -indinclude http://localhost:98/popupSection   (I've tried -include here
as
> well but no luck)
> -indexclude http://localhost:98/popupSection/pdfs/*

I don't see anything here that wouldn't work  You've got me.

> 4. Last question (for now) does the K2 server have to be restarted every
> time a collection is refreshed or only the first time it is created for
the
> new information to be available to the K2 Search.

>From what I've found, the answer is yes.  K2 Seems to get really squirrly if
it's not restarted on a collection refresh.  I've created batch files to
refresh the collection using the spider (works great) and subsequently
restart the K2 server.  There is virtually no downtime and it keeps things
running smooth.  I know it's probably not what you wanted to hear, but this
is what I've found to be pretty much bulletproof...

Also, I did a presentation about this.  You can find my presentation
materials and some batch files for updating collections and such here...

http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck!

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: PopUp Problem

[Garza, Jeff]

I just ran into this problem myself.  I found a script on irt.org and
modified it appropriately...





I think the last else statement is extraneous, but it doesn't seem to be
hurting anything...

HTH,

Jeff Garza
Webmaster/Lead Developer
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Gonzo Rock
To: CF-Talk
Sent: 12/12/01 9:15 PM
Subject: RE: PopUp Problem

Yes Marcus it does have the onload="window.focus()" in the body section.
The problem is that a user click that references the SAME DOCUMENT with
a different anchor ... ie somedoc.html#someanchor does not fire the
onload=window.focus() routine. 

Am I being clear?
Sure hope so.
Gonzo


>Perhaps a silly question, but does your second document, the one that
your
>trying to load in the named window, have the onload="window.focus()"
>statement in it?
>
>Since your reloading the page, the window will process again, and needs
it.
>
>Marcus
>
>> -Original Message-
>> From: Gonzo Rock [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, December 12, 2001 5:14 PM
>> To: CF-Talk
>> Subject: PopUp Problem
>>
>>
>> I'm still having trouble with PopUp browser windows... have read
>> lots of docs but not quite finding what I need.
>>
>> Specifically my problem is getting a PopUp that has been named
>> and used previously to receive the focus when again called. The
>> called document has a
>> 
>> statement in it.
>>
>> For example:
>> TheHelpDoc = SomeName.html#SomeAnchor
>>
>> Click4Help
>>
>> works great the first time it is called.
>>
>> If it is called a second time with some NEW Document name it WILL
>> bring the NEW Document into focus... (pop to the top).
>>
>> HOWEVER if the SameDocument but a DifferentAnchor is called it
>> will bring the document to the new anchor BUT it will NOT bring
>> the help_win into focus.
>>
>> It seems that the onload="window.focus()" does not fire the
>> second time around when the anchor tag is involved.
>> 
>

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

RE: Displaying of HTML in page?

[Garza, Jeff]

Actually either will produce the HTML Code, the formatting is different...


#HTMLCodeFormat("this is some Text")#


#HTMLEditFormat("this is some Text")#


HTMLCodeFormat() will output the string wrapped with  tags.

HTMLEditFormat() will output the string without  tags.


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



-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:23 AM
To: CF-Talk
Subject: RE: Displaying of HTML in page?


actually I believe it's HTMLEditFormat()

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:03 AM
To: CF-Talk
Subject: RE: Displaying of HTML in page?


HTMLCodeFormat(yourstring)

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



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:13 AM
To: CF-Talk
Subject: Displaying of HTML in page?


I am creating a forum for our site, and want to be able to display HTML 
code. How can I accomplish this where the browser will not try to render 
the code. Also if someone types in a link, I want that to display as a 
clickable link and not just text.


All help appreciated.




Doug







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

RE: Displaying of HTML in page?

[Garza, Jeff]

HTMLCodeFormat(yourstring)

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



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:13 AM
To: CF-Talk
Subject: Displaying of HTML in page?


I am creating a forum for our site, and want to be able to display HTML 
code. How can I accomplish this where the browser will not try to render 
the code. Also if someone types in a link, I want that to display as a 
clickable link and not just text.


All help appreciated.




Doug





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

RE: recordset sql statement

[Garza, Jeff]

It's part of the debug variables.  You can enable this in the CF
Administrator to appear on pages requested from a specific IP address.

HTH,

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



-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 9:11 AM
To: CF-Talk
Subject: recordset sql statement


in the debug window, under recordsets, there's a column that shows the sql
that ran to generate that query. is this an exposed variable that we have
access to on a page? like in the form of something like
#queryname.statement# or is it restricted to only their debug window and

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

RE: CFDirectory and Network

[Garza, Jeff]

Make sure the account that CF is running under (system by default) has
network rights.  Typically, the system account on a webserver doesn't have
network privs.  Change the account that CF runs as using the services
control panel to an account that has network rights.

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



-Original Message-
From: webmaster [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 11, 2001 8:05 AM
To: CF-Talk
Subject: CFDirectory and Network


I'm trying to do a cfdirectory across our network from the server to a 
mapped drive (i.e. the H:\ drive)

Everthing works fine on the locals but I get nothing back on the mapped 
drive.

Am I missing something in the doc about not being able to do this ?

TIA

Richard


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

RE: Templates executing twice CF bug

[Garza, Jeff]

Ran your test code and I only got a single log entry.  Running CF5 Single
User on Win2kPro.  Will try in the morning on Full Enterprise CF5 on
Advanced Server.

Jeff Garza
Webmaster/Lead Developer
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Max Paperno
To: CF-Talk
Sent: 12/10/01 9:29 PM
Subject: Templates executing twice CF bug

Greetings,

I've identified a somewhat minor but possibly damaging bug in CF 5.
It's pretty strange, but true.  Zac Belado has confirmed that this was
also the problem in his case (see his "Page Processing Twice" message
from earlier today).  It seems to only affect CF5 (4.5 was also tried)
but so far only tested on W2K.

The bug causes a template to be executed twice by the CF engine.  It
literally runs everything connected to the request twice (all includes,
parent template, etc).  There is no indication of this unless you have
data that is noticeably affected (such as inserting DB records).  The
HTTP request is not doubled, only the actual CF code execution.  This is
not browser or Web server-related in any way.

The cause seems to be missing cfoutput tags around a variable call, and
apparently specifically in an IMG tag (some others were tried with no
problems surfacing).  So some code like this:



(w/out cfoutput tags anywhere around it) will cause double execution.
Wrap it in cfoutputs (or in comments) and the problem goes away.

Strange, no?

So strange that I wrote a test for this.  I've pasted my test template
below, but if your email client makes it unreadable then you can also
download a version here .
Instructions are in the comment. I'll also submit this to MM.

Comments welcome.

Cheers,
-Max


BugTest.cfm
---















-
Maxim Paperno, CTO
World Design Group, Inc.
[ CF Development and Hosting since 1996 ]




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

RE: Help!

[Garza, Jeff]

You by chance using Query of Queries on that page?

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



-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 10, 2001 3:52 PM
To: CF-Talk
Subject: Help!


Hi,

Anyone ever seen the following error message?


PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (45:1) to (45:53).


Our application has been running fine for 3 months and now this occurs on
occasion.  Hit refresh on the browser and the page runs fine on the reload.
It is a page with multiple queries.  It is the index page that you are
directed to after a login with application, client and session variables
set.

I'm wondering if it has to do with system resources?

Any help?

Thanks,

Eric Homa



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

RE: Custom Tag to resize JPG on the fly...

[Garza, Jeff]

The only problem with this is you are still downloading the entire 
image
rather than the smaller thumbnail or whatever.  I think the purpose is 
to
reduce the physical size/resolution for a smaller download.

I've been fiddling with the Perl Image Magick modules for this.  
Running the
commands from cfexecute.  It's slow since I don't know Perl all that
well

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



-Original Message-
From: Mookie Bear [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 07, 2001 4:00 PM
To: CF-Talk
Subject: RE: Custom Tag to resize JPG on the fly...


or, you can use proportions to resize the pic :)

for example, i have a pic that is 237 in width and 500 height.

lets say i want to shrink it down to a width of 150.  to get the 
proportionate height (i knew this would come in handy one day since 4th 

grade!) just solve this equation  (237/500) = (150/x)

blah, u should remember this stuff, right? :)







>From: "Joseph DeVore" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Custom Tag to resize JPG on the fly...
>Date: Fri, 7 Dec 2001 14:26:23 -0800
>
>CFX_IMAGE by Jukka Manner can do this for you.
>
>You can download it from Lewis Sellers website at
>http://intrafoundation.com/3rdparty/CFX_Image.zip
>
>
>Joseph DeVore
>VeloxWeb Technologies
>
>
>
>-Original Message-
>From: Jared Stark [mailto:[EMAIL PROTECTED]]
>Sent: Friday, December 07, 2001 2:10 PM
>To: CF-Talk
>Subject: Custom Tag to resize JPG on the fly...
>
>
>I have been looking on the Allaire website for a tag to thumbnail JPG
>images on the fly.  I've found one that does GIF, but I need JPG.
>Anyone know of a good one that they can recommend?  I must admit that
>I'm tacaño(AKA cheap), and I'm looking for a free one.
>
>Thanks,
>Jared
>
>
>

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

RE: MS Access: True/False Questions

[Garza, Jeff]

Well, anything is an improvement over access. ;-)

You'll have to look into the documentation for MySQL.  There is a lot of
stuff that isn't supported SQL wise like transactions and the like, (too
much to get into here...) but it's getting better with each rev. from what
I've heard.  

You could also go to Slashdot for a completely "unbiased" view of MySQL vs.
SQL server... 

Good Luck!

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



-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 05, 2001 4:55 PM
To: CF-Talk
Subject: RE: MS Access: True/False Questions


> > You really shouldn't use MS Access with Cold Fusion... 
> (it's probably a
> > given that this is true, but with California State budget 
> cuts, it'll be a
> > while before we save up enough pennies to buy anything better)
> 
> What about MySQL?  It's still Free to my knowledge...  You 
> may want to look
> into this.

It'd be a hard sell for us.  The decision makers tend to cringe whenever
they can't add a $3000 support package.  Freeware is frowned upon, although
we did manage to get a Linux box to run WebCT.  

As it is, I think MS SQL is probably the forerunning candidate because the
name is recognized by the decision makers and they view it as having better
support.  

For the sake of argument though, MySQL is fairly robust?  A definite
improvement over Access?


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

RE: MS Access: True/False Questions

[Garza, Jeff]

> You really shouldn't use MS Access with Cold Fusion... (it's probably a
> given that this is true, but with California State budget cuts, it'll be a
> while before we save up enough pennies to buy anything better)

What about MySQL?  It's still Free to my knowledge...  You may want to look
into this.

> If you do use MS Access, you should set CF's threads to 1:  T/F?

No, we keep our threads normal...  Never had a problem.

> If you do use MS Access, and set the threads > 1, you risk corrupting your
> DB:  T/F?

Not that I know of.  There is a performance hit due to the fact that Access
uses table level locking during inserts/updates.  Also, it doesn't shrink
very well, so you can end up with some extremely bloated DB's over time
(compact and repair when you can...) but otherwise, it functions as
advertised.

HTH,

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

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

RE: NT Login?

[Garza, Jeff]

Using automatic authentication via IE doesn't supply a proper password to
pass along (the CGI.AUTH_PASSWORD var returns a null).  I think you'll be
stuck with a form based system to capture the password text.  

You could use HTTPS to encrypt the login transaction.  And if you use the
automatic login you can actually authenticate twice with one login. (one is
transparent, the second supplies the password for SQL Server.)  You could
then do a test query with a try/catch block to ensure that the password was
correct.  Hope this makes sense.

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



-Original Message-
From: Neil Ballantyne [mailto:[EMAIL PROTECTED]] 
Sent: Friday, November 30, 2001 8:35 AM
To: CF-Talk
Subject: RE: NT Login?


Has anyone ever tried to use the authentication information to connect
to SQL Server? I've only managed to do this previously by using a
form-based login, cfauthenticate to verify the details, and then storing
username and password in session variables to pass in to my queries
(datasource using trusted connections). 

Problems with this are:

a) Users must login twice
b) login details are sent plain text
c) anyone with access to the CF server could easily capture the login
details

--
neil


-Original Message-----
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: 30 November 2001 14:47
To: CF-Talk
Subject: RE: NT Login?


Yes, if you are using Internet Explorer and your site is defined within
the
security context of Intranet Zone, IE will automatically send the
username/password without a prompt.  This is, I believe, a default on
IE.
You might have to tweak your registry settings companywide if this is
not
enabled.  

Cheers,

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



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent: Friday, November 30, 2001 7:04 AM
To: CF-Talk
Subject: RE: NT Login?


But can I access this without havinga NT login window pop up?

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 9:07 AM
To: CF-Talk
Subject: RE: NT Login?


It seems to be CGI.AUTH_USER.

Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, November 30, 2001 8:52 AM
> To: CF-Talk
> Subject: NT Login?
> 
> 
> Is there a way for Coldfusion to grab the NT login info of 
> the user who is
> logged into the machine on out intranet?  Basically I want 
> the ability to
> display the users name on our intranet without having them login.
> 
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
> 




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

RE: NT Login?

[Garza, Jeff]

Yes, if you are using Internet Explorer and your site is defined within the
security context of Intranet Zone, IE will automatically send the
username/password without a prompt.  This is, I believe, a default on IE.
You might have to tweak your registry settings companywide if this is not
enabled.  

Cheers,

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



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent: Friday, November 30, 2001 7:04 AM
To: CF-Talk
Subject: RE: NT Login?


But can I access this without havinga NT login window pop up?

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 9:07 AM
To: CF-Talk
Subject: RE: NT Login?


It seems to be CGI.AUTH_USER.

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, November 30, 2001 8:52 AM
> To: CF-Talk
> Subject: NT Login?
> 
> 
> Is there a way for Coldfusion to grab the NT login info of 
> the user who is
> logged into the machine on out intranet?  Basically I want 
> the ability to
> display the users name on our intranet without having them login.
> 
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
> 


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

RE: Posting forms via email to cf servers

[Garza, Jeff]

Yes.  With the usual caveats of the user not enabling HTML in the browser in
which case you should have a web based version of the same form.  I've done
this with surveys before and it works well.  

Cheers,

Jeff Garza
Webmaster/Lead Developer
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: David Schmidt
To: CF-Talk
Sent: 11/29/01 8:57 PM
Subject: Posting forms via email to cf servers

Hi all.


It is possible to post html forms to a coldfusion page from an email
client
(Outlook & Outlook Express) using the post method and multipart
form/data
enctype.  My question is this... Are there any known caveats that are
email
client specific besides the possiblity of a client disabling html
messages?
I have an app that has an email component to it that sends forms to
users
and they can post back to the cf server, which does some data processing
and
pops up a browser window for them.

Thanks In Advance for any help.

Dave

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

RE: Verity - how to EXCLUDE a single file from the search?

[Garza, Jeff]

Liz,

Unfortunately on a shared host you are pretty much done...  

To effectively use the spider you'll need command line access as well as
full access to the CF Administrator.  Your best bet is to move it to an
outside directory or if it's just plain old HTML rename it as an .inc file
and CFINCLUDE it inside your nav page.  

When I've needed to do this in the past (and I was using 4.5) I would create
a ColdFusion Mapping (is this possible with your host?) and put all my
includes (header, footer, navigation) there.  That way I was really only
indexing the meat of the site.

Good Luck!

Jeff Garza
Webmaster/Lead Developer
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Les Mizzell
To: CF-Talk
Sent: 11/29/01 7:35 PM
Subject: Re: Verity - how to EXCLUDE a single file from the search?

> Les, can you change the file extension on this file to something that
won't get indexed?


I'm thinking of just moving the file in question to a directory outside
the
index parameters


Would be nice to know a way to do it when using the "CFCOLLECTION" tag
though

--
Les Mizzell
-
-
"People need to realize that every time
they mention about how "fragile" our
planet is, it's like asking outer-space
aliens to come invade us."
Jack Handey
-
-


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

RE: Verity - how to EXCLUDE a single file from the search?

[Garza, Jeff]

If you are using CF 5.0 the Verity Spider can do this.  You can configure it
to exclude any number of individual files based on name, path or regular
expression pattern matches.  Caveat is that it only works on the "Localhost"
address space.  So if you are using host header redirection on your
webserver you'll have to either assign localhost to that website or buy the
full spider...

Geesh... I'm starting to sound like the VSpider Zealot of the CF-Talk
List...  Am I that bad? ;^)

Anyway, I did a presentation for this earlier this year.  If any of you are
interested in the information, you can find the presentation, some related
Macromedia documentation (the Advanced CF5.0 Administration Guide in PDF
format -- has all the goodies on K2 and the Verity Spider) and some demo
batch files at http://www.spectrumastro.com/veritydemo/index.cfm

Enjoy,

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

-Original Message-
From: Les Mizzell
To: CF-Talk
Sent: 11/29/01 6:24 PM
Subject: Verity - how to EXCLUDE a single file from the search?

Title pretty much says it

I need to EXCLUDE a single file from a Verity index. Anybody got a good
way
to do this?

Basically, it's a framed site, and it's possible to pull up the
navigation
frame as one of the search results, since most of the main terms you'd
be
searching for exists in that frame!

--
Les Mizzell
-
-
"People need to realize that every time
they mention about how "fragile" our
planet is, it's like asking outer-space
aliens to come invade us."
Jack Handey
-
-


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

RE: CFFTP to upload a file from a form file statement?

[Garza, Jeff]

I host several sites at Crystaltech (www.crystaltech.com) with full CFFILE
capabilities.  They know how to properly configure advanced security so you
are truly limited to your own webspace and hence you get to use all the tags
most others restrict you from using.  You can get CF 5.0 starting with their
Plan I at 19.99 per month.

*** Not affiliated with CrystalTech, just a happy customer. ***

Jeff Garza

-Original Message-
From: Jeff Fongemie
To: CF-Talk
Sent: 11/25/01 11:51 AM
Subject: Re: CFFTP to upload a file from a form file statement?

 Hello cf-talk, On Sun, 25 Nov 2001, at 11:39:58 you carefully wrote:
GJ> CFFTP gives CFServer the ability to initiate a FTP session with a
FTP
GJ> service.  Unless your clients have a running FTP server this will
not work.
GJ> If you are running on a box that uses Windows2000 or NT4 Server you
might be
GJ> able to use the FileSystemObject (using ASP) to handle the upload.
GJ> Additionally, your ISP might have SA-FileUp or some similar COM
component
GJ> available to handle this...  You could probably instantiate this via
a
GJ> CFOBJECT call (unless they have that disabled as well which they
probably
GJ> do...)  Who is your ISP and what plan are you using?


Hi Jeff,

I'm using iqtinc.com.

I'm coming to the same conclusion on cfftp: not useful in my case.

They do offer ASP Upload, so I may take advantage of that. I just
don't like mixing the two. I'll probably just use the asp page in a
separate window since I'm using fusebox on this project.

I'd love to find a good host, not expensive, that includes cffile
enabled.


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
Internet Guns For Hire
(603) 356-0768

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

RE: CFFTP to upload a file from a form file statement?

[Garza, Jeff]

CFFTP gives CFServer the ability to initiate a FTP session with a FTP
service.  Unless your clients have a running FTP server this will not work.
If you are running on a box that uses Windows2000 or NT4 Server you might be
able to use the FileSystemObject (using ASP) to handle the upload.
Additionally, your ISP might have SA-FileUp or some similar COM component
available to handle this...  You could probably instantiate this via a
CFOBJECT call (unless they have that disabled as well which they probably
do...)  Who is your ISP and what plan are you using?

Jeff Garza
Webmaster/Lead Developer
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Jeff Fongemie
To: CF-Talk
Sent: 11/25/01 11:24 AM
Subject: CFFTP to upload a file from a form file statement?

 Hello cf-talk,


 I need to provide a user with the ability to upload a file via a
 browser ala-CFFILE. However, my ISP has cffile disabled.

 Some guys at the ISP told me there is a work around by using cfftp.

 They tell me I can use CFFTP to upload a file from a form file
 statement?

 Is this true, anyone do this? Anyone have a codesample they would
 would graciously share on this?
 


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
Internet Guns For Hire
(603) 356-0768

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

RE: SSL

[Garza, Jeff]

I believe that it's only valid for one FQDN.

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



-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 20, 2001 10:23 AM
To: CF-Talk
Subject: OT: SSL


Sorry for the OT question:

Is one SSL certificate valid for one whole domain, or is it valid only 
for one fully qualified domain name?

i.e., is it valid for *.mydomain.com, or only mysite.mydomain.com?


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

RE: Verity K2 anyone...

[Garza, Jeff]

There is a lot of documentation in the Advanced CF Administration guide
that's installed with CF5.0.  There are full chapters on Verity K2 and the
Verity Spider.  Unfortunately the interface for K2 within the CF
Administrator is very weak.  It's actually worse than their OLEDB
interface  

Anyway, dig into the docs and if you are still having problems, shoot me an
e-mail offlist.  I recently gave a presentation at the PhoenixCFUG on this
topic and I can give you a copy of it.

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



-Original Message-
From: Tage Widsell [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 20, 2001 4:16 AM
To: CF-Talk
Subject: Verity K2 anyone...


hi,

I just upgraded to CF 5 and I'm looking around at all the shiny new
features; One of them being the Verity K2 indexing server.

Has anyone tried using it? It looks a _lot_ more complicated than the Verity
indexing and searching in previous versions. The feature I really wanted to
use was the XML doc indexing.

What I'm wondering is if the K2 means a lot of overhead? Is it generally
hard to use and understand? Will there be conflicts with the old style (VDK)
searching and indexing?

Thanks
Tage Widsell
Webmaster
Propellerhead Software


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

RE: Access XP and CF?

[Garza, Jeff]

At least they finally got the default settings for text fields right...
Required= No and Allow Zero Length = Yes

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



-Original Message-
From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] 
Sent: Friday, November 16, 2001 7:02 AM
To: CF-Talk
Subject: Re: Access XP and CF?


access XP sux..
same thing it just doesnt let you open files on other networked drives..
they have to be on your local drive.
i would stick to Access and Office 2000.. XP is "buggy" too..
example..
if you open a doc file in word and then save it and try to open it in word
perfect
it wont work..
if you create a doc file and try to open it in word perfect it wont work..
some other random application crashes also makes it suck more..
i see no reall advantage on using any XP product over 2000 products.

- Original Message -
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 11:29 PM
Subject: Re: Access XP and CF?


> I talked to one developer who uploaded one of these and it worked fine; no
> problems yet (only two days live mind you) CF4.5
>
>
>
>
> > I just got a copy of Office XP Pro yesterday, which includes the new
> Access
> > XP.
> >
> > Is Access XP compatible with CF 4.5 sp2's ODBC *and* OLEDB drivers?
> Should
> > I leave XP off my development box and stick with Access 2k?  Any shared
> > experiences would be much appreciated.
> >
> > Thankfully I only have a very few sites still running it, but I have a
> bunch
> > of custom tags with Access in them that I have to keep up.
> >
> > Thx,
> >
> > -
> > Matt Robertson  [EMAIL PROTECTED]
> > MSB Designs, Inc. http://mysecretbase.com
> > -
> >
> 

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

RE: CFFILE

[Garza, Jeff]

Doh!!!  I forgot that's the one to use  I had originally put
Enctype="application/x-www-form-urlencoded"...

Sorry, my bad.

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



-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 15, 2001 9:27 AM
To: CF-Talk
Subject: RE: CFFILE


Make sure that your form tag has the following enctype

ENCTYPE="multipart/form-data"


HTH

Mike

-Original Message-
From: Steven Lancaster [mailto:[EMAIL PROTECTED]] 
Sent: 15 November 2001 16:02
To: CF-Talk
Subject: CFFILE


I don't understand I have on one page this:



On the action page I have this:



shouldn't this pass the directory for the file and upload it to the
server? What am I missing?

 Steven Lancaster
 WebMaster
 
 mailto:[EMAIL PROTECTED]

 http://www.corelab.com


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