Best approach

2009-09-16 Thread Randy Adkins

Looking for the best approach to the following task:

allow users to download a checklist to a tablet pc, do some security
checks with the tablet pc in hand (not connected to the web).

Upon completing the checks, connect to the Internet and upload the
results. Then I can parse and add to the master database.

Thought?

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Best approach

2009-09-16 Thread Allen Souliere

I have a great approach to this, assuming java can run on the tablet 
PC.  It is possible to make a bundle with OpenBlueDragon (with some .bat 
files to handle the startup) capable of running on the Tablet PC.  It 
can run locally with no network required, allow you to leverage your 
CFML skills to do the processing of the checklist.  Once done, the local 
CFML web application can then send the data (once connected) via web 
services (or whatever upload mechanism you decide upon) to the main 
server over the internet.

It is also possible through the admin api to set up a datasource from 
the tablet to the master server programmatically in OpenBD, and insert 
directly into your database, but you may prefer to expose the database 
in a different way (ie Web Services, etc.) instead.

I have done a standalone server in this manner before.

Otherwise, you may be looking at writing a native app on the tablet PC 
to do this.

Allen

Randy Adkins wrote:
 Looking for the best approach to the following task:

 allow users to download a checklist to a tablet pc, do some security
 checks with the tablet pc in hand (not connected to the web).

 Upon completing the checks, connect to the Internet and upload the
 results. Then I can parse and add to the master database.

 Thought?
   

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326367
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Best approach

2009-09-16 Thread Jason Fisher

Or look into an AIR app with Flash and the embedded Derby database?  AIR 
will help you handle the sync from local to server.
 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326368
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Best Approach for Budgeting Tool

2007-09-26 Thread Rick Faircloth
Hi, all.

 

I'm creating a basic budgeting/forecasting application

and I'd like some possible solutions to this issue:

 

Rather than have the app go through all the debits

and credits to calculate the current balance each time

the app is used, I'd like to have the previous balance

already available from the last time the app was used.

 

Would the best way be to store the previously calculated

current balance in a database table with the date of the

calculation, so any additional debits and credits are

added and subtracted from that balance?

 

Or is there another way to do this so there's not so much

calculation everytime the app is run. indexing?

 

Rick




~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289504
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: checking for best approach

2007-03-02 Thread Everett, Al \(NIH/NIGMS\) [C]
 Alternatively I could save the form data on the confirmation page to
hidden values and then on the action page use the data in the 
 hidden fields to write to the database.

That's probably how I would approach it.

Uncle Ben's CF_EmbedFields custom tag would make this easy.

http://www.adobe.com/cfusion/exchange/index.cfm?view=sn131extID=101
#loc=en_usview=sn131extID=101viewName=Adobe%20Exchangeavm=1

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271291
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: checking for best approach

2007-03-02 Thread Tom Chiverton
On Friday 02 Mar 2007, Everett, Al (NIH/NIGMS) [C] wrote:
 That's probably how I would approach it.

And of course, I don't need to warn you about just blindly taking the data 
you've saved into the form and got then got handedd back and using it in SQL 
do I ?

-- 
Tom Chiverton
Helping to autoschediastically initiate extensible experiences
On: http://thefalken.livejournal.com



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 are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271297
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: checking for best approach

2007-03-02 Thread Everett, Al \(NIH/NIGMS\) [C]
 And of course, I don't need to warn you about just blindly taking the
data you've saved into the form and got then got handedd back and 
 using it in SQL do I ?

Of course not. I am a zealous user of cfqueryparam.

~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271299
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: checking for best approach

2007-03-02 Thread Tom Chiverton
On Friday 02 Mar 2007, Tom Chiverton wrote:
 you've saved into the form and got then got handedd back and using it in

you've saved into the form and then got handed back and using it in

Damn pubs :-)

-- 
Tom Chiverton
Helping to autoschediastically deploy customized channels
On: http://thefalken.livejournal.com



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 are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271300
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: checking for best approach

2007-03-02 Thread Tom Chiverton
On Friday 02 Mar 2007, Everett, Al (NIH/NIGMS) [C] wrote:
 Of course not. I am a zealous user of cfqueryparam.

Excellent.
I'd still parse the inital form into the session scope and just redisplay that 
though.

-- 
Tom Chiverton
Helping to assertively drive compelling solutions
On: http://thefalken.livejournal.com



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 are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271305
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: checking for best approach

2007-03-02 Thread Everett, Al \(NIH/NIGMS\) [C]
 I'd still parse the inital form into the session scope and just
redisplay that though.

Nothing wrong with either approach, of course. I had a couple of reasons
for thinking form would be better.

- I have to have a form for the configuration button anyway.
- Sessions would have to be enabled.
- If the user navigates away from the confirmation page I don't want the
data to hang around.

Of course, these might not apply in the original poster's case. As with
so many things CF, there are multiple ways to accomplish the same thing.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271309
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


checking for best approach

2007-03-01 Thread Pete
 

Hi there

 

I have a form which I am using to allow a user to enter data into an
application.

 

Basically I have it that the user enters the data and then I display the
results back to the user - so that they can confirm what they have entered
is complete and accurate.

 

The use will then press submit on the confirmation page.

 

I was trying to figure out the best approach to do this.

 

Initially on the confirmation page I was going to:

 

1.  Display the values entered by using
cfoutput#form.dataentered#/cfoutput

2.  At the same time store a copy of the form data entered into session
variables

 

Then once the user pressed submit on the confirmation page I was going to
take the values that had been stored in the session variables and use them
to write to the database.

 

I was thinking then - is this the best approach?

 

Alternatively I could save the form data on the confirmation page to hidden
values and then on the action page use the data in the hidden fields to
write to the database.

 

I look forward to hearing ideas and thoughts on the best approach.

 

Regards

 

P 

 



~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271246
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Is this the best approach?

2007-02-23 Thread Bruce Sorge
I found a JS solution for this. I can create a separate .js file and append
a new line to it when they add another sweepstakes. Hopefully that will do
the trick. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 8:50 PM
To: CF-Talk
Subject: RE: Is this the best approach?


 Thanks but I do not want to use IIS password protection. I
 wanted to use a ..htaccess page for redirects.

IIS doesn't use .htaccess. Apache uses it.

And in any case, .htaccess isn't designed for redirects, it's an
authentication mechanism. You can use mod_rewrite in Apache, or
ISAPI_Rewrite in IIS, to do what you want.

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!




~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270576
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Is this the best approach?

2007-02-22 Thread Bruce Sorge
Hey, I tried the .htaccess thing and it is not working. Here is what I have:

Redirect /Nascar/Sweepstakes/index.cfm
http://bruceserver/nascar/Sweepstakes/Index.cfm?Sweepstakes_ID=4

This is my test server. My understanding is that the old path starts with a
directory as it relates to the sites root, so I start with /nascar/ When
I browse to http://bruceserver/nascar/sweepstakes, I get directory browsing
is not allowed. When I go to
http://bruceserver/nascar/sweepstakes/index.cfm, I get the file not found
error.

Thanks,

Bruce

-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 20, 2007 1:28 PM
To: CF-Talk
Subject: Re: Is this the best approach?


As an alternative to dynamically creating/managing directories and 
copying code into them, here is what I have done in the past.  Each time 
a sweepstake is added, modified or deleted, we recreated a .htaccess 
file in the root directory that sets up redirects for each sweepstake.  
So  /sweepstakeName redirects to 
/sweepstakes/index.cfm?sweepstakes_ID=45 or 
/sweepstakes/index.cfm?sweepstakes_Title=SweepstakeName

If you want the user to stay at /sweepstakename all the time and not be 
redirected, you could write out mod_rewrite lines instead.

I'm not saying thats a better way of doing it, just another way.  I 
prefer to have as few pieces of code-generated-code as possible.

Also you might want to think of having an active flag, so a sweepstake 
could still exist and be viewed in the admin side, without actually 
giving users access to it.

-Ryan

Bruce Sorge wrote:
 I have been tasked by one of my customers to create an on-line 
 sweepstakes. They want to be able to create a sweepstakes dynamically 
 (title of the sweepstakes, questions, answers and control types). 
 Also, they want to be able to run one or more sweepstakes at a time, 
 but they do not want a link to all of the sweepstakes currently 
 running from the home page. Rather they would want the customer to go 
 to www.sitename.com/sweepstakesname.

 So here is what I have devised. If anyone has a better idea, I would 
 love to hear it.

 DB Tables:

 Sweepstakes
 sweepstakes_ID int
 Sweepstakes_Title varchar

 Questions
 Question_ID int
 Question text
 Sweepstakes_ID

 Answers
 Answer_ID int
 Question_ID int
 Control_Type varchar
 Control_Name varchar
 Answer varchar

 CustomerAnswers
 Sweepstakes_ID int
 Customer_ID int
 Question_ID int
 Answer text

 I have an admin page that flows like this:

 Admin enters the name of the new sweepstakes. Then they go to the 
 question section. They select the sweepstakes that they want to add 
 questions to, enter in the question, then they go to a page that has 
 them enter answers and control types (radio, checkbox, text, 
 textarea). Once they are done entering the answers for that question, 
 they go back to a new question and then do it all over again. As far 
 as creating a new folder for each .cfm page for the sweepstakes, I 
 thought that when they enter the sweepstakes title, they can enter a 
 name for the directory, then I create a directory with CFDIRECTORY 
 tag, and use CFFILE to copy the .cfm files from a main directory to 
 the new directory. The main sweepstakes page is index.cfm so that 
 should work. Then, when they are done, I can show them a page that has 
 the URL of the sweepstakes they currently created, like 
 www.sitename.com/newcoolsweepstakes. They can then copy and paste it 
 to marketing email to customers. So what do you all think of this? Is 
 this a descent approach or is there a better way to do it?

 Thanks,

   





