RE: brain fart: some simple SQL

2001-11-29 Thread Fiona
Have a look at Hal Helms' May newsletter: http://www.halhelms.com/index.cfm?fuseaction=newsletters.may2001 (The Return of Mr SQL :-)) -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 06:20 To: CF-Talk Subject: brain fart: some simple SQL

Equivalent of cfdirectory and cffile for client side programming

2001-11-29 Thread John McCosker
I'm scanning the Javascript Bible here, and the web, but can't get the right resource in order to leverage what I need to do. I'd basically like the user to interface with their own drives, list directories, read files, i.e text/xml/csv etc using the browser and JS, from a website. Can

REPOST - cfquery timeout attribute

2001-11-29 Thread Carlisle, Eric
We had an Oracle listener hang. This caused big problems in ColdFusion. The timeout attribute just didn't seem to work. I posted this here before and it was suggested that the timeout clock doesn't start until the SQL is sent. Since the listener was hung, I'm not sure how far CF went

Re: REPOST - cfquery timeout attribute

2001-11-29 Thread Dave Hannum
Use CFTRY/CFCATCH around your queries and do a little custom error handling. It goes a LONG way! Dave - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:04 AM Subject: REPOST - cfquery timeout attribute We had

RE: REPOST - cfquery timeout attribute

2001-11-29 Thread Carlisle, Eric
Every query I do is nested in a try/catch. To bad I can't timeout a try/catch block. :/ Thanks :) EC -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 8:17 AM To: CF-Talk Subject: Re: REPOST - cfquery timeout attribute Use

RE: Equivalent of cfdirectory and cffile for client side programming

2001-11-29 Thread Raymond Camden
I don't know about IE, but I know signed JavaScript can do this in Netscape. Although the last time I worked w/ signed JS in Netscape, it was a nightmare. No, most nightmares are a walk in the park, a nice walk on a sunny day, compared to the hell I went through to get signed JS working. (The

RE: CFSCRIPT v CFIF

2001-11-29 Thread Raymond Camden
I assume you mean the if statement in cfscript, not cfscript itself. To be honest, I seriously doubt you will find a difference that will be significant in anything you do. My recommendation is to use what you feel comfortable with. If a code block in cfscript is easier for you to work with,

Re: REPOST - cfquery timeout attribute

2001-11-29 Thread Dave Hannum
Whenever I have an Oracle listner problem, try/catch always catches it. Are you sure it was a listner crash? Dave - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:18 AM Subject: RE: REPOST - cfquery timeout

RE: Show Running Requests Redux

2001-11-29 Thread cf refactoring
To expand on what Max said: In application.cfm 1) if there is no structure, create a structure in the application scope named application.requests 2) Generate a UUID for this request 3) store request info which you want to track into application.requests[UUID] 4) Store the time of request In

RE: Credit Card Validation

2001-11-29 Thread Joel Parramore
CyberCash (www.cybercash.com) used to have references on their site --- you might check there to find what you're looking for. Regards, Joel Parramore -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:03 AM To: CF-Talk Subject: Re:

RE: REPOST - cfquery timeout attribute

