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://mobile.msn.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 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 - - 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: .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
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: Any other way to look at datasources?
Well, if you access to use , you can look at the datasources entered through the ColdFusion Administrator: 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: 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: 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 -83F300508B94F85A&method=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... > > > > > > > services = 'PACKAGE'; > APIstr = 'IntlRate'; > XMLstr = ' PASSWORD="#attributes.password#">'; > > XMLstr = XMLstr & ' > 0 > 1 > Package > #Attributes.country# > '; > XMLstr = XMLstr & ''; > > > > URL="#attributes.server#?API=#APIstr#&XML=#urlencodedformat(XMLstr)#" > method="GET" resolveurl="false" timeout="45"> > > > action="XML2CF" >input="#xmlResp#" >output="countryData" >type="Variables" > > > > > > 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! > > > > > > > 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: 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: mySession = structnew(); mySession = duplicate(session); 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! An Error Occurred In Cold Fusion. User Info: #form.UserInput# System info: #form.debuginfo# Oops, an error has occurredPlease provide us info and click SUBMIT. Debugging Info (Appdev Only): visibility: hidden"> Browser:#Error.Browser# Remote Address: #Error.RemoteAddress# Error:#Error.Diagnostics# Template: #Error.Template# Query String: #Error.QueryString# Variables: SESSION.#myVar##evaluate("session." & "#myvar#")# FORM.#myVar2##evaluate("form." & "#myvar2#")# -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: 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=11714&Method=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 Panel>ODBC 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: Attaching CSS style sheet
I think you also need a 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: > > > > Title >type="text/css"> > > > .. > > > > Them, in your styles.cfm page, you could have: > > > > > > > > ... 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: 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! An Error Occurred In Cold Fusion. User Info: #form.UserInput# System info: #form.debuginfo# Oops, an error has occurredPlease provide us info and click SUBMIT. Debugging Info (Appdev Only): visibility: hidden"> Browser:#Error.Browser# Remote Address: #Error.RemoteAddress# Error:#Error.Diagnostics# Template: #Error.Template# Query String: #Error.QueryString# Variables: SESSION.#myVar##evaluate("session." & "#myvar#")# FORM.#myVar2##evaluate("form." & "#myvar2#")# -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: 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: 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 Panel>ODBC 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: > > > > to: > > > > > > > > - 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: > > | > > | > > | > > | > > | 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... > > | > > > | > > > | > > > | > > > | > > > | > > > | > > > | > > > | > > > | > first variable: #show# > > | > variable's variable: #evaluate('#show#')# > > | > > > | > > > | > > > | > > > | > > > | > > _ > _ > > 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?
Control Panel>ODBC 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: 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
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://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
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://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
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: > > to: > > > > - 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: > | > | > | > | > | 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... > | > > | > > | > > | > > | > > | > > | > > | > > | > > | > first variable: #show# > | > variable's variable: #evaluate('#show#')# > | > > | > > | > > | > > | > > | > _ _ > 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: Attaching CSS style sheet
> If you are trying to dynamically assign a style sheet for > each page, you could do the following: > > > > Title >type="text/css"> > > > .. > > > > Them, in your styles.cfm page, you could have: > > > > > > > > ... 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 __ 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?
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: > > > > > 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... > > > > > > > > > > > > > > > > > > > > first variable: #show# > > variable's variable: #evaluate('#show#')# > > > > > > > > > > > _ _ > 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: assigning a value to a dynamic variable?
Actually, there is a shorthand for this: change: to: - 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: | | | | | 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... | > | > | > | > | > | > | > | > | > | > first variable: #show# | > variable's variable: #evaluate('#show#')# | > | > | > | > | > | __ 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: 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: > | > > | > > | > > | > 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. > > So wouldn't it be simple then to assign a var from the > application.cfm file to the "HREF=" name? > > I.e., > > HREF="#varfromapplicationfile#"> Yes, that would work fine. 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: assigning a value to a dynamic variable?
To set a dynamic variable, use setVariable: 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... > > > > > > > > > > first variable: #show# > variable's variable: #evaluate('#show#')# > > > > > __ 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: Title .. Them, in your styles.cfm page, you could have: body { font-family: Verdana; font-size: 11px; } input { font-family: Arial; font-size: 12px; color: #33; } ... 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) 2) 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
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... first variable: #show# variable's variable: #evaluate('#show#')# __ 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
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
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
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., | -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: | > | > | > | > 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: 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: >> >> >> >>select id from table_1 >>insert into table_2(table_1_id)values(the_id_ just queried) >> >> >> >>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: 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 > application.cfm file? I have done this on several websites > and never seen a problem before. > > Here's the code I use: > > > > 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 __ 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: 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 > it"and 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: 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 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 of the page also. > > > > > > But if you really need it in your application.cfm, you could try > > something like this: > > > > > 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) > > 2) > > > > 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: 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 > it"and 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
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 it"and 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: 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 PII
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
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: 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: 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: select id from table_1 insert into table_2(table_1_id)values(the_id_ just queried) 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
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
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 __ 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?
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: What are these, headers?
Matthew, Yes, a lot of code is being generated (as Jochem pointed out, 2MB). > > What code is run before > > > > 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 > > > > > > > > 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: 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: > > > > select id from table_1 > insert into table_2(table_1_id)values(the_id_ just queried) > > > > 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
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: select id from table_1 insert into table_2(table_1_id)values(the_id_ just queried) 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: 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
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 it"and 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: 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
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
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 Error Unknown Data Access Error. "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 Error Unknown Data Access Error.The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (33:3) to (33:50).Date/Time: 03/01/02 11:07:21Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)Remote Address: 65.208.124.109HTTP Referrer: http://shop.hitmenow.com/affiliates/p-update.cfm" 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
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
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. 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://www.cfugorama.com/cfugorama/codelibrary/loader.cfm?url=/commonspot/se curity/getfile.cfm&PageID=1727 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: 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. 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. . 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 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/imagename.jpg 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 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 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 > __ 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: Image directory flow
Tim, In you application.cfm page set a variable to the base reference and then use it in you pages. Example: http://rootdomain.com/> Then when calling the graphics in your header and footer includes: 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 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: 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: 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=3&tag=ex.cn.1.srch.cnet&q=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?
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: 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://mysecretbase.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
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 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: 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: 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?
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: 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: 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: 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 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 ? > > > > 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
> 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... 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://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: 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 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 ? > > 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
Verity Issue - Returning Incorrect Results?
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
drivers
Hi, I know ColdFusion 5 comes with the 3.6 Merant ODBC drivers, if I install the 4.0 set of drivers will it be supported by ColdFusion? TIA, Deb _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
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
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
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
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 4.5.1 to 5.0 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://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 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
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
> > 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://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
Uploading file directly into SQL database
Hi, I want to insert an uploaded file directly into a SQL database field. So after the user has uploaded the file to our CF server, at some point later (probably overnight), we can move this file to store it directly in the db. I have no idea how to make a start on this (the file's already uploaded to the server), it's just the overnight routine I can't work out. Does anyone have any help for me thanks Alex __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 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: 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?]
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 #Queryname.Deleted# > __ 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: 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? > > > > > > SELECT TOP 2000 Product_id > > FROM Products > > ORDER BY Product_id > > > > > > > > > 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"> > > > > > __ 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