Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old October 30th, 2005, 11:33 PM
Fran_franco Fran_franco is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2005
Posts: 92 Fran_franco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 h 14 m
Reputation Power: 4
Store CheckBox value on database

1. How can I store a database value on a SQL database's table??

I have 6 checboxes and I need to store if they are checked or not, just that... Is ther any kind of var like Access' Yes/No value?

2. Do you know where can I find any example about storing an image in the same database?

Thanks...

Reply With Quote
  #2  
Old October 31st, 2005, 09:04 AM
evansc evansc is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 258 evansc User rank is Private First Class (20 - 50 Reputation Level)evansc User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 4 m 16 sec
Reputation Power: 5
I usually use the "bit" value - which is "1" for yes and "0" for no. In Access they are usually Boolean, which is "-1" for yes and "0" for no. If you are transferring data over it might make sense to change the Access value from Boolean to text - I think that's what switches it to a positive 1.

Sorry, don't know anything about images.

Reply With Quote
  #3  
Old November 1st, 2005, 05:21 PM
Adversus Adversus is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2005
Location: Portland, OR
Posts: 106 Adversus User rank is Private First Class (20 - 50 Reputation Level)Adversus User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 1 h 55 m 20 sec
Reputation Power: 4
Send a message via MSN to Adversus Send a message via Yahoo to Adversus
I generally use bit for SQL for a 1/0 type flag. Although thats just me. You could also use char, varchar, or a number data type if you are so inclined.

As far as images go, I never, ever save images in the actual SQL database. You have a lot more control over the image files, easy accessibility, so on and so forth, if you save them on your filesystem (i.e. a folder on your hard drive or network resource).

Storing images in SQL requires a fair amount of coding unless you buy or download some utilities to help the process along (I could be wrong on the amount of coding, but last time I tried it was a lot).

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingVisual Basic Programming > Store CheckBox value on database


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT