RE: padding a variable

2000-11-03 Thread Chapman, Katrina
That's not the queston boys. He's not asking how to limit it to 30 but how to force it up to 30. IE I have a string that's only 22 chars long I need it to be thirty. Try this CFSET foo = "my string less than 30" CFOUTPUT #foo# - #len(foo)# /CFOUTPUT BR CFIF Len(foo) GTe 30 CFSET foo =

Text File to Database Custom Tag.

2000-11-03 Thread Chapman, Katrina
I know that this has been discussed several times on the list but I'm in need of a Custom Tag that will take a tab delimited Text file and import it into a SQL 7.0 database. Does anyone know of a tag that does this? I can't find one in the tag gallery. --K

RE: Killing a variable

2000-11-02 Thread Chapman, Katrina
Actually StructIsEmpty() will always return false on the session structure. There are 4 vars that CF includes by default in that structure. Can anyone guess what they are. --K -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 02, 2000 8:47 AM

RE: CFFile ERROR

2000-11-01 Thread Chapman, Katrina
Can we see the tag in question? It should look like this. CFFILE ACTION="Rename" SOURCE="full_path_name" DESTINATION="full_path_name" ATTRIBUTES="file_attributes" --K -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: Displaying decimal part as a fraction...

2000-11-01 Thread Chapman, Katrina
Look at the function Max provided you with again. It will do exactly what you're asking for. --K -Original Message- From: Rice, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 1:20 PM To: CF-Talk Subject: RE: Displaying decimal part as a fraction... Not really,

RE: Capitalize First Letter of Each Word

2000-10-26 Thread Chapman, Katrina
No offense Jeff, but, I love it when people make things more complicated than they need to be. cfset newstring = "" CFSET TargetString = "Now is the time for all good men and WOMEN." cfloop index="ii" list="#TargetString#" delimiters=" " cfset newstring = newstring " " UCase(Left(ii, 1))

RE: processing umlaut characters

2000-10-26 Thread Chapman, Katrina
My guess is you're doing something like this select name="foo" option value="bar"cfif myquery.foo eq "bar" Selected/cfifbar/option option value="bar2"cfif myquery.foo eq "bar2" Selected/cfifbar2/option option value="bar3"cfif myquery.foo eq "bar3" Selected/cfifbar3/option /select Am I right?

RE: CFSCRIPT

2000-10-25 Thread Chapman, Katrina
You can also try the docs. http://127.0.0.1/CFDOCS/CFML_Language_Reference/2_ColdFusion_Tags/lr2_073.ht m --K -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 1:53 PM To: CF-Talk Subject: RE: CFSCRIPT The Advanced web application

RE: CFSCRIPT

2000-10-25 Thread Chapman, Katrina
al Message----- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 3:36 PM To: CF-Talk Subject: RE: CFSCRIPT You can also try the docs. http://127.0.0.1/CFDOCS/CFML_Language_Reference/2_ColdFusion_Tags/lr2_073.ht m --K -Original Message- From: Brad Rober

RE: how to prevent link from using IE window

2000-10-24 Thread Chapman, Katrina
Christopher, You answered your own question. "I cannot configure user computers." There is, therefore, no way to control that machine. --K -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:07 AM To: CF-Talk Subject: RE: how to

RE: looping through queries

2000-10-24 Thread Chapman, Katrina
You can do this with two queries. cfquery name="getallarticleCats" dsn=dsn Select catID, Name From ArticleCats /cfquery cfquery name="getassignedcats" dsn=dsn SELECT catID FROM ArticleCats WHERE catid NOT IN (Select Distinct catID from Articles) /cfquery Then when you're

RE: write var into txt file and save

2000-10-23 Thread Chapman, Katrina
You don't need a custom tag to do this. You need to use the Append action of the cffile tag. --K -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 7:17 AM To: CF-Talk Subject: RE: write var into txt file and save This is a multi-part

RE: disappearing form variables

2000-10-19 Thread Chapman, Katrina
Jordie do you have a url where we can see this happening. I copied your code exactly and it works fine for me. --K -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 12:57 PM To: CF-Talk Subject: RE: disappearing form variables If you

RE: Email a check???

