I am using Version 8.0.3e with Microsoft Visual Basic Scripting Edition.

I hear what you say about the VBScript. But all the script does is retrieve a name from the database. It does this successfully. The next thing the VBScript does is to store a value in the database. It also does that successfully too. Then, Macro Scheduler increments the counter k ready to loop arou...

I changed the code to protect my privacy on some stuff. I don't have a site at mysite.com for example. It is a different URL. Was this taken into consideration? And MyDB.Open "free_MyArticles" ...free_MyArticles is a MySQL connection using ODBC.

I did run vbstart and vbend - I just didn't post all the code. The whole lot is below: VBSTART Function GetCustomerName(ArticleID) Dim SQLString set MyDB = CreateObject("ADODB.Connection") MyDB.Open "free_MyArticles" SQLString = "select * from Articles where id = " & ArticleID ' msgbox sqlstring set...

I have am having a problem with the script just crashing when I get to the Until statement at the end. Is this a bug or something wrong with my code? Let>k=560 Repeat>k Let>ArticleID=k VBEval>GetCustomerName("%ArticleID%"),ArticleIDNumber StringReplace>ArticleIDNumber, ,%20,ArticleIDNumber HTTPReque...

Oh wow Bob that's a great bit of code. Thank you! Just what I am looking for.

I have used HTTPRequest to store a webpage into a variable. Now I want to store the text between the tags into a variable. How can I do that?

Should I be using some of the code from webrecorder?

There is a library function with ExtractTag. Can I use that on a variable or something?

Thanks,

The code below is not working. I get a "Not Acceptable" message. It works if I remove the %20 and just have DogFood. But it is part of the url so I can't, can I? How can I get around this problem? Thanks, Jon Let>KeywordPhrase=Dog%20Food HTTPRequest>http://mysite.com/cgi-bin/script/script.cgi/?keywo...