Re: VTM Files

2001-11-23 Thread Bryan LaPlante

There is an online wizard that will create the vtm file and the default
template for your custom tag and then email you the resulting files.
http://www.netwebapps.com/mytags/main.cfm

You can play around with it and get a feel for how vtm files are written.
The final page will allow you to pick a type of control for each of your
entries as well as adding in the standard event and style sheet tabs that
are used with the tag editors that come with studio/homesite.

Bryan LaPlante

- Original Message -
From: Steve Reich [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 7:26 PM
Subject: VTM Files


Does anyone know of any online resources for writing .vtm files?
Specifically, I'm looking for a way to have a color picker popup for the
user to select a color.

Thanks,
Steve


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Breaking up cfoutput

2001-10-03 Thread Bryan LaPlante

Sound like you are looking for the group attribute of the cfoutput tag. Here
is a snippet from the help file.

GROUP
Optional. Specifies the query column to use when you group sets of records
together. Use this attribute if you have retrieved a record set ordered on a
certain query column. For example, if you have a record set that is ordered
according to Customer_ID in the CFQUERY tag, you can group the output on
Customer_ID. The GROUP attribute, which is case sensitive, eliminates
adjacent duplicates in the case where the data is sorted by the specified
field. See the GROUPCASESENSITIVE attribute for information about specifying
a case insensitive grouping.

- Original Message -
From: W Luke [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 03, 2001 6:21 AM
Subject: Breaking up cfoutput


Hi,

I need to break up a Cfoutput query=... somehow - I have no idea whether
or not this is possible.

Here's the query:

cfquery name=fad datasource=#db1#
SELECT * FROM advert_details
WHERE town = '#url.thetown#'
OR (natpaid = Yes AND nationwide = Yes)
ORDER by town, start_date, nationwide
/cfquery

Now, say 10 records are found whose .natpaid and .nationwide both equal No.
And 4 are found whose natpaid and nationwide equal Yes, making 14 results.
When outputting the results, I ideally want to alternate and have one result
shown where natpaid AND nationwide = No, and then one where natpaid AND
nationwide = Yes...and so on.

I've seen this work before, I think, where sites include commercial
advertising mid-output on a search query.

Fantasy or a possibility?

Cheers

Will

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: JS tag keyboard shortcut

2001-10-03 Thread Bryan LaPlante

are you talking about code templates. Press F8 and expand the editor section
to see the code templates section and you will see at the bottom of the
dialog where it says [ctrl + j] is the keyboard short-cut that invokes the
code template.

Bryan LaPlante

- Original Message -
From: Tristram Charnley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 03, 2001 3:58 AM
Subject: JS tag keyboard shortcut


I've forgotten the keyboard shortcut in Studio
for inserting a Javascript opening/closing tag.

Can anyone remind me?

Tristram Charnley


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SELECT

2001-09-30 Thread Bryan LaPlante

I imagine you are pulling your list from a database and using the query of a
cfoutput, just add this code to it.
select
cfoutput query=mybooknames
cfif name is form.namecfset selected = selectedcfelsecfset selected
= /cfif
option value=#name# #selected##name#/option
/cfoutput
/select
there is a way to do it in one line with iif() but I can't remember that one
right off.

Bryan

- Original Message -
From: Tony Hicks [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, September 30, 2001 5:00 AM
Subject: SELECT


Hey Guys...

I have a problem, my site, www.bibleclicks.com has one request from people
that send me feedback.. they want me to set it so that when a user selects a
book and searches, the book remains selected on the next page.. the problem
comes in here:

It would take about 75 cfif tags to do it and some of them would be long..
my host is generous with bandwidth but.. I'm smart, I don't want to push the
limits.. is there an easy way to do this?

Thanks,
Tony Hicks


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF path question...

2001-09-16 Thread Bryan LaPlante

getDirectoryFromPath(script_name) should give you what you want.

Bryan LaPlante

- Original Message - 
From: Paris Lundis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, September 16, 2001 3:37 PM
Subject: CF path question...


I have one of these unique issues that presents itself...

Eseentially to solve such I need to rip out the current server_name and 
another value which is the directory location where the ccurent files 
is located on the CF server...

I know of Script_name - howeve it includes the file as well ... could 
parse it, however.

Also aware of PATH_INFO but it has the same problem...

Is there another CGI or CF feature that will just give me the path 
minus the filename?

I am certain many people have had to work around this if not... How 
have you gone about such?

-paris

[finding the future in the past, passing the future in the present]
[connecting people, places and things]


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Prepared statements

2001-08-30 Thread Bryan LaPlante

I have two questions. When you set up a dsn in the CF there is a check box
that says Create stored procedures for prepared statements. Do I need to
check that box to get cfquery's to work that include cfqueryparam's? Second
question, if it does create a stored proc for my query would I just continue
to run the query with the cfqueryparam or would I need to run it as a stored
procedure?

Bryan LaPlante
President
Network Web Applications Inc.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Looping through a CFfile upload

2001-08-22 Thread Bryan LaPlante

cfloop index=file list=#form.fieldnames# delimiters=,
cfif file is not submit
 cffile action=UPLOAD
filefield=#file#
destination=c:\destination\
nameconflict=MAKEUNIQUE
/cfif
/cfloop

- Original Message -
From: Brent Goldman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 4:58 PM
Subject: RE: Looping through a CFfile upload


Hi,

If you upload multiple files, you have to use multiple FILE form fields.  If
you have multiple form fields, then you just need to access them how you
would access any form field.

-Brent

-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 5:45 AM
To: CF-Talk
Subject: Looping through a CFfile upload


Has anyone had call to allow multiple file uploads from a single form submit
and if so how did you approach it?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ava script

2001-08-17 Thread Bryan LaPlante

In IE the form tag can have a property of autocomplete set to false and the
form elements won't do that.

Bryan

- Original Message -
From: Andy Ewings [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 6:50 AM
Subject: ava script


| OK another Javascript teaser.
|
| I have written a function which changes the value in text box 2 when the
| value text box 1 changes.  I call this function in the onchange event of
| text box 1.  By definition of the onchange event this function should run
if
| and only if the value in text box 1 is different when focus is lost to
when
| focus was gained.  When I enter the form the value in text box 1 is blank.
| I start to type in something and IE recognises that what I am trying to
type
| in I've entered before (much like when you attempt to go to a URL that is
in
| the browser history).  I select the entry from the drop down list I get
and
| hit tab to tab off the text box.  When I do this the function is not
called.
| However when I do not select it from the drop down list and type it in
| manually it does call the function!does anyone know why this is
| happening and what I can do to stop the browser trying to predict what I'm
| typing in ?
|
| --
| Andrew Ewings
| Project Manager
| Thoughtbubble Ltd
| http://www.thoughtbubble.net
| --
| United Kingdom
| http://www.thoughtbubble.co.uk/
| Tel: +44 (0) 20 7387 8890
| --
| New Zealand
| http://www.thoughtbubble.co.nz/
| Tel: +64 (0) 9 488 9131
| --
| The information in this email and in any attachments is confidential and
| intended solely for the attention and use of the named addressee(s). Any
| views or opinions presented are solely those of the author and do not
| necessarily represent those of Thoughtbubble. This information may be
| subject to legal, professional or other privilege and further distribution
| of it is strictly prohibited without our authority. If you are not the
| intended recipient, you are not authorised to disclose, copy, distribute,
or
| retain this message. Please notify us on +44 (0)207 387 8890.
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: UDF best practices

2001-08-09 Thread Bryan LaPlante

I am getting pretty good results with saving my udf's in the session scope.
see the tutorial at
http://www.kcfusion.org/Presentations/cflp.zip

Bryan

- Original Message -
From: Correa, Orlando (ITSC) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 08, 2001 9:02 PM
Subject: RE: UDF best practices


| If I have a page request that calls several templates during the
| request...
|
| For Example:
|
| + application.cfm
|   + myUDF.cfm
| + index.cfm
|   + cfinclude template1.cfm
|   + cfmodule template2.cfm
|
| Should I be able to include myUDF.cfm in the application.cfm file and it
| will be available to index.cfm, template1.cfm, and template2.cfm as
myUDF()?
| Currently I'm getting Error resolving parameter myUDF with this setup
when
| calling it from template2.cfm...
|
| If I set server.myUDF = myUDF() in application.cfm I get an The number of
| arguments passed to a user-defined function cannot be less than the number
| of parameters in its definition. This call to myUDF passes 0 arguments,
but
| 2 parameters are defined..  So when I pass in two dummy variables
| server.myUDF = myUDF('x','x') I get an The symbol you have provided
| (server.myUDF) is not the name of a function. in the calling page...
Would
| I need to make the arguments non-required to make this work properly...
|
| In this particular case, I'm running this in a hosted environment, so I
| don't have access to put them in the /cfide/udf/ folder.
|
| Any insight would be appreciated...
|
| Orlando
|
| -Original Message-
| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, August 08, 2001 11:40 AM
| To: CF-Talk
| Subject: RE: UDF best practices
|
|
| You could but what about re-usability outside the application. This is the
| reason for the CFINCLUDE of the UDF. There's nothing stopping you from
just
| putting a UDF in the application.cfm or anywhere on a template. Only
| limitation is that a UDF used as part of a CFINCLUDE must be defined
before
| it's to be used where a page based one can be anywhere on the page (even
| after the UDF call).
|
| At 12:59 PM 8/8/01, you wrote:
| Couldn't you just put them in the application.cfm for your application??
| 
| -Original Message-
| From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
| Sent: 08 August 2001 15:11
| To: CF-Talk
| Subject: Re: UDF best practices
| 
| 
| 1. In the admin set the server variables to auto-lock
| 2. run the template containing the UDFs before the application runs or on
| machine startup.
| 3. Set a CFLOCK with a scope of server
| 4. Set each UDF to a variable in the scope server
|   CFSET Server.Test=Test()
| 5. Call the UDF on any page without using a CFINCLUDE of it
|   CFSET name=Server.Test('michael')
| 
| This is slightly slower than having the UDFs in a CFINCLUDE that's
included
| into the page. It's a better practice to do the following:
| 
| 1. Create a small library of UDF's in a template (i.e. all data
validation
| in one file and all text manipulation in another).
| 2. Save these UDF library templates in the CFIDE/UDF directory.
| 3. Use a CFINCLUDE Template=/cfide/udf/text.cfm in the template you
| want to use UDFs in.
| 
| 
| At 08:59 AM 8/8/01, you wrote:
| 
|  Anyone know what's the best way to set a UDF as a global function for
use
| by
|  all tags (custom, includes, etc.)... or does one in fact have to
include
| the
|  function code locally in each file that's being called during a page
|  request?
|  
|  Thanks,
|  Orlando
|  
|  
| 
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Verity index problems

2001-08-05 Thread Bryan LaPlante

Try action=Purge first before you update.

Bryan LaPlante

- Original Message -
From: Carlo van Wyk [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, August 05, 2001 1:50 PM
Subject: Verity index problems


| Whenever I update my verity index after adding files, the index is
updated.
| However, whenever I update the verity after deleting files from the
indexed
| directory, it seems as if the index is not updated. I still get search
| results from files that is already deleted.
|
| The code I use to update my index is included. Please advise.
|
| CFSET IndexCollection = coldfusion
| CFSET IndexDirectory = c:\development\coldfusion\
| CFSET IndexRecurse = YES
| CFSET IndexExtensions = .pdf, .doc, .htm, .html, .txt, .cfm, .html,
.asp
| CFSET IndexLanguage = english
|
| cfindex action=update
|  collection=#IndexCollection#
|  key=#IndexDirectory#
|  type=PATH
|  extensions=#IndexExtensions#
|  recurse=Yes
|
| Regards
| Carlo
| FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
|


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFScript?

2001-07-22 Thread Bryan LaPlante

I am trying to create a custom tag for CF5 that will find functions in the
body of the tag and run them dynamically. The end result of the tag will be
saving or caching those user defined functions into the variable scope of my
choice. This much of the tag I have working properly. I don't know if there
is any way from inside a custom tag to dynamically run content inside of
cfscript tags like so.

CFSCRITP
thistag.generatedContent;
/CFSCRIPT

Any idea's on how I could accomplish this. The tag looks like this in the
calling template

CF_FunctionCache Scope=Application
function myFunction(){
// do stuff
}
/CF_FunctionCache


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFX and the caller scope?

2001-07-22 Thread Bryan LaPlante

I wish I had more information about how the request.class was written in the
cfx.jar file. I would like to write my own support for the pageContext()
into it. It would be nice at the very least to have support for session,
application, request and caller scope. As usual I want something that the
application is not supposed to do, or is it?

- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 12:02 AM
Subject: RE: CFX and the caller scope?


|  I have a lot of cfml custom tags and I am learning to write
|  them in Java. I have looked in the cf-talk and cfx-talk archives
|  as well as all the Allaire doc's I could find and searched via
|  google finding no information about interacting with the different
|  scopes of the calling template.
| 
|  Is it possible to communicate with the different scopes, session,
|  application, caller and so on?
|
| No, it's not, unfortunately. If I recall correctly, you can pass in string
| attributes, and your custom tag can manipulate query objects, and that's
it.
|
| Dave Watts, CTO, Fig Leaf Software
| http://www.figleaf.com/
| voice: (202) 797-5496
| fax: (202) 797-5444
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Regexp help

2001-07-17 Thread Bryan LaPlante

I need some help from one of the RegExp guru's. I am trying to get a list of
function names from my page for example the following functions name resides
in the page at position 9 to 17. I need a regular expression that will find
everything between the word function and the parenthesis character ( so that
I can get the word addition into a list. Here is what I have so far.

cfset funcName = refindnocase(([function]+) [ ]+
\(,thistag.generatedcontent,1,true)

function addition(a,b){
somevar = a + b;
return somevar;
}

Bryan LaPlante


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: [Custom Tag Question] ThisTag.GeneratedContent...

2001-07-17 Thread Bryan LaPlante

Try saving the content in a variable first.

cfset content = thistag.generatedContent

then clear the content.
cfset thistag.generatedContent = 

then do your replacement.
cfoutput#ReplaceNoCase(content, 'do NOT',
 'do')#/cfoutput

- Original Message -
From: Jamie Jackson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 17, 2001 10:38 AM
Subject: [Custom Tag Question] ThisTag.GeneratedContent...


| Please tell me if the following is possible, and how: I want to stifle
| the output of the area between cf_MyTag and /cf_MyTag.
|
| Here is a simplified example: I the following output: Hello World, I
| do want to display this sentence.
|
| ### Calling script ###:
| cf_MyTag
| Hello, World, I do NOT want to display this sentence.
| /cf_MyTag
|
| ### MyTag.cfm (custom tag) ###:
| cfoutput#ReplaceNoCase(ThisTag.GeneratedContent, 'do NOT',
| 'do')#/cfoutput
|
| Currently, this displays:
| Hello, World, I do NOT want to display this sentence. Hello, World, I
| do want to display this message. (Obviously, I don't want the first
| sentence displayed.)
|
| Is this best handled by cfsetting cfoutputonly=yes, or is there
| another way that's already built into the custom tag framework?
|
| Thanks,
| Jamie
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Learning CFX

2001-07-16 Thread Bryan LaPlante

I am learning to write cfx tag in Java. If anyone is aware of open source
tags that I can learn from I would like to download them.

Thanks

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Learning CFX

2001-07-16 Thread Bryan LaPlante

Thank you sir. I am finding that either there docs are really poor or cfx
tags have know way of knowing what is going on in the page. There seems to
be no access to any variable scope like application, session, client and so
on

- Original Message -
From: Paul Mone [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 7:24 AM
Subject: RE: Learning CFX


| Bryan,
| FYI, ColdFusion v5.0 comes with 5 java CFX examples in
| \CFUSION\cfx\java\distrib\examples\
|
|
| ---
| Paul Mone
| Ninthlink Consulting Group
| [EMAIL PROTECTED]
| http://www.ninthlink.com
| 619.222.7082
|
|
| -Original Message-
| From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
| Sent: Monday, July 16, 2001 4:57 AM
| To: CF-Talk
| Subject: Learning CFX
|
|
| I am learning to write cfx tag in Java. If anyone is aware of open source
| tags that I can learn from I would like to download them.
|
| Thanks
|
| Bryan LaPlante
| 816-347-8220
| [EMAIL PROTECTED]
| http://www.netwebapps.com
| Web Development
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: table column names

2001-07-16 Thread Bryan LaPlante

Try this.

CFQUERY NAME=QryResult DATASOURCE= MAXROWS= DBTYPE=ODBC

/CFQUERY
TABLE
 TR
  CFLOOP INDEX=ColumnName LIST=#QryResult.ColumnList# DELIMITERS=,
  TDCFOUTPUT#ColumnName#/CFOUTPUT/TD
  /CFLOOP
 CFOUTPUT QUERY=QryResult
 /TR
 TR
 CFLOOP INDEX=CellValue LIST=#QryResult.ColumnList# DELIMITERS=,
  TD#Evaluate(QryResult.  #CellValue#)#/TD
 /CFLOOP
 /CFOUTPUT
 /TR
/TABLE

- Original Message -
From: Bruce, Rodney [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 5:32 PM
Subject: table column names


| Hello
|
| Is there a way to get the column names from a table, if you don't
| know them.
| I am passing a table name to a page then need to look up information in
that
| table. because I am going to be passing a number of table names,  I can't
| use column names from any one table.
| The tables are of various sizes with anywhere from 4 to 20 columns.
|
| how can I display the query results?
| example:
|
| CFQUERY
| Select *
| from #tblname#;
| /CFQUERY
|
| The query itself works fine,  but I dont know how to get to the results
|
| Thanks for any help
| Rodney
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Services

2001-07-16 Thread Bryan LaPlante

I will approach this from the NT point of view since you didn't say what OS
your on. In user manager for domains you will see user rights under the
policies menu. Click the checkbox labeled show advanced user rights in the
user rights policy dialog. Choose access this computer from a network from
the drop down menu and add the user that CF server is logged in as to the
list of users. Double check the choice for log on as a service also gives
permission to that user if it isn't already. Hope that helps.

Bryan

- Original Message -
From: Bruce, Rodney [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 4:14 PM
Subject: CF Services


| Hello again
|
| I'm hoping someone can help with permissions for the CF services.
| by default CF logs on as the SYSTEM.  but for security we don't want
this.
|
| I have created a user account for CF.  but am having problems with
figuring
| out what permissions it needs to run.
|
| CF executive and CF RDS seem to be running fine.
|
| CF Application Services I have worked on until I am down to what I hope is
| the last error.
| When I try to start it I get the error  Error 2140 an internal Windows NT
| error occurred.
| When I view the Logs (all three),  there are no errors or failures listed.
|
| Does anyone know how to set up what permissions CF needs (file and
| registry).
| Also for MSSQL server will me what I have also been trying to set up and
am
| having a registry permission failure I cant find.
|
| FYI:  the system was really tightened down.  the base line is only
| Administrator and System have any privileges or permissions, both registry
| and files.  Each user account is set up individually as they are
| created/needed.
|
| Thanks for any help
| Rodney
|
|
|
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFX and the caller scope?

2001-07-15 Thread Bryan LaPlante

I have a lot of cfml custom tags and I am learning to write them in Java. I
have looked in the cf-talk and cfx-talk archives as well as all the Allaire
doc's I could find and searched via google finding no information about
interacting with the different scopes of the calling template.

Is it possible to communicate with the different scopes, session,
application, caller and so on?
I also tried to invoke the javadoc on cfx.jar file to see if I could take a
look at the class documentation and I keep getting a class constructor
expected error so the html docs never get created. Any insight or help would
be appreciated.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Define and Call UD-Functions

2001-07-11 Thread Bryan LaPlante

There is a tutorial you can download from the KCfusion (Cold Fusion user
group in Kansas city) that shows you how to package udf's and load them once
per life of the server if you choose the server scope. The tutorial says you
can use any scope you want.

http://www.kcfusion.org/
Look in the download section for Packaging UDF's

- Original Message -
From: Wagner Patrick [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 10:25 AM
Subject: Define and Call UD-Functions


| Hi there!
|
| I just started playing around with the UserDefined-functions in CF5 and
| found a strange issue making it nearly impossible to
| get any value of it.
|
| For example when defining global-functions in the application.cfm there
| seems to be no way to use these in a sub-called customtag.
| Is there a possiblity to reference the function created on top within the
| customtag without defining it new?
|
| Or simply, is there a way to make the functions available in the
| request-(scope)?
|
|
| Best Regards
|
| Patrick Wagner
| Application Engineer
| conceptware ag
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Host provider needed

2001-07-10 Thread Bryan LaPlante

I have a friend that is looking for a Cold Fusion host that supports a web
based shopping cart client so that he does not need to know programming to
sell his products. Any body have suggestions.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Contents of textarea formfield getting stripped out after quotation mark

2001-07-08 Thread Bryan LaPlante

When you do the insert statement use PreserveSingleQuotes(form.textarea)
around your value. CF puts escape characters around the single quotes so
they don't crash your query.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development

- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 08, 2001 8:53 AM
Subject: Contents of textarea formfield getting stripped out after quotation
mark


| I'm having a problem and can't figure out why.
| Using Access97 for the backend, I submit a form with a textarea tag. If
there
| are quotation marks in the textarea tag, everything in the textarea from
| where the quotation marks begin is stripped out when the textarea
formfield
| is inserted into the database.
|
| Why is everything from the quotation mark on, stripped out upon insert???
|
| How can I get that stuff to NOT be stripped out?
|
| Thanks,
|
| Jo-Anne Head
| [EMAIL PROTECTED]
|
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
|


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



test

2001-06-26 Thread Bryan LaPlante

Please disregard


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



KCfusion meeting tomorrow

2001-06-11 Thread Bryan LaPlante

Hey KCfusion and local CFUG'ers

Tomorrow Girish Kshirsagar will give a presentation on how to estimate
software costs in a project. He shared a little bit of it with me already
and it looks very interesting. The meeting will start at 7:pm like always.

You can find the meeting location and a map at http://www.kcfusion.org

See you there

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Need decryptor tag for CFUG presentation

2001-06-08 Thread Bryan LaPlante

I agree with you Raymond, I think as a producer of software I am offering a
fair approach to the folks out there that are new to Cold Fusion. For every
Application that I write and offer for sale I also make available all of the
custom tags and components that it took to build that software. If your like
most people the biggest reason for decrypting a template is to see how it
was built rather than to steal it from the author.
If you buy CF application from me, it is not because you can not build it
yourself but rather you don't have the time. So if I offer you the tool to
build it yourself and then offer the end product for sale I would hope you
would take the initiative to learn the components instead of hack into the
finished product.

Not all companies take the same approach but I think most of the A/MM
partners do, at least the ones that are CFUG managers.

My .02 cents

- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 8:45 AM
Subject: RE: Need decryptor tag for CFUG presentation


| Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden
| of Macromedia, but isn't use of this decryptor illegal? Should we so
| casually discuss a piece of a software that is probably illegal to use?
|
| Also, in general, unless you encrypt your OWN files, you should not be
| decrypting other people's templates. If you _do_ encrypt your files, you
can
| contact Tech support for help. Therefore, there is no need for this
| software.
|
| Am I wrong here? And let's not discuss wether it's right or wrong, I'm
| talking about legality.
|
| ===
| Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
|
| Email   : [EMAIL PROTECTED]
| ICQ UIN : 3679482
|
| My ally is the Force, and a powerful ally it is. - Yoda
|
|  -Original Message-
|  From: Jones, Matt [mailto:[EMAIL PROTECTED]]
|  Sent: Friday, June 08, 2001 9:37 AM
|  To: CF-Talk
|  Subject: RE: Need decryptor tag for CFUG presentation
| 
| 
|  http://shrewm.net/cfd/
| 
|  -Original Message-
|  From: Alii Design [mailto:[EMAIL PROTECTED]]
|  Sent: Friday, June 08, 2001 8:30 AM
|  To: CF-Talk
|  Subject: RE: Need decryptor tag for CFUG presentation
| 
| 
|  That website is gone http://shroom.dv8.org/cfd/ I was looking for it
|  recently and it has been down.
|  Is there another?
|  Rich
| 
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: How to get a list of all tables in a given datasource - and how to combine queries

2001-06-08 Thread Bryan LaPlante

That's very cool Clint, have you written a web version of the sql client so
that you can query the database and see your result set's?

Bryan

- Original Message -
From: Clint Tredway [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 9:01 AM
Subject: Re: How to get a list of all tables in a given datasource - and how
to combine queries


| Getting all the tables for a  SQL database is simple. Just query the
system table 'sysobjects' with this query:
|
| Select name,xtype from sysobjects where xtype = 'u' and name not like
'dt%' Order By Name
|
| For your second question it will take some logic to do what you want. Go
look at this app that I am writting. It is a web based sql manager.
|
| www.factorxsoftware.com/sqlmanager
|
| HTH
|
| Clint
|
| -- Original Message --
| From: JoshMEagle [EMAIL PROTECTED]
| Reply-To: [EMAIL PROTECTED]
| Date: Fri, 08 Jun 2001 08:34:07 -0400
|
| Have two questions 
|
| First, given the name of a datasource, how do I go about finding what
tables
| are contained in the datasource via CF (not just opening SQL Server)
|
| Second, I have a query of all the datasources on my server using
| cfregistry that is returned as a query ... how can I combine this
| information with the query to display the tables into one query? Is this
| even possible?
|
| THANKS!
|
| Joshua Miller
| Web Development
| Eagle Technologies Group
| Technology Solutions for the Next Generation
| www.eagletgi.com
| [EMAIL PROTECTED]
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT BUT URGENT: IIS stability

2001-06-08 Thread Bryan LaPlante

A similar thing happened to me and the cause of the memory saturation was a
security site I had used RDS security or advanced security. If you are using
the native cfauthenticate cfauthorize tags in a security setting, go look at
siteminder in perfMon and see how much memory it has tied up. It seemed
unrelated at the time I had problems, but replacing it with another solution
for security remedied the problem.

Bryan

- Original Message -
From: Alistair Davidson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 12:02 PM
Subject: OT BUT URGENT: IIS stability


| Hi guys ( gals)
|
| Sorry for the OT post, but I REALLY need help on this one, people's jobs
| are on the line.
|
| We have a serious problem with stability on IIS 5, Win 2K, CF 4.5.2. IIS
| has suddenly started to die. Symptoms include -
|
| - Existing virtual directories get lost. VDir's that have been working
| fine for 6 months suddenly return This page cannot be displayed IIS
| errors. If you delete the VDir and recreate it, it works again.
|
| - CF pages take forever to return. Flat HTML pages are responding
| reasonably well, but all the images now take forever to download.
| Restarting the CF service seems to help, but only for about half an
| hour, then it returns.
|
| - FTP transfer rates have gone down from over 200K / second to about 5
| BYTES / second.
|
| My first thought was a runaway CF process somewhere, but when we look at
| performance monitor on the CF/IIS server, CPU usage is only at 5% and
| memory usage is minimal. Then we thought it might be persistent database
| locks, but we've eliminated that. Performance monitor on the DB server
| shows only minimal CPU / memory usage too.
|
| We have CF and IIS on one server (Dual PIII 800, 1.3GB RAM) and SQL
| running on another. The SQL server is set up as the domain controller.
| CFSTAT shows that the database response time is fine, it's just taking
| ages for requests to get to  from the server.
|
| I know that at my last job, IIS was rebuilt as a regular maintenance
| task every two or three months. This installation of IIS has been for
| the last five or six months until this last week. And no code has
| changed in the last three weeks.
|
| Has anyone else had similar problems? How often do you all have to
| rebuild / re-install IIS ? I need some figures to give to the management
| ASAP, as they're starting to growl for blood.
|
| Mail me directly if you like
|
| Cheers,
|
| Alistair Davidson
| Senior Web Developer
| Rocom New Media
| www.rocomx.net
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Login Management

2001-06-07 Thread Bryan LaPlante

Chaz,
I built a couple of free custom tags that replace CF's advanced security
with a database solution. I also sell a management console to manipulate the
database. You can find all of the tutorials and documentation at
http://www.netwebapps.com/products/securitymanager/introduction.cfm

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development

- Original Message -
From: Chaz Scott [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 3:38 PM
Subject: Login Management


| Hi there,
|
| Can either of you recommend a nicely built login management application
built with Cold Fusion, which would allow me to assign permissions to
varying categories of users?
|
| Thanks,
| Chuck
|
| Find the best deals on the web at AltaVista Shopping!
| http://www.shopping.altavista.com
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF 5 Eval

2001-06-06 Thread Bryan LaPlante

Is anyone else evaluating or currently using CF 5? I have got
some examples I would like to share with you about getting tons of user
defined functions to run in memory instead of having to load them at the top
of ever page. It is kind of the same effect you would get from caching a
query except with a function instead.

Anyway before I go into it. Anybody?

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF 5 Eval

2001-06-06 Thread Bryan LaPlante

Ok let me get the sleep out of my eye's.

I am going to keep responding to my own post in an effort to keep the
progression of the responses cleaner. I don't all my presentations together
yet but I will probably present this subject to my cfug in Kansas city
meeting after next.

Here is what I found about User defined functions.  Raymond Camden and Rob
Brooks-Bilson are leading a project called Common Function Library Project
at http://www.cflib.org/.
They have put together 4 libraries of udf's complete with documentation and
examples, very helpful in getting you started with udf's.

The notion of loading a group of functions using cfinclude at the top of
ever template that requires access to said functions, well I am thinking
it's too heavy. go download http://www.netwebapps.com/projects/cflp.zip this
zip file while I go get my coffee and I will explain what I have done to
allow you to drop these libraries into you custom tags folder and only have
to load them once pre session,application,request or server occurrence,
which ever you choose.

Bryan

- Original Message -
From: Bryan LaPlante [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 1:43 AM
Subject: CF 5 Eval


| Is anyone else evaluating or currently using CF 5? I have got
| some examples I would like to share with you about getting tons of user
| defined functions to run in memory instead of having to load them at the
top
| of ever page. It is kind of the same effect you would get from caching a
| query except with a function instead.
|
| Anyway before I go into it. Anybody?
|
| Bryan LaPlante
| 816-347-8220
| [EMAIL PROTECTED]
| http://www.netwebapps.com
| Web Development
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF 5 Eval

2001-06-06 Thread Bryan LaPlante

The zip file in the previous post contains 4 custom tags and their editors.
The STRLIB.cfm file would be copied to your custom tag directory under
CFUSION\CustomTags.  All of the tag editors are the same with the exception
that they each output a tag by there own name, but all of these tags have a
common attribute which is the SCOPE attribute. Here is a break down of what
the custom tag does.

1.
First check to see if the SCOPE attribute is present in the call to the
custom tag.

CFIF NOT IsDefined( 'Attributes.SCOPE' )
HR
H4Missing Attribute/H4

You need to specify a value for the [ BSCOPE/B ] attribute. This
attribute is required for the BCF_STRLIB/B tag.
HR
CFABORT
CFELSE
 CFSET scopeVar = Attributes.SCOPE
/CFIF


2.
Setting that scopeVar variable will allow me to load the function into a
scope when the tag is finished running them.

3.
using concatenation to create a string that can be used in the isDefined()
function any function in your custom tag would be chosen to see if it exists
in the scope chosen by the user.

--
CFSET evalString = scopeVar  '.IsEmail'
!---
 Check to see if the scope named above contains the isEmail function.
 If it does then do not run the rest of the tag, otherwise build
 the function library and assign it to the requested scope.
---
CFIF NOT IsDefined(#evalString#)
--

4.
If the above returns true or does not find the IsEmail function in the scope
attribute, for example if the scope attribute was session and the tag had
already been run once, the value session.email would already be present and
the condition above would return false. If the condition above returns false
then the rest of the custom tag stops running and returns you to the rest of
your page processing.

5.
Given the above is true the next thing to do is run all of the function
inside a set of cfscript tags.
---
CFSCRIPT
function isEmail(){
return testing with this string of text;
}
/CFSCRIPT
---

6.
This next loop is where the assignment will take place. First set up a list
of scope names to be searched.

--
scopelist = server,application,session;
CFLOOP INDEX=func LIST=IsEmail,other,Functions,In,The,Library
DELIMITERS=,

6a.
Check to see if the scope chosen by the user is found in the scopelist


 CFIF ListContains(scopelist,Lcase(trim(scopeVar)))
--

6b.
If it is, Use cflock to prevent multiple users from writing to the same
variable name at the same time.

---
  CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=EXCLUSIVE
SCOPE=#scopeVar#
  CFSET Evaluate(scopeVar  .  func  =  func)
  /CFLOCK
--

6c.
Other wise in the case of a request scope or local variable just assign the
function name to a variable of it's own name

---
 CFELSE
  CFSET Evaluate(scopeVar  .  func  =  func)
 /CFIF
/CFLOOP
-

After the custom tag runs it will not need to run again unless you chose the
request scope in which case it is not persistent and the tag will run again
and again for each new page request..

7.
To access your function in the session scope for example you would refer to
it as:

--
CFOUTPUT
#session.IsEmail('[EMAIL PROTECTED]')#
/cfoutput

Ever request after the tag has already run will come right from the session
structure and as a result your function call will run just like it was a
native function call like Len() or ListContains(). That's pretty much it in
a nut shell.


- Original Message -
From: Bryan LaPlante [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 9:11 AM
Subject: Re: CF 5 Eval


| Ok let me get the sleep out of my eye's.
|
| I am going to keep responding to my own post in an effort to keep the
| progression of the responses cleaner. I don't all my presentations
together
| yet but I will probably present this subject to my cfug in Kansas city
| meeting after next.
|
| Here is what I found about User defined functions.  Raymond Camden and Rob
| Brooks-Bilson are leading a project called Common Function Library Project
| at http://www.cflib.org/.
| They have put together 4 libraries of udf's complete with documentation
and
| examples, very helpful in getting you started with udf's.
|
| The notion of loading a group of functions using cfinclude at the top of
| ever template that requires access to said functions, well I am thinking
| it's too heavy. go download http://www.netwebapps.com/projects/cflp.zip
this
| zip file while I go get my coffee and I will explain what I have done to
| allow you to drop these libraries into you custom tags folder and only
have
| to load them once pre session,application,request or server occurrence,
| which ever you choose

Re: cfhttp/cffile locking?

2001-06-03 Thread Bryan LaPlante

You only need to use scope on server, application and session. To single
thread another resource like cfhttp, cffile or cfregistry use the name
attribute instead.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development

- Original Message -
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 03, 2001 5:50 AM
Subject: cfhttp/cffile locking?


| I've heard that I need to lock cffile and cfhttp also?
| Is that right?
| what SCOPE should I use?!
|
| -=Michael.
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Store Query in APPLICATION variable

2001-06-02 Thread Bryan LaPlante

You should look into the CACHEDAFTER and CACHEDWITHIN attributes of the
CFQUERY tag. This will allow you to keep queries in memory for a period of
time that you indicate using the CreateTimeSpan(days, hours, minutes,
seconds) function. Every time the query is run with exactly the same
parameters it will be served from memory not requiring an additional trip to
the database.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development

- Original Message -
From: Hamid Hossain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 02, 2001 12:39 AM
Subject: Store Query in APPLICATION variable


| Hi folks,
|
| I want to store a query results in an APPLICATION
| variable. So, it will be available for all users with
| making the call through ODBC every time.
|
| for examble:
|
| the query may be for Countries like:
|
| cfquery datasource=DS name=GetCountries
|   SELECT * FROM Countries
| /cfquery
|
| then, I will use it with a loop to make HTML drop-down
| menu with SELECT
|
| Is there a way to do that ? please tell me if it is
| important to use CFLOCK with the previous code.
|
| Thanks
| Hamid Hossain
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF5 and UDF's

2001-06-02 Thread Bryan LaPlante

Is anyone playing with user defined functions? I can not find any doc's on
the subject in cfdocs or in studio. I wander if there is a way to do what I
am trying below

CFSCRIPT
function mydate(){
 if (arguments is )
  d = now();
  else
  d = arguments[1];

 return DateFormat(d);
}
/CFSCRIPT

CFOUTPUT#mydate(01/01/2001)#/CFOUTPUT


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF5 and UDF's

2001-06-02 Thread Bryan LaPlante

Thanks, I was walking past the kitchen table and picked up a copy this
months cfdj and read Ben Forta's article. That got me to thinking how could
I put all of my function in one place and load them up only once per visit
to the web site and not cfinclude them on ever page. I wrote this cool
little custom tag that lets you pick your scope like session, application,
request and then the tag loops through the function names assigning them to
the that scope.

Now I am thinking about building a wizard like my custom tag wizard that
will let you go in an package all of your functions into a library by way of
a custom tag. What d-ya think.

Bryan

- Original Message -
From: Dain Anderson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 02, 2001 9:29 AM
Subject: Re: CF5 and UDF's


| Bryan,
|
| In UDF's, you can use the ArrayLen() function to check for the existence
of
| passed values:
|
| CFSCRIPT
| function mydate()
| {
| var d = ;
| if(ArrayLen(Arguments))
| d = Arguments[1];
| else
| d = Now();
| return DateFormat(d);
| }
| /CFSCRIPT
|
| CFOUTPUT#mydate(01/01/2001)#/CFOUTPUT
|
| Dain Anderson
| Caretaker, CF Comet
| http://www.cfcomet.com/
|
|
| - Original Message -
| From: Bryan LaPlante [EMAIL PROTECTED]
| To: CF-Talk [EMAIL PROTECTED]
| Sent: Saturday, June 02, 2001 4:04 AM
| Subject: CF5 and UDF's
|
|
|  Is anyone playing with user defined functions? I can not find any doc's
on
|  the subject in cfdocs or in studio. I wander if there is a way to do
what
| I
|  am trying below
| 
|  CFSCRIPT
|  function mydate(){
|   if (arguments is )
|d = now();
|else
|d = arguments[1];
| 
|   return DateFormat(d);
|  }
|  /CFSCRIPT
| 
|  CFOUTPUT#mydate(01/01/2001)#/CFOUTPUT
| 
| 
| 
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF5 and UDF's

2001-06-02 Thread Bryan LaPlante

Yes, the custom tag I built was for the _strlib function library, I'll send
you a copy off line if you like and you can check it out.

- Original Message -
From: Dain Anderson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 02, 2001 9:51 AM
Subject: Re: CF5 and UDF's


|  Now I am thinking about building a wizard like my custom tag wizard that
|  will let you go in an package all of your functions into a library by
way
| of
|  a custom tag. What d-ya think.
|
| Hey, have at it :-)
|
| Have you seen the Common Function Library Project yet?
|
| http://www.cflib.org/
|
| Dain Anderson
| Caretaker, CF Comet
| http://www.cfcomet.com/
|
|
|
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Securing user created sub-directories

2001-05-31 Thread Bryan LaPlante

If the only file types in those directories are cfm pages you can put some
code in the application.cfm file to check for a login otherwise if there are
images and htm pages in the directory any user could view those files with
out cf knowing about it.

Bryan

- Original Message -
From: Bosky, Dave [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 1:40 PM
Subject: Securing user created sub-directories



 My goal is to allow a person to create sub-directories at will and let
them
 assign
 a UserAcct/Password to the sub-directory in order to view the directories
 contents.

 Need to prevent someone from typing in the url and viewing the contents
 without first logging in with a valid UserAcct/Password.

 Can this be done using ColdFusion/IIS?

 Thanks,

 Dave Bosky
 HTC Web Application Developer
 Macromedia Certified ColdFusion Developer
 843.369.8613
 [EMAIL PROTECTED]




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: COOKIE expiration :((

2001-05-30 Thread Bryan LaPlante

You may already be doing this but the value should be EXPIRES=NEVER not
timeout

Bryan

- Original Message -
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 3:27 AM
Subject: COOKIE expiration :((


 I'm getting really frustrated from this CFCOOKIE thing.
 Apparently, after I assign the cookie with Timeout=Never the cookie
 is deleted and terminated every time the user closes the browser.
 I tried to change Timeout to 14 days, but it didn't help.
 Closing the browser terminates the cookie.

 Is there a diffrent way to assign cookies?

 PLEASE HELP!!!

 -=Michael.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Logon Attempts

2001-05-29 Thread Bryan LaPlante

To resolve the problem put this code into login.cfm
cfif isDefined(client.counterVar)
cfset client.counterVar = IncrementValue(client.counterVar)
cfelse
cfset client.counterVar = 1
/cfif

You can use cfinclude or call the login.cfm as a custom tag, either way the
client scope will persist to the next page load where you can check it for
the appropriate action.

- Original Message -
From: Jerry Staple [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 2:35 AM
Subject: Logon Attempts


 Could anyone inform tell me what would be the best way to implement a
 logon page where the user gets 3 attempts to logon,after the 3 attempts
 the user is directed elsewhere.I have tried setting a variable on the
 application page then adding +1 when it goes to the Logon_Action.cfm but
 to no avail.

 Help


 Regards
 Jerry Staple
 Web Applications Developer
 Biznet Solutions
 133 - 137 Lisburn Road
 Belfast
 BT9 7AG
 www.biznet-solutions.com
 Tel: +44 (0)28 90205652
 Fax: +44 (0)28 9022 3223




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Paste Screen Capture into a browser and submit it

2001-05-29 Thread Bryan LaPlante

If you are on an intranet and you just need to get to the users screen, you
may want to look at this kind of solution.
http://www.uk.research.att.com/vnc/

- Original Message -
From: Don VanMeter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 1:00 AM
Subject: Paste Screen Capture into a browser and submit it


 I am stumped.  Are there any CF Gods out there?

 I need to add the capability of a user to paste a screen capture(alt -
 print screen) of a windows application error,  into a browser form
 without the user having to open another application, save the image ,
close
 the application, find the saved file, select it and then upload it.  I am
 not talking about text, I am talking about the bitmap created from a
screen
 capture .  I don't know if it resides in the clipboard.  The user needs to
 be able to paste it into a browser page and submit it.

 I tried CFX_DynamicImage and it brought my server to it's knees.

 Any Ideas?

 Thanks,
 Don



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: whitespace

2001-05-25 Thread Bryan LaPlante

I use cf_LessWhiteSpace from the tag gallery
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34784E-2830-11D4-AA
9700508B94F380method=Full


- Original Message -
From: nagesh [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 2:08 PM
Subject: whitespace


 hi all,


 i really fed up with the white space which is generated in the text file
by
 coldfusion(4.5). This happens when client(outlook) is reading the data
which
 is in output tags and trying to write into the text(log) file.

 Do we have anything by which we can remove/trim the white space before it
 goes to text file. Because the problem here is with the white space the
size
 of the file is getting increased like anything.


 I know about cfsetting enablecfoutputonly=yes tag. but i want
something
 powerful than that. Any ideas would be greatly appreciated.

 Thanks
 nagesh





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: whitespace

2001-05-25 Thread Bryan LaPlante

Could you clarify for me how you are using outlook as a client to read
output from CF. I am a little confused when you say text file when talking
about using outlook. What I'm hearing is you are using outlook to read a
text file but I don't think that is what you are intending to say, or is it?

Bryan

- Original Message -
From: nagesh [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 3:15 PM
Subject: RE: whitespace


 Hi bryan,

 thanks for the response. But i used even that tag too. And i tried with
 option available in settings in the administrator to suppress the
 whitespace. Is there any otherway around to overcome this problem.

 Because, the textfile is going to generated by the outputs of the 3 to 4
 coldfusion files.

 -Original Message-
 From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 25, 2001 3:50 PM
 To: CF-Talk
 Subject: Re: whitespace


 I use cf_LessWhiteSpace from the tag gallery

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34784E-2830-11D4-AA
 9700508B94F380method=Full


 - Original Message -
 From: nagesh [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, May 25, 2001 2:08 PM
 Subject: whitespace


  hi all,
 
 
  i really fed up with the white space which is generated in the text file
 by
  coldfusion(4.5). This happens when client(outlook) is reading the data
 which
  is in output tags and trying to write into the text(log) file.
 
  Do we have anything by which we can remove/trim the white space before
it
  goes to text file. Because the problem here is with the white space the
 size
  of the file is getting increased like anything.
 
 
  I know about cfsetting enablecfoutputonly=yes tag. but i want
 something
  powerful than that. Any ideas would be greatly appreciated.
 
  Thanks
  nagesh
 
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFX resources

2001-05-24 Thread Bryan LaPlante

Funny you would post this just now. I was just searching the web for that
very subject when I stumbled upon a site that looks like they have written
their own version of the Allaire docs. I don't know how different or alike
they might be but here is the url.
http://nesen.unl.edu/cfdocs/Advanced_ColdFusion_Development/11_Building_Cold
Fusion_Extensions/adv11.htm

Bryan
- Original Message -
From: dave fauth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 24, 2001 3:55 PM
Subject: Re: CFX resources


 what languages do you want


 At 01:32 PM 5/24/2001 -02-30, you wrote:
 
 Hi all,
 
 No matter how much I look I cannot seem to locate a good reference for
 creating CFX tags. I've been through the Allaire doc's but I want to know
 what other languages you can use to create CFX tags.
 
 TIA,
 
 Jay
  Strategy ~ Creativity ~ Technology  

 
 Jay Brushett
 [EMAIL PROTECTED]
 
 Developer
 
  ZeddComm Inc. 
 2nd Floor, The Tower | 100 Signal Hill Road
 St. John's, Newfoundland | Canada A1A 1B3
 Main: 709.570.5669 | Fax: 709.739.9003
 Web: www.zeddcomm.com
St. John's ~ Toronto ~ Newport Beach ~ Ottawa   
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT DBMS select distinct

2001-05-24 Thread Bryan LaPlante

Sorry for the off topic but how do you select distinct only on one of
several items in a select statement.
I only want the unique names from the query below but this doesn't seem to
be working.

Winnt 4 sp6
CF 4.5.2
Access or SQL 6.5

select
 r.ResourceID,
distinct  r.Name,
 r.Description,
 p.ApplicationID
from
 Resources as r LEFT OUTER JOIN
 Policies as p
ON
 r.ResourceID = p.ResourceID

The error message
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or
Hyperlink Object when you select unique values (r.Description).

Thanks in advance for your help

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT DBMS select distinct

2001-05-24 Thread Bryan LaPlante

Ok I see where you are going with this. your suggested work around does get
the unique values but the output duplicates the same value the number of
time it is referenced in the table. I will play around with it and worse
case I will just use the group field in the cfoutput.

Thanks for the heads up.

Bryan

- Original Message -
From: John [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 24, 2001 10:20 PM
Subject: RE: OT DBMS select distinct


 The key word distinct does not work that way.  It will only allow
duplicate
 record sets but does nothing for individual fields unless it is a one
field
 query.  A work around is as follows but depending on the data set .  Hope
 this helps.

 John


 select
  r.ResourceID,
  r.Name,
  r.Description,
  p.ApplicationID
 from
  Resources as r LEFT OUTER JOIN
  Policies as p
 ON
  r.ResourceID = p.ResourceID
 where r.name in (select distinct name from resources)

 -Original Message-
 From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, May 24, 2001 10:04 PM
 To: CF-Talk
 Subject: OT DBMS select distinct


 Sorry for the off topic but how do you select distinct only on one of
 several items in a select statement.
 I only want the unique names from the query below but this doesn't seem to
 be working.

 Winnt 4 sp6
 CF 4.5.2
 Access or SQL 6.5

 select
  r.ResourceID,
 distinct  r.Name,
  r.Description,
  p.ApplicationID
 from
  Resources as r LEFT OUTER JOIN
  Policies as p
 ON
  r.ResourceID = p.ResourceID
 The error message
 Error Diagnostic Information
 ODBC Error Code = 37000 (Syntax error or access violation)


 [Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or
 Hyperlink Object when you select unique values (r.Description).

 Thanks in advance for your help

 Bryan LaPlante
 816-347-8220
 [EMAIL PROTECTED]
 http://www.netwebapps.com
 Web Development

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: NT User authentication

2001-05-23 Thread Bryan LaPlante

CF has this ability through advanced security. There is a bit of a learning
curve but  once you figure it out it makes sense why it works the way it
does. Start reading the docs and when you get stuck email the group and I'll
keep an ear out for you.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development

- Original Message -
From: Neil H. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 9:02 PM
Subject: Re: NT User authentication


 Yes,
 But I want to check the password too.

 Thanks

 Neil

 - Original Message -
 From: John Wilker [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, May 23, 2001 9:47 PM
 Subject: RE: NT User authentication


  Assuming this will be running on an intranet where users will have to
 login
  to NT, you can access their NT login name with #REMOTE_USER# it should
  return domain/username
 
  you'll need to turn anonymous access off in IIS in order to make the
  variable record.
 
  J.
 
  John Wilker
  Web Applications Consultant
  Macromedia Certified ColdFusion Developer
 
  www.red-omega.com http://www.red-omega.com
 
  Pepsi's Come Alive With the Pepsi Generation translated into Pepsi
 Brings
  Your Ancestors Back From the Grave in Chinese.
 
 
  -Original Message-
  From: Neil H. [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, May 23, 2001 6:36 PM
  To: CF-Talk
  Subject: Re: NT User authentication
 
 
  No no, I want to have a login page that compares the username and
password
  to the NT user database :)
 
  Thanks,
 
  Neil
 
  - Original Message -
  From: Garza, Jeff [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Wednesday, May 23, 2001 7:29 PM
  Subject: RE: NT User authentication
 
 
   Turn off anonymous access, use NT/Challenge Response and or Plain
   Text(netscape).  Remove the IUSR_Machinename from the dirctory ACL.
And
  make
   sure to allow system access to the directories othwise your default
  install
   of CF can't access the scripts to run.
  
   HTH
  
   Jeff Garza
   Web Developer/Webmaster
   Spectrum Astro, Inc.
   480.892.8200
  
   [EMAIL PROTECTED]
   http://www.spectrumastro.com
  
  
  
   -Original Message-
   From: Neil H. [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, May 23, 2001 2:37 PM
   To: CF-Talk
   Subject: NT User authentication
  
  
   I am looking for a method where the website can authenticate against
the
  NT
   user database.
  
   Thanks,
  
   Neil
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: VTML edit tag dialogs: attributes with no value?

2001-05-22 Thread Bryan LaPlante

Use the free custom tag wizard at http://www.netwebapps.com/mytags/main.cfm
.. On the last screen you get a chance to choose the type of control you want
associated with your input and choosing a checkbox from the drop down gives
your vtm file that default behavior.

CF_CUSTOMTAGWIZARD TAGNAME=sample
[EMAIL PROTECTED]
EMAILMESSAGE=thanks for useing our tag wiz
SENDASHTML=false
 The sendashtml is a checkbox and if left unchecked it outputs with the
value of false or true if checked.

Bryan

- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 22, 2001 1:03 AM
Subject: Re: VTML edit tag dialogs: attributes with no value?


 In CF Studio: Select the tag selector tab in the resources area. (Next to
 the help tab)
 Then select the little yellow gear with the hint Edit Tag Definition.
 (Half way up on the gray separation bar)
 Use this to edit all your VTMs, it's a breeze.

 Rob Rusher
 Flare Networks Inc.

 233 Linden Street
 Fort Collins, CO 80524

 (970) 498-9196  Office
 (303) 884-7044 Cell
 (970) 472-1775  Fax
 [EMAIL PROTECTED]

 [EMAIL PROTECTED]
 http://www.flarenetworks.com



 --
--
 This email and any accompanying documents contain information belonging
 to the sender which may be confidential and legally privileged.  This
 information is only for the use of the intended individual or entity to
whom
 this electronically transmitted message is sent.

 If you are not the intended recipient, any disclosure, copying,
 distribution, or action taken in reliance on the contents of the
 information contained in this transmission is strictly prohibited.

 If you receive this transmission in error, please call Flare
 Networks collect at 970-689-1294 and delete the message
 and any attachments.
 --
--
 - Original Message -
 From: Kay Smoljak [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, May 21, 2001 9:48 PM
 Subject: Re: VTML edit tag dialogs: attributes with no value?


  On Mon, 21 May 2001 08:23:08 -0400, Raymond Camden
  [EMAIL PROTECTED] wrote:
 
  You can do a conditional output by using WIZIF So, your VTML  portion
 of
  the TAGLAYOUT portion can do this:
  
  
  mytag WIZIF fieldname EQ 'true'TEXT_BOLD = 1/WIZIF
  
  This way it would only show up if true, not false or not selected at
all.
 
  Thanks, but is there any way of doing this in the EDITORLAYOUT?
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfcatch and email

2001-05-22 Thread Bryan LaPlante

Never tried to do that inside of a cfcatch block before but could you just
populate a variable with the email message and then outside the try block
check to see if the message is not empty and then send an email if so?

Bryan

- Original Message -
From: sebastian palmigiani [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 10:39 PM
Subject: cfcatch and email



 I want to send an email with database error info using cftry/cfcatch. But
it
 is not working. Am I trying to do something that can't be done within a
 cfcatch block?

 Sebastian

 ---


 cftry

 cfquery name='foo' datasource='foo'

 Select * from members

 /cfquery

 cfcatch type=database

 !--- EMail WebMaster ---
 cfmail from=[EMAIL PROTECTED]
 type=HTML
 to=[EMAIL PROTECTED]
 subject=Database Error

 Date: #DateFormat(Now(), MM D, YYY)# #TimeFormat(Now(), h:mm tt)#br
 Error Type: #CFCATCH.Type#br
 Message: #CFCATCH.Message#br
 Template: #CGI.CF_Template_Path#br
 Referer: #CGI.HTTP_Referer#brbr
 Details:
 #CFCATCH.Detail#brbr
 /cfmail

 cflocation url=index.cfm?go=Error ---

 /cfcatch

 /cftry



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: VTML edit tag dialogs: attributes with no value?

2001-05-22 Thread Bryan LaPlante

I'm in the middle of adding a project to source safe, give me a sec and I
will grab a vtm file to see if you can change something to accommodate that.

Bryan

- Original Message -
From: Kay Smoljak [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 22, 2001 7:12 AM
Subject: Re: VTML edit tag dialogs: attributes with no value?


 On Tue, 22 May 2001 02:35:20 -0500, Bryan LaPlante
 [EMAIL PROTECTED] wrote:

 Use the free custom tag wizard at
http://www.netwebapps.com/mytags/main.cfm
 .. On the last screen you get a chance to choose the type of control you
 want
 associated with your input and choosing a checkbox from the drop down
gives
 your vtm file that default behavior.
 
 CF_CUSTOMTAGWIZARD TAGNAME=sample
 [EMAIL PROTECTED]
 EMAILMESSAGE=thanks for useing our tag wiz
 SENDASHTML=false
  The sendashtml is a checkbox and if left unchecked it outputs with the
 value of false or true if checked.

 OK, that's my problem... the tag takes parameters like this:

 cfx_pwimageproc text_draw=testing text text_bold
 -- would create text in bold

 cfx_pwimageproc text_draw=testing text
 -- would create text NOT bolded

 if the attribute was written as TEXT_BOLD=true or TEXT_BOLD=false it
 would still turn out bolded, because when the tag runs it is checking for
 the existence of the attribute. If the attribute TEXT_BOLD is not included
 the effect will not be applied. If the attribute TEXT_BOLD is included,
the
 effect will be applied. It doesn't matter what the value of the attribute
 is. It could be TEXT_BOLD=who_gives_a_toss and the text will still come
 out bold.

 I can do this in Tag Insight by specifying the attribute as type flag...
 there doesn't seem to be an equivalent for the tag editor dialog box.

 K.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: VTML edit tag dialogs: attributes with no value?

2001-05-22 Thread Bryan LaPlante

Ok I got it. I did this like 4 times with bad results so be careful how you
type it in. This is the line from one of my tags that tag editors that I got
to work like you want. It thinks checked it true and not checked is false
but don't forget the single quotes or it will through an error.

WIZIF edtThrowOnError EQ
'true'$$SpacingGap$${DefaultCase('ThrowOnError')}=$${Q}$$edtThrowOnError$${
Q}WIZSET SpacingGap = VertSpacingGap/WIZIF

How does everyone else feel about this behavior, I can update the custom tag
wizard to use this output instead of the current behavior that shows check
box attributes whether they are checked or not.
Your input would be appreciated.

Bryan

- Original Message -
From: Kay Smoljak [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 22, 2001 7:12 AM
Subject: Re: VTML edit tag dialogs: attributes with no value?


 On Tue, 22 May 2001 02:35:20 -0500, Bryan LaPlante
 [EMAIL PROTECTED] wrote:

 Use the free custom tag wizard at
http://www.netwebapps.com/mytags/main.cfm
 .. On the last screen you get a chance to choose the type of control you
 want
 associated with your input and choosing a checkbox from the drop down
gives
 your vtm file that default behavior.
 
 CF_CUSTOMTAGWIZARD TAGNAME=sample
 [EMAIL PROTECTED]
 EMAILMESSAGE=thanks for useing our tag wiz
 SENDASHTML=false
  The sendashtml is a checkbox and if left unchecked it outputs with the
 value of false or true if checked.

 OK, that's my problem... the tag takes parameters like this:

 cfx_pwimageproc text_draw=testing text text_bold
 -- would create text in bold

 cfx_pwimageproc text_draw=testing text
 -- would create text NOT bolded

 if the attribute was written as TEXT_BOLD=true or TEXT_BOLD=false it
 would still turn out bolded, because when the tag runs it is checking for
 the existence of the attribute. If the attribute TEXT_BOLD is not included
 the effect will not be applied. If the attribute TEXT_BOLD is included,
the
 effect will be applied. It doesn't matter what the value of the attribute
 is. It could be TEXT_BOLD=who_gives_a_toss and the text will still come
 out bold.

 I can do this in Tag Insight by specifying the attribute as type flag...
 there doesn't seem to be an equivalent for the tag editor dialog box.

 K.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Could someone test this

2001-05-22 Thread Bryan LaPlante

I uploaded a free wizard to the tag gallery at Allaire and stupid me I
wasn't paying attention and I made the download link relative to the Allaire
web site. I just went back in and fixed it. It looks like it is working.
Just so I will know that my browser is not caching the result. Would one of
you kindly go to the tag gallery and click on the custom tag wizard and then
click on the link at the top to see if it starts the wizard.

Your help is very much appreciated.
http://devex.allaire.com/developer/gallery/index.cfm

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Dynamic Queries (RecordCount)

2001-05-22 Thread Bryan LaPlante

you should be able to just output the queryname.recordcount. make sure it is
spelled correctly

Bryan

- Original Message -
From: Steve Reich [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 22, 2001 6:06 PM
Subject: Dynamic Queries (RecordCount)


 How do I set a variable equal to the recordcount of this query? Here's
what
 I've been trying

 ~CODE
 cfset queryName = MyQuery

 cfquery name=#queryName# datasource=#application.dns# dbtype=ODBC
 username=#application.dns_username#
password=#application.dns_password#
 cachedwithin=#CreateTimeSpan(0,0,10,0)#
 SELECT *
 FROM data
 WHERE dataid = #dataid#
 /cfquery

 cfset queryCount= evaluate(queryName  .recordcount)

 cfoutput#queryCount#/cfoutput
 cfabort

 ~CODE

 This code returns the following error:

 ~ERROR
 Error Diagnostic Information

 An error occurred while evaluating the expression:


  queryCount=evaluate(queryName  .RecordCount)



 Error near line 109, column 7.
 An error has occurred while processing the expression:

21.RecordCount


 Invalid parser construct found on line 1 at position 4. ColdFusion was
 looking at the following text:

 RecordCount
 Invalid expression format. The usual cause is an error in the expression
 structure.
 ~ERROR

 Seems like I've done this a million times, but I'm not hitting on all
 cylinders today. The name of the query is an integer if that makes any
 difference. Can somebody point out the obvious for me?

 Thanks,
 Steve




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Could someone test this

2001-05-22 Thread Bryan LaPlante

Thank you everyone who replied to me off list. Sometimes I don't know were
my head is at.

Bryan

- Original Message -
From: Bryan LaPlante [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 22, 2001 6:27 PM
Subject: Could someone test this


 I uploaded a free wizard to the tag gallery at Allaire and stupid me I
 wasn't paying attention and I made the download link relative to the
Allaire
 web site. I just went back in and fixed it. It looks like it is working.
 Just so I will know that my browser is not caching the result. Would one
of
 you kindly go to the tag gallery and click on the custom tag wizard and
then
 click on the link at the top to see if it starts the wizard.

 Your help is very much appreciated.
 http://devex.allaire.com/developer/gallery/index.cfm

 Bryan LaPlante
 816-347-8220
 [EMAIL PROTECTED]
 http://www.netwebapps.com
 Web Development



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Bizarre Error: Server/Studio Duplicating Carriage Returns

2001-05-21 Thread Bryan LaPlante

There is an option in studio's settings under tools (F8) that will allow you
to choose your file settings so that a saved document uses the OS type of
document structure.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development

- Original Message -
From: Willy Ray [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 12:17 PM
Subject: Bizarre Error: Server/Studio Duplicating Carriage Returns


 I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1.
When I save a template through RDS, for every carriage return I enter as I
code, I get two carriage returns on the saved document.  Example:

 I write:

 html
  head
  titleHello/title
  /head


 When I re-open the file it looks like this:

 html

  head

  titleHello/title

  /head

 What's worse, If I make a little change, like, change the Hello to
Hello, World and re-save the template, the next time I open it, it looks
like this:

 html


  head



   titlehello, world/title




  /head


 Big problem.  I've got a template with only about 20 lines of actual code
on it, but it's up to about 14000 lines, due to this problem.  I have studio
on two different machines, and it doesn't seem to matter which I use.  Also,
this is not happening from the same two workstations if I write to an NT
machine through RDS, or through windows networking.

 Any ideas?


 Willy



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFINPUT -- not validating Integer

2001-05-16 Thread Bryan LaPlante

Here is an experment that did and it works for IE, someone on the list may
have the equivilent for NS.
Here are the docs for all the char codes.
http://msdn.microsoft.com/workshop/author/dhtml/reference/charsets/charset1.
asp

Basicaly I just added an event to the input tag after it was loaded and told
it to check every key strock for the keyCode 46 (.) and return keyCode = 0
instead. It's not pretty but it may give you some idea's.

Heres the page

html
head
script
function addValidation()
{
 document.foo.barr.attachEvent('onkeypress',badChar)
}

function badChar()
{
if (event.keyCode == 46  event.srcElement.value.length = 0)
 {
 event.keyCode = 0;
 alert();
 return true;
 }
}
/script
/head
body onload=addValidation()
CFFORM ACTION=#SCRIPT_NAME# METHOD=POST ENABLECAB=Yes NAME=foo

CFINPUT TYPE=Text
   NAME=barr
   MESSAGE=no way
   VALIDATE=integer
   REQUIRED=yes
   SIZE=10
BR
INPUT TYPE=submit VALUE=go
/CFFORM
SCRIPT

/script
/body
/html
-
- Original Message -
From: Michael S. Kimmett [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 4:37 PM
Subject: CFINPUT -- not validating Integer


 Howdy,

 I am trying to get the CFINPUT Tag to validate an integer on a form.  The
darn tag will validate SSN, zipcodes, etc, but when I enter the integer
parameter and test the validation using the following value ( .3 or any
value that starts with a decimal point ) the javascript validation fails (
the js allows the value to pass).

 Does anyone know if this is a bug in CF 4.5 and something that I will just
have to live with?

 Michael

 CFFORM Name=Test ACTION=appCFINPUTTEST.cfm
  CFINPUT Type=Text Name=Number1 Required=yes
 validate=integer  Message=You did not provide a correct Integer!
Size=20 Maxlength=30

 BR
 INPUT Type=Submit Name=Submit Value=Submit
 /CFFORM



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: IE4 and Required Fields w/ CFINPUT

2001-05-14 Thread Bryan LaPlante

If the radio buttons are the only difficulty you are having in IE4, it would
be easier to just make one of them checked and not use cfinput for that
element, that way you are sure to get a value.

Bryan

- Original Message -
From: Ray Bujarski [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 14, 2001 2:45 PM
Subject: Re: IE4 and Required Fields w/ CFINPUT


 Make sure your cfform tag has a name AND the cfinput type has a name
specified

 At 03:27 PM 5/14/2001 -0400, you wrote:
 Ok, My form works like a champ in Netscape and I run
 into no problems in IE5 but I get a javascript error
 in IE4. Since I have no javascript on the page I can
 only assume it is the javascript that is auto-generated
 by my CFINPUT TYPE=Radio REQUIRED=Yes ... ...
 Anyone else run into problems using required=yes under IE4?
 Is there any way around it?
 
 Matt Hood
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Session/Application Locking

2001-05-13 Thread Bryan LaPlante

I would like a copy of that attachment. We just had Daryl Banttari a
Macromedia consultant speak to our CF user group last Tuesday in Kansas City
and he did a presentation on performance tuning that included some eye
opening information on locking variables. The power point presentation is
available on our CFUG web site at http://www.kcfusion.org/

Thanks

Bryan LaPlante

- Original Message -
From: Mike Brunt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, May 13, 2001 10:55 AM
Subject: RE: Session/Application Locking


 Thank you and my apologies to all on the list, the attachment is only
21kb,
 if anyone wants it, please let me know.

 Kind Regards - Mike Brunt

 -Original Message-
 From: ibtoad
 To: CF-Talk
 Sent: 5/13/01 11:46 AM
 Subject: RE: Session/Application Locking

 Attachments don't work on this list.
 Rich

 -Original Message-
 From: Mike Brunt [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, May 13, 2001 11:23 AM
 To: CF-Talk
 Subject: RE: Session/Application Locking



 I have attached an article by Jim Schley of Macromedia which gives a
 good
 explanantion of locking.  There is also a paper by Ben Forta.

 Hope this helps.

 Kind Regards - Mike Brunt
 Macromedia Consulting

 -Original Message-
 From: Michael Lugassy
 To: CF-Talk
 Sent: 5/13/01 5:48 AM
 Subject: Session/Application Locking

 Hi,
 can someone please explain how can I lock session/application/other
 shared
 variables in order NOT to lose them?

 I know there is a timeout and/or readonly attribute but I can't seem to
 understand
 what to use and where.

 if you can clarify, I would be more then grateful.

 BTW: I don't want to use CF automatic lock.

 Thanks!!

 -=michael.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF 5.0 graphs

2001-05-11 Thread Bryan LaPlante

Just as a heads up, if you have personal custom tags or download any from
the tag gallery and you would like a personal tag editor for them, go to
http://www.netwebapps.com/mytags/main.cfm and use the free custom tag
wizard. After you put in the parameters for the tag it will email you a .vtm
file for the tag editor.
If you want to click on the banner adds the spongers make it possible to
offer this tool for free.

Bryan LaPlante

- Original Message -
From: Kevin Gilchrist [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 12:29 PM
Subject: CF 5.0 graphs


 Hi All,

 I'm just starting to play with the new CFGRAPH tag and I was wondering if
 anyone's created any tag editor's for it?  I guess one will appear for
 Studio 5.0 but just wondering anyway.
 If no-one has I might just take a stab at it myself...

 Thanks,
 Kevin

 Kevin Gilchrist
 Senior Consultant
 RedSiren Technologies Inc.
 (412) 281 4427 ext 466


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Help!!

2001-05-11 Thread Bryan LaPlante

did you really mean to put the tick marks around the '#session.total#' or
did you mean to pass that as an integer without the tick marks?

Bryan

- Original Message -
From: ibtoad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 3:01 PM
Subject: Query Help!!


 Does anyone see any problems with the following query:

 cfquery name=get_shipratedollars datasource=#config.datasource#
 Select shiprate from shipratesdollars
 WHERE '#session.total#' = shipfrom
 and '#session.total#' = shipto
 /cfquery


 I can not figure out why I am getting incorrect results.  Sometimes it
will
 pull more than one record and sometimes it will pull the max record only.
 Here is a copy of the table I am using named shipratedollars.

 ID shiprate shipfrom  shipto
 1 4.00  0.00   50.00
 2 6.00 50.01  100.00
 3 8.00100.01  200.00
 4 12.00200.01  300.00
 5 18.00300.01  500.00
 6 25.00500.01  750.00
 7 40.00750.01 1000.00
 8 50.00   1000.01 1500.00
 9 70.00   1500.01 2000.00
 10 100.00 2000.009.00


 Thansk,
 Rich




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Help!!

2001-05-11 Thread Bryan LaPlante

Sound like the data type for that field is not integer or currency as the
output would suggest. That's probably why you are getting the mixed results.
If it is possible I would convert the data and type in that field to
currency and you may get better results.

Bryan

- Original Message -
From: ibtoad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 6:04 PM
Subject: RE: Query Help!!


 When I get rid of the tick marks I get:
 [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
 expression.

 Rich

 -Original Message-
 From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 4:48 PM
 To: CF-Talk
 Subject: Re: Query Help!!


 did you really mean to put the tick marks around the '#session.total#' or
 did you mean to pass that as an integer without the tick marks?

 Bryan

 - Original Message -
 From: ibtoad [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, May 11, 2001 3:01 PM
 Subject: Query Help!!


  Does anyone see any problems with the following query:
 
  cfquery name=get_shipratedollars datasource=#config.datasource#
  Select shiprate from shipratesdollars
  WHERE '#session.total#' = shipfrom
  and '#session.total#' = shipto
  /cfquery
 
 
  I can not figure out why I am getting incorrect results.  Sometimes it
 will
  pull more than one record and sometimes it will pull the max record
only.
  Here is a copy of the table I am using named shipratedollars.
 
  ID shiprate shipfrom  shipto
  1 4.00  0.00   50.00
  2 6.00 50.01  100.00
  3 8.00100.01  200.00
  4 12.00200.01  300.00
  5 18.00300.01  500.00
  6 25.00500.01  750.00
  7 40.00750.01 1000.00
  8 50.00   1000.01 1500.00
  9 70.00   1500.01 2000.00
  10 100.00 2000.009.00
 
 
  Thansk,
  Rich
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: JS:URL Parameter in window.open

2001-05-10 Thread Bryan LaPlante

Try building your string first and then pass it to window.open() in a
variable.

- Original Message -
From: Richard Colman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 10, 2001 9:40 AM
Subject: JS:URL Parameter in window.open



 does anyone know something like this will work:

 window.open('file.cfm?name=value', ... )

 (does not seem to be working.)

 is there another easy way to control window size while passing a parameter
 in the URL???

 TNX if you can help.

 Rick Colman





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: syntax error when inserting date

2001-05-09 Thread Bryan LaPlante

Remember that date is a key word in sql and will produce undesired results
if a field in a table is named date as in your code snippet.
insert into class_schedule (classID, location, date)

Try changing the field name to aDate or lastupdated or something.

Bryan

- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2001 3:06 PM
Subject: RE: syntax error when inserting date


 Your problem is most likely due to the format of the date.
 If the data field in the database is of type 'Date' you would have to use
 CreateODBCDate(Form.Date) in order to change the text to an ODBC date
 format.

 Regards,

 Rob Rusher

 Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
 Java Programmer

 email: [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] phone: 303-885-7044

 plan, build and integrate interactive applications and e-business services
 to enhance knowledge sharing, e-commerce and business communications
 initiatives



 -Original Message-
 From: megan sherman [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 09, 2001 8:02 AM
 To: CF-Talk
 Subject: syntax error when inserting date


 Hi all,
 My action template is supposed to insert classID, location and date into
 a table in my database. When creating new records in the form I provide,
 I want the user to be able to supply a comma delimited list of dates. I
 think the loop in the action template successfully extracts individual
 dates from the date list, but there is a syntax error in the insert
 command. Everything works if I don't try to insert the date, so that
 must be where the syntax error occurs. Can anybody tell me what my date
 syntax error is?
 Thanks in advance!
 Megan
 The action template code is shown below
 CFIF IsDefined(FORM.scheduleID)
  CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule
 CFELSE
 cfoutput
 cfset dategroup=form.date
 cfloop index=x from=1 to=#ListLen(dategroup)#
 cfset onedate=ListGetAt(dategroup,#x#)
 cfquery datasource=calkayak
 insert into class_schedule (classID, location, date)
 values(#form.classID#, '#form.location#', '#onedate#')
 /cfquery
 /cfloop
 /cfoutput
 /CFIF


 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Quick DB Design

2001-05-06 Thread Bryan LaPlante

go to Allaire devX and grab the securePack download. there is a custom tag
in there that will create a DB structure for roll based community security.
You can add as many groups as you want and the cf_addremoveuser tag will
allow you add users and do group assignments on the fly.

There is a management console that goes with the secure pack called security
manager you can get that from my site for a fee, but the custom tags are
free.

Bryan LaPlante
http://www.netwebapps.com

- Original Message -
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, May 06, 2001 11:38 AM
Subject: Quick DB Design


 I'm trying to normalize a table to best hold the following data:
 username, group1, group2, group3, group4... groupN...

 there are 1000s of unique usernames, and 1s of unique groups
 every user can subscribe to 1-1 diffrent groups (so I don't know how
much group colums to put).

 I need somehow to maintain a list of subscribed groups for each user.

 is there a better way then 2 fields like the following:

 username (nvarchar(30)
 groups (longtext) =  group1,group3,group15,group7,group9 ?


 Thanks,

 -=Michael.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Object Oriented CFML

2001-05-04 Thread Bryan LaPlante

That's awesome man, I want to take some time and read about it. Do you have
a design interface beyond the availability of the vtm editors? don't forget
I have a free tool for creating vtm's on line at
http://www.netwebapps.com/mytags/main.cfm

Bryan LaPlante

- Original Message -
From: Craig Bowes [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 04, 2001 2:30 PM
Subject: Object Oriented CFML


 Ok, here is a little poll for you guys.

 How many of you are using SmartObjects and how many of you are using
 CFObjects?  I know there's a ton of Fusebox people but I'm looking for the
 people using object oriented CFML.

 Tell me what you are using, if you like it, and for how long.

 Thanks!

 -Craig

 http://www.smart-objects.com/

 http://www.cfobjects.com/





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Inexpensive Hosting

2001-05-03 Thread Bryan LaPlante

http://www.cfdeveloper.co.uk/ Free

- Original Message - 
From: Guy McDowell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 8:52 AM
Subject: Inexpensive Hosting


 G'day eh?
 
 I'm trying to find very inexpensive CF hosting to no
 avail. Something under $20 CDN is preferred. I need to
 host my personal/resume site along with some CF
 examples I have done.
 
 Thought I saw someone post something about hosting for
 $5.95 a month
 
 If there is nothing like that, then is it possible for
 me to institute CF Server Express within my own
 account/directory on a regular hosting package of the
 WinNT variety?
 
 Guy
 www.guymcdowell.com
 
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Inexpensive Hosting

2001-05-03 Thread Bryan LaPlante

the cfdeveloper site is having technical difficulty this morning. I'll post
a mail here when it comes back on line.

- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 9:45 AM
Subject: RE: Inexpensive Hosting



 try looking at www.cfdeveloper.co.uk

 HTH

 Mike

 -Original Message-
 From: Guy McDowell [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, May 3, 2001 14:52
 To: CF-Talk
 Subject: Inexpensive Hosting


 G'day eh?

 I'm trying to find very inexpensive CF hosting to no
 avail. Something under $20 CDN is preferred. I need to
 host my personal/resume site along with some CF
 examples I have done.

 Thought I saw someone post something about hosting for
 $5.95 a month

 If there is nothing like that, then is it possible for
 me to institute CF Server Express within my own account/directory on a
 regular hosting package of the WinNT variety?

 Guy
 www.guymcdowell.com


 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Finding the last item in a loop

2001-05-03 Thread Bryan LaPlante

!--- start count outsite of loop ---
cfset count = 1

cfloop query=qry_show_event_sponsors

!--- check each iteration of the loop to see if count equals the total
records ---
#EventSponserName#cfif count is not
qry_show_event_sponsors.RecordCount,/cfif

!--- increment the count at the end of each loop ---
cfset count = IncrementValue(count)

/cfloop

- Original Message -
From: Chris Martin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 10:12 AM
Subject: Finding the last item in a loop


 IS it possible to find the last item in a loop?

 Right now I have this:

 cfloop query=qry_show_event_sponsors
 #EventSponserName#,
 /cfloop

 Is it possible to check if the #EventSponsorName#  is the last item in the
 record set, and then not display the comma?  I.E.

 cfloop query=qry_show_event_sponsors
 #EventSponserName#cfif something,/cfif
 /cfloop

 Thanks in advance

 Chris Martin



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfexecute problems

2001-05-02 Thread Bryan LaPlante

If the program you are trying to communicate with was build to support the
COM interface (probably a .dll) then you can use CFOBJECT. Look for the
OleViewer on Microsoft's site it will show you the methods and properties of
the program if you have no 3rd party documentation.

If you are trying to talk to an exe, you might try using the outputfile
property of CFEXECUTE to output the return value of the call to a txt file
and then read it back into a variable on the page with cffile.

Bryan

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 9:35 AM
Subject: Re: cfexecute problems


 * Team Allaire *
 I don't think it's possible. CFEXECUTE does a single command line call. It
 doesn't 'hold' the connection open at all. For that you need something
like
 COM (or the other CFOBJECT techs).


  Anyone know how to use cfexecute with a command line program that
requires
  user input after the first line?  That is, how do you tell cfexecute
that
  you want to do the first bit, then simulate pressing return, then do the
  next bit, etc
 
  I've tried passing \n, \r, #chr(10)#, #chr(13) and even actually
enclosing
 a
  real carriage return between quotes and it won't work.
 
  Any help would be great.
 
  TIA,
 
 
  Aaron Cooper, BSc
  Application Developer, Freeserve.com Plc
  The Observatory, 36-41 Clerkenwell Close, London EC1R OAU
  T: 0207 553 4992  M: 07799 191 589
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT - Good list for HTML questions

2001-05-02 Thread Bryan LaPlante

here is one. http://www.wdvl.com

- Original Message -
From: Perez, Bismark [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 10:16 AM
Subject: OT - Good list for HTML questions


 Hello there,

 Can somebody recommend a good list to ask HTML questions, I have this page
 which looks good under IE, but some how it looks terribly wrong under NS,
or
 if there is a site that will shed light on how to do things so they'll be
 cross-browser...

 TIA
 Bismarck Perez



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Verity Indexing a Remote Server

2001-05-01 Thread Bryan LaPlante

Have you tried referring to the share as a drive like
G:\Server\Path\To\My\Files where G is the drive letter assigned to the
share.

- Original Message -
From: Bryan Batchelder [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 01, 2001 8:11 AM
Subject: Verity Indexing a Remote Server


 I am trying to create a verity collection that indexes a share on a remote
 server.  (We have 2 front end clustered webservers, and a static data
server
 - I am trying to index files on the static server, via a UNC path)

 I believe the systems are set up properly in regards to the user which the
 CF services are running as having proper permissions to the share.

 I can successfully create files on the remote server using CFFILE from the
 webservers using the same UNC path - so I would think that the verity
 indexer would be able to read those files.

 also of note is the fact that we currently use this file server to store
our
 verity collections between servers - and that works fine.

 am I missing something?

 Here is the exact tag I use:

 cfindex action = refresh
  collection = somecollection
  key= \\Server\Path\To\My\Files
  type   = path
urlpath= ../images/mailings/
recurse= no

 Of course, when I change the key attribute to some local drive\directory
 (like D:\cf\is\ereet) it works just fine (and again, the collection
 datastructure itself is being stored on the static server)

 Also, when I try and use the CF Administrator to create the index, it
gives
 me the same error.

 Am I forgetting something?

 Thanks in advance.

 Bryan Batchelder
 Web Application Developer
 ConnectWise, Inc.
 Phone: 813-935-7100 x 425
 Email:  [EMAIL PROTECTED]





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT (maybe?): IIS5 CF authentication prob

2001-05-01 Thread Bryan LaPlante

That is the one that works for me is to go to the advanced user rights and
set permission to log on to the server locally. Are you using IIS challenge
response or any additional authentication?

Bryan

- Original Message -
From: Cold Fusion [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 30, 2001 12:39 PM
Subject: OT (maybe?): IIS5  CF authentication prob



 I'm having one of 'those days'... I just can't work this one out. It's
 probably more of an IIS issue than CF though, me thinks, but I've been
 looking so much I just can't see it anymore...  so it's list help time...

 I'm just in the process of setting up a new (replacement) server. It's
 running Win2K SP1 (i.e. IIS 5.0) and CF Pro 4.5.1 SP2.  The CF service
 logs in as LocalSystem. As things stand, the server has no problems
 spitting out anonymous CFM or plain old HTML files to browsers (anonymous
 access).

 That's cool, but I actually also to set up authenticated (by W2K) logins
 on the server to certain CFM pages (actually sub-folders containing CF
 apps) too.

 However, if I remove anonymous access to the site definition in IIS
 manager, or if I remove privs for the IUSR_ account from the relevant
 site folder, whilst I can then authenticate OK from a browser to access
 HTML files, accessing CFM files always bounces the authentication, finally
 settling on a 403 (ACL on resource) error.

 Here's the kicker: if I add the relevant W2K user account being used to
 the local 'administrators' group on the server, it then lets me in and the
 CFM pages load just fine.

 I though this might be related to 'administrators' by default having 'full
 control' on the site folder, but providing those privs to the relevant
 user (or their group) directly, even all the way up/down/across/inside/all
 over the directory tree, has no apparent effect. I can't see what
 'administrators' has permission to that others don't...

 I'm assuming user policy details ('log-on locally' etc) are OK because
 authenticating HTML works OK.   CFUSION/BIN has 'read/execute' for
 everyone set...

 So: what on earth did I miss and/or screw up??!   Anyone any suggestions
 where to look?

 I get the feeling it's probably something simple I've missed though... ;-)

 SB



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hosting Service Provider Edition Eliminated

2001-04-29 Thread Bryan LaPlante

Jim,

What you asked for in the second paragraph is here,
http://webteem.cf-developer.net/remotedev2001.cfm login as password

The online docs are here.
http://www.netwebapps.com/Accounts/index.cfm

- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, April 29, 2001 9:04 PM
Subject: Re: Hosting Service Provider Edition Eliminated


 Jeff,

 I'm very happy to see that Macromedia listens to its customers.  Thank
you.

 I haven't had the opportunity to check out CF 5 yet, so I don't know what
 features are planned for the Professional and Enterprise versions.  As a
very
 small web host, with maybe 30 domains, one thing that _did_ peak my
curiosity
 was what features would be planned for a Service Provider Edition.  I
think
 someone was badly misinformed when they drew up the licensing and pricing
for
 this product, but if indeed there is added value to someone doing shared
hosting
 of CF server, there may well be a place for it.

 It's obviously too late to suggest significant changes for the CF 5
release, but
 I had wondered if we'd see some nice site-level management features,
including
 some end-user domain management capabilities.  Depending on the power of
the
 management and security features bundled into this product, I could see an
 appropriate price somewhere between Pro and Enterprise, perhaps the cost
of Pro
 plus 20-30%.

 Right now, the financial incentive for web hosts is still to use CF Pro
over
 Enterprise for shared hosting.  I hope to at least see some of the
sand-box
 security features migrated into Pro, so that it IS a good fit for this
 environemant, and one that will further the stability and reputation of
using CF
 for small sites.

 Jim







 -Original Message-
 From: Jeff Whatcott [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Date: Sunday, April 29, 2001 4:59 PM
 Subject: Hosting Service Provider Edition Eliminated


 Based on valued feedback from the community, we have changed our
licensing
 plans for shared server hosting with ColdFusion Server 5.  Here's what
you
 need to know:
 1. We do not plan to offer a Hosting Service Provider Edition of
 ColdFusion Server 5 at this time
 2. We plan to license the Professional and Enterprise editions of
 ColdFusion Server 5 in a way that allows you to provide shared server
 hosting services
 3. We plan to introduce the Professional and Enterprise editions of
 ColdFusion Server 5 with the same pricing as the 4.5 release
 The broad availability of high quality, affordable ColdFusion hosting
 services is important to the continued growth and success of the
ColdFusion
 community.  We recognize the role of our partners in making this happen,
and
 we encourage partners who offer hosting services to participate our
hosting
 partner programs, including the Hosting Certification Program.  Your
 involvement will help us better meet your needs in the future.
 One of the most exciting things about the ColdFusion Server 5 release is
 that it was conceived based on suggestions and feedback from the
ColdFusion
 developer community.   We rely on your continued involvement.  Keep it
 coming.
 If you have any questions, concerns, or suggestions regarding the
ColdFusion
 business, including licensing and pricing issues, feel free to email me
 anytime.  And as you start using ColdFusion Server 5 in the months ahead,
be
 sure to send your ideas for new features and functionality to
 [EMAIL PROTECTED]
 Thanks,
 Jeff Whatcott
 Director, ColdFusion Product Marketing / Macromedia
 [EMAIL PROTECTED]
 
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: New CF5 Partner Hosting License

2001-04-28 Thread Bryan LaPlante

About a year ago I was really frustrated with the hassles of managing
clients web sites that my company had developed applications for. Most end
users are not permitted to connect to their host providers RDS, rather they
have the FTP flavor of managing there files. Some ISP's have control panels
so you can at least manage the datasources but control panels for CF are far
an few between. Sounds like there will be added support for the hosting
environment in CF 5 but maybe the license will be prohibitive to the smaller
ISP's. What I did a year ago to alleviate this problem was build a tool that
the ISP of my client could install for free and then I would give my client
a free license to abort the 30 day trial. I can manage the clients
datasources, verity, advanced security, log files and edit cfm templates
right online. There are a multitude of articles on query best practices and
the custom tag model thus far is a pretty fair method of creating reusable
code. I guess for now with the tools that I use I will be ok with not
upgrading to CF 5. It will be interesting to see the outcome of this in the
future.

Bryan LaPlante
Network Web Applications Inc.
http://www.netwebapps.com



- Original Message -
From: John McKown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, April 28, 2001 10:40 AM
Subject: RE: New CF5 Partner Hosting License


 Steve,

 Excellent points.  Might I also add that some of us ISPs are actually web
 development shops and hosting companies as well. In our web development
 shop, some of our designers are just getting into application development.
 And these guys are fast learners.  I have pointed them towards CF because
it
 is a good RAD environment for them to learn in.   They have already built
 some pretty impressive CF apps running on SQL.

 But when we give a quote for a web development job, we factor in the CF
 work, the CF License, as well as the increase in hosting that a CF site
will
 cause.  In many cases, our larger clients opt for a dedicated server.
Since
 the bottom fell out of the PC server market, it is not unheard of to build
a
 CF server that costs $1500 that will run Win2K, SQL Server, and CF all on
 the same box.  This actually works pretty well for a small application,
and
 we are doing this now.

 But add up the software cost:

 CF Pro: $1200
 M$ SQL Server (only 5 licenses): $1400
 Win2K: $600 (ASP Included Free)

 As much as I hate a command line interface, Linux, PHP and MySQL are
 starting to look attractive.  Especially for these smaller sites that need
 their own box for security, whatever.

 I agree with you Steve, MM should drop the price on CF Server to gain
market
 share.  Market share is important.  And for god's sake if you are going to
 try to get more revenue from hosting companies, then at least provide
tools
 to make managing the security of the sites easier.  IMHO the sandbox
feature
 should be standard across the board.  Maybe they should merge Enterprise
and
 Professional editions to accomplish this.

 John McKown, Owner
 Delaware.Net, Inc.
 30 Old Rudnick Lane, Suite 200
 Dover, DE 19901
 phone: 302-736-5515
 toll free: 888-432-7965
 fax: 302-736-5945
 e-mail: [EMAIL PROTECTED]
 icq: 1812513



 -Original Message-
 From: Steve Pierce [mailto:[EMAIL PROTECTED]]
 Sent: Friday, April 27, 2001 11:46 PM
 To: CF-Talk
 Subject: RE: New CF5 Partner Hosting License


 We have already been told by Allaire sales reps that there will
substantial
 price increases for hosting companies with hundreds or thousands of
 domains/applications and that if we need licenses, the time to buy is now.
 This is from your own sales folks.

 Allaire has a well established history of announcing a fire sale on the
 current partner membership before a major price increase. This is a way to
 try and keep the partners from screaming too loud when the price change
 comes in and to generate a short spike in partner revenue before that
 program price is also increased.

 I would love to be surprised by a price decrease across the board for CF
 server licenses, but your own sales folks are telling us to buy now before
 the price goes up.

 Last time during the beta cycle we were promised sand boxing and other
 features that would make large scale hosting, ApSP, and shared hosting
 systems more secure. Then at the last moment, sand boxing and the other
 security enhancements were moved into a new version of software called CF
 Enterprise which was not covered by existing maintenance contracts for
Pro.
 So folks had to scramble for new license agreements and when they did,
they
 found that the price of CF went up with a five fold increase to some
$5,000.
 Hence why many hosting companies are still with 4.0 and didn't upgrade to
 4.5.

 Now taking a page from Microsoft's successful price increase of SQL Server
 to processor based and connection based licensing, McAllaire is looking to
 do the same thing. We have already heard from MM in past conference calls

caller scope

2001-04-24 Thread Bryan LaPlante

Going nuts friends,
I could swear that I have used this syntax in the past, but I can not get it
to work now.

In custom tag getResult.cfm there is a query that uses the caller scope to
make the query result set available to the calling page.

cfquery name=caller.qry.
select * from someTable
/cfquery

In the calling page I output
cfoutput query=qry

/cfoutput

Error message says that the value of the output tag does not refer to the
name of an available query. I also tried to cfset caller.qry = qry setting
the name value for cfquery name=qry and that fails too.
Any idea's.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: caller scope

2001-04-24 Thread Bryan LaPlante

that is exactly what I am doing except the caller.qry is hard coded in the
custom tag. I got it to work except it returns a recordset of 0 now.

- Original Message -
From: DeVoil, Nick [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 8:54 AM
Subject: RE: caller scope


 Bryan

 I do it this way

 Calling page:

  cf_getResult queryname=qry

  cfoutput query=qry

  /cfoutput

 Tag:

  cfquery name=thisQuery.

  select * from someTable

  /cfquery

  cfset Caller.#Attributes.queryname# = thisQuery

 This uses one more assignment than strictly necessary,
 but it just seems neater that way.

 Nick

 -Original Message-
 From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 2:16 PM
 To: CF-Talk
 Subject: caller scope


 Going nuts friends,
 I could swear that I have used this syntax in the past, but I can not get
it
 to work now.

 In custom tag getResult.cfm there is a query that uses the caller scope to
 make the query result set available to the calling page.

 cfquery name=caller.qry.
 select * from someTable
 /cfquery

 In the calling page I output
 cfoutput query=qry

 /cfoutput

 Error message says that the value of the output tag does not refer to the
 name of an available query. I also tried to cfset caller.qry = qry
setting
 the name value for cfquery name=qry and that fails too.
 Any idea's.

 Bryan LaPlante
 816-347-8220
 [EMAIL PROTECTED]
 http://www.netwebapps.com
 Web Development


 **
 Information in this email is confidential and may be privileged.
 It is intended for the addressee only. If you have received it in error,
 please notify the sender immediately and delete it from your system.
 You should not otherwise copy it, retransmit it or use or disclose its
 contents to anyone.
 Thank you for your co-operation.
 **


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: caller scope

2001-04-24 Thread Bryan LaPlante

I am feeling just a little bit stupid here, but as a good list participant I
will fess up.
The original code would have worked fine and if I had posted it verbatim you
all might have beaten the life out of me.

Thanks for not doing that!!

Problem with cf_getResult was I forgot I had set this default at the top of
the custom tag page.
CFPARAM NAME=ATTRIBUTES.ID DEFAULT=0

Thus the query below was only being truthful, even though I did not pass
ID= in the custom tag it was getting set by the default for attributes.id.

  cfquery name=Caller.qry datasource=#DATASOURCE# dbtype=ODBC
  Select * from someTable
  CFIF IsDefined(Attributes.ID)
  where tableID = #Attributes.ID#
  /CFIF
  /cfquery

MAN I hate when I do that!



- Original Message -
From: DeVoil, Nick [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 8:54 AM
Subject: RE: caller scope


 Bryan

 I do it this way

 Calling page:

  cf_getResult queryname=qry

  cfoutput query=qry

  /cfoutput

 Tag:

  cfquery name=thisQuery.

  select * from someTable

  /cfquery

  cfset Caller.#Attributes.queryname# = thisQuery

 This uses one more assignment than strictly necessary,
 but it just seems neater that way.

 Nick

 -Original Message-
 From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 2:16 PM
 To: CF-Talk
 Subject: caller scope


 Going nuts friends,
 I could swear that I have used this syntax in the past, but I can not get
it
 to work now.

 In custom tag getResult.cfm there is a query that uses the caller scope to
 make the query result set available to the calling page.

 cfquery name=caller.qry.
 select * from someTable
 /cfquery

 In the calling page I output
 cfoutput query=qry

 /cfoutput

 Error message says that the value of the output tag does not refer to the
 name of an available query. I also tried to cfset caller.qry = qry
setting
 the name value for cfquery name=qry and that fails too.
 Any idea's.

 Bryan LaPlante
 816-347-8220
 [EMAIL PROTECTED]
 http://www.netwebapps.com
 Web Development


 **
 Information in this email is confidential and may be privileged.
 It is intended for the addressee only. If you have received it in error,
 please notify the sender immediately and delete it from your system.
 You should not otherwise copy it, retransmit it or use or disclose its
 contents to anyone.
 Thank you for your co-operation.
 **


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Validate a string for a valid directory name?

2001-04-24 Thread Bryan LaPlante

try
cfif directoryExists(path/to/directory/)
code
/cfif
- Original Message -
From: river [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 12:48 PM
Subject: Validate a string for a valid directory name?


 What's the best way to validate a string for a valid directory name?  I am
 trying to create a form that creates a folder with the name that's
specified
 in the form.  Entering a text MyDocument in a textbox and hitting
Submit
 creates a folder with the name MyDocument.

 I need to check this string for the valid folder/directory name under
 Windows NT.  What would be the best way of doing it?  Is there a custom
tag?

 Thank you for any help.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: get the directory a file is in.

2001-04-24 Thread Bryan LaPlante

I think it is getDirectoryFromPath(script_name) if you use script_name it
will return the current directory otherwise just use the
c:\wwwroot\1234\index.cfm approach.

- Original Message -
From: Tony Schreiber [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 10:04 PM
Subject: Re: get the directory a file is in.


 ExpandPath('relativepath/filebeingrun.cfm')

  Is there a way to get the name of the directory a file that is being
  processed is in?
  Let's say, in a file
 
  C:\wwwroot\1234\index.cfm
 
  is there a way to retrieve C:\wwwroot\1234\ part in the index.cfm
file?
 
  Thanks for any help.
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: populating the query result to IFRAME

2001-04-23 Thread Bryan LaPlante

Not sure if this is what you mean, but try this.

eval(document. + secNum + .style.display = '';

don't forget to alternate your single and double quotes.

- Original Message -
From: paul . [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 10:12 AM
Subject: populating the query result to IFRAME


 HI Guys am trying to populate the query result to the IRAME , so
 that i can give the user to view result in the same page
 please check my code and suggest me. the seeror i get is style is not an
object
 thanks
 -paul . Below is my code
 ---
 p align=centerfont face=Arial, Helvetica, sans-serif
size=4bi Training/i/b/font/p
 cfif qry_get_events.recordcount gt 0
 script language =javascript
 function doSection(secNum)
   {
 /*
 if(secNum.style.display == none) {secNum.style.display = ; }
  else {secNum.style.display = none; }
 */
 secNum.style.display = ;
   }

 function noSection (secNum)
   {
  if(secNum.style.display == ) {secNum.style.display = none;}
   }

 /script



 table border=1 cellspacing=0 cellpadding=6 bordercolor=#00
align=center width=750
   tr valign=top
 td bgcolor=#66font color=#FF size=2bfont
 face=Arial, Helvetica, sans-serifCourse
   Name /font/b/font/td
 td bgcolor=#66 align=centerfont color=#FF
size=2bfont
 face=Arial, Helvetica, sans-serifScheduled
   Date /font/b/font/td
 td bgcolor=#66 align=centerfont color=#FF
size=2bfont
 face=Arial, Helvetica, sans-serifOccurance
   Date /font/b/font/td
 td bgcolor=#66 align=centerfont color=#FF
size=2bfont
 face=Arial, Helvetica,
sans-serifNon-Participants/font/b/font/td
 td bgcolor=#66 align=centernbsp;/td
   /tr
   cfoutput query=qry_get_events
 cfif year(completion_date) eq 1001
 cfset current_completion_date=Not completed yet
 cfelse
 cfset current_completion_date=#dateformat(completion_date,  dd
)#
 /cfif
 cfif year(training_date) eq 1001
 cfset current_training_date=Not scheduled yet
 cfelse
 cfset current_training_date=#dateformat(training_date,  dd
)#
 /cfif
 tr valign=top bgcolor=##FF
   tdfont size=1 face=Arial, Helvetica, sans-serif
 cfif qry_get_training_courses.recordcount gt 1
 cfloop index=loopcount from=1
to=#qry_get_training_courses.recordcount#
   cfif training_crse_idx eq
qry_get_training_courses.rec_id[loopcount]
   #qry_get_training_courses.session_name[loopcount]#
   /cfif
 /cfloop
 /cfif
 /font/td
   td align=centerfont face=Arial, Helvetica, sans-serif
 size=1#current_training_date#/font/td
   td align=centerfont face=Arial, Helvetica, sans-serif
 size=1#current_completion_date#/font/td
   td align=centerfont face=Arial, Helvetica, sans-serif
 size=1a
href=index.cfm?fuseaction=event_nonparticipants_vamp;event_idx=#rec_id#am
p;traini
 ng_course_idx=#training_crse_idx#Non-participants/a/font/td
   td align=centerfont face=Arial, Helvetica, sans-serif
 size=1a class=anchorclass
href=javascript:doSection(thesection)participants/a/font/td
 /tr
   a name = test
 input name=quarter_idx type=hidden value=#attributes.quarter_idx#
 div id =thesection onClick = noSection(thesection)
STYLE=display:none

 iframe
SRC=http://10.158.20.123/careadv/test/index.cfm?fuseaction=event_participan
ts_vevent_idx=3training_course_idx=645
  WIDTH=800 HEIGHT=200
 /iframebr/br/
 center
 a href=javascript:noSection(thesection) Close/a
 /center
 /div

 /a

   /cfoutput
 /table

 /cfif
 cfoutputinput name=quarter_idx type=hidden
value=#attributes.quarter_idx#/cfoutput


 --





 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RSVP reminder

2001-04-23 Thread Bryan LaPlante

Just a quick reminder. If you haven't already registered for the Ben Forta
meeting this Wednesday in Kansas City, go to http://www.kcfusion.org/ and
RSVP for the meeting. All of the information for the meeting is there.

Thanks

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Oh that's just great.

2001-04-23 Thread Bryan LaPlante

dude, go and get cf_avartree, it rocks

- Original Message -
From: Erika L Walker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 1:56 PM
Subject: Oh that's just great.


 I just downloaded a tag from the Tag Gallery called CF_Debugthat I
 wanted to throw up on one of my hosted sites so that I could get some
quick
 debugging info...

 Of course I unzipped it and it doesn't contain the Debugging tag, it's got
 some silly find and replace JS function.

 HELP! Does anybody out there have a debugging tag? Or let me know what the
 quick method is of outputting all the wonderful things we see at the
bottom
 of the pages when we have debugging turned on?

 *** mumbles to herself, while she goes and loads up on caffeine laced with
 arsenic that may put her out of her misery. 

 Erika

 You can talk a great philosophy, but if you can't be kind to people
 everyday then it doesn't mean that much to me. - unknown



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SQL INSERTS - return ID

2001-04-23 Thread Bryan LaPlante

select max(id) as maxID from tablename

- Original Message -
From: Matt Eschenbaum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 6:36 PM
Subject: SQL INSERTS - return ID


 Anyone know a trick to return the ID of a record just Inserted into a
table?

 Sincerely,

 Matthew M. Eschenbaum
 Allaire Certified Professional
 DevTech Inc.
 [EMAIL PROTECTED]
 206.956.0888
 www.dev-tech.com




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFTRY / CFCATCH questions

2001-04-23 Thread Bryan LaPlante

There are no requirements on the order of cfcatch statements that I'm aware
of.

- Original Message -
From: Jeffry Houser [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 6:45 PM
Subject: CFTRY / CFCATCH questions



I know that at least one CFCATCH must be put inside a CFTRY block.  How
 picky is CF on the order of the tags, though?  for example:

 CFTRY
Some code
CFCATCH type=Database
/CFCATCH

CFCATCH type=object
/CFCATCH

CFCATCH type=all
/CFCATCH

 /CFTRY


  First off, can you use an 'all' catch with other specialized catches
 defined?  Would a database exception catch at 'all' or would it catch at
 'database'?  If I changed the code around to look like this:


 CFTRY
Some code

CFCATCH type=all
/CFCATCH

CFCATCH type=Database
/CFCATCH

CFCATCH type=object
/CFCATCH


 /CFTRY


 Then, where would a database exception catch?  At 'all' or at 'database'?


 If I put the code after the CFCATCHs, would an error catch?  Like this:

 CFTRY

CFCATCH type=Database
/CFCATCH

CFCATCH type=object
/CFCATCH

CFCATCH type=all
/CFCATCH

Some code
 /CFTRY


Thoughts, comments?  Much thanks!



 Jeffry Houser | mailto:[EMAIL PROTECTED]
 AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
 --
 Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
 Due out June 2001
 --
 DotComIt, LLC
 database driven web data using ColdFusion, Lotus Notes/Domino
 --
 Half of the Alternative Folk Duo called Far Cry Fly
 http://www.farcryfly.com | http://www.mp3.com/FarCryFly



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: value of field not appear

2001-04-23 Thread Bryan LaPlante

try
cfoutput
input type=image name=imageName src=#getdosen.image#
/cfoutput

- Original Message -
From: Haryono ... [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 9:04 PM
Subject: value of field not appear


 Hallo,

 Source code:
 cfoutput
 input type=file name=image
 value=#getdosen.image#
 /cfoutput

 When i excute source code above in browser, value of
 field image is not appear. why?

 If I use:
 cfoutput
 #getdosen.image#
 /cfoutput

 value of getdosen.image is appear

 can you help me?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: New File Extension....

2001-04-20 Thread Bryan LaPlante

go to your IIS management console in NT4 it's under the option pack menu and
W2k it's in the computer manager. Right click on the web site in question
and go to properties and them to the home directory tab.
Click on configure and you will see the extensions in there.

Bryan

- Original Message -
From: "Neil Clark" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 9:22 AM
Subject: New File Extension


 Anyone know how to set up their Web server (in this case IIS 4 and 5) to
 accept any file with the extension .xxx and then pass it to the CF server
 for processing as if it was anyother .cfm file?

 I have had a few replies from good sources from other sources indication
 that this is easy, but I am unsure on how to go about it; any one give me
 the instructions for a test?

 Neil

 !-
 Neil Clark
 Senior Web Applications Engineer
 Spectra / CF / XML
 MCB Digital
 Premier Allaire [Macromedia] Partner
 Tel: 020 8941 3232
 Fax: 020 8941 4333
 e-mail: [EMAIL PROTECTED]
 



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT Javascript question

2001-04-20 Thread Bryan LaPlante

In IE4  and up event.keyCode(13) is the enter key

- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 12:45 PM
Subject: Re: OT Javascript question



 i know there is in NS but i'm not sure about IE

 in NS you can enable event capturing and inherent to that is the type of
 event.  i.e., a key stroke and the key depressed
 see developer.netscape.com for more on this

 script
 document.captureEvents(ONKEYPRESS);

 function myHandler(e){ //where e is the event type
 return e.type;
 }

 document.onkeypress=myHandler;
 /script



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



SecurePack

2001-04-19 Thread Bryan LaPlante

If anyone downloaded the SecurePack from the Allaire DevX, I just realized
that I did not include the file to auto create the security database, I only
put in the tag editor for it. Sorry about that. The updated files should
show up in the morning on Allaires site.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: HTML editor for idiots? recommendation?

2001-04-18 Thread Bryan LaPlante

Try Dreamweaver, if you can walk them through using it, the wysiwyg editor
is a lot more code friendly than M$

- Original Message -
From: "Peter Theobald" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 9:09 AM
Subject: OT: HTML editor for idiots? recommendation?


 Sorry for the OT post...

 I have a client who needs to be able to make simple text changes to static
HTML pages.
 I tried having him use FrontPage but he managed to destroy the entire
site, which I had to restore from backups.

 Can someone recommend an HTML editor that will simply download ONE page,
allow SIMPLE editing of text, and upload THAT page. Something that my
grandmother could use (hint: she wonders why she never has to put new ice in
her "icebox").




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFML not being executed

2001-04-18 Thread Bryan LaPlante

Couple of things to look for. Forgive me I am not sitting at my W2k machine
but you need to go to computer manager and find the IIS manager.
Right click on the default web site or the site in question and go to the
home directory tab.
Look at application settings and see if you have an entry for the name
called default application.
Click on the configure button and go to the add mappings tab.
Look an see if you have an entry for .cfm pointed to c:\CFUSION\bin\iscf.dll
or where ever you have cf installed.

If you don't see all of this go back to the home directory and click on
create to enable a default application for IIS to send script requests to.

Start there and see if that fixes ya.

Bryan

- Original Message -
From: "Duane Boudreau" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 12:24 PM
Subject: CFML not being executed


 Just had a box put together with Win2k, IIS, CF 4.5.1 sp2 and for some
 reason it is not executing the CFML code. When I view the source the CFML
 code is still in the contained in the returned html. I've tried everything
 even reinstalling both CF and the OS. I checked the ISAPI filters,
execute,
 everything I can think of, but nothing works.

 Any ideas

 TIA,
 Duane



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Netscape equivalent of iframe

2001-04-18 Thread Bryan LaPlante

M$ is the only browser that will display a ppt in the browser, that I'm
aware of.

- Original Message -
From: "Rosa, Issac" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 3:48 PM
Subject: RE: Netscape equivalent of iframe


 I tried ilayer in the following code, but I get an NS error - "Alert!
did
 not find a converter or decoder.

 ilayer id="myLayer"
 src="documents/powerpoint/mop_mission_stmt.ppt"
 height="480"
 width="600"ilayer

 Thank you,

  Issac Rosa
 
  IT - National Sales  Marketing
  OLAP Specialist Team Lead
  Ofc: 407-658-3111
  Cell: 407-342-0644
  Fax: 407-971-2374
  [EMAIL PROTECTED]


 -Original Message-
 From: JLB [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 18, 2001 2:25 PM
 To: CF-Talk
 Subject: RE: Netscape equivalent of iframe


 layer and Ilayer are the closest tags. But they are not nearly as easy
 to work with as iframes.



 -Original Message-
 From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 18, 2001 1:31 PM
 To: CF-Talk
 Subject: Netscape equivalent of iframe


 Does anyone know of an equivalent in Netscape to the IE tag iframe.  NS6
 supports the tag, but we are currently using NS4 as corp standard.  I need
 to embed documents(.doc, .ppt, .xls, .pdf) that automatically load when
the
 page loads.  Any help or suggestions would be greatly appreciated.

 Thank you,

  Issac Rosa
 
  IT - National Sales  Marketing
  OLAP Specialist Team Lead
  Ofc: 407-658-3111
  Cell: 407-342-0644
  Fax: 407-971-2374
  [EMAIL PROTECTED]
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Bryan LaPlante

I have a question about your script. Assuming the input looks like so
form name="foo"
input type="file" name="bar"
/form
does your script refer to the input as document.foo.bar.value;
If so how did you work around the access denied js error that the browser
gives me when I try this?

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 4:25 AM
Subject: Re: input type='file'


 I had the same problem, it's ain't possible.
 What I used is to open a window indicating
 only .jpeg or .gif is allowed and then used a javascript
 to check what file was inserted in the formfield (before
 uploading, not after): take a look:

 script
 extensions = new Array(".JPG",".GIF",".gif",".jpg")
 function allowedExt(fileType){
  var extension = fileType.substring(fileType.length-4, fileType.length)
  for (var i = 0; i  extensions.length; i++) {
if (extension == extensions[i]) {
 return true
 break
   }
  }alert(errorMsg()); return false
 }

 function errorMsg(){
   alertTxt = "Please select one of the following file types: \n\r"
   for (var i = 2; i  extensions.length; i++){
alertTxt += extensions[i] + " "
 {
   }
  }return alertTxt
 }


 Hope this helps.

 Bye.

 Michael Lugassy
 Interactive Music Ltd.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Bryan LaPlante

I've never gotten that to work for me. It always complains about object
required or access denied when I refer to a client side file upload. It is
my understanding that JavaScript can not access the content of the input
type due to security issues.

I will have to try your method.

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 5:26 AM
Subject: Re: input type='file'


 form action="something.cfm" method="post" enctype="multipart/form-data"
 name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);"

 this is the form heading.


 - Original Message -
 From: "Bryan LaPlante" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 10:44 AM
 Subject: Re: input type='file'


  I have a question about your script. Assuming the input looks like so
  form name="foo"
  input type="file" name="bar"
  /form
  does your script refer to the input as document.foo.bar.value;
  If so how did you work around the access denied js error that the
browser
  gives me when I try this?
 
  - Original Message -
  From: "Michael Lugassy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 4:25 AM
  Subject: Re: input type='file'
 
 
   I had the same problem, it's ain't possible.
   What I used is to open a window indicating
   only .jpeg or .gif is allowed and then used a javascript
   to check what file was inserted in the formfield (before
   uploading, not after): take a look:
  
   script
   extensions = new Array(".JPG",".GIF",".gif",".jpg")
   function allowedExt(fileType){
var extension = fileType.substring(fileType.length-4,
fileType.length)
for (var i = 0; i  extensions.length; i++) {
  if (extension == extensions[i]) {
   return true
   break
 }
}alert(errorMsg()); return false
   }
  
   function errorMsg(){
 alertTxt = "Please select one of the following file types: \n\r"
 for (var i = 2; i  extensions.length; i++){
  alertTxt += extensions[i] + " "
   {
 }
}return alertTxt
   }
  
  
   Hope this helps.
  
   Bye.
  
   Michael Lugassy
   Interactive Music Ltd.
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Bryan LaPlante

dude, you are a genius. I have never gotten that to work. My hat is off to
ya.

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 5:53 AM
Subject: Re: input type='file'


 just keep in mind that the form must come AFTER the script.

 - Original Message -
 From: "Bryan LaPlante" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 11:36 AM
 Subject: Re: input type='file'


  I've never gotten that to work for me. It always complains about object
  required or access denied when I refer to a client side file upload. It
is
  my understanding that JavaScript can not access the content of the input
  type due to security issues.
 
  I will have to try your method.
 
  - Original Message -
  From: "Michael Lugassy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 5:26 AM
  Subject: Re: input type='file'
 
 
   form action="something.cfm" method="post"
enctype="multipart/form-data"
   name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);"
  
   this is the form heading.
  
  
   - Original Message -
   From: "Bryan LaPlante" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Tuesday, April 17, 2001 10:44 AM
   Subject: Re: input type='file'
  
  
I have a question about your script. Assuming the input looks like
so
form name="foo"
input type="file" name="bar"
/form
does your script refer to the input as document.foo.bar.value;
If so how did you work around the access denied js error that the
  browser
gives me when I try this?
   
- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 4:25 AM
Subject: Re: input type='file'
   
   
 I had the same problem, it's ain't possible.
 What I used is to open a window indicating
 only .jpeg or .gif is allowed and then used a javascript
 to check what file was inserted in the formfield (before
 uploading, not after): take a look:

 script
 extensions = new Array(".JPG",".GIF",".gif",".jpg")
 function allowedExt(fileType){
  var extension = fileType.substring(fileType.length-4,
  fileType.length)
  for (var i = 0; i  extensions.length; i++) {
if (extension == extensions[i]) {
 return true
 break
   }
  }alert(errorMsg()); return false
 }

 function errorMsg(){
   alertTxt = "Please select one of the following file types: \n\r"
   for (var i = 2; i  extensions.length; i++){
alertTxt += extensions[i] + " "
 {
   }
  }return alertTxt
 }


 Hope this helps.

 Bye.

 Michael Lugassy
 Interactive Music Ltd.

   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CSS

2001-04-17 Thread Bryan LaPlante

input type="text" style="border:1px solid blue;"

- Original Message -
From: "Neil H." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 7:54 AM
Subject: CSS


 I want to make "flat" select boxes, radio buttons, and checkboxes.  What I
 mean is no shadow and a 1px border of a color.

 Anyone have any ideas?  The browser for this app is always IE 5.x

 Thanks,

 Neil




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ZIPPING with coldfusion

2001-04-17 Thread Bryan LaPlante

This one works great, http://www.forta.com/cf/tags/ I use it for my Custom
tag wizard http://www.netwebapps.com/mytags/main.cfm
- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 11:42 AM
Subject: ZIPPING with coldfusion


 Could someone point to a good program/object I can use
 to easily zip a couple of 100s .txt files using CFEXCUTE
 or CFOBJECT?

 (Not in Developer's Exchange..)

 Thanks,

 Michael Lugassy
 Interactive Music Ltd.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: escaping ' in SQL

2001-04-17 Thread Bryan LaPlante

#PreserveSingleQuotes(string)#

- Original Message -
From: "Gil Barden" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:09 PM
Subject: escaping ' in SQL


 Hi everyone,
 I have a question about how to pass an SQL statement through a text area
 box in a form while protecting the SQL statement.  Below I have a
 self-submitting form, that passes the dynamic text through the text-area
box
 and then passes to a query that is to be then displayed.

 Problem is, that the SQL gets re-parsed when I use the " ' " single tick
 for a string to a " " " double tick.  I have tried htmlcodeFormat() and
 htmleditformat() with no success.

 The error I recieve is:

 
 Error Diagnostic Information
 ODBC Error Code = 37000 (Syntax error or access violation)


 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax
near
 'n'.


 SQL = "select * from d_school_names where charter_school = ''n''"

 

 Here is my code:
 

 html
 head
 /head
 body bgcolor="#C0C0C0"
 cfif isdefined("form.submit")
 !--- Dynamice Query ---
 !--- cftry   ---
 cfquery name="dynQuery" datasource="xxx" username=""
 password=""
 #form.sql#
 /cfquery

 !--- Outputting query ---

 cfset columns = ListtoArray(#dynQuery.ColumnList#)
 cfset numColumns = arraylen(#columns#)

 table border="1" cellpadding="1" cellspacing="1"
 thCurrent Row/th
 cfloop index="i" from="1" to="#numColumns#"
 cfoutputth#columns[i]#/th/cfoutput
 /cfloop

 cfloop query="dynQuery"
 tr
 td
 cfoutput#dynQuery.currentRow#/cfoutput
 /td
 cfloop index="i" from="1" to="#numColumns#"
 td
 cfoutput
 cfif evaluate(columns[i]) EQ ""
 nbsp;
 cfelse
 #evaluate(columns[i])#
 /cfif
 /cfoutput
 /td
 /cfloop
 /tr
 /cfloop
 /table
 !--- cfcatch type="Database"
 You have caused a database error!  Please hit your back button and try
 again.
 /cfcatch
 !--- Catching any type of error. ---
 cfcatch type="Any"
 You have caused a database error!  Please hit your back button and try
 again.
 /cfcatch
 /cftry  ---

 !--- First time through form ---
 cfelse

 h3  Please Enter a SQL Statement below/h3

 form action="#cgi.script_name#?#cgi.Query_String#" method="post"

 textarea cols="50" rows="5" name="SQL"
 /textarea
 br
 input type="Submit" name="submit"
 /form
 /cfif
 /body
 /html


 

 Gil Barden



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ENcoding URL

2001-04-17 Thread Bryan LaPlante

no without useing a form post

- Original Message -
From: "Pooh Bear" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:37 PM
Subject: ENcoding URL


 hey yall, is there a way to hide the values in the URL so people can't see
 them?

 like I am passing URL variables, like Something=4This=Hiyah
 is there a way to hide the values or display them differently

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Ben Forta in KC

2001-04-16 Thread Bryan LaPlante

Hello everyone,
I posted this the other day and I don't think I ever saw it come through, so
here it is again.

Ben Forta is coming to Kansas City to speak to our CFUG. go to
http://www.kcfusion.org/ for details and RSVP for the meeting so we will
know how many are coming.

This event is sponsored by:
Allaire/Macromedia
GreenSoft Solutions, Inc.
Network Web Applications, Inc.
Human Kind Systems, Inc.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Creating Page Breaks to make page printable?

2001-04-16 Thread Bryan LaPlante

http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre
akAfter.asp

- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, April 16, 2001 6:20 PM
Subject: Re: Creating Page Breaks to make page printable?



  Does anyone know of a way to force printing breaks of a document?

 You can do this with style sheets.



 --
 This message sent compliments of db Technology
http://www.dbtech.net/




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Image / File Security

2001-04-15 Thread Bryan LaPlante

not sure how your pages are set up but we server our images dynamically so
that if you were to just copy the url from the img tag on the site you would
get a page that gets the image for you. That will allow you to do auth on
users that attempt to obtain resources. If you need a solution for CF like
advanced security that will run in a clustered environment check the one out
at http://www.netwebapps.com/products/securityManager/introduction.cfm the
custom tags it uses for authentication and authorization are free.

Bryan

- Original Message -
From: "Jason" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, April 15, 2001 3:52 PM
Subject: Image / File Security


 I am looking for suggestions on ways to incorporate protection of my files
 /images from deep linking. I currently log users in and verify them on a
DB
 with CF however that doesn't stop them from linking back to a file at a
 later date. I can't really use advanced security because the Image server
is
 on a different machine and the web servers are on another cluster. I also
 don't want to use NT challenge response because I would force the user to
 log in twice. I have seen some examples by people using Apache that use
the
 ..htacess method (to verify refering URLor something of that nature) but
 since I am using IIS 5.0 this doesnt work for me. Anyone currently have a
 good way to do this?


 Thanks.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   >