RE: How the heck can I do this?

[Daniel Wm Brick III]

Jeff,

It looks like you only need a CFIF statement that checks the current row
being processed by the CFOUTPUT statement, such as:




Anonymous  #BidDate#

#Alias# #BidAmount# #BidDate#





Hope it helps!
dBIII+

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: How the heck can I do this?


As it stands, the output will show all bids. I need it to show a place
holder

for the first top 4 bids like  and show the 5th highest bid. The idea is

that the bidders can't see the top 4 bids.

Jeff Fongemie







SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,

BidDate, Alias

FROM bids

ORDER BY bidAmount desc









Bids Are...







Alias Amt. Bid Bid Date





#Alias# #BidAmount# #BidDate#
















"Steve DeWitt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> can you post the code?
>
> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 5:19 AM
> To: [EMAIL PROTECTED]
> Subject: How the heck can I do this?
>
>
> I'm setting up a real simple auction application. Super simple. People
>
> submit bids via a form, then the top 5 bids are displayed on a page. The
>
> catch is, I only want the 5th highest bid to show the actual bid.
>
> So, I can order the query by bid descending and for output bids 1 through
5
>
> will give the bidders name, but I need to have the bid amounts hidden for
>
> the top 4 bids, and show the 5th.
>
> To display only the top 5 bids, I'm using maxrows =5 in my output. Is
there
>
> a way to control all this stuff with the SQL, or do I have a basic query,
>
> order by bid desc. and control the results through output?
>
> With the output method, I can't seem to be able to get the results to
>
> populate the 5th bid amt., but not the first 4.
>
> Thanks,
>
> Jeff Fongemie
>
>
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: How the heck can I do this?

[Daniel Wm Brick III]

Jeff,

It looks like you only need a CFIF statement that checks the current row
being processed by the CFOUTPUT statement, such as:




Anonymous  #BidDate#

#Alias# #BidAmount# #BidDate#





Hope it helps!
dBIII+

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: How the heck can I do this?


As it stands, the output will show all bids. I need it to show a place
holder

for the first top 4 bids like  and show the 5th highest bid. The idea is

that the bidders can't see the top 4 bids.

Jeff Fongemie







SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,

BidDate, Alias

FROM bids

ORDER BY bidAmount desc









Bids Are...







Alias Amt. Bid Bid Date





#Alias# #BidAmount# #BidDate#
















"Steve DeWitt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> can you post the code?
>
> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 5:19 AM
> To: [EMAIL PROTECTED]
> Subject: How the heck can I do this?
>
>
> I'm setting up a real simple auction application. Super simple. People
>
> submit bids via a form, then the top 5 bids are displayed on a page. The
>
> catch is, I only want the 5th highest bid to show the actual bid.
>
> So, I can order the query by bid descending and for output bids 1 through
5
>
> will give the bidders name, but I need to have the bid amounts hidden for
>
> the top 4 bids, and show the 5th.
>
> To display only the top 5 bids, I'm using maxrows =5 in my output. Is
there
>
> a way to control all this stuff with the SQL, or do I have a basic query,
>
> order by bid desc. and control the results through output?
>
> With the output method, I can't seem to be able to get the results to
>
> populate the 5th bid amt., but not the first 4.
>
> Thanks,
>
> Jeff Fongemie
>
>
>
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

File Upload Size Limitation?

[Daniel Wm Brick III]

Hello all,

I created a quick and dirty couple of templates to allow a friend to upload
files to my web server.
I've run into a file upload size limitation that's really giving me
headaches.
Using  on the form and  on the action page, I've successfully uploaded
files up to 1.38mb in size.  Anything bigger than that, and I get:

Error writing data from web server to the ColdFusion Application 
Server.
Windows NT error number 1450 occurred.

I've tried this on two completely unrelated CF servers with with the same
result:
CF 4.5 on Win2k/IIS5
CF 4.01 on NT4/SP6/IIS4

Is this a known limitation?  With IIS?  CF?  Any way around this?

Thanks in advance,
dBIII+

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Obtain # of Files in a DIRECTORY

[Daniel Wm Brick III]

You could use the CFDIRECTORY tag and then use the RecordCount variable on
the query that is generated... for instance:



Number of files: #Pics.RecordCount#


Good luck!
dBIII+

-Original Message-
From: Gregory Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 1:32 PM
To: '[EMAIL PROTECTED]'
Subject: Obtain # of Files in a DIRECTORY


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFAE13.01D459EE
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need to get a count of the number of files in a particluar =
directory.=A0 I
know that CFFILE allows you to do several FILE operations, but how =
would you
actually get a count of the number of files that exist in a particular
directory.
=A0
Thanks in advance for your help.
=A0
Gregory L. Weiss
Web Development Project Leader
Trapezoid, Inc.
4107 Laguna Street
Coral Gables, Florida 33146
(305) 442-8060 x230
  [EMAIL PROTECTED]
