Re: FW: Regex prob (Re-Post)

2001-01-21 Thread Dick Applebaum
Katrina This isb't exactly what you waked for, but it may help to get you there. Note the first cfset may wrap in the email: cfset test = '"http://www.santaanacc.com/html/01chamber/directory/company.asp?COMPA NY=A+America+Signs%2C+Inc%2E" target="_top"' cfset test = test test test

Basic Search Engine

2001-01-21 Thread W Luke
Hi, I'm building a basic search engine to query a table in my Database, and return 10 results at a time. At the moment I've got URL parameters of url.query and url.start_row and a variable #maxrows# set to 10 - if no inital start_row is defined, then the startrow is 1. I was wondering the best

Re: Basic Search Engine

2001-01-21 Thread Seamus Campbell
this is a very good article http://www.defusion.com/articles/index.cfm?ArticleID=81 At 08:59 pm 21/01/01 , you wrote: Hi, I'm building a basic search engine to query a table in my Database, and return 10 results at a time. At the moment I've got URL parameters of url.query and url.start_row

Re: Basic Search Engine

2001-01-21 Thread W Luke
Thanks for that - very informative. On the subject of finding out how many pages in the search results there are, does anyone have any tips? The furthest I've got is to do the following: Cfset nopages = (get_results.recordcount / max) This, for example, gives results of 0.4 and 2.5 - what I

RE: Basic Search Engine

2001-01-21 Thread Raymond B.
CF has ceiling(), int() [commonly called floor()], fix(), and round() for returning integer number (input upto to real set). cfset pages = ceiling(query.recordCount / max_rows) I'd suggest you read through the language reference a few times; this will familiarise you with CFs tags,

RE: CFPOP - murphy's law

2001-01-21 Thread Owen Leonard
(from CF 4.5 Pro to 4.5.1 SP2) we started having problems with CFPOP accessing mail on a machine running SCO-UNIX and Sendmail. It's an "optional" pop3 command to get unique id numbers for all the messages currently on the mail server (to make it easier to keep track of what's what). At

Updating memo fields in FoxPro DBFs

2001-01-21 Thread Arden Weiss
Apparently the Fox ODBC driver can not update strings longer than 255 characters in memo fields with the standard SQL UPDATE or INSERT commands (works fine in Access). The workaround is to break the long string into 254 chunks and loop through the chunks while doing an insert or update.

Re: [FW: Regex prob (Re-Post)]

