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