|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
January 27th, 2004, 08:54 PM
|
|||
|
|||
|
ID value displayed in ASP QRY results instead of text
Using MS Access 2003 . . .
I have TBL_Movies with an "Available" field with Data type "Number". The data here points to the ID field in TBL_AvailableStatus. TBL_AvailableStatus has two fields: ID and Status. The lookup for the Available field in TBL_Movies is Code:
SELECT DISTINCTROW [TBL_AvailableStatus].[ID], [TBL_AvailableStatus].[Available Status Type] FROM [TBL_AvailableStatus]; I have a report that will display the various fields, including the Available fields. As desired, the report displays the written values from the Status field. I also have a QRY_AllMovies that looks like this: Code:
SELECT TBL_Movies.Title, TBL_Movies.Year, TBL_Movies.[Original Title], TBL_Movies.Available FROM TBL_Movies ORDER BY TBL_Movies.Title; When I view this QRY, everything looks as I want it (displaying the text from the TBL_AvailableStatus.Status field), but whenever I attempt to create an ASP from QRY_AllMovies, the resulting page displays only the number value from TBL_AvailableStatus.ID. Can anyone help me with how to get the text from the Status to display in an ASP instead of the ID? Technically, the ID is the value stored in the field, but the report is smart enough to display the info I want. I've tried various different 'solutions', but to no avail.
|
|
#2
January 28th, 2004, 05:19 AM
|
||||
|
||||
|
Anything after the SELECT keyword is returned. If you are having problems with what's being return in the ASP file, then that's where the problem is... the ASP, not the SQL, unless I've misunderstood your problem.
|
|
#3
January 28th, 2004, 08:20 AM
|
|||
|
|||
|
Yeah, that's what I was afraid of. I posted here first, since Access created the page for me, and I haven't touched a bit of ASP yet. I was hoping there was an easy solution within Access that I had overlooked. I'll try reposting in the ASP thread when I get around to it. Thanks!
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > ID value displayed in ASP QRY results instead of text |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
