Carolina CF User Group (CCFUG)

I'm wondering if anyone here has been part of this group, Carolina ColdFusion User Group (http://www.ccfug.org/home.cfm) ? Meets tonight in Chapel Hill, NC at 7 PM at the Hanes Building, Room #2, on the UNC campus. P@tty Ayers ~~ Structure you

Re: Could Not Delete From Specified Tables

Ben - Thanks very much for this response. I have the feeling I've built this database incorrectly, and I'm considering re-doing it. I will keep you posted! Appreciate your help, P@tty > P@tty, > > If you have the tables related, with 'cabins' as the "parent" table, you > cannot normally dele

Re: Could Not Delete From Specified Tables

Andy - Thank you very much for this response. I think I understand a lot better, and I'm reading the Access book and database theory book to get a better grip on this. I'm considering re-building my database now, which is why I'm not pursuing this particular question further. I think it could be

Re: Could Not Delete From Specified Tables

Andy - Thanks for your response. (Still welcoming any help from others as well..) > Do you mean you have a primary key called photoID in this table as a primary key? cabinID in this table should be a foreign key, related to the cabins table. Okay, I just checked and no, actually I didn't make

Could Not Delete From Specified Tables

Ok, you all helped me tremendously this morning, so I'm hoping someone can point me in the right direction on this new problem. I've created a Delete Record page, but when I test it, I get an error message simply saying "Could not delete from specified tables." Any ideas at all why? A little inf

Re: Newbie problem: Search on Yes/No Column

Okay - success! As several of you kindly pointed out: > You can't have filters after the Order By Clause > > ORDER BY cabinName AND hashottub = 1 I did that, and then stumbled upon what I think was giving me the error messages. This: AND hashottub = 1 Needed to be this: AND cabinHottub

Re: Newbie problem: Search on Yes/No Column

Randy (and/or anyone else willing to help!) - Thanks very much. But I've trying this exactly the way you've shown (code is quoted at the very bottom of this message), and I get an error message, which I've pasted directly below. Any idea why?? The column name in the database is 'cabinHottub'.. d

Newbie problem: Search on Yes/No Column

Friends: I thought that I had this solved, but not quite. Can anyone help? The problem: I need to search on a "yes/no" column - several of them - allowing the user to choose that this field "Doesn't Matter" or else "Yes". There's a search page and a results page. The database has a column "cabin

OT: Thank you!

Please excuse this off-topic post, but I really have to thank Kelly Matthews, whose solution to my form/query problem worked beautifully, as well as Randy, Jeff. Phoen, Christopher, and Al, whose suggestions I also printed, pored over, and learned from. This list is awesome, and as a CF newbie I'

Kelly: Can you clarify further?

Kelly, > Well if it doesn't matter just don't pass the parameter have it set with a > value of "" and > then when you run the query where hottub = > Yesetc > that way if they pass the parameter blank it won't include it in the search, > hence pulling > up records that do and/or don't include hott

How to Allow a "Doesn't Matter" Variable in a Search?

Friends: Can anyone help with this problem I'm stuck on? Not sure if this is a simple one or not, but in any case I'll sure be delighted to get it working. This set of pages allows the user to search a set of records using 9 search objects. Four of those are for searching yes/no (1/0) fields in

Thank you!

To all who helped with my problem - very quickly, and consistently! - Corina, Jason, James, David, Nathan, Peter, Frank, Alec, and Kelly - thank you *very* much! It worked perfectly for me. What a great list. P@tty Ayers Dreamweaver Resources, FAQs, and Tutorials: http://www.thepattysite.com/d

Displaying yes/no field dynamically in checkboxes

Friends, I would much appreciate any help with a problem I'm stuck on. I'm writing a page that will allow my client to edit a record. I've got it so that the page queries the table and inserts the values from the record specified by the numeric variable passed to it. The numeric fields, text fie

Displaying yes/no field dynamically in checkboxes?

Friends, I would much appreciate any help with a problem I'm stuck on. I'm writing a page that will allow my client to edit a record. I've got it so that the page queries the table and inserts the values from the record specified by the numeric variable passed to it. The numeric fields, text fie