Re: CFPARAM or CFSET

2000-12-16 Thread Bud
On 12/15/00, Eric Fickes penned: Could anybody school me in the difference between using CFPARAM and CFSET. I see CFPARAM all the time, but the little documentation that I've seen about CFPARAM makes it sound just like CFSET. cfparam sets a "default" value that will be replaced by another value

RE: Enterprise Manager (SQL 7.0) For SQL 2000

2000-12-16 Thread Norman Elton
You can install just the Enterprise Manager using the SQL Server Install CD. I believe you choose 'install server', then 'install only server tools' or something to that effect. As I understand it, if you have CALs for SQL Server, then you are allowed to install Enterprise Manager on those

Re: Enterprise Manager (SQL 7.0) For SQL 2000

2000-12-16 Thread Neil H.
I need to find a website or a page on Microsoft's site where customers can download the client for their use. With SQL 7 you would download the trial and then you would have the client. As for licensing its based on per a processor. Thanks, Neil - Original Message - From: "Norman

Fw: Fixed length export from Access 97

2000-12-16 Thread FatDot - Lenny Sorey
Jim, Thanks for your help! Yes, I did mean fixed field lengths. Your example worked perfectly. I mistakenly thought that CF's LJustify() / RJustify() Functions would only work with form fields. My bad. Regards, Lenny Sorey Fatdot.com - Original Message - From: "Jim McAtee" [EMAIL

RE: cfx tags

2000-12-16 Thread Jay Brushett
Thanks to everyone who helped answer this question, you've been really helpfull! Jay At 04:45 PM 12/15/2000 -0500, you wrote: Hi all, I'm in the midst of building my first cfx tag using visual c++ 6. I've gotten to the point where the dll is compiled. What I need to know now

Re: Delete method

2000-12-16 Thread Michael
Could you shed some more light on your reference of the onConfirm javascript? TIA Mak Wing Lok wrote: all these can simple be replace by using the onConfirm javascript mak wl - Original Message - From: Paul Bowley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday,

Field Length

2000-12-16 Thread Mike Weaver
Hello from a Newbie, I am using an access data base. I have a particular field set to memo which is 64k. I store notes here and each one has a time stamp. I use the first bracket of the time stamp as a delimiter when I display them from a query. It works fine but the fields acts like it is

Parsing??

2000-12-16 Thread ibtoad
Can anyone tell me where I can find out how to parse a webpage and pull out specific information? I have never done this before. Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: Parsing??

2000-12-16 Thread Craig Thomas
Rich, To parse a web page you first grab the content with the CFHTTP tag, then "read" the content using the CFHTTP.FileContent variable. In the code below I use the find and len functions to figure out where to start and stop the reading/parsing of the page. This code works only when the page

RE: Field Length

2000-12-16 Thread Craig Thomas
Mike, If the DB field is really set to "memo", I would check your which inserts the data. If the code seems fine and you are in a development environment, try inserting the data manually (straight into the DB) and see if what happens. Craig Thomas PK Interactive Inc. NY, NY 10002 212.273.9623

Re: Field Length

2000-12-16 Thread Mike Weaver
- Original Message - From: "Craig Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 16, 2000 10:18 AM Subject: RE: Field Length Mike, If the DB field is really set to "memo", I would check your which inserts the data. If the code seems fine and you

RE: Parsing??

2000-12-16 Thread ibtoad
I have successfully used the cfhttp tag to pull a webpage and then display it with CFHTTP.FileContent. But how do I just display specific parts? Rich -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 11:10 AM To: CF-Talk Subject: RE:

RE: Parsing??

2000-12-16 Thread Craig Thomas
Do you have access to the code of the target page? All my cfset tags and the find() and len() functions add and subtract characters from the CFHTTP.FileContent variable...giving me parts of the web page I want to display. Watch out, if the target page changes, your code needs to change. In my

RE: Parsing??

2000-12-16 Thread ibtoad
No, I wish I did. Rich -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 12:37 PM To: CF-Talk Subject: RE: Parsing?? Do you have access to the code of the target page? All my cfset tags and the find() and len() functions add and

