Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Mar 2005, 20:59
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
INSERT TABLE isn't allowed in FROM table list

have an error on a non vb project im working on this is the error

INSERT TABLE 'auctions' isn't allowed in FROM table list


any one tell me what is wrong ? thanks
Reply With Quote
  #2  
Old 19 Mar 2005, 21:03
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
You can not use a table in the from clause if you are inserting into the same table.

Not sure if this is changed is later MySQL versions.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 19 Mar 2005, 22:18
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
its basically an auction scrip , the error comes after an auction is over and i press the relist auction button which should send the data back into the databse and thus relisting the item how ever thats the error i get

any more ideas?

Last edited by corsacrazy; 20 Mar 2005 at 16:25. Reason: Automerged Doublepost
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:00.

Layout Options | Width: Wide Color: