Re: announce: ColdFusion Cookbook hits 100

[John C. Bland II]

Ray, big props on the cookbook. It has come a long ways since the first time
I looked at it. Thx for the great resource.

I'll have to cook up some examples and post, whenever I get a chance. :-)

On 6/13/06, Raymond Camden <[EMAIL PROTECTED]> wrote:
>
> I hope folks don't mind the advertisement (although its for a free
> resource), but I just wanted to make sure folks were aware that the
> ColdFusion Cookbook (www.coldfusioncookbook.com) hit 100 entries
> today. Most of the thanks go to Jeremy Petersen. I built the
> framework, but he did most of the publishing.
>
>
>
> --
>
> ===
> Raymond Camden, Vice President of Technology for roundpeg
>
> Email: [EMAIL PROTECTED]
> Blog : ray.camdenfamily.com
> AOL IM   : cfjedimaster
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243430
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: the infamous 'table_insert_id()' inquiry

[Charlie Griefer]

I believe with Access you need to alias the MAX() function.


select max(pk_id) AS MAXID from users where email = '#session.email#'



On 6/13/06, Jeff Sabarese <[EMAIL PROTECTED]> wrote:
> i've been through a few different conversations on the topic of "how do I 
> most easily retrieve the Primary Key of the 'last Insert Query'"
>
> i settled on this one to try for an ms access database (because, using CFMX 
> 6.1 on Linux, i was enjoying my time w/ MySQL-- only to later realize that my 
> SQL wasn't compatible... oops!)
>
> there error is as shown, taken directly from the debug:
>
> Too few parameters. Expected 1.
>
> The error occurred in C:\Apache2\Apache2\htdocs\XX\report_page1.cfm: line 
> 38
>
> 36 :
> 37 : 
> 38 : select max(pk_id) from users where email = '#session.email#'
> 39 : 
> 40 :
>
> so, what am i missing there? or, is something missing in the table itself? 
> thanks!
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243429
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: announce: ColdFusion Cookbook hits 100

[Jim Davis]

> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:22 PM
> To: CF-Talk
> Subject: Re: announce: ColdFusion Cookbook hits 100
> 
> The cookbook idea is not unique and has been used in other sites and
> books as well. Personally I think it works well. I think beginners
> tend to think in terms of problems, "How do I do X"? Whereas a more
> advanced person knows the language well enough to know basically how
> things are done, but may struggle more with the setup of larger
> applications.

I agree... it's one of the (very few) real-world metaphors that translates
well online.

Jim Davis


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243428
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

the infamous 'table_insert_id()' inquiry

[Jeff Sabarese]

i've been through a few different conversations on the topic of "how do I most 
easily retrieve the Primary Key of the 'last Insert Query'"

i settled on this one to try for an ms access database (because, using CFMX 6.1 
on Linux, i was enjoying my time w/ MySQL-- only to later realize that my SQL 
wasn't compatible... oops!)

there error is as shown, taken directly from the debug:

Too few parameters. Expected 1.
 
The error occurred in C:\Apache2\Apache2\htdocs\XX\report_page1.cfm: line 38

36 : 
37 : 
38 : select max(pk_id) from users where email = '#session.email#'
39 : 
40 : 

so, what am i missing there? or, is something missing in the table itself? 
thanks!

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243427
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Recurring CFMAIL problem

[dave]

Yeah, oh well... The reason 4 it was that if you don't set the mail server it 
can be sent though localhost on the server which may not be set up correctly 
for email sending.

~Dave - formerly known as "the disruptor"~ 


From: "James Holmes" <[EMAIL PROTECTED]>
Sent: Tuesday, June 13, 2006 10:17 PM
To: CF-Talk 
Subject: Re: Recurring CFMAIL problem 

Thanks, that didn't help this time but it's always worth trying.

On 6/14/06, dave  wrote:
> I had something like that b4 and the cure was to add the server attribute to 
> cfmail tag but had to use the mail servers ip addy like server="10.10.1.20"
>
> ~Dave - formerly known as "the disruptor"~
>
> 
> From: "James Holmes" 
> Sent: Tuesday, June 13, 2006 10:05 PM
> To: CF-Talk 
> Subject: Recurring CFMAIL problem
>
> Once again, our servers have started reporting this:
>
> A problem occurred when attempting to deliver mail.
> This exception was caused by: javax.mail.MessagingException:
> IOException while sending message; nested exception is:
> javax.activation.UnsupportedDataTypeException: no object DCH for MIME
> type text/plain; charset=UTF-8.
>
> This is for a standard CFMAIL tag. A restart usually fixes the
> problem. Can anyone shed light on whay this continues to happen? This
> is Solaris/CF Ent.

-- 
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243426
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: announce: ColdFusion Cookbook hits 100

[Raymond Camden]

The cookbook idea is not unique and has been used in other sites and
books as well. Personally I think it works well. I think beginners
tend to think in terms of problems, "How do I do X"? Whereas a more
advanced person knows the language well enough to know basically how
things are done, but may struggle more with the setup of larger
applications.

On 6/13/06, Dan Plesse <[EMAIL PROTECTED]> wrote:
> Logically I wonder if the How-to text list is the best idea. I have over 200
> solutions
> (the last two were TTS and a unzip solution) and I don't think people are
> finding them or if the user does not find a solution at the end of the
> branch that person should be able post the problem and get an answer. I
> don't think you can group all the problems one could have but it would be
> interesting to see. I think a ot of people have such lists on the web, i am
> not sure if they are doing any good.
>
> On 6/13/06, Massimo Foti <[EMAIL PROTECTED]> wrote:
> >
> > Thanks for the great resource. Both to Ray and all contributors.
> >
> > 
> > Massimo Foti
> > Tools for ColdFusion and Dreamweaver developers:
> > http://www.massimocorner.com
> > 
> >
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243425
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Recurring CFMAIL problem

[James Holmes]

Thanks, that didn't help this time but it's always worth trying.

On 6/14/06, dave <[EMAIL PROTECTED]> wrote:
> I had something like that b4 and the cure was to add the server attribute to 
> cfmail tag but had to use the mail servers ip addy like server="10.10.1.20"
>
> ~Dave - formerly known as "the disruptor"~
>
> 
> From: "James Holmes" <[EMAIL PROTECTED]>
> Sent: Tuesday, June 13, 2006 10:05 PM
> To: CF-Talk 
> Subject: Recurring CFMAIL problem
>
> Once again, our servers have started reporting this:
>
>  A problem occurred when attempting to deliver mail.
> This exception was caused by: javax.mail.MessagingException:
> IOException while sending message; nested exception is:
> javax.activation.UnsupportedDataTypeException: no object DCH for MIME
> type text/plain; charset=UTF-8.
>
> This is for a standard CFMAIL tag. A restart usually fixes the
> problem. Can anyone shed light on whay this continues to happen? This
> is Solaris/CF Ent.

-- 
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243424
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

re: Recurring CFMAIL problem

[dave]

I had something like that b4 and the cure was to add the server attribute to 
cfmail tag but had to use the mail servers ip addy like server="10.10.1.20"

~Dave - formerly known as "the disruptor"~ 


From: "James Holmes" <[EMAIL PROTECTED]>
Sent: Tuesday, June 13, 2006 10:05 PM
To: CF-Talk 
Subject: Recurring CFMAIL problem 

Once again, our servers have started reporting this:

 A problem occurred when attempting to deliver mail.
This exception was caused by: javax.mail.MessagingException:
IOException while sending message; nested exception is:
javax.activation.UnsupportedDataTypeException: no object DCH for MIME
type text/plain; charset=UTF-8.

This is for a standard CFMAIL tag. A restart usually fixes the
problem. Can anyone shed light on whay this continues to happen? This
is Solaris/CF Ent.

-- 
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243423
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Recurring CFMAIL problem

[James Holmes]

Once again, our servers have started reporting this:

 A problem occurred when attempting to deliver mail.
This exception was caused by: javax.mail.MessagingException:
IOException while sending message; nested exception is:
javax.activation.UnsupportedDataTypeException: no object DCH for MIME
type text/plain; charset=UTF-8.

This is for a standard CFMAIL tag. A restart usually fixes the
problem. Can anyone shed light on whay this continues to happen? This
is Solaris/CF Ent.

-- 
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243422
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: announce: ColdFusion Cookbook hits 100

[Dan Plesse]

Logically I wonder if the How-to text list is the best idea. I have over 200
solutions
(the last two were TTS and a unzip solution) and I don't think people are
finding them or if the user does not find a solution at the end of the
branch that person should be able post the problem and get an answer. I
don't think you can group all the problems one could have but it would be
interesting to see. I think a ot of people have such lists on the web, i am
not sure if they are doing any good.

On 6/13/06, Massimo Foti <[EMAIL PROTECTED]> wrote:
>
> Thanks for the great resource. Both to Ray and all contributors.
>
> 
> Massimo Foti
> Tools for ColdFusion and Dreamweaver developers:
> http://www.massimocorner.com
> 
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243421
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfoutput with groups and a startrow

[James Holmes]

I think in this situation you have to manually display the rows you
want. As a query can be addressed like this:

QSomeQuery["SomeColumnName"][1]
QSomeQuery["SomeColumnName"][2]

etc, you can loop through the query, display a row if the grouped
column's value changes and record where you are in the query and the
number of rows you've displayed so far.

On 6/14/06, Auke van Leeuwen <[EMAIL PROTECTED]> wrote:
> >I'm trying to output a grouped query using a startrow and maxrows.
> >Something like this:
> >
> >
> >
> > 
> >   #myQuery.Foo#
> >   
> > 
> > #myQuery.Bar#
> >
> > 
> >
> >
> >
>
> I haven't tested this (don't have the time right now), but you may have to 
> put the maxrows attribute in the inner  while maintaining the 
> startrow attribute at the outer  loop.
>
> Hmm thinking about that some more: that wouldn't really work well as it would 
> probably give you a maximum of 10 rows for every 'group'. Starting at row '5' 
> while specifying startrow="11" doesn't make much sense either way I guess.

-- 
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243420
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfloop query="" bug?

[David]

Sorry about resurrecting an old issue. I found what seems to be a similar
bug. Even if I save those to local variables at the top of the cfloop, if I
have a lot of processing in the middle I sometimes get that even outside the
inner cfloop/cfoutput.

In my case, query2 and query3 are set inside the loop over query1, and then
do processing on 2 and 3 to generate the details to dump out for the record
of query1.

queryOne has 111 rows, and let's say colA's value is the same rownumber (1
to 111)


  
  
  
  

   
(#variables.queryOne.currentRow#)
ColA=#Variables.colA#

Assume there's Lots of Processing here on query2 and 3, none of which
touches queryOne.

(Dump the generated results for this queryOne record here)



Results:

(1) ColA= 1
(2) ColA= 2
(3) ColA= 3
(4) ColA= 4

(45) ColA= 45
(46) ColA= 1
(47) ColA= 1
(48) ColA= 1


(111) ColA = 1

If I remove all the extra processing in the middle, get correct value for
colA = 46 ... colA = 111

Workaround is at top of outer loop on queryOne, get query variables by the
currentRow. Even though it's at the top of the cfloop on that query, outside
any inner query loops.
  
  

- David

On 3/3/06, Ryan Guill <[EMAIL PROTECTED]> wrote:
>
> But thats not the case.  The current row is correct, even in the inner
> loop, but the value is not.
>
> On 3/3/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
> > I think this issue has been discussed a few days before.
> > It is a bug in CF (not in blue Dragon).
> > The current row of a first level loop is alway on when seen from an
> > inner loop.
> > The workaround is to store column values in variables at the first
> level.
> >
> > --
>
>


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243419
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfoutputs in fckEditor

[Rick Root]

I've never seen cfoutput around anything in fckeditor, and I use it 
regularly.   Not sure what you're seeing, would love to see an example.

Rick


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243418
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Tracking hits/impressions DB design Considerations

[blists]

This system is for "members/users" of our webapp. What if, for each user 
that used this service (its and add-on), we created a new table on the fly. 
That way each table would be used for that users tracking only and not for 
all the users. Is that a viable idea?

BrookD


At 03:41 PM 6/13/2006, you wrote:
> >If you do not need to keep track of IP addresses and dates, I would go this
> >route.  If not, then make sure you have your columns as small as possible
> >and maybe purge the info on a regular basis.
>
>If you do need that info you do best to have a table like Jabob proposes 
>anyway. Any inserts into a table you yourself proposed doesn't really do 
>any harm to processing. If you need to do a query that counts the number 
>of hits on that table, that will probably slow down as the table grows. So 
>you can do the count (to determine what to show) on 'Jacobs' table' and 
>have the other info in a separate table. OR just analyze your webserver 
>logfiles for that info later on :-)
>
>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243417
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfoutputs in fckEditor

[Auke van Leeuwen]

> You sure that there aren't any HTMLFormatted (i.e. ) 

I was trying to 'HTML-escape' that . Maybe I should escape it twice:
--
You sure that there aren't any HTMLFormatted (i.e. <cfoutput>) 
--

PS if that didn't work it still looks the same, and I look rather dumb.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243416
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Tracking hits/impressions DB design Considerations

[Auke van Leeuwen]

>If you do not need to keep track of IP addresses and dates, I would go this
>route.  If not, then make sure you have your columns as small as possible
>and maybe purge the info on a regular basis.

If you do need that info you do best to have a table like Jabob proposes 
anyway. Any inserts into a table you yourself proposed doesn't really do any 
harm to processing. If you need to do a query that counts the number of hits on 
that table, that will probably slow down as the table grows. So you can do the 
count (to determine what to show) on 'Jacobs' table' and have the other info in 
a separate table. OR just analyze your webserver logfiles for that info later 
on :-)

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243415
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfoutputs in fckEditor

