Recent content by DrumAt5280

Thanks guys, much appreciated, that worked great!

Thanks Feherke I changed it to this: SELECT count(*) as totalSales, dateStamp FROM sales GROUP BY dateStamp ORDER BY totalSales desc Limit 1 This is what it returned: totalSales: 7 | dateStamp: 2012-10-21 07:33:25 I know my record sales day is higher than 7. Do you think it could be how...

I am confused how I can write a query to return the best sales day in terms of the amount and the date. Table: sales date field: dateStamp price: price My attempt did not work: SELECT count(*) as totalSales, dateStamp FROM sales GROUP BY dateStamp ORDER BY price desc Limit 1

I figured it out: <cfset dbvDescrip=REReplace(GetAd.rentaladdescription,'#chr(13)##chr(10)#','<br>','All' )> <p><cfoutput>#dbvDescrip#</cfoutput></p> The #chr(13)##chr(10)# makes it work.

Jedi, I tried the following but it didn't work. Still no spaces between paragraphs - i know it the REReplace tag works because i replaced "char(10)" below with a word i know is in the query and it worked fine creating the space. <cfset...

Chris, Thanks, I just tried that tag and it worked, however now i lost my word wrap (each paragraph runs off the screen in one long single line). Is the a function of how i got it in to the DB or is it the HTML tag? Thanks.

When pulling text information from my DB that I know is formatted correct with spaces between paragraphs I get all one string of text without spaces when i view it on the outputted page. Is there a html tag in need to wrap around the text to have it formatted like i see in my MySQL DB with...

Thanks James. Are there any issues doing that way with JavaScript (besides having JS diabled)?

I have a page which has 1 main photo shown and links to see the other 14 images. When you click on one of the links to see another image it populates the placeholder where the main default image was. Is there a way to load the new images from the server without reloading the whole page again...

John and Rudy thanks for your replies. Rudy got me thinking... I am allowing 15 photos for each listing (it is a real estate type site), but I am not adding a feature where the user can change the position of the images using an up or down arrow interface (i might do this later), so when it...

I have an Image Table in my DB which holds the names of the images. ImageId | imageName | imageOrder 1 | dsc0001.jpg | 1 2 | dsc0002.jpg | 2 3 | dsc0003.jpg | 3 4 | dsc0004.jpg | 4 When a user deletes an image, let's say the first one dsc001.jpg, I would like this: ImageId | imageName |...

I figured it out, i needed this one too: image/x-png,

<cftry> <!--- catch bad file types if JS fails to do it. ---> <cffile action="upload" filefield="uploadfile1" destination="D:\inetpub\example\photos\" ACCEPT="image/jpg, image/JPG, image/jpeg, image/JPEG, image/gif, image/png, image/xpng" nameconflict="makeunique"> <cfcatch type="any"> <p...

I am creating a site where people can upload images to my site. I am allowing 15 photos. I am interested to know what everyone thoughts are: 1. Upload one image at a time. (disadvantage is if uploading 15 photos the user needs to babysit the computer during each upload) 2. Upload all images...

If TruthInSatire is around I have a question for you. Or anyone else that is familar with the Alagad Image Component. Please look at this page: http://www.davecolorado.com/alagad.htm The page shows examples of a photo that has been resized using the component. I wrote a message to Doug (the...