RE: HTML In Application.cfm

2006-01-01 Thread Jennifer Gavin-Wear
I don't suppose dreamweaver templates would work?  They do for me, but I'm
not working with 2400 pages!

Jenny

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: 31 December 2005 20:10
To: CF-Talk
Subject: RE: HTML In Application.cfm


Separating anything wasn't the question of this topic... it's how to include
something in 2400 pages easily




~|
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:228105
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: HTML In Application.cfm

2006-01-01 Thread Jennifer Gavin-Wear
Oh my, I'm going to agree with Russ ;)!  Happy new year Russ :-)

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 01 January 2006 01:30
To: CF-Talk
Subject: RE: HTML In Application.cfm


To which you say.
OK go with x, and then when your not happy with the work, come and pay me to
do it properly.

-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: 31 December 2005 17:06
To: CF-Talk
Subject: RE: HTML In Application.cfm

lol Ade .. which is often followed by and we've been quoted half that price
by x .




~|
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:228106
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: Currency formatting

2006-01-01 Thread Paul Hastings
Jennifer Gavin-Wear wrote:
 looks like it needs to be set in the application.cfm as when it's set in a
 template as soon as the browser moves to another template it goes back to
 the original currency.

it works per request (well as soon as you setLocale() it does) otherwise 
we'd never be able to easily build multi-lingual apps. the currency 
symbol will vary by locale but also by jvm version, for instance 
pre-euro versions in the years before those locales/countries swapped to 
the euro.

~|
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:228107
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: HTML In Application.cfm

2006-01-01 Thread Snake
Great minds think alike
Or perhaps were both just short on patience with clients. :-)
But I have told a few to bugger off then, and they have come crawling back.

Happy new year to u too. 

-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: 01 January 2006 11:49
To: CF-Talk
Subject: RE: HTML In Application.cfm

Oh my, I'm going to agree with Russ ;)!  Happy new year Russ :-)

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 01 January 2006 01:30
To: CF-Talk
Subject: RE: HTML In Application.cfm


To which you say.
OK go with x, and then when your not happy with the work, come and pay me to
do it properly.

-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: 31 December 2005 17:06
To: CF-Talk
Subject: RE: HTML In Application.cfm

lol Ade .. which is often followed by and we've been quoted half that price
by x .






~|
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:228108
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: HTML In Application.cfm

2006-01-01 Thread Snake
Understatement.
Hasn't anyone come round your house and kicked your ass yet :-)

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: 01 January 2006 01:46
To: CF-Talk
Subject: RE: HTML In Application.cfm

lol sh***tt
hey im ok and fun, just short tempered lol

its will. between his shittin himself and having to stop at every rest
stop (since he has a thing for those) I sure do feel for bobby!

~Dave the disruptor~
google will pay you money to getting rid of ie :)
http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ 


From: Snake [EMAIL PROTECTED]
Sent: Saturday, December 31, 2005 8:35 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: HTML In Application.cfm 

Imagine a road trip with Will and Dave  

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: 31 December 2005 20:10
To: CF-Talk
Subject: RE: HTML In Application.cfm

Separating anything wasn't the question of this topic... it's how to include
something in 2400 pages easily (by the time you started posting anyway)...
and in this case it would be done easily with Application.cfm (you've
agreed) but separating milk from eggs or planting trees or spooning with
your doctor has nothing to do with anything CF related which... btw.. is the
language in question... not English. You want to say something without
actually saying it? Use pseudo code, examples and experiences.

 I don't think any of the responses to the original poster said that 
 doing this would break anything

I don't recall saying otherwise... but the only reason I can think of for
absolutley excluding a possible solution is that it would 'break'
something... not because it might put an html tag in the 'business logic' of
your HTML application. I was merely pointing out that it would not break it.

 Uh, you know, I thought Silent Bob was ... silent?

Just a side note but... Kevin Smith (Silent Bob) talks in every movie he's
ever been in

 It is NOT all preferences and habits. Or at least, it shouldn't be.

Why shouldn't it be? Because it's not your preference?

 there's a body of knowledge that's been built up by the experiences 
 and study of others.

Who? Trees, acorns, ill-equipped doctors and well organized refridgerators?

 In the case of the original poster, I'd probably do the same thing as 
 he's

 doing. But if I were building the application from scratch, I probably 
 wouldn't.

He probably wouldn't either after this little 2400 page adventure.

I guess the best 'saying' for Tim and his 2400 pages in this case would
be... You can't polish a turd so just use your Application.cfm to fix your
problem. 

Now you know that in the future you'll want to be a little more mindful of
an applications growth and scalability no matter how small you THINK its
going to 'stay' because things just don't always work out the way we expect
them to. Now you have your own experience and study to base your decisions
on and don't have to rely on spooning your dentist.

 If you don't think that's a worthy topic of discussion

You have to wait for me to say it before you are allowed to insinuate that I
said or thought it. ;-)

But he's seen the good and bad side of both and will make his choice as to
the best solution for him and his next application... and THAT... is a
preference no matter where you let your doctor stick his eating utensils.

Of course, I may just be a little bitter since I started reading a 60 post
strong thread that started out OK, got weak, then got better and then turned
to shit... and just decided I wanted to spruce up the ending a little...
maaayb

And mybe im just bitter because I have to go on a road trip with Will
(Who, incidentally, has went through the spoon procedure with his doctor and
now has huge gas problems...)

 ;-) 

.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
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:228109
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: HTML In Application.cfm

2006-01-01 Thread dave
nope but you are more than welcome to come over and give it a try ;)
Nice hair btw~ haha damn that was worse then what I had back in the day, should 
change your motto from snakepit to aqua-net pit... haha