=A0

--_=_NextPart_001_01BFAE13.01D459EE
Content-Type: text/html;
charset="iso-8859-1"








I need to get a
count of the number of files in a particluar directory.  I know that
CFFILE
allows you to do several FILE operations, but how would you actually get a
count
of the number of files that exist in a particular
directory.
 
Thanks in
advance
for your help.
 
Gregory L.
Weiss
Web Development Project Leader
Trapezoid, Inc.
4107 Laguna Street
Coral Gables, Florida 33146
(305) 442-8060 x230
mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]

 

--_=_NextPart_001_01BFAE13.01D459EE--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Problem controlling output

[Daniel Wm Brick III]

The name of the field returned by your SELECT statements is 'a', not
'JokeTitle'.
Since all of your SELECT statements are named 'a', then your values will be
returned in FORM.a as a list of JokeIDs.
In other words, FORM.a will be '1,3,9,15,4' or something similar.
In order to output a joke for each JokeID, you'll have to loop through the
list and query the database for each JokeID, as detailed in this
modification of your form action template:





 JokeAction





SELECT Joke
FROM WordJokes
WHERE JokeID=#MyIndex#


#Joke#






Hope this works for you.  Good luck!
dBIII+


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 2:18 AM
To: [EMAIL PROTECTED]
Subject: Problem controlling output


Hi,

I'm having a problem controlling the output of a form.  I have a form which
allows the user to choose up to 5 joke titles from a joke database, and a
form action template which should result in the output of just those 5
jokes, the titles of which were chosen on the form.  However, the entire
database gets output.  I've pasted the code of the form and action template
below.  Please advise me.

The form code:



SELECT JokeID, JokeTitle
FROM WordJokes
ORDER BY JokeTitle






 Jokes




JOKES



Please select joke titles from the contents of the select boxes below.  You
may select up to five titles at a time.

Joke title #1:


  
#JokeTitle#



Joke title #2:


  
#JokeTitle#



Joke title #3:


  
#JokeTitle#



Joke title #4:


  
#JokeTitle#



Joke title #5:


  
#JokeTitle#











--

The form action template:


SELECT Joke
FROM WordJokes
WHERE JokeTitle=JokeTitle








 JokeAction




#Joke#




---
Hubert Earl
ICQ#:  16199853

I develop & maintain web sites internationally.  I also build web
applications using CGI scripts written in Perl.  I accept subcontracting
work.

**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/
(please remember to view this with a sense of humour!)

**Business web page:  http://home.talkcity.com/MigrationPath/hearl/



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Application.cfm Question...

[Daniel Wm Brick III]

Application variables are only persistent because application.cfm file is
pre-pended to each and every template that is opened (not CFINCLUDED) by the
CF server.

The rule goes that the CF server will first search the current directory
where the CF template is located for an application.cfm file and pre-pend
it.  If not found in the current directory, it will search upwards from the
current directory until it finds one.  I believe the search stops at the web
root.

Hope this answers your question.

dBIII+

-Original Message-
From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 4:42 PM
To: Cf-Talk
Subject: Application.cfm Question...


Are application.(variablename) variables truly persistent. I am a bit
confused here. I know that only one application.cfm file is executed
automatically at any given time (others would have to be CFINCLUDEd).

I have a main application.cfm file in the root of the site. I set the
cfapplication (application and session management, name, etc.). I then set a
few application variables like application.dsn and application.sitename,
etc. That's about it.

(ex: main root application.cfm)




 




A directory level down I add another application.cfm that does a very quick
security check for user access to this area (yes/no field in db). In the
CFQUERY I use a datasourcename="#application.dsn#". I have, in the past,
just copied the application.cfm from the root into the other folder and
deleted anything not necessary, leaving the cfapplication and application
variables, then adding any other code.





SELECT PeopleID, PeopleFirstName, PeopleLastName, PeopleDACStaff
FROM tblPeople
WHERE PeopleID = #cookie.PeopleID#







Today I went ahead and deleted everything EXCEPT the little security query
(above) to see what would happen. Now the application can't seem to find my
application.dsn variable.

Does the running of another application.cfm file flush the variables created
previously?

Shouldn't the application variables be available for the life of the
application AS LONG as they are not flushed (STRUCTCLEARED or DELETED) or
changed?

