If it works when it's all on one line, why not just set the script (nicely
formatted) to a cf variable, then run replace on the line breaks, then use
the variable?
- Original Message -
From: Semrau Steven Ctr SAF/IE
The problem, in a nutshell, is that we (dba and me) have very limited
: Need Help with SQL inside CFQUERY
Okay, I'm new to doing straight SQL inside of a CFQUERY tag so any and all
advice / help is greatly appreciated - here is what I'm running into:
My DB guy wants (reasons I can't explain) me to run some SQL with the
CFQUERY tag.When I run the code below
resulting error.
I guess I should also mention this is a CF5 box.
-Original Message-
From: J E VanOver [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 4:46 PM
To: CF-Talk
Subject: RE: Need Help with SQL inside CFQUERY
dump the BEGIN and END
cfquery name=myName datasource
Okay, I'm new to doing straight SQL inside of a CFQUERY tag so any and all advice / help is greatly appreciated - here is what I'm running into:
My DB guy wants (reasons I can't explain) me to run some SQL with the CFQUERY tag.When I run the code below as is (multiple lines):
cfquery name=myName
cfquery...
CREATE TABLE Country
(
CountryID Integer Identity Primary Key,
Country VarChar(50),
Code_2 VarChar(2),
Code_3 VarChar(3),
Code_Numeric
Dominic, you go to www.factorxsoftware.com/download.cfm and download my WebSQL SQL
Server Tool. This is a web based SQL Server Manager. It is still in beta but you can
add tables, view data, add/modify stored procedures. I am still in the process of
finishing the app but it can help you as it
Ok having a big problem...
Need to get away from Access databases, I had my web host create a SQL Database for
me. They have SQL Server 7. My problem is, I have no idea how to add tables to it. I
was told I can use Visual Interdev, well I do own that but have never used it. Can
anyone help me
y, January 24, 2001 1:11 AM
To: CF-Talk
Subject: Need Help with SQL!!
Ok having a big problem...
Need to get away from Access databases, I had my web host create a SQL
Database for me. They have SQL Server 7. My problem is, I have no idea how
to add tables to it. I was told I can use Visual Inte
ot; [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 7:46 PM
Subject: RE: Need Help with SQL!!
First try the native tools supplied with SQL Server, which would be
Enterprise Manager if you like a graphic interface, or Query Analyzer if
you
like a command line. Both of these tools are found
you can do it with a cfquery:
cfquery...
CREATE TABLE Country
(
CountryID Integer Identity Primary Key,
Country VarChar(50),
Code_2 VarChar(2),
Code_3 VarChar(3),
Very good I didnt think of that one.
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:41 PM
To: CF-Talk
Subject: Re: Need Help with SQL!!
you can do it with a cfquery:
cfquery...
CREATE TABLE Country
though.
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:41 PM
To: CF-Talk
Subject: Re: Need Help with SQL!!
you can do it with a cfquery:
cfquery...
CREATE TABLE Country
(
CountryID
yeah thats what im going to do, screw it ill just make my own control panel
to add tables and remove them. Thanks for the email!
- Original Message -
From: "Dick Applebaum" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 8:40 PM
Su
PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, January 24, 2001 1:11 AM
Subject: Need Help with SQL!!
Ok having a big problem...
Need to get away from Access databases, I had my web host create a SQL
Database for me. They have SQL Server 7. My problem is, I have no id
-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:41 PM
To: CF-Talk
Subject: Re: Need Help with SQL!!
you can do it with a cfquery:
snip
~~
Structure your ColdFusion code with Fusebox. Get the official book
15 matches
Mail list logo