DW MX list box

  • pritesh_a
  • Graduate
  • Graduate
  • pritesh_a
  • Posts: 158
  • Loc: South London/UK

Post 3+ Months Ago

Hi all

How can i add a database function to the List box on my website i.e:

An Address book
List of names in a List box, when a name is clicked the e-mail address appears in the specif text box

I have an Access database where all the names and email address are stored and im using DW MX, running on Win XP Pro
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Nucleo
  • SausagePorkPie
  • Mastermind
  • User avatar
  • Posts: 2297
  • Loc: UK - England

Post 3+ Months Ago

because it is an access database, does that mean that the programming language for the text box will be asp?
  • pritesh_a
  • Graduate
  • Graduate
  • pritesh_a
  • Posts: 158
  • Loc: South London/UK

Post 3+ Months Ago

Yes ASP.
Like in Hotmail the address book
  • TheBecoming
  • Beginner
  • Beginner
  • TheBecoming
  • Posts: 52

Post 3+ Months Ago

You should use Cold Fusion. :twisted: ASP is totally not awesome.

Code: [ Select ]
<cfquery name="TableName" datasource="#Application.dsn#">
  SELECT        name,email_address
  FROM    Contacts
</cfquery>

<form name="form1" method="post" action="email2.cfm">
<select name="email_template" id="email_template">
<cfoutput query="TableName">
<option value="#email_address#">#name#</option>
</cfoutput>
</select>
</form>
  1. <cfquery name="TableName" datasource="#Application.dsn#">
  2.   SELECT        name,email_address
  3.   FROM    Contacts
  4. </cfquery>
  5. <form name="form1" method="post" action="email2.cfm">
  6. <select name="email_template" id="email_template">
  7. <cfoutput query="TableName">
  8. <option value="#email_address#">#name#</option>
  9. </cfoutput>
  10. </select>
  11. </form>


Although you could prolly try http://www.devguru.com/home.asp Or http://www.aspin.com/home/tutorial
  • pritesh_a
  • Graduate
  • Graduate
  • pritesh_a
  • Posts: 158
  • Loc: South London/UK

Post 3+ Months Ago

ok so what does the above code do and where do i put it?
  • TheBecoming
  • Beginner
  • Beginner
  • TheBecoming
  • Posts: 52

Post 3+ Months Ago

The server you are going to be running this on does it support CF? Are you going to be using a Database?
  • pritesh_a
  • Graduate
  • Graduate
  • pritesh_a
  • Posts: 158
  • Loc: South London/UK

Post 3+ Months Ago

Im using DW MX and i have an MS Acess database.
My server supports ASP

Post Information

  • Total Posts in this topic: 7 posts
  • Users browsing this forum: No registered users and 41 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.