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
er, assigning the script to a variable first and then using it within the CFQUERY tags produces the same 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
Subj
dump the "BEGIN" and "END"
UPDATE SYSTEMINFO
SET LOGINPAGEMESSAGE = 'Welcome to here'
WHERE DATACALL = 2
-Original Message-
From: Semrau Steven Ctr SAF/IE [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 1:18 PM
To: CF-Talk
Subject: Nee
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):
BEGIN
UPDATE SYS
>>If you are on access, the outer join won't work and you have to do a union:
Sorry...that's not true. Access supports outer joins, but the syntax is either RIGHT
JOIN or LEFT JOIN rather than OUTER JOIN.
>>Conversely if bugs.bug_type_id = 0 then simply add that statement to the query. .
Azeem,
ssage-
From: Azeem Huda [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 7 januari 2003 14:35
To: CF-Talk
Subject: RE: newbie: help with sql query
Jochem,
When i updated my query to your second version below i get:
Syntax error (missing operator) in query expression 'CASE WHEN
bugs.bug_type_id =
CAST also, cannot convert or change the datatype of certain datatypes to
others, there are some limitations to it.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:51
To: CF-Talk
Subject: Re: newbie: help with sql query
Azeem Huda wrote
Azeem Huda wrote:
>
> Syntax error (missing operator) in query expression 'CASE WHEN
> bugs.bug_type_id = 0 THEN CAST (0 AS VARCHAR) ELSE bug_type.bug_type'.
Sounds like your database does not have support for CASE statements. You
need to check the manual for some other type of IF support.
> C
velopment i
am using Access2000 but will be changing to SQL2000 soon, so the bug_type
field is simply "text".
Thanks again.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:07
To: CF-Talk
Subject: Re: newbie: help with sql query
Az
Azeem Huda wrote:
>
> I have the following query and was hoping that someone could help me out.
> I am trying to retrieve a field named bug_type in another table (bug_type)
> IF the bugs.bug_type_id != 0 (since i know that bug_type.bug_type_id does
> not exist). Conversely if bugs.bug_type_id = 0
Hi,
I have the following query and was hoping that someone could help me out.
I am trying to retrieve a field named bug_type in another table (bug_type)
IF the bugs.bug_type_id != 0 (since i know that bug_type.bug_type_id does
not exist). Conversely if bugs.bug_type_id = 0 then simply add that
sta
ailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 10 December 2002 12:28 p.m.
> To: CF-Talk
> Subject: HELP with SQL
>
>
> HELP, I keep getting this error. on the CFMX administrator:
>
>
>
> Connection verification failed for data source: contacts
> []java.sql.SQLExceptio
HELP, I keep getting this error. on the CFMX administrator:
Connection verification failed for data source: contacts
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause w
> I'm trying to run a query than uses the IN operator in a way I've not come
> across before:
> dbtype="#request.DB_type#" username="#request.DB_username#"
> password="#request.DB_password#">
> SELECT title
> FROM content
> WHERE 23 IN (keywordIDs)
> AND 12 IN (keywordIDs)
>
> So, instead
ld may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 11:14 AM
To: CF-Talk
Subject: OT: help with SQL 'IN'
I'm trying to run a query than uses the IN operator in a way I've not come
across before:
SELECT title
FROM content
WHERE 23 IN (keywordIDs)
AND 12 IN (keywordIDs)
So, instead of saying "WHERE [a certain field] IN ([comma-separated list of
dynamic values])", I'm looking for records where a
I know this is a little OT, but i have been looking at this for hours and cannot see
what the actual error is.
Can someone look at this MSSQL trigger and tell me where the error is? i know it is
around the if statements i commented around, but cannot figure out what the syntax
error is!
Thank
> I have converted a access database to sql server 7.0 my
> tables have not changed but everytime i try and access any
> page that has a database call i recieve the following error
>
> ODBC Error Code = S0002 (Base table not found)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid obj
try...
where ID IN (4,5,6)
"Neo Fusion" <[EMAIL PROTECTED]> wrote:
I have converted a access database to sql server 7.0 my tables have not
changed but everytime i try and access any page that has a database call i
recieve the following error
ODBC Error Code = S0002 (Base table not found)
[Mic
t;http://www.biznet-solutions.com/>
-Original Message-
From: Neo Fusion [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 05:08
To: CF-Talk
Subject: Help with sql server
I have converted a access database to sql server 7.0 my tables have not
changed but everytime i try and acce
Try prefixing your table name with the database.owner
e.g. FROM mydatabase.databaseowner.report2s
-Original Message-
From: Neo Fusion [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 05, 2001 10:08 PM
To: CF-Talk
Subject: Help with sql server
I have converted a access database to sql
I have converted a access database to sql server 7.0 my tables have not
changed but everytime i try and access any page that has a database call i
recieve the following error
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'repo
I have a template that strips out HTML code from a string. It then takes the
first 255 chars to create a blurb that is used as a summary in a verity
collection. When I try to insert the blurb in the DB, I get the following
SQL error:
ODBC Error Code = 37000 (Syntax error or access violation)
[ME
> I'm doing a select from three tables, and my query is timing out. The
> problem is probably coming from the fact that there is not always a
> record in the m.POS_ARC_HEADX table. Is there a way to restructure this
> query so it still checks the m.POS_ARC_HEADX but does not die if no
> record e
I'm doing a select from three tables, and my query is timing out. The
problem is probably coming from the fact that there is not always a
record in the m.POS_ARC_HEADX table. Is there a way to restructure this
query so it still checks the m.POS_ARC_HEADX but does not die if no
record exists? Is
bear; some days the bear eats you.
> -Original Message-
> From: chad jackson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 16:21
> To: CF-Talk
> Subject: help with sql query/CF
>
>
> Hi
Hi,
SELECT DISTINCT fruit, count(fruit) AS fruitcount
FROM greengrocer
GROUP BY fruit
ORDER BY fruit
HTH,
Chris
--Original Message--
From: "chad jackson" <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: January 25, 2001 11:39:49 PM GMT
Subject: help with
Select fruit,count(fruit)
>From greengrocer
Group By fruit
John Anderson
http://www.aloha-webdesign.com
-Original Message-
From: chad jackson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 3:40 PM
To: CF-Talk
Subject: help with sql query/CF
Hi,
I have a standard qu
Hi,
I have a standard query like:
SELECT fruit
FROM greengrocer
ORDER BY fruit
Which returns
apple
apple
bananna
pineapple
pineapple
pineapple
How do I get sql/cold fusion to return
apple (2)
bananna (1)
pineapple (3)
Any help would really be appreciated
thanks
chad
~~~
Hi,
I have a standard query like:
SELECT fruit
FROM greengrocer
ORDER BY fruit
Which returns
apple
apple
bananna
pineapple
pineapple
pineapple
How do I get sql/cold fusion to return
apple (2)
bananna (1)
pineapple (3)
Any help would really be appreciated
thanks
chad
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 s
>
>
> CREATE TABLE Country
>(
> CountryID Integer Identity Primary Key,
> Country VarChar(50),
> Code_2 VarChar(2),
> Code_3 VarChar(3),
> Code_Numeric
ction 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:
>
snip
~~~
t; <[EMAIL 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
, 2001 8:40 PM
Subject: Re: Need Help with SQL!!
> you can do it with a cfquery:
>
>
>
>
> CREATE TABLE Country
>(
> CountryID Integer Identity Primary Key,
> Country VarChar(50),
>
ed a connection 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:
CREATE TABLE Country
(
CountryID I
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:
CREATE TABLE Country
(
CountryID
you can do it with a cfquery:
CREATE TABLE Country
(
CountryID Integer Identity Primary Key,
Country VarChar(50),
Code_2 VarChar(2),
Code_3 VarChar(3),
Code_N
lk" <[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
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
Create a dsn on your machine pointing to there sql server and the database
for starters.
-Original Message-
From: Dominic Hess [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 1:11 AM
To: CF-Talk
Subject: Need Help with SQL!!
Ok having a big problem...
Need to get away
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
Using a UNION did the trick. Thanks for the tip.
Gary
- Original Message -
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 8:21 AM
Subject: RE: Help With SQL Query
> Well, the problem is
you give us a little more information, we might be able to recommend some
alternatives.
Some options:
1) Use a UNION
2) Use 2 queries
-Original Message-
From: Gary Groomer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 10:08 AM
To: CF-Talk
Subject: Help With SQL Query
I
I have two tables from which I want the sum of the columns based on a common
key. From the below tables, the desired output is 3,5,1,2. Instead I get
6,10,6,3. I am sure the solution is simple, but I haven't run into this one
before and any help would be appreacited.
Gary
Table1
---
Table
#ShowEvents.ThemeName[1]#
Dan
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 8:59 AM
To: [EMAIL PROTECTED]
Subject: Help with SQL
I have 2 tables with a One (MonthlyTheme) to Many (Events) relationship. I
want to be able to
: Help with SQL
I have 2 tables with a One (MonthlyTheme) to Many (Events) relationship. I
want to be able to select Programs within a certain range and to also
isolate the ThemeName with one query. The cfoutput below gives multiple
displays of the same ThemeName equal to the number of records. I
I have 2 tables with a One (MonthlyTheme) to Many (Events) relationship. I
want to be able to select Programs within a certain range and to also
isolate the ThemeName with one query. The cfoutput below gives multiple
displays of the same ThemeName equal to the number of records. I just want
it to
>
>
> --K
>
> -Original Message-
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 14, 2000 3:52 PM
> To: [EMAIL PROTECTED]
> Subject: Help with SQL
>
>
>
> I have a date and time field in the form of 8/14/00 in an Acc
In SQL server there is a month function, i.e. month(getdate()) or month(mydate).
Access may have the same function. If you are going to be ordering them,
remember to take the year into account if it spans the end of a year.
David
sebastian palmigiani wrote:
>
> I have a date and time field in t
You use the SQL DatePart function
select DatePart(mm, columnname) as month
from foo
--K
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 3:52 PM
To: [EMAIL PROTECTED]
Subject: Help with SQL
I have a date and time field in the
I have a date and time field in the form of 8/14/00 in an Access database. I
want to be able to select out the distinct months in all the fields. It
seems that I can't do that.
Do I have to redo the database and separate the month? Or do I have to
process the query with some kind of CF code?
Se
52 matches
Mail list logo
