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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DrumAt5280

    Query for Best Sales Day?

    Thanks guys, much appreciated, that worked great!
  2. DrumAt5280

    Query for Best Sales Day?

    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...
  3. DrumAt5280

    Query for Best Sales Day?

    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
  4. DrumAt5280

    Space between paragraph when pulling text from DB

    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.
  5. DrumAt5280

    Space between paragraph when pulling text from DB

    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...
  6. DrumAt5280

    Space between paragraph when pulling text from DB

    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.
  7. DrumAt5280

    Space between paragraph when pulling text from DB

    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...
  8. DrumAt5280

    Load new image without reloading page

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

    Load new image without reloading page

    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...
  10. DrumAt5280

    Delete image in DB, reorder remaining images

    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...
  11. DrumAt5280

    Delete image in DB, reorder remaining images

    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 |...
  12. DrumAt5280

    Cffile accept png with FireFox not with IE

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

    Cffile accept png with FireFox not with IE

    <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...
  14. DrumAt5280

    Upload images 1 at a time or all?

    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...
  15. DrumAt5280

    Alagad resize image jagged edges

    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...
  16. DrumAt5280

    User Account &quot;Administor&quot; then added a new one - problem

    Wow, thanks - that worked and saved me a bunch of time.
  17. DrumAt5280

    User Account &quot;Administor&quot; then added a new one - problem

    When I got my computer a couple of years ago I never created a user account for myself, it was just "Administor". I read that is was not a good for security. So i created a new user called "David". Then my Administor account that I had setup perfectly was now gone. I found all my files just...
  18. DrumAt5280

    Google base image upload status indicator

    Thanks Dan. I think it would be pretty easy to display the waiting type GIF when the image upload starts, but how do i know when not to display the GIF when the upload is complete? (I am using Coldfusion) I just thinking how i can make this work for my site.
  19. DrumAt5280

    Google base image upload status indicator

    http://base.google.com If you play with uploading images (you don't need an account to play with it) on Google's new Base application - how did they create what appears to be an animated gif "clock" on the right side indicating that the image is uploading. Do they use a combination of...
  20. DrumAt5280

    Understanding how the submit form botton works

    Never mind, i figured it out. I used the "location.url =" javascript command to steer it to the right page when i had it all validated. Thanks for your help.

Part and Inventory Search

Back
Top