cfAllie

Anyone Developing an airline reservation system in CF?

I have a form on our Web site where visitors enter data. I use cfinsert to insert this data into an MS access table. Most of the time, this form works. However, I occassionally get the following error: Error Executing Database Query. Application uses a value of the wrong type …

i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you …

Hi, I've set up a "Send Page to Friend" function using a script that I donwloaded. It works fine if I use my email as the recipient address, but I receive the following error when I try to send it to a Yahoo address: Invalid Addresses; nested exception is: class …

Hey guys, im in deep need of help for mysql. Ive been given a few questions most of them answered although theres 3 which are really bringing me down. I was wondering if u could get some help :D Given this schema borrow([U]transactionID[/U], personID*, borrowdate, duedate, returndate) author([U]authorID[/U], firstname, middlename, …

[COLOR=#0000ff]UPDATE[/COLOR][COLOR=#000000] table1 [/COLOR] [COLOR=#0000ff]SET[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC] [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#808080]([/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]SELECT[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC][/COLOR] [COLOR=#0000ff]FROM[/COLOR][COLOR=#000000] tmptable[/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] tmptable[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] table1[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN[/COLOR][COLOR=#808080])[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] [/COLOR][COLOR=#808080]EXISTS [/COLOR][COLOR=#808080]([/COLOR] [COLOR=#0000ff]SELECT[/COLOR] ID[COLOR=#808080],[/COLOR][DESC] [COLOR=#0000ff]FROM[/COLOR] tmptable [COLOR=#0000ff]WHERE[/COLOR] tmptable[COLOR=#808080].[/COLOR]ID_SUN [COLOR=#808080]=[/COLOR] [Table1][COLOR=#808080].[/COLOR]ID_SUN[COLOR=#808080])[/COLOR] [COLOR=#808080]I tired this but i coudn't uptade tow columns at once[/COLOR] [COLOR=#808080]do i need to seperate them or i have any mistake? …

Asset Table +-------+---------+-----------+ | Date | Asset | Value | +-------+---------+-----------+ |1/1/07 |Building | $1000 | |1/2/01 |Computer | $ 500 | |2/1/07 | Fax | $ 100 | +-------+--------+------------+ Result Table I would Like; +-------+---------------+ | Month | Total Asset | +-------+---------------+ | 1 | $1500 | | 2 …

hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number …

I'm building a large scale application and was wondering the difference between static counts vs dynamic counts. Right now, I'm using dynamic counts. For an example: [code] SELECT *, (SELECT COUNT(1) FROM CarImages WHERE CarImages.carid = Cars.id) as ImageCount, (SELECT COUNT(1) FROM CarBuyers WHERE CarBuyers.carid = Cars.id) as BuyerCount, (SELECT …

Hi, I am currently trying to write some sql that includes a where clause to limit responses but will leave blanks where there is no match. I will include the code so its easier to understand: SELECT DISTINCT teacher.teachername, student.studentname, results.grade FROM teacher INNER JOIN student ON teacher.teachername = student.teachername …

Hi all, I am running a query on an MS Access table that has some fields that are the same and some that aren't. For example, the customer number_field is the same, but the start_date field is different. I'd like to run through the query and when the customer_id is …

How can run an exe file in coldfusion.

Hi Folks I am in a difficult situation right now. Please help me. There are several stores and several employees. employees can work in multiple stores and stores have multiple employees the time they work are calculated based on the time they log in and log out. for this purpose …