Re: updating problem

[Judy]

Thanks for everyone's help - it's starting to come together I think - but
it's very late here so will work on it again tomorrow.

- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 12:52 AM
Subject: RE: updating problem


> Oops! Use " instead.
>
> -Original Message-
> From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 2:31 PM
> To: CF-Talk
> Subject: RE: updating problem
>
>
> eg:
>
>  enctype="multipart/form-data">
>
> Title:
>
> 
>
> 
>
>  title="Update">
> 
>
> Your "update.cfm" file will look something like this:
>
> 
> 
> 
>
>
> -Original Message-
> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 2:12 PM
> To: CF-Talk
> Subject: RE: updating problem
>
>
> Judy,
>
> Your query may be pulling records, but where is the FORM code?  You have
to
> make some changes to the form code to get it to populate correctly.  It
> doesn't happen automatically .
>
> Mark
>
> -Original Message-
> From: Judy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 10:58 PM
> To: CF-Talk
> Subject: Re: updating problem
>
>
> I did it, but the boxes are still empty when I go to the form. Here's my
new
> code for this query.
>
> 
> 
> SELECT
>  Title,
>  PrintDesc,
>  InterDesc,
>  IntraDesc,
>  Area,
>  Location ,
>  Ticketed ,
>  Kid ,
>  Handicap'
> FROM Events
> WHERE ID = #URL.ID#
> 
>
>
> - Original Message -
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 11:40 PM
> Subject: Re: updating problem
>
>
> > 
> >  
> >  SELECT *
> >  FROM Events
> >  
> >  
> >
> >  
> >  
> >   
> >
> >
> > Ok you need to add a WHERE clause WHERE ID = #url.id# to your query...
> >
> > Give that a shot!
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> > - Original Message -
> > From: "Judy" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 10:37 PM
> > Subject: Re: updating problem
> >
> >
> > > Thanks for the quick responses. I changed my update query as both Paul
> and
> > > Matthew suggested, but when I click on my Edit link in the
eventlist.cfm
> > > file, I'm still just pulling up a blank update form. I can see up in
the
> > > address bar that it is ID=4, for example which is the right record.
How
> do
> > I
> > > get all the existing information to appear in the boxes?
> > >
> > >
> > > - Original Message -
> > > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 11:22 PM
> > > Subject: RE: updating problem
> > >
> > >
> > > > On *s... I think sometimes they have a place. I'll sometimes write a
> > > > query to get say a person's record from the db and reuse it in
various
> > > > different pieces of code, where each piece requires different info
> from
> > > > the record. I could write ten queries, or I could write one and take
> > > > advantage of CF query caching.
> > > >
> > > >
> > > >
> > > > -Original Message-
> > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, 18 April 2002 3:14 p.m.
> > > > To: CF-Talk
> > > > Subject: Re: updating problem
> > > >
> > > >
> > > > First off
> > > >
> > > > Your update query should look like this and NOT use a *  (you
> shouldn't
> > > > use
> > > > *'s they are poor coding, spell everything out)
> > > >
> > > > 
> > > > Update tablename
> > > > set column1 = '#form.column1#',
> > > >  column2 = '#form.column2#',
> > > > column3 = '#form.column3#'
> > > > where id = id
> > > > 
> > > > Note a few things.
> > > > 1) If you have more than one column being updated they are always
> > > > followed
> > > > by a comma , (seperating them)
> > > > 2) strings are surrounded by single quotes ' and numeric/date values
> are
> > > > without single quotes
> > > >
> > > > Try that out and let us know ...
> > > >
> > > > Paul Giesenhagen
> > > > QuillDesign
> > > > http://www.quilldesign.com
> > > > SiteDirector v2.0 - Commerce Builder
> > > >
> > > >
> > > > - Original Message -
> > > > From: "Judy" <[EMAIL PROTECTED]>
> > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, April 17, 2002 10:06 PM
> > > > Subject: updating problem
> > > >
> > > >
> > > > > I'm in desparate need of help. I'm doing my first CF application
and
> > > > it's
> > > > not going so well. My database is in SQL.
> > > > >
> > > > > So far, I have an eventlist.cfm file containing a list of all our
> > > > events.
> > > > This page has an "Edit" link which takes me to an "update event"
input
> > > > form.
> > > > When I click it, the link takes me to a blank form - I need it to
pull
> > > > up
> > > > the form already filled in with the existing information so we can
> make
> > > >

RE: updating problem

[Peter Tilbrook]

Oops! Use " instead.

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 2:31 PM
To: CF-Talk
Subject: RE: updating problem


eg:



Title:








Your "update.cfm" file will look something like this:






-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 2:12 PM
To: CF-Talk
Subject: RE: updating problem


Judy,

Your query may be pulling records, but where is the FORM code?  You have to
make some changes to the form code to get it to populate correctly.  It
doesn't happen automatically .

Mark

-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:58 PM
To: CF-Talk
Subject: Re: updating problem


I did it, but the boxes are still empty when I go to the form. Here's my new
code for this query.



SELECT
 Title,
 PrintDesc,
 InterDesc,
 IntraDesc,
 Area,
 Location ,
 Ticketed ,
 Kid ,
 Handicap'
FROM Events
WHERE ID = #URL.ID#



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:40 PM
Subject: Re: updating problem


> 
>  
>  SELECT *
>  FROM Events
>  
>  
>
>  
>  
>   
>
>
> Ok you need to add a WHERE clause WHERE ID = #url.id# to your query...
>
> Give that a shot!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:37 PM
> Subject: Re: updating problem
>
>
> > Thanks for the quick responses. I changed my update query as both Paul
and
> > Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> > file, I'm still just pulling up a blank update form. I can see up in the
> > address bar that it is ID=4, for example which is the right record. How
do
> I
> > get all the existing information to appear in the boxes?
> >
> >
> > - Original Message -
> > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 11:22 PM
> > Subject: RE: updating problem
> >
> >
> > > On *s... I think sometimes they have a place. I'll sometimes write a
> > > query to get say a person's record from the db and reuse it in various
> > > different pieces of code, where each piece requires different info
from
> > > the record. I could write ten queries, or I could write one and take
> > > advantage of CF query caching.
> > >
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, 18 April 2002 3:14 p.m.
> > > To: CF-Talk
> > > Subject: Re: updating problem
> > >
> > >
> > > First off
> > >
> > > Your update query should look like this and NOT use a *  (you
shouldn't
> > > use
> > > *'s they are poor coding, spell everything out)
> > >
> > > 
> > > Update tablename
> > > set column1 = '#form.column1#',
> > >  column2 = '#form.column2#',
> > > column3 = '#form.column3#'
> > > where id = id
> > > 
> > > Note a few things.
> > > 1) If you have more than one column being updated they are always
> > > followed
> > > by a comma , (seperating them)
> > > 2) strings are surrounded by single quotes ' and numeric/date values
are
> > > without single quotes
> > >
> > > Try that out and let us know ...
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector v2.0 - Commerce Builder
> > >
> > >
> > > - Original Message -
> > > From: "Judy" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 10:06 PM
> > > Subject: updating problem
> > >
> > >
> > > > I'm in desparate need of help. I'm doing my first CF application and
> > > it's
> > > not going so well. My database is in SQL.
> > > >
> > > > So far, I have an eventlist.cfm file containing a list of all our
> > > events.
> > > This page has an "Edit" link which takes me to an "update event" input
> > > form.
> > > When I click it, the link takes me to a blank form - I need it to pull
> > > up
> > > the form already filled in with the existing information so we can
make
> > > changes to it. The primary key for the Events table is called ID and
is
> > > an
> > > AutoNumber type.
> > > >
> > > > There's also a Delete link on the eventlist.cfm page that doesn't
> > > delete
> > > anything out of my database and I can't figure out how to do it.
> > > >
> > > > Here is the code in the eventlist.cfm file:
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > WHERE ID = ID
> > > > 
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >
> > > > 
> > > >  
> > > >   
> > > >#title#
> > > > Updated on: #updatedon#
> > > >   
> > > >   
> > > >Preview
> > > >Edit
> > > >Delete
> > > >
> > > >Inactive?  > > notchecked>
> > > >   
> > > >  
> > 

RE: updating problem

[Peter Tilbrook]

eg:



Title:








Your "update.cfm" file will look something like this:






-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 2:12 PM
To: CF-Talk
Subject: RE: updating problem


Judy,

Your query may be pulling records, but where is the FORM code?  You have to
make some changes to the form code to get it to populate correctly.  It
doesn't happen automatically .

Mark

-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:58 PM
To: CF-Talk
Subject: Re: updating problem


I did it, but the boxes are still empty when I go to the form. Here's my new
code for this query.



SELECT
 Title,
 PrintDesc,
 InterDesc,
 IntraDesc,
 Area,
 Location ,
 Ticketed ,
 Kid ,
 Handicap'
FROM Events
WHERE ID = #URL.ID#



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:40 PM
Subject: Re: updating problem


> 
>  
>  SELECT *
>  FROM Events
>  
>  
>
>  
>  
>   
>
>
> Ok you need to add a WHERE clause WHERE ID = #url.id# to your query...
>
> Give that a shot!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:37 PM
> Subject: Re: updating problem
>
>
> > Thanks for the quick responses. I changed my update query as both Paul
and
> > Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> > file, I'm still just pulling up a blank update form. I can see up in the
> > address bar that it is ID=4, for example which is the right record. How
do
> I
> > get all the existing information to appear in the boxes?
> >
> >
> > - Original Message -
> > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 11:22 PM
> > Subject: RE: updating problem
> >
> >
> > > On *s... I think sometimes they have a place. I'll sometimes write a
> > > query to get say a person's record from the db and reuse it in various
> > > different pieces of code, where each piece requires different info
from
> > > the record. I could write ten queries, or I could write one and take
> > > advantage of CF query caching.
> > >
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, 18 April 2002 3:14 p.m.
> > > To: CF-Talk
> > > Subject: Re: updating problem
> > >
> > >
> > > First off
> > >
> > > Your update query should look like this and NOT use a *  (you
shouldn't
> > > use
> > > *'s they are poor coding, spell everything out)
> > >
> > > 
> > > Update tablename
> > > set column1 = '#form.column1#',
> > >  column2 = '#form.column2#',
> > > column3 = '#form.column3#'
> > > where id = id
> > > 
> > > Note a few things.
> > > 1) If you have more than one column being updated they are always
> > > followed
> > > by a comma , (seperating them)
> > > 2) strings are surrounded by single quotes ' and numeric/date values
are
> > > without single quotes
> > >
> > > Try that out and let us know ...
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector v2.0 - Commerce Builder
> > >
> > >
> > > - Original Message -
> > > From: "Judy" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 10:06 PM
> > > Subject: updating problem
> > >
> > >
> > > > I'm in desparate need of help. I'm doing my first CF application and
> > > it's
> > > not going so well. My database is in SQL.
> > > >
> > > > So far, I have an eventlist.cfm file containing a list of all our
> > > events.
> > > This page has an "Edit" link which takes me to an "update event" input
> > > form.
> > > When I click it, the link takes me to a blank form - I need it to pull
> > > up
> > > the form already filled in with the existing information so we can
make
> > > changes to it. The primary key for the Events table is called ID and
is
> > > an
> > > AutoNumber type.
> > > >
> > > > There's also a Delete link on the eventlist.cfm page that doesn't
> > > delete
> > > anything out of my database and I can't figure out how to do it.
> > > >
> > > > Here is the code in the eventlist.cfm file:
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > WHERE ID = ID
> > > > 
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >
> > > > 
> > > >  
> > > >   
> > > >#title#
> > > > Updated on: #updatedon#
> > > >   
> > > >   
> > > >Preview
> > > >Edit
> > > >Delete
> > > >
> > > >Inactive?  > > notchecked>
> > > >   
> > > >  
> > > > 
> > > > 
> > > > 
> > > >
> > > > Here is some of the code in my updateform.cfm file.
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > 
> > > > 
> > > >

RE: updating problem

[Mark A. Kruger - CFG]

Judy,

Your query may be pulling records, but where is the FORM code?  You have to
make some changes to the form code to get it to populate correctly.  It
doesn't happen automatically .

Mark

-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:58 PM
To: CF-Talk
Subject: Re: updating problem


I did it, but the boxes are still empty when I go to the form. Here's my new
code for this query.



SELECT
 Title,
 PrintDesc,
 InterDesc,
 IntraDesc,
 Area,
 Location ,
 Ticketed ,
 Kid ,
 Handicap'
FROM Events
WHERE ID = #URL.ID#



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:40 PM
Subject: Re: updating problem


> 
>  
>  SELECT *
>  FROM Events
>  
>  
>
>  
>  
>   
>
>
> Ok you need to add a WHERE clause WHERE ID = #url.id# to your query...
>
> Give that a shot!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:37 PM
> Subject: Re: updating problem
>
>
> > Thanks for the quick responses. I changed my update query as both Paul
and
> > Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> > file, I'm still just pulling up a blank update form. I can see up in the
> > address bar that it is ID=4, for example which is the right record. How
do
> I
> > get all the existing information to appear in the boxes?
> >
> >
> > - Original Message -
> > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 11:22 PM
> > Subject: RE: updating problem
> >
> >
> > > On *s... I think sometimes they have a place. I'll sometimes write a
> > > query to get say a person's record from the db and reuse it in various
> > > different pieces of code, where each piece requires different info
from
> > > the record. I could write ten queries, or I could write one and take
> > > advantage of CF query caching.
> > >
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, 18 April 2002 3:14 p.m.
> > > To: CF-Talk
> > > Subject: Re: updating problem
> > >
> > >
> > > First off
> > >
> > > Your update query should look like this and NOT use a *  (you
shouldn't
> > > use
> > > *'s they are poor coding, spell everything out)
> > >
> > > 
> > > Update tablename
> > > set column1 = '#form.column1#',
> > >  column2 = '#form.column2#',
> > > column3 = '#form.column3#'
> > > where id = id
> > > 
> > > Note a few things.
> > > 1) If you have more than one column being updated they are always
> > > followed
> > > by a comma , (seperating them)
> > > 2) strings are surrounded by single quotes ' and numeric/date values
are
> > > without single quotes
> > >
> > > Try that out and let us know ...
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector v2.0 - Commerce Builder
> > >
> > >
> > > - Original Message -
> > > From: "Judy" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 10:06 PM
> > > Subject: updating problem
> > >
> > >
> > > > I'm in desparate need of help. I'm doing my first CF application and
> > > it's
> > > not going so well. My database is in SQL.
> > > >
> > > > So far, I have an eventlist.cfm file containing a list of all our
> > > events.
> > > This page has an "Edit" link which takes me to an "update event" input
> > > form.
> > > When I click it, the link takes me to a blank form - I need it to pull
> > > up
> > > the form already filled in with the existing information so we can
make
> > > changes to it. The primary key for the Events table is called ID and
is
> > > an
> > > AutoNumber type.
> > > >
> > > > There's also a Delete link on the eventlist.cfm page that doesn't
> > > delete
> > > anything out of my database and I can't figure out how to do it.
> > > >
> > > > Here is the code in the eventlist.cfm file:
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > WHERE ID = ID
> > > > 
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >
> > > > 
> > > >  
> > > >   
> > > >#title#
> > > > Updated on: #updatedon#
> > > >   
> > > >   
> > > >Preview
> > > >Edit
> > > >Delete
> > > >
> > > >Inactive?  > > notchecked>
> > > >   
> > > >  
> > > > 
> > > > 
> > > > 
> > > >
> > > > Here is some of the code in my updateform.cfm file.
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > 
> > > > 
> > > >
> > > > 
> > > > 
> > > >  
> > > >
> > > > Finally, here is the code in my updateaction.cfm file.
> > > >
> > > > 
> > > > UPDATE Events
> > > > SET *
> > > > WHERE Events.ID = #URL.ID#
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >  Updat

