Re: Data Parse error
Scott, The error is: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL The error occurred on line 473. I tried simplifying the insert query to just the first item, and I'm still getting an error. The first item is just the first name. This leads me to believe that it HAS to be something with the actual database somewhere, right? The reason I ask is because I know that this database used to exist as a Filemaker 4 database, and the person did some work to convert it to a filemaker 10. I feel like I've quadruple checked the INSERT query and it's syntax is correct. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Parse error
Well, I'd say I'm officially stuck then. Looks like "Text" datatype in filemaker converts to varchar, which is what I have. I've removed the quotes around the cfqueryparam statements. The form is still not putting the data into the database. Would dropdown or check boxes convert the data type for some reason? I'm just thinking out loud. I really am not sure beyond this point where to go. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Parse error
Do I need the commas? I've tried it without the quotes and with single quotes and am still getting the same error. Parse error in SQL. This is a filemaker database and all of the datatypes are TEXT. Does that mean anything? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Parse error
I'm sorry, I'm just not getting it. I've spent a week on this form and I'm just about ready to throw in the towel. I tried this change, but still got the parse error. Not even sure if this is the correct use of cfqueryparam INSERT INTO SRAStaff (First, Last, MI, EmpID, CurrentSchool, CurrentSubjectOrGr, PhoneHome, PhoneCell, PhoneWork, Voicemail, Address, City, State, Zip, Email, ApplyPosition, ApplySchool, SchoolApplyOther, OnlineSubjectGr, OnlineSubjectGrPreferred, YrsPartic, TshirtSize) VALUES ("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "") ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Data Parse error
You all have been able to help me so much this week with a form I've been working on, and it's nearly complete. The final step is to get the data entered into the database without throwing an error. The error is: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL The error occurred on line 487. The SQL code in my document is: INSERT INTO SRAStaff (First, Last, MI, EmpID, CurrentSchool, CurrentSubjectOrGr, PhoneHome, PhoneCell, PhoneWork, Voicemail, Address, City, State, Zip, Email, ApplyPosition, ApplySchool, SchoolApplyOther, OnlineSubjectGr, OnlineSubjectGrPreferred, YrsPartic, TshirtSize) VALUES ('#Form.First#', '#Form.Last#', '#Form.MI#', '#Form.EmpID#', '#Form.CurrentSchool#', '#Form.CurrentSubjectorGr#', '#Form.PhoneHome#', '#Form.PhoneCell#', '#Form.PhoneWork#', '#Form.Voicemail#', '#Form.Address#', '#Form.City#', '#Form.State#', '#Form.Zip#', '#Form.Email#', '#Form.ApplyPosition#', '#Form.SchoolApply#', '#Form.SchoolApplyOther#', '#Form.SubjectGradePreferred#', '#Form.SubjectGradeOther#', '#Form.YrsPartic#', '#Form.TshirtSize#') Could it be that setting within the actual database for data type, etc. could be causing the issue? If so, how do I get around this? Thanks again for any help you can offer! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Data parse error
You guys have helped me this week figure out this form, and it's working perfectly except for the last step, which is actually putting the form responses into a database. I'm getting the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL The error occurred on line 487. I'm not sure how to resolve this. Could it be settings in the actual database tables? How can I get around something like this? Thanks again for your continued help! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Repeating Data - Unsure of my use of cfquery
Just so I'm clear, are you saying that I need to change my #aQuery.aColumn[aQuery.currentRow]# formatting within the form? For example, I need to change this: #getSchools.SchoolBrief# to this: #getSchools.SchoolBrief[getSchools.currentRow]# If so, what is the currentRow value? Just a little confused there. ___ > > > > > > >That is illegal because ColdFusion does some automatic variable scoping >that would just not work in such a situation. To do this you have to >use the form. > >I.E. > > > > > > > > >Just realize with this from CF is not going to automatically scope the >query column names for you and you will have to keep track of the rows. >You output will look something like this. > >#aQuery.aColumn[aQuery.currentRow]# and #bQuery.bColumn[bQuery.currentRow]# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Repeating Data - Unsure of my use of cfquery
I got my original form to output the way I wanted it to. Now, I'm trying to actually process and validate that form and I'm running into more errors. I sort of know what I'm doing wrong, but unclear how to fix it. Here is my error: Invalid tag nesting configuration. A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing. The error occurred on line 299. Is there an easy way for me to send the file of my processing document on this forum? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331784 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Repeating Data - Unsure of my use of cfquery
You guys are awesome. Sometimes it's the easiest things... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Repeating Data - Unsure of my use of cfquery
Barney, would that require that the different tables have a linking relationship? I think that's my problem. There is no common field shared among these tables. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Repeating Data - Unsure of my use of cfquery
My Code: (link to live page - http://www2.ccboe.com/summeracademy/app/emp/index.cfm) SELECT SchNum, SchoolBrief FROM SCHOOLS ORDER BY SchoolBrief SELECT ApplySubject, ApplySchool, School, ApplyPosition, YrsPartic, TshirtSize FROM ApplySchoolList, SRAStaff, ApplySubjectGrList, YrsParticList, TshirtSizeList ORDER BY School Contact and Payroll Information: Applicant Name: First: Last: MI: Employee ID: Current Regular School: Select your school #getSchools.SchoolBrief# Current Grade and/or Subject that you teach: Phone Numbers: Home: Cell: Work: IP Phone ext.: Address: Street: City: State: Zip: Email: Please type this carefully so that we can reach you. There are no spaces in an email address. Application Information for Summer Academy 2010: What position are you applying for: Select a position #getSrastaff.ApplyPosition# What school would you prefer? Select a school #getSrastaff.School# If you do not get your preferred school, mark where you are willing to work: #getSrastaff.School# What subject do you prefer to teach? Select a subject #getSrastaff.ApplySubject# What other subject(s) would you be willing to teach? #getSrastaff.ApplySubject# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Repeating Data - Unsure of my use of cfquery
I posted a few days ago about having multiple cfquery statements in the same document. After some troubleshooting, I finally figured out how to do this. I began building my test form, which is populated from fields in a database, I'm running into a problem where the data is just being repeated, to the point where it's making the page extremely slow to load. I have a feeling this is because I didn't use cfquery properly - but I'm not sure how to remedy the situation. The form kept looking over the data more and more as I added new rows querying new data. Any help is much appreciated. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Two CFQUERY statements?
You'll have to excuse me, I'm still sort of a CF novice so I'm not too familiar with how to use CFTRANSACTION. What I was doing was just putting two separate CFQUERY statements at the head of my document, each with a different name attribute and different data sources. When I did my cfoutput of the second cfquery, that's when I got my error. The error was "Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][SequeLink Server]The specified data source is not defined." But I'm not sure that is very helpful to you. If one of the databases was converted into a table and placed into the other database, I'd have no problem with this, but for some reason I'm getting tripped up with the different data sources. Thanks for any help you can offer. > You can happily query multiple databases within the same request; > what > you can't do is query multiple databases within a single transaction. > So as long as your CFQUERY tags don't share a CFTRANSACTION block you > should be fine. > > Can you post the actual error message? > > cheers, > barneyb > > On Thu, Mar 11, 2010 at 12:26 PM, Steven Sprouse > wrote: > > > > I have someone who has two separate databases and they want me to > write a Web form generating option menus from both databases. > > > > I have set up both as separate data sources in my Coldfusion > administrator and have included one cfquery at the head of my document > generating a list of locations. It's working fine. When I try to query > the second database and do a cfoutput for another option menu, I get > errors. > > > > I seem to remember that it might not be possible to have two > separate cfquery statements in the same document. Is this correct? If > so, how would I go about achieving my desired result? > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Two CFQUERY statements?
I have someone who has two separate databases and they want me to write a Web form generating option menus from both databases. I have set up both as separate data sources in my Coldfusion administrator and have included one cfquery at the head of my document generating a list of locations. It's working fine. When I try to query the second database and do a cfoutput for another option menu, I get errors. I seem to remember that it might not be possible to have two separate cfquery statements in the same document. Is this correct? If so, how would I go about achieving my desired result? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfif help
>Juste replace type by schoolTypeID > >Francois Levesque >http://blog.critical-web.com/ > > > > >>Got it. Thanks so much for your help! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfif help
>You can try something like this: > > > ... > > >or, a more verbose way, but it can end up being much longer if you add >possibilities: > > > ... > > >Francois Levesque >http://blog.critical-web.com/ > > > > >> So what if I already have a field in my database called "SchoolTypeID"? >> Where do I reference that? I already pulled that field out in my query of >> that database. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfif help
I need help figuring out how to display a link if an ID type is 1 or 2 (as defined in by database) but not displaying the link if the ID type is 3 or 4. I know this should be easy, but I keep screwing it up. The page that I'm working from is http://www2.ccboe.com/schoolscenters/viewschool.cfm?id=22 (just picked an ID at random). For elementary and middle schools I want to display a School Supply link in the resources section at the bottom. For High schools and centers, I do not want to display that link. Can anyone help me? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfif help
I need help figuring out how to display a link if an ID type is 1 or 2 (as defined in by database) but not displaying the link if the ID type is 3 or 4. I know this should be easy, but I keep screwing it up. The page that I'm working from is http://www2.ccboe.com/schoolscenters/viewschool.cfm?id=22 (just picked an ID at random). For elementary and middle schools I want to display a School Supply link in the resources section at the bottom. For High schools and centers, I do not want to display that link. Can anyone help me? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Easy Form
I just cannot seem to wrap my head around creating a simple CF feedback form. I've got the front-end side with the correct form fields, but when it comes to the action file, I always mess it up. All I want is a form that will validate that someone typed their name, a valid email address and some comment. I want to be able to direct them back to the form if they didn't enter their information properly, and to a thank you page if they did. I'm looking for it to block spammers somehow with the validation and make it so that they can't enter code into any of the fields. I want their comments to be mailed to a Webmaster. Can anyone help explain the entire process to me? I have books upon books, but never seem to do this properly. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Easy Form
I just cannot seem to wrap my head around creating a simple CF feedback form. I've got the front-end side with the correct form fields, but when it comes to the action file, I always mess it up. All I want is a form that will validate that someone typed their name, a valid email address and some comment. I want to be able to direct them back to the form if they didn't enter their information properly, and to a thank you page if they did. I'm looking for it to block spammers somehow with the validation and make it so that they can't enter code into any of the fields. I want their comments to be mailed to a Webmaster. Can anyone help explain the entire process to me? I have books upon books, but never seem to do this properly. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: news and press releases - need help!
>You could download blogcfc (google it) and look at the code. It does >this, and supports subscription confirmation to stop people from >subscribing someone else. > >--Greg > > >>This was amazingly helpful! Thank you so much for pointing me to this. I was >>able to get something up and running on the site after a day (I've been >>thinking about it and failing at it for about three months!) Thanks again. ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
news and press releases - need help!
I tried on here before without much luck, but I really need to know how to set up some code that allows us to notify people on a mailing list when we've posted a new news or press release item. I'm assuming I need to set up a database that will hold the people who register, but how will we notify them when something has been updated and how can we email them what's been updated? It's a lot like the mailing lists here. How do they work? I'm just really stuck putting all of the pieces together! ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Admin login and form upload
I would like to add the functionality to my website to have an employee login through an admin back end of our site, upload a form with the date it was uploaded, title, and file from their computer, have the form sent to our web server and the title and form accessible to the public. I know this can be done, but I don't know exactly how. Is there anyone out there smart enough with some time that might be able to guide me through this process? ~| 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:282578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Date and Time
Does anyone know how I can insert a date and time stamp into a SQL database when someone goes on our website and uploads something? I created a form where someone can input the title and body of a press release but I also want it to automatically record the time that it is uploaded, store it in the database and also output it on the list of press releases. How do I do this??? ~| 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:282288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query LDAP for back door web login
Well they won't really be web admins. They will just be uploading forms to the website for public use and I want them to do this without me being involved, because the forms change so often. And I'm not the one who manages the LDAP, so I'd hate to go to our LDAP admin and give them more work to do. >Since you have access to Active Directory, I would suggest that you put >your admin people into a domain group such as "WebSiteAdmins". Then, >when they log in, you can check for the group membership. > >If you need any details on how to pull this off, let me know. > >M!ke > ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query LDAP for back door web login
I am trying to design an application where users can login from a back door admin page but still use their Active Directory user name and password info that has already been assigned to them. I don't want to have to create a whole new database of user names just for back door access to the site. I'm hoping to check what users put in as their user name and password with an LDAP query. I then want my users to be able to upload certain files, where they will be accessible to the public. I have a basic understanding of ColdFusion and know bits and pieces of what I might need, but I'm having a hard time putting it all together. One of the main reasons for this is that we are running off of a Content Management System that already uses a lot of action files and some cfcs. I don't know if I try to do something if it will mess up the system we have in place. Anyway, I could use some help! If there is anyone out there with some free time, ideas or resources I would really appreciate any help I can get. Thanks! ~| 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:282048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
radio button validation
I know you can do a to throw an error if a form field is blank, but how do you do the same type of thing for a radio button. Is it any different? For some reason I keep getting an error on my form that says app_on_file is undefined in Form when I leave it blank (intentionally). Any help with this? Form is at http://www2.ccboe.com/employment/jobfair_register.cfm ~| 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:275691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF CAPTCHA - need help!
> Okay, I've made changes to the form, http://www2.ccboe. > com/feedback/feedbackform.cfm > > The CAPTCHA is there and looking nice, but I can still submit the form > without having to enter anything in the image field. Any help with > this? Does the mailto look UPDATE - I was able to get it to work. To the people with more experience in this than me, does it look like, code wise, that I've improved the functionality and reduced the amount of SPAM that might get through? ~| 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:275420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF CAPTCHA - need help!
Okay, I've made changes to the form, http://www2.ccboe.com/feedback/feedbackform.cfm The CAPTCHA is there and looking nice, but I can still submit the form without having to enter anything in the image field. Any help with this? Does the mailto look ~| 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:275412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF CAPTCHA - need help!
Well not exactly. It's not as bad as it sounds. My original feedback form was generated from a cf include file on my server. You'd have to change that code to change the email address > On Monday 16 Apr 2007, Steven Sprouse wrote: > > my mailto: tag is > > currently just a hidden input type in the form with a value of the > email > > address it's supposed to go to. > > Eeek ! > So if I change it to anything else, I can send my spam through your > mail > server ? > > Hard code things like this in the backend. > > -- > Tom Chiverton > Helping to dynamically evolve proactive patterns > on: http://thefalken.livejournal.com > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in > England and Wales under registered number OC307980 whose registered > office address is at St James's Court Brown Street Manchester M2 2JF. > A list of members is available for inspection at the registered office. > Any reference to a partner in relation to Halliwells LLP means a > member of Halliwells LLP. Regulated by the Law Society. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above > and may be confidential or legally privileged. If you are not the > addressee you must not read it and must not use any information > contained in nor copy it nor inform any person other than Halliwells > LLP or the addressee of its existence or contents. If you have > received this email in error please delete it and notify Halliwells > LLP IT Department on 0870 365 8008. > > For more information about Halliwells LLP visit www.halliwells.com. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF CAPTCHA - need help!
Rob, With the JS you sent, can I create a name for that whole thing and then make reference to the name in the form? I ask because my mailto: tag is currently just a hidden input type in the form with a value of the email address it's supposed to go to. How do I reference the new JS? >Hi Steve, > >Firstly, here is a great tutorial on lyla from Ray >http://ray.camdenfamily.com/index.cfm/2006/11/14/Quick-and-dirty-CAPTCHA-Gui >de I found it a great help when I started out with it. > >Next thing I notice about that contact form, is that you're only using JS >client side stuff to validate its contents, so I just disabled JS in my >browser and fired off about 10 blank emails though the form, imagine what a >mailing bot could do with it in just a few seconds. > >Get some server side validation on the form for starters, and get a captcha >or something on it, build your mail to links using the JS solution I >provided, that should start to stem the flow a little I think. > >Rob > >-Original Message- >From: Steven Sprouse [mailto:[EMAIL PROTECTED] >Sent: 16 April 2007 14:16 >To: CF-Talk >Subject: Re: CF CAPTCHA - need help! > >The feedback form can be found here: >http://www2.ccboe.com/feedback/feedbackform.cfm > >I think I've tried the lyla capcha in the past and couldn't figure it out. >Maybe I'll give it another go. ~| 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:275349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF CAPTCHA - need help!
The feedback form can be found here: http://www2.ccboe.com/feedback/feedbackform.cfm I think I've tried the lyla capcha in the past and couldn't figure it out. Maybe I'll give it another go. ~| 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:275342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF CAPTCHA - need help!
I have a feedback form on our website, and we're getting a lot of SPAM. I don't know if it's because we're using mailto in the cf code or because we're not using some sort of image verification on the form (I'm sure it's a combination of the two). Does anyone know of a good CF based form validation/image verification code to help make our feedback section more secure? ~| 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:275330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Altering display of data from SQL database
Thanks so much. I got it working. Had to create some cfsets defining a variable for the data field names and now everything is working great. ~| 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:275078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Altering display of data from SQL database
I have data in a SQL database that I want displayed with commas on my web page (ex. data is stored as 1234 and I want it displayed as 1,234. Does anyone know how I would go about doing this? I'm assuming I need a cfif statement, but I'm not sure if there is a specific function I should use or not. Please help! ~| 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:275071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: data not being displayed
you hit the nail on the head with looking closely at the data. The person who typed this data in left out all of the prin and vprin data out for the schools and centers. So it wasn't coming up because there was no school code in the prin and vprin table to match up to. It takes some stupidity to learn something I guessthanks for all of the help! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247350 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: data not being displayed
I don't get a thing when I do that query, but I do when I change the id to something else. What gives? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247346 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: data not being displayed
this is the query I am using on the viewschool.cfm doc... SELECT * FROM Schools s, Principals p, VicePrincipals v WHERE s.SchoolID = () AND p.SchoolID = () AND v.SchoolID = () and this is body code... Schools & Centers #SchoolNameLong# Click here to go to #SchoolName#'s website School Address: #SchoolAddr##SchoolCity#, #SchoolState# #SchoolZip# School Phone and Fax Numbers: #SchoolPhone# (main phone) #SchoolPhone2#(alternate phone) #SchoolFax# (fax) Administration: Principal: #PrincipalPrefix# #PrincipalFName# #PrincipalLName#Vice Principal(s): #VPPrefix# #VPFName# #VPLName# School Start and End Times: Start Time: #SchoolStart#End Time: #SchoolEnd# ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247340 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: data not being displayed
well click on a school name from any list about Center or Program and you'll what it generates. All of those forms are running off the same exact code. weird right? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247335 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
data not being displayed
Me again with a stupid problem. It's probably something easy. Does anyone know why certain data is coming up and some isn't? Go to this link (http://www.ccboe.com/website/schoolscenters/schools_main.cfm) and click on a Center or Program...page is blank, but on all of the other pages it is fine. Also, when I click on printable List all of the data is fine until I get to the Center or Program area. There, it only shows one of our programs. Any ideas? Sorry to be annoying ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247331 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating an indented department directory
Could I do this... In my Departments table create a field that is called SubDept and have it be either yes or no and another field called SubDeptID and allow null values so if a dept isn't a sub-department of something it stays blank, but if it is it will have a number that corresponds to the DeptID. Then in my code I could do a cfif statement saying "if subdept equals yes, then create do a nested unordered list based off of it's corresponding Dept ID, if no, do nothing" Would that even work? Would it still list that sub-department under the main departments anyway? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247307 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating an indented department directory
Okay, so I understand the Division and Departments ID thing. Now, what if there is a sub-department of a department? For example: We have a division of Instruction...under that division we have a department of Curriculum & Instruction. Under the C&I department we have sub-departments like Health, Social Studies, Math, etc. I know those sub-departments need to go in the departments table, but how do I link them together with the department? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247291 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating an indented department directory
Charlie, so in my case, the Division would be the genre, the Department would be the author, and the sub-department would be the book name, correct? In designing my table then, where the genre was entered in the book table, would I have to write out each division name or should I replace that with a division ID? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247283 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating an indented department directory
I think I can digest this and make it happen. Thanks so much!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247281 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Creating an indented department directory
I posted the other day about creating school pages and all of you were extremely helpful. Thank you! I have another issue today. I'm trying to create a department directory where we list the six main divisions and then indented a little bit are the departments that fall under that division (I know the indeted part will be done with some css). I have a table with DeptID, DeptName and SubDeptOf where SubDeptOf corresponds to the DeptID it falls under. I got CF to generate a department listing (see here http://www.ccboe.com/website/departments/departments_main.cfm) but I want to take it to the next level. Any help??? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247277 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help building pages with multiple queries and tables
Okay, working brilliantly! Take a look at my page so far http://www.ccboe.com/website/schoolscenters/schools_main.cfm How do I sort so that Elementary is First, Middle is Second, High is Third and Center/Program is Fourth? Their respective SchoolTypeIDs are 1,2,3,4 Thanks so much for all of the help! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247063 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help building pages with multiple queries and tables
So, if my table with SchoolType just has a field with SchoolType and 4 records of Elementary, Middle, High, and Center/Program...that works? Because in my Schools table I have a field called SchoolType, so those two tables should link up correct? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247054 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help building pages with multiple queries and tables
I'm new to this forum. I'm hoping there's someone out there that can help me with my problem. I'm trying to build a school directory similar to thi (http://www.mcps.k12.md.us/schools/index.cfm) or this (http://www.wcboe.k12.md.us/content/sch_schools.cfm) I have a Table named Schools with SchoolID, SchoolName, SchoolType, SchoolAddr, etc. and I also have a table called SchoolType with a fieldname of SchoolType that just lists Elementary, Middle, High, Center/Program. I don't know if I set my database up incorrectly or not, but I can't figure out a query (and the query string that I know I need) to get the first page to output a list of schools by School Type, and then when you click on the Go button or the School Name, it brings you to a page with information Specific to that school. Can anyone out there PLEASE help me? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247042 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4