{"id":39689,"name":null,"username":"Penhall","avatar_template":"/user_avatar/support.jodohost.com/penhall/{size}/81_2.png","created_at":"2006-08-25T21:41:36.000Z","cooked":"\u003cp\u003eThis is something that’s been bothering me for awhile and I figured I’d get off my butt and ask if anyone can shed some light.\u003c/p\u003e\n\u003cp\u003eWhen I’m doing a SELECT * from TABLE statement (on MS SQL at JH using ASP) sometimes fields won’t return their value when I do an rs(“FIELDNAME”) - what I end up doing usually is adding the field name directly to the the SELECT query… eg Select *, MissingField from TABLE\u003c/p\u003e\n\u003cp\u003eThis works sometimes but other times it doesn’t unless I juggle the order of the field names in the query when there are multiple gremlin FIELDS.\u003c/p\u003e\n\u003cp\u003eHas anyone run across this before and is there any advise around this issue that you would share. Suppose I should select each field individually in table-order but I would have thought SQL/ASP would have been smarter than this.\u003c/p\u003e\n\u003cp\u003eAnyway, I’m an admitted self-taught web DB hack who is trying to properly edjumukate myself so any thoughts/insites would be appreciated.\u003c/p\u003e\n\u003cp\u003eCheers\u003c/p\u003e","post_number":1,"post_type":1,"posts_count":5,"updated_at":"2026-08-03T05:50:55.132Z","reply_count":0,"reply_to_post_number":null,"quote_count":0,"incoming_link_count":0,"reads":0,"readers_count":0,"score":0.0,"yours":false,"topic_id":7214,"topic_slug":"select-question","display_username":null,"primary_group_name":null,"flair_name":null,"flair_url":null,"flair_bg_color":null,"flair_color":null,"flair_group_id":null,"badges_granted":[],"version":1,"can_edit":false,"can_delete":false,"can_recover":false,"can_see_hidden_post":false,"can_wiki":false,"user_title":"","bookmarked":false,"raw":"This is something that's been bothering me for awhile and I figured I'd get off my butt and ask if anyone can shed some light.\n\nWhen I'm doing a SELECT * from TABLE statement (on MS SQL at JH using ASP) sometimes fields won't return their value when I do an rs(\"FIELDNAME\") - what I end up doing usually is adding the field name directly to the the SELECT query... eg Select *, MissingField from TABLE\n\nThis works sometimes but other times it doesn't unless I juggle the order of the field names in the query when there are multiple gremlin FIELDS.\n\nHas anyone run across this before and is there any advise around this issue that you would share. Suppose I should select each field individually in table-order but I would have thought SQL/ASP would have been smarter than this.\n\nAnyway, I'm an admitted self-taught web DB hack who is trying to properly edjumukate myself so any thoughts/insites would be appreciated.\n\nCheers","actions_summary":[],"moderator":false,"admin":false,"staff":false,"user_id":848,"hidden":false,"trust_level":1,"deleted_at":null,"user_deleted":false,"edit_reason":null,"can_view_edit_history":true,"wiki":false,"post_url":"/t/select-question/7214/1","reactions":[],"current_user_reaction":null,"reaction_users_count":0,"current_user_used_main_reaction":false,"can_accept_answer":false,"can_unaccept_answer":false,"accepted_answer":false,"topic_accepted_answer":null,"can_vote":false}