The problem is that I want to be able to update multiple records at once and it won't allow me to do that. I get an error that says cannot update ID 5,8,45, etc. although Ik did not add any commas to ythe query. One record at a time updates fine.
I have a query that updates the record in the DB with the new information the user submits. What I want to do is allow the users to update all of their records at once, click submit, and then have the correct records update in the DB. Is there a way to di this? I tried using CFLOOP, but it was...
There are two columns in my table "Programs", SPM ID and Program Name. I need to be able to automatically populate the "Program Name" by selecting the SPM ID from the drop-down list.
How can I do this?
Thanks for the help.
Thanks for trying to help. I've tried changing the fields one at a time but to no avail. Even though I didn't want to use CFINSERT, it's working with so I'll just stick with that for now.
No. That still doesn't work.
It keeps saying there is something wrong with this line: <CFQUERY NAME="addexpense" DATASOURCE="WMRA">
Everything else is fine.
I have an application that is working well except for one thing. The submitted data will not insert into the Acess table. I have checked all of the field names, I have tried other applications running on this same DB and they work, and I have checked each field in the table to ensure that there...
I am trying to create an update query to correct the names of one table before comparing it with the other. The problem is, I have four people with the suffix of Jr. on their last name. I want to get rid of the "." without having to list each name indiviually. Is there a way I can do...
I have a simple application set up so that users can register for certain events through our website. The registration information is added to an Access database and a confirmation e-mail is sent to the reigstrant and the person in charge of the event.
The problem is, I need to limit the...
I am using the following script from javascriptkit.com for a slideshow. I need to know if there is a way for me to point to an entire directory of photos instead of listing the photos seperately. I am often replacing photos or adding new ones and instead of having to update my script each time...
I am using the following script from javascriptkit.com for a slideshow. I need to know if there is a way for me to point to an entire directory of photos instead of listing the photos seperately. I am often replacing photos or adding new ones and instead of having to update my script each time...
To your first query add a third column for Max of Rep#. Now your query resilts should be
Region MaxOfSales MaxOfRep#
A $15,000.00 0302
B $7,000.00 0004
Here is the code for the join query:
SELECT Query1.Region, Query1.[MaxOfRep#], Reps.Name, Reps.State, Query1.MaxOfSales
FROM Reps RIGHT JOIN...
Do you have this in your query?
INNER JOIN OpData ON Unit_Rental_Info.UnitID = OpData.UnitID
When I set up two sample tables with the same fields and used your query, it worked for me without giving me duplicates. Without that statement, you get duplicates.
Perhaps I'm not understanding what you want. First Where does the [OpData]![Month] come in?
If what you want is to show, for all records in the "Unit_Rental_Info" table, the field [Total Cost] for anything with a change date before and including today and [New Cost] for everything...
No, I mean scrolling. Like I have a list of 20 names, but the area is big enough for 10. The names continuously cycle from 1-20 and then start over again. Like a moving billboard. I have done this in javascript and it works great, but not with the CF query. I don't want to have to retype my JS...
I have a query that produces a list of people from an access DB. THe query is very simple and is working, but the problem is that I need to be able to display the contents of this query on a web page as a continuously scrolling list. I have not been able to figure this out. I have tried to use...
I wrote a query in Cold Fusion to pull the birthdays for the week in the organization. The query works OK. I want to add this to my groups homepage, but my boss would like to see this list scroll. Updating the list each week is not an option as we have 3,000 people in our organization. That's...
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.