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!
-
Erwino - tlHawkins - Pls Help - One more time
Thanks. I think I got it. -
Drop down list and recordcount
OK, you got two tables. I'm assuming that are properly linked. Your SQL should look something like this: <CFQUERY NAME="getAutoCount"> SELECT Tbl_Auto.Desc AS AutoType, Tbl_Auto.AutoID, '( ' & (Count(Tbl_Models.AutoID)) & ' listings)' AS CountDesc FROM Tbl_Auto INNER JOIN... -
Erwino - tlHawkins - Pls Help - One more time
Yes is me again. I didn't want to continue using the thread that someone else started, so, here goes. OK, I've modified the code based on the input from both of you guys. The problem is that the second default still doesn't work, worse, I don't know what I'm doing wrong. Here's the code... -
Link 2 drop down lists on one form, limit list
Thanks. So I'm not crazy. Well, then, could someone please verify the following code for me. Better, yet, tell me what I'm doing wrong. =============>>>>>>>>>>> { if (INV_ARRAY[0][m] == "#Select2_Default#") document.MyForm.PosID.options.selectedIndex = INV_ARRAY[0][m]; }... -
Link 2 drop down lists on one form, limit list
Erwino, I made the modifications you suggested. The only reason I was using only one query before was because I just went on the assumption that this was the preferred method based on the custom tag "ThreeSelectsRelated". I got the two selects two work, thank you. The issues I have... -
Is there a way to post multiple forms all at once?
Well, it's like Carl said in another post recently, in order for CFGRID to work properly, you need to have a certain level of control / assurance that the client machine will meet certain criteria, i.e. JRE version. I for one like using CFGRID, it resolve my issue completely; however, I do have... -
Updating more than one record at a time
Carl, you are absolutely right. I took for granted that the my users are right in front of my office AND that they run everything through a Citrix ICA client,so, I have complete control of the environment. Sorry about that nsukari. -
Is there a way to post multiple forms all at once?
I don't want to sound that I love the CFGRID tag, but, it is great and it sounds like it might give you what you want. All the employees can be listed, user updates everyone and then submits. Done. CFGRID solve I similar challenge for me, I'm sure it will help you out. The most common issue... -
Link 2 drop down lists on one form, limit list
OK Erwin. I took your code and modified it so that I could use it. I've only done it for two selects so far (I dout that adding a third select in this particular case would be very much different). Anyway, I think I'm almost there. The second select does updated based on what the 1st one... -
Updating more than one record at a time
OK, first I'm not sure what browser you are using. I'm using IE 5.5. Next the version I'm using for Java is "Java 2 Runtime Environment Standard Edition v1.3.1_07" (at least that is what is being displayed in my "Add/Remove Programs". As far as updating it, if I remember... -
cfif - trying to get a checkbox to display an SQL bit field
I never had very much success with check boxes in ColdFusion and believe me I tried. So, I just opt to use select boxes. I feel they give you much better control. -
CFGRID works in 4.5, not in 5
I had the same problem when I initially implemented CFGRID. Get the latest JRE, it should work. If it doesn't let me know and I'll see what version I'm using. I have a user that uses this everyday and so far, knock on wood no problem with it. -
CF_TwoSelectsRelated Breaks Javascript (Inserts Hard Returns in JS)
I've successfully used this tag. I have no idea what would cause something like this. If you wish, I can email you the version that I'm using just to see if something is quirky with your version. Let me know. -
Updating more than one record at a time
Another solution would be to use CFGRID, which is what I did. By using this, all the records retrieve look like a spreadsheet. The user updates everything he wants and then when submitted, CFGRID will recognize the changes and updates the records accordingly. If you need more information on... -
ThreeSelectsRelated
Thanks. I download it. It is actually and older version of the one that I already had. In either case, I tried it. No Joy. If I output the default attributes, I do get back the correct information, is just that for some reason the select boxes doesn't recognize them AND / OR the array is... -
Link 2 drop down lists on one form, limit list
Thanks for the code. I'll give it a try later on today or tomorrow. I'm currently having an issue with the "Cold Fusion Application Server" service. It keeps getting hung and I get Location Code: 26 errors. Don't know what could be causing. No new code was introduce recently and... -
Link 2 drop down lists on one form, limit list
OK, I've tried to modify "tlhawkins" code so that it works with THREE selects linked to a query and I can't get it to work. Again, my java script skills are zero to null. So I must apologize. If tlhawkins, or anyone for that matter can modify the code so that it works for three... -
Link 2 drop down lists on one form, limit list
If you can't get this code to work, you can also try looking for CF_TwoSelectsRelated from the DevExchange. I've used this with a lot of success!! (Can't say the same with CF_ThreeSelectsRelated as you can see from my post today). I'm hoping by looking at tlhawkins code, maybe I can... -
ThreeSelectsRelated
I was wondering if anyone had a "fixed" version of the custom tag, ThreeSelectsRelated. The copy that I have doesn't work properly with the default values. Only the value of default1 work. I've been banging my head and pulling my hair out trying to get it to work, but no go. I had... -
Display only once if records duplicated
OK, I really have to get back to work now. But, here it is. This should get you most of the way. <CFQUERY name="getOrders" datasource= username= password=> SELECT OrderID.OrderDate, OrderID.OrderID, ProductID.ProductName, ProductID.ProductID, CartID.Quantity, ProductID.Price FROM...