~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270531
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Is this the best approach?

2007-02-22 Thread Bruce Sorge
Disregard. I am using Windows and apparently .htaccess does NOT work in
windows. Fuc**ng Microsoft.

Bruce

-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 20, 2007 1:28 PM
To: CF-Talk
Subject: Re: Is this the best approach?


As an alternative to dynamically creating/managing directories and 
copying code into them, here is what I have done in the past.  Each time 
a sweepstake is added, modified or deleted, we recreated a .htaccess 
file in the root directory that sets up redirects for each sweepstake.  
So  /sweepstakeName redirects to 
/sweepstakes/index.cfm?sweepstakes_ID=45 or 
/sweepstakes/index.cfm?sweepstakes_Title=SweepstakeName

If you want the user to stay at /sweepstakename all the time and not be 
redirected, you could write out mod_rewrite lines instead.

I'm not saying thats a better way of doing it, just another way.  I 
prefer to have as few pieces of code-generated-code as possible.

Also you might want to think of having an active flag, so a sweepstake 
could still exist and be viewed in the admin side, without actually 
giving users access to it.

-Ryan


~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270532
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Is this the best approach?

2007-02-22 Thread Dave Watts
 Disregard. I am using Windows and apparently .htaccess does 
 NOT work in windows. Fuc**ng Microsoft.

?

If you're using Apache on Windows, you can certainly use Apache's
authentication mechanism:
http://httpd.apache.org/docs/howto/auth.html
http://sniptools.com/tutorials/windows-apache-and-htaccess-authentication

If you're using IIS, why would you expect it to work, since it's a specific
feature of Apache? There are plenty of approaches you can use instead, that
will work with IIS. I would recommend ISAPI_Rewrite - the free version
should be sufficient for this - which will work just fine to do the
redirects you're trying to 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!


~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270539
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Is this the best approach?

2007-02-22 Thread Bobby Hartsfield
It's Microsoft's fault that .htaccess doesn’t work with IIS? If you mean it 
doesn’t work with apache on Windows... well that's your fault, not Fuc**ng 
Microsoft's since you are apparently doing something wrong

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 4:34 PM
To: CF-Talk
Subject: RE: Is this the best approach?

Disregard. I am using Windows and apparently .htaccess does NOT work in
windows. Fuc**ng Microsoft.

Bruce

-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 20, 2007 1:28 PM
To: CF-Talk
Subject: Re: Is this the best approach?


As an alternative to dynamically creating/managing directories and 
copying code into them, here is what I have done in the past.  Each time 
a sweepstake is added, modified or deleted, we recreated a .htaccess 
file in the root directory that sets up redirects for each sweepstake.  
So  /sweepstakeName redirects to 
/sweepstakes/index.cfm?sweepstakes_ID=45 or 
/sweepstakes/index.cfm?sweepstakes_Title=SweepstakeName

If you want the user to stay at /sweepstakename all the time and not be 
redirected, you could write out mod_rewrite lines instead.

I'm not saying thats a better way of doing it, just another way.  I 
prefer to have as few pieces of code-generated-code as possible.

Also you might want to think of having an active flag, so a sweepstake 
could still exist and be viewed in the admin side, without actually 
giving users access to it.

-Ryan




~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Is this the best approach?

2007-02-22 Thread Bruce Sorge
I am not using Apache. I am using IIS because that is what my customers are
using.

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 7:38 PM
To: CF-Talk
Subject: RE: Is this the best approach?


It's Microsoft's fault that .htaccess doesn’t work with IIS? If you mean
it doesn’t work with apache on Windows... well that's your fault, not
Fuc**ng Microsoft's since you are apparently doing something wrong

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 4:34 PM
To: CF-Talk
Subject: RE: Is this the best approach?

Disregard. I am using Windows and apparently .htaccess does NOT work in
windows. Fuc**ng Microsoft.

Bruce

-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 20, 2007 1:28 PM
To: CF-Talk
Subject: Re: Is this the best approach?


As an alternative to dynamically creating/managing directories and 
copying code into them, here is what I have done in the past.  Each time 
a sweepstake is added, modified or deleted, we recreated a .htaccess 
file in the root directory that sets up redirects for each sweepstake.  
So  /sweepstakeName redirects to 
/sweepstakes/index.cfm?sweepstakes_ID=45 or 
/sweepstakes/index.cfm?sweepstakes_Title=SweepstakeName

If you want the user to stay at /sweepstakename all the time and not be 
redirected, you could write out mod_rewrite lines instead.

I'm not saying thats a better way of doing it, just another way.  I 
prefer to have as few pieces of code-generated-code as possible.

Also you might want to think of having an active flag, so a sweepstake 
could still exist and be viewed in the admin side, without actually 
giving users access to it.

-Ryan






~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270541
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Is this the best approach?

2007-02-22 Thread Oğuz Demirkapı
Check this out: http://www.troxo.com/products/iispassword/


Bruce Sorge wrote:
 I am not using Apache. I am using IIS because that is what my customers are
 using.

   


-- 

Oğuz Demirkapı

TeraTech Inc. | Senior Developer
405 East Gude Dr Suite 207, Rockville, MD 20850, USA
Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185
Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com
Winner in CFDJ awards Best Consulting. Member Team Fusebox.




~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270542
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Is this the best approach?

2007-02-22 Thread Bruce Sorge
Thanks but I do not want to use IIS password protection. I wanted to use a
..htaccess page for redirects.


-Original Message-
From: Oğuz Demirkapı [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 8:34 PM
To: CF-Talk
Subject: Re: Is this the best approach?


Check this out: http://www.troxo.com/products/iispassword/


Bruce Sorge wrote:
 I am not using Apache. I am using IIS because that is what my 
 customers are using.

   


-- 

Oğuz Demirkapı

TeraTech Inc. | Senior Developer
405 East Gude Dr Suite 207, Rockville, MD 20850, USA
Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185
Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com
Winner in CFDJ awards Best Consulting. Member Team Fusebox.






~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270544
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Is this the best approach?

2007-02-22 Thread Dave Watts
 Thanks but I do not want to use IIS password protection. I 
 wanted to use a ..htaccess page for redirects.

IIS doesn't use .htaccess. Apache uses it.

And in any case, .htaccess isn't designed for redirects, it's an
authentication mechanism. You can use mod_rewrite in Apache, or
ISAPI_Rewrite in IIS, to do what you want.

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!


~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270545
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Is this the best approach?

2007-02-22 Thread Oğuz Demirkapı
You did not check the link. :)

It uses .htaccess files for security in IIS. :)


Bruce Sorge wrote:
 Thanks but I do not want to use IIS password protection. I wanted to use a
 ..htaccess page for redirects.


 -Original Message-
 From: Oğuz Demirkapı [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 22, 2007 8:34 PM
 To: CF-Talk
 Subject: Re: Is this the best approach?


 Check this out: http://www.troxo.com/products/iispassword/


 Bruce Sorge wrote:
   
 I am not using Apache. I am using IIS because that is what my 
 customers are using.

   
 


   


-- 

Oğuz Demirkapı

TeraTech Inc. | Senior Developer
405 East Gude Dr Suite 207, Rockville, MD 20850, USA
Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185
Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com
Winner in CFDJ awards Best Consulting. Member Team Fusebox.




~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270546
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Is this the best approach?

2007-02-22 Thread Oğuz Demirkapı
Dave Watts wrote:
 Thanks but I do not want to use IIS password protection. I 
 wanted to use a ..htaccess page for redirects.
 

 IIS doesn't use .htaccess. Apache uses it.
   
Default doesn't. But there are tons of 3rd party tools to use .htaccess 
logic and files with IIS.

 And in any case, .htaccess isn't designed for redirects, it's an
 authentication mechanism. You can use mod_rewrite in Apache, or
 ISAPI_Rewrite in IIS, to do what you want.
   
But it would be used also for redirect. It is easier than using any 
other redirect tool. :)

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


-- 

Oğuz Demirkapı

TeraTech Inc. | Senior Developer
405 East Gude Dr Suite 207, Rockville, MD 20850, USA
Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185
Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com
Winner in CFDJ awards Best Consulting. Member Team Fusebox.




~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270548
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Is this the best approach?

2007-02-20 Thread Bruce Sorge
I have been tasked by one of my customers to create an on-line sweepstakes.
They want to be able to create a sweepstakes dynamically (title of the
sweepstakes, questions, answers and control types).
Also, they want to be able to run one or more sweepstakes at a time, but
they do not want a link to all of the sweepstakes currently running from the
home page. Rather they would want the customer to go to
www.sitename.com/sweepstakesname.

So here is what I have devised. If anyone has a better idea, I would love to
hear it.

DB Tables:

Sweepstakes
sweepstakes_ID int
Sweepstakes_Title varchar

Questions
Question_ID int
Question text
Sweepstakes_ID

Answers
Answer_ID int
Question_ID int
Control_Type varchar
Control_Name varchar
Answer varchar

CustomerAnswers
Sweepstakes_ID int
Customer_ID int
Question_ID int
Answer text

I have an admin page that flows like this:

