Here's my SQL:
SELECT *
FROM A, B
WHERE A.address IN ('X')
OR B.address IN ('X')
ORDER BY B.address, A.address,B.[date], A.[date]
Is there anything that sticks out here that could be improved so that this query takes less time to run?
If i want to see where all the borders are on all my divs, tds, etc I can put this line in my css:
*{
border: 1px;
border-style: solid;
}
But, I'd like to see margins and padding as well... Is this possible?
Here's some java code that does almost exactly what I want to do.
http://www.rgagnon.com/javadetails/java-0458.html
However, I want to use this java code in a cfc
I'm clueless how to put this java code into a cfc.
Any pointers or tips to help me get started would be very much appreciated.
Do search engines like Google, Yahoo, and MSN count the links back to your site? Has anyone found that submitting many articles has alone significantly improved their postition in the SERPS for the anchor text that they use with their backlinks?
Has anyone coded a script that will follow all the links on your site and create an xml sitemap from those links? Would you care to share any of your code or point me in the right direction here?
I find myself writting some pretty sloppy code from time to time and it would be nice if there was a good tool online to apply uniform indentation, spacing, etc to my css and html code automatically. Anyone know of a particular good tool for this?
How is this done? I understand it's difficult to code the CSS to work in most of the popular browsers. I could just enter the appropriate number of <br /> tags to push the footer down to the bottom on pages where the height is not all taken up by content. But, there's got to be a better way...
Is there something that can be done to make an image gallery looks better before images are loaded? Would you suggest a placeholder of some sort or is there another way to go about this using CSS?
I'm going to be creating a storefront and shopping cart in Coldfusion. Can anyone point me to an up to date and robust tutorial for how to code a shopping cart complete with a checkout process in Coldfusion? Or, any tips or advice you have would be much appreciated. We'll be using CF MX 7 on...
I'm getting this error:
Server Error
The server encountered an internal error and was unable to complete your request.
JRun closed connection.
Anyone know what causes this error? What can be done to fix it? Right now, restarting Coldfusion or rebooting the server seems to fix it temporarily.
Can someone please post instrucions on how to link to Google maps? That is, what do you append in the query string to view a map of an address with an from address input text box prompt?
I'd like to gather information from visitors to my site. What are the options out there both free and paid for Coldfusion? Has anyone written their own code that is open source and they wouldn't mind sharing?
The following query seems to work, but I'm not sure it's the best way to do this. Is there a better way to write this SQL statement? Is there another query that does the same thing, but is shorter and is better form?
SELECT j.jobid
FROM Job j
JOIN Image i
ON j.jobid = i.jobid...
I have the following select query:
SELECT DISTINCT Job.JobID, Job.DateAdded
FROM Job, ImageTag, Image, Tag, TagCat
WHERE TagCat.TagCatID = Tag.TagCatID AND Tag.TagID = ImageTag.TagID AND ImageTag.JobID = Image.ImageID AND Image.JobID = Job.JobID
AND ImageTag.TagID IN (#TagIDList#)
ORDER BY...
As a new coldfusion developer, I'm not sure when to make a function a udf or a cfc. Also, I'm not sure how to convert one to the other. Can anyone describe when to make it a udf or a cfc and how to convert one to the other?
I want to use cflocation to open up a page in a thickbox window. Without using cflocation, I can just do it like this: <a href="thickboxwindow.cfm" class="thickbox"> and it will open up that page in a thickbox. Is it possible to redirect a user to a thickbox with cflocation, though? How could...
Where do you keep your user defined functions? Do put them all in one file under a 'lib' folder and then cfinclude that file? Or, do you store them in a component and invoke that component? What is the best practice?
Can anyone help me convert this line of code from Javascript to Jquery?
$(fileObj.name).innerHTML += '<a href="javascript:;" class="floatLeft" onclick="removeImage(\''+fileObj.name+'\')">delete</a><br />';
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.