RE: Getting pages Timed Out

[Mark A. Kruger - CFG]

Vishal,

Ok - you caught me on a night when I'm not working and I'm in a chatty mood.

"...processed simultaneous request" is not  the same as simultaneous users.
It means the number of concurrent requests that CF will process.  Requests
that exceed this number are then placed in a queue and processed in a FIFO
order. So the answer is no, they would not get a timeout message.
Incidentally, 15 is probably too high in any case, unless you are on a quad
processor box. I've seen the "rule of thumb" written as 2x and no more than
3x the number of processors on your box.  Of course the speed of the procs
and other server resources are important as well.  In any case, another
similar setting "restart after n unresponsive requests" can cause the server
to restart if there are "hanging" requests.

As far as timing out, although you can work the administrative angle and
fiddle with your settings , you should probably go and look at the scripts
that are actually timing out and try to figure out why. That will probably
be a much more productive exercise.  Likely candidates are: large or poorly
worded database queries, overtaxed database servers or files, any external
process being used (cffile, cfmail, cfpop, COM objects, CFX etc.) and poor
application code (no locking, overuse of evaluate, nested looping etc.).

Funny anecdotal story regarding server tuning:

I did an emergency call a while back for someone who had a server that had
been responsive but was getting increasingly slower.  We turned on slow page
logging and identified the 3 or four templates that were excessively slow to
execute.  When I loaded the templates in the browser the reason they were
slow  became quickly apparent as soon as I saw the debugging information.  A
single query was taking as much as 2 minutes to complete.

The problem was bad database code. The "programmer" (really a designer who
dabbled), didn't know how to use the MAX( ) function in a query. To create a
primary key he was using an  integer field.  Every time he served a banner
ad he was logging to the database - but he had to figure out what the
maximum number in the database was, add +1 to it, and use that for the next
PK.

Not knowing anything but a few CF commands, he settled on the following
solution. 1) He grabbed ALL the records from the table ordered by the ID
number,  2) he used valuelist() to create a list from that ID field, and 3)
he grabbed the last item from the list using ListLast( ), and added +1 to
it. This became his new PK on the insert.  This (bad!)  code ran fine for
weeks - up until he had about 5 records in the database... then suddenly
he was bringing all the sites on the server to a screeching halt - because
the query was pulling 5 or more records for every time the page loaded.
By the time they called me in, the query was at 115,000 records - I was
frankly surprised that the database and ODBC driver and CF was even able to
handle that number of records at all (Interbase if you want to know). It was
also nice to know that CF could handle a list variable of more than 100k
(ha).

I fixed the problem by using the MAX function, then I slapped his hands and
told him NOT to program again or I would take away his dream weaver .
Still, these ISP webmasters had adjusted the settings on the server for days
before forking over a consulting fee to have someone fix in 10 minutes what
they could have figured out for themselves if they had just stopped
"administering the server" long enough to load up the actual pages causing
the problem.

Wow - that's a long tome... sorry about that. It must have been a triple
scotch .

-mk

Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
..no more brochures!





** you wrote *
We have set the max number of simultaneous requests in ColdFusion
Administrator to 15. Supposing we have a 16th simultaneous user, would they
get an error message or would their page time out ? How does ColdFusion
handle this ?

Vishal.


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

Re: updating problem

[Judy]

I did it, but the boxes are still empty when I go to the form. Here's my new
code for this query.



SELECT
 Title,
 PrintDesc,
 InterDesc,
 IntraDesc,
 Area,
 Location ,
 Ticketed ,
 Kid ,
 Handicap'
FROM Events
WHERE ID = #URL.ID#



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:40 PM
Subject: Re: updating problem


> 
>  
>  SELECT *
>  FROM Events
>  
>  
>
>  
>  
>   
>
>
> Ok you need to add a WHERE clause WHERE ID = #url.id# to your query...
>
> Give that a shot!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:37 PM
> Subject: Re: updating problem
>
>
> > Thanks for the quick responses. I changed my update query as both Paul
and
> > Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> > file, I'm still just pulling up a blank update form. I can see up in the
> > address bar that it is ID=4, for example which is the right record. How
do
> I
> > get all the existing information to appear in the boxes?
> >
> >
> > - Original Message -
> > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 11:22 PM
> > Subject: RE: updating problem
> >
> >
> > > On *s... I think sometimes they have a place. I'll sometimes write a
> > > query to get say a person's record from the db and reuse it in various
> > > different pieces of code, where each piece requires different info
from
> > > the record. I could write ten queries, or I could write one and take
> > > advantage of CF query caching.
> > >
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, 18 April 2002 3:14 p.m.
> > > To: CF-Talk
> > > Subject: Re: updating problem
> > >
> > >
> > > First off
> > >
> > > Your update query should look like this and NOT use a *  (you
shouldn't
> > > use
> > > *'s they are poor coding, spell everything out)
> > >
> > > 
> > > Update tablename
> > > set column1 = '#form.column1#',
> > >  column2 = '#form.column2#',
> > > column3 = '#form.column3#'
> > > where id = id
> > > 
> > > Note a few things.
> > > 1) If you have more than one column being updated they are always
> > > followed
> > > by a comma , (seperating them)
> > > 2) strings are surrounded by single quotes ' and numeric/date values
are
> > > without single quotes
> > >
> > > Try that out and let us know ...
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector v2.0 - Commerce Builder
> > >
> > >
> > > - Original Message -
> > > From: "Judy" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 10:06 PM
> > > Subject: updating problem
> > >
> > >
> > > > I'm in desparate need of help. I'm doing my first CF application and
> > > it's
> > > not going so well. My database is in SQL.
> > > >
> > > > So far, I have an eventlist.cfm file containing a list of all our
> > > events.
> > > This page has an "Edit" link which takes me to an "update event" input
> > > form.
> > > When I click it, the link takes me to a blank form - I need it to pull
> > > up
> > > the form already filled in with the existing information so we can
make
> > > changes to it. The primary key for the Events table is called ID and
is
> > > an
> > > AutoNumber type.
> > > >
> > > > There's also a Delete link on the eventlist.cfm page that doesn't
> > > delete
> > > anything out of my database and I can't figure out how to do it.
> > > >
> > > > Here is the code in the eventlist.cfm file:
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > WHERE ID = ID
> > > > 
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >
> > > > 
> > > >  
> > > >   
> > > >#title#
> > > > Updated on: #updatedon#
> > > >   
> > > >   
> > > >Preview
> > > >Edit
> > > >Delete
> > > >
> > > >Inactive?  > > notchecked>
> > > >   
> > > >  
> > > > 
> > > > 
> > > > 
> > > >
> > > > Here is some of the code in my updateform.cfm file.
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > 
> > > > 
> > > >
> > > > 
> > > > 
> > > >  
> > > >
> > > > Finally, here is the code in my updateaction.cfm file.
> > > >
> > > > 
> > > > UPDATE Events
> > > > SET *
> > > > WHERE Events.ID = #URL.ID#
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >  Update Event
> > > > 
> > > >
> > > > 
> > > >
> > > > Event Updated
> > > > 
> > > > You have updated the information for #Form.Title# in the Events
> > > database.
> > > > 
> > > > 
> > > > Edit another event
> > > > 
> > > > 
> > > > Return to website
> > > > 
> > > >
> > > >
> > > > I hope someone can help me - I'm going crazy trying to figur

Re: updating problem

[Paul Giesenhagen]

select col1, col2,col3,col4
from table
where id = #url.id#










I think that is what you are asking?!?!

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


- Original Message -
From: "Judy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 10:51 PM
Subject: Re: updating problem


> How to populate the form's text boxes with the existing data that's
already
> in my SQL db, so records can be updated. I have another "input" form that
> comes up blank to input a new record - and it's the one thing that
actually
> works in my app. The code is down below - I've included the code for the
> initial page that has a list of all the events, called eventlist.cfm, code
> for the updateform.cfm and for updateaction.cfm.
>
> Thanks, Judy
>
>
> - Original Message -
> From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 11:41 PM
> Subject: RE: updating problem
>
>
> > Judy,
> >
> > I'm not sure what you are getting at.  Do you mean, how do you populate
> the
> > form text boxes with data from your query? Or with data from the
submitted
> > form? some sample code might be helpful.
> >
> > mark
> >
> > -Original Message-
> > From: Judy [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 17, 2002 10:38 PM
> > To: CF-Talk
> > Subject: Re: updating problem
> >
> >
> > Thanks for the quick responses. I changed my update query as both Paul
and
> > Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> > file, I'm still just pulling up a blank update form. I can see up in the
> > address bar that it is ID=4, for example which is the right record. How
do
> I
> > get all the existing information to appear in the boxes?
> >
> >
> > - Original Message -
> > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 11:22 PM
> > Subject: RE: updating problem
> >
> >
> > > On *s... I think sometimes they have a place. I'll sometimes write a
> > > query to get say a person's record from the db and reuse it in various
> > > different pieces of code, where each piece requires different info
from
> > > the record. I could write ten queries, or I could write one and take
> > > advantage of CF query caching.
> > >
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, 18 April 2002 3:14 p.m.
> > > To: CF-Talk
> > > Subject: Re: updating problem
> > >
> > >
> > > First off
> > >
> > > Your update query should look like this and NOT use a *  (you
shouldn't
> > > use
> > > *'s they are poor coding, spell everything out)
> > >
> > > 
> > > Update tablename
> > > set column1 = '#form.column1#',
> > >  column2 = '#form.column2#',
> > > column3 = '#form.column3#'
> > > where id = id
> > > 
> > > Note a few things.
> > > 1) If you have more than one column being updated they are always
> > > followed
> > > by a comma , (seperating them)
> > > 2) strings are surrounded by single quotes ' and numeric/date values
are
> > > without single quotes
> > >
> > > Try that out and let us know ...
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector v2.0 - Commerce Builder
> > >
> > >
> > > - Original Message -
> > > From: "Judy" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 10:06 PM
> > > Subject: updating problem
> > >
> > >
> > > > I'm in desparate need of help. I'm doing my first CF application and
> > > it's
> > > not going so well. My database is in SQL.
> > > >
> > > > So far, I have an eventlist.cfm file containing a list of all our
> > > events.
> > > This page has an "Edit" link which takes me to an "update event" input
> > > form.
> > > When I click it, the link takes me to a blank form - I need it to pull
> > > up
> > > the form already filled in with the existing information so we can
make
> > > changes to it. The primary key for the Events table is called ID and
is
> > > an
> > > AutoNumber type.
> > > >
> > > > There's also a Delete link on the eventlist.cfm page that doesn't
> > > delete
> > > anything out of my database and I can't figure out how to do it.
> > > >
> > > > Here is the code in the eventlist.cfm file:
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > WHERE ID = ID
> > > > 
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > >
> > > > 
> > > >  
> > > >   
> > > >#title#
> > > > Updated on: #updatedon#
> > > >   
> > > >   
> > > >Preview
> > > >Edit
> > > >Delete
> > > >
> > > >Inactive?  > > notchecked>
> > > >   
> > > >  
> > > > 
> > > > 
> > > > 
> > > >
> > > > Here is some of the code in my updateform.cfm file.
> > > >
> > > > 
> > > > 
> > > > SELECT *
> > > > FROM Events
> > > > 
> > > > 
> 

RE: updating problem

[Matthew Walker]

There's no easy single answer to this. You can try copying all the
fields in your query into the form scope (you can loop thru
queryname.ColumnList). Then in your s specify #form.whatever# as
the value.

Personally, I use Inform, which is a system I put together to take care
of this sort of stuff. Most developers will have their own favourite
technique.


-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 3:38 p.m.
To: CF-Talk
Subject: Re: updating problem


Thanks for the quick responses. I changed my update query as both Paul
and
Matthew suggested, but when I click on my Edit link in the eventlist.cfm
file, I'm still just pulling up a blank update form. I can see up in the
address bar that it is ID=4, for example which is the right record. How
do I
get all the existing information to appear in the boxes?


- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:22 PM
Subject: RE: updating problem


> On *s... I think sometimes they have a place. I'll sometimes write a
> query to get say a person's record from the db and reuse it in various
> different pieces of code, where each piece requires different info
from
> the record. I could write ten queries, or I could write one and take
> advantage of CF query caching.
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 3:14 p.m.
> To: CF-Talk
> Subject: Re: updating problem
>
>
> First off
>
> Your update query should look like this and NOT use a *  (you
shouldn't
> use
> *'s they are poor coding, spell everything out)
>
> 
> Update tablename
> set column1 = '#form.column1#',
>  column2 = '#form.column2#',
> column3 = '#form.column3#'
> where id = id
> 
> Note a few things.
> 1) If you have more than one column being updated they are always
> followed
> by a comma , (seperating them)
> 2) strings are surrounded by single quotes ' and numeric/date values
are
> without single quotes
>
> Try that out and let us know ...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:06 PM
> Subject: updating problem
>
>
> > I'm in desparate need of help. I'm doing my first CF application and
> it's
> not going so well. My database is in SQL.
> >
> > So far, I have an eventlist.cfm file containing a list of all our
> events.
> This page has an "Edit" link which takes me to an "update event" input
> form.
> When I click it, the link takes me to a blank form - I need it to pull
> up
> the form already filled in with the existing information so we can
make
> changes to it. The primary key for the Events table is called ID and
is
> an
> AutoNumber type.
> >
> > There's also a Delete link on the eventlist.cfm page that doesn't
> delete
> anything out of my database and I can't figure out how to do it.
> >
> > Here is the code in the eventlist.cfm file:
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > WHERE ID = ID
> > 
> > 
> >
> >
> > 
> > 
> >
> > 
> >  
> >   
> >#title#
> > Updated on: #updatedon#
> >   
> >   
> >Preview
> >Edit
> >Delete
> >
> >Inactive?  notchecked>
> >   
> >  
> > 
> > 
> > 
> >
> > Here is some of the code in my updateform.cfm file.
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > 
> > 
> >
> > 
> > 
> >  
> >
> > Finally, here is the code in my updateaction.cfm file.
> >
> > 
> > UPDATE Events
> > SET *
> > WHERE Events.ID = #URL.ID#
> > 
> >
> >
> > 
> > 
> >  Update Event
> > 
> >
> > 
> >
> > Event Updated
> > 
> > You have updated the information for #Form.Title# in the Events
> database.
> > 
> > 
> > Edit another event
> > 
> > 
> > Return to website
> > 
> >
> >
> > I hope someone can help me - I'm going crazy trying to figure this
all
> out.
> >
> > Thanks, Judy
> >
> >
>
> 

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

Re: updating problem

[Judy]

How to populate the form's text boxes with the existing data that's already
in my SQL db, so records can be updated. I have another "input" form that
comes up blank to input a new record - and it's the one thing that actually
works in my app. The code is down below - I've included the code for the
initial page that has a list of all the events, called eventlist.cfm, code
for the updateform.cfm and for updateaction.cfm.

Thanks, Judy


- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:41 PM
Subject: RE: updating problem


