Re: Error Submitting Form

2012-05-31 Thread Paul Smith
>So where is your "process the form" code? > >On Thu, May 31, 2012 at 10:54 AM, Paul Smith wrote: >> Thanks! My error was in the third template in the "process code," not in the first one where I was looking. I failed to pass along the valid email (a

Re: Error Submitting Form

2012-05-31 Thread Paul Smith
>On Thu, May 31, 2012 at 10:35 AM, Paul Smith wrote: >> Any ideas? > >Yes. Test your code on Firefox. ;) > >Besides that, can you post both the form code and the code that runs >when you submit it? Without that, it's kind of hard to see where the >mistake li

Re: Error Submitting Form

2012-05-31 Thread Paul Smith
>On Thu, May 31, 2012 at 10:35 AM, Paul Smith wrote: >> Any ideas? > >Yes. Test your code on Firefox. ;) > >Besides that, can you post both the form code and the code that runs >when you submit it? Without that, it's kind of hard to see where the >mista

Error Submitting Form

2012-05-31 Thread Paul Smith
I have a simple Form with 2 fields: 1. Email address "email" 2. Password "password" If I submit a valid Email AND Password the Form works correctly. Submitting a valid Email only is supposed to send the Password to the email address. Even though the email (AND Form) is the SAME ONE that works

Re: Coldfusion Hosting

2011-09-29 Thread Paul Smith
Yesterday, hosting.com informs me they are going out of the ColdFusion hosting business. This thread has been very useful. Thank you all. I've been with ColdFusion from the VERY beginning and am too old to change now. AHPhostng.net's ColdFusion VPS for $99 looks good to me, but I wonder if the

Re: Sanitize input data for SQL

2010-11-08 Thread Paul Smith
>I need a cffunction similar to PHP's mysql_escape_string that >sanitizes input data, that is - escapes invalid code so as to prevent >SQL injection and the like. I've have been unable to trap/filter the following: www.MyWebsite.com\index.cfm?start=-1%27 to keep it from emailing me an error mes

Re: Problems with submit

2007-11-19 Thread Paul Smith
Thanks Rick, That info is really appreciated, I will check it out. Regards Paul >Hi, Paul... > >I'm not a Javascript person either, but jQuery, of >www.jQuery.com makes Javascript functionality accessible >to those of us who are "JS Challenged". > >There's a plug-in for just what you're trying

Re: Problems with submit

2007-11-18 Thread Paul Smith
Thanks for that Nick, Its just a pity I don't have a clue about Javascript, I guessed that was the answer and now JS has just become a priority to learn... Why is it when you leave education (many years ago for me) learning begins!. > You could do this with JavaScript. Create a function between

Problems with submit

2007-11-18 Thread Paul Smith
Hi Folks, Using CF8: I have a results entry form and if the user hits submit more than once the result is submitted more than once, how would I stop the user being able to submit more than once.. Yes I know a real newbie question :) Thanks for any feedback you can give.

Re: CF-Talk: Digest every hour

2005-02-01 Thread Paul Smith
n.com/cf_lists/index.cfm/method=messages&threadid=37994&forumid=4#192542 > >Quick google search turns up it is caused by MS office most lilely >frontpage or someone using office to view part of the website, maybe >excel files or word files?? No SQL injection more annoyance th

Block a Spyder / DOS Attack?

2005-01-31 Thread Paul Smith
me the opportunity to block an IP address in application.cfm on the fly. Anyone ever do anything like this? best, paul >Date: Thu, 13 Jan 2005 12:51:50 -0800 >To: [EMAIL PROTECTED] >From: Paul Smith <[EMAIL PROTECTED]> >Subject: Block a Spyder > >What do I put in robots.t

Re: CF-Talk: CFID & CFTOKEN in URL (in CF5)

2005-01-27 Thread Paul Smith
My main objective is to set cookies that expire when the visitor closes their browser. What do you suggest? Please be specific. I've been away from cfapplication a long time. best, paul At 07:01 PM 1/27/2005, you wrote: >

CFID & CFTOKEN in URL (in CF5)

2005-01-27 Thread Paul Smith
I'm re-doing a website to use Cookies to maintain state for sessions. I'm only setting cookies in the browser. I assume the coding below will delete cookies in the visitor's browser when they close it. Not interested at this time in setting any cookies on the visitor's hard drive. My applic

