RE: passing variables (was: Hiding Source Code)
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
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???
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
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
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
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
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
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
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
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:
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
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
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
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!
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
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
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
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
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
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
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.
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:
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