Re: CF and Crystal Reports

[bjonsson]

you might want to look at "CFX GRAPHICS SERVER".
 i havent actually used it, but it might help you out.
http://www.cfdev.com/cfxgraphicsserver/
:-)



Please respond to [EMAIL PROTECTED]

To:   [EMAIL PROTECTED]
cc:
From: "Wong, Phoebe" [EMAIL PROTECTED] on 07/06/2000 04:45 PM
Subject:  CF and Crystal Reports


I'm looking for a way to generate bar charts on the fly, based on a PIN
submitted by a User.

Is there, for instance,  a way to pass a parameter from a ColdFusion
template to Crystal Reports in order to generate bar charts on the fly?

thank you,
 Phoebe Wong
 [EMAIL PROTECTED]
 VA Greater Los Angeles Healthcare
 818.895.9550








--

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






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

Error:No Error ....with CFFILE

[mcardini]

Hi,
CF write the file on desktop but it is empty: why?
this is the code:
---
cfset outfile="c:\windows\desktop\u.htm"
cffile action="WRITE" file="#outfile#" output="plain text"
 and this is the CF error:
--
Error Occurred While Processing Request
Error Diagnostic Information
Error processing CFFILE

Error attempting to write data to target file 'c:\windows\desktop\u.htm'.

Error: No error occurred.

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (14:1) to (14:59).


Date/Time: 07/06/00 08:22:37
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 95)
Remote Address: 127.0.0.1
 ---

thanks in advance,

Mauro


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

RE: Error:No Error ....with CFFILE

[Peter Tilbrook]

I don't think that CF lets you (and quite rightly) interact with a users
desktop for security reasons. The manipulation should be within your
websites area of access and security. Can you imagine the fun developers
could have if they could send data directly to your desktop or anywhere else
on your PC? Create, say, a "temp" directory within your CF site and interact
with that instead.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 6 July 2000 4:34 PM
To: [EMAIL PROTECTED]
Subject: Error:No Error with CFFILE


Hi,
CF write the file on desktop but it is empty: why?
this is the code:
---
cfset outfile="c:\windows\desktop\u.htm"
cffile action="WRITE" file="#outfile#" output="plain text"
 and this is the CF error:
--
Error Occurred While Processing Request
Error Diagnostic Information
Error processing CFFILE

Error attempting to write data to target file 'c:\windows\desktop\u.htm'.

Error: No error occurred.

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (14:1) to (14:59).


Date/Time: 07/06/00 08:22:37
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 95)
Remote Address: 127.0.0.1
 ---

thanks in advance,

Mauro



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

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

Re: CFMAILHundreds of messages left undelivered ... why?

[Jim McAtee]

I'm not sure I undestand this.  Doesn't CF merely pass off the messages to
the SMTP server for relaying?  Same as if they had come from an email
client such as Outlook Express?  Is it the mass-assault on the SMTP server
that causes messages to be immediately sent to the undeliv folder?  In my
experience the immediate return to the sender would only be caused by
things like a domain that can't be resolved, or else the domain has no
mail exchanger in DNS, or else the destination mail server rejects the
imcoming message for some reason, like the email address is invalid, the
mailbox has exceeded its size quota, or the sender domain or IP address
has been rejected.  In most other cases, the outgoing SMTP server will
hold the message and attempt to send it for (usually) several days.  Are
there other reasons why CF, as a sending client would see more rejections
than another client?  If the 'undeliver' messages are placed there for a
good reason, then it wouldn't make much sense trying to send them again.

Jim


