buttons text fields

1: How do i change the style of text field and submit buttons

2: i have a field in a databse table which points to either a

picture

field = /images/hello.gif

sound

field = /sound/text.mp3

hyperlink

field = /test/energy.html

how do get the results page to have buttons which will reference the to play the sound or open the hyper link

or to have the picture displayed in a box.

1) Do it with CSS, like:

input {
color: black;
background: red;
}

2) Check the last 3 letters of the field content (gif/mp3/tml) then display the appropriate link accordingly.

not sure what you mean, i have designed a results page with the button, how to i reference the result to the button with out haveing to manuly change the html

is it online, can I see?

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by djaccess

not sure what you mean, i have designed a results page with the button, how to i reference the result to the button with out haveing to manuly change the html
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Can't you just do;

Code: Select all

<form action="<%= RecordSet("FieldWithPoints") %>">

ok right a make a picture in Fireworks that i am going to add as a link to open a sound or image. The link for this file is held in my access database as etc. sound/sound.pl

i want to have 5 or 6 diffrent sounds linked with some other information from the table

so for instance
Pages

Name song name

steve outerspace <Button to play song>

<Button to play song> = result from table sound/sound/pl

i dont want a textr field with the result

Assuming you've got a recordset (RS) with all the field values then:

Code: Select all

If not RS.EOF Then
	Do until RS.EOF
		response.write _
                RS("name") & ", " & _
                RS("title") & ", " & _
                "play
"
		RS.MoveNext
	Loop	
Else	
	response.write "no records found"
End If

this should produce the following type of listing:

The Prodigy, Charlie, <u>play</u>
The Beatles, Yesterday, <u>play</u>

...

what if i want the play to be a picture and i have more than one set of results say 7 sets

Right ok so you put the result in the href of the button, but the problem im getting is that it opens the result

e.g

/sounds/sound.mp3

as a web page and errors, how do i make this open in winamp or win media player and play rather than bringing up the download screen.

If you have an MP3 player installed it should be able to play it with IE. Otherwise suggest that they 'right-click save as' and play it using their favourite MP3 utility.

If you want to show a different word for each type:

.gif = "show"
.mp3 = "play"
.html = "view"

then you'll need some code tht works out what the last part of the string is (after the last dot):

pos = instrrev(RS("location"),".") 'find the last dot in the string
'make a new sring of just the stuff after the dot
extension = left( RS("location"),(len(RS("location")) - pos) )

then inside the loop have a sselect statement to put in the correct word:

Code: Select all

Do until RS.EOF
    select extension
        case "gif"
            linktext = "show"
        case "mp3"
            linktext = "show"
        case "html","htm"
            linktext = "show"
        case else
    end select
    response.write _
    RS("name") & ", " & _
    RS("title") & ", " & _
    "" & linktext & "
"
    RS.MoveNext
Loop

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by djaccess

what if i want the play to be a picture and i have more than one set of results say 7 sets
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Just have 7 loops in a row, one for each RS.