[Auke van Leeuwen]

> I am integrating fckEditor in to my companies product. I have 
> encountered an issue where fckEditor is automaticly inserting cfoutput 
> tags in to the content of the textarea. Do any of you know where this 
> comes from and/or how to disable it?

You sure that there aren't any HTMLFormatted (i.e. ) in the 
value of the hidden form field that FCKEditor uses? Are there any  
tags in the value that you extract from your database?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243414
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfoutput with groups and a startrow

[Auke van Leeuwen]

>I'm trying to output a grouped query using a startrow and maxrows.
>Something like this:
>
>
>
> 
>   #myQuery.Foo#
>   
> 
> #myQuery.Bar#
>
> 
>
>
>

I haven't tested this (don't have the time right now), but you may have to put 
the maxrows attribute in the inner  while maintaining the startrow 
attribute at the outer  loop. 

Hmm thinking about that some more: that wouldn't really work well as it would 
probably give you a maximum of 10 rows for every 'group'. Starting at row '5' 
while specifying startrow="11" doesn't make much sense either way I guess.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243413
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfoutputs in fckEditor

[John Crawford]

I am integrating fckEditor in to my companies product. I have encountered an 
issue where fckEditor is automaticly inserting cfoutput tags in to the content 
of the textarea. Do any of you know where this comes from and/or how to disable 
it?

 Thanks in advance,
 John

 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243412
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Tracking hits/impressions DB design Considerations

[Jacob]

I have tons of counters on our pages.  We just keep track of the number
hits.  Like a movie pages was viewed 700 times. I do not make a new record
for each hit.  I would have a table that will grow like a wild weed.

For example: The movie Hostel...

On this movie page, I have this query:


Update Hits
Set hits = hits + 1
Where CounterID = '1234D1'


I have a table name Hits:

Stock   MoviePage   Hits
-   -   
1234D1  Hostel  7800

When the query is ran, it will update the hits for Hostel by one.

For your examples, I was thinking something like this:

Hit_ID  PageTypeHits
--  --  ---
1   A   View456
2   A   View74
3   B   Action  476
4   B   Action  77

Just increase the number of hits.  You wont have a table that will grow.

So, for a view of Page A, maybe something like this:


Update Hits
Set hits = hits + 1
Where Hits_ID = 1


If you do not need to keep track of IP addresses and dates, I would go this
route.  If not, then make sure you have your columns as small as possible
and maybe purge the info on a regular basis.

Hope this helps...
Jacob

-Original Message-
From: blists [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 2:50 PM
To: CF-Talk
Subject: RE: Tracking hits/impressions DB design Considerations

Jacob,

It could possibly be eliminated if it would reduce server resources. We can 
consider it. Why? Is there a better way to increment a counter of some sort?

BrookD

At 02:41 PM 6/13/2006, you wrote:
>Is it necessary to keep track of the date and IP address for your program?
>
>-Original Message-
>From: blists [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, June 13, 2006 11:56 AM
>To: CF-Talk
>Subject: Tracking hits/impressions DB design Considerations
>
>Hello,
>
>I am setting out to build a basic split testing program for pages on my
>site. I am wondering what is the best approach to database design.
>Basically, I'll have two pages PAGE A and PAGE B that I want to show
>equally.  And I want to track how many times each page is viewed, and how
>many times the form on that page is filled out. So basically I have two
>parts:
>
>Part 1 (Display):
>---
-
>-
>- Alternate between showing PAGE A or PAGE B:
>
>My thoughts on this would be to first have a table with 1 record per split
>test campaign. It would have the template paths and the campaign info. Then
>I would call display.cfm?campaignID=12 which would get the campaign from
>the database and then store it in the Application Scope with a flag next to
>the page which is currently being shown.
>
>The next request would check the application scope for the campaign and if
>it exists, get the item that is not flagged, redirect the user, and update
>the flag. Does this make sense? How should this be locked?
>
>Part 2 (Tracking)
>---
-
>-
>- track impressions
>- track actions/completions
>
>When the page loads It will include a call to
>track.cfm?campaignID=12&page=PAGEA&type=view to track the impression. If
>the form on the page gets submitted, another call to
>track.cfm?campaignID=12&page=PAGEA&type=action to track the form
submission.
>
>My concern is regarding the DB design and how fast this would be? If my
>table looked like this:
>
>===
>SplitTestTrack_tbl
>--
>id
>pagename
>campaignID
>type
>cDateTime
>IP
>===
>
>Would this be two slow? How many rows would it take before this started to
>run slowly? Does this design seem okay?
>
>Thanks for the advice!
>
>BrookD
>
>
>
>
>
>



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243411
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Tracking hits/impressions DB design Considerations

[blists]

Jacob,

It could possibly be eliminated if it would reduce server resources. We can 
consider it. Why? Is there a better way to increment a counter of some sort?

BrookD

At 02:41 PM 6/13/2006, you wrote:
>Is it necessary to keep track of the date and IP address for your program?
>
>-Original Message-
>From: blists [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, June 13, 2006 11:56 AM
>To: CF-Talk
>Subject: Tracking hits/impressions DB design Considerations
>
>Hello,
>
>I am setting out to build a basic split testing program for pages on my
>site. I am wondering what is the best approach to database design.
>Basically, I'll have two pages PAGE A and PAGE B that I want to show
>equally.  And I want to track how many times each page is viewed, and how
>many times the form on that page is filled out. So basically I have two
>parts:
>
>Part 1 (Display):
>
>-
>- Alternate between showing PAGE A or PAGE B:
>
>My thoughts on this would be to first have a table with 1 record per split
>test campaign. It would have the template paths and the campaign info. Then
>I would call display.cfm?campaignID=12 which would get the campaign from
>the database and then store it in the Application Scope with a flag next to
>the page which is currently being shown.
>
>The next request would check the application scope for the campaign and if
>it exists, get the item that is not flagged, redirect the user, and update
>the flag. Does this make sense? How should this be locked?
>
>Part 2 (Tracking)
>
>-
>- track impressions
>- track actions/completions
>
>When the page loads It will include a call to
>track.cfm?campaignID=12&page=PAGEA&type=view to track the impression. If
>the form on the page gets submitted, another call to
>track.cfm?campaignID=12&page=PAGEA&type=action to track the form submission.
>
>My concern is regarding the DB design and how fast this would be? If my
>table looked like this:
>
>===
>SplitTestTrack_tbl
>--
>id
>pagename
>campaignID
>type
>cDateTime
>IP
>===
>
>Would this be two slow? How many rows would it take before this started to
>run slowly? Does this design seem okay?
>
>Thanks for the advice!
>
>BrookD
>
>
>
>
>
>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243410
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Tracking hits/impressions DB design Considerations

[Jacob]

Is it necessary to keep track of the date and IP address for your program?

-Original Message-
From: blists [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 11:56 AM
To: CF-Talk
Subject: Tracking hits/impressions DB design Considerations

Hello,

I am setting out to build a basic split testing program for pages on my 
site. I am wondering what is the best approach to database design. 
Basically, I'll have two pages PAGE A and PAGE B that I want to show 
equally.  And I want to track how many times each page is viewed, and how 
many times the form on that page is filled out. So basically I have two
parts:

Part 1 (Display):

-
- Alternate between showing PAGE A or PAGE B:

My thoughts on this would be to first have a table with 1 record per split 
test campaign. It would have the template paths and the campaign info. Then 
I would call display.cfm?campaignID=12 which would get the campaign from 
the database and then store it in the Application Scope with a flag next to 
the page which is currently being shown.

The next request would check the application scope for the campaign and if 
it exists, get the item that is not flagged, redirect the user, and update 
the flag. Does this make sense? How should this be locked?

Part 2 (Tracking)

-
- track impressions
- track actions/completions

When the page loads It will include a call to 
track.cfm?campaignID=12&page=PAGEA&type=view to track the impression. If 
the form on the page gets submitted, another call to 
track.cfm?campaignID=12&page=PAGEA&type=action to track the form submission.

My concern is regarding the DB design and how fast this would be? If my 
table looked like this:

===
SplitTestTrack_tbl
--
id  
pagename
campaignID
type
cDateTime
IP
===

Would this be two slow? How many rows would it take before this started to 
run slowly? Does this design seem okay?

Thanks for the advice!

BrookD





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243409
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Alan Rother]

Not really, it's just a habit. I like to explicitlly control the name of the
resulting variable.

Dave is right, as usual, you can just leave it and it will retain it's given
column name.

-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243408
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CFMX7 changed names of "custom" http headers?

[Gaulin, Mark]

Hi
I use an ISAPI filter (on IIS) to set header variables which
automatically get parsed into the CGI scope. Prior to CFMX7, all of my
header vars had CGI names with a "HTTP_" prefix, so adding a header "x:
value" would create CGI.HTTP_X = "value".  I just noticed on my dev box
that CFMX7 does not prefix "HTTP_". And, since the CGI scope is
read-only, I cannot just map one set of headers to the other in
application.cfm, which means code changes everywhere that uses the
header, and code that is either CFMX6-specific (and older) or
CFMX7-specific.

Is there some setting somewhere that would make CFMX7 compatible with
CFMX6?   I know it's a long shot, but this kind of (needless)
incompatibility is real pain in the butt.

Thanks
Mark

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243407
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Dave Watts]

> Question:  What's the benefit to using the alias?  Is there a 
> benefit or is its usage just required?
> 
> Could it just be:
> 
> Select distinct Book_Genre
>   from Books
> order by Book_Genre

You don't need an alias. "SELECT DISTINCT fieldname FROM tablename" will do.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243406
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

Yep...it was one of those "duh" moments...

Thanks for your help.

Rick


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 4:41 PM
To: CF-Talk
Subject: RE: Group By function for MS SQL Server Express 2005?

> Just a list of the genres to fill out a dropdown list...

SELECT DISTINCT Genre FROM Book

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243405
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

That's right...exactly the conclusion I thought of after I emailed.

I should have just used the DISTINCT function.

Question:  What's the benefit to using the alias?  Is there a benefit
or is its usage just required?

Could it just be:

Select distinct Book_Genre
  from Books
order by Book_Genre

???

Rick

-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 3:55 PM
To: CF-Talk
Subject: Re: Group By function for MS SQL Server Express 2005?

SELECT DISTINCT(Book_Genre) AS MyGenre
FROM Books
ORDER BY Book_Genre

This will accomplish what you want.

=]






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243404
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Does Interakt's KTML work with CF? Are there any other similar products for CF?

[Graeme, Kevin]

I haven't used it, but I talked with them at MAX a few years ago and it
mostly worked with CF then. I guess there were a few features they were
still working on adding, but iirc it did work.

---
Kevin Graeme
Cooperative Extension Technology Services
University of Wisconsin-Extension
 

> -Original Message-
> From: Jeff Small [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, June 13, 2006 3:43 PM
> To: CF-Talk
> Subject: Does Interakt's KTML work with CF? Are there any 
> other similar products for CF?
> 
> Okay, I've never done this before...
> 
> Has anyone used Interakt's "KTML" extension for Dreamweaver? 
> It basically allows you to have a text area with a little 
> formatting toolbar up top for boldface, italics, etc...
> 
> I've just never messed with one before, how do you store the 
> text in a database table (say Access or SQL "text" fields or 
> "memo" fields). Do they contain markup? How do you display 
> that output with just your run of the mill CFOUTPUT tags? Do 
> they work in conjunction with "ParagraphFormat()"?
> 
> This is what I'm talking about, by the way...
> http://www.interaktonline.com/Products/Online-HTML-Editor/KTML
> -for-Dreamweaver/Overview/
> 
> Something like that...I've just never messed with one...
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243403
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Batch file to Stop/Start ColdFusion MX...

[Jim Wright]

On 6/13/06, John C. Bland II <[EMAIL PROTECTED]> wrote:
> Sean Tierney had a good blog post about this. Check it out
> here

I've also found it handy to put links to batch files like those under
Run/External Tools in eclipse.  Makes it easy to turn on and off your
dev environment while developing.

-- 
Jim Wright
Wright Business Solutions
[EMAIL PROTECTED]
919-417-2257

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243402
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Does Interakt's KTML work with CF? Are there any other similar products for CF?

[Jeff Small]

Okay, I've never done this before...

Has anyone used Interakt's "KTML" extension for Dreamweaver? It basically 
allows you to have a text area with a little formatting toolbar up top for 
boldface, italics, etc...

I've just never messed with one before, how do you store the text in a database 
table (say Access or SQL "text" fields or "memo" fields). Do they contain 
markup? How do you display that output with just your run of the mill CFOUTPUT 
tags? Do they work in conjunction with "ParagraphFormat()"?

This is what I'm talking about, by the way...
http://www.interaktonline.com/Products/Online-HTML-Editor/KTML-for-Dreamweaver/Overview/

Something like that...I've just never messed with one...


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243401
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Dave Watts]

> Just a list of the genres to fill out a dropdown list...

SELECT DISTINCT Genre FROM Book

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243400
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfoutput with groups and a startrow

[Chris Mueller]

I'm trying to output a grouped query using a startrow and maxrows.
Something like this:



 
   #myQuery.Foo#
   
 
 #myQuery.Bar#

 




When startrow is 1, the output is as expected and I see 10 rows in the
table that correspond to the first ten rows (grouped) from my query.
When startrow is 11, the first row I see is what I would label row 5.
It seems that this is because ColdFusion is determining the startrow
before grouping is applied. The calculation of output for maxrows,
however, seems to be determined after grouping is applied. Is this a
correct evaluation of what's happening? Maybe I'm missing something.
I'm running CFMX 6.1.

I hope this makes sense. Basically what I want to do is output a
grouped query and use the startrow and maxrows attributes as they
would apply to the query after it has been grouped.

Thanks.
Chris

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243399
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SOT: Getting data into a web site

[Michael E. Carluen]

Would be great to have a "paste from clipboard" functionality into CFGRID
generated form.  



-Original Message-
From: Chris Mueller [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 11:35 AM
To: CF-Talk
Subject: Re: SOT: Getting data into a web site

Actually, applications like Google Spreadsheets support this kind of
interface (to some extent, at least). I suppose it would be a little
difficult to get the Google engineers to let you at their databases,
though. ;-)

Chris

On 6/13/06, Chad Gray <[EMAIL PROTECTED]> wrote:
> Slight rant too let loose of some tension.
>
> You know what would be nice is if there was a way for a user sitting in
their cubicle to be able to copy data from Excel and paste this data
directly into a web page then hit submit to insert it into a database
>
> It has to be dummy proof!  So don't tell me to have them paste in comma
delimited data then parse it.
>
> When they paste it should look like it did in excel...
>
> Is there currently anything?
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243398
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: index.cfm Conundrum

[Ian Skinner]

Like I said, I believe I was having a similar issue.  I just re-installed my CF 
in multi-home configuration.

When I put a file, hello.cfm in my localhost site root, c:\\inetpub\wwwroot\ it 
worked fine with the url http://localhost/hello.cfm.  Then I put hello.cfm in 
my Jrun instance root, c:\jrun\servers\cfusion\cfusion.ear\cfusion.war\.  Then 
localhost/hello.cfm pulled from the jrun root, as expected.  But when I removed 
the hello.cfm file from the jrun root, I started getting a file not found 
error, even though I still had a hello.cfm in my webroot.  When I unclicked the 
"save class files" option in the administrator's cache settings, I started 
getting the webroot hello.cfm file again.  I suspect there is some kind of path 
caching still going on when the cache class files option is checked.

And looking at the setting, Adobe nee Macromedia does recommend to uncheck this 
value in development environments.  


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243397
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF Requred Fields Not Working As Expected

[Tim Claremont]

The CFFORM tag looks like this:




The submit button looks like this:



I *DO* have some javascript on the page. It is entirely outside the CFFORM tag. 
It is used to populate a REQUIRED drop down list that is INSIDE the form, and I 
suspect this is where the trouble lies.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243396
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Alan Rother]

