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 bkrike 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, 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...
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...
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...
