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
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
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
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
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,
(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
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.
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
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:
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,
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
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
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
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
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:
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
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.
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'"
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'"
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
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
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
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
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
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
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
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
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
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()
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
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
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
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.
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
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?!!
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
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
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]
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:
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')
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.
-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
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
--=_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
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
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
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
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#'
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
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
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
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
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
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
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
55 matches
Mail list logo