~Dave the disruptor~
google will pay you money to getting rid of ie :)
http://explorerdestroyer.com/
http://www.killbillsbrowser.com/ 


From: Snake [EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 7:44 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: HTML In Application.cfm 

Understatement.
Hasn't anyone come round your house and kicked your ass yet :-)





~|
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:228110
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: Using CF with ArgoSoft Email Server Plus

2006-01-01 Thread Dave Watts
 Thanks, Dave...and Happy New Year!

Happy new year to you too, and to everyone else on the list!

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!


~|
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:228111
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: HTML In Application.cfm

2006-01-01 Thread Claude Schneegans
 the entire ITIL suite of best practices
is built up from the experience of professionals who have seen what
goes wrong when alternative practices are followed.

All this is very nice in theory, but it does not prevent anyone from 
making the mistake
of applying the conclusions of those professionals to situations that do 
not qualify
and are different from the one the professionals got their experience with.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
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:228112
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: Using CF with ArgoSoft Email Server Plus

2006-01-01 Thread Rick Faircloth
Well...you know, Dave...seems to have turned out that
SmarterMail (Free Version, Single Domain) will allow me
to send email from cleint's addresses using CF to their
distribution lists, too.

I don't need to handle multiple domains except in relaying.
I just need to relay traffice from other than my domain to
addresses that are also other than my domain...

I think I just didnt' have relaying setup properly.  I've been
tinkering with it and it seems to be working like I need it to.

Of course, I found this out just after plunking down the $49
for ArgoSoft Plus, which I'll probably never use now...

One other note...ArgoSoft Plus has one ugly user interface...
Hope the Pro version's better...

Rick

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Sunday, January 01, 2006 12:38 PM
 To: CF-Talk
 Subject: RE: Using CF with ArgoSoft Email Server Plus
 
 
  Thanks, Dave...and Happy New Year!
 
 Happy new year to you too, and to everyone else on the list!
 



~|
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:228113
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: HTML In Application.cfm

2006-01-01 Thread Claude Schneegans
 Claude's question was what is the value of separating presentation 
logic from application logic?

Exact, however it was still under the subject of separating presentation 
logic from application logic
IN THE APPLICATION.CFM file, which I'm still not convinced about.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
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:228114
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: HTML In Application.cfm

2006-01-01 Thread Snake
I'm afraid you have lost me. Aqua-net ? 

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: 01 January 2006 17:30
To: CF-Talk
Subject: RE: HTML In Application.cfm

nope but you are more than welcome to come over and give it a try ;) Nice
hair btw~ haha damn that was worse then what I had back in the day, should
change your motto from snakepit to aqua-net pit... haha

~Dave the disruptor~
google will pay you money to getting rid of ie :)
http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ 


From: Snake [EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 7:44 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: HTML In Application.cfm 

Understatement.
Hasn't anyone come round your house and kicked your ass yet :-)







~|
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:228115
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


SERVER scope in CF Enterprise

2006-01-01 Thread lists
Hi,

If you're running CF Enterprise with sandboxes, does the SERVER scope still
apply to the entire server or dos each sandbox have its own SERVER scope?
 
Cheers,
Baz





~|
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:228116
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SERVER scope in CF Enterprise

2006-01-01 Thread James Holmes
Sandboxes don't change the way scopes apply - they only introduce
security checking via the java security methods; there remains a
single SERVER scope common across all sandboxes.

However, multiple instances of CF on the one machine will each have
their own SERVER scope, because each instance runs in its own JVM.

On 1/2/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 Hi,

 If you're running CF Enterprise with sandboxes, does the SERVER scope still
 apply to the entire server or dos each sandbox have its own SERVER scope?

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.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:228117
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: HTML In Application.cfm

2006-01-01 Thread dave
was looking at your pix (btw~ your wifes site has a nice dsn cant be found 
error) and I just starting sing every rose has it's thorn.

~Dave the disruptor~
google will pay you money to getting rid of ie :)
http://explorerdestroyer.com/
http://www.killbillsbrowser.com/ 


From: Snake [EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 1:19 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: HTML In Application.cfm 

I'm afraid you have lost me. Aqua-net ? 

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: 01 January 2006 17:30
To: CF-Talk
Subject: RE: HTML In Application.cfm

nope but you are more than welcome to come over and give it a try ;) Nice
hair btw~ haha damn that was worse then what I had back in the day, should
change your motto from snakepit to aqua-net pit... haha

~Dave the disruptor~
google will pay you money to getting rid of ie :)
http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ 


From: Snake 
Sent: Sunday, January 01, 2006 7:44 AM
To: CF-Talk 
Subject: RE: HTML In Application.cfm 

Understatement.
Hasn't anyone come round your house and kicked your ass yet :-)



~|
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:228119
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-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


IIS vs. Apache again...

2006-01-01 Thread Russ
I'm trying out the CF on Wheels framework, and it's showing real promise.
I've got it running perfectly under Apache, but I can't seem to get it to
run under IIS.  It requires mod_rewrite under apache, and I've tried all the
ISAPI plugins I can find for IIS that simulate it, but none come even close.
One of the lines in the config file is 

 

RewriteCond %{REQUEST_FILENAME} !-f

RewriteRule ^(.*)$ dispatch.cfc?method=dispatchcf_request=%{REQUEST_URI}
[QSA,L]

 

Which basically sets up a 404 handler.  I couldn't find similar
functionality in any of the MOD_REWRITE clones for IIS.  Specifically the
!-f part.   Now, I tried setting up a 404 handler in IIS, and then pass the
url to the dispatch.cfc, and it works ok for GET, but doesn't work for POST.


 

So what happened to IIS being better than or as good as Apache?  It can't
even handle a simple 404 rewrite.  Or is it just me?

 

Russ



~|
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:228121
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