Re: CF-Talk: Cold Fusion and List server type software choices

2004-10-26 Thread Paul Smith
I'm pretty sure Michael uses iMS mail server software, which uses ColdFusion, etc, to do the basics. We use iMS, www.coolfusion.com , too. Pretty neat way to do mail. We developed broadcast and discussion CF list apps. (Too crude to share.) I think Cool Fusion's Free FusionMail2 (a CF app)

Re: CF-Talk: CF5 CFMAIL Problem

2004-10-23 Thread Paul Smith
ng stats from cf, via > cfexecute and for some reason the stats program was opening the files in > the spool folder, and cf was unable to delete them after sending. No stats program running. best, paul >-Original Message- >From: Paul Smith [mailto:[EMAIL PROTECTED] >S

CF5 CFMAIL Problem

2004-10-23 Thread Paul Smith
My CFMAIL is causing a problem. Somehow there are thousands of messages in the spool folder and CF has gone to 100% CPU attempting to process them. Any suggestions on what caused this and how to fix it? best, paul PS> I've already shut down CFMAIL but apparently this does not stop CF from at

Error Catching

2004-08-19 Thread Paul Smith
I'm using CF5 Thanks to a posting some years ago, I've used the following error reporting scheme for a long time: = Our apologies! An internal error occured on our web server. Our error catcher has reported it to the webmaster.  We'll fix it as soon as we ca

RE: Securing CFFILE (was OOP, Custom Tags..)

2003-01-31 Thread paul smith
That's another question. What is the list of vulnerabilities CFFILE exposes? best, paul At 03:43 PM 1/31/03 -0500, you wrote: > > Is a CFAS 5 solution securing CFFILE possible only > > with Sandbox? > >Yes, if by securing it you mean allowing people to use it only within their >own directories o

Securing CFFILE (was OOP, Custom Tags..)

2003-01-31 Thread paul smith
Hmmm..., Dave, I spent a few hours yesterday with Google, Macromedia, et al, looking for docs on how to secure CFAS 5 against CFFILE you alluded to in an earlier post (where you noted it was easier to do with CFMX) and all I could find was Sandbox, and a $1200 app from Macromedia's dev tags. Is

Re: SOT: Serv-U?

2003-01-30 Thread paul smith
If all server software was as trouble-free and did its job as well as Serv-U this would be a much different business.and we'd be much happier campers best, paul At 11:14 PM 1/30/03 -0800, you wrote: >Hi Rick, > >I learned of Serv-U back when I was on shared hosts. All of my ISPs used >it,

RE: SOT: Serv-U?

2003-01-30 Thread paul smith
LC >www.bluechromedesign.com >312.593.4260 :office >877.433.8427 :pager >312.873.4033 :fax > >Yep, we have RH & CFMX Hosting, too. Feel free to ask about it. > > > -Original Message- > > From: paul smith [mailto:[EMAIL PROTECTED]] > > Sent: Friday, Jan

Re: SOT: Serv-U?

2003-01-30 Thread paul smith
Serv-U is the hands-down standard FTP Server used by MANY ISPs. Rock-solid. No trouble to administer. Have used it here for many years. Would not even consider any other product. best, paul At 11:06 PM 1/30/03 -0600, you wrote: >In Windows2k Server, setting up multiple FTP accounts require you

RE: Screening files before CFFile upload: Follow-up

2003-01-30 Thread paul smith
OK. So on CF5, what needs to be done to "properly secure a CF server" - against the evils of CFFILE, or anything else? best, paul At 11:55 AM 1/30/03 -0500, you wrote: > > Yes true, on properly configured CF server, which as > > you know Dave, are not very common :-) > >Yes, which is why I fee

RE: Screening files before CFFile upload: Follow-up

2003-01-30 Thread paul smith
O! That's handy ;-) At 03:35 PM 1/30/03 +, you wrote: >becuase you can do this > > > > >WG > > > -Original Message- > > From: paul smith [mailto:[EMAIL PROTECTED]] > > Sent: 30 January 2003 15:13 > > To: CF-Talk > > Subj

RE: Screening files before CFFile upload: Follow-up

