thank you both for responding, now i know at the very least that this is possible!
when you say dont do anything funky to it before you insert it, i think thats where a problem might be coming in. I didnt want to limit the text size to something small, and i didnt want to allocate huge chunks of text in the DB when i might only use a little bit of it most of the time, so i have a table which has an id, a "chunk number" and a chunk of text thats 50 characters long. I use a for loop and <@substring> to cut it into blocks of 50 characters for storage in the database and when i dont use encoding=sql i get an error. An example insert that fails without sql encoding is this: insert into VarText (Chunk,TextID,ChunkNumber) values '.districtno='@@user$vdistrictno' and location.locn', 86, 5 also when i select...i select like this: select chunk from vartext where TextID=@@local$TextID order by chunk number then store it to a variable like this: <@assign local$Code value="<@VAR local$resultset type=text APrefix='' ASuffix='' RPrefix='' RSuffix='' CPrefix='' CSuffix=''>"> any obvious problems with any of this? ----- Original Message ----- From: Scott Cadillac To: Multiple recipients of list witango-talk Sent: Wednesday, January 08, 2003 11:17 PM Subject: Re: Witango-Talk: a question about dynamic code Hi Atrix, Yes, you can store raw Witango Metatag text in a database and execute it (dynamically) when the content is requested. I have this feature enabled for all my webpages of my site ( http://xml-extra.net ) and so many parts of the site are running dynamically straight from the database - and yes, at the same time, I have one set of Witango files that services many different domains with different content. And of course I have an on-line Text Editor for the pages, so when you couple this with things like Database and Mail Actions stored in TCF files (called via <@callmethod>) - you have a powerful programming environment running over the web. ENCODING=METAHTML is the trick - but if it's not working for you, check the Server configuration file because there might be a switch that turns this off. I doubt that it's a licensing restriction. Also, are you on T2K SP1 at least? I know it works on this version - but I can't remember about older versions. And maybe make user you're not doing anything funky with the variable before displaying it with ENCODING=METAHTML Hope this helps. Cheers.... Scott Cadillac VP, Research and Development Plus International Corp. 403-281-6090 [EMAIL PROTECTED] http://www.plusinternational.com Does your company have an Enterprise Information Portal? Check out Salsa at www.plusinternational.com/flash/salsa.htm ----- Original Message ----- From: Atrix Wolfe To: Multiple recipients of list witango-talk Sent: Wednesday, January 08, 2003 11:33 PM Subject: Witango-Talk: a question about dynamic code hello i got a crazy question kinda... we have an app where we have several different clients that each have their own "playground" within the same set of apps so depending on which group youve logged into, the applications can vary quite dramaticly. Because switches and settings can only go so far, i was thinking we could store snippets of witango code in the database and then select them for the appropriate group, store it in a var and do a <@var local$Code encoding=metahtml>. It seems not to want to work and i was wondering if it was because of a licensing issue? Im storing the code with encoding=sql so it can handle quotes and other sql control characters within the string. im selecting it into local$Rule and then doing an <@var local$Rule encoding=metahtml> to get the code to "run". When i try to run it it just spits out the code plaintext without parsing it. When i look at it in the database, it has < and > instead of < and > so thats not the problem. When i do a <@var local$Rule> it shows < as < and > as > when i do a <@var local$Rule encoding=none> it shows the code without parsing it (< as < and > as > but no code being run) when i do a <@var local$Rule encoding=metahtml> it also just shows the code without running it. im pretty sure i must be doing something wrong but cant see what. Anyone have any idea? ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
