Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Urgent, Can't get this grouping to work...
Hi, kathryn - That is correct. I need that feature for the "admin" site where i show the news headline and it shows which categories it belongs to. Also if im doing a search, lets say for generalcategory "small business" AND region "Canada", it will not give me the... -
Urgent, Can't get this grouping to work...
Hi guys & gals, kathryn - Yes i've tried that, its in my new SQL statement located at that URL i posted. tleish - I dunno much about CFOUTPUT (cause i've been working on it like crazy and can't get it right) But from the results i get, it turns out those two grouping ways gives me the same... -
Urgent, Can't get this grouping to work...
Yea i know, But thats a different forum and still no one has been able to give an answer. I posted here aswell to see if anyone here can give me a hand. I have posted the FULL info of my query, CFOUTPUT, Tables AND my results in that post. So if you like, please go here (... -
Urgent, Can't get this grouping to work...
Hi, It seems like nothing is working for me. I've got help from two people already but neither of the solutions have worked for me. So im gonna post with ALL the details and see if anyone can help me. I have Five tables: News, GC, RE, LS, BS News is the main table... Here are the full tables... -
Grouping problem...
Hi Guys, I have a problem... I don't seem to get this "multiple" grouping right... I have 5 tables... The first Table "News" and then 4 more that are in relation with "News" which are "GC, RE, LS, BS" Anyways here is my Query: CFQUERY... -
Displaying all values between two or more table relations...
Sorry guys, i need to bump my msg up for someone to see, i really need to findout how to do this. If anyone can help me out, i'd really appreciate it. :) Brad -
Displaying all values between two or more table relations...
STill having a problem... Not for calling from one field that worked GREAT! :) Thank you so much... But i wanted it to do it from multiple tables. I thought i could do it after figuring out how to do it with one, but it doesn't work. Like im using ur CFquery, except there are 3 more tables... -
Displaying all values between two or more table relations...
Hi Guys, If anyone can help me out i'd appreciate it. Here is the thing, i have two tables "news" and "GC" where "news.ID=GC.NID" ! For example if in the news table i have: ID(auto-number) NewsTitle 2 blah blah blah blha! and then in... -
Inserting multiple data into multiple rows...
Oops, by dropdown list i meat using option "<select Multiple name="list">" where it allows you to pick multiple value... So for the name "list" i get out multiple values. is it doable ?? :) -
Inserting multiple data into multiple rows...
Hi There, Here is my sit: Im trying to add multiple values coming out of a drop down list in a form, to go into multiple rows in a SQL table. For example, one value per row. Lets say i have a drop down list with 3 options (aa, bb, cc) and i want to insert it in a table so it goes like: ID... -
posting data, and avoiding duplicate posts...
Hi everyone, just a quick question, when posting data onto a SQL database, i want it to check for the email and if it exists it wont post and shows a friendly message. I've tried by making the email as primary key but i don't want my users to see that cf's nasty error page! How about defining...
