Ask a Question related to Coldfusion Database Access, Design and Development.
-
bloodfinger666 #1
Help with MS-Access Yes/No
I have about a dozen databases from a client that contain a Yes/No column.
How can I most effectively! ensure that the data from each column displays as
"No" vice "0" and
"Yes" vice "1" ?
Thanks!
bloodfinger666 Guest
-
Web Service + Anon Access, but getting 401 Access Denied Error
I have a simple webservice that just returns a string. The security for this is set to windows authentication in IIS (XP Professional) and anonymous... -
Network File access using anonymous access
I have seen a number of entries related to accessing remote resources (files in my case) that need to reside on a remote server. We must leave our... -
Access 2002 PDFWriter VBA Code w/WinXP does not work like Access 2000
I am trying to print an Access 2002 report (Windows XP OS) as a PDF. I had success with Access 2000 in a Windows 2000 environment, but as soon as I... -
Access Violation when using Visual Interdev to access Oracle
I am running Windows 200 Pro, IIS 5.0 and trying to connect to an Oracle 8.1 database. Prior to applying a security patch to W2k, the ASP... -
Access denied when creating Access application object
In an ASP file I am running the following in VBScript in order to extract data from an Access 2002 MDB file which is physically located in the... -
paross1 #2 Re: Help with MS-Access Yes/No
How about something like this?
SELECT SWITCH(CStr(your_column) = '0', 'No', True, 'Yes)
FROM your_table.
WHERE whatever
Phil
paross1 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