2001-11-29 Thread Carlisle, Eric
The listener was hanging. A Tivoli alarm would have caught it, but I think that justs checks for the presense of a process (dosn't actually try to connect to the listener). The listener process was running, just not working. (Hopefully I can get the Tivoli people to cook up a better alarm

RE: Equivalent of cfdirectory and cffile for client side programm ing

2001-11-29 Thread John McCosker
Thanks Raymond, I found a good Danny GoodMan article on this, http://developer.netscape.com/viewsource/index_frame.html?content=goodman_ss cripts.html and http://developer.netscape.com/docs/manuals/communicator/jssec/index.htm I'm going to have to way up the benefits of doing this, I know

Re: REPOST - cfquery timeout attribute

2001-11-29 Thread Dave Hannum
I'm not sure if designating your CFCATCH TYPE=Database would catch a timeout or not. Dave - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:54 AM Subject: RE: REPOST - cfquery timeout attribute The listener

maxrows question

2001-11-29 Thread Kola Oyedeji
Does anyone know if i set a maxrow value of 1 in a select query, if just one record is passed to coldfusion by the database or all matching results are returned by the database but only one is made available? Kola Oyedeji |Web Developer |ekeda elthorne gate |64 high street |pinner |middx

RE: maxrows question

2001-11-29 Thread Raymond Camden
All the records are returned by the DB. So, if you can use SQL instead of MAXROWs, it would probably be marginally better performance wise. For example, if you want the first X records, I know SQL Server lets you do: SELECT TOP 10 Foo, Goo, YourBoots FROM

RE: maxrows question

2001-11-29 Thread Mike Townend
I would assume you would get all requests back Maybe you could use the Top sql command to ensure that only one record is delt with HTH -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 14:31 To: CF-Talk Subject: maxrows question Does

RE: maxrows question

2001-11-29 Thread Simon Horwith
note that for consistency (especially across RDBMS Platforms), you should use the ORDER BY clause when using SELECT TOP blah ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036

Setting session variables using JavaScript

2001-11-29 Thread Perez, Bismark
Hello there, Is it possible to set the value of a session variable using JavaScript, the scenario is the following, I have a page that opens a window where the user can select a value from a select box, the form action is actually call to a JavaScript function that refresh the opener window

RE: maxrows question

2001-11-29 Thread Kola Oyedeji
Thanks guys I was actuall trying to work out the most efficient way to determine if a key exists in the db and then do some processing if it does, without searhing the rest of the records. I'm thinking that using Exists would be more efficient. Kola Oyedeji |Web Developer |ekeda elthorne gate

Re: maxrows question

2001-11-29 Thread Bernd VanSkiver
Is is possible to specify a starting row with SQL similar to the startrow= parameter in cfoutput? Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:36 AM

RE: Setting session variables using JavaScript

2001-11-29 Thread Raymond Camden
The only way to set a CF variable from JS is to have some kind of page reload. For example, via JavaScript, you can make the page reload while appending URL vars. So, I can make the page go from index.cfm to index.cfm?var=X, where X is some JS value. CF would then be able to look at url.var. If

RE: OT- Hosting recommendations

2001-11-29 Thread Yager, Brian T Contractor/NCCIM
Try www.advances.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:48 PM To: CF-Talk Subject: OT- Hosting recommendations I'm looking to move my smaller clients to a new hosting company, because of support issues and restrictions on

Simple Site Content Management

2001-11-29 Thread Gordon Burns
I have a need for a simple content management system. The header and footer will not be available to client but page content between these two elements will be in the main updated by client. The content enabled by client will consist of text, tables and occasional graphics. The content for

RE: OT- Hosting recommendations

2001-11-29 Thread Kelly Matthews
Yes I use them too (advances.com) and LOVE them, their prices are great and I have had NO CF or SQL problems, they even let me install custom dll tags etc... Very helpful support. Kelly -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: maxrows question

2001-11-29 Thread Steven Dworman
select 0 from table_name where column_name = '#passed_value#' or select 0 from table_name a where exists(select 0 from another_table_name b where b.column_name = a.column_name) i think either should work -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Thursday,

Re: Simple Site Content Management

2001-11-29 Thread Gary Kraeger
www.cfdev.com www.ektron.com there are some others also but those are the main two. gary - Original Message - From: Gordon Burns [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:49 AM Subject: Simple Site Content Management I have a need for a

Oracle and CF

2001-11-29 Thread Jason Dowdell
Hi all, Being a former Oracle employee I'm fairly familiar with Oracle but I've yet to use it with CF. What are some of the limitations versus SQL Server? I've heard that the Oracle drivers only return one record in a query result set at a time. Is this true. What are some of the other

OT: FTP

2001-11-29 Thread savan . thongvanh
Does anyone know how to get (recursively) all the files in a dir using ftp? when i do mget * it gets all the files in the current dir but no the subdirs. any help would be greatly appreciated. Thanks, Savan ~~ Get the mailserver that powers this

Re: (extended) maxrows question

2001-11-29 Thread Tyler Silcox
Good db question, Bernd! I've got a query that's pulling around 45k records and we are only displaying 500 records at a time; is the only way we can speed up the s.o.b. by cache-ing the query on repetitive calls to the db? There's got to be a better SQL way of doing this...(also: it has to sort

RE: FTP

2001-11-29 Thread C. Hatton Humphrey
I've only found clients that can do it and cannot find anything that natively recurses in the default FTP (aka CF or Text based) C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: client.CFID vanishes

2001-11-29 Thread Dave Watts
We sometimes get an error that client.CFID can't be found, right after we turn on client management. Anybody else ever get this? Out of curiosity, where are you storing client variables, since you don't list a repository in the CFAPPLICATION tag? If you're storing them in the registry, that

Re: Oracle and CF

2001-11-29 Thread Dave Hannum
We use Oracle here both with Native drivers and with ODBC. Works great! (mostly - some small issues) Dave - Original Message - From: Jason Dowdell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 10:39 AM Subject: Oracle and CF Hi all, Being a

Re: Simple Site Content Management

2001-11-29 Thread Dave Hannum
Isn't evolt.org working on a community one? Dave - Original Message - From: Gordon Burns [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:49 AM Subject: Simple Site Content Management I have a need for a simple content management system. The header

RE: word wrap in text area

2001-11-29 Thread Bill Killillay
You need to do a replace on #chr(10)##chr(13)# and turn them in to br that will give you the breaks your looking for. I can send some sample code if this is not enough to get you going in the right direction. -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent:

Re: OT- Hosting recommendations

2001-11-29 Thread Bryan Stevenson
take a look at WeDoHosting.com -great support -just about finished their web based admin stuff (domain and e-mail control etc.) -CF and SQL Server 2000 Oh ya and Canadian pricesas low as $9.95/month (about $6 US) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge

Re: Oracle and CF

2001-11-29 Thread Alex
What are the some small issues? On Thu, 29 Nov 2001, Dave Hannum wrote: We use Oracle here both with Native drivers and with ODBC. Works great! (mostly - some small issues) Dave - Original Message - From: Jason Dowdell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

Re: Oracle and CF

2001-11-29 Thread Dave Hannum
Well, the issues we face are more platform-centric than anything. We're running CF 5.0 on Win2000 and our Oracle 8x sits on an IBM OS/390. The issue is that with the native drivers, numeric and datefields must be set to TO_CHAR() in the SQL to output them in CF. You can add/update/delete

Re: Credit Card Validation

2001-11-29 Thread Bud
On 11/28/01, Jim McAtee penned: Can anyone point me toward an authoritative source for the algorithms used to validate credit card numbers and to identify card types based on the card number? There are numerouse code examples to be found on the web, in various languages (but with significant

SOAP Methods

2001-11-29 Thread Costas Piliotis
Hi ppl. If anyone has worked with SOAP, I'm in desperate need of some help. I have some VB Code as follows: Dim SOAPClient As SOAPClient Set SOAPClient = New SOAPClient SOAPClient.mssoapinit (http://services.xmethods.net/soap/urn:xmethods-CurrencyExchange.wsdl;) MsgBox

Re: Apache 1.3

2001-11-29 Thread Richard Ramos
I installed Apache 1.3.22 on XP with CF 5. The trick is to add the load module line after all module references. This includes the add module lines. I've had no probs since. Richard Ramos - Original Message - From: Iceraven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

RE: Oracle and CF

2001-11-29 Thread James Maltby
There are some probs with SQL syntax and autonumbering, but these should be easy for you (if you are used to ANSI SQL then you have to re-learn some syntax - such as adding schema dot notation before all table calls and creating server-side auto numbering formats and calling them from the code.

10 Step Program

2001-11-29 Thread Won Lee
Hi my name is Won Lee and I'm addicted to session variables. In an attempt to rid myself of all locking, I'm trying to stay away from application and session variables. One of the most common things is used for session variables is session.userID. How does one now emulate this functionality

RE: 10 Step Program

2001-11-29 Thread Declan Maher
Have you thought of using url.variables or passing vars in form.variables. -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 17:19 To: CF-Talk Subject: 10 Step Program Hi my name is Won Lee and I'm addicted to session variables. In an attempt to rid

RE: SOAP Methods

2001-11-29 Thread Pete Freitag
Look at CFX_SOAP http://www.cfdev.com/xml it's not a production ready tag, but its open source and provides a good start for SOAP and CF. It uses Apache's SOAP toolkit in Java. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer

Re: 10 Step Program

2001-11-29 Thread Kwang Suh
client vars... client vars client vars good. - Original Message - From: Won Lee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 10:18 AM Subject: 10 Step Program Hi my name is Won Lee and I'm addicted to session variables. In an attempt to

Re: 10 Step Program

2001-11-29 Thread savan . thongvanh
i try to handle mine using cookies and timeouts. how does that hinder the use of cflocation? Won Lee [EMAIL PROTECTED] on 11/29/2001 11:18:55 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: 10 Step Program Hi my name is Won Lee and I'm addicted to

Re: 10 Step Program

2001-11-29 Thread Kevin Schmidt
How about client variables? - Original Message - From: Declan Maher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:20 AM Subject: RE: 10 Step Program Have you thought of using url.variables or passing vars in form.variables. -Original

RE: SOAP Methods

2001-11-29 Thread Costas Piliotis
Thanks, but I already looked at that solution. The problem is that I need to do some stuff that's a bit more funky than simple soap calls, otherwise I would :-) Still, does CF and COM have that much limitation? -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent:

Re: Oracle and CF

2001-11-29 Thread Dave Hannum
You don't have to add the schema to the tables if you are the owner of the tables. Besides, schema dot, as you call it, is common and proper SQL for higher level RDBMS. You can't call it a problem. Perhaps you're comparing Oracle to Access or something - as for autonumbering, you simply create

RE: 10 Step Program

2001-11-29 Thread Rich Wild
Rather than eliminate all your session and application variables you could write a custom tag that does all the locking for you and copies whatever session or application variables you want into a local scope for your delectation. eg: cf_copySharedVars

RE: 10 Step Program

2001-11-29 Thread Won Lee
Hmm client vars. Why didn't I think about that. I don't want to keep using form variables. Currently I use a lot of URL variables. I'll test it out and see how the fast client variables run. PS you can't use cfcookie and cflocation on the same page. I use cfmodule a lot and manyof them have a

Repost - Query Question

2001-11-29 Thread Adrian Cesana
I think this was lost in the Why aren't there more CF progs out there post, so Ill try again. I almost have this query doing what I need. I want to select ONLY the MOST recent MyDetail.Entry_Date and MyDetail.Entry_Comment. Whats happening now is I get a SINGLE most recent MyDetail.Entry_Date

Credit Card Encryption

2001-11-29 Thread C. Hatton Humphrey
Does anyone have any insight on encrypting data into a Table? A client is asking about storing CC numbers and I want to see what level of protection we can provide. TIA! Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book

RE: Credit Card Encryption

2001-11-29 Thread Carlisle, Eric
You just missed the mother of all threads regarding this. Might want to check a cf-talk archive for last week. There was a lot of good input regarding this. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:43 PM To: CF-Talk

RE: Credit Card Encryption

2001-11-29 Thread C. Hatton Humphrey
Of course that would happen on the week I went of vacation and unsubscribed ;) I'll check it out, thanks! Hatton -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:45 PM To: CF-Talk Subject: RE: Credit Card Encryption You

Re: FTP

2001-11-29 Thread Joseph Thompson
If you build a recursive template you can have it open the connection first time, recursively read the directories, and then close the conneciton when you are done. This file recursively reads an FTP directory and builds a static CFTREE that you can view later.

RE: 10 Step Program

2001-11-29 Thread Won Lee
I read about that in depressedpress.com. How is overall performance though? I can see it being useful on pages that read or write over session.variables a lot, but what about a site where you only access one session variable per page? The greater purpose of me asking is because, I'm trying to

RE: 10 Step Program

2001-11-29 Thread savan . thongvanh
i've never had that problem, probably because i've never tried to do that. i was a javascript junkie well before i got into CF so i set and get all my cookies with javascript. the only hassle with that is that you have to resubmit all your variables to every action page and even so it's not that

Re: Credit Card Encryption

2001-11-29 Thread Stephen Moretti
There are several ways you can do this : 1) Hash() - which is one way encryption 2) cfencrypt() but this has the downside of having to have an encryption key on the server or in the code, which could (if your server is compromised) be aquired by a hacker. 3) CFX_PGP - this is a tag that you have

