OT: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread S . Isaac Dealey
I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL ,

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Tangorre, Michael
Not that this should make a whole lot of difference I the context of your issue, but I try and steer clear of using reserved words (trigger,description) for column names. I doubt it has anything to do with your problem but just thought I would throw that in there. Mike I'm going to lose my

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread S . Isaac Dealey
well so do I, but I didn't develop this app or these db's unfortunately... of all the things that are wrong with this app, keywords is the least significant... of course, until I have to create a table with cf... Not that this should make a whole lot of difference I the context of your issue,

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Ken Ferguson
, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:59 AM To: CF-Talk Subject: RE: SQL Create Table w/ Escaped Column Name Not that this should make a whole lot of difference I the context of your issue, but I try and steer clear of using reserved words (trigger,description) for column

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Ken Ferguson
We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened to this: cfquery Create table dbo.t_testing([trigger] int NULL) /cfquery What's that give you??? -Ferg _ I'm going to lose

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Ken Ferguson
_ From: Ken Ferguson Sent: Friday, July 23, 2004 1:06 PM To: CF-Talk Subject: RE: SQL Create Table w/ Escaped Column Name We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened

RE: SQL Create Table

2001-01-25 Thread Philip Arnold - ASP
It should be "Votes int NULL" instead of Votes varchar(4) NULL Damn, did he write the vote counting system for Florida? g Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world"

RE: SQL Create Table

2001-01-25 Thread Russel Madere
-Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 03:42 To: CF-Talk Subject: RE: SQL Create Table It should be "Votes int NULL" instead of Votes varchar(4) NULL Damn, did he write the vote counting system for

RE: SQL Create Table

2001-01-25 Thread Owens, Howard
So, I still don't know how to create a boolean column H. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: SQL Create Table

2001-01-25 Thread Rick Lamb
PROTECTED]] Sent: Thursday, January 25, 2001 1:57 PM To: CF-Talk Subject: RE: SQL Create Table So, I still don't know how to create a boolean column H. ~~ Structure your ColdFusion code with Fusebox. Get the official book

RE: SQL Create Table

2001-01-25 Thread Raymond B.
]] Sent: January 25, 2001 14:57 To: CF-Talk Subject: RE: SQL Create Table So, I still don't know how to create a boolean column H. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

AW: SQL Create Table

2001-01-25 Thread Christoph Schmitz
Hi, try "Votes bit NULL". HTH, Chris -Ursprüngliche Nachricht- Von: Owens, Howard [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 25. Januar 2001 00:57 An: CF-Talk Betreff: RE: SQL Create Table Great, got that. Thanks, Richard. I think I figured that out r

RE: SQL Create Table

2001-01-25 Thread Maia, Eric
I use the bit datatype for a boolean column in MS SQL. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 11:57 AM To: CF-Talk Subject: RE: SQL Create Table So, I still don't know how to create a boolean column H

SQL Create Table

2001-01-24 Thread Owens, Howard
I'm trying to run a SQL query to create a table ... locally, I'm creating in access, but when I'm ready to move to the production server, it needs to work in Oracle. At any rate, the following works, but it's not what I need: CREATE TABLE Test ( TestID

RE: SQL Create Table

2001-01-24 Thread PEREZ, RICHARD RINGO (SBCSI)
It should be "Votes int NULL" instead of Votes varchar(4) NULL -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 2:49 PM To: CF-Talk Subject: SQL Create Table I'm trying to run a SQL query to create a table ... lo

RE: SQL Create Table

2001-01-24 Thread Owens, Howard
, January 24, 2001 3:30 PM To: CF-Talk Subject: RE: SQL Create Table It should be "Votes int NULL" instead of Votes varchar(4) NULL -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 2:49 PM To: CF-Talk Subject: SQL Cr

RE: SQL Create Table Statement

2000-05-18 Thread Troy Johnson
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 10:31 AM To: [EMAIL PROTECTED] Subject: SQL Create Table Statement I am having major cranial flatulence today and can't remember how to write a create table statement. I don't have access to SQL server's book's

RE: SQL Create Table Statement

2000-05-18 Thread Dave Phillips
. Sincerely, Dave Phillips Founder/CEO ResumeBlaster.com a service of PC Pros, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 12:31 PM To: [EMAIL PROTECTED] Subject: SQL Create Table Statement I am having major