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 ,
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
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,
, 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
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
_
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
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"
-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
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:
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
]]
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
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
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
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
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
, 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
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
.
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
18 matches
Mail list logo