how to create api and use creating Web API like Twitter API

Question

Hi,
 
I am developing a project where user will come and write their opinions and comments on some employers with their scores such as good, bad, excellent, etc. and this data needs to be shown on all the clients websites with those actual data with the scores e.g. good, bad, excellent, etc. for example I have got 100 employers in the database and all the employees of those 100 companies will come and write their scores on a single website and then my role is to show the real data related to that particular company to their website. And I am not allowed to show the x company;s data on y company's website. Meaning thereby, XYZ-employer should get the real data related to XYZ employer and not of the ABC employer and ABC employer should get only ABC related data.
 
So how would I perform that functionality? what are the possible alternatives or the different different methods for achieving that.
 
Will it be like creating Web API like Twitter API or Facebook API? which shows the likes or tweets related to that login account.
 
Please suggest ASAP. Thanks in advance.

Answer 1

Correct sSql string is follows..
sSQL = "Insert into Transaction_Line (TransL_id,Trans_id, TL_dt, Pro_id, Quantity)" & _
"values('" & TransLid & "', '" & transID & "', '" & TLdte & "', '" & proID & "', '" & quan & "')"

Change transID Position in values it will be in 2nd position.
 

Answer 2

hi

i think you have taken date field value int not datetime or varchar . That's why you are getting this error.

please change it to datetime.

Don't forget to Mark Do you like this Answer  that solved your problem!

Answer 3

TransL_id: Varchar(25)
Trans_id: int
Pro_id: Varchar(15)
Quantity: numeric(4, 0)
Total_price: numeric(10, 2)
TL_dt: varchar(50)
Share_h_id: varchar(10)

For the TL_dt  tried a dateandtime format but its not working at all it always retrieves an error... therefore i tried the varchar instead

Answer 4

Hi,
The error is  coming due to this sentence,
sSQL = "Insert into Transaction_Line (TransL_id,Trans_id, TL_dt, Pro_id, Quantity)" & _
"values('" & TransLid & "', '" & TLdte & "', '" & proID & "', '" & quan & "', '" & transID & "')"
 
In that u r trying to insert..
TransL_id (int)- > TransLid (int),
Trans_id (int) - > TLdte (date),
TL_dt (date) -> proID (int),
Pro_id - > quan ,
Quantity - > transID

Answer 5

Can you also post Transaction_Line table structure (Fields with DataType) ?