Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Mar 2005, 18:41
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
help with a query , is this correct ?

here is the query



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


and here is the error i get from it

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


any ideas ?
Reply With Quote
  #2  
Old 22 Mar 2005, 18:58
tnguy3n's Avatar
tnguy3n tnguy3n is offline
 
Join Date: May 2003
Real name: Nguyễn
there's a space in between probid_auctions and b in line

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

maybe that causes the error.
Reply With Quote
  #3  
Old 22 Mar 2005, 19:43
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
afraid that didnt sort it mate
Reply With Quote
  #4  
Old 22 Mar 2005, 19:43
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
you cannot insert into the table you are using within your select query.
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 15:11.

Layout Options | Width: Wide Color: