You should probably replace all the " with ' as well. " is for identifiers (column/table names, etc.). ' is for strings.
--- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Keith Medcalf > Sent: Friday, 06 July, 2012 13:29 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Inserting from another table... > > > Does saying what you want to do this way work better? > > insert into PP_VIEWER_SETTINGS > (COMPANY_NAME, DSPNEXTPREVIOUS, ENABLE_CARTS, ENABLE_DEBUGINFO, > ENABLE_FAVORITES, ENABLE_RIGHTCLICK, ENABLE_SLIDESHOW, > ENABLE_TIMEOUT, EXIT_KVS, EXIT_PASSWORD, IS_CART_FAVORITES, > IS_LOGIN_REQUIRED, IMAGE_SIZE, PHONE_NUM_FORMAT, THEME_ID, > THUMBNAIL_SIZE, TICKER_MSG, TO_AFTER, TO_STARTS, > TO_TRANSITION_SECS, SS_COUNT, SS_DEFAULT_IS_IN_SLIDESHOW, > SS_DISPLAY_SECONDS, SS_ZOOM_FACTOR, USERLAN) > select (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "Company"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "DspNextPrevious"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "EnableCarts"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "EnableDebugInfo"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "EnableFavorites"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "EnableRightClick"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "EnableSlideShow"), > 1, > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "ExitKvs"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "ExitPassword"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "IsCartFavorites"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "IsLoginRequired"), > 900, > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "PhoneNumberFormat"), > 0, > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "ThumbnailSize"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "TickerMsg"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "TimeoutAfter"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "TimeoutStarts"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "TransitionSeconds"), > 0, > (select ItemValue from dblookup where Category = "SlideShowSettings" > and ItemName = "DefaultIsInSlideShow"), > (select ItemValue from dblookup where Category = "SlideShowSettings" > and ItemName = "DisplaySeconds"), > (select ItemValue from dblookup where Category = "SlideShowSettings" > and ItemName = "ZoomFactor"), > (select ItemValue from dblookup where Category = "KvsSettings" and > ItemName = "USERLAN"); > > --- > () ascii ribbon campaign against html e-mail > /\ www.asciiribbon.org > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
