RE: .Net and ColdFusion

2001-07-23 Thread David Gassner

When Jeremy Allaire visited SF for a users group meeting right after the
Macromedia merger, he said there was a future plan to make CF a front-end
language for the .NET platform, just as it will be for the J2EE platform
with CF6.  No technical details, of course, and I have no idea whether
Macromedia is actually working on such a thing, but it has been discussed.



~~
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: SAX in CF? Other ideas?

2001-03-16 Thread David Gassner

SAX requires a compiled language - there are implementations for Java, VB
and C++ - so you can't implement SAX parsers directly in CF, a non-compiled
scripting environment.

You could modify the Java classes so they can be called from a CF page; for
this, you have choices of calling them directly with CFOBJECT, modifying
them so they're useable as a Java-based CFX custom tag, or running them on
JRUN and calling them with CFSERVLET.

 -Original Message-
 From: Edward Smith [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 16, 2001 9:36 AM
 To: CF-Talk
 Subject: SAX in CF? Other ideas?


 Hey all,

 I have a situation where I want to duplicate an application written in
 Java using CF.

 The application uses XML documents as templates, and executes
 functionality based on tags in the XML.

 For instance, the XML template might look like this:

 page
  article id="227" /
 /page

 The Java app uses a SAX parser to parse the template, which fires off an
 event for each tag.

 When the parser sees the "page" tag, it runs the PAGE java class, which
 goes off into the database and gets page info, etc. and spits out more
 XML to the output stream.

 Same for the article tag, which calls the ARTICLE class., etc.

 How would one go about doing this in CF?  I'm not sure there would be
 any way to integrate a SAX parser into CF, so I'm not sure of how to do
 this.

 What I'd like to do is parse the template and execute CF custom tags for
 each tag.

 If I could rewrite the templates, I'd do something like:

 cf_page
  cf_article id="227"
 /cf_page

 and CFINCLUDE them into the page to get executed.

 But, I can't rewrite the templates, and the templates come from the
 database, not the filesystem.

 Speed/efficiency is the primary motivation, so a RegExp replace, and
 writing the file to the filesystem isn't really an option..

 Any ideas?

 Thanks in advance!
 --
 Edward Smith  Internet Broadcasting System
 Director of Architecture  http://www.ibsys.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: form to session

2001-03-16 Thread David Gassner

Since both session and form are structures, you can use array-style syntax:

cfloop index="field" list="#form.fieldnames#"
  cfset session[field] = form[field]
/cfloop

The cfoutput tags are unnecessary.  And remember to use cflock around
the whole thing...

 -Original Message-
 From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 16, 2001 4:35 PM
 To: CF-Talk
 Subject: form to session


 Is there a simple way to take the values submitted from a form and setting
 session variables with the same name... example:

 form submits variables Form.FirstName and Form.LastName... I need to
 set... Session.FirstName = Form.FirstName and Session.LastName =
 Form.LastName...

 I know I can use... cfset Session.FirstName = Form.FirstName

 But, I want to do this cfloop looping over the fieldnames... something
 like...

 cfloop index="field" list="#fieldnames#"
   cfoutput
   cfset session.#field# = Form.#field#
   /cfoutput
 /cfloop

 The above produces an error... :(


 thanks in advance
 Jay


~~
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: XML Anyone?

2001-03-15 Thread David Gassner

kev,

Take a look at the examples I put together for last year's conference:

http://www.vintageapps.com/conference.cfm

They detail how to use the MSXML3 COM object and a bit on the Java-based
Xerces library.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 15, 2001 11:49 AM
 To: CF-Talk
 Subject: XML Anyone?


 Surely all of you smart people can direct me to some awesome
 resources on CF
 with XML or vice versa

 Thanks a bunch

 kev

 ~
 Kevin Mansel
 Web Developer
 Fox Communications
 [EMAIL PROTECTED]


  Kevin Mansel.vcf



~~
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: Problem calling data from a database

2001-03-14 Thread David Gassner

I don't know if this is causing all of your problems, but you're missing
pound signs around the JokeID value in the OPTION tags.  The corrected
version:

SELECT MULTIPLE NAME="a" SIZE="5"
CFOUTPUT QUERY="Review"
OPTION VALUE="#JokeID#"#JokeTitle#/OPTION
/CFOUTPUT
/SELECT

 I have a review form which is supposed to submit the request to a review
 action file to call a single unapproved joke from a joke database for
 approval or deletion.  Instead, the following problems occur:

 1.  all unapproved jokes appear, except those submitted to the database
 after the form and action file were created.
 2.  jokes submitted to the database after the form and action file were
 created never appear.



~~
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: padding a variable

2000-11-03 Thread David Gassner

The LJustify() function is designed for exactly this purpose:

LJustify(myColumn, 30)

 -Original Message-
 From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 03, 2000 5:23 AM
 To: CF-Talk
 Subject: RE: padding a variable
 
 
  how do you pad a variable in CF.
  for example how can I force a query.columnname to take up exactly 30
  characters?
 
 Just using Left() won't work if you're using variable length fields
 (varchar)
 
 You could use Left(myColumn  RepeatString(" ", 30), 30)
 
 HTH
 
 Philip Arnold
 ASP Multimedia Limited
 T: +44 (0)20 8680 1133
 
 "Websites for the real world"
 
 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 **
 
 
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
 or send a message with 'unsubscribe' in the body to 
 [EMAIL PROTECTED]
 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Submitting form with Javascript

2000-11-03 Thread David Gassner

Add a hidden field to the form; have each of the links set the value of the
field to something you can check from within the action page.

 -Original Message-
 From: Brett Payne-Rhodes [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 03, 2000 6:29 AM
 To: CF-Talk
 Subject: Re: Submitting form with Javascript


 This is a question I have been wondering about for a while myself...
 Thanks to Peter, Rob and David for their contributions, and I have
 managed to use the solution on a simple form. But what about a more
 complicated form that has three 'submit' buttons; 'Add' 'Update' and
 'Delete'? Using the standard 'input type="submit"' method you
 differentiate between the buttons by value, but it seems that when using
 the javascript solution I don't see the 'button' that was pressed, even
 if I name the images. I had a look in Goodman's Javascript Bible but
 found little to help - but its a big book and I'll keep looking...

 In the meantime, can anyone shed any more light on this please?

 Many Thanks,

 Brett Payne-Rhodes
 B)

 "Joseph J. Sanger, M.D." wrote:
 
  This is simple, but I am not a javascript maven  I wish to submit
  a form by clicking in a link, rather than pressing the submit button.
  Isn't this possible with some javascript function in the URL of the
  anchor?  Could someone remind me what this should look like?  Thanks
  very much.
  --
  
 Joseph J. Sanger, M.D. |
 Associate Professor of Clinical Radiology  | Phone: (212) 263 - 7410
 Division of Nuclear Medicine   | Fax: (212) 263-7519
 New York University School of Medicine |
 [EMAIL PROTECTED]
  
 
 --
 --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Need help on http Error 405

2000-11-03 Thread David Gassner

Error 405 means that IIS doesn't understand the requests's file extension
and can't properly dispatch it to the ColdFusion server.  Your action
attribute implies a file extension ".cfm/download.csv" which is meaningless
to the web server.

If you want the user to be able to download a file called download.csv, just
call the download.cfm page; in that page, include the commands:

CFHEADER NAME="Content-Disposition" VALUE="Filename=download.csv"
CFCONTENT TYPE="application/excel" FILE="[fullpath]download.csv"

where the file is the complete path and filename in the server file system.

Also, note that the ENCTYPE attribute in the form is for uploading a file,
not downloading one.

 -Original Message-
 From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 03, 2000 6:32 AM
 To: CF-Talk
 Subject: RE: Need help on http Error 405


 hi,
 I have add enctype="multipart/form-data"
 cfform action="download.cfm/download.csv" method="POST" name="sform"
 enctype="multipart/form-data" onSubmit="return ck_submit();"
 onReset="clear_lists();"

 but I am still getting http Error 405 error, and suggestion

 YC

 -Original Message-
 From: Steve Bernard [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, November 02, 2000 7:02 PM
 To: [EMAIL PROTECTED]
 Cc: Chen, Yung-Chih (CIT)
 Subject: RE: Need help on http Error 405


 You need to add "Type=multipart/form-data" to the FORM tag, double check
 spelling ;)

 Steve

 -Original Message-
 From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, November 02, 2000 3:58 PM
 To: CF-Talk
 Subject: Need help on http Error 405

 I have a page allow user to download data in CSV file extension.
 it was working at the production server(Unix, netscape web server)
 but does not work on my developement server (NT , IIS 4)
 here is the code:
 form action="download.cfm/download.csv" method="post"

 when user click submit, it will call download.cfm to download
 data and open
 download.csv with MS Excel.


 Is there something I need to do on the Webserver?

 any suggestion will be helpful!!

 Thanks

 YC
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: cfinsert

2000-11-03 Thread David Gassner

You might be having problems field names using SQL reserved words.  Try
enclosing all the field names in brackets:

cfquery name="AddUser" datasource="NOW"
INSERT INTO Users
([First],[Last],Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')
/cfquery

 -Original Message-
 From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 03, 2000 8:14 AM
 To: CF-Talk
 Subject: cfinsert


 I was using the following query:

 cfquery name="AddUser" datasource="NOW"
 INSERT INTO Users
 (First,Last,Ride,Fav_Place)
 VALUES('#First#','#Last#','#Ride#','#Fav_Place#')
 /cfquery

 But it was giving me an error. None of the fields are numeric,
 they are all texted fields. But when I used the following query:

 cfinsert tablename="Users" datasource="NOW"

 This one worked, but why didn't they other one?

 Jeremy

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: [RE: padding a variable]

2000-11-03 Thread David Gassner

Use a non-breaking space:

cfset padding=RepeatString( "nbsp;", 30 - Len(myColumn) )
#myColumn##padding#

 -Original Message-
 From: Alex [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 03, 2000 8:24 AM
 To: CF-Talk
 Subject: Re: [RE: padding a variable]
 
 
 how do i get it to show 30 characters without the browser 
 truncating spaces
 
 "Philip Arnold - ASP" [EMAIL PROTECTED] wrote:
  how do you pad a variable in CF.
  for example how can I force a query.columnname to take up exactly 30
  characters?
 
 Just using Left() won't work if you're using variable length fields
 (varchar)
 
 You could use Left(myColumn  RepeatString(" ", 30), 30)
 
 HTH
 
 Philip Arnold
 ASP Multimedia Limited
 T: +44 (0)20 8680 1133
 
 "Websites for the real world"
 
 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 **
 
 
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
 or send a
 message with 'unsubscribe' in the body to 
 [EMAIL PROTECTED]
 
 
 
 Get free email and a permanent address at http://www.netaddress.com/?N=1
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts 
 or send a message with 'unsubscribe' in the body to 
 [EMAIL PROTECTED]
 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: conference info

2000-11-01 Thread David Gassner

Holiday Inn (White House) is 4 blocks from the Dupont Circle metro on the
red line, 1 stop from the Marriott, and has rooms at $99/night.

- Original Message -
From: Marius Milosav [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 01, 2000 4:25 PM
Subject: Re: conference info


 Can anybody recommend some hotels, motels in walking distance (or on the
 subway line) from the conference site.

 Thank you
 Marius Milosav
 www.scorpiosoft.com
 Virtual Help Desk Demo (VHD)
 www.scorpiosoft.com/vhd/login.cfm

 - Original Message -
 From: "news.fuseware.com" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, October 31, 2000 12:04 PM
 Subject: Re: conference info


  The metro stop for the zoo is right there...use the Woodley Park-Zoo
stop.
 
  http://www.washingtonpost.com/wp-srv/local/longterm/metro/front.htm
 
  Regards,
 
  Howie
 
  "Larry C. Lyons" [EMAIL PROTECTED] wrote in message
  [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
   Hi,
  
   Since the Main Developer's Conference is at the Marriott Woodley Park,
   is there any information about the nearest Metro stop etc available?
  
   thanks,
  
   larry
  
   --
   Larry C. Lyons
   ColdFusion/Web Developer
   EBStor.com
   8870 Rixlew Lane, Suite 201
   Manassas, Virginia 20109-3795
   tel: (703) 393-7930 x253
   fax: (703) 393-2659
   http://www.ebstor.com
   http://www.pacel.com
   email: [EMAIL PROTECTED]
  
   Chaos, panic, and disorder - my work here is done.
   --
 

 --
  --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
 send
  a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]
 
 
 

 --
 --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
 a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]

 --
--
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: cfobject

2000-11-01 Thread David Gassner

Sima, the only thing I notice is the misspelling of the "type" attribute;
it's spelled "tyep".  If that misspelling isn't in your actual code, then
the problem may be in the class itself; could you post the source code?

Also, note that if you call the class once, then modify and re-compile,
you'll need to stop and restart CF as the original class will have been
cached.

David

 Hi  I have some problems in using cfobject tag to create a java object
 and access its public method in Cold Fusion.
 Here is the detail:(This is just a test and to prove that we can use the
 real java objects on the server, so forget what it actually does here)

 I created a simple  java class called CreateDates.class.

 It has a public method called tellage(), which returns an integer.

 In the main method I make an instance of the class (use the default
 constructor), and do some stuff.

 It works fine by itself. But when I called it using cfobject and tried
to
 access the public method  Cold Fusion gave me an error: the method is not
a
 public method.

 The code is here:
  cfobject action="Create"
tyep="java"
class="CreateDates"
   name="MyDate"

 Then when I use  cfset age=MyDate.tellage(),
  the Cold Fusion says it's not a public method.

 Is this the right way to use this tag?

 Any suggestions will be greatly appreciated. Thanks in advance.


 Sima




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: Getting List of Form Fields

2000-10-31 Thread David Gassner

The form.formfields variable contains a comma-delimited list of form fields.

- Original Message -
From: Jonathan R. Karlen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 31, 2000 6:41 PM
Subject: Getting List of Form Fields


 This is a multi-part message in MIME format.

 --=_NextPart_000_0043_01C04340.442FB8C0
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: 7bit

 Is there any good way to get a list of fields in a submitted form?

 Jon

 
 Jonathan R. Karlen
 Karlen Internet Solutions
 Web Site and Application Development
 http://www.karlen.com
 [EMAIL PROTECTED]
 (914)-923-2116


 --=_NextPart_000_0043_01C04340.442FB8C0
 Content-Type: text/html;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
 xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
 xmlns=3D"http://www.w3.org/TR/REC-html40"

 head
 meta http-equiv=3DContent-Type content=3D"text/html; =
 charset=3Diso-8859-1"
 meta name=3DProgId content=3DWord.Document
 meta name=3DGenerator content=3D"Microsoft Word 9"
 meta name=3DOriginator content=3D"Microsoft Word 9"
 link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
 !--[if gte mso 9]xml
  o:OfficeDocumentSettings
   o:DoNotRelyOnCSS/
  /o:OfficeDocumentSettings
 /xml![endif]--!--[if gte mso 9]xml
  w:WordDocument
   w:ViewNormal/w:View
   w:Zoom0/w:Zoom
   w:DocumentKindDocumentEmail/w:DocumentKind
   w:EnvelopeVis/
  /w:WordDocument
 /xml![endif]--
 style
 !--
  /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
 {mso-style-parent:"";
 margin:0in;
 margin-bottom:.0001pt;
 mso-pagination:widow-orphan;
 font-size:12.0pt;
 font-family:Arial;
 mso-fareast-font-family:"Times New Roman";
 mso-bidi-font-family:"Times New Roman";}
 p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
 {margin:0in;
 margin-bottom:.0001pt;
 mso-pagination:widow-orphan;
 font-size:12.0pt;
 font-family:Arial;
 mso-fareast-font-family:"Times New Roman";
 mso-bidi-font-family:"Times New Roman";}
 span.EmailStyle15
 {mso-style-type:personal-compose;
 mso-ansi-font-size:10.0pt;
 mso-ascii-font-family:Arial;
 mso-hansi-font-family:Arial;
 mso-bidi-font-family:Arial;
 color:black;}
 @page Section1
 {size:8.5in 11.0in;
 margin:1.0in 1.25in 1.0in 1.25in;
 mso-header-margin:.5in;
 mso-footer-margin:.5in;
 mso-paper-source:0;}
 div.Section1
 {page:Section1;}
 --
 /style
 /head

 body lang=3DEN-US style=3D'tab-interval:.5in'

 div class=3DSection1

 p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
 color=3Dblack
 face=3DArialspan =
 style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'Is there
 any good way to get a list of fields in a submitted =
 form?o:p/o:p/span/font/span/p

 p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
 color=3Dblack
 face=3DArialspan =
 style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'![if =
 !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p

 p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
 color=3Dblack
 face=3DArialspan =
 style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'Jono:p/o:p/span=
 /font/span/p

 p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
 color=3Dblack
 face=3DArialspan =
 style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'![if =
 !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p

 p class=3DMsoAutoSig!--[if supportFields]font color=3Dblackspan=20
 style=3D'color:black'span =
 style=3D'mso-element:field-begin'/spanspan=20
 style=3D"mso-spacerun: yes"nbsp;/spanAUTOTEXTLIST \s quot;E-mail=20
 Signaturequot; span =
 style=3D'mso-element:field-separator'/span/span/font![endif]--f=
 ont
 color=3Dblackspan =
 style=3D'color:black'***=
 */span/fontfont
 color=3Dblackspan =
 style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
 /p

 p class=3DMsoAutoSigfont size=3D3 color=3Dblack face=3DArialspan =
 style=3D'font-size:
 12.0pt;color:black'Jonathan R. Karlen/span/fontfont =
 color=3Dblackspan
 style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
 /p

 p class=3DMsoAutoSigfont size=3D3 color=3Dblack face=3DArialspan =
 style=3D'font-size:
 12.0pt;color:black'Karlen Internet Solutions/span/fontfont =
 color=3Dblackspan
 style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
 /p

 p class=3DMsoAutoSigfont size=3D3 color=3Dblack face=3DArialspan =
 style=3D'font-size:
 12.0pt;color:black'Web Site and Application =
 Development/span/fontfont
 color=3Dblackspan =
 style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
 /p

 p class=3DMsoAutoSigfont size=3D3 color=3Dblack face=3DArialspan =
 style=3D'font-size:
 12.0pt;color:black'http://www.karlen.com/span/fontfont =
 color=3Dblackspan
 style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
 /p

 p class=3DMsoAutoSigfont size=3D3 color=3Dblack face=3DArialspan =
 style=3D'font-size:
 

RE: XSLT And CF

2000-10-31 Thread David Gassner

It's pretty straightforward with the LotusXSL/Xalan processor.  Here's a
code snippet that does a transformation and saves the result to a text file:

!--- Create the parser factory, and get the parser ---
CFOBJECT TYPE=JAVA
ACTION=CREATE
CLASS="com.lotus.xsl.XSLProcessor"
NAME=xslProcessor

!--- Process the xml file ---
cfset currentDir=GetDirectoryFromPath(GetCurrentTemplatePath())
CFSET xslProcessor.process( "#currentDir#input.xml",
  "#currentDir#input.xsl", "#currentDir#output.html")

Also, MS just released the new version of their XML parser and they claim
it's up to date with the latest XSLT recommendation; I haven't tested it
yet, has anyone tried it out?

 Hey we're using CF to pull a bunch of data and I wanted to see if
 anyone has
 sucessfully integrated CF with XSLT?


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Application Variables

2000-10-30 Thread David Gassner

Since the application and server scopes are stored in structures, you could
clear them all with:

cfset structclear(application)
cfset structclear(server)

 -Original Message-
 From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, October 29, 2000 6:20 PM
 To: CF-Talk
 Subject: Application Variables


 Guys,

 Is there anyway of resetting application variables in CF? i.e. I have an
 application and would like administrators to be able to log in
 and select an
 option that resetsout all application and server variables.

 Thanks,

 Peter Alexandrou
 Technical Leader

 tapestry communications : www.tapestry.net.au
 level 4, 32 walker street
 north sydney NSW 2060 australia

 phone : +61 2 9929 7400
 mobile : +61 411 445 111
 e-mail : [EMAIL PROTECTED]

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: Application Variables

2000-10-30 Thread David Gassner

My mistake:

This works for application variables, but not for server variables.

David

- Original Message -
From: David Gassner [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 30, 2000 3:18 PM
Subject: RE: Application Variables


 Since the application and server scopes are stored in structures, you
could
 clear them all with:

 cfset structclear(application)
 cfset structclear(server)

  -Original Message-
  From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, October 29, 2000 6:20 PM
  To: CF-Talk
  Subject: Application Variables
 
 
  Guys,
 
  Is there anyway of resetting application variables in CF? i.e. I have an
  application and would like administrators to be able to log in
  and select an
  option that resetsout all application and server variables.
 
  Thanks,
 
  Peter Alexandrou
  Technical Leader
 
  tapestry communications : www.tapestry.net.au
  level 4, 32 walker street
  north sydney NSW 2060 australia
 
  phone : +61 2 9929 7400
  mobile : +61 411 445 111
  e-mail : [EMAIL PROTECTED]
 
  --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]
 

 --
--
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: insert br

2000-10-30 Thread David Gassner

Yes, you can use the Replace() function:

cfoutput
#Replace(myQuery.htmlText, Chr(10), "br")#
/cfoutput

- Original Message -
From: S R [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 30, 2000 7:00 PM
Subject: insert br


 Hi,

 I am creating a page that calls a text field from a SQL database. Some
lines
 of the text look like this:

 a new section that will be offered.

 Group Sales__The group sales that will
 be offered..

 By I need it to look like this:

 a new section that will be offered.

 Group Sales__

 The group sales that will be offered..

 So basically I need to parse through each message and insert a br at the
 end of these "lines" that appear. Would a "Replace" function be a good
place
 to start?

 Sal


 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

 Share information about yourself, create your own public profile at
 http://profiles.msn.com.

 --
--
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: CFERROR Usage

2000-10-29 Thread David Gassner

If you use CFERROR Type="Exception" rather than "Request" (the default
value), you can execute any CF commands in the Error template, including the
CFMAIL tag.

 -Original Message-
 From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, October 29, 2000 5:13 PM
 To: CF-Talk
 Subject: CFERROR Usage


 Hi guys,

 I haven't used CFCERROR before so would appreciate a little
 help with it.
 I am using it in my application.cfm file as advised and all is
 working with
 my error handling page.  Thing is, I want an e-mail to be sent to
 the site's
 webmaster when an error occurs.  The CFERROR tag includes a
 mailto attribute
 but this isn't sending out e-mails.  This seems to only make the variable
 available to the error handling page which is quite useless in my eyes.

 Since no CF code is executed in an error handling page, does
 anyone have any
 ideas?  I would prefer to stick with CFERROR rather than use CFTRY and
 CFCATCH exception handling.

 Regards,

 Peter Alexandrou
 Technical Leader

 tapestry communications : www.tapestry.net.au
 level 4, 32 walker street
 north sydney NSW 2060 australia

 phone : +61 2 9929 7400
 mobile : +61 411 445 111
 e-mail : [EMAIL PROTECTED]

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: cfcontent

2000-10-28 Thread David Gassner

It's:

CFHEADER NAME="Content-Disposition" VALUE="inline; Filename=#myfilename#"

 -Original Message-
 From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 12:29 PM
 To: CF-Talk
 Subject: cfcontent


 I'm using cfcontent to trigger the upload of a file. Does anyone remember
 the trick to faking cfcontent into using a file name other the name of the
 template it is located in?

 TIA,
 Duane

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: cfcontent

2000-10-28 Thread David Gassner

Duane, the complete code in getfile.cfm should be:

cfheader name="Content-Disposition"
  value="inline; Filename=#url.filename#"
cfcontent type=""
  file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
  deletefile="No"

This trick only works in the browser when trying to save the file to disk.
If the user opens the file directly in a host application (say, for a Word
document), the new file name won't be respected within Word when called from
within Internet Explorer.  I've also experimented with dropping out the
"inline;" part of the Value attribute and seen no change in behavior.

David

 -Original Message-
 From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 2:51 PM
 To: CF-Talk
 Subject: RE: cfcontent


 I tried that but it didn't work. I thought there was/is something that can
 be done to the url to fix this.

 In file one I have

 a href="getfile.cfm?filename=something.ext"GetFile/a

 in getfile.cfm:

 cfcontent type=""
 file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
 deletefile="No"

 Duane


  -Original Message-
  From: David Gassner [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, October 28, 2000 3:44 PM
  To: CF-Talk
  Subject: RE: cfcontent
 
 
  It's:
 
  CFHEADER NAME="Content-Disposition" VALUE="inline;
  Filename=#myfilename#"
 
   -Original Message-
   From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
   Sent: Saturday, October 28, 2000 12:29 PM
   To: CF-Talk
   Subject: cfcontent
  
  
   I'm using cfcontent to trigger the upload of a file. Does
  anyone remember
   the trick to faking cfcontent into using a file name other the
  name of the
   template it is located in?
  
   TIA,
   Duane
  
   --
   --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
   or send a message with 'unsubscribe' in the body to
   [EMAIL PROTECTED]
  
 
  --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Power of 3

2000-10-27 Thread David Gassner

Here's another entry:

cfset Value="81"

cfset compare="3"
cfset isPower=false
cfloop condition="(value gte compare)"
  cfif value is Compare
cfset isPower = true
cfbreak
  cfelse
cfset compare = compare * 3
  /cfif
/cfloop

cfoutput#isPower#/CFOUTPUT

 -Original Message-
 From: Jon Hall [mailto:[EMAIL PROTECTED]]
 Sent: Friday, October 27, 2000 9:36 AM
 To: CF-Talk
 Subject: Power of 3
 
 
 Anyone have an idea on how to check to see if a value is a power of 3?
 
 I have a loop that needs to fire an event at every power of three that it
 hits and I am having problems getting my brain around how I need 
 to do this.
 My first thoughts are to have a loopcounter and each time around 
 the counter
 is incremented check and see if the counter value is the Next power of
 three.
 The end effect is that the if statement is triggered the following
 intervals: 3,9,27,81...
 
 jon
 
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
 or send a message with 'unsubscribe' in the body to 
 [EMAIL PROTECTED]
 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: HTML Editor

2000-10-27 Thread David Gassner

Ah, thanks for the correction!

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Friday, October 27, 2000 9:51 AM
 To: CF-Talk
 Subject: RE: HTML Editor
 
 
 
 David, It also runs on Netscape via a plugin.  That is one of the reasons
 we chose it.
 
 Mary
 
 
   
  
 "David
  
 Gassner" To: CF-Talk 
 [EMAIL PROTECTED]   
 david@vintagcc:  
  
 eapps.com   Subject: RE: HTML 
 Editor  
   
  
 10/27/00  
  
 12:37 PM  
  
 Please
  
 respond to
  
 cf-talk   
  
   
  
   
  
 
 
 
 
 You might want to look at a product named eWebEditPro from Ektron:
 
 http://www.ektron.com/single.cfm?doc_id=36
 
 It's ActiveX-based, requires IE 4 or 5, but does a pretty good job.
 
 David
 
  -Original Message-
  From: Deepak Agarwal [mailto:[EMAIL PROTECTED]]
  Sent: Friday, October 27, 2000 8:50 AM
  To: CF-Talk
  Subject: HTML Editor
 
 
  This is a multi-part message in MIME format.
 
  --=_NextPart_000_0013_01C0400C.0B8318A0
  Content-Type: text/plain;
 charset="iso-8859-1"
  Content-Transfer-Encoding: quoted-printable
 
  Can anyone suggest me a good HTML Editor tag, that can be used in cfm =
  templates/Spectra.
 
  Thanks in advance.
 
  Deepak
  703.633.4257
 
  --=_NextPart_000_0013_01C0400C.0B8318A0
  Content-Type: text/html;
 charset="iso-8859-1"
  Content-Transfer-Encoding: quoted-printable
 
  !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
  HTMLHEAD
  META content=3D"text/html; charset=3Diso-8859-1" =
  http-equiv=3DContent-Type
  META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR
  STYLE/STYLE
  /HEAD
  BODY bgColor=3D#ff
  DIVFONT face=3DArialCan anyone suggest me a good HTML Editor tag, =
  that can be=20
  used in cfm templates/Spectra./FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArialThanks in advance./FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArialDeepak/FONT/DIV
  DIVFONT face=3DArial703.633.4257/FONT/DIV/BODY/HTML
 
  --=_NextPart_000_0013_01C0400C.0B8318A0--
  --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]
 
 --
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
 or send a
 message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]
 
 
 
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
 or send a message with 'unsubscribe' in the body to 
 [EMAIL PROTECTED]
 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Find character not in a list (reverse of FindOneOf).

2000-10-27 Thread David Gassner

Change this line:
  cfif not ListFind(variables.SomeList, i)

to:
  cfif not ListFind(variables.SomeList, Mid(FORM.Username, i, 1))

Otherwise you're looking for the numeric index in the looping sequence, not
the equivalent character in the form variable.

David

 -Original Message-
 From: Steve Martin [mailto:[EMAIL PROTECTED]]
 Sent: Friday, October 27, 2000 10:00 AM
 To: CF-Talk
 Subject: RE: Find character not in a list (reverse of FindOneOf).


 It's gonna be a little more extensive than that. The scenario is that we
 have a variable which contains n characters and a list which contains m
 elements. We need a function which returns true if one of the
 characters in
 the string does not occur in the list. For this we will have to loop over
 the string and compare each character.

 cfset stopcondition=0
 cfloop from=1 to=Len(FORM.Username) index=i
   cfif not ListFind(variables.SomeList, i)
   cfset stopcondition=1
   cfbreak
   /cfif
 /cfloop

 cfif stopcondition
   Do your stuff here
 /cfif

 Steve


  -Original Message-
  From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
  Sent: Friday, October 27, 2000 15:03
  To: CF-Talk
  Subject: Re: Find character not in a list (reverse of FindOneOf).
 
 
  erlistfind() function I mean.
 
  -d
 
 
 
  
  Deanna Schneider
  Interactive Media Developer
  UWEX Cooperative Extension Electronic Publishing Group
  103 Extension Bldg
  432 N. Lake Street
  Madison, WI 53706
  (608) 265-7923
 
 
 
  --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]
 

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Suppressing Repeating Groups in a Query

2000-10-27 Thread David Gassner

Sam, track the current value of the repeating field in a local variable; on
each loop, check whether the repeating field value has changed, and react
accordingly:

cfset currentID = 0
cfoutput query="myquery"
  tr
  cfif myquery.ID is currentID  !--- if it's repeated ---
td/tdtd/td
  cfelse!--- if it's new ---
td#myquery.id#/tdtdmyquery.field2/td
cfset currentID = myquery.ID
  /cfif
  td#myquery.statename#/td
  /tr
/cfoutput

 -Original Message-
 From: sam komolafe [mailto:[EMAIL PROTECTED]]
 Sent: Friday, October 27, 2000 2:07 PM
 To: CF-Talk
 Cc: sam komolafe
 Subject: Suppressing Repeating Groups in a Query


 Hi guys,

 How do you suppress repeating groups in a query? e.g.

 What I Have:
 1DN12California
 1DN12Oregon
 5DQ46Utah
 5DQ46New York
 9DZ09 Texas

 What I Want:
 1DN12California
 Oregon
 5DQ46 Utah
  Utah
 9DZ09  Texas

 Thanks

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Suppressing Repeating Groups in a Query

2000-10-27 Thread David Gassner

I don't see how Distinct would work in this case.  If any value in a record
is unique, you'll get a record.  The request was to suppress output of the
repeating fields in columns 1 and 2 where a 3rd column's value changes on
each record.  If the 3rd column is unique in each record, you'll need to
code the output in some fashion.

 -Original Message-
 From: John Cummings [mailto:[EMAIL PROTECTED]]
 Sent: Friday, October 27, 2000 6:30 PM
 To: CF-Talk
 Subject: Re: Suppressing Repeating Groups in a Query


 Or as Brian said, just use SELECT DISTINCT FROM XXX
 - Original Message -
 From: "David Gassner" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, October 27, 2000 8:56 PM
 Subject: RE: Suppressing Repeating Groups in a Query


  Sam, track the current value of the repeating field in a local variable;
 on
  each loop, check whether the repeating field value has changed,
 and react
  accordingly:
 
  cfset currentID = 0
  cfoutput query="myquery"
tr
cfif myquery.ID is currentID  !--- if it's repeated ---
  td/tdtd/td
cfelse!--- if it's new ---
  td#myquery.id#/tdtdmyquery.field2/td
  cfset currentID = myquery.ID
/cfif
td#myquery.statename#/td
/tr
  /cfoutput
 
   -Original Message-
   From: sam komolafe [mailto:[EMAIL PROTECTED]]
   Sent: Friday, October 27, 2000 2:07 PM
   To: CF-Talk
   Cc: sam komolafe
   Subject: Suppressing Repeating Groups in a Query
  
  
   Hi guys,
  
   How do you suppress repeating groups in a query? e.g.
  
   What I Have:
   1DN12California
   1DN12Oregon
   5DQ46Utah
   5DQ46New York
   9DZ09 Texas
  
   What I Want:
   1DN12California
   Oregon
   5DQ46 Utah
Utah
   9DZ09  Texas
  
   Thanks
  
   --
   --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
   or send a message with 'unsubscribe' in the body to
   [EMAIL PROTECTED]
  
 
 
 --
 --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe:
 http://www.houseoffusion.com/index.cfm?sidebar=lists or send
 a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]
 

 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 or send a message with 'unsubscribe' in the body to
 [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Suppressing Repeating Groups in a Query

2000-10-27 Thread David Gassner

No apologies required...but I love being right once in awhile!!! :)))

 My apologies Dave.  This is what you get when you quickly scan the mail.
 You are correct, I am wrong.
 
 In cases like this, I defer to the person who is correct and 
 reply from the
 corner with a quiet "D'oh!"
 
 :)


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Application.cfm in a CFMODULE

