Peter J. Boettcher — Mon, 02 Apr 2001 21:59:42 +0000

You can setup aliases for tables in your query but I think you still have to reference them by their real name in the ASP page.

Are you saying it can't be done?

akohl — Mon, 02 Apr 2001 21:40:37 +0000

Hardcoding the field headings into the asp code is what I have been doing up until now. But I thought that giving the field names aliases in the recordset would be easier. Are you saying that this cannot be done?

Peter J. Boettcher — Mon, 02 Apr 2001 13:53:13 +0000

Andy,

I see what you mean. It's good practice not to use field names from the database in your presentation layer. The headings should be hard coded in the ASP to be something friendly for the user. This would avoid any mistakes in the future, incase someone renamed a field.

alias

akohl — Mon, 02 Apr 2001 13:46:53 +0000

What I mean by alias is that rs.fields(0).name will return the alias that I chose instead of the actual name of the field, which might not be an appropriate field heading for presenting to the user.

Peter J. Boettcher — Mon, 02 Apr 2001 12:56:10 +0000

Andy,

I'm not sure what you mean by alias, do you mean you want to use a variable? If so then you would code it like so:

strSQL = "SELECT * FROM My Table WHERE MyField = '" & MyVariable & "'"

As for books, I don't know of any specific titles, but I find books by WROX to be very good. An ASP book should at least have one chapter on databases. You can also find some examples at the following sites:

asp101.com
ultimateasp.com
freevbcode.com