Admin enters the name of the new sweepstakes. Then they go to the question
section. They select the sweepstakes that they want to add questions to,
enter in the question, then they go to a page that has them enter answers
and control types (radio, checkbox, text, textarea). Once they are done
entering the answers for that question, they go back to a new question and
then do it all over again. As far as creating a new folder for each .cfm
page for the sweepstakes, I thought that when they enter the sweepstakes
title, they can enter a name for the directory, then I create a directory
with CFDIRECTORY tag, and use CFFILE to copy the .cfm files from a main
directory to the new directory. The main sweepstakes page is index.cfm so
that should work. Then, when they are done, I can show them a page that has
the URL of the sweepstakes they currently created, like
www.sitename.com/newcoolsweepstakes. They can then copy and paste it to
marketing email to customers. So what do you all think of this? Is this a
descent approach or is there a better way to do it?

Thanks,

-- 
Bruce Sorge

I'm a mawg: half man, half dog. I'm my own best friend!


~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270237
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Is this the best approach?

2007-02-20 Thread Adkins, Randy
Perhaps a start and end date to the Sweepstakes.
Just at first glance. 

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 20, 2007 4:10 PM
To: CF-Talk
Subject: Is this the best approach?

I have been tasked by one of my customers to create an on-line
sweepstakes.
They want to be able to create a sweepstakes dynamically (title of the
sweepstakes, questions, answers and control types).
Also, they want to be able to run one or more sweepstakes at a time, but
they do not want a link to all of the sweepstakes currently running from
the home page. Rather they would want the customer to go to
www.sitename.com/sweepstakesname.

So here is what I have devised. If anyone has a better idea, I would
love to hear it.

DB Tables:

Sweepstakes
sweepstakes_ID int
Sweepstakes_Title varchar

Questions
Question_ID int
Question text
Sweepstakes_ID

Answers
Answer_ID int
Question_ID int
Control_Type varchar
Control_Name varchar
Answer varchar

CustomerAnswers
Sweepstakes_ID int
Customer_ID int
Question_ID int
Answer text

I have an admin page that flows like this:

Admin enters the name of the new sweepstakes. Then they go to the
question section. They select the sweepstakes that they want to add
questions to, enter in the question, then they go to a page that has
them enter answers and control types (radio, checkbox, text, textarea).
Once they are done entering the answers for that question, they go back
to a new question and then do it all over again. As far as creating a
new folder for each .cfm page for the sweepstakes, I thought that when
they enter the sweepstakes title, they can enter a name for the
directory, then I create a directory with CFDIRECTORY tag, and use
CFFILE to copy the .cfm files from a main directory to the new
directory. The main sweepstakes page is index.cfm so that should work.
Then, when they are done, I can show them a page that has the URL of the
sweepstakes they currently created, like
www.sitename.com/newcoolsweepstakes. They can then copy and paste it to
marketing email to customers. So what do you all think of this? Is this
a descent approach or is there a better way to do it?

Thanks,

--
Bruce Sorge

I'm a mawg: half man, half dog. I'm my own best friend!




~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270238
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Is this the best approach?

2007-02-20 Thread Bruce Sorge
Damn. That would be a good feature to have. Thanks.

On 2/20/07, Adkins, Randy [EMAIL PROTECTED] wrote:

 Perhaps a start and end date to the Sweepstakes.
 Just at first glance.



~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270239
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Is this the best approach?

2007-02-20 Thread Ryan Stille
As an alternative to dynamically creating/managing directories and 
copying code into them, here is what I have done in the past.  Each time 
a sweepstake is added, modified or deleted, we recreated a .htaccess 
file in the root directory that sets up redirects for each sweepstake.  
So  /sweepstakeName redirects to 
/sweepstakes/index.cfm?sweepstakes_ID=45 or 
/sweepstakes/index.cfm?sweepstakes_Title=SweepstakeName

If you want the user to stay at /sweepstakename all the time and not be 
redirected, you could write out mod_rewrite lines instead.

I'm not saying thats a better way of doing it, just another way.  I 
prefer to have as few pieces of code-generated-code as possible.

Also you might want to think of having an active flag, so a sweepstake 
could still exist and be viewed in the admin side, without actually 
giving users access to it.

-Ryan

Bruce Sorge wrote:
 I have been tasked by one of my customers to create an on-line sweepstakes.
 They want to be able to create a sweepstakes dynamically (title of the
 sweepstakes, questions, answers and control types).
 Also, they want to be able to run one or more sweepstakes at a time, but
 they do not want a link to all of the sweepstakes currently running from the
 home page. Rather they would want the customer to go to
 www.sitename.com/sweepstakesname.

 So here is what I have devised. If anyone has a better idea, I would love to
 hear it.

 DB Tables:

 Sweepstakes
 sweepstakes_ID int
 Sweepstakes_Title varchar

 Questions
 Question_ID int
 Question text
 Sweepstakes_ID

 Answers
 Answer_ID int
 Question_ID int
 Control_Type varchar
 Control_Name varchar
 Answer varchar

 CustomerAnswers
 Sweepstakes_ID int
 Customer_ID int
 Question_ID int
 Answer text

 I have an admin page that flows like this:

 Admin enters the name of the new sweepstakes. Then they go to the question
 section. They select the sweepstakes that they want to add questions to,
 enter in the question, then they go to a page that has them enter answers
 and control types (radio, checkbox, text, textarea). Once they are done
 entering the answers for that question, they go back to a new question and
 then do it all over again. As far as creating a new folder for each .cfm
 page for the sweepstakes, I thought that when they enter the sweepstakes
 title, they can enter a name for the directory, then I create a directory
 with CFDIRECTORY tag, and use CFFILE to copy the .cfm files from a main
 directory to the new directory. The main sweepstakes page is index.cfm so
 that should work. Then, when they are done, I can show them a page that has
 the URL of the sweepstakes they currently created, like
 www.sitename.com/newcoolsweepstakes. They can then copy and paste it to
 marketing email to customers. So what do you all think of this? Is this a
 descent approach or is there a better way to do it?

 Thanks,

   



~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270243
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Is this the best approach?

2007-02-20 Thread K Simanonok
Before you get too far into your sweepstakes coding, I would suggest that you 
have your client check with his attorney, if he hasn't already done so, to be 
sure that the details of what he intends to do are legal.  I'm not any kind of 
expert in this area but I have heard of sweepstakes going very badly with the 
sponsors being financially ruined in the end and being threatened with the 
possibility of prison time in the process.  Plus whatever your client needs to 
do to conduct his sweepstakes legally may very well influence your coding.  

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270283
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Is this the best approach?

2007-02-20 Thread K Simanonok
Before you get too far into your sweepstakes coding, I would suggest that you 
have your client check with his attorney, if he hasn't already done so, to be 
sure that the details of what he intends to do are legal.  I'm not any kind of 
expert in this area but I have heard of sweepstakes going very badly with the 
sponsors being financially ruined in the end and being threatened with the 
possibility of prison time in the process.  Plus whatever your client needs to 
do to conduct his sweepstakes legally may very well influence your coding.  

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270284
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Is this the best approach?

2007-02-20 Thread K Simanonok
Ryan's right, and I'll go so far as to say what he's described to you is a 
*much* better way to create new sweepstakes.  Think about it: once you start 
creating a bunch of subdirectories and copying .cfm templates into them, at 
some point in the future you may find yourself maintaining them all too and 
eventually wishing that you hadn't created such a mess of redundancy for 
yourself to wade through and try to keep straight.  So you'll almost certainly 
be much better off using one code set for all your sweepstakes, providing that 
the sweepstakes are going to resemble each other in their functioning which it 
sounds like you are planning to do.  There are a number of ways to do it too, 
not necessarily with .htaccess mods either.  I would think about using a single 
/sweepstakes/ subdirectory containing a custom .cfm landing page for each 
individual sweepstakes event (which your client is going to want anyway) so 
that each landing page could contain a unique Sweepstakes_ID in a hidden form 
field that gets passed from one page to the next.  Less cleanly you could pass 
a URL.Sweepstakes_ID between pages, or better, you might even want to set a 
cookie with a Sweepstakes_ID that doesn't get deleted until the user finishes 
the questions.  There are a lot of ways to skin this cat.

The only reason to NOT do it with one code set might be if you planned to use 
your Admin functionality to actually write out static files so that your users 
working their way through the questions wouldn't be hitting the database at all 
or hardly at all (you could accumulate all their answers in hidden form fields 
or in a cookie without hitting the database until the very end, just once).  
You could get away with using a not-very-powerful server and database doing it 
that way if you had to (MS Access on a 500Mhz shared server for example) but if 
you have a fast dedicated web server and any version of MSSQL running on a 
second machine then you ought to keep it all dynamic, the way CF was meant to 
be.  


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270285
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Is this the best approach?

2007-02-20 Thread K Simanonok
A couple of other thoughts:

1) Separate landing pages for each sweepstakes gives you the opportunity to 
name them with keywords to benefit your clients' SEO.  So 
http://mysite.com/sweepstakes/win-a-2008-mustang.cfm is significantly better in 
Google's eyes than http://mysite.com/sweepstakes/index.cfm, for example.  

2) It sounds like the functionality you're intending to build to construct and 
operate your sweepstakes is very similar to the functionality needed to build 
surveys, and there's code already out there for surveys.  I remember looking at 
the survey engine at http://www.activefeedback.com/af/ow/order1.cfm a few years 
ago and being quite impressed with the Admin functionality that lets you very 
easily create questions and choose response types (probably the $495 Survey 
Engine 2.0 Enterprise without the library of forms would work well for you).  
Unfortunately it looks like you can no longer download a trial version to see 
for yourself, but they've got some pretty good demos so you can see the end 
result anyway, I couldn't find a demo for the Admin functionality which is even 
better.  The point is you may not have to start from scratch if you do your 
homework, there may even be free code available for CF surveys that would save 
you lots of coding time.  


