This is a simple and quick project for someone that knows JSON and ASP.
I simply need to have a CLASSIC ASP script that will read a JSON POST and then insert the data to a SQL database.
Here is the sample JSON post
[login to view URL]
The POST may contain up to 1000 events. For each type "blacklist", I need to insert them into a SQL database like this.
SQLStmt = "INSERT INTO s_EmailBlacklist(Email,Reason,Detail,EventDate) "
SQLStmt = SQLStmt & "VALUES ('" & [login to view URL]("email")
SQLStmt = SQLStmt & "','" & [login to view URL]("reason")
SQLStmt = SQLStmt & "','" & [login to view URL]("detail")
SQLStmt = SQLStmt & "','" & formatdate(now(), vbshortdate)
I've tried implementing it using the suggestion at [login to view URL]
but, it's not reading the values. It's probably something stupid that I'm doing but I can't figure it out.
I will fix it for you and also I will explain it to you about how to do it later, we could use a json library if you want or make it with a library you choose
chat with me anytime
$25 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
2 freelancerzy składają oferty o średniej wysokości $25 USD dla tej pracy
Hello,
Yeah i'm sure it's something simple. I'd need to take a look at your script. Shouldn't take longer than an hour if the post is returning data. Otherwise, you might have bigger issue on your hands.