SELECT DISTINCT(Book_Genre) AS MyGenre
FROM Books
ORDER BY Book_Genre

This will accomplish what you want.

=]

-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243395
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF Requred Fields Not Working As Expected

[Josh Nathanson]

Is your submit button a true submit button?  I have run into trouble with 
cfform if the submit button is type "button" with other js stuff attached to 
it, or a link that contains 'document.theform.submit();' or some such to do 
the form submission.  That can interfere with or supercede the cfform 
scripts.

-- Josh


- Original Message - 
From: "Claude Schneegans" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, June 13, 2006 12:27 PM
Subject: Re: CF Requred Fields Not Working As Expected


> >>I have a form with a number of requred fields. Messages are assigned to
> these fields.
>
> Is it an HTML form or a CFFORM?
> If the first, this is not a CF problem, but a Javascript problem.
> Can you show us some code, in particular the FORM tag?
>
> -- 
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243394
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: Getting data into a web site

[Claude Schneegans]

 >>I suppose the google
spreadsheet is capturing the paste event and then parsing the input
and putting the resulting fields in the correct places.

That sounds logical.
I capture what's pasted in textarea this way and clean up the MS Word.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243393
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF Requred Fields Not Working As Expected

[Claude Schneegans]

 >>I have a form with a number of requred fields. Messages are assigned to
these fields.

Is it an HTML form or a CFFORM?
If the first, this is not a CF problem, but a Javascript problem.
Can you show us some code, in particular the FORM tag?

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243392
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

Just a list of the genres to fill out a dropdown list...


-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 1:16 PM
To: CF-Talk
Subject: Re: Group By function for MS SQL Server Express 2005?

Are you trying to get a count of all of the books by Genre? Or are you
trying to get a list of all of the genres?
--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243391
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: Getting data into a web site

[Jim Wright]

>
> It has to be dummy proof!  So don't tell me to have them paste in comma 
> delimited data then parse it.
>

Have them paste in the data directly from excel data and then parse
it...I believe that excel pastes with chr(9) between the fields and
chr(13)chr(10) at the end of each line.  I suppose the google
spreadsheet is capturing the paste event and then parsing the input
and putting the resulting fields in the correct places.

-- 
Jim Wright
Wright Business Solutions
[EMAIL PROTECTED]
919-417-2257

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243390
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: model-glue editor

[dave]

ty

~Dave - formerly known as "the disruptor"~ 


From: "Joe Rinehart" <[EMAIL PROTECTED]>
Sent: Tuesday, June 13, 2006 10:26 AM
To: CF-Talk 
Subject: Re: model-glue editor 

Hey Dave,

Try XMLBuddy - the free version makes it easy to associate a given XML file
with a given DTD, and it'll close things for you, etc.

On 6/13/06, dave  wrote:
>
> well i'll be damned! I wished it closed them tho but thats a good start :)
>
> ~Dave - formerly known as "the disruptor"~
>
> 
> From: [EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 2:40 AM
> To: CF-Talk 
> Subject: Re: model-glue editor
>
> > So I dove into mg but the thing I immediately found was that dw nor cfe
> > has any code hints in them
>
> For DW, get the DTD from MG's distro. Then:
>
> Edit > Tag Libraries > + DTD or Schema > Import XML DTD
>
> Massimo
>
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243389
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Best Practices - Source Control and Hotfixes

[Qasim Rasheed]

Not to contradict the usefulness of SVN, there is a plugin for VSS that you
use within Eclipse which essentially gives you all the feature from VSS IDE
that you are accustomed to.

HTH

Qasim


On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
>
> Most of my people use CFEclipse.  I have one CFStudio/HS+ holdover.
> The integration points via the SVN plugin were just one of the
> attractions of moving to SVN from VSS.
>
> On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> > (At the further risk of crazy people) what IDE are you using, because I
> > found that easy of use for the development team is a key factor. That is
> > what prompted us to switch to eclipse. There are other clients, and good
> > ones, but for me having it integrated in the ide was key. With eclipse
> all
> > your source control is on a right click within the IDE and eclipse
> smooths
> > the awkward edges of some CVS functions (e.g. new files have to be added
> > then commited before they are in the repository, but eclipse does the
> add
> > silently for you and treats new files same as amended ones - you just
> have
> > to commit then), Another great source code related feature is that you
> can
> > compare the local version of a file with any historic version that was
> > committed to the repostory and see a 'diff' view of the two files side
> by
> > side. You also see a history of the current file you are working on in a
> > pane within eclipse so you can see who worked on it when it was
> committed
> > and the comment they entered when they committed.  The other major
> feature
> > is the ability to create a branch to do big software changes alongside
> > bugfixes without the two code lines overlapping. I have some stuff
> regarding
> > this on my blog but it is CVS centric.
> >
> > On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> > >
> > > True, but in this case we already own VSS so cost is less of a factor.
> > > I have to sell added value and less-than-absurd conversion costs.  To
> > > that end, any conversion resources anyone could offer would be great.
> > > Also, any selling points on the value added side would be helpful.
> > >
> > >
> > --
> > Mike T
> > Blog http://www.socialpoints.com/
> > This e-mail may contain privileged and confidential information and/or
> > copyright material and is intended for the use of the addressee only. If
> you
> > receive this e-mail by mistake please advise the sender immediately by
> using
> > the reply facility in your e-mail software and delete this e-mail from
> your
> > computer system. You may not deliver, copy or disclose its contents to
> > anyone else. Any unauthorised use may be unlawful. Any views expressed
> in
> > this e-mail are those of the individual sender and may not necessarily
> > reflect the views of The Collinson Group Ltd and/or its subsidiaries.
> >
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243388
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Tracking hits/impressions DB design Considerations

[blists]

Hello,

I am setting out to build a basic split testing program for pages on my 
site. I am wondering what is the best approach to database design. 
Basically, I'll have two pages PAGE A and PAGE B that I want to show 
equally.  And I want to track how many times each page is viewed, and how 
many times the form on that page is filled out. So basically I have two parts:

Part 1 (Display):
-
- Alternate between showing PAGE A or PAGE B:

My thoughts on this would be to first have a table with 1 record per split 
test campaign. It would have the template paths and the campaign info. Then 
I would call display.cfm?campaignID=12 which would get the campaign from 
the database and then store it in the Application Scope with a flag next to 
the page which is currently being shown.

The next request would check the application scope for the campaign and if 
it exists, get the item that is not flagged, redirect the user, and update 
the flag. Does this make sense? How should this be locked?

Part 2 (Tracking)
-
- track impressions
- track actions/completions

When the page loads It will include a call to 
track.cfm?campaignID=12&page=PAGEA&type=view to track the impression. If 
the form on the page gets submitted, another call to 
track.cfm?campaignID=12&page=PAGEA&type=action to track the form submission.

My concern is regarding the DB design and how fast this would be? If my 
table looked like this:

===
SplitTestTrack_tbl
--
id  
pagename
campaignID
type
cDateTime
IP
===

Would this be two slow? How many rows would it take before this started to 
run slowly? Does this design seem okay?

Thanks for the advice!

BrookD



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243387
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: Getting data into a web site

[Sam Farmer]

If the spreadsheets are in a standard layout you could allow users to
upload them.

Then in CF connect to the spreadsheet via a datasource and get the
data that way.

Cheers,

Sam F

On 6/13/06, Chris Mueller <[EMAIL PROTECTED]> wrote:
> Actually, applications like Google Spreadsheets support this kind of
> interface (to some extent, at least). I suppose it would be a little
> difficult to get the Google engineers to let you at their databases,
> though. ;-)
>
> Chris
>
> On 6/13/06, Chad Gray <[EMAIL PROTECTED]> wrote:
> > Slight rant too let loose of some tension.
> >
> > You know what would be nice is if there was a way for a user sitting in 
> > their cubicle to be able to copy data from Excel and paste this data 
> > directly into a web page then hit submit to insert it into a database
> >
> > It has to be dummy proof!  So don't tell me to have them paste in comma 
> > delimited data then parse it.
> >
> > When they paste it should look like it did in excel...
> >
> > Is there currently anything?
> >
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243386
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: Getting data into a web site

