Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 28, 2005 11:38 AM by JeffreyABecker
Apr 08, 2005 09:55 PM|LINK
Apr 09, 2005 12:54 AM|LINK
Apr 09, 2005 03:39 AM|LINK
In this case I would suggest that you should have an active column in the database table which will denote that if the slot has been taken or not.
This will also makes it easier to find all the available slots since than you will only run a query like this:
SELECT * FROM Table WHERE Active = 1;
Which will return all the slots on which bookings have been done.
Apr 09, 2005 09:27 AM|LINK
Apr 09, 2005 09:34 PM|LINK
Apr 10, 2005 01:44 PM|LINK
Apr 10, 2005 02:19 PM|LINK
Apr 12, 2005 11:27 AM|LINK
i'm using vb.net
well, your problem is that you're trying to feed the VB.Net compiler vbscript. It just isnt going to work. On top of that, it has syntax errors for vbscript. Furthermore, even if you had your object creation right, Access does not to my knowledge support
anything similar to that form of sql.
Ok, the first step in fixing this code is to turn on Option Strict and Option explicit.
For embeded code, change your page declaration from
<%@ Page Language="VB" %>
<%@ Page Language="VB" Explicit="True" Strict="True" %>
If you're using a code behind, simply put
Option Explicit On
Option Strict On
as the first 2 lines in your code behind file.
This is going to cause a very very large number of errors. It will however shake out bugs that VB will introduce by trying to guess what you mean.
Apr 12, 2005 11:53 AM|LINK
Now we move on to Converting your old ADO code to ADO.Net.
To Start, in VB.Net, we no longer use Server.CreateObject to Create Database Objects.
Honestly, i'd suggest getting a good book on VB.Net, another on ADO.Net
Apr 13, 2005 01:46 PM|LINK