Re: SQL Server 7.0 evaluation/developer's edition

2002-03-01 Thread Mike Alberts

I have a book called SQL The Complete Reference that came with a CD that has 
an evaluation version of SQL Server 7, as well as versions of Oracle, 
Informix, Sybase and DB2.

Osborne ISBN 0-07-211845-8

HTH

Mike


_
Send and receive Hotmail on your mobile device: http://mobile.msn.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: XML question

2002-03-01 Thread Aaron Rouse

Does anyone know of a online source with some examples of accessing WDDX
packets from within a VB application?  I know Forta's book has one example
of this and the SDK for WDDX has a little bit, but that is about all I have
been able to find. Like how it is www.openwddx.org now but the SDK points to
www.wddx.org still, sure does instill confidence in me.  ;)

Snipe - 


- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 6:32 PM
Subject: Re: XML question


> I have a funny feeling Rey knows all about wddx already ;-)
> It's openwddx.org now though.
>
> jon
> - Original Message -
> From: "Tim Stadinski" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 01, 2002 6:46 PM
> Subject: RE: XML question
>
>
> > wddx is just another form of an xml document.  you can reference the dtd
> for
> > wddx here: http://www.wddx.org
> >
> > i am not sure of your question though, they are two different sets of
> > technologies that have XML in common.
> >
> > cheers,
> > Timothy Stadinski
> > Senior Software Engineer
> > Afternic.com
> > [EMAIL PROTECTED]
> >
> >
> >
> > -Original Message-
> > From: Rey Bango [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 28, 2002 11:40 PM
> > To: CF-Talk
> > Subject: Re: XML question
> >
> >
> > Andres,
> >
> > Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM
component
> > is a COM object which needs to be invoked using the CFOBJECT tag. The
WDDX
> > functionality is built into CF and there are defined tags for using it.
> >
> > HTH.
> >
> > Rey...
> >
>
> 
__
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: .NET co-Exist with CF Server

2002-03-01 Thread stas

Do you envision being it a $600 plug-in for VS .Net?


-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]] 


Just as a thought to throw out there, with so many other languages
porting over to .net, anyone see a ColdFusion.net in the future?
Granted it's not an open language and would take an initiative by
Macromedia (vs. languages such as Perl, Cobol, Python, etc. that are a
bit more "open").  Quite frankly tho, it might be nice to be able to
develop and debug ColdFusion and the CFX tags in a common environment.
Everyone's thoughts?

__
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: XML question

2002-03-01 Thread Jon Hall

I have a funny feeling Rey knows all about wddx already ;-)
It's openwddx.org now though.

jon
- Original Message -
From: "Tim Stadinski" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 6:46 PM
Subject: RE: XML question


> wddx is just another form of an xml document.  you can reference the dtd
for
> wddx here: http://www.wddx.org
>
> i am not sure of your question though, they are two different sets of
> technologies that have XML in common.
>
> cheers,
> Timothy Stadinski
> Senior Software Engineer
> Afternic.com
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 28, 2002 11:40 PM
> To: CF-Talk
> Subject: Re: XML question
>
>
> Andres,
>
> Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component
> is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX
> functionality is built into CF and there are defined tags for using it.
>
> HTH.
>
> Rey...
>

__
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: Any other way to look at datasources?

2002-03-01 Thread Scott Van Vliet

Well, if you access to use , you can look at the datasources
entered through the ColdFusion Administrator:



Then just output the dsnQuery query to view the DSNs.

NOTE that these reg keys only hold the ColdFusion data for each
datasource.  This might not be what you are looking for, but might steer
you in the right direction. HTH.



-Original Message-
From: bajaria aslam [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 1:56 PM
To: CF-Talk
Subject: Any other way to look at datasources?

Hi All.
I know that you can see the datasource names and the
servers they are pointing to in cfadmin. But, is there
another way to find the list of datasources and the
servers they point to?


Also, even in cfadmin, we can just see the datasource
name, but until we don't click on the the datsource
name link, we don't know the server it is pointing to.
All we know is if it is a MS Access Driver datasource
or a SQL Server datasource etc. So, if there is
another way to look at the datasources, that would be
nice.

Thanks All




__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!

__
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: Regular Expression Help

2002-03-01 Thread Matthew Walker

Or you could use ListReplace with " " as the delimiter -- as long as you
force everything lower case first.

- Original Message -
From: "Jared Stark" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 10:10 AM
Subject: Regular Expression Help


> Hello all.  I am trying to write a simple search engine, and would like
> to replace certain commonly used prepositions from the search string
> such as 'a','the','for', etc...
>
> I have an array of the prepositions that I would like to remove, howeve
r
> the problem I have is that it is removing them when they are subsets of
> other words, for example 'them' would become 'm' when removing 'the',
> 'bag' would become 'bg' when removing 'a', etc...
>
> I'm not an expert at regular expression, but I'm assuming it is possibl
e
> to remove only those instances where the prepositions are stand-alone
> and not subsets of other words.  Could someone render me some
> assistance?
>
> Much thanks,
> Jared
>
> 
__
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: XML question

2002-03-01 Thread Tim Stadinski

wddx is just another form of an xml document.  you can reference the dtd for
wddx here: http://www.wddx.org

i am not sure of your question though, they are two different sets of
technologies that have XML in common.

cheers,
Timothy Stadinski
Senior Software Engineer
Afternic.com
[EMAIL PROTECTED] 



-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 11:40 PM
To: CF-Talk
Subject: Re: XML question


Andres,

Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component
is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX
functionality is built into CF and there are defined tags for using it.

HTH.

Rey...

- Original Message -
From: "Andres" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 11:34 PM
Subject: RE: XML question


> Jon,
> Thank you for your help on this.
>
> Do you know if msxml will somehow affect CF's wddx implementation? i dont
know if the two relate to each other... but i am using wddx to export some
data to other systems, and dont want to interfere with those elements.
>
> Thanks!
>
> Andres
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Thu 2/28/2002 8:45 PM
> To: CF-Talk
> Cc:
> Subject: Re: XML question
>
>
>
> I'd bet that it's same the problem I ran into when using MSXML via
> cfobject to grab the UPS XML, which is essentially what soxml does.
> CFObject apparently doesn't understand the nulls that MSXML passes back
> when an XML element is empty, and bombs. If you are running an older
> version of msxml you may want to upgrade it as 4.0 is out, that may fix
> some problems, as 4.0 is the first solid release imo.
>
> Have you tried the cf_usps tag? It handles pretty much everything for you.
>
http://devex.macromedia.com/developer/gallery/info.cfm?ID=9C9C2AB9-7F93-11D5
-83F300508B94F85A&method=Full
>
> If you want to do it via soxml here is a real simple custom tag sample
> that I did that just returns the country information that usps passes
> back. Expanding upon this to do full rates would be pretty easy, but
> that's what the above tag goes anyway...
>
> 
> 
> 
>
> 
> services = 'PACKAGE';
> APIstr = 'IntlRate';
> XMLstr = ' PASSWORD="#attributes.password#">';
>
> XMLstr = XMLstr & '
> 0
> 1
> Package
> #Attributes.country#
> ';
> XMLstr = XMLstr & '';
> 
>
>
>  URL="#attributes.server#?API=#APIstr#&XML=#urlencodedformat(XMLstr)#"
> method="GET" resolveurl="false" timeout="45">
> 
>
> action="XML2CF"
>input="#xmlResp#"
>output="countryData"
>type="Variables"
> >
> 
>
>
> jon
>
> ps For anyone who cares, FEDEX is finally planning on releasing an XML
> API withing the next two months. It's already been delayed once from Q4
> 2001 though, so I'm not getting my hopes up though.
>
> Andres wrote:
> > This a rather long email...
> >
> > i am trying to query the USPS international rate calculator via their
> > API. Their response is an XML document which i am parsing via SOXML.
> > This is a great tool!
> >
> 
> >
> > CF throws an error saying that it cannot resolve the parameter
> > outhere.IntlRateResponse.Service. Even though this does exist and indeed
> > is to be an array since there are two of them.
> >
> > Any help would be much appreciated!
> >
> > Thank you
> >
>
>
>
> 

__
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: Bug Tracking Systems

2002-03-01 Thread Tim Stadinski

err...you might want to dereference the session collection first and 
lock
this call, otherwise you get instability issues.  kinda like this:



mySession = structnew();
mySession = duplicate(session); 



then loop through the collection called 'mySession'.

my2bits

Timothy Stadinski
Senior Software Engineer
Afternic.com
[EMAIL PROTECTED] 


-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 6:21 PM
To: CF-Talk
Subject: RE: Bug Tracking Systems


Very easy...  The easiest thing to do is parse the logs, but that's a 
pain. 

In cf server, you can set a global error handling template. Here's the 
code
because it's Friday and I feel like giving back:


YAY!  Free Code!








An Error Occurred In Cold Fusion.
User Info:
#form.UserInput#
System info:
#form.debuginfo#











Oops, an error has
occurredPlease provide us info and click 
SUBMIT.



Debugging Info (Appdev Only):


visibility: hidden">
Browser:#Error.Browser#
Remote Address: #Error.RemoteAddress#

Error:#Error.Diagnostics#

Template: #Error.Template#
Query String: #Error.QueryString#

Variables:






SESSION.#myVar##evaluate("session." &
"#myvar#")#









