RE: form fields not being passed on the action page

2001-08-16 Thread Howarth, Craig (IBK-NY)
Is it possible that the action page is being called directly -- i.e. not being posted. For instance, if someone has bookmarked the action page this error might occur if publish is the first form variable referenced. Craig -Original Message- From: Peter Fralin [SMTP:[EMAIL

RE: CFSET error because of character

2001-07-19 Thread Howarth, Craig (IBK-NY)
Do this: CFSET dot =tr width=#chr(34)#190#chr(34)#td/td/tr or this CFSET dot ='tr width=190td/td/tr' chr() returns the character represented by the passed ASCII value. 34 is a double quote. For a list of ASCII values see http://www.asciitable.com/ -Original Message- From: nyon

RE: Column names containing a # sign

2001-07-10 Thread Howarth, Craig (IBK-NY)
Two solutions: 1) Try escaping the names, as in Product##, in the CFQUERY and use a alias CFQUERY ... SELECT Product## AS ProductNum FROM whatever /CFQUERY 2) Create a view on your database server that assigns an alias to each offending column.

RE: Barcode generation

2001-06-15 Thread Howarth, Craig (IBK-NY)
Here is a list of resources for you: http://www.adams1.com/pub/russadam/webapps.html You're sure to find something here that will help you out. Craig -Original Message- From: stas [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 9:44 AM To: CF-Talk Subject: Barcode

RE: OT SQL Server (OK 1 More ?)

2001-06-13 Thread Howarth, Craig (IBK-NY)
No, the 4 refers to 4 bytes required to store the value, not the number of characters in the value. The range that can be stored in an int is -2^31 to 2^31-1. Craig -Original Message- From: ibtoad [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:32 PM To: CF-Talk

RE: Image resizing question

2001-06-06 Thread Howarth, Craig (IBK-NY)
Eron, I resize on the X axis only and let the Y fall where it will -- I'm more concerned about the width than the height on my sites. This retains the aspect ratio and retains image quality. If you try to force the image into a ratio that differs from the original, you will have distortion.

RE: What's with this?

2001-06-01 Thread Howarth, Craig (IBK-NY)
No bug. daysInMonth() takes a full date as a parameter -- not the month. If you say daysInMonth(now()), it will work as expected. Craig -Original Message- From: Norman Elton [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:33 AM To: CF-Talk Subject: RE: What's with

RE: Best way to clear Cached Queries?

2001-06-01 Thread Howarth, Craig (IBK-NY)
I've used two methods. 1) Use a variable in the CreateTimeSpan which holds the number of minutes or hours that you want the cache to last. To force the query to execute, change this variable to 0, hit the page, and then restore the variable back to the proper value. 2) Add the following code

RE: Using IE5 HTTP com object

2001-05-29 Thread Howarth, Craig (IBK-NY)
I use this all the time for intranet development. It is really useful for client-side validation and dynamic page building. For validation, use the object to post values to a page and then wait for the results. In one application, I use this to validate state/country/postal code

RE: Attributes Scoped Structure?

2001-05-24 Thread Howarth, Craig (IBK-NY)
Brad, The attributes scope can only be used within a custom tag. This is the error message that you get when you attempt to assign a value to the attributes scope in a normal template. Craig -Original Message- From: Brad Roberts [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24,

RE: Attributes Scoped Structure?

2001-05-24 Thread Howarth, Craig (IBK-NY)
]] Sent: Thursday, May 24, 2001 11:58 AM To: CF-Talk Subject: Re: Attributes Scoped Structure? That's not true. Fusebox uses nothing but Attributes scoped variables. You can set Attributes variables anywhere. - Original Message - From: Howarth, Craig (IBK-NY) [EMAIL PROTECTED

RE: Count check boxes?

2001-05-23 Thread Howarth, Craig (IBK-NY)
Change the form like so: CFOUTPUT QUERY=MetList TR TDINPUT TYPE=checkbox NAME=MetCheck VALUE=#Met_ID#/TD TD#Met_ID#/TD TD#FirstName# #LastName#/TD

RE: Missing Line Numbers

2001-05-21 Thread Howarth, Craig (IBK-NY)
Do you see the gray bar on the left? If not, that means that you have the gutter toggled off. Press the button above the line number toggle to turn the gutter back on. Craig -Original Message- From: Jay Jennings [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:35 PM To:

RE: finding special characters in a list

2001-05-15 Thread Howarth, Craig (IBK-NY)
You have them reversed. Try cfset errorText = Find(Chr(13) Chr(10), mylist). -Original Message- From: Stephenie Hamilton [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:28 AM To: CF-Talk Subject: RE: finding special characters in a list this doesn't seem to work,

RE: Code Snippet:Random Password Generator(repost)

2001-05-10 Thread Howarth, Craig (IBK-NY)
Seems unlikely, but it does generate some great words like teethuku and taafduno and the unforgettable fuoflyru. Fun script. -Original Message- From: Erika L Walker [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:19 PM To: CF-Talk Subject: RE: Code Snippet:Random

RE: WingDings

2001-05-10 Thread Howarth, Craig (IBK-NY)
Roll your own: cfoutput cfloop index=i from=0 to=255 #i# - span style=font-family: wingdings#chr(i)#/spanbr /cfloop /cfoutput -Original Message- From: Andrew Peterson [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:35 PM To: CF-Talk Subject: OT: WingDings

RE: Highlighting Text

2001-05-09 Thread Howarth, Craig (IBK-NY)
Save the following as a tag and place all of your content between the open and end tags. For example, if your tag was called CF_Highlight: cfset variables.foo = This is a sales test cf_highlight text=sales This is a test of the sales system. cfoutput#variables.foo#/cfoutput

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Howarth, Craig (IBK-NY)
Is note a reserved word in Access? Try [note] = 'dr'. Craig -Original Message- From: Jason Lees (National Express) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you

RE: Row Color

2001-04-26 Thread Howarth, Craig (IBK-NY)
I do something like this... Define a couple of styles for even and odd rows: style type=text/css .evenRow { background-color: #99 } .oddRow { background-color: #cc99ff } /style Then when running the query, figure out

RE: Character code for a TAB

2001-04-24 Thread Howarth, Craig (IBK-NY)
You have no VALUE attribute on the default option. -Original Message- From: Marc Garrett [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 9:48 AM To: CF-Talk Subject: Re: Character code for a TAB Michael Lugassy wrote: I JUST LOVE IT WHEN 1203483409875 PEOPLE

RE: Oh that's just great.

2001-04-23 Thread Howarth, Craig (IBK-NY)
Someone posted this a while back. So useful that it is now a permanent CF Studio snippet. It doesn't lock, so it should only be used while debugging. CFLOOP LIST=application,session,request,form,url,attributes,cgi INDEX=struct CFOUTPUT B#ucase(struct)#:/BBR CFIF

RE: make the select menu a must select

2001-04-18 Thread Howarth, Craig (IBK-NY)
You have two options with this code: 1) Remove the option value="0"/option default value. That way a valid value will always be selected. 2) Change the test in the JS function to if (theform.member_role.selectedindex != 0), since the first item has an index of 0, not -1. The

RE: excluding application.cfm from one template

2001-04-09 Thread Howarth, Craig (IBK-NY)
Two ways that I can think of: 1) Put the template in seperate directory from the rest of your site and place an empty application.cfm in the same directory. 2) In the application.cfm check the value of cgi.path_info for the name of the template and skip the bits you don't want to execute.

RE: syntactically valid variables?

2001-04-06 Thread Howarth, Craig (IBK-NY)
Remove the forward slash from the variable name. -Original Message- From: Toivonen, Nicole [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 10:11 AM To: CF-Talk Subject: syntactically valid variables? Hi there, I'm getting the error below when attempting to

RE: Order By being ignored

2001-04-04 Thread Howarth, Craig (IBK-NY)
What is the data type of the times column? Can you post a few rows of sample data from the times column showing the randomness that you described. -Original Message- From: W Luke [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:45 PM To: CF-Talk Subject: "Order

RE: CFHTMLHEAD

2001-03-27 Thread Howarth, Craig (IBK-NY)
Use single quotes in the alert() or use a custom tag to implement CFHTMLHEAD the way it should have been done: cfif thistag.ExecutionMode IS "end" cfhtmlhead text="#thistag.GeneratedContent#" cfset thistag.GeneratedContent = "" /cfif Save this in a file called htmlhead.cfm and

RE: To ASP or not to ASP

2001-03-21 Thread Howarth, Craig (IBK-NY)
I first developed web apps in ASP but soon discovered CF. But I was one of those who came from a programming background -- 10+ years in VB, C, RPG, and COBOL. I gladly embraced CF for something that none of these other languages offer: simplicity and speed of development. Having coded CF

RE: query result to list

2001-03-21 Thread Howarth, Craig (IBK-NY)
valueList(getOptinfo.Name) -Original Message- From: Ethan Rosch [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 10:47 AM To: CF-Talk Subject: query result to list Hi all, what's the easiest way to get the outut of a query into a list? ex. CFQUERY

RE: Need assistance:Nested CFLOOPs

2001-03-21 Thread Howarth, Craig (IBK-NY)
This line is the problem: CFSET WordToGet=ListGetAt(#CompanyList#,#counter#,",") counter contains the value of the current item in the list, not a numeric position. So listGetAt() won't work as expected as it requires a numeric value in the second position. The

RE: QUERY TROUBLE

2001-03-20 Thread Howarth, Craig (IBK-NY)
Try this: I have added an additional column which test for the value of RMOTown and outputs a 0 if it matches otherwise a 1. The same column is added to the order by. This should work in Access. cfquery name="get_cluster" datasource="#DS_1#" dbtype="ODBC" SELECT T.RMOTown,

RE: Code review, PLEASE

2001-03-19 Thread Howarth, Craig (IBK-NY)
selectcandidate is the name of your query, to resolve the expression you need to indicate a column name. do you really want: input type="hidden" name="id" value="#selectcandidate.id# which will store the ID column of the query as a hidden form field. Craig -Original Message- From:

RE: Cold fusion has top line blank.......

2001-03-15 Thread Howarth, Craig (IBK-NY)
Do you have an application.cfm file? This is always processed before your template, so it may be adding extra blank space. Craig -Original Message- From: Richard Kuryk [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 4:11 PM To: CF-Talk Subject: Cold fusion has top

RE: Evaluate/De problem

2001-03-14 Thread Howarth, Craig (IBK-NY)
Try this: CFSET CategoryIDList = Evaluate("Valuelist(GetCategory#url.id#.Category_ID)") Craig -Original Message- From: Duane Boudreau [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 10:43 AM To: CF-Talk Subject: Evaluate/De problem I have a query that is

RE: Testing for NULL in stored procedures

2001-03-08 Thread Howarth, Craig (IBK-NY)
Try IS NOT NULL Craig -Original Message- From: sebastian palmigiani [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 10:49 AM To: CF-Talk Subject: Testing for NULL in stored procedures I am working on a poll which allows multiple selections. How do I get this

RE: Form submit new window

2001-03-07 Thread Howarth, Craig (IBK-NY)
Try this: form action="test.cfm" method="post" target="newTest" onsubmit="window.open('','newTest','width=200,height=400')" The name given to the new window must match the name specified in target. Craig -Original Message- From: Lee Surma [SMTP:[EMAIL PROTECTED]] Sent: Wednesday,

RE: Text box not wrapping

2001-03-07 Thread Howarth, Craig (IBK-NY)
If you specify wrap="hard" in the textarea tag, you must either convert the CR/LF using replace or ParagraphFormat() or use PRE to preserve the CR/LF as they are. If you are using PRE already, then perhaps you have not specified wrap="hard" on textarea. Craig -Original Message-

RE: NULLs

2001-03-01 Thread Howarth, Craig (IBK-NY)
How do I go about doing this? If you have a form field that is blank, you can do this: CFQUERY INSERT INTO foo (name,age,zip) VALUES ( '#form.name#', CFIF trim(form.age) is "" NULL,

RE: Removing Duplicate Values in a List

2001-02-27 Thread Howarth, Craig (IBK-NY)
Jason, In order for the DISTINCT keyword to work, the query must be ordered. This query should work: cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT DISTINCT Keywords FROMPhotos ORDER BY

RE: Two functions with a single onClick?

2001-02-22 Thread Howarth, Craig (IBK-NY)
Simply seperate the two function calls with a semicolon, as in onClick="alert('hi'); alert('bye');". Or write one function that calls the two functions. Craig -Original Message- From: Les Irvin [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 11:16 PM To: CF-Talk

RE: Ben Forta's (?) article on using # signs...

2001-02-22 Thread Howarth, Craig (IBK-NY)
http://www.defusion.com/articles/index.cfm?ArticleID=26 -Original Message- From: Aidan Whitehall [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 5:10 AM To: CF-Talk Subject: Ben Forta's (?) article on using # signs... Does anyone have a link to an article

RE: Interesting Java/CF Article

2001-02-22 Thread Howarth, Craig (IBK-NY)
Here is another article on tagFusion. Looks interesting. http://www.cfadvisor.com/api-shl/engine.cfm?ArticleID=34106DepartmentID=1 -Original Message- From: Lee Surma [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:44 AM To: CF-Talk Subject: Interesting Java/CF

RE: cfassociate

2001-02-22 Thread Howarth, Craig (IBK-NY)
In your parent tag, you reference the subtag structure with the thisTag scope. So, you need to reference mystruct as thisTag.mystruct. Craig -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 2:14 PM To: CF-Talk Subject:

RE: Returning a variable with a custom tag

2001-02-21 Thread Howarth, Craig (IBK-NY)
Your code didn't come through, but based on your description I would guess that you are refering to the variable in your calling template as "caller.output" when, in fact, it is "variables.output". The caller scope refers to the variables scope in the calling template while executing the tag.