Getting CF to display value, not variable

2002-10-09 Thread Steven Monaghan

For the app I am working on, the "power users" are given a maintenance
screen.  From this screen, they can build a free-form description. But, they
need to be able to include dynamic data in the description.

They are entering variable names in the description wrapped in # signs.
But, I cannot figure out how to get CF to realize that the data inside the
variable needs to be evaluated as well as the data itself.

I tried using the Evaluate function, but it blew up when it hit the # sign.

Sorry if this is a simple question, but I only get to do CF part time, and
appreciate any help.

Thanks,
Steve

-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
copies of it.  Thank you.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Issue with text database on Unix

2002-08-28 Thread Steven Monaghan

Yup.  Still treated is as numeric.  I wound up having to put a dummy row in
the file with text in those columns to force the driver to treat them as
text.

Ugly, but it works.

Steve

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 7:10 PM
To: CF-Talk
Subject: Re: Issue with text database on Unix


have you tried saving the CSV file with double quotes (") around the 
text column?

Dick


On Tuesday, August 27, 2002, at 12:55 PM, Steven Monaghan wrote:

> I configured a data source, and can now query any csv file I drop into 
> a
> directory.  The only issue I am having, is that sometimes, a "text" 
> column
> only has numeric data.  The driver assumes that since the column only
> contains numeric data, that the column is numeric.  So, any reference 
> to
> this column as a string (ie DESCRIPTION NE '') fails on a datatype 
> error.
>
> Does anyone know how to tell CF/Merant ODBC Text driver that this 
> column is
> a text column?
>
> TIA,
> Steve Monaghan
>
> -
> Steven Monaghan
> Oracle DBA / Cold Fusion Developer
> MSC Industrial Direct Co., Inc.
> http://www.mscdirect.com
> -
>
>
> This e-mail is intended for the use of the addressee(s) only and may 
> contain
> privileged, confidential, or proprietary information that is exempt 
> from
> disclosure under law.  If you are not the intended recipient, please 
> do not
> read, copy, use or disclose the contents of this communication to 
> others.
> Please notify the sender that you have received this e-mail in error by
> replying to the e-mail.  Please then delete the e-mail and destroy any
> copies of it.  Thank you.
> 

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



Issue with text database on Unix

2002-08-27 Thread Steven Monaghan

I configured a data source, and can now query any csv file I drop into a
directory.  The only issue I am having, is that sometimes, a "text" column
only has numeric data.  The driver assumes that since the column only
contains numeric data, that the column is numeric.  So, any reference to
this column as a string (ie DESCRIPTION NE '') fails on a datatype error.

Does anyone know how to tell CF/Merant ODBC Text driver that this column is
a text column?

TIA,
Steve Monaghan

-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
copies of it.  Thank you.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Problem writing query result to file

2002-05-21 Thread Steven Monaghan

Nevermind...

The process is to be run by only one person, so it doesn't protect against
multiple people running at the same time.  The person double-clicked the
link, causing the process to run twice simultaneously, creating the issue.

If it continues to happen, I'll use unique file names to eliminate the
problem.

Thanks again,
Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-

-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 6:00 PM
To: CF-Talk
Subject: RE: Problem writing query result to file


I think you'd have two choices...

1. CFLOCK the  tag (not recommended)
2. build up a string in the CFOUTPUT then do a single 

Both options will fix your problem, but the second one will be MUCH faster
(assuming you are not memory constrained)

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

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



-Original Message-
From: Steven Monaghan [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 2:28 PM
To: CF-Talk
Subject: Problem writing query result to file


I am using CFFILE to create a file using "write" and then append about
10,000 lines to the file by using cfoutput over a set of query results.
Sporadically in the file, it puts two sets of data on the same line, and
leaves the next line blank.  It happens a few dozen times in this 10,000
line file, so I can't ignore it.

Has anyone ever seen this behavior?  Any remedies?  I am running CF5 on
Solaris.

Thanks,
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
copies of it.  Thank you.


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



Problem writing query result to file

2002-05-20 Thread Steven Monaghan

I am using CFFILE to create a file using "write" and then append about
10,000 lines to the file by using cfoutput over a set of query results.
Sporadically in the file, it puts two sets of data on the same line, and
leaves the next line blank.  It happens a few dozen times in this 10,000
line file, so I can't ignore it.

Has anyone ever seen this behavior?  Any remedies?  I am running CF5 on
Solaris.

Thanks,
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
copies of it.  Thank you.
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: OT: Oracle version of TOP

2002-03-28 Thread Steven Monaghan

What version are you on?

In 8.1 (8i) and above, you can do the following:
SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
   FROM
   (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
  FROM Emp
  ORDER BY NVL(Sal, 0) DESC)
   WHERE ROWNUM < 6;

For 8.0 and below, you cannot do an order by in a nested select, but you can
cheat by doing the following:
SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
   FROM
   (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
  FROM Emp
  union
SELECT 1,2,3,4,5,6
 from dual where 1=2)
   WHERE ROWNUM < 6;
The union forces a sort (in ascending order only!) and tricks oracle into
sorting.

Here's a link that should help...

http://www.jlcomp.demon.co.uk/faq/top_sql.html

Steve
---------
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-

-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:31 PM
To: CF-Talk
Subject: Re: OT: Oracle version of TOP


VAN VLIET, SCOTT E (SBCSI) wrote:

>Sorry for the OT, but do any of you know the Oracle function for selecting
>the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL).
> 
>Thanks!
> 
>Scott
>
rowcount is similar but my oracle skills have bit rotted :-( i think :-)

z



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



RE: Meet my tables

2002-03-19 Thread Steven Monaghan

If you are using Oracle, there is the CONNECT BY clause that is designed for
use with Hierarchical data.  I'm not sure if there is corresponding
functionality in your database, but this may give you a starting point...

Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-

-Original Message-
From: Jason Davis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 3:20 PM
To: CF-Talk
Subject: Meet my tables


Meet my Products table:

CREATE TABLE [Products] (
 [Product_id] [int] NOT NULL ,
 [Product_title] [varchar] (200) NULL ,
 [Category_id] [int] NOT NULL ,
)

Each product has a category, meet my categories table:

CREATE TABLE [Categories] (
 [Category_id] [int] NOT NULL ,
 [Category_parent] [int] NULL ,
 [Category_title] [varchar] (200) NULL ,
 [Category_count] [int] NULL DEFAULT (0)
)

As you can see, each category has a Category_parent
which symbolize the above category (categories are sorted hirarchly).

Can I do some kind of a loop that will run for each Category_id,
and store in Category_count the number of Products available in that
category, and all of the hirearchy categories beneath?

i.e - if I have the following categories:

(1) Printers
(2) Laser (category_parent=1)
(3) Ink (category_parent=1)

and the following products:

HP LaserJet (category_id = 2)
HP Deskjet (category_id = 3)
Canon BJ200D (Category_id = 3)

category count will be:

(1) Printers => 3 (1+2)
(2) Laser => 1
(3) Ink => 2


Help!?




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



RE: SQL indexing

2002-02-27 Thread Steven Monaghan

The answer is a definite maybe.

I'm Oracle familiar, not SQL Server, but if the data is skewed in any 
of
those columns(90%=0 10%=1) then you may get some benefit when 
selecting the
smaller value.  Also, Oracle has special indexes for columns with low
cardinality called bitmap indexes.  These are amazing for static data, 
but
can really slow down inserts and updates on these tables.  You might 
want to
see if SQL Server has something similar. 

HTH,
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-

-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 2:26 PM
To: CF-Talk
Subject: OT: SQL indexing


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

I know I could play with the indexes and test the timing, but I only 
have a
live database to work with and don't want to disrupt anything until I 
feel
there will be some significant benefit.

Also, along the same lines, I report by grouping output (in SQL - not 
CF's
group=) using the DAY, HOUR and MONTH parts of a datetime stamp.  
Will
indexing help when using portions of a datetime field in this way, as
opposed to considering the entire field?

BTW - this is using SQL Server 2000 (and I guess the same theory would 
apply
to SQL 7).

Thanks!

Jeff


__
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



Complete lack of locking...

2001-11-21 Thread Steven Monaghan

I inherited an application that uses session variables and has no CFLOCK
tags in it at all! All session variables have a CFPARAM in the
Application.cfm, but even there it isn't inside a cflock.  I was reading the
docs and even if I set the locking to "Automatic Read Locking", I don't
think I'm protected from potential locking problems.  

Am I understanding things correctly?  Do I need to go through every bit of
code, find where a session variable is referenced and put it in a ReadOnly
lock, and find where a session variable is updated and put it in a Exclusive
lock?

TIA,
Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-



This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Cold Fusion Error on Solaris

2001-11-01 Thread Steven Monaghan

We have just taken over hosting of a Cold Fusion website in-house.  We are
running on Solaris and have been live for just over 2 days without any
problems.  All of a sudden, everyone trying to connect to the site received
the following error:

Unix error number 24 occurred: Too many open files

This was displayed in a standard Cold Fusion error format.  My Sysadmin
stopped and started the webserver running on the box, and the problem was
resolved.  Anyone else had a similar problem and willing to offer some
guidance?

Thanks,
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-



This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Oracle Help

2001-10-31 Thread Steven Monaghan

The Cold Fusion documentation has some good stuff on connecting to an oracle
database.  You really need to read through the entire section, since
depending on your platform there are some very specific issues that must be
addressed.

http://www.houseoffusion.com/cfdocs1/Administering_the_App_Server/3_Managing
_Data_Sources/admin03.htm

Steve

-Original Message-
From: Simon Whittaker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 12:20 PM
To: CF-Talk
Subject: Oracle Help


Hello there,


I need some help with Oracle - I am not able to connect to my oracle dbase
from within cf administrator - it simply gives the not verified message. The
trouble is I am not entirely sure what the host string is supposed to look
like in the input box - is it dbasename/username@hostname or nothing like
the above? I hope someone can help with this.


Cheers

Simon


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



RE: OT - move Oracle database from Solaris to Intel

2001-10-25 Thread Steven Monaghan

Create an empty database there, along with tablespaces whose names match the
ones on your Solaris box.  Then, export/import should work fine, unless I'm
forgetting something...

-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:33 PM
To: CF-Talk
Subject: OT - move Oracle database from Solaris to Intel


Suppose I have a large Oracle database running on a Solaris box. If I
had an Intel box that run the same version of Oracle, what would be
necessary to move the database over and running it there? In other
words, is it just a simple export or would I need to do a lot of
modifying and converting?


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



RE: Still need a little help

2001-10-25 Thread Steven Monaghan

Use this for a Microsoft database...


update  tbl_users
set fullname = firstname & " "  & lastname
where   firstname = '#Trim(form.firstname)#' and
lastname = '#Trim(form.lastname)#'


-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:24 PM
To: CF-Talk
Subject: Still need a little help


As stated before, i was thinking insert when i should have been thinking
update. still have not got it working just right. want to merge two
populated fields into a third field. in this case take FIRSTNAME and
LASTNAME which are separate fields and merge them into a new column
FULLNAME.


update  tbl_users
set fullname = '#firstname# #lastname#'
where   firstname = '#Trim(form.firstname)#' and
lastname = '#Trim(form.lastname)#'


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



RE:

2001-10-25 Thread Steven Monaghan

Would this work?


SELECT  db1_email as email_field, 
FROMdb1
union
SELECT  db2_email as email_field, 
FROMdb2 
union
SELECT  db3_email as email_field, 
FROMdb3
  

 
 
   
body 



-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:12 AM
To: CF-Talk
Subject: 


Hello,

I am querying 3 tables that all contain email addresses.
What I want to do is send an email using all the email
addresses.  I just want to make sure there aren't 
duplicate e-mail when i sent the email.

I need some advice on how to remove duplicates.


---
i've got the cfquery ...


SELECT  db1_email, 
db2_email, 
db3_email
FROMdb1, 
db2, 
db3,
  

--
I need some advice on how to remove dupplicates


--
I've got the beginning of the cfloop/cfmail ...

 

 

body 





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



RE: SQL quicky

2001-10-04 Thread Steven Monaghan

Try:

select "(" & left(Str(telephone), 3) & ") " & mid(Str(telephone), 4, 3) &
"-" & right(Str(telephone), 4)
from ...

Just coding off of the top of my head, so definitely no guarantees.  The
idea is that the Str function will eliminate the decimal point.  If if
doesn't ,try:

select "(" & left(Str(telephone), 3) & ") " & mid(Str(telephone), 4, 3) &
"-" & mid(Str(telephone), 7,4)
from ...

Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 12:54 PM
To: CF-Talk
Subject: RE: SQL quicky


Yes I am trying to format a phone number (it's kept in the database as
1234567890) for an output form. The problem is that the usual formatting
()won't work
for this output so I'm trying to move the formatting to inside the sql
query. 
 
This formats fine: Gives the result: (123)456-7890

#TELEPHONE#


BUT I need it to loop through a 2ndary query and this does not work: Gives
result 1234567890.0


#TELEPHONE#



Someone sent me the code 
(#insert("-",foo,6)# but this just gives me a result of
(123456-7890.0
and I'm not sure how to get the other ) and how to get rid of the decimal

Anyways I find it all kind of weird that that is the only formatting that is
screwy- all the others (ie: city, state zip) etc are fine.
Any ideas?


-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 3:16 PM
To: CF-Talk
Subject: RE: SQL quicky


Sorry, I don't understand what you're trying to accomplish here. 
Are you trying to output a value obtained from a query to a web 
page or add formatted data to a database table or something 
else?

> That's what I had originally. It works fine for my forms that pull
> up individual records. However, upon doing the bulk records I needed
> to change how my queries sat. All the related queries are a  QUERY> within a query.(  QUERY2> ) And for some reason the
> formatting of telephone now will not  I'm not sure why,
> so I thought I'd try to format it within the sql statement instead.
> 
> -Original Message-
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 03, 2001 2:14 PM
> To: CF-Talk
> Subject: RE: SQL quicky
> 
> 
> This is not exactly within a cf sql statement, but...
> 
> If you can be sure that your phone numbers are 10 digit strings you
> can format your output like this:
> 
> 
> 
> tel=(#left(tel,3)#)
> #mid(tel,4,3)#-#right(tel,4)#
> 
> The output would look like this:
> tel=(800) 555-1212 
> 
> > How do I format a phone number (###) ###- within my cf sql
> > statement? My backend is sql 2000. Thanks in advance.
> 
> 
> 


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



RE: Important - For a project -- please help

2001-10-04 Thread Steven Monaghan

The order of your statements is incorrect.  It should be...

  SELECT count(t.File) as file3, g.File, t.File
  FROM tblfile t, gilway12 g
  WHERE t.File=g.File
  GROUP BY g.File

Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
From: Julia Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 10:30 AM
To: CF-Talk
Subject: Important - For a project -- please help


Can you use counts with joined tables and a where statement?

This seems like a dumb question...

Goto:  http://www.cheshiregroup.com/gilway/subcount3.cfm

My client wants the count of each separate number...next to the
number preferably...

This is tricky because there is 2  tables, one that takes the input
of the form with the customer's number(tblfile), and the other that has all
the valid numbers (gilway12).

I got just the valid numbers to come up on subcount3.cfm, by using aliases
and
a where statement and joining tables.

Then he said he  wanted a count and I can't get it to work with the
code...

Below is the sql code for the statement using File in both tables...
I keep getting errors around the WHERE statement when it worked in
subcount3.cfm...



  SELECT count(t.File) as file3, g.File, t.File
  FROM tblfile t, gilway12 g
  GROUP BY g.File
  WHERE t.File=g.File



produces the incorrect code.


SELECT count(File) AS file2
FROM tblfile





  SELECT t.File, g.File
  FROM tblfile t, gilway12 g
  WHERE t.File=g.File
  ORDER BY t.File DESC



produces subcount3.cfm





From: "Mark Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 04, 2001 10:17 AM
Subject: Stored Procedure Question


> All,
>
> I've been using stored procedures for a while now but I've never really
> needed to create one that returned multiple result sets. My question is,
> how do you do that? Would someone be kind enough to show me a little
> pseudo code or a snippet of code on how to accomplish this?
>
> I assume in cf, I would build my cfstoredproc like this:
>
> 
> 
> 
> 
>
> But I draw a blank when it comes to building the stored proc in SQL
> Server where it would return multiple results. I assume the following:
>
> create procedure [procedure] as
>
> select ... from ... where...
>
> select ... from... where...
>
> How do I specify what query goes with what result?
>
> Thanks for your help!
>
> Mark
>
> 

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



RE: Strangest Problem in a long time

2001-10-04 Thread Steven Monaghan

What about creating a database view with the corrected name?  This way, you
don't have to change your Cold Fusion generated SQL, except for the
table/view name or the actual database layout.

Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 6:08 PM
To: CF-Talk
Subject: RE: Strangest Problem in a long time


Dave, 


I'm using this in a large site where the SQL is generated based on the
fieldname. 

fieldnameXXcolumnname is translated into:
Insert into fieldname (columname) values ('#fieldnameXXcolumname#');

I will have to come up with an extra conversion step to change the name of
these fields and then change them back. What a bummer. 

Leon


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001 4:57 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Strangest Problem in a long time


> Because of the database_design I cannot change the name of my 
> fields. Is there any way I can turn this feature off? 

No, you can't turn the feature off, but you can certainly change the names
of your form fields - there's no reason that they have to be identical in
name to the database fields.

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

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



RE: oracle help

2001-10-03 Thread Steven Monaghan

Try...

Where open_date > to_date('01-JAN'||to_char(sysdate, ''), 'DD-MON-')

This will give you midnight of the current year.

HTH,
Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 3:44 PM
To: CF-Talk
Subject: oracle help


I have a DTS package on my sql server that pulls from an oracle database.
There is a column called open_Date and I want it to pull the data starting
with the year 2001 till it is no longer needed.  Then in 2002 I need it to
do the same thing start pulling all records in 2002 till current.  I was
trying sysdate but I cant make it do the dynamic stuff like that.  I looked
at the date column oracle command but am not sure on it.  Please help if you
can and if you need more info then email me.  Thanks in advance.

Joshua Tipton

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



RE: SQL Query Quandary

2001-09-25 Thread Steven Monaghan

Assuming you have not listed any amenities more than once for a property:

select propertyid, count(*)
from property_amenities
where amenityid in (#amenity_list#)
having count(*) = #the_number_of_items_in_amenity_list#

Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 2:56 PM
To: CF-Talk
Subject: SQL Query Quandary


I've got three tables describing lodging properties and their amenities, as
shown below.  If a lodging property has more than one amenity (for example,
hot tub, min-ibar, fireplace, etc) then there are multiple records for that
property in the property_amenities table.  Pretty basic stuff.

properties
-
propertyid  autonumber
propertynametext

amenities
-
amenityid   autonumber
amenitydescription  text

property_amenities
-
property_amenityid  autonumber
propertyid  number
amenityid   number


I need to form a search for all properties that meet the criteria of having
all of the amenities that a user asks for.  Not an OR, but, logically an
AND - all properties that have ALL of the amenities ask for.  The user
interface is a form with check boxes, so that when the form is submitted I
have a comma delimited list of amenityid's to work with.  Given the above
table structure, I have no idea how to form this query.

Thanks for any assistance,
Jim

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



RE: AND & OR placement in SQL

2001-09-25 Thread Steven Monaghan

My suggestion when mixing AND & OR is to wrap everything in parentheses.
This way there can be no confusion.

SELECT left(subject,20) as newsubject, * FROM advert_details
WHERE 
(
town = '#form.towny#'
OR 
(
natpaid = Yes 
AND nationwide = Yes
)
)

AND category = '#form.category#'


Is that the correct grouping?

Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:28 PM
To: CF-Talk
Subject: AND & OR placement in SQL


Hi,

Bit confused on the placement of AND & OR operators in the same query.


SELECT left(subject,20) as newsubject, * FROM advert_details
WHERE town = '#form.towny#'
OR (natpaid = Yes AND nationwide = Yes)



AND category = '#form.category#'



Before form.category is defined, the query works as I want it to.  But once
form.category is defined, will the addition of an AND operator muck up the
query?

Thanks

Will

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



Monitoring of Cold Fusion logs

2001-09-25 Thread Steven Monaghan

I am a new Cold Fusion Developer/Administrator and was wondering if anyone
has any suggestions on what to check my logs for.

I'm running on Solaris, and I have a pretty generic log monitoring script
that I can use, but I'm not sure what to look for, meaning which messages
are critical, and which are informational.  Any guidance would be
appreciated.

Thanks in advance,
Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SQL - Oracle Functions

2001-09-24 Thread Steven Monaghan

Not one function, but a combination of two should serve your purpose...

select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'),
A.event_type, A.event,
B.name, B.description
from table_a A, table_b B
where upper(B.name) = substr(upper(a.event), instr(a.event, '.', -1), 2)

A quick explanation,
substr(string, start position, length)

We know the field and the length, so now we need the start position
instr(string, field to find, start position)
Putting a start position of -1 tells oracle to work from the end of the
list.

Hope this works, since I don't have your data to test.  If you still have
problems, let me know.

Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 10:46 AM
To: CF-Talk
Subject: SQL - Oracle Functions


Let me see if I can explain this clearly...I am trying to join 2 tables,
using a field from table A to match just a part of a field in table B
(re-working of my tables and what I store will fix this, but I want to see
if it can be done in my current setup)
 
select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'),
A.event_type, A.event,
B.name, B.description
from table_a A, table_b B
where B.name = "a part of A.event"
 
A.event is a long string of data, stored from a system log, which I can
parse out the name for display purposes with the following cf code:
#Ucase(ListLast(GetToken(event, 2, chr(10)), '.'))#
 
select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'),
A.event_type, A.event,
B.name, B.description
from table_a A, table_b B
where upper(B.name) = '#Ucase(ListLast(GetToken(A.event, 2, chr(10)),
'.'))#'
 
The above does not work, since it does not know the value of A.event.
 
Are there any Oracle functions that can achieve this result?
If not I will just rework the table to parse out the name prior to insertion
and store it in table A to do a straight join (A.name = B.name)
 
Thanks,
Scott


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



Find in-coming form fields

2001-09-24 Thread Steven Monaghan

I have a situation where I need to accept a form, but I don't know the names
of the form fields that are set.

I can't access the posting form, since it's hidden in someone else's app, so
I can't find the names that way.  I want to build a simple page where I can
accept the post, then dump out all of the values in memory into an e-mail.
I looked at the  tag, but that requires the variable name.

I'm new to Cold Fusion, so please indulge me if this is a simple task.

Thanks for any help,
Steve
-----
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: RE: Mystery:Code dissappears/changes on Unix Server

2001-09-17 Thread Steven Monaghan

Here's a possible suggestion: case of the file name.

On Unix, the file names are case sensitive.  So, maybe a piece of code has
the wrong case in a link.  Or when you deploy the file to your server, you
are putting it in the wrong case, since MS doesn't care about case you may
just be putting a second file out instead of overwriting the original file.

I haven't had the specific problems you guys are reporting, but have had
file name case problems before on my Unix box.

Steve
---------
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 11:08 AM
To: CF-Talk
Subject: Re:RE: Mystery:Code dissappears/changes on Unix Server


EC, would love to but there is absolutely no consistency in
the errors.  Could be a what looks like a typing error, 
could be a line of code, could be what looks like reversion to
the prior code,  or it could be code that looks like somebody
else (highly unlikely) touched it -- causing the "Who did this" reaction.

It is never the same .cfm and has happened across programs.
It is not every day or week or month.  It is occassional and
can always be corrected although finding out what the problem
is takes time especially when the program was working the
night before.

I know this sounds like going to a car mechanic and saying
occasionally, sporadically, I hear a "boink" and asking them 
to fix it.  And, in my lifetime, only once and very recently, 
I sheepishly made this crazy kind of report to my mechanic,
expecting the usual -- if it happens again call me -- and,
to my complete and utter surprise, it turned out to be
something very specific for which they had a fix.

So, I'm hoping that is true in this case too!

Carol





Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:RE: Mystery:Code dissappears/changes on Unix Server
Author: [EMAIL PROTECTED]
Date:   9/14/01 11:51 AM

More information is probably needed to make any good suggestion.
Senarios? Error messages? Examples? :)

EC

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 11:04 AM
To: CF-Talk
Subject: Mystery:Code dissappears/changes on Unix Server


Hi all. 

We have been experiencing code problems on our Unix server.
Pages that are working on day 1 are NOT working on day 2.
It is NOT multiple developers hitting the same code at the
same time as far as we can track.  It is NOT that changes
are not being received by the server, we can see the effects
of changed code.  

We are working on an NT platform with our data stored on
SYBASE IQ12 and ColdFusion on a UNIX platform.

Any and all possible solutions would be appreciated and
will be explored.

Thanks,
Carol


Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335



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



Recall: REGEX to strip special characters

2001-09-14 Thread Steven Monaghan

Steven Monaghan would like to recall the message, "REGEX to strip special
characters".

This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: REGEX to strip special characters

2001-09-14 Thread Steven Monaghan

Here's what I did...

Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 3:34 PM
To: CF-Talk
Subject: Re: REGEX to strip special characters


try

   x=ReReplaceNoCase(x, "[^a-z0-9]", "", "All">

hth

dick

At 1:32 PM -0400 9/13/01, Joshua Miller wrote:
>Anyone know of a REGEX to strip special characters from a string?
>

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



RE: CF_BOOLSEARCH tag

2001-09-13 Thread Steven Monaghan

Thanks for the help.

I did indeed find the tag.  I was looking for a file named
cf_boolsearch.cfm, not boolsearch.cfm.

Also, thanks for the link to the tag source.  I was modifying the source to
work with an Oracle database (which is case sensitive, unlike the Sql Server
db that was being used).

If anyone wants a copy of the modified tag, please let me know.

Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:41 AM
To: CF-Talk
Subject: Re: CF_BOOLSEARCH tag


Go to this URL:
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476C7-2830-11D4-AA
9700508B94F380&method=Full

Here you will find this tag as well as an explanation as to what it does.
- Original Message -
From: "Steven Monaghan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 9:26 AM
Subject: CF_BOOLSEARCH tag


> I am new to Cold Fusion have inherited an application written by outside
> consultants that is being brought in-house.  In the code I see a tag
> CF_BOOLSEARCH.  I have not installed any custom tags, so I don't think it
is
> one, yet I can't find any documentation/information on this tag.
>
> Can anyone help?
>
> Steve
> -
> Steven Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> [EMAIL PROTECTED]
> http://www.mscdirect.com
> -
>
>
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you are not the intended recipient, please do
not
> read, copy, use or disclose the contents of this communication to others.
> Please notify the sender that you have received this e-mail in error by
> replying to the e-mail.  Please then delete the e-mail and destroy any
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF_BOOLSEARCH tag

2001-09-13 Thread Steven Monaghan

I am new to Cold Fusion have inherited an application written by outside
consultants that is being brought in-house.  In the code I see a tag
CF_BOOLSEARCH.  I have not installed any custom tags, so I don't think it is
one, yet I can't find any documentation/information on this tag.

Can anyone help?

Steve
-----
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Verity search of PDF's

2001-09-12 Thread Steven Monaghan

Yes it can...Just did it here a few weeks ago.

Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Brian Scott Barnett [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:57 PM
To: CF-Talk
Subject: Verity search of PDF's


I just got CF 5.  Does anyone know if the verity search engine in it can be
configured to search PDF documents via text search?

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SQL help for a brain that's not awake yet

2001-09-10 Thread Steven Monaghan

What about using UNION?

select count(*) from
(
SELECT * as Total FROM Cycles WHERE BrandNameID1_1=#LoopIndex#)
union
SELECT * as Total FROM Cycles WHERE BrandNameID2_1=#LoopIndex#)
union
.
.
.


Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 11:52 AM
To: CF-Talk
Subject: SQL help for a brain that's not awake yet


I know the answer to my problem is easy I just can't seem to get my brain
functioning today. 

My problem is that I want to get the number of times an integer ID appears
in a list of columns for every row in a table. The integer ID is from an
outer SQL statement that I am looping through. 

An example
Current ID = 1
DBColumn 1  DBColumn 2

1  1
2  1
1  1
The result should be 5. The second time I loop through the outer sql
statement the ID would be 2 and the result should = 1

Here is what the current SQL statement looks like:
SELECT Count(*) as Total FROM Cycles WHERE (BrandNameID1_1=#LoopIndex# OR
BrandNameID2_1=#LoopIndex# OR BrandNameID3_1=#LoopIndex# OR
BrandNameID1_2=#LoopIndex# OR BrandNameID2_2=#LoopIndex# OR
BrandNameID3_2=#LoopIndex# OR BrandNameID1_3=#LoopIndex# OR
BrandNameID2_3=#LoopIndex# OR BrandNameID3_3=#LoopIndex#)

This however returns only the number of rows that have the loop index in it.

I know there is probably an easy solution to this but for the life of me I
can't think straight today. 

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



Problem with re-direct to other site.

2001-09-07 Thread Steven Monaghan

All,

We are in the process of trying to bring a website currently hosted
externally in-house.  As part of the process, I removed all hard-coded
references to the URL in the code and set up a web server.  Instead of using
the DNS, I am testing using IP:port.

In my development environment, it appears that any reference to the root
directory of the web goes to production.

For example, a link that references /index.htm will not go to
http://1.1.1.1:80/index.htm.  Instead, it will go to
http://www.production-site.com/index.htm.  This makes it impossible to test.

I took a quick look at the both the Netscape and the Cold Fusion
administration applications, but don't see any settings that would control
the root being something other than the server itself.

Does anyone have an idea where to look?  I already reviewed all of the code,
and there are no references to the other address in the code.  

HELP!!!

Thanks in advance,
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists