http posts

[bryantbeau]

I am developing a LabView interface to insert data into a database with mySQL. I have used the the "example_http_protocols.llb" (the POST vi) as an example which is very good. I have been able to insert data into one column of my database table but I have not been able to add data to all the columns. The mySQL statements are correct since I can update all the columns of my table via a webpage. In the "example_http_protocols.llb", one textbox is used that is named "cccc". What would I need to do if I had two textboxes that needed filled before submitting? If I perform two separate posts, I have two separate insertions into my table. I may be able to change  my php and SQL code, but I'm hoping there's an easy fix. (not buying the toolkit)

[Dennis_Knutson]

I don't know what example you are referring to. You should provide a link or the actual code if you need help with it.

You should also consider using LabSQL if you do not wish  to purchase the database toolkit. This and other examples posted here use ADO just like the toolkit. Seems like that would be more effecient than posting to a web page which in turn probably use ADO to write to the actual database.

[bryantbeau]

Thanks for the tips. I found an error in my http message. Now everything works fine. In this project I have a website that a user can manually enter and manipulate data in the database as well as having LabView directly update the database. The website posts to a php script that contains mySQL code. My LabView code posts to the php script as well. With how little LabView code it actually takes, I don't know why you would do it differently, unless you wanted an easy way to query the database through LabView. In my case a website works best since not everyone accessing the database will have LabView.