Search results for query: *

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

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

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

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

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

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

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

I have a form with 3 select boxes that allow you to select the state / metro area / city. The select boxes refresh the page with OnChange each time a selection occurs - all is working well. What i want to happen when the user clicks on the submit button is to send the user to the action page...

I have seen car web sites that let you select: - year - make - model from 3 drop down lists using javascript. Once you select the "model" for instance, it knows to fill in the next pulldown for "make". I need something just like this for: - state - metro area - town Does anyone know of a...

I will like to kill my sessions variables once the browser closes on CF7 (i don't use client variables). <CFAPPLICATION NAME="test" sessionmanagement="yes" setclientcookies="no" sessiontimeout="#CreateTimeSpan(0,0,20,00)#"> <!--- preserve session variables only until browser closes --->...

I created a session varable "session.pre_info" and it works great. But how do I check to see if the session is declared already? <cfif IsStruct("session.pre_info")> Do this... <cfelse> or do this... </cfif> Is that right?

I have tried adding a class to the <cfselect> tag to add a background color to a pulldown box, however the color is not adding. Is CSS classes not allowed within this tag? <CFSELECT NAME="csFk" class="red" QUERY="GetSuburb" VALUE="suburbId" DISPLAY="suburb" > <OPTION value="0"...

I have been using MySQL-Front for a couple of years and while it is helped me a great deal it is also pretty buggy for my experience. I am looking for a backup method to see and edit my table data. Can anyone offer a another method - perhaps web based that is free and easy to use? Thanks.

I know the static IP address of a visitor I wish to track when he comes for a visit. With Coldfusion can I: - see if he visits by watching for his IP address? - if he is visiting my site to send me an email? Once i get the email i can go to my logs to see where he has been on the site...

The following Coldfusion code dynamically generates a list of suburbs in a pulldown menu. I would like to use onChange="gotoURL();" so when a user selects a suburb from the menu it will take him to the correct page without a submit button. I know how to do this with plain HTML but not in...

The following Coldfusion code dynamically generates a list of suburbs in a pulldown menu. I would like to use onChange="gotoURL();" so when a user selects a suburb from the menu it will take him to the correct page without a submit button. I know how to do this with plain HTML but not in...

I have two DB tables, one table has a complete list of street names and the other has partial list of street names - I would like to make sure that each street name in the Partial list has a matching entry in the Complete list. Because i have thousands of street names how can i automate this...

I am new to JavaScript. I think this is an easy question. I have a form that uploads images to the server and i would like a pop-up to occur onClick or onSubmit that displays a message "Please wait for upload..." while the images are being uploaded on the action page. Once the action page is...