[Chris Mueller]

Actually, applications like Google Spreadsheets support this kind of
interface (to some extent, at least). I suppose it would be a little
difficult to get the Google engineers to let you at their databases,
though. ;-)

Chris

On 6/13/06, Chad Gray <[EMAIL PROTECTED]> wrote:
> Slight rant too let loose of some tension.
>
> You know what would be nice is if there was a way for a user sitting in their 
> cubicle to be able to copy data from Excel and paste this data directly into 
> a web page then hit submit to insert it into a database
>
> It has to be dummy proof!  So don't tell me to have them paste in comma 
> delimited data then parse it.
>
> When they paste it should look like it did in excel...
>
> Is there currently anything?
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243385
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfhttp with https and self generated certificates

[Russ]

I decided to skip the hassle and buy a $30 cert from X-Registrar.  Took only
a few mins and now it works with CF and I get no warning on the browser.  I
think that's money well spent.  (I'll see if I can use the same cert to
secure pop3s and smtps, to get rid of those annoying warnings in
thunderbird).  

Thanks for your help all.  

Russ

> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 1:11 PM
> To: CF-Talk
> Subject: RE: cfhttp with https and self generated certificates
> 
> You can find out what is in your keystore using the keytool (if you are
> using the Sun jvm). Here's the syntax.
> 
> C:\CFusionMX\runtime\jre\lib>keytool -list -storepass changit -noprompt
> -keystore C:\CFusionMX\runtime\jre\lib\security\cacerts
> 
> I have a blog post on this issue:
> 
> http://mkruger.cfwebtools.com/index.cfm?mode=entry&entry=8E44925A-B73D-
> E3AD-
> 709D4E02FD6D4588
> 
> It's a hassle I know - but you only have to  do it once :)
> 
> -mark
> 
> 
> 
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:46 AM
> To: CF-Talk
> Subject: RE: cfhttp with https and self generated certificates
> 
> When you choose to trust a certificate, the browser doesn't import it
> right
> away... it imports it for that session only.  Why can't cfhttp have a
> similar setting where it allows you to use a certificate just for that
> session?
> 
> How do I know what vendors are in the keystore?  Has anyone tried using
> those cheap certs with CF and know whether they work out of the box?
> 
> Russ
> 
> > -Original Message-
> > From: Mark A Kruger [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 11:39 AM
> > To: CF-Talk
> > Subject: RE: cfhttp with https and self generated certificates
> >
> > In order to make a successful connection the key has to be imported.
> > Otherwise it cannot unencrypt the stream. Don't confuse this error
> > with the browser warning error. In the case of the browser warning it
> > is giving you a choice - do you want to accept (import into keystore)
> > this certificate?
> > Choosing yes, allows the cert to be trusted.
> >
> > In Java you have to do this programatically.  If you use something
> > like X-registrar it "may" work IF that vendor is in the keystore. If
> > not, you would have to import that one as well.
> >
> > -Mark
> >
> >
> >
> > -Original Message-
> > From: Russ [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 10:25 AM
> > To: CF-Talk
> > Subject: cfhttp with https and self generated certificates
> >
> > I am trying to use cfhttp over https and I'm getting "I/O Exception:
> > peer not authenticated".  A quck google search turns up that I need to
> > import the certificate into my keystore.  Isn't there a way to tell
> > CFHTTP to ignore certificate warnings?  The certificate in question is
> > a self generated apache certificate.  Will a Turbo SSL from somewhere
> > like X-Registrar.com work out of the box, or will I still have to
> > import something?
> >
> >
> >
> > Russ
> >
> >
> >
> >
> >
> >
> 
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243384
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Best Practices - Source Control and Hotfixes

[Rob Wilkerson]

Most of my people use CFEclipse.  I have one CFStudio/HS+ holdover.
The integration points via the SVN plugin were just one of the
attractions of moving to SVN from VSS.

On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> (At the further risk of crazy people) what IDE are you using, because I
> found that easy of use for the development team is a key factor. That is
> what prompted us to switch to eclipse. There are other clients, and good
> ones, but for me having it integrated in the ide was key. With eclipse all
> your source control is on a right click within the IDE and eclipse smooths
> the awkward edges of some CVS functions (e.g. new files have to be added
> then commited before they are in the repository, but eclipse does the add
> silently for you and treats new files same as amended ones - you just have
> to commit then), Another great source code related feature is that you can
> compare the local version of a file with any historic version that was
> committed to the repostory and see a 'diff' view of the two files side by
> side. You also see a history of the current file you are working on in a
> pane within eclipse so you can see who worked on it when it was committed
> and the comment they entered when they committed.  The other major feature
> is the ability to create a branch to do big software changes alongside
> bugfixes without the two code lines overlapping. I have some stuff regarding
> this on my blog but it is CVS centric.
>
> On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> >
> > True, but in this case we already own VSS so cost is less of a factor.
> > I have to sell added value and less-than-absurd conversion costs.  To
> > that end, any conversion resources anyone could offer would be great.
> > Also, any selling points on the value added side would be helpful.
> >
> >
> --
> Mike T
> Blog http://www.socialpoints.com/
> This e-mail may contain privileged and confidential information and/or
> copyright material and is intended for the use of the addressee only. If you
> receive this e-mail by mistake please advise the sender immediately by using
> the reply facility in your e-mail software and delete this e-mail from your
> computer system. You may not deliver, copy or disclose its contents to
> anyone else. Any unauthorised use may be unlawful. Any views expressed in
> this e-mail are those of the individual sender and may not necessarily
> reflect the views of The Collinson Group Ltd and/or its subsidiaries.
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243383
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: announce: ColdFusion Cookbook hits 100

[Massimo Foti]

Thanks for the great resource. Both to Ray and all contributors.

  
Massimo Foti
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
  


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243382
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: index.cfm Conundrum

[Sung Woo]

I had this issue with 6.1, but it's the first time I've experienced it with 7.  
I'm not sure the save class file will help, but I'll give it a shot.

Keep in mind that this is only happening with the index.cfm file, nowhere else, 
and only when it's called from root.  So to summarize:

http://localhost/index.cfm pulls in c:\cfusionmx7\wwwroot\index.cfm
http://localhost/default.cfm pulls in d:\site1\default.cfm
http://localhost/app/index.cfm pulls in d:\site1\app\index.cfm

http://localhost:81/index.cfm pulls in c:\cfusionmx7\wwwroot\index.cfm
http://localhost:81/default.cfm pulls in d:\site2\default.cfm
http://localhost:81/app/index.cfm pulls in d:\site2\app\index.cfm

It's only index.cfm, and only if it's being pulled in off the root.  Like I 
said, it's a very weird issue.

>The save class files simple saves the java byte code of a given file.
>As I understand it, it's the other option that caches only one
>location for the file.  For example, on a multi-homed server (a web
>server serving more than one CF site), if the index.cfm file for site1
>is rendered first, then any calls for index.cfm on site2 will be
>served site1's index.cfm because the server path for index.cfm was
>cached as the path to site1.  Likewise, if no file was cached and
>site2 was called first then the path to index.cfm would be cached as
>that of site2.
>
>This was a problem in v6.x because the caching value defaulted to true
>(cache the path) and it wasn't available in the administrator.  You
>had to edit the XML config file to change it.  The problem you're
>describing sounds like that to me.
>
>On 6/13/06, Sung Woo <[EMAIL PROTECTED]> wrote:
>>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243381
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Bar codes

[Robert Everland III]

Check this out


http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=7&threadid=973582&highlight_key=y&keyword1=itext



Bob

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243380
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Dave Watts]

> Ok...I had read a message that mentioned the aggregate 
> function requirement...but how would I write my example 
> query to include an (unneeded?) aggregate function?
> 
> (And why would there be an aggregate requirement anyway?)
> 
> Query (MySQL version):
> 
> Select * from books group by genre

The GROUP BY clause requires an aggregate because its sole purpose is to let
you perform aggregations on subsets of data returned by your query, instead
of on the entire set. I don't use MySQL very much, but I can't even imagine
what your example query would return, since there is no aggregation upon
which to group. How, in your example, does the query differ from one with no
GROUP BY clause?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243379
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Server firewall software

[Bryan Stevenson]

Thanks to Dave, Denny and Jochem for the IP Security Policy infoI see where 
it's going now and will peruse the tutorials etc to get the full picture

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243378
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SOT: Getting data into a web site

[Chad Gray]

Slight rant too let loose of some tension.

You know what would be nice is if there was a way for a user sitting in their 
cubicle to be able to copy data from Excel and paste this data directly into a 
web page then hit submit to insert it into a database

It has to be dummy proof!  So don’t tell me to have them paste in comma 
delimited data then parse it.

When they paste it should look like it did in excel...

Is there currently anything?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243377
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

announce: ColdFusion Cookbook hits 100

[Raymond Camden]

I hope folks don't mind the advertisement (although its for a free
resource), but I just wanted to make sure folks were aware that the
ColdFusion Cookbook (www.coldfusioncookbook.com) hit 100 entries
today. Most of the thanks go to Jeremy Petersen. I built the
framework, but he did most of the publishing.



-- 
===
Raymond Camden, Vice President of Technology for roundpeg

Email: [EMAIL PROTECTED]
Blog : ray.camdenfamily.com
AOL IM   : cfjedimaster

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

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243376
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Best Practices - Source Control and Hotfixes

[Michael Traher]

(At the further risk of crazy people) what IDE are you using, because I
found that easy of use for the development team is a key factor. That is
what prompted us to switch to eclipse. There are other clients, and good
ones, but for me having it integrated in the ide was key. With eclipse all
your source control is on a right click within the IDE and eclipse smooths
the awkward edges of some CVS functions (e.g. new files have to be added
then commited before they are in the repository, but eclipse does the add
silently for you and treats new files same as amended ones - you just have
to commit then), Another great source code related feature is that you can
compare the local version of a file with any historic version that was
committed to the repostory and see a 'diff' view of the two files side by
side. You also see a history of the current file you are working on in a
pane within eclipse so you can see who worked on it when it was committed
and the comment they entered when they committed.  The other major feature
is the ability to create a branch to do big software changes alongside
bugfixes without the two code lines overlapping. I have some stuff regarding
this on my blog but it is CVS centric.

On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
>
> True, but in this case we already own VSS so cost is less of a factor.
> I have to sell added value and less-than-absurd conversion costs.  To
> that end, any conversion resources anyone could offer would be great.
> Also, any selling points on the value added side would be helpful.
>
>
-- 
Mike T
Blog http://www.socialpoints.com/
This e-mail may contain privileged and confidential information and/or
copyright material and is intended for the use of the addressee only. If you
receive this e-mail by mistake please advise the sender immediately by using
the reply facility in your e-mail software and delete this e-mail from your
computer system. You may not deliver, copy or disclose its contents to
anyone else. Any unauthorised use may be unlawful. Any views expressed in
this e-mail are those of the individual sender and may not necessarily
reflect the views of The Collinson Group Ltd and/or its subsidiaries.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243375
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CF Requred Fields Not Working As Expected

[Claremont, Timothy]

Using 7.1 on Win2k3 Server. HTML forms. NOT Flash forms.

I have a form with a number of requred fields. Messages are assigned to
these fields.

If I hit the submit button while leaving requred fields blank, I get a
dialog box informing me of the problems with the form, just as expected.

But when I click OK on the error dialog box, the form submits anyway,
resulting in an error message generated by the action page, because it
expects values in the required fields.

In the event that a required field is not filled, shouldn't the dialog
box return the user to the form, instead of forwarding them to the
submission page? I dont recall having this specific problem before, so I
am a bit flummoxed. 

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243374
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Greg Morphis]

