Changing Icon on Input

[Renie83]

Hi,
What I would like to do is when a user enters new information to a
table in a database by submitting a form, the icon that was used to
open up the page to let them provide that input should be temporarily
changed. I have everything set up except how to change the icon. I
really don't have any ideas on how this is done so if anyone can start
me in the right direction I'd appreciate it. If anyone knows a web
site with this kind of information that would be a big help too.
Thanks a lot!
RENIE 83

[Ray at]

What icon are you talking about?

Ray at work

"Renie83" <renie83@lycos.com> wrote in message
news:8e153bdf.0307220805.6f7e3694@posting.google.c om...

> Hi,
> What I would like to do is when a user enters new information to a
> table in a database by submitting a form, the icon that was used to
> open up the page to let them provide that input should be temporarily
> changed. I have everything set up except how to change the icon. I
> really don't have any ideas on how this is done so if anyone can start
> me in the right direction I'd appreciate it. If anyone knows a web
> site with this kind of information that would be a big help too.
> Thanks a lot!
> RENIE 83

[Renie83]

Hi Ray,
What I have is a little x icon with a link that a user clicks on to
bring up a form.This form lets the user enter some input that will be
sent off to a table. When the user enters input with the submit button
I would like the little x to change to a check mark that does not have
a link to it so no one can change that record. Right now I have the x
icon with it's link inside a span and also the check mark icon in a
span on hidden. They are both contained within a cell of a table. One
thing, I can't seem to get them right on top of eachother, maybe it
has something to do with being inside the cell. I have to have those
icons in the table, because they go along with certain rows in the
table. Another thing is that I only want the check mark to be up for a
certain period of time. It will need to change back to an x after a
set amount of time. I hope you can give me some ideas as to where to
go with this. Thanks a lot!
RENIE83

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message news:<OA9VPvGUDHA.1364@TK2MSFTNGP10.phx.gbl>...

> What icon are you talking about?
>
> Ray at work
>
> "Renie83" <renie83@lycos.com> wrote in message
> news:8e153bdf.0307220805.6f7e3694@posting.google.c om...

> > Hi,
> > What I would like to do is when a user enters new information to a
> > table in a database by submitting a form, the icon that was used to
> > open up the page to let them provide that input should be temporarily
> > changed. I have everything set up except how to change the icon. I
> > really don't have any ideas on how this is done so if anyone can start
> > me in the right direction I'd appreciate it. If anyone knows a web
> > site with this kind of information that would be a big help too.
> > Thanks a lot!
> > RENIE 83

[Ray at]

Hi RENIE83,

You'd want to change your images based on whatever condition you want it to
be based on. Like, if you want it to be image2 from the last time the
record was updated until midnight of that night, you could do something
like:

sLastUpdated = "1/1/1904" '' or some other old date - doesn't matter
sID = Request.Querystring("id")
sSQL = "SELECT [lastUpdated] FROM [theTable] WHERE [theRecordID]=" & sID
Set rsDate = objADO.Execute(sSQL)
If Not rsDate.EOF Then sLastUpdated = rsDate.Fields(0).Value
rsDate.Close
Set rsDate = Nothing
objADO.Close
Set objADO = Nothing



If DateDiff("d", sLastUpdate, Now()) > 0 Then
sImgSource = "/images/updatedalreadytoday.gif"
Else
sImgSource = "/images/clickheretoupdate.gif"
End If