FORM.#myVar2##evaluate("form." &
"#myvar2#")#

















-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 27, 2002 7:13 PM
To: CF-Talk
Subject: Bug Tracking Systems


Hi all,
I'm thinking about offering a bug tracking system for our clients
(during 
testing stages of course, I'd never have a bug in a production system 
:-)) 
for the various jobs they have running with us (i.e we'd have a number 
of 
projects with each client that they can open bugs with, but each client 
may 
not see another clients projects or bugs).

Before I invest energy into reinventing the wheel, does anybody know of 
any 
bug tracking systems written in CF that I might be able to massage to 
fit 
my needs ?

---
James Sleeman


__
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: Any other way to look at datasources?

2002-03-01 Thread Fred Jambukeswaran

If you feel like being risky and using undocumented functions theres:

CFUSION_GETODBCDSN()

see macromedia's article on the undocumented functions / tags

http://www.macromedia.com/v1/handlers/index.cfm?ID=11714&Method=Full


-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 6:06 PM
To: CF-Talk
Subject: RE: Any other way to look at datasources?


CF_Datasource will give you a list of datasources on the server...
http://www.cfdev.com/products free encrypted version.

+
Pete Freitag ([EMAIL PROTECTED])
CTO, CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 5:02 PM
To: CF-Talk
Subject: Re: Any other way to look at datasources?


Control Panel>ODBC Settings

Regards,

Howie

- Original Message -
From: "bajaria aslam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 4:55 PM
Subject: Any other way to look at datasources?


> Hi All.
> I know that you can see the datasource names and the
> servers they are pointing to in cfadmin. But, is there
> another way to find the list of datasources and the
> servers they point to?
>

>
> Also, even in cfadmin, we can just see the datasource
> name, but until we don't click on the the datsource
> name link, we don't know the server it is pointing to.
> All we know is if it is a MS Access Driver datasource
> or a SQL Server datasource etc. So, if there is
> another way to look at the datasources, that would be
> nice.
>
> Thanks All
>
>
>
>
> __
> Do You Yahoo!?
> Yahoo! Greetings - Send FREE e-cards for every occasion!
>


__
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: Attaching CSS style sheet

2002-03-01 Thread Costas Piliotis

I think you also need a  tag in ther, but I'm not
sure...  

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 1:52 PM
To: CF-Talk
Subject: RE: Attaching CSS style sheet 


> If you are trying to dynamically assign a style sheet for
> each page, you could do the following:
> 
> 
> 
> Title
>type="text/css">
> 
> 
> ..
> 
> 
> 
> Them, in your styles.cfm page, you could have:
> 
> 
> 
> 
> 
> 
> 
>  ...

In general, if you can avoid dynamically generating style sheets (just like
anything else), you'll get better performance, since the browser will cache
them, and won't have to refetch them. I'd recommend that you organize your
styles in such a way that you don't reuse style identifiers, or if you do,
you use the "cascading" part of the standard to override the styles attached
to certain identifiers.

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

__
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: Bug Tracking Systems

2002-03-01 Thread Costas Piliotis

Very easy...  The easiest thing to do is parse the logs, but that's a pain. 

In cf server, you can set a global error handling template. Here's the code
because it's Friday and I feel like giving back:


YAY!  Free Code!








An Error Occurred In Cold Fusion.
User Info:
#form.UserInput#
System info:
#form.debuginfo#











Oops, an error has
occurredPlease provide us info and click SUBMIT.



Debugging Info (Appdev Only):


visibility: hidden">
Browser:#Error.Browser#
Remote Address: #Error.RemoteAddress#

Error:#Error.Diagnostics#

Template: #Error.Template#
Query String: #Error.QueryString#

Variables:






SESSION.#myVar##evaluate("session." &
"#myvar#")#









FORM.#myVar2##evaluate("form." &
"#myvar2#")#

















-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 27, 2002 7:13 PM
To: CF-Talk
Subject: Bug Tracking Systems


Hi all,
I'm thinking about offering a bug tracking system for our clients
(during 
testing stages of course, I'd never have a bug in a production system :-)) 
for the various jobs they have running with us (i.e we'd have a number of 
projects with each client that they can open bugs with, but each client may 
not see another clients projects or bugs).

Before I invest energy into reinventing the wheel, does anybody know of any 
bug tracking systems written in CF that I might be able to massage to fit 
my needs ?

---
James Sleeman

__
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: PHPConfig

2002-03-01 Thread Costas Piliotis

Yeah...  I think it's called notepad

:-)

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 7:50 AM
To: CF-Talk
Subject: RE: PHPConfig


There wouldn't happen to be one of those to edit apache? That's the only
thing that stops me from using it. Don't have the time to really sit there
and do it. One of these days I will.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 10:15 AM
To: CF-Talk
Subject: PHPConfig


I know some of us CFers still must code in other languages, and I found 
this little jewel for editing the PHP.ini

http://www.analogx.com/contents/download/network/phpconf.htm








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



Doug Brown



__
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: Any other way to look at datasources?

2002-03-01 Thread Pete Freitag

CF_Datasource will give you a list of datasources on the server...
http://www.cfdev.com/products free encrypted version.

+
Pete Freitag ([EMAIL PROTECTED])
CTO, CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 5:02 PM
To: CF-Talk
Subject: Re: Any other way to look at datasources?


Control Panel>ODBC Settings

Regards,

Howie

- Original Message -
From: "bajaria aslam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 4:55 PM
Subject: Any other way to look at datasources?


> Hi All.
> I know that you can see the datasource names and the
> servers they are pointing to in cfadmin. But, is there
> another way to find the list of datasources and the
> servers they point to?
>

>
> Also, even in cfadmin, we can just see the datasource
> name, but until we don't click on the the datsource
> name link, we don't know the server it is pointing to.
> All we know is if it is a MS Access Driver datasource
> or a SQL Server datasource etc. So, if there is
> another way to look at the datasources, that would be
> nice.
>
> Thanks All
>
>
>
>
> __
> Do You Yahoo!?
> Yahoo! Greetings - Send FREE e-cards for every occasion!
>

__
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: assigning a value to a dynamic variable?

2002-03-01 Thread Joseph Thompson

Or..

SetVariable(Show,'alUsers');

> > change:
> > 
> > to:
> > 
> >
> >
> > - Original Message -
> > From: "Raymond Camden" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, March 01, 2002 2:36 PM
> > Subject: RE: assigning a value to a dynamic variable?
> >
> >
> > | To set a dynamic variable, use setVariable:
> > |
> > | 
> > | 
> > |
> > | You will still need evaluate to display it though.
> > |> |

> > | Raymond Camden, Principal Spectra Compliance Engineer for Macromedi
> a
> > |
> > | Email: [EMAIL PROTECTED]
> > | Yahoo IM : morpheus
> > |
> > | "My ally is the Force, and a powerful ally it is." - Yoda
> > |
> > | > -Original Message-
> > | > From: Louis Klepner [mailto:[EMAIL PROTECTED]]
> > | > Sent: Friday, March 01, 2002 4:34 PM
> > | > To: CF-Talk
> > | > Subject: assigning a value to a dynamic variable?
> > | >
> > | >
> > | > Can someone help me make this work?
> > | > I'm not sure how to explain it clearly, so I'm hoping the
> > | > code/comments make
> > | > sense...
> > | >
> > | > 
> > | > 
> > | >
> > | > 
> > | > 
> > | >
> > | > 
> > | > 
> > | > first variable: #show#
> > | > variable's variable: #evaluate('#show#')#
> > | > 
> > | >
> > | >
> > | >
> > | >
> > |
> > _
> _
> > 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
> >
> 
__
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: Any other way to look at datasources?

2002-03-01 Thread Howie Hamlin

Control Panel>ODBC Settings

Regards,

Howie

- Original Message -
From: "bajaria aslam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 4:55 PM
Subject: Any other way to look at datasources?


> Hi All.
> I know that you can see the datasource names and the
> servers they are pointing to in cfadmin. But, is there
> another way to find the list of datasources and the
> servers they point to?
>