Re: Credit Card Encryption

2001-11-29 Thread savan . thongvanh
[beating dead horse]i think, and i think some others would agree, the best way to do it if you have to at all is to store the ENCRYPTED number in a table and after that your data is only as good as the security you carryout on your decryption method (com object or otherwise). [EMAIL

RE: Oracle and CF

2001-11-29 Thread James Maltby
Talking to someone new to CF - so talking in S-L-O-W voice - lighten up! :) J -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 17:34 To: CF-Talk Subject: Re: Oracle and CF You don't have to add the schema to the tables if you are the owner of the

RE: SOAP Methods

2001-11-29 Thread Pete Freitag
I see. I realize the tag is quite limited in scope, but if you use the source code of the tag, you could build a tag that is specialized in the object you are connecting to. Unless you are trying to do something that Apache's SOAP toolkit cannot do, then I guess your stuck with COM. I tend to

Re: SOAP Methods

2001-11-29 Thread Alex
Look in the custom tag devex on allaire site. I am unaware of any builtin SOAP support in CF. On Thu, 29 Nov 2001, Costas Piliotis wrote: Hi ppl. If anyone has worked with SOAP, I'm in desperate need of some help. I have some VB Code as follows: Dim SOAPClient As SOAPClient Set

Re: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Larry W. Virden
from: Dave Watts [EMAIL PROTECTED] I don't think AOLServer supports any of the standard APIs used by other web servers. What type of 'standard' API do you have in mind? Considering all the places the server is used, I'd be surprised to find some non-proprietary API not yet available... --