Why would running another application.cfm, that does not delete or change
the earlier set application variables, make them unavailable to the
application?

Do you have to re-create the application.cfm file for each subfolder?

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Application.cfm Question...

[Daniel Wm Brick III]

One other thing I forgot to mention in my previous mail is that once it
finds the first application.cfm file during the search from the current
directory upwards, it stops.  It does not search upwards for any more
application.cfm files.

So, if you have an application.cfm file in your root, and another
application.cfm in a subdirectory of /control, and you open any template in
the /control directory, it will pre-pend the application.cfm file from the
/control directory and nothing else.

dBIII+

-Original Message-
From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 4:42 PM
To: Cf-Talk
Subject: Application.cfm Question...


Are application.(variablename) variables truly persistent. I am a bit
confused here. I know that only one application.cfm file is executed
automatically at any given time (others would have to be CFINCLUDEd).

I have a main application.cfm file in the root of the site. I set the
cfapplication (application and session management, name, etc.). I then set a
few application variables like application.dsn and application.sitename,
etc. That's about it.

(ex: main root application.cfm)




 




A directory level down I add another application.cfm that does a very quick
security check for user access to this area (yes/no field in db). In the
CFQUERY I use a datasourcename="#application.dsn#". I have, in the past,
just copied the application.cfm from the root into the other folder and
deleted anything not necessary, leaving the cfapplication and application
variables, then adding any other code.





SELECT PeopleID, PeopleFirstName, PeopleLastName, PeopleDACStaff
FROM tblPeople
WHERE PeopleID = #cookie.PeopleID#







Today I went ahead and deleted everything EXCEPT the little security query
(above) to see what would happen. Now the application can't seem to find my
application.dsn variable.

Does the running of another application.cfm file flush the variables created
previously?

Shouldn't the application variables be available for the life of the
application AS LONG as they are not flushed (STRUCTCLEARED or DELETED) or
changed?

Why would running another application.cfm, that does not delete or change
the earlier set application variables, make them unavailable to the
application?

Do you have to re-create the application.cfm file for each subfolder?

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Application.cfm Question...

[Daniel Wm Brick III]

Whoops.  Here's a classic case of not understanding the question before
answering it.  (Hey! It was 1am!) Sorry 'bout that.  I'm booking passage
off-planet now. ;)

dBIII+

-Original Message-----
From: Daniel Wm Brick III [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 1:08 AM
To: [EMAIL PROTECTED]
Subject: RE: Application.cfm Question...


Application variables are only persistent because application.cfm file is
pre-pended to each and every template that is opened (not CFINCLUDED) by the
CF server.

The rule goes that the CF server will first search the current directory
where the CF template is located for an application.cfm file and pre-pend
it.  If not found in the current directory, it will search upwards from the
current directory until it finds one.  I believe the search stops at the web
root.

Hope this answers your question.

dBIII+

-Original Message-
From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 4:42 PM
To: Cf-Talk
Subject: Application.cfm Question...


Are application.(variablename) variables truly persistent. I am a bit
confused here. I know that only one application.cfm file is executed
automatically at any given time (others would have to be CFINCLUDEd).

I have a main application.cfm file in the root of the site. I set the
cfapplication (application and session management, name, etc.). I then set a
few application variables like application.dsn and application.sitename,
etc. That's about it.

(ex: main root application.cfm)




 




A directory level down I add another application.cfm that does a very quick
security check for user access to this area (yes/no field in db). In the
CFQUERY I use a datasourcename="#application.dsn#". I have, in the past,
just copied the application.cfm from the root into the other folder and
deleted anything not necessary, leaving the cfapplication and application
variables, then adding any other code.





SELECT PeopleID, PeopleFirstName, PeopleLastName, PeopleDACStaff
FROM tblPeople
WHERE PeopleID = #cookie.PeopleID#







Today I went ahead and deleted everything EXCEPT the little security query
(above) to see what would happen. Now the application can't seem to find my
application.dsn variable.

Does the running of another application.cfm file flush the variables created
previously?

Shouldn't the application variables be available for the life of the
application AS LONG as they are not flushed (STRUCTCLEARED or DELETED) or
changed?

Why would running another application.cfm, that does not delete or change
the earlier set application variables, make them unavailable to the
application?

Do you have to re-create the application.cfm file for each subfolder?

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: OT:IE and bookmark icons?

[Daniel Wm Brick III]

I have always wanted to know how to do this since I saw it done for the
first time.
Only now that you mention it, I figured out a way to find out how it's done:
I have at my disposal a proxy that I can watch to see what web requests are
made when pulling up a web site...
When I created the URL shortcut for a few sites that I know that have custom
icons, I noticed the file 'favicon.ico' being pulled.  :)
I tried it on my own site and it works.  I put a custom icon in the web root
by the name of 'favicon.ico'.  Any web page that I pull up in the root or
any subdirectories gets this icon.

