Re: Single-to-dual processor... reinstall CF?

2002-04-18 Thread Jon Hall
CF to my knowledge has no concept of multiple CPU's. It relies on the OS to handle parceling out tasks to the different cpu's. - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 6:03 PM Subject: Single-to-dual

RE: Encrypting Numeric ID's

2002-04-18 Thread Jason Dowdell
I tried all of those solutions except the htmleditformat. Will the htmleditformat remove double quotes? ~jason -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:07 PM To: CF-Talk Subject: Re: Encrypting Numeric ID's How about this:

Re: RE: Encrypting Numeric ID's

2002-04-18 Thread ksuh
Yes. It will escape the double quote to quot;. Once you submit the form, it will revert back to a double quote. URLEncodedFormat should have worked as well, although I only use that function for when I'm putting variables on the URL. - Original Message - From: Jason Dowdell [EMAIL

Re: RE: Encrypting Numeric ID's

2002-04-18 Thread ksuh
Actually, I just realized that URLEncodedFormat won't work, as a quote will be url escaped, and when you submit the form, it won't change back to a quote. - Original Message - From: Jason Dowdell [EMAIL PROTECTED] Date: Thursday, April 18, 2002 4:38 pm Subject: RE: Encrypting Numeric

Re: RE: Encrypting Numeric ID's

2002-04-18 Thread Matt Robertson
You'd have to decode it and decrypt it on the next page before you use it for anything. I don't understand what you mean by it not working. those things are pretty big, tho'. One thing you could do is CFSET base64encrypted = ToBase64(encrypt(string, key)) CFSET encrypted =

Finding Images in HTML and Uploading

2002-04-18 Thread VAN VLIET, SCOTT E (SBCSI)
Before I go any farther than I already have, I thought I should ask you folks if you have already seen this functionality, or know of a custom tag or UDF to do this: I have a client who wants to be able to post HTML to a content management site, and have the ability to upload the images he

RE: Javascript: onKeydown event

2002-04-18 Thread Thanh Nguyen
Scott, It's a typo. In my template there's only one onKeyDown event. -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:09 PM To: CF-Talk Subject: RE: Javascript: onKeydown event Is there any reason you have two onKeyDown

calendar

2002-04-18 Thread Higgins, Cathy
my problem is the forum calendar. I add events and if click commit changes twice there are 2 entries, when I try to delete an entry the computer locks up--If I change the verbage and commit changes it locks up. I don't errors, so I'm not sure where to start looking for the problem

RE: Finding Images in HTML and Uploading

2002-04-18 Thread Matthew Walker
Why don't you use something like Activedit which has image uploading built in? -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, 19 April 2002 10:50 a.m. To: CF-Talk Subject: Finding Images in HTML and Uploading Before I go any farther than I

RE: using != in a filed with a null value

2002-04-18 Thread Sam Roach
You can also use neq ContactCnt neq 'Do Not Contact' -- Sam - -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:13 AM To: CF-Talk Subject: RE: using != in a filed with a null value I have always

RE: RE: Encrypting Numeric ID's

2002-04-18 Thread Jason Dowdell
Thanks for the tips, I'll try to explain when I return later tonight. ~Jason -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:46 PM To: CF-Talk Subject: Re: RE: Encrypting Numeric ID's You'd have to decode it and decrypt it on the

SQL DISTINCT Question

2002-04-18 Thread Jeff Green
SELECT DISTINCT Email FROM LinkedEmails returns a record set with no dupe emails, but I want first and last names as well so i try SELECT DISTINCT Email, FirstName, LastName FROM LinkedEmails returns a record set that has dupe email fields How would I query for unique emails and get the first

cffile - probs with spaces in file name

2002-04-18 Thread Seamus Campbell
Hi I'm having a problem with CFFILE that I hope someone may be able to help me with I'm uploading and deleting files. If a file is uploaded with spaces in the file name - it cannot be deleted - gives this error: Unable to delete the file 'D:\Virtual

RE: SQL DISTINCT Question

2002-04-18 Thread Sam Roach
try: SELECT email, first(firstname), first(lastname) FROM people GROUP BY email; -- Sam -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:15 PM To: CF-Talk Subject: SQL DISTINCT Question SELECT DISTINCT Email FROM LinkedEmails returns a

RE: SQL DISTINCT Question

2002-04-18 Thread Jeff Green
Thanks Sam, got the following to work but I like yours better ;) SELECT Email, FirstName, LastName FROM Users WHERE ID IN (SELECT Min(ID) FROM Users GROUP BY email) -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:33 PM To: CF-Talk Subject:

RE: SQL DISTINCT Question

2002-04-18 Thread Sam Roach
creative :) -- Sam -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:55 PM To: CF-Talk Subject: RE: SQL DISTINCT Question Thanks Sam, got the following to work but I like yours better ;) SELECT Email, FirstName, LastName FROM Users WHERE

Re: RE: Encrypting Numeric ID's