2001-01-21 Thread Alex
is the url on one line? get rid of the ^ "Katrina Chapman" [EMAIL PROTECTED] wrote: I sent this a week ago and didn't really get a response. So I'm posting again in the hopes that my question will be answered this time. TIA, --K -Original Message- From: Katrina Chapman [mailto:[EMAIL

OT: Win2k Time

2001-01-21 Thread Bernd VanSkiver
Has anyone had any luck setting up Windows 2000 to get time from an external/internet SNTP or NTP server? I'm trying to use the NET TIME feature, but can't get it to grab the time from the server on the web. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 Archives:

Re: chmod

2001-01-21 Thread Yvette Ingram
Jay: From back in my Unix days, I think that's 777 Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: ingramrecruiting@erols or [EMAIL PROTECTED] ICQ: 21200397 - Original Message - From: Jay Patton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday,

Re: Evaluating height/width of a JPG?

2001-01-21 Thread Gary Groomer
I have successfully used the "ImageSize.cfm" custom tag from Allaire's web site. If you use this with Photoshop images, make sure that the files are not saved with thumbnails as this tag may pick up the size of the thumbnail vs. the size of the image. Also, you will find more custom tags on

CFDIRECTORY on Redhat 7.0??

2001-01-21 Thread Daniel Wm Brick III
Help! I've been using the CFDIRECTORY tag on an NT box to list directories under my web site's home dir that start with "pics_". I just recently moved my entire site to a Linux box (running Redhat 7), and now the query always returns empty. I can match entire directory names or everything in

Re: Evaluating height/width of a JPG?

2001-01-21 Thread David Hannum
If you'd like to see CF_ImageSize in action, go to www.countrytraditions.com and see it there. I used imagesize to tell the catalog how wide the image is. For images under 350 pixels wide, it puts the image on the left with the info on the right. For wider images, it puts the image on top, and

Re: Selecting on dates

2001-01-21 Thread Paige Chandler
Hi Jim, Thanks for all your help. I'm sure that I need to convert the memory variable to the same format as the field variable StartVisit (which is in DateTime). In the CFOutPut code below I can see that the 2 fields are in a compatible format. But when I try use the comparison in the Where

Re: CFDIRECTORY on Redhat 7.0??

2001-01-21 Thread Howie Hamlin
Linux is case sensitive so /home/sites/mysite.com/ is not the same as /Home/Sites/Mysite.com/ and "pics" is not the same as "Pics". So, I would make sure to match the case of what I'm searching for. HTH, Howie - Original Message - From: "Daniel Wm Brick III" [EMAIL PROTECTED] To:

RE: CFDIRECTORY on Redhat 7.0??

2001-01-21 Thread Daniel Wm Brick III
Thanks, that had ocurred to me. I've made sure everything is in lowercase. Anything that isn't would be after the pics_ prefix in the directory name, which I assume would match with the * wildcard... still, it doesn't work. dBIII+ -Original Message- From: Howie Hamlin [mailto:[EMAIL

asp to cfobject

2001-01-21 Thread Paul Hastings
not up to speed with COM my vb guy's out sick so would anyone be kind enough to suggest cf code for the following ASP: Set rs = Map.Layer("states").SearchExpression("STATE_NAME = 'California'") Set Extent = Map("states").Recordset.RecordExtent many thanks.

java ?

2001-01-21 Thread Mike
onmouseout works onclickworks But for some reason onmouseover is not working a href="index.asp?fuseaction=admin_IndexSite" onmouseover="JavaScript:window.status= 'Admin Over '" onmouseout = "JavaScript:window.status = '' " onclick="JavaScript:window.status = 'Admin click'"

RE: java ?

2001-01-21 Thread ron
onmouseout works onclickworks But for some reason onmouseover is not working a href="index.asp?fuseaction=admin_IndexSite" onmouseover="JavaScript:window.status= 'Admin Over '" onmouseout = "JavaScript:window.status = '' " onclick="JavaScript:window.status = 'Admin click'"

Re: asp to cfobject

2001-01-21 Thread Michael Dinowitz
Try this: cfobject type="COM" name="rs" class="Map.Layer("states").SearchExpression("STATE_NAME = 'California'")" action="CREATE" CFSET mapset='Map("states").Recordset' CFSET Extent=mapset.RecordExtent CF use of objects has a problem using more than 2 dot paths at a time. Setting the first 2

RE: java ?

2001-01-21 Thread ron
return of true, so you're end result is like this: ^^ your, of course. I do no how two spel. -ron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

RE: Evaluating height/width of a JPG?

2001-01-21 Thread Brad Roberts
If you mean after the file has been uploaded, yes. If you mean before the file is uploaded, I'm not sure. There is a tag called cf_imagesize in the tag gallery that does this. It gives you the width, height, and type of a gif or jpg. I've used it several times and it works well. Try this

RE: CF games

2001-01-21 Thread Dave Yang
We have a new project that requires "Games". I need to find a few classic English teaching games, Hangman, crossword puzzles and the like. Has anyone seen or written these game in CF? Or for that matter in java script? Are you only looking for HTML-based games? How about games done in

Help with grouping

2001-01-21 Thread Nick Slay
Ok, I'm beating my head trying to figure this one out, so I figured I'd try the list to see if anyone can help out before I tear ALL my hair out!!! I'm currently writing a Forum System, and I just can't figure out a way of grouping the messages correctly... If I have 10 messages entered, I want

Re: Win2k Time

2001-01-21 Thread Jon Hall
I've used the Atomic TimeSynch from www.analogx.com with no problems in the past. jon - Original Message - From: "Bernd VanSkiver" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, January 21, 2001 10:55 AM Subject: OT: Win2k Time Has anyone had any luck setting up

Re: Help with grouping

2001-01-21 Thread Stephen M Aylor
Seems allaire's forums are able to do something real similar. Isnt their app [Forums] now Open Sourced? Would their queries provide the needed clues? Just a quick, not well researched thought. Steve - Original Message - From: "Nick Slay" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL

How to Convert currency to numeric value

2001-01-21 Thread Mike Kear
I'm doing a calculator that involves users entering their annual income into an input field. So the gross income needs to be a numeric value. But if the user types in $36000, then the val(grossincome) function returns zero, because the first character isn't numeric. What's the easiest way to

Re: How to Convert currency to numeric value

2001-01-21 Thread Phoeun Pha
CFSET NumberIwant = Replace(Form.Number, "$", "ALL") - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 21, 2001 6:31 PM Subject: How to Convert currency to numeric value I'm doing a calculator that involves users entering

RE: How to Convert currency to numeric value

2001-01-21 Thread Bill Killillay
Take a look at the replace functions, then on your incoming string do a search and replace on the common things like $ and . and replace them with "" that will leave you with just raw numbers and you can then number format them later on output. So look at replace() functions and numberformat()

RE: How to Convert currency to numeric value

2001-01-21 Thread Mike Kear
Hey! Hang on - I was just checking to see if my question had appeared on the list and here's your answer!Sheeesh . next you'll be answering my questions before I even get them written down! Actually, the solution to the problem required another parameter in the replace function so it reads

RE: How to Convert currency to numeric value

2001-01-21 Thread paul smith
At 12:12 PM 1/22/01 +1100, you wrote: Sheeesh . next you'll be answering my questions before I even get them written down! #1. No. #2. Yes, but only in NT, not Windows 2000. ;-) ~~ Structure your ColdFusion code with Fusebox. Get the

Re: How to Convert currency to numeric value

2001-01-21 Thread Phoeun Pha
I knew something was missing! heh - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 21, 2001 7:12 PM Subject: RE: How to Convert currency to numeric value Hey! Hang on - I was just checking to see if my question had appeared on

RE: How to Convert currency to numeric value

2001-01-21 Thread Benekli
How about: cfinput type="text" validate="integer" message="enter only numbers please" Benekli20:20P21I2001 -CFSET NumberIwant = Replace(Form.Number, "$", "ALL") - But if the user types in $36000, then the val(grossincome) function -returns zero, because the first character isn't numeric.

RE: Slightly OT: Securing SQL 7.0 database

2001-01-21 Thread Darryl Lyons
I think the second option of specifying the username and password in the query tag would work best - as it really isn't a globally available file - especially in an ISP environment. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 9:22 PM

SQL syntax problem

2001-01-21 Thread Phoeun Pha
ok, i have a field where people type in the names of songs. The problem is, if the song title has an apostrophe in it, like "I'm comin' ova", i get an error. i think it's cuz SQL don't read dem apostrophes as text. how do i make the database accept them?!!

Multi-language CF sites

2001-01-21 Thread Darryl Lyons
Hi, Has anybody successfully built a multi-language dynamic website - where the page data, etc, is kept within the database? How did you display the languages on screen, in the database, etc.. --- Regards, Darryl Lyons Web Development Team LogicWorld Internet

Stopping people doing the 'I clicked submit twice' thing..

2001-01-21 Thread Darryl Lyons
Has anybody found a way around this? It seems that whenever someone clicks submit twice, data is inserted twice (updates are ok). --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site

Re: SQL syntax problem

2001-01-21 Thread Nick Slay
Hi, you can use a function called PreserveSingleQuotes before storing the information to the database. At least that's what I think it's for!!! :^) From: "Phoeun Pha" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 21 Nov 2000 19:31:42 -0600 To: CF-Talk [EMAIL PROTECTED]

Re: SQL syntax problem

2001-01-21 Thread Phoeun Pha
ok, i am confused. what do i type to get this character ' and why is it different from this character ' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: Stopping people doing the 'I clicked submit twice' thing..

2001-01-21 Thread Tim Fields
Darryl, Here's the best solution we've found. It's amazingly simple and it does the job! Note that it's not simply changing the name of the button to "Please Wait" - it actually disables it. Here's the code: input type="submit" value="Submit" onClick="if(this.value == 'Submit')

Re: Stopping people doing the 'I clicked submit twice' thing..

2001-01-21 Thread Kym Kovan
Hi Darryl, Has anybody found a way around this? It seems that whenever someone clicks submit twice, data is inserted twice (updates are ok). You can use javascript to make sure it only happens once or, better but more overhead, write some cf code to make sure you are not doing it twice.

RE: Win2k Time

2001-01-21 Thread Cruz, Joseph
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Try NET TIME /SETSNTP:timeserver.domain.com This sets a registry entry. Check out http://support.microsoft.com/support/kb/articles/Q223/1/84.ASP?LN=EN-USSD=gnFR =0qry=w32timernk=1src=DHCS_MSPSS_gn_SRCHSPR=WIN2000 for more information. :) Joe

RE: CFDIRECTORY on Redhat 7.0??

2001-01-21 Thread Deb Dickerson
I was able to run your code without any problems. The first thing you should check is to be sure that the account ColdFusion is running under (typically 'nobody', but not necessarily) has permissions to the directory structure where the files are residing, and to the files themselves. When I ran

Formatting CFMAIL

2001-01-21 Thread Harry Miller
--=_4525931==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed I have formatted the subject line in the CFMAIL as follows: SUBJECT="CDR Beta-#Company#-#Now()#-#Last_Name#, #First_Name#" How can I eliminate the {ts ' and '} from printing in the subject line

RE: Win2k Time

2001-01-21 Thread Bernd VanSkiver
Have you gotten it to actually work? I have done that and tried many servers, can't get it to work. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 -Original Message- Date: Sun, 21 Jan 2001 21:03:56 -0500 From: "Cruz, Joseph" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Win2k

RE: Formatting CFMAIL

2001-01-21 Thread Dylan Bromby
if you want to put the date and time in the subject, why don't you use DateFormat(Now(), 'mask') and TimeFormat(Now(), 'mask')? -Original Message- From: Harry Miller [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 7:31 PM To: CF-Talk Subject: Formatting CFMAIL

RE: SQL syntax problem

2001-01-21 Thread Raymond B.
INSERT INTO table (field1) VALUES ('#form.field1#') ; When you do this, CF should automatically escape all single quotes. The preserveSingleQuotes() function is generally only needed when passing full SQL statements as variables or inserting lists (generally already quoted). If you find for

RE: Multi-language CF sites

2001-01-21 Thread Benekli
Did a dynamic five language site (Japanese, Korean, Cantonese, Mandarin, English) using access for prototyping and oracle for publishing. The language code is simple, note that you can only specify one charset per page: meta http-equiv='content-type' content='text/html;charset=#bnkCharSet#'

RE: CFPOP - murphy's law

2001-01-21 Thread lsellers
That was about as far as we got in our investigation. And of course we're checking into an update for Sendmail. The question is, if it's optional, how do you get CFPOP to not send the command? Good question, but I don't know the answer. And where's the documentation for this feature

Re: Formatting CFMAIL

2001-01-21 Thread Howie Hamlin
Check out the DateFormat function. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original

OT, but helpful maybe

2001-01-21 Thread Bud
Howdy all. I built myself a cool little template for creating forms, cfparam and cfset tags, and insert and update queries. Just paste in a comma delimited list of field names, then on the next screen you can specify the type of field, whether it is required, enter your option tags for select

Re: How to Convert currency to numeric value

2001-01-21 Thread Bud
On 1/22/01, Mike Kear penned: I'm doing a calculator that involves users entering their annual income into an input field. So the gross income needs to be a numeric value. But if the user types in $36000, then the val(grossincome) function returns zero, because the first character isn't

RE: Multi-language CF sites

2001-01-21 Thread John Quarto-vonTivadar
we did a 5-language site (all european so dunno if this works on asian languages) using Fusebox where we kept all the DSP files in separate but mirrored directories and then called them in the standard Fusebox index.cfm file with cfcase value="myfuseaction" cfinclude

RE: Stopping people doing the 'I clicked submit twice' thing..

2001-01-21 Thread Darryl Lyons
Can you explain more about database flags and how they may come in handy? -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 12:01 PM To: CF-Talk Subject: Re: Stopping people doing the 'I clicked submit twice' thing.. Hi Darryl, Has anybody

RE: Stopping people doing the 'I clicked submit twice' thing..

2001-01-21 Thread Darryl Lyons
That's a great solution, but unfortunately it doesn't work with client-side validation in place using the standard cfinput required="yes" -Original Message- From: Tim Fields [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 11:21 AM To: CF-Talk Subject: RE: Stopping people doing