> Judy,
>
> I'm not sure what you are getting at.  Do you mean, how do you populate
the
> form text boxes with data from your query? Or with data from the submitted
> form? some sample code might be helpful.
>
> mark
>
> -Original Message-
> From: Judy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 10:38 PM
> To: CF-Talk
> Subject: Re: updating problem
>
>
> Thanks for the quick responses. I changed my update query as both Paul and
> Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> file, I'm still just pulling up a blank update form. I can see up in the
> address bar that it is ID=4, for example which is the right record. How do
I
> get all the existing information to appear in the boxes?
>
>
> - Original Message -
> From: "Matthew Walker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 11:22 PM
> Subject: RE: updating problem
>
>
> > On *s... I think sometimes they have a place. I'll sometimes write a
> > query to get say a person's record from the db and reuse it in various
> > different pieces of code, where each piece requires different info from
> > the record. I could write ten queries, or I could write one and take
> > advantage of CF query caching.
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 18 April 2002 3:14 p.m.
> > To: CF-Talk
> > Subject: Re: updating problem
> >
> >
> > First off
> >
> > Your update query should look like this and NOT use a *  (you shouldn't
> > use
> > *'s they are poor coding, spell everything out)
> >
> > 
> > Update tablename
> > set column1 = '#form.column1#',
> >  column2 = '#form.column2#',
> > column3 = '#form.column3#'
> > where id = id
> > 
> > Note a few things.
> > 1) If you have more than one column being updated they are always
> > followed
> > by a comma , (seperating them)
> > 2) strings are surrounded by single quotes ' and numeric/date values are
> > without single quotes
> >
> > Try that out and let us know ...
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> > - Original Message -
> > From: "Judy" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 10:06 PM
> > Subject: updating problem
> >
> >
> > > I'm in desparate need of help. I'm doing my first CF application and
> > it's
> > not going so well. My database is in SQL.
> > >
> > > So far, I have an eventlist.cfm file containing a list of all our
> > events.
> > This page has an "Edit" link which takes me to an "update event" input
> > form.
> > When I click it, the link takes me to a blank form - I need it to pull
> > up
> > the form already filled in with the existing information so we can make
> > changes to it. The primary key for the Events table is called ID and is
> > an
> > AutoNumber type.
> > >
> > > There's also a Delete link on the eventlist.cfm page that doesn't
> > delete
> > anything out of my database and I can't figure out how to do it.
> > >
> > > Here is the code in the eventlist.cfm file:
> > >
> > > 
> > > 
> > > SELECT *
> > > FROM Events
> > > WHERE ID = ID
> > > 
> > > 
> > >
> > >
> > > 
> > > 
> > >
> > > 
> > >  
> > >   
> > >#title#
> > > Updated on: #updatedon#
> > >   
> > >   
> > >Preview
> > >Edit
> > >Delete
> > >
> > >Inactive?  > notchecked>
> > >   
> > >  
> > > 
> > > 
> > > 
> > >
> > > Here is some of the code in my updateform.cfm file.
> > >
> > > 
> > > 
> > > SELECT *
> > > FROM Events
> > > 
> > > 
> > >
> > > 
> > > 
> > >  
> > >
> > > Finally, here is the code in my updateaction.cfm file.
> > >
> > > 
> > > UPDATE Events
> > > SET *
> > > WHERE Events.ID = #URL.ID#
> > > 
> > >
> > >
> > > 
> > > 
> > >  Update Event
> > > 
> > >
> > > 
> > >
> > > Event Updated
> > > 
> > > You have updated the information for #Form.Title# in the Events
> > database.
> > > 
> > > 
> > > Edit another event
> > > 
> > > 
> > > Return to website
> > > 
> > >
> > >
> > > I hope someone can help me - I'm going crazy trying to figure this all
> > out.
> > >
> > > Thanks, Judy
> > >
> > >
> >
> >
>
> 
__
Structure your ColdFusion code with

RE: updating problem

[Tony Gruen]

Judy, you simply need to populate the form. There are some minor differences
in the way to do this but one way for your to use to start would be...

Use 

Pupulate a select...


SELECTED>a
SELECTED>b
SELECTED>c
SELECTED>d
SELECTED>e


..and similar for radio boxes etc..

T


-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 8:38 PM
To: CF-Talk
Subject: Re: updating problem


Thanks for the quick responses. I changed my update query as both Paul and
Matthew suggested, but when I click on my Edit link in the eventlist.cfm
file, I'm still just pulling up a blank update form. I can see up in the
address bar that it is ID=4, for example which is the right record. How do I
get all the existing information to appear in the boxes?


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

Re: updating problem

[Paul Giesenhagen]

Oh how true... I am wit ya!

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


> Paul,
>
> I've often gone back to my OWN code 2 days later and been unable to figure
> out what the heck I was doing .
>
> -mk
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 10:28 PM
> To: CF-Talk
> Subject: Re: updating problem
>
>
> True, it does make it easy, but that doesn't make it a good .. don't get
me
> wrong ..I have been guilty of using it but if you passed me over your
code,
> I would have to look at the database to figure out what * represented.  If
> you come back to the application 1 year from now (shoot in my place 1
month)
> and you could forget what * represented and thus you have to look at the
> database .. to figure out what and where the problem(s) may be ... after
> spending time opening and going back and forth in the database your time
> saved has now become time lost 
>
> I guess the way "I" look at it is that it doesn't hurt and if you are
> caching the query, why does it matter if you are using a * or not?
>
> Anyway, I guess to each his own :)
>
> Best of Luck!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
>
> > On *s... I think sometimes they have a place. I'll sometimes write a
> > query to get say a person's record from the db and reuse it in various
> > different pieces of code, where each piece requires different info from
> > the record. I could write ten queries, or I could write one and take
> > advantage of CF query caching.
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 18 April 2002 3:14 p.m.
> > To: CF-Talk
> > Subject: Re: updating problem
> >
> >
> > First off
> >
> > Your update query should look like this and NOT use a *  (you shouldn't
> > use
> > *'s they are poor coding, spell everything out)
> >
> > 
> > Update tablename
> > set column1 = '#form.column1#',
> >  column2 = '#form.column2#',
> > column3 = '#form.column3#'
> > where id = id
> > 
> > Note a few things.
> > 1) If you have more than one column being updated they are always
> > followed
> > by a comma , (seperating them)
> > 2) strings are surrounded by single quotes ' and numeric/date values are
> > without single quotes
> >
> > Try that out and let us know ...
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> > - Original Message -
> > From: "Judy" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 10:06 PM
> > Subject: updating problem
> >
> >
> > > I'm in desparate need of help. I'm doing my first CF application and
> > it's
> > not going so well. My database is in SQL.
> > >
> > > So far, I have an eventlist.cfm file containing a list of all our
> > events.
> > This page has an "Edit" link which takes me to an "update event" input
> > form.
> > When I click it, the link takes me to a blank form - I need it to pull
> > up
> > the form already filled in with the existing information so we can make
> > changes to it. The primary key for the Events table is called ID and is
> > an
> > AutoNumber type.
> > >
> > > There's also a Delete link on the eventlist.cfm page that doesn't
> > delete
> > anything out of my database and I can't figure out how to do it.
> > >
> > > Here is the code in the eventlist.cfm file:
> > >
> > > 
> > > 
> > > SELECT *
> > > FROM Events
> > > WHERE ID = ID
> > > 
> > > 
> > >
> > >
> > > 
> > > 
> > >
> > > 
> > >  
> > >   
> > >#title#
> > > Updated on: #updatedon#
> > >   
> > >   
> > >Preview
> > >Edit
> > >Delete
> > >
> > >Inactive?  > notchecked>
> > >   
> > >  
> > > 
> > > 
> > > 
> > >
> > > Here is some of the code in my updateform.cfm file.
> > >
> > > 
> > > 
> > > SELECT *
> > > FROM Events
> > > 
> > > 
> > >
> > > 
> > > 
> > >  
> > >
> > > Finally, here is the code in my updateaction.cfm file.
> > >
> > > 
> > > UPDATE Events
> > > SET *
> > > WHERE Events.ID = #URL.ID#
> > > 
> > >
> > >
> > > 
> > > 
> > >  Update Event
> > > 
> > >
> > > 
> > >
> > > Event Updated
> > > 
> > > You have updated the information for #Form.Title# in the Events
> > database.
> > > 
> > > 
> > > Edit another event
> > > 
> > > 
> > > Return to website
> > > 
> > >
> > >
> > > I hope someone can help me - I'm going crazy trying to figure this all
> > out.
> > >
> > > Thanks, Judy
> > >
> > >
> >
> >
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://

RE: updating problem

[Mark A. Kruger - CFG]

Judy,

I'm not sure what you are getting at.  Do you mean, how do you populate the
form text boxes with data from your query? Or with data from the submitted
form? some sample code might be helpful.

mark

-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:38 PM
To: CF-Talk
Subject: Re: updating problem


Thanks for the quick responses. I changed my update query as both Paul and
Matthew suggested, but when I click on my Edit link in the eventlist.cfm
file, I'm still just pulling up a blank update form. I can see up in the
address bar that it is ID=4, for example which is the right record. How do I
get all the existing information to appear in the boxes?


- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:22 PM
Subject: RE: updating problem


> On *s... I think sometimes they have a place. I'll sometimes write a
> query to get say a person's record from the db and reuse it in various
> different pieces of code, where each piece requires different info from
> the record. I could write ten queries, or I could write one and take
> advantage of CF query caching.
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 3:14 p.m.
> To: CF-Talk
> Subject: Re: updating problem
>
>
> First off
>
> Your update query should look like this and NOT use a *  (you shouldn't
> use
> *'s they are poor coding, spell everything out)
>
> 
> Update tablename
> set column1 = '#form.column1#',
>  column2 = '#form.column2#',
> column3 = '#form.column3#'
> where id = id
> 
> Note a few things.
> 1) If you have more than one column being updated they are always
> followed
> by a comma , (seperating them)
> 2) strings are surrounded by single quotes ' and numeric/date values are
> without single quotes
>
> Try that out and let us know ...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:06 PM
> Subject: updating problem
>
>
> > I'm in desparate need of help. I'm doing my first CF application and
> it's
> not going so well. My database is in SQL.
> >
> > So far, I have an eventlist.cfm file containing a list of all our
> events.
> This page has an "Edit" link which takes me to an "update event" input
> form.
> When I click it, the link takes me to a blank form - I need it to pull
> up
> the form already filled in with the existing information so we can make
> changes to it. The primary key for the Events table is called ID and is
> an
> AutoNumber type.
> >
> > There's also a Delete link on the eventlist.cfm page that doesn't
> delete
> anything out of my database and I can't figure out how to do it.
> >
> > Here is the code in the eventlist.cfm file:
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > WHERE ID = ID
> > 
> > 
> >
> >
> > 
> > 
> >
> > 
> >  
> >   
> >#title#
> > Updated on: #updatedon#
> >   
> >   
> >Preview
> >Edit
> >Delete
> >
> >Inactive?  notchecked>
> >   
> >  
> > 
> > 
> > 
> >
> > Here is some of the code in my updateform.cfm file.
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > 
> > 
> >
> > 
> > 
> >  
> >
> > Finally, here is the code in my updateaction.cfm file.
> >
> > 
> > UPDATE Events
> > SET *
> > WHERE Events.ID = #URL.ID#
> > 
> >
> >
> > 
> > 
> >  Update Event
> > 
> >
> > 
> >
> > Event Updated
> > 
> > You have updated the information for #Form.Title# in the Events
> database.
> > 
> > 
> > Edit another event
> > 
> > 
> > Return to website
> > 
> >
> >
> > I hope someone can help me - I'm going crazy trying to figure this all
> out.
> >
> > Thanks, Judy
> >
> >
>
>

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

Re: updating problem

[Paul Giesenhagen]

 
 
 SELECT *
 FROM Events
 
 

 
 
  


Ok you need to add a WHERE clause WHERE ID = #url.id# to your query...

Give that a shot!

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


- Original Message -
From: "Judy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 10:37 PM
Subject: Re: updating problem


> Thanks for the quick responses. I changed my update query as both Paul and
> Matthew suggested, but when I click on my Edit link in the eventlist.cfm
> file, I'm still just pulling up a blank update form. I can see up in the
> address bar that it is ID=4, for example which is the right record. How do
I
> get all the existing information to appear in the boxes?
>
>
> - Original Message -
> From: "Matthew Walker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 11:22 PM
> Subject: RE: updating problem
>
>
> > On *s... I think sometimes they have a place. I'll sometimes write a
> > query to get say a person's record from the db and reuse it in various
> > different pieces of code, where each piece requires different info from
> > the record. I could write ten queries, or I could write one and take
> > advantage of CF query caching.
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 18 April 2002 3:14 p.m.
> > To: CF-Talk
> > Subject: Re: updating problem
> >
> >
> > First off
> >
> > Your update query should look like this and NOT use a *  (you shouldn't
> > use
> > *'s they are poor coding, spell everything out)
> >
> > 
> > Update tablename
> > set column1 = '#form.column1#',
> >  column2 = '#form.column2#',
> > column3 = '#form.column3#'
> > where id = id
> > 
> > Note a few things.
> > 1) If you have more than one column being updated they are always
> > followed
> > by a comma , (seperating them)
> > 2) strings are surrounded by single quotes ' and numeric/date values are
> > without single quotes
> >
> > Try that out and let us know ...
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> > - Original Message -
> > From: "Judy" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 10:06 PM
> > Subject: updating problem
> >
> >
> > > I'm in desparate need of help. I'm doing my first CF application and
> > it's
> > not going so well. My database is in SQL.
> > >
> > > So far, I have an eventlist.cfm file containing a list of all our
> > events.
> > This page has an "Edit" link which takes me to an "update event" input
> > form.
> > When I click it, the link takes me to a blank form - I need it to pull
> > up
> > the form already filled in with the existing information so we can make
> > changes to it. The primary key for the Events table is called ID and is
> > an
> > AutoNumber type.
> > >
> > > There's also a Delete link on the eventlist.cfm page that doesn't
> > delete
> > anything out of my database and I can't figure out how to do it.
> > >
> > > Here is the code in the eventlist.cfm file:
> > >
> > > 
> > > 
> > > SELECT *
> > > FROM Events
> > > WHERE ID = ID
> > > 
> > > 
> > >
> > >
> > > 
> > > 
> > >
> > > 
> > >  
> > >   
> > >#title#
> > > Updated on: #updatedon#
> > >   
> > >   
> > >Preview
> > >Edit
> > >Delete
> > >
> > >Inactive?  > notchecked>
> > >   
> > >  
> > > 
> > > 
> > > 
> > >
> > > Here is some of the code in my updateform.cfm file.
> > >
> > > 
> > > 
> > > SELECT *
> > > FROM Events
> > > 
> > > 
> > >
> > > 
> > > 
> > >  
> > >
> > > Finally, here is the code in my updateaction.cfm file.
> > >
> > > 
> > > UPDATE Events
> > > SET *
> > > WHERE Events.ID = #URL.ID#
> > > 
> > >
> > >
> > > 
> > > 
> > >  Update Event
> > > 
> > >
> > > 
> > >
> > > Event Updated
> > > 
> > > You have updated the information for #Form.Title# in the Events
> > database.
> > > 
> > > 
> > > Edit another event
> > > 
> > > 
> > > Return to website
> > > 
> > >
> > >
> > > I hope someone can help me - I'm going crazy trying to figure this all
> > out.
> > >
> > > Thanks, Judy
> > >
> > >
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: updating problem

[Mark A. Kruger - CFG]

Paul,

I've often gone back to my OWN code 2 days later and been unable to figure
out what the heck I was doing .

-mk

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:28 PM
To: CF-Talk
Subject: Re: updating problem


True, it does make it easy, but that doesn't make it a good .. don't get me
wrong ..I have been guilty of using it but if you passed me over your code,
I would have to look at the database to figure out what * represented.  If
you come back to the application 1 year from now (shoot in my place 1 month)
and you could forget what * represented and thus you have to look at the
database .. to figure out what and where the problem(s) may be ... after
spending time opening and going back and forth in the database your time
saved has now become time lost 

I guess the way "I" look at it is that it doesn't hurt and if you are
caching the query, why does it matter if you are using a * or not?

Anyway, I guess to each his own :)

Best of Luck!

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