2003-01-30 Thread paul smith
Since file upload is part of the http protocol why is CFFILE considered such a security risk? best, paul At 02:24 PM 1/30/03 +, you wrote: >Hi, > > > Follow-up yesterday's thread of trying to screen files before > > uploading with > > cffile: > >I didn't comment on this tread yesterday..so.

Re: CFQuery Retrieval of cached query failed

2003-01-27 Thread paul smith
I've seen it, too. On CF5. Not as often as you are. best, paul At 04:17 PM 1/27/03 -0500, you wrote: > On CF5, I'm getting this error on random pages at random times. The > queries have nothing in common other than they connect to the same > datasource. > However I am starting to get i

Re: CF & Database Options

2003-01-23 Thread paul smith
At 08:11 PM 1/23/03 +0100, you wrote: > >>- you could use multiple logins to the database, a readonly login and a > normal > >>one for instance > > > > Tell me more. > >Define more as 1 login. Use the readonly login from all the public >templates, and the one with full access from an administrativ

Re: CF & Database Options

2003-01-23 Thread paul smith
At 12:21 PM 1/23/03 +0100, you wrote: >Quoting paul smith <[EMAIL PROTECTED]>: > > > > For some time, I have run the main listing database at > > www.SMARTERyellowpages.com as read-only, being more than a little paranoid > > about it. Obviously, this means the q

Re: Query How-To

2003-01-22 Thread paul smith
Remove the parens around t.employeeid ? DISTINCT applies to ALL columns requested, not just one. So DISTINCT can work correctly and return duplicate t.employeeid's (if there are dups in the data). To get DISTINCT t.employeeid's, you'll have to run this query first: SELECT DISTINCT t.employeeid

CF & Database Options

2003-01-22 Thread paul smith
For some time, I have run the main listing database at www.SMARTERyellowpages.com as read-only, being more than a little paranoid about it. Obviously, this means the queries are read only. But this complicates updating the database, which I do every 24 hours. Since so many queries are cached,

Re: XML Primer Request (basic)

2003-01-19 Thread paul smith
I understand CFMX makes it possible for syndication where only Flash is needed on the client end (which 95+% browsers have?) to parse xml. Is this described somewhere? best, paul PS> It looks like openwddx.org pretty much died. What happened? CFMX? At 11:15 AM 1/19/03 -0500, you wrote: >I'

Re: Next N" Navigation and query caching theory question

2003-01-17 Thread paul smith
Interesting. That's basically what I do at SMARTERyellowpages.com for full-text queries, except I store the list of primary keys in a cached query. For example, using "office" as a search term in www.SMARTERyellowpages.com I find 1941 Listings that I can page thru 50 at a time. For drill-dow

Re: Next N" Navigation and query caching theory question

2003-01-17 Thread paul smith
As I understand your case, this is where cached queries really shine. I have all kind of 50 results per page at www.SMARTERyellowpages.com where cached queries do the job. My understanding from below is that your users select parameters from each of a couple of dozen columns. So each user wi

RE: ColdFusion, WDDX, and Flash

2003-01-16 Thread paul smith
Sounds like WDDX serializing to js on ColdFusion server and js on the client would be fast for data syndication. best, paul At 08:37 PM 1/16/03 -0500, you wrote: >WDDX serialize is very fast when serializing to JavaScript--but I've >never seen that done for Flash integration, only for JavaScrip

RE: ColdFusion, WDDX, and Flash

