Re: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread cf coder
I figured out the problem. Basically what was happenning was, it was deleting the record and re-inserting a new one. That's because I have code just above it that inserts a record if the recordcount is 0. I'm sorry guys for the unnecessary hassle. Best regards, cfcoder [Todays Threads] [This Me

Re: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread Jochem van Dieten
cf coder wrote: > > I have a form with a cancel button. You mean ? That is a client side action, it doesn't touch anything on the server. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread cf coder
look directly into the > database?  Or does it tell you on the processing page? > >    > - Original Message -    > From: cf coder    > To: CF-Talk    > Sent: Wednesday, June 16, 2004 10:35 AM    > Subject: Re: why doen't sql delete work if it is followed w

Re: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread brobborb
-   From: cf coder   To: CF-Talk   Sent: Wednesday, June 16, 2004 10:35 AM   Subject: Re: why doen't sql delete work if it is followed with a cflocation tag   yes I am. If I run the query in sql analyser it deletes the row. [Todays Threads] [This Message] [Subscription] [Fast Unsubs

Re: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread cf coder
yes I am. If I run the query in sql analyser it deletes the row. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread Burns, John D
Just a comment, but you don't need the around the John -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 11:16 AM To: CF-Talk Subject: Re: why doen't sql delete work if it is followed with a cflocation tag Are you looking directl

Re: why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread brobborb
Are you looking directly into the database to see if data was deleted or not?   - Original Message -   From: cf coder   To: CF-Talk   Sent: Wednesday, June 16, 2004 10:18 AM   Subject: why doen't sql delete work if it is followed with a cflocation tag   Hello everybody,   I h

why doen't sql delete work if it is followed with a cflocation tag

2004-06-16 Thread cf coder
Hello everybody, I have a form with a cancel button. When the user hits the cancel button, I want to perform a sql delete.. immediately after that I want to redirect the user. Here is the code: eq 1> delete from table1 where lvalue ='12345' url=""> addtoken="no"> When I ru