Database: assign variables as fields of the table

Volgar · **Joined:** March 4th, 2007, 7:17 pm **Posts:** 132

Code:

var db = new Database("FILEDSN=bsff.dsn"); 
var records = db.ExecuteSQL("SELECT * FROM `table1`WHERE `problem` = pr_load  ORDER BY `id` DESC"); 
var num_records = records.GetNumberOfRecords(); 
for (num=0; num< num_records; num++) { 
   ap[num] = records.aspect;
   records.NextRecord(); 
}

And then listbox to display:
<ap[0]>
<ap[1]>
<ap[2]>
.......

Lar_123 · **Posted:** May 11th, 2008, 12:13 pm

I still don't know if anything is set-up to execute your code... for example is it part of a function() and you are calling it with some Button.

It just seems to me that your variable
'pr_load' has no initial value that matches 'pr' field, AND... either nothing is changing 'pr_load' value or initiating your code (except when page first starts).

Use debug.trace to see what 'pr_load' is doing. Or set your script console to come up on Preview... and look at the watch-variable Tab there (hint: right click to choose your variable).

I am out of ideas.

Digital Workshop

Database: assign variables as fields of the table

Who is online