~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270286
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Managing Multiple Instances - Best Approach

2007-01-15 Thread James Buckingham
Morning everyone,

I thought I'd do a bit of asking around as I don't seem to be able to find much 
about this online. I'm curious about how others manage things like updates, 
testing and release management on a daily basis across multiple instances of CF 
running on more than one server.

We've just started a migration project to move all our applications up from 
version 5 to MX 7.0 and to load balance everything across 4 Win2003 servers (2 
for testing purposes and 2 as our live servers). I've now been given the task 
of looking at new procedures on managing these servers and the way that our 
team should control these for the points above.

I know you could probably write a couple of books on this subject but I thought 
I'd just ask for people's experiences and find out what they found to be the 
best way of managing their code and servers.

Cheers,
James

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Managing Multiple Instances - Best Approach

2007-01-15 Thread Paul Vernon
 I know you could probably write a couple of books on this 
 subject but I thought I'd just ask for people's experiences 
 and find out what they found to be the best way of managing 
 their code and servers.

We install an SVN client (Tortoise) on the servers and all our sites are
deployed to the servers using a checkout and subsequent updates are done via
the update processes. 

Version control of over 70 sites is now a breeze. We never miss a file when
uploading and we have the ability to roll back to previous versions if
required. Having spent hours doing deployments to clusters in the past,
performing an update via SVN is just a breeze.

In essence, the deployment methodology works in the same manner for our
local dev environments, test server and the production servers.

It's quick, simple, cheap and effective. I can't say much more about it
really. The only catch is you need to be running your own servers to do
this.

Paul



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266595
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Managing Multiple Instances - Best Approach

2007-01-15 Thread Tom Chiverton
On Monday 15 January 2007 12:27, Paul Vernon wrote:
 via the update processes.

+1
'svn switch' rocks !

-- 
Tom Chiverton
Helping to adaptively initiate third-generation services



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 are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266596
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Managing Multiple Instances - Best Approach

2007-01-15 Thread Jochem van Dieten
James Buckingham wrote:
 
 I thought I'd do a bit of asking around as I don't seem to be able to 
 find much about this online. I'm curious about how others manage 
 things like updates, testing and release management on a daily basis 
 across multiple instances of CF running on more than one server.

We build EAR files in the build environment and move them from there to 
testing, QA and production. The configuration comes from properties files that 
are local to the server, instance or even application so typically we do not 
have to do any configuration on the server for an update (only when it is a 
feature release). We just shut the instance down, remove the old EAR file, drop 
the new one in and restart the instance with a batch file that in the process 
removes all the temp files of the previous EAR file. Typically takes 1 minute 
per instance, but in clusters we do the instances 5 minutes apart to allow the 
sessions to sync before we do the next instance.

Someday I will automate this completely (the build environment is already 
automated), but for now we do the upgrades and checks manually.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266597
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Best Approach

2007-01-08 Thread Pete
 

Hi there

 

I am currently developing a business application (business directory) for a
specialized section of the medical profession in Sydney (Australia).

 

As part of the directory people who wish to advertise and have their details
included on the site they are able to provide us with description of
services etc.

 

Each person has been allowed to submit photos (Min 1 and Max 8) which can
appear next to their details.

 

I have developed the form etc to enable details of each advertiser to be
entered.  

 

What I am struggling to come to grips with yet is - what is the best way to
allow the input form to cater for the addition of photos for each listing.

 

When a user is adding photos for a listing I would like them to search
trough pictures so they can select photos to have displayed with their
listing.

 

Any ideas would be appreciated.

 

Regards

 

Pete 




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265946
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Best Approach for Survey Question

2006-01-02 Thread Dave Francis
ALWAYS use separate columns. I've been bit in the a$$ just about every 
time
I tried  the comma-delim list approach.
Another plus is it's really easy to return an Excel file directly to 
those
doing the tabulating - which they seem to like - without bugging me for the
latest results 3 times a day.


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 9:14 PM
To: CF-Talk
Subject: Best Approach for Survey Question


I am trying to determine the best way to structure a series of survey
questions, keeping in mind that I need to make it easy to use for the
respondent, easy to code, and easy to tabulate the data later on.

I can structure the following typical question as a single set of
checkboxes:

Q5: Please select schools that provide interns (check all that apply):  [ ]
Sciences [ ] Management/Business [ ] Law [ ] Communications  [ ] Other

Using a single datafield for the question, I then would need to parse a
comma-delimited list to separated the answers.

- or - I can use a series of radio buttons:

Q5:Please select schools that provide interns (check all that apply):
   A. Sciences  [ ]
  B. Management/Business  [ ]
  C. Law  [ ]
   D. Communications  [ ]
E. Other  [ ]

If I use a separate data field (5 in this case) for each sub-part of the
question, then it is easy to tabulate results for each part.

Recommendations appreciated.

Richard Colman






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228132
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: Best Approach for Survey Question

2006-01-02 Thread Snake
I once made a form build that could be used for pretty much anything,
profiles, questionnaires, anything that required a form.

It was constructed something like thus:-

Table: questions
questionID  int primarykey
Questionvarchar
Fieldtype   varchar
Requiredbit default(0)
Sizeint
Maxlength   int
Validation  varchar
Multiplebit default(0)


Table: answers
answerIDint primarykey
questionId  int
Answer

Table: Options
optionIDint primarykey
Optiontext  varchar
Optionvalue varchar
DefaultSelected BIT default(0)

So then you just loop over the questions, creating the specifield form field
types with the specified attributes.
For select lists, multi radios or checkboxes, you just add items to the
options table.

E.G.

cfquery name=questions
Select * from questions
/cfquery
cfquery name=options
Select * from questions
/cfquery

cfloop query=questions
cfset QUID = questionID
cfif fieldtype=select
  select name=Q#QID# #IIF(multiple, 'multiple', '')# size=#size#
cfloop query=options
cfif questionID = QID
option value=#optionvalue# #IIF(SefaultSelected,
'Selected','')##optiontext#
/cfif
/cfloop
  /select
cfelseif fieldtype is text
  input type=text name=Q#QID# maxlength=#maxlength# size=#size##
/cfif

Get the idea?

Then when the form is submitted you simply save the answers in the answers
table for the specified QID.
--
Russ
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED] 
Sent: 02 January 2006 15:43
To: CF-Talk
Subject: RE: Best Approach for Survey Question

ALWAYS use separate columns. I've been bit in the a$$ just about
every time I tried  the comma-delim list approach.
Another plus is it's really easy to return an Excel file directly to
those doing the tabulating - which they seem to like - without bugging me
for the latest results 3 times a day.


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 9:14 PM
To: CF-Talk
Subject: Best Approach for Survey Question


I am trying to determine the best way to structure a series of survey
questions, keeping in mind that I need to make it easy to use for the
respondent, easy to code, and easy to tabulate the data later on.

I can structure the following typical question as a single set of
checkboxes:

Q5: Please select schools that provide interns (check all that apply):  [ ]
Sciences [ ] Management/Business [ ] Law [ ] Communications  [ ] Other

Using a single datafield for the question, I then would need to parse a
comma-delimited list to separated the answers.

- or - I can use a series of radio buttons:

Q5:Please select schools that provide interns (check all that apply):
   A. Sciences  [ ]
  B. Management/Business  [ ]
  C. Law  [ ]
   D. Communications  [ ]
E. Other  [ ]

If I use a separate data field (5 in this case) for each sub-part of the
question, then it is easy to tabulate results for each part.

Recommendations appreciated.

Richard Colman








~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228138
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: Best Approach for Survey Question

2006-01-02 Thread Snake
I thought that when I made it the first time :-)

Russ

-Original Message-
From: Rick Colman [mailto:[EMAIL PROTECTED] 
Sent: 02 January 2006 17:52
To: [EMAIL PROTECTED]
Subject: RE: Best Approach for Survey Question

This is a very cool approach to doing it. Thank you. 

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: Monday, January 02, 2006 9:33 AM
To: CF-Talk
Subject: RE: Best Approach for Survey Question

I once made a form build that could be used for pretty much anything,
profiles, questionnaires, anything that required a form.

It was constructed something like thus:-

Table: questions
questionID  int primarykey
Questionvarchar
Fieldtype   varchar
Requiredbit default(0)
Sizeint
Maxlength   int
Validation  varchar
Multiplebit default(0)


Table: answers
answerIDint primarykey
questionId  int
Answer

Table: Options
optionIDint primarykey
Optiontext  varchar
Optionvalue varchar
DefaultSelected BIT default(0)

So then you just loop over the questions, creating the specifield form field
types with the specified attributes.
For select lists, multi radios or checkboxes, you just add items to the
options table.

E.G.

cfquery name=questions
Select * from questions
/cfquery
cfquery name=options
Select * from questions
/cfquery

cfloop query=questions
cfset QUID = questionID
cfif fieldtype=select
  select name=Q#QID# #IIF(multiple, 'multiple', '')# size=#size#
cfloop query=options
cfif questionID = QID
option value=#optionvalue# #IIF(SefaultSelected,
'Selected','')##optiontext#
/cfif
/cfloop
  /select
cfelseif fieldtype is text
  input type=text name=Q#QID# maxlength=#maxlength# size=#size##
/cfif

Get the idea?

Then when the form is submitted you simply save the answers in the answers
table for the specified QID.
--
Russ
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: 02 January 2006 15:43
To: CF-Talk
Subject: RE: Best Approach for Survey Question