What information are you trying to get then?


On 6/13/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> But why does it require that the count be calculated
> if I don't need that information?
>
>
>
>
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 1:05 PM
> To: CF-Talk
> Subject: Re: Group By function for MS SQL Server Express 2005?
>
> But it is needed, that query is returning the count of the books per
> book_genre
>
> On 6/13/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> > I finally did get Express to give me the results I wanted...
> >
> > Here's the solution the Query Builder gave:
> >
> > Select Count(*) as Expr2, Book_Genre
> > from Books
> > Group By Book_Genre
> > Order By Book_Genre
> >
> > Seems strange to require an unneeded aggregate function...
> >
> > Rick
> >
> >
> >
> >
> > -Original Message-
> > From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 12:43 PM
> > To: CF-Talk
> > Subject: RE: Group By function for MS SQL Server Express 2005?
> >
> > Ok...I had read a message that mentioned the aggregate function
> > requirement...but how would I write my example query to include an
> > (unneeded?) aggregate function?
> >
> > (And why would there be an aggregate requirement anyway?)
> >
> >
> > Query (MySQL version):
> >
> > Select * from books group by genre
> >
> >
> >
> > -Original Message-
> > From: Alan Rother [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 12:31 PM
> > To: CF-Talk
> > Subject: Re: Group By function for MS SQL Server Express 2005?
> >
> > Here is a simple example using the Northwind database in SQL Server
> >
> >
> > The key to the GROUP BY clause is that is needs to be used in
> > aggregate functions
> >
> >
> > SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName FROM Products
> > AS P INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID GROUP
> > BY P.CategoryID, C.CategoryName
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243373
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: index.cfm Conundrum

[Rob Wilkerson]

The save class files simple saves the java byte code of a given file.
As I understand it, it's the other option that caches only one
location for the file.  For example, on a multi-homed server (a web
server serving more than one CF site), if the index.cfm file for site1
is rendered first, then any calls for index.cfm on site2 will be
served site1's index.cfm because the server path for index.cfm was
cached as the path to site1.  Likewise, if no file was cached and
site2 was called first then the path to index.cfm would be cached as
that of site2.

This was a problem in v6.x because the caching value defaulted to true
(cache the path) and it wasn't available in the administrator.  You
had to edit the XML config file to change it.  The problem you're
describing sounds like that to me.

On 6/13/06, Sung Woo <[EMAIL PROTECTED]> wrote:
> "Save class files" is checked.  I bet I need to restart the server, right?  
> I'll have to wait to do that.
>
> > Hi Rob,
> >
> > Thanks -- it's not checked.
> >
> > Are all three values unchecked?  I just unchecked the middle one and
> > it resolved a somewhat similar issue for me.
> >
> >
> > --
> > Ian Skinner
> > Web Programmer
> > BloodSource
> > www.BloodSource.org
> > Sacramento, CA
> >
> > -
> > | 1 |   |
> > -  Binary Soduko
> > |   |   |
> > -
>
> >
> > "C code. C code run. Run code run. Please!"
> > - Cynthia Dunning
> >
> > Confidentiality Notice:  This message including any
> > attachments is for the sole use of the intended
> > recipient(s) and may contain confidential and privileged
> > information. Any unauthorized review, use, disclosure or
> > distribution is prohibited. If you are not the
> > intended recipient, please contact the sender and
> > delete any copies of this message.
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243372
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

But why does it require that the count be calculated
if I don't need that information?




-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 1:05 PM
To: CF-Talk
Subject: Re: Group By function for MS SQL Server Express 2005?

But it is needed, that query is returning the count of the books per
book_genre

On 6/13/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> I finally did get Express to give me the results I wanted...
>
> Here's the solution the Query Builder gave:
>
> Select Count(*) as Expr2, Book_Genre
> from Books
> Group By Book_Genre
> Order By Book_Genre
>
> Seems strange to require an unneeded aggregate function...
>
> Rick
>
>
>
>
> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 12:43 PM
> To: CF-Talk
> Subject: RE: Group By function for MS SQL Server Express 2005?
>
> Ok...I had read a message that mentioned the aggregate function 
> requirement...but how would I write my example query to include an
> (unneeded?) aggregate function?
>
> (And why would there be an aggregate requirement anyway?)
>
>
> Query (MySQL version):
>
> Select * from books group by genre
>
>
>
> -Original Message-
> From: Alan Rother [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 12:31 PM
> To: CF-Talk
> Subject: Re: Group By function for MS SQL Server Express 2005?
>
> Here is a simple example using the Northwind database in SQL Server
>
>
> The key to the GROUP BY clause is that is needs to be used in 
> aggregate functions
>
>
> SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName FROM Products 
> AS P INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID GROUP 
> BY P.CategoryID, C.CategoryName
>
>
>
>
>
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243371
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: index.cfm Conundrum

[Sung Woo]

"Save class files" is checked.  I bet I need to restart the server, right?  
I'll have to wait to do that.

> Hi Rob,
> 
> Thanks -- it's not checked.
> 
> Are all three values unchecked?  I just unchecked the middle one and 
> it resolved a somewhat similar issue for me.
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> -
> | 1 |   |
> -  Binary Soduko
> |   |   |
> -
 
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message. 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243370
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Alan Rother]

Are you trying to get a count of all of the books by Genre? Or are you
trying to get a list of all of the genres?
-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243369
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Alan Rother]

Ok, I see what's going on. You want to out put your records in a group,
thats a CF issue, not a SQL issue.

What you need to do is to use ORDER BY to get your records in the correct
order then user the GROUP attribute of the CFOUTPUT tag


GROUP BY in SQL is for compiling related data and performing calculations,
such as in my example, I wanted to know how many products were in the
Products table, but instead of just knowing how many altogether, I wanted to
know BY category, which is what the SQL GROUP BY does.




-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243368
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfhttp with https and self generated certificates

[Mark A Kruger]

You can find out what is in your keystore using the keytool (if you are
using the Sun jvm). Here's the syntax.

C:\CFusionMX\runtime\jre\lib>keytool -list -storepass changit -noprompt
-keystore C:\CFusionMX\runtime\jre\lib\security\cacerts

I have a blog post on this issue:

http://mkruger.cfwebtools.com/index.cfm?mode=entry&entry=8E44925A-B73D-E3AD-
709D4E02FD6D4588

It's a hassle I know - but you only have to  do it once :)

-mark
 



-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 10:46 AM
To: CF-Talk
Subject: RE: cfhttp with https and self generated certificates

When you choose to trust a certificate, the browser doesn't import it right
away... it imports it for that session only.  Why can't cfhttp have a
similar setting where it allows you to use a certificate just for that
session?

How do I know what vendors are in the keystore?  Has anyone tried using
those cheap certs with CF and know whether they work out of the box?  

Russ

> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 11:39 AM
> To: CF-Talk
> Subject: RE: cfhttp with https and self generated certificates
> 
> In order to make a successful connection the key has to be imported.
> Otherwise it cannot unencrypt the stream. Don't confuse this error 
> with the browser warning error. In the case of the browser warning it 
> is giving you a choice - do you want to accept (import into keystore) 
> this certificate?
> Choosing yes, allows the cert to be trusted.
> 
> In Java you have to do this programatically.  If you use something 
> like X-registrar it "may" work IF that vendor is in the keystore. If 
> not, you would have to import that one as well.
> 
> -Mark
> 
> 
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:25 AM
> To: CF-Talk
> Subject: cfhttp with https and self generated certificates
> 
> I am trying to use cfhttp over https and I'm getting "I/O Exception: 
> peer not authenticated".  A quck google search turns up that I need to 
> import the certificate into my keystore.  Isn't there a way to tell 
> CFHTTP to ignore certificate warnings?  The certificate in question is 
> a self generated apache certificate.  Will a Turbo SSL from somewhere 
> like X-Registrar.com work out of the box, or will I still have to 
> import something?
> 
> 
> 
> Russ
> 
> 
> 
> 
> 
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243367
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Greg Morphis]

But it is needed, that query is returning the count of the books per book_genre

On 6/13/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> I finally did get Express to give me the results I wanted...
>
> Here's the solution the Query Builder gave:
>
> Select Count(*) as Expr2, Book_Genre
> from Books
> Group By Book_Genre
> Order By Book_Genre
>
> Seems strange to require an unneeded aggregate function...
>
> Rick
>
>
>
>
> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 12:43 PM
> To: CF-Talk
> Subject: RE: Group By function for MS SQL Server Express 2005?
>
> Ok...I had read a message that mentioned the aggregate function
> requirement...but how would I write my example query to include an
> (unneeded?) aggregate function?
>
> (And why would there be an aggregate requirement anyway?)
>
>
> Query (MySQL version):
>
> Select * from books group by genre
>
>
>
> -Original Message-
> From: Alan Rother [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 12:31 PM
> To: CF-Talk
> Subject: Re: Group By function for MS SQL Server Express 2005?
>
> Here is a simple example using the Northwind database in SQL Server
>
>
> The key to the GROUP BY clause is that is needs to be used in aggregate
> functions
>
>
> SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName FROM Products AS P
> INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID GROUP BY
> P.CategoryID, C.CategoryName
>
>
>
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243366
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

I finally did get Express to give me the results I wanted...

Here's the solution the Query Builder gave:

Select Count(*) as Expr2, Book_Genre
from Books
Group By Book_Genre
Order By Book_Genre

Seems strange to require an unneeded aggregate function...

Rick




-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 12:43 PM
To: CF-Talk
Subject: RE: Group By function for MS SQL Server Express 2005?

Ok...I had read a message that mentioned the aggregate function
requirement...but how would I write my example query to include an
(unneeded?) aggregate function?

(And why would there be an aggregate requirement anyway?)


Query (MySQL version):

Select * from books group by genre



-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 13, 2006 12:31 PM
To: CF-Talk
Subject: Re: Group By function for MS SQL Server Express 2005?

Here is a simple example using the Northwind database in SQL Server


The key to the GROUP BY clause is that is needs to be used in aggregate
functions


SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName FROM Products AS P
INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID GROUP BY
P.CategoryID, C.CategoryName







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243365
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

Ok...I had read a message that mentioned the aggregate function
requirement...but
how would I write my example query to include an (unneeded?) aggregate
function?

(And why would there be an aggregate requirement anyway?)


Query (MySQL version):

Select * from books group by genre



-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 12:31 PM
To: CF-Talk
Subject: Re: Group By function for MS SQL Server Express 2005?

Here is a simple example using the Northwind database in SQL Server


The key to the GROUP BY clause is that is needs to be used in aggregate
functions


SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName FROM Products AS P
INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID GROUP BY
P.CategoryID, C.CategoryName





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243364
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: index.cfm Conundrum

[Ian Skinner]

Hi Rob,

Thanks -- it's not checked.

Are all three values unchecked?  I just unchecked the middle one and it 
resolved a somewhat similar issue for me.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243363
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Alan Rother]

Here is a simple example using the Northwind database in SQL Server


The key to the GROUP BY clause is that is needs to be used in aggregate
functions


SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName
FROM Products AS P INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID
GROUP BY P.CategoryID, C.CategoryName


-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243362
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: index.cfm Conundrum

[Sung Woo]

Hi Rob,

Thanks -- it's not checked.

> Take a look at your settings in CF Admin.  In the "Caching" settings,
> ensure that " Cache web server paths" is unchecked.  This is 
> important
> for servers running multiple sites.
> 
> On 6/13/06, Sung Woo <[EMAIL PROTECTED]> wrote:
> > I have a very strange issue with a server running CFMX7.  This 
> server initially was running CFMX7 standalone, and when the time came, 
> it was uninstalled and reinstalled as a CFMX7 using IIS.
> >
> > So now here's the wacky issue: no matter the site (on ports 80 and 
> 81), whenever the file index.cfm is pulled from the root, it always 
> goes to c:\cfusionmx7\wwwroot\index.cfm.  It ONLY happens with index.
> cfm -- no other .cfm file does this!  I'm guessing this is because it 
> had once been a standalone installation, so how can I stop this from 
> happening?
> >
> > As a test, I created a dummy site on port 82, and sure enough, the 
> same exact thing happened -- using CF_TEMPLATE_PATH, I can see that 
> c:\cfusionmx7\wwwroot\index.cfm is always the file pulled.  Any help 
> on this would be greatly appreciated.
> >
> > 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243361
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Group By function for MS SQL Server Express 2005?

