1

I have been a long time user of Stack Overflow and have just today signed up to post a question. The question description is quite long, does not reference any outside sites, but when I go to post it, I get a message saying "This looks like spam".

All of the detail in my question is necessary for full understanding of the problem, so how do I get this question posted? I can send the question detail, or if your system saves the question before it is actually posted, then you can look at my only question entitled "SQL tricky query to update contact id".

I have made the following screenshots:

...

What do I need to do so I can post my question on Stack Overflow?

17
  • Can you post a screenshot of the question details? – Taryn Aug 6 '15 at 18:29
  • I am about to post links to 4 screenshots, just a sec... – Kershaw Aug 6 '15 at 18:38
  • 1
    Seems reasonable enough for the most part; I'd suggest trimming a bit of the fluffiness in the closing paragraph ("thx" and "still with me" and so forth) but that shouldn't be triggering spam. Maybe the lack of code formatting for those tables is hurting you. – Nathan Tuggy Aug 6 '15 at 18:45
  • Removing a little bit of fluff didn't help. How would I "code format" the tables? Thx – Kershaw Aug 6 '15 at 18:48
  • Haha, I'll simply post the screenshots. Great idea... – Kershaw Aug 6 '15 at 18:49
  • Actually, will having simply links to the screenshots put some ppl off and maybe they will skip the question? – Kershaw Aug 6 '15 at 18:50
  • You might want to have a look at meta.stackexchange.com/editing-help – rene Aug 6 '15 at 18:50
  • Yes, we meant to edit them in the question here on meta! – rene Aug 6 '15 at 18:51
  • I tried posting the entire SO question into this Meta question only to exceed posting limits by a few thousand characters! – Kershaw Aug 6 '15 at 18:52
  • Can a SO moderator look at my pending question and simply accept it?? – Kershaw Aug 6 '15 at 18:53
  • There is no such thing "pending question" and moderator can't help you bypass spam filters – Shadow Wizard is Vaccinating Aug 6 '15 at 19:00
  • Thx for the edit rene. – Kershaw Aug 6 '15 at 19:02
  • So, I tried editing those links into my SO question, but need 10 rep pts. I guess I need to go answer some questions first? – Kershaw Aug 6 '15 at 19:05
  • Ambulance chasing? What does that comment have to do with anything? – Kershaw Aug 6 '15 at 19:10
  • So, is it fair to say that SO validations are a bit too restrictive given the contents of my question are perfectly legit?? – Kershaw Aug 6 '15 at 19:15
5

I would be very happy that you couldn't post that. I really don't think that question will be well received in its current form. It is way too broad and it tries to address two problems instead of one.

So first split your question into TWO separate ones.

The first one will be about the insert in the tblInquiry and the contacts. Something like this:

I have the table tblInquiry

id |  name | lots of other fields 
--------------------------------
1  |  foo  |  blah

I have the table tblCustomer

id  | custname | lots of other fields
-----------------------------------
101 | Bar      | blieb

To update inquiry I want to execute the following query

insert inquiry 
select id, custame
from customer 
where awesome where clause

This gives an error/ wrong data / performs bad.

I have a sqlfiddle prepared so you can try the query your self.

What can I do to prevent the error/fetch the correct data/ improve performance?

A similar approach should be followed for the other issue. You can supply the background information about how you got into this problem as a link but it doesn't need to be in the question.

Make sure to read the editing and formatting topics in the [help] as it contains guidance on how all the editing features work.

Also revisit How to ask, specially all the linked material at the end of that help topic. For the code parts you might want to study How to create a Minimal, Complete, and Verifiable example

4
  • I agree that the question really is 2 questions. But the background info is necessary to understand the issue and how it got to be this way. I will try to pare it down. – Kershaw Aug 6 '15 at 19:20
  • 1
    I understand you think it is relevant but do you think it makes any difference to the technical challenge if a developer, the son of the boss or your neighbor wrote that code/invented the datamodel? – rene Aug 6 '15 at 19:23
  • True. I am rethinking my question and will try to post it with its bare essentials and some proper formatting. – Kershaw Aug 6 '15 at 19:32
  • Yay, see cleaned up question here: stackoverflow.com/questions/31864545/… – Kershaw Aug 6 '15 at 19:49

Not the answer you're looking for? Browse other questions tagged .