Ask a Question related to ASP Database, Design and Development.
Can I change my BIT column to receive YES or NO?
Is there a way I can make BIT column able to receive "yes" or "no" values
instead of "-1" and "0" values?
I use the following code to create my database...
strSQL = "CREATE TABLE Inventory (ItemNumber TEXT(30), InStock BIT);"
....I am not interested in manually using MS Access to make this change
because my site creates new databases often. I am searching for a way to do
Maybe something along these lines....?
strSQL = "CREATE TABLE Inventory (ItemNumber TEXT(30), InStock
Hi My ASP.NET application has a datagrid and the data in the cells varies from 10 to 500 characters. The users would like to be able to...
There are times when you will need to highlight or otherwise modify the contents of a particular DataGrid row-column value based upon the value in...
You can do thisn DataGrid_ItemCreated Event HTH Prasad "MarkMurphy" <firstname.lastname@example.org> wrote in message...
Hi All, I have a datagrid and am autogenerating columns. I would like one of the columns to be a hyperlink column after the data has been bound...
Hey, I have a table that has 5 columns in it. What it does is when the user enters a name into a field and clicks submit it takes them to this page...
Bob Barrows [MVP] #2
Re: Can I change my BIT column to receive YES or NO?
michaaal wrote:> Is there a way I can make BIT column able to receive "yes" or "no"
> values instead of "-1" and "0" values?
1. Use vbscript to translate the 0 and -1 values to the values you wish to
display to the user
2. Use a CHAR field (Text if Access) and store the data as you wish to
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Bob Barrows [MVP] Guest