[Alan Rother]

I've used it.

Can you show us the SQL you are having a problem with?

-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243360
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: index.cfm Conundrum

[Rob Wilkerson]

Take a look at your settings in CF Admin.  In the "Caching" settings,
ensure that " Cache web server paths" is unchecked.  This is important
for servers running multiple sites.

On 6/13/06, Sung Woo <[EMAIL PROTECTED]> wrote:
> I have a very strange issue with a server running CFMX7.  This server 
> initially was running CFMX7 standalone, and when the time came, it was 
> uninstalled and reinstalled as a CFMX7 using IIS.
>
> So now here's the wacky issue: no matter the site (on ports 80 and 81), 
> whenever the file index.cfm is pulled from the root, it always goes to 
> c:\cfusionmx7\wwwroot\index.cfm.  It ONLY happens with index.cfm -- no other 
> .cfm file does this!  I'm guessing this is because it had once been a 
> standalone installation, so how can I stop this from happening?
>
> As a test, I created a dummy site on port 82, and sure enough, the same exact 
> thing happened -- using CF_TEMPLATE_PATH, I can see that 
> c:\cfusionmx7\wwwroot\index.cfm is always the file pulled.  Any help on this 
> would be greatly appreciated.
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243359
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Best Practices - Source Control and Hotfixes

[Rob Wilkerson]

True, but in this case we already own VSS so cost is less of a factor.
 I have to sell added value and less-than-absurd conversion costs.  To
that end, any conversion resources anyone could offer would be great.
Also, any selling points on the value added side would be helpful.

On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> I found the greatest aid to selling CVS/SVN was the price :-)
>
> On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> >
> > I think it does and it means that SVN offers a capability that VSS is
> > fundamentally lacking.  That will make selling this change much
> > easier.  Thanks for your help.
> >
> > On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> > > :-) yes, each of these source systems has a language all its own!
> > > Fortunately CVS and SVN have the same root so thats one mercy.
> > >
> > > The project is all stored in the repository (all versions since you
> > first
> > > created it there or committed your existing source files for the first
> > > time).
> > >
> > > In eclipse (and other CVS/SVN client tools) youcan checkout the entire
> > > project, and the most common files you want are the latest ones these
> > are
> > > the default files you will get if you don't ask for anything else.
> > >
> > > eclipse lets you 'replace' your working copy of a project with another
> > > version from the repository. This other version it identified by a tag
> > (yes
> > > a label) that you have previously told CVS/SVN to apply to a particular
> > set
> > > of files.
> > >
> > > It could be that this tag was applied a week ago and that since then
> > further
> > > changes have taken place to the source code but these changes are not
> > > ready/tested yet so you don't want those. Thats what the tags are for to
> > pin
> > > down a particular consistent set of files from the repository.
> > >
> > > I have always applied tags to all files (so I click on the top folder in
> > the
> > > project) but in response to your request I tried just 3 files. Then I
> > asked
> > > eclipse to replace my current version of the project with the version
> > > represented by the tag. All I got was
> > > /rootfolder
> > >/subfolder
> > >/subsubfolder
> > >file1.cfm
> > >file2.cfm
> > >file3.cfm
> > >
> > > So I could zip/tar this up and then expand on the production server
> > > overwriting just the 3 files as required.
> > >
> > > After this is done I can ask eclipse to 'replace' my project with the
> > latest
> > > version and I will get all the project back again with latest changes.
> > >
> > > Does that make it clearer?
> > >
> > > On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Michael, it sounds like you tried exactly what I'm looking to do, but
> > > > I need to clarify since you used terminology that I'm not familiar
> > > > with (read: non-VSS terms).  I assume "tagging" is "labeling", but
> > > > what do you mean you "replaced the project"?  I need to "tag" a few
> > > > selected files and then extract - using the tag value - those files to
> > > > a build directory (not my standard working directory) where they will
> > > > be consolidated into a tarball.  Once extracted, the build directory
> > > > would contain only the files with the given tag.  Does "replacing the
> > > > project" mean anything like that?  :-)
> > > >
> > > > Thanks.
> > > >
> > > > On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> > > > > I just experimented with tagging just a handful of files (i tried
> > three)
> > > > and
> > > > > then I replaced the project with the 'tag' and all I had was the
> > > > necessary
> > > > > folder tree and the files I had tagged!
> > > > >
> > > > > This would then make a nice neat distribution.
> > > > >
> > > > > (I suspect this is what the 'patch' wizard in eclipse may do for you
> > > > anyway
> > > > > but I've never tried it..)
> > > > >
> > > > > At the risk of crazy people joining the thread eclipse does have
> > very
> > > > nice
> > > > > source control tools CVS built in and SVN as a plugin.
> > > > >
> > > > > On 6/13/06, Tom Chiverton <[EMAIL PROTECTED]> wrote:
> > > > > >
> > > > > > On Monday 12 June 2006 18:25, Rob Wilkerson wrote:
> > > > > > > customers.  Ideally, I'd like to extract only the modified files
> > > > from
> > > > > > > the source control repository so I can then just roll them up in
> > a
> > > > > > > tarball without any additional weeding of what's in and what's
> > out.
> > > > > >
> > > > > > Should be easy enough, you ask SVN for all the changes between the
> > > > last
> > > > > > release revision and the current (with fixes).
> > > > > >
> > > > > > --
> > > > > > Tom Chiverton
> > > > > >
> > > > > > 
> > > > > >
> > > > > > This email is sent for and on behalf of Halliwells LLP.
> > > > > >
> > > > > > Halliwells LLP is a limited liability partnership registered in
> > > > England
> > > > > > and Wales under re

Group By function for MS SQL Server Express 2005?

[Rick Faircloth]

Hi, all.

Does MS SQL Server Express 2005 or even MS SQL Server
not use a "Group By" function?

Rick



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243357
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: XML - looking to return an XML object original parced format

[Ian Sheridan]

Your right I just was writing that way for brevity.

- Ian

On 6/13/06, Dawson, Michael <[EMAIL PROTECTED]> wrote:
> As long as you don't use the same variable "xml" for all of your
> function results, you won't have to re-parse the xml.  Regardless, of
> the size of the xml source, it would be a waste of processing to parse
> it twice in the same request.
>
> cfset xmlObj = xmlParse(xmlSource)
> cfset xmlResult = xmlSearch(xmlObj, "//root/")
> cfset xmlString = xmlResult[1].toString()
>
> M!ke
>
> -Original Message-
> From: Ian Sheridan [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:24 AM
> To: CF-Talk
> Subject: Re: XML - looking to return an XML object original parced
> format
>
> Well this is about returning the data structure to a state that it was
> in when you first parsed the xml. Which I have figured out how to do.
> Here it is:
>
> 
> 
> 
> 
>
> done... :)
>
> - Ian
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243356
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Bar codes

[Ian Skinner]

The standard responses to this request.

Check out barcode font classes.

Check out barcodeZone: http://www.fusionzone.com/applications/barcode/index.cfm.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243355
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

index.cfm Conundrum

[Sung Woo]

I have a very strange issue with a server running CFMX7.  This server initially 
was running CFMX7 standalone, and when the time came, it was uninstalled and 
reinstalled as a CFMX7 using IIS.

So now here's the wacky issue: no matter the site (on ports 80 and 81), 
whenever the file index.cfm is pulled from the root, it always goes to 
c:\cfusionmx7\wwwroot\index.cfm.  It ONLY happens with index.cfm -- no other 
.cfm file does this!  I'm guessing this is because it had once been a 
standalone installation, so how can I stop this from happening?

As a test, I created a dummy site on port 82, and sure enough, the same exact 
thing happened -- using CF_TEMPLATE_PATH, I can see that 
c:\cfusionmx7\wwwroot\index.cfm is always the file pulled.  Any help on this 
would be greatly appreciated.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243354
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfhttp with https and self generated certificates

[Russ]

When you choose to trust a certificate, the browser doesn't import it right
away... it imports it for that session only.  Why can't cfhttp have a
similar setting where it allows you to use a certificate just for that
session?

How do I know what vendors are in the keystore?  Has anyone tried using
those cheap certs with CF and know whether they work out of the box?  

Russ

> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 11:39 AM
> To: CF-Talk
> Subject: RE: cfhttp with https and self generated certificates
> 
> In order to make a successful connection the key has to be imported.
> Otherwise it cannot unencrypt the stream. Don't confuse this error with
> the
> browser warning error. In the case of the browser warning it is giving you
> a
> choice - do you want to accept (import into keystore) this certificate?
> Choosing yes, allows the cert to be trusted.
> 
> In Java you have to do this programatically.  If you use something like
> X-registrar it "may" work IF that vendor is in the keystore. If not, you
> would have to import that one as well.
> 
> -Mark
> 
> 
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:25 AM
> To: CF-Talk
> Subject: cfhttp with https and self generated certificates
> 
> I am trying to use cfhttp over https and I'm getting "I/O Exception: peer
> not authenticated".  A quck google search turns up that I need to import
> the
> certificate into my keystore.  Isn't there a way to tell CFHTTP to ignore
> certificate warnings?  The certificate in question is a self generated
> apache certificate.  Will a Turbo SSL from somewhere like X-Registrar.com
> work out of the box, or will I still have to import something?
> 
> 
> 
> Russ
> 
> 
> 
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243353
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Best Practices - Source Control and Hotfixes

[Michael Traher]

I found the greatest aid to selling CVS/SVN was the price :-)

