Re: 2 Selected Boxes not posting with rest of form?
Just a guess, but something to check: The second one has no options in it. The first one may or may not have options in it, depending on the query. I wouldn't be suprised if a select box with no options wouldn't post. ~| 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:221828 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
User's Browser: gibberish
I have gotten a couple error reports today which identified the user's browser as very odd strings. Any ideas on either what this means or what's going wrong? User's Browser: ÆÆ User's Browser: h jâ¹X¾⹠User's Browser: eâ¹ Ââ° User's Browser: t Some of these are pasting here even differently than they look in my Outlook (specifically, squares are being removed) It's the same error template we've used as long as I've been here, and it always has identifed the browser correctly before. ~| 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:215266 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: variables... to prefix or not to prefix
I generally do this when I'm working with arrays of structures and crap, like: arrMonth[31] = structDay; Way back in college, (6 months ago), we used to do it for everything - but it mattered a lot more when we were using very strictly typed languages. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187410 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: List Contains
articleID - articleRelations 1 3,14,33 2 3,4,12 3 11,1,2 4 7,8,5 5 7,8 The problem with this, is 1) that you're still storing a list, and 2) you will have either redundant or inconsistent information. Meaning, article 1 says it is related to 3, and 3 says it is related to 1. Depending on your business rules, this could be redundant. Also, when you delete article 3, you'll need to go through every list and remove all 3's from all the lists. OR... would there be a separate row for every relation. So if my articleID was 4, it would search all records below and pull out relationsIDs 1,2 and 5 and display all the articleRelations accept for the number 4's? RelationID - articleRelations 1 2,4 2 3,4 3 11,2 4 7,5 5 7,4 This is more on the right track. Though rather than 2,4 being a comma-separated-pair, it should be two seperate fields. Now when you delete article 3, you can easily do a query that deletes all the relations relating article 3 to another article. This approach is also much more scalable. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184396 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
Survey Creation Application
We're looking to make our own application that lets people create surveys - similar to Zoomerang (ww.zoomerang.com). We've played around with possible DB schemas and it just seems to get more and more complicated. I was wondering if any of you have tried implementing such an application, or if you would otherwise have any insight into the matter. It would need to let people do stuff like: - Add, edit, delete, move questions - Allow lots of different types of questions (ex: multiple choice, open ended, rating) - Arrange the questions across pages - Distribute the survey via links in emails, and track which response came from which email address - Generate reports based on the data collected We currently use Zoomerang - and think it works pretty well. We are looking for an alternative in-house solution so that we can put surveys into existing webpage templates. Thanks. ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182537 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: JavaScript Enabled Stats
This idea rules -thanks!I had never thought of this, but played with a bit and could find myself using it a decent amount. You could use JS to load an image that's really a CFM page -- new Image().src = "" . You would embed code to add the record (set to notEnabled) in your page, and add code to the stats.cfm file that would toggle it to enabled. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
JavaScript Enabled Stats
I want to find out about how many of our users have _javascript_ enabled.I think it'll be like 99%, but would like to know if it is, in fact, something like 75%. I can make a simple database that stores 2 values (Enabled, notEnabled) to update with each session, but I'm not sure how to exactly check. The plan would be just a simple addition to a site's Application.cfm.I want to set a var on the page, JSEnabled = false;then use _javascript_ to set the var to true onLoad.(which will obviously only happen if they have JS enabled) The problem then, is how do I get this information back, as the page is not just a form.They could click on any number of links which I don't want to change.Has anyone tried taking stats like this before?Otherwise, is it available in some other way?(For example, a cgi.client_javascript??) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Flash Versioning Middle Page
There is a subsection of an application which requires the newest Flash components.To check for the components I made a blank Flash movie and used its built in version tester which redirects to either the graphing section, or to a page that says: You need new components. Click here. And it all works fine, except the back button. If you are in the subsection and hit 'back', it will take you to the versioning page and send you back to the subsection again. Same is true for the page that says Upgrade Flash components -if they click back, it will version them again, and send them immediately back to the page that says upgrade. Do you know of any way to keep this from happening?Something like using some session variables, or is it possible to manually alter the browser history using _javascript_ or anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: A Quick Question - Javascript
Hello everyone, Using _javascript_, I want to display numbers from 1 to 5 such that numbers are ordered randomly on each page refresh and none of the number is repeated. e.g first refresh 1,3,4,2,5 second refesh 2,3,5,1,2 etc etc Any help is appreciated. Thanks How about something like this? script language=_javascript_ function writeNumbers() { var usedList = ; var myList = ; while (usedList.length 5) { var tempInt = Math.round(Math.random()*4) + 1; if (usedList.indexOf(tempInt) == -1) { usedList = usedList + tempInt; myList = myList + tempInt + ,; } } document.write(myList); } /script You can make some changes as to put your commas in, etc. - Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Best Practice - Forms
You could also generate the ID for the record on the page where they enter data, and pass it to the page that processes it.This way, you can first see if the record exists (yes = update, no = create).You may end up with IDs that get selected and not used, but such is life. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Small query question..
cfquery name=charting datasource=#dsn# SELECT * FROM #tablename# WHERE #url.date# ORDER by date LIMIT 31 /cfquery I don't use MySQL so maybe this is not the case, but don't you need to say something like: WHERE myDateColumn = #url.date#, rather than just WHERE #url.date# ? Or does MySQL have some built-in thing where that's implied? Just a thought. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]