2000-08-10 Thread David Gassner

You can avoid this whole issue by using the Request scope for variables
which are set in application.cfm instead of application or session
variables.  Request variables aren't shared between threads, so they don't
need to be locked; and they are available for the entire page request,
including any nested custom tags.

 -Original Message-
 From: Peter Theobald [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 09, 2000 10:11 AM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Application.cfm in a CFMODULE


 html
 font size=3Since CFMODULE doesn't load Application.cfm, I can't use any
 of my Application.cfm settings in a module. For example, inside a module
 I cant use Session variables without this:br
 br
 CFLock cannot be used to lock the application or session shared scopes
 without these scopes being established through the use of the
 CFApplication tag. You must use CFApplication and specify an application
 name to use the application scope. If you want to use the session scope
 you need to enable session management as well. Application and/or Session
 variables must also be enabled in the ColdFusion Administrator.br
 br
 Should I lt;CFINCLUDE TEMPLATE=quot;Application.cfmquot;gt; to get
 all the settings? If this is something I will need in all my MODULEs, why
 doesn't CF just load it for MODULES?br
 br
 /fontbr

 br
 -font
 size=3---
 ---br
 Peter Theobald, Chief Technology Officerbr
 LiquidStreaming
 a href="http://www.liquidstreaming.com/"
 eudora="autourl"http://www.liquidstreaming.com/abr
 [EMAIL PROTECTED]br
 Phone 1.212.545.1232 Fax 1.212.679.8032br
 /font/html

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: I need a host. Intermedia testimonials

2000-08-08 Thread David Gassner

I have one site at Media3 - an intranet-style project management system
hosted for a client - and have had very few problems, and NO complaints from
my client over the course of about 18 months.

 -Original Message-
 From: Raymond K. Camden [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 08, 2000 8:09 AM
 To: [EMAIL PROTECTED]
 Subject: RE: I need a host. Intermedia testimonials


 Same here. Media3 hosts DeathClock.com (approx 2.2-2.5 million hits per
 month) and has served me well for around 2 years now. They aren't perfect,
 and I've had problems in the past, but it seems like they have been near
 perfect for many, many months now.

 ===
 Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
 Allaire Certified Instructor and Member of Team Allaire

 Email   : [EMAIL PROTECTED]
 ICQ UIN : 3679482

 "My ally is the Force, and a powerful ally it is." - Yoda


  -Original Message-
  From: Brian L. Wolfsohn [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, August 08, 2000 10:56 AM
  To: [EMAIL PROTECTED]
  Subject: RE: I need a host. Intermedia testimonials
 
 
  At 10:50 AM 8/8/00 , you wrote:
 
  we've use www.media3.net for over 3 years now.  i can recommend them
  highly.  we started out putting on individual domains, and now
  have 4 boxes
  co-located on their farm.
 
 
 

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problems with CFINSERT and Date/Time fields

2000-08-04 Thread David Gassner

Paul, try formatting the value with CreateODBCTime() - as in:

cfquery name="EventInsert" datasource="EventReg" dbtype="ODBC"
INSERT INTO Events(startTime, endTime, place)
Values(#CreateODBCTime(FORM.startTime)#,
#CreateODBCTime(FORM.endTime)#,
'FORM.place')
/cfquery

 -Original Message-
 From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 04, 2000 1:33 PM
 To: [EMAIL PROTECTED]
 Subject: Problems with CFINSERT and Date/Time fields


 I have a data entry form that captures several time fields. The
 corresponding database field is date/time. I've been using a
 simple CFINSERT
 to insert the data into the db.

 For some reason, the time field data is not getting into the db
 properly. No
 matter what time is entered in the form, it gets entered as 12:00:00 AM in
 the db.

 I have tried doing away with the simple CFINSERT and using a more lengthy
 CFQUERY thing, like:

 cfquery name="EventInsert" datasource="EventReg" dbtype="ODBC"
   INSERT INTO Events(startTime, endTime, place)
   Values('FORM.startTime', 'FORM.endTime',
 'FORM.place')
 /cfquery

 But this is giving me problems as well.

 What am I missing?

 Thanks.

 Paul Sinclair

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: How to get part of string?

2000-08-04 Thread David Gassner

Use the Mid() function:

newvariable = Mid(variable, startposition, endposition)

 -Original Message-
 From: PC [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 04, 2000 3:08 PM
 To: [EMAIL PROTECTED]
 Subject: How to get part of string?
 
 
 I must be missing something obvious -- but I need a function to set a
 variable to a range of characters within a string.
 
 I know the starting and ending indices -- how can I set a variable to the
 characters within that range? I don't see a function for that...
 
 THX
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.
 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Creating A List

2000-08-04 Thread David Gassner

Version 1:

 list = simg1,limg1,simg2,limg2...

cfset list=""
cfloop query="MakeList"
  cfset list = listAppend(list, SmallImage)
  cfset list = listAppend(list, LargeImage)
/cfloop

Or version 2:

 list= simg1,simg2,limg1,limg2...

CFSET LImage = valuelist(MakeList.LargeImage)
CFSET SImage = valuelist(MakeList.SmallImage)

CFSET ImageList = ListAppend( SImage, LImage )


 -Original Message-
 From: Jeffrey V. Lemire [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 04, 2000 2:06 PM
 To: CFTALK
 Subject: Creating A List


 Hello Folks!

 I was wondering if someone could point me in the right direction.
 Im trying
 to create a list that is derived from two columns. For example:

 cfquery name="MakeList" datasource="Cars"
   SELECT  LargeImage,SmallImage
   FROMCoolCars
   WHERE   CarID=#form.CarID#
 /cfquery

 CFSET LImage = valuelist(MakeList.LargeImage)
 CFSET SImage = valuelist(MakeList.SmallImage)

 CFSET ImageList = valuelist((SmallImage)  (LargeImage))

 I know that the cfset imagelist section is wrong
 becausewell...it does
 not work. Am I heading in the right direction or is there a
 better way to do
 this.

 TIA

 Jeffrey V. Lemire

 --
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: XML / XSL

2000-08-03 Thread David Gassner

To use Lotusxsl for transformations, the classpath in the CF Administrator
needs to include full paths to these files:
xalan.jar
Lotusxsl.jar

For instance:

c:\lotusxsl\lotusxsl.jar;c:\lotusxsl\xalan.jar

As Sean Renet pointed out awhile back, the KB article has some fatal errors.
Here are the fixes you need to apply to get it working:

1.  If you copy the example XSL file from the website, the xsl:stylesheet
tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl
processor to fail completely.  Instead of doing the transformation, it just
outputs the content of the original xsl file.  The namespace needs to be in
a continuous line, as follows:

xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

2.  The printWriter class isn't being closed, so the file containing the
wddx isn't being flushed to disk.  Add the following to the end of the code:

cfset printWriter.close()

3.  The resulting processed file isn't being read into a CF variable, so
add:

cffile action="read"
   file="[path]wddx_test.wddx"
   variable="wddx"

4.  When you try to run cfwddx to transform the wddx to a structure,
you'll get:

Error Diagnostic Information
unknown exception condition
TagCFWddx::execute

There is an error in the XSL file.  The "item" element is being mapped to a
named structure.  Since it's a structure within an array, it can't take a
name, causing the WDDX parser to fail.  Here's the corrected XSL file:


xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

!-- Match invoice root  emit WDDX packet wrapper --
xsl:template match="/invoice"
wddxPacket version="1.0"
header/
data
struct
xsl:apply-templates/
/struct
/data
/wddxPacket
/xsl:template


!-- Process all elements that map to array variables --
xsl:template match="billableHours"
var name="{name(.)}"
array length="{count(*)}"
xsl:apply-templates/
/array
/var
/xsl:template

!-- Process all elements that map to struct variables --
xsl:template match="invoice|contractorInfo|address"
var name="{name(.)}"
struct
xsl:apply-templates/
/struct
/var
/xsl:template


!--- Process structures inside arrays (no names) - this is the fixed
structure ---
xsl:template match="item"
struct
xsl:apply-templates/
/struct
/xsl:template

!-- Process all elements that map to string variables --
xsl:template
match="firstName|lastName|street|city|state|zip|country|voice|fax|email|
description|currency"
var name="{name(.)}"
string
xsl:value-of select="text()"/
/string
/var
/xsl:template

!-- Process all elements that map to number variables --
xsl:template match="invoiceID|employeeID|hours|amount"
var name="{name(.)}"
number
xsl:value-of select="text()"/
/number
/var
/xsl:template

!-- Process all elements that map to date-time variables --
xsl:template match="dateSubmitted|date"
var name="{name(.)}"
string
xsl:value-of select="text()"/
/string
/var
/xsl:template

/xsl:stylesheet


 -Original Message-
 From: dave fauth [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 02, 2000 5:32 PM
 To: [EMAIL PROTECTED]
 Subject: Re: XML / XSL


 Cary,

 It is an Allaire KB:

 http://www.allaire.com/handlers/index.cfm?ID=14244Method=Full

 Also, you may want to check here:

 http://www.sys-con.com/xml/archives/0102/gassner/index.html

 dave

 At 08:28 AM 8/2/00 -0700, you wrote:
 What KB article would that be?  I searched xml, xsl and lotus and found
 nothing like what you mentioned.
 
 Cary
 
 At 09:13 AM 8/2/2000 -0400, you wrote:
 Doug,
 
 I'm just getting started in XML/XSL with CF.  I've looked at the KB
 article from Allaire on it and have downloaded the Lotus XML parser.
 
 One question I have is how the set the Class Path.  The Lotus parser
 documentation isn't really clear on it.  It seems like there is
 a place in
 the CF administrator but there must be another place to do it.
 Anybody's
 help would be appreciated.
 
 I'm looking to both read XML into WDDX and also convert WDDX
 into XML via
 XSL.
 
 What kind of things are you doing with XML?
 
 dave
 
 -
 --
 ---
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 
 ---
 dave fauth
 [EMAIL PROTECTED]

 "The opinions expressed here
 are my own and not those of
 DOMAIN technologies, inc."
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 

Read HTTP Headers

2000-07-29 Thread David Gassner

Does anyone know of a way to read raw http headers from a form post?  For
instance, a form posts to a CF action page; other than the form fields, is
there any way for the CF action page to get at the other information in the
file header?

Thanks,
David

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Commenting Text in Studio

2000-07-28 Thread David Gassner

It's the 2nd button from the right on the CFML Basic toolbar.  Highlight the
text you want to comment, then click the button.

 -Original Message-
 From: Paige Chandler [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 27, 2000 10:24 PM
 To: [EMAIL PROTECTED]
 Subject: Commenting Text in Studio


 This is a multi-part message in MIME format.

 --=_NextPart_000_0009_01BFF832.922450D0
 Content-Type: text/plain;
   charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 Hi All,

 I saw someone at the last sig click on an icon in the upper right corner =
 (I believe) in Studio that automatically added the !--- --- to a block =
 of text. I can't remember how he did that.

 I can't find reference to that in the books or Help. I would appreciate =
 it if you could refresh my memory. TIA.

 Regards,

 Paige

 --=_NextPart_000_0009_01BFF832.922450D0
 Content-Type: text/html;
   charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
 HTMLHEAD
 META http-equiv=3DContent-Type content=3D"text/html; =
 charset=3Diso-8859-1"
 META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2I saw someone at the last sig click on =
 an icon in=20
 the upper right corner (I believe) in Studio that automatically added =
 the=20
 lt;!--- ---gt; to a block of text. I can't remember how he did=20
 that./FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2I can't find reference to that in the =
 books or=20
 Help. I would appreciate it if you could refresh my memory. =
 TIA./FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Regards,/FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Paige/FONT/DIV/BODY/HTML

 --=_NextPart_000_0009_01BFF832.922450D0--

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread David Gassner

The reason some developers use application variables for this case is the
variable protection in custom tags.  That is, a local variable set in
application.cfm isn't available in a custom tag except with use of the
caller scope.  A better approach, and one that avoids the need to cflock,
is use of the request scope (not well documented).  In application.cfm:

cfset request.dsn="mydsn"

And everywhere else:

...datasource="#request.dsn#"...

The request scope is non-persistent and non-shared, so it doesn't need to be
locked, but it's available for the entire page request, including custom
tags.

 -Original Message-
 From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 28, 2000 7:31 AM
 To: [EMAIL PROTECTED]
 Subject: RE: CFLOCKs is this really necessary?



For things like datasource names, wouldn't it just be easier to define
 it in application.cfm as a local variable? Why add the overhead of
 locking   / checking if it is defined then setting it, etc... at all?

 cfset DSN = 'mydata'

 instead of

 cflock ...
cfif not(isdefined(application.dsn))
 cfset application.dsn = 'mydata'
/cfif
 /cflock


 I am getting away from all application and session variables on my new
 sites.  They became more trouble than they are worth.

 Al Musella
 a1webs.com





 They *should* be locked.  Realisticly, I've got a million-hit-a-month
 site that does:
 Cfquery name="blah"
 datasource="#Application.OLEDBDSN#".../cfquery

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Fast Track to CF Course Providers

2000-07-21 Thread David Gassner

Both organizations use the same curriculum and the instructors for both
Allaire and roundpeg are certified to teach them, so there shouldn't be any
problem taking the courses from either provider.  I teach some of Allaire's
courses in SF, and have also taught for roundpeg; both are worthy
organizations...

David

 -Original Message-
 From: Braver, Ben: [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 21, 2000 10:06 AM
 To: '[EMAIL PROTECTED]'
 Subject: Fast Track to CF Course Providers


 Hi all,

 We would like to send several people to the Fast Track to CF
 courses in San
 Francisco.
 Both Allaire and roundpeg are listed as providers on Allaire's web site.
 Would appreciate any comments / preferences.

 Also, a couple of the people will need Fast Track to HTML first.
 Any problem with taking the HTML course from Allaire and the CF
 course from
 roundpeg?

 Thanks.

 Ben Braver
 Information Technology
 Tosco Refining Company
 San Francisco Area Refinery at Avon
 Martinez, CA  94553-1487
 (925) 370-3673 voice
 (925) 370-3393 fax
 (510) 716-2557 pager
 [EMAIL PROTECTED]



 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Preventing duplicates prior to insert

2000-07-21 Thread David Gassner

If you're trying to capture duplicates of a single field value, you could
use the database to catch the error.  Set the field properties as Indexed
(no duplicates) in Access.  Then wrap your cfquery in a cftry block to
capture the error:

cftry
  cfquery...
Insert ...
  /cfquery
  cfcatch type="database"
...There was an error in the insert statement...
  /cfcatch
/cftry

This will only stop exact matches (case-sensitive) and won't work if you
need to match multiple fields.

 -Original Message-
 From: Lisa Greenberg [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 21, 2000 10:50 AM
 To: cftalk
 Subject: Preventing duplicates prior to insert


 I would like to prevent duplicate entries from being
 inserted to a table (MS Access).  Is there a way to do this
 without querying the database and comparing the
 "pre-inserted data" with data currently in the table?

 Any leads in the right direction is most appreciated.

 -- Lisa

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF-Talk V1 #92

2000-07-21 Thread David Gassner

Your query doesn't have any joining statement in it; the duplicates might be
resulting from not properly joining the tables.

WHERE Stories.field1 = MailingList.field1, etc.

 -Original Message-
 From: Mark Smeets [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 21, 2000 11:24 AM
 To: [EMAIL PROTECTED]
 Subject: Re: CF-Talk V1 #92


 Hi again everyone,

 My last problem, I pray with this cfmail stuff. It would seem as
 I can send
 the mail without a prob but now I'm getting double entries in each email.
 How do I stop this? Here's the new/updated code.

 Again, any help is appreciated.

 ---

 CFQUERY NAME="News" DATASOURCE="OtherPress"
 SELECT Stories.Author,
Stories.Type,
Stories.Number,
Stories.ByLine,
Stories.Title,
MailingList1.Email,
Ads.Ads
 FROM Stories, MailingList1, Ads
 /cfquery

 CFMAIL QUERY="News" TO="[EMAIL PROTECTED]" FROM="The Other Press"
 SUBJECT="The Other Press Weekly Mailing List"

 Welcome #Email# to the Other Press Weekly Mailing List, here are
 this weeks
 stories

 cfoutput
 #Type# - #Title#
 By #Author# - #ByLine#
 Continue - http://24.113.34.178/op1999/Stories/story.cfm?Number=#Number#

 #Ads#
 /cfoutput

 -
 You are recieving this email because you are subscribed to the
 Other Press
 Mailing List. To Unsubscribe, please visit the Other Press website.

 /CFMAIL


 Mark Smeets/stranger0/ICQ #1062196

 "Mr. West, not every situation requires your patented approach of shoot
 first, shoot later, shoot some more and then when everybody's dead try to
 ask a question or two" - Wild Wild West

 Other Press Webslinger *New and Improved*
 http://otherpress.douglas.bc.ca/

 Official Splitting Adam Homepage
 http://www.splittingadam.com/

 Over the Wall Productions and Web Designs
 http://www.solarcourt.com/

 
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: URL Query String

2000-07-21 Thread David Gassner

If you want to pass a series of values without identifying each value's
source, you could send them as a single variable containing a
comma-delimited list, then use cfloop to loop through them:

cfset list=urlencodedformat("1,2,3,4")
cfoutput
a href="detailpage.cfm?list=#list#"Clicka
/cfoutput

and on the detail page:

cfloop list="#form.list#" index="item"
  ...#variables.item#...
/cfloop

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 21, 2000 7:59 AM
 To: [EMAIL PROTECTED]
 Subject: URL Query String


 Ok. This might be a simple question, but I am perplexed.

 I am executing a form that has 20 variables.  I want to be able to append
 all those variables on the next page to a URL Query String, i.e.
 template.cfm?a=1b=2c=3  .. etc.  Is there an easy way to do this instead
 of looping through the Fields that were passed or hard coding
 them into the
 template?  Thereby making the link on the following page dynamic based on
 the fields passed.

 In the same vein, is there a way to take "a=1b=2c=3... etc" out of the
 query sting and have it as ONE long variable to be used again going
 forward?

 Thanks,

 Vance Duke
 Cold Fusion Application Developer
 x4729


 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Access field names with spaces

2000-07-20 Thread David Gassner

You can alias the fields inside each query like this:

Select [Field Name] as FieldName
from [Table Name]


 -Original Message-
 From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 20, 2000 11:12 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Access field names with spaces


 There is nothing I would like more (well..there are a few things) than the
 rename the fields, but when you are connecting to somebody else's database
 you get into political BS!
 There is an article in the current issue of ColdFusion Advisor,
 but I can't
 locate the issue, and you can't get to it online without your username and
 password!

 Gr...having the answer, but not being able to get to it is worse than
 not having a clue!!!

 Tim

 
 Tim Claremont
 Xerox Corporation
 


 -Original Message-
 From: Allen G [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 20, 2000 2:10 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Access field names with spaces


 rename them!  =-)

 - Original Message -
 From: "Claremont, Timothy S" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, July 20, 2000 1:03 PM
 Subject: Access field names with spaces


  Can anyone tell me the secret to working with Access field
 names that have
  spaces in them?
 
  Thanks,
  Tim
 
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF Express

2000-07-18 Thread David Gassner

http://www.allaire.com/cfexpress


 -Original Message-
 From: John Allred [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, July 18, 2000 8:25 AM
 To: [EMAIL PROTECTED]
 Subject: CF Express


 Can anyone give me a URL where I can download CF Express? I found it on
 Allaire's site previously using search, but that's currently disabled.

 Thanks,
 John Allred

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Variable IN a list? How to check?

2000-07-15 Thread David Gassner

Use ListFind, which looks for a complete value:

cfif listfind( mylist, myvalue )

David

 -Original Message-
 From: Angel Stewart [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, July 15, 2000 6:52 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Variable IN a list? How to check?


 Yeah well this one win, dread.

 This man went and did Time Trials on the loop
 =)

 Now I'm totally confused as to which method to use..
 A CFLOOP with a CFIF Contains...
 Or one with a NOT GetListAt.
 (bear in mind that for htis particular problem, #DeptID# is a list of
 values,not necessarily a single value).

 -Gel


 - Original Message -
 From: Duane Boudreau [EMAIL PROTECTED]

  Sorry I didnt notice that you were adding two extra blank
 elements to the
  string.
 
  I tried time trials on this and over 100 iterations each the
 contains come
  out about an average of 250 ms faster
 
  Duane


 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Search---help

2000-07-15 Thread David Gassner

Vikram, you can do a quick replace function while outputting the value that
looks something like this:

cfoutput
  #replace(dbvalue, searchstring,
  "font color='blue'#searchstring#/font", "all")#
/cfoutput

David

 -Original Message-
 From: Vikram Ponuganti [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, July 15, 2000 5:47 AM
 To: [EMAIL PROTECTED]
 Subject: Search---help


 Hi,
 Iam new to cold fusion could any of the pros help me out..

 Well i have a search form where in i use the sql query to retrive

 the matching data... when i display the data I want the color of the
 matching text to be different,.,..

 expectin some fast help

 regards
 Vikram


 __
 FREE voicemail, email, and fax...all in one place.
 Sign Up Now! http://www.onebox.com

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Another Query to Table

2000-05-28 Thread David Gassner

Patric, you'll need to use the index array method of getting to query data.
Here's some code which does what you want, assuming a query named "q" and a
field called "fieldvalue":

!--- If number of items isn't divisible by three,
add one row ---
cfset numRows = q.recordcount / 3
cfif (numRows mod 3)
cfset numRows = int(numRows) + 1
/cfif

table cellpadding="5" cellspacing="0"
cfloop from=1 to="#numRows#" index="currentRow"

!--- Start the row with alternating colors ---
cfoutput
  tr bgcolor=#iif(currentRow mod 2,
de("silver"),
de("white"))#
/cfoutput

cfloop from="1" to="3" index="cellNumber"
  cfset dataIndex = (numRows * (cellNumber-1)) + currentRow
  td
  cfif dataIndex lte q.recordcount
cfoutput#dataindex#-#q.fieldvalue[dataIndex]#/cfoutput
  /cfif
  /td
/cfloop
/tr

/cfloop
/table

David Gassner
Vintage Business Applications

 but i wanted it like

 1   5   9
 2   6   10
 3   7   11
 4   8   12

 Hope this is possible...!?!

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Replacing crlf with br

2000-05-26 Thread David Gassner

cfset memovalue = replace(memovalue, chr(10), "br", "all")

David

 -Original Message-
 From: Jay Sudowski [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 26, 2000 2:36 PM
 To: [EMAIL PROTECTED]
 Subject: Replacing crlf with br


 This is a multi-part message in MIME format.

 --=_NextPart_000_01E6_01BFC738.EB595720
 Content-Type: text/plain;
   charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 Hi -

 I need to replace the crlf characters with the br tag so that line =
 breaks people enter while editing database content show up when they are =
 displayed.  I found a custom tag that will do this, but I'd like to =
 avoid calling it multiple times on the same page?

 Doing this should be possible with the replace function (or so I think), =
 but I'm not sure how to go about it.  Any ideas?

 Thanks,

 Jay

 --=_NextPart_000_01E6_01BFC738.EB595720
 Content-Type: text/html;
   charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
 HTMLHEAD
 META content=3D"text/html; charset=3Diso-8859-1" =
 http-equiv=3DContent-Type
 META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2Hi -/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2I need to replace the crlf characters =
 with the=20
 lt;brgt; tag so that line breaks people enter while editing database =
 content=20
 show up when they are displayed.nbsp; I found a custom tag that will do =
 this,=20
 but I'd like to avoid calling it multiple times on the same =
 page?/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2Doing this should be possible with the =
 replace=20
 function (or so I think), but I'm not sure how to go about it.nbsp; Any =

 ideas?/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2Jay/FONT/DIV/BODY/HTML

 --=_NextPart_000_01E6_01BFC738.EB595720--

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Credit Card Payment - Java or Perl ?

2000-05-25 Thread David Gassner

Ken, which vendor is this?  Surepay by any chance?  If so, they also have an
XML version.

I can't speak to CFEXECUTE, haven't used it.  CFOBJECT works well with Java
classes, as it allows you to send and receive information by calling class
methods.

David Gassner
Vintage Business Applications

 -Original Message-
 From: Ken M. Mevand [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 24, 2000 9:29 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Credit Card Payment - Java or Perl ?


 thanks. my vendor has both Java classes and Active Perl script
 ready. i was
 just wondering which would be better supported by CF.

 Do i use CFEXECUTE for Perl and CFOBJECT for Java?  if so, maybe the
 question should be which tag is better?

 TIA

 - Original Message -
 From: David Gassner [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, May 24, 2000 11:16 PM
 Subject: RE: Credit Card Payment - Java or Perl ?


  If the vendor has a java component ready to use, you can call it from
  cfobject.  As Justin says, if you have to code everything
 from scratch,
  it's probably a question of which language you're more comfortable with.
 
  David
 
   -Original Message-
   From: Ken M. Mevand [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, May 24, 2000 6:12 AM
   To: 02 cf-talk
   Subject: Credit Card Payment - Java or Perl ?
  
  
   i have a site which will be accepting credit card payments.
 my solution
   provide has 2 methods of clearing credit cards, using Active Perl or
 Java.
  
   in your opinions, which method is better from the point of view of CF.
 my
   site is running virtual server on Win NT with CF4.5.1 and MS SQL7.
  
   thanks
  
   -ken
  
  
   --
   
   Archives: http://www.eGroups.com/list/cf-talk
   To Unsubscribe visit
   http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
   _talk or send a message to [EMAIL PROTECTED] with
   'unsubscribe' in the body.
  
 
 
 --
 
  Archives: http://www.eGroups.com/list/cf-talk
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: OT- Premiere Partners

2000-05-25 Thread David Gassner

Start at this URL; it depends on what kind of partner...

http://www.allaire.com/handlers/index.cfm?ID=10208


 -Original Message-
 From: Ian Lurie [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, May 25, 2000 7:58 AM
 To: '[EMAIL PROTECTED]'
 Subject: OT- Premiere Partners
 
 
 Hi all,
 
 What are the Allaire reqs for becoming a premiere partner? I've 
 searched the
 site and sent an email - no dice...
 
 Ian
 
 Portent Interactive
 http://www.portentinteractive.com
 Process, Design, Content
 
 Market Matrix
 http://www.marketmatrix.com 
 Secure Commerce for Your Business
 
 Working together to create powerful, usable web solutions.
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.
 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: xml and wddx problems

2000-05-25 Thread David Gassner

You can use one of the xml processors to read and parse the xml file; either
MS' COM-based or the lotusxsl java-based or another.  I can help with the
syntax if you can get your hands on a sample xml file.

David

 -Original Message-
 From: eyal gaisler [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 24, 2000 10:39 AM
 To: [EMAIL PROTECTED]
 Subject: Re: xml and wddx problems


 libarary is like :

 c:\eyal

 eyal is a libarary containe number of files, one of them is a xml
 file that
 has in it the name,password, and the names of the files the user
 is intitle
 to see!

 i don't have the exact xml file becose i didn't write it!



 - Original Message -
 From: "David Gassner" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, May 24, 2000 4:54 PM
 Subject: RE: xml and wddx problems


  Eyal, can you give more detail?  What do you mean by "library"
 - a url, a
  specific xml file, a database location?
 
  Can you post an example of the xml file?
 
  David
 
   -Original Message-
   From: eyal gizler [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, May 24, 2000 3:10 AM
   To: [EMAIL PROTECTED]
   Subject: xml and wddx problems
  
  
   Hi,
  
   I have a project that I need the user to enter his name and
   password and the
   name of a library.
   then I need to go to that library and get a xml file from there that
   describe the content of the library.
   in the xml I will have the user name and password that allow
 to see the
   files in that library!
  
   how can I get the xml file from the specified library and compare
   it to the
   user name and password the user has entered?
  
   eyal
  
   --
   
   Archives: http://www.eGroups.com/list/cf-talk
   To Unsubscribe visit
   http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
  _talk or send a message to [EMAIL PROTECTED] with
  'unsubscribe' in the body.
 
 
 --
 
  Archives: http://www.eGroups.com/list/cf-talk
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: xml and wddx problems

2000-05-24 Thread David Gassner

Eyal, can you give more detail?  What do you mean by "library" - a url, a
specific xml file, a database location?

Can you post an example of the xml file?

David

 -Original Message-
 From: eyal gizler [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 24, 2000 3:10 AM
 To: [EMAIL PROTECTED]
 Subject: xml and wddx problems


 Hi,

 I have a project that I need the user to enter his name and
 password and the
 name of a library.
 then I need to go to that library and get a xml file from there that
 describe the content of the library.
 in the xml I will have the user name and password that allow to see the
 files in that library!

 how can I get the xml file from the specified library and compare
 it to the
 user name and password the user has entered?

 eyal

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Credit Card Payment - Java or Perl ?

2000-05-24 Thread David Gassner

If the vendor has a java component ready to use, you can call it from
cfobject.  As Justin says, if you have to code everything from scratch,
it's probably a question of which language you're more comfortable with.

David

 -Original Message-
 From: Ken M. Mevand [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 24, 2000 6:12 AM
 To: 02 cf-talk
 Subject: Credit Card Payment - Java or Perl ?


 i have a site which will be accepting credit card payments. my solution
 provide has 2 methods of clearing credit cards, using Active Perl or Java.

 in your opinions, which method is better from the point of view of CF. my
 site is running virtual server on Win NT with CF4.5.1 and MS SQL7.

 thanks

 -ken


 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Help needed on CF-OBJECT and XSLT ....

2000-05-23 Thread David Gassner

Ed, the classpath in the CF Administrator should include the jar file itself
with a full path; for instance, I'm using IBM's Xerces processor, and have
placed the xerces.jar file in the c:\cfusion\java\classes directory.  My
classpath looks like this:

c:\cfusion\java\classes;c:\cfusion\java\classes\xerces.jar

The JVM path is the name and location of jvm.dll, whereever you've installed
the 1.2x or 1.3 jvm.  Mine is in:

c:\jdk1.3\jre\bin\classic\jvm.dll

It sounds like you've got that part right, since you're getting a java
error, but the classpath may need some adjustment.

David

 -Original Message-
 From: Ed Dunn [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 23, 2000 8:49 AM
 To: [EMAIL PROTECTED]
 Subject: Help needed on CF-OBJECT and XSLT 


 Hi,
 I followed the technical tips from Allaire on using XSLT and WDDX.I have
 been trying to get the Java based Lotus XSL processor to work in
 Cold Fusion
 but without any luck.

 What do I set  the ClassPath in the Coldfusion administrator?
 What do I set
 the cfx jar path to? And the java virtual machine path?  I think i install
 sun's java jvm correctly. I thought I set the paths correctly too
 but  I get
 the following error:

 Error Diagnostic Information
 Unhandled System exception !
 java.lang.NoClassDefFoundError: com/lotus/xsl/XSLProcessor. Java exception
 occurred in attempt to locate class 'com/lotus/xsl/XSLProcessor'
 (you should
 verify that the class is in the CLASSPATH).
 The error occurred while processing an element with a general
 identifier of
 (CFOBJECT), occupying document position (55:1) to (59:24).
 Date/Time: 05/22/00 21:50:47
 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
 Remote Address: 127.0.0.1

 Thanks a lot,
 Ed

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: XML Question

2000-05-23 Thread David Gassner

Sean, I got Allaire's example working.  I found these problems based on the
version I copied from the Allaire website:

1.  If you copy the example XSL file from the website, the xsl:stylesheet
tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl
processor to fail completely.  Instead of doing the transformation, it was
just outputting the content of the original xsl file.  The namespace needs
to be in a continuous line, as follows:

xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

2.  The printWriter class wasn't being closed, so the file containing the
wddx was never being flushed to disk.  I added the following to the end of
the code:

cfset printWriter.close()

3.  The resulting processed file wasn't being read into a CF variable, so I
added:

cffile action="read"
   file="[path]wddx_test.wddx"
   variable="wddx"

4.  Next, when I tried to run cfwddx to transform the wddx to a structure,
I got:

Error Diagnostic Information
unknown exception condition
TagCFWddx::execute

There was an error in the XSL file: the "item" element was being mapped to a
named structure; since it was a structure within an array, it couldn't take
a name, causing the WDDX parser to fail.  I corrected the XSL file, and
everything now works.  Here's my corrected XSL file:


xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

!-- Match invoice root  emit WDDX packet wrapper --
xsl:template match="/invoice"
wddxPacket version="1.0"
header/
data
struct
xsl:apply-templates/
/struct
/data
/wddxPacket
/xsl:template


!-- Process all elements that map to array variables --
xsl:template match="billableHours"
var name="{name(.)}"
array length="{count(*)}"
xsl:apply-templates/
/array
/var
/xsl:template

!-- Process all elements that map to struct variables --
xsl:template match="invoice|contractorInfo|address"
var name="{name(.)}"
struct
xsl:apply-templates/
/struct
/var
/xsl:template


!-- Process structures inside arrays (no names) --
xsl:template match="item"
struct
xsl:apply-templates/
/struct
/xsl:template

!-- Process all elements that map to string variables --
xsl:template
match="firstName|lastName|street|city|state|zip|country|voice|fax|email|
description|currency"
var name="{name(.)}"
string
xsl:value-of select="text()"/
/string
/var
/xsl:template

!-- Process all elements that map to number variables --
xsl:template match="invoiceID|employeeID|hours|amount"
var name="{name(.)}"
number
xsl:value-of select="text()"/
/number
/var
/xsl:template

!-- Process all elements that map to date-time variables --
xsl:template match="dateSubmitted|date"
var name="{name(.)}"
string
xsl:value-of select="text()"/
/string
/var
/xsl:template

/xsl:stylesheet



I'll pass this info to the folks at Allaire.
--David

 -Original Message-
 From: Sean Renet [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 23, 2000 5:53 PM
 To: [EMAIL PROTECTED]
 Subject: Re: XML Question


 yes, you would think someone would have tested the knowledge base article.
 I though it necessary to point this out as you directed someone that asked
 how to parse an XML file into CFML to your article which
 references this doc
 as the means to do such.
 - Original Message -
 From: "David Gassner" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, May 23, 2000 11:27 AM
 Subject: RE: XML Question


  Interesting; I never actually tested Allaire's approach, but
 included the
  reference in my article for the sake of completeness.  My
 article focuses
 on
  parsing xml file's document object model, rather than
 translation with xls
  (which the knowledgebase article deals with).
 
  Side note: I've been playing with IBM's java-based xerces processor from
  cfobject and have been having some good results.
 
  David
 
   -Original Message-
   From: Sean Renet [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, May 23, 2000 11:09 AM
   To: [EMAIL PROTECTED]
   Subject: Re: XML Question
  
  
   David,
   The "Tech Note" you are refering to "
   www.allaire.com/handlers/index.cfm?ID=14244Method=Full#1020244 "
does not
   work.  I have an open incident with Allaire, wherein they are
 trying to
   figure out why.  Evidently after they fix the problem they
 are going to
   update the knowledge base article.
   - Original Message -
   

RE: Allaire's strategy re CF???

2000-05-22 Thread David Gassner

Allaire has announced that the next version of ColdFusion server will be a
merging of CF and JRun into a single java-based server; that doesn't mean
they're abandoning CF.  They've said that applications written in CF and in
JRun (servlets and JSP) will both be compatible with the new platform.  The
CFML language will remain the key to rapid deployment, but the fact that the
server's "innards" are based on java servlets should improve performance,
scalability, extensibility, and cross-platform capabilities.

Take a look at the white paper at:

http://www.allaire.com/DocumentCenter/Partners/AllaireBusinessPlatform1.PDF

David

 -Original Message-
 From: Simha R. Magal [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 22, 2000 6:28 AM
 To: [EMAIL PROTECTED]
 Subject: Allaire's strategy re CF???


 Greetings,

 I ran into the following e-mail message and wondered if any of you
 (especially those close to Allaire) have any thoughts on the matter.

 ". Allaire is not moving forward with its Cold Fusion product. Instead
 they are supporting their J server and Spectra product. Basically they are
 transitioning into a complete Java solution ."


 Thanks,

 Simha

 --

 Simha R. Magal ([EMAIL PROTECTED])
 Internet Commerce Solutions www.magal.com
 Placement Online dot com www.PlacementOnline.com
 Voice:  419-353-6822  Fax:  353-3522
 --
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: HELP!!! Can I set a delay with cfhttp?

2000-05-22 Thread David Gassner

Bud, is the first page being sent back then calling a secondary page after
the transaction is completed?  Look in the returned HTML text and see
whether there's a meta tag doing a refresh to call the second page; you
may be able to setup  cfhttp to call the secondary page directly.  If not,
call the vendor and see whether they have an api for server-to-server calls,
as the api you're using is clearly designed for browser use.

David

 -Original Message-
 From: Bud [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 22, 2000 10:09 AM
 To: [EMAIL PROTECTED]
 Subject: HELP!!! Can I set a delay with cfhttp?


 Hi. I'm writing a tag for a card processor (linkpoint) for a customer
 of mine. I'm having a problem. After submitting the cfhttp parameters
 and waiting on validation to return, I'm getting this loading on the
 page first:

 --string
 Content-type: text/html

 BProcessing order.  Please wait.../BBR

 Unfortunately, it seems as if ColdFusion thinks this is the full
 extent of the cfhttp.filecontent and finishes loading the page before
 I can do any sort of conditional settings based on the content. I've
 tried doing a replace and setting a variable of 'content' and reading
 that, but then it just reads as an empty variable. Is there any way I
 can make CF wait until the full content is returned?

 Thanks,

 Bud Schneehagen - Tropical Web Creations

 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 ColdFusion Solutions / eCommerce Development
 [EMAIL PROTECTED]
 http://www.twcreations.com/
 954.721.3452
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: WDDX OR XML News Feeds

2000-05-22 Thread David Gassner

www.isyndicate.com does feeds in XML and javascript formats.  The free
version sends only a link which maps to their site, then bounces the user to
the correct website containing the content.  Paid versions contain both
headline and content.

David

 -Original Message-
 From: Robert Everland [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 22, 2000 12:45 PM
 To: '[EMAIL PROTECTED]'
 Subject: WDDX OR XML News Feeds


   Can anyone give me a link where I may be able to get some news feeds
 off of sites so that I may put them on my intranet. Please specify if they
 carry the whole story or only headlines.

 Robert Everland III
 Web Developer
 Dixon Ticonderoga
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFStudio app Complaint...who do I complain to?

2000-05-20 Thread David Gassner

Loretta, in regard to issue #1, take a look at the new project management
features.  You can set up a project with links to both local and remote
directories which will then appear on the same tab; this should make
switching back and forth between local and remote directories even easier
than it was with the old system.

David

 -Original Message-
 From: Nick  Loretta Pioch [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 19, 2000 2:22 PM
 To: [EMAIL PROTECTED]
 Subject: CFStudio app Complaint...who do I complain to?


 Just was wondering what the contact info might be to submit a
 "suggestion" for changes to CFStudio...contact info such that my
 suggestion won't necessarily be lost in the black pit of all
 suggestions.
 ok...part of my hope is that someone from Allaire will read this as
 well

 With Studio 4.5.1, (or maybe it's just 4.5.*), the RDS tab was taken
 away, and RDS as well as local files are located under the same tab.  As
 a remote developer, this is highly annoying for the following reasons:

 1.  I develop locally, with the exact same set up as the test machine
 (rds).  So often, I like to tab back and forth between the local and RDS
 files / directories...but can no longer with this new implementation.

 2.  When I save a pile of local files to RDS, the SaveAs window no
 longer remembers the last RDS location I saved to...it always takes me
 to the top-level of MY machine (actually...stupidly enough...to where
 Studio is installed!)...causing me tons of clicks or tab-returns to
 select the RDS location/directories that I need.  With many files at
 once, I can spend quite a time just doing this traversing!

 3.  If Studio *is* configurable to make #1 and #2 above easier (please
 let me know how...and...), make that documentation much more obvious,
 'cause I can't find it!!!

 Thanks for your help / info!
 -- Loretta Pioch

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: java class from CF template

2000-05-19 Thread David Gassner

Jason,

You can call it from cfobject or redesign it as a CFX_Java class.

If calling from cfobject, you will need to design a public constructor
with the appropriate number of arguments, then call it as follows:

cfobject type="java" action="create" name="myObj" class="Auth"
cfset myObj.init(arg1, arg2, ...)

If redesigning as a Java CFX, you'll pass the arguments as named values in
the CFX call:

CFX_Auth arg1="val1" arg2="val2"

For returning the variable, with CFObject you can create and call a public
method which returns the value:

cfset ret=myObj.getReturnText()

or in CFX, set it directly from within the java class using the
Response.setVariable() method.

David

 -Original Message-
 From: Jason Egan [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 19, 2000 7:32 AM
 To: Cf-Talk
 Subject: java class from CF template


 I have a java .class file that I can run from the command line:

 Java Auth ISPtest DBAUTH.txt OUT.txt

 The name of the class file is Auth.class, how can I run this from A CF
 template?? Can I make this a cfx tag?  Or pass the parameters to it in any
 other way???  The dbauth.txt is the packet to send, and the out.txt is a
 text file of the received packet…

 Once the application has executed, I will need to have the out.txt as a
 variable… I can read the text file, but if it is called from the template
 and can be stored as a variable rather than a text file I think this will
 work better….

 Anyone
 je

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Can I stop the JVM from caching classes?

2000-05-16 Thread David Gassner

I'm learning all about calling Java classes with CFOBJECT and building CFX_J
tags. Everything works fine on the first call to a compiled class, but if I
modify and recompile the class, then try to run the calling CF page again,
it calls the old version of the class unless I stop and restart CF server.
I'm sure there's a performance benefit, but during development it's a pain.

Does anyone know of any initialization options I can put into CF
Administrator to tell the JVM to reload classes each time they're called?

I'm working with CF 4.51, NT 4.0, Sun JVM 1.3.

Thanks,
David

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Help Parsing a String

2000-05-15 Thread David Gassner

Erika, you can treat it as a list with "/" as the delimiter:

cfset list="14/12"
cfset firstnumber=listGetAt(list, 1, "/")
cfset firstnumber=listGetAt(list, 2, "/")

David Gassner
Vintage Business Applications

 -Original Message-
 From: Erika Foster [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 15, 2000 9:38 PM
 To: [EMAIL PROTECTED]
 Subject: Help Parsing a String


 I have a field that contains the number of authorized vehicles vs. the
 number of assigned vehicles like this: 14/12.  What function
 would  I use to
 grab everything to the left of the "/" and then everything to the right of
 the "/" to display them in separate text boxes?

 Thanks,


 Erika Foster
 engineering-environmental Management
 Applications Developer
 (505) 866-1654
 [EMAIL PROTECTED]

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Previous Install Problem

2000-04-09 Thread David Gassner

Jim, what drive  directory do you have CF installed in?  I had the same
problem until I reinstalled 4.5 in the default C:\CFUSION directory, and
then the upgrade worked.

David Gassner
Vintage Business Applications

 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 08, 2000 8:04 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Previous Install Problem


 It never prompts me.  As soon as I agree to the license I get the "Severe:
 The upgrade requires a previous installation" warning and the install
 program closes.

 -Original Message-
 From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 08, 2000 4:55 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Previous Install Problem


 You should be prompted for your CF 4.5 serial number. Then you
 will need to
 enter it again on the next screen. Worked for me - I even installed it
 remotely using NetMeeting.

 -Original Message-
 From: paul smith [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, 9 April 2000 4:08 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Previous Install Problem


 Was CF4.5 installed when you tried to upgrade to 4.5.1?
 If not, this is needed.  Same thing happened to me.

 best,  paul

 At 01:45 PM 4/8/00 -0400, you wrote:
 When attempting to upgrade CF Pro 4.5 to 4.5.1 I get following error:
 "Severe: The upgrade requires a previous installation". I looked
 this up in
 both the forums and knowledge base and there were several
 complaints about
 this but I did not fine a method to fix this.  Please Help
 
 
 Jim Watkins
 NGT Blairsville Campus
 (706)781-2305
 http://www.clarkes.tec.ga.us/Blairsville
 -
 --
 ---
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/c
f_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Left X characters without breaking a word...

2000-04-08 Thread David Gassner

How about:

cfset textVar = "This is a really wonderful, and nice chunk of text."
cfloop from="21" to="1" step="-1" index="CharPosition"
  cfif Mid(textVar, CharPosition, 1) is " "
cfset first20 = Left(textVar,(CharPosition - 1))
    cfbreak
  /cfif
/cfloop
cfoutput#first20#/cfoutput

David Gassner
Vintage Business Applications

 -Original Message-
 From: Chris Lott [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 08, 2000 12:58 AM
 To: [EMAIL PROTECTED]
 Subject: Left X characters without breaking a word...


 Any ideas on the most efficient way to grab the leftmost 20
 characters of a
 field, or as close as possible without going over, but without chopping a
 word in the middle? For instance, given the following text:

 This is a really wonderful, and nice chunk of text.

 I would want to break it after "Really" because taking the first 20 would
 break the text in the middle of the word "wonderful"...

 c
 --
 Chris Lott [EMAIL PROTECTED],  Technical Manager
 p907.474.5122  |  f907.474.5402  |  PGP Key ID: 0x8687E87E

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Previous Install Problem

2000-04-08 Thread David Gassner

Is that what I have to do?

What about all the new customers who bought 4.5 and don't have 4.0?  Oh,
never mind.

David Gassner
Vintage Business Applications

 -Original Message-
 From: paul smith [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 08, 2000 12:22 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Previous Install Problem


 At 02:08 PM 4/8/00 -0400, you wrote:
 Yes 4.5 is installed but when I try to reinstall 4.5 I get the
 same "upgrade
 requires a previous installation" problem

 Right.  Same here.  I had to install CF 4.0

 Both CF 4.5 and 4.5.1 are upgrades.  (Damn large for an upgrade, too!)

 best,  paul


 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Previous Install Problem

2000-04-08 Thread David Gassner

I've tried this from 4.51 RC1, 4.5, and 4.01, and I'm getting the same
message and abort each time.  Has anyone figured this out?

David Gassner
Vintage Business Applications

 -Original Message-
 From: paul smith [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 08, 2000 12:22 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Previous Install Problem


 At 02:08 PM 4/8/00 -0400, you wrote:
 Yes 4.5 is installed but when I try to reinstall 4.5 I get the
 same "upgrade
 requires a previous installation" problem

 Right.  Same here.  I had to install CF 4.0

 Both CF 4.5 and 4.5.1 are upgrades.  (Damn large for an upgrade, too!)

 best,  paul


 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Previous Install Problem

2000-04-08 Thread David Gassner

Answer to my own question:

I'd installed CF on a non-default drive.  I re-installed 4.5 from the CD in
the default location (c:\cfusion), and the upgrade went just fine.

David

 -Original Message-
 From: David Gassner [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 08, 2000 1:07 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Previous Install Problem


 I've tried this from 4.51 RC1, 4.5, and 4.01, and I'm getting the same
 message and abort each time.  Has anyone figured this out?

 David Gassner
 Vintage Business Applications

  -Original Message-
  From: paul smith [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, April 08, 2000 12:22 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Previous Install Problem
 
 
  At 02:08 PM 4/8/00 -0400, you wrote:
  Yes 4.5 is installed but when I try to reinstall 4.5 I get the
  same "upgrade
  requires a previous installation" problem
 
  Right.  Same here.  I had to install CF 4.0
 
  Both CF 4.5 and 4.5.1 are upgrades.  (Damn large for an upgrade, too!)
 
  best,  paul

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: dynamic data sets?? outputs?

2000-04-07 Thread David Gassner

Joe, if you want to see the field names, try this:

cfquery Name="Get_fields" datasource="Personal"
  Select * from  table_name
/cfquery

cfloop list="#get_fields.columnlist#" index="fieldname"
  cfoutput#fieldname#br/cfoutput
/cfloop

If you want to see the data:

table
cfoutput query="get_fields"
tr
cfloop list="#get_fields.columnlist#" index="fieldname"
  td
  #evaluate("get_fields.#fieldname#")#
  /td
/cfloop
/tr
/cfoutput
/table

David Gassner
Vintage Business Applications

 -Original Message-
 From: Joseph Eugene [mailto:[EMAIL PROTECTED]]
 Sent: Friday, April 07, 2000 5:37 PM
 To: [EMAIL PROTECTED]
 Subject: dynamic data sets?? outputs?


 Hello all,
   I am using this code to find the fields in the
 table  i want
 to dynamically generate the output.

 cfquery Name="Get_fields" datasource="Personal"
 Select * from  table_name
 /cfquery
 cfoutput
 cfset x=#ListLen(Get_Fields.ColumnList)#
 #x#br
 /cfoutput
 cfloop index="z" from="1" to="#x#"
 cfset output=#GetToken(Get_Fields.ColumnList, #z#, ",")#
 cfoutput#output#/cfoutput
 /cfloop

 how can i output the fields of the table, i tried different
 things, cant get
 it to work.
 Thanks inadvance, appretiate it.

 Joe



 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Combining Cf and ASP in the same Template

2000-04-03 Thread David Gassner

Steve, could you describe the steps for configuring this?

 -Original Message-
 From: Steve Reich [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 03, 2000 8:15 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Combining Cf and ASP in the same Template


 Yes it is possible. You can set CF to parse any file extension
 you want. If
 you set it to look for CF code in an ASP page, then the ASP code will get
 processed and then sent to CF server to parse the CF code. This can easily
 be done and seems to work fine. I'm not sure what the performance
 drain is.

 Steve

 -Original Message-
 From: David Gassner [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 03, 2000 10:35 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Combining Cf and ASP in the same Template


 No, since the page is sent either to the ASP engine or to CF depending on
 the file extension, they can't be combined.

  -Original Message-
  From: Eric Sheetz [mailto:[EMAIL PROTECTED]]
  Sent: Monday, April 03, 2000 6:42 AM
  To: [EMAIL PROTECTED]
  Subject: Combining Cf and ASP in the same Template
 
 
  Is it possible to combine Cf and ASP in the same template?  If so, are
  there any "gotchas" I need to be aware of?
 
  Thanks,
  Eric
 
  --
  
  Archives: http://www.eGroups.com/list/cf-talk
  To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.

 --
 --
 --
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Balanced Web Server

2000-04-01 Thread David Gassner

As you say, client variables are stored on disk can be shared between
servers, while session variables are stored in server memory and are only
available to that server.  The other difference: client variables are
limited to strings, while session vars can store arrays and structures.  You
can store the more complex variables in client vars by serializing them to
WDDX strings; see the CFWDDX tag for more info.

 -Original Message-
 From: Brian Peddle [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 31, 2000 5:37 PM
 To: [EMAIL PROTECTED]
 Subject: Balanced Web Server


 I am moving to a new location where load balancing is used.  I
 know CF ships with bright tiger but I dont think I need to use
 that at this point.

 My only concern is session variables.

 I only store 3 session variables in my application.  With load
 balancing I know this causes a problem unless I use Bright Tiger
 and sticky sessions.

 Could I just switch them over to client variables and store the
 clients in the database?

 Would this solve the problem?  What are differences between
 clients and session vars.  They seem very similiar.  Is it that
 sessions are stored in memory while clients are stored in the
 registry/database/or cookie?

 Thanks
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Balanced Web Server

2000-04-01 Thread David Gassner

Only client variables can be saved to a datasource.  Session variables are
always stored in server memory.

 -Original Message-
 From: Nick McClure [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, April 01, 2000 10:25 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Balanced Web Server


 But what about when you have your session variables saving to a
 datasource.

 Shouldn't they be able to be seen by both servers assuming both of them
 have the correct application name and session datasource.

 At 10:01 AM 4/1/2000 -0800, you wrote:
 As you say, client variables are stored on disk can be shared between
 servers, while session variables are stored in server memory and are only
 available to that server.  The other difference: client variables are
 limited to strings, while session vars can store arrays and
 structures.  You
 can store the more complex variables in client vars by
 serializing them to
 WDDX strings; see the CFWDDX tag for more info.
 
   -Original Message-
   From: Brian Peddle [mailto:[EMAIL PROTECTED]]
   Sent: Friday, March 31, 2000 5:37 PM
   To: [EMAIL PROTECTED]
   Subject: Balanced Web Server
  
  
   I am moving to a new location where load balancing is used.  I
   know CF ships with bright tiger but I dont think I need to use
   that at this point.
  
   My only concern is session variables.
  
   I only store 3 session variables in my application.  With load
   balancing I know this causes a problem unless I use Bright Tiger
   and sticky sessions.
  
   Could I just switch them over to client variables and store the
   clients in the database?
  
   Would this solve the problem?  What are differences between
   clients and session vars.  They seem very similiar.  Is it that
   sessions are stored in memory while clients are stored in the
   registry/database/or cookie?
  
   Thanks
   --
   
   Archives: http://www.eGroups.com/list/cf-talk
   To Unsubscribe visit
   http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.
 
 -
 -
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/c
f_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Nick McClure[EMAIL PROTECTED]
Technical Director  606.245.9656
squareFish Mediawww.squareFish.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: XML to Structure

2000-03-31 Thread David Gassner

I've used the MS XMLDOM COM object to read an XML file with 1-to-many
relationships into an multi-dimensional array of structures.  I haven't used
on a very large document, but I suppose that given sufficient memory and
time it would work fine.  You can get the COM object from:

http://msdn.microsoft.com/downloads/tools/xmlparser/xmlparser.asp

These are the object methods and properties I used:

XMLDOMDocument. The top node containing the entire XML DOM tree.
* Async. When set to True (the default setting), returns control to the
caller before the download is finished. In ColdFusion, this can cause a
partial document load, so set it to False.
* Load(url). Loads the XML tree from a web document.
* getElementsByTagName(nodename). Returns a list of document-level Nodes
where the NodeName matches the argument.
hasChildNodes(). Returns True if the Node has Child Nodes.
XMLDOMNodeList. A collection of nodes in the document tree, supporting
iteration with cfloop.
XMLDOMNode. A single node in the document tree.
* hasChildNodes(). Returns True if the Node has children, False if it doesn’
t.
* childNodes(). Returns all of the Node’s child nodes as an XMLDOMNodeList.
* selectNodes(nodename). Returns an XMLDOMNodeList of the current Node’s
children where the NodeName matches the argument.
* Attributes. Returns a collection of Attributes, each of which consists of
a key-value pair.
* Text. The value between the Node’s begin and end tags.

Here's some sample code to instantiate the object and read in a top-level
node list:

cfobject type="COM" name="xmlDoc" class="Microsoft.XMLDOM" action="CREATE"
cfset xmlDoc.async = false
cfset xmlDoc.load(url of file)

!--- Create an XMLDOMNodeList ---
cfset nodes = xmlDoc.getElementsByTagName(nodeName)
cfset nodeArray = Arraynew(1)

!--- Loop through the nodes ---
cfloop collection="#nodes#" item="thisNode"
  !--- For each node, append a structure to the array ---
  cfset ArrayAppend(nodeList, structnew()
  cfset nodeIndex = ArrayLen(nodeList)
  !--- Get the node's text and its other attributes into the structure ---
  cfset nodeList[nodeIndex]["Text"] = thisNode.Text
  cfset attributeList = thisNode.Attributes
  cfloop collection="#attributeList#" index="thisAttribute"
cfset nodeList[nodeIndex][thisAttribute.nodeName] = thisAttribute.Text
  /cfloop
/cfloop

The full documentation for the COM object is at:

http://msdn.microsoft.com/library/psdk/xmlsdk/xmld2rl1.htm

--David Gassner

 Has anybody had any success in creating an array of structures
 from an XML
 document?

 I have a 30,000 item catalog that is in XML that I have to import into my
 DB Server but I also have to do some data checking via CF.

 Any help would be great

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: dynamic control names

2000-03-30 Thread David Gassner

Use the Evaluate() function:

cfoutput#evaluate("form.var#count#")#/cfoutput

 -Original Message-
 From: Ayush Lall [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 29, 2000 1:22 PM
 To: [EMAIL PROTECTED]
 Subject: dynamic control names


 "dynamic variable names
 In this example, the variable name is itself a variable.
 CFSET myvariable="current_value"
 CFSET "#myvariable#"=5"

 Hi !!

 My question is very much related to dynamic names.

 I have control names in the form as "varN" where N is a count changing
 with every iteration of the loop.So names are like..var1,var2,var3...so
 on.

 I need to access the values of those variable controls in a iterative
 loop like

 CFLOOP INDEX="Count" FROM="1" TO="#Form.Count#" STEP="1"

 Here I need to have access to the value of control
 "Form.var1" but I am not able to find a way to do so.

 Format - (Form.var)(Count)

 What can be done so as to have an output for the statement :
 CFOUTPUT#Form.var1#CFOUTPUT ??

 Thanks.

 Ayush Lall.

 
 Get free email and a permanent address at http://www.netaddress.com/?N=1
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFTry Question

2000-03-29 Thread David Gassner

How about...

cfset success=true
cftry
cffile action="WRITE" ..
cfcatch type="Any"
cfset success = false
The file could not be updated. File is locked or read only.
/cfcatch
/cftry

cfif success
Display success message...
/cfif

 I have wrapped cftry around a cfflile call to intercept error messages if
 the file can not be updated but I want to return a success message if the
 was no errors. Here is what I have:
 
 cftry
   cffile action="WRITE" ..
   cfcatch type="Any"
   The file could not be updated. File is locked or read only.
   /cfcatch
 /cftry
 

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Using CFLOCK

2000-03-29 Thread David Gassner

Actually, this is the Allaire recommendation for 4.01 and prior.  For 4.5,
they recommend using the new scope attribute, as in:

scope="application"

or

scope="session"

which results in the same behavior.  For more see Knowledgebase Article
14165.

 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 29, 2000 1:37 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Using CFLOCK


 Good answer... makes sense... officially it conflicts with Allaire's
 recomendation, but I think you are correct.

 -Cameron

 
 Cameron Childress
 McRae Communications
 770.460.7277 x.232
 770.460.0963 fax

  -Original Message-
  From: David Gassner [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, March 29, 2000 4:01 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Using CFLOCK
 
 
  session.sessionid is a value which is set by the CF server, not
  by the user,
  and is based on the CFID and CFToken cookies.  It's initialized at the
  beginning of the session, and not changed until the session expires, and
  therefore (theoretically) it needs no locking.
 
  Doing it this way simulates the rules followed by CF server 4.5 when you
  turn on "Automatic read locking" in CF Server Administrator.
 
   -Original Message-
   From: Cameron Childress [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, March 29, 2000 11:54 AM
   To: [EMAIL PROTECTED]
   Subject: RE: Using CFLOCK
  
  
   So David... riddle me this...
  
   If you should lock all session vars, and you name your lock
  with a session
   var, what is locking the session var you are using as the name of
   the lock?
  
   -Cameron
  
   
   Cameron Childress
   McRae Communications
   770.460.7277 x.232
   770.460.0963 fax
  
-Original Message-
From: David Gassner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 2:31 PM
To: [EMAIL PROTECTED]
Subject: RE: Using CFLOCK
   
   
If you are locking session vars, use the name:
   
name="#session.sessionid#"
   
If you are locking application vars, use the name:
   
name="#application.applicationname#"
   
 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 29, 2000 10:48 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Using CFLOCK


  When using CFLOCK how important is it to name the lock

 In CF 4.0: very, always name it... In CF 4.5, which I am not
 using yet, I am
 uncertain if names should be used or not.  In 4.5, I *think* they
 should be
 used in all cases except for when locking application, session
and server
 vars.  Someone else should be able to answer that for you.

  and if you name all locks should everylock in your application
  have a different name?

 Depends on what you are locking and why you are locking it.

 -Cameron

 
 Cameron Childress
 McRae Communications
 770.460.7277 x.232
 770.460.0963 fax

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
   
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
  
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
  send a message to [EMAIL PROTECTED] with
 'unsubscribe' in
  the body.
 
  --
  
  Archives: http://www.eGroups.com/list/cf-talk
  To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.

 --
 --
 --
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Ordering a list

2000-03-27 Thread David Gassner

Use the ListSort() function:

myList = ListSort(myList, "Text")

- Original Message -
From: Pecora, James [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 8:52 AM
Subject: Ordering a list


 Any way to order a list easily???

 Say I have a LIST and I want it alphabetized?

 I am looping thry the list and would like to have some contro over the
 display order...

 thanks
 --

 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.