2003-01-16 Thread paul smith
mpared to other XML schemas. > >If you're using MX, then you should use Remoting. If you're not using >MX, you should seriously consider upgrading. > > > -Original Message- > > From: paul smith [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 1

RE: Definition of a cached query

2003-01-16 Thread paul smith
ave received this e-mail in error please delete it immediately and >advise us by return e-mail to [EMAIL PROTECTED] >******** >* > > >-Original Message- >From: paul smith [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 16, 2003 4:57 PM >To: CF-Talk >Subject: Re: Defi

RE: Macromedia TechNote on Database Performance

2003-01-16 Thread paul smith
QUERY="MyQuery#ID#" best, paul At 05:04 PM 1/16/03 -0500, you wrote: >I'm having luck just changing some queries to Stored Proceedures ... I'd >like to use caching, but I can't figure out a way to specify dynamic >query names.

Re: Definition of a cached query

2003-01-16 Thread paul smith
At 04:18 PM 1/16/03 -0500, you wrote: >Could someone point me to what exactly is a cached query. It's kind of what it says. The record set is stored in memory for the specified time. As long as it hasn't expired, subsequent requests are pulled from memory. On SMARTERyellowpages.com for example

RE: Visual Fusion - Thoughts?

2003-01-16 Thread paul smith
Last year I decided to charge more than my auto mechanic charges me, and for ColdFusion I now charge $90/hour ($1 more than my mechanic :) Someone on this list, or perhaps the FuseBox list, said their rule of thumb was that you should charge $15/hour for every $10,000 you wanted to make each ye

Re: Query Caching Question

2003-01-16 Thread paul smith
I'm not sure I understand your circumstances, but if one user has siteID=20 and another one has siteID=123, the query below will cache 2 record sets. Happens all the time at www.SMARTERyellowpages.com (MANY cached queries there) best, paul At 01:24 PM 1/16/03 -0500, you wrote: >Ok, I've been r

ColdFusion, WDDX, and Flash

2003-01-16 Thread paul smith
Any advantage to using Flash with WDDX for data syndication? For example, when a user makes a data request to a remote machine, which is passed via WDDX to the central machine where the data resides, would a Flash implementation require the user to download a Flash/WDDX/etc module? best, paul

Re: Can Coldfusion & Verity be this clever ???

2003-01-16 Thread paul smith
hing like ... > >Title : þÿ >Summary: First so many characters of the document >Relavance : 84% > >So by using these two fields from the table the descriptions would be much >more user friendly > > >- Original Message - >From: "paul smith" <

Re: building date list

2003-01-15 Thread paul smith
Would this do it? SELECT TOP 1 pub_date ORDER BY pub_date ASC SELECT TOP 1 pub_date ORDER BY pub_date DESC best, paul At 09:14 AM 1/15/03 -0800, you wrote: >I have a query that returns all of the publication dates of stories in a >database. Currently, it returns 18,000 rows. Eventually, ther

Re: Can Coldfusion & Verity be this clever ???

2003-01-15 Thread paul smith
Why would you want to use Verity to search the docs AND the doc summary in a DB? (2 queries) Wouldn't Verity's search of the docs give you all relevant search results? (1 query). best, paul At 03:47 PM 1/15/03 +, you wrote: >Hi > >I am trying to complete the below with verity and would li

Re: WOT: MySQL in the Enterprise

2003-01-15 Thread paul smith
In M$ SQL7, how do you complete the following: RESTORE DATABASE MainBiz2 FROM DISK = 'd:\mssql7\backup\MainBiz\MainBiz_db_200301130102.BAK' WITH RECOVERY, MOVE 'MainBiz2.mdf' TO 'd:\mssql7\data\MainBiz2.mdf', MOVE 'MainBiz2.ldf' TO 'd:\mssql7\data\MainBiz2.ldf' where I

RE: web beacons

2003-01-13 Thread paul smith
You don't even have to view the mail if the gif is near/at the top and the user has something like Eudora's "message preview pane" set. (But then again, how many of the target demographics have even heard of Eudora ;-) OTOH, for legit opt-in mail, the message preview pane can also give a false

SQL7 DB Update Procedure

2003-01-13 Thread paul smith
The on-line database of listings, etc, at www.SMARTERYellowpages.com , Biz1, is read-only in normal operation. The off-line database, Biz2, is not read-only in normal operation, and it is currently updated daily on a backup machine, including automatic backup, and updating of full-text indexes

Re: Email Quandry

2003-01-08 Thread paul smith
Anyone here not familiar with iMS should take a look as it is virtually infinitely configurable using ColdFusion (as well as others). best, paul At 12:47 AM 1/9/03 -0500, you wrote: >I know you mentioned that this is a freebie on your part. If this is a >temporary thing then you can get a 60-

RE: Shopping Cart Under $500 bux?

2003-01-08 Thread paul smith
I'll second that. You can develop the entire website in it, too. Not just the store. See www.CDrollout.com for example. best, paul At 12:05 PM 1/8/03 -0500, you wrote: >http://www.cfwebstore.com/store/index.cfm > >CFWebStore is great ... Very customizable and easy to use. Good support >and yo

RE: OT: HTML Question

2003-01-07 Thread paul smith
I started doing it after looking at Yahoo! source (Amazon, too) best, paul At 03:31 PM 1/7/03 -0800, you wrote: >I hate it when people do not put in those quotes > > >Robert Bailey >[EMAIL PROTECTED] >"Famous for nothing!" >http://www.tinetics.com > > > > >-Original Message- >From: Dave

RE: OT: HTML Question

2003-01-07 Thread paul smith
Yep. Escaped them, too. Even with quotes. No help. best, paul At 02:48 PM 1/7/03 -0500, you wrote: >Did you try using #s for your colors? If they are inside of a >, you will need to escape them like so; bgcolor=##b4d0dc. I >seem to recall having this issue before and doing this solved my >pro

RE: OT: HTML Question

2003-01-07 Thread paul smith
think that >only had to do with style sheets) > >Good luck, xhtml man :) >Rob > >-Original Message- >From: paul smith [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 07, 2003 10:36 AM >To: CF-Talk >Subject: RE: OT: HTML Question > > >Thank you for

RE: OT: HTML Question

2003-01-07 Thread paul smith
27;t feel quotes are needed (where > > they are not needed ;-). > >Well Musciano & Kennedy are wrong. And you should burn that book as that is >the old way of thinking and it makes your pages dated - in the past. > >lookup xhtml and try to follow that, if you give a hoot about yo

Re: OT: HTML Question

2003-01-07 Thread paul smith
As I mentioned before, I had already tried quoting. I just now added hash marks. No change. So whether or not they are needed, the absence of quotes or hash marks is not why Netscape 4.79 is being stubborn best, paul At 05:56 PM 1/7/03 +0100, you wrote: >paul smith wrote: >

Re: OT: HTML Question

2003-01-07 Thread paul smith
Nope. Tried that. Besides, check out the bible, "HTML The Definitive Guide" by Musciano & Kennedy. They don't feel quotes are needed (where they are not needed ;-). best, paul At 05:07 PM 1/7/03 +0100, you wrote: > > >You need a lot of quotes around tag attributes there. ~~

Re: OT: HTML Question

2003-01-07 Thread paul smith
At 10:46 AM 1/7/03 +0100, you wrote: >Did you try http://validator.w3.org Yes. It refused to check an html-only version of the following (something about character set). With "border=1" replaced by "border=0" in the following, Netscape 4.79 does not display the following - IE 5.50 does. best,

Re: OT: HTML Question

2003-01-07 Thread paul smith
At 10:46 AM 1/7/03 +0100, you wrote: >paul smith wrote: > > Page displays fine in IE > > > > Page does not display in Netscape unless I put TABLE border > 0 > > > > Tables are involved, but no missing TABLE/TR/TD tags. > >Did you try http://validat

RE: HTML Question

2003-01-06 Thread paul smith
I don't use Netscrape that much, but I do find Netscrape 4.79 loads pages almost twice as fast as Internet Exploader 5.50, and Netscrape starts up 5 to 10 times as fast. best, paul At 09:17 PM 1/6/03 -0500, you wrote: >Microsoft says "Netscape Bad"

OT: HTML Question

2003-01-06 Thread paul smith
Page displays fine in IE Page does not display in Netscape unless I put TABLE border > 0 Tables are involved, but no missing TABLE/TR/TD tags. Suggestions? best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.c

RE: Retaining formatting in form fields

2003-01-06 Thread paul smith
A la a practice used in the open-source forum discussed here recently, I wonder if including HTML with "[" instead of "<" and "]" instead of ">" in the form, and then a Replace of "[" with "<" and "]" with ">" on the backend would help. best, paul At 02:44 PM 1/6/03 -0400, you wrote: >At 01:3

Re: cftry cftransaction across multiple includes

2003-01-03 Thread paul smith
I would put the CFTRANSACTION before the first CFINCLUDE and /CFTRANSACTION after the last CFINCLUDE (in other words, at the level of the CASE statement) You can also do it with the database instead of ColdFusion, for example in M$ SQL: SET NOCOUNT ON BEGIN TRANSACTION UPDATE AWads SET AdImpre

RE: CFAS5 Problem

2003-01-02 Thread paul smith
iginal Message- >From: Robert Bailey [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 02, 2003 2:01 PM >To: CF-Talk >Subject: RE: CFAS5 Problem > >I had this problem before, there is something in the registry that I can >not find, check the Macromedia forums, that is wher

CFAS5 Problem

2003-01-02 Thread paul smith
In the Security part of CF Admin, I unchecked/disabled the CFREGISTRY tag. Now I cannot get into CF Admin! Suggestions? best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://ww

Re: Cold Fusion forum

2002-12-24 Thread paul smith
;-) At 09:57 PM 12/23/02 -0600, you wrote: >It uses Fusebox, but you might be able to get something useful out of >it. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion

Re: CFQUERYPARAM and Lists

2002-12-22 Thread paul smith
And add ()? WHERE ticketID IN () best, paul At 10:36 PM 12/22/02 +0100, you wrote: >Quoting Cedric Villat <[EMAIL PROTECTED]>: > > > > > username="#request.dbuser#" password="#request.dbpass#"> > > UPDATE Tickets > > SET folder = > value="#getEscalationInfo.eFolder#">, > > dateUpdate

RE: Strange CFAS 5 Error

2002-12-18 Thread paul smith
> Looks like somehow you've accidentally set variables.start > > to "51Please" > > instead of 51 -- you know that CF will assign values even > > if you don't ask > > nicely, right? :-P > > > > > --Ben Doom > > Programmer &

RE: Strange CFAS 5 Error

2002-12-18 Thread paul smith
#x27;t ask >nicely, right? :-P > > > > --Ben Doom > Programmer & General Lackey > Moonbow Software > >: -Original Message- >: From: paul smith [mailto:[EMAIL PROTECTED]] >: Sent: Wednesday, December 18, 2002 1:17 PM >: To: CF-Talk >: Su

RE: OT: AOL?

2002-12-18 Thread paul smith
I set Max Recpt = 1 At 01:15 PM 12/18/02 -0500, you wrote: >No good This sucks... MY clients are starting to notice this >too. Weird thing is the mail just disappears... No bounce back or >anything like that... That's the "AOL way" best, paul >KP > >-Original Message- >From:

Strange CFAS 5 Error

2002-12-18 Thread paul smith
Why would: #VARIABLES.start# #REQUEST.LISTINGS.MAXROWS# Where Variables.start=51 and request.listings.maxrows=50 throw this error: An error occurred while evaluating the expression: variables.end = variables.start + request.listings.maxrows - 1 Error near line 16, co

RE: Random SQL statement

2002-12-18 Thread paul smith
I think you can modify the following to do what you want. #RandHint.Hints# best, paul At 12:15 PM 12/18/02 -0500, you wrote: >This link goes into this in depth. > >http://www.aspalliance.com/stevesmith/articles/randomselect.asp > >~Jason > >-Original Message- >From: Chad [mailto:[EMAIL

SQL7 Full-Text (was RE: mySQL & CF)

2002-12-16 Thread paul smith
600, you wrote: >hehe... maybe - can you post some of your code? How are your catalogs built >and how often? > >-Mark > >-Original Message- >From: paul smith [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 16, 2002 8:10 PM >To: CF-Talk >Subject: RE: mySQL &a

RE: mySQL & CF

2002-12-16 Thread paul smith
Thanks! CFQUERYPARAM enabled me to reduce that pesky overhead using client vars in a database to maintain state from 32ms to 16ms. Anything up your sleeve to reduce my SQL7 1,000ms-2,000ms full-text searches by 50% ? best, paul At 11:52 AM 12/16/02 -0600, you wrote: >While it's true that

Re: Verity vs. SQL Server 2000 Full-Text

2002-12-16 Thread paul smith
d forms, such as derivational, soundex, and thesaurus." best, paul At 11:46 PM 12/16/02 +0100, you wrote: >paul smith wrote: > > >Please define "way more intelligent" I'm not disputing your assertion. I > >just want to better understand the features you are refe

Re: Verity vs. SQL Server 2000 Full-Text

2002-12-16 Thread paul smith
Please define "way more intelligent" I'm not disputing your assertion. I just want to better understand the features you are referring to. best, paul At 10:42 AM 12/16/02 +0100, you wrote: >Matt Kornguth wrote: > > Would love to hear people's feelings and relative > > advantages/disadvantages

RE: For the gurus: Question about state management with CLIENT sc ope

2002-12-15 Thread paul smith
Well guys, looking at the numbers in my app, I see I could reduce the 31ms spent maintaining state using client variables if I used session variables instead, but I would be much happier if I could reduce the 1625ms spent doing a full-text search using SQL7 by 10%. best, paul At 09:55 PM 12/1

RE: For the gurus: Question about state management with CLIENT sc ope

2002-12-14 Thread paul smith
Sorry, Dave. I guess I wasn't clear enuf. The original had "...it's intended..." referring to client scope. My comment about "practicality" referred to client scope not to session scope. I was simply pointing out that it can be practical to use client scope. I did not mean to imply session

RE: For the gurus: Question about state management with CLIENT sc ope

2002-12-14 Thread paul smith
It's intent is one thing. It's practicality is another. I never use session scope to maintain state. I use client scope and store client variables in a database. I let the database worry about what it is good at - locking, so I don't have to worry about it. best, paul At 04:54 PM 12/12/02

RE: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread paul smith
In my experience with storing recordsets in cached structures, subsequent reading records from the structure was slower than reading the same records from a cached query. Is this expected behavior, or did I screw up? (first time again) best, paul At 04:29 PM 12/13/02 -0500, you wrote: > > On

Re: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread paul smith
er. > >Thanks again. > >On 12/13/2002 1:21 PM, paul smith <[EMAIL PROTECTED]> wrote: > >SQL7/2000 allows combination of full-text searches and standard SQL > >in the > >same query. > > > >With Verity I find I often need a query to find the list of IDs tha

RE: Session Variables (was Login/Password screen)

2002-12-13 Thread paul smith
??? How about using the URL to maintain state? The big advantages of cookies is to simplify/eliminate subsequent logins / and simplify coding. Forta's books have forever shown how to test to see if user allows cookies and if not pass state in URL. best, paul At 09:20 AM 12/13/02 -0800, you wr

Re: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread paul smith
SQL7/2000 allows combination of full-text searches and standard SQL in the same query. With Verity I find I often need a query to find the list of IDs that match the search text, and then a second query to match the standard SQL constraints. Not that important if your app is not heavily loaded.

RE: Prev 1 2 3 ... Next

2002-12-12 Thread paul smith
k_num#< >/a>  > > > > >-Original Message- >From: paul smith [mailto:[EMAIL PROTECTED]] >Sent: Thursday, December 12, 2002 7:32 AM >To: CF-Talk >Subject: Prev 1 2 3 ... Next > > >Google resul

Prev 1 2 3 ... Next

2002-12-12 Thread paul smith
Google results offer links like the subject. Given RecordCount from a query, is there a tag to create links like the subject? Or a script? best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subs

RE: retrieval of cached query failed (was: CFSET in CFMX)

2002-12-08 Thread paul smith
Thanks, Dave. Now I understand what happened. Most likely, this happened while another (non-CF) application was running away and stealing all the CPU it could. best, paul At 02:27 PM 12/8/02 -0500, you wrote: > > It's funny you should bring caching up, Dave. What do you > > make of this er

RE: CFSET in CFMX

2002-12-08 Thread paul smith
It's funny you should bring caching up, Dave. What do you make of this error message? Retrieval of cached query failed The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:1) to (74:175) in the template file C:\WEBSITE\HTDOCS\SM

AbleCommerce

2002-12-06 Thread paul smith
The Readiness Operation Inc owns a license for an unlimited store version of AbleCommerce (which licenses are no longer available). I'm considering selling The Readiness Operation Inc, which has the ABC license as one of its assets. I don't believe such a sale violates the terms of the ABC lice

RE: MX Hosting

2002-12-05 Thread paul smith
Define "dirt cheap" best, paul At 07:17 PM 12/5/02 -0600, you wrote: >You know, I'd love to find a great place to let me host a dedicated NT >Server dirt cheap. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forum

Re: CFX_Excel Tag not working with CF 5.0

2001-06-19 Thread Paul Smith
What does the CFX_Excel tag allow you to do? Does it help you import an Excel spreadsheet into SQL? best, paul At 01:21 AM 6/17/01 -0400, you wrote: >Dave, >That did it! >I deleted the tag and removed the "registration". Downloaded a fresh tag >and installed and registered it. Restarted CF5.

Re: ColdFusion Server 5 Performance Brief Updated

2001-06-17 Thread Paul Smith
Just what the world needs -- another annoying website. What the hell is this "a message is waiting for you" pop up crap. Has Macrame jumped on the spam wagon? best, paul At 09:28 PM 6/16/01 -0600, you wrote: > > http://www.macromedia.com/software/coldfusion/resources/ > > (click "Performanc

RE: Coding Standards.....

2001-06-15 Thread Paul Smith
Yes. I can confirm that Dave is a closet Fuseboxer. Sorry to out you, Dave, but I saw it myself when I met you at Allaire's conference last year. Chin up. Things could be worse. Now you can feel free to publicly expose your wisdom on Fusebox topics. This should take a lot of stress off yo

Re: Cached Query

2001-06-14 Thread Paul Smith
If it's cached you don't need to put it in Application scope (and probably don't want to). I put mine in Request scope, but I'm not sure I need to. best, paul At 02:52 PM 6/14/01 -0400, you wrote: >Is a cached query always within the application scope? Or do I need to add >"Application." before

Re: Comparing value against a list of values

2001-06-13 Thread Paul Smith
Which database? SQL7 doesn't appear to have this problem. best, paul At 07:30 PM 6/13/01 -0500, you wrote: >I had the same situation with about 200,000 record table. Of course the >first identity >number was 1 thru something like 400,000(after deletions):o)) >The query was something like: >sel

RE: Comparing value against a list of values

2001-06-13 Thread Paul Smith
alized table and move the contents to a new, normalized >table with a single record for each. Is there a good way to do this? > >Regards, >Paul Sinclair > > > > -Original Message- > > From: Paul Smith [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 1

Re: Verity & SQL

2001-06-13 Thread Paul Smith
Assuming we're talking about searching a database here, what I did (before I went to SQL Server Full Text) was to perform the Verity search to find a list of IDs whose records matched the Verity Search query, and then perform a standard SQL search, a la: to match the SQL requirements. It wa

RE: Verity & SQL

2001-06-13 Thread Paul Smith
This is one of the reasons I went to SQL Server 7 full text search. It's easy and faster to combine full text search with standard SQL. best, paul At 11:19 AM 6/13/01 -0400, you wrote: > > Is there any way to combine the results of a CFSEARCH and a > > standard SQL search into the same CFOUTPUT

RE: Comparing value against a list of values

2001-06-13 Thread Paul Smith
Since the list is in a column in the database table, the IN below won't work. I believe you'll have to normalize your table, or better create another table. In the latter case, for example, assuming the list 10,11,21,100 is in a row with ID = 89, the new table for these data would be: 89 10

Re: What is this?

2001-06-12 Thread Paul Smith
in.close(); > } > catch (MalformedURLException e) {System.out.println(e);} > catch (IOException e) {System.out.println(e);} > } >} > > >Nick Texidor wrote: > > >Could be the Java Browser from Sun.. HotJava I think it's

What is this?

2001-06-11 Thread Paul Smith
cgi.http_user_agent Java1.3.0 What is Java1.3.0? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Uns

Re: Re: Login Management

2001-06-08 Thread Paul Smith
You're right, it does look interesting. But I kept getting JS errors. best, paul At 04:18 PM 6/7/01 -0700, you wrote: >WOW!!! That is one outstanding web application Bryan!! Have bookmarked >your site as I may be purchasing one or more of your products for my >"side-line" consulting biz. In

Re: database structure

2001-06-07 Thread Paul Smith
Why Sales_Cat_ID? best, paul At 02:01 PM 6/7/01 -0500, you wrote: >Go with #1, but make it 4 tables. the fourth being the relationship table >(we'll call it Sales_Cat), that has the salespersonID, the StateID, and the >categoryID, and for good measure, a Sales_Cat_ID. ~~~

  1   2   3   4   5   6   7   8   >