2000-10-19 Thread Chapman, Katrina
That is if they even accept the check in the first place. --K -Original Message- From: Braver, Ben: [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 4:09 PM To: CF-Talk Subject: RE: Email a check??? Hmmm, how ya gonna get the MICR characters (magnetic ink character

RE: I know we have gone over this a million times.

2000-10-18 Thread Chapman, Katrina
#Chr(10)# and #Chr(13)# should do the trick. One is a CR and one is a LF. I don't remember which is which though. --K -Original Message- From: Nick Call [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 9:44 AM To: CF-Talk Subject: I know we have gone over this a million

RE: CFCase - Number in range of values

2000-10-18 Thread Chapman, Katrina
No. You cannot do this. Cfswitch/cfcase tags check for equality. You can't do a GT or LT comparasion with cfcase. For this kind of conditional logic you have to use a set of if/elseif/else statements, or list all of the numbers between 400 and 499 comme ca. cfswitch

RE: outputting data in a matrix

2000-10-17 Thread Chapman, Katrina
No offence to anyone but your all making this much more difficult than it is. With a little creative HTML you can do this. CFQUERY name="get_stuff" datasource="katrinachapman" SELECT bookcat.Name, book.title FROM bookcat, book WHERE book.catid = bookcat.id ORDER BY bookcat.name /CFQUERY TABLE

RE: CFContent Weirdness

2000-10-17 Thread Chapman, Katrina
What we do here is a cfhttp call to the template that creates the HTML for the report passing through the file attribute. Then cfcontent the file that was created in the cfhttp. That way you don't lose anything. Let me know if you need anymore help with this. --K -Original Message-

RE: What's with all the space?

2000-10-17 Thread Chapman, Katrina
Look at the cfsetting tag. The white space is caused by the cf tags taking up space but not appearing in the source code. --K -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 10:04 AM To: CF-Talk Subject: What's with all the space?

RE: outputting data in a matrix

2000-10-17 Thread Chapman, Katrina
No Prob. --K -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 10:55 AM To: CF-Talk Subject: RE: outputting data in a matrix This worked just great. Thank you. Richard Colman -Original Message- From: Chapman, Katrina [mailto

RE: Storing passwords in database as one way hash

2000-10-17 Thread Chapman, Katrina
The purpose is to keep people from peeking in the db and getting pw's they shouldn't have. Hash() works great. We used it on a project that I worked on before. Unfortunately you have to have CF Server 4.5.1 to use it the way that I believe it was intended. --K -Original Message-

RE: acess =

2000-10-16 Thread Chapman, Katrina
Yeah. Send the message again so that we don't have to spend time decoding your mime formatted message. --K -Original Message- From: wpdd [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 9:47 AM To: CF-Talk Subject: acess = This is a multi-part message in MIME format.

RE: Coldfusion FreeLance Work websites?

2000-10-16 Thread Chapman, Katrina
I think that Fred means fusioneers.com. Note the "s". Fusioneers not Fusioneer. Am I right Fred? --K -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 4:21 PM To: CF-Talk Subject: Re: FreeLance

RE: Weird CFLOCATION error

2000-10-13 Thread Chapman, Katrina
This is a known "feature". You cannot set a cookie and then cflocation in the same template. You need to use an alternate method of sending the user on to where you want them. --K -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 9:42 AM

RE: Allaire trips over itself - flame warning

2000-10-12 Thread Chapman, Katrina
Funny. I never seem to have a problem finding what I'm looking for on Allaire. Perhaps you're not using the correct search criteria. --K -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 9:24 AM To: CF-Talk Subject: Re: Allaire

RE: slightly ot: math question, needed for cold fusion programming

2000-10-12 Thread Chapman, Katrina
That would be 1/2592:1 or 3.85802e-4:1 or .000385802:1 That's the chance that two people will hit at the same exact millisecond. --K -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 11:33 AM To: CF-Talk Subject: RE: slightly ot: math

RE: slightly ot: math question, needed for cold fusion programming

2000-10-12 Thread Chapman, Katrina
: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 2:44 PM To: CF-Talk Subject: RE: slightly ot: math question, needed for cold fusion programming That would be 1/2592:1 or 3.85802e-4:1 or .000385802:1 That's the chance that two people will hit at the same exact

RE: Developer Directory?

2000-10-11 Thread Chapman, Katrina
Actually you're both wrong. The bill reads "Under the bill, California electronic mail service providers may publish a notice forbidding the use of their equipment to send or deliver spam. They may sue anyone who violates this for $50 per message up to $25,000 per day in which the spamming

RE: Developer Directory?

2000-10-11 Thread Chapman, Katrina
and they have stated that you wish to receive these types of mailings. Talk about a cf_loophole - Original Message - From: Chapman, Katrina [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 11, 2000 3:00 PM Subject: RE: Developer Directory? Actually

RE: Developer Directory?

2000-10-11 Thread Chapman, Katrina
The equipment has to be in CA. For the full text of the bill check this out. http://www.leginfo.ca.gov/pub/97-98/bill/asm/ab_1601-1650/ab_1629_bill_19980 928_chaptered.html -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 2:46 PM

RE: Developer Directory?

2000-10-11 Thread Chapman, Katrina
hould hold up anywhere in the Us under contract law. This is based on a rudimentary knowledge of contract law, and has, to my knowledge, not been tested. might be fun though On Wed, 11 Oct 2000, Chapman, Katrina spake thusly: Actually you're both wrong. The bill reads "

RE: Cookie Detector

2000-10-09 Thread Chapman, Katrina
I thought that you couldn't test for a cookie on the same page that sets it. Is this wrong? Because this: cfcookie name="test" value="test" expires="NEVER" cfoutput#IsDefined("cookie.test")#/cfoutput Generates a Yes. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [RE: CGI Referrer variable]

2000-10-09 Thread Chapman, Katrina
Yes. --K -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 4:58 PM To: CF-Talk Subject: RE: [RE: CGI Referrer variable] Does anybody know if it is possible for CGI.REMOTE_ADDR or CGI.REMOTE_HOST to be

FW: Undeliverable: RE: [RE: CGI Referrer variable]

2000-10-09 Thread Chapman, Katrina
message is: c=US;a= ;p=TAMPA;l=MOJO00100923004SNJTYCH MSEXCH:IMS:TAMPA:MOJO:MOJO 0 (000C05A6) Unknown Recipient - Message-ID: [EMAIL PROTECTED] From: "Chapman, Katrina" [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: [RE: CGI Referrer variable] Date: Mon,

RE: NOT A MATH QUESTION, NumberFormat

2000-10-05 Thread Chapman, Katrina
Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. ======== -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, O

RE: NOT A MATH QUESTION, NumberFormat

2000-10-05 Thread Chapman, Katrina
uot; means OK, and an "11," means incorrect date. It works from 1/1 to 12/3 or "1,1" to "12,31" OK, OK, I'll stop now! Hey K, you can go now and explain this to *your fellow* Jaime/ Jaime/ -----Original Message- From: Chapman, Katrina [ma

RE: #Timeformat(Now())#

2000-10-05 Thread Chapman, Katrina
It's not a typo. #TimeFormat(Now())# works, I get "01:22 PM". He just forgot his cfoutput's. --K -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 11:17 AM To: CF-Talk Subject: RE: #Timeformat(Now())# That's a typo in whatever

NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Chapman, Katrina
MM, Here's a question for y'all. It's not math. It's cf. What will cfoutput#NumberFormat("4,000")#/cfoutput give you? Try to answer before you test it. BB, --K --- Thank you, Katrina Chapman ColdFusion Web Developer System Development

RE: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Chapman, Katrina
Nope. -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 3:44 PM To: CF-Talk Subject: Re: NOT A MATH QUESTION, NumberFormat -4,000 Just guessing -Mark :o) - Original Message - From: Chapman, Katrina [EMAIL

RE: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Chapman, Katrina
i look now? - Original Message - From: Chapman, Katrina [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 04, 2000 3:59 PM Subject: RE: NOT A MATH QUESTION, NumberFormat Nope. -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]

RE: _date fields

2000-10-03 Thread Chapman, Katrina
I've had this problem using standard input tags. I even knew not to use it but forgot. Couldn't figure out why my start_date field wasn't being passed. Silly me. --K -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 3:55 PM To:

RE: JS does not work in Netscape but does in IE

2000-09-29 Thread Chapman, Katrina
function ValidateForm() { var valCurrentLoanInfo=document.Mailme.CurrentLoanInfo.value; var valNewMortinfo=document.Mailme.NewMortinfo.value; //validate required fields if ((valCurrentLoanInfo=="")(valNewMortinfo=="")) {

RE: JS does not work in Netscape but does in IE

2000-09-29 Thread Chapman, Katrina
I'm sorry I didn't realise till I sent this that I read your message backwards. --K -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 1:44 PM To: CF-Talk Subject: RE: JS does not work in Netscape but does in IE function

RE: sql question

2000-09-28 Thread Chapman, Katrina
You can't do it without one other row that has a UNIQUE identifier. --K -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 11:59 AM To: CF-Talk Subject: ot: sql question here's what i'm doing delete from class_registration

RE: What's wrong with this script?

2000-09-26 Thread Chapman, Katrina
English EspaƱol) 1 Producteur Producer Productor 2 Commercialisation Marketing ComercializaciĆ³n 3 Sous-traitant Subcontractor Thanks! - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Mond

RE: Cheap CF Hosting FOUND

2000-09-26 Thread Chapman, Katrina
You can use www.tio.com for $25 a month. I'm not sure about all the details but I know I have my own IP for both of my sites hosted there. I can adminstrate my own email accounts. I have full FTP access. Never had a problem connecting unless I forgot my password. And Adolph, the owner, is

RE: cfsqltype / StoredProc

2000-09-26 Thread Chapman, Katrina
MM Neil, BTW I forgot you need to make sure that the cfprocparam tags are in the same order as they are in the sp. BB, --K -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 1:30 PM To: CF-Talk Subject: cfsqltype / StoredProc If I

FW: Link that submits form

2000-09-25 Thread Chapman, Katrina
I tried posting this on Friday but it apparently didn't go through. So here it is again. FORM NAME="myform" A HREF="javascript:document.myform.submit()"IMG SRC="text1.gif" WIDTH="16" HEIGHT="16" BORDER="0"/A /FORM --K -Original Message- From: System Administrator Sent:

RE: Link that submits form

2000-09-25 Thread Chapman, Katrina
Add parentheses around the whole javascript function call. a href="javascript:(document.myform.submit());" -Original Message- From: Chapman, Katrina [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 1:47 PM To: CF-Talk Subject:FW: Link that su

RE: Law Suit

2000-09-25 Thread Chapman, Katrina
It soo silly. If you go to http://www.milberg.com/allaire/complaint.html And try to right click or make any keystroke while in the window you'll get a message that says: "This document may not be downloaded. It may be viewed by clicking on the scroll bar, on the right side of your screen.

RE: What's wrong with this script?

2000-09-25 Thread Chapman, Katrina
You need to remove the languages. Try This CFOUTPUT query="table" cfset ID = evaluate("#FORM.hid#ID") tr td class="txt9yellow"#ID#/td cfloop query="languages" cfset txt = evaluate("table.#FORM.hlang##Abrev#") td class="txt9yellow"#txt#/td /cfloop

RE: SQL Select Max + a column

2000-09-22 Thread Chapman, Katrina
How about SELECT TOP 1 ID_ENC_TOY_IMAGE, ENC_TOY_IMAGE_LINK_TEXT FROM ENC_TOY_IMAGE WHERE ID_ENC_TOY = #ID_ENC_TOY# ORDER BY ID_ENC_TOY_IMAGE DESC --K -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Friday, September 22, 2000

RE: Reason for Alliare Stocks

2000-09-22 Thread Chapman, Katrina
No offense but honestly this isn't the place for this kind of letter. You should be writing to Allaire directly about how upset you were with the service you received. Something will be done about it. Trust me I used to be in Customer Service, before CF of course, and if you screw up and

RE: Current Row in SQL as opposed to CF? [CF-Talk]

2000-09-21 Thread Chapman, Katrina
I spoke with our DBA and this is what he came up with. SELECT RowNo = 'Category ' + convert(varchar(10), (select count(*) from category c2 where c2.category_title = c1.category_title)),

RE: [CF-Talk] Random Images-Resources for Information?

2000-09-20 Thread Chapman, Katrina
This wouldn't really be random. It would ensure that the same number doesn't come up two times in a row, but that's not random. According to m-w.com random (as an adjective, which is how we're using it) is "being or relating to a set or to an element of a set each of whose elements has equal

RE: Strange behavior in cfmail message body: no hard returns [CF-Talk] [CF-Talk]

2000-09-20 Thread Chapman, Katrina
You can try CFMAIL FROM="[EMAIL PROTECTED]" TO="#FORM.email#" SUBJECT="Your submission#SpanExcluding(FORM.Name," ")# Thank you for submitting your information. Regards, Paul Sinclair - Your form was as follows - #Form.Comments##chr(10)# #Form.Name##chr(10)#

RE: [CF-Talk] Incorrect use of CFPARAM?

2000-09-19 Thread Chapman, Katrina
Can we see the template that has the query? --K -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, September 18, 2000 12:11 PM To: [EMAIL PROTECTED] Cc: Christopher S Martin Subject: Re: [CF-Talk] Incorrect use of CFPARAM? That's the way it should

RE: Newbie: Refreshing screen after update

2000-09-15 Thread Chapman, Katrina
You can also append a random number to the end of all of your urls a la CFSET foo= TimeFormat(Now(),'ss') (RAND()*1) cfoutput a href="http::/www.fusioneers.com/index.cfm?fuseaction=become_a_partnerfoo=#f oo#" /cfoutput --K -Original Message- From: Jason Green

FW: Comparing values in 2 queries

2000-09-14 Thread Chapman, Katrina
This is bad = #field_a#br /cfoutput The only prob with this is when either field has thousands of entries. --K -Original Message- From: Chapman, Katrina Sent: Thursday, September 14, 2000 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: Comparing values in 2 queries

RE: Comparing values in 2 queries

2000-09-14 Thread Chapman, Katrina
You're right this can be done with a simple query cfquery name="myQuery" datasource="foo" SELECT field_a FROM table WHERE field_a NOT IN (SELECT field_b FROM table) /cfquery cfoutput query="myQuery" This is bad = #field_a# -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent:

RE: Ok, What is Fusebox?

2000-09-13 Thread Chapman, Katrina
check out fusebox.org -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 11:48 AM To: [EMAIL PROTECTED] Subject: Ok, What is Fusebox? What is Fusebox? I keep hearing about it.

RE: Hah! I'm an idiot!

2000-09-12 Thread Chapman, Katrina
Sounds like a candidate for a verity search. Don't ask me how though cause I've never built one. Although I'm sure someone else on this list can help you. --K -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 6:25 AM To: '[EMAIL

RE: REGEX for everything but numbers

2000-09-11 Thread Chapman, Katrina
There's also ReReplaceNoCase(string, "[a-z]", "", "ALL") --K -Original Message- From: Justin Kidman [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 11:26 AM To: '[EMAIL PROTECTED]' Subject: RE: REGEX for everything but numbers Try [^[:digit:]] Justin Kidman

RE: REGEX for everything but numbers

2000-09-11 Thread Chapman, Katrina
whitespace and control characters. -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 14:24 To: [EMAIL PROTECTED] Subject: RE: REGEX for everything but numbers There's also ReReplaceNoCase(string, "[a-z]", "&

RE: Importing a text file

2000-09-08 Thread Chapman, Katrina
Like this #Replace("#f1_element#","Chr(34)"," ","ALL")# --K -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 12:05 PM To: [EMAIL PROTECTED] Subject: Importing a text file I have a file that I need to import that looks something like

RE: MS Access CFUPDATE question

2000-09-06 Thread Chapman, Katrina
No you can't insert data into categories.groupid UNLESS that value that you are inserting is in group.groupid. For example: +Group table ++Groupid ++group 1 fruits 2 veges 3 meats 4 breads +categories table ++groupid

RE: ODBC Date errors

2000-09-05 Thread Chapman, Katrina
The DaysInMonth function needs a date not just the month number but also the year. Try this. Good!! cfloop from=1 to="12" index="ii" cfoutputcfset byyear = "2000" cfset bymonth = ii CFSET Today = CreateODBCDate(CreateDate(ByYear, ByMonth, 1)) CFSET EndDay = CreateODBCDate(CreateDate(ByYear,

RE: Rounding to the nearest nickel?

2000-08-30 Thread Chapman, Katrina
This would round to the nearest penny. It should b CFSET yourNumber = ROUND(yourNumber * 20)/20 --K -Original Message- From: !jeff! [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 5:22 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Rounding to the nearest nickel?

RE: Can't work out IIF/IsDefined quirk

2000-08-29 Thread Chapman, Katrina
Paul, You're right you can use IsDefined in an IIf. I do it all the time. BTW you should probably also trim the form.fieldname. IE: Cfif IIF(IsDefined("form.fieldname"), "Trim(form.fieldname)", DE("")) is "something" The form fieldname equals something. /cfif Bud, From the docs. "The

RE: Query Help - Using 'GROUP'

2000-08-29 Thread Chapman, Katrina
that's all good except the r. It should be table tr thAgent/th thTerritories/th /tr cfoutput query="r" group="agentid" tr td#firstname# #lastname#/td tdcfoutput#territory#,/cfoutput/td /tr /cfoutput /table --K -Original Message- From: Jim McAtee

RE: IsDefined help

2000-08-29 Thread Chapman, Katrina
Try cfif IIF(IsDefined("form.name"), "trim(form.name)", "de("")) is "" You forgot your name. /cfif -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 7:33 PM To: [EMAIL PROTECTED] Subject: IsDefined help This is a multi-part

RE: IsDefined help

2000-08-29 Thread Chapman, Katrina
That only works however if the user hasn't turned off JavaScript. --K -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 8:00 PM To: '[EMAIL PROTECTED]' Subject: RE: IsDefined help If you use "CFFORM" with "CFINPUT" you can ensure that

RE: Sorting Query results

2000-08-28 Thread Chapman, Katrina
You need to add an order by clause to your SQL statement, and order by company name. --K -Original Message- From: Lisa Hamlin [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 11:39 AM To: [EMAIL PROTECTED] Subject: Sorting Query results This is a multi-part message in MIME

RE: IsDefined() Problem

2000-08-24 Thread Chapman, Katrina
The reason you don't put quotes in most of the other functions is because you want those functions to work with the value of the variable. This one you just want it to make sure that exists. If you don't put the "'s and the parameter isn't defined you'll get an error. --K -Original

RE: How do I get my Current URL

2000-08-24 Thread Chapman, Katrina
Don't know of one off the top of my head but you could build it using three CGI variables. Server_name, Script_name, and query_string Just concatenate those in that order and you'll have it. --K -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Thursday, August

RE: Concatenate Strings

2000-08-24 Thread Chapman, Katrina
cfset string3 = string1 string2 If your strings aren't variables cfset string3 = "hello" "world" --K -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:57 AM To: '[EMAIL PROTECTED]' Subject: Concatenate Strings How can I concatenate

RE: Division in Cold Fusion?

2000-08-23 Thread Chapman, Katrina
Just like you did but you're using the wrong slash it should be. CFSET MYVAL = thisval / thatval BTW you also don't need #'s in set's unless the variable name is in ""'s. HTH, --K -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 11:33

RE: Newbie Cold Fusion Studio Question

2000-08-23 Thread Chapman, Katrina
"I am not running Cold Fusion Server but am using the Microsoft Personal Server for Windows 95." There's your problem You can't expect CF templates to process as CF unless you have the server. --K -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent:

RE: How can I get around this?

2000-08-23 Thread Chapman, Katrina
You can reload the left hand nav bar after the user logs in to include that value on that particular link. --K -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 12:00 PM To: [EMAIL PROTECTED] Subject: How can I get around this? Hi All,

RE: Select Query

2000-08-23 Thread Chapman, Katrina
That's almost it you need to add %'s around the string passed. IE cfquery name="doclist" datasource="custdoc" dbtype="ODBC" SELECT * FROM Customerdoclist WHERE (Customerdoclist.keywords LIKE '%#url.page#%') /cfquery -Original

RE: nested cfoutput

2000-08-22 Thread Chapman, Katrina
That's not entirely true. You can do a plain vanilla cfoutput inside of a grouped query driven output. What are you trying to do. --K -Original Message- From: Dana Larose [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 3:29 PM To: [EMAIL PROTECTED] Subject: RE: nested

custom functions

2000-08-21 Thread Chapman, Katrina
Was the article on custom functions ever published on FusionAuthority? If so where is it? I can't seem to find it. Then again I can't open a bag of cookies without scissor's but that's something else entirely. --K Thank you, Katrina Chapman ColdFusion Web Developer Systems Development

RE: CF's Redheaded Stepchild

2000-08-18 Thread Chapman, Katrina
The "redheaded stepchild" is a joke. --K -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Friday, August 18, 2000 9:24 AM To: [EMAIL PROTECTED] Subject: Re: CF's Redheaded Stepchild Not sure what you mean by "Redheaded Stepchild". It just looks to me like they're

RE: Query a Query

2000-08-17 Thread Chapman, Katrina
A [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 6:22 AM To: [EMAIL PROTECTED] Subject: RE: Query a Query You are correct. Jim Ray -Original Message----- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 1:50 PM To: [EMAIL PROTECTED] Subject:

RE: SQL query problem...

2000-08-17 Thread Chapman, Katrina
What's a TB303? --K -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 10:57 AM To: [EMAIL PROTECTED] Subject: RE: SQL query problem... OK, this is probably wrong, but its all I can glean from SQL BOL ALTER TABLE table_name NOCHECK

RE: Query a Query

2000-08-16 Thread Chapman, Katrina
Andy, Why can't you combine where clauses when they reference two seperate tables? I'm also curious as to why you think they reference two tables? Jim, You can use the second query provided by Chad and it should work. --K -Original Message- From: Andy Ewings [mailto:[EMAIL

RE: Ben Forta's Quick Store Application

2000-08-16 Thread Chapman, Katrina
Can we see the code and the exact error message? Also have you tried putting the template not in the C:\CFUSION\CustomTags directory but in the directory that you're calling it from? --K -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000

RE: Ben Forta's Quick Store Application

2000-08-16 Thread Chapman, Katrina
Sorry I can't help you there. I haven't looked at that application. --K -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 9:52 AM To: [EMAIL PROTECTED] Subject: RE: Ben Forta's Quick Store Application Actually i got Ben Fortas application

RE: replace function

2000-08-16 Thread Chapman, Katrina
Look at cf_highlight in the tag gallery. --K -Original Message- From: Eli Shechter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 11:08 AM To: [EMAIL PROTECTED] Subject: replace function Hi i am using the replace function with a search interface, that when the results

RE: Query a Query

2000-08-16 Thread Chapman, Katrina
I assume you are trying to do a previous/next function. Am I right? --K -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 1:42 PM To: [EMAIL PROTECTED] Subject: RE: Query a Query Here is some more background. Here is what I need to do.

RE: session.basket URL

2000-08-14 Thread Chapman, Katrina
Actually Paul it's when you don't specify "addtoken="no"" If you just have cflocation url="foo.htm" you'll get the cfid and cftoken in the URL. If you cflocation url="foo.htm" addtoken="no" You won't. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: Help with SQL

2000-08-14 Thread Chapman, Katrina
You use the SQL DatePart function select DatePart(mm, columnname) as month from foo --K -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Help with SQL I have a date and time field in the

RE: session.basket URL

2000-08-14 Thread Chapman, Katrina
Well then can we see the offending code? Both the posting page and the processing pages please. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:57 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL Well, there's no

RE: CSv

2000-08-11 Thread Chapman, Katrina
Comma Separated Values. --K -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 9:18 AM To: [EMAIL PROTECTED] Subject: CSv what is a csv file? -- Archives:

RE: Select Distinct not so distinct

2000-08-11 Thread Chapman, Katrina
The problem with select distinct is if you're select more than one column at a time. It will return distinct ROWS. Not just the one column you specify. --K -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:48 AM To: [EMAIL PROTECTED]

RE: Database problems

2000-08-11 Thread Chapman, Katrina
Try This. cftransaction cfquery datasource="county" insert into LINKS (APPROVE, TYPE_DESC, MAIN_NBR, LINK) values ('#form.APPROVE#', '#form.TYPE_DESC#', '#form.MAIN_NBR#', '#form.LINK#') /cfquery cfquery

RE:

2000-08-10 Thread Chapman, Katrina
Let's not get pissy Adam. Sree, It should work. IT should be exaclty like this CFHTTP URL="http://www.amazon.com" METHOD="GET" RESOLVEURL=YES /CFHTTP CFOUTPUT PYour file was of type: #CFHTTP.MimeType# P#HTMLCodeFormat(CFHTTP.FileContent)# /CFOUTPUT I ran it

RE: Comma/Number Problem

2000-08-10 Thread Chapman, Katrina
No offense to you Shawn but with new people, which he obvioulsy is as he doesn't know about replace, you should probably explain what this does instead of just supplying it. --K -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:51 PM To:

RE: Comma/Number Problem

2000-08-10 Thread Chapman, Katrina
ntrolled source where you know the only issue will be commas, Don's replace will do ya just fine. If there's a chance you might face other non-numeric characters (currency symbols, etc.), the rereplace would be more appropriate. Right tool for the job and all that. HTH, Sean G. -Original

RE: Multiple value Select

2000-08-09 Thread Chapman, Katrina
August 08, 2000 21:36 Subject: RE: Multiple value Select No. That field would have multiple items in a comma-delimited format. = Not=20 even the first option is selected.=20 Athelene=20 -Original Message-=20 From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]=20 Sent: Tu

  1   2   >