Search:

Well glad you got it working but either you were giving me bogus info in a lot of those posts or what I showed you 50 posts back would have worked like a charm without changing the database at all. ...

You said that you were already able to display the hex string. That means that you have it and you know what it is. You can use that to get the color name just like I showed you. What is so hard to...

You never showed where you tried the select statement so I do not know where you went wrong.

If you have the hex value of the newly changed color that you want to display the name for and that hex...

To much information and no clear answer to the question at hand.

Do you have the hex string value of the newly selected color?
Does that Hex string value exist in the Linkcolor table?

That is...

So are you saying that your linkColor table has the hex string value in it and the actual name of the color you want to display and that you have access to this hex string value from the script where...

At this point I am lost as to what you actually have in that table. At several points it sounded like you have the ColorCode and colorName in the same table but when I asked you went off on to...

Here is an example of a script I wrote many years ago. It does have a couple of places where it makes use of Inline VBScript and 1 place where it uses inline JavaScript but notice how much easier it...

You keep talking about other tables and other scripts but not answering the question. I don't care what it is called in another table. I don't care what the user sees. That does not matter at all....

A lot of info but mostly not needed and the part that is needed is still vague.

The important thing is what value you are getting when the user submits the page. and is that value in the table...

Yes you would need to do it just above that part so that you have the values when you want to display them.



Database > Tables > Fields

Example: MasterInventory.Mdb would be a database. A...

You need to use a select statement like I showed you with a where clause so that the results are limited to what you want to get.

When you say 2 forms I do not know if you mean to fields with the...

When you get a chance take a stab at it and then show the code where you are trying to get the colorname and where you are trying to display it and if they are in different scripts make sure to...

Well if the Session var is populated when you show the edit page and you are assigning the color there then of course when you display it later it will show what it was when the page was loaded...

That code is getting the value of the selected color which is what i thought you were talking about at one point but of course that is at the time the page is displayed not after you make a change to...

What error are you referring to?



You would use it where you need the info. You need to have the colorcode available when you do it as that is required to do the lookup. I do not know where all...

btw... this line ....



If (TypeRS("TypeName") = TypeRS("TypeName")) Then Session("NewName")=TypeRS("TypeName")


Why on earth did you write the If Test like that? You do know that...

Like I said to do a lookup you would do something like


RS.Open "SELECT ColorName FROM LinkColor WHERE ColorCode =" & Request("ColorCode"), Connect, 2, 3


I'm not sure what you do not...

To display data all you need to do is do a lookup. I mentioned this a few times already. It is very simple. You apparently know the value of the colorcode and that value is apparently in the table...

I do not even know what you are referring to now, I thought we were talking about how to display the color name that goes with the color code?

I don;t know what else to tell you. I showed you where to put it in Post #35 and I showed you the syntax for using a session var in post #37. I have no idea why you tried to put it in a different...

I really have no idea what you are trying to do at this point. That is apparently a different section of code than what you showed last time as there is no loop in it and this section opens the...

That looks pretty much like what you have been posting before, still no use of Session() vars .
There is no way I can tell you what you are doing wrong if I do not see the code that is giving a...

see post #35 and #37

It looks like you are not setting any value for either of the session vars you are trying to display

In the first part of the script there is one line that would set one of the session vars if the...

You should use a new thread for a new question. You can have as many as you need.

As for what you posted there is no code there that uses session vars so I can't tell you what you did wrong. I...