Re: 10 Step Program

2001-11-29 Thread Sam Farmer
This is a great solution and one we use. I would suggest making them request variables though (easy access in custom tags) Sam - Original Message - From: Rich Wild [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 12:31 PM Subject: RE: 10 Step Program

OT: Advertising (reply off list)

2001-11-29 Thread Douglas L. Brown
Please respond off list to this question, as it has nothing to do with programming. [EMAIL PROTECTED] . I have just about finished our business website and am about to go LIVE and am wondering if anyone on the list has any insight into advertising. As with most start-up companies the

Re: Oracle and CF

2001-11-29 Thread Dave Hannum
LOL - sorry if I seemed intense - I like to think of myself as passoniate - LOL (yea, right) BTW - how does cf run on *nix. I've yet to venture that direction, but I have to soon. Does CF run on True64? What should I watch for? Dave - Original Message - From: James Maltby [EMAIL

Re: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Cary Gordon
What is a non-proprietary API? Aren't APIs by their nature proprietary? At 01:10 PM 11/29/2001 -0500, you wrote: from: Dave Watts [EMAIL PROTECTED] I don't think AOLServer supports any of the standard APIs used by other web servers. What type of 'standard' API do you have in mind?

RE: REPOST - cfquery timeout attribute

2001-11-29 Thread Chris Norloff
CF can't control external threads (like database calls) so if the thread never returns then nothing happens. If enough threads never return then CF restarts (based on the CFadmin settings). I think you can use cfcatch type=COM/Allaire.ColdFusion.Request.Timeout to at least catch the timeout

RE: client.CFID vanishes

2001-11-29 Thread Chris Norloff
The client variables are stored in the database (registry on Solaris? ... what registry? :-) The reason I didn't include clientstorage in the particular cfapplication tag is that #DSN# is set in a cfincluded file that comes a little later. So I figure it defaults to the CFadmin settings

Re: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Howie Hamlin
No, many are standard - ISAPI, CGI, etc. are examples. Regards, Howie - Original Message - From: Cary Gordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 1:18 PM Subject: Re: AOLServer (was: CF/IIS/Windows security class) What is a

RE: SOAP Methods

2001-11-29 Thread Costas Piliotis
To tell you the truth, I'm really starting to not be too thrilled with CFOBJECT either :-) -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:02 AM To: CF-Talk Subject: RE: SOAP Methods I see. I realize the tag is quite limited in

RE: client.CFID vanishes

2001-11-29 Thread Dave Watts
The client variables are stored in the database (registry on Solaris? ... what registry? :-) The cf.registry text file (in /opt/coldfusion/registry, I think). CF doesn't write to the file until it shuts down, if I recall correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/

Re: brain fart: some simple SQL

2001-11-29 Thread cf refactoring
John, From my knowledge of SQL, I don't think this can be easily done. SQL can easily combine output from different columns from either the same table or different table, but what you're trying to do is to combine output from the same column in different ROWS in the same table. That being said,

SQL Syntax

2001-11-29 Thread James Taavon
Question, Does Access have different SQL syntax than SQL Server? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Dave Watts
Isn't ISAPI proprietary? Kind of, in that MS created it, and their implementation is certainly the reference implementation. However, ISAPI has been implemented with non-MS web servers before. (WebSite, I think, at one points supported ISAPI in addition to its own WSAPI.) Dave Watts, CTO, Fig

RE: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Dave Watts
What is a non-proprietary API? Aren't APIs by their nature proprietary? No, there's no reason for an API to be proprietary by necessity, although most are bound to products which themselves are proprietary. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax:

Re: Credit Card Encryption

2001-11-29 Thread Bud
On 11/29/01, Stephen Moretti penned: 3) CFX_PGP - this is a tag that you have to pay for and you need a couple of copies of some PGP software, but because of the public and private keys is a lot more secure (no key required on the server to decrypt the credit cards, just on the client's side)

RE: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Dave Watts
What type of 'standard' API do you have in mind? Considering all the places the server is used, I'd be surprised to find some non-proprietary API not yet available... I was thinking along the lines of ISAPI, NSAPI, WSAPI, and Apache modules. Dave Watts, CTO, Fig Leaf Software

Re: SQL Syntax

2001-11-29 Thread Scott Brady
Does Access have different SQL syntax than SQL Server? Yes, there are some minor differences. Which is really annoying since they're both Microsoft products. I'd give you some examples, but I'd hate to get them wrong (I always have to use trial and error). Scott

Re: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Howie Hamlin
No, it's an open specification which means that you can write clients and servers to use the spec. I know of several web servers, for example, that utilize ISAPI interfaces. Regards, Howie - Original Message - From: BILLY CRAVENS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

Re: OT: Advertising (reply off list)

2001-11-29 Thread Bud
On 11/29/01, Douglas L. Brown penned: We are a Gaming PC Manufacturer and our clients would be between the age of 16 to 45. I turn 46 next May. Does this mean I'll be able to get rid of my PS2 and finally get some work done? :-D -- Bud Schneehagen - Tropical Web Creations

RE: 10 Step Program

2001-11-29 Thread Dave Watts
I read about that in depressedpress.com. How is overall performance though? I can see it being useful on pages that read or write over session.variables a lot, but what about a site where you only access one session variable per page? If this is in reference to the concept of copying the

Re: SQL Syntax

2001-11-29 Thread Bruce Sorge
This word document I have is invaluable. Check it out. -- Original Message -- From: Scott Brady [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 29 Nov 2001 11:51:31 -0700 Does Access have different SQL syntax than SQL Server? Yes, there are

RE: SQL Syntax

2001-11-29 Thread James Taavon
ok, specifically with doing an UPDATE, are there any differences? -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:52 PM To: CF-Talk Subject: Re: SQL Syntax Does Access have different SQL syntax than SQL Server? Yes, there are some

Re: OT: Advertising (reply off list)

2001-11-29 Thread Douglas L. Brown
That's a distinct possibility Bud!!! Don't you know everything from 45 on is downhill? :-D Doug - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 10:52 AM Subject: Re: OT: Advertising (reply off list) On 11/29/01,

Re: AOLServer (was: CF/IIS/Windows security class)

2001-11-29 Thread Howie Hamlin
Actually, I think Purveyor (www.process.com) was the first server to support ISAPI (Purveyor is no longer sold, however). http://www.njnet.edu.cn/info/ebook/isapi/ch01.htm Regards, Howie - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

Re: SQL Syntax

2001-11-29 Thread Bruce Sorge
I swear I attached the document. Stupid web based email application. I will send it to you off-line from my hotmail account Scott. -- Original Message -- From: Bruce Sorge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 29 Nov 2001 13:57:11

RE: SQL Syntax

2001-11-29 Thread James Taavon
what Word document? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:57 PM To: CF-Talk Subject: Re: SQL Syntax This word document I have is invaluable. Check it out. -- Original Message --

RE: SQL Syntax

2001-11-29 Thread Bruce Sorge
I meant James, not scott.-- Original Message -- From: James Taavon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 29 Nov 2001 13:59:16 -0500 ok, specifically with doing an UPDATE, are there any differences? -Original Message- From:

Re: SQL Syntax

2001-11-29 Thread Scott Brady
James wrote: ok, specifically with doing an UPDATE, are there any differences? It might be easier if you tell us what you're trying to do. The main parts of the language are the same (so an Update is still an Update), but things like certain keywords may be different. Scott

Re: Simple Site Content Management

2001-11-29 Thread Maureen
You could create a quick form for this using activedit if that is truly all they require. http://www.cfdev.com/activedit2/ At 01:49 PM 11/29/01 +, you wrote: I have a need for a simple content management system. The header and footer will not be available to client but page content

Re: Oracle and CF

2001-11-29 Thread Maureen
Installing Oracle client software and ODBC drivers is a pain the a**. Stored procedures and triggers may need modification if you move from SQLServer. Tablespace allocation and user manager is somewhat different. Performance tuning is very complex and not a task for novices. At 11:13 AM

RE: SQL Syntax

2001-11-29 Thread Bruce, Rodney (Contractor)
Bruce If you wouldn't mind, I would like a copy of the document. I am getting ready to migrate a couple of Access Dbs to SQL, and it sounds like it might come in handy. Thanks, Rodney Bruce -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29,

Where to find a complete U.S. Zipcode listing?

2001-11-29 Thread Bosky, Dave
Like to get a zipcode listing, any idea where to locate a good listing? Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

Re: Credit Card Encryption

2001-11-29 Thread Stephen Moretti
On 11/29/01, Stephen Moretti penned: 3) CFX_PGP - this is a tag that you have to pay for and you need a couple of copies of some PGP software, but because of the public and private keys is a lot more secure (no key required on the server to decrypt the credit cards, just on the client's

Non Verity CF web spider?

2001-11-29 Thread Rick Moon
Hi, I've built a custom CF5 web spider using cfhttp, lists, rereplace and loops. After 200 pages it gets really slow, I have 3000 pages to go. Would accessing VB/COM objects via CF help? Would doing it in asp help? Verity and other copy-a-site programs aren't really an option at this point, I

RE: Credit Card Encryption

2001-11-29 Thread C. Hatton Humphrey
Thanks for all the answers... the end answer is that we are not going to store the information after all, but that's not really a bad thing! Hatton -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 2:35 PM To: CF-Talk Subject:

Re: Where to find a complete U.S. Zipcode listing?

2001-11-29 Thread Jon Hall
AFAIK there isn't a free updated one anywhere. USPS actually sells the zip code database itself ( around $800 subscription...), which a number of people resell. I would think that zip codes are public domain, but then again the USPS still is running in the red... jon - Original Message -

Re: Where to find a complete U.S. Zipcode listing?

2001-11-29 Thread Douglas L. Brown
http://zipinfo.com/products/products.htm Doug - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:20 AM Subject: Where to find a complete U.S. Zipcode listing? Like to get a zipcode listing, any idea where to

  1   2   >