Eddie Leong
July 9th, 2001, 11:33 AM
I know how to connect to my DB, form posting and store in to my database. but I do not know how to get back the data from MS Access to show like a graph. I try this in vbscript:
mySQL1="select * from DB where (Fields1 = '%intData1%')
mySQL2="select * from DB where (Fields1 = '%intData2%')
mySQL3="select * from DB where (Fields1 = '%intData3%')
recordset1.open(mySQL1)
intValue1 = recordset1.getcount
recordset1.close
recordset1.open(mySQL2)
intValue2 = recordset1.getcount
recordset1.close
recordset1.open(mySQL3)
intValue3 = recordset1.getcount
recordset1.close
'How to show my intValue, I've stuck here. I try to show like below. but it won't work.
label1.setcaption = intValue1
label2.setcaption = intValue2
label3.setcaption = intValue3
What's wrong? Can anyone tell me? Is my method correct? Please give me some suggestion (VBscript or JavaScript also understand). I'm using V.InterDev 6 Design time control (Form manager,listbox,label, button and recordset). Please, Please Help me. I'm stuck.
Thank you very much
mySQL1="select * from DB where (Fields1 = '%intData1%')
mySQL2="select * from DB where (Fields1 = '%intData2%')
mySQL3="select * from DB where (Fields1 = '%intData3%')
recordset1.open(mySQL1)
intValue1 = recordset1.getcount
recordset1.close
recordset1.open(mySQL2)
intValue2 = recordset1.getcount
recordset1.close
recordset1.open(mySQL3)
intValue3 = recordset1.getcount
recordset1.close
'How to show my intValue, I've stuck here. I try to show like below. but it won't work.
label1.setcaption = intValue1
label2.setcaption = intValue2
label3.setcaption = intValue3
What's wrong? Can anyone tell me? Is my method correct? Please give me some suggestion (VBscript or JavaScript also understand). I'm using V.InterDev 6 Design time control (Form manager,listbox,label, button and recordset). Please, Please Help me. I'm stuck.
Thank you very much