Change it to.
cfquery name="get_auctions" datasource="happytoad"
DELETE auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
Mark
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 4:11 PM
To: CF-Talk
Subje
Nope. Try DELETE FROM
At 11:11 AM 11/30/00 -0500, you wrote:
Is * not the correct syntax for All is SQL 7.0?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
you don't need the NAME attribute of CFQUERY with DELETE. :)
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:12 AM
To: CF-Talk
Subject: RE: SQL 7.0 Question
try
cfquery name="get_auctions" datasource="ha
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
Here is the error:
ODBC Error Code = 37000 (Syntax
DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
Rich
Just lose the star.
The normal DELETE syntax is simply DELETE FROM...
Nick
**
Information in this email is confidential and may be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
/cfquery
Here is the error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL
You don't need the * ... DELETE FROM will work just fine.
Todd Ashworth
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question
| Ok I just did a local upgrade fro
You may want to use FROM instead of from, I am not sure if it is that picky
or not, but * does mean all in SQL 7.0 as well.
Robert
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 11:11 AM
Subje
PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE * from a
I'm guessing auction_id or userid are numeric -- not text -- fields; try
removing the single quotes where appropriate.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local
You are correct, just leave off the *
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 10:11 AM
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
are
1400 16th St NW, # 220
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQ
You do not need the *.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name
Yes, you don't need * when doing a SQL delete statement.
Dave
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great
In Oracle you just use DELETE FROM TABLE. No * is necessary.
Duncan Hays
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
ember 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where auction_id
* from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
You will need to do this on all you DELETE if you have many
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I j
k" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 8:11 AM
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_r
try
cfquery name="get_auctions" datasource="happytoad"
DELETE auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Ques
That's right, don't use the *
Just DELETE FROM ... WHERE ...
Regards,
Gaston
-Mensaje original-
De: ibtoad [SMTP:[EMAIL PROTECTED]]
Enviado el: Jueves 30 de Noviembre de 2000 13:11
Para: CF-Talk
Asunto: SQL 7.0 Question
Ok I just did a local upgrade
x 228 Voice
704.849.9291 Fax
-Original Message-
From: ibtoad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, November 30, 2000 2:24 PM
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement
I'm surprised that statement worked in Access.
The delete statement automatically deletes a whole row. You do not
need to specify a wildcard, or column as you would in a select statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE from auction_records where
I believe the SQL should read:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
(minus the *)
- - - Jeanne
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 11:11 AM
Subje
No the * is not used in SQL 7.0 when using the DELETE function
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works
hursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where auction_
CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
cfquery name="get_auctions" datasource="happytoad"
DELETE * fr
://www.dealforce.com
http://www.dealstream.com
http://www.mergernetwork.com
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works
I know this is a very newbie-like question, but I'm
stuck all the same. I had SQL Server 7.0 installed on
my machine, and I had to nuke my HD and re-install
every last weekend. I burned my Data directory to
a CD before I formatted. Now, I've re-installed
SQL, but I need to know how to get
You should be able to do an ATTACH in sql7. Will be something like this,
but you should look it up and check as there are more options available I
believe.
sp_attach_db @dbname = N'Your_DB_Name_Here',
@filename1 = N'd:\data\mydb.mdf',
@filename2 = N'e:\trans\mydb.ldf'
GO
Also, when you copy
lookup sp_attach_db in BOL.
It may not work if sp_detach_db was not used.
-Original Message-
From: Scott Wolf [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 2:28 PM
To: CF-Talk
Subject: OT: SQL 7.0 Question
I know this is a very newbie-like question, but I'm
stuck all
It can be done, did you burn a backup or the actual data files?
If not, you need to create the database, then stop the SQL Services
Now you need to copy all the files, the database and the transaction files,
to the directories. and name them the exact names as the new ones are
named. Then
lookup sp_attach_db in BOL.
It may not work if sp_detach_db was not used.
I've never had any problem getting sp_attach_db to work without previously
detaching the database. The problem I have run into is that logins from the
old server will still be stored in the attached database, and you
32 matches
Mail list logo