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
Subject: SQL 7.0 Question
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
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 from Access 2000 to SQL
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
Subject: SQL 7.0 Question
No, just remove the asterisk (*) and it should work fine. In delete queries, it
is assumed that you want to delete all records that match the criteria in the
WHERE clause, unless you explicitly specify which fields to delete.
-- Bruce
-Original Message-
From: ibtoad [mailto:[EMAIL
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
works great except
I believe you want:
cfquery name="get_auctions" datasource="happytoad"
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
in other words, you don't want that asterisk.
~Simon
Simon Horwith
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, #
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
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
If you're deleting, you don't need the "*". SQL Server understands that you
want to delete the whole row just by saying "DELETE FROM tablename where
something = 'somethingelse'".
Evan
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11
Take out the * in the Query in SQL all you need is
cfquery name="get_auctions" datasource="happytoad"
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
Instead of
cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where
Your statement for SQL would be:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
(basically delete the "*")
Gregory Harris
Web Developer
Stirling Bridge Group LLC
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent:
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 Question
Ok I just did
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
Try just DELETE FROM table WHERE conditions
You'd have to use UPDATE to delete/mangle individual cell data, so the * in
the previous statement is unnecessary. :)
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559
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
Subject: SQL 7.0 Question
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
Why the * ?
cfquery name="get_auctions" datasource="happytoad"
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery
If your 'deleting' your all of the record anyway.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30,
You don't need * in a delete statement
try
delete auction_records where auction_id='#id#' and userid='#userid#'
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL
The statement should be:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
- Sean
Sean Daniels
Manager, Engineering
Marketplace Technologies
(t) 207.439.6030
(c) 207.332.6340
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
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
29 matches
Mail list logo