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...
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] == "#Select2_Default#")
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 "ThreeSelectsRelated".
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 "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...
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...
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.