-
Hi I've been working with active server pages for a few weeks now to try to write a program that can manipulate a table's cells properties with vbscript and also access an Access database to store and retrieve data.
I've encountered lots of problems when it comes to variable sharing between my server and my client side page. I notice that when the user selects several options and that I tried to do some data calculations between my <vbscript> tags very often I was in very much need of variables that I could only access by using the <%=variable%> tag. But unfortunately there's no way to use this tag within the vbscipt tags. The main reason I wanted to do that was to retrieve data pulled from the database since I can't open my database within the vbscript tags.
The only other way for me to go around this limitation was to load my page each time & passing new variables along but then I would have to do it everytime the user makes a selection (where there's actually quite a few to be done b4 I can gather all the informations needed to update my database) which would be very annoying. Imagine a page reloading every time you click an option in a pull down menu and then you'd have to redisplay all the options that have been previously selected when you reload as long as all the appropriate cell bgcolor if it has been changed in your codes.
To make a story short, I would like to know if there's any other application that allows table design flexibility such as front page. I know the grid control in visual basic isn't really what I'm looking for. The grids are too wide and I would need to resize them.
Well if you have any idea please let me know. Thanks
p.s. What application is the software Sub7 written in?
-
Depending on the size of your data, you could store the data on the page in arrays and access it from the client side to your heart's content. Another option is refreshing the page when they select something that will require updated data from the database. I use both of these methods depending on the average target client machine and the size of the data I need to display and use.
