|
 |
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
|
|
|
View Cart
