Re: BETWEEN statement

Yup, most of my books use SQL Server as the example test-bed, but the
ADO.NET book discusses all of the interfaces and includes comments on other
platforms as well. DB2? Ah, no specific references to it, but there are
plenty of general guidelines that apply across the board.
MSDE and SQL Express are "PC database" types too--and free.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Darrell Wesley" <DarrellWesley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:41344236-958A-4624-BF73-0513CE739930@xxxxxxxxxxxxxxxx
> Bill,
>
> Which one of your books are you referring to? Does it cover something
> other
> than SQL Server. (Poor guys like me only have access to DB2 on a iSeries
> box
> or one of the other PC database types such as MDB or DBF files)
>
> "William (Bill) Vaughn" wrote:
>
>> Again, the Command object Parameters collection is the answer here too.
>> It
>> deals with the issues you expect and a number you don't.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>>
>> "bbdobuddy" <bbdobuddy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:70B33591-BDDC-45E3-9186-DB44D965DD99@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I have a connection to a SQL Database but this line of code keeps
>> > giving
>> > me
>> > errors and I don't know why. StartDate and endDate are dateTime
>> > objects
>> >
>> > objCommand.CommandText = "SELECT * FROM TICKETS WHERE daterecordadded
>> > BETWEEN " & StartDate & " and " & endDate & " ORDER BY SEQNUM ASC"
>> >
>> > This doesn't work either:
>> >
>> > objCommand.CommandText = "SELECT * FROM TICKETS WHERE daterecordadded
>> > BETWEEN #" & StartDate & "# and #" & endDate & "# ORDER BY SEQNUM ASC"
>> >
>> > Any help would be appreciated
>> > Thanks
>> > Brian
>> >
>>
>>
>>


.

Relevant Pages

  • Re: BETWEEN statement
    ... than SQL Server. ... "William (Bill) Vaughn" wrote: ... the Command object Parameters collection is the answer here too. ...
    (microsoft.public.vb.database.ado)
  • Re: MS Access Reports and VB.NET Program
    ... think that I want to ship a 30mb .NET framework to each of my clients? ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Getting started in IT.
    ... Have ordered both books. ... MCITP SQL Server 2005 Database Administration All-in-One Exam Guide ...
    (microsoft.public.cert.mcdba)
  • Re: Requirements to Run ADO.NET Application
    ... Okay, AFA SQLCe, consider that the functionality you get for that 1MB database engine might be just what you need. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I'm working through a stack of books that involves many technologies and SQL is just one of them. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... > I think I've seen similar writings elsewhere, perhaps in Bill Vaughn's ... I recall an article in SQLMag a few years back by Bill Vaughn where he ... > Craig Utley did a cool article on output vars vs. rowsets in SQL Server ...
    (microsoft.public.inetserver.asp.general)