>
> Also, even in cfadmin, we can just see the datasource
> name, but until we don't click on the the datsource
> name link, we don't know the server it is pointing to.
> All we know is if it is a MS Access Driver datasource
> or a SQL Server datasource etc. So, if there is
> another way to look at the datasources, that would be
> nice.
>
> Thanks All
>
>
>
>
> __
> Do You Yahoo!?
> Yahoo! Greetings - Send FREE e-cards for every occasion!
> 
__
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: Any other way to look at datasources?

2002-03-01 Thread Paul Giesenhagen

The servers registry holds all of the datasource information for the
CFAdmin, you can see it in there .. but it doesn't give the server
information...

Software/allaire/datasources

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


- Original Message -
From: "bajaria aslam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 3:55 PM
Subject: Any other way to look at datasources?


> Hi All.
> I know that you can see the datasource names and the
> servers they are pointing to in cfadmin. But, is there
> another way to find the list of datasources and the
> servers they point to?
>
>
> Also, even in cfadmin, we can just see the datasource
> name, but until we don't click on the the datsource
> name link, we don't know the server it is pointing to.
> All we know is if it is a MS Access Driver datasource
> or a SQL Server datasource etc. So, if there is
> another way to look at the datasources, that would be
> nice.
>
> Thanks All
>
>
>
>
> __
> Do You Yahoo!?
> Yahoo! Greetings - Send FREE e-cards for every occasion!
> 
__
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



Any other way to look at datasources?

2002-03-01 Thread bajaria aslam

Hi All.
I know that you can see the datasource names and the
servers they are pointing to in cfadmin. But, is there
another way to find the list of datasources and the
servers they point to?


Also, even in cfadmin, we can just see the datasource
name, but until we don't click on the the datsource
name link, we don't know the server it is pointing to.
All we know is if it is a MS Access Driver datasource
or a SQL Server datasource etc. So, if there is
another way to look at the datasources, that would be
nice.

Thanks All




__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
__
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



Any other way to look at datasources?

2002-03-01 Thread bajaria aslam

Hi All.
I know that you can see the datasource names and the
servers they are pointing to in cfadmin. But, is there
another way to find the list of datasources and the
servers they point to?


Also, even in cfadmin, we can just see the datasource
name, but until we don't click on the the datsource
name link, we don't know the server it is pointing to.
All we know is if it is a MS Access Driver datasource
or a SQL Server datasource etc. So, if there is
another way to look at the datasources, that would be
nice.

Thanks All




__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
__
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: Regular Expression Help

2002-03-01 Thread Shawn Grover

Going from limited memory of the subject here, but try something like this:

[\w the|a|..] (the 'the|a|..' part would be your preposition
list...)

I think the \w means you are looking for whole words.  Or it might be \W...

Hope that helps some...

Shawn Grover


-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:11 PM
To: CF-Talk
Subject: Regular Expression Help


Hello all.  I am trying to write a simple search engine, and would like
to replace certain commonly used prepositions from the search string
such as 'a','the','for', etc...

I have an array of the prepositions that I would like to remove, however
the problem I have is that it is removing them when they are subsets of
other words, for example 'them' would become 'm' when removing 'the',
'bag' would become 'bg' when removing 'a', etc...

I'm not an expert at regular expression, but I'm assuming it is possible
to remove only those instances where the prepositions are stand-alone
and not subsets of other words.  Could someone render me some
assistance?

Much thanks,
Jared


__
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: assigning a value to a dynamic variable?

2002-03-01 Thread Louis Klepner

Okay, that works too- and it's a little shorter... I like it-
Thanks!

>
> Actually, there is a shorthand for this:
>
> change:
> 
> to:
> 
>
>
> - Original Message -
> From: "Raymond Camden" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 01, 2002 2:36 PM
> Subject: RE: assigning a value to a dynamic variable?
>
>
> | To set a dynamic variable, use setVariable:
> |
> | 
> | 
> |
> | You will still need evaluate to display it though.
> |> | 
> | Raymond Camden, Principal Spectra Compliance Engineer for Macromedi
a
> |
> | Email: [EMAIL PROTECTED]
> | Yahoo IM : morpheus
> |
> | "My ally is the Force, and a powerful ally it is." - Yoda
> |
> | > -Original Message-
> | > From: Louis Klepner [mailto:[EMAIL PROTECTED]]
> | > Sent: Friday, March 01, 2002 4:34 PM
> | > To: CF-Talk
> | > Subject: assigning a value to a dynamic variable?
> | >
> | >
> | > Can someone help me make this work?
> | > I'm not sure how to explain it clearly, so I'm hoping the
> | > code/comments make
> | > sense...
> | >
> | > 
> | > 
> | >
> | > 
> | > 
> | >
> | > 
> | > 
> | > first variable: #show#
> | > variable's variable: #evaluate('#show#')#
> | > 
> | >
> | >
> | >
> | >
> |
> _
_
> 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
>
__
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: Attaching CSS style sheet

2002-03-01 Thread Dave Watts

> If you are trying to dynamically assign a style sheet for 
> each page, you could do the following:
> 
> 
> 
> Title
>type="text/css">
> 
> 
> ..
> 
> 
> 
> Them, in your styles.cfm page, you could have:
> 
> 
> 
> 
> 
> 
> 
>  ...

In general, if you can avoid dynamically generating style sheets (just like
anything else), you'll get better performance, since the browser will cache
them, and won't have to refetch them. I'd recommend that you organize your
styles in such a way that you don't reuse style identifiers, or if you do,
you use the "cascading" part of the standard to override the styles attached
to certain identifiers.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
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: assigning a value to a dynamic variable?

2002-03-01 Thread Louis Klepner

