RE: SQL 7.0 Question

2000-12-01 Thread Mark Johnson
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

Re: SQL 7.0 Question

2000-12-01 Thread paul smith
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:

RE: SQL 7.0 Question

2000-12-01 Thread Dylan Bromby
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

RE: SQL 7.0 Question

2000-11-30 Thread DeVoil, Nick
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

RE: SQL 7.0 Question

2000-11-30 Thread Zachary Bedell
-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

Re: SQL 7.0 Question

2000-11-30 Thread Todd Ashworth
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

Re: SQL 7.0 Question

2000-11-30 Thread netman
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

RE: SQL 7.0 Question

2000-11-30 Thread Bruce Heerssen
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

RE: SQL 7.0 Question

2000-11-30 Thread Hayes, David
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

Re: SQL 7.0 Question

2000-11-30 Thread Aaron Rouse
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

RE: SQL 7.0 Question

2000-11-30 Thread Simon Horwith
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, #

RE: SQL 7.0 Question

2000-11-30 Thread Clint Tredway
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

RE: SQL 7.0 Question

2000-11-30 Thread David Livingston
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

RE: SQL 7.0 Question

2000-11-30 Thread Hays, Duncan
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

RE: SQL 7.0 Question

2000-11-30 Thread Evan Lavidor
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

RE: SQL 7.0 Question

2000-11-30 Thread Doug Powell
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

Re: SQL 7.0 Question

2000-11-30 Thread Gregory Harris
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:

RE: SQL 7.0 Question

2000-11-30 Thread Bosky, Dave
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

RE: SQL 7.0 Question

2000-11-30 Thread Nardi, Gaston
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

Re: SQL 7.0 Question

2000-11-30 Thread Jamie Keane
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

Re: SQL 7.0 Question

2000-11-30 Thread Jeffry Houser
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

Re: SQL 7.0 Question

2000-11-30 Thread Jeanne Sarfaty Glazer
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

RE: SQL 7.0 Question

2000-11-30 Thread Adkins, Randy
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

RE: SQL 7.0 Question

2000-11-30 Thread Jeff Sarsoun
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,

Re: SQL 7.0 Question

2000-11-30 Thread Marius Milosav
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

RE: SQL 7.0 Question

2000-11-30 Thread Sean Daniels
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

RE: SQL 7.0 Question

2000-11-17 Thread Adrian Cesana
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

RE: SQL 7.0 Question

2000-11-17 Thread Gary Davidson
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

RE: SQL 7.0 Question

2000-11-17 Thread Dave Watts
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