> On *s... I think sometimes they have a place. I'll sometimes write a
> query to get say a person's record from the db and reuse it in various
> different pieces of code, where each piece requires different info from
> the record. I could write ten queries, or I could write one and take
> advantage of CF query caching.
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 3:14 p.m.
> To: CF-Talk
> Subject: Re: updating problem
>
>
> First off
>
> Your update query should look like this and NOT use a *  (you shouldn't
> use
> *'s they are poor coding, spell everything out)
>
> 
> Update tablename
> set column1 = '#form.column1#',
>  column2 = '#form.column2#',
> column3 = '#form.column3#'
> where id = id
> 
> Note a few things.
> 1) If you have more than one column being updated they are always
> followed
> by a comma , (seperating them)
> 2) strings are surrounded by single quotes ' and numeric/date values are
> without single quotes
>
> Try that out and let us know ...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:06 PM
> Subject: updating problem
>
>
> > I'm in desparate need of help. I'm doing my first CF application and
> it's
> not going so well. My database is in SQL.
> >
> > So far, I have an eventlist.cfm file containing a list of all our
> events.
> This page has an "Edit" link which takes me to an "update event" input
> form.
> When I click it, the link takes me to a blank form - I need it to pull
> up
> the form already filled in with the existing information so we can make
> changes to it. The primary key for the Events table is called ID and is
> an
> AutoNumber type.
> >
> > There's also a Delete link on the eventlist.cfm page that doesn't
> delete
> anything out of my database and I can't figure out how to do it.
> >
> > Here is the code in the eventlist.cfm file:
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > WHERE ID = ID
> > 
> > 
> >
> >
> > 
> > 
> >
> > 
> >  
> >   
> >#title#
> > Updated on: #updatedon#
> >   
> >   
> >Preview
> >Edit
> >Delete
> >
> >Inactive?  notchecked>
> >   
> >  
> > 
> > 
> > 
> >
> > Here is some of the code in my updateform.cfm file.
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > 
> > 
> >
> > 
> > 
> >  
> >
> > Finally, here is the code in my updateaction.cfm file.
> >
> > 
> > UPDATE Events
> > SET *
> > WHERE Events.ID = #URL.ID#
> > 
> >
> >
> > 
> > 
> >  Update Event
> > 
> >
> > 
> >
> > Event Updated
> > 
> > You have updated the information for #Form.Title# in the Events
> database.
> > 
> > 
> > Edit another event
> > 
> > 
> > Return to website
> > 
> >
> >
> > I hope someone can help me - I'm going crazy trying to figure this all
> out.
> >
> > Thanks, Judy
> >
> >
>
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: updating problem

[Mark A. Kruger - CFG]

Matt,

I agree with you in some cases,  but it should be noted that an " * " comes
with a performance penalty when executing a query. The DB has to come up
with an execution plan that details the path the RDBMS is going to take to
retrieve your data. One of the reasons that a stored procedure is slightly
faster than a query is that this execution plan is decided on in advance and
stored along with the procedure. When you do a query with an  asterick, the
database must "lookup" the column names to complete its execution plan.  In
addition, there are cases where the column order can make a difference to
the speed of the retrieval (when retrieve long text).

Having said all that,  if your table is characterized as a "lookup" table
with a very simple schema, and you are using caching, the difference is
often negligable. Still, specifying column names is a VERY good practice if
you are working on a team or in any situation where someone else must help
maintain your code.  There is nothing more frustrating that seeing a query
that you have to work with - and not really knowing what's in it. That's one
basic reason why  is so popular (ha).

And I have to admit to being an occasional asterick user - when I'm in a
hurry.  Writing out all the column names is a pretty tedious chore, and when
you didn't design the database it often means working with naming
conventions that don't seem intuitive to you. So I guess (after a double
scotch) there IS a place for them after all.

Mark

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

Getting pages Timed Out

[Vishal Narayan]

Our ColdFusion Logs show pages getting timed out - it seems to happen at 
times of high traffic. We would like to be able to troubleshoot the source 
of the problem.

We have set the max number of simultaneous requests in ColdFusion 
Administrator to 15. Supposing we have a 16th simultaneous user, would they 
get an error message or would their page time out ? How does ColdFusion 
handle this ?

Vishal.

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: updating problem

[Judy]

Thanks for the quick responses. I changed my update query as both Paul and
Matthew suggested, but when I click on my Edit link in the eventlist.cfm
file, I'm still just pulling up a blank update form. I can see up in the
address bar that it is ID=4, for example which is the right record. How do I
get all the existing information to appear in the boxes?


- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 11:22 PM
Subject: RE: updating problem


> On *s... I think sometimes they have a place. I'll sometimes write a
> query to get say a person's record from the db and reuse it in various
> different pieces of code, where each piece requires different info from
> the record. I could write ten queries, or I could write one and take
> advantage of CF query caching.
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 3:14 p.m.
> To: CF-Talk
> Subject: Re: updating problem
>
>
> First off
>
> Your update query should look like this and NOT use a *  (you shouldn't
> use
> *'s they are poor coding, spell everything out)
>
> 
> Update tablename
> set column1 = '#form.column1#',
>  column2 = '#form.column2#',
> column3 = '#form.column3#'
> where id = id
> 
> Note a few things.
> 1) If you have more than one column being updated they are always
> followed
> by a comma , (seperating them)
> 2) strings are surrounded by single quotes ' and numeric/date values are
> without single quotes
>
> Try that out and let us know ...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:06 PM
> Subject: updating problem
>
>
> > I'm in desparate need of help. I'm doing my first CF application and
> it's
> not going so well. My database is in SQL.
> >
> > So far, I have an eventlist.cfm file containing a list of all our
> events.
> This page has an "Edit" link which takes me to an "update event" input
> form.
> When I click it, the link takes me to a blank form - I need it to pull
> up
> the form already filled in with the existing information so we can make
> changes to it. The primary key for the Events table is called ID and is
> an
> AutoNumber type.
> >
> > There's also a Delete link on the eventlist.cfm page that doesn't
> delete
> anything out of my database and I can't figure out how to do it.
> >
> > Here is the code in the eventlist.cfm file:
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > WHERE ID = ID
> > 
> > 
> >
> >
> > 
> > 
> >
> > 
> >  
> >   
> >#title#
> > Updated on: #updatedon#
> >   
> >   
> >Preview
> >Edit
> >Delete
> >
> >Inactive?  notchecked>
> >   
> >  
> > 
> > 
> > 
> >
> > Here is some of the code in my updateform.cfm file.
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > 
> > 
> >
> > 
> > 
> >  
> >
> > Finally, here is the code in my updateaction.cfm file.
> >
> > 
> > UPDATE Events
> > SET *
> > WHERE Events.ID = #URL.ID#
> > 
> >
> >
> > 
> > 
> >  Update Event
> > 
> >
> > 
> >
> > Event Updated
> > 
> > You have updated the information for #Form.Title# in the Events
> database.
> > 
> > 
> > Edit another event
> > 
> > 
> > Return to website
> > 
> >
> >
> > I hope someone can help me - I'm going crazy trying to figure this all
> out.
> >
> > Thanks, Judy
> >
> >
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: updating problem

[Paul Giesenhagen]

True, it does make it easy, but that doesn't make it a good .. don't get me
wrong ..I have been guilty of using it but if you passed me over your code,
I would have to look at the database to figure out what * represented.  If
you come back to the application 1 year from now (shoot in my place 1 month)
and you could forget what * represented and thus you have to look at the
database .. to figure out what and where the problem(s) may be ... after
spending time opening and going back and forth in the database your time
saved has now become time lost 

I guess the way "I" look at it is that it doesn't hurt and if you are
caching the query, why does it matter if you are using a * or not?

Anyway, I guess to each his own :)

Best of Luck!

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



> On *s... I think sometimes they have a place. I'll sometimes write a
> query to get say a person's record from the db and reuse it in various
> different pieces of code, where each piece requires different info from
> the record. I could write ten queries, or I could write one and take
> advantage of CF query caching.
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 April 2002 3:14 p.m.
> To: CF-Talk
> Subject: Re: updating problem
>
>
> First off
>
> Your update query should look like this and NOT use a *  (you shouldn't
> use
> *'s they are poor coding, spell everything out)
>
> 
> Update tablename
> set column1 = '#form.column1#',
>  column2 = '#form.column2#',
> column3 = '#form.column3#'
> where id = id
> 
> Note a few things.
> 1) If you have more than one column being updated they are always
> followed
> by a comma , (seperating them)
> 2) strings are surrounded by single quotes ' and numeric/date values are
> without single quotes
>
> Try that out and let us know ...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> - Original Message -
> From: "Judy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 10:06 PM
> Subject: updating problem
>
>
> > I'm in desparate need of help. I'm doing my first CF application and
> it's
> not going so well. My database is in SQL.
> >
> > So far, I have an eventlist.cfm file containing a list of all our
> events.
> This page has an "Edit" link which takes me to an "update event" input
> form.
> When I click it, the link takes me to a blank form - I need it to pull
> up
> the form already filled in with the existing information so we can make
> changes to it. The primary key for the Events table is called ID and is
> an
> AutoNumber type.
> >
> > There's also a Delete link on the eventlist.cfm page that doesn't
> delete
> anything out of my database and I can't figure out how to do it.
> >
> > Here is the code in the eventlist.cfm file:
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > WHERE ID = ID
> > 
> > 
> >
> >
> > 
> > 
> >
> > 
> >  
> >   
> >#title#
> > Updated on: #updatedon#
> >   
> >   
> >Preview
> >Edit
> >Delete
> >
> >Inactive?  notchecked>
> >   
> >  
> > 
> > 
> > 
> >
> > Here is some of the code in my updateform.cfm file.
> >
> > 
> > 
> > SELECT *
> > FROM Events
> > 
> > 
> >
> > 
> > 
> >  
> >
> > Finally, here is the code in my updateaction.cfm file.
> >
> > 
> > UPDATE Events
> > SET *
> > WHERE Events.ID = #URL.ID#
> > 
> >
> >
> > 
> > 
> >  Update Event
> > 
> >
> > 
> >
> > Event Updated
> > 
> > You have updated the information for #Form.Title# in the Events
> database.
> > 
> > 
> > Edit another event
> > 
> > 
> > Return to website
> > 
> >
> >
> > I hope someone can help me - I'm going crazy trying to figure this all
> out.
> >
> > Thanks, Judy
> >
> >
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: updating problem

[Matthew Walker]

On *s... I think sometimes they have a place. I'll sometimes write a
query to get say a person's record from the db and reuse it in various
different pieces of code, where each piece requires different info from
the record. I could write ten queries, or I could write one and take
advantage of CF query caching. 



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 3:14 p.m.
To: CF-Talk
Subject: Re: updating problem


First off

Your update query should look like this and NOT use a *  (you shouldn't
use
*'s they are poor coding, spell everything out)


Update tablename
set column1 = '#form.column1#',
 column2 = '#form.column2#',
column3 = '#form.column3#'
where id = id

Note a few things.
1) If you have more than one column being updated they are always
followed
by a comma , (seperating them)
2) strings are surrounded by single quotes ' and numeric/date values are
without single quotes

Try that out and let us know ...

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


- Original Message -
From: "Judy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 10:06 PM
Subject: updating problem


> I'm in desparate need of help. I'm doing my first CF application and
it's
not going so well. My database is in SQL.
>
> So far, I have an eventlist.cfm file containing a list of all our
events.
This page has an "Edit" link which takes me to an "update event" input
form.
When I click it, the link takes me to a blank form - I need it to pull
up
the form already filled in with the existing information so we can make
changes to it. The primary key for the Events table is called ID and is
an
AutoNumber type.
>
> There's also a Delete link on the eventlist.cfm page that doesn't
delete
anything out of my database and I can't figure out how to do it.
>
> Here is the code in the eventlist.cfm file:
>
> 
> 
> SELECT *
> FROM Events
> WHERE ID = ID
> 
> 
>
>
> 
> 
>
> 
>  
>   
>#title#
> Updated on: #updatedon#
>   
>   
>Preview
>Edit
>Delete
>
>Inactive? 
>   
>  
> 
> 
> 
>
> Here is some of the code in my updateform.cfm file.
>
> 
> 
> SELECT *
> FROM Events
> 
> 
>
> 
> 
>  
>
> Finally, here is the code in my updateaction.cfm file.
>
> 
> UPDATE Events
> SET *
> WHERE Events.ID = #URL.ID#
> 
>
>
> 
> 
>  Update Event
> 
>
> 
>
> Event Updated
> 
> You have updated the information for #Form.Title# in the Events
database.
> 
> 
> Edit another event
> 
> 
> Return to website
> 
>
>
> I hope someone can help me - I'm going crazy trying to figure this all
out.
>
> Thanks, Judy
>
> 

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

RE: updating problem

[Tony Gruen]

check your output row on your initial page. Looks like you have the initial
CFOUTPUT outside the table tag. Should be inside it so that the row is
repeated for each record.

T


-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 8:06 PM
To: CF-Talk
Subject: updating problem


I'm in desparate need of help. I'm doing my first CF application and it's
not going so well. My database is in SQL.

So far, I have an eventlist.cfm file containing a list of all our events.
This page has an "Edit" link which takes me to an "update event" input form.
When I click it, the link takes me to a blank form - I need it to pull up
the form already filled in with the existing information so we can make
changes to it. The primary key for the Events table is called ID and is an
AutoNumber type.

There's also a Delete link on the eventlist.cfm page that doesn't delete
anything out of my database and I can't figure out how to do it.

Here is the code in the eventlist.cfm file:



SELECT *
FROM Events
WHERE ID = ID








 
  
   #title#
Updated on: #updatedon#
  
  
   Preview
   Edit
   Delete
   
   Inactive? 
  
 




Here is some of the code in my updateform.cfm file.



SELECT *
FROM Events





 

Finally, here is the code in my updateaction.cfm file.


UPDATE Events
SET *
WHERE Events.ID = #URL.ID#





 Update Event




Event Updated

You have updated the information for #Form.Title# in the Events database.


Edit another event


Return to website



I hope someone can help me - I'm going crazy trying to figure this all out.

Thanks, Judy


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

Re: updating problem

[Paul Giesenhagen]

First off

Your update query should look like this and NOT use a *  (you shouldn't use
*'s they are poor coding, spell everything out)


Update tablename
set column1 = '#form.column1#',
 column2 = '#form.column2#',
column3 = '#form.column3#'
where id = id

Note a few things.
1) If you have more than one column being updated they are always followed
by a comma , (seperating them)
2) strings are surrounded by single quotes ' and numeric/date values are
without single quotes

Try that out and let us know ...

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


- Original Message -
From: "Judy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 10:06 PM
Subject: updating problem


> I'm in desparate need of help. I'm doing my first CF application and it's
not going so well. My database is in SQL.
>
> So far, I have an eventlist.cfm file containing a list of all our events.
This page has an "Edit" link which takes me to an "update event" input form.
When I click it, the link takes me to a blank form - I need it to pull up
the form already filled in with the existing information so we can make
changes to it. The primary key for the Events table is called ID and is an
AutoNumber type.
>
> There's also a Delete link on the eventlist.cfm page that doesn't delete
anything out of my database and I can't figure out how to do it.
>
> Here is the code in the eventlist.cfm file:
>
> 
> 
> SELECT *
> FROM Events
> WHERE ID = ID
> 
> 
>
>
> 
> 
>
> 
>  
>   
>#title#
> Updated on: #updatedon#
>   
>   
>Preview
>Edit
>Delete
>
>Inactive? 
>   
>  
> 
> 
> 
>
> Here is some of the code in my updateform.cfm file.
>
> 
> 
> SELECT *
> FROM Events
> 
> 
>
> 
> 
>  
>
> Finally, here is the code in my updateaction.cfm file.
>
> 
> UPDATE Events
> SET *
> WHERE Events.ID = #URL.ID#
> 
>
>
> 
> 
>  Update Event
> 
>
> 
>
> Event Updated
> 
> You have updated the information for #Form.Title# in the Events database.
> 
> 
> Edit another event
> 
> 
> Return to website
> 
>
>
> I hope someone can help me - I'm going crazy trying to figure this all
out.
>
> Thanks, Judy
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: updating problem