Ahh-  Very good! Thank you!

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Raymond
> Camden
> Sent: Friday, March 01, 2002 4:37 PM
> To: CF-Talk
> Subject: RE: assigning a value to a dynamic variable?
>
>
> To set a dynamic variable, use setVariable:
>
> 
> 
>
> You will still need evaluate to display it though.
>> 
> 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: Louis Klepner [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 01, 2002 4:34 PM
> > To: CF-Talk
> > Subject: assigning a value to a dynamic variable?
> >
> >
> > Can someone help me make this work?
> > I'm not sure how to explain it clearly, so I'm hoping the
> > code/comments make
> > sense...
> >
> > 
> > 
> >
> > 
> > 
> >
> > 
> > 
> > first variable: #show#
> > variable's variable: #evaluate('#show#')#
> > 
> >
> >
> >
> >
> _
_
> 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
>
__
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: assigning a value to a dynamic variable?

2002-03-01 Thread Jared Stark

Actually, there is a shorthand for this:

change:

to:



- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 2:36 PM
Subject: RE: assigning a value to a dynamic variable?


| To set a dynamic variable, use setVariable:
|
| 
| 
|
| You will still need evaluate to display it though.
|
| ===
| 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: Louis Klepner [mailto:[EMAIL PROTECTED]]
| > Sent: Friday, March 01, 2002 4:34 PM
| > To: CF-Talk
| > Subject: assigning a value to a dynamic variable?
| >
| >
| > Can someone help me make this work?
| > I'm not sure how to explain it clearly, so I'm hoping the
| > code/comments make
| > sense...
| >
| > 
| > 
| >
| > 
| > 
| >
| > 
| > 
| > first variable: #show#
| > variable's variable: #evaluate('#show#')#
| > 
| >
| >
| >
| >
| 
__
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: Attaching CSS style sheet

2002-03-01 Thread Dave Watts

> | > What's the problem with referencing the stylesheet in the
> | > application.cfm file? I have done this on several websites 
> | > and never seen a problem before.
> | > 
> | > Here's the code I use:
> | > 
> | > 
> | > 
> | > Is there an issue with doing it this way?
> | 
> | Not really, except from an HTML validation point of view. The 
> | LINK tag should be placed within the document head, not 
> | before the entire HTML document, which is typically where it 
> | would be if you put it in via Application.cfm.
>
> So wouldn't it be simple then to assign a var from the 
> application.cfm file to the "HREF=" name?
> 
> I.e., 
> 
>  HREF="#varfromapplicationfile#">

Yes, that would work fine.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
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: assigning a value to a dynamic variable?

2002-03-01 Thread Raymond Camden

To set a dynamic variable, use setVariable:




You will still need evaluate to display it though.

===
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: Louis Klepner [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, March 01, 2002 4:34 PM
> To: CF-Talk
> Subject: assigning a value to a dynamic variable?
> 
> 
> Can someone help me make this work?
> I'm not sure how to explain it clearly, so I'm hoping the 
> code/comments make
> sense...
> 
> 
> 
> 
> 
> 
> 
> 
> 
> first variable: #show#
> variable's variable: #evaluate('#show#')#
> 
> 
> 
> 
> 
__
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: Attaching CSS style sheet

2002-03-01 Thread Scott Van Vliet

If you are trying to dynamically assign a style sheet for each page, you
could do the following:



Title



..



Them, in your styles.cfm page, you could have:










body { font-family: Verdana; font-size: 11px; }
input { font-family: Arial; font-size: 12px; color:
#33; }


...




NOT TESTED, but it should work. HTH

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 28, 2002 6:24 PM
To: CF-Talk
Subject: Attaching CSS style sheet 

How does one call a CSS from the application.cfm file.  I've
 tried 
the following two methods with no effect:

1) 
2) 

The Css directory is under the application.cfm file.

Thanks for your help.

Mark

-- 
Mark Leder, [EMAIL PROTECTED] on 02/28/2002


__
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



assigning a value to a dynamic variable?

2002-03-01 Thread Louis Klepner

Can someone help me make this work?
I'm not sure how to explain it clearly, so I'm hoping the code/comments make
sense...









first variable: #show#
variable's variable: #evaluate('#show#')#




__
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



Regular Expression Help

2002-03-01 Thread Jared Stark

Hello all.  I am trying to write a simple search engine, and would like 
to replace certain commonly used prepositions from the search string 
such as 'a','the','for', etc...

I have an array of the prepositions that I would like to remove, however 
the problem I have is that it is removing them when they are subsets of 
other words, for example 'them' would become 'm' when removing 'the', 
'bag' would become 'bg' when removing 'a', etc...  

I'm not an expert at regular expression, but I'm assuming it is possible 
to remove only those instances where the prepositions are stand-alone 
and not subsets of other words.  Could someone render me some 
assistance?

Much thanks,
Jared

__
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: page up/down

2002-03-01 Thread Jared Stark

I've written a custom tag that does that, and is fairly customizable.  I
just wrote it for in house use so it isn't anything special, but you are
more than welcome to the code and you can change it however you'd like.
Contact me off list if you'd like me to send it to you.

Jared
[EMAIL PROTECTED]

- Original Message -
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 12:52 PM
Subject: page up/down


| Hello,
|
| I know this has been asked 1000's of times, but I lost the code: Anyone
| have a simple Page Up/Page Down CF code. I want to insert it into a
| display page to have it display fivce records at a time.
|
| Many thanks for all the help!
|
| 
__
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: Attaching CSS style sheet

2002-03-01 Thread Lee Fuller

So wouldn't it be simple then to assign a var from the application.cfm
file to the "HREF=" name?

I.e., 





| -Original Message-
| From: Dave Watts [mailto:[EMAIL PROTECTED]] 
| Sent: Friday, March 01, 2002 1:16 PM
| To: CF-Talk
| Subject: RE: Attaching CSS style sheet 
| 
| 
| > What's the problem with referencing the stylesheet in the
| > application.cfm file? I have done this on several websites 
| > and never seen a problem before.
| > 
| > Here's the code I use:
| > 
| > 
| > 
| > Is there an issue with doing it this way?
| 
| Not really, except from an HTML validation point of view. The 
| LINK tag should be placed within the document head, not 
| before the entire HTML document, which is typically where it 
| would be if you put it in via Application.cfm.
| 
| Dave Watts, CTO, Fig Leaf Software
| http://www.figleaf.com/
| voice: (202) 797-5496
| fax: (202) 797-5444 
| 
__
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: mulitple SQL statements and passing values

2002-03-01 Thread Douglas Jordon

Yes, that worked. Thank you.

Douglas Brown wrote:
> You might be able to do something like so, never tried it.
> 
> 
> declare @this_id int
> begin
> select @this_id = (id)
> from your table
> end
> 
> 
> insert into table2 (tablerow)
> values (@this_id)
> 
> 
> 
> 
> "Success is a journey, not a destination!!"
> 
> 
> 
> Doug Brown
> - Original Message - 
> From: "Douglas Jordon" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 01, 2002 10:47 AM
> Subject: mulitple SQL statements and passing values
> 
> 
> 
>>Hi,
>>
>>If I want to query a table for an id and then save that id to another 
>>table, can I do it in the same SQL statement? If so, how do I refer to 
>>
> 
>>the value from the first select? It's something like this:
>>
>>
>>
>>select id from table_1
>>insert into table_2(table_1_id)values(the_id_ just queried)
>>
>>
>>
>>TIA,
>>
>>Doug Jordon
>>
>>
> 
__
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: page up/down

2002-03-01 Thread Paul Giesenhagen

Glad it worked for you ...

We haven't updated QD Next in awhile .. it could probably use a few tweaks
..

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

- Original Message -
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 3:04 PM
Subject: RE: page up/down


> Thank you. Works fine.
>
> Robert O.
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 01, 2002 3:01 PM
> To: CF-Talk
> Subject: Re: page up/down
>
>
> You can download our QDNext for free:
>
> http://www.quilldesign.com
>
> It allows for next/previous and page series's as well ..
>
> It's also free!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector - Commerce Builder
>
> - Original Message -
> From: "Robert Orlini" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 01, 2002 1:52 PM
> Subject: page up/down
>
>
> > Hello,
> >
> > I know this has been asked 1000's of times, but I lost the code:
> Anyone
> > have a simple Page Up/Page Down CF code. I want to insert it into a
> > display page to have it display fivce records at a time.
> >
> > Many thanks for all the help!
> >
> >
>
> 
__
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: page up/down

2002-03-01 Thread Robert Orlini

Thank you. Works fine.

Robert O.

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 3:01 PM
To: CF-Talk
Subject: Re: page up/down


You can download our QDNext for free:

http://www.quilldesign.com

It allows for next/previous and page series's as well ..

It's also free!

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

- Original Message -
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 1:52 PM
Subject: page up/down


> Hello,
>
> I know this has been asked 1000's of times, but I lost the code: 
Anyone
> have a simple Page Up/Page Down CF code. I want to insert it into a
> display page to have it display fivce records at a time.
>
> Many thanks for all the help!
>
> 

__
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: Attaching CSS style sheet

2002-03-01 Thread Dave Watts

> What's the problem with referencing the stylesheet in the 
> application.cfm file? I have done this on several websites 
> and never seen a problem before.
> 
> Here's the code I use:
> 
> 
> 
> Is there an issue with doing it this way?

Not really, except from an HTML validation point of view. The LINK tag
should be placed within the document head, not before the entire HTML
document, which is typically where it would be if you put it in via
Application.cfm.

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: Flash Connector Kit issues

2002-03-01 Thread Simon Horwith

it also happens when you simply pass too much data to a FLASH control.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion 5 Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 4:01 PM
To: CF-Talk
Subject: Re: Flash Connector Kit issues


I'm just trying to get the examples that come with the connector kit
working.  Please tell me that
Macromedia didn't ship broken examples.

I'm brand spankin new to this, so if you have something a tad more 
detailed
to look for in the
ActionScript I'd be very grateful.

>From what I've found so far a lot of people have had this same issue, 
but
none of the forums have
shown how to deal with it.

HELP!!! ;-)

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

- Original Message -
From: "Scott Van Vliet" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 12:38 PM
Subject: RE: Flash Connector Kit issues


> This usually happens when you have an infinite loop in the Flash 
Player.
> Check you ActionScript to verify that you are not hanging up while
> trying to connect to the server.
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 01, 2002 10:06 AM
> To: CF-Talk
> Subject: Flash Connector Kit issues
>
> Hi All,
>
> I'm trying to get the Flash Connector Kit examples to run and I'm 
having
> some problems.
>
> I've changed the path from localhost to the domain I'm hosting in the
> Flash ActionScripts of the
> examples and that works fine.  I can browse to the greeting
> exampletype in my name...hit "try
> it"and then I get.
>
> "A script in this movie is causing Flash Player to run slowly.  If it
> continues to run, your
> computer may become unresponsive.  Do you want to abort the script?"
>
> Anybody else run across this one?
>
> 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
>
> 

__
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: Attaching CSS style sheet

2002-03-01 Thread WebMaster

What's the problem with referencing the stylesheet in the application.cfm 
file? I have done this on several websites and never seen a problem before.

Here's the code I use:



Is there an issue with doing it this way?

Thanks,

Mike


