need tag for dropdown and input

2002-12-17 Thread Valerie L. Criswell
I know I've seen it somewhere on my journeys.

It's the tag that displays both a dropdown (populated from a query) as well
as an accompanying text input so that the if the needed value isn't listed
in the dropdown, the user can enter it into the text box.  But only one
variable for the value is sent.

Anyone know where I can pick this up?

I'm not sure what to search for on the DevX.  I sure wish they would make a
more powerful and relevant search tool.

TIA,

~Val



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: cfmx and FORM file oddity

2002-12-05 Thread Valerie L. Criswell
The variable you want to call is actually

#File.ServerFile#

This is the default name assigned by CF to any just uploaded file.  There's
also a host of other available attributes.  Check the docs for more info.

hth,

~Val


- Original Message -
From: Jaye Morris - jayeZERO.com [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 9:47 AM
Subject: cfmx and FORM file oddity


 I am using something relative to the following code:

 form action=blahblahblah.cfm method=post
 enctype=multipart/form-data
 input type=File name=uploadedFileNamebr
 input type=Submit value=Upload Now

 /form

 During the process, I am attempting to catch the variable
 uploadedFileName,  but instead of getting a file name like
 myfilename.zip or whatever, I get something like:

 R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1
 6991.tmp

 Being that neotmp16991.tmp is not the file name and is really something
 like myfilename.zip, how do I get that actual file name as opposed to
 what is seen above.


 -//-  Jaye Morris - Multimedia Developer
 -//-  [EMAIL PROTECTED] - www.navtrak.net
 -//-  [EMAIL PROTECTED] - www.jayezero.com


 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: Multiple updates on a single submit

2002-10-22 Thread Valerie L. Criswell
If I'm understanding you , there are actually two ways of doing this.

If you're certain that your data won't contain any commas, the easiest way
is to build the form by looping over each queried item.  Each item in the
form will have the same name (ie employeeID, attendanceStatusID).  This will
send a comma delimited list pairs (ie employeeID:23,45,64,23,87
attendanceStatusID:4,2,3,3,1,2)  Then, to submit each record into the
database, loop over the lists.  The key here is that each position in each
list corresponds to the data in the same position in the other lists.  If
you're going to do this, you MUST make sure that some value is submitted for
every single item on the form.  Otherwise, the length of the lists is thrown
off and thus, the values for each record, not to mention that an error will
be thrown.

If your data may contain commas or you don't want to force the user to
submit a value for each item in the form, you can build the form by looping
over each queried item, but instead, this time give each and every form item
a unique name, usually a number (ie employeeID1,employeeID2,
attendanceStatus1,attendanceStatus2).  In this way, all 1's go together and
all 2's go together, etc.  You can then break apart the form item names and
insert them via a loop.

If you'd like to see code examples of either form elements or data insert
sequences, let me know.  I have code samples of either approach.

hth,

~Val

- Original Message -
From: Kennerly, Rick H CIV [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 11:04 AM
Subject: Multiple updates on a single submit


 a bit intimidated by the level of discourse on this list, but here goes.
 (You should start a CF-Talk_Training_Wheels for guys like me.)

 Anyway, just getting started with CF and one thing I never see are
examples
 of multiple record updates into a database with a single submit button.

 What we're noodling over is an attendance process for a staff of about 500
 in 14 departments.  The idea is that an administrator would click a button
 that would query the entire SQL db for employee names by department.  The
 query would dump the results into a form that also had check boxes or
radio
 buttons (on duty, day off, holiday, training, leave, sick).  We've gotten
 that far.  But we can't figure out how to code so that the submit button
 would then update all the queried records in the database. When we try the
 obvious--to us--code, all the buttons on the entire update are applied to
 very first record only.

 I can see how to do this one record at a time.  I just don't see how to do
 it five at a time.  Is it possible in ASP/CF?

 Thanks

 Rick
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



DevX slowwww

2002-10-16 Thread Valerie L. Criswell

Is anyone else experiencing the same slowness problem with the MM Developer
Exchange?  What's up?  It's been like this for over a week now that I've
noticed.  Mighty frustrating!

~Val



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: DevX slowwww

2002-10-16 Thread Valerie L. Criswell

cool, thanks ... I'll be patient.


- Original Message -
From: Vernon Viehe [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 2:09 PM
Subject: RE: DevX slo


 We know it has performance problems regularly, and is among the parts of
the site being re-engineered, not sure of the exact ETA, but it's coming.

 I'm asking if there's anything unusual going on in the last week. I'll
report back here if I find out anything useful, but if they're unaware of
anything, at least they now have these comments as feedback about possible
recent performance issues.

 Thanks

 -Vern



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: Date matchup help in Access 2000

2002-08-28 Thread Valerie L. Criswell

Try this as your query instead

SELECT AddDate, Title, Team
FROM TBLteam
WHERE AddDate = #CreateODBCDate(Url.GetDate)#
ORDER BY Team

~Val

- Original Message -
From: Bob Wilson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 9:24 AM
Subject: Date matchup help in Access 2000


 Hello,

 I'm having some trouble getting dates to match up in Access 2000.  This
 date thing is new
 to me and I think I'm close, just can't get everything lined up.

 I'm trying to pull records when the dates match.

 Here's my link, this works fine --

 cfoutput query=getDates
 a href=articles.cfm?GetDate=#AddDate##DateFormat(AddDate,  DD,
 )#/a
 /cfoutput


 Here's the query ---

 cfquery name=getteam datasource=#application.datasource#
dbtype=ODBC
 Select AddDate, Title, Team from TBLteam
 WHERE
 AddDate = GetDate
 Order BY Team
 /cfquery

 This either gives me no records returned, gives me EVERY record in the
 list, or says it
 doesn't know what AddDate is as I've tried different configs.

 I've tried this with quotes, without quotes, using the DateFormat to try
to
 format them
 correctly, using both GetDate and URL.GetDate and anything else I can
think
 of and
 can't quite get it to match up.

 The version of CF is 4.5.2 and of course Access 2000.

 Please help so I can learn to love dates and not hate them as I do right
now.

 Thanks,

 Bob Wilson


 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




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



Re: DWMX - Monitor page design time

2002-07-22 Thread Valerie L. Criswell

Not sure what you mean by plugs, but I use this piece of software to keep up
with the time I spend on my hourly clients' work.  We've used it for over a
year now with no complaints.

http://www.spudcity.com/traxtime/traxtime.htm

hth,

~val


- Original Message -
From: Bosky, Dave [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 9:15 AM
Subject: DWMX - Monitor page design time


 Are there any plugs that can track the amount of design time a developer
 puts into a page?

 Dave




 DISCLAIMER: The information contained in this message may be privileged
and
 confidential and protected from disclosure. If the reader of this message
is
 not the intended recipient, or an employee or agent responsible for
 delivering this message to the intended recipient, you are hereby notified
 that any dissemination, distribution or copying of this communication is
 strictly prohibited.  If you have received this communication in error,
 please notify us immediately by replying to the message and deleting it
from
 your computer.  Thank you.


 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: DWMX - Monitor page design time

2002-07-22 Thread Valerie L. Criswell

I'm independent, so while I know about SourceSafe, I don't have experience
with it.  TraxTime can indeed run on a network and there is a management
version that will compile all employee's times into one report.  We use one
copy of the regular version on my machine (where I write CF apps) and one
copy of the management version on the server so my husband (who manages the
server) can clock hours as well on the same account.  It's just the two of
us though, so it's a perfect solution.  Your situation may be otherwise.

~val

- Original Message -
From: Bosky, Dave [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 9:36 AM
Subject: RE: DWMX - Monitor page design time


 Does it work by using a checkout/checkin time?  If so could I use MS
 SourceSafe to accomplish this?
 Dave

 -Original Message-
 From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 22, 2002 9:32 AM
 To: CF-Talk
 Subject: Re: DWMX - Monitor page design time

 Not sure what you mean by plugs, but I use this piece of software to keep
up
 with the time I spend on my hourly clients' work.  We've used it for over
a
 year now with no complaints.

 http://www.spudcity.com/traxtime/traxtime.htm

 hth,

 ~val


 - Original Message -
 From: Bosky, Dave [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, July 22, 2002 9:15 AM
 Subject: DWMX - Monitor page design time


  Are there any plugs that can track the amount of design time a developer
  puts into a page?
 
  Dave
 
 
 
 
  DISCLAIMER: The information contained in this message may be privileged
 and
  confidential and protected from disclosure. If the reader of this
message
 is
  not the intended recipient, or an employee or agent responsible for
  delivering this message to the intended recipient, you are hereby
notified
  that any dissemination, distribution or copying of this communication is
  strictly prohibited.  If you have received this communication in error,
  please notify us immediately by replying to the message and deleting it
 from
  your computer.  Thank you.
 
 
 

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



Re: SoEditor Pro

2002-07-22 Thread Valerie L. Criswell

We purchased the SoEditor pro about 4 months ago.  I have implemented it
about 10 times with great success.  Once you get it going once, setting up
subsequent instances literally take less than 15 minutes.  I had about 3
major issues that I was unable to work out and the developer's responded in
the user forums on the website pretty quickly.  The users we've trained to
use it seem very pleased with it.  It was a good product to invest in.

The only complaint I have is that the documentation could be more complete.
Particularly in the area of extending and customizing the editor.  Maybe you
have developers that are more advanced than me, in which case... if you are
going to use the editor as a component to build into another application,
purchasing the code to do such, is still a good purchase.

hth

~val

- Original Message -
From: Brook Davies [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 2:23 PM
Subject: SoEditor Pro


 Hello,

 We are just about to purchase the SoEditor pro wysiwyg editor form
 www.siteobjects.com. Before we make the purchase, I thought it would be a
 good idea to check with this list and solicit some feedback from anyone
who
 has used these components. Any comments?

 FYI, We are building an email delivery system, possibly with the Soeditor
 component and with the excellent IMS (www.coolfusion.com) Products.

 Brook Davies
 maracasmedia inc.


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



Re: variables not let go

2002-07-02 Thread Valerie L. Criswell

I have noticed this in a nested loop/query situation.  I just had to make a
workaround for it.

~Val

- Original Message -
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 2:28 PM
Subject: variables not let go


 has anyone noticed when they have a query
 that returns lets say for example the variable called
 CompanyName, and on the 3rd loop through the results
 the variable CompanyName is undefined and then
 value of CompanyName from the 2nd row shows
 up as the value of the 3rd row?

 ..tony

 Tony Weeg
 Senior Web Developer
 Information System Design
 Navtrak, Inc.
 Fleet Management Solutions
 www.navtrak.net
 410.548.2337

 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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



Mac form submission file upload

2002-06-11 Thread Valerie L. Criswell

I must admit, I'm stupified (okay, maybe just stupid) by this problem.  I've
been beating my head on my desk for a good long while trying to solve this
same problem.  I've browsed the Macromedia CF Forum and TEK TIPS forum and
found quite a bit of info on this subject.  However, I've tried the TRIM()
thing on all received form fields, but now my PC upload isn't working.  I've
seen a few other tidbits of stuff to try, but before I waste any time trying
those, does anyone have a definitive solution in their pocket for this
silliness?

Here's the deal.

Without the TRIM(), my entire form (which contains an upload field and is
enctype multipart/form-data) works perfectly on the PC, but the Mac just
totally ignores my form submission.  No errors, just a clean blank page.  If
I use the TRIM(), the form works on the PC until I put a file in the file
input (for upload).  Thus, I'm in a catch22 atm.

TIA to anyone with any advice.  I'm just aching to get this done so I can
check out of here and go on vacation!

~Val

- Original Message -
From: Michael Dorr [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 4:58 PM
Subject: RE: MAC file upload


 Just worked through this problem about a month ago.  The
enctype=multipart/form-data on IE 5.0 does a strange thing - it inserts a
blank space at the end of every single form input inside the form.  Major
pain.  Anyway, on the receiving end, you need to Trim() your form variables,
especially from input type=file.



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: SQL Server virus

2002-05-23 Thread Valerie L. Criswell

Thought this might be interesting.


- Original Message -
From: Peter Tilbrook [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 3:39 AM
Subject: SOT: SQL Server virus


 Worm hits SQL servers

 A NEW worm which has infected thousands of servers running Microsoft SQL
 server, although security vendor Symantec says it is not a serious threat.

 The worm, known as Spida Worm, js.spida.b.worm, Double Tap and SQLSnake,
 searches for access the databases via the default system administrator
 login, and then forwards database configuration information and the
password
 database to an email address.
 As well as its security violations, it can create a huge traffic burden by
 running up to 100 scans simultaneously, for both local and remote hosts.

 Symantec has given the worm a rating of 2 on a scale of 1 to 5, but
Security
 software vendor ISS X-Force, which issued an alert on the worm, said it
was
 responsible for millions of port scans on the internet so far.
Incidents.org
 reports scans of the 1433 port, which the worm probes, had jumped
 dramatically since Monday, although they began to slow yesterday.

 Head of ISS's Global Threats Operations Centre, Dennis Treece, said it
 simply exploited the tendency to not reconfigure default system settings.

 It's not a vulnerabilty of the software, which is usually the case with a
 Microsoft issue, it's actually... exploiting the fact that people are
 sometimes lazy and don't put a password on the account, Mr Treece said.

 The worm appeared to be forwarding database files to a mail-forwarding
 service in Singapore with the domain name postone.com

 ISS was trying to contact the administrators of the service, he said.

 The worm installs several files, including files named sqlprocess.js,
 sqlexec.js, and clemail.exe, into the Windowssystem32 directory.

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



Re: SQL Server virus - pardon me!

2002-05-23 Thread Valerie L. Criswell

bah... I meant to send that to my husband at his office... I'll go get my
coffee now.


- Original Message -
From: Valerie L. Criswell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 9:19 AM
Subject: Re: SQL Server virus


 Thought this might be interesting.


 - Original Message -
 From: Peter Tilbrook [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, May 23, 2002 3:39 AM
 Subject: SOT: SQL Server virus


  Worm hits SQL servers
 
  A NEW worm which has infected thousands of servers running Microsoft SQL
  server, although security vendor Symantec says it is not a serious
threat.
 
  The worm, known as Spida Worm, js.spida.b.worm, Double Tap and SQLSnake,
  searches for access the databases via the default system administrator
  login, and then forwards database configuration information and the
 password
  database to an email address.
  As well as its security violations, it can create a huge traffic burden
by
  running up to 100 scans simultaneously, for both local and remote hosts.
 
  Symantec has given the worm a rating of 2 on a scale of 1 to 5, but
 Security
  software vendor ISS X-Force, which issued an alert on the worm, said it
 was
  responsible for millions of port scans on the internet so far.
 Incidents.org
  reports scans of the 1433 port, which the worm probes, had jumped
  dramatically since Monday, although they began to slow yesterday.
 
  Head of ISS's Global Threats Operations Centre, Dennis Treece, said it
  simply exploited the tendency to not reconfigure default system
settings.
 
  It's not a vulnerabilty of the software, which is usually the case with
a
  Microsoft issue, it's actually... exploiting the fact that people are
  sometimes lazy and don't put a password on the account, Mr Treece said.
 
  The worm appeared to be forwarding database files to a mail-forwarding
  service in Singapore with the domain name postone.com
 
  ISS was trying to contact the administrators of the service, he said.
 
  The worm installs several files, including files named sqlprocess.js,
  sqlexec.js, and clemail.exe, into the Windowssystem32 directory.
 
 
 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Creating a list

2002-05-21 Thread Valerie L. Criswell

I remember asking myself the same question when I first got into lists.
There is no function for creating a list like there is for query or array.
AFAIK CF looks at whatever variable like a list.  Just set the field's value
to a CF variable like this.  It works perfectly for me.

cfset myList = queryName.fieldName

HTH,

~Val

- Original Message -
From: Tony Gruen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 4:51 PM
Subject: Creating a list


 Is ListAppend used to create a new list? I am querying a db for one field.
 This will return multiple values. I need to turn that return set into a
list
 for use elsewhere. Strange I have realized I have not had to create a list
 like this before.




 
__
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: cf_html2PDF

2002-05-15 Thread Valerie L. Criswell

SR ... Go grab the HMTL2PDF3 ... It's the upgrade version of what you have.
It supports images beautifully.  In fact, it's what I'm working with all day
today and tomorrow.

~Val


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



DWMX Code Indenting Problem

2002-05-07 Thread Valerie L. Criswell

I posted this issue to the DWMX forum and got no response.  Is anyone
experiencing this same problem?  Is there a workaround?

The code in DWMX is not behaving as expected (I'm used to coding in HS5).

See the visual example below. For instance if I type the tag cfcase
value=whatever which is indented say maybe 10 spaces, then I press the
ENTER key so I can close the tag on the next line (/cfcase), the cursor
doesn't line up vertically with the start of the last tag. Instead, it goes
to the beginning of the line no matter what. If I want my matching
open/close tags to line up (and I do), this means that I have to manually
either use the SPACE BAR or the TAB key.

I'm used to HS being intelligent enough to do this for me automatically.

Is this a bug? Something that was overlooked? Or do I have something set
wrong? BTW, I've played around a good deal with the Code Format dialog in
Preferences with no luck in changing this behavior.

Ideas, anyone?

EXAMPLE:

_|cfcase value=whateverPRESS ENTER
| The cursor begins here
_| Instead of here


TIA,

~Val


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: DWMX Code Indenting Problem

2002-05-07 Thread Valerie L. Criswell

YES!  Thank you very much.


- Original Message -
From: David Armstrong [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 10:05 AM
Subject: RE: DWMX Code Indenting Problem


 The option you are looking for is available in the document toolbar
 above the coding window. Go to the view options
 button on the far right and check the Auto Indent option.


 -Original Message-
 From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 07, 2002 2:55 PM
 To: CF-Talk
 Subject: DWMX Code Indenting Problem


 I posted this issue to the DWMX forum and got no response.  Is anyone
 experiencing this same problem?  Is there a workaround?

 The code in DWMX is not behaving as expected (I'm used to coding in
 HS5).

 See the visual example below. For instance if I type the tag cfcase
 value=whatever which is indented say maybe 10 spaces, then I press
 the
 ENTER key so I can close the tag on the next line (/cfcase), the
 cursor
 doesn't line up vertically with the start of the last tag. Instead, it
 goes
 to the beginning of the line no matter what. If I want my matching
 open/close tags to line up (and I do), this means that I have to
 manually
 either use the SPACE BAR or the TAB key.

 I'm used to HS being intelligent enough to do this for me automatically.

 Is this a bug? Something that was overlooked? Or do I have something set
 wrong? BTW, I've played around a good deal with the Code Format dialog
 in
 Preferences with no luck in changing this behavior.

 Ideas, anyone?

 EXAMPLE:

 _|cfcase value=whateverPRESS ENTER
 | The cursor begins here
 _| Instead of here


 TIA,

 ~Val



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: SiteObjec soEditor vs. Ektron eWebEdit Pro

2002-05-02 Thread Valerie L. Criswell

We just purchased soEditor pro unencrypted last month and I installed
several instances of it for one client.  I did have a few technical issues
which turned out to not be bugs, but problems that I needed to handle on my
own end.  The support for soEditor is very good. There is a very active
forum and the developers keep a close eye on it.  I was pleased with the
support I received.  I'm also very pleased with the editor, and happy we
chose their product for our client's Web site.

Now that being said, I do have one complaint.  We purchased the unencrypted
version, so I could have the flexibility of extensibility.  However, I found
the documentation on this point very weak.  It sure would be nice if
SiteObjects would outline their schema for their users and give a few
examples of how to add custom buttons/functions.

HTH,

~Val Criswell


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Flash Expression....

2002-04-30 Thread Valerie L. Criswell

Hey Neil,

That's a cool thing.  Can I dock it?

~Val

- Original Message -
From: Neil Clark - =TMM= [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 11:33 AM
Subject: Flash Expression


 Anyone who needs the latest .mxp for the Flash Expression can download
 it from www.fluidik.com/mxp/flashexpression.zip

 The version on the MM site is 1.0.1, and the latest is 1.0.3

 Thanks!!

 Neil Clark
 Team Macromedia
 http://www.macromedia.com/go/team




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Dreamweaver MX Functionality?? (was: CFMX etc etc)

2002-04-29 Thread Valerie L. Criswell

Well, I've gotta tell you.  I've been pecking away with DWMX all morning.

I've been a very devoted HS and Dreamweaver user.  I've evaluated CFStudio
and UltraDev, but after you're used to doing everything manually, learning a
new piece of development software is about as appealing as riding in the
same car with your parents and your children all day long.  Anyhow, I just
couldn't ever swallow the change.  THIS new piece of software, however, is
very exciting.  I'm making the commitment to use it exclusively until it
expires.  I'm missing terribly the little vertical stream of buttons down
the left of the HS program, but I'm betting I'll be a convert before it's
all over.

I feel strongly that this software will delight Studio users as well as DW
users.  Great job guys!

~Val


- Original Message -
From: Ben Forta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 11:43 AM
Subject: RE: Dreamweaver MX Functionality?? (was: CFMX etc etc)


 :-)

 We've all been there. I used to swear by Brief, and then SAGE, and then
 CodeWrite (which I still use for specific tasks) ... switching editors
 often feels as unnatural as replacing body parts (I assume, don't
 actually know that for sure).



 -Original Message-
 From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 29, 2002 11:41 AM
 To: CF-Talk
 Subject: RE: Dreamweaver MX Functionality?? (was: CFMX etc etc)


  Well, developers become emotionally attached to their development
  tools, but ...

 Probably the only reason the vi editor is still around... ;-)

 *runs away before the penguins get him*

 EC



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



Re: end of month function

2002-04-24 Thread Valerie L. Criswell

How about use the DaysInMonth function on the date?  That will always
reliably return the last day of the month.

~Val

- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 8:25 AM
Subject: RE: end of month function


 I wouldn't try that in december.

 -Original Message-
 From: Bill Grover [mailto:[EMAIL PROTECTED]]
 Sent: woensdag 24 april 2002 14:17
 To: CF-Talk
 Subject: RE: end of month function


 I just had to do this on one of our sites.  Here is the code I use:

 DateAdd(d, -1, CreateDate(Year(Now()), Month(Now()) + 1, 1))

 __

 Bill Grover
 Supervisor MIS  Phone:  301.424.3300 x3324
 EU Services, Inc.   FAX:301.424.3696
 649 North Horners Lane  E-Mail: [EMAIL PROTECTED]
 Rockville, MD 20850-1299WWW:http://www.euservices.com
 __



  -Original Message-
  From: Perez, Percy [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, April 23, 2002 11:33 AM
  To: CF-Talk
  Subject: end of month function
 
 
  Hello all,
 
  Is there a End of month function in ColdFusion...
  I am trying to get the end of month for a date.
  excel has one, but I could not find one under the help files.
  eg:
  eomonth(1-15-2002) would return 1-31-2002
  and of course, before I build one, I figure I ask first.
 
  Thanks
 
  Percy E Perez
 
 
 

 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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



RegEx for alpha num

2002-04-22 Thread Valerie L. Criswell

I'm very new to regular expressions.  I see there is a posix class
[:alnum:], but I don't begin to understand how to use it.  I have a need to
implement it though in server side password validation.  I know my syntax
isn't right, but I'm not sure how to format it.  Below is an example of what
I need.  Can anyone offer advice?

cfif REFind([:alnum:],#Form.Password#
  Insert the password into the database
cfelse
  Send the user back to the form with an error message
/cfif

TIA! ~Val


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: RegEx for alpha num

2002-04-22 Thread Valerie L. Criswell

Very cool.  I'm going to try it!  Thanks so much.  The funny thing is that
as good as some documentation is, for me... a few real-world examples go a
long way.  Too many docs try to focus on the mumbo jumbo rules (which are
good for reference, but don't get you anywhere fast).  I'm sure once I use a
few of these things, I'll get the hang of it.  So, thanks again, Sean and
Jerry.

~Val

- Original Message -
From: Jerry Johnson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 2:23 PM
Subject: Re: RegEx for alpha num


 At a very simple level, the POSIX class [:digit:] can be used wherever you
would type a single character or group of characters.

 What I mean by this:

 REFind(a,Form.Password)

 the class can fit where a character would go.

 REFind([:class:],Form.Password)

 It MEANS something different than that character, but it FITS in the same
place.

 What it sounds like you want is to find out if all the characters in your
password are [:alnum:], yes?

 OR, stated another way, you want to find out if any characters in password
are NOT [:alnum:]?

 As Sean suggested, you do this by looking for anything NOT in the class.

 cfif REFind([^[:alnum:]],Form.Password)
 fail
 cfelse
 go on
 /cfif

 HTH at all,
 Jerry Johnson


  [EMAIL PROTECTED] 04/22/02 02:00PM 
 I'm very new to regular expressions.  I see there is a posix class
 [:alnum:], but I don't begin to understand how to use it.  I have a need
to
 implement it though in server side password validation.  I know my syntax
 isn't right, but I'm not sure how to format it.  Below is an example of
what
 I need.  Can anyone offer advice?

 cfif REFind([:alnum:],#Form.Password#
   Insert the password into the database
 cfelse
   Send the user back to the form with an error message
 /cfif

 TIA! ~Val



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



Re: RegEx for alpha num

2002-04-22 Thread Valerie L. Criswell

*choke*

hehe... I'm sure it's a thing of beauty to those who are enlightened.

Thx,  ~Val

- Original Message -
From: Joseph Thompson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 2:37 PM
Subject: Re: RegEx for alpha num


 ... a few real-world examples go a
  long way.

 Here is my all time favourite RE.  It has a little of everything:

 A special thanks to Erik Voldengen for  this email validation RE.

 It handles multiple top levels, checks for valid root domains,
disallows
 double @@ and will ensure that the email address contains just
 alphanumeric characters.

 Very nice piece of work!

 cfset email_address=[EMAIL PROTECTED]

 cfif

REFindNocase(^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a-z
 ]{2,3})|(aero|coop|info|museum|name))$,email_address)
 .good..
 cfelse
 .bad..
 /cfif


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



Re: CSS and Netscape - was(CSS and dynamically changing classes)

2002-04-16 Thread Valerie L. Criswell

I just began reading this thread, so I hope I'm understanding what's going
on.  I looked at your screenshots, but I didn't see that your code was
posted anywhere.  A few thoughts come to mind.  First, I always use CSS on
my selects and they work fine in IE and NS, so I can't see that CSS is at
fault.  Second, in my experience, NS is famous for doing this to select
boxes if there are no form tags around it.  Do you have form tags?  Even if
you're just using JavaScript, you have to have the tags, even if they are
void of any attributes.  Third, I agree regarding your opinion of NS (but
that's a whole 'nother thread!).  Anyhow, HTH!

~Val


- Original Message -
From: Trusz, Andrew [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 12:30 PM
Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes)


 The A List Apart discussion on css might be helpful, Matt,
 http://www.alistapart.com/stories/journey/. Try sticking the @import code
in
 and see what it does to the 4x browsers: style type=text/css
media=all
 @import /nucss/css;
   /style
 andy

 -Original Message-
 From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 12:00 PM
 To: CF-Talk
 Subject: RE: CSS and Netscape - was(CSS and dynamically changing
 classes)


 Here is the code that I am using for all of my select boxes.  Only the
 names change.

 select name=expmonth class=box

 For a view of the ridiculous crap that is going on, I took screenshots
 of the page in both netscape
 http://www.showstopperonline.com/netscape408.jpg
 And internet explorer 6.0  http://www.showstopperonline.com/ie6.jpg

 The only difference between the pages is that the resolution is smaller
 on the netscape page.  I can't believe the difference!

 And I just decided to check out my page in the latest - netscape 6 NONE
 OF MY JAVASCRIPT WORKS!  I click on the button, nothing happens!
 Doesn't NS6 have javascript support??? I HATE NETSCAPE!

 - Matt Small







 -Original Message-
 From: Katherine Maltby [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 11:40 AM
 To: CF-Talk
 Subject: RE: CSS and Netscape - was(CSS and dynamically changing
 classes)

 class properties should not break the selects, but lower-end Netscape
 browsers do sometimes have a tendency to pick and choose what it wants
 to
 display from css! Are you including it in the select tag or from a style
 sheet? How is it breaking them?

 Kath


 -Original Message-
 From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
 Sent: 16 April 2002 16:42
 To: CF-Talk
 Subject: OT: CSS and Netscape - was(CSS and dynamically changing
 classes)


 Thanks Dave!
 I decided to use the visibility property after I got this going.

 On another note - I decided to view my page in Netscape 4.08.  I was in
 for a HUGE shock.  My page, which uses CSS mostly at the most basic
 level, totally breaks my page.  Selects don't work at all when I have
 the class property in the tag.  Does this mean that the Netscape 4
 series browsers are totally off limits for CSS?

 - Matt Small

 -Original Message-
 From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 11:05 AM
 To: CF-Talk
 Subject: RE: CSS and dynamically changing classes

 I usually use onfocus/onblur:

 INPUT TYPE=text NAME=name VALUE= SIZE=30
 onfocus=style.backgroundColor='gray'; style.color='white'
 onblur=style.backgroundColor='white'; style.color='black'


 Dave

 -Original Message-
 From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 10:57 AM
 To: CF-Talk
 Subject: OT: CSS and dynamically changing classes

 Hi everybody,
 I have a form where a text input box become available for use
 only if a certain slection is made.  What I want to do is have the color
 of the text box be grey if it is not available and normal color (which
 is purple in my case) if it is available.
 I can handle the css which makes it grey, and the javascript
 which makes it non-focusable until the correct selection is made, but I
 need it to change color.

 I tried (as an educated guess)
 If (select.selectedIndex == 8) {
 form.nameoftextbox.class = sameclassasrest;}

 and

 If (select.selectedIndex == 8) {
 form.nameoftextbox.style = sameclassasrest;}

 but neither worked for me.

 Can I do this and how?

 Thank you,
 Matt Small






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



Re: CSS and Netscape - was(CSS and dynamically changing classes)

2002-04-16 Thread Valerie L. Criswell

*uncontrollable fits of laughter*

yeah, it happened here too.

~Val

- Original Message -
From: Matthew R. Small [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 12:58 PM
Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes)


 I'm busy writing a letter to Steve Case (Chairman of the board, AOL Time
 Warner, owner of Netcrap), and I am asking to PLEASE kill this one.

 Anybody else interested in doing this? [EMAIL PROTECTED] - I don't know
 if he'll get it or not, but I'll try.


 Omigosh... this is so good... I just went to Steve Case's website using
 Netcrap 4.08...  the page loads and reloads and reloads again... to
 infinity. I guess even the owners can't get netscape to work properly.
 If you try this, let me know if you get the same reaction.

 http://www.aoltimewarner.com/corporate_information/bio/CaseSteph.adp

 - Matt Small


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: CSS and Netscape - was(CSS and dynamically changing classes)

2002-04-16 Thread Valerie L. Criswell

This doesn't directly align with the standardization argument, but it still
bespeaks a major disadvantage of NS.  What about mentioning that it's
difficult for us to reccommend the NS browsers to our Intranet type clients
because it doesn't offer the same rich non-standard features that IE does?
In those environments we can expolit IE coolness, but what does NS offer in
comparision?

btw, you can add my name.

~Val Criswell

- Original Message -
From: Matthew R. Small [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 1:16 PM
Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes)


 Here's my rough draft.  Anybody got anything to add?

 - Matt Small


 Dear Mr. Case,

 We are a group of internet designers/ developers that have come
 together to express our dissatisfaction with the Netscape line of
 browsers.
   Developing for Netscape is more than a headache for web designers
 and developers.  It means money spent for time when developing a new
 site for multiple browsers; it means having to code for the lowest
 common denominator in browsers and using the least number of features
 available.  It means that people have different technologies to access
 the same medium, and they get different, unequal experiences.  None of
 these things are good for the internet.
   Let us use an analogy:  If our television were to get Time-Warner
 Cable, with every channel from HBO to Fox News, and your different brand
 of television received the same cable line but the top 30 channels were
 fuzzy, and then advertisements appeared much different than when the
 designers created them, what kind of experience would that be?  You have
 advertisers unhappy because their messages do not get across to a
 maximum sized audience; some of the audience gets the newest and
 fastest, while parts of it just stay the same because they don't know
 how to change. Television programmers go crazy trying to figure out what
 is viable viewing and what isn't.
  We are not trying to condone a monopoly by any company, especially
 Microsoft, but rather a standard which must be set and achieved.
 Internet Explorer sets the defacto standard in usability, functionality,
 and features.  Netscape needs to step up or step out. Netscape 6.X still
 does not meet the standard.

 We hope you get this and understand our position.

   Thank you for you time.

 Matthew Small [EMAIL PROTECTED]
 Mark Kruger [EMAIL PROTECTED]
 Katherine Maltby [EMAIL PROTECTED]














 -Original Message-
 From: Katherine Maltby [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 12:58 PM
 To: CF-Talk
 Subject: RE: CSS and Netscape - was(CSS and dynamically changing
 classes)

 I'm up for anything involving slagging off NS!


 -Original Message-
 From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
 Sent: 16 April 2002 17:58
 To: CF-Talk
 Subject: RE: CSS and Netscape - was(CSS and dynamically changing
 classes)


 I'm busy writing a letter to Steve Case (Chairman of the board, AOL Time
 Warner, owner of Netcrap), and I am asking to PLEASE kill this one.

 Anybody else interested in doing this? [EMAIL PROTECTED] - I don't know
 if he'll get it or not, but I'll try.


 Omigosh... this is so good... I just went to Steve Case's website using
 Netcrap 4.08...  the page loads and reloads and reloads again... to
 infinity. I guess even the owners can't get netscape to work properly.
 If you try this, let me know if you get the same reaction.

 http://www.aoltimewarner.com/corporate_information/bio/CaseSteph.adp

 - Matt Small

 -Original Message-
 From: Katherine Maltby [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 12:00 PM
 To: CF-Talk
 Subject: RE: CSS and Netscape - was(CSS and dynamically changing
 classes)

 that is definitely some difference! I would just like to state here for
 the
 record that I also hate Netscape. Anyway..what's the code you're
 using
 in the style sheet? Also how are you laying the page out? (i.e. tables
 etc...)

 Ta,
 Kath

 -Original Message-
 From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
 Sent: 16 April 2002 17:00
 To: CF-Talk
 Subject: RE: CSS and Netscape - was(CSS and dynamically changing
 classes)


 Here is the code that I am using for all of my select boxes.  Only the
 names change.

 select name=expmonth class=box

 For a view of the ridiculous crap that is going on, I took screenshots
 of the page in both netscape
 http://www.showstopperonline.com/netscape408.jpg
 And internet explorer 6.0  http://www.showstopperonline.com/ie6.jpg

 The only difference between the pages is that the resolution is smaller
 on the netscape page.  I can't believe the difference!

 And I just decided to check out my page in the latest - netscape 6 NONE
 OF MY JAVASCRIPT WORKS!  I click on the button, nothing happens!
 Doesn't NS6 have javascript support??? I HATE NETSCAPE!

 - Matt Small







 -Original Message-
 From: 

Re: Query Trouble

2002-04-16 Thread Valerie L. Criswell

I've used many nested queries too.  How about this code?  This way, you can
loop through and query each record of the qGroups query.  Also, I dont think
you need two qualifiers in the cfif statement.  The one making sure there's
a record is sufficient.  Anyhow I hope this works!


CFQUERY NAME=qGroups DATASOURCE=Events
   SELECT DISTINCT EventType
   FROM Events
/CFQUERY
CFLOOP QUERY=qGroups
  CFQUERY NAME=qSpecificLocations DATASOURCE=Events
   SELECT EventID,EventType,X,Y,EventText
   FROM Events
   WHERE EventType = '#EventType#'
  /CFQUERY
  CFOUTPUT QUERY=qSpecificLocations
CFIF qSpecificLocations.RecordCount GTE 1

#qGroups.CurrentRow#,#qSpecificLocations.CurrentRow#,#qSpecificLocations.X#,
  #qSpecificLocations.Y#);
 /CFIF
  /CFOUTPUT
/CFLOOP

~Val


- Original Message -
From: Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 2:54 PM
Subject: RE: Query Trouble


 That's not true.  I have MANY apps that have nested queries.

 Brian Yager
 President - North AL Cold Fusion Users Group
 Sr. Systems Analyst
 NCCIM/CIC
 [EMAIL PROTECTED]
 (256) 842-8342


 -Original Message-
 From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 1:41 PM
 To: CF-Talk
 Subject: Re: Query Trouble


 This has got to be in the FAQ.  By the way, where's the FAQ?

 To cut from a similar answer a few days ago:

My understanding is that you can only run through one query at a time
(with
 CF handling the currentRow your on.)

So you are going to want to only rely on the query= for one of your two
 loops. Or maybe none.

This is not the only way, but it should work.

Other people will chime in with the correct (and faster) ways, but this
 should get you going.

cfoutput
cfloop index=cRow from=1 to=#SecondQuery.recordCount#
step=1
#SecondQuery['RowName'][cRow]#
cfloop index=cRow2 from=1 to=#first.recordCount# step=1
#SecondQuery['RowName'][cRow]#
#first['RowName'][cRow2]#
/cfloop
/cfoutput


 If this doesn't help, shout out and I'll try a more specific answer.
 Jerry Johnson



  [EMAIL PROTECTED] 04/16/02 02:29PM 
 Can someone point out why this query is only getting the last group of
 records?
 A second set of eyes would really help!

 If the query qGroups returns the following eventtypes: ItemA, ItemB, ItemC
 Only group ItemC and records that are in ItemC will print out.

 --
 CFQUERY NAME=qGroups DATASOURCE=Events
 SELECT DISTINCT EventType
 FROM Events
 /CFQUERY

 CFOUTPUT QUERY=qGroups
 CFQUERY NAME=qSpecificLocations DATASOURCE=Events
 SELECT EventID,EventType,X,Y,EventText
 FROM Events
 WHERE EventType = '#qGroups.EventType#'
 /CFQUERY

 CFIF IsDefined(qSpecificLocations.RecordCount) AND
 qSpecificLocations.RecordCount GTE 1
 CFLOOP QUERY=qSpecificLocations


#qGroups.CurrentRow#,#qSpecificLocations.CurrentRow#,#qSpecificLocations.X#,
 #qSpecificLocations.Y#);
 /CFLOOP
 /CFIF

 /CFOUTPUT
 --
 Thanks,
 Dave






 
__
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: INPUT / check boxes

2002-04-16 Thread Valerie L. Criswell

I think you're using checkboxes where you should be using radio buttons.
Radio buttons have this functionality built in.

~Val

- Original Message -
From: phumes1 [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 3:02 PM
Subject: Re: INPUT / check boxes


 Hi,

 Below I have the following checkboxes. What I would like to do is if a
user
 checks the first box (User must change password at next login) then the
 next two (User cannot change password  Password never expires) become
 uncheckable or greyed out.


 If the (Password never expires) is checked then the User must change
 password at next login gets greyed out or uncheckable.

 Similar to adding a user in NT.

 How can I do this?


 input class=formbuttons type=checkbox name=select
 value=MustChangePasswordUser must change password at next loginbr

 input class=formbuttons type=checkbox name=select
 value=CannotChangePasswordUser cannot change passwordbr

 input class=formbuttons type=checkbox name=select
 value=PasswordNeverExpiresPassword never expiresbr
  input class=formbuttons type=checkbox name=select
 value=AccountDisabledAccount is disabled





+---
+

 Philip Humeniuk
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]

+---
-+


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



Re: Upgrade to CF 5.0 - yes or no ??

2002-04-15 Thread Valerie L. Criswell

Our upgrade went well with the exception of our cfgraph implementations.
I'm trying to remember, but it was something about a different Java version
being used in the newer version.  That was a mess.  5.0 did seem to smooth
out some problems, and run faster, but not so much in a way that I could
really cite examples.  In any event, it was a good investment.

We actually originally had ColdFusion Express, which we upgraded to 4.5
which we upgraded to 5.0.  I don't think we'll upgrade immediately to MX,
though.  We're tickled with 5.0, and it seems like we just bought it!  In
technology there's always something faster and better.  *sigh*  Maybe in
another year.

~Val

- Original Message -
From: Harmony Jones [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 6:27 AM
Subject: Upgrade to CF 5.0 - yes or no ??


 Presently running CF 4.5 SP2 on W2K, IIS5 with SQL2000 database.

 Things generally seem OK, except for some users getting random errors
about
 missing
 parameters - either form data or url parameters (a problem we still have
 not been able to resolve but heard it goes away with CF 5.0)

 We are contemplating upgrading to CF.5.0 but not sure about full backward
 compatability and the concern that it may end up creating new problems.
The
 main attraction to upgrade is the alleged increased in performance, and
the
 fact that with NEO coming along we want to remain somewhat current.

 Does anyone have any input to share? Should we stay put or push forward.
Is
 CF 5.0 worth it?


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Multiple Checkbox update?

2002-04-09 Thread Valerie L. Criswell

What about placing the client names into a dropdown and allow multiple
selections?  This would send a comma delimited list of the ClientIDs, then
you could loop through the list in the action page, placing the IDs in your
WHERE clause.  This would save some real estate on the page depending on how
many clients there are.

Otherwise, if you're sure you want to do the checkboxes, do a cfparam
value=Form.ClientIDHere default=0 for each ClientID just before the
UPDATE/INSERT so that each client has a value.  Then you'll either insert a
1 or 0 for each client.

I hope my thinking is on the right track here for you.  (That's my
disclaimer) In any event, enjoy the day!

~Val

- Original Message -
From: Kris Pilles [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 9:32 AM
Subject: RE: Multiple Checkbox update?


 All I need to do is have the action page either enter a 1 into a field
 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off
 on a monthly basis inorder to keep track of billing.  So, I have a drop
 down that has our different services.  The user selects the ares they
 want, then it lists all the clients with a checkbox.  If the checkbox is
 checked, they were billed in the previous cycle, if it isn't they will
 check it and add it to our accounting system.



 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?


 There are many ways to skin this cat, but it all depends on your
 checkboxes and what your trying to accomplish.  If you could provide
 more details, I am sure you will get some good help!

 Paul Giesenhagen
 QuillDesign
 http://www.quilldesign.com
 SiteDirector v2.0 - Commerce Builder



  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!
 

 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Multiple Checkbox update?

2002-04-09 Thread Valerie L. Criswell

If I remember correctly, Booleans in cfgrid display a 1 or 0 and require the
user to input 1 or 0 as well (not too user-friendly).

My experience with cfgrid isn't the greatest.  If you're working in an
intranet sort of environment where you can manually make sure the right java
version gets loaded properly on each machine, it's alright.  However, if the
grid will be used in the real world, it's not too cool. cfgrid is a great
idea with poor implementation.   But that's just my opinion.

~Val

- Original Message -
From: John McCosker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:32 AM
Subject: RE: Multiple Checkbox update?


 As far as I'm aware,
 No!!

 Check your documentation,
 type cfgrid in studio click in it and press F1,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:29 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 But it wouldn't display as a checkbox is what your saying?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 10:24 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 Yep this would be another way of presenting the data,
 handy for people who are used to using access which is usually accounts
 type people,

 of course the data would be represented in a cfgrid column
 as oppossed to checkbox on output,

 I'm not sure about using cfgrid for initial fresh input,

 John


 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:14 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 On another note, is it possible to incorporatre a checkbox into CFGRID?


 If so, this will work for me?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:53 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 form ...
 input type=checkbox name=customerOne
 input type=checkbox name=customerTwo
 input type=checkbox name=customerThree
 /form

 Then when your doing your insert query

 cfquery name=insert datasource=#request.dsn# ...
 INSERT INTO tblSubscribe

 (customerOne,customerTwo,customerThree)
 (
 cfif IsDefined(form.customerOne)cfset
 customerOne=1#customerOne#,cfelse0,/cfif
 cfif IsDefined(form.customerTwo)cfset
 customerTwo=1#customerTwo#,cfelse0,/cfif
 cfif IsDefined(form.customerThree)cfset
 customerThree=1#customerThree#,cfelse0/cfif
 )
 /cfquery

 Then if you had another page showing who has done what it could look
 something like this

 cfquery name=get datasource=#request.dsn# ...
 select customerOne,customerTwo,customerThree
 from dbo.somewhere
 where someid=#maybesomevar#
 /cfquery
 cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
 cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
 cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

 FORM 
 input type=checkbox name=customerOne cfif
 len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
 name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
 0selected/cfif input type=checkbox name=customerThree cfif
 len(ATTRIBUTES.customerThree) GT 0selected/cfif
 /FORM

 Just a quick and straight forward way but there are others and probably
 better,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 2:33 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 All I need to do is have the action page either enter a 1 into a field
 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off
 on a monthly basis inorder to keep track of billing.  So, I have a drop
 down that has our different services.  The user selects the ares they
 want, then it lists all the clients with a checkbox.  If the checkbox is
 checked, they were billed in the previous cycle, if it isn't they will
 check it and add it to our accounting system.



 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?


 There are many ways to skin this cat, but it all depends on your
 checkboxes and what your trying to accomplish.  If you could provide
 more details, I am sure you will get some good help!

 Paul Giesenhagen
 QuillDesign
 http://www.quilldesign.com
 SiteDirector v2.0 - Commerce Builder



  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!
 






 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: 

Re: is this even possible?? Loop using lists?

2002-04-09 Thread Valerie L. Criswell

What is this bracket notation and where can I find more info?  It looks
mighty handy.

~Val

- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 12:00 PM
Subject: RE: is this even possible?? Loop using lists?


 Ack! Evaluate police!

 You do not need to use evaluate to get dynamic form names. Just use
 bracket notation.

 cfset thisName = form[name#i#]
 etc.



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



Re: FileExists returns NO every time, even with absolute path

2002-04-05 Thread Valerie L. Criswell

If you're checking to make sure the file exists after it's uploaded, then
it's variable name has changed from form.description to file.serverfile.  If
I'm understanding what's going on, what about trying
#fileExists(file.serverfile)# ?

~Val

- Original Message -
From: Stocke Terri [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 9:41 AM
Subject: RE: FileExists returns NO every time, even with absolute path


 Tried that, too. Still returns NO. :(

 -Original Message-
 From: Don Vawter [mailto:[EMAIL PROTECTED]]
 Sent: Friday, April 05, 2002 9:44 AM
 To: CF-Talk
 Subject: Re: FileExists returns NO every time, even with absolute path


 Try this instead. You were looking for a file called  form.description

 #fileExists(form.description)#

 °¿°
  ~
 Don Vawter

 - Original Message -
 From: Stocke Terri [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, April 05, 2002 7:24 AM
 Subject: FileExists returns NO every time, even with absolute path


  Hi All,
 
  This is maddening.
 
  I am using FileExists to check for the existence of a file that I am
  browsing to on my local machine. No matter what file I choose, the
  FileExists function returns NO every time, even though I am 100%
positive
  that the file does exist. I have included a small portion of code that I
 am
  using for debugging purposes.
  The first outputted variable (form.description) displays the file path,
  which is C:\MyDocs\app_request.doc. The second outputted variable
displays
  NO. Even if I replace the form.description in the second outputted
  variable with C:\MyDocs\app_request.doc, it still returns NO. Any ideas?
 
  cfif form.description is not 
 
  cfoutput
  #form.description#br
  #fileExists(form.description)#
  /cfoutput
 
  cfabort
 
  cfif NOT #fileExists(form.description)#
  Do this...
  /cfif
 
  Terri
 
 

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



Re: FileExists returns NO every time, even with absolute path

2002-04-05 Thread Valerie L. Criswell

I don't think the server can check for the existence of files on the user's
machine via that function, although maybe there are some Java or ActiveX
components that would allow this.  Best Regards,

~Val

- Original Message -
From: Stocke Terri [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 9:56 AM
Subject: RE: FileExists returns NO every time, even with absolute path


 Nope, I'm checking for it's existence prior to upload...

 -Original Message-
 From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
 Sent: Friday, April 05, 2002 9:53 AM
 To: CF-Talk
 Subject: Re: FileExists returns NO every time, even with absolute path


 If you're checking to make sure the file exists after it's uploaded, then
 it's variable name has changed from form.description to file.serverfile.
If
 I'm understanding what's going on, what about trying
 #fileExists(file.serverfile)# ?

 ~Val

 - Original Message -
 From: Stocke Terri [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, April 05, 2002 9:41 AM
 Subject: RE: FileExists returns NO every time, even with absolute path


  Tried that, too. Still returns NO. :(
 
  -Original Message-
  From: Don Vawter [mailto:[EMAIL PROTECTED]]
  Sent: Friday, April 05, 2002 9:44 AM
  To: CF-Talk
  Subject: Re: FileExists returns NO every time, even with absolute path
 
 
  Try this instead. You were looking for a file called  form.description
 
  #fileExists(form.description)#
 
  °¿°
   ~
  Don Vawter
 
  - Original Message -
  From: Stocke Terri [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, April 05, 2002 7:24 AM
  Subject: FileExists returns NO every time, even with absolute path
 
 
   Hi All,
  
   This is maddening.
  
   I am using FileExists to check for the existence of a file that I am
   browsing to on my local machine. No matter what file I choose, the
   FileExists function returns NO every time, even though I am 100%
 positive
   that the file does exist. I have included a small portion of code that
I
  am
   using for debugging purposes.
   The first outputted variable (form.description) displays the file
path,
   which is C:\MyDocs\app_request.doc. The second outputted variable
 displays
   NO. Even if I replace the form.description in the second outputted
   variable with C:\MyDocs\app_request.doc, it still returns NO. Any
ideas?
  
   cfif form.description is not 
  
   cfoutput
   #form.description#br
   #fileExists(form.description)#
   /cfoutput
  
   cfabort
  
   cfif NOT #fileExists(form.description)#
   Do this...
   /cfif
  
   Terri
  
  
 
 

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



Re: FileExists returns NO every time, even with absolute path

2002-04-05 Thread Valerie L. Criswell

Well, two things that have messed me up in the past are ...

1.  Make sure you have the attribute enctype=multipart/form-data in your
form tag
2.  You MUST place a trailing slash at the end of the destination value in
the CFFILE tag. (I'm betting it's this one causing your error).

I see where you were going with this now.  I think CF is pretty darn good at
finding errors for you, but unfortunately sometimes the error you're
receiving has absolutely nothing to do with the real issue.  *sigh*

Best Regards,

~Val

- Original Message -
From: Stocke Terri [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 10:46 AM
Subject: RE: FileExists returns NO every time, even with absolute path


 Okay, that makes sense. But how come no matter what file I browse to, CF
 will not upload the file? That is, if I remove the fileExists altogether
and
 just go right to my cffile tag, I get the error that the form field
 specified in the CFFILE tag (DESCRIPTION) does not contain an uploaded
file.
 I checked, and the path to the file is correct.

 Sorry guys!!! I hate to be a pest, but my development is at a standstill
 until I get this figured out.

 -Original Message-
 From: Michael Corrigan [mailto:[EMAIL PROTECTED]]
 Sent: Friday, April 05, 2002 10:32 AM
 To: CF-Talk
 Subject: Re: FileExists returns NO every time, even with absolute path


 D'oh, she's right.  I said that it would be ok, but I was incorrect.  CF
 cannot verify the existence of a file on a users system before upload.

 Michael Corrigan
 Programmer
 Endora Digital Solutions
 1900 Highland Avenue, Suite 200
 Lombard, IL 60148
 630-627-5055 ext.-136
 630/627-5255 Fax
   - Original Message -
   From: Valerie L. Criswell
   To: CF-Talk
   Sent: Friday, April 05, 2002 9:30 AM
   Subject: Re: FileExists returns NO every time, even with absolute path


   I don't think the server can check for the existence of files on the
 user's
   machine via that function, although maybe there are some Java or ActiveX
   components that would allow this.  Best Regards,

   ~Val

   - Original Message -
   From: Stocke Terri [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Friday, April 05, 2002 9:56 AM
   Subject: RE: FileExists returns NO every time, even with absolute path


Nope, I'm checking for it's existence prior to upload...
   
-Original Message-
From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:53 AM
To: CF-Talk
Subject: Re: FileExists returns NO every time, even with absolute path
   
   
If you're checking to make sure the file exists after it's uploaded,
 then
it's variable name has changed from form.description to
file.serverfile.
   If
I'm understanding what's going on, what about trying
#fileExists(file.serverfile)# ?
   
~Val
   
- Original Message -
From: Stocke Terri [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 9:41 AM
Subject: RE: FileExists returns NO every time, even with absolute path
   
   
 Tried that, too. Still returns NO. :(

 -Original Message-
 From: Don Vawter [mailto:[EMAIL PROTECTED]]
 Sent: Friday, April 05, 2002 9:44 AM
 To: CF-Talk
 Subject: Re: FileExists returns NO every time, even with absolute
path


 Try this instead. You were looking for a file called
form.description

 #fileExists(form.description)#

 °¿°
  ~
 Don Vawter

 - Original Message -
 From: Stocke Terri [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, April 05, 2002 7:24 AM
 Subject: FileExists returns NO every time, even with absolute path


  Hi All,
 
  This is maddening.
 
  I am using FileExists to check for the existence of a file that I
am
  browsing to on my local machine. No matter what file I choose, the
  FileExists function returns NO every time, even though I am 100%
positive
  that the file does exist. I have included a small portion of code
 that
   I
 am
  using for debugging purposes.
  The first outputted variable (form.description) displays the file
   path,
  which is C:\MyDocs\app_request.doc. The second outputted variable
displays
  NO. Even if I replace the form.description in the second
outputted
  variable with C:\MyDocs\app_request.doc, it still returns NO. Any
   ideas?
 
  cfif form.description is not 
 
  cfoutput
  #form.description#br
  #fileExists(form.description)#
  /cfoutput
 
  cfabort
 
  cfif NOT #fileExists(form.description)#
  Do this...
  /cfif
 
  Terri
 
 


   
   


 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion

Re: FileExists returns NO every time, even with absolute path

2002-04-05 Thread Valerie L. Criswell

heh heh. I hate it when that happens, congrats.

- Original Message -
From: Stocke Terri [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 11:13 AM
Subject: RE: FileExists returns NO every time, even with absolute path


 Oh...my...gosh...

 I am SUCH a bonehead! I can't believe I did that. Yes, that solved the
 problem nicely. I can blame my momentary lapse on pregnancy hormones,
right?
 ;)  No? Well, I'm going to anyway. :D

 Thanks to everyone. You guys are the absolute BEST!





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



Re: Developers Exchange... How *could* they!?

2002-03-12 Thread Valerie L. Criswell

THANK YOU!!!

- Original Message -
From: Matt Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 12:21 PM
Subject: Re: Developers Exchange... How *could* they!?


 Friends...

 I am as shocked as you are at the speed of the Developer Exchange and am
 painfully aware of the effects that the new speed have had in your daily
work.

 I wanted to let you know that we were not going to take this lying down.

 I have formulated a plan to reintroduce a lag into the Developer Exchange.

 1. Reduce the servers to one machine and replace that with a Compaq
Deskpro
 386, that I brought with me when I left Ashton-Tate.

 2. Introduce calls to the SETI on the web project to process every time a
 new page is called.

 3. Reduce the text size for ALL browsers so you don't need to use NS6.

 4. Turn the system off for maintenance at random times twice per day
 between 6am and 5pm Pacific time.

 5. Create a random letter insert program to change developers names,
 passwords and download names.

 I hope you will all bear with us in these troubled time.

 PS. VERY glad you all noticed that we had cleaned up some of the problems.
:-)
 We really are trying to make this a superb resource that will be even
 better than it was at Allaire.
 _

 Matt Brown  Community Manager
 Macromedia (650) 481-4525   [EMAIL PROTECTED]

 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



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Forcing Excel Download

2002-03-12 Thread Valerie L. Criswell

I just did this sort of thing this week.  To force a dialog box for download
instead of having a file load into the browser for display, I made a page
called download.cfm and placed this code on it.

cfheader name=content-disposition value=attachment;
filename=#Url.filename#
cfcontent type=unknown
file=#ExpandPath(./)#files/upload/#Url.ProductID#/#Url.filename#

Then I linked my filenames to point to it, with a query string that includes
the filename.  The beauty is that the unknown file type tricks the browser
into not rendering the doc, and the cfheader allows the retention of the
file extension in the dialog box.  I can't take credit for it, though.  I
found the solution in a search at TechTips forum.

HTH,

~Val


- Original Message -
From: Attley, Simon (CMG-SF) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 12:58 PM
Subject: Forcing Excel Download


 Hello list,
 I currently have an absolute link to an Excel file on our server.
Clicking
 the link opens a new window and the excel spreadsheet populates the new
 window.  The problem is that when I replace the excel file on the server
 with a newer version, clicking on the absolute link still brings up the
old
 file.

 How do I ensure that when a user clicks the link they will get the newest
 version of the file and can I force them to first save the file to their
 local machine before opening it, as it is know it always just opens in the
 browser.

 Thanks very much,

 Simon
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: cfgrid and CF5

2002-03-07 Thread Valerie L. Criswell

There's a good amount of info on this in the macromedia cf support forum, so
I won't go into the nitty gritties until you read all the mess about it
there.  We just gave up and decided to place the class directly into each
directory where we run it and we have to go to the user's machine and
install the JVM manually most times.  This is okay because we're only using
it in a few places.  Most of our problems came from the JVM not loading,
when we upgraded.  I can tell you this, however ... I won't ever be using
the CFGrid function again.  What a mess.

http://webforums.macromedia.com/coldfusion/messageview.cfmcatid=3threadid=2
34364highlight_key=ykeyword1=cfgridkeyword2=class
(watch for wrapping on the URL above)

Best wishes,

~Val

- Original Message -
From: Stephenie Hamilton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 1:54 PM
Subject: cfgrid and CF5


 has anyone gotten CFGrid to work in CF5 (win2k server)
 I keep getting an error load: class
 allaire.controls2.CFGridApplet.class not found.
 now I searched on the server and can't even find that class...
 I also have the CFIDE dir as a virtual dir under the site that
 needs to use CFGrid and gave IUSR read permissions
 but still that error persists...
 is there even such a file with CF5?
 has anyone been able to get CFGrid to work?

 ~~
 Stephenie


 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Developers Exchange... How *could* they!?

2002-03-03 Thread Valerie L. Criswell

WOW! this is excellent. I usually go there and begin a search with a big
groan and a sigh.  Now maybe I can make some time to actually browse the
place.  How wonderfully cool!


[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 9:21 PM
Subject: Re: Developers Exchange... How *could* they!?


 At least they haven't made the site compatible with Netscape 6 yet, so
 you could load the site in NS6 and then go on a magnifying glass hunting
 expedition :)

 jon

 Matt Robertson wrote:
  For two days now I've been doing searches on the Developers Exchange and
  getting regular one- to two-second responses.  I just searched for
  ''ColdFusion'' and got back 374 results in just under 3 seconds.
 
  I'm shocked and outraged.  I no longer have the time to go to the water
  cooler, doze off or chat with the ladies in the next office while
  waiting for search results.  This has completely fouled up my workflow.
 
  How could Macromedia do this to all of their loyal CF developers, and me
  in particular???


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Solution: Divide record output cleanly when printing?

2002-02-24 Thread Valerie L. Criswell

oh oh oh ... sorry, I misunderstood.  The custom tag is available from the
Developer's Exchange at Macromedia, and it is indeed a great tag.

~Val

- Original Message -
From: Chuck McElwee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, February 23, 2002 4:11 PM
Subject: RE: Solution: Divide record output cleanly when printing?


 via the custom tag html2pdf3?  That's the one I was curious about.
Google
 turns up nothing on html2pdf3...

 Thanks

 -Original Message-
 From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, February 23, 2002 3:14 PM
 To: CF-Talk
 Subject: Re: Solution: Divide record output cleanly when printing?

 no custom tag... just plain old CSS.  I had never heard of the attribute
 actually until I did some research.

 - Original Message -
 From: Chuck McElwee [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Saturday, February 23, 2002 3:06 PM
 Subject: RE: Solution: Divide record output cleanly when printing?


  Is this a publicly available custom tag?  Sounds handy...
 
  - Chuck
 
  -Original Message-
  From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
  Sent: Friday, February 22, 2002 8:40 AM
  To: CF-Talk
  Subject: Solution: Divide record output cleanly when printing?
 
  To anyone who is interested, the solution was actually quite
  straightforward.  There are apparently two attributes in CSS called
  pageBreakBefore and pageBreakAfter.  To print exactly 5 records per
page,
 I
  inserted this code in the head of the doc within style tags.
 
  div.page { page-break-before: always }
 
  and this code after the end of my record display but before the close of
 the
  output tag.
 
  cfif get_missionary.CurrentRow MOD 5 IS 0/divdiv class=page/cfif
 
  Works like a dream and is very cool!
 
  ~Val
 
 

 Does anyone have any tricks that will not split up the results of
a
 record output when printing, but will instead be smart
and know that
 if the entire record won't fit on one page, to begin it on
the next one?
 In my particular situation, each record is fully contained
(formatted)
 in its own table.  As well, if it helps, I am exporting the
html to a
 pdf via the custom tag html2pdf3.
 
 
 

 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Solution: Divide record output cleanly when printing?

2002-02-23 Thread Valerie L. Criswell

no custom tag... just plain old CSS.  I had never heard of the attribute
actually until I did some research.

- Original Message -
From: Chuck McElwee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, February 23, 2002 3:06 PM
Subject: RE: Solution: Divide record output cleanly when printing?


 Is this a publicly available custom tag?  Sounds handy...

 - Chuck

 -Original Message-
 From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
 Sent: Friday, February 22, 2002 8:40 AM
 To: CF-Talk
 Subject: Solution: Divide record output cleanly when printing?

 To anyone who is interested, the solution was actually quite
 straightforward.  There are apparently two attributes in CSS called
 pageBreakBefore and pageBreakAfter.  To print exactly 5 records per page,
I
 inserted this code in the head of the doc within style tags.

 div.page { page-break-before: always }

 and this code after the end of my record display but before the close of
the
 output tag.

 cfif get_missionary.CurrentRow MOD 5 IS 0/divdiv class=page/cfif

 Works like a dream and is very cool!

 ~Val


   
Does anyone have any tricks that will not split up the results of a
record output when printing, but will instead be smart
   and know that
if the entire record won't fit on one page, to begin it on
   the next one?
In my particular situation, each record is fully contained
   (formatted)
in its own table.  As well, if it helps, I am exporting the
   html to a
pdf via the custom tag html2pdf3.


 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



Solution: Divide record output cleanly when printing?

2002-02-22 Thread Valerie L. Criswell

To anyone who is interested, the solution was actually quite
straightforward.  There are apparently two attributes in CSS called
pageBreakBefore and pageBreakAfter.  To print exactly 5 records per page, I
inserted this code in the head of the doc within style tags.

div.page { page-break-before: always }

and this code after the end of my record display but before the close of the
output tag.

cfif get_missionary.CurrentRow MOD 5 IS 0/divdiv class=page/cfif

Works like a dream and is very cool!

~Val


  
   Does anyone have any tricks that will not split up the results of a
   record output when printing, but will instead be smart
  and know that
   if the entire record won't fit on one page, to begin it on
  the next one?
   In my particular situation, each record is fully contained
  (formatted)
   in its own table.  As well, if it helps, I am exporting the
  html to a
   pdf via the custom tag html2pdf3.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



Divide record output cleanly when printing?

2002-02-21 Thread Valerie L. Criswell

Does anyone have any tricks that will not split up the results of a record
output when printing, but will instead be smart and know that if the
entire record won't fit on one page, to begin it on the next one?  In my
particular situation, each record is fully contained (formatted) in its own
table.  As well, if it helps, I am exporting the html to a pdf via the
custom tag html2pdf3.

TIA,  ~Val

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Divide record output cleanly when printing?

2002-02-21 Thread Valerie L. Criswell

Hey thanks... I'm going to see if I can figure that out.

~Val

- Original Message -
From: Darryl Lyons [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 5:07 PM
Subject: RE: Divide record output cleanly when printing?


 Yeah, we've done a HTML-based reporting thing here that counted the
 number of lines in a report and inserted a footer then a new header each
 time the line limit was met. We used CSS to force page breaks and ensure
 line height consistency. There's also a table trick with two rows
 (bottom being the footer) that ensured exact footer placement from page
 to page.

 Darryl

 -Original Message-
 From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
 Sent: Friday, 22 February 2002 6:28 AM
 To: CF-Talk
 Subject: Divide record output cleanly when printing?


 Does anyone have any tricks that will not split up the results of a
 record output when printing, but will instead be smart and know that
 if the entire record won't fit on one page, to begin it on the next one?
 In my particular situation, each record is fully contained (formatted)
 in its own table.  As well, if it helps, I am exporting the html to a
 pdf via the custom tag html2pdf3.

 TIA,  ~Val


 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



Image Theft Sofware

2002-02-18 Thread Valerie L. Criswell

*Sigh*  Does anyone know of a good, cheap piece of software that I can
install on the server to detect websites that are using images on your
server by linking to them?

Thanks,

~Val

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Image Theft Sofware

2002-02-18 Thread Valerie L. Criswell

Thanks to all replies.  I originally found the theiving linkers by manually
checking out the referrals from my WebTrends report.  Unfortunately there
doesn't appear to be a quick fix that will nab illegal linkers.  Some of the
solutions sound very viable, however.  For now, until I have more time to
devote to placing all images through a piece of software, I have edited my 3
images to embarrass the guilty parties and relinked my pages to new image
names.  Thanks again to all.

~Val

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Get a random record, but not too random?

2002-01-31 Thread Valerie L. Criswell

What if you write the ID of the previous set into a variable, then either
deny that set from within the next query, or simply test to see if it picked
the same one and if so, redo the query until it retrieves a set that does
not match the previous.  Does that make sense?  Did I understand the
question?

HTH!

~Val

- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 3:40 PM
Subject: Get a random record, but not too random?


 Thursday, January 31, 2002, 3:32:59 PM
 Hello cf-talk,

   I've got a layout that displays a random set of images on each page.

   I have one to many DB setup, with image sets, and images
   respectively. I first find a random set, then get the images for
   that set. It works like this:

 cfquery name=getcoverset  datasource=#request.DSN# dbtype=ODBC
 SELECT coverid
 FROM coverpicsets
 /cfquery

 CFSET List = ValueList(getcoverset.coverid)
 CFSET Position = RandRange(1, ListLen(List))
 CFSET Randomset = ListGetAt(List, Position)

 CFQUERY name=set datasource=#request.DSN#
 SELECT *
 FROM coverpics
 WHERE coverid=(SELECT *
FROM coverpicsets
WHERE coverid = #Randomset#)
 /cfquery

 cfoutput query=set#one# #two# #three# #four#/cfoutput



 What I'm trying to do is have the random set, choose a set, but
 exclude set that was used on the previous page. I've tried setting the
 randomset as a parameter, and using it in an cfif statement, as in
 cfif randomset exists, then run the query exluding that random set, if
 not then just run the normal above query. However, it
 is not keeping random set from page to page.

 Am I going about this is the right way?


 Best regards,
  Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Get a random record, but not too random?

2002-01-31 Thread Valerie L. Criswell

I forgot to mention that you'll want to use an application var to store that
ID so that it persists for you.

~Val

- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 3:40 PM
Subject: Get a random record, but not too random?


 Thursday, January 31, 2002, 3:32:59 PM
 Hello cf-talk,

   I've got a layout that displays a random set of images on each page.

   I have one to many DB setup, with image sets, and images
   respectively. I first find a random set, then get the images for
   that set. It works like this:

 cfquery name=getcoverset  datasource=#request.DSN# dbtype=ODBC
 SELECT coverid
 FROM coverpicsets
 /cfquery

 CFSET List = ValueList(getcoverset.coverid)
 CFSET Position = RandRange(1, ListLen(List))
 CFSET Randomset = ListGetAt(List, Position)

 CFQUERY name=set datasource=#request.DSN#
 SELECT *
 FROM coverpics
 WHERE coverid=(SELECT *
FROM coverpicsets
WHERE coverid = #Randomset#)
 /cfquery

 cfoutput query=set#one# #two# #three# #four#/cfoutput



 What I'm trying to do is have the random set, choose a set, but
 exclude set that was used on the previous page. I've tried setting the
 randomset as a parameter, and using it in an cfif statement, as in
 cfif randomset exists, then run the query exluding that random set, if
 not then just run the normal above query. However, it
 is not keeping random set from page to page.

 Am I going about this is the right way?


 Best regards,
  Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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