What does the error look like? My guess is you can save the HTML returned and look for some key words like:

Try Again
Invalid Password
Not Authorized

Actually, I'm working with a java application, and the list box is a swing control from which you pick dates. Although there are a limited number of dates within the available choices, you cannot predict what the presented choices will be. There is no way so simply enter the date, it must be selecte...

Hi, Is there a limit as to how much data can be passed from VB to MS? For instance, I'm working with 16 columns that add up to probably no more than 80 chars total, there is no problem. However, some of my tables contain a lot more data than that for each record. What are my practical and theoretica...

Gotcha - I added this to my script: MessageModal>RValue[%k%] MessageModal>elements_%k% and both worked like a charm. This is the part that is missing in your help file, I would suggest the addition of a warning that displaying array values with text will prevent the value from displaying, and that t...

Your solution worked but it is still ..... I could use a little more robust solution, specifically, to place the values in an array. I tried this: Repeat>k Let>k=k+1 Let>the_element=elements_%k% Let>RValue[%k%]=the_element MessageModal>List item %k% %CRLF% the_element is %the_element% %CRLF% RValue ...

Thanks both!

Your support is great, thanks.

Yeah, the "file_names_%k%" is in there alright. I thought it looked a little funny. I will try your approach, makes sense, I appreciate it.

Tx,

George

I found that this code from above: MessageModal>%Record% GetFileList>Record,files Separate>files,;,file_names MessageModal>Num Files: %file_names_count% Let>k=0 Repeat>k Let>k=k+1 Message>List item %k% -> file_names_%k% -->file_names_1 Until>k,file_names_count should not use GetFileList, so I change...

Hi, I query from a db using VBScript, and place a record in the return variable. I've tried a couple of delimiters, ~ and ; but I get the same results. Here is the offending code, pretty much stripped off the help file: MessageModal>%Record% GetFileList>Record,files Separate>files,;,file_names Messa...

Hi, This VB code causes two errors: Function GetTimeEntry(SerNum) Dim SQLString Dim AcctNum Dim SerNum set MyDB = CreateObject("ADODB.Connection") MyDB.Open "GATER" SQLString = "SELECT time.* FROM [time] where time.serial = '" & SerNum & "';" 'MsgBox SQLString set rsTime = MyDB.Execute(SQLString) If...

For clarity,

BEGIN DBRECORD LOOP

--Query DB
--Select
--Pass value back to MS

--BEGIN DBCOLUMN LOOP

----Do stuff to record
----Put it in another application

--NEXT DBCOLUMN

NEXT DBRECORD

Hi, I've looked at the ODBC via VB script on the page, and I'm going to try it out, but I already see one need for change. The subroutine CONNECTS, QUERIES, CLOSES ... In my application, I'm going to do something like this: BEGIN DBRECORD LOOP Query DB Select Pass value back to MS BEGIN DBCOLUMN LOO...