Re: Loop in Distinct loop with more then one column

I think your first problem is that your db is not normalised and if I were you I would look into imrpoving the db structure here. However, it is possible to do what you are after without resorting to two queries or rearranging your db. The following code assumes that there are always three

Re: CF restart daily

Michael, do you have any word on this? I'm kind of curious. Could you clarify if the ColdFusion service is restarting or the OS. You said cron job-- are you hosting on Linux? First of all, how do you know it is restarting? What is the symptom? If it is ColdFusion that is restarting, start

Re: Loop in Distinct loop with more then one column

Just a general note that any time you run a query and then loop over it and run more queries, there's almost always a way to accomplish the same task using a single query (which will be far more efficient). On Fri, Mar 6, 2009 at 4:17 PM, Sin Tec tooles...@gmail.com wrote: Im doing a loop

Re: CF Facebook

Hi Michael, I have done five Facebook apps using ColdFusion and there are 3 others in the works right now. In addition to the traditional Facebook application, Facebook now has the Facebook Connect option. What Facebook Connect allows you to do is for you to allow your users to log on

Join Problem

Hi I am joining two tables, together, there will always be one record in the left table associated to serveral in the right. When i query the tables, i always get to many records displayed. i.e if there are 5 items in the left table associated to 24 items in the right table instead of

cffile in a CFC

I have a user submitting an image via a form. I would like to make a function in my cfc to upload the file. What do I put in the fileField attribute of CFFile? Arguments.TitleImage or Form.TitleImage? What type do I set for the cfargument? String? Binary? cffunction

Re: cffile in a CFC

If the name of the form field is 'TitleImage', you would just put 'TitleImage'. You may wish to pass the form field name as the argument; otherwise no argument would be required. It feels kinda nasty but if you are to do cffile uploads inside a function there's little choice. HTH, Dominic

Coldfusion 8 reseller hosting and helm

Hi does anyone know of any large hosting companies (50 staff) that provide coldfusion 8 reseller packages and includes the helm control panel? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

URL Rewrite/URL Aliasing

Hi All, Anyone here using MS URL Rewrite for URL aliasing for CF web sites? Are there any options for URL aliasing? Thanks, Duane Boudreau President/CTO Sandy Bay Networks Inc. Smart People. Smart Solutions. ~|

Re: Join Problem

You *should* be getting 24 rows - that is how joining works! To make your grouped output work, start by adding ORDER BY gp_name to the end of the query. Then this CF code should do what you want... cfoutput query=thababove group=gp_name [group logic] #gp_name# cfoutput

Re: cffile in a CFC

I have a user submitting an image via a form. I would like to make a function in my cfc to upload the file. What do I put in the fileField attribute of CFFile? Arguments.TitleImage or Form.TitleImage? What type do I set for the cfargument? String? Binary?

Re: cffile in a CFC

This function will upload a file. http://coz.pastebin.com/f4eb4bbaa The full CFC is on my interblog if you are interested. http://www.myinternetisbroken.com/files/FileUpload.cfc.zip Here is the basic usage for the cfc cfifNOT isdefined(application.FileUpload ) cfset

Re: Join Problem

An inner join returns one item on the right and one item on the left for every equality. So if one item on the left matches 5 items on the right, you will get 5 rows returned because there are 5 matches between rows on the left and rows on the right. Now, that said...what do you want? You never

Re: Join Problem

Thanks for your responses Sorry for my lack of question!! The query grabs a product and its images, I only need to display products in the list I.e product 1, product 2, product 3 etc. At the moment the query will display product 1, product 1 etc for every picture it has, which I know is

Re: Join Problem

It isn't clear to me which part of your query is the product id, but if simplicity is your goal, you could leave that query as it is, then do a query of queries and just do a SELECT DISTINCT on which ever columns have your product info. More generally, if you want the product info but not the

CF8 Image manipulation

I am loving the CF8 Image drawing functions, but have a question. Consider this: I have drawn an image and written it to the browser. Has anyone seen a way to click on an image and then get the normal 8 handles and be able to massage the angles by clicking on a corner handle and adusting the