ALWAYS use separate columns. I've been bit in the a$$ just about
every time I tried  the comma-delim list approach.
Another plus is it's really easy to return an Excel file directly to
those doing the tabulating - which they seem to like - without bugging me
for the latest results 3 times a day.


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 9:14 PM
To: CF-Talk
Subject: Best Approach for Survey Question


I am trying to determine the best way to structure a series of survey
questions, keeping in mind that I need to make it easy to use for the
respondent, easy to code, and easy to tabulate the data later on.

I can structure the following typical question as a single set of
checkboxes:

Q5: Please select schools that provide interns (check all that apply):  [ ]
Sciences [ ] Management/Business [ ] Law [ ] Communications  [ ] Other

Using a single datafield for the question, I then would need to parse a
comma-delimited list to separated the answers.

- or - I can use a series of radio buttons:

Q5:Please select schools that provide interns (check all that apply):
   A. Sciences  [ ]
  B. Management/Business  [ ]
  C. Law  [ ]
   D. Communications  [ ]
E. Other  [ ]

If I use a separate data field (5 in this case) for each sub-part of the
question, then it is easy to tabulate results for each part.

Recommendations appreciated.

Richard Colman










~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228141
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


Best Approach for Survey Question

2006-01-01 Thread Richard Colman
I am trying to determine the best way to structure a series of survey
questions, keeping in mind that I need to make it easy to use for the
respondent, easy to code, and easy to tabulate the data later on. 

I can structure the following typical question as a single set of
checkboxes:

Q5: Please select schools that provide interns (check all that apply):  [ ]
Sciences [ ] Management/Business [ ] Law [ ] Communications  [ ] Other

Using a single datafield for the question, I then would need to parse a
comma-delimited list to separated the answers.

- or - I can use a series of radio buttons:

Q5:Please select schools that provide interns (check all that apply):
   A. Sciences  [ ]
  B. Management/Business  [ ]
  C. Law  [ ]
   D. Communications  [ ]
E. Other  [ ]

If I use a separate data field (5 in this case) for each sub-part of the
question, then it is easy to tabulate results for each part.

Recommendations appreciated.

Richard Colman




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228118
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: Best Approach for Survey Question

2006-01-01 Thread Bobby Hartsfield
Not quite sure what your question is... whether or not you should use a
comma delimited list of items or a separate record for each? If that is your
question most definitely a separate record for each question AND answer

Here's a script I use for building the necessary tables for a survey app I
did... It can house multiple surveys, multiple questions per survey, and
multiple answers per question.

At the 'question' level, you define the form field type to use for that
particular question. 

Eg... radio (single answer), checkbox (multiple answers), text, textarea... 

The backend has everything you'd need... including reports and it all works
great with this database schema.

There is only one type of answer that I haven't put in it and that is a
question with multiple answers but each of those answers would have multiple
answers themselves... It would be used for rating each answer to one
question. Something like...

Rate These Answers:
One [bad] [good] [great]
Two [bad] [good] [great]
Three [bad] [good] [great]

Email me offlist if you'd like to see the app and its administrative tools
in action.

== srv_globals.cfm =
cfscript
request.surveydsn = surveyapp;
request.tblprefix = tbl_survey_;
request.debugon = yes;
request.imageroot = http://#cgi.server_name#/images;;
request.webroot = http://#cgi.server_name#/surveys;;
/cfscript



=== msaccess_tbl_script.cfm ==
cfinclude template=surveys/srv_globals.cfm
cfoutput
cftry
cfquery datasource=#request.surveydsn#
create table #request.tblprefix#as
(
  answerid counter primary key
, questionid number
, surveyid number
, answer text(250)
, fieldtype text(50)
, sortid number
)
/cfquery
div#request.tblprefix#as was created successfully/div
cfcatch type=any
div style=color:##ff;#request.tblprefix#as already exists/div
/cfcatch
/cftry


cftry
cfquery datasource=#request.surveydsn#
create table #request.tblprefix#qs
(
  questionid  counter primary key
, surveyid number
, question memo
, fieldtype text(50)
, sortid number
)
/cfquery
div#request.tblprefix#qs was created successfully/div
cfcatch type=any
div style=color:##ff;#request.tblprefix#qs already exists/div
/cfcatch
/cftry



cftry
cfquery datasource=#request.surveydsn#
create table #request.tblprefix#faqs
(
  faqid  counter primary key
, faqquestion memo
, faqanswer memo 
, sortid number
)
/cfquery
div#request.tblprefix#faqs was created successfully/div
cfcatch type=any
div style=color:##ff;#request.tblprefix#faqs already exists/div
/cfcatch
/cftry



cftry
cfquery datasource=#request.surveydsn#
create table #request.tblprefix#results
(
  resultid counter primary key
, submitid number
, surveyid number
, questionid number
, answer memo

)
/cfquery
div#request.tblprefix#results was created successfully/div
cfcatch type=any
div style=color:##ff;#request.tblprefix#results already exists/div
/cfcatch
/cftry



cftry
cfquery datasource=#request.surveydsn#
create table #request.tblprefix#submits
(
  submitid counter primary key
, surveyid number
, dateadded datetime
, fname text(20)
, lname text(20)
, address text(150)
, address2 text(150)
, city text(50)
, state text(20)
, zip text(15)
, comments memo
, emailaddr text(150)
, contactme number
)
/cfquery
div#request.tblprefix#submits was created successfully/div
cfcatch type=any
div style=color:##ff;#request.tblprefix#submits already exists/div
/cfcatch
/cftry




cftry
cfquery datasource=#request.surveydsn#
create table #request.tblprefix#surveys
(
  surveyid counter primary key
, surveyname text(250)
, activesurvey number
, dateadded datetime
, confirmation memo
)
/cfquery
div#request.tblprefix#surveys was created successfully/div
cfcatch type=any
div style=color:##ff;#request.tblprefix#surveys already exists/div
/cfcatch
/cftry
/cfoutput 

 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228120
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


Best Approach?

2005-10-11 Thread Adkins, Randy
What is the best approach to searching a LARGE segment of text for each
instance of
FONT-FAMILY and changing the actual value of it to ARIAL?
 
Here is an example of the text before it is converted:
P class=MsoNormal style=MARGIN: 0in 0in 0pt 1inSPAN
style=FONT-SIZE: 11pt; FONT-FAMILY: VERDANATESTING THIS OUT/SPAN 
 
Now the catch is, the font-family could be any font, but all needs to be
changed to one standard font.
 
Also there are variations of fonts such as:  Arial (W1), that should be
just ARIAL.
 
Without doing a Search and Replace for each and every variation of each
font (which is a nightmare to even consider),
I had thought of doing a search for FONT-FAMILY then finding the end of
the value by either a single quote, double quote, semi-colon
or even the greater than symbol () and then replacing it that way, but
it seems to be more cumbersome than it should be.
 
Any ideas on improving that??
 
Thanks!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220678
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: Best Approach?

2005-10-11 Thread Bobby Hartsfield
Just a shot but see how this works. 

#rereplacenocase(str, (font-family:)(.*?)(;||)|\), \1arial\3, all)#

It turned this
font-family:verdana;font-family:arial(w1);font-family:sans-seriffont-family
:sans-serif

into this
font-family:arial;font-family:arial;font-family:arialfont-family:arial  

but of course that’s not a real-world test

it only works if the name of the font ends with on of these...

;


)

And puts the ending char back in place except when it is a )

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 11, 2005 10:49 AM
To: CF-Talk
Subject: Best Approach?

What is the best approach to searching a LARGE segment of text for each
instance of
FONT-FAMILY and changing the actual value of it to ARIAL?
 
Here is an example of the text before it is converted:
P class=MsoNormal style=MARGIN: 0in 0in 0pt 1inSPAN
style=FONT-SIZE: 11pt; FONT-FAMILY: VERDANATESTING THIS OUT/SPAN 
 
Now the catch is, the font-family could be any font, but all needs to be
changed to one standard font.
 
Also there are variations of fonts such as:  Arial (W1), that should be
just ARIAL.
 
Without doing a Search and Replace for each and every variation of each
font (which is a nightmare to even consider),
I had thought of doing a search for FONT-FAMILY then finding the end of
the value by either a single quote, double quote, semi-colon
or even the greater than symbol () and then replacing it that way, but
it seems to be more cumbersome than it should be.
 
Any ideas on improving that??
 
Thanks!




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220715
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


best approach - appending fields in recordset

2004-09-20 Thread Lawrence Ng
hello folks,

