SV: SV: Witango-Talk: Talklist
Yeah, sound like a good idea using Witango as email parser, save them in a db and create a Witango app for searching the db. Thanks Robert I will look in to it. It will mean a possibility to create a talklist even for external mailing lists, /Bengt Från: Robert Shubert [mailto:[EMAIL PROTECTED] Skickat: den 19 november 2005 21:08 Till: witango-talk@witango.com Ämne: RE: SV: Witango-Talk: Talklist For this purpose, I would say that you could go in either direction. What you really want to do, however, is setup a normal listserv with your email software, and send a copy of each email an account which you read into your database using Witango. There are listserv archiving tools out there as well. You may want to consider taking a forum approach to this problem as well. Robert From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Saturday, November 19, 2005 5:06 AM To: witango-talk@witango.com Subject: SV: SV: Witango-Talk: Talklist Thanks for all your input on this. What I really want is a talklist for our internal company. Maybe 20-50 email per day from our own developers around Scandinavia. The emails has to be stored in a db so it can be searched for later. I have looked at a couple of listservers and they seem to be very good mailservers but hasnt any or small possibilities for searching. The definition of listserver doesnt by default include search possibility as I see it. A small talklist application inside every company is a great thing to have for exchanging info and experiences automatically and it has to be searchable. Maybe Witango isnt the tool but together with a listserver maybe? /Bengt Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 19 november 2005 00:19 Till: witango-talk@witango.com Ämne: RE: SV: Witango-Talk: Talklist Ok, Ok, Ill chime in ;-) For one thing, I agree with John, Witango is not a mail server. And with the volume of emails on a list server and the fact that you have to manage retries and failed emails and spam, there are other mail server packages that can be used to augment this. For instance I use MDaemon Pro and it has great list server capabilities (for Windows). MDaemon allows list of any number of users that dont tie to the license count. So for instance you could by the 6 user pro and have a list server of 1000 members. One cool thing is that MDaemons list server allows you to run the members off an ODBC connection so you can admin the users via Witango and Let the Mail server handle emails. There are probably other solutions, I am biased though. As for using Witango, you have a problem because it is not a SMTP server it can only interact with one via the @EMAIL and @EMAILSESSION tags. Ok here is an example: You have an email account on a mail server that is used to receive the emails for the list You use @EMAILSESSION and @EMAIL Tags to retrieve the email But here is the kicker, you have to use Witango to create 1000 copies of the email and send them to the mail server. Here is also another fun thing about emails Attachments!!! Im sorry to say it but I like John feel that Witango is the wrong tool for this Ben Johansen From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 2:32 PM To: witango-talk@witango.com Subject: Re: SV: Witango-Talk: Talklist TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: SV: Witango-Talk: Talklist
Thanks for all your input on this. What I really want is a talklist for our internal company. Maybe 20-50 email per day from our own developers around Scandinavia. The emails has to be stored in a db so it can be searched for later. I have looked at a couple of listservers and they seem to be very good mailservers but hasnt any or small possibilities for searching. The definition of listserver doesnt by default include search possibility as I see it. A small talklist application inside every company is a great thing to have for exchanging info and experiences automatically and it has to be searchable. Maybe Witango isnt the tool but together with a listserver maybe? /Bengt Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 19 november 2005 00:19 Till: witango-talk@witango.com Ämne: RE: SV: Witango-Talk: Talklist Ok, Ok, Ill chime in ;-) For one thing, I agree with John, Witango is not a mail server. And with the volume of emails on a list server and the fact that you have to manage retries and failed emails and spam, there are other mail server packages that can be used to augment this. For instance I use MDaemon Pro and it has great list server capabilities (for Windows). MDaemon allows list of any number of users that dont tie to the license count. So for instance you could by the 6 user pro and have a list server of 1000 members. One cool thing is that MDaemons list server allows you to run the members off an ODBC connection so you can admin the users via Witango and Let the Mail server handle emails. There are probably other solutions, I am biased though. As for using Witango, you have a problem because it is not a SMTP server it can only interact with one via the @EMAIL and @EMAILSESSION tags. Ok here is an example: You have an email account on a mail server that is used to receive the emails for the list You use @EMAILSESSION and @EMAIL Tags to retrieve the email But here is the kicker, you have to use Witango to create 1000 copies of the email and send them to the mail server. Here is also another fun thing about emails Attachments!!! Im sorry to say it but I like John feel that Witango is the wrong tool for this Ben Johansen From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 2:32 PM To: witango-talk@witango.com Subject: Re: SV: Witango-Talk: Talklist TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Talklist
Thanks for the suggestion, but it's on Linux and we only play Windows, or ? /Bengt -Ursprungligt meddelande- Från: William M Conlon [mailto:[EMAIL PROTECTED] Skickat: den 17 november 2005 22:52 Till: witango-talk@witango.com Ämne: Re: Witango-Talk: Talklist GNU Mailman includes Per-list privacy features, such as closed- subscriptions, private archives, private membership rosters, and sender-based posting rules. (http://www.gnu.org/software/mailman/ features.html) bill On Nov 17, 2005, at 1:32 PM, Bengt Bredin wrote: Hi all Im thinking of setting up a company internal Talklist (like this one) using Witango and looking for a quick start. Anyone got an embryo for this (app and/or database structure) and willing to share? My email [EMAIL PROTECTED] - Bengt __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Bill William M. Conlon, P.E., Ph.D. To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Blogs
Yes it is. First login, Choose Witango Blog Click more on About the Witango Demo Blog Module And there you have You can download the source from here. /Bengt Från: steve [mailto:[EMAIL PROTECTED] Skickat: den 17 november 2005 17:42 Till: witango-talk@witango.com Ämne: RE: Witango-Talk: Blogs Thanks so much! I was somehow under the impression that the .taf was there for anyone that wanted it. Maybe I misread what Phil posted at the time of his announcement of this projedt; Was it there or Thanks in advance Steve From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 2:39 PM To: witango-talk@witango.com Subject: SV: Witango-Talk: Blogs Steve! Its on http://blog.witango.com/ /Bengt Från: steve [mailto:[EMAIL PROTECTED] Skickat: den 15 november 2005 17:29 Till: witango-talk@witango.com Ämne: RE: Witango-Talk: Blogs I am almost for sure that the Blogs that Phil posted on the With site were there for the using/taking, etc. But, I am unable to find it now. Any ideas? Steve TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Blogs
Glad to help, Ive got so much useful info from the list myself. /Bengt Från: steve [mailto:[EMAIL PROTECTED] Skickat: den 17 november 2005 22:09 Till: witango-talk@witango.com Ämne: RE: Witango-Talk: Blogs Thank you so very much. I suppose everyone else on the list just got tired of me asking about this. I am so very glad that you decided to bear with me thru some of my own ineptness. Thanks again Steve From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Thursday, November 17, 2005 2:59 PM To: witango-talk@witango.com Subject: SV: Witango-Talk: Blogs Yes it is. First login, Choose Witango Blog Click more on About the Witango Demo Blog Module And there you have You can download the source from here. /Bengt Från: steve [mailto:[EMAIL PROTECTED] Skickat: den 17 november 2005 17:42 Till: witango-talk@witango.com Ämne: RE: Witango-Talk: Blogs Thanks so much! I was somehow under the impression that the .taf was there for anyone that wanted it. Maybe I misread what Phil posted at the time of his announcement of this projedt; Was it there or Thanks in advance Steve From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 2:39 PM To: witango-talk@witango.com Subject: SV: Witango-Talk: Blogs Steve! Its on http://blog.witango.com/ /Bengt Från: steve [mailto:[EMAIL PROTECTED] Skickat: den 15 november 2005 17:29 Till: witango-talk@witango.com Ämne: RE: Witango-Talk: Blogs I am almost for sure that the Blogs that Phil posted on the With site were there for the using/taking, etc. But, I am unable to find it now. Any ideas? Steve TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Talklist
Hi all Im thinking of setting up a company internal Talklist (like this one) using Witango and looking for a quick start. Anyone got an embryo for this (app and/or database structure) and willing to share? My email [EMAIL PROTECTED] - Bengt TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Blogs
Steve! Its on http://blog.witango.com/ /Bengt Frn: steve [mailto:[EMAIL PROTECTED] Skickat: den 15 november 2005 17:29 Till: witango-talk@witango.com Ämne: RE: Witango-Talk: Blogs I am almost for sure that the Blogs that Phil posted on the With site were there for the using/taking, etc. But, I am unable to find it now. Any ideas? Steve TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 11/10/2005 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: @FILTER and number of char
Is there a minumum char length in EXPR inside @FILTER of 2 ? @FILTER ARRAY=AllParameter EXPR=(#1 = M0) and (#1 = M9) SCOPE=request works fine, but @FILTER ARRAY=AllParameter EXPR=(#1 = M) and (#1 = M) SCOPE=request returns Error An error occurred while processing your request: File: Search.taf Position: Search_All_Parameters Class: Internal Main Error Number: -18 Error during _expression_ evaluation. String expected in statement [(F007AF = M) and (F007AF = M)] Same result with EXPR=#1 = M but works with #1 = M0, wildcards doesnt work either. Using Witango Studio 5.5.08 and 5.0.1.065 Chimera (Win32) on IIES W2K. Appreciate any help on this. /Bengt TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: @FILTER and number of char
Of course, those quotes again .. Thanks Robert ! Bengt Try @FILTER ARRAY=AllParameter EXPR=(#1 = 'M0') and (#1 = 'M9') SCOPE=request @FILTER ARRAY=AllParameter EXPR=(#1 = 'M') and (#1 = 'M') SCOPE=request Quote your strings, one letter strings may be evaluated as variables, see docs on @calc and _expression_ evaluation. I would even add quotes around the #1. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED]net - [EMAIL PROTECTED]com http://bighead.net/ - http://eventpix.com/ On Feb 10, 2005, at 4:09 AM, Bengt Bredin wrote: Is there a minumum char length in EXPR inside @FILTER of 2 ? @FILTER ARRAY=AllParameter EXPR=(#1 = M0) and (#1 = M9) SCOPE=request works fine, but @FILTER ARRAY=AllParameter EXPR=(#1 = M) and (#1 = M) SCOPE=request returns Error An error occurred while processing your request: File: Search.taf Position: Search_All_Parameters Class: Internal Main Error Number: -18 Error during _expression_ evaluation. String expected in statement [(F007AF = M) and (F007AF = M)] Same result with EXPR=#1 = M but works with #1 = M0, wildcards doesnt work either. Using Witango Studio 5.5.08 and 5.0.1.065 Chimera (Win32) on IIES W2K. Appreciate any help on this. /Bengt TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Documentation for Witango Server
Hope With E can fix that, but the 5.0 link works. Bengt Bredin BTW: Witango_5.5_Admin.zip (http://www2.witango.com/installers/witango5admin/Witango_5.5_Admin.zip) is not available (Error: The page cannot be found)! -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Thursday, January 20, 2005 01:59 To: witango-talk@witango.com Subject: SV: Witango-Talk: Documentation for Witango Server Hey John ! Agree that the configuration documentation could have been better, but download the Witango_5_admin.zip from Witango.com under Witango Utilities, Server Admin Application it will assist you to config your server. Bengt Bredin I'm looking for documentation on configuring the witango application server. There used to be a Tango Application Server handbook, but now all I see in the documentation is a what's new, and an install guide. For instance, information on setting up a crontab file seems to be nowhere. Am I missing something? Thanks, John Newsom TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: SV: Witango-Talk: Showing progress bar before opening resultset in Excel
Hi Edmund and thanks again. I feel that my knowledge about http header is week. I've tried your example out (I think) but it ends up with showing either the HTML page (only with push set at the result action) but the Excel data in the browser or Not showing the HTML page (no push in result action) but Excel data downloaded ok. As I understand the javascript sends the first HTTP request (if push is activated) and the Excel request sends the other one but it ends up in the browser. There is no @PUSH metatag to use inside the HTML page, only to the result action. I keep on trying, will not give up so easily, thanks for you help. /Bengt -Ursprungligt meddelande- Från: Edmund Edgar (mailing list account) [mailto:[EMAIL PROTECTED] Skickat: den 20 december 2004 11:50 Till: [EMAIL PROTECTED] Ämne: Re: SV: Witango-Talk: Showing progress bar before opening resultset in Excel Hi Bengt. Maybe I've misunderstood your problem, but, let me rephrase. You can't output an HTML page (which you need to show the progress bar) in the same HTTP request that you use to output the downloadable Excel data. You need two request/responses. This is a limitation of the way HTTP requests/responses work, not a limitation of Tango. One request has one and only one response, and one response has one and only one header type, content-disposition, etc. (As far as I can imagine...) So you need to make the browser send you another HTTP request. There are lots of ways you might do this, but the scenario I suggested is like this: - The first response prepares the data, shows the progress bar and makes a second request. (Probably a Javascript redirect) - The second response sends the Excel headers and the Excel data to the browser. These can both be in the same taf. For example, at the beginning of your taf you might put in something like this: * Warning: Undebugged, and it's a while since I wrote Tango stuff... @IF @@user$downloadIsPrepared @COMMENT Your original code... /@COMMENT @EXCLUDE @ASSIGN local$DebugMode ForceOff @ASSIGN local$FileExtension .xls @ASSIGN local$FileName value=Labsvar @ASSIGN local$Tab '@CHAR CODE=9' @ASSIGN local$httpHeader 'HTTP/1.1 @HTTPSTATUSCODE @HTTPREASONPHRASE@CRLFContent-type: application/vnd.ms-excel@CRLFContent-Disposition: attachment; filename=@VAR local$FileName@VAR local$FileExtension@CRLFLocation: http://@CGIPARAM SERVER_NAME/@VAR local$FileName@VAR local$FileExtension@CRLF@CRLF' @ASSIGN local$encodeResults FALSE @PURGERESULTS /@EXCLUDE@PURGERESULTS@var user$exceldata encoding=none @COMMENT Clean up the user variables /@COMMENT @ASSIGN user$downloadIsDone 0 @ASSIGN user$excelData @ELSE // Go to the rest of your taf, which will include things like this: html head titleLoading your data/title script language=JavaScript function submitToSelf() { location.href=@APPFILE?@CGIPARAM NAME=HTTP_SEARCH_ARGS; } /script /head body onload=submitToSelf(); Write a page with the start of your progress bar... @PUSH Get some data Write some more of the progress bar (I'm not sure how you're doing this without making lots of trips backwards and forwards between client and server, but let's assume you've got it figured out...) @PUSH Get some more data and assign it to a user variable @ASSIGN user$downloadIsPrepared 1 @ASSIGN user$excelData @@local$someDataYouHavePrepared Finish writing the progress bar Put in a link for people without Javascript noscript a href=@APPFILE?@CGIPARAM NAME=HTTP_SEARCH_ARGSClick here to continue/a noscript /body html /@IF Or am I missing your point? Edmund On Mon, 20 Dec 2004 10:02:49 +0100, Bengt Bredin [EMAIL PROTECTED] wrote: Hi Edmund ! Thanks for your reply but I can't get hold of it anyway. I can't get the normal HTML page in Request 1 to show without PUSH because I use branch to reconnect to Request 2 and Witango execute all components from start to the end (Request 1 and 2). And PUSH makes my Excel HTTP header not to work in Request 2, it ends up in the browser. Can I redirect any other way or what am I missing ? /Bengt -Ursprungligt meddelande- Från: Edmund Edgar (mailing list account) [mailto:[EMAIL PROTECTED] Skickat: den 20
Witango-Talk: Showing progress bar before opening resultset in Excel
Hi all ! I have a working app that do sql searches, calculations and then present the resultset in Excel. Im trying to insert a progress bar to the browser while the search and calculation works. I insert a pushed result action before the sql and calc parts and it shows in the browser ok but when the sql and calc are finished the result now only shows in the browser and not to Excel. If its not possible to use push, how can I create a progress bar before presenting the resultset to Excel ? The http header looks like this: @EXCLUDE @ASSIGN local$DebugMode ForceOff @ASSIGN local$FileExtension .xls @ASSIGN local$FileName value=Labsvar @ASSIGN local$Tab '@CHAR CODE=9' @ASSIGN local$httpHeader 'HTTP/1.1 @HTTPSTATUSCODE @HTTPREASONPHRASE@CRLFContent-type: application/vnd.ms-excel@CRLFContent-Disposition: attachment; filename=@VAR local$FileName@VAR local$FileExtension@CRLFLocation: http://@CGIPARAM SERVER_NAME/@VAR local$FileName@VAR local$FileExtension@CRLF@CRLF' @ASSIGN local$encodeResults FALSE @PURGERESULTS /@EXCLUDE@PURGERESULTS@var request$exceldata encoding=none Hope anyone can guide me on this one. /Bengt TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: [ot] Databases
Title: [ot] Databases When we set up our database interface the goal was to be able to support several databases, MSSQL, Pervasive.SQL, MS-Access, Oracle, Informix etc. We didnt supply any triggers or stored proc. But just to name all tables, columns, Pkey, Fkey was a tricky job because they all have their own rules for reserved names. The connection from the application with ODBC or ADO/OLEDB was the easy part of it. So migrate from MSSQL to something else can give you naming problems which will end up in editing your application. If you also use triggers and stored proc. that will also give you problems in converting from transact SQL to something else. Different databases have separate implementations of joins as well, which can give you application problems. As you say there are tools that can help, one can be data junction. I havent tried it but I hear its good, se more at http://www.pervasive.com/migrationtoolkit/ Today we prefer MSSQL, it cost some money but the best thing with it today (from ver 7) is that you dont need any dba to handle it. Online backup, automatically checked integrity and index and scheduled jobs etc. Right set up it works like a charm. I think Oracle still need a dba to maintain the database. Oracle itself (as I remember ver 8) is one database on one computer. You only add tables to it so that also give you naming problems. There can only be one table named customer on one Oracle database. In MSSQL you just create a separate database on the same computer. I have just begin looking at MySQL and it seems to be an alternative if you dont require triggers or stored proc. Most people think its free but thats only true if your application code is open source else you have to pay for the license. Ok its cheep comparing to MSSQL or Oracle. So if you dont have any good reason to leave MSSQL, why do it ? /Bengt -Ursprungligt meddelande- Från: Wilcox, Jamileh (HSC) [mailto:Jamileh-Wilcox@ouhsc.edu] Skickat: den 12 augusti 2004 00:10 Till: [EMAIL PROTECTED] Ämne: Witango-Talk: [ot] Databases We run all of our databases on MS-SQL2000 or MS Access. (I've been slowly working towards moving all the Access databases to SQL.) We're considering changing database servers. Under discussion so far are Oracle and MySQL. The campus has a site license for Oracle, so purchase cost isn't much of a factor. I've been researching MySQL and it looks a bit limited (no stored procs yet, no scheduler/jobs/etc.), but the new version due out next year has a several of those features added (although I'm not sure *when* in 2005 it'll be available). How difficult is it to switch to MySQL or Oracle from MS-SQL? I realize there will be some conversion issues in any db migration (i.e., SQL language variations, datatype variations, etc.), but there appear to be tools available to assist with that. I'm mostly concerned about the learning curve and how long it would take to come up to speed on a new db. Does anyone have experience with such a migration, or experience with using more than one of these dbs? Any info or advice would be most appreciated! Thanks. jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Page has expired
For you info ! The scenario is: 1.tcf collects data into an array and before showing the list it calls for each row a Custom Tag (2.tcf) which look for existing files in a specific directory, which is being done with a file action. Then 1.tcf displays the list and the user can click on a row and get a detail page. If the user then use the Back, Backspace or a _javascript_ back code they sometimes get the page Warning page has Expired. I found out the reason was that if the 2.tcf didnt find the file it generates an error (which the error.html part took care of), but because that error the user got the Warning page has Expired page. It works fine if the call to 2.tcf comes from a .taf file instead. I dont know if this is the right behaviour or a bug, but a had to recode to solve it. Bengt -Ursprungligt meddelande- Från: Bengt Bredin [mailto:bengt[EMAIL PROTECTED]se] Skickat: den 12 maj 2004 12:59 Till: Witango-Talk Ämne: Witango-Talk: Page has expired Hi all ! I have a question about calling a Custom Tag from within a tcf. From inside a .tcf and @rowsI call a Custom Tag @Check_File_Exists filepath='xx to see if corresponding .pdf file exists for that @currow and that works fine. On the html page being produced I also have other links to press and if I do that a receive a new html page with detail information, but if I press Backspace or Back on my browser to go back to the previous page I get Warning page has Expired. I have tried to clean out my temporary internet files but with no success. If I dont call the Custom Tag from within the .tcf then it works again. What is it that I dont get here ? Do I have to check all rows for pdf files before showing the page or what ? /Best regards Bengt Bredin TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Page has expired
Hi all ! I have a question about calling a Custom Tag from within a tcf. >From inside a .tcf and @rowsI call a Custom Tag @Check_File_Exists filepath='xx to see if corresponding .pdf file exists for that @currow and that works fine. On the html page being produced I also have other links to press and if I do that a receive a new html page with detail information, but if I press Backspace or Back on my browser to go back to the previous page I get Warning page has Expired. I have tried to clean out my temporary internet files but with no success. If I dont call the Custom Tag from within the .tcf then it works again. What is it that I dont get here ? Do I have to check all rows for pdf files before showing the page or what ? /Best regards Bengt Bredin TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: sql server column reference
Title: Message Hey Ted ! You talk of course about MS SQL ? The dbo. Prefix comes from the owner or creator of the table. If you have connect to the SQL server as the user sa and there creates a table it will get the prefix dbo. If you connect as Ted and have privileges to create tables in a database they will get the prefix ted. So you can in fact have two tables with the same name but with different prefix, dbo.table1 and ted.table1. I always create tables as a sa and then creates users with rights to the database and tables. That way the tables always have the prefix dbo. Hope it clear things up ? /Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Ted Wolfley [mailto:ted@ogdengroup.com] Skickat: den 14 april 2004 17:33 Till: [EMAIL PROTECTED] Ämne: Witango-Talk: sql server column reference Hi, Just wondering if anyone knew why sometimes the column references in search actions have the dbo. prefix and other times the columns references don't. Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED]com www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: sql server column reference
Title: Message Strange, havent seen it. I tried just now but I always get the dbo. Prefix in the columns. Do you connect the same way to the database from the different workstations, the same ODBC system configuration, username etc. ? Med vänlig hälsning/Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : bengt.[EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Ted Wolfley [mailto:ted@ogdengroup.com] Skickat: den 15 april 2004 14:19 Till: '[EMAIL PROTECTED]' Ämne: RE: Witango-Talk: sql server column reference Yes, we are using MS SQL. I understand the why there is the prefix dbo and we only connect as sa. But sometimes when I open up a search action that had columns with the prefixes, the prefixes disappear and then I have to edit the column references in the Result Action. It also happens the other way, where there weren't any prefixes on the column names and now there are, where the Result Action needs to be edited. It seems to depend upon which workstation created the Search Action whether there are prefixes or not. What would cause the prefix not to appear? Ted -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 3:34 AM To: [EMAIL PROTECTED] Subject: SV: Witango-Talk: sql server column reference Hey Ted ! You talk of course about MS SQL ? The dbo. Prefix comes from the owner or creator of the table. If you have connect to the SQL server as the user 'sa' and there creates a table it will get the prefix dbo. If you connect as 'Ted' and have privileges to create tables in a database they will get the prefix ted. So you can in fact have two tables with the same name but with different prefix, dbo.table1 and ted.table1. I always create tables as a 'sa' and then creates users with rights to the database and tables. That way the tables always have the prefix dbo. Hope it clear things up ? /Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Ted Wolfley [mailto:ted@ogdengroup.com] Skickat: den 14 april 2004 17:33 Till: [EMAIL PROTECTED] Ämne: Witango-Talk: sql server column reference Hi, Just wondering if anyone knew why sometimes the column references in search actions have the dbo. prefix and other times the columns references don't. Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] com www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafTO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: http and tiff image
Thanks Bill and Tom for your suggestions ! But the real reason was that I had forgot to put @purgeresults before @var request$tiff encoding=none at the last call. There is no need for Content-Length header to make it work. Cheers Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN mail : [EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Bill Conlon [mailto:[EMAIL PROTECTED] Skickat: den 2 april 2004 19:26 Till: Witango-Talk Ämne: Re: Witango-Talk: http and tiff image I see you aren't using the Content-Length header, but one problem can be caused if the content-length is incorrect. I'm speculating that the problem I've seen is caused when the source file is uploaded into the db using some MacOS9 browsers. (I think it must insert an extra Carriage Return or Line Feed). Anyway if you download one of these problem files, (save target as) you see the file length being one byte less than recorded during the upload. If it's re-uploaded using a different browser, such as OS X Mozilla os XP IE, the problem disappears, and the length of the uploaded file is now one byte less. Hey list ! I' am struggling with a http problem 'again'. I'll bring out an tiff blob from the db and put it into @ASSIGN request$tiff '@@request$resultSet[1,data]' then set up the http (yes it's one row) @assign request$encodeResults false @ASSIGN request$httpHeader HTTP/1.1 @HTTPSTATUSCODE @HTTPREASONPHRASE @crlf Date: @CURRENTTIMESTAMP FORMAT='datetime:http'@crlfServer: Witango @version @crlf MIME-Version: 1.0@crlfContent-Type: image/tiff@crlf@crlf And then calls @var request$tiff encoding=none The Imaging software starts up in the browser alright but I get the error: Can't open the document. The document format is not supported !!! If I first get it out from the db and stores it as a file and through the browser open the file its works, so it's stored correctly in the db. The size of the blob or file is 21569 bytes. I use the same procedure for pdf files with Content-Type: application/pdf and it works fine. I have tried the HTTPLook but I can't se any problem. //W2K, SQL Server 2K, IIS, Witango 5.0 (049), Witango 5.0 Studio// Any ideas ? Cheers Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN mail : [EMAIL PROTECTED] --- ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax:650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web:http://www.tothept.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: http and tiff image
Hey list ! I am struggling with a http problem again. Ill bring out an tiff blob from the db and put it into @ASSIGN request$tiff '@@request$resultSet[1,data]' then set up the http (yes its one row) @assign request$encodeResults false @ASSIGN request$httpHeader HTTP/1.1 @HTTPSTATUSCODE @HTTPREASONPHRASE @crlf Date: @CURRENTTIMESTAMP FORMAT='datetime:http'@crlfServer: Witango @version @crlf MIME-Version: 1.0@crlfContent-Type: image/tiff@crlf@crlf And then calls @var request$tiff encoding=none The Imaging software starts up in the browser alright but I get the error: Cant open the document. The document format is not supported !!! If I first get it out from the db and stores it as a file and through the browser open the file its works, so its stored correctly in the db. The size of the blob or file is 21569 bytes. I use the same procedure for pdf files with Content-Type: application/pdf and it works fine. I have tried the HTTPLook but I cant se any problem. //W2K, SQL Server 2K, IIS, Witango 5.0 (049), Witango 5.0 Studio// Any ideas ? Cheers Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN mail : [EMAIL PROTECTED] --- TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: StoreFront
Many thanks Steve and Scott it works great. I also had to skip the single quotes @CALLMETHOD application$Common HTTPRedirect(@VAR application$CGI before and after the @VAR [EMAIL PROTECTED] above and also insert http://@CGIPARAM SERVER_NAME Before @VAR application$RootPath to make it work. I think it would be great if someone could host this updated StoreFront Demo app for others to download and don't think the P-company would mind. So if anyone will do it please let me know and I can send a zip. Thanks again Steve and Scott ! Cheers / Bengt -Ursprungligt meddelande- Från: Fogelson, Steve [mailto:[EMAIL PROTECTED] Skickat: den 9 mars 2004 15:39 Till: '[EMAIL PROTECTED]' Ämne: RE: Witango-Talk: StoreFront Brengt, I changed the method to the following with help from Scott Cadillac. @assign request$httpHeader @var application$RedirectPrefixLocation: @var method$URL encoding=metahtml@crlf@setcookies@userreferencecookie@crlf@crl f The variable RedirectPrefix should be set to HTTP/1.0 302 Moved@CRLF Hope this helps. Steve Fogelson Internet Commerce Solutions -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 7:26 AM To: Witango-Talk Subject: Witango-Talk: StoreFront Hey list ! I'am trying to get the StoreFront Demo to work on my W2K, IIS, Witango 5 server (049), Witango 5.0 Studio and Access db but having problems with the method application$common HTTPRedirect... I always get : Client Error The response received from the application server is invalid When trying to login as admin or trying to create a new user or even just start the Admin.taf who should start the Default.taf through that method. I have updated the taf:s and tcf:s for version 5. Lack of http header knowledge I hope someone have got it up and running on Witango 5 and could guide me ! Cheers / Bengt TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: StoreFront
Hey list ! I'am trying to get the StoreFront Demo to work on my W2K, IIS, Witango 5 server (049), Witango 5.0 Studio and Access db but having problems with the method application$common HTTPRedirect... I always get : Client Error The response received from the application server is invalid When trying to login as admin or trying to create a new user or even just start the Admin.taf who should start the Default.taf through that method. I have updated the taf:s and tcf:s for version 5. Lack of http header knowledge I hope someone have got it up and running on Witango 5 and could guide me ! Cheers / Bengt TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Tango Memory Leaks
Hi ! I just created a bat file with two lines: Net stop witango server 5 Net start witango server 5 Then use the W2K Scheduler to set up a routine that calls the bat file. Seems to work fine. Bengt -Ursprungligt meddelande- Från: Steve Campbell [mailto:[EMAIL PROTECTED] Skickat: den 10 februari 2004 16:36 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: Tango Memory Leaks I am interested in this as well. Thanks Steve -Original Message- From: Peter Ternström [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 6:45 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Tango Memory Leaks Cool! could you tell me how to do this? I would like to restart tango server every night, due to memory leak problems. Kind regards Peter - Original Message - From: RJ Hendrickson [EMAIL PROTECTED] To: Multiple recipients of list witango-talk [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 9:10 PM Subject: Re: Witango-Talk: Tango Memory Leaks You can use the W2K Scheduler to set up a routine to reset Tango automatically on a daily basis, or as often as you like if you don't want to have to worry about doing it manually. RJ At 04:33 PM 4/1/2002, you wrote: Unfortunately, I have found to have similar memory leaks in tango 4.05.047. with apache. The leak occurs on windows 2000 and linux and mac. On my win2000/apache or linux apache systems, I can slowly watch the memory usage creap up, and my windows 2000 servers will crash occasionally due to it. I am sure it is tango, because if I just restart the tango service, the memory goes back to normal. As long as I restart the tango server every couple of days, no problems. The linux machines will restart the tango daemon by itself when the memory gets out of hand. I use a lot of binary library applications with tango, which means I am pulling large amounts of binary data from PrimeBase SQL, and I think that is why I see this problem more pronounced than others. -- Robert Garcia BigHead Technology 21053 Devonshire Suite 206 Chatsworth, Ca 91311 Phone 818.773.8162 Fax 818.773.8164 http://www.bighead.net/ [EMAIL PROTECTED] From: Jose Kuhn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 20 Mar 2002 14:03:57 -0500 To: Multiple recipients of list witango-talk [EMAIL PROTECTED] Subject: Re: Witango-Talk: Trying to make plans - Mac, Web*, Tango projections Hello! Both, Robert Garcia and myself are huge Mac heads but we have both temporarily moved to WiTango 2k Windows 2K running with Apache(Due to the memory leak in the Tango Webstar Plug in). We also use PrimeBase as our SQL Database. There is a memory leak in the Webstar Plug in Witango 2k. I would wait until this summer when Witango 5 comes out. Witango 5 will not run on Mac OS 9. According to Phil, there will be a Webstar 5 plug-in as well as the usual Apache Plug-in for Mac OS X. It runs fabulously with Apache. Primebase flies on Mac OS X (IT's slow on Mac OS 9.) You can download a free developer's version from http://www.Primebase.com. BTW Robert's http://www.bighead.net company is a Primebase Distributor. You can Run Primebase from everything from Mac OS 9/X to Solaris/AIX Jose on 3/20/02 11:51 AM, Joe Terrasi at [EMAIL PROTECTED] wrote: I currently use WebSTAR/Tango2k/Filemaker on a classic Mac (actually, the FileMaker is on a different box). What are anybody's thoughts on how I should upgrade? I wouldn't mind moving to an OSX box if necessary. I would love to scrap FileMaker all together (unless performance can be improved). I REALLY want to stay with Tango. I would like to stay with WebSTAR if possible, but I could possibly switch. What will be my best solution in the next 6 months-1 year? What database will serve me well? I also have a lot of forms/labels to print from the data - do I need a separate reports package? Sorry if these are basic questions, but I'd love your collective input. Thanks!! Joe TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ___ _ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body Songsearch Customer Service _ Orders can be placed at http://www.songsearch.net If you have questions, please don't hesitate to email us at [EMAIL PROTECTED] or call us at: (toll-free line)(877) 995-7664 fax (909) 792-4407 Our policy is to answer all inquiries within 24 hours. We're here to help! __ Postal mail orders are welcome! Send your order along with payment (don't forget shipping charges!) to:
SV: Witango-Talk: [OT] Online Backups?
Hi Ben ! Suppose you mean on the database ? Depends on what you are using, I manage MSSQL and Pervasive. /Best regards Bengt Bredin --- LabIT Solutions AB SWEDEN --- -Ursprungligt meddelande- Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 22 januari 2004 16:01 Till: 'WiTango List' Ämne: Witango-Talk: [OT] Online Backups? Hi, Anyone have experience with online backups and have a service they like? Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Array
Hey Jonah ! I have tried out your example and it works greatly. This example and the info you gave me have really helped me understand it better. Many thanks Jonah! Best regards Bengt Bredin --- LabIT Solutions AB Stockholm SWEDEN --- -Ursprungligt meddelande- Från: Jonah Simpson [mailto:[EMAIL PROTECTED] Skickat: den 23 december 2003 10:56 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: Array Hey Bengt! Duh, I made a mistake a couple mistakes in my code (musta been too early in the morning) ; Try this: @assign request$init_string value=Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference @rows @cols array=request$Ttext @assign request$init_string value=@var request$init_string,@var request$Ttext[1,@curcol] /@cols @break /@rows @assign name='request$Excel' value=@ARRAY VALUE='@var request$init_string' The idea being that you're creating a string of column names delimited with commas. Then you use the original string (Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference) of comma-delimited values, concatenated with the init_string (which is really a string of comma-delimited values) to form the init string for the array. What you were trying to do before wouldn't work, as by default, when you specify a array like @var request$Ttext[1,*] you're gonna get an output of the form: td@var request$Ttext[1,1]/tdtd,@var request$Ttext[1,2]/td etc for the number of columns in your array. (put @var request$Ttext[1,*] in a results action and then view source to see what I mean). You change the default row and column delimiters in the witango.ini file, but I don't like to code based on defaults, I'd rather explicitly assign everything (never know when you're gonna have to host your code on a server with different defaults). I belive you can set those delimiters inline in your code too, but I could be wrong on that. The reason @assign name=request$Excel value=@var request$Ttext[1,*] works is because WiTango recognizes Ttext as an array. The way you were trying to do it before, WiTango wasn't sure whether the string was of type text or of type array, and was taking the array part to assign to the new variable. I'm sure I'm about 90% correct on the reasoning, but I'm sure someone will chime in and correct me if I'm wrong. Bottom line is, you've gotta be careful with your typing. Hope this answers your question. Jonah Simpson [EMAIL PROTECTED] - Original Message - From: Bengt Bredin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:32 AM Subject: SV: Witango-Talk: Array Thanks Jonah ! Yes, I think you are right, but how do I add columns to the request$init_string ? In your example I end up only with the last column from request$Ttext in the request$init_string. If I'm right it's not possible to add columns with @assign, only rows. What I am trying to do is to give the user an array for Excel that's different from the table structure of the database. I don't know the numbers of columns for the Excel array before the user search the database. Best regards Bengt Bredin --- LabIT Solutions AB SWEDEN --- -Ursprungligt meddelande- Från: Jonah Simpson [mailto:[EMAIL PROTECTED] Skickat: den 22 december 2003 16:20 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: Array With the code you're using, you're building an array with a comma-delimited list, which is all well and good, but to the best of my knowledge @var request$Ttext[1,*] will not output in a comma-delimited format that you need. You should probably just create a new variable and iterate through the cols in Ttext, adding each column as it occurs. @cols array=request$Ttext @assign request$init_string value=,@var request$Ttext[1,@curcol] /@cols @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference @var request$init_string Good luck! Cheers, Jonah Simpson [EMAIL PROTECTED] - Original Message - From: Bengt Bredin [EMAIL PROTECTED] To: Witango-Talk [EMAIL PROTECTED] Sent: Monday, December 22, 2003 8:12 AM Subject: Witango-Talk: Array | | Hey list ! | | I would like to say Merry Christmas to you all and at the same time ask | for some help concerning a problem I have. | | I have a one row array @var TText with x numbers of columns in it. | Then I would like to create a new array, also one row with 7 named | columns and the @var TText columns added. | What happens is that I only get the @var TText columns in the new | array. | | @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr, | Sample_Number,Location,Reference,@var request$Ttext[1,*]' | | What am I doing wrong ? | | | Best regards | | Bengt Bredin
SV: Witango-Talk: Array
Thanks Jonah ! Yes, I think you are right, but how do I add columns to the request$init_string ? In your example I end up only with the last column from request$Ttext in the request$init_string. If I'm right it's not possible to add columns with @assign, only rows. What I am trying to do is to give the user an array for Excel thats different from the table structure of the database. I don't know the numbers of columns for the Excel array before the user search the database. Best regards Bengt Bredin --- LabIT Solutions AB SWEDEN --- -Ursprungligt meddelande- Från: Jonah Simpson [mailto:[EMAIL PROTECTED] Skickat: den 22 december 2003 16:20 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: Array With the code you're using, you're building an array with a comma-delimited list, which is all well and good, but to the best of my knowledge @var request$Ttext[1,*] will not output in a comma-delimited format that you need. You should probably just create a new variable and iterate through the cols in Ttext, adding each column as it occurs. @cols array=request$Ttext @assign request$init_string value=,@var request$Ttext[1,@curcol] /@cols @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference @var request$init_string Good luck! Cheers, Jonah Simpson [EMAIL PROTECTED] - Original Message - From: Bengt Bredin [EMAIL PROTECTED] To: Witango-Talk [EMAIL PROTECTED] Sent: Monday, December 22, 2003 8:12 AM Subject: Witango-Talk: Array | | Hey list ! | | I would like to say Merry Christmas to you all and at the same time ask | for some help concerning a problem I have. | | I have a one row array @var TText with x numbers of columns in it. | Then I would like to create a new array, also one row with 7 named | columns and the @var TText columns added. | What happens is that I only get the @var TText columns in the new | array. | | @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr, | Sample_Number,Location,Reference,@var request$Ttext[1,*]' | | What am I doing wrong ? | | | Best regards | | Bengt Bredin | --- | LabIT Solutions AB | SWEDEN | --- | | | | TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: Array
Hey Jonah ! Thanks again for your help. I will try it over Christmas weekend and report back. Merry Christmas to you from a -15 degrees Celsius Stockholmb.. Best regards Bengt Bredin --- LabIT Solutions AB SWEDEN --- -Ursprungligt meddelande- Från: Jonah Simpson [mailto:[EMAIL PROTECTED] Skickat: den 23 december 2003 10:56 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: Array Hey Bengt! Duh, I made a mistake a couple mistakes in my code (musta been too early in the morning) ; Try this: @assign request$init_string value=Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference @rows @cols array=request$Ttext @assign request$init_string value=@var request$init_string,@var request$Ttext[1,@curcol] /@cols @break /@rows @assign name='request$Excel' value=@ARRAY VALUE='@var request$init_string' The idea being that you're creating a string of column names delimited with commas. Then you use the original string (Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference) of comma-delimited values, concatenated with the init_string (which is really a string of comma-delimited values) to form the init string for the array. What you were trying to do before wouldn't work, as by default, when you specify a array like @var request$Ttext[1,*] you're gonna get an output of the form: td@var request$Ttext[1,1]/tdtd,@var request$Ttext[1,2]/td etc for the number of columns in your array. (put @var request$Ttext[1,*] in a results action and then view source to see what I mean). You change the default row and column delimiters in the witango.ini file, but I don't like to code based on defaults, I'd rather explicitly assign everything (never know when you're gonna have to host your code on a server with different defaults). I belive you can set those delimiters inline in your code too, but I could be wrong on that. The reason @assign name=request$Excel value=@var request$Ttext[1,*] works is because WiTango recognizes Ttext as an array. The way you were trying to do it before, WiTango wasn't sure whether the string was of type text or of type array, and was taking the array part to assign to the new variable. I'm sure I'm about 90% correct on the reasoning, but I'm sure someone will chime in and correct me if I'm wrong. Bottom line is, you've gotta be careful with your typing. Hope this answers your question. Jonah Simpson [EMAIL PROTECTED] - Original Message - From: Bengt Bredin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:32 AM Subject: SV: Witango-Talk: Array Thanks Jonah ! Yes, I think you are right, but how do I add columns to the request$init_string ? In your example I end up only with the last column from request$Ttext in the request$init_string. If I'm right it's not possible to add columns with @assign, only rows. What I am trying to do is to give the user an array for Excel that's different from the table structure of the database. I don't know the numbers of columns for the Excel array before the user search the database. Best regards Bengt Bredin --- LabIT Solutions AB SWEDEN --- -Ursprungligt meddelande- Från: Jonah Simpson [mailto:[EMAIL PROTECTED] Skickat: den 22 december 2003 16:20 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: Array With the code you're using, you're building an array with a comma-delimited list, which is all well and good, but to the best of my knowledge @var request$Ttext[1,*] will not output in a comma-delimited format that you need. You should probably just create a new variable and iterate through the cols in Ttext, adding each column as it occurs. @cols array=request$Ttext @assign request$init_string value=,@var request$Ttext[1,@curcol] /@cols @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference @var request$init_string Good luck! Cheers, Jonah Simpson [EMAIL PROTECTED] - Original Message - From: Bengt Bredin [EMAIL PROTECTED] To: Witango-Talk [EMAIL PROTECTED] Sent: Monday, December 22, 2003 8:12 AM Subject: Witango-Talk: Array | | Hey list ! | | I would like to say Merry Christmas to you all and at the same time ask | for some help concerning a problem I have. | | I have a one row array @var TText with x numbers of columns in it. | Then I would like to create a new array, also one row with 7 named | columns and the @var TText columns added. | What happens is that I only get the @var TText columns in the new | array. | | @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr, | Sample_Number,Location,Reference,@var request$Ttext[1,*]' | | What am I doing wrong ? | | | Best regards | | Bengt Bredin
Witango-Talk: Array
Hey list ! I would like to say Merry Christmas to you all and at the same time ask for some help concerning a problem I have. I have a one row array @var TText with x numbers of columns in it. Then I would like to create a new array, also one row with 7 named columns and the @var TText columns added. What happens is that I only get the @var TText columns in the new array. @assign name='Excel' value=@ARRAY VALUE='Sample,Station,Date,Unr/Bnr, Sample_Number,Location,Reference,@var request$Ttext[1,*]' What am I doing wrong ? Best regards Bengt Bredin --- LabIT Solutions AB SWEDEN --- TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
SV: Witango-Talk: SQL data manager tool
Hi Marc ! We still use Pervasive.SQL 2000 in many applications. Not for Witango but others. Error 3020 stands for: 3020: An error occurred while loading the MicroKernel You receive this status code when an error occurs while loading the MicroKernel or when access to the server and client machine shared memory objects are unavailable. Check the Pervasive Event Log (PVSW.LOG) for more information. What do you see in the logfile ? Try to use the Maintenance tool on the server and try to open a Pervasive file and see what happens. Med vänlig hälsning/Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : bengt.[EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Marc Leblanc [mailto:m[EMAIL PROTECTED]com] Skickat: den 4 november 2003 23:04 Till: [EMAIL PROTECTED] Ämne: Witango-Talk: SQL data manager tool Hi all, I was wondering if any of you were still using the Pervasive SQL 2000 database. I'm getting this error while doing a test connection in ODBC. [Pervasive][ODBC Engine Interface][Data Record Manager] An error ocurred while loading the MicroKernel(Btrieve Error 3020). Also in the Pervasive control center I cannot use the SQL data manager tool even if I try to add it through the custom tools properties. Any ideas? This install was done using Tango2000 Application Server (service pack 1) disc on a windows 2000 server OS. Thanks! Marc Leblanc TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
SV: Witango-Talk: SQL data manager tool
Hi Marc ! Its seems to be a problem with the SPX protocol on the server. Do you need SPX on the Windows server ? If not try to take it away from the communication protocols in the Control Center and restart the service. Not sure what you mean with the SQL Data manager Tool is it a Pervasive tool ? I also recommend to update to at least SP3 on the Pervasive.SQL 2000. Med vänlig hälsning/Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Marc Leblanc [mailto:[EMAIL PROTECTED] Skickat: den 5 november 2003 16:28 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: SQL data manager tool Hi Brengt, Thanks for the reply, I'm in a really bad situation right now I get those errors in PVSW.log 10-21-2003 13:22:43 NTMKDE 0414 NTDBSMGR.EXE SERVER I Error initializing the SPX protocol. Error code: 6. 10-21-2003 13:38:32 NTBTRV 03E8 BIN\NTBTRV.EXE SERVER E NTBTRV.EXE failed to load. RC = 4083. 10-21-2003 13:46:56 NTBTRV 00F4 BIN\NTBTRV.EXE SERVER E NTBTRV.EXE failed to load. RC = 6. 10-21-2003 13:50:14 NTMKDE 046C NTDBSMGR.EXE SERVER I Error initializing the SPX protocol. Error code: 6. 11-04-2003 13:41:22 W3MIF10F 133C 2\odbcad32.exe SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:31:22 W3MIF10F 0D5C SW\Bin\pcc.exe SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:32:54 W3MIF10F 16F0 IN\W32MAINT.EXE SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:34:36 W3MIF10F 16F0 IN\W32MAINT.EXE SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:36:04 W3MIF10F 16F0 IN\W32MAINT.EXE SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:51:46 W3MIF10F 16F0 IN\W32MAINT.EXE SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:52:26 W3MIF10F 16F0 IN\W32MAINT.EXE SERVER E 0225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 Any idea why the SQL data manager tool would not be installed. The 10-21-2003 was the installation date. Thanks a lot! Marc Leblanc - Original Message - From: Bengt Bredin To: [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 02:19 Subject: SV: Witango-Talk: SQL data manager tool Hi Marc ! We still use Pervasive.SQL 2000 in many applications. Not for Witango but others. Error 3020 stands for: 3020: An error occurred while loading the MicroKernel You receive this status code when an error occurs while loading the MicroKernel or when access to the server and client machine shared memory objects are unavailable. Check the Pervasive Event Log (PVSW.LOG) for more information. What do you see in the logfile ? Try to use the Maintenance tool on the server and try to open a Pervasive file and see what happens. Med vänlig hälsning/Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Marc Leblanc [mailto:[EMAIL PROTECTED] Skickat: den 4 november 2003 23:04 Till: [EMAIL PROTECTED] Ämne: Witango-Talk: SQL data manager tool Hi all, I was wondering if any of you were still using the Pervasive SQL 2000 database. I'm getting this error while doing a test connection in ODBC. [Pervasive][ODBC Engine Interface][Data Record Manager] An error ocurred while loading the MicroKernel(Btrieve Error 3020). Also in the Pervasive control center I cannot use the SQL data manager tool even if I try to add it through the custom tools properties. Any ideas? This install was done using Tango2000 Application Server (service pack 1) disc on a windows 2000 server OS. Thanks! Marc Leblanc TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.tafTO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
SV: Witango-Talk: PDF stored in db?
Hey Jamileh! Now I have some nice info to you concerning pdf/MSSQL/Witango. You have to use data type image and not text. If using image Witango will readout all binary data including nulls from the blob, just as nice as M$ tools does for the text data type. I updated a record with a 6.2 Mbyte pdf to the image column of my db with a serverside taf . Then read it back also with a serverside taf and it works fine. Of course you have to increase the itemBufferSize in the witango.ini for such a large source Default is 64K. It feels good to focus on something else now, like packing for the SD trip. /Best regards /Bengt Bredin -Ursprungligt meddelande- Från: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Skickat: den 18 september 2003 15:40 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: PDF stored in db? Hey Bengt! Yes, it seems to be a MSSQL/Witango combination - Bill (and others) say it works fine with MySQL. Your experience matches mine - you can work with binary files in MSSQL if you use M$ tools, but not with Witango. Did you see Ben's suggestion about using MySQL just for the binary files? -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:20 AM To: [EMAIL PROTECTED] Subject: SV: Witango-Talk: PDF stored in db? More info about pdf/MSSQL. I made a small taf that from serverside read a pdf file (file action) and updated my data column in the db. Then I read out the data from VB and the pdf data is correct with nulls and all but not if I read it from Witango. So it's only when reading a blob with Witango which includes nulls that we do have a problem. Question still remains to answer is if this only affect MSSQL or is it a common issue ? Best regards Bengt Bredin -- - LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] -- - -Ursprungligt meddelande- Från: Bengt Bredin [mailto:[EMAIL PROTECTED] Skickat: den 18 september 2003 11:16 Till: [EMAIL PROTECTED] Ämne: SV: Witango-Talk: PDF stored in db? Hey, Jamileh, Ben and Bill ! I found out that there isn't any problem to insert a pdf file into a column with datatype text (than xmbyte) in MSSQL 2000 and read it out again. But only if you do it with a tool like VB. We have tried it and we get exactly the same binary data out including the null characters which often exists in a pdf file. And that takes Mr Gates to a safe place. If I let my VB program store a pdf file (with nulls) into the blob and then tries to do a search in Witango from it, the request$resultset[1,data] only includes the characters up to the first null character. The problem seems to be difficulties for Witango, ODBC, MSSQL to upload a pdf including nulls, storing it or reading data from a blob including nulls. It would be very interesting to see if some of you could try this with mysql and a pdf including nulls. Then we know if it's the combination Witango MSSQL or Witango itself causing the problem. -Ursprungligt meddelande- Från: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Skickat: den 17 september 2003 23:28 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: PDF stored in db? You know, that's an idea. I hadn't thought about setting up a separate datasource for the files. H :) -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Hey, Jamileh, MYSQL is free and thanks to Bill, you have the code, just setup a second data source for the blobs :-) Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Yup, text and image columns can hold huge amounts of data...but you have to put it in 8KB at a time. Is that a great system, or what? *g* -Original Message- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:51 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? As Seargeant Schultz said I know nothing about MSSQL. I have had issues with uploading blobs greater than 1MB into mysql (this requires the variable max_allowed_packet be set), and I presume there is a parameter in MSSQL. But ... my copy of Microsoft SQL Server Administrator Guide says binary columns are limited to 8000 bytes
SV: Witango-Talk: PDF stored in db?
=request encoding=none VALUE=HTTP/1.1 200 OK@CRLFServer: Apache 2.0.046@CRLFAccept-Ranges: bytes@CRLFContent-Type: @@request$type@CRLFContent-Disposition: inline; filename=@@request$filename@CRLFLast-Modified: @VAR NAME=date scope=request format=datetime@CRLFContent-Length: @@request$size@CRLF@CRLF@VAR NAME=file SCOPE=request ENCODING=none Hiya Bengt! 1. Check the binary data in your blob against your original file. How are you putting the PDF in? 2. Check the pdf binary data that is displayed against the binary data in the original. I've still not gotten this to work properly, due to a null character used in the PDF format. That characters always truncated the data either at upload or at read; I haven't found a workaround yet. Other folks said they had gotten it working, but they were either doing image files rather than PDF, or were not on MSSQL. (I had to drop the issue when I hadn't managed to resolve it after several days.) If you can give me more info about how your process works, I'll pull the pertinent info I've collected and forward it. Good luck! jamileh -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:28 AM To: [EMAIL PROTECTED] Subject: SV: Witango-Talk: PDF stored in db? Hi all ! I have tried out this example from Troy and Scott but can't get it to work. It's probably some misunderstanding from me, but I try to get some help anyway. So I pull out my blob, a pdf file from the db (MSSQL) and use just a test taf to do this: @ASSIGN NAME=filedata SCOPE=Local VALUE=@@request$resultset[1,data] @EXCLUDE @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLF@SETCOOKIES@CRLF /@EXCLUDE@var request$filedata ENCODING=NONE Now I would like Adobe reader to start inside my browser and show me the pdf, but instead I get: Client Error The response received from the application server is invalid. On some occasions it shows the pdf binary data instead. Hope for better knowledge after San Diego trip Cheers... Bengt Bredin, [EMAIL PROTECTED] Sweden Great work Troy, Something to add, that I discovered the hard way, is that some versions of the Adobe Plug-in for PDF may not initialize properly because the plug-in needs to know the size of the document before hand. So you might want to add Content-Length: to the HTTP Response header, something like: @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLFContent-Length: @LENGTH STR='@COLUMN @DQarticles.art_blob@DQ ENCODING=NONE'@CRLF@SETCOOKIES@CRLF@COLUMN articles.art_blob ENCODING=NONE Of course it might be more efficent to capture the @LENGTH on the upload and store it a separate field next to the PDF content. Hope this helps. Cheers Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) - -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:59 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Here is the trickey part that you need. Use a javascrip and open a new window and call a search action that returns a blob and use this code: @EXCLUDE @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLF@SETCOOKIES@CRLF /@EXCLUDE@COLUMN articles.art_blob ENCODING=NONE @commentother content types-- VALUE=Content-type: image/jpeg, text/html /@comment Troy -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I have done it using R:tango, IIS5 and W2k. R:tango is Tango2000 and an R:base database. I am not sure about how your DB handles the blobs, but to load the files, I upload the the file to a temp file on the server and then do a directdbms command to put the file into the database. Pulling the pdf out if you write it to a temp file on the server and link
SV: Witango-Talk: PDF stored in db?
More info about pdf/MSSQL. I made a small taf that from serverside read a pdf file (file action) and updated my data column in the db. Then I read out the data from VB and the pdf data is correct with nulls and all but not if I read it from Witango. So it's only when reading a blob with Witango which includes nulls that we do have a problem. Question still remains to answer is if this only affect MSSQL or is it a common issue ? Best regards Bengt Bredin --- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] --- -Ursprungligt meddelande- Från: Bengt Bredin [mailto:[EMAIL PROTECTED] Skickat: den 18 september 2003 11:16 Till: [EMAIL PROTECTED] Ämne: SV: Witango-Talk: PDF stored in db? Hey, Jamileh, Ben and Bill ! I found out that there isn't any problem to insert a pdf file into a column with datatype text (than xmbyte) in MSSQL 2000 and read it out again. But only if you do it with a tool like VB. We have tried it and we get exactly the same binary data out including the null characters which often exists in a pdf file. And that takes Mr Gates to a safe place. If I let my VB program store a pdf file (with nulls) into the blob and then tries to do a search in Witango from it, the request$resultset[1,data] only includes the characters up to the first null character. The problem seems to be difficulties for Witango, ODBC, MSSQL to upload a pdf including nulls, storing it or reading data from a blob including nulls. It would be very interesting to see if some of you could try this with mysql and a pdf including nulls. Then we know if it's the combination Witango MSSQL or Witango itself causing the problem. -Ursprungligt meddelande- Från: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Skickat: den 17 september 2003 23:28 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: PDF stored in db? You know, that's an idea. I hadn't thought about setting up a separate datasource for the files. H :) -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Hey, Jamileh, MYSQL is free and thanks to Bill, you have the code, just setup a second data source for the blobs :-) Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Yup, text and image columns can hold huge amounts of data...but you have to put it in 8KB at a time. Is that a great system, or what? *g* -Original Message- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:51 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? As Seargeant Schultz said I know nothing about MSSQL. I have had issues with uploading blobs greater than 1MB into mysql (this requires the variable max_allowed_packet be set), and I presume there is a parameter in MSSQL. But ... my copy of Microsoft SQL Server Administrator Guide says binary columns are limited to 8000 bytes, though text and image columns can be 2^31. Bill this is great, but are you working with MS SQL Server? The issue here is mainly inserting blobs over 8k not just into any DB but MSSQL Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:27 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I realized I didn't explicitly answer your question: I can upload any file type into the db, and download it to a client. The only restriction is that the file extension be in the mime type table, a portion of which is below: idtypeextension 38 video/quicktime .mov 37 video/mpeg .mpg 36 text/xml.xml 35 text/tab-separated-values .tsv 34 text/sgml .sgm 33 text/rtf.rtf 32 text/richtext .rtx Have you done this with __PDF__ files stored in __MSSQL__? If so, how are you loading the files into the db? There is more to this issue than just how to set the HTTP header for display of pdf files. I can read the file contents and display as a pdf; it's the database piece that causes a problem. I suspect Bengt is running into the same issues
SV: Witango-Talk: PDF stored in db?
Hi all ! I have tried out this example from Troy and Scott but can't get it to work. It's probably some misunderstanding from me, but I try to get some help anyway. So I pull out my blob, a pdf file from the db (MSSQL) and use just a test taf to do this: @ASSIGN NAME=filedata SCOPE=Local VALUE=@@request$resultset[1,data] @EXCLUDE @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLF@SETCOOKIES@CRLF /@EXCLUDE@var request$filedata ENCODING=NONE Now I would like Adobe reader to start inside my browser and show me the pdf, but instead I get: Client Error The response received from the application server is invalid. On some occasions it shows the pdf binary data instead. Hope for better knowledge after San Diego trip Cheers... Bengt Bredin, [EMAIL PROTECTED] Sweden Great work Troy, Something to add, that I discovered the hard way, is that some versions of the Adobe Plug-in for PDF may not initialize properly because the plug-in needs to know the size of the document before hand. So you might want to add Content-Length: to the HTTP Response header, something like: @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLFContent-Length: @LENGTH STR='@COLUMN @DQarticles.art_blob@DQ ENCODING=NONE'@CRLF@SETCOOKIES@CRLF@COLUMN articles.art_blob ENCODING=NONE Of course it might be more efficent to capture the @LENGTH on the upload and store it a separate field next to the PDF content. Hope this helps. Cheers Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) - -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:59 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Here is the trickey part that you need. Use a javascrip and open a new window and call a search action that returns a blob and use this code: @EXCLUDE @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLF@SETCOOKIES@CRLF /@EXCLUDE@COLUMN articles.art_blob ENCODING=NONE @commentother content types-- VALUE=Content-type: image/jpeg, text/html /@comment Troy -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I have done it using R:tango, IIS5 and W2k. R:tango is Tango2000 and an R:base database. I am not sure about how your DB handles the blobs, but to load the files, I upload the the file to a temp file on the server and then do a directdbms command to put the file into the database. Pulling the pdf out if you write it to a temp file on the server and link to that file it is very easy. It is a little trickier, but can be done where you pull the file and send it directly to the browser w/o needing to put it in a file on the server. Troy Sosamon Denver, Co. -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:08 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: PDF stored in db? Tango2000, W2K server, IIS5, SQL2K I'm building an application to search and display lots of PDF files. My preference would be to store the files in the database, rather than try to organize and keep track of all the separate files. Does anyone know if this method will work with PDF files? If so, has anyone done a similar app? I'm having problems getting the files loaded displayed - I'm not sure if I'm doing it wrong, or if it's just not going to work. Thanks for any suggestions! jamileh __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
SV: Witango-Talk: PDF stored in db?
Ben, sorry if I mislead you there. In our client/server software (VB) we update the table with a large pdf or zip file to a blob with text datatype. It's been done with oledb. My next mission will be to get it out with Witango and show it for the webusers. The point is that it works with MSSQL to put large files into a blob if the datatype is text. We did have problems with image datatype and therefore changed it. All the best/ Bengt -Ursprungligt meddelande- Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 4 september 2003 17:40 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: PDF stored in db? Wow, I tried Text and it wouldn't take the data, Jamileh and the rest of the list and I would be interested in a snippet of that insert technique. Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 5:07 AM To: [EMAIL PROTECTED] Subject: SV: Witango-Talk: PDF stored in db? Ben ! For you info: We also had problems with IMAGE datatype for the blob. But we changed it to text and it works. We can insert big files (7M) of pdf or zip files into MSSQL. Bengt Bredin [EMAIL PROTECTED] -Ursprungligt meddelande- Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 3 september 2003 19:27 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: PDF stored in db? Ok, this is great work, if they were using a user friendly database, something other than M$SQL. Yes M$SQL says you can set up an IMAGE datatype of up to 2Gig. But this is just for spec. try inserting. The max MSSQL can take is 8k blocks and so your nice IMAGE or PDF will need to be broken into 8k blocks and stored in M$SQLs special format with a reference pointer to all the little 8k blocks So forget doing a simple Insert into dba.ImageTable (ImageData) values (@@local$LoadedImageData) M$SQL is playing the TPC.org game of Transactions per second to say they have the fastest. Of course you can be faster if you drop functionality. Sorry venting here. This is why I use database based on functionality like R:Base or Sybase SQL Anywhere. There might be a COM object that you could use out there, haven't looked. Heck, you could probably setup a second database in Access to store the PDFs/Images Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:13 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Great work Troy, Something to add, that I discovered the hard way, is that some versions of the Adobe Plug-in for PDF may not initialize properly because the plug-in needs to know the size of the document before hand. So you might want to add Content-Length: to the HTTP Response header, something like: @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLFContent-Length: @LENGTH STR='@COLUMN @DQarticles.art_blob@DQ ENCODING=NONE'@CRLF@SETCOOKIES@CRLF@COLUMN articles.art_blob ENCODING=NONE Of course it might be more efficent to capture the @LENGTH on the upload and store it a separate field next to the PDF content. Hope this helps. Cheers Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) - -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:59 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Here is the trickey part that you need. Use a javascrip and open a new window and call a search action that returns a blob and use this code: @EXCLUDE @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLF@SETCOOKIES@CRLF /@EXCLUDE@COLUMN articles.art_blob ENCODING=NONE @commentother content types-- VALUE=Content-type: image/jpeg, text/html /@comment Troy -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I have done it using R:tango, IIS5 and W2k. R:tango is Tango2000 and an R:base database. I am not sure about how your DB handles the blobs, but to load the files, I upload the the file to a temp file on the server and then do a directdbms command to put the file into the database. Pulling the pdf out if you
SV: Witango-Talk: PDF stored in db?
Ben ! For you info: We also had problems with IMAGE datatype for the blob. But we changed it to text and it works. We can insert big files (7M) of pdf or zip files into MSSQL. Bengt Bredin [EMAIL PROTECTED] -Ursprungligt meddelande- Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 3 september 2003 19:27 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: PDF stored in db? Ok, this is great work, if they were using a user friendly database, something other than M$SQL. Yes M$SQL says you can set up an IMAGE datatype of up to 2Gig. But this is just for spec. try inserting. The max MSSQL can take is 8k blocks and so your nice IMAGE or PDF will need to be broken into 8k blocks and stored in M$SQLs special format with a reference pointer to all the little 8k blocks So forget doing a simple Insert into dba.ImageTable (ImageData) values (@@local$LoadedImageData) M$SQL is playing the TPC.org game of Transactions per second to say they have the fastest. Of course you can be faster if you drop functionality. Sorry venting here. This is why I use database based on functionality like R:Base or Sybase SQL Anywhere. There might be a COM object that you could use out there, haven't looked. Heck, you could probably setup a second database in Access to store the PDFs/Images Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:13 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Great work Troy, Something to add, that I discovered the hard way, is that some versions of the Adobe Plug-in for PDF may not initialize properly because the plug-in needs to know the size of the document before hand. So you might want to add Content-Length: to the HTTP Response header, something like: @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLFContent-Length: @LENGTH STR='@COLUMN @DQarticles.art_blob@DQ ENCODING=NONE'@CRLF@SETCOOKIES@CRLF@COLUMN articles.art_blob ENCODING=NONE Of course it might be more efficent to capture the @LENGTH on the upload and store it a separate field next to the PDF content. Hope this helps. Cheers Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) - -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:59 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Here is the trickey part that you need. Use a javascrip and open a new window and call a search action that returns a blob and use this code: @EXCLUDE @ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL @ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE=Content-type: application/pdf@CRLF@SETCOOKIES@CRLF /@EXCLUDE@COLUMN articles.art_blob ENCODING=NONE @commentother content types-- VALUE=Content-type: image/jpeg, text/html /@comment Troy -Original Message- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I have done it using R:tango, IIS5 and W2k. R:tango is Tango2000 and an R:base database. I am not sure about how your DB handles the blobs, but to load the files, I upload the the file to a temp file on the server and then do a directdbms command to put the file into the database. Pulling the pdf out if you write it to a temp file on the server and link to that file it is very easy. It is a little trickier, but can be done where you pull the file and send it directly to the browser w/o needing to put it in a file on the server. Troy Sosamon Denver, Co. -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:08 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: PDF stored in db? Tango2000, W2K server, IIS5, SQL2K I'm building an application to search and display lots of PDF files. My preference would be to store the files in the database, rather than try to organize and keep track of all the separate files. Does anyone know if this method will work with PDF files? If so, has anyone done a similar app? I'm having problems getting the files loaded displayed - I'm not sure if I'm doing it wrong, or if it's just not going to work. Thanks for any suggestions! jamileh __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf