cfAllie

[quote=omesanni;353829]Hi, I have decided 2 develop an online reservation system and I have no idea how I am goin 2 do dis. [/quote] Start by defining what kind of reservation system you want to write and what capabilities the system must have. For example 1. Goal is to design a …

I don't know what version you're using but you might look at [url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18952[/url] You might also consider converting the cfinsert to a regular insert statement <cfquery ...> INSERT INTO YourTable (Columns..) VALUES (....) </cfquery>

select t1.* from theTable t1 join theTable t2 on t1.id2 = t2.id1 and t1.id1 < t2.id1

What sender address are you using? It sounds like its being rejected, possibly as an anti-spam measure. Though I don't know if its from your mail server or from yahoo. Check their faq's [URL]http://help.yahoo.com/l/us/yahoo/mail/original/abuse/basics-55.html[/URL] Personally I use a regular <a href="mailto:..."> link instead of cfmail. I'd rather emails are sent …

Start with 1). Can you post your query and a description of what didn't work?

Yes, you need to separate them. The syntax should be more like [code] UPDATE SomeTable SET Column1 = SomeValue1, Column2 = SomeValue2, Column3 = .... [/code] It doesn't look like you need a subquery either. A simple join should be sufficient. Something like [code] UPDATE t1 SET t1.ID = tmp.ID, …

[quote=MidiMagic;361961]You are not summing in the previous month.[/quote] As Midimagic said, you need to sum the previous month(s) too. One way to do this is using a join [code] SELECT curr.AssetYear, curr.AssetMonth, SUM(curr.Total + ISNULL(prev.Total, 0)) AS Asset_Total FROM ( SELECT Year(Date) AS AssetYear, Month(Date) AS AssetMonth, Sum(Value) AS Total …

--- delete selected question delete from Questions where SurveyID = 140 and QuestionNum = 3 --- decrease subsequent numbers update Questions set QuestionNum = QuestionNum -1 where SurveyID = 140 and QuestionNum > 3

I'll let someone else tackle the issue of expectations, but I did have a few thoughts.... Left joins may be tedious to write, but performance is more important. I could reduce a 10 line query to 1 line. But if the 1 line query takes 45 minutes longer to run, …

[code] SELECT DISTINCT teacher.teachername, student.studentname, results.grade FROM teacher LEFT JOIN ( student INNER JOIN results ON student.studentname = results.studentname AND results.grade = 'A' ) ON teacher.teachername = student.teachername [/code]

If you order the query by customer_number you can use cfoutput with the group attribute to group the results together. Sorry for the poor wrapping [code] ------------------------------------------------- |customer_num# 1 2007-04-26 | 2007-04-16 ------------------------------------------------- |customer_num# 2 2007-03-10 ------------------------------------------------- |customer_num# 3 2007-03-20 | 2007-04-06 ------------------------------------------------- [/code]

Use cfexecute [url]http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p25.htm[/url]

Hi Ramesh, This example might be more complex than what you need, but it should give you a starting point. Caveat - This example [U]only[/U] counts the time that fall within @start and @end period. So for example if an employee started work at 11/1/06 6:30AM, and you entered a …