Post by benjamin1 on Jan 24, 2008 20:48:43 GMT -5
hello,
i'm adding code to have rb get my sql data and create a table with it. When I add the caption and column heading lines of code I get and error screen (white screen with a bunch of error info on it). After this I am unable to go back to the code and fix the error. I have to exit the browser and re start it. Here is my code.
here is the error info.
Debug Full Stack
Subscript out of bounds:
Array(Object)>>subscriptBoundsErrorFor:index:
self #(nil)
temps
t1 #at:
t2 2
Array(Object)>>at:
self #(nil)
temps
t1 2
TableElementFactory>>renderOn:item:columnPosition:rowIndex:
self a TableElementFactory
temps
t1 a Seaside.WARenderCanvas
t2 '1,001,00123,0012,D12-100,,New,5707,Jan 23, 2008,,,,,'
t3 2
t4 1
t5 nil
inst vars
clsBlock BlockClosure [] in Director>>assignObjectByName:toBe:
caption 'Master Inventory List'
array Name: invlist$( type: string number of dimensions: 2 specifiication: OrderedCollection (100 13)
columnNames OrderedCollection ('Record ID')
flip nil
firstRange (0 to: 100)
secondRange (0 to: 13)
deviceHandle '#inv'
cssClass nil
trClass nil
tdClass nil
thClass nil
captionClass nil
columnHandlers #(nil)
sub nil
clickParameter nil
director a BranchingProgramDirector
optimized [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
self BlockClosure [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
temps
self a TableElementFactory
t1 a Seaside.WARenderCanvas
t5 1
t4 0
t2 nil
t3 nil
inst vars
method CompiledBlock [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
outerContext nil
copiedValues #(a TableElementFactory a Seaside.WARenderCanvas 1 0 #(1 2))
BlockClosure>>renderOn:
self BlockClosure [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
temps
t1 a Seaside.WARenderCanvas
inst vars
method CompiledBlock [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
outerContext nil
copiedValues #(a TableElementFactory a Seaside.WARenderCanvas 1 0 #(1 2))
i'm adding code to have rb get my sql data and create a table with it. When I add the caption and column heading lines of code I get and error screen (white screen with a bunch of error info on it). After this I am unable to go back to the code and fix the error. I have to exit the browser and re start it. Here is my code.
'select all fields in table
query$ = "select * from inventory order by rid;"
#mySQLdb execute(query$)
dim invlist$(100,13)
while #mySQLdb hasanswer()
result$ = #mySQLdb nextrow$(",")
'Create table with data
invlist$(r,0)=result$
r=r+1
wend
#mySQLdb disconnect()
table #inv, invlist$()
#inv columnnames("Record ID")
#inv caption("Master Inventory List")
render #inv
here is the error info.
Debug Full Stack
Subscript out of bounds:
Array(Object)>>subscriptBoundsErrorFor:index:
self #(nil)
temps
t1 #at:
t2 2
Array(Object)>>at:
self #(nil)
temps
t1 2
TableElementFactory>>renderOn:item:columnPosition:rowIndex:
self a TableElementFactory
temps
t1 a Seaside.WARenderCanvas
t2 '1,001,00123,0012,D12-100,,New,5707,Jan 23, 2008,,,,,'
t3 2
t4 1
t5 nil
inst vars
clsBlock BlockClosure [] in Director>>assignObjectByName:toBe:
caption 'Master Inventory List'
array Name: invlist$( type: string number of dimensions: 2 specifiication: OrderedCollection (100 13)
columnNames OrderedCollection ('Record ID')
flip nil
firstRange (0 to: 100)
secondRange (0 to: 13)
deviceHandle '#inv'
cssClass nil
trClass nil
tdClass nil
thClass nil
captionClass nil
columnHandlers #(nil)
sub nil
clickParameter nil
director a BranchingProgramDirector
optimized [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
self BlockClosure [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
temps
self a TableElementFactory
t1 a Seaside.WARenderCanvas
t5 1
t4 0
t2 nil
t3 nil
inst vars
method CompiledBlock [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
outerContext nil
copiedValues #(a TableElementFactory a Seaside.WARenderCanvas 1 0 #(1 2))
BlockClosure>>renderOn:
self BlockClosure [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
temps
t1 a Seaside.WARenderCanvas
inst vars
method CompiledBlock [] in [] in [] in [] in TableElementFactory>>renderRowsOn:
outerContext nil
copiedValues #(a TableElementFactory a Seaside.WARenderCanvas 1 0 #(1 2))