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...
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...
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 (...
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...
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...
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
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...
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...
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 ?? :)
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.