2002-04-18 Thread ksuh
Yes, but why bother doing all this work when htmlEditFormat() does all this for you? - Original Message - From: Matt Robertson [EMAIL PROTECTED] Date: Thursday, April 18, 2002 4:46 pm Subject: Re: RE: Encrypting Numeric ID's You'd have to decode it and decrypt it on the next page

RE: cffile - probs with spaces in file name

2002-04-18 Thread Tim Painter
After the file is uploaded, you should be able to use the #cffile.serverFile# variable to get the filename that was saved on the server. Can you use that to delete it? cffile action=delete file=D:\VirtualSites\test_\ccsbt\documents_directory\#cffile.serverFile# HTH, Tim P. -Original

RE: Stored Process

2002-04-18 Thread Eric Gilbert
Jerry, Since lists are also strings why not pass it in as a varchar using cfsqltype=CF_SQL_VARCHAR then within the stored procedure select * from country where country_id IN (@countries) just make sure the varchar is large enough to hold a little more than the maximum number of characters

RE: Javascript: onKeydown event

2002-04-18 Thread Thanh Nguyen
worked great !!! thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:14 PM To: CF-Talk Subject: Re: Javascript: onKeydown event http://developer.irt.org/script/1214.htm - Original Message - From: Thanh Nguyen [EMAIL

Client var weirdness

2002-04-18 Thread Ian Lurie
Help?! We just set up a new SQL box. Now we get this whenever you access a CF page in an app that uses client vars: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CGLOBAL' We set up the client var table as normal - both tables

RE: Finding Images in HTML and Uploading

2002-04-18 Thread Scott Van Vliet
ActivEdit is too much for this particular client. The client is basically going to be receiving a ZIP file containing an HTML file and images. His job will just be to copy the HTML out of the file and paste it into the field, and then supply the required images (which will be named as those in

RE: Finding Images in HTML and Uploading

2002-04-18 Thread Bill Harper
hey At 07:42 PM 4/18/02 -0700, you wrote: ActivEdit is too much for this particular client. The client is basically going to be receiving a ZIP file containing an HTML file and images. His job will just be to copy the HTML out of the file and paste it into the field, and then supply the

update form displays multiple pages

2002-04-18 Thread Judy
When I click an Edit link for a record, instead of displaying a form containing existing data, I get 25 pages of the same record. I know my relationships in my database are correct - they are all one-to-many. Where have I gone wrong? The main file, Events contains the primary key ID and the

RE: Finding Images in HTML and Uploading

2002-04-18 Thread Brad Roberts
Just a thought... Have the client upload the zip file to a temp dir. Then use cfx_zip to unzip the files where you want them. -OR- If you have to rename the images because of name conflicts, loop through the images and do a replace function on the html file for each image. You could get the

RE: Client var weirdness

2002-04-18 Thread Ian Lurie
Dunno WHAT happened - I recreated the tables and now it works. Spooky... -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 7:54 PM To: 'Ian Lurie ' Subject: RE: Client var weirdness Interestingly enough, we just had the same thing happen.

RE: Finding Images in HTML and Uploading

2002-04-18 Thread Matthew Walker
Seems to me you need to use a regex to strip out all the image tags and replace them with markers (I would use #SUB#1, #SUB#2, #SUB#3 etc where SUB = Chr(26). After the second form replace the markers with the actual code. You need to search for something like this: img[^]* -Original

RE: update form displays multiple pages

2002-04-18 Thread Matthew Walker
WHERE ID = ID This is always true. You need something like WHERE ID = #ID# See the difference? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original

Re: update form displays multiple pages

2002-04-18 Thread Judy
I made the change, but got this error message: !--- add query to select all events--- cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = #ID# /cfquery !--- end query to select all events--- Do I need to have additional WHERE statements here because I'm using 6 different

RE: update form displays multiple pages

2002-04-18 Thread Matthew Walker
Oops. I mean #URL.ID# -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Friday, 19 April 2002 3:26 p.m. To: CF-Talk Subject: Re: update form displays multiple pages I made the change, but got this error message: !--- add query to select all events--- cfquery

RE: Client var weirdness

2002-04-18 Thread Peter Tilbrook
This has happened to me once before. Try creating a new empty database and re-configure the client variables setting under CF Administrator. If that works you can then delete the old db. Peter Tilbrook ([EMAIL PROTECTED]) Macromedia ColdFusion Applications Developer Cubok Pty. Ltd. Units 7-10

RE: Client var weirdness

2002-04-18 Thread Ian Lurie
Yes, that fixed it. But what CAUSED it? I don't like the idea that my client var storage can crack at any time. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:41 PM To: CF-Talk Subject: RE: Client var weirdness This has happened to

RE: Client var weirdness

2002-04-18 Thread Ron Anderson
Could it be the table owner has changed? -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:39 PM To: CF-Talk Subject: RE: Client var weirdness Yes, that fixed it. But what CAUSED it? I don't like the idea that my client var storage can

<    1   2   3