Re: cfhttp pressure
Matt, Do the pages truly have to be static? I do something that only requires CFFILE to generate its run of templates ... which are just copies with different filenames, where the filename incorporates the key ID and there's code inside to pull that ID out and use it. Doesn't affect the resources the page needs to display, but is an easy way to make the page crawlable. I can provide a code sample if you'd like. The way I'm working now is including the statics pages using application.cfm when a product_id appears in the url. Is there a better way, other then converting all content to static pages? (I don't want to use query caching as it will not do and eat all the memory). Thanks. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- CF 5.0 chokes after trying to do the following (openeing lots and lots of cfhttps to make static pages from my product template). I know it's an hard job, but is there a solution? how can I try and perfom this task without splitting the records? cfquery name=Generate_pages blockfactor=100 SELECT TOP 2000 Product_id FROM Products ORDER BY Product_id /cfquery cfloop query=Generate_ct_pages cfhttp url=http://mydomain/generate.cfm?id=#Product_id#generate=1; method=GET path=#Map_root#\generate\html\ file=#Product_id#.html resolveurl=false useragent=CF Fetcher/cfhttp /cfloop __ 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: count delete [anyone?]
Anyone? Why do you think I can't get the Rowcount AS Deleted in cfoutput? DELETE from Orders WHERE Product_id=#val(Product_id)# SELECT ROWCOUNT AS Deleted error cfoutput#QuerynameDeleted#/cfoutput __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Change Server Time, is this possible ???
Maybe cfexecute or xp_cmdshell and the dos 'date' command? Ian -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: 01 March 2002 05:53 To: CF-Talk Subject: RE: Change Server Time, is this possible ??? Well if you know a little C++ you could probably do a CFX tag that will do what you want. COM objects should be able to as well (you can develop to access the windows API from there) but you won't be able to in ColdFusion in a way that's documented. Gregory Harris [EMAIL PROTECTED] -Original Message- From: Fisichella [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 7:54 PM To: CF-Talk Subject: Change Server Time, is this possible ??? Hi, We build apps in intranet scope. I want to change the server time, through user authorization. I know client can't do this because of security issue. But, can I do this via COM objects or anything else ??? For IE only is ok. TIA, Fisichella. __ 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: count delete [anyone?]
SET NOCOUNT ON DELETE from Orders WHERE Product_id=#val(Product_id)# SELECT Deleted = ROWCOUNT SET NOCOUNT OFF __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?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://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
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 __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: count delete [anyone?] --solved
That did it! Thanks Paul. - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 12:34 PM Subject: Re: count delete [anyone?] SET NOCOUNT ON DELETE from Orders WHERE Product_id=#val(Product_id)# SELECT Deleted = @@ROWCOUNT SET NOCOUNT OFF __ 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
All Excel ODBC data sources broken - CF 5.0
Why would Excel ODBC data sources that have been working for several months all of a sudden all break? We have a CF application that uses about a dozen different Excel spreadsheets for data sources Depending on the type of report requested, we query one of the Excel spreadsheets using ODBC to pull out data and then we build the report This has worked fine since last October Last week we upgraded our server from CF 451 to 50 and it still worked fine - until yesterday We made no changes to the CF server configuration yesterday and we did not upload new files The only out-of-the-ordinary thing that happened yesterday is that we had a team reviewing each page on our site using a new desktop image that will be distributed throughout our organization They successfully accessed each of the types of reports in this application without getting any errors on the Excel data sources It wasn't till later in the afternoon that we discovered this problem I could not verify any of the Excel data sources through CF Administrator I tried uploading new Excel files to the server and they would not verify I tried opening and saving a file and then uploading it and it still would not verify Stopping and restarting the CF service fixed the problem, but I'd like to find out what caused it in the first place Any ideas on what broke our Excel ODBC data sources? Thanks! George __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
SQL Server 7.0 evaluation/developer's edition
Anyone know if there's such a thing as an MS SQL Server 7.0 evaluation version/developer's edition? I grabbed the SQL 2000 trial in anticipation of doing some work for a client, now it turns out they're running 7, and I'd like to do this bit of development on the same version... - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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
Displaying Please wait message during a process
I have a template that I want to display Please wait text, then go through a CFIndex Process, with a complete message when done. This is displayed in a pop-up window. I find that when the CF process starts, the window goes blank until the process is done, then displays all the text. I've tried a CFFlush on the please wait prior to the process, but then the process hangs. I've also tried wrapped CFSilent around the process, to no avail. What's the right way to do this? Thanks, Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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
PHPConfig
I know some of us CFers still must code in other languages, and I found this little jewel for editing the PHPini http://wwwanalogxcom/contents/download/network/phpconfhtm Success is a journey, not a destination!! Doug Brown __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
drivers
Hi, I know ColdFusion 5 comes with the 36 Merant ODBC drivers, if I install the 40 set of drivers will it be supported by ColdFusion? TIA, Deb _ Join the worlds largest e-mail service with MSN Hotmail http://wwwhotmailcom __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Verity Issue - Returning Incorrect Results?
Running CF 50 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear Next article will be in English and does contain the keyword in the body But then next article in English does not contain the keyword in the body Wondering if anyone could point me to where the mistake might be taking place During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: CFOBJECT and Excel Column widths
Can the column widths be resized dynamically to their widest value? What I found was that, without any VBScript or COM automation, this was not possible. I would be interested in seeing an example of doing this another way, if anyone has one. Mike -Original Message- From: list peters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:16 AM To: CF-Talk Subject: Re: CFOBJECT and Excel Column widths ben forta described how to do this (variable width columns), along with formatting etc in his web application construction kit book. start a new excel document, and enter a test row how you would like... apply all formatting, column widths, etc, and then save as HTML. Open up the HTML file created, stick in your query, and your cfoutputs around the tables (like you would normally), and then serve it up with cfcontent. goodluck! chad I've been using cfcontent to output query results in Excel. My client now wants the width of the spreadsheet columns being generated to automatically size to the length of the longest string returned from the query. Does anyone know whether this is possible, maybe with cfobject? No luck so far with cfcomet. Tristram Charnley --- [EMAIL PROTECTED] Allaire Certified ColdFusion Developer __ 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: SQL Server 7.0 evaluation/developer's edition
Anyone know if there's such a thing as an MS SQL Server 70 evaluation version/developer's edition? I grabbed the SQL 2000 trial in anticipation of doing some work for a client, now it turns out they're running 7, and I'd like to do this bit of development on the same version There is a developer's edition of both SQL Server 7 and SQL Server 2000, but they cost about $500 apiece I doubt that the evaluation version of SQL Server 7 is still available from Microsoft, because it's no longer the current product You have some options, though First, you can do development on SQL Server 2000 and deploy against SQL Server 7 - there are very few differences beyond new features in SQL Server 2000 For the vast majority of stuff you're going to do, it won't make a difference Also, you can get the SQL 7 compatible version of MSDE, and work against that You can use the SQL Server 2000 Enterprise Manager to manage it, although you won't want to just install it on your SQL Server 2000 machine Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: CFOBJECT and Excel Column widths
Yes, but it requires Excel 2000perhaps I can persuade them to upgrade. Meanwhile I was hoping CFOBJECT would do the trick. - Original Message - From: list peters [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 01, 2002 8:16 AM Subject: Re: CFOBJECT and Excel Column widths ben forta described how to do this (variable width columns), along with formatting etc in his web application construction kit book. start a new excel document, and enter a test row how you would like... apply all formatting, column widths, etc, and then save as HTML. Open up the HTML file created, stick in your query, and your cfoutputs around the tables (like you would normally), and then serve it up with cfcontent. goodluck! chad I've been using cfcontent to output query results in Excel. My clie nt now wants the width of the spreadsheet columns being generated to automatically size to the length of the longest string returned from the query. Doe s anyone know whether this is possible, maybe with cfobject? No luck so far with cfcomet. Tristram Charnley --- [EMAIL PROTECTED] Allaire Certified ColdFusion Developer _ _ 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 __ 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: SQL Server 7.0 evaluation/developer's edition
With SQL Server 2000 out, I doubt you can still get SQL Server 7 evaluation. But you will have no trouble accessing a SQL Server 7 server w/ SQL Server 2000 utilities. At 03:01 PM 03/01/2002 +, you wrote: Anyone know if there's such a thing as an MS SQL Server 7.0 evaluation version/developer's edition? I grabbed the SQL 2000 trial in anticipation of doing some work for a client, now it turns out they're running 7, and I'd like to do this bit of development on the same version... - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: PHPConfig
There wouldn't happen to be one of those to edit apache? That's the only thing that stops me from using it. Don't have the time to really sit there and do it. One of these days I will. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:15 AM To: CF-Talk Subject: PHPConfig I know some of us CFers still must code in other languages, and I found this little jewel for editing the PHP.ini http://www.analogx.com/contents/download/network/phpconf.htm Success is a journey, not a destination!! Doug Brown __ 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: Verity Issue - Returning Incorrect Results?
On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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: Verity Issue - Returning Incorrect Results?
Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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: Verity Issue - Returning Incorrect Results?
look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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: cfhttp pressure
Jason said, Is there a better way, other then converting all content to static pages? (I don't want to use query caching as it will not do and eat all the memory) The method I referred to isn't going to do anything for you if you are looking to reduce load on your db server and CF itself Its just a quick/dirty way to make pages appear to be static If I had CF5, I'd probably use the method Jochem suggested, and then build code to maintain it on a page-by-page basis as I added or edited content --Matt Robertson-- MSB Designs, Inc http://mysecretbasecom __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Verity Issue - Returning Incorrect Results?
At the risk of sounding lame, is there any documentation on the Verity search engine that comes with CF? My applications are full of includes, modules, etc. and I chose NOT to use verity because it would always return only a partial page. Can I use it as a spider, I mean, follow links on the site and return results based on the actual layout? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:19 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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: SQL Server 7.0 evaluation/developer's edition
You can still pick up copies of SQL Server 7, and it is a little cheaper than before they released SQL 2000. http://cnet.search.com/search?timeout=3tag=ex.cn.1.srch.cnetq=sq l+server+7 Mike -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:02 AM To: CF-Talk Subject: SQL Server 7.0 evaluation/developer's edition Anyone know if there's such a thing as an MS SQL Server 7.0 evaluation version/developer's edition? I grabbed the SQL 2000 trial in anticipation of doing some work for a client, now it turns out they're running 7, and I'd like to do this bit of development on the same version... - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Verity Issue - Returning Incorrect Results?
On Fri, 1 Mar 2002 11:18:32 -0500, Sean McCarthy wrote: look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit ___ _ _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 _ _ 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 I thought I saw a custom tag at the DevCenter which addresses the junk html strip-out, you may also want to check CFLib.org -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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: Image directory flow
Tim, In you application.cfm page set a variable to the base reference and then use it in you pages. Example: cfset baseRef=http://rootdomain.com/ Then when calling the graphics in your header and footer includes: img src=#baseref#/content/graphics/image.jpg Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ -Original Message- From: Tim VanderPloeg [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:36 PM To: CF-Talk Subject: Image directory flow I must be missing something very simple but I am new to CF. I have to follow a directory structure hear where I work that goes like this: Root Dept Apps Content Graphics Apps What I am trying to do is to have a header.cfm and footer.cfm that will be located in the Apps directory and the images in the Graphics directory. All of my pages will use the header.cfm and footer.cfm no matter what level the module is at. With the cfinclude template=/header.cfm the images do not carry over to the different levels unless they are in the same level as the header.cfm is. In the img src=../content/graphics/image.jpg call I have tried it with just the / at the beginning and still no luck. What do I need to do so all of the images that are stored in the graphics folder and used in the header.cfm no matter what level I include the header.cfm will be seen. I only want one header.cfm, menu.cfm and footer.cfm on the site. Tim VanderPloeg South Florida TSG Web Developer 561-840-7018 __ 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: Image directory flow
Tim, Use aboslute instead of relative paths ie /dept/content/graphics/imagenamejpg This will fix the problem because the first backslash in front of dept tells it to drop to the root On Fri, 01 March 2002, Tim VanderPloeg wrote: I must be missing something very simple but I am new to CF I have to follow a directory structure hear where I work that goes like this: Root Dept Apps Content Graphics Apps What I am trying to do is to have a headercfm and footercfm that will be located in the Apps directory and the images in the Graphics directory All of my pages will use the headercfm and footercfm no matter what level the module is at With the cfinclude template=/headercfm the images do not carry over to the different levels unless they are in the same level as the headercfm is In the img src=/content/graphics/imagejpg call I have tried it with just the / at the beginning and still no luck What do I need to do so all of the images that are stored in the graphics folder and used in the headercfm no matter what level I include the headercfm will be seen I only want one headercfm, menucfm and footercfm on the site Tim VanderPloeg South Florida TSG Web Developer 561-840-7018 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Image directory flow
Tim; Um... okay, I think I know what the problem is. The header and footer files are in a different directory than the content files. The client Web browser will be looking for the files based on the physical location of the content files on the Web server, not based on the location of the header and footer files. You need to think about the location of the image directory relative to the location of the content pages. What you will need to do is adjust the links to images in the header and footer files to be dynamic based on the location of the content page, i.e. img src=#request.page_level#images/thisimg.jpg You will need to set a variable in each one of your content pages that refers to the location of the images directory relative to the content page, i.e. cfset request.page_level = ../. You can create a new file, call it app_local.cfm or something like that, and include it in each of your content pages. Should do the trick, Mike -Original Message- From: Tim VanderPloeg [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:36 PM To: CF-Talk Subject: Image directory flow I must be missing something very simple but I am new to CF. I have to follow a directory structure hear where I work that goes like this: Root Dept Apps Content Graphics Apps What I am trying to do is to have a header.cfm and footer.cfm that will be located in the Apps directory and the images in the Graphics directory. All of my pages will use the header.cfm and footer.cfm no matter what level the module is at. With the cfinclude template=/header.cfm the images do not carry over to the different levels unless they are in the same level as the header.cfm is. In the img src=../content/graphics/image.jpg call I have tried it with just the / at the beginning and still no luck. What do I need to do so all of the images that are stored in the graphics folder and used in the header.cfm no matter what level I include the header.cfm will be seen. I only want one header.cfm, menu.cfm and footer.cfm on the site. Tim VanderPloeg South Florida TSG Web Developer 561-840-7018 __ 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: 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 03 sec If you're running CF 5, and you're not using the bundled Verity K2 Server for searches, you might want to try that out first It's significantly faster, and may be a better solution than storing files within the database Information on using K2 is available in the CF docs, and here: http://wwwcfugoramacom/cfugorama/codelibrary/loadercfm?url=/commonspot/se curity/getfilecfmPageID=1727 Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Unknown Data Access Error
Anyone ever seen this? CF5/Win2k/Apache/Oracle 8.0.5 (using ODBC driver) This is from a basic update statement. I have plenty of others and they don't have this problem... Error,1400,03/01/02,11:07:21,,Data Access ErrorP Unknown Data Access Error.P Error,1400,03/01/02,11:07:21,,65.208.124.109, Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0), Data Access ErrorPP Unknown Data Access Error.PPpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (33:3) to (33:50)./pPPDate/Time: 03/01/02 11:07:21BRBrowser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)BRRemote Address: 65.208.124.109BRHTTP Referrer: http://shop.hitmenow.com/affiliates/p-update.cfmP Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ 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: Verity Issue - Returning Incorrect Results?
Mike, If you have access to the CF docs, which are linked from the cfadmin check out cfdocs/Advanced_ColdFusion_Administration/VerityPart.html I read through it a week or two ago and it has a good coverage of the functionality provided by Verity with CF and how to use it and tweak it, including the Spider. Good luck, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com ** -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 8:45 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? At the risk of sounding lame, is there any documentation on the Verity search engine that comes with CF? My applications are full of includes, modules, etc. and I chose NOT to use verity because it would always return only a partial page. Can I use it as a spider, I mean, follow links on the site and return results based on the actual layout? Mike __ 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
OOT - Information
Hello everyone, As its sitting on a month and half of looking for a job and no luck yet I was wondering if anyone has any leads for the Minnesota,Minneapolis area I could check out and hopefully get hired Thank You Troy Montour Vampires Inc 4663 Main ST Fridley, MN 55421 Phone: (612) 867-6831 Fax: (763) 586-0552 wwwvampiresinccom __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: OOT - Information
Troy, it looks like a definite nightmare out there right now for jobs. I find nobody wanting to hire , but several wanting just contract work. you figure California would be busting out the seams with jobs, but.NOT Success is a journey, not a destination!! Doug Brown - Original Message - From: Troy Montour [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 9:15 AM Subject: OOT - Information Hello everyone, As its sitting on a month and half of looking for a job and no luck yet I was wondering if anyone has any leads for the Minnesota,Minneapolis area I could check out and hopefully get hired. Thank You Troy Montour Vampires Inc 4663 Main ST Fridley, MN 55421 Phone: (612) 867-6831 Fax: (763) 586-0552 www.vampiresinc.com __ 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
Flash Connector Kit issues
Hi All, I'm trying to get the Flash Connector Kit examples to run and I'm having some problems. I've changed the path from localhost to the domain I'm hosting in the Flash ActionScripts of the examples and that works fine. I can browse to the greeting exampletype in my name...hit try itand then I get. A script in this movie is causing Flash Player to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? Anybody else run across this one? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ 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: Verity Issue - Returning Incorrect Results?
Do a search on the houseoffusion.com mail list there are a number of examples. The docs would reference it as the vspider. Heres Jeffs examples: http://www.spectrumastro.com/veritydemo/index.cfm Ahh found it another good example: http://www.daemon.com.au/navitron/display.cfm?objectid=DD870544-07B0-4 AF0-8B 67792653EDB5D4 Sean -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:45 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? At the risk of sounding lame, is there any documentation on the Verity search engine that comes with CF? My applications are full of includes, modules, etc. and I chose NOT to use verity because it would always return only a partial page. Can I use it as a spider, I mean, follow links on the site and return results based on the actual layout? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:19 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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
mulitple SQL statements and passing values
Hi, If I want to query a table for an id and then save that id to another table, can I do it in the same SQL statement? If so, how do I refer to the value from the first select? It's something like this: cfquery datasource=#datasource# cfloop from=1 to=whatever index=index select id from table_1 insert into table_2(table_1_id)values(the_id_ just queried) /cfloop /cfquery TIA, Doug Jordon __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: mulitple SQL statements and passing values
You might be able to do something like so, never tried it. declare @this_id int begin select @this_id = (id) from your table end insert into table2 (tablerow) values (@this_id) Success is a journey, not a destination!! Doug Brown - Original Message - From: Douglas Jordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 10:47 AM Subject: mulitple SQL statements and passing values Hi, If I want to query a table for an id and then save that id to another table, can I do it in the same SQL statement? If so, how do I refer to the value from the first select? It's something like this: cfquery datasource=#datasource# cfloop from=1 to=whatever index=index select id from table_1 insert into table_2(table_1_id)values(the_id_ just queried) /cfloop /cfquery TIA, Doug Jordon __ 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: What are these, headers?
Matthew, Yes, a lot of code is being generated (as Jochem pointed out, 2MB). What code is run before CFIF CheckCache.RecordCount cflocation url=/cache/#checkcache.file# Jochem, The only code being written prior to that is a query called checkcache. However, CFHTTP is run on the first access to that query result page. The header is generated either by an exessively long page (why I don't know), the CFHTTP, a combination of the two, or some web server setting or filter. Thanks again! Andrew -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 4:06 PM To: CF-Talk Subject: RE: What are these, headers? I've had this. It happens when a lot of code is output before the cflocation. If you can reduce the amount of code it should come right. For example, I resolved it by moving a large Javascript block from the top to the bottom. Any help? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 March 2002 10:39 am To: CF-Talk Subject: Re: What are these, headers? Andrew Peterson wrote: Hi The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? Standard HTML headers (although I wouldn't want to call the content length standard, 2MB is a lot :) ). This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. Thing to check is if this text is actually inside the static HTML page (quite unlikely because of the rest of the symptoms, but check anyway). However, I've learned through testing that if I use a Meta Refresh instead of a CFLocate, text does not appear (i.e. problem solved). This makes me believe you have a problem that is bigger as this. Somewhere in the webserver/cfserver setup something goes wrong which means that the server is adding the HTTP headers twice. And that is a problem because in that case the second occurence ends up in the page visible to the user. What code is run before CFIF CheckCache.RecordCount cflocation url=/cache/#checkcache.file# Anything that does something with headers/pageflow (cfflush, cfcache, cfcontent, cfheader, cflocation etc.)? What happens if you remove that code? Try putting a cfabort after the cflocation? Did you by any chance install URLScan recently? Which ISAPI filters do you have? Are you running IIS HTTP compression? Jochem __ 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: Verity Issue - Returning Incorrect Results?
Those documents are pretty cool. I had no idea there was an actual spider! I don't need to use it now, but most of the sites I build are in Fusebox and I would want to spider those sites instead of index them. The spider collection is limited to links on the localhost. Has anyone worked with the more robust version that handles a full domain? If so, how much does it cost? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:15 PM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Do a search on the houseoffusion.com mail list there are a number of examples. The docs would reference it as the vspider. Heres Jeffs examples: http://www.spectrumastro.com/veritydemo/index.cfm Ahh found it another good example: http://www.daemon.com.au/navitron/display.cfm?objectid=DD870544-07B0-4 AF0-8B 67792653EDB5D4 Sean -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:45 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? At the risk of sounding lame, is there any documentation on the Verity search engine that comes with CF? My applications are full of includes, modules, etc. and I chose NOT to use verity because it would always return only a partial page. Can I use it as a spider, I mean, follow links on the site and return results based on the actual layout? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:19 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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
Oracle Error about extending tablespace..
Hi all, I don't know Oracle very well, and a client is getting this error from a website I built for them that uses Oracle Oracle Error Code = 1653 ORA-01653: unable to extend table Timentrytabledetails by 41 in tablespace TIMENTRY This is happening whenever someone tries to add a new record to the database The tabledetails table takes very high traffic and can potentially have errrmmaybe thousands of records in a very short time Any ideas? Hewp! 0_0 -Gel __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Oracle Error about extending tablespace..
check the disk space on the drive on which the table resides. you may be out. christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:15 PM To: CF-Talk Subject: Oracle Error about extending tablespace.. Hi all, I don't know Oracle very well, and a client is getting this error from a website I built for them that uses Oracle. Oracle Error Code = 1653 ORA-01653: unable to extend table Timentry.tabledetails by 41 in tablespace TIMENTRY This is happening whenever someone tries to add a new record to the database. The tabledetails table takes very high traffic and can potentially have errrm..maybe thousands of records in a very short time. Any ideas? Hewp! 0_0 -Gel __ 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: mulitple SQL statements and passing values
in SQL Server: INSERT INTO table_2 (table_1_id) SELECT id from Table_1 christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:48 PM To: CF-Talk Subject: mulitple SQL statements and passing values Hi, If I want to query a table for an id and then save that id to another table, can I do it in the same SQL statement? If so, how do I refer to the value from the first select? It's something like this: cfquery datasource=#datasource# cfloop from=1 to=whatever index=index select id from table_1 insert into table_2(table_1_id)values(the_id_ just queried) /cfloop /cfquery TIA, Doug Jordon __ 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
page up/down
Hello, I know this has been asked 1000's of times, but I lost the code: Anyone have a simple Page Up/Page Down CF code I want to insert it into a display page to have it display fivce records at a time Many thanks for all the help! __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: page up/down
You can download our QDNext for free: http://www.quilldesign.com It allows for next/previous and page series's as well .. It's also free! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 1:52 PM Subject: page up/down Hello, I know this has been asked 1000's of times, but I lost the code: Anyone have a simple Page Up/Page Down CF code. I want to insert it into a display page to have it display fivce records at a time. Many thanks for all the help! __ 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: Verity Issue - Returning Incorrect Results?
I called verity, 10K for the full... but as they said: In the current state of the market that price is... negotiable You can spider multiple sites on the same box though Sean -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:06 PM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Those documents are pretty cool. I had no idea there was an actual spider! I don't need to use it now, but most of the sites I build are in Fusebox and I would want to spider those sites instead of index them. The spider collection is limited to links on the localhost. Has anyone worked with the more robust version that handles a full domain? If so, how much does it cost? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:15 PM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Do a search on the houseoffusion.com mail list there are a number of examples. The docs would reference it as the vspider. Heres Jeffs examples: http://www.spectrumastro.com/veritydemo/index.cfm Ahh found it another good example: http://www.daemon.com.au/navitron/display.cfm?objectid=DD870544-07B0-4 AF0-8B 67792653EDB5D4 Sean -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:45 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? At the risk of sounding lame, is there any documentation on the Verity search engine that comes with CF? My applications are full of includes, modules, etc. and I chose NOT to use verity because it would always return only a partial page. Can I use it as a spider, I mean, follow links on the site and return results based on the actual layout? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:19 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ 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: Verity Issue - Returning Incorrect Results?
That version of the spider is limited to 10 sites, but they can be ANY site. Additional site packs cost extra. Did they quote you for the Silver version of the K2 Enterprise system? If so definitely check into the Gold, shouldn't be too much more than the silver and you get a lot more (the Security module which is way cool and the content categorization engine that is cool as well). Good Luck, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:24 PM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? I called verity, 10K for the full... but as they said: In the current state of the market that price is... negotiable You can spider multiple sites on the same box though Sean -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:06 PM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Those documents are pretty cool. I had no idea there was an actual spider! I don't need to use it now, but most of the sites I build are in Fusebox and I would want to spider those sites instead of index them. The spider collection is limited to links on the localhost. Has anyone worked with the more robust version that handles a full domain? If so, how much does it cost? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:15 PM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Do a search on the houseoffusion.com mail list there are a number of examples. The docs would reference it as the vspider. Heres Jeffs examples: http://www.spectrumastro.com/veritydemo/index.cfm Ahh found it another good example: http://www.daemon.com.au/navitron/display.cfm?objectid=DD870544-07B0-4 AF0-8B 67792653EDB5D4 Sean -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:45 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? At the risk of sounding lame, is there any documentation on the Verity search engine that comes with CF? My applications are full of includes, modules, etc. and I chose NOT to use verity because it would always return only a partial page. Can I use it as a spider, I mean, follow links on the site and return results based on the actual layout? Mike -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:19 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? look into the verity spider -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:14 AM To: CF-Talk Subject: RE: Verity Issue - Returning Incorrect Results? Hi Mark, I've determined this now. Its returning the correct results, because some of the articles are uploaded files (html) that were created in Word and contain a bunch of excess html code at the type (one being style sheets that contains the word hybrid, which what the search word was). So now I'm trying to find out the best way to strip out all this extra and just index the actual text of the uploaded file. Thanks again, Phil -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 11:05 AM To: CF-Talk Subject: Re: Verity Issue - Returning Incorrect Results? On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote: Running CF 5.0 and when we run our search against the collection, it returns what from the surface appear to be inconsistent results. I will search on hybrid and first 7 articles will be foreign text and when I search the body that word does not appear. Next article will be in English and does contain the keyword in the body. But then next article in English does not contain the keyword in the body. Wondering if anyone could point me to where the mistake might be taking place. During the index/update of the collection? During the actual search call? Thanks in advance Phil E Hebenstreit _ _ 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 Hi Phil, Is this a document search or a db search? Did you set a specific language in the CFIndex tag? Mark -- Mark Leder, [EMAIL PROTECTED] on 03/01/2002 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB
RE: Flash Connector Kit issues
This usually happens when you have an infinite loop in the Flash Player. Check you ActionScript to verify that you are not hanging up while trying to connect to the server. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:06 AM To: CF-Talk Subject: Flash Connector Kit issues Hi All, I'm trying to get the Flash Connector Kit examples to run and I'm having some problems. I've changed the path from localhost to the domain I'm hosting in the Flash ActionScripts of the examples and that works fine. I can browse to the greeting exampletype in my name...hit try itand then I get. A script in this movie is causing Flash Player to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? Anybody else run across this one? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ 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: Flash Connector Kit issues
I'm just trying to get the examples that come with the connector kit working. Please tell me that Macromedia didn't ship broken examples. I'm brand spankin new to this, so if you have something a tad more detailed to look for in the ActionScript I'd be very grateful. From what I've found so far a lot of people have had this same issue, but none of the forums have shown how to deal with it. HELP!!! ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Scott Van Vliet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 12:38 PM Subject: RE: Flash Connector Kit issues This usually happens when you have an infinite loop in the Flash Player. Check you ActionScript to verify that you are not hanging up while trying to connect to the server. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:06 AM To: CF-Talk Subject: Flash Connector Kit issues Hi All, I'm trying to get the Flash Connector Kit examples to run and I'm having some problems. I've changed the path from localhost to the domain I'm hosting in the Flash ActionScripts of the examples and that works fine. I can browse to the greeting exampletype in my name...hit try itand then I get. A script in this movie is causing Flash Player to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? Anybody else run across this one? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ 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: Flash Connector Kit issues
it also happens when you simply pass too much data to a FLASH control. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 4:01 PM To: CF-Talk Subject: Re: Flash Connector Kit issues I'm just trying to get the examples that come with the connector kit working. Please tell me that Macromedia didn't ship broken examples. I'm brand spankin new to this, so if you have something a tad more detailed to look for in the ActionScript I'd be very grateful. From what I've found so far a lot of people have had this same issue, but none of the forums have shown how to deal with it. HELP!!! ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Scott Van Vliet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 12:38 PM Subject: RE: Flash Connector Kit issues This usually happens when you have an infinite loop in the Flash Player. Check you ActionScript to verify that you are not hanging up while trying to connect to the server. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:06 AM To: CF-Talk Subject: Flash Connector Kit issues Hi All, I'm trying to get the Flash Connector Kit examples to run and I'm having some problems. I've changed the path from localhost to the domain I'm hosting in the Flash ActionScripts of the examples and that works fine. I can browse to the greeting exampletype in my name...hit try itand then I get. A script in this movie is causing Flash Player to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? Anybody else run across this one? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ 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: Attaching CSS style sheet
What's the problem with referencing the stylesheet in the application.cfm file? I have done this on several websites and never seen a problem before. Here's the code I use: LINK REL=STYLESHEET TYPE=text/css HREF=stylesheet.css Is there an issue with doing it this way? Thanks, Mike At 2/28/2002 09:46 PM, you wrote: I'm not sure, but I agree that the header.cfm is the way to go. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:39 PM To: CF-Talk Subject: Re: Attaching CSS style sheet Steve, Wouldn't the cfhtmlhead in the application.cfm file place two headers o n each page? It would seem the best would be to create a header.cfm file that included information like stylesheets, and other repetitive information. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 8:35 PM Subject: RE: Attaching CSS style sheet The first one should work, but I don't think your supposed to include html or scripts in the application.cfm. If you need something like that make a header.cfm and cfinclude it in your documents. I believe it has to be in the head of the page also. But if you really need it in your application.cfm, you could try something like this: cfhtmlhead text=LINK href=css/ifma1.css rel=stylesheet type=text/css _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:24 PM To: CF-Talk Subject: Attaching CSS style sheet How does one call a CSS from the application.cfm file. I've tried the following two methods with no effect: 1) LINK rel=stylesheet href=/css/ifma1.css type=text/css 2) cfinclude template = css/ifma1.css The Css directory is under the application.cfm file. Thanks for your help. Mark -- Mark Leder, [EMAIL PROTECTED] on 02/28/2002 __ 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: page up/down
Thank you. Works fine. Robert O. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:01 PM To: CF-Talk Subject: Re: page up/down You can download our QDNext for free: http://www.quilldesign.com It allows for next/previous and page series's as well .. It's also free! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 1:52 PM Subject: page up/down Hello, I know this has been asked 1000's of times, but I lost the code: Anyone have a simple Page Up/Page Down CF code. I want to insert it into a display page to have it display fivce records at a time. Many thanks for all the help! __ 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: Attaching CSS style sheet
What's the problem with referencing the stylesheet in the applicationcfm file? I have done this on several websites and never seen a problem before Here's the code I use: LINK REL=STYLESHEET TYPE=text/css HREF=stylesheetcss Is there an issue with doing it this way? Not really, except from an HTML validation point of view The LINK tag should be placed within the document head, not before the entire HTML document, which is typically where it would be if you put it in via Applicationcfm Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: mulitple SQL statements and passing values
Yes, that worked. Thank you. Douglas Brown wrote: You might be able to do something like so, never tried it. declare @this_id int begin select @this_id = (id) from your table end insert into table2 (tablerow) values (@this_id) Success is a journey, not a destination!! Doug Brown - Original Message - From: Douglas Jordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 10:47 AM Subject: mulitple SQL statements and passing values Hi, If I want to query a table for an id and then save that id to another table, can I do it in the same SQL statement? If so, how do I refer to the value from the first select? It's something like this: cfquery datasource=#datasource# cfloop from=1 to=whatever index=index select id from table_1 insert into table_2(table_1_id)values(the_id_ just queried) /cfloop /cfquery TIA, Doug Jordon __ 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: page up/down
Glad it worked for you ... We haven't updated QD Next in awhile .. it could probably use a few tweaks .. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 3:04 PM Subject: RE: page up/down Thank you. Works fine. Robert O. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:01 PM To: CF-Talk Subject: Re: page up/down You can download our QDNext for free: http://www.quilldesign.com It allows for next/previous and page series's as well .. It's also free! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 1:52 PM Subject: page up/down Hello, I know this has been asked 1000's of times, but I lost the code: Anyone have a simple Page Up/Page Down CF code. I want to insert it into a display page to have it display fivce records at a time. Many thanks for all the help! __ 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: Attaching CSS style sheet
So wouldn't it be simple then to assign a var from the application.cfm file to the HREF= name? I.e., LINK REL=STYLESHEET TYPE=text/css HREF=cfoutput#varfromapplicationfile#/cfoutput | -Original Message- | From: Dave Watts [mailto:[EMAIL PROTECTED]] | Sent: Friday, March 01, 2002 1:16 PM | To: CF-Talk | Subject: RE: Attaching CSS style sheet | | | What's the problem with referencing the stylesheet in the | application.cfm file? I have done this on several websites | and never seen a problem before. | | Here's the code I use: | | LINK REL=STYLESHEET TYPE=text/css HREF=stylesheet.css | | Is there an issue with doing it this way? | | Not really, except from an HTML validation point of view. The | LINK tag should be placed within the document head, not | before the entire HTML document, which is typically where it | would be if you put it in via Application.cfm. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 | __ 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: page up/down
I've written a custom tag that does that, and is fairly customizable. I just wrote it for in house use so it isn't anything special, but you are more than welcome to the code and you can change it however you'd like. Contact me off list if you'd like me to send it to you. Jared [EMAIL PROTECTED] - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 12:52 PM Subject: page up/down | Hello, | | I know this has been asked 1000's of times, but I lost the code: Anyone | have a simple Page Up/Page Down CF code. I want to insert it into a | display page to have it display fivce records at a time. | | Many thanks for all the help! | | __ 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
Regular Expression Help
Hello all I am trying to write a simple search engine, and would like to replace certain commonly used prepositions from the search string such as 'a','the','for', etc I have an array of the prepositions that I would like to remove, however the problem I have is that it is removing them when they are subsets of other words, for example 'them' would become 'm' when removing 'the', 'bag' would become 'bg' when removing 'a', etc I'm not an expert at regular expression, but I'm assuming it is possible to remove only those instances where the prepositions are stand-alone and not subsets of other words Could someone render me some assistance? Much thanks, Jared __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
assigning a value to a dynamic variable?
Can someone help me make this work? I'm not sure how to explain it clearly, so I'm hoping the code/comments make sense !--- assign show variable --- CFSET show = userID !--- assign sub value to value set above --- CFSET evaluate('#show#')= allUsers !--- debugging output --- CFOUTPUT first variable: #show#br variable's variable: #evaluate('#show#')#BR /CFOUTPUT __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: assigning a value to a dynamic variable?
To set a dynamic variable, use setVariable: cfset show = userID cfset setVariable(show,allUsers) You will still need evaluate to display it though. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 4:34 PM To: CF-Talk Subject: assigning a value to a dynamic variable? Can someone help me make this work? I'm not sure how to explain it clearly, so I'm hoping the code/comments make sense... !--- assign show variable --- CFSET show = userID !--- assign sub value to value set above --- CFSET evaluate('#show#')= allUsers !--- debugging output --- CFOUTPUT first variable: #show#br variable's variable: #evaluate('#show#')#BR /CFOUTPUT __ 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: Attaching CSS style sheet
If you are trying to dynamically assign a style sheet for each page, you could do the following: html head titleTitle/title link rel=stylesheet href=includes/css/styles.cfm type=text/css /head body .. /body /html Them, in your styles.cfm page, you could have: cfsetting enablecfoutputonly=yes !--- --- --- !--- PAGE: styles.cfm -- --- !--- --- --- cfswitch expression=#CGI.SCRIPT_NAME# cfcase value=/index.cfm cfoutput body { font-family: Verdana; font-size: 11px; } input { font-family: Arial; font-size: 12px; color: #33; } cfoutput /cfcase ... /cfswitch cfsetting enablecfoutputonly=no NOT TESTED, but it should work. HTH -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 6:24 PM To: CF-Talk Subject: Attaching CSS style sheet How does one call a CSS from the application.cfm file. I've tried the following two methods with no effect: 1) LINK rel=stylesheet href=/css/ifma1.css type=text/css 2) cfinclude template = css/ifma1.css The Css directory is under the application.cfm file. Thanks for your help. Mark -- Mark Leder, [EMAIL PROTECTED] on 02/28/2002 __ 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: assigning a value to a dynamic variable?
Actually, there is a shorthand for this: change: cfset Evaluate('#show#') = allUsers to: cfset #show# = allUsers - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 2:36 PM Subject: RE: assigning a value to a dynamic variable? | To set a dynamic variable, use setVariable: | | cfset show = userID | cfset setVariable(show,allUsers) | | You will still need evaluate to display it though. | | === | Raymond Camden, Principal Spectra Compliance Engineer for Macromedia | | Email: [EMAIL PROTECTED] | Yahoo IM : morpheus | | My ally is the Force, and a powerful ally it is. - Yoda | | -Original Message- | From: Louis Klepner [mailto:[EMAIL PROTECTED]] | Sent: Friday, March 01, 2002 4:34 PM | To: CF-Talk | Subject: assigning a value to a dynamic variable? | | | Can someone help me make this work? | I'm not sure how to explain it clearly, so I'm hoping the | code/comments make | sense... | | !--- assign show variable --- | CFSET show = userID | | !--- assign sub value to value set above --- | CFSET evaluate('#show#')= allUsers | | !--- debugging output --- | CFOUTPUT | first variable: #show#br | variable's variable: #evaluate('#show#')#BR | /CFOUTPUT | | | | | __ 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: assigning a value to a dynamic variable?
Ahh- Very good! Thank you! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raymond Camden Sent: Friday, March 01, 2002 4:37 PM To: CF-Talk Subject: RE: assigning a value to a dynamic variable? To set a dynamic variable, use setVariable: cfset show = userID cfset setVariable(show,allUsers) You will still need evaluate to display it though. Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 4:34 PM To: CF-Talk Subject: assigning a value to a dynamic variable? Can someone help me make this work? I'm not sure how to explain it clearly, so I'm hoping the code/comments make sense... !--- assign show variable --- CFSET show = userID !--- assign sub value to value set above --- CFSET evaluate('#show#')= allUsers !--- debugging output --- CFOUTPUT first variable: #show#br variable's variable: #evaluate('#show#')#BR /CFOUTPUT _ _ 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 __ 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: Attaching CSS style sheet
If you are trying to dynamically assign a style sheet for each page, you could do the following: html head titleTitle/title link rel=stylesheet href=includes/css/stylescfm type=text/css /head body /body /html Them, in your stylescfm page, you could have: cfsetting enablecfoutputonly=yes !--- --- --- !--- PAGE: stylescfm -- --- !--- --- --- cfswitch expression=#CGISCRIPT_NAME# In general, if you can avoid dynamically generating style sheets (just like anything else), you'll get better performance, since the browser will cache them, and won't have to refetch them I'd recommend that you organize your styles in such a way that you don't reuse style identifiers, or if you do, you use the cascading part of the standard to override the styles attached to certain identifiers Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Attaching CSS style sheet
| What's the problem with referencing the stylesheet in the | applicationcfm file? I have done this on several websites | and never seen a problem before | | Here's the code I use: | | LINK REL=STYLESHEET TYPE=text/css HREF=stylesheetcss | | Is there an issue with doing it this way? | | Not really, except from an HTML validation point of view The | LINK tag should be placed within the document head, not | before the entire HTML document, which is typically where it | would be if you put it in via Applicationcfm So wouldn't it be simple then to assign a var from the applicationcfm file to the HREF= name? Ie, LINK REL=STYLESHEET TYPE=text/css HREF=cfoutput#varfromapplicationfile#/cfoutput Yes, that would work fine Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: assigning a value to a dynamic variable?
Okay, that works too- and it's a little shorter... I like it- Thanks! Actually, there is a shorthand for this: change: cfset Evaluate('#show#') = allUsers to: cfset #show# = allUsers - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 2:36 PM Subject: RE: assigning a value to a dynamic variable? | To set a dynamic variable, use setVariable: | | cfset show = userID | cfset setVariable(show,allUsers) | | You will still need evaluate to display it though. | | | Raymond Camden, Principal Spectra Compliance Engineer for Macromedi a | | Email: [EMAIL PROTECTED] | Yahoo IM : morpheus | | My ally is the Force, and a powerful ally it is. - Yoda | | -Original Message- | From: Louis Klepner [mailto:[EMAIL PROTECTED]] | Sent: Friday, March 01, 2002 4:34 PM | To: CF-Talk | Subject: assigning a value to a dynamic variable? | | | Can someone help me make this work? | I'm not sure how to explain it clearly, so I'm hoping the | code/comments make | sense... | | !--- assign show variable --- | CFSET show = userID | | !--- assign sub value to value set above --- | CFSET evaluate('#show#')= allUsers | | !--- debugging output --- | CFOUTPUT | first variable: #show#br | variable's variable: #evaluate('#show#')#BR | /CFOUTPUT | | | | | _ _ 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 __ 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: Regular Expression Help
Going from limited memory of the subject here, but try something like this: [\w the|a|..] (the 'the|a|..' part would be your preposition list...) I think the \w means you are looking for whole words. Or it might be \W... Hope that helps some... Shawn Grover -Original Message- From: Jared Stark [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:11 PM To: CF-Talk Subject: Regular Expression Help Hello all. I am trying to write a simple search engine, and would like to replace certain commonly used prepositions from the search string such as 'a','the','for', etc... I have an array of the prepositions that I would like to remove, however the problem I have is that it is removing them when they are subsets of other words, for example 'them' would become 'm' when removing 'the', 'bag' would become 'bg' when removing 'a', etc... I'm not an expert at regular expression, but I'm assuming it is possible to remove only those instances where the prepositions are stand-alone and not subsets of other words. Could someone render me some assistance? Much thanks, Jared __ 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
Any other way to look at datasources?
Hi All I know that you can see the datasource names and the servers they are pointing to in cfadmin But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc So, if there is another way to look at the datasources, that would be nice Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Any other way to look at datasources?
Hi All I know that you can see the datasource names and the servers they are pointing to in cfadmin But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc So, if there is another way to look at the datasources, that would be nice Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: Any other way to look at datasources?
The servers registry holds all of the datasource information for the CFAdmin, you can see it in there .. but it doesn't give the server information... Software/allaire/datasources Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 3:55 PM Subject: Any other way to look at datasources? Hi All. I know that you can see the datasource names and the servers they are pointing to in cfadmin. But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to. All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc. So, if there is another way to look at the datasources, that would be nice. Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ 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: Any other way to look at datasources?
Control PanelODBC Settings Regards, Howie - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 4:55 PM Subject: Any other way to look at datasources? Hi All. I know that you can see the datasource names and the servers they are pointing to in cfadmin. But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to. All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc. So, if there is another way to look at the datasources, that would be nice. Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ 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: assigning a value to a dynamic variable?
Or.. SetVariable(Show,'alUsers'); change: cfset Evaluate('#show#') = allUsers to: cfset #show# = allUsers - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 2:36 PM Subject: RE: assigning a value to a dynamic variable? | To set a dynamic variable, use setVariable: | | cfset show = userID | cfset setVariable(show,allUsers) | | You will still need evaluate to display it though. | | | Raymond Camden, Principal Spectra Compliance Engineer for Macromedi a | | Email: [EMAIL PROTECTED] | Yahoo IM : morpheus | | My ally is the Force, and a powerful ally it is. - Yoda | | -Original Message- | From: Louis Klepner [mailto:[EMAIL PROTECTED]] | Sent: Friday, March 01, 2002 4:34 PM | To: CF-Talk | Subject: assigning a value to a dynamic variable? | | | Can someone help me make this work? | I'm not sure how to explain it clearly, so I'm hoping the | code/comments make | sense... | | !--- assign show variable --- | CFSET show = userID | | !--- assign sub value to value set above --- | CFSET evaluate('#show#')= allUsers | | !--- debugging output --- | CFOUTPUT | first variable: #show#br | variable's variable: #evaluate('#show#')#BR | /CFOUTPUT | | | | | _ _ 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 __ 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: Any other way to look at datasources?
CF_Datasource will give you a list of datasources on the server... http://www.cfdev.com/products free encrypted version. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 5:02 PM To: CF-Talk Subject: Re: Any other way to look at datasources? Control PanelODBC Settings Regards, Howie - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 4:55 PM Subject: Any other way to look at datasources? Hi All. I know that you can see the datasource names and the servers they are pointing to in cfadmin. But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to. All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc. So, if there is another way to look at the datasources, that would be nice. Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ 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: PHPConfig
Yeah... I think it's called notepad :-) -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 7:50 AM To: CF-Talk Subject: RE: PHPConfig There wouldn't happen to be one of those to edit apache? That's the only thing that stops me from using it. Don't have the time to really sit there and do it. One of these days I will. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:15 AM To: CF-Talk Subject: PHPConfig I know some of us CFers still must code in other languages, and I found this little jewel for editing the PHP.ini http://www.analogx.com/contents/download/network/phpconf.htm Success is a journey, not a destination!! Doug Brown __ 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: Bug Tracking Systems
Very easy... The easiest thing to do is parse the logs, but that's a pain. In cf server, you can set a global error handling template. Here's the code because it's Friday and I feel like giving back: YAY! Free Code! link rel=stylesheet type=text/css href=/styles/worp.css cfparam name=url.action default= cfif url.action EQ sendmail cfmail server=#application.smtp# to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML An Error Occurred In Cold Fusion.br bUser Info:/bbr #form.UserInput#br System info:br #form.debuginfo# /cfmail cflocation url=joblisting.cfm /cfif form name=error action=error.cfm?action=sendmail method=post /td td valign=top table trtdspan style=font-size: 16ptbOops, an error has occurredbrPlease provide us info and click SUBMIT./b/span/td/tr trtd textarea name=UserInput rows=6 cols=80 style=font: 8pt MS Sans Serif/textarea /td/tr trtdDebugging Info (Appdev Only):/td/tr trtd textarea name=debuginfo rows=6 cols=80 style=font: 8pt MS Sans Serif; cfif session.worpadmin NEQ 1visibility: hidden/cfif bBrowser:/bcfoutput#Error.Browser#/cfoutputbr Remote Address: cfoutput#Error.RemoteAddress#/cfoutputbr bError:/bcfoutput#Error.Diagnostics#/cfoutputbr bTemplate:/b cfoutput#Error.Template#/cfoutputbr bQuery String:/b cfoutput#Error.QueryString#/cfoutputbr bVariables:/bbr table border=0 cfloop collection=#session# item=myVar tr td cftry cfoutputSESSION.#myVar#/tdtd#evaluate(session. #myvar#)#/cfoutput cfcatch/cfcatch/cftry /td /tr /cfloop br cftry cfloop collection=#form# item=myVar2 tr td cfoutputFORM.#myVar2#/tdtd#evaluate(form. #myvar2#)#/cfoutput/td /cfloop cfcatch/cfcatch /cftry /table /textarea /td/tr trtd input type=submit value= Submit /td/tr /table /td /table /form -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:13 PM To: CF-Talk Subject: Bug Tracking Systems Hi all, I'm thinking about offering a bug tracking system for our clients (during testing stages of course, I'd never have a bug in a production system :-)) for the various jobs they have running with us (i.e we'd have a number of projects with each client that they can open bugs with, but each client may not see another clients projects or bugs). Before I invest energy into reinventing the wheel, does anybody know of any bug tracking systems written in CF that I might be able to massage to fit my needs ? --- James Sleeman __ 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: Attaching CSS style sheet
I think you also need a cfcontent type=text/css tag in ther, but I'm not sure... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:52 PM To: CF-Talk Subject: RE: Attaching CSS style sheet If you are trying to dynamically assign a style sheet for each page, you could do the following: html head titleTitle/title link rel=stylesheet href=includes/css/styles.cfm type=text/css /head body .. /body /html Them, in your styles.cfm page, you could have: cfsetting enablecfoutputonly=yes !--- --- --- !--- PAGE: styles.cfm -- --- !--- --- --- cfswitch expression=#CGI.SCRIPT_NAME# ... In general, if you can avoid dynamically generating style sheets (just like anything else), you'll get better performance, since the browser will cache them, and won't have to refetch them. I'd recommend that you organize your styles in such a way that you don't reuse style identifiers, or if you do, you use the cascading part of the standard to override the styles attached to certain identifiers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Any other way to look at datasources?
If you feel like being risky and using undocumented functions theres: CFUSION_GETODBCDSN() see macromedia's article on the undocumented functions / tags http://www.macromedia.com/v1/handlers/index.cfm?ID=11714Method=Full -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 6:06 PM To: CF-Talk Subject: RE: Any other way to look at datasources? CF_Datasource will give you a list of datasources on the server... http://www.cfdev.com/products free encrypted version. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 5:02 PM To: CF-Talk Subject: Re: Any other way to look at datasources? Control PanelODBC Settings Regards, Howie - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 4:55 PM Subject: Any other way to look at datasources? Hi All. I know that you can see the datasource names and the servers they are pointing to in cfadmin. But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to. All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc. So, if there is another way to look at the datasources, that would be nice. Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ 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: Bug Tracking Systems
err...you might want to dereference the session collection first and lock this call, otherwise you get instability issues. kinda like this: cflock scope=session type=readonly timeout=5 throwontimeout=yes cfscript mySession = structnew(); mySession = duplicate(session); /cfscript /cflock then loop through the collection called 'mySession'. my2bits Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 6:21 PM To: CF-Talk Subject: RE: Bug Tracking Systems Very easy... The easiest thing to do is parse the logs, but that's a pain. In cf server, you can set a global error handling template. Here's the code because it's Friday and I feel like giving back: YAY! Free Code! link rel=stylesheet type=text/css href=/styles/worp.css cfparam name=url.action default= cfif url.action EQ sendmail cfmail server=#application.smtp# to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML An Error Occurred In Cold Fusion.br bUser Info:/bbr #form.UserInput#br System info:br #form.debuginfo# /cfmail cflocation url=joblisting.cfm /cfif form name=error action=error.cfm?action=sendmail method=post /td td valign=top table trtdspan style=font-size: 16ptbOops, an error has occurredbrPlease provide us info and click SUBMIT./b/span/td/tr trtd textarea name=UserInput rows=6 cols=80 style=font: 8pt MS Sans Serif/textarea /td/tr trtdDebugging Info (Appdev Only):/td/tr trtd textarea name=debuginfo rows=6 cols=80 style=font: 8pt MS Sans Serif; cfif session.worpadmin NEQ 1visibility: hidden/cfif bBrowser:/bcfoutput#Error.Browser#/cfoutputbr Remote Address: cfoutput#Error.RemoteAddress#/cfoutputbr bError:/bcfoutput#Error.Diagnostics#/cfoutputbr bTemplate:/b cfoutput#Error.Template#/cfoutputbr bQuery String:/b cfoutput#Error.QueryString#/cfoutputbr bVariables:/bbr table border=0 cfloop collection=#session# item=myVar tr td cftry cfoutputSESSION.#myVar#/tdtd#evaluate(session. #myvar#)#/cfoutput cfcatch/cfcatch/cftry /td /tr /cfloop br cftry cfloop collection=#form# item=myVar2 tr td cfoutputFORM.#myVar2#/tdtd#evaluate(form. #myvar2#)#/cfoutput/td /cfloop cfcatch/cfcatch /cftry /table /textarea /td/tr trtd input type=submit value= Submit /td/tr /table /td /table /form -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:13 PM To: CF-Talk Subject: Bug Tracking Systems Hi all, I'm thinking about offering a bug tracking system for our clients (during testing stages of course, I'd never have a bug in a production system :-)) for the various jobs they have running with us (i.e we'd have a number of projects with each client that they can open bugs with, but each client may not see another clients projects or bugs). Before I invest energy into reinventing the wheel, does anybody know of any bug tracking systems written in CF that I might be able to massage to fit my needs ? --- James Sleeman __ 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: XML question
wddx is just another form of an xml document. you can reference the dtd for wddx here: http://www.wddx.org i am not sure of your question though, they are two different sets of technologies that have XML in common. cheers, Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:40 PM To: CF-Talk Subject: Re: XML question Andres, Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX functionality is built into CF and there are defined tags for using it. HTH. Rey... - Original Message - From: Andres [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 11:34 PM Subject: RE: XML question Jon, Thank you for your help on this. Do you know if msxml will somehow affect CF's wddx implementation? i dont know if the two relate to each other... but i am using wddx to export some data to other systems, and dont want to interfere with those elements. Thanks! Andres -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thu 2/28/2002 8:45 PM To: CF-Talk Cc: Subject: Re: XML question I'd bet that it's same the problem I ran into when using MSXML via cfobject to grab the UPS XML, which is essentially what soxml does. CFObject apparently doesn't understand the nulls that MSXML passes back when an XML element is empty, and bombs. If you are running an older version of msxml you may want to upgrade it as 4.0 is out, that may fix some problems, as 4.0 is the first solid release imo. Have you tried the cf_usps tag? It handles pretty much everything for you. http://devex.macromedia.com/developer/gallery/info.cfm?ID=9C9C2AB9-7F93-11D5 -83F300508B94F85Amethod=Full If you want to do it via soxml here is a real simple custom tag sample that I did that just returns the country information that usps passes back. Expanding upon this to do full rates would be pretty easy, but that's what the above tag goes anyway... CFPARAM NAME=attributes.userid CFPARAM NAME=attributes.password CFPARAM NAME=attributes.server CFSCRIPT services = 'PACKAGE'; APIstr = 'IntlRate'; XMLstr = 'IntlRateRequest USERID=#attributes.userid# PASSWORD=#attributes.password#'; XMLstr = XMLstr 'Package ID=1 Pounds0/Pounds Ounces1/Ounces MailTypePackage/MailType Country#Attributes.country#/Country /Package'; XMLstr = XMLstr '/IntlRateRequest'; /CFSCRIPT CFHTTP URL=#attributes.server#?API=#APIstr#XML=#urlencodedformat(XMLstr)# method=GET resolveurl=false timeout=45 CFSET XMLResp = CFHTTP.FileContent cf_SOXML action=XML2CF input=#xmlResp# output=countryData type=Variables cfset caller.countryData = countryData.intlRateResponse.package jon ps For anyone who cares, FEDEX is finally planning on releasing an XML API withing the next two months. It's already been delayed once from Q4 2001 though, so I'm not getting my hopes up though. Andres wrote: This a rather long email... i am trying to query the USPS international rate calculator via their API. Their response is an XML document which i am parsing via SOXML. This is a great tool! snip CF throws an error saying that it cannot resolve the parameter outhere.IntlRateResponse.Service. Even though this does exist and indeed is to be an array since there are two of them. Any help would be much appreciated! Thank you __ 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: Regular Expression Help
Or you could use ListReplace with as the delimiter -- as long as you force everything lower case first. - Original Message - From: Jared Stark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 10:10 AM Subject: Regular Expression Help Hello all. I am trying to write a simple search engine, and would like to replace certain commonly used prepositions from the search string such as 'a','the','for', etc... I have an array of the prepositions that I would like to remove, howeve r the problem I have is that it is removing them when they are subsets of other words, for example 'them' would become 'm' when removing 'the', 'bag' would become 'bg' when removing 'a', etc... I'm not an expert at regular expression, but I'm assuming it is possibl e to remove only those instances where the prepositions are stand-alone and not subsets of other words. Could someone render me some assistance? Much thanks, Jared __ 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: Any other way to look at datasources?
Well, if you access to use CFREGISTRY, you can look at the datasources entered through the ColdFusion Administrator: CFREGISTRY ACTION=GetAll BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\ Datasources TYPE=Key NAME=dsnQuery Then just output the dsnQuery query to view the DSNs. NOTE that these reg keys only hold the ColdFusion data for each datasource. This might not be what you are looking for, but might steer you in the right direction. HTH. -Original Message- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:56 PM To: CF-Talk Subject: Any other way to look at datasources? Hi All. I know that you can see the datasource names and the servers they are pointing to in cfadmin. But, is there another way to find the list of datasources and the servers they point to? Also, even in cfadmin, we can just see the datasource name, but until we don't click on the the datsource name link, we don't know the server it is pointing to. All we know is if it is a MS Access Driver datasource or a SQL Server datasource etc. So, if there is another way to look at the datasources, that would be nice. Thanks All __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ 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: XML question
I have a funny feeling Rey knows all about wddx already ;-) It's openwddx.org now though. jon - Original Message - From: Tim Stadinski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 6:46 PM Subject: RE: XML question wddx is just another form of an xml document. you can reference the dtd for wddx here: http://www.wddx.org i am not sure of your question though, they are two different sets of technologies that have XML in common. cheers, Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:40 PM To: CF-Talk Subject: Re: XML question Andres, Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX functionality is built into CF and there are defined tags for using it. HTH. Rey... __ 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: .NET co-Exist with CF Server
Do you envision being it a $600 plug-in for VS .Net? -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Just as a thought to throw out there, with so many other languages porting over to .net, anyone see a ColdFusion.net in the future? Granted it's not an open language and would take an initiative by Macromedia (vs. languages such as Perl, Cobol, Python, etc. that are a bit more open). Quite frankly tho, it might be nice to be able to develop and debug ColdFusion and the CFX tags in a common environment. Everyone's thoughts? __ 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: XML question
Does anyone know of a online source with some examples of accessing WDDX packets from within a VB application? I know Forta's book has one example of this and the SDK for WDDX has a little bit, but that is about all I have been able to find. Like how it is www.openwddx.org now but the SDK points to www.wddx.org still, sure does instill confidence in me. ;) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 6:32 PM Subject: Re: XML question I have a funny feeling Rey knows all about wddx already ;-) It's openwddx.org now though. jon - Original Message - From: Tim Stadinski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 6:46 PM Subject: RE: XML question wddx is just another form of an xml document. you can reference the dtd for wddx here: http://www.wddx.org i am not sure of your question though, they are two different sets of technologies that have XML in common. cheers, Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:40 PM To: CF-Talk Subject: Re: XML question Andres, Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX functionality is built into CF and there are defined tags for using it. HTH. Rey... __ 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: SQL Server 7.0 evaluation/developer's edition
I have a book called SQL The Complete Reference that came with a CD that has an evaluation version of SQL Server 7, as well as versions of Oracle, Informix, Sybase and DB2 Osborne ISBN 0-07-211845-8 HTH Mike _ Send and receive Hotmail on your mobile device: http://mobilemsncom FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists