Digital Workshop

I am currently, and quite successfully, sending and retrieving data from a publication via a set of ASP pages to a server SQL database using the Post Web Data action.
Wishing to expand the amount of scripting I use in a production I want to convert these actions into script. I have worked out the basics of InternetPostData but I am a bit stuck on how to retrieve a particular record from the data set.
I currently retrieve a record by sending two variables STUDENT_ID and COURSE_ID to the asp page, and that sends back the rest of the fields in the data record.
I have reviewed previous posts to the forum but none seem to cover this combined sending and retrieving action.
(At the end of the day I could stick to the action I am using, but you don't learn anything that way, do you )

Andy Thompson

04 January 2006 - No replies as yet, this is either regarded as too difficult or far too simple to warrant a reply.

Hey folks...5th January...49 people have viewed this and no-one has posted a reply. DG - maybe others are also wondering how this works and are too afraid to ask!

Hi Andy,

I didn't read your message before (skiïng with Christmas).
Yes I'm also wondering how to use Opus Script to do this, because it's much more flexible than using actions.

Unfortunately at this moment I have no time to do some research.

But maybe others are?

To all who are reading this:

Please help Andy

Kind regards,

Not sure if this helps but I have been successful with using the InternetPostData script function to GET information (InternetGetData has never worked for me!). I posted an example below. Create a new object, I used that object name in the InternetPostData, then had my string of "&ca_user1=John&ca_user1status" in my cgi script populate the LobbyStatus object, with the 'true' option to return data sent in the function. So, basically, I'm sending nothing with the new object created but getting data from my cgi script. Works like a charm!




function GetTableUserStatus(){
var LobbyStatus = new Object()
GetTableUserStatusURL = ""+url+"lobby.php"
var LobbyStatus = InternetPostData(GetTableUserStatusURL,LobbyStatus,true)
ca_user1=LobbyStatus.ca_user1
ca_user1status=LobbyStatus.ca_user1status
}