Enjoy!
dBIII+

-Original Message-
From: Reuben King [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 3:05 PM
To: [EMAIL PROTECTED]
Subject: OT: IE and bookmark icons?


Some sites, like www.google.com, when you add them to your favorites,
the icon for the bookmark file is a custom icon.  I have looked at the
HTML source and found nothing out of the ordinary.. I'm guessing there
is a .gif or .ico file at the host site that IE looks for?  Anybody know
the particulars?

TIA,
-R

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFUPDATE

[Daniel Wm Brick III]

I've only ever seen this happen once, and it was because the hidden input
field that specified the primary key wasn't enclosed in CFOUTPUT tags.  Eg.


instead of





It was passing #ID# instead of the actual record ID.  Every time I tried to
update the record, the server would just sort of hang... I could do other
stuff in CF, but it was very slow.

Good Luck!
dBIII+

-Original Message-
From: Richard Hart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 12:46 PM
To: House of Fusion
Subject: CFUPDATE


Hi

I've been trying to update a record using cfupdate,
however it seems to be hanging in a continous loop
whenever I try to submit the updates.  Does anyone know
what the cause could be?

Any help would be greatly appreciated.

Thanks,

Richard

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

file checksum...

[Daniel Wm Brick III]

Greetings all,
 
Anybody know of a cfx or CF script that can quickly (the key
word here is "quickly") calculate a checksum for a given file?
 
TIA,
dBIII+

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

CFDIRECTORY on Redhat 7.0??

[Daniel Wm Brick III]

Help!  I've been using the CFDIRECTORY tag on an NT box to list directories
under my web site's home dir that start with "pics_".  I just recently moved
my entire site to a Linux box (running Redhat 7), and now the query always
returns empty.  I can match entire directory names or everything in the
directory by not using the filter, but nothing with wildcards.  For
instance, using "pics_general" as the filter will work, but "pics_*" (see
line below) will not.  Does anybody know why I can't use wildcards for
directory matching?



TIA,
dBIII+


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

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

RE: CFDIRECTORY on Redhat 7.0??

[Daniel Wm Brick III]

Thanks, that had ocurred to me.  I've made sure everything is in lowercase.
Anything that isn't would be after the pics_ prefix in the directory name,
which I assume would match with the * wildcard... still, it doesn't work.

dBIII+

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 11:39 AM
To: CF-Talk
Subject: Re: CFDIRECTORY on Redhat 7.0??


Linux is case sensitive so /home/sites/mysite.com/ is not the same as
/Home/Sites/Mysite.com/ and "pics" is not the same as "Pics".  So, I would
make sure to match the case of what I'm searching for.

HTH,

Howie

----- Original Message -
From: "Daniel Wm Brick III" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 21, 2001 12:33 PM
Subject: CFDIRECTORY on Redhat 7.0??


> Help!  I've been using the CFDIRECTORY tag on an NT box to list
directories
> under my web site's home dir that start with "pics_".  I just recently
moved
> my entire site to a Linux box (running Redhat 7), and now the query always
> returns empty.  I can match entire directory names or everything in the
> directory by not using the filter, but nothing with wildcards.  For
> instance, using "pics_general" as the filter will work, but "pics_*" (see
> line below) will not.  Does anybody know why I can't use wildcards for
> directory matching?
>
>  filter="pics_*">
>
> TIA,
> dBIII+
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Query help

[Daniel Wm Brick III]

Try this:

SELECT ID, Name, "table1" as WhichTable
FROM Table1
WHERE Name LIKE '%#search$%'

UNION

SELECT ID, Name, "table2" as WhichTable
FROM Table2
WHERE Name LIKE '%#search#%'
-

This will return the results as one query.
The "WhichTable" field will tell you which table you got the row from.
Good luck,
dBIII+
-Original Message-
From: Katrina Chapman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:09 AM
To: CF-Talk
Subject: Query help


Merry Meet,

I have a query that pulls data from almost identical tables and I need to
know which rows come from which tables.

IE:

SELECT id, name
FROM table1, table2
WHERE table1.name LIKE '%#search#%'
OR table2.name LIKE '%#search#%'

then in the output I need to know which table (1 or 2) each record comes out
of.  Can this be done?  If so how?

Blessed Be,
--Katrina Chapman
http://www.katrinachapman.com
http://www.cfchick.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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