Re: Parsing??

2000-12-16 Thread pan
I have successfully used the cfhttp tag to pull a webpage and then display it with CFHTTP.FileContent. But how do I just display specific parts? Rich Craig already showed you one method. Basic info is that cfhttp.filecontent is one_big_string. You use the various cf string functions to

RE: SQL: Aliases in where clauses.

2000-12-16 Thread Joe Sheble aka Wizaerd
The original question was field aliases, not necessarily table aliases I just opened up my SQL Server, and ran this on the Northwind sample database, and the message I get is 'Invalid Column Name', because the alias fullname isn't a table column SELECT firstname + ' ' + lastname AS fullname

CF and Interbase

2000-12-16 Thread Tristram Charnley
Just interested to find out who else is using Borland Interbase Server. We've been using Interbase 4.5 NT happily for a couple of years on an intranet but I'm interested to hear from anyone with any experience of it on big public sites with CF. How well does it perform under serious loads etc.

Re: Parsing??

2000-12-16 Thread Michael Dinowitz
www.houseoffusion.com/httpagent.ppt I've got a section in it on using both find/mid and RegEx/mid to do parsing. It also explains the basics of RegEx. Can anyone tell me where I can find out how to parse a webpage and pull out specific information? I have never done this before. Thanks,

Re: Parsing??

2000-12-16 Thread Bill Davidson
To be really efficient in doing this, learn regular expressions and use CF's regular expression functions. Otherwise you'll be writing a parser that is bulky to handle many different cases, unless the page you are formatting is always pretty much the same, but just some different data. Not

regular expressions

2000-12-16 Thread Craig Thomas
Does anyone know of a good source of info on Regular Expressions for CF? Craig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

OT: Undo Delete

2000-12-16 Thread David Shadovitz
I'm thinking of changing my typical "Delete" button so that it doesn't actually delete a record, but rather flags it as a record to be ignored. I'd also record the date/time that it was flagged. That way I can offer the user the opportunity to Undo the Delete. I'll probably schedule a job to

Re: CF and Interbase

2000-12-16 Thread Troy Leaver
I'm using CF Interbase on a relatively small scale, but so far so good. I'm using IB 6.01 along with the Easysoft ODBC Driver (www.easysoft.com/products/interbase). I can't give you any scalability feedback, but thought you might find the ODBC info useful. Regards, Troy Leaver Systems

Re: regular expressions

2000-12-16 Thread Bill Davidson
umm.. Look back 2 messages... It's from Fusion Authority, so I'm sure its good... www.houseoffusion.com/httpagent.ppt ;) (I realize you may have sent this message before Michael's message posted.) -Bill /intraget - Original Message - From: Craig Thomas [EMAIL PROTECTED] To: CF-Talk

Re: OT: Undo Delete

2000-12-16 Thread Michael She
Hello, I do this for my message forum where I flag deleted posts. This way, I can recover the posts if neccessary in the future (ie law suit against me! : ) Another possibility is using your "approved field" and making it a text/numeric flag instead. This way you can have mutliple states

RE: Parsing??

2000-12-16 Thread Michael She
You'll have a fun time. unfortately HTML unlike XML is not well defined. Basically you'll have to hard code patterns and rules to pull out specific data. The best would be to switch over to an XML type webpage/data packet instead. That way you can easily manipulate it. At 12:49 PM 12/16/00

Re: OT: Undo Delete

2000-12-16 Thread Michael Thomas
Just like an audit trail. From: Michael She [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: OT: Undo Delete Date: Sun, 17 Dec 2000 02:04:33 -0500 Hello, I do this for my message forum where I flag deleted posts. This way, I can recover the posts if

RE: SQL: Aliases in where clauses.

2000-12-16 Thread Michael Thomas
I saw you had an aggregate function within your example but you said nothing about using a TABLE ALIAS inside an aggregate function. Your question asked if you could use an ALIAS in a WHERE clause. You can use an ALIAS in a WHERE clause but Ive never been able to use an ALIAS inside an