RE: Extracting Text from PDF Documents with CF

2001-07-15 Thread Dennis Powers

Kevin,

I downloaded the win32 version and can't seem to make it work.  What command
line parameters do you use?

Best Regards,

Dennis Powers
UXB Internet
(203) 879-2844
http://www.uxbinfo.com/

-Original Message-
From: Kevin Ward [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 4:19 PM
To: CF-Talk
Subject: RE: Extracting Text from PDF Documents with CF


Dennis,

You might take a look at using a combination of pstotext (
http://www.research.compaq.com/SRC/virtualpaper/pstotext.html ) and
Ghostscript ( http://www.ghostscript.com/ )

I currently use this arrangement to do pretty much what you are requesting.

HTH,

Kevin

At 02:36 PM 7/13/01 -0400, you wrote:
For this project we are using CF 4.01 (client's server) and we are using
verity to index the database, with excellent results.  Using verity to
index
the PDF files is not an option in this case.

What we are looking for is either a CFX or a COM object that can be called
from CF to extract the raw unformatted ASCII text from the PDF files.
Anyone know of such an animal?

Best Regards,

Dennis Powers
UXB Internet
(203) 879-2844
http://www.uxbinfo.com/

-Original Message-
From: Robert Rusher [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 1:41 PM
To: CF-Talk
Subject: RE: Extracting Text from PDF Documents with CF

Verity requires a filter for the indexing of PDF
documents. This filter is provided with CF in most
cases.
The version of Verity that is included in ColdFusion
4.5.1 for Linux and HP-UX does not include a filter
for PDF files.

Regards,
Rob
--- Jann VanOver [EMAIL PROTECTED] wrote:
  I thought Verity could index the text in PDFs
  automatically!  It did with
  previous versions of Acrobat.  You can create a
  Verity index that indexes
  your database AND other files (pdfs) that you want.
  Try it and see.
 
  -Original Message-
  From: Dennis Powers [mailto:[EMAIL PROTECTED]]
  Sent: Friday, July 13, 2001 9:00 AM
  To: CF-Talk
  Subject: Extracting Text from PDF Documents with CF
 
 
  Hi,
 
  I am wondering if anyone has a method of extracting
  the raw (unformatted)
  text from a PDF file using CF?  I have a project
  were we need to index PDF
  files AND associated information in a database.  We
  are currently using
  Verity for searching the database with great success
  but now we need to
  index the PDF files that are associated with the
  data records in the
  database.
 
  When a user uploads a new PDF I would like to
  extract the text from it and
  add it to the database with the other information.
  Then I can use Verity to
  search all the data fields AND the PDF text data
  field.
 
  A CFX or a COM object would be nice so that I can
  call it from CF. I would
  be very appreciative if anyone can steer me to a tag
  or object that can
  accomplish this task.
 
  Best Regards,
 
  Dennis Powers
  UXB Internet
  (203) 879-2844
  http://www.uxbinfo.com/
 

-
Kevin Ward
Web Developer
Lattice Semiconductor Corporation
 NE Moore Court
Hillsboro, OR 97124-6421
Ph: 503.268.8656
Fx: 503.268.8693
[EMAIL PROTECTED]
http://www.latticesemi.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: php info

2001-07-15 Thread W Luke

www.devshed.com is a great resource too.

hth

--
Will
new media discussion for Berkshire -=- http://bnm.lukrative.com
local classifieds -=- http://www.localbounty.com
e: [EMAIL PROTECTED]  icq: 31099745

- Original Message -
From: Bruce, Rodney [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Friday, July 13, 2001 7:21 PM
Subject: OT: php info


 Anyone have a good place to go to get information on learning php?

 THanks


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

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



CFX and the caller scope?

2001-07-15 Thread Bryan LaPlante

I have a lot of cfml custom tags and I am learning to write them in Java. I
have looked in the cf-talk and cfx-talk archives as well as all the Allaire
doc's I could find and searched via google finding no information about
interacting with the different scopes of the calling template.

Is it possible to communicate with the different scopes, session,
application, caller and so on?
I also tried to invoke the javadoc on cfx.jar file to see if I could take a
look at the class documentation and I keep getting a class constructor
expected error so the html docs never get created. Any insight or help would
be appreciated.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


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



Test

2001-07-15 Thread Dick Applebaum



~~
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: Loading file into another application

2001-07-15 Thread phumes1


Hi,

I have a list of files that I would like to send to another application 
(UltraEdit).

When a user clicks on the hyperlink that file will be opened in the editor. 
Can this easily be done?


~~
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: Kinda OT: Search by zip code

2001-07-15 Thread David Shadovitz

I can't resist:
Be careful with your calculations, or you'll go the WRONG WAY CORRIGAN.
(See http://www.thehistorynet.com/AviationHistory/articles/2001/0501_cover.htm)

-David

On Wednesday, July 11, 2001 1:41 PM, [EMAIL PROTECTED] 
[SMTP:[EMAIL PROTECTED]] wrote:
 I have to write a search function that locates businesses by their zip code
 and return businesses within a certain  mile radius.  I've never done that
 before and I was wondering if anyone else had to do it and how because I have
 not a clue in how to begin that one.

 Thanks,

 Michael Corrigan

~~
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: Sorting on Two Queries

2001-07-15 Thread Skyward Internet Technology

Lee,  How does that help me.  I need the items in query 1 to display, unless
there is an item in query 2 during the same time slot, then the time from
query two displays instead.  Example below:

Query 1 Query 2   Display
6am - 10amQ1 6am-10am
10am - 2pmQ1 10am-2pm
2pm - 4pm2pm - 6pm  Q2  2pm - 6pm
4pm - 9pm  Q1  6pm - 9pm

Dave







- Original Message -
From: Lee Fuller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 13, 2001 10:49 PM
Subject: RE: Sorting on Two Queries


 Sure Dave..

 Are you using CF5? If so, there is a new feature called Query-a-Query.
 You can actually set a query to run on an existing query's values.


 Lee Fuller
 Chief Technical Officer
 PrimeDNA Corporation / AAA Web Hosting Corporation
 We ARE the net.
 http://www.aaawebhosting.com



  -Original Message-
  From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]]
  Sent: Friday, July 13, 2001 7:37 PM
  To: CF-Talk
  Subject: Sorting on Two Queries
 
 
  I've got a situation where I have scheduling information in
  two different databases (different DSN's).  Here's what I
  need.  I need to query both and in the output, if there is
  something in the schedule from table 2 that is scheduled
  during the same time as something in table 1, the table 2
  info needs to be displayed instead of the table 1 info.  Can
  someone suggest a good approach to this?  I've downloaded
  CF_QueryUnion and have been working with that.
 
  Thanks,
  Dave
 
 
 
 

~~
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: Forms+SQL+Params

2001-07-15 Thread David Shadovitz

If so, that's one good reason to use CGI.SCRIPT_NAME for the form's action 
template.
cfform action=#CGI.SCRIPT_NAME# method=post
-David

On Thursday, July 12, 2001 1:48 PM, Lee Moore [SMTP:[EMAIL PROTECTED]] wrote:
 I'm assuming that the form is posting to itself since you did not give the
 name of the file.

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



SOT: Remove dead projects from Studio drop-down list?

2001-07-15 Thread Lee Fuller

Has anyone figured out how to remove a project from the drop-down in
Studio, when that project is dead or has been deleted (either on purpose
or by mistake)?

I can't seem to get the little bugger off that drop-down menu.

TTAIA


PS - This is the second send to the list.  The last came back
undeliverable. (?)


~~
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: Extracting Text from PDF Documents with CF

2001-07-15 Thread David Shadovitz

There's a little bit on using COM to access PDF info in CF at CF Comet, 
www.cfcomet.com/.

The Adobe website has tons of documentation.  See chapter 4 of the 
Interapplication Communication (IAC) Overview at 
  http://partners.adobe.com/asn/developer/acrosdk/docs/iac/IACOverview.pdf. 
 Objects of interest include AcroExch.App, AcroExch.AVDoc and AcroExch.PDDoc.

-David

On Friday, July 13, 2001 9:00 AM, Dennis Powers [SMTP:[EMAIL PROTECTED]] 
wrote:
 Hi,

 I am wondering if anyone has a method of extracting the raw (unformatted)
 text from a PDF file using CF?  I have a project were we need to index PDF
 files AND associated information in a database.  We are currently using
 Verity for searching the database with great success but now we need to
 index the PDF files that are associated with the data records in the
 database.

 When a user uploads a new PDF I would like to extract the text from it and
 add it to the database with the other information.  Then I can use Verity to
 search all the data fields AND the PDF text data field.

 A CFX or a COM object would be nice so that I can call it from CF. I would
 be very appreciative if anyone can steer me to a tag or object that can
 accomplish this task.

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



can I combine this query somehow?

2001-07-15 Thread Terri Stocke

Hey group,

I'm creating a search interface for my users, and due to the potential 
number of records being returned by the searches, I really need to use Next 
N browsing to display the returned records.

However, since I cannot use more than one query with Next N browsing, I 
either need to find a way to combine my queries into one, or find an 
alternate navigation method that will allow more than one query in the 
results.

The situation is this:
I am pulling almost all of the information from a table called MAIN. 
However, there is a Regions column (VARCHAR) in the table that stores 
numbers in a comma-delimited format (e.g. '2000,3110,4300'). What I need to 
do is somehow pull the actual menu item name from the REGIONS reference 
table to correspond with each ID number in the MAIN.REGION list. BUT, I need 
to do this all in ONE query to use Next N browsing.

So, does anyone have any ideas as to how I can either combine these queries 
to pull both the information from MAIN and from REGIONS, OR, does anyone 
have an alternate record navigation idea that would allow me to use multiple 
queries in the results?

Thanks!
Terri
~~
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: sharing a structure with the calling template

2001-07-15 Thread Rich Tretola

OK here is my question.  I would like to run an application with several
accounts sharing the same code based on their id.  I know that I could
simply include the id in each url like http://www.whatever.com/?id=#id# but
I would really like a cleaner look like http://www.whatever.com/#id#  Is
there anyway to do this through 1 main directory or would the code have to
duplicated for each id.  I hope I am explaining myself if not I will try to
clarify.

Rich


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

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



RE: Unrelated

2001-07-15 Thread David Shadovitz

How about http://docushare.xerox.com/
-David

On Thursday, July 12, 2001 3:29 PM, bajaria aslam [SMTP:[EMAIL PROTECTED]] 
wrote:
 Hi All,
 sorry to post a question that is not related to
 coldfusion.

 Does anyone know of any mailing list for Docushare (
 it is document management software product from a
 product from Xerox).
 I could not find any books on it either. I need to
 make a report on whether it is good to have it for the
 company or not.

 Any suggestion is welcome
 Can anyone help me on this.

~~
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: Client variable storage

2001-07-15 Thread Bud

OK, I gather that the general consensus is that there are no security 
issues to speak of? At least as long as we're not storing sensitive 
information as client variables.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

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



RE: Client variable storage

2001-07-15 Thread Bud

On 7/13/01, Dave Watts penned:
   Why is it that some hosts won't store client variables in a
   default database?

If you change the default client variable storage repository to a database,
you won't be able to access the CF Administrator if you can't connect to the
database. You can fix this by going into the registry and changing the
appropriate value, but that's my guess why they do it like they do.

I believe CF Administrator uses the registry no matter what the 
default is. I use an Access database on my development machine as the 
default client storage and just renamed it and accessed CF 
Administrator just fine.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

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



RE: Remove dead projects from Studio drop-down list?

2001-07-15 Thread David Shadovitz

CF Studio 4.5:
Select the project in the Projects tab.
Select the globe icon.
Right-click and select Delete Project

-David

On Saturday, July 14, 2001 7:29 PM, Lee Fuller [SMTP:[EMAIL PROTECTED]] 
wrote:
 Has anyone figured out how to remove a project from the drop-down in
 Studio, when that project is dead or has been deleted (either on purpose
 or by mistake)?

 I can't seem to get the little bugger off that drop-down menu.

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

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



RE: Sending one CFMAIL

2001-07-15 Thread Cameron Childress

Um...  You are writing grades, names and course info to the email, and you
want them all to get the same message?  Unless they all have the same name
and grade, I'd keep it how you have it.

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, July 15, 2001 1:27 PM
 To: CF-Talk
 Subject: Sending one CFMAIL


 How can I send email from a query so that all the info is in one email
 rather than sending individual e-mails for each person in the query?  IOW:
 If 50 people fit the criteria then I get 50 individual e-mails rather than
 one email with all the people. Currently my code is:

 CFMAIL query = badgrade
 FROM=Eagle
 To=#facemail.email#
 Subject=Results
 TYPE=HTML
 b#lname#, #fname#/b
 Course: #ssbsect_subj_code# #ssbsect_crse_numb#
 CRN: #sfrstcr_crn#
 Grade: #grades#brbr
 /CFMAIL

 Jim Watkins
 http://www.ngtcollege.org



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

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



RE: Sending one CFMAIL

2001-07-15 Thread Lee Fuller

You'll have to wrap the CFMAIL in a CFLOOP.  Loop through the query, and
do a CFMAIL for each matching criterion.



 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, July 15, 2001 10:27 AM
 To: CF-Talk
 Subject: Sending one CFMAIL
 
 
 How can I send email from a query so that all the info is in 
 one email rather than sending individual e-mails for each 
 person in the query?  IOW: If 50 people fit the criteria then 
 I get 50 individual e-mails rather than one email with all 
 the people. Currently my code is:
 
 CFMAIL query = badgrade
 FROM=Eagle
 To=#facemail.email#
 Subject=Results
 TYPE=HTML
 b#lname#, #fname#/b
 Course: #ssbsect_subj_code# #ssbsect_crse_numb#
 CRN: #sfrstcr_crn#
 Grade: #grades#brbr
 /CFMAIL
 
 Jim Watkins
 http://www.ngtcollege.org
 
 

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

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



RE: Sending one CFMAIL

2001-07-15 Thread Robert Segal

CFMAIL FROM=Eagle To=#facemail.email# Subject=Results TYPE=HTML
CFLOOP QUERY=BADGRADE
b#lname#, #fname#/b
Course: #ssbsect_subj_code# #ssbsect_crse_numb#
CRN: #sfrstcr_crn#
Grade: #grades#brbr
/CFLOOP
/CFMAIL

-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 1:27 PM
To: CF-Talk
Subject: Sending one CFMAIL


How can I send email from a query so that all the info is in one email
rather than sending individual e-mails for each person in the query?  IOW:
If 50 people fit the criteria then I get 50 individual e-mails rather than
one email with all the people. Currently my code is:

CFMAIL query = badgrade
FROM=Eagle
To=#facemail.email#
Subject=Results
TYPE=HTML
b#lname#, #fname#/b
Course: #ssbsect_subj_code# #ssbsect_crse_numb#
CRN: #sfrstcr_crn#
Grade: #grades#brbr
/CFMAIL

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

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



RE: Sending one CFMAIL

2001-07-15 Thread Lee Fuller

Or the other way around ;)



 -Original Message-
 From: Robert Segal [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, July 15, 2001 10:58 AM
 To: CF-Talk
 Subject: RE: Sending one CFMAIL
 
 
 CFMAIL FROM=Eagle To=#facemail.email# Subject=Results 
 TYPE=HTML
   CFLOOP QUERY=BADGRADE
   b#lname#, #fname#/b
   Course: #ssbsect_subj_code# #ssbsect_crse_numb#
   CRN: #sfrstcr_crn#
   Grade: #grades#brbr
   /CFLOOP
 /CFMAIL
 
 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, July 15, 2001 1:27 PM
 To: CF-Talk
 Subject: Sending one CFMAIL
 
 
 How can I send email from a query so that all the info is in 
 one email rather than sending individual e-mails for each 
 person in the query?  IOW: If 50 people fit the criteria then 
 I get 50 individual e-mails rather than one email with all 
 the people. Currently my code is:
 
 CFMAIL query = badgrade
 FROM=Eagle
 To=#facemail.email#
 Subject=Results
 TYPE=HTML
 b#lname#, #fname#/b
 Course: #ssbsect_subj_code# #ssbsect_crse_numb#
 CRN: #sfrstcr_crn#
 Grade: #grades#brbr
 /CFMAIL
 
 Jim Watkins
 http://www.ngtcollege.org 

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



WOT: Licensing Search Engine Results

2001-07-15 Thread Michael Lugassy

Can anyone recommend a good search engine company that will license the search results
and allow me to put them on my site, after full customization? (Other the the OBVIOUS 
google/altavista 
which seem a bit expensive.)

This is kinda WOT but I'm gonna use CF to customize the results on the back end.

Thanks,

Michael 


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

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



RE: Sending one CFMAIL

2001-07-15 Thread Jeffry Houser


  Wouldn't the other way around send 50 emails, not one?  The original 
poster only wanted one.


At 11:00 AM 07/15/2001 -0700, you wrote:
Or the other way around ;)



  -Original Message-
  From: Robert Segal [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, July 15, 2001 10:58 AM
  To: CF-Talk
  Subject: RE: Sending one CFMAIL
 
 
  CFMAIL FROM=Eagle To=#facemail.email# Subject=Results
  TYPE=HTML
CFLOOP QUERY=BADGRADE
b#lname#, #fname#/b
Course: #ssbsect_subj_code# #ssbsect_crse_numb#
CRN: #sfrstcr_crn#
Grade: #grades#brbr
/CFLOOP
  /CFMAIL
 
  -Original Message-
  From: Jim Watkins [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, July 15, 2001 1:27 PM
  To: CF-Talk
  Subject: Sending one CFMAIL
 
 
  How can I send email from a query so that all the info is in
  one email rather than sending individual e-mails for each
  person in the query?  IOW: If 50 people fit the criteria then
  I get 50 individual e-mails rather than one email with all
  the people. Currently my code is:
 
  CFMAIL query = badgrade
  FROM=Eagle
  To=#facemail.email#
  Subject=Results
  TYPE=HTML
  b#lname#, #fname#/b
  Course: #ssbsect_subj_code# #ssbsect_crse_numb#
  CRN: #sfrstcr_crn#
  Grade: #grades#brbr
  /CFMAIL
 
  Jim Watkins
  http://www.ngtcollege.org
 

~~
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: Licensing Search Engine Results

2001-07-15 Thread Lee Fuller

I think the more important question is would you WANT other search
results?

Lee


 -Original Message-
 From: Michael Lugassy [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, July 15, 2001 12:05 PM
 To: CF-Talk
 Subject: WOT: Licensing Search Engine Results
 
 
 Can anyone recommend a good search engine company that will 
 license the search results and allow me to put them on my 
 site, after full customization? (Other the the OBVIOUS 
 google/altavista 
 which seem a bit expensive.)
 
 This is kinda WOT but I'm gonna use CF to customize the 
 results on the back end.
 
 Thanks,
 
 Michael 
 
 

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

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



RE: Sending one CFMAIL

2001-07-15 Thread Lee Fuller

Right... That's why I corrected myself.  Robert's solution was correct.

Lee


 -Original Message-
 From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, July 15, 2001 2:03 PM
 To: CF-Talk
 Subject: RE: Sending one CFMAIL
 
 
 
   Wouldn't the other way around send 50 emails, not one?  The 
 original 
 poster only wanted one.
 
 
 At 11:00 AM 07/15/2001 -0700, you wrote:
 Or the other way around ;)
 
 
 
   -Original Message-
   From: Robert Segal [mailto:[EMAIL PROTECTED]]
   Sent: Sunday, July 15, 2001 10:58 AM
   To: CF-Talk
   Subject: RE: Sending one CFMAIL
  
  
   CFMAIL FROM=Eagle To=#facemail.email# Subject=Results 
   TYPE=HTML
 CFLOOP QUERY=BADGRADE
 b#lname#, #fname#/b
 Course: #ssbsect_subj_code# #ssbsect_crse_numb#
 CRN: #sfrstcr_crn#
 Grade: #grades#brbr
 /CFLOOP
   /CFMAIL
  
   -Original Message-
   From: Jim Watkins [mailto:[EMAIL PROTECTED]]
   Sent: Sunday, July 15, 2001 1:27 PM
   To: CF-Talk
   Subject: Sending one CFMAIL
  
  
   How can I send email from a query so that all the info is in one 
   email rather than sending individual e-mails for each 
 person in the 
   query?  IOW: If 50 people fit the criteria then I get 50 
 individual 
   e-mails rather than one email with all the people. 
 Currently my code 
   is:
  
   CFMAIL query = badgrade
   FROM=Eagle
   To=#facemail.email#
   Subject=Results
   TYPE=HTML
   b#lname#, #fname#/b
   Course: #ssbsect_subj_code# #ssbsect_crse_numb#
   CRN: #sfrstcr_crn#
   Grade: #grades#brbr
   /CFMAIL
  
   Jim Watkins
   http://www.ngtcollege.org
  
 

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



Works! was Re: Sending one CFMAIL

2001-07-15 Thread Jim Watkins

Thanks Robert,

Worked great!!

Jim

- Original Message -
From: Robert Segal [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 15, 2001 1:57 PM
Subject: RE: Sending one CFMAIL


 CFMAIL FROM=Eagle To=#facemail.email# Subject=Results TYPE=HTML
 CFLOOP QUERY=BADGRADE
 b#lname#, #fname#/b
 Course: #ssbsect_subj_code# #ssbsect_crse_numb#
 CRN: #sfrstcr_crn#
 Grade: #grades#brbr
 /CFLOOP
 /CFMAIL

 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, July 15, 2001 1:27 PM
 To: CF-Talk
 Subject: Sending one CFMAIL


 How can I send email from a query so that all the info is in one email
 rather than sending individual e-mails for each person in the query?  IOW:
 If 50 people fit the criteria then I get 50 individual e-mails rather than
 one email with all the people. Currently my code is:

 CFMAIL query = badgrade
 FROM=Eagle
 To=#facemail.email#
 Subject=Results
 TYPE=HTML
 b#lname#, #fname#/b
 Course: #ssbsect_subj_code# #ssbsect_crse_numb#
 CRN: #sfrstcr_crn#
 Grade: #grades#brbr
 /CFMAIL

 Jim Watkins
 http://www.ngtcollege.org

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

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



OT: Arcadia CMS soon available

2001-07-15 Thread zbelado


Well hopefully.

I have been developing a small to medium scale CMS called Arcadia
(http://www.pixelgeek.com/arcadia.cfm). The system is going to be released
as a free download next week (I need to fix some bugs). I am also hoping to
start an Open Source project using the code as a basis so that we can
hopefully work at building a free CMS solution for ColdFusion.

As part of this I would like to get some input by interested parties on what
type of license the code should be covered under to allow web developers to
use it in commercial products. My current thought is that the LGPL should
handle this case but I am open to comments and suggestions as the primary
aim is to get as many developers using the code.

Feel free to email me directly with any comments or questions you might
have. Also, please feel free to distribute this announcement.

TIA


~~
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: Arcadia CMS soon available

2001-07-15 Thread zbelado

I should have mentioned that any comments should, please and thank-you, be
sent to my personal email account ([EMAIL PROTECTED]) and not my work
address.

TIA


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



Got it! was Re: Displaying across page

2001-07-15 Thread Jim Watkins

Never could get the IIF statement to work so used following code to display
across page:

table border=0
CFLOOP INDEX=i from=1 to=#badgrade.recordcount#
cfif #i# mod 4 is 1TR/cfif
TD align=center bgcolor=A7DAFF
CFOUTPUT
#badgrade.lname[i]#, #badgrade.fname[i]#br
#badgrade.ssbsect_subj_code[i]#-#badgrade.ssbsect_crse_numb[i]#
(#badgrade.sfrstcr_crn[i]#)nbsp;nbsp;
#badgrade.grades[i]#
/cfoutput
TD align=center bgcolor=A7DAFF
cfif #i# mod 4 is 0/tr/cfif
/cfloop
/table



- Original Message -
From: Jim Watkins [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, July 14, 2001 3:09 AM
Subject: Re: Displaying across page


 Rob,
 Thanks for your input but I can't get your suggestion to work.  Would you
 make it a little clearer?
 Thanks

 Jim

 - Original Message -
 From: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, July 13, 2001 10:44 PM
 Subject: RE: Displaying iacross page


  Use something like
  #iif query_name.currentrow mod 3, /td/trtrtd,#
  in you loop or cfoutput.
  When it reaches the 3rd record it will start a new row in your table.
 
  Regards,
 
  Rob Rusher
 
  Spectra Architect, Certified ColdFusion Instructor + Developer,
Certified
  Java Programmer
 
  (303) 885-7044 Cell
  (970) 472-1775  Fax
  [EMAIL PROTECTED]
 
  [EMAIL PROTECTED]
  http://www.flarenetworks.com
 
 
  plan, build and integrate interactive applications and e-business
services
  to enhance knowledge sharing, e-commerce and business communications
  initiatives
 
 
   -Original Message-
   From: Jim Watkins [mailto:[EMAIL PROTECTED]]
   Sent: Friday, July 13, 2001 7:06 PM
   To: CF-Talk
   Subject: Displaying iacross page
  
  
   Currently the following code displays in a narrow long table on the
left
   side of page. as in:
   blah
   blah
   blah
  
Is it possible to display this info across and down the page.as in:
   blah   blah   blah
   blah   blah   blah
  
   CFOUTPUT Query=badgrade group=lname
   br
   font size=3 b #lname#, #fname#/font/b
   table border=0 width=auto
   TR
   TD align=center bgcolor=A7DAFFbfont size=2Course/TD
   TD align=center bgcolor=A7DAFFbfont size=2CRN/TD
   TD align=center bgcolor=A7DAFFbfont size=2Grade/TD
   /B
   /TR
   TR
   CFOUTPUT
   tdfont size=2#ssbsect_subj_code# #ssbsect_crse_numb#/TD
   tdfont size=2#sfrstcr_crn#/TD
   tdfont size=2center#grades#/center/TD
   /TR
   /CFOUTPUT
   /TABLE
   /CFOUTPUT
  
   Jim Watkins
   http://www.ngtcollege.org
  
  
  
 

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

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



RE: Sending one CFMAIL

2001-07-15 Thread Cameron Childress

Oops... that's what I get for trying to code on a Sunday afternoon!  Lee got
it...

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, July 15, 2001 1:51 PM
 To: CF-Talk
 Subject: RE: Sending one CFMAIL


 Um...  You are writing grades, names and course info to the email, and you
 want them all to get the same message?  Unless they all have the same name
 and grade, I'd keep it how you have it.

 -Cameron

 
 Cameron Childress
 elliptIQ Inc.
 p.770.460.7277.232
 f.770.460.0963

  -Original Message-
  From: Jim Watkins [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, July 15, 2001 1:27 PM
  To: CF-Talk
  Subject: Sending one CFMAIL
 
 
  How can I send email from a query so that all the info is in one email
  rather than sending individual e-mails for each person in the
 query?  IOW:
  If 50 people fit the criteria then I get 50 individual e-mails
 rather than
  one email with all the people. Currently my code is:
 
  CFMAIL query = badgrade
  FROM=Eagle
  To=#facemail.email#
  Subject=Results
  TYPE=HTML
  b#lname#, #fname#/b
  Course: #ssbsect_subj_code# #ssbsect_crse_numb#
  CRN: #sfrstcr_crn#
  Grade: #grades#brbr
  /CFMAIL
 
  Jim Watkins
  http://www.ngtcollege.org
 
 
 

~~
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: Client variable storage

2001-07-15 Thread Dave Watts

   Why is it that some hosts won't store client variables in a
   default database?
 
  If you change the default client variable storage repository 
  to a database, you won't be able to access the CF Administrator 
  if you can't connect to the database. You can fix this by going 
  into the registry and changing the appropriate value, but that's 
  my guess why they do it like they do.
 
 I believe CF Administrator uses the registry no matter what the 
 default is. I use an Access database on my development machine as 
 the default client storage and just renamed it and accessed CF 
 Administrator just fine.

That certainly hasn't been the behavior in the past. I've had to change the
HKLM\Software\Allaire\ColdFusion\CurrentVersion\ClientStores\DefaultStore
value to Registry in the past, when locked out of a CF Administrator
(which was returning an error message about the client database being
inaccessible).

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

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

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



CF 5.0 and Java 2

2001-07-15 Thread John Lucas

I have a corporate client who has recently upgraded their servers to CF 5.0.
Of course, the administration areas of their intranet that utilize cftree,
etc... no longer work because the browsers require Java2.  They are
utilizing IE, but IE is not automatically updating the browser.

I have been asked by the IT manager for step by step instructions for
upgrading to Java2.  I was hoping someone may have this already instead of
reinventing it.  Any assistance would be greatly appreciated.

Thanks,
John Lucas
[EMAIL PROTECTED]

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

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



Re: CF 5.0 and Java 2

2001-07-15 Thread Lee Moore

Very simple...

Go to http://java.sun.com/j2se/1.3/jre/
and follow the links to download the Java Runtime Environment

Install the executable file that is downloaded.

That's it

The java runtime environment installs the java 2 plugin for any browsers
installed on the system.

- Original Message -
From: John Lucas [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 15, 2001 6:44 PM
Subject: CF 5.0 and Java 2


 I have a corporate client who has recently upgraded their servers to CF
5.0.
 Of course, the administration areas of their intranet that utilize cftree,
 etc... no longer work because the browsers require Java2.  They are
 utilizing IE, but IE is not automatically updating the browser.

 I have been asked by the IT manager for step by step instructions for
 upgrading to Java2.  I was hoping someone may have this already instead of
 reinventing it.  Any assistance would be greatly appreciated.

 Thanks,
 John Lucas
 [EMAIL PROTECTED]


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

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



Re: Get Table names, and Field Names

2001-07-15 Thread Roger Dove

I can help with the second part. query_name.ColumnList returns a comma 
delimited list of the query columns.

Roger


From: Chad Gray [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Get Table names, and Field Names
Date: Wed, 11 Jul 2001 14:25:57 -0400

Is there a SQL command, or CF Function that can get the names of all the
tables in a database?  Then once it gets the names of the tables it can get
the fields in the tables?

Or should i just setup a table that i would put this information into?

Thanks in advanced
Chad



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

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



Client variable storage - confused person here!

2001-07-15 Thread Mike Kear

I hope you guys can help me, because I'm a newbie to multi-server clustered
environment and I'm getting more confused every day as I try to wrestle with
client variables,  only to find every turn I take leads me to a dead end
street.

I have no access to the administrator, the registry or anything at all
central.  In fact it takes a week or more to get a response from the system
administrator (which is another story that's giving me food for thought
about where I host my sites!)  I have to implement an authentication system
on a site where I have to use client variables, because it's a cluster
environment, and I am not allowed to rely on any central variable storage.

So that means I have to use cookies, and a table in my SQLServer7 datasource
to keep track of all the CFIDs and CFTOKENS.  (Is that correct?  If not I'm
barking up the wrong tree entirely!)

Therefore, I have to create a table in my datasource to keep hold of all the
sessions.  What fields should I have in my table if all I want to do is just
identify one user session from another?If I want to hold the levels of
access data too, should I keep that in there or go back to the users table
every page looking for that info?

And how do I maintain this table so it doesn't just get bigger and bigger
forever?

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


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

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



Re: Client variable storage - confused person here!

2001-07-15 Thread Nick Texidor

Hey Mike, 

Sorry for changing the topic slightly, but I noticed you mentioned your
hosting problems.   I've been having major problems of late with the hosts I
use.

I used Cyberhost for most of my sites, but when they sold out to iAsiaWroks
things started to go a bit awry.  Then when OzHosting took over, it all went
out the window.   I waited nearly six weeks for a site to be setup, and
ended up telling them to go jump.

The guys that started up Cyberhost have apparently started up another
business because a) they heard a lot of complaints from their old clients,
and b) they were unhappy with the way it went after selling out.

Anyway, the upshot is, they are able to offer CF hosting again.  The support
I had with them in the past was great, I haven't found many others to be as
responsive.  And their prices are affordable.

I'm not selling anything here... I have just been through all these
problems, and I thought I'd mention it to you out of courtesy!

All the best, and good luck with your other problems!!

Nick


  
on 16/7/01 12:26 PM, Mike Kear at [EMAIL PROTECTED] wrote:

 I hope you guys can help me, because I'm a newbie to multi-server clustered
 environment and I'm getting more confused every day as I try to wrestle with
 client variables,  only to find every turn I take leads me to a dead end
 street.
 
 I have no access to the administrator, the registry or anything at all
 central.  In fact it takes a week or more to get a response from the system
 administrator (which is another story that's giving me food for thought
 about where I host my sites!)  I have to implement an authentication system
 on a site where I have to use client variables, because it's a cluster
 environment, and I am not allowed to rely on any central variable storage.
 
 So that means I have to use cookies, and a table in my SQLServer7 datasource
 to keep track of all the CFIDs and CFTOKENS.  (Is that correct?  If not I'm
 barking up the wrong tree entirely!)
 
 Therefore, I have to create a table in my datasource to keep hold of all the
 sessions.  What fields should I have in my table if all I want to do is just
 identify one user session from another?If I want to hold the levels of
 access data too, should I keep that in there or go back to the users table
 every page looking for that info?
 
 And how do I maintain this table so it doesn't just get bigger and bigger
 forever?
 
 Cheers,
 Mike Kear
 Windsor, NSW, Australia
 AFP WebWorks
 
 

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

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



Removing of whitespaces in a text file.

2001-07-15 Thread nyon

Hi,

Is there any CFM method to clean out whitespaces in a text file ?
The files are dynamic generated every day.


The whitespaces is making my files bigger as I insert it into a CFM page.
  


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

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



RE: Client variable storage - confused person here!

2001-07-15 Thread Dave Watts

 I hope you guys can help me, because I'm a newbie to 
 multi-server clustered environment and I'm getting more 
 confused every day as I try to wrestle with client variables,  
 only to find every turn I take leads me to a dead end street.
 
 I have no access to the administrator, the registry or anything 
 at all central. In fact it takes a week or more to get a response 
 from the system administrator (which is another story that's 
 giving me food for thought about where I host my sites!) I have 
 to implement an authentication system on a site where I have to 
 use client variables, because it's a cluster environment, and I 
 am not allowed to rely on any central variable storage.
 
 So that means I have to use cookies, and a table in my SQLServer7 
 datasource to keep track of all the CFIDs and CFTOKENS. (Is that 
 correct?  If not I'm barking up the wrong tree entirely!)
 
 Therefore, I have to create a table in my datasource to keep hold 
 of all the sessions. What fields should I have in my table if all 
 I want to do is just identify one user session from another? If I 
 want to hold the levels of access data too, should I keep that in 
 there or go back to the users table every page looking for that info?
 
 And how do I maintain this table so it doesn't just get bigger and 
 bigger forever?

You're putting too much thought into this. When you use Client variables,
and they're stored in a database, you automatically create the necessary
tables (CDATA and CGLOBAL, if I recall correctly) in the database you choose
to use. Just like with Session variables, you need to have the browser
return a CFID and CFTOKEN on each subsequent page request; this can be done
most easily with cookies, or you can pass them as URL attributes or form
fields. The tables will hold any data that you put into Client variables.
You don't have to worry about any of that.

Of course, using Client variables will require a database query for each
page within the application, so if you're already using a database to
retrieve user information on each page request, you could simply use your
existing mechanism, and track the user with an identifier of your choice.

In addition, when you create your Client variable repository in the CF
Administrator, it has an option for how long these variables are kept. CF
will delete them after that period has passed.

Since you don't have access to the CF Administrator in your server
environment, it would probably be a good idea for you to install a
single-user version of CF 4.5.x (which comes on your CF Studio CD) or CF 5.0
(the single-user version of which will be available when CF Studio 5.0 comes
out. This way, you can see locally what exactly happens when you use Client
variables, and you can then tell your tardy system administrator exactly
what you need.

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

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

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



checkbox!

2001-07-15 Thread Melly Masram

Guys..i have a problem to insert values 1 and 0 into a
database. I want the insert values to be like below:-


1|0|1|1|0   -this value will be insert to a field
name AccessArray. The value 1 and 0 depends on the
user choice when he/she tick the checkbox value.

Could you guys help me,as soon as possible!
Thanz
~~
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: checkbox!

2001-07-15 Thread Nick Texidor

With the check box fields, make sure the value is set to 1.

Then when adding the record, you need to do a CFIF test to see if the
checkbox is checked...

INSERT INTO YourTable (accessArray)
VALUES ('CFIF IsDefined(Checkbox1)1CFELSE0/CFIF|CFIF
IsDefined(Checkbox2)1CFELSE0/CFIF|CFIF
IsDefined(Checkbox3)1CFELSE0/CFIF')

Etc etc.  Alternately, you may want to name the fields Access_1, Access_2
etc, and then loop over them.

Hope this helps a little

Nick




on 16/7/01 1:47 PM, Melly Masram at [EMAIL PROTECTED] wrote:

 Guys..i have a problem to insert values 1 and 0 into a
 database. I want the insert values to be like below:-
 
 
 1|0|1|1|0   -this value will be insert to a field
 name AccessArray. The value 1 and 0 depends on the
 user choice when he/she tick the checkbox value.
 
 Could you guys help me,as soon as possible!
 Thanz

~~
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: Removing of whitespaces in a text file.

2001-07-15 Thread Joseph Thompson

The 'el cheapo method:

Replace(MyTextFile,'  ',' ','all)

(that is two spaces after the first comma)

Another way?
REReplace(MyTextFile, [space],, All)
 OR
REReplace(MyTextFile, [space], , All)

(of course, the output of the first RE would be totally void of ALL
spaces... actually, I would expect it would wind up as one long line of
textthe second RE examle may be better)



~~
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: Client variable storage - confused person here!

2001-07-15 Thread Mike Kear


OH jeez Dave!  I do love it when people talk like that!   I'm doing too much
work and I have to do less???   How long I've waited in my life to hear
that!

You make this seem a great deal simpler and easier that I've been trying it.
I really appreciate your going to the effort to tell me about this stuff.

And I agree that while it's great to have a hosting wholesale company look
after all the hardware and systems admin issues, one of the big drawbacks is
that if they get a paranoia and want to shut off every possible way a bad
guy might damage the system, you have to live with it.   This issue is
making me re-think the decision not to invest in my own co-located server.

Thanks again!

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
 Subject: RE: Client variable storage - confused person here!

You're putting too much thought into this. When you use Client variables,
and they're stored in a database, you automatically create the necessary
tables (CDATA and CGLOBAL, if I recall correctly) in the database you choose
to use.

[snip]



~~
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: Client variable storage - confused person here!

2001-07-15 Thread Kay Smoljak

On Mon, 16 Jul 2001 12:40:01 +1000, Nick Texidor
[EMAIL PROTECTED] wrote:
The guys that started up Cyberhost have apparently started up another
business because a) they heard a lot of complaints from their old clients,
and b) they were unhappy with the way it went after selling out.

Hi Nick,

What's the name of this company? I am always intersted in local companies
hosting.

Regards,

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



Preventing Dups

2001-07-15 Thread sam komolafe

Hi guys,

What is the best way to prevent Duplicates in the case where form data is
saved and out of curiousity the user clicks the back button and click on
submit again?

Thanks
sam


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



Review: CF 5.0

2001-07-15 Thread Peter Tilbrook

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

http://www.firmware.com.au/news/article.cfm?story_id=38
-BEGIN PGP SIGNATURE-
Version: PGP Personal Edition 6.0.2

iQA/AwUBO1H0LkUmflCFE8qcEQJlIACgk4/8OXzKkpxclR9ggINQxjVig6cAoItg
fMbg5cYFwlbia1JR3e7sknjH
=NK9J
-END PGP SIGNATURE-


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



CFFILE Output--how do I include CFLOOP and session variables

2001-07-15 Thread Megan Cytron

I'll preface this dodo-brain question by saying that I'm
completely sleep-deprived, half brain-dead and away from my home
base, references, etc.

Here's what I need to do: we are using CFFILE to write the
results of an order to a file. We are using CFSET to create a
variable called textoutput. When I put CFLOOP in textoutput
and then reference it within CFFILE, all of my session variables
(from a shopping cart) get messed up and I get an error message
saying that my session variables are no longer there. (My
shopping cart is working fine elsewhere and I'm able to send the
looped session info via CFMAIL, so that probably isn't the
problem.)

Here's my code:

cfset textoutput=
  Order:  #getMaxOrderID.MaxOrderID#

CFLOOP INDEX=loopcount From=1 To=#ArrayLen(session.cart)#
  ITEM CODE:#session.cart[loopcount][3]#
  VARIETY:  #session.cart[loopcount][1]#
  QUANTITY: #session.cart[loopcount][4]#
/cfloop



CFFILE ACTION=Write
FILE=E:\websites\foo.txt
OUTPUT=#textoutput#

I know I've been down this road before... is it possible to run
CF tags within CFFILE? Am I missing something really simple?

Any insight would be greatly appreciated!

Thanks in advance!!

Megan
[EMAIL PROTECTED]

Alpha 60 Design Shop
http://www.alpha60.com
phone: 202-745-6393
fax:   202-745-6394


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



This is so messed up....

2001-07-15 Thread Pablo Varando

Read through this message and help out if you can!

Pablo Varando

- Original Message -
From: sengwai [EMAIL PROTECTED]
To: Yayoi Odani [EMAIL PROTECTED]; Tham Poh Weng
[EMAIL PROTECTED]; Teoh Lay Ean [EMAIL PROTECTED]; shinobu suzuki
[EMAIL PROTECTED]; sengwai [EMAIL PROTECTED]; Reiko Akiyama
[EMAIL PROTECTED]; [EMAIL PROTECTED]; Pooi San Ho
[EMAIL PROTECTED]; [EMAIL PROTECTED]; Pablo Varando
[EMAIL PROTECTED]; Malesiana Tropicals
[EMAIL PROTECTED]; Lay Eng [EMAIL PROTECTED]; Kok Woh Wong
[EMAIL PROTECTED]; Ken Franks [EMAIL PROTECTED]; john rabbit
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; Alan Chai [EMAIL PROTECTED]; :: oji ::
[EMAIL PROTECTED]
Sent: Friday, July 15, 2022 10:07 PM
Subject: Fw: PLEASE HELP THIS ANIMAL!!!




 
 
  -Original Message-
  From: Ram Deo [[EMAIL PROTECTED]]
  [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, July 11, 2001 4:02 PM
  Subject: please SIGN if ur an animal lover
 
 
  To anyone with love and respect for life:
 
  In New York there is a Japanese who sells bonsai-kittens. Sounds like
  fun huh? NOT! These animals are squeezed into a bottle. Their urine and
  faeces are removed through probes. They feed them with a kind of tube.
  They feed them chemicals to keep their bones soft and flexible so the
  kittens grow into the shape of the bottle. The animals will stay there
  as long as they live. They can't walk or move or wash themselves.
  Bonsai-kittens are becoming a fashion in New York and Asia. Please
  forward
  to everyone you know, except people who've already signed this!
 
  See this horror at http://www.bonsaikitten.com
  http://www.bonsaikitten.com
 
 
  Please sign this email in protest against these tortures. If you
  receive
  an email with over 500 names, please send a copy to:
 
  [EMAIL PROTECTED]
 
  From there this protest will be sent to USA and Mexican animal
  potection
  organizations. If you send this to your friends: Use the copy  paste
  method
 
  in an NEW email to keep this readable
 
  1.-Ana Check Mexico, D.F..
  2.-Manolo Alert Mexico, D.F.
  3.-AlbertoHuerta Mexico,D.F.
  4.-Manuel Gutierrez Mexico, D.F.
  5.-Marco Zapata Madrid
  6.-Teresa Morato Mexico,D.F.
  7.-Ximena Goyenechea Mexico, D.F.
  8.-Larissa Lara M???ico, D.F.
  9.-Marina Arencibia, Venezuela
  10.-Ana Maria Carvajal, Venezuela
  11.-Edgard D'Angelo, Venezuela
  12.-Claudia Marquez, Venezuela
  13.-Derek Ludovic, Venezuela
  14.-Rodolfo Placencia, Venezuela
  15.-Marbella Caceres, Venezuela
  16.-Maria Cristina Caceres, Venezuela
  17. Ana C.Castro, venezuela
  18.-Victoria Sanchez,Venezuela
  19.-Maria Editha Valdeavellano, Chile
  20.-Patricio Valdeavellano, Chile
  21.-Reinaldo Lopez, Venezuela
  22.-Paula Aedo, Chile
  23.-Constanza Carrasco, Chile.
  24.-Cecilia Noton, Chile
  25.-Carlos Eduardo Briones Bolbaran, Chile
  26.-Ximena Alejandra BrionesBolbaran, Chile
  27.-Pamela Andrea Roa Alarcon, Chile
  28.-Gabriela Beatriz Christiny Guajardo, Chile
  29.-Magdalena Amenabar Iniguez, Chile
  30.-Indra Soledad Kleinhempel Valladares, Chile
  31.-Monica Marisol Moreno Muga, Chile
  32.-Pilar Rebolledo,Chile
  33.-Andrea Villagra, Chile
  34.-Claudia Jerez, Chile
  35.-Erna Zagal, Chile
  36.-Andrea Munoz, Chile
  37.-Jacqueline Mateluna, Chile
  38.-Beatriz Crovetto, Chile
  39.-Carinne Santana, Chile
  40.-Ang? ?ica Benda???,Chile
  41.-Isabel Olivares, Chile
  42.-Max Aguilera, Chile
  43.-Mar?? Jos?Molina, Chile
  44.-Alejandra Fuentealba, Chile
  45.-Tamara Huanquel, Chile.
  46.-Paulina Garc? ?, Chile
  47.-Carmen Gloria Mu?? z,Chile
  48.-Mar?? Soledad Cofr? Chile
  49.-Sergio Antoine, Chile
  50.-Maria Jose Espinoza, Chile
  51.-Alejandra Bauerle, Chile
  52.-Ximena Chau, Chile
  53.-Doris Rubio, Chile
  54.-Heidi Acevedo, Chile
  55.-Claudia Acevedo, Chile
  56.-Maria Elena Vergara, Chile
  57.-Sandra Soto
  58.-Elizabeth Molina
  59.-Paula Rios
  60.-Rodrigo Gajardo
  61.-Andrea Solari
  62.-Paula Baranda
  63.-Guillermina de la Jara
  64.-Monserrat Gajardo
  65.-Paola Croma
  66.-Erika Leiva
  67.-Luis Bravo
  68.-Ximena Cruz, Chile
  69.-Marcela Serey, Chile
  70.-Ismael Serey, Chile
  71.-Luisa Torres, Chile
  72.-Luis G???ez, Chile
  73.-Loreto Valenzuela, Chile
  74.-Lorena Tapia, Chile
  75.-Antonia Fortt,Chile
  76.-Fernando A. Vivanco, Wisconsin, USA
  77.-Gisela Le???, Chile
  78.-Andrea Le???, Chile
  79.-Lorena Calleja, Chile.
  80.-Rossana Cerecera, Chile.
  81.-HUGO VERA,CHILE
  82.-Elena Mena,Puerto Rico
  83.-Vangie Vall? ?, Puerto Rico
  84.-Ana Maria Alvarez Carta??? Puerto Rico
  85.-KARINNA RODR? ?UEZ,MONTEVIDEO, URUGUAY
  86.-Antonio Viera Vecchio, Montevideo, URUGUAY
  87.-Carlos Vigliola, Montevideo, URUGUAY
  88.-Jorge Savecki, Montevideo, URUGUAY
  89.-Bianca Koch, S??? Paulo, BRASIL
  90.-Evandro Cordova da Silva, S??? Paulo, Brasil
  100.-Rodrigo Bertolani, S??? Paulo, Brasil
  101.-Ri cardo Leonardi Fernandes, S??? Paulo, Brasil
  102.-Daniella Costa Neri, S??? Paulo, Brasil
  

RE: This is so messed up....

2001-07-15 Thread Jared Clinton

Pablo,

Umm.. its a hoax 

Please read carefully what you get in your email, and then question it, then
do some research before setting off more bonsai kitten hysteria.

Thanks,
Jared Clinton
NEC Business Solutions

-Original Message-
From: Pablo Varando [mailto:[EMAIL PROTECTED]]
Sent: Monday, 16 July 2001 3:56 PM
To: CF-Talk
Subject: This is so messed up


Read through this message and help out if you can!

Pablo Varando

- Original Message -
From: sengwai [EMAIL PROTECTED]
To: Yayoi Odani [EMAIL PROTECTED]; Tham Poh Weng
[EMAIL PROTECTED]; Teoh Lay Ean [EMAIL PROTECTED]; shinobu suzuki
[EMAIL PROTECTED]; sengwai [EMAIL PROTECTED]; Reiko Akiyama
[EMAIL PROTECTED]; [EMAIL PROTECTED]; Pooi San Ho
[EMAIL PROTECTED]; [EMAIL PROTECTED]; Pablo Varando
[EMAIL PROTECTED]; Malesiana Tropicals
[EMAIL PROTECTED]; Lay Eng [EMAIL PROTECTED]; Kok Woh Wong
[EMAIL PROTECTED]; Ken Franks [EMAIL PROTECTED]; john rabbit
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; Alan Chai [EMAIL PROTECTED]; :: oji ::
[EMAIL PROTECTED]
Sent: Friday, July 15, 2022 10:07 PM
Subject: Fw: PLEASE HELP THIS ANIMAL!!!




 
 
  -Original Message-
  From: Ram Deo [[EMAIL PROTECTED]]
  [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, July 11, 2001 4:02 PM
  Subject: please SIGN if ur an animal lover
 
 
  To anyone with love and respect for life:
 
  In New York there is a Japanese who sells bonsai-kittens. Sounds like
  fun huh? NOT! These animals are squeezed into a bottle. Their urine and
  faeces are removed through probes. They feed them with a kind of tube.
  They feed them chemicals to keep their bones soft and flexible so the
  kittens grow into the shape of the bottle. The animals will stay there
  as long as they live. They can't walk or move or wash themselves.
  Bonsai-kittens are becoming a fashion in New York and Asia. Please
  forward
  to everyone you know, except people who've already signed this!
 
  See this horror at http://www.bonsaikitten.com
  http://www.bonsaikitten.com
 
 
  Please sign this email in protest against these tortures. If you
  receive
  an email with over 500 names, please send a copy to:
 
  [EMAIL PROTECTED]
 
  From there this protest will be sent to USA and Mexican animal
  potection
  organizations. If you send this to your friends: Use the copy  paste
  method
 
  in an NEW email to keep this readable
 
  1.-Ana Check Mexico, D.F..
  2.-Manolo Alert Mexico, D.F.
  3.-AlbertoHuerta Mexico,D.F.
  4.-Manuel Gutierrez Mexico, D.F.
  5.-Marco Zapata Madrid
  6.-Teresa Morato Mexico,D.F.
  7.-Ximena Goyenechea Mexico, D.F.
  8.-Larissa Lara M???ico, D.F.
  9.-Marina Arencibia, Venezuela
  10.-Ana Maria Carvajal, Venezuela
  11.-Edgard D'Angelo, Venezuela
  12.-Claudia Marquez, Venezuela
  13.-Derek Ludovic, Venezuela
  14.-Rodolfo Placencia, Venezuela
  15.-Marbella Caceres, Venezuela
  16.-Maria Cristina Caceres, Venezuela
  17. Ana C.Castro, venezuela
  18.-Victoria Sanchez,Venezuela
  19.-Maria Editha Valdeavellano, Chile
  20.-Patricio Valdeavellano, Chile
  21.-Reinaldo Lopez, Venezuela
  22.-Paula Aedo, Chile
  23.-Constanza Carrasco, Chile.
  24.-Cecilia Noton, Chile
  25.-Carlos Eduardo Briones Bolbaran, Chile
  26.-Ximena Alejandra BrionesBolbaran, Chile
  27.-Pamela Andrea Roa Alarcon, Chile
  28.-Gabriela Beatriz Christiny Guajardo, Chile
  29.-Magdalena Amenabar Iniguez, Chile
  30.-Indra Soledad Kleinhempel Valladares, Chile
  31.-Monica Marisol Moreno Muga, Chile
  32.-Pilar Rebolledo,Chile
  33.-Andrea Villagra, Chile
  34.-Claudia Jerez, Chile
  35.-Erna Zagal, Chile
  36.-Andrea Munoz, Chile
  37.-Jacqueline Mateluna, Chile
  38.-Beatriz Crovetto, Chile
  39.-Carinne Santana, Chile
  40.-Ang? ?ica Benda???,Chile
  41.-Isabel Olivares, Chile
  42.-Max Aguilera, Chile
  43.-Mar?? Jos?Molina, Chile
  44.-Alejandra Fuentealba, Chile
  45.-Tamara Huanquel, Chile.
  46.-Paulina Garc? ?, Chile
  47.-Carmen Gloria Mu?? z,Chile
  48.-Mar?? Soledad Cofr? Chile
  49.-Sergio Antoine, Chile
  50.-Maria Jose Espinoza, Chile
  51.-Alejandra Bauerle, Chile
  52.-Ximena Chau, Chile
  53.-Doris Rubio, Chile
  54.-Heidi Acevedo, Chile
  55.-Claudia Acevedo, Chile
  56.-Maria Elena Vergara, Chile
  57.-Sandra Soto
  58.-Elizabeth Molina
  59.-Paula Rios
  60.-Rodrigo Gajardo
  61.-Andrea Solari
  62.-Paula Baranda
  63.-Guillermina de la Jara
  64.-Monserrat Gajardo
  65.-Paola Croma
  66.-Erika Leiva
  67.-Luis Bravo
  68.-Ximena Cruz, Chile
  69.-Marcela Serey, Chile
  70.-Ismael Serey, Chile
  71.-Luisa Torres, Chile
  72.-Luis G???ez, Chile
  73.-Loreto Valenzuela, Chile
  74.-Lorena Tapia, Chile
  75.-Antonia Fortt,Chile
  76.-Fernando A. Vivanco, Wisconsin, USA
  77.-Gisela Le???, Chile
  78.-Andrea Le???, Chile
  79.-Lorena Calleja, Chile.
  80.-Rossana Cerecera, Chile.
  81.-HUGO VERA,CHILE
  82.-Elena Mena,Puerto Rico
  83.-Vangie Vall? ?, Puerto Rico
  84.-Ana Maria Alvarez Carta??? Puerto Rico
  85.-KARINNA RODR? ?UEZ,MONTEVIDEO,