That will just check to see if there was an update today (according to the
server's date) and if so, set a different image source.

Ray at work



"Renie83" <renie83@lycos.com> wrote in message
news:8e153bdf.0307230422.3a78a828@posting.google.c om...

> Hi Ray,
> What I have is a little x icon with a link that a user clicks on to
> bring up a form.This form lets the user enter some input that will be
> sent off to a table. When the user enters input with the submit button
> I would like the little x to change to a check mark that does not have
> a link to it so no one can change that record. Right now I have the x
> icon with it's link inside a span and also the check mark icon in a
> span on hidden. They are both contained within a cell of a table. One
> thing, I can't seem to get them right on top of eachother, maybe it
> has something to do with being inside the cell. I have to have those
> icons in the table, because they go along with certain rows in the
> table. Another thing is that I only want the check mark to be up for a
> certain period of time. It will need to change back to an x after a
> set amount of time. I hope you can give me some ideas as to where to
> go with this. Thanks a lot!
> RENIE83
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message

news:<OA9VPvGUDHA.1364@TK2MSFTNGP10.phx.gbl>...

> > What icon are you talking about?
> >
> > Ray at work
> >
> > "Renie83" <renie83@lycos.com> wrote in message
> > news:8e153bdf.0307220805.6f7e3694@posting.google.c om...

> > > Hi,
> > > What I would like to do is when a user enters new information to a
> > > table in a database by submitting a form, the icon that was used to
> > > open up the page to let them provide that input should be temporarily
> > > changed. I have everything set up except how to change the icon. I
> > > really don't have any ideas on how this is done so if anyone can start
> > > me in the right direction I'd appreciate it. If anyone knows a web
> > > site with this kind of information that would be a big help too.
> > > Thanks a lot!
> > > RENIE 83

[Ray at]

There isn't really any simple way for the page to know until after the
second user submits the form. (This is not entirely true, as you could use
some client-side code to hit the server every n seconds or something, but
that probably is not the best method.) What you'll have to do is check the
record before the data is entered by the user, like:

sSQL = "SELECT [lastUpdated] FROM [theTable] WHERE [theRecordID]=" & sID
Set rsDate = objADO.Execute(sSQL)
If Not rsDate.EOF Then sLastUpdated = rsDate.Fields(0).Value
rsDate.Close
Set rsDate = Nothing
objADO.Close
Set objADO = Nothing

If DateDiff("d", sLastUpdate, Now()) = 0 Then
response.write "This record was already updated today."
response.end
Else
'''normal code that goes ahead and updates.
End If

Ray at home

--
Will trade ASP help for SQL Server help


"Renie83" <renie83@lycos.com> wrote in message
news:8e153bdf.0307231129.76762432@posting.google.c om...

> That seems like a better way of doing it than I was trying to. The
> only thing is that say two people are on the same page at the same
> time. How can I make sure that as soon as that information is
> submitted there is no way the other person can enter information until
> the time has elaspsed. Is this even possible? Thanks a lot! I really
> appreciate all your help!
>
>
> Renie83
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message

news:<epIjZuRUDHA.1576@TK2MSFTNGP12.phx.gbl>...

> > Hi RENIE83,
> >
> > You'd want to change your images based on whatever condition you want it

to

> > be based on. Like, if you want it to be image2 from the last time the
> > record was updated until midnight of that night, you could do something
> > like:
> >
> > sLastUpdated = "1/1/1904" '' or some other old date - doesn't matter
> > sID = Request.Querystring("id")
> > sSQL = "SELECT [lastUpdated] FROM [theTable] WHERE [theRecordID]=" & sID
> > Set rsDate = objADO.Execute(sSQL)
> > If Not rsDate.EOF Then sLastUpdated = rsDate.Fields(0).Value
> > rsDate.Close
> > Set rsDate = Nothing
> > objADO.Close
> > Set objADO = Nothing
> >
> >
> >
> > If DateDiff("d", sLastUpdate, Now()) > 0 Then
> > sImgSource = "/images/updatedalreadytoday.gif"
> > Else
> > sImgSource = "/images/clickheretoupdate.gif"
> > End If
> >
> > That will just check to see if there was an update today (according to

the

> > server's date) and if so, set a different image source.
> >
> > Ray at work
> >
> >
> >
> > "Renie83" <renie83@lycos.com> wrote in message
> > news:8e153bdf.0307230422.3a78a828@posting.google.c om...

> > > Hi Ray,
> > > What I have is a little x icon with a link that a user clicks on to
> > > bring up a form.This form lets the user enter some input that will be
> > > sent off to a table. When the user enters input with the submit button
> > > I would like the little x to change to a check mark that does not have
> > > a link to it so no one can change that record. Right now I have the x
> > > icon with it's link inside a span and also the check mark icon in a
> > > span on hidden. They are both contained within a cell of a table. One
> > > thing, I can't seem to get them right on top of eachother, maybe it
> > > has something to do with being inside the cell. I have to have those
> > > icons in the table, because they go along with certain rows in the
> > > table. Another thing is that I only want the check mark to be up for a
> > > certain period of time. It will need to change back to an x after a
> > > set amount of time. I hope you can give me some ideas as to where to
> > > go with this. Thanks a lot!
> > > RENIE83
> > >
> > > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in

message

> > news:<OA9VPvGUDHA.1364@TK2MSFTNGP10.phx.gbl>...

> > > > What icon are you talking about?
> > > >
> > > > Ray at work
> > > >
> > > > "Renie83" <renie83@lycos.com> wrote in message
> > > > news:8e153bdf.0307220805.6f7e3694@posting.google.c om...
> > > > > Hi,
> > > > > What I would like to do is when a user enters new information to a
> > > > > table in a database by submitting a form, the icon that was used

to

> > > > > open up the page to let them provide that input should be

temporarily

> > > > > changed. I have everything set up except how to change the icon. I
> > > > > really don't have any ideas on how this is done so if anyone can

start

> > > > > me in the right direction I'd appreciate it. If anyone knows a web
> > > > > site with this kind of information that would be a big help too.
> > > > > Thanks a lot!
> > > > > RENIE 83