[Matthew Walker]

That looks pretty good. Your update query is wrong. Needs to be more
like this:


UPDATE  Events
SET foo = '#Form.Foo#',
bar = '#Form.Bar#' ...
WHERE   Events.ID = #URL.ID#


Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New Zealand

http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/



-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 3:06 p.m.
To: CF-Talk
Subject: updating problem


I'm in desparate need of help. I'm doing my first CF application and
it's not going so well. My database is in SQL.

So far, I have an eventlist.cfm file containing a list of all our
events. This page has an "Edit" link which takes me to an "update event"
input form. When I click it, the link takes me to a blank form - I need
it to pull up the form already filled in with the existing information
so we can make changes to it. The primary key for the Events table is
called ID and is an AutoNumber type.

There's also a Delete link on the eventlist.cfm page that doesn't delete
anything out of my database and I can't figure out how to do it.

Here is the code in the eventlist.cfm file:



SELECT *
FROM Events
WHERE ID = ID








 
  
   #title#
Updated on: #updatedon#
  
  
   Preview
   Edit
   Delete
   
   Inactive? 
  
 




Here is some of the code in my updateform.cfm file.



SELECT *
FROM Events





 

Finally, here is the code in my updateaction.cfm file.


UPDATE Events
SET *
WHERE Events.ID = #URL.ID#

 
 


 Update Event




Event Updated

You have updated the information for #Form.Title# in the Events
database.


Edit another event


Return to website



I hope someone can help me - I'm going crazy trying to figure this all
out.

Thanks, Judy


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

updating problem

[Judy]

I'm in desparate need of help. I'm doing my first CF application and it's not going so 
well. My database is in SQL.

So far, I have an eventlist.cfm file containing a list of all our events. This page 
has an "Edit" link which takes me to an "update event" input form. When I click it, 
the link takes me to a blank form - I need it to pull up the form already filled in 
with the existing information so we can make changes to it. The primary key for the 
Events table is called ID and is an AutoNumber type.

There's also a Delete link on the eventlist.cfm page that doesn't delete anything out 
of my database and I can't figure out how to do it.

Here is the code in the eventlist.cfm file:



SELECT *
FROM Events
WHERE ID = ID








 
  
   #title#
Updated on: #updatedon#
  
  
   Preview
   Edit
   Delete
   
   Inactive? 
  
 




Here is some of the code in my updateform.cfm file.



SELECT *
FROM Events





 

Finally, here is the code in my updateaction.cfm file.


UPDATE Events
SET *
WHERE Events.ID = #URL.ID#

 
 


 Update Event




Event Updated

You have updated the information for #Form.Title# in the Events database.


Edit another event


Return to website



I hope someone can help me - I'm going crazy trying to figure this all out.

Thanks, Judy

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

Re: CF MX

[Neil H.]

Yes I am part of the beta program however me emails do not reference the
forums.. NM I think I figured it out.

Neil

- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 10:23 PM
Subject: Re: CF MX


> Neil,
>
> You must be on the beta team to access the beta forums.
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
>
> > Dave,
> > I can't seem to find them  Could you direct me to them...
> >
> > Neil
> >
> > - Original Message -
> > From: "Dave Carabetta" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 7:52 PM
> > Subject: Re: CF MX
> >
> >
> > > If you're a part of the beta program, this question would probably be
> > better
> > > answered in the beta forums.
> > >
> > > Just a thought.
> > >
> > > Dave.
> > >
> > >
> > > - Original Message -
> > > From: "Neil H." <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 17, 2002 07:22 PM
> > > Subject: CF MX
> > >
> > >
> > > > Anyone know if I could setup a test box for Neo and allow people to
> test
> > > > pages on it?  I know the NDA is pretty thick but it isn't for profit
> > just
> > > > for testing.  Maybe a MM employee could shed some light or point me
to
> > an
> > > > address to inquire?
> > > >
> > > > Thanks,
> > > >
> > > > Neil
> > > >
> > > >
> > >
> >
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF MX

[Paul Giesenhagen]

Neil,

You must be on the beta team to access the beta forums.

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



> Dave,
> I can't seem to find them  Could you direct me to them...
>
> Neil
>
> - Original Message -
> From: "Dave Carabetta" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 7:52 PM
> Subject: Re: CF MX
>
>
> > If you're a part of the beta program, this question would probably be
> better
> > answered in the beta forums.
> >
> > Just a thought.
> >
> > Dave.
> >
> >
> > - Original Message -
> > From: "Neil H." <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 17, 2002 07:22 PM
> > Subject: CF MX
> >
> >
> > > Anyone know if I could setup a test box for Neo and allow people to
test
> > > pages on it?  I know the NDA is pretty thick but it isn't for profit
> just
> > > for testing.  Maybe a MM employee could shed some light or point me to
> an
> > > address to inquire?
> > >
> > > Thanks,
> > >
> > > Neil
> > >
> > >
> >
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF MX

[Neil H.]

Dave,
I can't seem to find them  Could you direct me to them...

Neil

- Original Message -
From: "Dave Carabetta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 7:52 PM
Subject: Re: CF MX


> If you're a part of the beta program, this question would probably be
better
> answered in the beta forums.
>
> Just a thought.
>
> Dave.
>
>
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 07:22 PM
> Subject: CF MX
>
>
> > Anyone know if I could setup a test box for Neo and allow people to test
> > pages on it?  I know the NDA is pretty thick but it isn't for profit
just
> > for testing.  Maybe a MM employee could shed some light or point me to
an
> > address to inquire?
> >
> > Thanks,
> >
> > Neil
> >
> >
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

change IP address failed to startup CF

[Mak Wing Lok]

i want to change the production server IP from 203.121.13.138 to 10.1.4.15,
as i had tried it out on the development server i found out that other than
changing the server IP address, i need to reconfigure apache server, i need
to change the LDAP IP settings, etc, but after all these changes i failed to
startup the CF advanced security features/siteminder, i get this message
when i startup CF server :

Apr 18 08:49:47 ehealth4all SiteMinder[19785]: CATEGORY: 1  Object Store
failed operation 'ProviderInit' for object type 'Object Store Provider'.
Exception: ''
Apr 18 08:49:47 ehealth4all SiteMinder[19785]: CATEGORY: 1  Object Store
failed operation 'ProviderInit' for object type 'Object Store Provider'.
Exception: ''
Apr 18 08:49:47 ehealth4all SiteMinder[19785]: CATEGORY: 1  Object Store
failed operation 'ProviderInit' for object type 'Object Store Provider'.
Exception: ''
Apr 18 08:49:47 ehealth4all SiteMinder[19780]: CATEGORY: 3  Object Store
failed operation 'ProviderInit' for object type 'Object Store Provider'.
Exception: ''
Apr 18 08:49:47 ehealth4all SiteMinder[19780]: CATEGORY: 3  Object Store
failed operation 'ProviderInit' for object type 'Object Store Provider'.
Exception: ''
Apr 18 08:49:47 ehealth4all SiteMinder[19780]: CATEGORY: 3  Object Store
failed operation 'ProviderInit' for object type 'Object Store Provider'.
Exception: ''
ERROR: Siteminder daemon SMSERVAZ failed to start!

any idea what else i need to do?

--- 
"Pharmaniaga Berhad, your integrated healthcare provider"
www.pharmaniaga.com.my 
"www.ehealth4all.com, your most convenient way to healthcare, everyday..." 
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential or privileged material.
If you received this in error, please contact the sender and delete the
material from any computer. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. 
---
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: TopStyle2.5 with CF Stu 5

[Chuck McElwee]

Inside TopStyle under Options / Configure External Programs you are supposed
to be able to set up the Studio link.  I was unable to configure it that
way, but if you re-install 2.5, it should detect Studio and be integrated
the same way the lite version was.

Chuck McElwee
etech solutions inc
www.etechsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 8:22 AM
To: CF-Talk
Subject: RE: TopStyle2.5 with CF Stu 5


its win2k

what i am talking about is when your in studio.
you right click on a tag.

then you can edit its styles by Studio pulling open topstyle
but i want it to use the newer version.

cant find a setting for it


-paul



-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 7:59 AM
To: CF-Talk
Subject: RE: TopStyle2.5 with CF Stu 5


what OS?

(w2k, right click a .css file>>open with>>choose program)

Craig

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 7:40 AM
To: CF-Talk
Subject: TopStyle2.5 with CF Stu 5


ok i did a bad thing
i deleted TopStyle2.1 before i check whether 2.5 would work with in cf
studio
i can find where to change what app is used for css..

any one know where?
thanks

-paul




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

Re: Threaded list integration

[Jim McAtee]

In my experience a forums application (threaded or not) works better than
mailing lists for exchanging project information.  Most forums already have
extensive search capabilities built in.  If you need this-second
notification of new posts, many offer e-mail notification for participants
in a given thread.  The only area you may need to address is that of
security.  For instance, if you wanted only certain eyes to view certain
threads.  Not all forums applications have that capability.

Jim


- Original Message -
From: "John Anderson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 3:03 PM
Subject: Threaded list integration


