RE: passing variables (was: Hiding Source Code)

2002-09-05 Thread A . Little

How about using form variables? (Doesn't hide the values from the end user
though, if that's what you're trying to achieve)

Alex

> -Original Message-
> From: Aunger, Mitch [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 16:39
> To: CF-Talk
> Subject: passing variables (was: Hiding Source Code)
> 
> 
> Hi all
> 
> I tried to send this msg yesterday and it never came thru (i 
> must be killing
> the server ggg)and of course, I didn't save it, so maybe this 
> version will
> be shorter.
> 
> My question is related to the comments below... 
> (the short version is:) is there another way to pass 
> variables to another cf
> page other than the URL (and session or client variables)? 
> I've searched
> high and low and can't find another option.
> 
> (longer version:) I want to present the user with LINKS which 
> are formed
> with the right variables I need in the second cfm page. But 
> since there
> isn't any interaction with the first page when the user 
> clicks a link, I
> can't think of any other way to do it
> 
> ex: (i want to pass the value of "parm")
> link to abc1
> link to abc2
> link to abc3
> link to abc4
> etc.
> 
> I can't CFSET anything since I can't read the user's mind 
> before she clicks
> and i can't set anything after because there's no interaction 
> with the first
> page when a link is clicked.
> 
> Any suggestions?
> 
> thanks
> Mitch
> 
> -Original Message-
> From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 04, 2002 2:00 PM
> To: CF-Talk
> Subject: RE: Hiding Source Code
> 
> 
> pass the variable in a session or client variable
> 
> -Original Message-
> From: Paul [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 04, 2002 2:59 PM
> To: CF-Talk
> Subject: Re: Hiding Source Code
> 
> 
> The main reason I am trying to hide the code is that through 
> some pages I
> have variable's values being past and for whatever reason the 
> variable's
> value seems to be displaying in the source code, that is what 
> I am trying to
> hide, the variable's value. I'm not sure why the variable's 
> value would show
> up in the source code in the 1st place? Possibly I should simply take
> another approach as to how I am passing the variables?
> 
> Thanks for your input
> 
> -Paul
> 
> 
> -Original Message-
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 04, 2002 2:33 PM
> To: CF-Talk
> Subject: RE: Hiding Source Code
> 
> 
> Ah, hide html?  I don't expect there is a way of doing that.  
> The browser
> needs the html code to render the visible page.  No HTML no webpage.
> 
> I did run a cross a guy a few years back that was overly 
> afraid that his
> html code would be stolen and reused on other sites. So he 
> found a html tool
> that would remove all extra spaces and all line brakes.  The 
> html code would
> be turned into 1 really long line of code.  I found that 
> almost any program
> like dream weaver or CF studio would fix his code so I could 
> read it easily.
> 
> Any reason you are looking to hide your HTML?
> 
> Mark W. Breneman
> -Macromedia Certified ColdFusion Developer
> -Network / Web Server Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
> 
> -Original Message-
> From: Paul [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 04, 2002 1:33 PM
> To: CF-Talk
> Subject: RE: Hiding Source Code
> 
> 
> I apologize my question should of been more clear. I realize 
> that the CF
> code is hidden, but I was hoping coldfusion could somehow 
> block out the HTML
> code as well?
> 
> 
> 
> 
> 
__
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: getting file size and date last modified from CFSEARC H

2002-07-16 Thread A . Little

I don;t think you can do it directly with cfsearch - I'm sure someone will
correct me if I'm wrong :-)

One way you might be able to achieve what you want is to make use of the
custom1 and custom2 fields when indexing the collection. You may then have
to add each file individually to the collection using  and you'd need to write a recursive function to find all
the files in your directory structure.

Someone out there may have a better solution though!

Alex

> -Original Message-
> From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
> Sent: 16 July 2002 05:04
> To: CF-Talk
> Subject: Verity: getting file size and date last modified 
> from CFSEARCH
> 
> 
> Is is possible to get the file size and date last modified 
> for results using
> CFSEARCH?
> 
> cheers
> 
> David
> 
__
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: Auto includes???

2002-07-11 Thread A . Little

onRequestEnd.cfm

> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> Sent: 11 July 2002 13:50
> To: CF-Talk
> Subject: Auto includes???
> 
> 
> Correct me if I am wrong But isn't there something similat to
> application.cfm that functions as a automatic footer
> 
> What is it called???
> 
> thanks
> 
> -Original Message-
> From: John Beynon [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, July 11, 2002 8:38 AM
> To: CF-Talk
> Subject: RE: cflocation problem. Anyone seen this?
> 
> 
> How about this one:
> 
> http://www.macromedia.com/v1/Handlers/index.cfm?ID=22712&Method=Full
> 
> Jb.
> 
> > -Original Message-
> > From: Bud [mailto:[EMAIL PROTECTED]]
> > Sent: 11 July 2002 12:03
> > To: CF-Talk
> > Subject: RE: cflocation problem. Anyone seen this?
> > 
> > 
> > On 7/11/02, Tilbrook, Peter penned:
> > >Are you using cookies? This was a well documented problem. Eg:
> > >
> > >Also CF 4.5 has an additional service pack (2) available.
> > 
> > Well documented where? :) I've been through all the items in the
> > knowledge base containing cflocation and there's no mention of this 
> > problem.
> > 
> > -Original Message-
> > From: Bud [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 11 July 2002 10:32 AM
> > To: CF-Talk
> > Subject: cflocation problem. Anyone seen this?
> > 
> > 
> > Not sure id this is a problem with CF or IIS or IE.
> > 
> > Post a form and write some client and session variables to a
> > cart, then do an immediate cflocation. I get HTTP header info 
> > showing up in IE 5.5 on PC. It doesn't show up on NN 4.7 on 
> > Mac or PC, IE 5.1 on Mac  or NN 6.2 on PC. If I refresh the 
> > page where I cflocation to, the headers go away.
> > 
> > The server is running IIS 5 and CF 4.5.1 SP 1.
> > 
> > Clues?
> > --
> > 
> > Bud Schneehagen - Tropical Web Creations
> > 
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development
> > [EMAIL PROTECTED] http://www.twcreations.com/ 
> > 954.721.3452 
> > 
> 
> 
__
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: filemaker

2002-07-10 Thread A . Little

I tried using the built in ODBC driver for FileMaker so CF could read the
data, but the driver that comes with FM is really slow (this could also have
been because of the design of this particular FileMaker db), the other odd
thing that it took me a while to work out was that the FileMaker db needs to
be open on the FM server for the ODBC connection to work - not very useful
if you need to connect to a number of FM dbs.

In the end we gave up and imported all the data to SQL Server.

Alex




> -Original Message-
> From: Won Lee [mailto:[EMAIL PROTECTED]]
> Sent: 09 July 2002 20:35
> To: CF-Talk
> Subject: filemaker
> 
> 
> Does anyone have a stable ODBC driver for Filemaker pro?
> OR can I use any of the other drivers?
> 
> Won Lee
> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFQUERY Question to populate a drop down for search

2002-05-29 Thread A . Little

You could use:

SELECT DISTINCT city FROM profiles


Alex

> -Original Message-
> From: Brian Simpson [mailto:[EMAIL PROTECTED]]
> Sent: 29 May 2002 10:32
> To: CF-Talk
> Subject: CFQUERY Question to populate a drop down for search
> 
> 
> CFQUERY Question to populate a drop down for search
> 
> I'm looking for a way to query a database table and display 
> the results 
> with out any diplicates.
> 
> The  "WHERE city is unique" does not work.
> 
> 
> 
> 
> SELECT city
> FROM profiles
> WHERE city is unique
> 
> 
> 
> #getcity.city#
> 
> 
> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FileExists returns NO every time, even with absolute path

2002-04-05 Thread A . Little

Have you checked that the form tag where you select the file has the
attribute:

enctype="multipart/form-data" 

Alex

-Original Message-
From: Stocke Terri [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 15:36
To: CF-Talk
Subject: RE: FileExists returns NO every time, even with absolute path


I used this same code in another app for the same thing, and it worked fine.
Also, if I remove the fileExists function and just try to upload the file
without checking for it, I get the error that the file doesn't exist. For
some reason CF just doesn't want to see these files and upload them. ??

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:37 AM
To: CF-Talk
Subject: RE: FileExists returns NO every time, even with absolute path


doesn't fileExists look to find the file on the server, not the local
machine. The form.description is the reference to the path & filename on the
client PC.

Alex

-Original Message-
From: Stocke Terri [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 15:24
To: CF-Talk
Subject: FileExists returns NO every time, even with absolute path


Hi All,

This is maddening.

I am using FileExists to check for the existence of a file that I am
browsing to on my local machine. No matter what file I choose, the
FileExists function returns NO every time, even though I am 100% positive
that the file does exist. I have included a small portion of code that I am
using for debugging purposes.
The first outputted variable (form.description) displays the file path,
which is C:\MyDocs\app_request.doc. The second outputted variable displays
"NO". Even if I replace the form.description in the second outputted
variable with C:\MyDocs\app_request.doc, it still returns NO. Any ideas?




#form.description#
#fileExists("form.description")#


 


Do this...


Terri 




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



RE: FileExists returns NO every time, even with absolute path

2002-04-05 Thread A . Little

doesn't fileExists look to find the file on the server, not the local
machine. The form.description is the reference to the path & filename on the
client PC.

Alex

-Original Message-
From: Stocke Terri [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 15:24
To: CF-Talk
Subject: FileExists returns NO every time, even with absolute path


Hi All,

This is maddening.

I am using FileExists to check for the existence of a file that I am
browsing to on my local machine. No matter what file I choose, the
FileExists function returns NO every time, even though I am 100% positive
that the file does exist. I have included a small portion of code that I am
using for debugging purposes.
The first outputted variable (form.description) displays the file path,
which is C:\MyDocs\app_request.doc. The second outputted variable displays
"NO". Even if I replace the form.description in the second outputted
variable with C:\MyDocs\app_request.doc, it still returns NO. Any ideas?




#form.description#
#fileExists("form.description")#


 


Do this...


Terri 


__
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



Prevent mode=debug working

2002-03-15 Thread A . Little

Hi all,

I'm being a little slow today how can I disable the mode=debug function
when entered by users in the url to display the list of params at the end of
the page?

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



RE: Uploading file directly into SQL database

2002-03-01 Thread A . Little

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

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

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

Alex

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


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

Alex,

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

What is it you're really trying to do?

Regards

Stephen

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



Uploading file directly into SQL database

2002-03-01 Thread A . Little

Hi,

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

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

Does anyone have any help for me

thanks

Alex

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



RE:

2002-02-21 Thread A . Little

I think you could use 



then treat ReadMe as a comma separated list to loop through to generate the
checkboxes

Alex

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: 21 February 2002 15:47
To: CF-Talk
Subject: Re: 

", "ALL")>


#ReadMe#


Outputs:

file1
file2
file3
file4
file5

What I need to to is loop through the above variable and output the 
following using
#ReadMe#

[  ] file1
[  ] file2
[  ] file3
[  ] file4
[  ] file5

__
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



Tool to convert files on server

2002-02-13 Thread A . Little

Hi all,

We allow users to upload .doc and .pdf files to our webserver and would like
to be able to automatically create a .txt or .rtf versions of these files,
also to be saved on the webserver.

Does anyone know of any tools/tags available allow us to do this?

thanks,

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



Running CF and iHTML on same server

2002-01-11 Thread A . Little

Hi all,

We're planning to move some of our websites written in iHTML over to the
same (W2K) server that we run our CF websites on.

Has anyone out there had any experience in running iHTML and CF on the
server - and if so, have there been any problems or anything else we need to
be aware of, or lookout for.

Thanks in advance,

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



RE: client vars

2001-12-14 Thread A . Little

No, I'm using IE 5.5. I have tested the site with ie6, and it was working
fine.

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 10:54
To: '[EMAIL PROTECTED]'
Subject: client vars


are you using ie6?

Mark Smyth 
Internet Systems Developer 
SUeBS 
00 44 1865 880800 
[EMAIL PROTECTED] 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Client variables driving me up the wall!

2001-12-14 Thread A . Little

Hi all,

We're storing our client variables in a SQL 2k database and the
application.cfm file checks that 'client.iamid' exists, if not, sends user
to the login screen. This has all been working fine, until recently, now
each request from the client machine creates a new record in the Cdata and
cglobal tables of the client variables db. 

This is forcing the login screen to appear for each page request (whenever
application.cfm is run) - so why is CF 'forgetting' that client.iamid has
already been defined, and creating a new cfid for each page request?

This is working fine on our live server, the problems are with a development
machine, I've tried reinstalling CF5, but this has made no difference.

Any help would be much appreciated.

Thanks,

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



Using CFCONTENT with Office XP

2001-10-30 Thread A . Little

Hi All,

Has anyone else come across the following problem...

I'm using cfcontent to display a powerpoint presentation in the browser.
This method has worked fine so far, but we recently tried it on a W2K
machine with Office XP installed and instead of displaying the presentation,
a presentation does appear on screen, but with html code from the current
page in a very small font (bit difficult to describe without actually seeing
it!). The code i'm using for the cfcontent is:

 

The machine will display a powerpoint presentation fine in the browser, when
it is served directly from the web, and also shows .doc .pdf .xls files as
they should be.

Any ideas?

Alex Little
IET
~~
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



Using CFHTTP

2001-08-20 Thread A . Little

Hi all,

I'm trying to use the cfhttp tag to get a webpage in a directory on our
server which is not open to the general public.

I don't like the idea of having to hard code a username and password into
the attributes of the cfhttp tag. Is there a way round this?

I've tried to change the login account of the CF service on the server to
one which would allow access to the directory, but no luck there.

Hope someone can help,

Alex Little
Open University

~~
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: Access and CFGraph

2001-08-14 Thread A . Little

You could change your query to:

SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
WHERE COUNT(State) > 1
  ORDER BY COUNT(state)

Alex


> -Original Message-
> From: Ann Harrell [SMTP:[EMAIL PROTECTED]]
> Sent: 14 August 2001 16:31
> To:   CF-Talk
> Subject:  Access and CFGraph
> 
> I have this query that goes through the database and counts up the number
> of
> people from each state and then I put it in a cfgraph. How do I get it to
> only display states that are greater than 1?
> 
> SELECT state, COUNT (state) AS StateCount
> FROM Wobinfo
> GROUP BY state
> ORDER BY COUNT(state)
> 
> QUERY="GetStates"
>VALUECOLUMN="StateCount"
>ITEMCOLUMN="State"
>SHOWVALUELABEL="Yes"
>VALUELOCATION="ONBAR"
>SCALEFROM="0"
>SCALETO="10"
>TITLE="Wobbers By State"
>FILEFORMAT="Flash"
>GRAPHHEIGHT="500"
>GRAPHWIDTH="700"
>BACKGROUNDCOLOR="white"
>DEPTH="10"
>COLORLIST="red,green,blue,yellow,orange, fuchsia, teal, Lime"
>GRIDLINES="4">
> 
> 
> Ann Harrell
> Harrell Computer Enterprises
> Phone: 219.342.0618
> eFax: 603.843.9212 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: counting form fields

2001-08-09 Thread A . Little

Not sure about  counting the number of fields returned by a form,

but... you can use:

MyQueryName.RecordCount

to show the number of results returned by a CF query.

Alex

> -Original Message-
> From: Michael Wolter [SMTP:[EMAIL PROTECTED]]
> Sent: 09 August 2001 14:34
> To:   CF-Talk
> Subject:  counting form fields
> 
> Is there any way to get a count of the number of fields that are returned
> from a form?
> 
> Also, is there a way to get a count of the number of records selected by a
> cfquery?  The only way I have found to do that is to do a second cfquery
> and use the "count(*)" function, but that seems to be double the work.
> In Visual Basic, I can just put ".recordcount" after the recordset name to
> get a count.  Does Cold Fusion have anything like that?
> 
> Thanks!
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> |  Michael Wolter [EMAIL PROTECTED]   |
> |  Administrative Programmer/Analyst  Carlisle, PA 17013 |
> |  Dickinson College, Computer Services   (717) 245-1527 |
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> 
> 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

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



RE: Verity problem

2001-08-03 Thread A . Little

I've found that verity doesn't seem to like criteria with leading or
trailing spaces, so I trim the search criteria before passing it to the
cfsearch tag.

Anyone know why Verity doesn't like the spaces?

Alex

> -Original Message-
> From: Christian L. Watt [SMTP:[EMAIL PROTECTED]]
> Sent: 02 August 2001 16:40
> To:   CF-Talk
> Subject:  RE: Verity problem
> 
> Adrian,
>   You can search for those words if you replace them with no blanks,
> but make sure you put a space both before and after them.  This should
> also
> only happen if you are splitting the string out to search the words one at
> a
> time.
> 
> #replace(string, " and ", "", "all")#
> #replace(string, " or ", "", "all")#
> #replace(string, " not ", "", "all")#
> 
> Christian Watt
> 
> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 11:18 AM
> To: CF-Talk
> Subject: Verity problem
> 
> 
> I'm new to this so go easy on me. I'm using verity to search a site,
> typing
> in 'and', 'not' and 'or' on their own is causing an error. Anyone out
> there
> come across this problem before? Stopping these words from going through
> isn't the answer as I then can't search for things like s'and',
> f'or'gotten
> ect..
> Cheers
> 
> Adrian Lynch
> --
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Ph: +44 (0) 20 7387 8890
> --
> New Zealand
> http://www.thoughtbubble.co.nz/
> Ph: +64 (0) 9 488 9131
> 
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s) . Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
> or
> retain this message. Please notify us on +44 (0) 20 7387 8890
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Verity: Searching multiple collections

2001-08-03 Thread A . Little

You can put multiple collections in the cfsearch tag.



This will combine the output and it will be ready formatted.

I've had to do this for database and file collections. For the database
collections I defined 'custom1' of the index to be the ID and for the file
collections I have not defined 'custom1'.

Then when I'm outputting, if the record's custom1 is a non null, it must
link to a database record, but if custom1 is null then it link directly to
the file.

HTH

Alex

> -Original Message-
> From: Jason Blum [SMTP:[EMAIL PROTECTED]]
> Sent: 02 August 2001 12:54
> To:   CF-Talk
> Subject:  RE: Verity: Searching multiple collections
> 
> Hey Carlo,
> 
> If I understand you correctly, you are trying to do a single search
> against three collections so that the results are all displayed in the
> same order of relevance?
> 
> I am doing something very similar - two db collections and one doc
> collection - and am simply running three CFSEARCHes one after another,
> but formatted such that they appear to be a single output.
> 
> I'm not sure I understand what you mean by their all using the same
> link.
> 
> -J
> 
> > --
> > From:   Carlo van Wyk
> > Reply To:   [EMAIL PROTECTED]
> > Sent:   Thursday, August 2, 2001 1:51 AM
> > To: CF-Talk
> > Subject:Verity: Searching multiple collections
> > 
> > I am searching 3 different verity collections with cfsearch. Two of
> > the
> > collections are indexed from a database and contains articles and
> > staff
> > details. The other collection is a directory collection of files.
> > 
> > I want to use one search, and display results from different areas.
> > The problem is: if you display the results, how do you link to data
> > from the
> > 3 different collections, as they all use the same link. How does one
> > create
> > a different link for each collection?
> > 
> > Regards
> > Carlo
> > 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
> > 
> > 
> 
>
~~
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: Hooking to Lotus Notes.

2001-07-27 Thread A . Little


Yes you can use ODBC to link to a Notes db. I'm not so sure about linking to
a remote Notes db though. I know for Notes 4.5 to get the ODBC working you
needed to have a Notes client installed, so you may need to install a Notes
client on your CF server. This may of course be different for Notes 5. :)

Alex

> -Original Message-
> From: Angél Stewart [SMTP:[EMAIL PROTECTED]]
> Sent: 27 July 2001 14:19
> To:   CF-Talk
> Subject:  Hooking to Lotus Notes.
> 
> Can you connect to a Lotus Notes database file..a .nsf file I believe, via
> ODBC?
> And can this be done remotely if the CF Server and the Lotus Notes
> database do not reside on the same machine?
> 
> I've never used this darn thing before, but apparently a client has this
> as one of their requirements, that data be read from
> a .nsf file at regular intervals, and then we write a file that can be
> imported into that same Lotus Notes database to a
> location on the server.
> 
> -Gel
> 
> 
> 
>
~~
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-07-19 Thread A . Little

Try using '190' instead of "190"

Alex Little
IET
Open University



> -Original Message-
> From: nyon [SMTP:[EMAIL PROTECTED]]
> Sent: 19 July 2001 14:40
> To:   CF-Talk
> Subject:   
> 
>   Hi,
> 
> I get an error when using the following statement.
> 
> ">
> 
> Only when I remove the character " does it work.
> 
> Any solution ?
> 
> 
> 
> Nyon 
> 
> 
> 
>
~~
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