On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
>
> I think it does and it means that SVN offers a capability that VSS is
> fundamentally lacking.  That will make selling this change much
> easier.  Thanks for your help.
>
> On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> > :-) yes, each of these source systems has a language all its own!
> > Fortunately CVS and SVN have the same root so thats one mercy.
> >
> > The project is all stored in the repository (all versions since you
> first
> > created it there or committed your existing source files for the first
> > time).
> >
> > In eclipse (and other CVS/SVN client tools) youcan checkout the entire
> > project, and the most common files you want are the latest ones these
> are
> > the default files you will get if you don't ask for anything else.
> >
> > eclipse lets you 'replace' your working copy of a project with another
> > version from the repository. This other version it identified by a tag
> (yes
> > a label) that you have previously told CVS/SVN to apply to a particular
> set
> > of files.
> >
> > It could be that this tag was applied a week ago and that since then
> further
> > changes have taken place to the source code but these changes are not
> > ready/tested yet so you don't want those. Thats what the tags are for to
> pin
> > down a particular consistent set of files from the repository.
> >
> > I have always applied tags to all files (so I click on the top folder in
> the
> > project) but in response to your request I tried just 3 files. Then I
> asked
> > eclipse to replace my current version of the project with the version
> > represented by the tag. All I got was
> > /rootfolder
> >/subfolder
> >/subsubfolder
> >file1.cfm
> >file2.cfm
> >file3.cfm
> >
> > So I could zip/tar this up and then expand on the production server
> > overwriting just the 3 files as required.
> >
> > After this is done I can ask eclipse to 'replace' my project with the
> latest
> > version and I will get all the project back again with latest changes.
> >
> > Does that make it clearer?
> >
> > On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> > >
> > > Michael, it sounds like you tried exactly what I'm looking to do, but
> > > I need to clarify since you used terminology that I'm not familiar
> > > with (read: non-VSS terms).  I assume "tagging" is "labeling", but
> > > what do you mean you "replaced the project"?  I need to "tag" a few
> > > selected files and then extract - using the tag value - those files to
> > > a build directory (not my standard working directory) where they will
> > > be consolidated into a tarball.  Once extracted, the build directory
> > > would contain only the files with the given tag.  Does "replacing the
> > > project" mean anything like that?  :-)
> > >
> > > Thanks.
> > >
> > > On 6/13/06, Michael Traher <[EMAIL PROTECTED]> wrote:
> > > > I just experimented with tagging just a handful of files (i tried
> three)
> > > and
> > > > then I replaced the project with the 'tag' and all I had was the
> > > necessary
> > > > folder tree and the files I had tagged!
> > > >
> > > > This would then make a nice neat distribution.
> > > >
> > > > (I suspect this is what the 'patch' wizard in eclipse may do for you
> > > anyway
> > > > but I've never tried it..)
> > > >
> > > > At the risk of crazy people joining the thread eclipse does have
> very
> > > nice
> > > > source control tools CVS built in and SVN as a plugin.
> > > >
> > > > On 6/13/06, Tom Chiverton <[EMAIL PROTECTED]> wrote:
> > > > >
> > > > > On Monday 12 June 2006 18:25, Rob Wilkerson wrote:
> > > > > > customers.  Ideally, I'd like to extract only the modified files
> > > from
> > > > > > the source control repository so I can then just roll them up in
> a
> > > > > > tarball without any additional weeding of what's in and what's
> out.
> > > > >
> > > > > Should be easy enough, you ask SVN for all the changes between the
> > > last
> > > > > release revision and the current (with fixes).
> > > > >
> > > > > --
> > > > > Tom Chiverton
> > > > >
> > > > > 
> > > > >
> > > > > This email is sent for and on behalf of Halliwells LLP.
> > > > >
> > > > > Halliwells LLP is a limited liability partnership registered in
> > > England
> > > > > and Wales under registered number OC307980 whose registered office
> > > address
> > > > > is at St James's Court Brown Street Manchester M2 2JF.  A list of
> > > members is
> > > > > available for inspection at the registered office. Any reference
> to a
> > > > > partner in relation to Halliwells LLP means a member of Halliwells
> > > LLP.
> > > > > Regulated by the Law Society.
> > > > >
> > > > > CONFIDENTIALITY
> > > > >
> > > > > This email is intended only for the use of the addressee named
> above
> > > and
> > > > > may be confidential or legally privileged.  If you

RE: cfhttp with https and self generated certificates

[Mark A Kruger]

In order to make a successful connection the key has to be imported.
Otherwise it cannot unencrypt the stream. Don't confuse this error with the
browser warning error. In the case of the browser warning it is giving you a
choice - do you want to accept (import into keystore) this certificate?
Choosing yes, allows the cert to be trusted.

In Java you have to do this programatically.  If you use something like
X-registrar it "may" work IF that vendor is in the keystore. If not, you
would have to import that one as well.

-Mark

 

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 10:25 AM
To: CF-Talk
Subject: cfhttp with https and self generated certificates

I am trying to use cfhttp over https and I'm getting "I/O Exception: peer
not authenticated".  A quck google search turns up that I need to import the
certificate into my keystore.  Isn't there a way to tell CFHTTP to ignore
certificate warnings?  The certificate in question is a self generated
apache certificate.  Will a Turbo SSL from somewhere like X-Registrar.com
work out of the box, or will I still have to import something?

 

Russ





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243351
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: XML - looking to return an XML object original parced format

[Dawson, Michael]

As long as you don't use the same variable "xml" for all of your
function results, you won't have to re-parse the xml.  Regardless, of
the size of the xml source, it would be a waste of processing to parse
it twice in the same request.

cfset xmlObj = xmlParse(xmlSource)
cfset xmlResult = xmlSearch(xmlObj, "//root/")
cfset xmlString = xmlResult[1].toString()

M!ke

-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 13, 2006 10:24 AM
To: CF-Talk
Subject: Re: XML - looking to return an XML object original parced
format

Well this is about returning the data structure to a state that it was
in when you first parsed the xml. Which I have figured out how to do.
Here it is:






done... :)

- Ian

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243350
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfhttp with https and self generated certificates

[Russ]

I am trying to use cfhttp over https and I'm getting "I/O Exception: peer
not authenticated".  A quck google search turns up that I need to import the
certificate into my keystore.  Isn't there a way to tell CFHTTP to ignore
certificate warnings?  The certificate in question is a self generated
apache certificate.  Will a Turbo SSL from somewhere like X-Registrar.com
work out of the box, or will I still have to import something?

 

Russ



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243349
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: XML - looking to return an XML object original parced format

[Ian Sheridan]

Well this is about returning the data structure to a state that it was
in when you first parsed the xml. Which I have figured out how to do.
Here it is:






done... :)

- Ian

On 6/13/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> Can you use XMLSearch()?
>
>  />
>
> #node[1].value#
>
> I recommend dumping the node value to ensure that the way my code
> accesses that value is correct.  It may be a little off - I'm winging
> it, here.
>
> On 6/13/06, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> > My subject line pretty much says it all, but let me clarify. I want to
> > return an XML object back to it's original format after I have used
> > XMLSEARCH on it. I guess it's a matter of aesthetic but I'd like to be
> > able to use the node name as the name of the structure I am accessing.
> >
> > EX.
> >  
> >   
> >DUDE
> >   
> >  
> >
> >   parse xml 
> >   search xml 
> >   place xml in xml variable 
> >
> >  #xml.root.goodnode.goodnode_name.xmltext#!
> >
> >   resulting in 
> >
> >  DUDE!
> >
> > It's a pain to do this:
> >
> >  
> > #xml.XmlChildren[1].XmlChildren[1].XmlChildren[1].xmltext#!
> >
> > I figure that I am missing something and I do not want to reinvent the
> > wheel so to speak.
> >
> >
> > - Ian
> >
> > --
> >
> > --
> > Ian Sheridan
> > http://www.savagevines.com
> > --
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243348
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Itext Sample code

[Robert Everland III]

Someone had mentioned they were going to offer some sample code showing how to 
use Itext to load a PDF with fields and fill in the values. Any status on when 
we can see that?



Bob

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243347
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Server firewall software

[Dave Watts]

> Can ya provide some insight here DaveI took a look at the 
> IP Security Policy GUI and honestly didn't know what I was 
> looking at.  If it helps our setup is simple (and yes the 
> network is small...dev web serverfile server...6 
> workstations.  We are using DSL with a D-Link router.
> 
> I'm just not sure what I should block/allow?  I assume I do 
> it by adding my own policies?

Well, the first step is to figure out what traffic you want to allow. As
Jochem said, you'll want to deny everything, then specifically allow that
traffic. So, what services do you host on that machine? What machines does
that machine need to talk to, and why?

Let's say, for example, that you have a web/application server. You probably
need access to some or all of the filesystem, although you may be able to
limit that access to machines on your internal network. Your filesystem
access might be through FTP, or CIFS (Windows Networking). Your web/app
server, in turn, might need to access a SQL Server database server on your
local network, and you might want to be able to download patches directly
from MS to that server.

So, that gives us a working list of services, from which we can determine a
list of allowed ports, inbound and outbound.

Inbound:
Web server - TCP/80, TCP/443 from everywhere
File server - appropriate NetBIOS over IP ports, or DirectHost port, from
internal network

Outbound:
SQL Server - TCP/1433 to database server
Windows Update - TCP/80, TCP/443 to MS update servers

Now, of course, it's very important to determine exactly what services your
machine will provide, and what services it will need to use. For example, in
the above case, your server wouldn't be able to find out the names of the
database server, or the MS update servers, because we haven't included
access to DNS. This might be intentional, in which case you'd have to figure
out the appropriate IP addresses and put them directly on the server where
needed. Also, your server won't be able to ping any other machines, nor will
it be pingable itself. Again, this might be intentional, but you need to be
aware of it.

Here's a tutorial on how to use the GUI:
http://homepages.wmich.edu/~mchugha/w2kfirewall.htm

As Jochem mentioned, you can also do this with the netsh command-line tool,
but I don't have a link handy for that.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243346
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Problems using aexp.htr

[Brian Yager]

I just changed to a new server and the aexp.htr file brings up a wierd 
error...Our help desk can't fix it so they said just use one of the other aexp 
files (aexp4.htr).  That file loads but doesn't change the password.  Does 
anyone have anything custom that changes the users password?  This is the local 
accounts on the maching (not active directory)

Thanks,

Brian

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243345
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Slightly OT: Document imaging system in CF, need good viewer?

[Jerry Johnson]

I honestly don't know.  I have never needed to get imput back from a
user in this way. That pretty much precludes a PDF, since you don't
want to require your users to have a pdf writer as well as the free
reader, and you can't draw over it in a browser (afaik)

Jerry

On 6/13/06, Peterson, Chris <[EMAIL PROTECTED]> wrote:
> Jerry,
>
> I know that I can draw text over a document during upload (date time
> stamp, etc), but how do I allow the user to open the document, then save
> a note overtop of it, or allow them to draw an arrow to a portion of the
> document and add a 'sticky' to it, after it has been saved?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243344
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Dave Watts]

> So even if I transfer the user via cfhttp to secpay's secure 
> payment facility, because I am still technically in an 
> unsecure environment I would need to secure it with my own 
> certificate?

You can't "transfer the user via CFHTTP". The CFHTTP tag lets you use CF as
an HTTP client. The user isn't connecting to Secpay, your server is. The
security of the connection between your server and Secpay has nothing to do
with the security of the connection between your user and your server.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243343
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Emulate fast compile in other frameworks

[Robert Everland III]

I was wondering if anyone has tried to take what the Fusebox team has done so 
that some of the other frameworks run as fast as Fusebox?



Bob

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Spydersweb Internet Solutions]

Russ

I think I understand, however I just wanted to bring your attention to the 
process I use.

The user selects a product subscription and is sent to a form on my server 
which asks for their personal details ie home address etc, but not payment 
information.  Once they click on submit the page I use files all the 
personal information in the database and then does the http post to secpay's 
secure payment page.  They then enter their credit card information in on 
this page and the payment is processed.  Secpay then activates a script on 
my server for callback to feedback information regarding the payment's 
success or failure, which I then log in the database accordingly.

So even if I transfer the user via cfhttp to secpay's secure payment 
facility, because I am still technically in an unsecure environment I would 
need to secure it with my own certificate?

Graham



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT: CF-United : Rooms at the north

[Paul Ihrig]

any one canceling there room at the north marriot, please email me.
would like to get in there.
thanks!
-paul


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243340
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Russ]

Actually the lock will only be seen if the page AND all the images on it are
secure.  So you have to make sure you don't have any http paths hard coded
for your image src's.  

> -Original Message-
> From: Terry L Schmitt [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:31 AM
> To: CF-Talk
> Subject: Re: CFHTTP / SSL and Secpay Payments
> 
> I don't program for payments, but cfhttp is communication between your
> server and secpay and has nothing to do with what is displayed on the
> users browser.
> If you are accepting CC information, then your web server and forms should
> be secured, in which case you would see the appropriate "lock" icon in
> your browser.
> 
> Terry
> 
> 
> 
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243339
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Russ]

>From what I understand, the user fills out the form on your website with
their credit card information, etc.  You process that form, put in the
transaction details sans the credit card # into your database and then
process the payment using the cfhttp post to secpay.  

The connection from your server to secpay is secure as they are using SSL
(https).  If the user is viewing your page over http (and not submitting to
your server over https), then that connection is not secure, and you should
at least use a self generated certificate to install ssl.  A self generated
certificate will give user's warnings, but at least their connection will be
secure.  The proper way to do this, of course, would be to buy a certificate
from a trusted third party (verisign, thawte, a bunch of cheaper third party
ones). 

Russ