At 2/28/2002 09:46 PM, you wrote:
>I'm not sure, but I agree that the header.cfm is the way to go.
>
>_
>steve oliver
>senior internet developer
>atnet solutions, inc.
>http://www.atnetsolutions.com
>
>
>-Original Message-
>From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, February 28, 2002 9:39 PM
>To: CF-Talk
>Subject: Re: Attaching CSS style sheet
>
>
>Steve,
>
>Wouldn't the  in the application.cfm file place two headers
>o
>n
>each page?
>
>It would seem the best would be to create a header.cfm file that
>included
>information like stylesheets, and other repetitive information.
>
>Paul Giesenhagen
>QuillDesign
>http://www.quilldesign.com
>SiteDirector - Commerce Builder
>
>- Original Message -
>From: "Steve Oliver" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, February 28, 2002 8:35 PM
>Subject: RE: Attaching CSS style sheet
>
>
> > The first one should work, but I don't think your supposed to include
> > html or scripts in the application.cfm.
> >
> > If you need something like that make a header.cfm and cfinclude it in
> > your documents.
> >
> > I believe it has to be in the  of the page also.
> >
> >
> > But if you really need it in your application.cfm, you could try
> > something like this:
> >
> >  > type=""text/css"">">
> >
> >
> > _
> > steve oliver
> > senior internet developer
> > atnet solutions, inc.
> > http://www.atnetsolutions.com
> >
> >
> > -Original Message-
> > From: Mark Leder [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 28, 2002 9:24 PM
> > To: CF-Talk
> > Subject: Attaching CSS style sheet
> >
> >
> > How does one call a CSS from the application.cfm file.  I've
> >  tried
> > the following two methods with no effect:
> >
> > 1) 
> > 2) 
> >
> > The Css directory is under the application.cfm file.
> >
> > Thanks for your help.
> >
> > Mark
> >
> > --
> > Mark Leder, [EMAIL PROTECTED] on 02/28/2002
> >
> >
> >
>
>
__
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: Flash Connector Kit issues

2002-03-01 Thread Bryan Stevenson

I'm just trying to get the examples that come with the connector kit working.  Please 
tell me that
Macromedia didn't ship broken examples.

I'm brand spankin new to this, so if you have something a tad more detailed to look 
for in the
ActionScript I'd be very grateful.

>From what I've found so far a lot of people have had this same issue, but none of the 
>forums have
shown how to deal with it.

HELP!!! ;-)

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

- Original Message -
From: "Scott Van Vliet" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 12:38 PM
Subject: RE: Flash Connector Kit issues


> This usually happens when you have an infinite loop in the Flash Player.
> Check you ActionScript to verify that you are not hanging up while
> trying to connect to the server.
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 01, 2002 10:06 AM
> To: CF-Talk
> Subject: Flash Connector Kit issues
>
> Hi All,
>
> I'm trying to get the Flash Connector Kit examples to run and I'm having
> some problems.
>
> I've changed the path from localhost to the domain I'm hosting in the
> Flash ActionScripts of the
> examples and that works fine.  I can browse to the greeting
> exampletype in my name...hit "try
> it"and then I get.
>
> "A script in this movie is causing Flash Player to run slowly.  If it
> continues to run, your
> computer may become unresponsive.  Do you want to abort the script?"
>
> Anybody else run across this one?
>
> 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
>
> 
__
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: Flash Connector Kit issues

2002-03-01 Thread Scott Van Vliet

This usually happens when you have an infinite loop in the Flash Player.
Check you ActionScript to verify that you are not hanging up while
trying to connect to the server.

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 10:06 AM
To: CF-Talk
Subject: Flash Connector Kit issues

Hi All,

I'm trying to get the Flash Connector Kit examples to run and I'm having
some problems.

I've changed the path from localhost to the domain I'm hosting in the
Flash ActionScripts of the
examples and that works fine.  I can browse to the greeting
exampletype in my name...hit "try
it"and then I get.

"A script in this movie is causing Flash Player to run slowly.  If it
continues to run, your
computer may become unresponsive.  Do you want to abort the script?"

Anybody else run across this one?

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



RE: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread 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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Sean McCarthy

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







__
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



page up/down

2002-03-01 Thread Robert Orlini

Hello,

I know this has been asked 1000's of times, but I lost the code: Anyone 
have a simple Page Up/Page Down CF code. I want to insert it into a 
display page to have it display fivce records at a time.

Many thanks for all the help!

__
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: page up/down

2002-03-01 Thread Paul Giesenhagen

You can download our QDNext for free:

http://www.quilldesign.com

It allows for next/previous and page series's as well ..

It's also free!

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

- Original Message -
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 1:52 PM
Subject: page up/down


> Hello,
>
> I know this has been asked 1000's of times, but I lost the code: Anyone
> have a simple Page Up/Page Down CF code. I want to insert it into a
> display page to have it display fivce records at a time.
>
> Many thanks for all the help!
>
> 
__
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: mulitple SQL statements and passing values

2002-03-01 Thread Christopher Olive

in SQL Server:

INSERT INTO table_2
(table_1_id)
SELECT id from Table_1

christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 1:48 PM
To: CF-Talk
Subject: mulitple SQL statements and passing values


Hi,

If I want to query a table for an id and then save that id to another 
table, can I do it in the same SQL statement? If so, how do I refer to 
the value from the first select? It's something like this:



select id from table_1
insert into table_2(table_1_id)values(the_id_ just queried)



TIA,

Doug Jordon

__
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: Oracle Error about extending tablespace..

2002-03-01 Thread Christopher Olive

check the disk space on the drive on which the table resides.  you may 
be out.

christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:15 PM
To: CF-Talk
Subject: Oracle Error about extending tablespace..


Hi all,

I don't know Oracle very well, and a client is getting this error from a
website I built for them that uses Oracle.

Oracle Error Code = 1653
ORA-01653: unable to extend table Timentry.tabledetails by 41 in
tablespace TIMENTRY

This is happening whenever someone tries to add a new record to the
database. The tabledetails table takes very high traffic and can
potentially have errrm..maybe thousands of records in a very short time.

Any ideas?

Hewp!
0_0

-Gel

__
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



Oracle Error about extending tablespace..

2002-03-01 Thread Angel Stewart

Hi all,

I don't know Oracle very well, and a client is getting this error from a
website I built for them that uses Oracle.

Oracle Error Code = 1653
ORA-01653: unable to extend table Timentry.tabledetails by 41 in
tablespace TIMENTRY

This is happening whenever someone tries to add a new record to the
database. The tabledetails table takes very high traffic and can
potentially have errrm..maybe thousands of records in a very short time.

Any ideas?

Hewp!
0_0

-Gel
__
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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Haggerty, Michael A.

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






__
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: What are these, headers?

2002-03-01 Thread Andrew Peterson

Matthew,

Yes, a lot of code is being generated (as Jochem pointed out, 2MB).

> > What code is run before
> > 
> > 

Jochem,

The only code being written prior to that is a query called checkcache.
However, CFHTTP is run on the first access to that query result page. The
header is generated either by an exessively long page (why I don't know),
the CFHTTP, a combination of the two, or some web server setting or filter.

Thanks again!
Andrew



> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 28, 2002 4:06 PM
> To: CF-Talk
> Subject: RE: What are these, headers?
>
>
> I've had this. It happens when a lot of code is output before the
> cflocation. If you can reduce the amount of code it should
> come right. For
> example, I resolved it by moving a large Javascript block
> from the top to
> the bottom. Any help?
>
>
> Regards,
> Matthew Walker
> /*
>   Cabbage Tree Creative Ltd
>   Christchurch - New Zealand
>
>   http://www.matthewwalker.net.nz/
>   http://www.cabbagetree.co.nz/
> */
>
>
> > -Original Message-
> > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, 1 March 2002 10:39 am
> > To: CF-Talk
> > Subject: Re: What are these, headers?
> >
> >
> > Andrew Peterson wrote:
> > > Hi
> > > The text below is randomly appearing at the top of some of
> > my web pages:
> > > HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb
> > 2002 17:45:56
> > > GMT Content-Type: text/html Accept-Ranges: bytes
> > Last-Modified: Thu, 28 Feb
> > > 2002 17:44:15 GMT ETag: "90e1e5897fc0c11:1df0"
> > Content-Length: 1991537
> > > What is this?
> >
> > Standard HTML headers (although I wouldn't want to call the content
> > length standard, 2MB is a lot :) ).
> >
> >
> > > This text seems to appear only when I am using CFLocation to
> > > redirect to a static html page that I created through
> > CFHTTP, and it occurs
> > > randomly.
> >
> > Thing to check is if this text is actually inside the static
> > HTML page
> > (quite unlikely because of the rest of the symptoms, but
> > check anyway).
> >
> >
> > > However, I've learned through testing that if I use a Meta
> > Refresh instead
> > > of a CFLocate, text does not appear (i.e. problem solved).
> >
> > This makes me believe you have a problem that is bigger as this.
> > Somewhere in the webserver/cfserver setup something goes wrong which
> > means that the server is adding the HTTP headers twice. And
> that is a
> > problem because in that case the second occurence ends up
> in the page
> > visible to the user.
> >
> > What code is run before
> > 
> > 
> >
> > Anything that does something with headers/pageflow
> (cfflush, cfcache,
> > cfcontent, cfheader, cflocation etc.)? What happens if you
> > remove that
> > code? Try putting a cfabort after the cflocation? Did you by
> > any chance
> > install URLScan recently? Which ISAPI filters do you have? Are you
> > running IIS HTTP compression?
> >
> > Jochem
> >
> 
__
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: mulitple SQL statements and passing values

