p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Access Database


Message #1 by "Hiro Shiratori" <hiro-shiratori@m...> on Thu, 28 Dec 2000 15:32:45 -0800
I'm wondering if anybody can help me resolve some difficulties that I have

now.



I have Access 2000 database, in which there is a pull-down list menu on the

form.



On the table, I set-up as follows:

Display Control - Combo Box

Row Source Type - Value List

Row Source - 0=Morning; 1=Afternoon; 2=Night

Data Type - Nummber



All the values (Morning, Afternoon, Night) are shown correctly on the form.



However, on the ASP, all the values are shown as numbers such as 0 or 1 or

2.



Do you know how to show the values (Morning, Afternoon, Night) on ASP?



It will be greatly appreciated if you could provide me with any solution

at your earliest convenience.



Hiro Shiratori









---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #2 by Gregory_Griffiths@c... on Fri, 29 Dec 2000 08:46:57 +0000
The values that you are seeing is how Access stores the different 

values, use an IF or CASE statement to seperate them out in your ASP.



> -----Original Message-----

> From: hiro-shiratori@m... [mailto:hiro-shiratori@m...]

> Sent: 28 December 2000 23:33

> To: asp_databases@p...

> Cc: hiro-shiratori@m...

> Subject: [asp_databases] Access Database

> 

> 

> I'm wondering if anybody can help me resolve some 

> difficulties that I have

> now.

> 

> I have Access 2000 database, in which there is a pull-down 

> list menu on the

> form.

> 

> On the table, I set-up as follows:

> Display Control - Combo Box

> Row Source Type - Value List

> Row Source - 0=Morning; 1=Afternoon; 2=Night

> Data Type - Nummber

> 

> All the values (Morning, Afternoon, Night) are shown 

> correctly on the form.

> 

> However, on the ASP, all the values are shown as numbers such 

> as 0 or 1 or

> 2.

> 

> Do you know how to show the values (Morning, Afternoon, Night) on ASP?

> 

> It will be greatly appreciated if you could provide me with 

> any solution

> at your earliest convenience.

> 

> Hiro Shiratori

> 

> 

> 



--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com


  Return to Index