> -Original Message-
> From: Spydersweb Internet Solutions [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:21 AM
> To: CF-Talk
> Subject: RE: CFHTTP / SSL and Secpay Payments
> 
> Russ, hi
> 
> thanks for the help
> 
> Can I just clarify your response please
> 
> If the end user is viewing the secpay secure page in this way it is not
> using the security provided by secpay via their ssl certificate?
> 
> I am not storing credit cards in the database, just the transaction
> details,
> ie name price and what ever the response from secpay is eg authorised etc.
> 
> Graham
> -Original Message-
> From: "Russ" <[EMAIL PROTECTED]>
> To: CF-Talk 
> Date: Tue, 13 Jun 2006 10:20:03 -0400
> Subject: RE: CFHTTP / SSL and Secpay Payments
> 
> > When you do a cfhttp request, it does it on the server side.   There is
> > nothing that gets shown on the browser.  If you're using an https url,
> > it
> > should be secure.  If you want to show a browser lock to your users,
> > you
> > will have to use https on your server (and if you're not, then their
> > data is
> > not secure, even if you're passing it to secpay over https).  Also
> > storing
> > cc's in your database is a bad idea, as it opens you up to all sorts of
> > liabilities.
> >
> > Russ
> >
> > > -Original Message-
> > > From: Spydersweb Internet Solutions
> > [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, June 13, 2006 10:07 AM
> > > To: CF-Talk
> > > Subject: CFHTTP / SSL and Secpay Payments
> > >
> > > Dear All
> > >
> > > I am utilising a SECPAY payment authorisation service to process
> > client
> > > payments.
> > >
> > > I collect data via a form, do a database insert with it and then do a
> > > cfhttp
> > > post to Secpay's Secure server.
> > >
> > > I have only just noticed that when I do the post I do not get to see
> > the
> > > https in the url nor do I see the secure lock in the bottom part of
> > the
> > > browser window.
> > >
> > > I therefore have two questions:
> > >
> > > 1) Is the connection still secure to the secpay server?
> > > 2) Is it possible to show the https or the padlock in the bottom of
> > the
> > > browser window?
> > >
> > > Code listing:
> > >
> > >  > > url="https://www.secpay.com/java-bin/ValCard";>
> > >  > value="#REQUEST.merchant#">
> > >  > value="#REQUEST.trans_id#">
> > >  > > value="#REQUEST.field_amount#">
> > >  > value="#REQUEST.callback#">
> > > 
> > >  > > value="http://www.secpay.com/users/digita02/temp.html";>
> > > 
> > >  > > value="#Request.field_currency#">
> > >  > > value="#REQUEST.field_name#">
> > >  > > value="#REQUEST.field_company#">
> > >  > > value="#REQUEST.field_email#">
> > >  > > value="#REQUEST.field_phone#">
> > >  > > value="#REQUEST.field_address1#">
> > >  > > value="#REQUEST.field_address2#">
> > >  > > value="#REQUEST.field_town#">
> > >  > > value="#REQUEST.field_county#">
> > >  > > value="#REQUEST.field_postcode#">
> > >  > > value="#REQUEST.field_country#">
> > >  > > value="[EMAIL PROTECTED]:[EMAIL PROTECTED]">
> > >  > value="false">
> > >  > value="false">
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > #cfhttp.filecontent#
> > > 
> > > 
> > > 
> > >
> > > Any help offered is greatly appreciated.
> > >
> > > regards
> > > Graham Cole
> > > [EMAIL PROTECTED]
> > >
> > >
> > >
> >
> >
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243338
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Spydersweb Internet Solutions]

Russ, hi

thanks for the help

Can I just clarify your response please

If the end user is viewing the secpay secure page in this way it is not 
using the security provided by secpay via their ssl certificate?

I am not storing credit cards in the database, just the transaction details, 

ie name price and what ever the response from secpay is eg authorised etc.

Graham



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243337
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFHTTP / SSL and Secpay Payments

[Terry L Schmitt]

I don't program for payments, but cfhttp is communication between your 
server and secpay and has nothing to do with what is displayed on the 
users browser.
If you are accepting CC information, then your web server and forms should 
be secured, in which case you would see the appropriate "lock" icon in 
your browser.

Terry





"Spydersweb Internet Solutions" <[EMAIL PROTECTED]> wrote on 
06/13/2006 10:07:03 AM:

> Dear All
> 
> I am utilising a SECPAY payment authorisation service to process client 
> payments.
> 
> I collect data via a form, do a database insert with it and then do a 
cfhttp 
> post to Secpay's Secure server.
> 
> I have only just noticed that when I do the post I do not get to see the 

> https in the url nor do I see the secure lock in the bottom part of the 
> browser window.
> 
> I therefore have two questions:
> 
> 1) Is the connection still secure to the secpay server?
> 2) Is it possible to show the https or the padlock in the bottom of the 
> browser window?
> 
> Code listing:
> 
>  url="https://www.secpay.com/java-bin/ValCard";>
> 
> 
> 
> 
> 
>  value="http://www.secpay.com/users/digita02/temp.html";>
> 
>  value="#Request.field_currency#">
> 
>  value="#REQUEST.field_company#">
>  value="#REQUEST.field_email#">
> 
>  value="#REQUEST.field_address1#">
>  value="#REQUEST.field_address2#">
> 
>  value="#REQUEST.field_county#">
>  value="#REQUEST.field_postcode#">
>  value="#REQUEST.field_country#">
>  value="[EMAIL PROTECTED]:[EMAIL PROTECTED]">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> #cfhttp.filecontent#
> 
> 
> 
> 
> Any help offered is greatly appreciated.
> 
> regards
> Graham Cole
> [EMAIL PROTECTED] 
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243336
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Spydersweb Internet Solutions]

Russ, hi

thanks for the help

Can I just clarify your response please

If the end user is viewing the secpay secure page in this way it is not 
using the security provided by secpay via their ssl certificate?

I am not storing credit cards in the database, just the transaction details, 
ie name price and what ever the response from secpay is eg authorised etc.

Graham
-Original Message-
From: "Russ" <[EMAIL PROTECTED]>
To: CF-Talk 
Date: Tue, 13 Jun 2006 10:20:03 -0400
Subject: RE: CFHTTP / SSL and Secpay Payments

> When you do a cfhttp request, it does it on the server side.   There is
> nothing that gets shown on the browser.  If you're using an https url,
> it
> should be secure.  If you want to show a browser lock to your users,
> you
> will have to use https on your server (and if you're not, then their
> data is
> not secure, even if you're passing it to secpay over https).  Also
> storing
> cc's in your database is a bad idea, as it opens you up to all sorts of
> liabilities.  
> 
> Russ
> 
> > -Original Message-
> > From: Spydersweb Internet Solutions
> [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 10:07 AM
> > To: CF-Talk
> > Subject: CFHTTP / SSL and Secpay Payments
> > 
> > Dear All
> > 
> > I am utilising a SECPAY payment authorisation service to process
> client
> > payments.
> > 
> > I collect data via a form, do a database insert with it and then do a
> > cfhttp
> > post to Secpay's Secure server.
> > 
> > I have only just noticed that when I do the post I do not get to see
> the
> > https in the url nor do I see the secure lock in the bottom part of
> the
> > browser window.
> > 
> > I therefore have two questions:
> > 
> > 1) Is the connection still secure to the secpay server?
> > 2) Is it possible to show the https or the padlock in the bottom of
> the
> > browser window?
> > 
> > Code listing:
> > 
> >  > url="https://www.secpay.com/java-bin/ValCard";>
> >  value="#REQUEST.merchant#">
> >  value="#REQUEST.trans_id#">
> >  > value="#REQUEST.field_amount#">
> >  value="#REQUEST.callback#">
> > 
> >  > value="http://www.secpay.com/users/digita02/temp.html";>
> > 
> >  > value="#Request.field_currency#">
> >  > value="#REQUEST.field_name#">
> >  > value="#REQUEST.field_company#">
> >  > value="#REQUEST.field_email#">
> >  > value="#REQUEST.field_phone#">
> >  > value="#REQUEST.field_address1#">
> >  > value="#REQUEST.field_address2#">
> >  > value="#REQUEST.field_town#">
> >  > value="#REQUEST.field_county#">
> >  > value="#REQUEST.field_postcode#">
> >  > value="#REQUEST.field_country#">
> >  > value="[EMAIL PROTECTED]:[EMAIL PROTECTED]">
> >  value="false">
> >  value="false">
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > #cfhttp.filecontent#
> > 
> > 
> > 
> > 
> > Any help offered is greatly appreciated.
> > 
> > regards
> > Graham Cole
> > [EMAIL PROTECTED]
> > 
> > 
> > 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243335
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: model-glue editor

[Joe Rinehart]

Hey Dave,

Try XMLBuddy - the free version makes it easy to associate a given XML file
with a given DTD, and it'll close things for you, etc.

On 6/13/06, dave <[EMAIL PROTECTED]> wrote:
>
> well i'll be damned! I wished it closed them tho but thats a good start :)
>
> ~Dave - formerly known as "the disruptor"~
>
> 
> From: [EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 2:40 AM
> To: CF-Talk 
> Subject: Re: model-glue editor
>
> > So I dove into mg but the thing I immediately found was that dw nor cfe
> > has any code hints in them
>
> For DW, get the DTD from MG's distro. Then:
>
> Edit > Tag Libraries > + DTD or Schema > Import XML DTD
>
> Massimo
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243334
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFHTTP / SSL and Secpay Payments

[Russ]

When you do a cfhttp request, it does it on the server side.   There is
nothing that gets shown on the browser.  If you're using an https url, it
should be secure.  If you want to show a browser lock to your users, you
will have to use https on your server (and if you're not, then their data is
not secure, even if you're passing it to secpay over https).  Also storing
cc's in your database is a bad idea, as it opens you up to all sorts of
liabilities.  

Russ

> -Original Message-
> From: Spydersweb Internet Solutions [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 10:07 AM
> To: CF-Talk
> Subject: CFHTTP / SSL and Secpay Payments
> 
> Dear All
> 
> I am utilising a SECPAY payment authorisation service to process client
> payments.
> 
> I collect data via a form, do a database insert with it and then do a
> cfhttp
> post to Secpay's Secure server.
> 
> I have only just noticed that when I do the post I do not get to see the
> https in the url nor do I see the secure lock in the bottom part of the
> browser window.
> 
> I therefore have two questions:
> 
> 1) Is the connection still secure to the secpay server?
> 2) Is it possible to show the https or the padlock in the bottom of the
> browser window?
> 
> Code listing:
> 
>  url="https://www.secpay.com/java-bin/ValCard";>
> 
> 
>  value="#REQUEST.field_amount#">
> 
> 
>  value="http://www.secpay.com/users/digita02/temp.html";>
> 
>  value="#Request.field_currency#">
>  value="#REQUEST.field_name#">
>  value="#REQUEST.field_company#">
>  value="#REQUEST.field_email#">
>  value="#REQUEST.field_phone#">
>  value="#REQUEST.field_address1#">
>  value="#REQUEST.field_address2#">
>  value="#REQUEST.field_town#">
>  value="#REQUEST.field_county#">
>  value="#REQUEST.field_postcode#">
>  value="#REQUEST.field_country#">
>  value="[EMAIL PROTECTED]:[EMAIL PROTECTED]">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> #cfhttp.filecontent#
> 
> 
> 
> 
> Any help offered is greatly appreciated.
> 
> regards
> Graham Cole
> [EMAIL PROTECTED]
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:24
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CFHTTP / SSL and Secpay Payments

[Spydersweb Internet Solutions]

Dear All

I am utilising a SECPAY payment authorisation service to process client 
payments.

I collect data via a form, do a database insert with it and then do a cfhttp 
post to Secpay's Secure server.

I have only just noticed that when I do the post I do not get to see the 
https in the url nor do I see the secure lock in the bottom part of the 
browser window.

I therefore have two questions:

1) Is the connection still secure to the secpay server?
2) Is it possible to show the https or the padlock in the bottom of the 
browser window?

Code listing:

https://www.secpay.com/java-bin/ValCard";>





http://www.secpay.com/users/digita02/temp.html";>
























#cfhttp.filecontent#




Any help offered is greatly appreciated.

regards
Graham Cole
[EMAIL PROTECTED] 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243332
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Batch file to Stop/Start ColdFusion MX...

[John C. Bland II]

Sean Tierney had a good blog post about this. Check it out
here
..

On 6/13/06, Jason Crider <[EMAIL PROTECTED]> wrote:
>
> How much editing would it take to get that to work on CFMX 7?
>
>
> -Original Message-
>
> On 13/06/06, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> >
> > Rob, Randy... Thank you! It doesn't get any easier than that.
> >
> > -Original Message-
> > From: Adkins, Randy [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 8:44 AM
> > To: CF-Talk
> > Subject: RE: Batch file to Stop/Start ColdFusion MX...
> >
> >
> > ECHO OFF
> > REM 
> > REM STOPPING SERVICES
> > REM 
> >
> > REM NET STOP "Macromedia JRun Default Server"
> > NET STOP "Macromedia JRun CFusion Server"
> > REM NET STOP "Macromedia JRun Admin Server"
> >
> >
> > REM 
> > REM STARTING SERVICES
> > REM 
> >
> >
> > REM NET START "Macromedia JRun Admin Server"
> > NET START "Macromedia JRun CFusion Server"
> > REM NET START "Macromedia JRun Default Server"
> >
> > -Original Message-
> > From: Che Vilnonis [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 13, 2006 8:38 AM
> > To: CF-Talk
> > Subject: Batch file to Stop/Start ColdFusion MX...
> >
> > Does anyone have a batch file to Stop/Start ColdFusion MX?
> > Not sure how to write one. Thanks, Che.
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54