2002-03-01 Thread Douglas Brown

You might be able to do something like so, never tried it.


declare @this_id int
begin
select @this_id = (id)
from your table
end


insert into table2 (tablerow)
values (@this_id)




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



Doug Brown
- Original Message - 
From: "Douglas Jordon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 10:47 AM
Subject: mulitple SQL statements and passing values


> Hi,
> 
> If I want to query a table for an id and then save that id to another 
> table, can I do it in the same SQL statement? If so, how do I refer to 

> the value from the first select? It's something like this:
> 
> 
> 
> select id from table_1
> insert into table_2(table_1_id)values(the_id_ just queried)
> 
> 
> 
> TIA,
> 
> Doug Jordon
> 
__
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



mulitple SQL statements and passing values

2002-03-01 Thread Douglas Jordon

Hi,

If I want to query a table for an id and then save that id to another 
table, can I do it in the same SQL statement? If so, how do I refer to 
the value from the first select? It's something like this:



select id from table_1
insert into table_2(table_1_id)values(the_id_ just queried)



TIA,

Doug Jordon
__
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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Sean McCarthy

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





__
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



Flash Connector Kit issues

2002-03-01 Thread Bryan Stevenson

Hi All,

I'm trying to get the Flash Connector Kit examples to run and I'm having some problems.

I've changed the path from localhost to the domain I'm hosting in the Flash 
ActionScripts of the
examples and that works fine.  I can browse to the greeting exampletype in my 
name...hit "try
it"and then I get.

"A script in this movie is causing Flash Player to run slowly.  If it continues to 
run, your
computer may become unresponsive.  Do you want to abort the script?"

Anybody else run across this one?

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
__
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: OOT - Information

2002-03-01 Thread Douglas Brown

Troy, it looks like a definite nightmare out there right now for jobs. I 
find nobody wanting to hire , but several wanting just contract work. 
you figure California would be busting out the seams with jobs, 
but.NOT




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



Doug Brown
- Original Message - 
From: "Troy Montour" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 9:15 AM
Subject: OOT - Information


> Hello everyone,
> As its sitting on a month and half of looking for a job and no 
luck 
> yet I was wondering if anyone has any leads for the 
> Minnesota,Minneapolis area I could check out and hopefully get hired.
> 
> Thank You
> Troy Montour
> Vampires Inc
> 4663 Main ST
> Fridley, MN 55421
> Phone: (612) 867-6831
> Fax: (763) 586-0552
> www.vampiresinc.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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Tyler M. Fitch

Mike,

If you have access to the CF docs, which are linked from the cfadmin
check out

cfdocs/Advanced_ColdFusion_Administration/VerityPart.html

I read through it a week or two ago and it has a good coverage of the
functionality provided by Verity with CF and how to use it and tweak it,
including the Spider.

Good luck,

t

**
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer
http://isitedesign.com
** 

-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 8: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


__
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



Unknown Data Access Error

2002-03-01 Thread Tony Schreiber

Anyone ever seen this?

CF5/Win2k/Apache/Oracle 8.0.5 (using ODBC driver)

This is from a basic update statement. I have plenty of others and they
don't have this problem...

"Error","1400","03/01/02","11:07:21",,"Data Access Error Unknown Data
Access Error.
"Error","1400","03/01/02","11:07:21",,"65.208.124.109, Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0), Data Access Error Unknown
Data Access Error.The error occurred while processing an element
with a general identifier of (CFQUERY), occupying document position (33:3)
to (33:50).Date/Time: 03/01/02 11:07:21Browser: Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0)Remote Address:
65.208.124.109HTTP Referrer:
http://shop.hitmenow.com/affiliates/p-update.cfm"



Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange
__
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



OOT - Information

2002-03-01 Thread Troy Montour

Hello everyone,
As its sitting on a month and half of looking for a job and no luck 
yet I was wondering if anyone has any leads for the 
Minnesota,Minneapolis area I could check out and hopefully get hired.

Thank You
Troy Montour
Vampires Inc
4663 Main ST
Fridley, MN 55421
Phone: (612) 867-6831
Fax: (763) 586-0552
www.vampiresinc.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: Uploading file directly into SQL database

2002-03-01 Thread Dave Watts

> Yes, we want to be able to use the SQL server indexing. 
> In the db I'm already storing a reference to the file, 
> for when someone needs to download it.
> 
> We're finding that Verity is way too slow when we have a 
> mixture of several Verity database collections and a Verity 
> file collection. When we output the results of a verity 
> search, we need to be able to check that someone has
> access to the file (based on other db data), before it is 
> presented to them in the search results. Doing this with 
> a SQL index search, we can do all the 'access-checking' 
> and search with one query.
> 
> Currently searching one of our (optimised) verity database 
> collections can take up to 7 secs, doing the same search 
> with SQL indexing knocks this down to 0.3 sec.

If you're running CF 5, and you're not using the bundled Verity K2 Server
for searches, you might want to try that out first. It's significantly
faster, and may be a better solution than storing files within the database.

Information on using K2 is available in the CF docs, and here:
http://www.cfugorama.com/cfugorama/codelibrary/loader.cfm?url=/commonspot/se
curity/getfile.cfm&PageID=1727

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
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: Image directory flow

2002-03-01 Thread Haggerty, Michael A.

Tim;

Um... okay, I think I know what the problem is. 

The header and footer files are in a different directory than the 
content
files. The client Web browser will be looking for the files based on 
the
physical location of the content files on the Web server, not based on 
the
location of the header and footer files. 

You need to think about the location of the image directory relative to 
the
location of the content pages. 

What you will need to do is adjust the links to images in the header 
and
footer files to be dynamic based on the location of the content page, 
i.e.


You will need to set a variable in each one of your content pages that
refers to the location of the images directory relative to the content 
page,
i.e. . 

You can create a new file, call it app_local.cfm or something like 
that, and
include it in each of your content pages. 

Should do the trick,
Mike