> I have recently been asked to implement some type of list solution using
> (Outlook) and ColdFusion.  The requirements are as follows:
>
> They want to set up a mail box for a number of projects
> example [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
>
> Users can subscribe to any of the lists.
>
> Users can view/search threads using CF on the company intranet.  Just like
> the current cf-talk list.
>
> My main question is this:
> Is there an easy way to do this with Outlook? (I have seen some stuff on
the
> comet site)
> Would it be better to implement some type of listserve software?
>
> If anyone has some experience with this sort of thing that would be great!
>
> Thanks,
> John
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF MX

[Dave Carabetta]

If you're a part of the beta program, this question would probably be better
answered in the beta forums.

Just a thought.

Dave.


- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 07:22 PM
Subject: CF MX


> Anyone know if I could setup a test box for Neo and allow people to test
> pages on it?  I know the NDA is pretty thick but it isn't for profit just
> for testing.  Maybe a MM employee could shed some light or point me to an
> address to inquire?
>
> Thanks,
>
> Neil
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF MX

[Neil H.]

Anyone know if I could setup a test box for Neo and allow people to test
pages on it?  I know the NDA is pretty thick but it isn't for profit just
for testing.  Maybe a MM employee could shed some light or point me to an
address to inquire?

Thanks,

Neil

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

Re: IE 6.0 Bug

[Matt Robertson]

On my dev box it works fine.  Charming.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: Sam Roach <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 17 Apr 2002 15:16:15 -0700

http://online.securityfocus.com/archive/1/267561

has anyone tried this?

-- Sam

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

RE: Custom tag (here it is)

[Matthew Walker]

Here's a non-recursive version. I haven't turned it into a custom tag.
It's just a block of code. I might finish it and put it up as a custom
tag on http://www.matthewwalker.net.nz


























#TotalSize#





-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 April 2002 9:02 a.m.
To: CF-Talk
Subject: Custom tag (here it is)


























  

 

This tag works for smaller directorys (ie 35 folders (nested 3 deep)
with 114 files) but it seems to start to lose count on bigger
directories IE 200 + folders and  1000 + files

 

Any ideas. 

 

All I need is the size of all the files in the folders and sub folders.
I tried the filesystem COM object but it didn't like working across the
network shares.

 

Any idea on that would help too! 

 

Kevin

 

 

 

 



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

IE 6.0 Bug

[Sam Roach]

http://online.securityfocus.com/archive/1/267561

has anyone tried this?

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

RE: guest-login

[Joshua Tipton]

Create a different session variable for that part and check it when they
click on that item or items or create another application.cfm in the
other directory and have a totally different application name for the
other app.

Josh

-Original Message-
From: cf-talk [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 5:49 PM
To: CF-Talk
Subject: guest-login

Hi list,
I have two directories secure_A
and secure_B
In both users have to login. After login I ask if the user
is logged in via sessionmanagement an a valid application.cfm
file in each directory.
In directory secure_B people use a guest-login.
Right now people who logged in in secure_B are still able to use
functions of secure_A. How can I avoid this ?
When people who are using their guest-login klick on certain files of
secure_A they must get the login mask again.
Do you know, how I can accomplish this ? Thanks.
Uwe

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

RE: atswebnet

[Clint Tredway]

Yes, mine is down.. but its back up now as I got this mail through their
mail server.

Clint

-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:56 PM
To: CF-Talk
Subject: atswebnet


Any other atswebnet folks gone dead? Even there main site is downmail
too!


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

Re: atswebnet

[Cold Fusion]

Mine is up.

- Original Message -
From: "Michael Ross" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 4:55 PM
Subject: atswebnet


> Any other atswebnet folks gone dead? Even there main site is downmail
too!
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: atswebnet

[David Hannum \(Ohio University\)]

At 5:48 pm all of my sites there are fine.  I have three small ones.

Dave


- Original Message -
From: "Michael Ross" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 4:55 PM
Subject: atswebnet


> Any other atswebnet folks gone dead? Even there main site is downmail
too!
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

guest-login

[cf-talk]

Hi list,
I have two directories secure_A
and secure_B
In both users have to login. After login I ask if the user
is logged in via sessionmanagement an a valid application.cfm
file in each directory.
In directory secure_B people use a guest-login.
Right now people who logged in in secure_B are still able to use
functions of secure_A. How can I avoid this ?
When people who are using their guest-login klick on certain files of secure_A they 
must get the login mask again.
Do you know, how I can accomplish this ? Thanks.
Uwe
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: weird insert/update error

[Christopher Olive]

i remember this as well.  my CEO had the same problem (he dabbles in programming).

make sure IUSR_MACHINENAME has write perms to the directory in which the MDB file 
resides.  it needs them to create the LDB file.  this is, of course, if you have 
anonymous access enabled.

if you search MS's site, they give 4 or 5 possible solutions to this problem.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:59 PM
To: CF-Talk
Subject: RE: weird insert/update error


just right click on the database file you copied over.
make sure the web client or what ever your server calls it has read/write
privileges to the db.

that's it.

-paul



-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:44 PM
To: CF-Talk
Subject: RE: weird insert/update error


I am receiving the same error message after migrating an app from my laptop
(wok, CIF, Silk) to our dev box (same).  Can you tell me what permissions
needed to be reset/set? All seems to be in order. (I have also checked, per
earlier comment, both MAC versions and they are the same (2.6). did this
help you at all?)

-Craig Thomas

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:23 PM
To: CF-Talk
Subject: RE: weird insert/update error


found the problem

when i copied the files & the data base to the server, the file permissions
where reset.
i had to allow web users to be able to write to the database.

kind of odd, never ran into this before.

should be fine now.


-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:50 AM
To: CF-Talk
Subject: RE: weird insert/update error


no.  download the MDAC checker from MS (http://www.microsoft.com/mdac) and
run it at the server console.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:27 AM
To: CF-Talk
Subject: RE: weird insert/update error


ok.

can i do that in cf admin?

-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:06 AM
To: CF-Talk
Subject: RE: weird insert/update error


check the MDAC version on the production box.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:31 AM
To: CF-Talk
Subject: weird insert/update error


ok i have this little app.
runs just fine on my local host using cf 5.0 server

it also runs just fine on our cf 4.51 production server winNT

but when i move it to a 5.0 production server that is win2k
i get the error below

same files, same db, same odbc's...
any ideas.

thanks

-paul

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.



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







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

RE: Threaded list integration

[Rick Eidson]

Isn't that great...

Communitech hosting Company sucks!

Rick


-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:24 PM
To: CF-Talk
Subject: RE: Threaded list integration


Rick,




Error Occurred While Processing Request
Error Diagnostic Information
Just in time compilation error

unknown parser error

The last successfully parsed CFML construct was the CFML template
beginning occupying document position (1:1) to (1:1).

The specific sequence of files included or processed is:
E:\home\mybluee\public_html\Application.cfm  


Date/Time: 04/17/02 16:10:30
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address: 216.81.190.237

 







Kevin


-Original Message-
From: Rick Eidson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 4:11 PM
To: CF-Talk
Subject: RE: Threaded list integration

I have built (building) one in CF. 

Setup mailbox in Exchange Server check it with a CF schedule using CFPOP
load it in a database. Then build a CF front-end to moderate the
messages
and send emails to the list using CFMAIL. All against the database so
its
searchable, editable and you can thread it.

Look at http://www.blueear.com the whole site is ran from Exchange, CF
and
SQL Server.

Rick Eidson

-Original Message-
From: John Anderson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:04 PM
To: CF-Talk
Subject: Threaded list integration


I have recently been asked to implement some type of list solution using
(Outlook) and ColdFusion.  The requirements are as follows:

They want to set up a mail box for a number of projects
example [EMAIL PROTECTED]
  [EMAIL PROTECTED]

Users can subscribe to any of the lists.

Users can view/search threads using CF on the company intranet.  Just
like
the current cf-talk list.

My main question is this:
Is there an easy way to do this with Outlook? (I have seen some stuff on
the
comet site)
Would it be better to implement some type of listserve software?

If anyone has some experience with this sort of thing that would be
great!

Thanks,
John



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

RE: Fourm DB Design & Examples

[Mike Brunt]

There is a Fusebox based Forum at www.sourceforge.net   I believe it is called
FB OpenForums and comes with MS Sql and Oracle scripts I think.

Kind Regards - Mike Brunt, CTO
Webapper
http://www.webapper.com
Downey CA Office
"Webapper - Making the NET work"


-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:43 PM
To: CF-Talk
Subject: Fourm DB Design & Examples


I am trying to design a DB for use with a Foums ap that I am also designing.
Can anyone shed some light on a possible DB layout? Examples out there
anywhere?
*preferrably fusebox*

Thanks,
Mike




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

Re: Threaded list integration

[Tracy Bost]

 If they are using exchange server I would look first to what it has to offer 
before spending alot of time building something that it may already do what 
they need.





--
Visit "The Most Powerful Tool on the Farm" at http://www.ifarm.com
Get the latest on Ag News, Market Reports, FREE email, and much more.


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

RE: Threaded list integration

[Kevin Schmidt]

Rick,




Error Occurred While Processing Request
Error Diagnostic Information
Just in time compilation error

unknown parser error

The last successfully parsed CFML construct was the CFML template
beginning occupying document position (1:1) to (1:1).

The specific sequence of files included or processed is:
E:\home\mybluee\public_html\Application.cfm  


Date/Time: 04/17/02 16:10:30
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address: 216.81.190.237

 







Kevin


-Original Message-
From: Rick Eidson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 4:11 PM
To: CF-Talk
Subject: RE: Threaded list integration

I have built (building) one in CF. 

Setup mailbox in Exchange Server check it with a CF schedule using CFPOP
load it in a database. Then build a CF front-end to moderate the
messages
and send emails to the list using CFMAIL. All against the database so
its
searchable, editable and you can thread it.

Look at http://www.blueear.com the whole site is ran from Exchange, CF
and
SQL Server.

Rick Eidson

-Original Message-
From: John Anderson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:04 PM
To: CF-Talk
Subject: Threaded list integration


I have recently been asked to implement some type of list solution using
(Outlook) and ColdFusion.  The requirements are as follows:

They want to set up a mail box for a number of projects
example [EMAIL PROTECTED]
  [EMAIL PROTECTED]

Users can subscribe to any of the lists.

Users can view/search threads using CF on the company intranet.  Just
like
the current cf-talk list.

My main question is this:
Is there an easy way to do this with Outlook? (I have seen some stuff on
the
comet site)
Would it be better to implement some type of listserve software?

If anyone has some experience with this sort of thing that would be
great!

Thanks,
John


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

RE: Threaded list integration

[Rick Eidson]

I have built (building) one in CF. 

Setup mailbox in Exchange Server check it with a CF schedule using CFPOP
load it in a database. Then build a CF front-end to moderate the messages
and send emails to the list using CFMAIL. All against the database so its
searchable, editable and you can thread it.

Look at http://www.blueear.com the whole site is ran from Exchange, CF and
SQL Server.

Rick Eidson

-Original Message-
From: John Anderson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:04 PM
To: CF-Talk
Subject: Threaded list integration


I have recently been asked to implement some type of list solution using
(Outlook) and ColdFusion.  The requirements are as follows:

They want to set up a mail box for a number of projects
example [EMAIL PROTECTED]
  [EMAIL PROTECTED]

Users can subscribe to any of the lists.

Users can view/search threads using CF on the company intranet.  Just like
the current cf-talk list.

My main question is this:
Is there an easy way to do this with Outlook? (I have seen some stuff on the
comet site)
Would it be better to implement some type of listserve software?

If anyone has some experience with this sort of thing that would be great!

Thanks,
John

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

Threaded list integration

[John Anderson]

I have recently been asked to implement some type of list solution using
(Outlook) and ColdFusion.  The requirements are as follows:

They want to set up a mail box for a number of projects
example [EMAIL PROTECTED]
  [EMAIL PROTECTED]

Users can subscribe to any of the lists.

Users can view/search threads using CF on the company intranet.  Just like
the current cf-talk list.

My main question is this:
Is there an easy way to do this with Outlook? (I have seen some stuff on the
comet site)
Would it be better to implement some type of listserve software?

If anyone has some experience with this sort of thing that would be great!

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

Custom tag (here it is)

[Kevin Schmidt]

  

 

This tag works for smaller directorys (ie 35 folders (nested 3 deep)
with 114 files) but it seems to start to lose count on bigger
directories IE 200 + folders and  1000 + files

 

Any ideas. 

 

All I need is the size of all the files in the folders and sub folders.
I tried the filesystem COM object but it didn't like working across the
network shares.

 

Any idea on that would help too! 

 

Kevin

 

 

 

 


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

atswebnet

[Michael Ross]

Any other atswebnet folks gone dead? Even there main site is downmail too!

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

RE: Custom Tags question

[BillyC]

There's no magic number - probably there's some sort of a logic error or
timeout going on.

---
Billy Cravens


-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 3:04 PM
To: CF-Talk
Subject: Custom Tags question

Is there a maximum number of times a custom tag can be called?  I have a
custom tag that calls itself quite a few times in the process.  And it
seems to be barfing out of the process and moving on after a certain
amount of times the tag is called?  Does that make any sense?

 

Kevin

 

 

Kevin Schmidt

Two Rivers Marketing Group

502 E. Locust, Des Moines, IA 50309

Phone: 515.557.2028

Mobile: 515.865.3526

Fax: 515.557.2001

[EMAIL PROTECTED]

 

 

 



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

RE: ColdFusion based mass email module

[BillyC]

I had this in a text file copied from a mailing list, so I'm sure some
funky returns or wrapping occurred in transit :-)

---
Billy Cravens


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 3:25 PM
To: CF-Talk
Subject: Re: ColdFusion based mass email module

[EMAIL PROTECTED] wrote:
> You can send mixed-mode messages:
> 
> 
> 
> 
>  subject="test">  value="multipart/alternative; boundary=""#boundary#"""> --#boundary#
> Content-Type: text/plain;
> charset="iso-8859-1"

RFC says Content-Type and charset should be on the same line (or the 
line with charset should start with one or more spaces).

Jochem


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

RE: Regex

[Matthew R. Small]

Thanks, worked great for me.

- Matt Small

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 4:25 PM
To: CF-Talk
Subject: Re: Regex

REReplace(string, '[^0-9]', '', 'all')
this says find anything that is not 0-9 and replace it with nothing.

At 04:26 PM 4/17/02, you wrote:
>Anybody got a regex that will remove anything except numbers from a
>string?
>
>Thanks,
>Matt Small
>
>

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

Re: Regex

[Michael Dinowitz]

REReplace(string, '[^0-9]', '', 'all')
this says find anything that is not 0-9 and replace it with nothing.

At 04:26 PM 4/17/02, you wrote:
>Anybody got a regex that will remove anything except numbers from a
>string?
>
>Thanks,
>Matt Small
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ColdFusion based mass email module

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:
> You can send mixed-mode messages:
> 
> 
> 
> 
>  subject="test">  value="multipart/alternative; boundary=""#boundary#"""> --#boundary#
> Content-Type: text/plain;
> charset="iso-8859-1"

RFC says Content-Type and charset should be on the same line (or the 
line with charset should start with one or more spaces).

Jochem

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

Regex

[Matthew R. Small]

Anybody got a regex that will remove anything except numbers from a
string?

Thanks,
Matt Small

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL insanity...

[David DiPietro]

perhaps something like this would work


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally,
sermons.title, sermons.tape, sermons.name, speakers.initials,sermons.size
FROM sermons_details
Inner join sermons on sermons_details.sermon_num = sermons.ID
Inner join speakers on sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num, sermons.title, sermons.tape, sermons.name,
speakers.initials,sermons.size
ORDER BY count(sermons_details.sermon_num) DESC


OR...
You could drop the group by

Then for output





some code



-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:01 PM
To: CF-Talk
Subject: RE: SQL insanity...


I tried this:


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally, sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM (sermons_details INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


..and I got this error:

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


[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.


ideas?

David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...


Why not do a join... something like this I expect...

>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ColdFusion based mass email module

[Jochem van Dieten]

Dowdell, Jason G wrote:
> Justin,
> 
> Do you have to do anything special if it's an html formatted
> message?  Is there a failover in case the client's email client
> does not render html?

rfc 2045-9, rfc 2822 and possibly rfc 2387 (if you want inline images)

Or cf_advancedemail :)

Jochem

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

RE: SQL insanity...

[David Grabbe]

Yup -- that was it.  Thanks for the help.


David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org


-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:03 PM
To: CF-Talk
Subject: RE: SQL insanity...


Every item in the select statement other than the count needs to be in the
group by
statement

-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:01 PM
To: CF-Talk
Subject: RE: SQL insanity...


I tried this:


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally, sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM (sermons_details INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


.and I got this error:

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


[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.


ideas?

David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...


Why not do a join... something like this I expect...

>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>



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

Re: Custom Tags question

[Paul Giesenhagen]

I just wrote a custom tag that calls upon itself over and over drilling down
through departments and products .. it can process many times and I haven't
seen any problems...

How many times is your tag calling before it gacks on ya?

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



> Is there a maximum number of times a custom tag can be called?  I have a
> custom tag that calls itself quite a few times in the process.  And it
> seems to be barfing out of the process and moving on after a certain
> amount of times the tag is called?  Does that make any sense?
>
>
>
> Kevin
>
>
>
>
>
> Kevin Schmidt
>
> Two Rivers Marketing Group
>
> 502 E. Locust, Des Moines, IA 50309
>
> Phone: 515.557.2028
>
> Mobile: 515.865.3526
>
> Fax: 515.557.2001
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
>
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL insanity...

[Mark A. Kruger - CFG]

or something similar...

-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:01 PM
To: CF-Talk
Subject: RE: SQL insanity...


I tried this:


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally, sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM (sermons_details INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


..and I got this error:

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


[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.


ideas?

David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...


Why not do a join... something like this I expect...

>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ColdFusion based mass email module

[BillyC]

You can send mixed-mode messages:





  --#boundary#
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

This is the plain text message for the email.  HTML readers will not see
this.  That is all. End of message

--#boundary#
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



HTML Message


This is the HTML text message
for the email. This will not be seen with a plain text reader. 

--#boundary#--


---
Billy Cravens


-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 1:34 PM
To: CF-Talk
Subject: RE: ColdFusion based mass email module

Justin,

Do you have to do anything special if it's an html formatted
message?  Is there a failover in case the client's email client
does not render html?

Thanks,
jason

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 9:57 AM
To: CF-Talk
Subject: Re: ColdFusion based mass email module


> That sounds very interesting.  Could you include a code
> snippet or example to show me how to do what you're
> proposing.  I'm not sure the host will allow it but it's
> definitely worth looking into.

I don't know what your clear_newsletter.cfm file does, but here's a
sample
of the IIS SMTP dump code:

--[ snip ]--



--[ snip ]--

Note that you will need to change the GMT offset in the time to the
correct
value.  The Reply-To header is not needed, but I use that to store a
contact
address and use a system address (which sends things into null) for the
From
address so I don't get thousands of delivery errors and autoresponders
in my
regular mailbox.  I hope this helps a little.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com




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

RE: SQL insanity...

[Mark A. Kruger - CFG]

Dave,

Yeah - all of your returned columns should be included in either the group
or order by attributes (I believe it's either or). so yous should have:

GROUP BY
sermons_details.sermon_num,sermons.title,Sermons.tap,sermons.name,speakers.i
nitials
ORDER BY tally

-mk

-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:01 PM
To: CF-Talk
Subject: RE: SQL insanity...


I tried this:


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally, sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM (sermons_details INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


..and I got this error:

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


[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.


ideas?

David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...


Why not do a join... something like this I expect...

>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>


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

Custom Tags question

[Kevin Schmidt]

Is there a maximum number of times a custom tag can be called?  I have a
custom tag that calls itself quite a few times in the process.  And it
seems to be barfing out of the process and moving on after a certain
amount of times the tag is called?  Does that make any sense?

 

Kevin

 

 

Kevin Schmidt

Two Rivers Marketing Group

502 E. Locust, Des Moines, IA 50309

Phone: 515.557.2028

Mobile: 515.865.3526

Fax: 515.557.2001

[EMAIL PROTECTED]

 

 

 


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

RE: SQL insanity...

[David DiPietro]

Every item in the select statement other than the count needs to be in the group by
statement

-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:01 PM
To: CF-Talk
Subject: RE: SQL insanity...


I tried this:


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally, sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM (sermons_details INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


..and I got this error:

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


[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.


ideas?

David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...


Why not do a join... something like this I expect...

>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>


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

RE: SQL insanity...

[David Grabbe]

I tried this:


SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally, sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM (sermons_details INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


...and I got this error:

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


[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.


ideas?

David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...


Why not do a join... something like this I expect...

>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>

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

RE: Recursive Query: Anything better??

[Venable, John]

Worked like a charm Rob, Thanks so much!!

John Venable

-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:03 AM
To: CF-Talk
Subject: RE: Recursive Query: Anything better??


I't probably possible in sql, but it would be a pain.

I haven't used it but why don't you check out this UDF I found on CFLib. It
looks like exactly what you need.

http://cflib.org/udf.cfm?ID=543

Let me know how it works.


-Original Message-
From: Venable, John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:49 AM
To: CF-Talk
Subject: RE: Recursive Query: Anything better??


Rob,

I am using SQL Server and this works great. Thanks much.

Is there a way to turn weekofyear into a human readable form, such as the
Sunday that starts that week??

TIA

John Venable

-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 5:47 PM
To: CF-Talk
Subject: RE: Recursive Query: Anything better??


You didn't say what DB you are using but this should work on SQL Server ...

select count(id) as Num, datepart(ww, date) as weekofyear, year(date) as
year
from main
where date > #firstDate# and date < #lastDate#
group by datepart(ww, date), year(date)
order by year, weekofyear



-Original Message-
From: Venable, John [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 5:25 PM
To: CF-Talk
Subject: Recursive Query: Anything better??


I'm sure there is something better than what I'm doing, basically I want to
do a weekly count of how many people have signed up for our newsletter.
Here's what I have, it seems VERY inefficient. Any SQL gurus out there wanna
help me out? Thanks in advance.




SELECT count(id) as num
FROM  MAIN
WHERE date between '#dateformat(DateAdd("d", -7, end))#' AND
'#dateformat(end, "mm/dd/yy")#'



[formatting clipped for
clarity]





John Venable




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: automated data replication

[mynews]

Is this expensive?

BJ
= = = Original message = = =

we use Repliweb, it is excellent. http://www.repliweb.com

there is also a Microsoft one, that comes in the Resource Kit.

Kirk


- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 12:30 PM
Subject: OT: automated data replication


> Hello all,
>
> Anyone know of an app which does data replication for NT? It 
would
> preferably run as a service. FTP a plus. Thanks for your input!
>
> Brook Davies
> maracasmedia inc.
>
>
> 

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

RE: Fourm DB Design & Examples

[Dave Watts]

> I am trying to design a DB for use with a Foums ap that 
> I am also designing. Can anyone shed some light on a 
> possible DB layout? Examples out there anywhere?
> *preferrably fusebox*

What does it mean for a database schema to be compliant with Fusebox?

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

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

Re: Another COM object question

[Joseph Thompson]

The Macromedia CF 5.0 book has a great chapter on COM.

Correct me if I'm wrong but I think that chapter and cfcomet.com share an
author... (Dain Anderson)

While cfcomet.com is great, I still liked the chapter better!

> Can anyone recommend some good Internet or book resources for more
> information on working with COM objects and CF, and COM objects in
general?
>


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

Fourm DB Design & Examples

[Michael Tangorre]

I am trying to design a DB for use with a Foums ap that I am also designing. Can 
anyone shed some light on a possible DB layout? Examples out there anywhere?
*preferrably fusebox*

Thanks,
Mike



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

Re: automated data replication

[Kirk Boecker]

we use Repliweb, it is excellent. http://www.repliweb.com

there is also a Microsoft one, that comes in the Resource Kit.

Kirk


- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 12:30 PM
Subject: OT: automated data replication


> Hello all,
>
> Anyone know of an app which does data replication for NT? It would
> preferably run as a service. FTP a plus. Thanks for your input!
>
> Brook Davies
> maracasmedia inc.
>
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL database security/design

[Jeffry Houser]

At 03:21 PM 4/17/2002 -0400, you wrote:
>Currently each client has their own database on our sql box.
>Our web manager is considering moving all clients to a single database
>called
>clients and use a single login from Cold Fusion to access their data.
>Is this the best practice? How do the rest of you guys handle client
>databases?

  I'm not quite sure I understand the full situation, but..
  Does it matter if client1 accesses the data of client2?  Based on what I 
am understanding, that it will be allowed.


>I thought the best procedure is to give each client their own database.
>Create a account with access to only their database.

  I would consider this a best practice.

>In the CF admin datasource restrict sql operations to stored procedures
>only.

  If you can do this, that would be great.  Although many applications may 
require re-writes to allow for this, since many applications do not use 
stored procedures exclusively.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

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

Re: SQL database security/design

[Douglas Brown]

That would be an absolute nightmare to keep up with, if he does infact try
something like that. Sure you can allow certain access to certain tables etc
through sql but when a person ads a table etc then he would have to redo hids
security settings for the new table. This in my opinion would be a terrible idea
and if I were hosted on the server, I would leave!!!



"Success is a journey, not a destination!!"



Doug Brown
- Original Message -
From: "Bosky, Dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 12:21 PM
Subject: SQL database security/design


> Currently each client has their own database on our sql box.
> Our web manager is considering moving all clients to a single database
> called
> clients and use a single login from Cold Fusion to access their data.
> Is this the best practice? How do the rest of you guys handle client
> databases?
>
> I thought the best procedure is to give each client their own database.
> Create a account with access to only their database.
> In the CF admin datasource restrict sql operations to stored procedures
> only.
>
> Any input?
>
>
> Dave
>
>
>
>
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL insanity...

[Brian Scandale]

Why not do a join... something like this I expect... 

>
>SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
>tally


 sermons.title etc, speakers.initials


>FROM sermons_details

 JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num

 JOIN speakers ON sermons.speaker = speaker.full_name


>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a



At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there  :)
>
>Here's the deal:  we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days.  Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number.  This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them.  Works like a
>champ.  The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name, speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out.  Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too.  Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL database security/design

[Bosky, Dave]

Currently each client has their own database on our sql box.
Our web manager is considering moving all clients to a single database
called 
clients and use a single login from Cold Fusion to access their data.
Is this the best practice? How do the rest of you guys handle client
databases?
 
I thought the best procedure is to give each client their own database.
Create a account with access to only their database.
In the CF admin datasource restrict sql operations to stored procedures
only.
 
Any input?
 
 
Dave
 
 
 
 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: automated data replication

[Brook Davies]

Hello all,

Anyone know of an app which does data replication for NT? It would 
preferably run as a service. FTP a plus. Thanks for your input!

Brook Davies
maracasmedia inc.


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

RE: weird insert/update error

[Craig Thomas]

Thanks.

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:59 PM
To: CF-Talk
Subject: RE: weird insert/update error


just right click on the database file you copied over.
make sure the web client or what ever your server calls it has read/write
privileges to the db.

that's it.

-paul



-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:44 PM
To: CF-Talk
Subject: RE: weird insert/update error


I am receiving the same error message after migrating an app from my laptop
(wok, CIF, Silk) to our dev box (same).  Can you tell me what permissions
needed to be reset/set? All seems to be in order. (I have also checked, per
earlier comment, both MAC versions and they are the same (2.6). did this
help you at all?)

-Craig Thomas

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:23 PM
To: CF-Talk
Subject: RE: weird insert/update error


found the problem

when i copied the files & the data base to the server, the file permissions
where reset.
i had to allow web users to be able to write to the database.

kind of odd, never ran into this before.

should be fine now.


-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:50 AM
To: CF-Talk
Subject: RE: weird insert/update error


no.  download the MDAC checker from MS (http://www.microsoft.com/mdac) and
run it at the server console.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:27 AM
To: CF-Talk
Subject: RE: weird insert/update error


ok.

can i do that in cf admin?

-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:06 AM
To: CF-Talk
Subject: RE: weird insert/update error


check the MDAC version on the production box.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:31 AM
To: CF-Talk
Subject: weird insert/update error


ok i have this little app.
runs just fine on my local host using cf 5.0 server

it also runs just fine on our cf 4.51 production server winNT

but when i move it to a 5.0 production server that is win2k
i get the error below

same files, same db, same odbc's...
any ideas.

thanks

-paul

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.



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







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

SQL insanity...

[David Grabbe]

I need some help from your SQL gurus out there  :)

Here's the deal:  we are keeping a running tally of the sermons which have
been downloaded the most over the past 30 days.  Every time a sermon is
downloaded, I write a record out to a sermons_details table, where the
primary key is the sermon number.  This is working fine:




SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
tally
FROM sermons_details
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC


This counts up the number of detail records, and orders them.  Works like a
champ.  The difficulty comes in when I try to get the info from the header
record for each sermon:


SELECT sermons.title, sermons.tape, sermons.name, speakers.initials,
sermons.size
FROM sermons, speakers
WHERE tape IN ('#sermon_num#',)
AND sermons.size > 0 --->
AND speakers.full_name = sermons.speaker


This gets the right info, but now the ordering is off -- the second query
isn't ordered according to which sermon was downloaded most.

I'm assuming there is a way to do all of this with a single query, but so
far I haven't been able to figure it out.  Oh yeah, I'm (still) using
Access2000, so the functionality of the DB is a bit limited too.  Ideas?

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Another COM object question

[Howie Hamlin]

You don't have to destroy the object like you do in ASP.  A good resource for CF and 
COM is www.cfcomet.com.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: "lars bc4x4" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 2:56 PM
Subject: Another COM object question


> I've just started writing some COM objects in VB and have a question.  If I
> create an object and then use CFOBJECT to instantiate it, do I have to
> explicitly destroy the object afterwards?  Or will CF automagically do that
> for me?
> 
> Can anyone recommend some good Internet or book resources for more
> information on working with COM objects and CF, and COM objects in general?
> 
> TIA,
> 
> 
> ...lars
> www.bc4x4.com - Canada's Largest 4x4 Site
> 
> 
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
> 
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 

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

RE: weird insert/update error

[Paul Ihrig]

just right click on the database file you copied over.
make sure the web client or what ever your server calls it has read/write
privileges to the db.

that's it.

-paul



-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:44 PM
To: CF-Talk
Subject: RE: weird insert/update error


I am receiving the same error message after migrating an app from my laptop
(wok, CIF, Silk) to our dev box (same).  Can you tell me what permissions
needed to be reset/set? All seems to be in order. (I have also checked, per
earlier comment, both MAC versions and they are the same (2.6). did this
help you at all?)

-Craig Thomas

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:23 PM
To: CF-Talk
Subject: RE: weird insert/update error


found the problem

when i copied the files & the data base to the server, the file permissions
where reset.
i had to allow web users to be able to write to the database.

kind of odd, never ran into this before.

should be fine now.


-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:50 AM
To: CF-Talk
Subject: RE: weird insert/update error


no.  download the MDAC checker from MS (http://www.microsoft.com/mdac) and
run it at the server console.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:27 AM
To: CF-Talk
Subject: RE: weird insert/update error


ok.

can i do that in cf admin?

-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:06 AM
To: CF-Talk
Subject: RE: weird insert/update error


check the MDAC version on the production box.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:31 AM
To: CF-Talk
Subject: weird insert/update error


ok i have this little app.
runs just fine on my local host using cf 5.0 server

it also runs just fine on our cf 4.51 production server winNT

but when i move it to a 5.0 production server that is win2k
i get the error below

same files, same db, same odbc's...
any ideas.

thanks

-paul

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.



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






__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Another COM object question

[lars bc4x4]

I've just started writing some COM objects in VB and have a question.  If I
create an object and then use CFOBJECT to instantiate it, do I have to
explicitly destroy the object afterwards?  Or will CF automagically do that
for me?

Can anyone recommend some good Internet or book resources for more
information on working with COM objects and CF, and COM objects in general?

TIA,


...lars
www.bc4x4.com - Canada's Largest 4x4 Site


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: weird insert/update error

[Craig Thomas]

I am receiving the same error message after migrating an app from my laptop
(wok, CIF, Silk) to our dev box (same).  Can you tell me what permissions
needed to be reset/set? All seems to be in order. (I have also checked, per
earlier comment, both MAC versions and they are the same (2.6). did this
help you at all?)

-Craig Thomas

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:23 PM
To: CF-Talk
Subject: RE: weird insert/update error


found the problem

when i copied the files & the data base to the server, the file permissions
where reset.
i had to allow web users to be able to write to the database.

kind of odd, never ran into this before.

should be fine now.


-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:50 AM
To: CF-Talk
Subject: RE: weird insert/update error


no.  download the MDAC checker from MS (http://www.microsoft.com/mdac) and
run it at the server console.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:27 AM
To: CF-Talk
Subject: RE: weird insert/update error


ok.

can i do that in cf admin?

-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:06 AM
To: CF-Talk
Subject: RE: weird insert/update error


check the MDAC version on the production box.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:31 AM
To: CF-Talk
Subject: weird insert/update error


ok i have this little app.
runs just fine on my local host using cf 5.0 server

it also runs just fine on our cf 4.51 production server winNT

but when i move it to a 5.0 production server that is win2k
i get the error below

same files, same db, same odbc's...
any ideas.

thanks

-paul

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.



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





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

RE: ColdFusion based mass email module

[Dowdell, Jason G]

Justin,

Do you have to do anything special if it's an html formatted
message?  Is there a failover in case the client's email client
does not render html?

Thanks,
jason

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 9:57 AM
To: CF-Talk
Subject: Re: ColdFusion based mass email module


> That sounds very interesting.  Could you include a code
> snippet or example to show me how to do what you're
> proposing.  I'm not sure the host will allow it but it's
> definitely worth looking into.

I don't know what your clear_newsletter.cfm file does, but here's a sample
of the IIS SMTP dump code:

--[ snip ]--



--[ snip ]--

Note that you will need to change the GMT offset in the time to the correct
value.  The Reply-To header is not needed, but I use that to store a contact
address and use a system address (which sends things into null) for the From
address so I don't get thousands of delivery errors and autoresponders in my
regular mailbox.  I hope this helps a little.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com



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

Re: Random Record

[Joel Firestone]

One way:




HTH

J

- Original Message -
From: "Eric J Hoffman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 5:19 PM
Subject: Random Record


> What is the best way to get a random record from an table that has
> frequent changes and updates...best practices or practical advice from
> veterans?  Randrange between 1 and recordcount won't work pulling a num
> and then going against primary id..so somehow to get a "row"?
>
> Thanks.
>
> Regards,
>
> Eric J. Hoffman
> Director of Internet Development
> DataStream Connexion, LLC
> (formerly Small Dog Design)
>
>
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Submitting a form only once, iow, preventing impatient user d ouble clicks.

[Dave Carabetta]

>This should work to maintain type=submit:
>
>onClick="if(this.value == 'Generate Report'){
>this.value='Running Report...';return true;}else{return false};"
>class="submit">
>
>(remove line wraps in the onClick parameter)
>
>Ron Hornbaker
>Co-Founder, BookCrossing.com
>
>BOOKS JUST WANNA BE FREE! http://BookCrossing.com

Actually, I have it working for input type="submit" ... what I'm trying to 
figure out is why input type="button" for that code doesn't work in IE 6 and 
Netscape 6.x.

Thanks,
Dave.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Submitting a form only once, iow, preventing impatient user d ouble clicks.

[Matt Robertson]

Dave,

I'm doing exactly what you are this morning.  Of the three examples that
were given early on in the thread, I've settled on this one so far:



On my win2k/apache dev box it works in NN 6.2 and 4.77 as well as IE.

I do self-posting forms as well.  Sometimes I 
 to test if the page
is a form submission, and carry on processing from there.  That might
help you out on the self-testing thing.

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com

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

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

[Jerry Johnson]

Of course you can't have the last word. No thread ever dies. That's the law.

And I hope you don't think I ACTUALLY care about HTML code with or without close tags. 
Not on a nice day like today.

But, whenever given the chance to pontificate on programming, how do you expect an 
old-timer to pass that up?

It's like lofting a soft pitch at a good batter. Gotta swing.

Jerry Johnson



>>> [EMAIL PROTECTED] 04/17/02 01:39PM >>>
Well - Yes, I hope that this letter is the last post on this thread.
Everybody's got their opinions on this issue and I respect everybody's
as much as you respect mine.  I hope that everybody else thinks as I do
in that
this is a forum to share ideas and expressions and to debate the same.
We don't have to agree but hopefully we can agree to disagree on
occassion. If I ruffled any feathers I apologize (Jerry Johnson :-) ) 

This is a great list.
- Matt Small


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

Sorry for coming back to this thread again but I wanted to make one
thing
clear about my feelings for Netscape. I agree that ALL code should be
solid
code, and if there are browsers around that do not display a page
because I
have missed a closing  then I'd prefer to know that I've done
something
wrong. In this respect I do not have a problem with Netscape. For this
reason, if you are still intending to send the letter please don't put
my
name on it.

Kath

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


OK...  
:-)

I'm done thinking about Netscape, IE and browsers.  I'm going to go
jetski the rest of my day away.

I hope that everybody had a good time with this little thread today.  

Take care,

- Matt Small

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 16, 2002 6:24 PM
To: CF-Talk
Subject: RE: CSS and Netscape - was(CSS and dynamically changing
classes)

> We're not talking about bad code. We're talking about 
> forgotten table tags. We're talking about not fully 
> scoping a variable.

I'd argue that's bad code. It might not be as bad, comparatively
speaking,
as not using CFLOCK around a memory variable, but forgetting a table tag
is
an invalid instruction, and not scoping a variable is a potentially
ambiguous instruction. It's important to remember that computers are
very,
very stupid, and will generally do exactly what we tell them to do, with
very little ability to "fill in the blanks" when we provide incomplete
or
incorrect instructions.

While I prefer IE to Netscape, there's a reason that IE is such a big
install, and why the Gecko parser in Mozilla is as fast as it is. This
is
because IE attempts to render HTML even if it's not well-formed, and
does a
decent job of it. Of course, for this to happen, IE has to include all
kinds
of code to cover every eventuality. We're not going to have this luxury
in
the future, probably - as browsers become smaller, and as they're found
in
more devices, the necessity of writing well-formed HTML, or XHTML, more
likely, will be much greater than it may be now.

> We're talking about the fact that when bad code does get 
> written, you're a whole lot better off if you have internet 
> explorer than when you have netscape. If you had to choose 
> between riding in a car that was based on the fact that 
> everything was always perfect in a perfect world then 
> netscape works quite nicely. The fact is, IE takes into 
> account the fact that code doesn't always get written 
> like the rules say. It figures out the right most of the 
> time and leaves you with options so your code is not left 
> broken when multiple people who work on the application 
> make a mistake here or there then it's left to somebody 
> else to fix.

A couple of points worth noting here:

1. IE may figure out the optimal thing to display, but your code is in
fact
"left broken".

2. If you follow your car analogy to its logical conclusion, you could
compare IE to a Humvee, and Netscape to, say, a Yugo. However, as a
road-builder, your roads should work for both, and if you build roads
with
giant potholes, you can't blame the problems encountered by Yugo drivers
on
their choice of cars - maybe they can't afford a Humvee! (The analogy
here
would be that they're running Linux or something, rather than Windows or
Mac, I suppose.)

> You're right, writing things properly is always a good 
> thing. Being able to account and correct mistakes rapidly 
> is also.

Yes, both of those are important. The second one is usually called
"debugging", and in an ideal world, most of it happens before an
application
is deployed, and isn't performed by end users.

> Now, let's attack me personally because I have these 
> views. Yes, go ahead a

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

[Matthew R. Small]

Well - Yes, I hope that this letter is the last post on this thread.
Everybody's got their opinions on this issue and I respect everybody's
as much as you respect mine.  I hope that everybody else thinks as I do
in that
this is a forum to share ideas and expressions and to debate the same.
We don't have to agree but hopefully we can agree to disagree on
occassion. If I ruffled any feathers I apologize (Jerry Johnson :-) ) 

This is a great list.
- Matt Small


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

Sorry for coming back to this thread again but I wanted to make one
thing
clear about my feelings for Netscape. I agree that ALL code should be
solid
code, and if there are browsers around that do not display a page
because I
have missed a closing  then I'd prefer to know that I've done
something
wrong. In this respect I do not have a problem with Netscape. For this
reason, if you are still intending to send the letter please don't put
my
name on it.

Kath

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


OK...  
:-)

I'm done thinking about Netscape, IE and browsers.  I'm going to go
jetski the rest of my day away.

I hope that everybody had a good time with this little thread today.  

Take care,

- Matt Small

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 16, 2002 6:24 PM
To: CF-Talk
Subject: RE: CSS and Netscape - was(CSS and dynamically changing
classes)

> We're not talking about bad code. We're talking about 
> forgotten table tags. We're talking about not fully 
> scoping a variable.

I'd argue that's bad code. It might not be as bad, comparatively
speaking,
as not using CFLOCK around a memory variable, but forgetting a table tag
is
an invalid instruction, and not scoping a variable is a potentially
ambiguous instruction. It's important to remember that computers are
very,
very stupid, and will generally do exactly what we tell them to do, with
very little ability to "fill in the blanks" when we provide incomplete
or
incorrect instructions.

While I prefer IE to Netscape, there's a reason that IE is such a big
install, and why the Gecko parser in Mozilla is as fast as it is. This
is
because IE attempts to render HTML even if it's not well-formed, and
does a
decent job of it. Of course, for this to happen, IE has to include all
kinds
of code to cover every eventuality. We're not going to have this luxury
in
the future, probably - as browsers become smaller, and as they're found
in
more devices, the necessity of writing well-formed HTML, or XHTML, more
likely, will be much greater than it may be now.

> We're talking about the fact that when bad code does get 
> written, you're a whole lot better off if you have internet 
> explorer than when you have netscape. If you had to choose 
> between riding in a car that was based on the fact that 
> everything was always perfect in a perfect world then 
> netscape works quite nicely. The fact is, IE takes into 
> account the fact that code doesn't always get written 
> like the rules say. It figures out the right most of the 
> time and leaves you with options so your code is not left 
> broken when multiple people who work on the application 
> make a mistake here or there then it's left to somebody 
> else to fix.

A couple of points worth noting here:

1. IE may figure out the optimal thing to display, but your code is in
fact
"left broken".

2. If you follow your car analogy to its logical conclusion, you could
compare IE to a Humvee, and Netscape to, say, a Yugo. However, as a
road-builder, your roads should work for both, and if you build roads
with
giant potholes, you can't blame the problems encountered by Yugo drivers
on
their choice of cars - maybe they can't afford a Humvee! (The analogy
here
would be that they're running Linux or something, rather than Windows or
Mac, I suppose.)

> You're right, writing things properly is always a good 
> thing. Being able to account and correct mistakes rapidly 
> is also.

Yes, both of those are important. The second one is usually called
"debugging", and in an ideal world, most of it happens before an
application
is deployed, and isn't performed by end users.

> Now, let's attack me personally because I have these 
> views. Yes, go ahead and attack the person instead of 
> the views themselves. Show me how much class you've got.

I hope you don't take this as a personal attack. I don't think that
Jerry
intended for you to take his criticism as a personal attack, either,
based
on my reading of it:

"What you are talking about is bad coding. Pure and simple. 
And laziness. Just because IE currently allows you to code 
so poorly, and the page sometimes renders the wa

RE: CF based classifieds

[Bosky, Dave]

Kevin,

I wrote it about 2yrs ago but it works pretty good.
I have a scheduled task to remove ads after 30 days and it sends me an email
to approve new ads. I've been trying to update the functionality/layout but
it keeps getting pushed back.  

Thanks,
Dave Bosky
 

-Original Message-
From: Kevin Langevin [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 17, 2002 12:26 PM
To: CF-Talk
Subject: RE: CF based classifieds

Dave-  Do you know who wrote the SeaCoast ads app?  I'd love to get a hold
of a copy of it, if it's available for use.


Kevin Langevin
Flying Chimp Media
954-585-0999
[EMAIL PROTECTED]
http://www.FlyingChimp.com

> -Original Message-
> From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 10:02 AM
> To: CF-Talk
> Subject: RE: CF based classifieds
>
>
> Heres another:
>
> http://www.sccoast.net/cf/classifieds/ad_index.cfm
>
>
> Thanks,
> Dave Bosky
>
>
> -Original Message-
> From: Declan Maher [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 9:58 AM
> To: CF-Talk
> Subject: RE: CF based classifieds
>
> http://www.avidweb.net/avidweb/demo/classifiedads/
>
> -Original Message-
> From: Burcham, Steve [mailto:[EMAIL PROTECTED]]
> Sent: 17 April 2002 14:50
> To: CF-Talk
> Subject: RE: CF based classifieds
>
>
> I have created one for our company. It is very simple and is created
> with
> one page and a footer. There is no security built into it as of yet. The
> users can only add and view the records.
>
>
> Thank you.
>
> Steve Burcham
> Webmaster
> RDO Equipment Co.
> Phone (701) 239-8755
> [EMAIL PROTECTED] 
>
>
> -Original Message-
> From: John Anderson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 16, 2002 6:31 PM
> To: CF-Talk
> Subject: CF based classifieds
>
>
> Does anyone have or know of a CF based classified ads app that can be
> integrated into a corporate intranet?  Preferably fusebox?
>
> Thanks,
> John
>
>
>
> 

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

RE: weird insert/update error

[Paul Ihrig]

found the problem

when i copied the files & the data base to the server, the file permissions
where reset.
i had to allow web users to be able to write to the database.

kind of odd, never ran into this before.

should be fine now.


-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:50 AM
To: CF-Talk
Subject: RE: weird insert/update error


no.  download the MDAC checker from MS (http://www.microsoft.com/mdac) and
run it at the server console.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:27 AM
To: CF-Talk
Subject: RE: weird insert/update error


ok.

can i do that in cf admin?

-paul



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:06 AM
To: CF-Talk
Subject: RE: weird insert/update error


check the MDAC version on the production box.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:31 AM
To: CF-Talk
Subject: weird insert/update error


ok i have this little app.
runs just fine on my local host using cf 5.0 server 

it also runs just fine on our cf 4.51 production server winNT

but when i move it to a 5.0 production server that is win2k
i get the error below

same files, same db, same odbc's...
any ideas.

thanks

-paul

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.



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




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

RE: Purge cfVar db using SQL script

[Mark A. Kruger - CFG]

Way to go Anthony . You just cleaned the poor guy out.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:06 PM
To: CF-Talk
Subject: RE: Purge cfVar db using SQL script


MISTAKE

i didn't see that you only wanted to get rid of records over 30 days. sorry
about that. the statements i gave you before would delete EVERYTHING in the
tables. again sorry.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:02 PM
To: CF-Talk
Subject: RE: Purge cfVar db using SQL script


make sure you use

truncate table cfdata
truncate table cfglobal

it's faster then

DELETE FROM cfdata
DELETE FROM cfglobal

also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more
about it.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:49 PM
To: CF-Talk
Subject: RE: Purge cfVar db using SQL script


Miles,

I may be mistaken, but I think there is a custom tag or script on the
gallery that can take care of this task for you.

Mark

-Original Message-
From: Miles Fawcett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:31 AM
To: CF-Talk
Subject: Purge cfVar db using SQL script


We are using CF5 in a clustered environment and would like to purge the
cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am
interested in anyone has a script they know works are has any insight into
this approach.

We would like to purge all records older than 30 days.

Thanks,
Miles





Miles Fawcett, President
Interactive Applications Group (iapps)
tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271
Washington  *  New York  *  San Francisco  *  Boston





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

RE: Purge cfVar db using SQL script

[Tony_Petruzzi]

MISTAKE

i didn't see that you only wanted to get rid of records over 30 days. sorry
about that. the statements i gave you before would delete EVERYTHING in the
tables. again sorry.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:02 PM
To: CF-Talk
Subject: RE: Purge cfVar db using SQL script


make sure you use 

truncate table cfdata
truncate table cfglobal

it's faster then 

DELETE FROM cfdata
DELETE FROM cfglobal

also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more
about it.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:49 PM
To: CF-Talk
Subject: RE: Purge cfVar db using SQL script


Miles,

I may be mistaken, but I think there is a custom tag or script on the
gallery that can take care of this task for you.

Mark

-Original Message-
From: Miles Fawcett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:31 AM
To: CF-Talk
Subject: Purge cfVar db using SQL script


We are using CF5 in a clustered environment and would like to purge the
cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am
interested in anyone has a script they know works are has any insight into
this approach.

We would like to purge all records older than 30 days.

Thanks,
Miles





Miles Fawcett, President
Interactive Applications Group (iapps)
tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271
Washington  *  New York  *  San Francisco  *  Boston




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

RE: Purge cfVar db using SQL script

[Tony_Petruzzi]

make sure you use 

truncate table cfdata
truncate table cfglobal

it's faster then 

DELETE FROM cfdata
DELETE FROM cfglobal

also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more
about it.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:49 PM
To: CF-Talk
Subject: RE: Purge cfVar db using SQL script


Miles,

I may be mistaken, but I think there is a custom tag or script on the
gallery that can take care of this task for you.

Mark

-Original Message-
From: Miles Fawcett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:31 AM
To: CF-Talk
Subject: Purge cfVar db using SQL script


We are using CF5 in a clustered environment and would like to purge the
cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am
interested in anyone has a script they know works are has any insight into
this approach.

We would like to purge all records older than 30 days.

Thanks,
Miles





Miles Fawcett, President
Interactive Applications Group (iapps)
tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271
Washington  *  New York  *  San Francisco  *  Boston



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

RE: Submitting a form only once, iow, preventing impatient user d ouble clicks.

[Ron Hornbaker]

This should work to maintain type=submit:



(remove line wraps in the onClick parameter)

Ron Hornbaker
Co-Founder, BookCrossing.com

BOOKS JUST WANNA BE FREE! http://BookCrossing.com



> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 10:37 AM
> To: CF-Talk
> Subject: RE: Submitting a form only once, iow, preventing impatient user
> d ouble clicks.
>
>
> >Use javascript to disable the submit button once it's been clicked.
> >
> >I tend to use an input type="button" so idtio users pressing
> return when
> >they shouldn't, don't actually submit the form early.
> >
> > onclick="javascript:this.value='Please
> >Wait';this.disabled=1;document.forms[0].submit()">
> >
> >Should do the trick
> >
>
> OK, so I've been looking into this same problem myself and
> decided to create
> a test page with the examples posted. I'm having a strange
> problem and was
> hoping somebody could point out what I'm doing wrong.
>
> I almost always have my forms post to themselves, and then test for the
> existence of the submit button's name. If I use:
>
>  onClick="if(this.value == 'Generate Report') this.form.submit();
> this.value='Running Report...';" class="submit">
>
> the page submits to itself, but the existence check fails:
>
> 
>Run the processing code.
> 
>
> However, if I change the input type to "submit" the page
> submits just fine
> and runs the processing code. Why would the submit button's
> name not exist
> if the type="button", but it does exist if I change it to type="submit"?
>
> To further complicate the issue, if I have the input
> type="submit" and use
> the this.disabled = 1; feature, the processing does not occur either.
> Removing this.disabled processes the form perfectly.
>
> I'm testing in IE 6, if that makes a difference. I'm gonna go
> try Nutscrape
> now and see what happens.
>
> Any thoughts?
>
> Thanks,
> Dave.

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Purge cfVar db using SQL script

[Mark A. Kruger - CFG]

Miles,

I may be mistaken, but I think there is a custom tag or script on the
gallery that can take care of this task for you.

Mark

-Original Message-
From: Miles Fawcett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:31 AM
To: CF-Talk
Subject: Purge cfVar db using SQL script


We are using CF5 in a clustered environment and would like to purge the
cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am
interested in anyone has a script they know works are has any insight into
this approach.

We would like to purge all records older than 30 days.

Thanks,
Miles





Miles Fawcett, President
Interactive Applications Group (iapps)
tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271
Washington  *  New York  *  San Francisco  *  Boston


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

RE: Is there a way to measure memory usage of variables?

[Dave Watts]

> anyone out there know if is there a way to track for 
> example how much ram is being used by application vars?

To the best of my knowledge, you can only track total memory usage of the CF
service; there's no exposed internal memory information. I'd very much like
to be proven wrong on this, though.

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

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

RE: isquery

[Jon Block]

A recordset variable is a recordset variable. Don't use the double quotes...

In your example, use: isQuery(peopleInapp)

Cheers,
Jon

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:33 PM
To: CF-Talk
Subject: isquery


Will isquery work on a result set of a stored procedure.


 
  
   query
  
 
 
 blah
 


I have this but blah always shows. TIA,.

Josh


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

RE: isquery

[Dave Watts]

> Will isquery work on a result set of a stored procedure.

Yes, it should work on any Query object, including those you get from a
stored procedure, from a Verity query, or if you create them yourself with
QueryNew.

> 
>  
>   
>query
>   
>  
>  
>  blah
>  
> 
> I have this but blah always shows.

You're asking CF whether the literal string "peopleinapp" is a query, and it
never will be. Remove the quotes, and it'll probably work fine.

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

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