Re: How do you guys save progressing projects?
>Yes, that's SVN. You can use GUI clients to manage it like TortoiseSVN >(assuming you are on Windows). Ahh yeah! I was trying to figure it out and I'm one of those folks without my GUI's. :) preesh james, Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do you guys save progressing projects?
Is this what you use? http://subversion.tigris.org/ Thanks, Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How do you guys save progressing projects?
I'm building an application and testing new features constantly in it. How do you guys deal with saving the project and its different versions as it grows and features are added. Some features are just tests... you don't know they'll be in the final build. Sometimes you don't even know if they'll work as you want, so you have to retreat back to the older version and continue along from there. How do you organize this kinda stuff? the files? etc.. Thanks, Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: switching to coldfusion
Hi Tom, To answer your questions: Yes, CF is ideal for this project. It's pretty easy to learn, particularly if you are familiar with the tag based syntax of HTML. It has a lot of functionality 'out of the box', and it's syntax is pretty intuitive. You can happily have plain HTML pages and CF pages in the same site. You can happily use drop down menus, javascript, infact anything else you can put on a webpage and CF at the same time. You could use CF to dynamically build your drop down menus on page load for example. I've not used Cartweaver, so I can't comment on that specifically, but there are a wealth of options for CF based shopping carts. You've found a great resource here in the mailing list. Check the Adobe developers centre at http://www.adobe.com/devnet/coldfusion/ for a load of tutorials, and of course the massive number of communtity sites and blogs out there. Hope that helps. w -Original Message- From: Tom Budd [mailto:[EMAIL PROTECTED] Sent: 26 April 2007 13:04 To: CF-Talk Subject: switching to coldfusion Hi I recently set up an HTML site using Dreamweaver 8 on a MAC which now needs to be converted into an ecommerce site. My background is in graphic design (therefore I'm still fairly new to Dreamweaver and HTML) and we've slightly ground to a halt and need some advice on which way to go next. Having trawled through various shopping cart software, we've decided that flexibility/customizability is key and therefore opted against a more template driven option (hosted cart solutions which all seem quite rigid). We've been looking at the software 'Cartweaver' (seems like one of the better ones) which gives 3 software options: ASP, Coldfusion or PHP. Having read a bit about them I'm leaning towards Coldfusion as they claim it is written specifically to ease the learning curve and development time of creating dynamic web applications and also because it is a tag-based language like HTML. Few QUESTIONS really: In the opinion of an experienced web developer/programmer, is Coldfusion the way to go with this project. Is it really as straight forward as the software guys claim it is or is there a chance I will be biting off more than I can chew (being of limited experience)? Can I keep the existing HTML pages as they are or do I need to re-create them in Coldfusion? My client is very keen to use drop down menus as an easy means of searching through the different product categories. Initially I was looking to create these using Fireworks (Javascript) which seemed relatively painless... Is this still an option if we opt to go with Coldfusion? Any advice hugely appreciated especially on software recommendations and decent learning resources. Thanks Tom ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOLVED: pre-select not selecting
I think it was just a firefox thing. Seems to be workin now. Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Why is this select not pre-selecting?
I have a form that generates this code. but in the browser, it doesn't pre-select 3. What am I not seeing here? 1 2 3 #rankCtr# selected="selected">#answername# Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CSS layered div problem
I can't quite get a div to position itself over another div. What I'm trying to
create is a content div that has a big image in it. Then placing a promo div
box right on top of it... the promo box will contain html text.
My problem is, one appears either above or below the other depending on where I
place it. I tried some floats, positions, nothing is working.
Here's my content css:
div#content {text-align:center; margin-top: 4px;}
div#content img{border: 1px solid #003366;}
div#content .promobox {
top: 100px;
border: solid 1px #00;
width: 200px;
height: 100px;
float: right;
}
And the html
This is some promo text
Thanks,
Will
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276042
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with CFCHART
> Hi there, i'm having trouble upgrading some code to > Dunno if this has anything to do with your problem, but on page 454 of the WACK book: "The only things you can pass are the actual label and value of the data point displayed on the graph." If you have some other unique identifier, like a unique identifier, it won't work. Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reversal?
One thing I did to make it LOOK better at least is turn them into horizontal bars instead of vertical. That makes the item that scored highest on top. As it loses ranking, it moves down the chart. Thanks, Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
reversal?
I have a ranking system in which items are scored, say 1-3. 1 being the highest ranking. I'm displaying these in a bar chart, but the item with the highest ranking is lowest on the chart, which is correct, but misleading at first glance. The chart naturally pushes the item with the highest value to the top. Is there a way to force the lowest ranked bar to the top. I tried to scale from 3 to 1 but it didn't work. Thanks, Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access Query Question
I just know someone that's a higher-up at the IRS. She told me they mostly use oracle, but thought they'd try an access db for a small application. She said if they had 6 users on the system, the data became corrupted. Acted all pissy about it and stuff. Of course, she also told me CF sucked. lol! Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form data not being inserted into mssql database
Could you: What the hell is goin on here?? redirect user letting them know there's a problem http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Access Query Question
>Access does not sucks. >Access works perfectly for many sites for what it has been made for, ie >small and medium databases. Not tryin' to argue here, but I've mostly heard bad stuff about it. Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Breakfast is ready honey... come'n'get it!
https://store1.adobe.com/cfusion/store/index.cfm?store=OLS-US&storeregion=us&nr=0 ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client-side validation or Server-side Validation?
>Which is exactly why I started this thread... to broaden my understanding of >the issues... I'm workin on an app right now where it's incredibly important to be bulletproof. I just turned off JS, then started writing my validation routines with CF. I'm validating checkboxes, selects, radio buttons, etc... Then when I was finished, I added my JS (cfform) to it. Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Counting number of records
>What query would I use to count the number of documents within each >category > Off the top of my head SELECT catno, COUNT(sub_cat) AS numDocs FROM tbldocuments GROUP BY catno ORDER BY catno Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ANYONE? Pretty please?? more SQL help....
Heck, I did up a special page just to explain my needs better. :) http://wtomlinson.com/eval.html been flailing away at this for quite a while now... Thanks, Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:27 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need more SQL help....
Ok, I have one last query to get right in my eval app. Here's my schema: http://wtomlinson.com/evalschema.gif Jim has been kind enough to help work out my queries. Now, I just need to rollup my rankings questions and I'm done (mostly). The data looks like this: tblquestions: Rank these tools in order of learning curve tblanswersets CF ..NET PHP tblanswers 1 2 3 Answer get inserted into an output table, tblevalanswerresults, where they can be counted. Here's what I need in plain english: Show me a list of questions. With each question, show me a list of the answers according to what they were ranked, listed highes ranked to lowest. Here's a query I'm workin with, the data isn't right tho. It just counts up the answers for each answerset. SELECT Q.questionID, Q.questionsetID, Q.question, Q.questioncatid, QAX.questionid, QAX.answersetid, ASets.answersetid, ASets.answersettypeid, ASets.answersetname, AST.answersettypename, ASAX.answersetid, ASAX.answerid, A.answerID, A.answername, A.answervalue, (SELECT count(*) FROM tblevalanswerresults e1 INNER JOIN tblevaluations e2 ON e1.evalid = e2.evalid WHERE e2.InstructorID = '#SESSION.CollegeID#' AND e1.answerID = A.answerID AND e1.questionid = Q.questionID) AS totalforthisquestion, (SELECT count(*) FROM tblevalanswerresults e1 INNER JOIN tblevaluations e2 ON e1.evalid = e2.evalid WHERE e2.InstructorID = '#SESSION.CollegeID#' AND e1.questionid = Q.questionID) AS totalforinstructor, ((SELECT count(*) FROM tblevalanswerresults e1 INNER JOIN tblevaluations e2 ON e1.evalid = e2.evalid WHERE e2.InstructorID = '#SESSION.CollegeID#' AND e1.answerID = A.answerID AND e1.questionid = Q.questionID)/ (SELECT count(*) FROM tblevalanswerresults e1 INNER JOIN tblevaluations e2 ON e1.evalid = e2.evalid WHERE e2.InstructorID = '#SESSION.CollegeID#' AND e1.questionid = Q.questionID)*100) AS answerpercentage FROM tblquestions Q INNER JOIN tblquestionsanswers_x QAX ON Q.questionID = QAX.questionID INNER JOIN tblanswersets ASets ON QAX.answersetid = ASets.answersetid INNER JOIN tblanswersettypes AST ON AST.answersettypeid = ASets.answersettypeid INNER JOIN tblanswersetsanswers_x ASAX ON QAX.answersetid = ASAX.answersetid INNER JOIN tblanswers A ON ASAX.answerid = A.answerid WHERE Q.questioncatid = 3 /* Additional Q = 3*/ AND ASets.answersettypeid = 3 /* Ranking answers only = 3*/ Thanks much, Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help totaling something up
>How'd i know this was gunna be u? > I got it figured out tho... ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS is gonna Vistafy Flash
I wonder if you'll be downloading security patches every day. :) http://www.themoneytimes.com/articles/20070416/microsoft_intends_to_outshine_adobe-id-103319.html ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help totaling something up
Ok, here's what's throwing me. My output expands dynamically horizontally AND vertically. I'm having a hard time tracking the totals for each column, since they're dynamic. Here's my entire . I worked on it a few hours, then got pissed and erased what I'd done. I need to track each column by using the Qctr var and prob an ansCtr var. bgcolor="##FF"bgcolor="##EE"> #Qctr# #question##question# #answervalue# #totalforthisquestion# #NumberFormat(answerpercentage, "__")#% Thanks, Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help totaling something up
> I don't see any nested loops in the code below. So the simple answer > here is to just declare some variables outside of the loop to manage I'm sorry, I should've posted the WHOLE output. The one I posted is JUST the inner . I'll try your example shortly.. .Thanks jake! Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help totaling something up
Hey, I have an inner that shows totals for each question answered. It looks like this: http://wtomlinson.com/outputcap.jpg I need it to count up the totals vertically for each question, then show them at the bottom, horizontally as shown. Except what you see in the screen cap are incorrect values. I've worked on this for quite a few hours and made a little progress. Heavy emphasis on little. :) Just can't seem to wrap my head around these loops. I'm thinking it needs to build an array, then loop over it at the bottom horizontally. Does anyone have suggestions? Here's my output code below, thanks! Will #answervalue# #totalforthisquestion# #NumberFormat(answerpercentage, "__")#% ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Tons of records - archive, or what?
> How many indexes do you have setup on the table? I had a table with > about 6 million records that I inherited and it only had an index It has all the pertinent fields included in indexes. I believe about 8-10 fields in the one main output table. All tables have all the indexes that are needed I believe. It just hit me this morning, I may be creating a bunch of data to query that'll never exist anyway. It's trying to count up 200,000 + records for one instructor. That'll never happen anyway! I think I need to load more real-world data into my tables and try it then. Maybe I'm asking something of it that nothing can handle, and we don't need that type of report anyway. make sense?? Thanks for your help! Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tons of records - archive, or what?
Just joined up thanks for the info dana! I did find some performance info thru googling. I can't even query 200,000 records without my db givin out. Weird! Thanks,Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Tons of records - archive, or what?
Hey, I have a mySQL db that has lotsa joins, lotsa filters, etc., and could potentially accumulate millions of records over a year or two. The db revolves around school semesters. I'm worried about performance issues as time goes on. But I need to keep these records searchable. I've come up with a few ideas but thought you folks might have better solutions. Mine are: 1. Create a parallel set of tables prefixed with archive. Move records there every so often. 2. Allow users to create new tables with semester suffixes. Then search off those with a variable placed at the end of the table. 3. Save all the rollups/queries themselves in the db somehow. Anyone have ideas on this one? Thanks, Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with grouped query and inner
Thanks Ali! I'm using mySQL. Adding a did the trick. Thanks, Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: grouping
Thanks to Jim Wright for the answer. I had completely blanked on being able to use a nested with an outer query output grouping. #answersetname# #answername# Thanks for the suggestions from everyone, including the disrupted one! Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help with grouped query and inner
>use distinct in there to only output one of each name > > I tried distinct, didn't work. Here's what my output looks like: http://wtomlinson.com/questionCap.jpg SELECT DISTINCT tblquestionsets.questionsetid, tblquestionsets.questionsetname, tblquestions.questionid, tblquestions.questionsetid, tblquestions.question, tblquestions.questioncatid, tblquestions.questionsortnum, tblquestions.questionrequired, tblquestioncats.questioncatid, tblquestioncats.questioncatname, tblquestionsanswers_x.questionanswersetid, tblquestionsanswers_x.answersetid, tblquestionsanswers_x.questionid, tblanswersets.answersetid, tblanswersets.answersetname, tblanswersets.answersettypeid, tblanswersets.answersetrequired, tblanswersettypes.answersettypeid, tblanswersettypes.answersettypename, tblanswersetsanswers_x.answersetsanswersid, tblanswersetsanswers_x.answersetid, tblanswersetsanswers_x.answerid, tblanswers.answerid, tblanswers.answername, tblanswers.answervalue, tblanswers.answersortnum, tblquestionsets.questionsetdateadded FROM tblquestionsets, tblquestions, tblanswersets, tblquestionsanswers_x, tblanswersettypes, tblanswers, tblanswersetsanswers_x, tblquestioncats WHERE tblquestionsets.questionsetID = tblquestions.questionsetID AND tblquestions.questionid = tblquestionsanswers_x.questionid AND tblquestionsanswers_x.answersetid = tblanswersets.answersetid AND tblanswersets.answersetid = tblanswersetsanswers_x.answersetid AND tblanswersetsanswers_x.answerid = tblanswers.answerid AND tblanswersets.answersettypeid = tblanswersettypes.answersettypeid AND tblquestions.questioncatid = tblquestioncats.questioncatid AND tblquestionsets.questionsetID = 1 AND tblquestions.questioncatid = 3 ORDER BY tblquestions.questionid, tblanswersets.answersetid, tblanswers.answerid #answersetname# #answername# ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with grouped query and inner
>I beleive your cfoutput group should match the sort order of the query. > I added the questionid to the front of the sort order. Still no luck. I did setup a valuelist so I could see what's coming straight out of the query. It produces this: Clinton,Clinton,Clinton,Clinton,Clinton,Bush,Bush,Bush,Bush,Bush,Reagan,Reagan,Reagan,Reagan,Reagan Computers,Projectors,Chalkboard,1,2,3,4,5,1,2,3,4,5,1,2,3,4,5 How am I getting a cartesian join?? I've double checked my join clauses. I need Clinton 1,2,3,4,5 Bush 1,2,3,4,5 Thanks, Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help with grouped query and inner
I usually don't have problems with grouping and outputting data, but this one's got my number so far... With my db schema, a question can be related to more than one answer set. An answer set can be related to more than one question. An answer set can be related to more than one answer. An answer can be related to more than one answer set. All my questions work except the rankings. I'm trying to do this. Question: Rank your favorite colors. Answer set: Blue Answers: 1,2,3,4 Answer set: Green Answers: 1,2,3,4 etc.. etc.. Here's my query: SELECT tblquestionsets.questionsetid, tblquestionsets.questionsetname, tblquestions.questionid, tblquestions.questionsetid, tblquestions.question, tblquestions.questioncatid, tblquestions.questionsortnum, tblquestions.questionrequired, tblquestioncats.questioncatid, tblquestioncats.questioncatname, tblquestionsanswers_x.questionanswersetid, tblquestionsanswers_x.answersetid, tblquestionsanswers_x.questionid, tblanswersets.answersetid, tblanswersets.answersetname, tblanswersets.answersettypeid, tblanswersets.answersetrequired, tblanswersettypes.answersettypeid, tblanswersettypes.answersettypename, tblanswersetsanswers_x.answersetsanswersid, tblanswersetsanswers_x.answersetid, tblanswersetsanswers_x.answerid, tblanswers.answerid, tblanswers.answername, tblanswers.answervalue, tblanswers.answersortnum, tblquestionsets.questionsetdateadded FROM tblquestionsets, tblquestions, tblanswersets, tblquestionsanswers_x, tblanswersettypes, tblanswers, tblanswersetsanswers_x, tblquestioncats WHERE tblquestionsets.questionsetID = tblquestions.questionsetID AND tblquestions.questionid = tblquestionsanswers_x.questionid AND tblquestionsanswers_x.answersetid = tblanswersets.answersetid AND tblanswersets.answersetid = tblanswersetsanswers_x.answersetid AND tblanswersetsanswers_x.answerid = tblanswers.answerid AND tblanswersets.answersettypeid = tblanswersettypes.answersettypeid AND tblquestions.questioncatid = tblquestioncats.questioncatid AND tblquestionsets.questionsetID = 1 AND tblquestions.questioncatid = 3 ORDER BY tblanswersets.answersetid, tblanswers.answerid Here's my output: #answersetname# #answername# But here's what it outputs: http://wtomlinson.com/questionCap.jpg I need it to show just one answer set, but with the multiple answers in the dropdown. I've tried playing with all sorts of combinations, with no luck. Any ideas? Thanks, Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
7.01 updater and vista?
I have CF running on my new vista machine. Just dloaded and trying to install updater 7.01 so I can install 7.02, and the installer appears to hang up and go no nowhere. Anyone else with Vista and these issues? BTW, I don't know what all the hoopla was surrounding vista. It seems to operate just like XP pro. I get the same "program not responding/send error report?" messages as I got with XP pro. lol! Thanks, Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hostmysite down...
>no more problems with other people's rubbish code. > James, don't talk about dave's code like that! :) ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hostmysite down...
When I email tech support, they just look at my site and say, "it's working > now". No kidding! That doesn't mean it's not still having problems > intermittently. It's frustrating because they used to be such a > reliable host, but I've been hearing similar complaints from a lot of > my customers as well. > I get the same exact thing at CT. They pretend things are ok and don't understand what your problem is. The other day I contacted support about missing JS files causing my cfform validation to fail. They email me back, "I checked and the files are on your server". I go back and check, and it's working all of a sudden. lol! Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274691 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 thing on?
>Not seeing any list traffic..so I thought I'd make my own ;-) You guys start goin into convultions when there's no list traffic dont'cha! :) Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Server side validation for checkboxes
I have a form with dynamic checkboxes and radio buttons. They output from my db tables that have tblanswersets (one) and tblanswers (many) I'm grouping some questions, then spitting out these items. It mostly works, except the checkboxes. Right now, my server side validation makes sure ANY group of checkboxes or radio buttons have at least one selection. When the form submits to itself, the values are saved and form items are pre-checked/selected if something's caught in the validation. But my checkboxes get caught if there isn't a selection. I've decided to add a field to tblanswersets - answersetrequired = yes/no I can output that somehow in my form inputs to setup some new validation routine. Thought you guys might have a good way to do this. I'll show you what I'm using now, maybe gimme some pointers/ideas on how to improve this? Thanks, Will SELECT tblquestionsets.questionsetid, tblquestionsets.questionsetname, tblquestions.questionid, tblquestions.answersetid, tblquestions.questionsetid, tblquestions.question, tblquestions.questioncatid, tblquestions.questionsortnum, tblquestioncats.questioncatid, tblquestioncats.questioncatname, tblanswersets.answersetid, tblanswersets.answersetname, tblanswersets.answersettypeid, tblanswersets.answersetrequired, tblanswersettypes.answersettypeid, tblanswersettypes.answersettypename, tblanswers.answerid, tblanswers.answername, tblanswers.answervalue, tblanswers.answersortnum, tblanswers.answersetid, tblquestionsets.questionsetdateadded FROM tblquestionsets, tblquestions, tblanswersets, tblanswersettypes, tblanswers, tblquestioncats WHERE tblquestionsets.questionsetID = tblquestions.questionsetID AND tblquestions.answersetID = tblAnswersets.answersetid AND tblanswersets.answersetid = tblanswers.answersetID AND tblquestionsets.questionsetID = 1 AND tblquestions.questioncatid = 1 AND tblanswersets.answersettypeid = tblanswersettypes.answersettypeid AND tblquestions.questioncatid = tblquestioncats.questioncatid ORDER BY tblquestions.questionsortnum, tblanswers.answersortnum #ctr# #question# #answervalue# Additional Questions Then I param the formfields: Here's where I setup an errorstruct If my code contains items in the error struct, I show a warning: ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274352 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Just checking
>And, yes, I'm back on cf-talk as part of my "being more active in the >community post-Adobe" promise... WOOOoo! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Extending Application.cfc
Right, sean's the one that told me to do it like that. Good advice, seems to work perfectly. Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Site Check please: www.CodeFetcher.com
> Personally, I don't like sites that shove the main content over to the > left, I prefer it in the middle, just a usability quirk I have. umm... dude we all know you prefer it in the middle. How bout keepin your sex life off the list tho, k? Will ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Extending Application.cfc
One thing I do is use a proxyApplication.cfc in the root that extends the root application.cfc. Then in the subfolder app.cfc's, extend them to testfolder.user.username.yourapp.proxyApplication Or could you create a mapping to it? Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Which version of vista plays well with CF7?
> XP. > Or, better, RedHat :-) How much ya wanna bet I end up just installin' xp pro on the dam* thing before it's over with! :) Thanks, Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Which version of vista plays well with CF7?
>Vista Business is running well with it. The installation is a pain, since >the installer doesn't play well with Vista. But I did get it running. After reading that, my thoughts are yucko!! I'm buying a new dell desktop and trying to figure out which version to get. Thanks for the great info sandy. Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Which version of vista plays well with CF7?
THat's my question.. Thanks, Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFHTTP and SSL woes
Ah, good point. I'm not sure to be honest - it's a client's server so they may well have done. I will investigate. Thanks Will -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: 27 March 2007 19:19 To: CF-Talk Subject: Re: CFHTTP and SSL woes Have you upgraded the jvm? If so, could you be importing the cert into the wrong keystore? You will need to import it into the keystore under the new JVM installation directory. If you follow any of the cert import instructions on the net, they will probably lead you to install the cert into the old keystore (CFusionMX/runtime/jre/lib/security/cacerts). -Ryan http://www.stillnetstudios.com Will Swain wrote: > Yup - this old chestnut. > > Server running cfmx6.1 trying to use CFHTTP to a url using SSL v3. > This worked until recently when they upgraded their cert from v2 to > v3, and now I'm getting the infamous Connection Failure error. > > I've tried applying the fixes such as importing the cert into cfmx's > cacerts etc., all to no avail. > > My question is this - I can run this code fine on my local test > server, running cfmx 7.0.2. I get communication with the remote url > via CFHTTP no problem. Is this something that was fixed somewhere in > between CFMX 7 (I've seen some people having this issue still with 7) > and CFMX 7.0.2? I don't want to recommend that the client upgrades > from cfmx 6.1 to 7.0.2 unless I'm pretty sure it will work. > > Thanks all. > > Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Validation Question
I have used ColdFusion to do >batch processing of large text files in the past, and it is NOT >efficient, in fact I would say that it is very inefficient at this >task. I am not saying that CF is inefficient overall, just with large >text files. I have bugged Macromedia about it before, we'll see if >Adobe addresses this issue in future releases. I remember Barney saying a while back, ColdFusion wasn't built to be fast, it was built to be just fast enough. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFHTTP and SSL woes
Yup - this old chestnut. Server running cfmx6.1 trying to use CFHTTP to a url using SSL v3. This worked until recently when they upgraded their cert from v2 to v3, and now I'm getting the infamous Connection Failure error. I've tried applying the fixes such as importing the cert into cfmx's cacerts etc., all to no avail. My question is this - I can run this code fine on my local test server, running cfmx 7.0.2. I get communication with the remote url via CFHTTP no problem. Is this something that was fixed somewhere in between CFMX 7 (I've seen some people having this issue still with 7) and CFMX 7.0.2? I don't want to recommend that the client upgrades from cfmx 6.1 to 7.0.2 unless I'm pretty sure it will work. Thanks all. Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Introduction, Cheap Hosting
Peter, Try www.hostmysite.com - very cf-oriented And www.crystaltech.com - kinda cf-oriented. A lot of the members of this list use one of the two. There are also a few folks on this list that offer hosting themselves. I'm sure they'll chime in. HTH, Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: xml cfform validation problem
People can crack on me all they want, I love xforms. They're too easy to use. Never had any validation problems out of em myself. Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need More SQL help - DRIVING ME NUTS!
Ok Jim, this is getting the results I'm after. The counts are correct, everything looks right so far. I just needta test it some more. Would you please email me offlist? WT at WTOMLINSON.com Thanks a ton dude! Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need More SQL help - DRIVING ME NUTS!
Thanks a ton Jim! I'll give it a shot later today and let you know the results. Thanks! Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need More SQL help - DRIVING ME NUTS!
>No been following this thread, but can you do the first two parts? Yes, I've got this part working with Jochem's fine SQL. > >What about the third part? > >"With each possible answer, show me a count of the ones that were selected" Nope > >Do those then try to combine them. > >Adrian This is where the problem is. I haven't figured out how to combine them, group them, whatever needs to be done, I haven't gotten it right yet. I can't quit on this until it works. Here's the data retrieval as it stands now: http://wtomlinson.com/evalQRYs/qryDatabig.gif Here's the data in my many table: http://wtomlinson.com/evalQRYs/tableData.gif This shouldn't be hard!! Thanks adrian, Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need More SQL help - DRIVING ME NUTS!
Put every field from the select that is not an aggregate in your >group by and you get something understandable. > >Jochem Jochem, I did this and it still gives me incorrect results. It gives me a count of 1 for each answer, no matter what the answer is. I'm just testing with one evaluation record to keep it simple. I should still get 0 records returned for some of these answers. I don't know why I can't simply run a query that says this: "Show me a list of all the questions. With each question, I need all possible answers. With each possible answer, show me a count of the ones that were selected" I should be able to get this with a query, but I'm not. I'm missing something. ARG!! Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need More SQL help - DRIVING ME NUTS!
And what I can't figure out is why this: COUNT(EAR.answerID) AS numAnswers would produce values of 1 for rows in which it should be 0. Thanks, Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need More SQL help - DRIVING ME NUTS!
MySQL 5 Here's some table date as it looks in tblEvalAnswerResults. This is a many table. http://wtomlinson.com/evalQRYs/tableData.gif Then here's what my query produces. I had to add E.evalID to get both evaluations to show up in the results. I went ahead and did another evaluation, so there are two tblEvaluations records, 3 questions each, which produced 6 records in the tblEvalAnswerResults many table. http://wtomlinson.com/evalQRYs/qryDatabig.gif How I should fix this query to give me what I need, I have no idea. I simply want to display each question, along with its possible answers, and a count of the answers that were chosen. All in the same query output in rows, like me link from the first post. Thanks, hope this makes sense. Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need More SQL help - DRIVING ME NUTS!
Ok, I'm really close on this. I've been workin on it for hours, changing queries, not gettin the results I need. I filled out one survey of 3 questions, each question has 5 possible answers. Here's the query: SELECT Q.questionID, Q.questionsetID, Q.question, Q.answersetid, ARS.answersetid, ARS.answersetname, A.answerID, A.answersetID, A.answername, A.answersortnum, A.answervalue, EAR.evalID, EAR.answerID, E.evalID, E.InstructorID, COUNT(EAR.answerID) AS numAnswers FROM tblquestions Q INNER JOIN tblanswersets ARS USING (answerSetID) INNER JOIN tblanswers A USING (answerSetID) LEFT JOIN tblevalanswerresults EAR USING (questionID) INNER JOIN tblEvaluations E ON E.evalID = EAR.evalID WHERE E.InstructorID = '#SESSION.CollegeID#' GROUP BY Q.questionID, A.answerID HEre's the results, with my http://wtomlinson.com/evalQRYs/qryData2.gif It should return 0 for 4 answers out of 5, since I can only answer one of five possible answers. But it's counting 1 for each answer - not right. I think I can tell what's happening, but don't know how to fix it. It's like it's grouping off the tblAnswers table, but should be calculating rows from the tblEvalAnswerResults table. And here's my DB schema if it helps: http://wtomlinson.com/evalDBSchema.jpg Thanks!! Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some SQL help!
Ok, I ALMOST got it! The results that are incorrect is just the number of answers per question. Here's what the query returns: http://wtomlinson.com/evalQRYs/qryData.jpg Look at numAnswers. I completed two evaluations. But numAnswers should be the total count of each answer that was given. I obviously didn't answer twice for every answer as shown in the query results. I need it to count up the number of answers that were chosen, for each answer, for each question. Here's my query as it stands now: ALMOST! SELECT Q.questionID, Q.questionsetID, Q.question, Q.answersetid, ARS.answersetid, ARS.answersetname, A.answerID, A.answersetID, A.answername, A.answersortnum, A.answervalue, EAR.evalID, EAR.answerID, E.evalID, E.InstructorID, COUNT(EAR.answerID) AS numAnswers FROM tblquestions Q INNER JOIN tblanswersets ARS USING (answerSetID) INNER JOIN tblanswers A USING (answerSetID) LEFT JOIN tblevalanswerresults EAR USING (questionID) INNER JOIN tblEvaluations E ON E.evalID = EAR.evalID WHERE E.InstructorID = '1021338' GROUP BY Q.questionID, A.answerID Thanks, Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some SQL help!
I may have figured it out... I used this for my group by. GROUP BY Q.questionID, A.answerID Still needta test it more tho but my results are lookin better. Thanks Jochem! Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some SQL help!
Jochem, this is close but not quite giving me the results I'm after. Here's the data as it looks in the table. I answered three questions, each had a choice of 5 answers. I chose 1 answer for each question. Here's the data as it appears in the tblEvalAnswerResults many table. http://wtomlinson.com/evalQRYs/tableData.jpg Here's the qry: SELECT Q.questionID, Q.questionsetID, Q.question, Q.answersetid, ARS.answersetid, ARS.answersetname, A.answersetID, A.answername, A.answersortnum, A.answervalue, EAR.evalID, EAR.answerID, A.answerID, COUNT(EAR.answerID) FROM tblquestions Q INNER JOIN tblanswersets ARS USING (answerSetID) INNER JOIN tblanswers A USING (answerSetID) LEFT JOIN tblevalanswerresults EAR USING (answerID) GROUP BY A.answerID Here's the data the query returns: http://wtomlinson.com/evalQRYs/qryData.jpg Notice how it's indeed returning 5 rows - 1 per answer choice. But It's also just returning 1 question. There were 3 questions answered. I've played with it some and will keep trying. Any ideas? Thanks much, Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some SQL help!
>Will Tomlinson wrote: >> >> Do all these individual queries go into one query, separated with a ; ? > >Just run the last one, the others are to show how you build it step by step. > duhh.. :) Thanks Jochem! Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some SQL help!
Jochem, Do all these individual queries go into one query, separated with a ; ? Thanks, Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some SQL help!
>> Does this make sense? > >If you join this to some table with instructors you should get what you >need. > >Jochem Yes Jochem. I'm remote right now, but I'll give this a shot later today and let'cha know how it turns out. Thanks a ton dude! Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some SQL help!
Ok, I wrote down in plain english what I need. Show me a list of questions, all possible evaluation answers for each question, and a total of each answer chosen. Does this make sense? Thanks, Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need some SQL help!
MySQL 5. I'm building a dynamic question survey form. Here's my db schema: http://wtomlinson.com/evalDBSchema.jpg I need to pull data for a specific instructor. How do I get a count for each answer? I need to display each question like this: http://wtomlinson.com/evaldisplay.jpg I'm workin on the query and having a hard time figuring out howta write it. This returns 3 records. I filled out a 3 question survey to get that. Now, I need to total up answers. Here's what I've got so far. Could someone point me in the right direction? SELECT tblevaluations.EvalID, tblevaluations.Course, tblevaluations.GtccDeptID, tblevaluations.InstructorID, tblevaluations.Program, tblevaluations.Section, tblevaluations.SectionID, tblevaluations.DivCode, tblevalanswerresults.evalID, tblevaluations.DeptPrograms, tblevalanswerresults.answerID, tblevalanswerresults.evalanswerID, tblevalanswerresults.questionID, tblevalanswerresults.questionsetID, tblquestions.answersetID, tblquestions.question, tblquestions.questionID, tblquestions.questionsetID, tblquestions.questionsortnum, tblanswersets.answersetid, tblanswersets.answersetname, SUM(tblanswers.answerID) AS numAnswers, tblanswers.answersetID, tblanswers.answername, tblanswers.answersortnum, tblanswers.answervalue, tblquestionsets.questionsetID, tblInstructor.instructorLastName, tblInstructor.instructorFirstName, tblInstructor.InstructorID FROM tblEvaluations, tblevalanswerresults, tblquestions, tblanswersets, tblInstructor, tblanswers , tblquestionsets WHERE tblevaluations.EvalID = tblevalanswerresults.evalID AND tblevalanswerresults.answerID = tblanswers.answerID AND tblevalanswerresults.questionID = tblquestions.questionID AND tblevalanswerresults.questionsetID = tblquestionsets.questionsetID AND tblanswers.answersetID = tblanswersets.answersetid AND tblquestions.questionID = tblevalanswerresults.questionID AND tblevaluations.InstructorID = '0103419' GROUP BY tblquestionsets.questionsetID, tblquestions.questionID, tblanswersets.answersetid, tblanswers.answerID Thanks, Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Virus protection
>Hah, they fooled Will. > Stuff it Rick! :) Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Virtual "pages", without extensions. How to do it?
One area it'd help with SEO, is if you're able to sneak a product name or other keyword into that url. Either a directory name or filename. Google definitely picks up on those. Dunno if that's relevant to the discussion here, but it helps. Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Virus protection
>I use Avast Home Edition. Free > >http://www.avast.com Thanks sandy! And just so y'all know, I typed OT: before the subject of this thread, and it was taken out. oh well! Thangya, Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Virus protection
>I just upgraded from 7.1 to 7.5 free version yesterday. It says I'm up to >date now. They tried to funnel you towards the 7.5 pay version, but there >was a link below for the new free version. Thanks Greg! I didn't see that link. "Don't make me think!" :) Thanks, Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Virus protection
Since AVG isn't free anymore, what do you guys use for virus protection? And don't say Vista! lol!! :) Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam vs val( )
>You are safe using val for number fields. Nothing would crash it. Val >evaluates to 0 if what you pass in cannot be recognized as a number. > Just to let you know, Ray Camden crashed my val() with a SUPER long string in my URL. lol! Was like a daisy cutter dropped on it. :) Will ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How to server side validate these radio buttons
I have a form with dynamically created radio buttons. They look like this in the source: 1 You'd like a place to smoke on campus SA A N D SD I'm looping over the fieldnames,inserting the values into the db, workin just fine. What's the best way to server side validate to make sure at least ONE radio button per set was selected? Here's my loop insert in case that helps ( don't pay attention to the no s, just testing this out: INSERT INTO tblevalanswerresults (answerID, questionID, questionsetID) VALUES (#ListLast(FORM[thisField], "_")#, #ListFirst(FORM[thisField], "_")#, #FORM.questionset#) Thanks, Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access SQL > MySQL SQL code
>I don't think it likes the double quotes around Section - Yep that was it. Thanks josh! Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Access SQL > MySQL SQL code
I'm converting an access db over to MySQL, and getting an error: Here's the code: SELECT tblStudentCourses.SectionID, tblStudentCourses.StudentID, tblStudentCourses.Program, tblStudentCourses.Title, tblStudentCourses."Section", tblStudentCourses.Submit FROM tblStudentCourses WHERE tblStudentCourses.StudentID = '#SESSION.CollegeID#' AND (tblStudentCourses.Submit = '' OR tblStudentCourses.Submit Is Null) Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver][mysqld-5.0.24-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"Section", tblStudentCourses.Submit FROM tblStudentCourses WHERE tblStudentCours' at line 1 The error occurred in C:\CFusionMX7\wwwroot\Eval\evalForm\studentCourses.cfm: line 6 Called from C:\CFusionMX7\wwwroot\Eval\Application.cfc: line 33 Called from C:\CFusionMX7\wwwroot\Eval\evalForm\studentCourses.cfm: line 6 Called from C:\CFusionMX7\wwwroot\Eval\Application.cfc: line 33 4 : 5 : SELECT tblStudentCourses.SectionID, tblStudentCourses.StudentID, tblStudentCourses.Program, tblStudentCourses.Title, tblStudentCourses."Section", tblStudentCourses.Submit FROM tblStudentCourses 6 : WHERE tblStudentCourses.StudentID = '#SESSION.CollegeID#' 7 : AND (tblStudentCourses.Submit = '' OR tblStudentCourses.Submit = Null) 8 : I've played round with it some with no luck. Any ideas? Thanks much! Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Exam apps out there?
Does anyone know of any good exam applications out there? Testing apps? Something with question/answer admin and such. Thanks, Will ~| 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:272507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: List of Countries
I exported one I've been using in my store app. Maybe you can use it. Has alotta countries. wtomlinson.com/countries.sql Will ~| 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:272472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Obscenity/Bad Words filter udf/cfc?
> Before I create something on my own, I was wondering if anyone already > has an available obscenity or bad-words filter, either as a udf or a > cfc. Something that can evaluate any textfield and replace or remove > any bad words. Thank you in advance!! I built one a while back, will try to dig it out. I remember it crashed CF if you put in too much text. lol! I think dave was the one that blew it up. Will ~| 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:272265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFire
That's v nice Ray. Would certainly be interested in using it. Thanks Will -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 09 March 2007 16:58 To: CF-Talk Subject: Ann: ColdFire Just in case some folks don't read my blog (I always feel egotistical when I assume folks do ;) I thought I'd point out a new resource for CF developers, ColdFire. This is being developed by myself and Adam Podolnick. Info may be found here: http://ray.camdenfamily.com/index.cfm/2007/3/9/Announcing-ColdFire The first release should be soon. -- === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| 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:272181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: - Please stop breaking my validation
AMEN! ~| 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:272077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
- Please stop breaking my validation
I hate to gripe again, I really do, but it seems that once I get hooked on another CF feature like xForms, somethin rears its ugly head. CF sticks this right above the form: validator.w3.org LOVES this. It gives me a pretty red FAILED flag. Error Line 113 column 92: document type does not allow element "link" here. So to the CF team, please check these things when developing future versions. Stop CF from generating invalid code. With that rant said, how can I get around it without ditching my fun xForms?? Thanks, Will ~| 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:272024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista - too many files open error message- Dave watts?
Dave, She says, "YOU DA MAN". Your solution worked perfectly. :) Thanks much dude, Will ~| 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:272019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Which function converts special chars to html
>Or simply htmlEditFormat() THAT's the one I was lookin for! Thanks doug! Will ~| 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:271953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Which function converts special chars to html
I'm drawin a blank here, there are so many functions we have. My users enter their own product titles, and some contain & and other special characters. Which function would I use to automatically convert any of those to it's html equivalent? Do I have to manually do a replace() on all of them? Thanks, Will ~| 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:271949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Vista - too many files open error message- Dave watts?
Dave, She says this: the first time i attempted to edit the file, vista yelled at me and said the file was read only and would not let me save it. more than one way to skin a catmade a new file, saved it as config1.nt, deleted config.nt after some trouble-it finally let me delete (i think i had to move it to a different directory then delete it). then moved the other one over and renamed. BIG pain. still yells at me "TOO MANY FILES OPEN" was wondering if vista looked at a different file in addition to the config.nt or config.sys ~| 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:271912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista - too many files open error message- Dave watts?
Thanks Dave. I'm gonna get some more info from her. Will ~| 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:271908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Nesting CFCs?
Here's some info from joe. There's lotsa stuff out there. http://www.firemoss.com/blog/index.cfm?mode=entry&entry=039C3509-E081-2BAC-6912DEE1EDC1C588 Found it on ray's site: http://ray.camdenfamily.com/cfcresources.cfm hth, Will ~| 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:271898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Vista - too many files open error message- Dave watts?
>She needs more RAM if she wants to access that many files at once... >especially since Vista lays an egg if it *assumes* something *might* be >*potentially* wrong. > She says she's got 2gb ram and that shouldn't be an issue. I don't know enough to know. Just trying to get pointed in the right direction. Thanks much Kevin, Will ~| 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:271879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Vista - too many files open error message- Dave watts?
My friend is having a problem with Vista giving her this error message: "Too many files open" She said she used to edit the config.nt file to say files=100 to fix it. But that's not working here. She has between 40-100 files open in FoxPro 2.6. Anyone have any ideas/suggestions? Thanks much, Will ~| 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:271870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: udf var
> You're mixing up the global Form scope, with your Arguments.Form > struct, and the idea of var scoping function-local variables. Thanks! This is sweet! Will ~| 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:271865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't my SQL right on this
>Each "OR" is like a select statement unto itself. > It's SQL server... That worked! Thanks! Will ~| 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:271827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can't my SQL right on this
>Without looking at the page you may try > >AND ( tblMusicProducts.musicprodname LIKE '%#FORM.criteria#%' OR >tblMusicProducts.musicproddescription LIKE '%#FORM.criteria#%' ) > >That way it validates the OR statement as a single entity. That worked perfectly! Thanks! Will ~| 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:271825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can't my SQL right on this
I have a search form that's looking for text in a title or description. But there's also a select menu to filter by a product type. My problem is, I can't get that product type filter workin in the query, unless you don't enter any search criteria. Go here: http://208.106.220.143/index.cfm Enter "test" in the text input. I'm dumping everything so you can see what it's doing. It's still showing all the product types even tho I have this in the query: WHERE tblMusicProdTypes_X.musicprodtypeID = #FORM.prodType# Here's the whole query. Don't worry about the cfqueryparams, I'm just trying to get this to work first. SELECT tblMusicProducts.musicprodID, tblMusicProducts.musicprodname, tblMusicProducts.musicprodprice, tblMusicProducts.musicproddescription, tblMusicProducts.musicprodimagethumb, tblMusicProdTypes_X.musicprodID, tblMusicProdTypes_X.musicprodtypeID, tblMusicProdTypes.musicprodtypeID, tblMusicProdTypes.musicprodtypename FROM tblMusicProducts, tblMusicProdTypes_X, tblMusicProdTypes WHERE tblMusicProdTypes_X.musicprodtypeID = #FORM.prodType# AND tblMusicProducts.musicprodname LIKE '%#FORM.criteria#%' OR tblMusicProducts.musicproddescription LIKE '%#FORM.criteria#%' AND tblMusicProducts.musicprodID = tblMusicProdTypes_X.musicprodID AND tblMusicProdTypes.musicprodtypeID = tblMusicProdTypes_X.musicprodtypeID ORDER BY #order# Thanks, Will ~| 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:271821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
udf var
I haven't built a simple udf in forever, but decided to do one for my trimming of formfields. I tried sticking a right above the loop, but I get an error: Cannot declare local variable FORM twice. Am I not supposed to var this one? Thanks, Will ~| 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:271812 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Error with a form - enctype problem - test page up
IE 6, I didn't seem to have a problem. Just default IE settings... Will ~| 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:271810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Neat trick for cleaning formfields
I noticed I forgot to put my trim()'s in my form inputs for an admin area, and dreaded coding them all in. Cause there's lotsa forms. So I did this up and it seems to work well: #FORM[thisfield]# #FORM[thisfield]# I can run that right before my inserts, and bingo, done! I guess you could turn it into a cfc, send in the form, send it back out cleaned, maybe do more types of cleaning than just trim(). Anyway, thought I'd share. It seems quite a bit easier than coding in the trim()s. I've tried to think of some gotchas and none come to mind. Will ~| 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:271695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
A neat valueList() trick....
I like using valuelist(), but it messes up the display because it crunches the list items together, no spaces after the comma. So I tried this and it worked. Had no idea... Just thought I'd post it in case anyone else ran into the same problem. Will ~| 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:271671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: can't order by?
10 - 4! Thanks, Will ~| 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:271452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: can't order by?
Also, here's my form select if that helps. selected>Title selected>Newly listed selected>Price - lowest first selected>Price - highest first ~| 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:271448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
can't order by?
I'm letting users filter by specific columns, including ORDER BY... So I naturally 'd it and got this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name. SELECT tblMusicProducts.musicprodID, tblMusicProducts.musicprodname, tblMusicProducts.musicprodprice, tblMusicProducts.musicprodimagethumb, tblMusicProdTypes_X.musicprodID, tblMusicProdTypes_X.musicprodtypeID, tblMusicProdTypes.musicprodtypeID, tblMusicProdTypes.musicprodtypename FROM tblMusicProducts, tblMusicProdTypes_X, tblMusicProdTypes WHERE tblMusicProdTypes.musicprodtypeID = AND tblMusicProducts.musicprodID = tblMusicProdTypes_X.musicprodID AND tblMusicProdTypes.musicprodtypeID = tblMusicProdTypes_X.musicprodtypeID ORDER BY If I remove the cfqueryparam, it works fine. I guess it's doing this because I'm including ASC and DESC in the variable. I'm creating a statement IN a variable basically. What's the best practice for doing this. I'm obviously goin about it the wrong way. Thanks, Will ~| 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:271446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: advice...
Sweet! Preeesh Ray... Will ~| 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:271395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: advice...
>CFCs for display/Layout? Tut tut... :-) Hey, I was given a prescription to do it, from the doctor of OO. :) ~| 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:271394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
advice...
I'm writin a site old school using custom tags, and wanted to if there's a best way to invoke the tag. I hardly ever use them... This is just handling page layout. I'll have a footer, left menu, etc. I usually use CFC's for all this, but decided to write this site different. Thanks, Will ~| 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:271379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
