Cool, thanks. Sam
----- Original Message ----- From: "David L. Penton" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 2:00 PM Subject: RE: DOUBLE > Sure, it should be fine in this case. Yes, you can order by it. > > David L. Penton, Microsoft MVP > JCPenney Application Specialist / Lead > "Mathematics is music for the mind, and Music is Mathematics for the > Soul. - J.S. Bach" > [EMAIL PROTECTED] > > Do you have the VBScript Docs or SQL BOL installed? If not, why not? > VBScript Docs: http://www.davidpenton.com/vbscript > SQL BOL: http://www.davidpenton.com/sqlbol > > > -----Original Message----- > From: Sam Thompson [mailto:[EMAIL PROTECTED]] > > Its a small content management app, the content is split into sections and > sub sections. The FLOAT field is used to store the section number, which in > some cases looks like this: 2.1 > I dont need to do any calculations or anything complicated with this number, > will FLOAT still be ok? Can I use ORDER BY against a FLOAT field? > > Thanks, Sam > > ----- Original Message ----- > From: "David L. Penton" <[EMAIL PROTECTED]> > > > FLOAT is a representation of the number. It is not as precise as you > might > > like, although it might not make any difference in your particular > > application. > > > > -----Original Message----- > > From: Sam Thompson [mailto:[EMAIL PROTECTED]] > > > > Thanks guys, FLOAT did the trick. > > > > Sam. > > > > ----- Original Message ----- > > From: "Bostrup, Tore" <[EMAIL PROTECTED]> > > > > > Float > > > > > > HTH, > > > Tore. > > > > > > -----Original Message----- > > > From: Sam Thompson [mailto:[EMAIL PROTECTED]] > > > > > > Hi > > > > > > In access I can set the field size of a number datatype to be "Double", > > now > > > im creating the same table in SQL Server 7, what do I put in my SQL > script > > > (which creates the table) to make the equivalent field? Currently ive > got: > > > > > > CREATE TABLE tblData > > > ( > > > [ID] numeric IDENTITY(1,1), > > > [Section] varchar (255) NULL, > > > [Content] text NULL, > > > [SectionNo] int , <---------- what goes here to make it double? > > > [DateUpdated] datetime, > > > [DateSent] datetime > > > ) > > > > > > Thanks! > > > > > > Sam > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
