...SQL 2005 but Access does not like the query syntax.
Here is my query:
SELECT TOP 5 Category.Title, article.pubDate, article.Title AS Title, *
FROM Article
INNER JOIN Article_Category ON Article.ID = Article_Category.ArticleID
INNER JOIN Category ON Article_Category.CategoryID =...
Hello, I have roughly coded a script to grab data of articles from a database. There is an id, title, content, and category. I have it working fine with one category, but I now need it to work with multiple categories.
Along side of this, I need my code to show related articles belonging to...
Anyone know of any good tutorials on how to create an image/background like the one on the Windows home page (http://www.microsoft.com/windows/default.mspx)? Thanks
Thanks tarwn, that tutorial did what I needed. After getting just the login portion working, I tried the sessions. They didn't seem to work for me. I kept getting an error "Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent" What's this...
I am new to PHP and trying to create a simple user login. I've done many searches and they all seem great but they are including things I do not want to implement at the moment. I just want a tutorial that explains how to create a simple login that checks the user against a mySQL database. I...
Hi, I'm creating an script that grabs form values and emails them. I've got that portion working fine. The issue I'm having is with a link within the email body that has 2 or more variables it's passing. I have a variable holding the body of the email and this is how I have the line with the...
I'm running Server 2003 and I'm trying to establish something that will upload files to certain directories. I've found much code and components but I can't get them to work on the server box. IIS5 seems to run them ok, but IIS6 seems to think it's more "secure" and I'm having trouble getting...
Hello, I'm having a bit of issues. I'm running a query and then outputing it with the date and title. That part I have working. But sometimes there are more than one item per date and I would like to only list the date once instead of on each record. Here's an example:
05/01/06
-Todays News...
OK, that seems to work, but it just doesn't seem pratical for a site that has hundreds of pages. Maybe someone has a suggestion as to the best way to many links to that many pages.
I'm trying to manage my includes. I would like to have a link with a variable and have that variable represent an included template.
i.e.
http://www.whatever.com/index.cfm?page=01
01 = "includes/pages/bios/01.cfm"
<cfinclude template=#page#>
Hope that's not confusing. I'm trying to make my...
Is it possible to set a number to the value of a string.
i.e
<cfset 01 = "includes/pages/bios/01.cfm">
I know this particular syntax throws an error, but is there a way to do this? Thanks.
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.