-Original Message-
From: Tim VanderPloeg [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:36 PM
To: CF-Talk
Subject: Image directory flow


I must be missing something very simple but I am new to CF. I have to
follow a directory structure hear where I work that goes like this:
Root
Dept
Apps
Content
Graphics
Apps

What I am trying to do is to have a header.cfm and footer.cfm that will
be located in the Apps directory and the images in the Graphics
directory. All of my pages will use the header.cfm and footer.cfm no
matter what level the module is at. With the  the images do not carry over to the different
levels unless they are in the same level as the header.cfm is. In the
img src="../content/graphics/image.jpg" call I have tried it with 
just
the / at the beginning and still no luck. What do I need to do so all 
of
the images that are stored in the graphics folder and used in the
header.cfm no matter what level I include the header.cfm will be seen. 
I
only want one header.cfm, menu.cfm and footer.cfm on the site.

Tim VanderPloeg
South Florida TSG
Web Developer
561-840-7018 

__
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: Image directory flow

2002-03-01 Thread Joshua Tipton

Tim,

Use aboslute instead of relative paths.

ie..

/dept/content/graphics/imagename.jpg

This will fix the problem because the first backslash in front of dept tells it to 
drop to the root.



On Fri, 01 March 2002, "Tim VanderPloeg" wrote:

> 
> I must be missing something very simple but I am new to CF. I have to
> follow a directory structure hear where I work that goes like this:
> Root
> Dept
> Apps
> Content
> Graphics
> Apps
> 
> What I am trying to do is to have a header.cfm and footer.cfm that will
> be located in the Apps directory and the images in the Graphics
> directory. All of my pages will use the header.cfm and footer.cfm no
> matter what level the module is at. With the  template="/header.cfm"> the images do not carry over to the different
> levels unless they are in the same level as the header.cfm is. In the
> img src="../content/graphics/image.jpg" call I have tried it with just
> the / at the beginning and still no luck. What do I need to do so all of
> the images that are stored in the graphics folder and used in the
> header.cfm no matter what level I include the header.cfm will be seen. I
> only want one header.cfm, menu.cfm and footer.cfm on the site.
> 
> Tim VanderPloeg
> South Florida TSG
> Web Developer
> 561-840-7018 
> 
__
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: Image directory flow

2002-03-01 Thread UXB Internet

Tim,

In you application.cfm page set a variable to the base reference and then
use it in you pages.

Example:

http://rootdomain.com/>

Then when calling the graphics in your header and footer includes:

http://www.uxbinternet.com/

-Original Message-
From: Tim VanderPloeg [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:36 PM
To: CF-Talk
Subject: Image directory flow

I must be missing something very simple but I am new to CF. I have to
follow a directory structure hear where I work that goes like this:
Root
Dept
Apps
Content
Graphics
Apps

What I am trying to do is to have a header.cfm and footer.cfm that will
be located in the Apps directory and the images in the Graphics
directory. All of my pages will use the header.cfm and footer.cfm no
matter what level the module is at. With the  the images do not carry over to the different
levels unless they are in the same level as the header.cfm is. In the
img src="../content/graphics/image.jpg" call I have tried it with just
the / at the beginning and still no luck. What do I need to do so all of
the images that are stored in the graphics folder and used in the
header.cfm no matter what level I include the header.cfm will be seen. I
only want one header.cfm, menu.cfm and footer.cfm on the site.

Tim VanderPloeg
South Florida TSG
Web Developer
561-840-7018

__
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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Mark Leder

On Fri, 1 Mar 2002 11:18:32 -0500, Sean McCarthy wrote:
>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
>
>
>
>
_

>_
>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
>

I thought I saw a custom tag at the DevCenter which addresses the
 
junk html strip-out, you may also want to check CFLib.org
-- 
Mark Leder, [EMAIL PROTECTED] on 03/01/2002

__
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: SQL Server 7.0 evaluation/developer's edition

2002-03-01 Thread Haggerty, Michael A.

You can still pick up copies of SQL Server 7, and it is a little 
cheaper
than before they released SQL 2000.

http://cnet.search.com/search?timeout=3&tag=ex.cn.1.srch.cnet&q=sq
l+server+7

Mike

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 10:02 AM
To: CF-Talk
Subject: SQL Server 7.0 evaluation/developer's edition


Anyone know if there's such a thing as an MS SQL Server
7.0 evaluation version/developer's edition? I grabbed the
SQL 2000 trial in anticipation of doing some work for a
client, now it turns out they're running 7, and I'd like to
do this bit of development on the same version...

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
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?

2002-03-01 Thread Haggerty, Michael A.

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




__
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: cfhttp pressure

2002-03-01 Thread Matt Robertson

Jason said,

> Is there a better way, other then converting 
> all content to static pages? (I don't want to 
> use query caching as it will not do and eat 
> all the memory).

The method I referred to isn't going to do anything for you if you are
looking to reduce load on your db server and CF itself.  Its just a
quick/dirty way to make pages appear to be static.

If I had CF5, I'd probably use the method Jochem suggested, and then
build code to maintain it on a page-by-page basis as I added or edited
content.  

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.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



Image directory flow

2002-03-01 Thread Tim VanderPloeg

I must be missing something very simple but I am new to CF. I have to
follow a directory structure hear where I work that goes like this:
Root
Dept
Apps
Content
Graphics
Apps

What I am trying to do is to have a header.cfm and footer.cfm that will
be located in the Apps directory and the images in the Graphics
directory. All of my pages will use the header.cfm and footer.cfm no
matter what level the module is at. With the  the images do not carry over to the different
levels unless they are in the same level as the header.cfm is. In the
img src="../content/graphics/image.jpg" call I have tried it with just
the / at the beginning and still no luck. What do I need to do so all of
the images that are stored in the graphics folder and used in the
header.cfm no matter what level I include the header.cfm will be seen. I
only want one header.cfm, menu.cfm and footer.cfm on the site.

Tim VanderPloeg
South Florida TSG
Web Developer
561-840-7018 
__
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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Sean McCarthy

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



__
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?

2002-03-01 Thread phil e hebenstreit

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
  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: Verity Issue - Returning Incorrect Results?

2002-03-01 Thread Mark Leder

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

__
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: PHPConfig

2002-03-01 Thread Robert Everland

There wouldn't happen to be one of those to edit apache? That's the only
thing that stops me from using it. Don't have the time to really sit there
and do it. One of these days I will.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 10:15 AM
To: CF-Talk
Subject: PHPConfig


I know some of us CFers still must code in other languages, and I found 
this little jewel for editing the PHP.ini

http://www.analogx.com/contents/download/network/phpconf.htm








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



Doug Brown


__
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: SQL Server 7.0 evaluation/developer's edition

2002-03-01 Thread Jeffry Houser

  With SQL Server 2000 out, I doubt you can still get SQL Server 7
 evaluation.
  But you will have no trouble accessing a SQL Server 7 server w/ SQL 
Server 2000 utilities.

At 03:01 PM 03/01/2002 +, you wrote:
>Anyone know if there's such a thing as an MS SQL Server
>7.0 evaluation version/developer's edition? I grabbed the
>SQL 2000 trial in anticipation of doing some work for a
>client, now it turns out they're running 7, and I'd like to
>do this bit of development on the same version...
>
>- Gyrus
>
>
>- [EMAIL PROTECTED]
>work: http://www.tengai.co.uk
>play: http://www.norlonto.net
>- PGP key available
>
>
__
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: CFOBJECT and Excel Column widths

2002-03-01 Thread Tristram Charnley

Yes, but it requires Excel 2000perhaps I can persuade them to upgrade.
Meanwhile I was hoping CFOBJECT would do the trick.

- Original Message -
From: "list peters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 8:16 AM
Subject: Re: CFOBJECT and Excel Column widths


> ben forta described how to do this (variable width columns), along with
> formatting etc in his web application construction kit book.
>
> start a new excel document, and enter a test row how you would like...
apply
> all formatting, column widths, etc, and then save as HTML.
> Open up the HTML file created, stick in your query, and your cfoutputs
> around the tables (like you would normally), and then serve it up with
> cfcontent.
>
> goodluck!
>
> chad
>
>
> > I've been using  to output query results in Excel. My clie
nt
> now
> > wants the width of the spreadsheet columns being generated to
> automatically
> > size to the length of the longest string returned from the query. Doe
s
> > anyone know whether this is possible, maybe with ?
> >
> > No luck so far with cfcomet.
> >
> > Tristram Charnley
> > ---
> > [EMAIL PROTECTED]
> > Allaire Certified ColdFusion Developer
> >
> >
> >
> >
> > _
_
> > 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
> >
>
>
__
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: SQL Server 7.0 evaluation/developer's edition

2002-03-01 Thread Dave Watts

> Anyone know if there's such a thing as an MS SQL Server
> 7.0 evaluation version/developer's edition? I grabbed the
> SQL 2000 trial in anticipation of doing some work for a
> client, now it turns out they're running 7, and I'd like to
> do this bit of development on the same version...

There is a developer's edition of both SQL Server 7 and SQL Server 2000, but
they cost about $500 apiece. I doubt that the evaluation version of SQL
Server 7 is still available from Microsoft, because it's no longer the
current product.

You have some options, though. First, you can do development on SQL Server
2000 and deploy against SQL Server 7 - there are very few differences beyond
new features in SQL Server 2000. For the vast majority of stuff you're going
to do, it won't make a difference.

Also, you can get the SQL 7 compatible version of MSDE, and work against
that. You can use the SQL Server 2000 Enterprise Manager to manage it,
although you won't want to just install it on your SQL Server 2000 machine.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
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: CFOBJECT and Excel Column widths

2002-03-01 Thread Haggerty, Michael A.

Can the column widths be resized dynamically to their widest value? 
What I
found was that, without any VBScript or COM automation, this was not
possible.

I would be interested in seeing an example of doing this another way, 
if
anyone has one.

Mike

-Original Message-
From: list peters [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 3:16 AM
To: CF-Talk
Subject: Re: CFOBJECT and Excel Column widths


ben forta described how to do this (variable width columns), along with
formatting etc in his web application construction kit book.

start a new excel document, and enter a test row how you would like... 
apply
all formatting, column widths, etc, and then save as HTML.
Open up the HTML file created, stick in your query, and your cfoutputs
around the tables (like you would normally), and then serve it up with
cfcontent.

goodluck!

chad


> I've been using  to output query results in Excel. My 
client
now
> wants the width of the spreadsheet columns being generated to
automatically
> size to the length of the longest string returned from the query. 
Does
> anyone know whether this is possible, maybe with ?
>
> No luck so far with cfcomet.
>
> Tristram Charnley
> ---
> [EMAIL PROTECTED]
> Allaire Certified ColdFusion Developer
>
>
>
>
> 

__
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



Verity Issue - Returning Incorrect Results?

2002-03-01 Thread phil e hebenstreit

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



drivers

2002-03-01 Thread Deborah Curley

Hi,
I know ColdFusion 5 comes with the 3.6 Merant ODBC drivers, if I install the 
4.0 set of drivers will it be supported by ColdFusion?

TIA,
Deb

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.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



PHPConfig

2002-03-01 Thread Douglas Brown

I know some of us CFers still must code in other languages, and I found 
this little jewel for editing the PHP.ini

http://www.analogx.com/contents/download/network/phpconf.htm








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



Doug Brown

__
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



Displaying Please wait message during a process

2002-03-01 Thread Mark Leder

I have a template that I want to display "Please wait" text, then
 go 
through a CFIndex Process, with a "complete" message when done. 
 This 
is displayed in a pop-up window.  I find that when the CF process
 
starts, the window goes blank until the process is done, then 
displays all the text.  I've tried a CFFlush on the "please wait"
 
prior to the process, but then the process hangs.  I've also
 tried 
wrapped CFSilent around the process, to no avail.

What's the right way to do this?

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

__
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



SQL Server 7.0 evaluation/developer's edition

2002-03-01 Thread Gyrus

Anyone know if there's such a thing as an MS SQL Server
7.0 evaluation version/developer's edition? I grabbed the
SQL 2000 trial in anticipation of doing some work for a
client, now it turns out they're running 7, and I'd like to
do this bit of development on the same version...

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available

__
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



All Excel ODBC data sources broken - CF 5.0

2002-03-01 Thread Earl, George

Why would Excel ODBC data sources that have been working for several months
all of a sudden all break?

We have a CF application that uses about a dozen different Excel
spreadsheets for data sources. Depending on the type of report requested, we
query one of the Excel spreadsheets using ODBC to pull out data and then we
build the report. This has worked fine since last October.

Last week we upgraded our server from CF 4.5.1 to 5.0 and it still worked
fine - until yesterday. We made no changes to the CF server configuration
yesterday and we did not upload new files. The only out-of-the-ordinary
thing that happened yesterday is that we had a team reviewing each page on
our site using a new desktop image that will be distributed throughout our
organization. They successfully accessed each of the types of reports in
this application without getting any errors on the Excel data sources. It
wasn't till later in the afternoon that we discovered this problem.

I could not verify any of the Excel data sources through CF Administrator. I
tried uploading new Excel files to the server and they would not verify. I
tried opening and saving a file and then uploading it and it still would not
verify.

Stopping and restarting the CF service fixed the problem, but I'd like to
find out what caused it in the first place.

Any ideas on what broke our Excel ODBC data sources?

Thanks!

George
__
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: Uploading file directly into SQL database

2002-03-01 Thread A . Little

Yes, we want to be able to use the SQL server indexing. In the db I'm
already storing a reference to the file, for when someone needs to download
it.

We're finding that Verity is way too slow when we have a mixture of several
Verity database collections and a Verity file collection. When we output the
results of a verity search, we need to be able to check that someone has
access to the file (based on other db data), before it is presented to them
in the search results. Doing this with a SQL index search, we can do all the
'access-checking' and search with one query.

Currently searching one of our (optimised) verity database collections can
take up to 7 secs, doing the same search with SQL indexing knocks this down
to 0.3 sec.

Alex

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2002 11:30
To: CF-Talk
Subject: Re: Uploading file directly into SQL database


>
> I want to insert an uploaded file directly into a SQL database field. So
> after the user has uploaded the file to our CF server, at some point later
> (probably overnight), we can move this file to store it directly in the
db.
>
> I have no idea how to make a start on this (the file's already uploaded to
> the server), it's just the overnight routine I can't work out.
>
> Does anyone have any help for me
>

Alex,

Do you really need to store the file in the database?
You can store files in BLOBs in databases, but they aren't really made for
that kind of thing.
If you want to send the file out to someone some how, you'll need to extract
it from the database, write it to the server and then send it out to the
user.  Why not just leave the file on the server in the first place and just
store a reference to it in the database?

What is it you're really trying to do?

Regards

Stephen

__
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: count delete [anyone?] --solved

2002-03-01 Thread Jason Davis

That did it! Thanks Paul.

- Original Message -
From: "Paul Hastings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 12:34 PM
Subject: Re: count delete [anyone?]


> SET NOCOUNT ON
> > > DELETE from Orders WHERE
> > > Product_id=#val(Product_id)#
>
> SELECT Deleted = @@ROWCOUNT
>
> SET NOCOUNT OFF
> 
__
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: Uploading file directly into SQL database

2002-03-01 Thread Stephen Moretti

>
> I want to insert an uploaded file directly into a SQL database field. So
> after the user has uploaded the file to our CF server, at some point later
> (probably overnight), we can move this file to store it directly in the
db.
>
> I have no idea how to make a start on this (the file's already uploaded to
> the server), it's just the overnight routine I can't work out.
>
> Does anyone have any help for me
>

Alex,

Do you really need to store the file in the database?
You can store files in BLOBs in databases, but they aren't really made for
that kind of thing.
If you want to send the file out to someone some how, you'll need to extract
it from the database, write it to the server and then send it out to the
user.  Why not just leave the file on the server in the first place and just
store a reference to it in the database?

What is it you're really trying to do?

Regards

Stephen
__
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



Uploading file directly into SQL database

2002-03-01 Thread A . Little

Hi,

I want to insert an uploaded file directly into a SQL database field. So
after the user has uploaded the file to our CF server, at some point later
(probably overnight), we can move this file to store it directly in the db.

I have no idea how to make a start on this (the file's already uploaded to
the server), it's just the overnight routine I can't work out. 

Does anyone have any help for me

thanks

Alex

__
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: count delete [anyone?]

2002-03-01 Thread Paul Hastings

SET NOCOUNT ON
> > DELETE from Orders WHERE
> > Product_id=#val(Product_id)#

SELECT Deleted = @@ROWCOUNT 

SET NOCOUNT OFF
__
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: Change Server Time, is this possible ???

2002-03-01 Thread Ian Tait

Maybe cfexecute or xp_cmdshell and the dos 'date' command?

Ian

-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2002 05:53
To: CF-Talk
Subject: RE: Change Server Time, is this possible ???


Well if you know a little C++ you could probably do a CFX tag that will 
do
what you want.  COM objects should be able to as well (you can develop 
to
access the windows API from there) but you won't be able to in 
ColdFusion in
a way that's documented.

Gregory Harris
[EMAIL PROTECTED]

-Original Message-
From: Fisichella [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 7:54 PM
To: CF-Talk
Subject: Change Server Time, is this possible ???


Hi,

We build apps in intranet scope. I want to change the server time,
through user authorization. I know client can't do this because of
security issue. But, can I do this via COM objects or anything else ???
For IE only is ok.


TIA,

Fisichella.



__
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: count delete [anyone?]

2002-03-01 Thread Jason Davis

Anyone?

> Why do you think I can't get the @@Rowcount AS Deleted in cfoutput?
> 
> DELETE from Orders WHERE
> Product_id=#val(Product_id)#
> SELECT @@ROWCOUNT AS Deleted
> 
> error #Queryname.Deleted#
> 

__
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: cfhttp pressure

2002-03-01 Thread Jason Davis

Matt,

> Do the pages truly have to be static?  I do something that only requires
CFFILE to generate its run of templates ... which are just copies with
different filenames, where the filename incorporates the key ID and there's
code inside to pull that ID out and use it.  Doesn't affect the resources
the page needs to display, but is an easy way to make the page crawlable.  I
can provide a code sample if you'd like.

The way I'm working now is including the statics pages using application.cfm
when a product_id appears in the url.

Is there a better way, other then converting all content to static pages?
(I don't want to use query caching as it will not do and eat all the
memory).

Thanks.

>
> ---
> Matt Robertson[EMAIL PROTECTED]
> MSB Designs, Inc., www.mysecretbase.com
> ---
>
> > CF 5.0 chokes after trying to do the following (openeing
> > lots and lots of cfhttps to make static pages from my
> > product template). I know it's an hard job, but is there
> > a solution? how can I try and perfom this task without
> > splitting the records?
> >
> > 
> > SELECT TOP 2000 Product_id
> > FROM Products
> > ORDER BY Product_id
> > 
> >
> > 
> >  > url="http://mydomain/generate.cfm?id=#Product_id#&generate=1";
> > method="GET" path="#Map_root#\generate\html\"
> > file="#Product_id#.html" resolveurl="false"
> > useragent="CF Fetcher">
> > 
>
>
> 
__
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