Search results for query: *

Thanks. I think I got it.

OK, you got two tables. I'm assuming that are properly linked. Your SQL should look something like this: <CFQUERY NAME=&quot;getAutoCount&quot;> SELECT Tbl_Auto.Desc AS AutoType, Tbl_Auto.AutoID, '( ' & (Count(Tbl_Models.AutoID)) & ' listings)' AS CountDesc FROM Tbl_Auto INNER JOIN...

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...

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] == &quot;#Select2_Default#&quot;) document.MyForm.PosID.options.selectedIndex = INV_ARRAY[0][m]; }...

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 &quot;ThreeSelectsRelated&quot;. I got the two selects two work, thank you. The issues I have...

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...

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.

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...

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...

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 &quot;Java 2 Runtime Environment Standard Edition v1.3.1_07&quot; (at least that is what is being displayed in my &quot;Add/Remove Programs&quot;. As far as updating it, if I remember...

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.

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.

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.

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...

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...

Thanks for the code. I'll give it a try later on today or tomorrow. I'm currently having an issue with the &quot;Cold Fusion Application Server&quot; 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...

OK, I've tried to modify &quot;tlhawkins&quot; 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...

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...

I was wondering if anyone had a &quot;fixed&quot; 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...

OK, I really have to get back to work now. But, here it is. This should get you most of the way. <CFQUERY name=&quot;getOrders&quot; datasource= username= password=> SELECT OrderID.OrderDate, OrderID.OrderID, ProductID.ProductName, ProductID.ProductID, CartID.Quantity, ProductID.Price FROM...