Re: RAM variables
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11547
interpreted = N
texte = >I'm building a temporary site at cwd.tempcontrol.com > >I'm pretty proud that I figured out a way to format search results in a >table, formatting the rows with alternating images and descriptions. > >This required using a second database to temporarily hold record data to >be placed in the next row of cells. > >The problem I have is speed. In order to make this thing work, I have >to delete the temporary records each time I complete a pair of rows. I >also have to close the database to get it out of RAM. I can hear the >disk clatter for each pair of rows, every time the page is loaded. > >Is there a way to hold this temporary data in RAM without writing it to >another database? Can variables be declared using WebCat? Maybe there >could be a [variable][/variable] context.You can do this with numeric values only by using [MATH]YourVariableNameHere=YourNumericValueHere[/MATH].I didn't really understand what you were trying to do, so I took a brief look at your site (very nice layout and formatting).I presume you could use a [MATH]Var1=[SKU][/MATH] for each picture, and then do a [LOOKUP] in every textcell for retrieving the text (if your SKU is numeric).You could also choose a different approach by doing two searches (one for pics and one for texts) inside another search for achieving the same result. I don't know which one is faster, you'll have to try it out. ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se
Associated Messages, from the most recent to the oldest:
>I'm building a temporary site at cwd.tempcontrol.com > >I'm pretty proud that I figured out a way to format search results in a >table, formatting the rows with alternating images and descriptions. > >This required using a second database to temporarily hold record data to >be placed in the next row of cells. > >The problem I have is speed. In order to make this thing work, I have >to delete the temporary records each time I complete a pair of rows. I >also have to close the database to get it out of RAM. I can hear the >disk clatter for each pair of rows, every time the page is loaded. > >Is there a way to hold this temporary data in RAM without writing it to >another database? Can variables be declared using WebCat? Maybe there >could be a [variable][/variable] context.You can do this with numeric values only by using
[math]YourVariableNameHere=YourNumericValueHere[/MATH].I didn't really understand what you were trying to do, so I took a brief look at your site (very nice layout and formatting).I presume you could use a
[math]Var1=[SKU][/MATH] for each picture, and then do a
[lookup] in every textcell for retrieving the text (if your SKU is numeric).You could also choose a different approach by doing two searches (one for pics and one for texts) inside another search for achieving the same result. I don't know which one is faster, you'll have to try it out. ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se
Christer Olsson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
RE: (1997)
Sendmail and textarea (1998)
interactive .pdf files and WebCatalog (2000)
Error Lob.db records error message not name (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Browser Reloads and AddlineItem (1997)
E-Mail Preferences in Admin Folder (1997)
PIXO support (1997)
Server slowing down. (1997)
RE: Webcatalog and CyberSTUD (1998)
Serial Number Question (1997)
Sort Order on a page search (1997)
Pass Thru Page? (1998)
PCS Frames (1997)
For those of you not on the WebCatalog Beta... (1997)
Thanks ! (1997)
[addlineitems] (1997)
[ShowIf] and empty fields (1997)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
Not really WebCat (1997)