I have a situation where the database was designed (limitation in the
db unfortunately) so that if a user wants to enter a lot of
text/content, they would have to add a new line for every entry that
doesn't fit. Think textarea but only your using multiple input type
text =(

so when I pull up the query (which is correct), it displays all the
lines/rowsof content for that field entered.

example:

courseID
courseDescription (varchar 80)

so if the description was more than 80 chars, then they would have to
add another line. if the description was 350 chars, then 5 lines, etc.

so, how would you approach this where I could append the results from
the courseDescription field to make it all look like one?

thanks,

Lawrence
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: best approach - appending fields in recordset

2004-09-20 Thread G
With a one-to-many relationship like this, you might want courseID and courseDescription to be in seperate tables. You could then join ID and Description to bring back a list of descriptions, grouping the descriptions together to make it look like one description. Your Description table would probably have to have some type of ordering value in it though so you'd know how to construct the descriptions in the correct order.

- Original Message - 
From: Lawrence Ng 
To: CF-Talk 
Sent: Monday, September 20, 2004 10:10 AM
Subject: best approach - appending fields in recordset

hello folks,

I have a situation where the database was designed (limitation in the
db unfortunately) so that if a user wants to enter a lot of
text/content, they would have to add a new line for every entry that
doesn't fit. Think textarea but only your using multiple input type
text =(

so when I pull up the query (which is correct), it displays all the
lines/rowsof content for that field entered.

example:

courseID
courseDescription (varchar 80)

so if the description was more than 80 chars, then they would have to
add another line. if the description was 350 chars, then 5 lines, etc.

so, how would you approach this where I could append the results from
the courseDescription field to make it all look like one?

thanks,

Lawrence
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: best approach - appending fields in recordset

2004-09-20 Thread Lawrence Ng
the description field is on a separate table. the problem is that field
type which is only char type not ntext/memo which would make it easier
to order them properly.

 [EMAIL PROTECTED] 9/20/2004 9:29:33 AM 
With a one-to-many relationship like this, you might want courseID and
courseDescription to be in seperate tables. You could then join ID and
Description to bring back a list of descriptions, grouping the
descriptions together to make it look like one description. Your
Description table would probably have to have some type of ordering
value in it though so you'd know how to construct the descriptions in
the correct order.

- Original Message - 
From: Lawrence Ng 
To: CF-Talk 
Sent: Monday, September 20, 2004 10:10 AM
Subject: best approach - appending fields in recordset

hello folks,

I have a situation where the database was designed (limitation in
the
db unfortunately) so that if a user wants to enter a lot of
text/content, they would have to add a new line for every entry that
doesn't fit. Think textarea but only your using multiple input type
text =(

so when I pull up the query (which is correct), it displays all the
lines/rowsof content for that field entered.

example:

courseID
courseDescription (varchar 80)

so if the description was more than 80 chars, then they would have
to
add another line. if the description was 350 chars, then 5 lines,
etc.

so, how would you approach this where I could append the results
from
the courseDescription field to make it all look like one?

thanks,

Lawrence
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: best approach - appending fields in recordset

2004-09-20 Thread G
So, if you've got 10 description entries that all go together somehow to form the overall description for one course, how do you know in which order they are supposed to go? Which sentence comes first, second, etc?

Wouldn't you need some sort of ordering field to do this on the description table?
- Original Message - 
From: Lawrence Ng 
To: CF-Talk 
Sent: Monday, September 20, 2004 2:36 PM
Subject: Re: best approach - appending fields in recordset

the description field is on a separate table. the problem is that field
type which is only char type not ntext/memo which would make it easier
to order them properly.

snip
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: best approach - appending fields in recordset

2004-09-20 Thread Lawrence Ng
yeah... that's right...

my best guess is that I'll sort/order them asc fashion...

first line entered (id 1), second line (id 2)...

i'll see what I come up with

 [EMAIL PROTECTED] 9/20/2004 12:43:59 PM 
So, if you've got 10 description entries that all go together somehow
to form the overall description for one course, how do you know in which
order they are supposed to go? Which sentence comes first, second, etc?

Wouldn't you need some sort of ordering field to do this on the
description table?
- Original Message - 
From: Lawrence Ng 
To: CF-Talk 
Sent: Monday, September 20, 2004 2:36 PM
Subject: Re: best approach - appending fields in recordset

the description field is on a separate table. the problem is that
field
type which is only char type not ntext/memo which would make it
easier
to order them properly.

snip
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: best approach - appending fields in recordset

2004-09-20 Thread Douglas Knudsen
assuming you have this, I'd order teh content by courseid.Then use
the group attribute of cfoutput to loop thgough all these descriptions
outputing them.This will basically do

COURSEID
DESCR1DESCR2DESCR3..DESCRN

format as desired

Doug

- Original Message -
From: G [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 14:43:59 -0500
Subject: Re: best approach - appending fields in recordset
To: CF-Talk [EMAIL PROTECTED]

So, if you've got 10 description entries that all go together somehow
to form the overall description for one course, how do you know in
which order they are supposed to go? Which sentence comes first,
second, etc?

Wouldn't you need some sort of ordering field to do this on the
description table?
- Original Message - 
From: Lawrence Ng 
To: CF-Talk 
Sent: Monday, September 20, 2004 2:36 PM
Subject: Re: best approach - appending fields in recordset

the description field is on a separate table. the problem is that field
type which is only char type not ntext/memo which would make it easier
to order them properly.

snip
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: best approach - appending fields in recordset

2004-09-20 Thread Lawrence Ng
yeah those were my thoughts too...

 [EMAIL PROTECTED] 9/20/2004 12:50:58 PM 
assuming you have this, I'd order teh content by courseid.Then use
the group attribute of cfoutput to loop thgough all these descriptions
outputing them.This will basically do

COURSEID
DESCR1DESCR2DESCR3..DESCRN

format as desired

Doug

- Original Message -
From: G [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 14:43:59 -0500
Subject: Re: best approach - appending fields in recordset
To: CF-Talk [EMAIL PROTECTED]

So, if you've got 10 description entries that all go together somehow
to form the overall description for one course, how do you know in
which order they are supposed to go? Which sentence comes first,
second, etc?

Wouldn't you need some sort of ordering field to do this on the
description table?
- Original Message - 
From: Lawrence Ng 
To: CF-Talk 
Sent: Monday, September 20, 2004 2:36 PM
Subject: Re: best approach - appending fields in recordset

the description field is on a separate table. the problem is that
field
type which is only char type not ntext/memo which would make it
easier
to order them properly.

snip
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Best Approach to Storing Selections...

2003-09-15 Thread Adam Reynolds
If you put a picture up, just make sure it has a watermark all over it. If
you don't they will find a way of getting to the picture.

As to storing their selections. Seriously consider storing their current
selection in a DB, storing an id in a cookie. So that should they be
building an order over time, this information isn't lost should their
machine crash or something.

Also assume some MOST people want to shop by searching the description of
each photo (i.e. they only want pictures of one particular
player/team/car/animal/pvc/mud wrestling etc ;) ).

If I came to your site and wanted a picture, I do not want to look through
1000s of pictures 25 at a time.

I would also like to browse by event (navigating through sport types), but
mostly I would do keyword searches.




 -Original Message-
 From: Jim Davis [mailto:[EMAIL PROTECTED]
 Sent: 15 September 2003 05:08
 To: CF-Talk
 Subject: RE: Best Approach to Storing Selections...


  I had planned to use a javascript function to not allow
 right-clicking
  and saving the image...
 
  Forget this: this is just a gadget. It will only prevent people from
  copying the image who
  would be too dumb to print it anyway.
  You don't need to come from Harvard to know how to get an image from
 the
  cache,
  or get its address directly from the source page, or even just capture
 the
  image on the screen.

 Or just turn off JavaScript. ;^)

 Jim Davis



 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Best Approach to Storing Selections...

2003-09-15 Thread Rick Faircloth
Yes, the intention is to use Efflare's CFX_ImageCR Tag or CFX_jpg Tag
to create separate files for the display images.  They won't have access
to the files that we'll print from...

Rick


  -Original Message-
  From: Doug White [mailto:[EMAIL PROTECTED]
  Sent: Sunday, September 14, 2003 11:40 PM
  To: CF-Talk
  Subject: Re: Best Approach to Storing Selections...


  The JavaScript function will prevent right clicking, however
  the image will
  still be in the browser cache and can be saved from there.
  Instead of resizing
  the true image, use a utility to create a thumbnail for
  browser display, or
  alternatively display the images via Java in a popup window.
  You can obtain Anfy Java (intended for special effects) and
  create the code to
  display via Java which cannot be saved.  With a little
  effort you can create a
  photo display on a revolving cube.
  http://www.anfyteam.com/panjava.html  or even
  display them in flash.

  ==
  Stop spam on your domain, use our gateway!
  For hosting solutions http://www.clickdoug.com
  Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all
  databases.
  ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
  Suggested corporate Anti-virus policy:
  http://www.dshield.org/antivirus.pdf
  ==
  If you are not satisfied with my service, my job isn't done!

  - Original Message -
  From: Rick Faircloth [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Sunday, September 14, 2003 10:17 PM
  Subject: RE: Best Approach to Storing Selections...


  | I had planned to use a javascript function to not allow
  right-clicking
  | and saving the image...the onscreen display image would only be
  | a 320 pixel wide image, so it wouldn't be very good for
  printing and framing
  | anyway,
  | but the javascript function will prevent saving of the image.
  |
  | Probably none of the people we'd be selling to...football
  parents, soccer
  | parents, etc.,
  | would know how to search the temporary Internet files to
  find the image
  | either.
  |
  | Most of the images will be processed through Photoshop,
  whether I take them
  | or my
  | partner takes them, so we could add a watermark manually.
  |
  | I'll probably check into CFX_stampImage, also.
  |
  | What do you think about the approach of using an array to
  store selections
  | from each
  | page and then dumping the array contents onscreen for
  review, then into a db
  | upon checkout...
  |
  | Rick
  |
  |
  |
  |
  |   -Original Message-
  |   From: Claude Schneegans [mailto:[EMAIL PROTECTED]
  |   Sent: Sunday, September 14, 2003 10:29 PM
  |   To: CF-Talk
  |   Subject: Re: Best Approach to Storing Selections...
  | 
  | 
  |   Also make damm sure you put some sort of watermark all
  |   over the images on
  |   the screen to stop people just printing off their images.
  | 
  |   Pretty good point.
  | 
  |   If you produce the images yourself, you can use PaintShopPro
  |   for this, or PhotoShop or any image editor.
  |   If you or users upload their photos themselves, look at
  |   CFX_stampImage at:
  | 
  http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf
  | 
  | 
  | 
  ~
  |   |
  |   Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
  |   Subscription:
  http://www.houseoffusion.com/lists.cfm?link=s:4
  |   Unsubscribe:
  | 
  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
  | 
  |   Get the mailserver that powers this list at
  |   http://www.coolfusion.com
  | 
  | 
  |
  |
  |
  ~
  |
  Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
  Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
  Unsubscribe:
  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4

  This list and all House of Fusion resources hosted by
  CFHosting.com. The place for dependable ColdFusion Hosting.
  http://www.cfhosting.com



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user

RE: Best Approach to Storing Selections...

2003-09-15 Thread Rick Faircloth
Thanks for the feedback, Claude...

Rick


  -Original Message-
  From: Claude Schneegans [mailto:[EMAIL PROTECTED]
  Sent: Sunday, September 14, 2003 11:32 PM
  To: CF-Talk
  Subject: Re: Best Approach to Storing Selections...
  
  
  I had planned to use a javascript function to not allow 
  right-clicking
  and saving the image...
  
  Forget this: this is just a gadget. It will only prevent 
  people from copying the image who
  would be too dumb to print it anyway.
  You don't need to come from Harvard to know how to get an 
  image from the cache,
  or get its address directly from the source page, or even 
  just capture the image on the screen.
  
  the onscreen display image would only be a 320 pixel wide image,
  
  This is definitely a much better security.
  
  I'll probably check into CFX_stampImage, also.
  
  While you pass by, also check for CF_picture frame, it could 
  add a plus to your presentation.
  
  What do you think about the approach of using an array to 
  store selections
  from each page and then dumping the array contents onscreen 
  for review, then into a db
  upon checkout...
  
  It could be an array or just using variables in the form scope.
  You could also look at techniques used by some shoping cart systems.
  There are a couple in the CF gallery.
  
  
  
  ~
  |
  Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
  Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
  Unsubscribe: 
  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
  
  Signup for the Fusion Authority news alert and keep up with 
  the latest news in ColdFusion and related topics. 
  http://www.fusionauthority.com/signup.cfm
  
  

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Best Approach to Storing Selections...

2003-09-15 Thread Rick Faircloth
Thanks for the feedback Adam...

  As to storing their selections. Seriously consider storing
  their current selection in a DB, storing an id in a cookie. So that
should they be
  building an order over time, this information isn't lost should their
  machine crash or something.

You mean, after each page's selections, insert that part of the order
into the database, so that their selections are still in the cart if/when
they come agan to continue?  Then, once they move on to checkout,
pull the order parts from the db?  Or, I guess, instead of inserting a
separate row
after each page of photos selected is processed, just update the row that
was first
created after they made their first selections on a page...using the cookie
ID you referred
to as a key in the db to match up the current user with their order in the
db?

Only problem I can see with using a cookie is if the user usually placed
orders
from a single machine, got used to the system keeping track of multliple
ordering sessions,
then decided one day to go over to a friend's house in the middle of placing
an order,
and tried to continue from there...they would find their previous selections
unaccessible
because the cookie wouldn't exist on the machine at their friend's house...

I see pros and cons to using the cookie to enable multiple session order
placement...
If they had to login, that problem would be solved, but we don't want to
require people to login...

I haven't placed content in cookies before (other than what the system does
for session management)...
What type of ID would be good for storing in the cookie?

Also, searching by category, event, and keyword are part of the plans
for the shopping experience.  There would probably be only about 100
photos
of a typical event, such as a football game...so looking through all the
photos,
especially when they are photos of the person looking through them, wouldn't
be too much of a hassle and time-consuming...

Rick







  -Original Message-
  From: Adam Reynolds [mailto:[EMAIL PROTECTED]
  Sent: Monday, September 15, 2003 4:16 AM
  To: CF-Talk
  Subject: RE: Best Approach to Storing Selections...


  If you put a picture up, just make sure it has a watermark
  all over it. If
  you don't they will find a way of getting to the picture.

  As to storing their selections. Seriously consider storing
  their current
  selection in a DB, storing an id in a cookie. So that should they be
  building an order over time, this information isn't lost should their
  machine crash or something.

  Also assume some MOST people want to shop by searching the
  description of
  each photo (i.e. they only want pictures of one particular
  player/team/car/animal/pvc/mud wrestling etc ;) ).

  If I came to your site and wanted a picture, I do not want
  to look through
  1000s of pictures 25 at a time.

  I would also like to browse by event (navigating through
  sport types), but
  mostly I would do keyword searches.




   -Original Message-
   From: Jim Davis [mailto:[EMAIL PROTECTED]
   Sent: 15 September 2003 05:08
   To: CF-Talk
   Subject: RE: Best Approach to Storing Selections...
  
  
I had planned to use a javascript function to not allow
   right-clicking
and saving the image...
   
Forget this: this is just a gadget. It will only prevent
  people from
copying the image who
would be too dumb to print it anyway.
You don't need to come from Harvard to know how to get
  an image from
   the
cache,
or get its address directly from the source page, or
  even just capture
   the
image on the screen.
  
   Or just turn off JavaScript. ;^)
  
   Jim Davis
  
  
  
  
  ~
  |
  Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
  Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
  Unsubscribe:
  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4

  Get the mailserver that powers this list at
  http://www.coolfusion.com




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Best Approach to Storing Selections...

2003-09-15 Thread Adam Reynolds
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: 15 September 2003 13:28
 To: CF-Talk
 Subject: RE: Best Approach to Storing Selections...

 Also, searching by category, event, and keyword are part of the plans
 for the shopping experience.  There would probably be only about 100
 photos
 of a typical event, such as a football game...so looking through all the
 photos,
 especially when they are photos of the person looking through
 them, wouldn't
 be too much of a hassle and time-consuming...

Wanna bet! Think about doing this on a 33kbps modem.




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Best Approach to Storing Selections...

2003-09-14 Thread Rick Faircloth
Hi, all.

I'm setting up a site for users to order photos...
They won't be purchasing online, just specifiying which
photos they want to have printed...then an email will be
sent to the user after placing their order...and an email will be sent
to a local photo shop who will handle the printing and payments.

I was wondering about the best way to handle the data...

The flow will be like this...

- User views multiple photos on page...

- Each photo has checkboxes for options like 4x6, 5x7, 8x10, and associated
price.

 -The user will check boxes for various options for photos on each page.

- The user will go to another page to view more photos and make selections.

- User checks list of all they're order and total cost is calculated and
presented.


The biggest issue to the best way to handle the info...

- First, I'm considering making all checkbox names dynamic, such as
  '#PhotoQuery.PhotoName#''4x6', '#PhotoQuery.PhotoName#''5x7', etc...
  Would that work for making each checkbox unique?

- Secondly, I need to store the selections...should I do this in an array,
including
  PhotoName, Size, Price...then just output the array contents for review,
then
  into the order emails when checkout occurs?


Thanks for anyone's time and insight...I haven't put together a shopping
cart yet,
so I just want to make sure I'm headed in the right direction with the
coding before I start...

Thanks,

Rick


Rick Faircloth
WhiteStoneMedia.com


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Best Approach to Storing Selections...

2003-09-14 Thread Adam Reynolds
Firstly are these pictures specific to them? Or are they along the lines of
IMDB.com's pictures of celebs?

Also how many pictures are involved?

Assuming sombeody sent you a roll of film (so around 36 pictures), would it
not be better to present the user with all the images on one page and (after
they have default selected a size.)

Also make damm sure you put some sort of watermark all over the images on
the screen to stop people just printing off their images.

Also what if a customer wanted multiple copies of a picture all different
sizes? I would probably go for a quantity box for each size which defaults
to 1 of each 4x6.

I would probably store the order away in a db against their username. I
would assume if they were personal photos the person would have to log in.

Anyway lots to think about.

 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: 14 September 2003 22:39
 To: CF-Talk
 Subject: Best Approach to Storing Selections...


 Hi, all.

 I'm setting up a site for users to order photos...
 They won't be purchasing online, just specifiying which
 photos they want to have printed...then an email will be
 sent to the user after placing their order...and an email will be sent
 to a local photo shop who will handle the printing and payments.

 I was wondering about the best way to handle the data...

 The flow will be like this...

 - User views multiple photos on page...

 - Each photo has checkboxes for options like 4x6, 5x7, 8x10, and
 associated
 price.

  -The user will check boxes for various options for photos on each page.

 - The user will go to another page to view more photos and make
 selections.

 - User checks list of all they're order and total cost is calculated and
 presented.


 The biggest issue to the best way to handle the info...

 - First, I'm considering making all checkbox names dynamic, such as
   '#PhotoQuery.PhotoName#''4x6', '#PhotoQuery.PhotoName#''5x7', etc...
   Would that work for making each checkbox unique?

 - Secondly, I need to store the selections...should I do this in an array,
 including
   PhotoName, Size, Price...then just output the array contents for review,
 then
   into the order emails when checkout occurs?


 Thanks for anyone's time and insight...I haven't put together a shopping
 cart yet,
 so I just want to make sure I'm headed in the right direction with the
 coding before I start...

 Thanks,

 Rick


 Rick Faircloth
 WhiteStoneMedia.com


 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Best Approach to Storing Selections...

2003-09-14 Thread Rick Faircloth
Hi, Adam and thanks for the reply...

These are photos that I and a partner will be taking of sporting events,
etc.

There could possibly be about 75-100 photos per game to be uploaded.

100 photos is a lot to display on a single page...so I was thinking about
having them view photos 25 at a time, to keep downloading shorter for
dial-up access, which most will be on.

With that in mind, I'll need to store the selections, (thanks for the tip on
handling multiples copies of a photo) some way that will maintain selections
between pages...once the order is complete, then the info will go into a
database.

I figure an array will be most appropriate...is that what most shopping
carts use
to store info until checkout?

Rick


  -Original Message-
  From: Adam Reynolds [mailto:[EMAIL PROTECTED]
  Sent: Sunday, September 14, 2003 8:44 PM
  To: CF-Talk
  Subject: RE: Best Approach to Storing Selections...


  Firstly are these pictures specific to them? Or are they
  along the lines of
  IMDB.com's pictures of celebs?

  Also how many pictures are involved?

  Assuming sombeody sent you a roll of film (so around 36
  pictures), would it
  not be better to present the user with all the images on one
  page and (after
  they have default selected a size.)

  Also make damm sure you put some sort of watermark all over
  the images on
  the screen to stop people just printing off their images.

  Also what if a customer wanted multiple copies of a picture
  all different
  sizes? I would probably go for a quantity box for each size
  which defaults
  to 1 of each 4x6.

  I would probably store the order away in a db against their
  username. I
  would assume if they were personal photos the person would
  have to log in.

  Anyway lots to think about.

   -Original Message-
   From: Rick Faircloth [mailto:[EMAIL PROTECTED]
   Sent: 14 September 2003 22:39
   To: CF-Talk
   Subject: Best Approach to Storing Selections...
  
  
   Hi, all.
  
   I'm setting up a site for users to order photos...
   They won't be purchasing online, just specifiying which
   photos they want to have printed...then an email will be
   sent to the user after placing their order...and an email
  will be sent
   to a local photo shop who will handle the printing and payments.
  
   I was wondering about the best way to handle the data...
  
   The flow will be like this...
  
   - User views multiple photos on page...
  
   - Each photo has checkboxes for options like 4x6, 5x7, 8x10, and
   associated
   price.
  
-The user will check boxes for various options for photos
  on each page.
  
   - The user will go to another page to view more photos and make
   selections.
  
   - User checks list of all they're order and total cost is
  calculated and
   presented.
  
  
   The biggest issue to the best way to handle the info...
  
   - First, I'm considering making all checkbox names dynamic, such as
 '#PhotoQuery.PhotoName#''4x6',
  '#PhotoQuery.PhotoName#''5x7', etc...
 Would that work for making each checkbox unique?
  
   - Secondly, I need to store the selections...should I do
  this in an array,
   including
 PhotoName, Size, Price...then just output the array
  contents for review,
   then
 into the order emails when checkout occurs?
  
  
   Thanks for anyone's time and insight...I haven't put
  together a shopping
   cart yet,
   so I just want to make sure I'm headed in the right
  direction with the
   coding before I start...
  
   Thanks,
  
   Rick
  
  
   Rick Faircloth
   WhiteStoneMedia.com
  
  
  
  ~
  |
  Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
  Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
  Unsubscribe:
  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4

  Get the mailserver that powers this list at
  http://www.coolfusion.com




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: Best Approach to Storing Selections...

2003-09-14 Thread Claude Schneegans
Also make damm sure you put some sort of watermark all over the images on
the screen to stop people just printing off their images.

Pretty good point.

If you produce the images yourself, you can use PaintShopPro for this, or PhotoShop or 
any image editor.
If you or users upload their photos themselves, look at CFX_stampImage at:
http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Best Approach to Storing Selections...

2003-09-14 Thread Doug White
Or just display thumbnails on the screen (with watermark)

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases.
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: Claude Schneegans [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 9:29 PM
Subject: Re: Best Approach to Storing Selections...


| Also make damm sure you put some sort of watermark all over the images on
| the screen to stop people just printing off their images.
|
| Pretty good point.
|
| If you produce the images yourself, you can use PaintShopPro for this, or
PhotoShop or any image editor.
| If you or users upload their photos themselves, look at CFX_stampImage at:
| http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf
|
|
| 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Best Approach to Storing Selections...

2003-09-14 Thread Rick Faircloth
I had planned to use a javascript function to not allow right-clicking
and saving the image...the onscreen display image would only be
a 320 pixel wide image, so it wouldn't be very good for printing and framing
anyway,
but the javascript function will prevent saving of the image.

Probably none of the people we'd be selling to...football parents, soccer
parents, etc.,
would know how to search the temporary Internet files to find the image
either.

Most of the images will be processed through Photoshop, whether I take them
or my
partner takes them, so we could add a watermark manually.

I'll probably check into CFX_stampImage, also.

What do you think about the approach of using an array to store selections
from each
page and then dumping the array contents onscreen for review, then into a db
upon checkout...

Rick




  -Original Message-
  From: Claude Schneegans [mailto:[EMAIL PROTECTED]
  Sent: Sunday, September 14, 2003 10:29 PM
  To: CF-Talk
  Subject: Re: Best Approach to Storing Selections...


  Also make damm sure you put some sort of watermark all
  over the images on
  the screen to stop people just printing off their images.

  Pretty good point.

  If you produce the images yourself, you can use PaintShopPro
  for this, or PhotoShop or any image editor.
  If you or users upload their photos themselves, look at
  CFX_stampImage at:
  http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf


  ~
  |
  Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
  Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
  Unsubscribe:
  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4

  Get the mailserver that powers this list at
  http://www.coolfusion.com




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Best Approach to Storing Selections...

2003-09-14 Thread Doug White
The JavaScript function will prevent right clicking, however the image will
still be in the browser cache and can be saved from there.  Instead of resizing
the true image, use a utility to create a thumbnail for browser display, or
alternatively display the images via Java in a popup window.
You can obtain Anfy Java (intended for special effects) and create the code to
display via Java which cannot be saved.  With a little effort you can create a
photo display on a revolving cube. http://www.anfyteam.com/panjava.html  or even
display them in flash.

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases.
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 10:17 PM
Subject: RE: Best Approach to Storing Selections...


| I had planned to use a javascript function to not allow right-clicking
| and saving the image...the onscreen display image would only be
| a 320 pixel wide image, so it wouldn't be very good for printing and framing
| anyway,
| but the javascript function will prevent saving of the image.
|
| Probably none of the people we'd be selling to...football parents, soccer
| parents, etc.,
| would know how to search the temporary Internet files to find the image
| either.
|
| Most of the images will be processed through Photoshop, whether I take them
| or my
| partner takes them, so we could add a watermark manually.
|
| I'll probably check into CFX_stampImage, also.
|
| What do you think about the approach of using an array to store selections
| from each
| page and then dumping the array contents onscreen for review, then into a db
| upon checkout...
|
| Rick
|
|
|
|
|   -Original Message-
|   From: Claude Schneegans [mailto:[EMAIL PROTECTED]
|   Sent: Sunday, September 14, 2003 10:29 PM
|   To: CF-Talk
|   Subject: Re: Best Approach to Storing Selections...
| 
| 
|   Also make damm sure you put some sort of watermark all
|   over the images on
|   the screen to stop people just printing off their images.
| 
|   Pretty good point.
| 
|   If you produce the images yourself, you can use PaintShopPro
|   for this, or PhotoShop or any image editor.
|   If you or users upload their photos themselves, look at
|   CFX_stampImage at:
|   http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf
| 
| 
|   ~
|   |
|   Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
|   Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
|   Unsubscribe:
|   http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
| 
|   Get the mailserver that powers this list at
|   http://www.coolfusion.com
| 
| 
|
|
| 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: Best Approach to Storing Selections...

2003-09-14 Thread Claude Schneegans
I had planned to use a javascript function to not allow right-clicking
and saving the image...

Forget this: this is just a gadget. It will only prevent people from copying the image 
who
would be too dumb to print it anyway.
You don't need to come from Harvard to know how to get an image from the cache,
or get its address directly from the source page, or even just capture the image on 
the screen.

the onscreen display image would only be a 320 pixel wide image,

This is definitely a much better security.

I'll probably check into CFX_stampImage, also.

While you pass by, also check for CF_picture frame, it could add a plus to your 
presentation.

What do you think about the approach of using an array to store selections
from each page and then dumping the array contents onscreen for review, then into a db
upon checkout...

It could be an array or just using variables in the form scope.
You could also look at techniques used by some shoping cart systems.
There are a couple in the CF gallery.



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Best Approach to Storing Selections...

2003-09-14 Thread Jim Davis
 I had planned to use a javascript function to not allow
right-clicking
 and saving the image...
 
 Forget this: this is just a gadget. It will only prevent people from
 copying the image who
 would be too dumb to print it anyway.
 You don't need to come from Harvard to know how to get an image from
the
 cache,
 or get its address directly from the source page, or even just capture
the
 image on the screen.

Or just turn off JavaScript. ;^)

Jim Davis



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Best Approach: Populating Exchange Server data

2000-06-29 Thread Eric Dawson

Here's what I got:
An exchange server with 240 mailboxes.
I want to use the exchange server as the source of Human Resource related 
items such as org charts. Visio 2000 has ODBS connection and a wizard to 
generate the org charts. Problem is there is a bunch of data entry required 
(and I don't want to do it ... heh heh).

??? How can I give someone else Win95 client on Novell / NT network access 
to Exchange Server 5.5SP?3? administration to update the mailbox records. I 
haven't seen a remote administration client for Exchange Server, does this 
exist? Can I use LDAP?

Next I want to "publish" the company directory to the Intranet and (maybe) 
Internet site. What is the best way, and quickest ways to do this. LDAP?

Also they have IIS with ASP installed, but not Cold Fusion. I have 
recommended CF, but I am curious also to learn ASP approaches to the same 
problems.

Thanks
Eric

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

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