Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating more than one record at a time
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. -
Updating more than one record at a time
CidMatrix, I want to use CFGRID, but I keep getting the message that my browser does not support Java2. How can I update? -
Updating more than one record at a time
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... -
Populating a text box by selecting from a drop down
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. -
Insert Data into Access DB using CFQUERY
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. -
Insert Data into Access DB using CFQUERY
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. -
Insert Data into Access DB using CFQUERY
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... -
Deleting last character of a text field using update query
Thank You. It works perfectly.- nsukari
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Deleting last character of a text field using update query
...exclude, etc. Please help. Here is an example of my query. IIf([Name_Last]="Smithy","Smith",IIf([Name_Last]="Davisy","Davis",IIf([Name_Last]="Jonesy","Jones",IIF([Name_Last]Like "*.",<>(Right([Name_Last],1)),[Name_Last]))))- nsukari
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Limit the number of records with CFIF
Thank You so much! It worked perfectly. -
Limit the number of records with CFIF
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... -
Image Slide Show
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...- nsukari
- Thread
- Replies: 1
- Forum: Javascript
-
Image Slide Show Question
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...- nsukari
- Thread
- Replies: 0
- Forum: Javascript
-
Query Join Help
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...- nsukari
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Count of more than one record
Count([Table].Field))>1- nsukari
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
DATE BASED QUERY - IIf STATEMENT NOT WORKING
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.- nsukari
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
DATE BASED QUERY - IIf STATEMENT NOT WORKING
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...- nsukari
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Scrolling Contents of a query
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... -
Scrolling Contents of a query
...if there is a method in CF, I would appreciate the help. Here is my very simple query code: <CFQUERY DATASOURCE="birthdays" NAME="bviewer"> SELECT * FROM birthdays </CFQUERY> <CFOUTPUT query="bviewer"> #Name# - #DateFormat(DOB,"mmmm d")#<br>... -
Can I use Javascript to scroll the contents of a Cold Fusion Query?
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...- nsukari
- Thread
- Replies: 0
- Forum: Javascript