-Original Message-
From: Nick Slay [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, July 05, 2000 11:54 PM
Subject: Re: CFMAILHundreds of messages left undelivered ... why?


As far as I understand Mike, the steps you mention are correct.  I have
seen
things sitting in the undeliv folder, and they have never been sent.. so
I'm
fairly certain that you're 40,000+ messages would never have been sent.

If you want to actually send them, you can copy them back to the Spool
folder, however this poses the question as to why they weren't sent,
which I
guess you've figured...  If it was that the mail server was unavailable
at
the time, then they should be delivered if you drop them into the spool
folder.. but if it's a relaying error, ie, the domain of the senders
address
does not equal that of the email server, then they would never be
delivered.

Hope that helps a little

Nick


 From: Michael Kear [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Thu, 6 Jul 2000 13:01:43 +1000 (EST)
 To: [EMAIL PROTECTED]
 Subject: CFMAILHundreds of messages left undelivered ... why?

 Yesterday, I did a dumb thing and got into a nasty pickle with my email
 newsletter.  I'm really grateful to Nick Slay for coming rapidly to my
 rescue with the solution.

 Now I find there's another potential problem . there were 40,920
 undelivered messages left on my server after I rebooted it, all with a
 file name like CFM.TMP.  As it happens, this was a blessing in this
 case, or else there would have been 40,920 messages incorrectly
delivered
 to my users.  And they'd have been even more irate than they were.

 But what about all those undelivered messages?

 Would they have ever been sent?  If I had wanted them to be sent, how
 would I do that?

 Is this folder C:\CFUSION\MAIL\UNDELIVR  (Assuming a default
installation)
 a holding pen for messages that are to be delivered?  If not, what
exactly
 is the process?

 Here's how I am guessing it works .. can someone confirm this please?

 (1) The CF server performs the query and other processing to compile
each
 email.
 (2)  Each email is in a file of its own called CFM.TMP and is
dropped
 into C:\CFUSION\MAIL\SPOOL
 (3) The SMTP server looks there regularly and takes any files and
 sends them.
 (4) If there is an error, the SMTP server writes a record to
 C:\CFUSION\MAIL\LOGS\ERRORS.LOG  then moves the error email to
 C:\CFUSION\MAIL\UNDELIVR
 (5) Once a message gets to C:\CFUSION\MAIL\UNDELIVR it sits there until
 manual intervention fixes it.

 Is this right?

 Cheers,
 Mike Kear
 AFP Web Development
 Windsor, NSW, Australia


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

Re: CFMAILHundreds of messages left undelivered ... why?

[Nick Slay]

I'm not sure how many reasons there are for rejecting messages, in my
experience, I know that specifying a sender address that is different to the
email server wil cause an undeliverable message where relaying is not
allowed, ie, sending a message from [EMAIL PROTECTED] and the email
server is set up for domain webbods.com.au will not work because my email
server is set up to not relay messages.

As for the email server not being available, I'm not entirely sure how CF
would handle that, i.e whether it stays in the spool folder, or whether it
get's moved to the undeliv folder.


 From: "Jim McAtee" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Thu, 6 Jul 2000 01:25:43 -0600
 To: [EMAIL PROTECTED]
 Subject: Re: CFMAILHundreds of messages left undelivered ... why?
 
 I'm not sure I undestand this.  Doesn't CF merely pass off the messages to
 the SMTP server for relaying?  Same as if they had come from an email
 client such as Outlook Express?  Is it the mass-assault on the SMTP server
 that causes messages to be immediately sent to the undeliv folder?  In my
 experience the immediate return to the sender would only be caused by
 things like a domain that can't be resolved, or else the domain has no
 mail exchanger in DNS, or else the destination mail server rejects the
 imcoming message for some reason, like the email address is invalid, the
 mailbox has exceeded its size quota, or the sender domain or IP address
 has been rejected.  In most other cases, the outgoing SMTP server will
 hold the message and attempt to send it for (usually) several days.  Are
 there other reasons why CF, as a sending client would see more rejections
 than another client?  If the 'undeliver' messages are placed there for a
 good reason, then it wouldn't make much sense trying to send them again.
 
 Jim
 
 
 -Original Message-
 From: Nick Slay [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Wednesday, July 05, 2000 11:54 PM
 Subject: Re: CFMAILHundreds of messages left undelivered ... why?
 
 
 As far as I understand Mike, the steps you mention are correct.  I have
 seen
 things sitting in the undeliv folder, and they have never been sent.. so
 I'm
 fairly certain that you're 40,000+ messages would never have been sent.
 
 If you want to actually send them, you can copy them back to the Spool
 folder, however this poses the question as to why they weren't sent,
 which I
 guess you've figured...  If it was that the mail server was unavailable
 at
 the time, then they should be delivered if you drop them into the spool
 folder.. but if it's a relaying error, ie, the domain of the senders
 address
 does not equal that of the email server, then they would never be
 delivered.
 
 Hope that helps a little
 
 Nick
 
 
 From: Michael Kear [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Thu, 6 Jul 2000 13:01:43 +1000 (EST)
 To: [EMAIL PROTECTED]
 Subject: CFMAILHundreds of messages left undelivered ... why?
 
 Yesterday, I did a dumb thing and got into a nasty pickle with my email
 newsletter.  I'm really grateful to Nick Slay for coming rapidly to my
 rescue with the solution.
 
 Now I find there's another potential problem . there were 40,920
 undelivered messages left on my server after I rebooted it, all with a
 file name like CFM.TMP.  As it happens, this was a blessing in this
 case, or else there would have been 40,920 messages incorrectly
 delivered
 to my users.  And they'd have been even more irate than they were.
 
 But what about all those undelivered messages?
 
 Would they have ever been sent?  If I had wanted them to be sent, how
 would I do that?
 
 Is this folder C:\CFUSION\MAIL\UNDELIVR  (Assuming a default
 installation)
 a holding pen for messages that are to be delivered?  If not, what
 exactly
 is the process?
 
 Here's how I am guessing it works .. can someone confirm this please?
 
 (1) The CF server performs the query and other processing to compile
 each
 email.
 (2)  Each email is in a file of its own called CFM.TMP and is
 dropped
 into C:\CFUSION\MAIL\SPOOL
 (3) The SMTP server looks there regularly and takes any files and
 sends them.
 (4) If there is an error, the SMTP server writes a record to
 C:\CFUSION\MAIL\LOGS\ERRORS.LOG  then moves the error email to
 C:\CFUSION\MAIL\UNDELIVR
 (5) Once a message gets to C:\CFUSION\MAIL\UNDELIVR it sits there until
 manual intervention fixes it.
 
 Is this right?
 
 Cheers,
 Mike Kear
 AFP Web Development
 Windsor, NSW, Australia
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
 body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 

Re: CFMAILHundreds of messages left undelivered ... why?

[Michael Kear]

In this case, the vast majority of the email addresses would have been
valid, since it's a mailing list that's used quite regularly.  So the
reason for rejection must be other than invalid domains, invalid addresses
etc.

It could possibly be errors caused by the SMTP server being too busy -
we're talking about early evening - our peak time of day, and the CF
server suddenly dumping a huge number of emails into the queue.

Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia



On Thu, 6 Jul 2000, Nick Slay wrote:

 I'm not sure how many reasons there are for rejecting messages, in my
 experience, I know that specifying a sender address that is different to the
 email server wil cause an undeliverable message where relaying is not
 allowed, ie, sending a message from [EMAIL PROTECTED] and the email
 server is set up for domain webbods.com.au will not work because my email
 server is set up to not relay messages.
 
 As for the email server not being available, I'm not entirely sure how CF
 would handle that, i.e whether it stays in the spool folder, or whether it
 get's moved to the undeliv folder.
 
 
  From: "Jim McAtee" [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date: Thu, 6 Jul 2000 01:25:43 -0600
  To: [EMAIL PROTECTED]
  Subject: Re: CFMAILHundreds of messages left undelivered ... why?
  
  I'm not sure I undestand this.  Doesn't CF merely pass off the messages to
  the SMTP server for relaying?  Same as if they had come from an email
  client such as Outlook Express?  Is it the mass-assault on the SMTP server
  that causes messages to be immediately sent to the undeliv folder?  In my
  experience the immediate return to the sender would only be caused by
  things like a domain that can't be resolved, or else the domain has no
  mail exchanger in DNS, or else the destination mail server rejects the
  imcoming message for some reason, like the email address is invalid, the
  mailbox has exceeded its size quota, or the sender domain or IP address
  has been rejected.  In most other cases, the outgoing SMTP server will
  hold the message and attempt to send it for (usually) several days.  Are
  there other reasons why CF, as a sending client would see more rejections
  than another client?  If the 'undeliver' messages are placed there for a
  good reason, then it wouldn't make much sense trying to send them again.
  
  Jim
  
  
  -Original Message-
  From: Nick Slay [EMAIL PROTECTED]
  To: [EMAIL PROTECTED] [EMAIL PROTECTED]
  Date: Wednesday, July 05, 2000 11:54 PM
  Subject: Re: CFMAILHundreds of messages left undelivered ... why?
  
  
  As far as I understand Mike, the steps you mention are correct.  I have
  seen
  things sitting in the undeliv folder, and they have never been sent.. so
  I'm
  fairly certain that you're 40,000+ messages would never have been sent.
  
  If you want to actually send them, you can copy them back to the Spool
  folder, however this poses the question as to why they weren't sent,
  which I
  guess you've figured...  If it was that the mail server was unavailable
  at
  the time, then they should be delivered if you drop them into the spool
  folder.. but if it's a relaying error, ie, the domain of the senders
  address
  does not equal that of the email server, then they would never be
  delivered.
  
  Hope that helps a little
  
  Nick
  
  
  From: Michael Kear [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date: Thu, 6 Jul 2000 13:01:43 +1000 (EST)
  To: [EMAIL PROTECTED]
  Subject: CFMAILHundreds of messages left undelivered ... why?
  
  Yesterday, I did a dumb thing and got into a nasty pickle with my email
  newsletter.  I'm really grateful to Nick Slay for coming rapidly to my
  rescue with the solution.
  
  Now I find there's another potential problem . there were 40,920
  undelivered messages left on my server after I rebooted it, all with a
  file name like CFM.TMP.  As it happens, this was a blessing in this
  case, or else there would have been 40,920 messages incorrectly
  delivered
  to my users.  And they'd have been even more irate than they were.
  
  But what about all those undelivered messages?
  
  Would they have ever been sent?  If I had wanted them to be sent, how
  would I do that?
  
  Is this folder C:\CFUSION\MAIL\UNDELIVR  (Assuming a default
  installation)
  a holding pen for messages that are to be delivered?  If not, what
  exactly
  is the process?
  
  Here's how I am guessing it works .. can someone confirm this please?
  
  (1) The CF server performs the query and other processing to compile
  each
  email.
  (2)  Each email is in a file of its own called CFM.TMP and is
  dropped
  into C:\CFUSION\MAIL\SPOOL
  (3) The SMTP server looks there regularly and takes any files and
  sends them.
  (4) If there is an error, the SMTP server writes a record to
  C:\CFUSION\MAIL\LOGS\ERRORS.LOG  then moves the error email to
  C:\CFUSION\MAIL\UNDELIVR
  (5) Once a message gets to 

Re: CFMAILHundreds of messages left undelivered ... why?

[Nick Slay]

Mike, I was refering to the email address that you specified in the FROM
parameter of CFMAIL, not the ones you are sending to.  While this probably
isn't the reason, it's worth checking none the less, it's tripped me up in
the past.

When I was looking for an email server program to run here, I discovered a
document that showed the rejection rates of emails, and I understand that
just about all email servers with the exception of one, Merak Mail, had
problems when several hundred messages were dumped to it at once.. so I
would agree with the other comments that it's probably overload related.

Just a suggestion, but do you run the email server there?  Does it handle
mailing lists?  If it's anything like Merak, it contains a text file with a
list of email addresses that have subscribed.. What you could do is let CF
create a text file of all the email addresses you want to send the
newsletter to, save that text file to the relevant place, and then send a
single email to the mailing list address.  I know this would work ok with
Merak, but it really depends on your email server.  Just a thought anyhow!


(oops.. while I name dropped Merak a few times, I by no means have any
relationship with them other than as a client.  The program, in my own
opinion is great, and the support excellent.  I haven't experienced any
problems with it at all)


 From: Michael Kear [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Thu, 6 Jul 2000 17:56:08 +1000 (EST)
 To: [EMAIL PROTECTED]
 Subject: Re: CFMAILHundreds of messages left undelivered ... why?
 
 In this case, the vast majority of the email addresses would have been
 valid, since it's a mailing list that's used quite regularly.  So the
 reason for rejection must be other than invalid domains, invalid addresses
 etc.
 
 It could possibly be errors caused by the SMTP server being too busy -
 we're talking about early evening - our peak time of day, and the CF
 server suddenly dumping a huge number of emails into the queue.
 
 Cheers,
 Mike Kear
 AFP Web Development
 Windsor, NSW, Australia
 
 
 
 On Thu, 6 Jul 2000, Nick Slay wrote:
 
 I'm not sure how many reasons there are for rejecting messages, in my
 experience, I know that specifying a sender address that is different to the
 email server wil cause an undeliverable message where relaying is not
 allowed, ie, sending a message from [EMAIL PROTECTED] and the email
 server is set up for domain webbods.com.au will not work because my email
 server is set up to not relay messages.
 
 As for the email server not being available, I'm not entirely sure how CF
 would handle that, i.e whether it stays in the spool folder, or whether it
 get's moved to the undeliv folder.
 
 
 From: "Jim McAtee" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Thu, 6 Jul 2000 01:25:43 -0600
 To: [EMAIL PROTECTED]
 Subject: Re: CFMAILHundreds of messages left undelivered ... why?
 
 I'm not sure I undestand this.  Doesn't CF merely pass off the messages to
 the SMTP server for relaying?  Same as if they had come from an email
 client such as Outlook Express?  Is it the mass-assault on the SMTP server
 that causes messages to be immediately sent to the undeliv folder?  In my
 experience the immediate return to the sender would only be caused by
 things like a domain that can't be resolved, or else the domain has no
 mail exchanger in DNS, or else the destination mail server rejects the
 imcoming message for some reason, like the email address is invalid, the
 mailbox has exceeded its size quota, or the sender domain or IP address
 has been rejected.  In most other cases, the outgoing SMTP server will
 hold the message and attempt to send it for (usually) several days.  Are
 there other reasons why CF, as a sending client would see more rejections
 than another client?  If the 'undeliver' messages are placed there for a
 good reason, then it wouldn't make much sense trying to send them again.
 
 Jim
 
 
 -Original Message-
 From: Nick Slay [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Wednesday, July 05, 2000 11:54 PM
 Subject: Re: CFMAILHundreds of messages left undelivered ... why?
 
 
 As far as I understand Mike, the steps you mention are correct.  I have
 seen
 things sitting in the undeliv folder, and they have never been sent.. so
 I'm
 fairly certain that you're 40,000+ messages would never have been sent.
 
 If you want to actually send them, you can copy them back to the Spool
 folder, however this poses the question as to why they weren't sent,
 which I
 guess you've figured...  If it was that the mail server was unavailable
 at
 the time, then they should be delivered if you drop them into the spool
 folder.. but if it's a relaying error, ie, the domain of the senders
 address
 does not equal that of the email server, then they would never be
 delivered.
 
 Hope that helps a little
 
 Nick
 
 
 From: Michael Kear [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Thu, 6 Jul 2000 13:01:43 +1000 

Memory Leaks in CFX tags

[Colin Robinson]

I have just started using  the cfx_ss and cfx_csvtoquery tags from the
allaire website . I am now starting to experience out of virtual memory
errors and this morning had to reboot the server.  Are there any know memory
leak problems with these tags ?

cheers

Colin Robinson
In-tuition.co.uk
Tel: +44 (0) 1825 746400
ICQ: 74207528

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

RE: a very specifc query...

[Bert Dawson]

sounds like you need an outer join to the tech_code table

SELECT  nxstar_e.*
   ,nxsprodr.prod_desc
   ,(SELECT Count (id)
 FROM  nxsnotes
 WHERE nxsnotes.id = nxstar_e.tar_num) AS Activities
   ,nxsteche.tech_name
FROMnxstar_e
   ,nxsprodr
   ,nxsteche
WHERE   nxsprodr.prod_code = nxstar_e.prod_id
AND cust_code = #Cookie.User_ID#
AND nxstar_e.entered_by *= nxsteche.tech_code  /** new line **/
ORDER BY nxstar_e.tar_num desc

Note the *= on the last line - if the join condition is met then the
nxsteche.tech_code will be returned, otherwise NULL will be returned.

ps. Don't know what dB you're using: this is the syntax for sql server

Bert Dawson

 -Original Message-
 From: miles [mailto:[EMAIL PROTECTED]]
 Sent: 05 July 2000 22:48
 To: [EMAIL PROTECTED]
 Subject: RE: a very specifc query...
 
 
 Can you just add the nxsteche table to the first query?
 
 nope.  that creates more problems... because it further refines
 the query based on the fact that its looking for assigned_to to match
 the tech_code (the last AND)...and if it doesn't match then the query
 will produce nothing.
 
 I know I just tried ithowever if you remove the last AND
 statement that you added it does sort of what Im looking for
 it to do...but not quite...it swaps out the tech_code for the
 user_name, just not the right ones!
 
 CFQUERY Name="CaseAndNotes" DataSource="CCMast"
  SELECT  nxstar_e.*
 ,nxsprodr.prod_desc
 ,(SELECT Count (id)
   FROM  nxsnotes
   WHERE nxsnotes.id = nxstar_e.tar_num) AS Activities
 ,nxsteche.tech_name  /** new line **/
  FROMnxstar_e
 ,nxsprodr
 ,nxsteche/** new line **/
  WHERE   nxsprodr.prod_code = nxstar_e.prod_id
  AND cust_code = #Cookie.User_ID#
  AND nxstar_e.entered_by = nxsteche.tech_code/** new line **/
  ORDER BY nxstar_e.tar_num desc
 /cfquery
 
 Wanna try this one more time, anyone else ?
 
 Miles.
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Oops Compiling CFX Tags

[Larry W. Virden]

From: GE [EMAIL PROTECTED]
 Has anyone had any luck compiling CFX tags with CF Server 4.5.1 on
 Solaris 7 and the
 2.8.1.1. g++ compiler?

I've not found any info on how to do this.  If you find any info, please
let me know.  I've asked Allaire tech reps, this group numerous times,
other web forums, etc.  The most I have ever found is some info talking
about Visual C++, which of course is totally useless on Solaris...
-- 
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/
Unless explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: How to set a future date?

[Anthony Geoghegan]

|
|Is there a way to fill in a future date in a column of
|a table? 


Use the dateadd function with the now() fuction as an argument to specify a
future date
ex.:
2 weeks from today:
#DateAdd("d","14",Now())#
make sure the number of "days" is in quotes.

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

Using Select Tags in optional Form Submissions

[Angél Stewart]

Hello!

I have a form, with four text boxes and a select box that is pulling data
from a Department Table to get available departments and their Department
IDs.

Now, the user can eitehr enter an Employee Name, ID, or select a department.
However, on the next page I have several CFIF IsDefined tags to check
which field has a value in it, so that I know what to build the query on.

It's one or the other, they can't enter a Name, and an ID...AND a department
(wouldn't make sense to do that anyways heh heh).

But...for some reason the Department is always carried forward,even if the
user makes no selection.

I need to do this same thing on a couple other forms. Is it impossible to
use a Select box in this way?
Is a value ALWAYS sent when the user clicks submit, even if the user never
made a selection from the box?

I require a way around this, or some other way to simulate a combo box :-\
help help.
*waves arms frantically*

-Gel



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

How the heck can I do this?

[Jeff Fongemie]

I'm setting up a real simple auction application. Super simple. People

submit bids via a form, then the top 5 bids are displayed on a page. The

catch is, I only want the 5th highest bid to show the actual bid.

So, I can order the query by bid descending and for output bids 1 through 5

will give the bidders name, but I need to have the bid amounts hidden for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output. Is there

a way to control all this stuff with the SQL, or do I have a basic query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

Thanks,

Jeff Fongemie



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

RE: Application.cfm location costs?

[paul smith]

Why is this?

best,  paul

At 05:46 PM 7/5/00 -0700, you wrote:
Perhaps it's because complex directory structures with extensive 
sub-directories are inherently BAD application design.

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

Last post: How do I Optimize Win 2000 (IIS) for Warp speed with Cold Fusion.

[Mark W. Breneman]

This will be my last posting requesting optimizing tips.  Please share any
info you have/know.  The more info you share the stronger the CF community
becomes thus the stronger CF is in the marketplace.

IF, you are looking for my NT 4.0 info, I have posted it several times to
the CF talk list in the last few days per lots of requests.

Anyone care to share



About 9 months ago I collected and posted a compiled list tips and tricks
(thanks for all the info, by the way) for optimizing NT4.0(IIS) and Cold
Fusion for max performance.  I would like to do the same for Windows 2000
(IIS 5) and CF 4.5.

Please also include any gaping security holes and fixes.  And / Or any handy
tricks like renaming the administrator account in NT.

I will post all the tips and tricks compiled in a list with my own in a few
days.

If you would like to contact me off list [EMAIL PROTECTED]

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


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


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

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

Re: Memory Leaks in CFX tags

[Jeremy Allen]

I have a suggestion you may wish to try :)
Instead of csvtoquery, which I am assuming is a comma
delimited file. Check out the CFHTTP tag. You can specify
a delimiter and you can specify a file to point it at and it will
turn the xyz delimited file into a query.

Jeremy Allen
[EMAIL PROTECTED]


- Original Message -
From: Colin Robinson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 06, 2000 4:27 AM
Subject: Memory Leaks in CFX tags


I have just started using  the cfx_ss and cfx_csvtoquery tags from the
allaire website . I am now starting to experience out of virtual memory
errors and this morning had to reboot the server.  Are there any know memory
leak problems with these tags ?

cheers

Colin Robinson
In-tuition.co.uk
Tel: +44 (0) 1825 746400
ICQ: 74207528


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

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

This where has everyone that has left the list gone?

[Mark W. Breneman]

I have noted over the last few months a lot of the people, that I have
enjoyed reading and chatting with, no longer seem to post to this list.

In short where has everyone gone?  Another list?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

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

Re: Using Select Tags in optional Form Submissions

[Julie McKellar]

How I handle this is setting a default value in the top selection of the
box.

option name = "blah" value = "none"--Select One--/option

Then on the other side you will not use the IsDefined, use neq "none".

Julie




- Original Message -
From: Angél Stewart [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 06, 2000 7:01 AM
Subject: Using Select Tags in optional Form Submissions


 Hello!

 I have a form, with four text boxes and a select box that is pulling data
 from a Department Table to get available departments and their Department
 IDs.

 Now, the user can eitehr enter an Employee Name, ID, or select a
department.
 However, on the next page I have several CFIF IsDefined tags to
check
 which field has a value in it, so that I know what to build the query on.

 It's one or the other, they can't enter a Name, and an ID...AND a
department
 (wouldn't make sense to do that anyways heh heh).

 But...for some reason the Department is always carried forward,even if the
 user makes no selection.

 I need to do this same thing on a couple other forms. Is it impossible to
 use a Select box in this way?
 Is a value ALWAYS sent when the user clicks submit, even if the user never
 made a selection from the box?

 I require a way around this, or some other way to simulate a combo box :-\
 help help.
 *waves arms frantically*

 -Gel



 --

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


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

Re: Last post: How do I Optimize Win 2000 (IIS) for Warp speed with Cold Fusion.

[Lewis Steven]

This is a multi-part message in MIME format.
--B21926975EE819D62D1F9427
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Mark,

Can I receive a copy of your list of optimizing tips for NT 4.0?

Steve

"Mark W. Breneman" wrote:

 This will be my last posting requesting optimizing tips.  Please share any
 info you have/know.  The more info you share the stronger the CF community
 becomes thus the stronger CF is in the marketplace.

 IF, you are looking for my NT 4.0 info, I have posted it several times to
 the CF talk list in the last few days per lots of requests.

 Anyone care to share

 About 9 months ago I collected and posted a compiled list tips and tricks
 (thanks for all the info, by the way) for optimizing NT4.0(IIS) and Cold
 Fusion for max performance.  I would like to do the same for Windows 2000
 (IIS 5) and CF 4.5.

 Please also include any gaping security holes and fixes.  And / Or any handy
 tricks like renaming the administrator account in NT.

 I will post all the tips and tricks compiled in a list with my own in a few
 days.

 If you would like to contact me off list [EMAIL PROTECTED]

 Mark W. Breneman
 -Cold Fusion Developer
 -Network Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770

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

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

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

--B21926975EE819D62D1F9427
Content-Type: text/x-vcard; charset=us-ascii;
 name="lewis_steven.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steven Lewis
Content-Disposition: attachment;
 filename="lewis_steven.vcf"

begin:vcard 
n:Lewis;Steven
tel;fax:703-845-3939
tel;work:703-845-3996
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Steven Lewis
end:vcard

--B21926975EE819D62D1F9427--

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

still not working

[gregg Kachel]

Hi, thanks for all of your help. I'm still struggling with the connecting
the two tables. I did as Mark suggested and checked for required fields, the
only one I have is the primary keys wich are autonumbered (memberid for
memberlist, id for members) I linked the tables together with memberID but
that doesn't seem to help.  Also as Nick suggested I took out the ''s from
my number fields, and put the inserts in correct order. So far this is what
i have:
cfquery
Datasource="vhc"

insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )
values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
'#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
/cfquery

cfquery
Datasource="vhc"
insert into members(firstname,lastname, username, password, emailaddress)
values( '#firstname#', '#lastname#', '#username#', '#password#',
'#emailaddress#')
/cfquery

The error is:
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (3:17).


Date/Time: 07/06/00 09:26:49
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.55
HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
Template: D:\Inetpub\wwwroot\CFDOCS\a
Web\houseboat\admin\vhc\newaddprofile2.cfm

Thanks again, I'm getting very frustrating, I know this should be fairly
easy and straight forward.

Gregg

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

RE: still not working

[Steve DeWitt]

if this is the exact code you have a comma missing in the values between
'#phone#' and '#state#'

-Original Message-
From: gregg Kachel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:18 AM
To: [EMAIL PROTECTED]
Subject: still not working


Hi, thanks for all of your help. I'm still struggling with the connecting
the two tables. I did as Mark suggested and checked for required fields, the
only one I have is the primary keys wich are autonumbered (memberid for
memberlist, id for members) I linked the tables together with memberID but
that doesn't seem to help.  Also as Nick suggested I took out the ''s from
my number fields, and put the inserts in correct order. So far this is what
i have:
cfquery
Datasource="vhc"

insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )
values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
'#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
/cfquery

cfquery
Datasource="vhc"
insert into members(firstname,lastname, username, password, emailaddress)
values( '#firstname#', '#lastname#', '#username#', '#password#',
'#emailaddress#')
/cfquery

The error is:
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (3:17).


Date/Time: 07/06/00 09:26:49
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.55
HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
Template: D:\Inetpub\wwwroot\CFDOCS\a
Web\houseboat\admin\vhc\newaddprofile2.cfm

Thanks again, I'm getting very frustrating, I know this should be fairly
easy and straight forward.

Gregg


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

RE: How the heck can I do this?

[Steve DeWitt]

can you post the code?

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 5:19 AM
To: [EMAIL PROTECTED]
Subject: How the heck can I do this?


I'm setting up a real simple auction application. Super simple. People

submit bids via a form, then the top 5 bids are displayed on a page. The

catch is, I only want the 5th highest bid to show the actual bid.

So, I can order the query by bid descending and for output bids 1 through 5

will give the bidders name, but I need to have the bid amounts hidden for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output. Is there

a way to control all this stuff with the SQL, or do I have a basic query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

Thanks,

Jeff Fongemie




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

RE: still not working

[Troy Johnson]

doesn't surprise me :)

-Original Message-
From: Steve DeWitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: still not working


if this is the exact code you have a comma missing in the values between
'#phone#' and '#state#'

-Original Message-
From: gregg Kachel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:18 AM
To: [EMAIL PROTECTED]
Subject: still not working


Hi, thanks for all of your help. I'm still struggling with the connecting
the two tables. I did as Mark suggested and checked for required fields, the
only one I have is the primary keys wich are autonumbered (memberid for
memberlist, id for members) I linked the tables together with memberID but
that doesn't seem to help.  Also as Nick suggested I took out the ''s from
my number fields, and put the inserts in correct order. So far this is what
i have:
cfquery
Datasource="vhc"

insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )
values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
'#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
/cfquery

cfquery
Datasource="vhc"
insert into members(firstname,lastname, username, password, emailaddress)
values( '#firstname#', '#lastname#', '#username#', '#password#',
'#emailaddress#')
/cfquery

The error is:
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (3:17).


Date/Time: 07/06/00 09:26:49
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.55
HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
Template: D:\Inetpub\wwwroot\CFDOCS\a
Web\houseboat\admin\vhc\newaddprofile2.cfm

Thanks again, I'm getting very frustrating, I know this should be fairly
easy and straight forward.

Gregg


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

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

RE: still not working

[Troy Johnson]

actually, try removing the trailing comma after emailaddress in the insert
part of your sql.
by the way, Ryan found your error ;)and says hi.

-Original Message-
From: Steve DeWitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: still not working


if this is the exact code you have a comma missing in the values between
'#phone#' and '#state#'

-Original Message-
From: gregg Kachel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:18 AM
To: [EMAIL PROTECTED]
Subject: still not working


Hi, thanks for all of your help. I'm still struggling with the connecting
the two tables. I did as Mark suggested and checked for required fields, the
only one I have is the primary keys wich are autonumbered (memberid for
memberlist, id for members) I linked the tables together with memberID but
that doesn't seem to help.  Also as Nick suggested I took out the ''s from
my number fields, and put the inserts in correct order. So far this is what
i have:
cfquery
Datasource="vhc"

insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )
values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
'#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
/cfquery

cfquery
Datasource="vhc"
insert into members(firstname,lastname, username, password, emailaddress)
values( '#firstname#', '#lastname#', '#username#', '#password#',
'#emailaddress#')
/cfquery

The error is:
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (3:17).


Date/Time: 07/06/00 09:26:49
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.55
HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
Template: D:\Inetpub\wwwroot\CFDOCS\a
Web\houseboat\admin\vhc\newaddprofile2.cfm

Thanks again, I'm getting very frustrating, I know this should be fairly
easy and straight forward.

Gregg


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

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

RE: still not working

[Steve DeWitt]

well actually it is probably both

-Original Message-
From: Troy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:26 AM
To: '[EMAIL PROTECTED]'
Subject: RE: still not working


actually, try removing the trailing comma after emailaddress in the insert
part of your sql.
by the way, Ryan found your error ;)and says hi.

-Original Message-
From: Steve DeWitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: still not working


if this is the exact code you have a comma missing in the values between
'#phone#' and '#state#'

-Original Message-
From: gregg Kachel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:18 AM
To: [EMAIL PROTECTED]
Subject: still not working


Hi, thanks for all of your help. I'm still struggling with the connecting
the two tables. I did as Mark suggested and checked for required fields, the
only one I have is the primary keys wich are autonumbered (memberid for
memberlist, id for members) I linked the tables together with memberID but
that doesn't seem to help.  Also as Nick suggested I took out the ''s from
my number fields, and put the inserts in correct order. So far this is what
i have:
cfquery
Datasource="vhc"

insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )
values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
'#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
/cfquery

cfquery
Datasource="vhc"
insert into members(firstname,lastname, username, password, emailaddress)
values( '#firstname#', '#lastname#', '#username#', '#password#',
'#emailaddress#')
/cfquery

The error is:
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (3:17).


Date/Time: 07/06/00 09:26:49
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.55
HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
Template: D:\Inetpub\wwwroot\CFDOCS\a
Web\houseboat\admin\vhc\newaddprofile2.cfm

Thanks again, I'm getting very frustrating, I know this should be fairly
easy and straight forward.

Gregg


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

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

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

More than one Submit button

[aslam bajaria]

This is a long question. Please be patient with the
question.

I have a form which has to have more than one submit
button. 

But, each submit button will have to have a different
fuseaction. 

Also, for one of the submit buttons, a message box
should appear if the user has not selected something
from the drop down menu. 

Can this be done in Javascript? Or is it better to use
CFFORM/CFFORM tag? if so, can someone please help
me in figuring out how to do it?

Appreciate.
A.B.

__
Do You Yahoo!?
Send instant messages  get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: How the heck can I do this?

[Jeff Fongemie]

As it stands, the output will show all bids. I need it to show a place
holder

for the first top 4 bids like  and show the 5th highest bid. The idea is

that the bidders can't see the top 4 bids.

Jeff Fongemie





CFQUERY NAME="getbids" DATASOURCE="hclimb"

SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,

BidDate, Alias

FROM bids

ORDER BY bidAmount desc/CFQUERY



!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

html

head

titleBids Are.../title

/head

body

TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"

THAlias/TH THAmt. Bid/TH THBid Date/TH

CFOUTPUT QUERY="getbids" maxrows=5

TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#

TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD

/TR

/CFOUTPUT

/TABLE

/body

/html






"Steve DeWitt" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 can you post the code?

 -Original Message-
 From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 5:19 AM
 To: [EMAIL PROTECTED]
 Subject: How the heck can I do this?


 I'm setting up a real simple auction application. Super simple. People

 submit bids via a form, then the top 5 bids are displayed on a page. The

 catch is, I only want the 5th highest bid to show the actual bid.

 So, I can order the query by bid descending and for output bids 1 through
5

 will give the bidders name, but I need to have the bid amounts hidden for

 the top 4 bids, and show the 5th.

 To display only the top 5 bids, I'm using maxrows =5 in my output. Is
there

 a way to control all this stuff with the SQL, or do I have a basic query,

 order by bid desc. and control the results through output?

 With the output method, I can't seem to be able to get the results to

 populate the 5th bid amt., but not the first 4.

 Thanks,

 Jeff Fongemie



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

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


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

RE: wddx problem

[Jennifer A. Caulfield]

I don't know if this would be the reason, but I got a similar error when my
pages included accented characters. I had to convert them using char
code=?? before making the recordset.

Jennifer

-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:28 AM
To: [EMAIL PROTECTED]
Subject: wddx problem


I've been using wddx to process backend pages from moreover.com, which has
been working great. Today I am getting this message:

XML parsing error: not well-formed (error code 4, line 70, column 16, buffer
offset 4196)
The error occurred while processing an element with a general identifier of
(CFWDDX), occupying document position (5:1) to (5:87) in the template file
d:\http\4pines\index.cfm

How do I figure out what is wrong?

TIA
Matt


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

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

RE: How the heck can I do this?

[Lon Lentz]

  Use a counter to count rows.

cfif RowNum Mod 5 eq 0#BidAmount#/cfif



Lon Lentz
Applications Developer - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:19 AM
To: [EMAIL PROTECTED]
Subject: How the heck can I do this?


With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

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

RE: How the heck can I do this?

[Jeff Fongemie]

As it stands, the output will show all bids. I need it to show a place
holder
for the first top 4 bids like  and show the 5th highest bid. The idea is
that the bidders can't see the top 4 bids.

Jeff Fongemie



CFQUERY NAME="getbids" DATASOURCE="hclimb"
SELECT  bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,
BidDate, Alias
FROM bids
ORDER BY  bidAmount desc/CFQUERY


!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

html
head
titleBids Are.../title
/head

body

TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"
  THAlias/TH THAmt. Bid/TH THBid Date/TH
  CFOUTPUT QUERY="getbids"
  TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#
  TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD
  /TR
  /CFOUTPUT
  /TABLE

/body
/html


-Original Message-
From: Steve DeWitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 9:43 AM
To: 'Jeff Fongemie '
Subject: RE: How the heck can I do this?



can you post a code sample?
-Original Message-
From: Jeff Fongemie
To: [EMAIL PROTECTED]
Sent: 7/6/00 5:19 AM
Subject: How the heck can I do this?

I'm setting up a real simple auction application. Super simple. People

submit bids via a form, then the top 5 bids are displayed on a page. The

catch is, I only want the 5th highest bid to show the actual bid.

So, I can order the query by bid descending and for output bids 1
through 5

will give the bidders name, but I need to have the bid amounts hidden
for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output. Is
there

a way to control all this stuff with the SQL, or do I have a basic
query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

Thanks,

Jeff Fongemie




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

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

Re: How the heck can I do this?

[Jon Boehnker]

try this (replacing the table/field names of course):

select top 5 bid
from bid_table
order by bid_desc

as far as hiding all but the 5th bid, it would probably be easiest to
just do a cfif bid_query.currentrow neq 5 type thing.

HTH

Jon

Jeff Fongemie wrote:
 
 I'm setting up a real simple auction application. Super simple. People
 
 submit bids via a form, then the top 5 bids are displayed on a page. The
 
 catch is, I only want the 5th highest bid to show the actual bid.
 
 So, I can order the query by bid descending and for output bids 1 through 5
 
 will give the bidders name, but I need to have the bid amounts hidden for
 
 the top 4 bids, and show the 5th.
 
 To display only the top 5 bids, I'm using maxrows =5 in my output. Is there
 
 a way to control all this stuff with the SQL, or do I have a basic query,
 
 order by bid desc. and control the results through output?
 
 With the output method, I can't seem to be able to get the results to
 
 populate the 5th bid amt., but not the first 4.
 
 Thanks,
 
 Jeff Fongemie
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

-- 
Jon Boehnker
[EMAIL PROTECTED]

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

Re: This where has everyone that has left the list gone?

[David Shadovitz]

 Where has everyone gone?  Another list?

Yes, but they asked us not to tell certain people ;)

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Using Select Tags in optional Form Submissions

[kraybill]

A select box will always result in a value being passed to the "action" page. I'd 
suggest
you use an initial OPTION something like this:

SELECT name="Department"
OPTION value="0"Select a Department
OPTIONDepartment 1
 OPTIONDepartment 2
etc
/SELECT

Then on your action page, do a CFIF test for Department, and if it's not 0, you know 
they
made a department selection...

Gene Kraybill

Angél Stewart [EMAIL PROTECTED] wrote:

 I have a form, with four text boxes and a select box that is pulling data
 from a Department Table to get available departments and their Department
 IDs.

 Now, the user can eitehr enter an Employee Name, ID, or select a department.
 However, on the next page I have several CFIF IsDefined tags to check
 which field has a value in it, so that I know what to build the query on.

 It's one or the other, they can't enter a Name, and an ID...AND a department
 (wouldn't make sense to do that anyways heh heh).

 But...for some reason the Department is always carried forward,even if the
 user makes no selection.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Using Select Tags in optional Form Submissions

[Bill Killillay]

Gel,

Any time a form is submitted it sends all of the form elements to the next
page or script.  What I have done in the past is set a bogus value for a
Please Select statement in the first option of my select.  That way if they
leave it alone and just choose to enter an ID the only real data you get is
the ID.  Then in your action page setup your IsDefined to check that the
value is NEQ to what ever the default value you set was.  The other way is
to break your form into two forms with two separate submits and just send it
to the same action page.  Hope that helps some...

Bill

 -Original Message-
 From: Angél Stewart [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 8:01 AM
 To: [EMAIL PROTECTED]
 Subject: Using Select Tags in optional Form Submissions


 Hello!

 I have a form, with four text boxes and a select box that is pulling data
 from a Department Table to get available departments and their Department
 IDs.

 Now, the user can eitehr enter an Employee Name, ID, or select a
 department.
 However, on the next page I have several CFIF IsDefined
 tags to check
 which field has a value in it, so that I know what to build the query on.

 It's one or the other, they can't enter a Name, and an ID...AND a
 department
 (wouldn't make sense to do that anyways heh heh).

 But...for some reason the Department is always carried forward,even if the
 user makes no selection.

 I need to do this same thing on a couple other forms. Is it impossible to
 use a Select box in this way?
 Is a value ALWAYS sent when the user clicks submit, even if the user never
 made a selection from the box?

 I require a way around this, or some other way to simulate a combo box :-\
 help help.
 *waves arms frantically*

 -Gel



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


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

When should I use CFLOCK?

[Tom Dyson]

The Allaire knowledge base article on monitoring memory usage states:

One of the most common causes [of increased memory usage] are improperly
locked access to session, application, and server variables. These variables
are stored in memory and need to be enclosed in a CFLOCK tag with the
appropriate SCOPE attribute specified (i.e. session, application, or server)
when referenced.

while Ben Forta says:

Caution: avoid unnecessary use of CFLOCK. Forcing code to single-threaded
use only can seriously impact system performance.

We're building an application which uses session and application variables
on every page (for security and user customisation). Should we use cflock
when we read them? Or when we write them? Or both? Does anyone have any
guidelines on cflock usage?

Thanks

Tom

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

RE: How the heck can I do this?

[Daniel Wm Brick III]

Jeff,

It looks like you only need a CFIF statement that checks the current row
being processed by the CFOUTPUT statement, such as:
CFOUTPUT QUERY="getbids" maxrows=5

TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#
CFIF CurrentRow IS NOT 5
TDAnonymous/TD TD/TD TD#BidDate#/TD
CFELSE
TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD
/CFIF
/TR

/CFOUTPUT

Hope it helps!
dBIII+

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: How the heck can I do this?


As it stands, the output will show all bids. I need it to show a place
holder

for the first top 4 bids like  and show the 5th highest bid. The idea is

that the bidders can't see the top 4 bids.

Jeff Fongemie





CFQUERY NAME="getbids" DATASOURCE="hclimb"

SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,

BidDate, Alias

FROM bids

ORDER BY bidAmount desc/CFQUERY



!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

html

head

titleBids Are.../title

/head

body

TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"

THAlias/TH THAmt. Bid/TH THBid Date/TH

CFOUTPUT QUERY="getbids" maxrows=5

TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#

TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD

/TR

/CFOUTPUT

/TABLE

/body

/html






"Steve DeWitt" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 can you post the code?

 -Original Message-
 From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 5:19 AM
 To: [EMAIL PROTECTED]
 Subject: How the heck can I do this?


 I'm setting up a real simple auction application. Super simple. People

 submit bids via a form, then the top 5 bids are displayed on a page. The

 catch is, I only want the 5th highest bid to show the actual bid.

 So, I can order the query by bid descending and for output bids 1 through
5

 will give the bidders name, but I need to have the bid amounts hidden for

 the top 4 bids, and show the 5th.

 To display only the top 5 bids, I'm using maxrows =5 in my output. Is
there

 a way to control all this stuff with the SQL, or do I have a basic query,

 order by bid desc. and control the results through output?

 With the output method, I can't seem to be able to get the results to

 populate the 5th bid amt., but not the first 4.

 Thanks,

 Jeff Fongemie






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

Re: More than one Submit button

[Justin v0.9 MacCarthy]

 But, each submit button will have to have a different
 fuseaction.

Sure , create a hidden form field called fuseaction
input type=hidden name=fuseaction value =""

Put this function in the header

cfhtmlhead text="
script
function SubmitFuseAction(fuseaction)
{
document.forms[0].fuseaction.value = fuseaction;
document.forms[0].submit();
}
/script
"

and on your buttons

input type=button onclick="SubmitFuseAction('fuseaction1');" value="button
1"
input type=button onclick="SubmitFuseAction('fuseaction2');" value="button
2"


~Justin



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

RE: Compiling CFX Tags

[Conrad, Christopher]

I know Allaire told me that I had to upgrade to Sun's 5.0 compiler when I
went to 4.51.

I just got 4.51 installed on our Solaris server here and I see something
kind of crazy. I register a CFX, compile it with Sun's 4.2 compiler. When I
hit the test template - I get a server error - it kills the server and
REMOVES the CFX tag from the CF admin!

Strange - I'm going to call our support person for this.

We have gnu 2.9 installed - I'll see if I can get that to work.

Chris

Christopher Conrad
Victoria's Secret Catalogue
http://www.VictoriasSecret.com
Senior.Programmer.Analyst
614.337.5653
[EMAIL PROTECTED]


 -Original Message-
 From: GE [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 05, 2000 7:51 PM
 To:   cf-talk
 Subject:  Compiling CFX Tags
 
 Hello,
 
 Has anyone had any luck compiling CFX tags with CF Server 4.5.1 and the
 g++ compiler?
 
 thanks,
 Nelson
 
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Sorting Structs

[Shawn Mirza]

This is a multi-part message in MIME format.

--=_NextPart_000__01BFE740.65E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,
I have a question regarding Structures. I have a structure made up of simple
name/value pairs. What would be the best technique to sort this structure
upon the values?
My Structure:

PageName.cfm = 1
PageTwo.cfm = 5
PageThree.cfm = 8

I need to show these in descending order:

PageThree.cfm = 8
PageTwo.cfm = 5
PageName.cfm = 1

Are Arrays the only way to use a 'sort' function?
Please feel free to provide ANY input, thanks!

--=_NextPart_000__01BFE740.65E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD
BODY
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000Hello, =

/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000I have =
a question=20
regarding Structures. I have a structure made up of simple name/value =
pairs.=20
What would be the best technique to sort this structure upon the=20
values?/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000My=20
Structure:/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN =
class=3D580184615-06072000PageName.cfm =3D=20
1/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN =
class=3D580184615-06072000PageTwo.cfm =3D=20
5/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN =
class=3D580184615-06072000PageThree.cfm =3D=20
8/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000I need =
to show these=20
in descending order: /SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000FONT =
face=3DArial=20
size=3D2SPAN class=3D580184615-06072000PageThree.cfm =3D=20
8/SPAN/FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000FONT =
face=3DArial=20
size=3D2SPAN class=3D580184615-06072000FONT face=3DArial =
size=3D2SPAN=20
class=3D580184615-06072000PageTwo.cfm =3D=20
5/SPAN/FONT/SPAN/FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000FONT =
face=3DArial=20
size=3D2SPAN class=3D580184615-06072000FONT face=3DArial =
size=3D2SPAN=20
class=3D580184615-06072000FONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000PageName.cfm =3D=20
1/SPAN/FONT/SPAN/FONT/SPAN/FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000FONT =
face=3DArial=20
size=3D2SPAN class=3D580184615-06072000FONT face=3DArial =
size=3D2SPAN=20
class=3D580184615-06072000FONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000/SPAN/FONT/SPAN/FONT/SPAN/FONT/SP=
AN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000FONT =
face=3DArial=20
size=3D2SPAN class=3D580184615-06072000FONT face=3DArial =
size=3D2SPAN=20
class=3D580184615-06072000FONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000Are Arrays the only way to use a 'sort'=20
function?/SPAN/FONT/SPAN/FONT/SPAN/FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D580184615-06072000FONT =
face=3DArial=20
size=3D2SPAN class=3D580184615-06072000FONT face=3DArial =
size=3D2SPAN=20
class=3D580184615-06072000FONT face=3DArial size=3D2SPAN=20
class=3D580184615-06072000Please feel free to provide ANY input,=20
thanks!/SPAN/FONT/SPAN/FONT/SPAN/FONT/SPAN/FONT/DIV/BO=
DY/HTML

--=_NextPart_000__01BFE740.65E0--

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

Getting the ID after insert...

[Gary McNeel, Jr.]

Hello all. Hope any of you celebrating 4th of July had a good one.

I have a question about the code below. This was done by a colleague of
mine, he is pretty handy with SQL coding. One of his observations was the
time involved in writing stored procedures and then calling them with
CFSTORPROC. I agree, that discouraged me somewhat in the past, but I knew of
no other way. He put this transact-sql query together and it seems solid,
works well.

My question(s): Have any of you tried this? Any problems? Can anyone see a
potential problem?

Thanks. -Gary McNeel

CFQUERY name="InsertLkpRec" datasource="#Application.DSN#"
DECLARE @LookupID char(6)
DECLARE @MembersID char(6)
!--- Insert Member Lookup Record ---
INSERT INTO tblMemberLkp
(DBAName, ReferredBy )
VALUES
('#Form.DBAName#', '#Form.ReferredBy#')

SELECT @LookupID = @@IDENTITY

! Members Record ---
INSERT INTO Members
(MemberLkpID)
VALUES
(@LookupID)

SELECT @MembersID = @@IDENTITY

!--- Insert Site Info record ---
INSERT INTO tblSiteInfo
(BusName, Website, RecStatusID, RecOriginID, MembersID,
PartnerNumber, SourceID, ApplicationDate)
VALUES
('#Form.BusName#', '#Lcase(Form.Website)#', 2, 1, @MembersID,
'#Form.PartnerNumber#', '#Form.SourceID#', getdate())
/CFQUERY


Gary McNeel, Jr.
Project Manager - DAC-Net, Research  Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

Re: How the heck can I do this?

[Jennifer]

At 08:19 AM 7/6/00 -0400, you wrote:
I'm setting up a real simple auction application. Super simple. People

submit bids via a form, then the top 5 bids are displayed on a page. The

catch is, I only want the 5th highest bid to show the actual bid.

So, I can order the query by bid descending and for output bids 1 through 5

will give the bidders name, but I need to have the bid amounts hidden for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output. Is there

a way to control all this stuff with the SQL, or do I have a basic query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

Ok, in your output, use cfloop instead of cfoutput. Loop through the query 
and use a counter in the loop (if you need more info on this, let me know, 
but it's pretty basic, so I'll assume you can figure it out). When the 
counter is 5, you will change the information that is sent to the browser. 
So you'd do something like this (I don't guarantee the code because I'm not 
testing it):

cfset i=1
cfloop query="yourqueryname"
 cfif i LT 5
 #bidder##biddercontact#
 cfelse
 #bidder##biddercontact# #bid#
 /cfif
/cfloop
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: How the heck can I do this?

[Todd Ashworth]

Couldn't you just do something like check the value of
queryname.recordcount, or, instead of cfoutput query=, loop through the
query and check for when the index hits 5?

Todd Ashworth

- Original Message -
From: "Jeff Fongemie" [EMAIL PROTECTED]
Newsgroups: cf-talk
To: [EMAIL PROTECTED]
Sent: Thursday, July 06, 2000 11:38 AM
Subject: Re: How the heck can I do this?


| As it stands, the output will show all bids. I need it to show a place
| holder
|
| for the first top 4 bids like  and show the 5th highest bid. The idea
is
|
| that the bidders can't see the top 4 bids.
|
| Jeff Fongemie
|
|
|
|
|
| CFQUERY NAME="getbids" DATASOURCE="hclimb"
|
| SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,
|
| BidDate, Alias
|
| FROM bids
|
| ORDER BY bidAmount desc/CFQUERY
|
|
|
| !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
|
| html
|
| head
|
| titleBids Are.../title
|
| /head
|
| body
|
| TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"
|
| THAlias/TH THAmt. Bid/TH THBid Date/TH
|
| CFOUTPUT QUERY="getbids" maxrows=5
|
| TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#
|
| TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD
|
| /TR
|
| /CFOUTPUT
|
| /TABLE
|
| /body
|
| /html


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

Re: How the heck can I do this?

[Laure Lunot]

Why don't you put a CFIF... in the output ?

TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"

THAlias/TH THAmt. Bid/TH THBid Date/TH
CFOUTPUT QUERY="getbids" maxrows=5
 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#
 TD#Alias#/TD TDCFIF CurrentRow eq
5#BidAmount#CFELSE$/CFIF/TD TD#BidDate#/TD
 /TR
 /CFOUTPUT
/TABLE

Laure

- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
Newsgroups: cf-talk
To: [EMAIL PROTECTED]
Sent: Thursday, July 06, 2000 5:38 PM
Subject: Re: How the heck can I do this?


 As it stands, the output will show all bids. I need it to show a place
 holder

 for the first top 4 bids like  and show the 5th highest bid. The idea
is

 that the bidders can't see the top 4 bids.

 Jeff Fongemie





 CFQUERY NAME="getbids" DATASOURCE="hclimb"

 SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,

 BidDate, Alias

 FROM bids

 ORDER BY bidAmount desc/CFQUERY



 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

 html

 head

 titleBids Are.../title

 /head

 body

 TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"

 THAlias/TH THAmt. Bid/TH THBid Date/TH

 CFOUTPUT QUERY="getbids" maxrows=5

 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#

 TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD

 /TR

 /CFOUTPUT

 /TABLE

 /body

 /html






 "Steve DeWitt" [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  can you post the code?
 
  -Original Message-
  From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, July 06, 2000 5:19 AM
  To: [EMAIL PROTECTED]
  Subject: How the heck can I do this?
 
 
  I'm setting up a real simple auction application. Super simple. People
 
  submit bids via a form, then the top 5 bids are displayed on a page. The
 
  catch is, I only want the 5th highest bid to show the actual bid.
 
  So, I can order the query by bid descending and for output bids 1
through
 5
 
  will give the bidders name, but I need to have the bid amounts hidden
for
 
  the top 4 bids, and show the 5th.
 
  To display only the top 5 bids, I'm using maxrows =5 in my output. Is
 there
 
  a way to control all this stuff with the SQL, or do I have a basic
query,
 
  order by bid desc. and control the results through output?
 
  With the output method, I can't seem to be able to get the results to
 
  populate the 5th bid amt., but not the first 4.
 
  Thanks,
 
  Jeff Fongemie
 
 
 

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

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


 --

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

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

RE: How the heck can I do this?

[Mark Warrick]

Use conditional logic to display only the 5th record or better yet, output only the 
5th record by using the startrow attribute in your CFOUTPUT QUERY statement.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 8:39 AM
 To: [EMAIL PROTECTED]
 Subject: Re: How the heck can I do this?
 
 
 As it stands, the output will show all bids. I need it to show a place
 holder
 
 for the first top 4 bids like  and show the 5th highest bid. 
 The idea is
 
 that the bidders can't see the top 4 bids.
 
 Jeff Fongemie
 
 
 
 
 
 CFQUERY NAME="getbids" DATASOURCE="hclimb"
 
 SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,
 
 BidDate, Alias
 
 FROM bids
 
 ORDER BY bidAmount desc/CFQUERY
 
 
 
 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
 
 html
 
 head
 
 titleBids Are.../title
 
 /head
 
 body
 
 TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0"
 
 THAlias/TH THAmt. Bid/TH THBid Date/TH
 
 CFOUTPUT QUERY="getbids" maxrows=5
 
 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))#
 
 TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD
 
 /TR
 
 /CFOUTPUT
 
 /TABLE
 
 /body
 
 /html
 
 
 
 
 
 
 "Steve DeWitt" [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  can you post the code?
 
  -Original Message-
  From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, July 06, 2000 5:19 AM
  To: [EMAIL PROTECTED]
  Subject: How the heck can I do this?
 
 
  I'm setting up a real simple auction application. Super simple. People
 
  submit bids via a form, then the top 5 bids are displayed on a page. The
 
  catch is, I only want the 5th highest bid to show the actual bid.
 
  So, I can order the query by bid descending and for output bids 
 1 through
 5
 
  will give the bidders name, but I need to have the bid amounts 
 hidden for
 
  the top 4 bids, and show the 5th.
 
  To display only the top 5 bids, I'm using maxrows =5 in my output. Is
 there
 
  a way to control all this stuff with the SQL, or do I have a 
 basic query,
 
  order by bid desc. and control the results through output?
 
  With the output method, I can't seem to be able to get the results to
 
  populate the 5th bid amt., but not the first 4.
 
  Thanks,
 
  Jeff Fongemie
 
 
 
  
 --
 --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
  
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
  send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in
  the body.
  
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.

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

RE: Oracle BLOB and CF

[Steve Runyon]

Sorry for the late post, but based on my experience with Oracle 7.x
and VB5 (yeah, okay, not exactly parallel...), you have to write out
the BLOB to a temporary file (using GETCHUNK() if these are big
images), then link to that file in your template.

How you do your garbage collection will be up to you, based on your
requirements.

Hope this helps!


-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 29, 2000 5:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Oracle BLOB and CF


Thanks again for the responses.
I figured it would get to be a little involved.

I created a CFQuery that only returns data of type CHAR or NUMBER.
I'm using the Oracle Native Drivers to access an Oracle8i database.
The BLOB field is called "jpeg".
Here is the query I wrote and it responds fine.

cfquery name="image" datasource="design_cf" dbtype="Oracle80" timeout="20"
SELECT  image_id,  DBMS_LOB.GETLENGTH(jpeg) AS jpeg_length
FROM  design.image
/cfquery

*Note:  The DBMS_LOB.GETLENGTH(jpeg) is a function in Oracle that will
return the number of bytes that the BLOB contains.  The return value is of
type NUMBER.

When I try to actually SELECT the content of the BLOB field I get an error.
Here is the query that selects the contents of the BLOB field.
In this case the BLOB field is call "jpeg".

cfquery name="image" datasource="design_cf" dbtype="Oracle80" timeout="20"
SELECT image_id,  DBMS_LOB.GETLENGTH(jpeg) AS jpeg_length,  jpeg
FROM  design.image
/cfquery

And here is the error that I get:
Oracle Error Code = 932
ORA-00932: inconsistent datatypes
SQL = "SELECT image_id, DBMS_LOB.GETLENGTH(jpeg) AS jpeg_length, jpeg FROM
design.image"


I believe that since the contents stored in the BLOB are not of type CHAR or
NUMBER, the native driver is having a problem returning the content stored
in the BLOB back to the
ColdFusion Application Server, or something like that.  I believe I'm going
to have to somehow fool CF into thinking that the data being returned is of
Type CHAR or NUMBER.  If I do
it this way, the data may become corrupted.

Any ideas on how to get the data into a CF Variables so that I can write it
to disk?

Thanks,
Troy

Dave Watts wrote:

  I may be wrong, but I think that images are stored as binary
  data in a BLOB. The article applies to binary data (at least
  it seems to claim this in the first and second paragraphs)
  regardless of its nature. It does refer to long character text
  over and over, but I think it applies anyway. Try searching the
  knowledge base for more articles on the "long text" setting.

 It mentions character text for a reason. Non-text binary data is
represented
 using symbols other than ASCII characters, and CF can't handle those
 symbols. There's no easy way to work with binary data within CF,
 unfortunately, and you can't simply retrieve the binary data and push it
 directly to the browser. CF 4.5.x does provide some functions for working
 with binary data, but no way to output that binary data. You can work with
 binary data using a couple of workarounds, though; I suspect you may be
able
 to retrieve it and write it to a file, then use CFCONTENT to retrieve the
 file and push that to the browser.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444

 --

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

--
Troy Simpson | North Carolina State University
NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330



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

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

UPS Online Tools

[Chris Michl]

For those of you who need to know...
==
Dear UPS OnLine(r) Tools Registrant:

UPS is continuing to develop its family of UPS OnLine Tools in ways that
allow you
to maximize your e-commerce strategies.

With this in mind, we have updated our Rates and Service Selection tool. As
of
September 30, 2000, the UPS Internet ToolsTM Quick Cost Calculator,
datastream
version 1999a or earlier, will be discontinued. You can find out if you are
using this
version by viewing your request message.  If you are accessing the tool at
www.ups.com/using/services/rave/qcostcgi.cgi, you should upgrade by the
September 30, 2000 deadline.  In addition, if you have developed solutions
utilizing
this version of Quick Cost Calculator for customers, please consider
notifying them
of this change.

Anyone using this Quick Cost Calculator tool will need to upgrade to the new
Rates
and Service Selection tool. You can do this by simply registering for the
HTML or
datastreaming version of UPS OnLine Tools Rates and Service Selection by
going to
"Get Tools" at www.ec.ups.com. This newer tool allows online shoppers to
compare,
price and select shipping services that best fit their needs and budgets.
Plus, it gives
you access to the most current UPS rates.

If you have questions or need more information, contact us by clicking
"Customer
Support" at www.ec.ups.com.

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

Re: More than one Submit button

[Brandon Whitaker]

Can this be done in Javascript? Or is it better to use
CFFORM/CFFORM tag? if so, can someone please help
me in figuring out how to do it?

JavaScript would work.  I believe that instead of a submit button, you'd
want to use something along the lines of the following:

input type='button' onClick='mySubmitFunction(myFuseAction)'

...where 'mySubmitFunction' is a script which submits the form, using
'myFuseAction' as the variable which calls a particular fuseAction.

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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

RE: still not working

[Mark Warrick]

Gregg,

As others have pointed out, you're missing some commas and you've got an extra comma.

The best way to test queries is to do it directly in the database itself.  If you're 
using Access, use the query builder within Access to create and test queries.  If it's 
Microsoft's SQL, use iSQL/w.

Then copy and paste the queries over to a CFQUERY and make sure that there's no end of 
statement ";".

By doing this, you'll be able to isolate your SQL coding errors from your CF coding 
errors. Your life will become suddenly more peaceful.  ;)

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: gregg Kachel [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 8:18 AM
 To: [EMAIL PROTECTED]
 Subject: still not working
 
 
 Hi, thanks for all of your help. I'm still struggling with the connecting
 the two tables. I did as Mark suggested and checked for required 
 fields, the
 only one I have is the primary keys wich are autonumbered (memberid for
 memberlist, id for members) I linked the tables together with memberID but
 that doesn't seem to help.  Also as Nick suggested I took out the ''s from
 my number fields, and put the inserts in correct order. So far 
 this is what
 i have:
 cfquery
 Datasource="vhc"
 
 insert into memberlist(firstname,lastname, boat, boatyear, address, city,
 phone, state, zip, emailaddress, )
 values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
 '#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
 /cfquery
 
 cfquery
 Datasource="vhc"
 insert into members(firstname,lastname, username, password, emailaddress)
 values( '#firstname#', '#lastname#', '#username#', '#password#',
 '#emailaddress#')
 /cfquery
 
 The error is:
 ODBC Error Code = 37000 (Syntax error or access violation)
 
 
 [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
 statement.
 
 
 
 The error occurred while processing an element with a general 
 identifier of
 (CFQUERY), occupying document position (2:1) to (3:17).
 
 
 Date/Time: 07/06/00 09:26:49
 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
 Remote Address: 192.168.0.55
 HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
 Template: D:\Inetpub\wwwroot\CFDOCS\a
 Web\houseboat\admin\vhc\newaddprofile2.cfm
 
 Thanks again, I'm getting very frustrating, I know this should be fairly
 easy and straight forward.
 
 Gregg
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.

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

custom tag for calculating business hours

[Tom Dyson]

I'm struggling to write a tag that will give me the number of business hours
between two specified date/time fields. What I want is something like this:

cf_businesshours   bh_start = #starttime#   bh_end = #endtime# 

which will give me the total hours, not including weekends, bank holidays
(which are supplied as a list variable #application.holidays#) and non-work
hours (e.g. 6pm to 9am - again supplied as application variables #workstart#
and #workfinish#). 

e.g. if #starttime# was friday june 10th 15.00 and #endtime# was monday june
13th 10.00 #businesshours# would be 4.

The tag is for an extranet application where we need to check whether or not
users have performed a specific task within x working hours of accepting it.
In most cases it will run as a scheduled query and bh_end will equal
#now()#.

I can work it on in terms of days (using the DateDiff function) but it's
tricky to find out which hours fall on which days. Has anyone written
something like this? Or do you have any suggestions on how I should go about
it?

Please copy any responses me as well as to the list (I'm subscribed to the
archived version).

Thanks very much

Tom

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

RE: How the heck can I do this?

[joeug]

Jeff,
 I think you are actually bringing down the entire
 record set by specifying Maxrows="5"
  
 If you are using Sql Server use

 Select Top 5 Bid_Price, Bidder_Name, Bidder_Address ..
 from Auction_Bid_Table

 This will only bring down the record set, you need.

 If you only want to show the 5th max bidder price,
 
 In your cfoutput, use a count variable and display the
 the 5th only when the var is 5

 cfset x="0"
 cfoutput query="Get_5maxBidder"
 cfset x=x+1
 #name#
 cfif x eq "5"#5thMaxBidder#/cfif
 /cfoutput

hope this helps


Joe









 




--- Original Message ---
"Jeff Fongemie" [EMAIL PROTECTED] Wrote on 
Thu, 6 Jul 2000 08:19:11 -0400
 -- 
I'm setting up a real simple auction application. Super simple.
People

submit bids via a form, then the top 5 bids are displayed on
a page. The

catch is, I only want the 5th highest bid to show the actual
bid.

So, I can order the query by bid descending and for output bids
1 through 5

will give the bidders name, but I need to have the bid amounts
hidden for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output.
Is there

a way to control all this stuff with the SQL, or do I have a
basic query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results
to

populate the 5th bid amt., but not the first 4.

Thanks,

Jeff Fongemie



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



-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

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

RE: Application.cfm location costs?

[Mark Warrick]

Paul,

Try it and you'll find out.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: paul smith [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 6:37 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Application.cfm location costs?
 
 
 Why is this?
 
 best,  paul
 
 At 05:46 PM 7/5/00 -0700, you wrote:
 Perhaps it's because complex directory structures with extensive 
 sub-directories are inherently BAD application design.
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.

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

RE: More than one Submit button

[Mark W. Breneman]

Ok, here is an answer to the multiple submit buttons.

You can see if the XY coordinates exists.  I just check for X.

Submit button one submit
Submit button two recal

cfif ParameterExists(form.recal.x)/cfif
cfif ParameterExists(form.submit.x)/cfif

As for the Required fields...  Yes, CFform will sorta work.  It will pop up
a box for each of the required fields that are blank.  I saw a CFX tag that
does just what I think you are asking for in the tag gallery.  FYI both the
CFX tag and the CFform uses JavaScript to require fields.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 10:40 AM
To: [EMAIL PROTECTED]
Subject: More than one Submit button


This is a long question. Please be patient with the
question.

I have a form which has to have more than one submit
button.

But, each submit button will have to have a different
fuseaction.

Also, for one of the submit buttons, a message box
should appear if the user has not selected something
from the drop down menu.

Can this be done in Javascript? Or is it better to use
CFFORM/CFFORM tag? if so, can someone please help
me in figuring out how to do it?

Appreciate.
A.B.

__
Do You Yahoo!?
Send instant messages  get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

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

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

RE: Compiling CFX Tags

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

 We have gnu 2.9 installed - I'll see if I can get that to work.

Just out of curiousity, why are you using the Sun compiler at all?

My boss' fiance worked for Sun, and she got us a couple of old Sparcs
to play with.  I asked her if she could get the compiler package for
us, and her response was, "Why?  Just user GNU.  It's better
anyways."  That said by one of Sun's marketing people

Is there some other reason for using Sun over GNU compilers?

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com
Comment: Please use PGP!!!

iQA/AwUBOWSyrQraVoMWBwRBEQIOQwCfXIps78g1NXVCi+5Hl7DADIXVoTMAmwa+
2eQiIsM1txsOGQYHdrl5UhV/
=kH4e
-END PGP SIGNATURE-
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: still not working

[Randy Adkins]

Actually you have an EXTRA comma in yout INSERT line:
You have an extra comma after the emailaddress and before the ).


insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )

Should be:
insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress )


- Original Message -
From: "gregg Kachel" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 06, 2000 11:18 AM
Subject: still not working


: Hi, thanks for all of your help. I'm still struggling with the connecting
: the two tables. I did as Mark suggested and checked for required fields,
the
: only one I have is the primary keys wich are autonumbered (memberid for
: memberlist, id for members) I linked the tables together with memberID but
: that doesn't seem to help.  Also as Nick suggested I took out the ''s from
: my number fields, and put the inserts in correct order. So far this is
what
: i have:
: cfquery
: Datasource="vhc"
:
: insert into memberlist(firstname,lastname, boat, boatyear, address, city,
: phone, state, zip, emailaddress, )
: values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
: '#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
: /cfquery
:
: cfquery
: Datasource="vhc"
: insert into members(firstname,lastname, username, password, emailaddress)
: values( '#firstname#', '#lastname#', '#username#', '#password#',
: '#emailaddress#')
: /cfquery
:
: The error is:
: ODBC Error Code = 37000 (Syntax error or access violation)
:
:
: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
: statement.
:
:
:
: The error occurred while processing an element with a general identifier
of
: (CFQUERY), occupying document position (2:1) to (3:17).
:
:
: Date/Time: 07/06/00 09:26:49
: Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
: Remote Address: 192.168.0.55
: HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
: Template: D:\Inetpub\wwwroot\CFDOCS\a
: Web\houseboat\admin\vhc\newaddprofile2.cfm
:
: Thanks again, I'm getting very frustrating, I know this should be fairly
: easy and straight forward.
:
: Gregg
:
: --

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

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

Re: line break as delimiter

[Brandon Whitaker]

Hi
im trying to run a list loop from a file that uses separate lines for the
items.
i would like to use a line break as a delimiter
anyone have any ideas??
*
select name="screen_names"
 cfloop index="i" list="#IM_list#" delimiters=" "
  option value="1" SELECTED#i#/option
 /cfloop
/select
*
Thanks
-Eli-

You could turn it into an array...
  cfSet resultArray = listToArray(IM_list,chr(10))

select name="screen_names"
   cfloop from="1" to="#arrayLen(resultArray)# index="i"
  option value="1" SELECTED#resultArray[i]#/option
   /cfloop
/select

I notice that you also have the same value (1) being input for all of your
options, you might want to re-think that. :)

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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

RE: UPS Online Tools

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

So if I understand this correctly, Ben Forta's tag (CF_UPSPrice) is
offically dead as of Sept. 30 (pending a rewrite), but Ken
McCafferty's tag (CF_UPSShipRate) should still be alive  well.  Can
anyone else confirm or deny that understanding?

(Thanks UPS!)

Best regards,
Zac Bedell

 -Original Message-
 From: Chris Michl [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 11:27 AM
 To: [EMAIL PROTECTED]
 Subject: UPS Online Tools
 
 
 For those of you who need to know...
 ==
 Dear UPS OnLine(r) Tools Registrant:

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com
Comment: Please use PGP!!!

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

REPOST: Submitting a page with a cftree

[Michael O Reilly]

Hi,
I'm re-posting this as it seem's to have slipped by everyone.

I've been struggling with a problem for some time now and have figured out a
way of solving it using HTTP_REFERER.
However this CGI var is only sent when a page is "Submitted".
Even though a CFTree must be within a CFForm, double-clicking on a
CFTreeItem doesn't seem to cause the page to be submitted.
Has anyone noticed/found a way round this?

Regards
Michael O'Reilly
TransAer

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

Re: [How the heck can I do this?]

[double-down]

try max rows 1. if that doesnt work try cfloop instead of cfoutput and then
put in a cfbreak. 
i am sure there is a better way though.

"Jeff Fongemie" [EMAIL PROTECTED] wrote:
I'm setting up a real simple auction application. Super simple. People

submit bids via a form, then the top 5 bids are displayed on a page. The

catch is, I only want the 5th highest bid to show the actual bid.

So, I can order the query by bid descending and for output bids 1 through 5

will give the bidders name, but I need to have the bid amounts hidden for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output. Is there

a way to control all this stuff with the SQL, or do I have a basic query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

Thanks,

Jeff Fongemie



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



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

Rounding of numbers

[Stewart McGowan]

Sorry for the noddy nature of the question but its 5.30 i've had a tooth out
today and i'm getting no sympathy :)

how do i round a number i've got as a result of a piece of arithmatic?
Thanks as always

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

RE: a very specifc query...

[miles]

Bret,

BINGO!

SELECT  nxstar_e.*
,nxsprodr.prod_desc
,(SELECT Count (id)
  FROM  nxsnotes
  WHERE nxsnotes.id = nxstar_e.tar_num) AS Activities
,nxsteche.tech_name
FROMnxstar_e
,nxsprodr
,nxsteche
WHERE   nxsprodr.prod_code = nxstar_e.prod_id
AND cust_code = #Cookie.User_ID#
AND nxstar_e.entered_by *= nxsteche.tech_code  /** new line **/
ORDER BY nxstar_e.tar_num desc

Thanks!

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

cfregistry and basic security

[jamesa {James Alexander}]

In CF4.51 administrator, one can disable tags such as CFREGISTRY for
security purposes.  There is also a setting for "unsecured tags directory"
where these imposed tag restrictions should not apply.  Why then can I not
run scheduled tasks when CFREGISTRY is disabled.  From its behavior, it
would seem that the "unsecured tags directory" is not recursive.  I see
mention of this issue in the support forums, but no explanation or
resolution.  Does anyone know why this must be, or if there is some
workaround?  
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

line break as delimiter

[Eli Shechter]

Hi
im trying to run a list loop from a file that uses separate lines for the
items.
i would like to use a line break as a delimiter
anyone have any ideas??
*
select name="screen_names"
 cfloop index="i" list="#IM_list#" delimiters=" "
  option value="1" SELECTED#i#/option
 /cfloop
/select
*
Thanks
-Eli-


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

OT: ODBC Strange Problem

[Olson, Kelly]

Help Anyone!!

Anyone seen this, that can give me a little info.  This is comming out
of a 2 field table AccountID and AccountDescription. It works great up
to 5 records and on the 6 record or above it generates the error above.

It is basically a list of choices that are selected and a record inputed
into a second table.  Nothing special and it works great as long as I
only have 5 records in the selecting table.  There is no validation.  I
have tried deleting the table and recreating it with the same problem.





Error Diagnostic Information

 ODBC Error Code = 22003 (Numeric value out of range)

 [Microsoft][ODBC Microsoft Access 97 Driver]Numeric value out of range

 The error occurred while processing an element with a general
identifier of (CFINSERT), occupying document position (3:2) to (3:61).

 Date/Time: 07/06/00 13:19:51
 Browser: Mozilla/4.73 [en] (Windows NT 5.0; U)
 Remote Address: 63.238.222.92
 HTTP Referer:
http://www.mfglinks.org/scenarios/scenario/create_scenario5.cfm
 Template:
D:\webclients\mfglinks.org\scenarios\scenario\create_scenario5.cfm

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

Re: More than one Submit button

[Jennifer]

At 08:40 AM 7/6/00 -0700, you wrote:
This is a long question. Please be patient with the
question.

I have a form which has to have more than one submit
button.

But, each submit button will have to have a different
fuseaction.

Also, for one of the submit buttons, a message box
should appear if the user has not selected something
from the drop down menu.

Can this be done in Javascript? Or is it better to use
CFFORM/CFFORM tag? if so, can someone please help
me in figuring out how to do it?

Since you are using fusebox, this should be pretty easy to handle. Name the 
submit buttons and make sure that the submit button name is passed to the 
next page. Test for the names of the submit buttons and select a fuseaction 
on the target page depending on the name of the submit button. I think this 
works. I could be wrong about the submit button naming, but I think it 
works. In any case, what you should try to do is select the fuseaction on 
the target page depending on some information from the form. House of 
Fusion also has a fusebox list, so they can help you with fusebox 
methodology like this. They may know of some really good ways to do this.

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

RE: wddx problem

[Matt Rodosky]

Thanks Jennifer, Chris  Steve:

It looks like Chris' experience is right on. The code is fine, it seems that
every once and a while moreover.com's feed generates a goofy wddx packet.
Jennifer, could you give an example of how you use char code=?? to clean
up files?? Moreover.com is at a loss to figure out what they can do to
prevent this, maybe its a simple fix from their end using your example...

Thanks,
Matt

-Original Message-
From: Jennifer A. Caulfield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 9:21 AM
To: [EMAIL PROTECTED]
Subject: RE: wddx problem


I don't know if this would be the reason, but I got a similar error when my
pages included accented characters. I had to convert them using char
code=?? before making the recordset.

Jennifer

-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:28 AM
To: [EMAIL PROTECTED]
Subject: wddx problem


I've been using wddx to process backend pages from moreover.com, which has
been working great. Today I am getting this message:

XML parsing error: not well-formed (error code 4, line 70, column 16, buffer
offset 4196)
The error occurred while processing an element with a general identifier of
(CFWDDX), occupying document position (5:1) to (5:87) in the template file
d:\http\4pines\index.cfm

How do I figure out what is wrong?

TIA
Matt


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


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

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

Slightly OT:Single Server vs. Cluster Comparison

[Gregory Harris]

Hello everyone, right now I've been assigned to do a comparison of a single server vs. 
a multiple server configuration, this is what I've thought of so far, can anyone help 
further?  Need a few more brainstorms.

Single:

Advantages:

 Easier maintenance
 Simpler setup
 Cheaper

Disadvantages:

 Less reliable (no fail-over)
 Slower

Multiple Server:

 Advantages:

 Faster throughput
 Fail-over reliability

Disadvantages:

 More complicated setup
 Harder to maintain



Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]

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

RE: custom tag for calculating business hours

[Dan Haley]

We do something similar for calculating ship date based on shipping method
and customer required date.  Time enters in because 2:00 PM is our cut-off
time for orders to ship the same day.

What you will want to do is loop through the days involved from start_date
to end_date.  Check each day to decide if it is a weekend or holiday, which
you can discard.  For all other days, check if they are the start or the end
date . . . if not they consist of a full work day . . . if they are, then
you only need to work with the time component.

Dan

-Original Message-
From: Tom Dyson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 3:44 AM
To: [EMAIL PROTECTED]
Subject: custom tag for calculating business hours



I'm struggling to write a tag that will give me the number of business hours
between two specified date/time fields. What I want is something like this:

cf_businesshours   bh_start = #starttime#   bh_end = #endtime# 

which will give me the total hours, not including weekends, bank holidays
(which are supplied as a list variable #application.holidays#) and non-work
hours (e.g. 6pm to 9am - again supplied as application variables #workstart#
and #workfinish#). 

e.g. if #starttime# was friday june 10th 15.00 and #endtime# was monday june
13th 10.00 #businesshours# would be 4.

The tag is for an extranet application where we need to check whether or not
users have performed a specific task within x working hours of accepting it.
In most cases it will run as a scheduled query and bh_end will equal
#now()#.

I can work it on in terms of days (using the DateDiff function) but it's
tricky to find out which hours fall on which days. Has anyone written
something like this? Or do you have any suggestions on how I should go about
it?

Please copy any responses me as well as to the list (I'm subscribed to the
archived version).

Thanks very much

Tom


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

Re: When should I use CFLOCK?

[Gregory Harris]

Does anyone have any
guidelines on cflock usage?


You should use CFLOCK when you are setting session variables to insure that you 
maintain consistency throughout your code.  Reading however, is not a problem.  

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

Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]

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

OT:DNS

[Michael Lubrano]

I need a program (Or write a program)that creates Subdomians on the fly.
(Like http://www.intranets.com) I have NT (IIS) and Linux running DNS. Any
ideas how to do this on the fly like the above example?

Thx,

Michael

--
Michael Lubrano

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

Re: OT: Digital Camera

[Marlene Buffa]

I own a Sony FD88, a bit beyond your budget of $675, but 
check for price reductions.

I prefer the Sony brand because it uses the standard floppy 
disk instead of a card. I bring 20-30 disks with me on vacation and 
if I run out, they are very cheap to buy. (at this resolution, I can 
usually fit 8-9 shots per floppy)

no software to install, no downloading, no card-hookup. I just 
put in the floppy and fire up Corel Photo Paint and I'm ready to edit 
my pics.

The FD88 has a 16x zoom lens, with 1.3 meg pixel resolution.
It also has the capability of doing a short (1-2 minute) video 
with sound.

I paid $800 for it a few months ago and since then, the prices 
have come down considerably.

A long-life battery (170 minutes) will run you another $100, but 
if you can live without it,  the standard battery included does come 
with a recharger.
Marlene
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

cf 4.5 cfmail problems

[James]

This is a multi-part message in MIME format.

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

I have an email being sent out with cfmail on a coldfusion 4.5 server. =
The content is being pulled from a database. The copy in the database is =
perfect. However once the email is received by the user the copy has =
problems.

This is the copy as it sites in the database:=20
"security at the company since the."

The copy how it appears in the email:
"security at the compa! ny since the"

any ideas???

thanks
james



James Durr
Web Application Developer
Carton Donofrio Interactive
www.cdinteractive.com
120 West Fayette Street
Baltimore, MD  21201
410-576-9000, ext. 287
[EMAIL PROTECTED]

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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT size=3D2I have an email being sent out with cfmail on a =
coldfusion 4.5=20
server./FONTFONT size=3D2 The content is being pulled from a =
database. The=20
copy in the database is perfect./FONTFONT size=3D2 However once the =
email is=20
received by the user the copy has problems./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2This is the copy as it sites in the database: =
/FONT/DIV
DIVFONT size=3D2"security at the company since =
the."/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2The copy how it appears in the email:/FONT/DIV
DIVFONT size=3D2"security at the compa! ny since =
the"/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2any ideas???/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2thanks/FONT/DIV
DIVFONT size=3D2james/FONT/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV
DIVFONT size=3D2BRJames DurrBRWeb Application =
DeveloperBRCarton Donofrio=20
InteractiveBRA=20
href=3D"http://www.cdinteractive.com"www.cdinteractive.com/ABR120 =
West=20
Fayette StreetBRBaltimore, MDnbsp; 21201BR410-576-9000, ext. =
287BRA=20
href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT=
/DIV/BODY/HTML

--=_NextPart_000_0168_01BFE750.AD81D430--

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

RE: line break as delimiter

[Top-Link Tech (John Ceci)]

try this:

cfloop index="i" list="#IM_list#" delimiters="#Chr(13)##Chr(10)#"

I think that should do it...

John

-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 10:31 AM
To: [EMAIL PROTECTED]
Subject: line break as delimiter


Hi
im trying to run a list loop from a file that uses separate lines for the
items.
i would like to use a line break as a delimiter
anyone have any ideas??
*
select name="screen_names"
 cfloop index="i" list="#IM_list#" delimiters=" "
  option value="1" SELECTED#i#/option
 /cfloop
/select
*
Thanks
-Eli-


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

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

sssssssssssssssssssssssssssssssssssssssssssssssssssssss

[jonathan hamner]

I have a text field which can have upto 255
characters. Is there a way to loop in such a way that
if the name string is 70 characters, then the first
line should have 30 characters, then second line30,
then third line 10?

Can we assign a statement such as:
cfset blah = #Len(form.name)#

and then use this in the loop?

Please view my previous email (with the answer I got
from the list).

Thank You.

From: "Roberts, Jesse D"
[EMAIL PROTECTED]  | Block address 
To: "'[EMAIL PROTECTED]'"
[EMAIL PROTECTED] 
Subject: RE: shorter lines 
Date: Wed, 5 Jul 2000 15:57:59 -0700  
Reply-to: [EMAIL PROTECTED] 
Add Addresses  
 


Sure, use the Left, Mid, and Right functions.  You
should find info on 
them
in your documentation.

Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
[EMAIL PROTECTED]
Ph. 714-896-3462
Fx. 714-896-3303

 -Original Message-
 From: jonathan hamner
[SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 05, 2000 3:25 PM
 To:   [EMAIL PROTECTED]
 Subject:  shorter lines
 
 I have to print out a invoice. In that if the name
of
 the person is greater than 30 characters, the name
 goes over other peice of informations.
 
 Is there a way that instead of the name being
 displayed like:
 

sss
 
 be displayed like:
 ss
 ss
 ss
 
 
 Thank You.
 




__
Do You Yahoo!?
Send instant messages  get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF and Crystal Reports

[kraybill]

This may not be as sophisticated as you'd like, but the simplest way to generate bar
charts is to have your code generate a table where the background of each row has a
different BGCOLOR and the size of the "bar" on each row is controlled dynamically by
setting the WIDTH parameter of the TDs, using a percentage or a number. If you have 
any 
trouble with the sizing, you could plop a one-pixel graphic via an IMG SRC in each 
cell, 
and set the WIDTH or HEIGHT to stretch it to the required size for your bar

Gene Kraybill
LPW  Associates
Mansfield, PA

"Wong, Phoebe" [EMAIL PROTECTED] wrote:

 I'm looking for a way to generate bar charts on the fly, based on a PIN
 submitted by a User.
 
 Is there, for instance,  a way to pass a parameter from a ColdFusion
 template to Crystal Reports in order to generate bar charts on the fly? 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Using Select Tags in optional Form Submissions

[Troy M. Wussow]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFE747.107EE6B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is there a default value set for the Drop Down or are you using a CF =
PARAM
tag?

I'm new at this, but I thought I would ask.  I have had similar =
problems in
the past.

Troy:)

-Original Message-
From: Ang=E9l Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 7:01 AM
To: [EMAIL PROTECTED]
Subject: Using Select Tags in optional Form Submissions

Hello!

I have a form, with four text boxes and a select box that is pulling =
data
from a Department Table to get available departments and their =
Department
IDs.

Now, the user can eitehr enter an Employee Name, ID, or select a =
department.
However, on the next page I have several CFIF IsDefined tags to =
check
which field has a value in it, so that I know what to build the query =
on.

It's one or the other, they can't enter a Name, and an ID...AND a =
department
(wouldn't make sense to do that anyways heh heh).

But...for some reason the Department is always carried forward,even if =
the
user makes no selection.

I need to do this same thing on a couple other forms. Is it impossible =
to
use a Select box in this way?
Is a value ALWAYS sent when the user clicks submit, even if the user =
never
made a selection from the box?

I require a way around this, or some other way to simulate a combo box =
:-\
help help.
*waves arms frantically*

-Gel



=

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

--_=_NextPart_001_01BFE747.107EE6B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1"
META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12"
TITLERE: Using Select Tags in optional Form Submissions/TITLE
/HEAD
BODY

PFONT SIZE=3D2Is there a default value set for the Drop Down or are =
you using a CF PARAM tag?/FONT
/P

PFONT SIZE=3D2I'm new at this, but I thought I would ask.nbsp; I =
have had similar problems in the past./FONT
/P

PFONT SIZE=3D2Troy:)/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Ang=E9l Stewart [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT=

BRFONT SIZE=3D2Sent: Thursday, July 06, 2000 7:01 AM/FONT
BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT
BRFONT SIZE=3D2Subject: Using Select Tags in optional Form =
Submissions/FONT
/P

PFONT SIZE=3D2Hello!/FONT
/P

PFONT SIZE=3D2I have a form, with four text boxes and a select box =
that is pulling data/FONT
BRFONT SIZE=3D2from a Department Table to get available departments =
and their Department/FONT
BRFONT SIZE=3D2IDs./FONT
/P

PFONT SIZE=3D2Now, the user can eitehr enter an Employee Name, ID, =
or select a department./FONT
BRFONT SIZE=3D2However, on the next page I have several lt;CFIF =
IsDefinedgt; tags to check/FONT
BRFONT SIZE=3D2which field has a value in it, so that I know what =
to build the query on./FONT
/P

PFONT SIZE=3D2It's one or the other, they can't enter a Name, and =
an ID...AND a department/FONT
BRFONT SIZE=3D2(wouldn't make sense to do that anyways heh =
heh)./FONT
/P

PFONT SIZE=3D2But...for some reason the Department is always =
carried forward,even if the/FONT
BRFONT SIZE=3D2user makes no selection./FONT
/P

PFONT SIZE=3D2I need to do this same thing on a couple other forms. =
Is it impossible to/FONT
BRFONT SIZE=3D2use a Select box in this way?/FONT
BRFONT SIZE=3D2Is a value ALWAYS sent when the user clicks submit, =
even if the user never/FONT
BRFONT SIZE=3D2made a selection from the box?/FONT
/P

PFONT SIZE=3D2I require a way around this, or some other way to =
simulate a combo box :-\/FONT
BRFONT SIZE=3D2help help./FONT
BRFONT SIZE=3D2*waves arms frantically*/FONT
/P

PFONT SIZE=3D2-Gel/FONT
/P
BR
BR

PFONT =
SIZE=3D2---=
---/FONT
BRFONT SIZE=3D2Archives: A =
HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/=
/A/FONT
BRFONT SIZE=3D2To Unsubscribe visit A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli=
sts/cf_talk" =
TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
body=3Dlists/cf_talk/A or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body./FONT/P

/BODY
/HTML
--_=_NextPart_001_01BFE747.107EE6B0--

Re: cfparam depreciated?

[Jeff Davis]

Scott,

I believe you've correctly identified someone's typo (depreciated) and asked
a good question...
Perhaps similar to "depreciated", a financial term generally meaning "to
lower the valuation to account for aging, wear and tear, etc.", "deprecated"
means "retained for backwards compatability, but not to be used in new
code".

In the case of the term being discussed, a better replacement has been
provided.

Jeff Davis
Allaire Certified Trainer
Fig Leaf Software

Problems cannot be solved at the same
level of awareness that created them.
 -= Albert Einstein
__


Date: Sat, 29 Apr 2000 18:16:02 -0700
From: "Computer Simplistics Suppoer" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: cfparam depreciated?
Message-ID: 000f01bfb241$a67c5e10$[EMAIL PROTECTED]

Can someone explain the term "deprecated". I see it come up in Studio every
once in a while and I am guessing that it means the function I am using is
no longer in use, but what is the technical explanation of it?

Scott Berry

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

RE: Getting the ID after insert...

[Robert Everland]

Why not just do a trigger to get the last inserted record?

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 10:51 AM
To: Cf-Talk
Subject: Getting the ID after insert...


Hello all. Hope any of you celebrating 4th of July had a good one.

I have a question about the code below. This was done by a colleague of
mine, he is pretty handy with SQL coding. One of his observations was the
time involved in writing stored procedures and then calling them with
CFSTORPROC. I agree, that discouraged me somewhat in the past, but I knew of
no other way. He put this transact-sql query together and it seems solid,
works well.

My question(s): Have any of you tried this? Any problems? Can anyone see a
potential problem?

Thanks. -Gary McNeel

CFQUERY name="InsertLkpRec" datasource="#Application.DSN#"
DECLARE @LookupID char(6)
DECLARE @MembersID char(6)
!--- Insert Member Lookup Record ---
INSERT INTO tblMemberLkp
(DBAName, ReferredBy )
VALUES
('#Form.DBAName#', '#Form.ReferredBy#')

SELECT @LookupID = @@IDENTITY

! Members Record ---
INSERT INTO Members
(MemberLkpID)
VALUES
(@LookupID)

SELECT @MembersID = @@IDENTITY

!--- Insert Site Info record ---
INSERT INTO tblSiteInfo
(BusName, Website, RecStatusID, RecOriginID, MembersID,
PartnerNumber, SourceID, ApplicationDate)
VALUES
('#Form.BusName#', '#Lcase(Form.Website)#', 2, 1, @MembersID,
'#Form.PartnerNumber#', '#Form.SourceID#', getdate())
/CFQUERY


Gary McNeel, Jr.
Project Manager - DAC-Net, Research  Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein


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

cgi.remote_user

[Helge Hetland]

Apache / Solaris / CF Ent 4.51

Is there any ways to reset this variable with CF so that the user will have
to log on again to access resources under the protected dir?

(when remote_user doesn't exist I believe that any requests to the pages
under the security contexts is redirected to the loging page / popup?

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

Re: Compiling CFX Tags

[GE]

Hello Chrisopher,

This is *exactly* what happens to me !! (It also drops a core file in the 
/opt/coldfusion/ directory.

Please let me know anything new concerning this.

Thanks,
Nelson


"Conrad, Christopher" wrote:

 I know Allaire told me that I had to upgrade to Sun's 5.0 compiler when I
 went to 4.51.

 I just got 4.51 installed on our Solaris server here and I see something
 kind of crazy. I register a CFX, compile it with Sun's 4.2 compiler. When I
 hit the test template - I get a server error - it kills the server and
 REMOVES the CFX tag from the CF admin!

 Strange - I'm going to call our support person for this.

 We have gnu 2.9 installed - I'll see if I can get that to work.

 Chris

 Christopher Conrad
 Victoria's Secret Catalogue
 http://www.VictoriasSecret.com
 Senior.Programmer.Analyst
 614.337.5653
 [EMAIL PROTECTED]

  -Original Message-
  From: GE [SMTP:[EMAIL PROTECTED]]
  Sent: Wednesday, July 05, 2000 7:51 PM
  To:   cf-talk
  Subject:  Compiling CFX Tags
 
  Hello,
 
  Has anyone had any luck compiling CFX tags with CF Server 4.5.1 and the
  g++ compiler?
 
  thanks,
  Nelson
 
 
  --
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
  send a message to [EMAIL PROTECTED] with 'unsubscribe' in
  the body.
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

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

RE: line break as delimiter

[Chris Evans]

You'll need #CHR(10)# as your delimiter.

Why incur the extra overhead of converting the list to an array, and then
looping over the array?  Arrays are normally faster than lists, but the
extra overhead in converting  the list to an array negates any performance
gains.

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com



-Original Message-
From: Brandon Whitaker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:28 PM
To: [EMAIL PROTECTED]
Subject: Re: line break as delimiter


Hi
im trying to run a list loop from a file that uses separate lines for the
items.
i would like to use a line break as a delimiter
anyone have any ideas??
*
select name="screen_names"
 cfloop index="i" list="#IM_list#" delimiters=" "
  option value="1" SELECTED#i#/option
 /cfloop
/select
*
Thanks
-Eli-

You could turn it into an array...
  cfSet resultArray = listToArray(IM_list,chr(10))

select name="screen_names"
   cfloop from="1" to="#arrayLen(resultArray)# index="i"
  option value="1" SELECTED#resultArray[i]#/option
   /cfloop
/select

I notice that you also have the same value (1) being input for all of your
options, you might want to re-think that. :)

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore



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


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

Re: line break as delimiter

[Sharon DiOrio]

I have some code to separate out long selects into multiple selects with
the same ID, but I don't see where you're getting the ID from a list.
Also, your code would seem to output everything in the list with the value
of "1".  If you could give me an example of the list, I could probably help.

Sharon

At 11:30 AM 7/6/2000 -0400, Eli Shechter wrote:
Hi
im trying to run a list loop from a file that uses separate lines for the
items.
i would like to use a line break as a delimiter
anyone have any ideas??
*
select name="screen_names"
 cfloop index="i" list="#IM_list#" delimiters=" "
  option value="1" SELECTED#i#/option
 /cfloop
/select
*
Thanks
-Eli-

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

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

RE: wddx problem

[Chris Evans]

We have encountered a similar problem with WDDX packets, but not from
Moreover. We pass some information in WDDX format within form fields.  It
seems that IE sees things like "reg;", and converts it to its "real"
version.  As it is passed on from the  form, WDDX doesn't know how to deal
with the new value.

We ended up doing nasty search and replaces to clean the data before
deserializing it.

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com


-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 1:17 PM
To: [EMAIL PROTECTED]
Subject: RE: wddx problem


Thanks Jennifer, Chris  Steve:

It looks like Chris' experience is right on. The code is fine, it seems that
every once and a while moreover.com's feed generates a goofy wddx packet.
Jennifer, could you give an example of how you use char code=?? to clean
up files?? Moreover.com is at a loss to figure out what they can do to
prevent this, maybe its a simple fix from their end using your example...

Thanks,
Matt

-Original Message-
From: Jennifer A. Caulfield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 9:21 AM
To: [EMAIL PROTECTED]
Subject: RE: wddx problem


I don't know if this would be the reason, but I got a similar error when my
pages included accented characters. I had to convert them using char
code=?? before making the recordset.

Jennifer

-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:28 AM
To: [EMAIL PROTECTED]
Subject: wddx problem


I've been using wddx to process backend pages from moreover.com, which has
been working great. Today I am getting this message:

XML parsing error: not well-formed (error code 4, line 70, column 16, buffer
offset 4196)
The error occurred while processing an element with a general identifier of
(CFWDDX), occupying document position (5:1) to (5:87) in the template file
d:\http\4pines\index.cfm

How do I figure out what is wrong?

TIA
Matt


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


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


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


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

Re: Its still not working

[gregg Kachel]

Thanks alot for everyone's help, I finally got it to work. I really don't
know what the problem was. I just went thru and rewrote the code one line at
a time. When one field I could add, I then added another, until they all
worked ! Thanks again everyone!

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

RE: line break as delimiter

[jstiefel]

cfloop index="i" list="#IM_List#" delimiters="#Chr(13)##Chr(10)#"

Or, for just a linefeed, use Chr(10)

-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 11:31 AM
To: [EMAIL PROTECTED]
Subject: line break as delimiter


Hi
im trying to run a list loop from a file that uses separate lines for the
items.
i would like to use a line break as a delimiter
anyone have any ideas??
*
select name="screen_names"
 cfloop index="i" list="#IM_list#" delimiters=" "
  option value="1" SELECTED#i#/option
 /cfloop
/select
*
Thanks
-Eli-


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

RE: How the heck can I do this?

[jstiefel]

Jennifer-

You don't need to carry your own counter. The queryName.CurrentRow variable
stores it for you during a cfloop query="queryName" or cfoutput
query="queryName"

-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:00 PM
To: [EMAIL PROTECTED]
Subject: Re: How the heck can I do this?


At 08:19 AM 7/6/00 -0400, you wrote:
I'm setting up a real simple auction application. Super simple. People

submit bids via a form, then the top 5 bids are displayed on a page. The

catch is, I only want the 5th highest bid to show the actual bid.

So, I can order the query by bid descending and for output bids 1 through 5

will give the bidders name, but I need to have the bid amounts hidden for

the top 4 bids, and show the 5th.

To display only the top 5 bids, I'm using maxrows =5 in my output. Is there

a way to control all this stuff with the SQL, or do I have a basic query,

order by bid desc. and control the results through output?

With the output method, I can't seem to be able to get the results to

populate the 5th bid amt., but not the first 4.

Ok, in your output, use cfloop instead of cfoutput. Loop through the query 
and use a counter in the loop (if you need more info on this, let me know, 
but it's pretty basic, so I'll assume you can figure it out). When the 
counter is 5, you will change the information that is sent to the browser. 
So you'd do something like this (I don't guarantee the code because I'm not 
testing it):

cfset i=1
cfloop query="yourqueryname"
 cfif i LT 5
 #bidder##biddercontact#
 cfelse
 #bidder##biddercontact# #bid#
 /cfif
/cfloop

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

RE: Rounding of numbers

[Duane Boudreau]

Try:

cfset var.number = x * y

Round(var.number)  - Rounds a number to the closest integer
Ceiling(var.number) - Returns the closest integer greater than a given
number
Int(var.number) - Returns the closest integer smaller than a number

Duane Boudreau,
Project/Beta Manager, eMPower
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249
Fax: 603-594-0258

 -Original Message-
 From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 12:42 PM
 To: '[EMAIL PROTECTED]'
 Subject: Rounding of numbers


 Sorry for the noddy nature of the question but its 5.30 i've had
 a tooth out
 today and i'm getting no sympathy :)

 how do i round a number i've got as a result of a piece of arithmatic?
 Thanks as always

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


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

Re: Compiling CFX Tags

[GE]

Hello,

I use the gnu compiler myself (I love it and have been using it for years) on the 
Solaris and Linux (and even Win (ie. DOS) machines !).

The reason for using it is that *Allaire* seems to have built this latest version (CF 
Server 4.5.1) so that it *requires* the Sun compiler verion 5. Hm...

By the way, do you know otherwise ? Does it really have to use the Sun compiler?

regards,
Nelson



Zachary Bedell wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

  We have gnu 2.9 installed - I'll see if I can get that to work.

 Just out of curiousity, why are you using the Sun compiler at all?

 My boss' fiance worked for Sun, and she got us a couple of old Sparcs
 to play with.  I asked her if she could get the compiler package for
 us, and her response was, "Why?  Just user GNU.  It's better
 anyways."  That said by one of Sun's marketing people

 Is there some other reason for using Sun over GNU compilers?

 Best regards,
 Zac Bedell

 -BEGIN PGP SIGNATURE-
 Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com
 Comment: Please use PGP!!!

 iQA/AwUBOWSyrQraVoMWBwRBEQIOQwCfXIps78g1NXVCi+5Hl7DADIXVoTMAmwa+
 2eQiIsM1txsOGQYHdrl5UhV/
 =kH4e
 -END PGP SIGNATURE-
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

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

Session Management

[Matt Rodosky]

Is it possible to terminate a session when a user closes their browser?? Its
easy when a user logs out, or the session times out, it would be nice if you
could also do it when the browser is closed.

TIA
Matt

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

CFSchedule

[David Scheiderich]

Hello,

  Currently there is a section of my webpage that generates a massive
list (Requing 400-800 queries per hit), that is taxing down my
server. These pages are dynamic, driven by a SQL DB, that doesnt
change all the time. CFCACHE wont work, since it also relies on
cookies.

  My solution is to create the pages (360, varitions of view and
cookies), and store them into a Db table. And when someone requests
to see one, retreve the entire page from the DB and output it. So
each time a update takes place to the underlying tables, the pages
must be regenerated. Sometimes only a few, other changes could affect
all.

  In the case were it affects all, I schedule an event to run Once,
after updating the DB, to regenerate all the pages (~15 min process).
Only, it doesnt run. It does work, if I go into the CFIDE and modify
the Task. Otherwise, it just ignores it.
  This is what my code looks like:

cfschedule Task="TaskName"
Action = "Update"
Operation = "HTTPRequest"
URL = "URL"
StartDate = "#DateFormat(Now())#"
StartTime = "#TimeFormat(DateAdd('n',10,Now()),'HH:mm:ss')#"
Interval = "Once"
EndDate = "#DateFormat(DateAdd('d',1,Now()))#"
EndTime = "#TimeFormat(DateAdd('n',30,Now()),'HH:mm:ss')#"
RequestTimeOut=900

  Any ideas? - I'm running NT4/CF4.5.1/MS SQL 7

Thanks,
David Scheiderich

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

RE: Rounding of numbers

[Dan Haley]

Check the docs for round, fix, ceiling, and int.  They all work with
integers, so if you want to maintain decimal places you will have to
multiply before and divide after manipulating with these functions.

100.9 = round(100.867*10)/10

If this is for outputting only, also look at the display and formatting
section of the CF functions where you will find decimalformat, dollarformat,
numberformat, etc.

Dan

-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 9:42 AM
To: '[EMAIL PROTECTED]'
Subject: Rounding of numbers


Sorry for the noddy nature of the question but its 5.30 i've had a tooth out
today and i'm getting no sympathy :)

how do i round a number i've got as a result of a piece of arithmatic?
Thanks as always

Stew

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

Re: line break as delimiter

[Ric Smith]

Use the Chr(13) to delimit.

   cffile action="READ" file="#ExpandPath('fist_of_funk.dat')#"
variable="myWords"
   cfloop index="myLine" list="#myWords#" delimiters="#Chr(13)#"

Ric Smith


- Original Message -
From: "Eli Shechter" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 06, 2000 11:30 AM
Subject: line break as delimiter


 Hi
 im trying to run a list loop from a file that uses separate lines for the
 items.
 i would like to use a line break as a delimiter
 anyone have any ideas??
 *
 select name="screen_names"
  cfloop index="i" list="#IM_list#" delimiters=" "
   option value="1" SELECTED#i#/option
  /cfloop
 /select
 *
 Thanks
 -Eli-

 --

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

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

Last post: How do I Optimize Win 2000 (IIS) for Warp speed with Cold

[Damon Cooper]

For environmental performance tuning tips that work (all platforms), check
out:

http://www.allaire.com/Handlers/index.cfm?ID=11772Method=Full
http://www.allaire.com/Handlers/index.cfm?ID=11773Method=Full

On Win2000, be forewarned that you'll experience about a 17-20% performance
degradation over NT 4.0.  This is with the ZDLabs ServerBench 4.1 CPU suite
of tests in our labs.  

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

RE: Rounding of numbers

[Reilly, Jim]

Try:Round(number) 

It returns a number to the closest integer.


Jim


-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:42 PM
To: '[EMAIL PROTECTED]'
Subject: Rounding of numbers


Sorry for the noddy nature of the question but its 5.30 i've had a tooth out
today and i'm getting no sympathy :)

how do i round a number i've got as a result of a piece of arithmatic?
Thanks as always

Stew

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

RE: When should I use CFLOCK?

[Raymond K. Camden]

Incorrect. You should use CFLOCK when reading as well.

Basically, if you TYPE session, server, or application, you should have a
CFLOCK around it.

This includes:

CFPARAM NAME="Session.Foo" DEFAULT=1

And,

CFOUTPUT QUERY="Session.StoredQuery"
..
/CFOUTPUT

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

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

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


 -Original Message-
 From: Gregory Harris [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 1:23 PM
 To: [EMAIL PROTECTED]
 Subject: Re: When should I use CFLOCK?


 Does anyone have any
 guidelines on cflock usage?


 You should use CFLOCK when you are setting session variables to
 insure that you maintain consistency throughout your code.
 Reading however, is not a problem.

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

 Gregory Harris
 Los Angeles ITA Dept.
 [EMAIL PROTECTED]

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

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

RE: Rounding of numbers

[Larry Juncker]

If your number variable is #Number#

Then you simply say CFOUTPUT#Round(number)#/cfoutput



-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 11:42 AM
To: '[EMAIL PROTECTED]'
Subject: Rounding of numbers


Sorry for the noddy nature of the question but its 5.30 i've had a tooth out
today and i'm getting no sympathy :)

how do i round a number i've got as a result of a piece of arithmatic?
Thanks as always

Stew

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


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

RE: When should I use CFLOCK?

[Ben Forta]

Tom,

I just finished a column on just this subject for the August CFDJ. But to
summarize, locks are necessary if there is EVER a chance that shared
variables are updated. SESSION variables pretty much always need locks.
APPLICATION variables need locks if they are updated, if they are only ever
set once and are never ever written to again then the truth is they do not
need a lock (but ONLY if you can be sure of that). You could use a READONLY
lock to be sure, that does not have any real overhead and you can be safer
that way.

--- Ben


-Original Message-
From: Tom Dyson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 8:33 AM
To: [EMAIL PROTECTED]
Subject: When should I use CFLOCK?


The Allaire knowledge base article on monitoring memory usage states:

One of the most common causes [of increased memory usage] are improperly
locked access to session, application, and server variables. These variables
are stored in memory and need to be enclosed in a CFLOCK tag with the
appropriate SCOPE attribute specified (i.e. session, application, or server)
when referenced.

while Ben Forta says:

Caution: avoid unnecessary use of CFLOCK. Forcing code to single-threaded
use only can seriously impact system performance.

We're building an application which uses session and application variables
on every page (for security and user customisation). Should we use cflock
when we read them? Or when we write them? Or both? Does anyone have any
guidelines on cflock usage?

Thanks

Tom


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

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

RE: Rounding of numbers

[Mark Warrick]

You can use the ROUND() function.  (Go figure)

There are many other mathematical functions in the CFDOCS as well:

http://127.0.0.1/cfdocs/CFML_Language_Reference/3_ColdFusion_Functions/lr3_011.htm

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 9:42 AM
 To: '[EMAIL PROTECTED]'
 Subject: Rounding of numbers
 
 
 Sorry for the noddy nature of the question but its 5.30 i've had 
 a tooth out
 today and i'm getting no sympathy :)
 
 how do i round a number i've got as a result of a piece of arithmatic?
 Thanks as always
 
 Stew
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.

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

RE: ODBC Strange Problem

[Mark Warrick]

Yes, I've seen it.  I tried entering a number that was over 10 digits into a normal 
LONG INTEGER field.  I believe I resolved the problem by changing the datatype for 
that field to DOUBLE.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Olson, Kelly [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 06, 2000 10:10 AM
 To: [EMAIL PROTECTED]
 Subject: OT: ODBC Strange Problem
 
 
 Help Anyone!!
 
 Anyone seen this, that can give me a little info.  This is comming out
 of a 2 field table AccountID and AccountDescription. It works great up
 to 5 records and on the 6 record or above it generates the error above.
 
 It is basically a list of choices that are selected and a record inputed
 into a second table.  Nothing special and it works great as long as I
 only have 5 records in the selecting table.  There is no validation.  I
 have tried deleting the table and recreating it with the same problem.
 
 
 
 
 
 Error Diagnostic Information
 
  ODBC Error Code = 22003 (Numeric value out of range)
 
  [Microsoft][ODBC Microsoft Access 97 Driver]Numeric value out of range
 
  The error occurred while processing an element with a general
 identifier of (CFINSERT), occupying document position (3:2) to (3:61).
 
  Date/Time: 07/06/00 13:19:51
  Browser: Mozilla/4.73 [en] (Windows NT 5.0; U)
  Remote Address: 63.238.222.92
  HTTP Referer:
 http://www.mfglinks.org/scenarios/scenario/create_scenario5.cfm
  Template:
 D:\webclients\mfglinks.org\scenarios\scenario\create_scenario5.cfm
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.

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

Why does blank dates default to 1899-12-30?

[Paige Chandler]

This is a multi-part message in MIME format.

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

Hi All,

I'm "Selecting * From..." using a Visual FoxPro free table. Some of the =
date fields (VFP date format) are blank. When displayed with CFTable or =
CFGridCol they appear "1899-12-30". I must resolve this. Any =
suggestions? TIA.

Regards,

Paige

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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I'm "Selecting * From..." using a =
Visual FoxPro=20
free table. Some of the date fields (VFP date format) are blank. When =
displayed=20
with CFTable or CFGridCol they appear "1899-12-30". I must resolve this. =
Any=20
suggestions? TIA./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Regards,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Paige/FONT/DIV/BODY/HTML

--=_NextPart_000_0009_01BFE76E.D7462320--

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

USPS calculator?

[Jeff Green]

Hi all,

Is anyone aware of any sort of US postal service shipping calculator tag?

The CF_UPSShipRate works good, but UPS doesnt deliver everywhere and its
expensive.  So im looking to give an option USPS or UPS.

TIA,
jeff


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