RE: Witango-Talk: Zip Codes into a CSV Excel file
Nope, if it's imported/opened the field as a text, any leading zeroes are gone. You have to force Excel to use the wizard so that you can tell it the field is text before it actually touches the data. (Changing the .csv ending to a .txt will do it.) I dunno if you're trying to do an automatic open...maybe prefixing with a single quote (Excel's denotation for a text field) or enclosing in double-quotes? -Original Message- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 12:36 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Zip Codes into a CSV Excel file When excel opens a document, it looks at the data and tries to determine the datatype and format appropriately. When you open, and it treats as a number, just select that whole row of cells, and go to format menu, and cells. Change the format from whatever type of number it guessed to Text. And it should now display the data correctly. -- 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] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On May 5, 2005, at 10:18 AM, Fogelson, Steve wrote: I am writing an array into a csv file with the following: @var request$Labels aprefix= asuffix= rprefix= rsuffix=@crlf cprefix= csuffix=, Everything works great except when I open it with excel, it removes leading zeros for zip codes. Evidently it thinks it is a numeric field. If you open the csv file with NotePad, it is fine. Any suggestions how to handle this? Thanks Steve Fogelson Internet Commerce Solutions 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
RE: Witango-Talk: Zip Codes into a CSV Excel file
I have this discussion with my users, quite...frequently. :) -Original Message- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 3:33 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Zip Codes into a CSV Excel file You are correct. -- 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] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On May 5, 2005, at 10:42 AM, Wilcox, Jamileh ((HSC)) wrote: Nope, if it's imported/opened the field as a text, any leading zeroes are gone. You have to force Excel to use the wizard so that you can tell it the field is text before it actually touches the data. (Changing the .csv ending to a .txt will do it.) I dunno if you're trying to do an automatic open...maybe prefixing with a single quote (Excel's denotation for a text field) or enclosing in double-quotes? -Original Message- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 12:36 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Zip Codes into a CSV Excel file When excel opens a document, it looks at the data and tries to determine the datatype and format appropriately. When you open, and it treats as a number, just select that whole row of cells, and go to format menu, and cells. Change the format from whatever type of number it guessed to Text. And it should now display the data correctly. -- 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] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On May 5, 2005, at 10:18 AM, Fogelson, Steve wrote: I am writing an array into a csv file with the following: @var request$Labels aprefix= asuffix= rprefix= rsuffix=@crlf cprefix= csuffix=, Everything works great except when I open it with excel, it removes leading zeros for zip codes. Evidently it thinks it is a numeric field. If you open the csv file with NotePad, it is fine. Any suggestions how to handle this? Thanks Steve Fogelson Internet Commerce Solutions __ __ 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
RE: Witango-Talk: Number Generate
Title: Message Steve - you need to put numbers into the attributes, like @RANDOM LOW="1" HIGH="100". That will return a random number between 1 and 100 (inclusive). -Original Message-From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Thursday, November 04, 2004 3:07 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Number Generate Ben Here it is Thanks Steve From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 9:52 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Number Generate Can you send a debug output that shows the insert statement or an excerpt of the taf in a file and attach it. Ben Johansen From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 8:00 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Number Generate Thanks for all the input..its great. I have the following problem, when I put it in a typical builder and I use the following the HTML code with tag: @RANDOM LOW=lowest_possible_value HIGH=highest_possible_value I get the error Main Error Number -3502 Class DBMS Position Insert Syntax error in insert into statement Now this error happens when the insert action in my taf has this in it Column Value Quote Value Number @ARG Number true When I take out this line in the insert action and take it out of the taf html as well. I get no errors.so Has to be the problem..anyone have a workaround Thanks Steve From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 1:41 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Number Generate @RANDOM LOW=lowest_possible_value HIGH=highest_possible_value -Original Message-From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 2:37 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Number Generate Hello I have a table that I am going to insert info into 4 of the 5 fields into the table. In the 5th field, I just want the application to automatically generate a number or a number with some prefixes I choose, and insert that number into the 5th field. I seem to remember in the past using a metatag to do this, but I cant seem to find what I need. Any ideas would be appreciate and thanks in advance. Steve ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.788 / Virus Database: 533 - Release Date: 11/1/2004 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Number Generate
Title: Message @RANDOM will generate a random number; you can set high low limiters in the tag attributes. -Original Message-From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 1:37 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Number Generate Hello I have a table that I am going to insert info into 4 of the 5 fields into the table. In the 5th field, I just want the application to automatically generate a number or a number with some prefixes I choose, and insert that number into the 5th field. I seem to remember in the past using a metatag to do this, but I cant seem to find what I need. Any ideas would be appreciate and thanks in advance. Steve ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Email Issue
Title: Message What version of Witango are you running? T2K had a problem with not correctly changing for DST will behave like this, although I thought it was for all users. -Original Message-From: Michael Dittbrenner [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 8:43 AMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Email Issue I dont think this is a witango problem but involves witango so I figured I ask to see if anyone has any ideas what may be this issue. I have a support request form where users fill out a basic form and it is inserted into a database and they are sent an email. Everything works fine but I have just one user who gets the email back but its set an hour ahead and I cant figure out why. I have myself also get sent on that email and I get the correct time. I have sent her an email from my personal email and it shows the correct time on her system. I have checked her date and time on her computer and that looks good. She is using entourage on mac os 10.3.4 If anyone has any ideas id greatly appreciate it. Mike D Educational Directories Unlimited, Inc. Michael Dittbrenner Programmer http://www.StudyAbroad.com http://www.GradSchools.com A service of EDU, Inc... http://www.EDUdirectories.com A partner of EDU Internet Strategies: http://www.EDUInternetStrategies.com/ [Phone] 610-499-9200 [Fax] 610-499-9205 [E-mail] [EMAIL PROTECTED] or [EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [ot] Databases
Title: Message Primarily $$$. We run some serious data-crunching apps and need to upgrade our server hardware. We bought new servers, butjust discovered that to go over 2G of memory on a SQL server, you must upgrade to SQL Enterprise server at $12K per processor. With 4 CPUs, that's a large chunk o' change that we haven't budgeted for. So we're looking at other db options as one possible solution. -Original Message-From: McElhinny, Greg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 8:55 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: [ot] Databases Wondering why you are getting away from MS SQL 2000? From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED]Sent: Wed 8/11/2004 6:09 PMTo: [EMAIL PROTECTED]Subject: 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
RE: Witango-Talk: [ot] Databases
Title: Message I'll check out Postgre, too. Thanks! -Original Message-From: William M.Conlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 5:57 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: [ot] Databases If cost is not an issue, Oracle sure looks great (but I would read the fine print on the license). Though I use MySQL, many in the open source community are a little peeved about changes being made to the MySQL license. Instead, take a look at Postgre SQL, which may already have most of the features you would be waiting for, and which is open source. Regarding migration, MySQL has a couple of quirks: Timestamp columns: the first timestamp column in a table gets auto updated, no matter what. If you have one varchar in a table, all character types become varchar. On Wednesday, August 11, 2004, at 03:09 PM, Wilcox, Jamileh (HSC) wrote: 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
RE: Witango-Talk: Excel Drops zeros from download with witango
We deal with this all the time on network files (not web). The only solution I know is to save the download file with an extension that Excel doesn't open automatically (e.g., .txt) and thereby force the import wizard, where you can manually designate the field as text. If you find a better way to do this, I'd love to hear it! jamileh -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 8:50 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Excel Drops zeros from download with witango Long standing issue I am not sure how to resolve. In SQL table phone number suffix is a text field. Doing a download of a search to excel. When opens in excel it decides this is a number field and drops the leading zero. Is there anyway around this? Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Some Press for Witango...
John, that's a great writeup! I went out and played with your template tool when you posted it before; it's pretty durn nifty. Congrats! jamileh -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Some Press for Witango... The Wilson Jones Template tool that I've mentioned before was just written up as a Profile at the Design Interact site. http://www.designinteract.com/ The link is on the homepage. On page 3 of the article the Witango application server is mentioned. I stressed it's importance when I was interviewed, but this publication is design oriented, so focusing on the technical aspects wasn't that important to the writer. /John TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Checkbox for database criteria
Vili, I'm not sure I understand what you're trying to do. Here's what I get: you know how to query the database for a list of models, and you know how to list those models on a web form with checkbox selectors. What you're asking is how to query for further info after a user checks some boxes and submits the form. Right? If not, then ignore this. :) Values from a select boxes are returned as a postarg array. The easiest way would probably be to use @MAP to turn your array into a comma-delimited string (you may have to assign the array to a variable first). Then you can query where model in (@@yourstring). This is new with W5, though. If you're using an older version, you'll have to do a FOR loop through your postarg array and either concatenate it to a string and do an IN query, or run a query for each selection. As far as the Search Action vs Direct DBMS - it depends on what you're trying to do. You can do either of the above with a search action. Does that help? jamileh -Original Message- From: McElhinny, Greg [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 6:39 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Checkbox for database criteria Vili, You may also want to look at the 'in' instead of =. e.g. Select * from vehicles where model in ('MERCEDES', 'AUDI', 'FIAT', 'FORD', 'OPEL') Greg -Original Message- From: Vili Cankar [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 7:27 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Checkbox for database criteria Hi, I just wonder if someone can help me with this problem: I have following SQL statement: select * from vehicles where model = 'MERCEDES' and model = 'AUDI' and model = 'FIAT' and model = 'FORD' and model = 'OPEL' I know how to display models from database with check box that I want to include them in the criteria. (There are no fixed models in the sistem, they are read from table in database.) Is it better to use DIRECT DBMS or SEARCH ACTION and would someone give me a hint how to build queryes for users who just check checkboxes next to the right models ? Regards, Vili CANKAR __ __ 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
RE: Witango-Talk: Multiple Table Search Results
Title: Message You'll have to use outer joins between your tables. It'll look something like: FROM tblOne LEFT OUTER JOIN tblTwo ON tblOne.ID = tblTwo.ID LEFT OUTER JOIN tblThree ON tblTwo.ID = tblThree.ID and so on. You're telling it to take ALL records in tblOne, not just the rows with data in both tblOne and tblTwo, and et cetera. I'd suggest building one join at a time and testing it before you add the next - these things can get ugly. jamileh -Original Message-From: Cecilia Cos [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 11:36 AMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Multiple Table Search Results Hello, I have created a web app that basically goes from step 1 to step 2 to step 3 etc... but you cannot go to step 2 without step 1 being completed..etc I would like to do a History report that allows me to see which steps are complete and which steps remain undone I have 7 tables (each step) that I want to search based on the field ID that is the same in all tables. I am doing a search on table 1 in field ID then in the record list I have from table 1 fields ID, Type and Issue Date now I want to display the details of all of the 7 tables... so in the record detail I have put all of the fields from the 7 tables that I want to see and created the joins based on the field ID My problem is this. If steps 1-7 have been completed the record detail shows. but if only steps 1-3 were completed than I get nothing in the detail...and I would like to see that Steps 1-3 were completed while 4-7 remain empty. Any thoughts would be greatly appreciated? Cecilia C. CosData AnalystNewsweek | 251 W 57th Street | New York, NY | 10019212-445-4309[EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [OT] IQ test
Title: Message Silly fun! Except for the Gates reference... Your IQ score is 140 This number is based on a scientific formula that compares how many questions you answered correctly on the Classic IQ Test relative to others. Your Intellectual Type is Facts Curator. This means you are highly intelligent and have picked up an impressive and unique collection of facts and figures over the years. You've got a remarkable vocabulary and exceptional math skills which puts you in the same class as brainiacs like Bill Gates. And that's just some of what we know about you from your test results. I think I took this some time back scored about the same thing. I was wondering if it was a timed test, which could affect the scores (I only get interrupted a half-dozen times on any given task). I guess I could try again tonight from home see how it compares, it would be much speedier the 2nd time around. I know I remembered the general solution (although not the specific answer) to several problems from the last time. I took standard IQ tests when I was a kid. They're MUCH more extensive (several hours). And I agree with Mike that they don't really mean much except for a general level of a few specific skills. There's actually a good book on that subject that explains how IQ tests were developed and how they've been misused and misinterpreted: The Mismeasure of Man by Stephen Jay Gould. I dunno about the descriptions - they strike me as the sort of generic descriptions that apply to most anyone, much like astrology horoscopes and such. But it was a nice break for a bit, being that I remembered how to do most of the difficult ones. ;^D -Original Message-From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 4:14 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: [OT] IQ test Ok, ok, how many of you took the test more than once to beat my score. ;-) I need to know the mean number so that it is a fair playing field. LOL! Ben Johansen - http://www.pcforge.comAuthorized Witango MDaemon ResellerAvailable for Witango Developement -Original Message-From: Alan Wolfe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 13, 2004 9:29 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: [OT] IQ test Steve, i scored the same exact way (i also was disgusted at the picture of bill gates) ::high five:: hehe - Original Message - From: Steve Smith To: [EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 8:25 PM Subject: Re: Witango-Talk: [OT] IQ test Congratulations, Steve! Your IQ score is 135 This number is based on a scientific formula that compares how many questions you answered correctly on the Classic IQ Test relative to others. Your Intellectual Type is Facts Curator . This means you are highly intelligent and have picked up an impressive and unique collection of facts and figures over the years. You've got a remarkable vocabulary and exceptional math skills which puts you in the same class as brainiacs like Bill Gates. And that's just some of what we know about you from your test results. U Bill Gates, ptuie. Now Steve Jobs I could handle.Steve SmithOakbridge Information SolutionsOffice: (519) 624-4388GTA: (416) 606-3885Fax: (519) 624-3353Cell: (416) 606-3885Email: [EMAIL PROTECTED]Web: http://www.oakbridge.caOn Tuesday, July 13, 2004, at 01:57 PM, Ben Johansen wrote: Hi All,I happened upon this site which tests your IQ. It is a pretty grueling 40 question test.I think that most of us on this list are highly intelligent, so lets have some fun and go take the test at http://www.tickle.comHere is my scoreCongratulations, Ben!Your IQ score is129This number is based on a scientific formula that compares how many questions you answered correctly on the Classic IQ Test relative to others.Your Intellectual Type is Insightful Linguist. This means you are highly intelligent and have the natural fluency of a writer and the visual and spatial strengths of an artist. Those skills contribute to your creative and expressive mind. And that's just some of what we know about you from your test results. I paid the 12 buck to get the report and it is pretty insightful.Well if anything it made me feel better today ;-)Ben Johansen - http://www.pcforge.comAuthorized Witango MDaemon ResellerAvailable 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
Witango-Talk: Passing search arguments across links
Title: Passing search arguments across links I have an app that gives web access to pdf documents (policies procedures). It includes a search form that allows users to search all of the db fields and list appropriate policies. I have a completely separate webapp. I need to add a link within that app that will bring up the pp app, with specific policies listed. The policies that need to be listed have matching policy numbers, so the correct listing can be created by putting the proper info in the search form. I can create a link that will do exactly what I want, like so: http://ourintranet/PnP/index.taf?_function=list_type=search_beg=1SearchFor=frmidx The search argument is listed in the link reference (SearchFor=frmidx). Question: is there another way to pass this search arg info (and keep it out of the browser address)? There's not really room to set up a form on the other page, there's barely enough room for a link title. Thanks for any suggestions! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Passing search arguments across links
Title: Message Right, the URL I gave works (those are underscores, not spaces), but leaves the arguments in the address window. Even with hidden args, a form requires a button takes up room thatI don't really have readily available. That's why I was trying to figure out if there was some sneaky third method known only to wizened gurus and Witango experts. ;^) Thanks. j -Original Message-From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 10:22 AMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Passing search arguments across links Hi! First off, yes you can pass those parameters in the URL. Just be sure that if you use spaces, that you put in the %20 parameter for spaces if the argument value contains spaces: DSL modem would be: DSL%20Modem. In the link you provided after the function=list there looks like there is a space between the and the word type. If it's an underscore, then that's ok. If it is a space, you'll have to put the word search right after the . As far as getting the values out of the address window, simply create a form with hidden values: input type=hidden name="type" value="search" input type=hidden name="beg" value="1" etc... Then, it won't be displayed on the page, or in the address. Rick Sanders I have an app that gives web access to pdf documents (policies procedures). It includes a search form that allows users to search all of the db fields and list appropriate policies. I have a completely separate webapp. I need to add a link within that app that will bring up the pp app, with specific policies listed. The policies that need to be listed have matching policy numbers, so the correct listing can be created by putting the proper info in the search form. I can create a link that will do exactly what I want, like so: http://ourintranet/PnP/index.taf?_function=list_type=search_beg=1SearchFor=frmidx The search argument is listed in the link reference (SearchFor=frmidx). Question: is there another way to pass this search arg info (and keep it out of the browser address)? There's not really room to set up a form on the other page, there's barely enough room for a link title. Thanks for any suggestions! 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
RE: Witango-Talk: Passing search arguments across links
Right now it's just a regular link to a document (they click and the document opens up). I'd like to keep it very similar - my users are easily confused! But I need to move the docs to this central storage application and get them started going there for their forms. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 11:16 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Passing search arguments across links In what way are you invoking the link? Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 8:38 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Passing search arguments across links Right, the URL I gave works (those are underscores, not spaces), but leaves the arguments in the address window. Even with hidden args, a form requires a button takes up room that I don't really have readily available. That's why I was trying to figure out if there was some sneaky third method known only to wizened gurus and Witango experts. ;^) Thanks. j -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 10:22 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Passing search arguments across links Hi! First off, yes you can pass those parameters in the URL. Just be sure that if you use spaces, that you put in the %20 parameter for spaces if the argument value contains spaces: DSL modem would be: DSL%20Modem. In the link you provided after the function=list there looks like there is a space between the and the word type. If it's an underscore, then that's ok. If it is a space, you'll have to put the word search right after the . As far as getting the values out of the address window, simply create a form with hidden values: input type=hidden name=type value=search input type=hidden name=beg value=1 etc... Then, it won't be displayed on the page, or in the address. Rick Sanders I have an app that gives web access to pdf documents (policies procedures). It includes a search form that allows users to search all of the db fields and list appropriate policies. I have a completely separate webapp. I need to add a link within that app that will bring up the pp app, with specific policies listed. The policies that need to be listed have matching policy numbers, so the correct listing can be created by putting the proper info in the search form. I can create a link that will do exactly what I want, like so: http://ourintranet/PnP/index.taf?_function=list_type=search_ beg=1Sear chFor=frmidx http://ourintranet/PnP/index.taf?_function=list_type=search; _beg=1Sea rchFor=frmidx The search argument is listed in the link reference (SearchFor=frmidx). Question: is there another way to pass this search arg info (and keep it out of the browser address)? There's not really room to set up a form on the other page, there's barely enough room for a link title. Thanks for any suggestions! __ __ 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 --_=extPart_001_01C468EF.54CCFC82 Content-Type: text/html; charset=s-ascii Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEADTITLEMessage/TITLE META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2800.1400 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVSPAN class=756143115-13072004FONT face=Arial size=2Right, the URL I gave works (those are underscores, not spaces), but leaves the arguments in the address window.nbsp; Even with hidden args, a form requires a button amp; takes up room thatnbsp;I don't really have readily available.nbsp; That's why I was trying to figure out if there was some sneaky third method known only to wizened gurus and Witango experts.nbsp; ;^)/FONT/SPAN/DIV DIVSPAN class=756143115-13072004FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=756143115-13072004FONT face=Arial size=2Thanks.nbsp
RE: Witango-Talk: Passing search arguments across links
Hey, that might work! I'd not thought about using javascript to submit a form from a link. I'll give that a try. Thanks much! -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 11:17 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Passing search arguments across links Hi Jamileh, Using JavaScript, you can use a hyperlink to submit a form that is hidden (with hidden arguments). Something like: form name=secret_form style=margin:0px; method=post action=http://ourintranet/PnP/index.taf?_function=list; input type=hidden name=_function value=list input type=hidden name=_type value=search input type=hidden name=_beg value=1 input type=hidden name=SearchFor value=frmidx /form a href=javascript:document.secret_form.submit();Open PnP Document/a There shouldn't be a limit to how many hidden forms you have on a page, just be careful about how you write your html so that you don't nest any of the forms inside of each other. Hope this helps. Cheers... Scott Cadillac, XML-Extranet ~ 403-254-5002 ~ [EMAIL PROTECTED] Well-formed Programming in C# .NET, Witango, MSIE and XML For Hire ~ http://xmlx.ca/forhire Weblog ~ http://xmlx.ca Forums ~ http://forums.xmlx.ca Knowledge Base ~ http://kb.xmlx.ca IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca P.O. Box 69006 RPO Bridlewood SW Calgary, Alberta Canada T2Y 4T9 From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 9:02 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Passing search arguments across links I have an app that gives web access to pdf documents (policies procedures). It includes a search form that allows users to search all of the db fields and list appropriate policies. I have a completely separate webapp. I need to add a link within that app that will bring up the pp app, with specific policies listed. The policies that need to be listed have matching policy numbers, so the correct listing can be created by putting the proper info in the search form. I can create a link that will do exactly what I want, like so: http://ourintranet/PnP/index.taf?_function=list_type=search_beg=1Sear chFo r=frmidx http://ourintranet/PnP/index.taf?_function=list_type=search_beg=1Sea rchF or=frmidx The search argument is listed in the link reference (SearchFor=frmidx). Question: is there another way to pass this search arg info (and keep it out of the browser address)? There's not really room to set up a form on the other page, there's barely enough room for a link title. Thanks for any suggestions! 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
RE: Witango-Talk: Passing search arguments across links
See how he is! :^) Ben - tried the onLoad; like a page redirect but with args attached. Cool! Not exactly what I need here, but I'll remember that. Scott - perfect! Thanks guys. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Passing search arguments across links This is where I was going, but of course Scott had to rain on my parade ;-) LOL! You can also do this using the onLoad event in the BODY Tag. Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 9:31 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Passing search arguments across links Hey, that might work! I'd not thought about using javascript to submit a form from a link. I'll give that a try. Thanks much! -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 11:17 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Passing search arguments across links Hi Jamileh, Using JavaScript, you can use a hyperlink to submit a form that is hidden (with hidden arguments). Something like: form name=secret_form style=margin:0px; method=post action=http://ourintranet/PnP/index.taf?_function=list; input type=hidden name=_function value=list input type=hidden name=_type value=search input type=hidden name=_beg value=1 input type=hidden name=SearchFor value=frmidx /form a href=javascript:document.secret_form.submit();Open PnP Document/a There shouldn't be a limit to how many hidden forms you have on a page, just be careful about how you write your html so that you don't nest any of the forms inside of each other. Hope this helps. Cheers... Scott Cadillac, XML-Extranet ~ 403-254-5002 ~ [EMAIL PROTECTED] Well-formed Programming in C# .NET, Witango, MSIE and XML For Hire ~ http://xmlx.ca/forhire Weblog ~ http://xmlx.ca Forums ~ http://forums.xmlx.ca Knowledge Base ~ http://kb.xmlx.ca IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca P.O. Box 69006 RPO Bridlewood SW Calgary, Alberta Canada T2Y 4T9 From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 9:02 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Passing search arguments across links I have an app that gives web access to pdf documents (policies procedures). It includes a search form that allows users to search all of the db fields and list appropriate policies. I have a completely separate webapp. I need to add a link within that app that will bring up the pp app, with specific policies listed. The policies that need to be listed have matching policy numbers, so the correct listing can be created by putting the proper info in the search form. I can create a link that will do exactly what I want, like so: http://ourintranet/PnP/index.taf?_function=list_type=search_ beg=1Sear chFo r=frmidx http://ourintranet/PnP/index.taf?_function=list_type=search_beg=1Sea rchF or=frmidx The search argument is listed in the link reference (SearchFor=frmidx). Question: is there another way to pass this search arg info (and keep it out of the browser address)? There's not really room to set up a form on the other page, there's barely enough room for a link title. Thanks for any suggestions! 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
RE: Witango-Talk: Insert to 2 tables based on criteria
Title: Message In the insert section of your taf, you should have an Insert Action to add the record to Table A. Under that, add an IF action to check for @ARG MFGDirect = Yes. Inside the IF, add an Insert Action to add a record to Table B. Like this: ElseIf _function = insert Insert Table A If MFGDirect = Yes Insert Table B -Original Message-From: Cecilia Cos [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 1:26 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Insert to 2 tables based on criteriaHello All, I have a Form with one of the fields being MFGDirect which is a yes no field. When I click submit, I want to check if the MFGDirect field is a Yes or No If it is No, then I want it to just submit the current form info to table A (this is basically a new record builder which I have already setup) But If it is a Yes, in addition to it submitting the current form info to table A, I also want it to submit info to fields in Table B... Any thoughts on what would be the best way of doing this??? Cecilia C. CosData AnalystNewsweek | 251 W 57th Street | New York, NY | 10019212-445-4309[EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango Wiki?
Title: Message I think it's a grand idea, but know absolutely nothing about wikis (other than what I've picked up in general conversation). And I have no servers accessible to the public. But I'd be willing to help work on it, if someone wants to put one up. -Original Message-From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 1:46 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Witango Wiki? Does anyone thinkhaving a witango wiki would be a good idea? I subscribe to a game programming list wherethey just made a wiki and it's great because people can post answers to FAQ's, put up code samples, and all sorts of things. We have some elements of that with peoples various pages, especialy pcforge but a wiki would enable people to post lots of code techniques to do commonly needed tasks (such as Mathew's question about having a dynamic form created in witango and auto-calculated in _javascript_) which other people could review and make suggestions/changes for making the shown technique better. I dont have a server to host a wiki unfortunately butI figuredI'd toss this idea out there in case anyone else agrees it would be a good idea and has the means to make it happen. of course lots of wikis are written in php or python so maybe the first step is someone needs to write awiki in witango? (: TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: [OT] SEO include files
Title: [OT] SEO include files If I'm using INCLUDES (witango asp) for link menus, etc., in my applications - do the search engine robots see those? I've thought that they do but a question came up, so I want to be sure before I give out wrong answers. Thanks for any info! jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [Off] Access to SQL with ASP
It depends on the complexity of the Access setup. The Upsize Wizard does a pretty good job on tables/fields, but not always perfect. If they have any code (macros, modules, field/form specific checks, calculations, etc.) it will be lost. On the other hand, a lot of that could probably be done in your web app instead of the database. So they could well be right in what they're saying. I'm not sure this is an accurate indication of skill level, though. It could take a lot of programming time because they *don't* have the needed skills in SQL. Or it could just be what they've been told by other programmers. -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 10:27 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: [Off] Access to SQL with ASP I am looking for a confirmation of something to check on the skill level of a company I may be working with. They have a content management tool built in Access. It uses ASP. We want them to migrate it to SQL 2000 or MySQL. My understanding was that if the table structures were the same this would not be a complex task. They are saying it will take a lot of programming time. Who's right? -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [OT] SEO include files
Title: Message That's part of what I'm trying to move to slowly... /root /includes /tcfs /images /scripts I didn't know you could make them all read-only, though. I'll do that. -Original Message-From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 2:52 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: [OT] SEO include files This really an option on the server best practice: / (root) contains HMTL and TAFs /include contains included html/tml /TCF contains TCFs The web server should be programmed to not allow read to the /include and /TCF folders. This wont stop Witango or your FTP client from accessing them, but they should not be directly accessible to the internet. Normally these files dont contain much of importance, but some times they do contain sensitive code. Either way, you should always use the Save As Run-Only option any time you have sensitive code in a TAF/TCF. Robert -Original Message-From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 2:02 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: [OT] SEO include files If I'm using INCLUDES (witango asp) for link menus, etc., in my applications - do the search engine robots see those? I've thought that they do but a question came up, so I want to be sure before I give out wrong answers. Thanks for any info! jamileh 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
RE: Witango-Talk: [OT] SEO include files
Title: Message So it works like I thought...robots see include files as part of the page. Since these are straight html, the robots shouldn't have any problems spidering through the links. I'll tell 'em again. Thanks very much everybody! -Original Message-From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 2:49 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: [OT] SEO include files no disagreement. the bots don't find the include files, but they will see whatever the include has to offer as a seamless part of the rendered page. Therefore, if your include has logic in it, the bot will see the product of that logic as part of the page that references the include. so if my include is in the /includes/ directory and says something like IF user=bot This link ELSEIF user=admin another link ELSE nolink then the bot will only see the "this link" and won't know where that include really lives in the directory structure. On Jun 24, 2004, at 11:47 AM, [EMAIL PROTECTED] wrote: Sorry to disagree, but since the files are processed on the server side, the bots don't even know they are includes and they read them just fine. Case in point... If you view source of a taf with an include, what you see is what the bot sees. The code from the include IS displayed as if it is a part of the page. 1. you should protect your /includes/ folder to keep someone from guessing file names and reading them. There's usually nothing to hide, but it's a good practice incase your includes have some logic that you don't want to expose. 2. the includes are processed on the server side, replacing the @include tag with a copy of the file, so there isn't any remnant of the file name or location unless you have it in a comment, therefore robots won't find them On Jun 24, 2004, at 11:02 AM, Wilcox, Jamileh (HSC) wrote: If I'm using INCLUDES (witango asp) for link menus, etc., in my applications - do the search engine robots see those? I've thought that they do but a question came up, so I want to be sure before I give out wrong answers. Thanks for any info! jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Tango to Witango conversion
Thanks all! -Original Message- From: Customer Support [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 3:46 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Tango to Witango conversion It is in the read me document. Here is the list: A Few Things To Note If You Don't Like Reading Manuals. 1 Local scope has been changed to request scope. This more accurately describes the life of the variable. 2 Local scope has been kept as an alias to Request scope to ensure backward compatability. The Witango Dev Studio version 5 uses Request scope with all actions instead of Local scope and will therefore produce code that is not fully compatible with a Tango 2000 server. This can be worked around by opening your taf and tcf files in a text editor and replacing Request with Local in the actions. On a Tango 2000 server all Request scoped variables will function as Custom scoped variables. 3 Request and Method scope have been optimized for speed and will operate faster than shared scopes like Domain, Application and Custom. 4 Always quote your parameter values, especially if they are string values. 5 The server settings now have the default scope set to Request. If you do not scope your variables (we recommend that you do) you will need to change this setting in the witango.ini file to User. Using a default scope of request will typically keep memory usage to a minimum and performance optimized. 6 The httpheader configuration variable does not function the same way in Witango v5.0 as it did in Tango 2000. Partial headers are no longer allowed and you now need to send complete http headers. There are 2 new tags to assist you in formulating http headers - @HTTPREASONPHRASE and @HTTPRESPONSECODE 7 TCF objects now operate in shared scopes without crashing the server. 8 Always scope your variables. This make more robust code and takes load off the server as it does not have to search the different scopes for the variable name. e.g. @@MyVariable forces the server to search the different variable scopes (domain, application, custom, user and request) while @@user$MyVariable would not require the server to search the different scopes. 9 If you have installed an alternate ODBC driver manager ensure that the path in ODBCDMLIBRARY points to the odbc library you are using. 10The license key generated in 30 day trial mode is tied to the machines IP addresses or host names. The server will report an invalid license if either of these changes. This may affect installations on portables. A fully registered license key does not have this restriction. On 22/06/2004, at 11:28 PM, Jason Schulz wrote: The 'Witango Server 5 What's New pdf' has details on the changes between Witango 5 and Tango2000. It isn't a checklist as such, but it is comprehensive. Jason. On 23/06/2004, at 4:14 AM, Wilcox, Jamileh (HSC) wrote: I swear I remember a guide for converting apps that Phil had on the website (it was something like a list of things to remember doublecheck) that was mentioned here. But I can't find it on the website nor any mention in the list archives. Does anyone have a link to this, or did I hallucinate the whole thing? Thanks. j _ _ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf WITH IMAGINATION Planning, Implementation and Management of Web Applications 160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770 web - www.wi.com.au email - [EMAIL PROTECTED] __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Tango to Witango conversion
Title: Tango to Witango conversion I swear I remember a guide for converting apps that Phil had on the website (it was something like a list of things to remember doublecheck) that was mentioned here. But I can't find it on the website nor any mention in the list archives. Does anyone have a link to this, or did I hallucinate the whole thing? Thanks. j TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Numeric Field Formatting??
Title: Message According to the docs, your setup should work as long as your packet key is an integer, as in your example. I'm not sure why it's adding zeroes - is the code here pasted from your app or retyped? If your value is an integer,try one of these for your format see if they work better: num:simple-integer num:,,0-, -Original Message-From: Cecilia Cos [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 12:12 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Numeric Field Formatting??Hello, So I have a numeric field in SQL 2000 and have the info below in an updatable record detail TR VALIGN=TOP ALIGN=LEFT TD Packet Key #: /TD TD @COLUMN "PELog.KeyNo" FORMAT="num:,,,'@@decimalChar',,,'-'," /TD /TR but for some reasonthe field keeps getting formatted and it comes out like this Packet Key #: 123,123.00 but in the table it is 123123 which is what I want Any thoughts or suggestions?Cecilia C. CosData AnalystNewsweek | 251 W 57th Street | New York, NY | 10019212-445-4309[EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Search on Email
Search for an empty string - in MSSQL a null an empty string are two different things. Depending on your Inserts, you may need to check for both. (Looking for an empty string won't find a null, and looking for a null won't find an empty string.) Try this: table.emailaddr != '' jamileh -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 9:09 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Search on Email What would be the best way to do a search to bring back only the records where their was an email address. I can't use null for some reason they seem to be blank not null. SQL 2000 witango 5 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Question about argument names
That makes sense. Thanks for the info! -Original Message- From: Customer Support [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:58 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Question about argument names There is no speed improvement by using _function but if you look at the code that builds the next previous buttons in the search builder you will see where the _ before an argument is used and why Everyware built it this way. This routine removes the args that start with an _ as it is assumed to be a witango control arg (_function, _start) and should not be created as a hidden field. @ROWS ARRAY=request$arg_names @ASSIGN request$arg_name @COL 1 @! Ignore args beginning with _ as they will be passed manually. @IF '@LEFT @@request$arg_name 1' != '_' @! Assign the current argument values to a variable. Use TYPE=ARRAY to get all the values for multi-select lists. @ASSIGN request$arg_values @ARG @@request$arg_name TYPE=ARRAY @! Loop through all the values for the current arg. Build a hidden form field for each. Append field HTML to existing HTML. @ROWS ARRAY=request$arg_values @ASSIGN request$search_vals_HTML '@@request$search_vals_HTMLinput type=hidden name=@VAR request$arg_name value=@COL 1 /@CRLF' /@ROWS /@IF @! End ignoring args beginning with _ /@ROWS The reason for ignoring them is that they are manually added to the form action and do not need to be added as a hidden post arg. form method=post action=@APPFILE? _function=list_start=@@request$new_start@UserReferenceArgument If they were not stripped out, every iteration of the next/previous functionality would add more and more of the same arg and so you would end up with multiple values for the args controlling the loop. You would also have a http header that was continually growing in size as more and more hidden post args are created. If you want to see the affect, do a global change on _function to function in a search builder. Turn debug on and look at the post args that are passed through. In this situation, after quite a few next iteration, you will see a slow down in both the web server and witango server as they have to process an every increasing number of post args in the http header. Witango Support On 02/06/2004, at 7:32 AM, Scott Cadillac wrote: Hi Jamileh, I'm not sure about the _function argument, but I have a vague memory of an engineer confiding in me at a Conference once that if you include the following argument in a TAF file request - the Server automatically goes into Secret-double-hyper-overdrive and will run 200% faster. http://www.mydomain.com/some.taf?_function=listPhilIsAGod=true Or was it PervasiveBits=true? I can't remember which, except it started with a P. If I could remember which Conference it was (I've been to a few), than that might help me remember. . . . . . . . Sorry to make you a victim of my deprived humor Jamileh :-) No, I don't believe there is any truth to it. I think this question was brought up in the past, but my understanding is that _function is simply a training standard, so is widely adopted. I'm just in a weird mode today, can't ya tell? From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 2:50 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Question about argument names I seem to remember reading something on the list about it being preferable to use the argname _function, because Witango recognizes that and will process faster. I've tried to find the original posts but no luck. Can anyone give me more info on this? Is it true? Are there other key argnames that I should use when possible? Thanks much! __ _ _ 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
Witango-Talk: Question about argument names
Title: Question about argument names I seem to remember reading something on the list about it being preferable to use the argname _function, because Witango recognizes that and will process faster. I've tried to find the original posts but no luck. Can anyone give me more info on this? Is it true? Are there other key argnames that I should use when possible? Thanks much! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Question about argument names
Sorry to make you a victim of my deprived humor Jamileh :-) deprived? or depraved? ;^) I'm gonna try that arg in my whitespace application - man, that thing is gonna ZING! I'll let ya know which one works better. Must be the post-long-weekend exhaustion hitting. :) j -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 4:32 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Question about argument names Hi Jamileh, I'm not sure about the _function argument, but I have a vague memory of an engineer confiding in me at a Conference once that if you include the following argument in a TAF file request - the Server automatically goes into Secret-double-hyper-overdrive and will run 200% faster. http://www.mydomain.com/some.taf?_function=listPhilIsAGod=true Or was it PervasiveBits=true? I can't remember which, except it started with a P. If I could remember which Conference it was (I've been to a few), than that might help me remember. . . . . . . . No, I don't believe there is any truth to it. I think this question was brought up in the past, but my understanding is that _function is simply a training standard, so is widely adopted. I'm just in a weird mode today, can't ya tell? From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 2:50 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Question about argument names I seem to remember reading something on the list about it being preferable to use the argname _function, because Witango recognizes that and will process faster. I've tried to find the original posts but no luck. Can anyone give me more info on this? Is it true? Are there other key argnames that I should use when possible? Thanks much! __ __ 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
RE: Witango-Talk: Problem assigning Array values in local and user scope
Can you copy and paste in send the exact code from the server that is failing? (IME, sometimes I think I've got the exact same code on both, but I don't.) -Original Message- From: Mike Scally [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Problem assigning Array values in local and user scope Nope, tried it and purge in or out doesn't make a difference it still fails... -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 17:20 To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Problem assigning Array values in local and user scope I assume that if you take the purge out of there it works ok... /John Mike Scally wrote: John, Its 4.05.020 ... The strange thing is both Development box and Deployment Box are up to the same version 4.05.020 Cheers Mike. -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 17:01 To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Problem assigning Array values in local and user scope Mike, What specific version of Tango2000 are you running? Hint: Use the @version tag to find out... /John Mike Scally wrote: Hi, I am having a problem assigning arrays. I cannot figure out the issue but I have simplified the problem down to reproduce the error and the following 4 lines suffice. I assign an array in local scope, then assign this to a user variable. I purge the local variable but if I re-assign back to a local variable the new local variable is empty. Lines of code as follows : @ASSIGN NAME=myArray VALUE=@ARRAY ROWS='1' COLS='1' VALUE='12234' SCOPE=local @ASSIGN NAME=myArrayUser VALUE=@VAR local$myArray SCOPE=user @PURGE NAME=myArray SCOPE=local @ASSIGN NAME=myArrayLocal SCOPE=local VALUE=@VAR user$myArrayUser New Local Array : @VAR local$myArrayLocal The user$myArrayUser variable contains 1 row as expected but the local$myArrayLocal is empty and never gets assigned the value of user$myArrayUser. This works on my development server but when deployed on the same version of Tango Server it fails. If anyone had any ideas at all they would be much appreciated. Could it be some kind of Tango Configuration issue? Setup : Windows 2000 Tango2000 Thanks Mike. This message is intended only for the use of the person(s) (the intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board). Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems. __ _ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf This message is intended only for the use of the person(s) (the intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board). Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems. _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf This message is intended only for the use of the person(s) (the intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the
RE: Witango-Talk: Development Studio Crashing on Windows VERY ANNOYING.
That's not the version I'm currently using, but I have had similar problems in the past with I-don't-remember-which version. My solution was to add a couple of Saves into the process, something like: Open Witango Studio Create New Taf File Save Add Assign Action to New Taf Save Double Click on Assign Action Change Scope From Default to Request I think it was the Save after adding the Assign Action that was critical, but I don't remember for sure, so you might play with it a bit. At any rate, it seemed to solve the problem, and was only a marginal PITA. Good luck! jamileh -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 1:26 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Development Studio Crashing on Windows VERY ANNOYING. if you change your steps it might help. something like creating a new taf, adding a results html, then adding the assign action, then doing something else and then changing to request scope. if that doesnt help, rebooting might clear it up. sounds kinda like it might be a memory corruption problem which are normaly really fickle and random, so you should be able to find a way around it (: - Original Message - From: John McGowan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 11:11 AM Subject: Re: Witango-Talk: Development Studio Crashing on Windows VERY ANNOYING. thanks for the suggestion, but I'm looking for a workaround that still lets me use the assign action. /John Stefan Gonick wrote: I'm not using that version, but that sounds very frustrating. You might try assigning variables in a results html action. eg. @assign request$My_Var 10 That should get around your problem. Stefan At 02:01 PM 5/12/2004, you wrote: The following step are causing My witango dev studio to crash... This is making my job very dificult. anybody else having this problem? Version: 5.5.08 Open Witango Studio Create New Taf File Add Assign Action to New Taf Double Click on Assign Action Change Scope From Default to Request ---Dev Studio Crashes--- Date: Wed May 12 12:59:53 2004 Product: Witango Studio Version: 5.5.08 License Key: x-x-x-x Operating System: Windows NT, 5.1, 2600, Service Pack 1 Unhandled exception: 0xc005 Address:0x77d45391 This happens every time I try to modify the scope of a new assign action. Making my life very painful right now. If anybody is experiencing this and knows of a workaround I'd be very interested to know it. /John __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf = Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com 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
Witango-Talk: Server Statistics
Title: Server Statistics I asked about webstats programs a while back received several suggestions, which got me off to a good start. I've had to compile a comparison list for mgt here, so I thought maybe someone else could use it. Some of my notes are pretty sketchy (of course, I postponed the research until the last minute ;) and may not be much help, but you can get a general idea. I'm sure I didn't list 'em all, either. It's a tab-delimited Excel export. SoftwareComparisons.txt Product Company Web RequirementsWebserver requirements Webpage requirements FeaturesMethod Support Price Other Recommended by Analog 5.32 http://www.analog.cx/ Any OS Any webserver none Multiple languages; very fast; highly configurable; reads all standard formats and allows custom formats; very scalable Log file analysis Mail List; online userguides and tutorials; third party vendors FreewareMany helper applications Jason Schulz [witango list]: For others analog is useful. AWstats Laurent Destailleur http://awstats.sourceforge.net/ Any OS Perl, any webserver noneWeb, FTP and mailserver logs. Robots detected. Log file analysis Online documentationfreewareHelper apps available ClickTracks ClickTracks http://www.clicktracks.com/ Win98+ any depends on product Page reports, link reports, path reports, visitor info by defined group for each page; search engine reports including keyword vs engine; primarily geared to pay-per-click sites; visitor behavior; import/export capable; visitor labeling for grouping reporting; reports shown on website page. visitor behavior analysis geared towards marketing/advertising.5 products - 2 log file analyzers, 3 javascript embedded. online email during business hours; telephone for certain packages. $495-3000+; online $49-$239+/month FreeStats Mega Web Services Inc http://freestats.com/ NoneNoneAdd scripts to webpages.Traffic reports, marketing reports (search engines, referrers, keywords, etc.), path reports, visitor profile reports. Higher levels increase features, reports, history.Page embedding using javascripts; online serviceonline during business hoursfree w/banner ads; bannerless $2.99-$8.99/month Appears to be same as SiteTracker HBX OnDemand Web Analysis (aka HitBox) WebSideStoryhttp://www.hbxondemand.com Nonenoneunknown - not on websitewebsite navigation analysis, ecommerce analysis, campaign analysis, content analysis, visitor analysis - custom visitor grouping; custom reports into Excel; executive KPI dashboard; overlay stats/reports onto website pages. additional upgrades/modules available. online unknown - not on websiteunknown - not on website HitCounter Lorentz Consulting Grouphttp://hitcounter.leveltendesign.com/ ? Perl or PHP Add logo/program to webpagesTraffic summary, page comparisons, path reports, referrer reports, historical reports, browser reports. Page embedding using Perl or PHPuser forum Free but logo on pages LiveStats XSP DeepMetrix http://www.deepmetrix.com/livestats/xsp/ Windows2000+; MSDE included or use with MSSQL. Any OS, any webserver.none Multiple servers; reimport for reprocessing previous log files; full search; SOAP interface; customize reports available; command line interface; live statistics, page reports, visitor reports, referrals, demographics; custom reporting; graphs, trending, etc.; export email reports; search engine results; Log file analysis Automated website setup; automated account creation for report viewing; automated db maintenance; 12 month support plan included. 30 day full function demo.$1,095 Tom Ferguson [witango list] I've used a product called Live Stats from a Canadian company named Media House for years. It is rock solid, accurate, and their tech support is superb. LiveStats.NET v7MediaHouse Software / DeepMetrix http://www.deepmetrix.com/livestats/net/SQL backend (MSDE included or separate full SQL server), Win2000/XP/2003 any OS, any webserver, anywhere; can collect statistics from remote servers Use provided installers or manually add scripts to webpages.Visitor tracking (even thru caches/proxies/firewalls/etc.; not IP dependent;excludes spiders); live (not from log) stats; interactive graphic reports including geographic maps, comparisons, trending forecasting, history, search engine usage, site paths, visitor demographics, browser/screen resolution info, flash, etc.; customizable reports; multiple accounts and/or multiple servers; web-based reports accessible via internet; schedule or demand email reports; exportable reports; scalable to very high
RE: Witango-Talk: Server Statistics
Thanks John! That's the one I thought looked best for us...good to have some feedback on it. -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 1:39 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Server Statistics Jamileh Others, Up until very recently our shop used web trends. and before that, funnel web. In the last month we evaluated and installed Urchin. It's in the list below, but I just wanted to put a personal stamp of approval on the product. It's the best stats package I've ever worked with. If anybody wants more information about it feel free to contact me directly. Urchin reminds me of Witango. It's made by a small company and seems to blow away the competition and is worth every penny we paid for it. /John Wilcox, Jamileh (HSC) wrote: I asked about webstats programs a while back received several suggestions, which got me off to a good start. I've had to compile a comparison list for mgt here, so I thought maybe someone else could use it. Some of my notes are pretty sketchy (of course, I postponed the research until the last minute ;) and may not be much help, but you can get a general idea. I'm sure I didn't list 'em all, either. It's a tab-delimited Excel export. SoftwareComparisons.txt - -- - Product Company Web RequirementsWebserver requirements Webpage requirementsFeaturesMethod Support Price Other Recommended by Analog 5.32 http://www.analog.cx/ Any OS Any webserver noneMultiple languages; very fast; highly configurable; reads all standard formats and allows custom formats; very scalableLog file analysis Mail List; online userguides and tutorials; third party vendors Freeware Many helper applicationsJason Schulz [witango list]: For others analog is useful. AWstats Laurent Destailleur http://awstats.sourceforge.net/ Any OS Perl, any webservernoneWeb, FTP and mailserver logs. Robots detected.Log file analysis Online documentation freeware Helper apps available ClickTracks ClickTracks http://www.clicktracks.com/ Win98+any depends on product Page reports, link reports, path reports, visitor info by defined group for each page; search engine reports including keyword vs engine; primarily geared to pay-per-click sites; visitor behavior; import/export capable; visitor labeling for grouping reporting; reports shown on website page. visitor behavior analysis geared towards marketing/advertising. 5 products - 2 log file analyzers, 3 javascript embedded. online email during business hours; telephone for certain packages. $495-3000+; online $49-$239+/month FreeStatsMega Web Services Inc http://freestats.com/ None NoneAdd scripts to webpages.Traffic reports, marketing reports (search engines, referrers, keywords, etc.), path reports, visitor profile reports. Higher levels increase features, reports, history. Page embedding using javascripts; online service online during business hoursfree w/banner ads; bannerless $2.99-$8.99/month Appears to be same as SiteTracker HBX OnDemand Web Analysis (aka HitBox) WebSideStory http://www.hbxondemand.comNonenoneunknown - not on websitewebsite navigation analysis, ecommerce analysis, campaign analysis, content analysis, visitor analysis - custom visitor grouping; custom reports into Excel; executive KPI dashboard; overlay stats/reports onto website pages. additional upgrades/modules available. onlineunknown - not on websiteunknown - not on website HitCounter Lorentz Consulting Group http://hitcounter.leveltendesign.com/ ? Perl or PHP Add logo/program to webpages Traffic summary, page comparisons, path reports, referrer reports, historical reports, browser reports.Page embedding using Perl or PHP user forum Free but logo on pages LiveStats XSPDeepMetrix http://www.deepmetrix.com/livestats/xsp/ Windows2000+; MSDE included or use with MSSQL. Any OS, any webserver. noneMultiple servers; reimport for reprocessing previous log files; full search; SOAP interface; customize reports available; command line interface; live statistics, page reports, visitor reports, referrals, demographics; custom reporting; graphs, trending, etc.; export email reports; search engine results; Log file analysis Automated website setup; automated account creation for report viewing; automated db maintenance; 12 month support plan included. 30 day full function demo. $1,095 Tom
Witango-Talk: DB transactions
So the BT/ET works on MSSQL if you're writing to the db? I'm in the middle of a large application and this is fairly critical to the pieces I've built. It's worked so far in testing, but hasn't been stressed with many concurrent users yet. Begin Transaction Insert Table1 Search Table1 for ID Insert Table2 with Table1 ID Search Table2 for ID etc End Transaction If that's not going to work all together to ensure that I've got the correct ID links, then I'm going to have to rebuild that process. Thanks. jamileh -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 8:52 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Sleep While + explanations Even Further Clarification You *can* get it to behave the way I explained. By adding more than just Search Actions or SELECTs to the code inside of the transaction. You have to have something that creates a dependency. For example, I can't do a read in hitsecond.taf, because someone else may have done a write in hitfirst.taf. I'll attach another screenshot showing a situation where the second taf doesn't finish until the first one leaves the transaction, but then i'll be quiet. :) /John John McGowan wrote: never mind about my post below... The transactions do what they're supposed to do, isolate the database transactions from eachother, but they do not do what I proposed below. The second hit finishes before the first hit. If your problem is that you don't want more than 1 DB transaction going on ever, could this be handled by limiting the number of connections to the database to 1 connection? /John John McGowan wrote: Why aren't you just using the DB Transactions? I think the assumptions you made about Witango 5 vs T2K and how the threading affects the use of those are false. We've been using Begin and end transactions without any problem. And have been running W5 for quite some time. If you want to prove it to yourself, do what I did. Use the suggestions earlier in this thread to do an external action that waites for some period of time. Create 2 tafs like the ones in the screenshot I've attached. (hitfirst.taf and hitsecond.taf) if threading and transactions don't work properly, hitsecond.taf should return results before hitfirst.taf You won't see that though. The actions in side of the transaction block of hitfirst.taf will have to complete before the hitsecond.taf will enter the block. just because a thread pre-empts doesn't mean that another thread waiting for it to complete will not continue to wait. I would argue that the old threading method of witango allowed many people to get away without using transactions (unless they were running on multiple processors or multiple servers) And the real use for transactions only comes now that we have a truly threaded application server. Anyone disagree with this? /John [EMAIL PROTECTED] wrote: Yes, I am using MS SQL but I thought I'd rather not use SPs to keep the code transportable. It was also one of the recommendations in the old Tango 2000 documentation. I was afraid of getting these answers... We are now talking redesign... I wish I knew better what I was getting into. Thank you for all your input; it really helps. - Mike. -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 14:43 To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Sleep While + explanations One thing to note is that BT/ET actions are very robust with the right database, and can be trusted. Also, look into stored procedures, and using internal (to the SP) transactions. Rather than using a variable to block further db access, use a value in a table (controlled by the SP). Better yet, just do everything in the SP and let the DB worry about the overhead, they are much faster for most things. Robert -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 14:39 To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Sleep While + explanations Thank you Mike, Now I'm seeing a bigger picture for what you're up against. Yes, the new Threading model in Witango 5.0, although greatly more efficient in many respects, can introduce timing issue with controlling Transaction blocks. I haven't seen mentioned what Database you're using? For such a fine need of control, Stored Procedures in SQL Server, for example, can help. A Stored Procedure will execute much faster than a series of Database Actions, which could go a long way to eliminating timing/resource conflicts. Hope this helps. Cheers... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April
RE: Witango-Talk: Contact with Australia
I emailed Support last Wednesday with a question haven't had a response. I just figured they were busy and hadn't gotten back to me. -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 10:17 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Contact with Australia Has anybody had any contact with Australia lately I'm having the hardest time trying to buy a product. Trying to figure out if Phil and Sophie are on Vacation or something... /John __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Select a submit button in a form (OT)
Steve - here's several different javascripts I collected when I was trying to solve the same problem. The bottom one (submit wait) is one I'm using. I can't verify the others - some I got working and some I didn't, but I don't remember which. Enjoy! -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 4:25 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Select a submit button in a form (OT) I think I am going to incorporate 2 or 3 of the ideas. Java script looks good. I should double check for products already added. I have to add a little bit to this as I allow product options as well and will have to check them as well. I believe I am using a single threaded ODBC for my db. Still working on some issues with the multi threaded version. So this may be a cause as well. Not ready to move to an array based cart but will consider that. Thanks for all the ideas. Steve -Original Message- From: Dave Shelley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 4:12 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Select a submit button in a form (OT) Steve, On your form tag, add onSubmit=return(checkSubmit()) and add a javascript function that says: var submitted=false; function checkSubmit() { if (submitted==false) { sunmitted=true; return true; } else { alert('Already submitted'); return false; } } That should do it. Dave. -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: April 15, 2004 4:40 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Select a submit button in a form (OT) I am having problems with shoppers selecting the Add To Cart button repeatedly. It all happens within a few seconds. They are probably impatient when the server is busy. Is there a way to display something immediately when the shopper selects the button to indicate we are processing? Thanks for any ideas Steve Fogelson Internet Commerce Solutions __ __ 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=== //script from http://www.rgagnon.com/jsdetails/js-0110.html script var submitDone = false; function submitForm(myForm, button) { if (!submitDone) { submitDone = true; button.value = 'Please Wait'; button.disabled = true; myForm.submit(); } else { alert (Already submitted, please wait!); } return true; } /script form name=longsubmit action=http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?query=foo; Impossible to submit multiple times input type=button value=Go onClick=return submitForm(document.longsubmit, this) /form === script type=text/javascript /* Block multiple form submission script- By JavaScriptKit.com Visit http://www.javascriptkit.com for this script and more This notice must stay intact for use */ //Enter error message to display if submit button has been pressed multiple times below. //Delete below line if you don't want a message displayed: var formerrormsg=You\'ve attempted to submit the form multiple times.\n Please reload page if you need to resubmit form. function checksubmit(submitbtn){ submitbtn.form.submit() checksubmit=blocksubmit return false } function blocksubmit(){ if (typeof formerrormsg!=undefined) alert(formerrormsg) return false } /script form input type=submit value=Submit onClick=return checksubmit(this) /form === function SubDisable(dform) { if (document.getElementById) { for (var sch = 0; sch dform.length; sch++) { if (dform.elements[sch].type.toLowerCase() == submit) dform.elements[sch].disabled = true; } } return true; } form onSubmit=SubDisable(this); Value: input type=text name=dvalue input type=submit value=Test This /form === HEAD SCRIPT LANGUAGE=JavaScript !-- Begin var submitcount=0; if (submitcount == 0) { submitcount++; return true; } else { alert(This form has already been submitted. Thanks!); return false; } // End --
RE: Witango-Talk: Import CSV
-Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Hey, I asked for tab delimited and look what I got. *g* Yeah, I've got a few of those, too. That is a very good point and one I hadn't thought of. It is the same fields in each record that are quoted. I'll try your REGEX stuff but I've never had much luck with it before. I believe this is because REGEX didn't work real well in T2000 so I might try in WT5 instead. If you find a clear explanation of POSIX regex, send it in. I end up cross-eyed every time I try to read the stuff I've found. I've never gotten it working in Tango, but I thought it was just me. -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Be sure to use Witango 065 as the REGEX code was just recently updated. So how do I tell which version I'm on? I thought I'd updated to 065, but when I check the About in Witango it says 5.0.1.037 - am I looking in the wrong place or am I imagining the update? If regex is working better now, I'd start using it. Thanks! j TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: List of files in a folder
I can send you a copy of a T2000 setup for Windows to do this, if that would help. I can't translate to Mac, though. -Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 1:24 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: List of files in a folder There is an example (by Fergal) on the component zone on witango.com Cheers, I'll check it out. I'm currently working on a TAF that loads the index.dir result into a VAR and then parses it. Should be fun. Wayne Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: CSV into Array
Pretty nifty! -Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:32 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: CSV into Array Sussed it!! @ELSEIF '@VAR local$CurrChar=@CHAR CODE=44' @IF '@VAR [EMAIL PROTECTED]=OFF' @ASSIGN NAME=NewString VALUE=@VAR local$NewString[COL] SCOPE=LOCAL @ELSEIF @VAR [EMAIL PROTECTED]='ON' @ASSIGN NAME=NewString VALUE=@VAR local$NewString@VAR local$CurrChar SCOPE=LOCAL Notice the @s where there should be $! Also, I was checking for one character matching @CRLF, which is two characters. Here's the code all working and spiffy. If anyone wants to use it feel free. @VAR local$FileContentsbrhr @ASSIGN NAME=DoubleQuote VALUE='OFF' SCOPE=LOCAL @ASSIGN FileContents VALUE=@REPLACE STR=@VAR local$FileContents FINDSTR=@CRLF REPLACESTR=[ROW] SCOPE=LOCAL @LENGTH @VAR local$FileContentsbr @DEBUG TABLE /@DEBUG @FOR START=1 STOP=@LENGTH @VAR local$FileContents @DEBUG TR TD @CURROW /TD TD /@DEBUG @ASSIGN NAME=CurrChar Value=@SUBSTRING STR=@VAR local$FileContents START=@CURROW NUMCHARS=1 SCOPE=LOCAL @DEBUG @VAR local$CurrChar /TD /@DEBUG @IF EXPR='@VAR local$CurrChar=@DQ' @DEBUG TD Double Quote /TD /@DEBUG @IF '@VAR local$DoubleQuote=ON' @ASSIGN NAME=DoubleQuote VALUE='OFF' SCOPE=LOCAL @ELSEIF '@VAR local$DoubleQuote=OFF' @ASSIGN NAME=DoubleQuote VALUE='ON' SCOPE=LOCAL /@IF @ELSEIF EXPR='@VAR local$CurrChar=@CHAR CODE=44' @DEBUG TD Comma /TD /@DEBUG @IF '@VAR local$DoubleQuote=OFF' @ASSIGN NAME=NewString VALUE=@VAR local$NewString[COL] SCOPE=LOCAL @ELSEIF @VAR local$DoubleQuote=ON @ASSIGN NAME=NewString VALUE=@VAR local$NewString@VAR local$CurrChar SCOPE=LOCAL /@IF @ELSE @DEBUG TD Other /TD /@DEBUG @ASSIGN NAME=NewString VALUE=@VAR local$NewString@VAR local$CurrChar SCOPE=LOCAL /@IF @DEBUG TD @VAR local$DoubleQuote /TD TD @VAR local$NewString /TD /TR /@DEBUG /@FOR @DEBUG /TABLE /@DEBUG @VAR local$NewStringbrhr @ARRAY NAME=UpdateArray VALUE=@VAR local$NewString CDELIM='[COL]' RDELIM='[ROW]' SCOPE=local @VAR local$UpdateArray Wayne Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Import CSV
Doh! I'm going to wake up, soon, I swear. Thanks. -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 9:12 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Import CSV Robert is talking about the server version... 5.0.1.065 The current production version for osx, windows and linux. Wilcox, Jamileh (HSC) wrote: -Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Hey, I asked for tab delimited and look what I got. *g* Yeah, I've got a few of those, too. That is a very good point and one I hadn't thought of. It is the same fields in each record that are quoted. I'll try your REGEX stuff but I've never had much luck with it before. I believe this is because REGEX didn't work real well in T2000 so I might try in WT5 instead. If you find a clear explanation of POSIX regex, send it in. I end up cross-eyed every time I try to read the stuff I've found. I've never gotten it working in Tango, but I thought it was just me. -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Be sure to use Witango 065 as the REGEX code was just recently updated. So how do I tell which version I'm on? I thought I'd updated to 065, but when I check the About in Witango it says 5.0.1.037 - am I looking in the wrong place or am I imagining the update? If regex is working better now, I'd start using it. Thanks! j _ __ _ 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
RE: Witango-Talk: Import CSV
I'd say the first thing to try is ask him if he can produce csv files with all fields quoted. That may or may not be possible, depending on the program he's using and his level of expertise, but you could ask. If that's not possible, are they standard files? By which I mean, the same columns always have the same datatype: 123,456,COL3,789,Col,5,012 If so, you could probably write a regex to replace the field delimiter columns with another character, something like: Find: ^([0-9]*),([0-9]*),(.*),([0-9]*),(.*),([0-9]*)$ Replace with: ^\1|\2|\3|\4|\5|\6$ which would give you: 123|456|COL3|789|Col,5|012 You'd still have to loop through all the lines, though. Then you can assign it to a witanto array as below, just change your cdelim to the pipe character. (The above is a Unix-style regex in UltraEdit. Test the code for yourself - no warranties, express or implied. ;^P I'm not that familiar with Witango or Javascript regex, so I can't help you much there.) Hope this might help. jamileh -Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 12:44 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Import CSV heres a simple way to get csv data into a witango array: @assign user$csvdata value=@array cols=2 value='@arg csvdata' rdelim='@crlf' cdelim=',' dunno if that helps any, just tossing it out hoping that it does That doesn't address the issue of fields containing commas which is the sole reason for this question in the first place? Wayne Irvine Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [OFF] EDI Programs windows
I've been looking at EDI mappers specifically for HIPAA files. I dunno about VAN sr - that's not something we're doing. I don't know if my notes would be helpful to what you're doing, but if you want 'em just let me know. jamileh -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:05 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: [OFF] EDI Programs windows Any suggestions for EDI programs for windows. Has to be able to create Maps based on EDI spec and send a receive with VAN. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Problem with date Metatags
Title: Problem with date Metatags Windows 2000, Witango 5.0.1.062 I'm having a problem with using the date-based metatags on dates entered with 2-digit years. ISDATE works fine and recognizes both 4-digit and 2-digit years. The documentation for the other tags (DAYS, DATEDIFF, DATETOSECS) says that they will convert 2-digit years to 4-digit years (i.e., 00-36 become 2000-2036, 37-99 become 1937-1999), but that's not happening correctly. The standard dateFormat is set to the default (%m/%d/%Y). I've looked for other configuration settings, but haven't found any. I tried searching the list archives, but didn't find any previous mention. Is anyone familiar with this problem? Thanks! jamileh Examples: Witango code needby date: @ARG A5#NeedBy_Datebr isdate: @ISDATE VALUE=@ARG A5#NeedBy_Datebr datediff: @DATEDIFF DATE1=@ARG A5#NeedBy_Date DATE2=@CURRENTDATEbr days: @DAYS DATE=@ARG A5#NeedBy_Date DAYS=0 br datetosec: @DATETOSECS DATE=@ARG A5#NeedBy_Date BR dateformat: @@dateFormat Example 1 (working) date entered 04/09/2004 gives output needby date: 04/09/2004 isdate: 1 datediff: 3 days: 04/09/2004 datetosec: 1081468800 dateformat: %m/%d/%Y Example 2 (not working) date entered 04/09/04 gives output: needby date: 04/09/04 isdate: 1 datediff: -36522 days: 04/09/1904 datetosec: -2074291200 dateformat: %m/%d/%Y TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: selected value in @choicelist
Title: Message John - SELECTED="@arg projects" will do it. If you lose your default, try something like this: @IF EXPR='@ARG ContactState=""' TRUE='@assign name="temp" scope="request" value="@@user$defaultstate[*,BaseOneId]"' FALSE='@assign name="temp" scope="request" value="@ARG ContactState"'@CHOICELIST NAME="ContactState" TYPE="select" OPTIONS="@@user$statelist[*,BaseOneItem]" VALUES="@@user$statelist[*,BaseOneId]" SELECTED="@@request$temp" -Original Message-From: John Newsom [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 12:14 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: selected value in @choicelist I have a drop down list that stays on the top of a page with the search results below. When a search is done using the list, I want the selected item to remain selected in the list, instead of the list reverting back to the default. I can manually do it without using choicelist by having an if statement check the item id and add the word selected on true. Is there a way to dynamically use the selected attribute of @choicelist? I've tried @currow in the array element, but that doesnt seem to work. Here is my code for choicelist: @CHOICELIST NAME="projects" TYPE=SELECT OPTIONS="@@request$projects[*,2]" VALUES="@@request$projects[*,1]" SIZE=1 SELECTED="@@request$projects[@currow,2]" Here is my manual code for the other drop down list: SELECT NAME="student" SIZE="1"@ROWS array="usstudents"OPTION VALUE="@@request$usstudents[@currow,1]" @IF EXPR="@@request$usstudents[@currow,1]=@arg student"selected/@IF@@request$usstudents[@currow,2] @@request$usstudents[@currow,3] @@request$usstudents[@currow,4] /OPTION /@ROWS/SELECT Thanks, John TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: another sql puzzler
John - have you tried changing the Select Type in a Search Action to Summary? I think Witango will do this. -Original Message- From: John Newsom [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 3:32 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: another sql puzzler Duh! Thanks, Alan. Worked like a charm. Now I wonder why I need to use a direct sql statement. It seems like the search action ought to be able to produce simple sql like that! John -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 1:32 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: another sql puzzler Hi John, In a join like below, you have to have a column that links the 2 tables together, or else it will select all data from t shirts for every student or something silly like that and thats why your getting such huge counts. if tblStudents2003 has a studentid you would do it like this: select count(a1.studentid) as numorders, a1.studentid from dbo.maydayShirts a1, dbo.tblStudents2003_4 b1 where b1.yog = '2004' and a1.studentid=b1.studentid group by a1.studentid order by numorders desc Adding the a1.studentid=b1.studentid clause (or something else which links the 2 tables directly together like that) is what should do the trick for you. Hope that helps! Alan - Original Message - From: John Newsom [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 25, 2004 12:48 PM Subject: Witango-Talk: another sql puzzler I have two tables, one with tshirt orders, one with students, including year of graduation (yog). I'm trying to get a count of the number of shirts ordered by each student, selecting only the current seniors. This statement, which joins the two tables, select count(a1.studentid) as numorders, a1.studentid from dbo.maydayShirts a1, dbo.tblStudents2003_4 b1 where b1.yog = '2004' group by a1.studentid order by numorders desc produces a bizzare count in the numorders column, where I get a goofy number in the numorders column. Here is a sample output: numorders studentid 565 5998 565 8429 339 8249 226 8136 226 8308 226 8342 226 7980 226 7986 226 8059 226 8074 The other statement relies on a view which joins the two tables, and works fine. select count(studentid) as numorders, studentid from dbo.tshirtsyog where yog = '2004' group by studentid order by numorders desc Here is sample output: numorders studentid 5 5998 2 5999 2 7356 2 7516 2 7561 2 7857 2 7868 2 7887 2 7980 2 7986 Is the basic lesson that if one is doing a count and a where clause, do join first? Or is there some sort of sub select statement I need? I gave up trying to use the witango search action, because I couldn't get even a simple count statement to work! Thanks! John Newsom -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:48 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Something completely different Hi Gene, Could you build an array with the table names and then loop through the array doing the work for each table (using the variable in place of where you would normaly have your constant table name in the DBMS)? - Original Message - From: Wolf, Gene [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:32 AM Subject: RE: Witango-Talk: Something completely different Scott, no, I could do that and that may be a solution. What I have, in essence, is a single ODBC with what amounts to multiple tables within the database. All of the tables have the exact same structure so I want to loop through all of the records of one table, list them, then read all of the records of the next table, list them, etc. This is hard to explain but I hope this gives you a better idea of what I'm trying to do. Thanks for your help! -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Something completely different Hi Gene, Not that I understand 100% of what you're doing, but I think you're saying each Excel file has a different ODBC connection, right? If you have an array that describes all your Excel file connections, then you can do a Loop on that and use Variables for your datasource connections - then you only need one Search Action and one set of code (for parsing the data) for the whole thing. See http://xmlx.ca/articles/571.aspx Hope this helps. Cheers Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca
RE: Witango-Talk: Problem with inserting textarea arg - truncating
Noel - I have a taf with Textarea to Memo inserts running in T2K to Access2K on W2K server. The code has WRAP=SOFT, which is supposedly the same as WRAP=VIRTUAL. It's got a regular insert, with quotes set to True. Have you tried looking at the debug info? jamileh -Original Message- From: Noel Estabrook [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 6:01 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Problem with inserting textarea arg - truncating I am having an issue (Tango 2000 on Windows2000 Server using MS Access 2000) and can't seem to find if this is a known issue anywhere. I have some memo fields in an access database I'm writing to from a Textarea field in my form. I have wrap=virtual on. For some reason, however, if a user happens to hit a carriage return within the text area, Tango is truncating the data that is written to the database at the carriage return. I can't figure out what would be causing this. I have tried using the @OMIT tag to strip out carriage returns to no avail. I KNOW I have used textarea fields with soft wrap before and have had data go into access without any problems. Any ideas? __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Zipping files with Witango
Any zip program that has a command-line interface should work. I've done it with pkzip (www.pkzip.com) and WinZip (www.winzip.com). You'd write the excel file to disk, then use an External Action to run the zip command line create a zipfile on disk, then attach that file to the email. You might be able to write an Excel macro to do the zip email (without writing to disk) if you use WinZip, since it interfaces with Office applications, but I've never tried. jamileh -Original Message- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 2:34 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Zipping files with Witango Are there any zip programs that can be executed from Witango to zip a file that is created on the fly? We have a need to allow a user to select records, create excel spreadsheets from the results, write the file to a directory, zip that file, and then mail that zipped file to the user. We can do it all except for the zipping portion. Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida 32905 Phone: 321-309-0685 E-mail: [EMAIL PROTECTED] __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango Tutorial
Title: Message Thanks very much, Fergal! -Original Message-From: Fergal Donlon [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 6:48 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Witango Tutorial Hi Jamileh, Attached is a MS-SQL script to set up the tutorial database. If I can be of further assistance let me know, Fergal - Original Message - From: Wilcox, Jamileh (HSC) To: [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:34 AM Subject: Witango-Talk: Witango Tutorial I just downloaded and unzipped the Witango Tutorial - one of the guys here is going to start learning Witango give me a hand with some of our updates. The tutorial comes with a database setup for MySQL. Would anyone happen to have a database setup already done for MS-SQL, or know where I can get one? Thanks much! jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Witango Tutorial
Title: Witango Tutorial I just downloaded and unzipped the Witango Tutorial - one of the guys here is going to start learning Witango give me a hand with some of our updates. The tutorial comes with a database setup for MySQL. Would anyone happen to have a database setup already done for MS-SQL, or know where I can get one? Thanks much! jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Finding index of an array row
Title: Message I had thought of that, but was afraid that sort of backwards filtering could run along time also. If you've not had problems, then I'll give it a try. Thanks. j -Original Message-From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 1:30 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Finding index of an array row I have found it to be safer to do something like this assuming you have the array as MyArray @assign name="request$MyArray" value="@filter array='MyArray' expr='#1 != (value you're selecting)'" (Assumes that column 1 is the column containing the info in question - so change that to whatever is the correct value - or if you created the array from a database, you can use the column name instead, e.g., #ID) What this does is recreate the array with everything EXCEPT the row(s) containing the value indicated in the column indicated. It's reliable and simple to set up. On Feb 20, 2004, at 1:52 PM, Wilcox, Jamileh (HSC) wrote: I have an array and I need to delete a particular row, based on the value in one column. The DELROWS tag starts deleting at a given row index. So the question is, how do I obtain the index of a particular row in an array, so that I can delete just that row from the array? I'm probably just stupid today, but I've not been able to figure this out, short of looping through the whole array and saving CURROW as a variable. Surely there must be a better method! Thanks very much. jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Record Builder Error
Title: Message Steve - if you're sure you don't have the database already open in Access (which will cause this error), then you might try doing a compact repair on the database. It sounds like something has the db locked up and that might fix it. Open the Access db, Tools menu,Database Utilities, Compact Repair. Also, check your perms on that file to be sure Witango has rights to open it. You don't have a password or anything on there, do you? Hope that helps. jamileh wilcox Information Systems OU Physicians (405)271-4647 x54124 [EMAIL PROTECTED] -Original Message-From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 5:33 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Record Builder Error Hi Tom No sir, I sure dont Steve -Original Message-From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 5:25 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Record Builder Error You don't have the file open in the Access Window do you? -Original Message-From: Steve Campbell [mailto:[EMAIL PROTECTED]Sent: Thursday, January 29, 2004 6:01 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Record Builder Error I am working with a simple insert on a Record builder like application. I know in the years back ..I use to see this error all the time when working with Access. ( I know ..its not a good database type app. to use). I got this error today and have checked my DSN and pathways ..etc..etc.. Any insight would be appreciated and I know its an easy error..I just think its been so long since I have seen it, that I have forgetten the work around for it. Thanks for helping out his part time coder! Steve File: addnews.tafPosition: InsertClass: DBMSMain Error Number: -1032 [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.HY000File: addnews.tafPosition: InsertClass: DBMSMain Error Number: 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedIM006File: addnews.tafPosition: InsertClass: InternalMain Error Number: -4 Unable to connect to the specified data source.File: addnews.tafPosition: InsertClass: InternalMain Error Number: -4 Unable to connect to the specified data source.Verify that data source is properly configured and that database server is online. SteveTO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafTO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004 ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004 ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: (OT) Website Statistics
Tom - I'm curious. Since this is based on having javascript loaded onto each page, do you know what happens when the user has javascript turned off in their browser? Does that person just not get counted, or do they have some clever means of accounting for that? Thanks. j -Original Message- From: Wilcox, Jamileh (HSC) Sent: Tuesday, January 13, 2004 5:54 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: (OT) Website Statistics That does look terrific. A bit pricey for us, but maybe someday... -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 4:57 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: (OT) Website Statistics I've used a product called Live Stats from a Canadian company named Media House for years. It is rock solid, accurate, and their tech support is superb. www.mediahouse.com -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 5:28 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: (OT) Website Statistics I think this has been discussed before, but I've not found it in the archives. What are youse guys using to track your web statistics? I need to set up to look at hits per site, per page, browser types, etc. Thanks. jamileh __ __ 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
RE: Witango-Talk: [OT] Latest picture from Mars...
Hey dude! The MediaHouse software seems to be called LiveStats. Is that what you meant? There is a product called StatServer at (www.insightful.com). They say it can be used for website statistics, but I have yet to find anything further on that usage. If this is what you're using, can you point me to any details? Then there's a StatServer by MathSoft, but it doesn't look to be webdev related. Thanks! jamileh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 5:37 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: [OT] Latest picture from Mars... StatServer by Mediahouse. http://inessential.com/2004/01/13.php Cheers... ___ _ 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
RE: Witango-Talk: (OT) Website Statistics
[even more OT digression] g Actually, I'm Okie and our second person plural is y'all. I think youse guys is from the New York/New Jersey area; I'm not sure where I picked it up. So what's the Oz version and how do you say it? [/even more OT digression] -Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 8:04 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: (OT) Website Statistics What are youse guys using to track your web statistics? I need to set up to look at hits per site, per page, browser types, etc. You must be Australian! I don't know another nationality that actually spells the plural of 'you'. ;) I use Traffic Report. It can be scheduled to generate reports periodically from log in HTML format. http://www.seacloak.com/ Wayne Irvine Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: (OT) Website Statistics
I think this has been discussed before, but I've not found it in the archives. What are youse guys using to track your web statistics? I need to set up to look at hits per site, per page, browser types, etc. Thanks. jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: (OT) Website Statistics
That does look terrific. A bit pricey for us, but maybe someday... -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 4:57 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: (OT) Website Statistics I've used a product called Live Stats from a Canadian company named Media House for years. It is rock solid, accurate, and their tech support is superb. www.mediahouse.com -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 5:28 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: (OT) Website Statistics I think this has been discussed before, but I've not found it in the archives. What are youse guys using to track your web statistics? I need to set up to look at hits per site, per page, browser types, etc. Thanks. jamileh __ __ 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: Looking for Witango Developer in OKC area
We're looking into the possibility of bringing in some outside resources for a couple of projects. Management wants someone local to the Oklahoma City area, but may be willing to go with someone who's in town periodically. This is all very early stages, so I don't have anything concrete at the moment. Please email me offlist if you would be interested in further information. Thanks. jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Directory Contents Returned
I'm not entirely sure, but I'd suspect it's to cover directory names with spaces. Don't look at me, I don't name 'em that way. ;-) j -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 10:06 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned Why the double quotes? -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:02 AM To: [EMAIL PROTECTED] Subject: FW: Witango-Talk: Directory Contents Returned OK, our outlook server will not take the bat file, even renamed. Here's what's in ls.bat: dir /B %DIR% Hope that helps. j -Original Message- From: Wilcox, Jamileh (HSC) Sent: Monday, December 15, 2003 9:58 AM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Directory Contents Returned Steve - is this what you're looking for? j -Original Message- From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 3:27 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned As I said..thanks again.but if I remember right there was one that was even easier then this. It had a couple of parts to it anyway, if anyone remembers that one, let me know please. Thanks Steve -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned There's probably more than you need in this, but I think what you want is there. -Original Message- From: Steve-Forg [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 3:36 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned I have build and used this taf before. I have even used it extensively in the past, but that was many machines ago and my snip's file is no longer.. SO, I am looking for a simple taf that use to be at the componet zone that had an external action that read the contents of a directory and then listed back what they were. This taf could also be customized via file name endings and of course, it was ran by the fact that it used a .bat file to do the external. Anyone remember this please let me know as I really used the heck out of it, once upon a time. Thanks Steve --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 __ __ 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
RE: Witango-Talk: Paged results for a Direct DBMS action
Yah, I'd thought of the pre-search but hate to have to add all those in; might as well just rewrite them all as Search Actions. I'll have to think about the on-the-fly criteria calculations, but I can see how that might work. Thanks for the advice! jamileh -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:32 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action You'll either have to pre-search for the total records available (without your subset code) and save that in a variable to replicate what @TOTALROWS does. Or you'll have to calculate what your next and previous subset criteria are on the fly for each button to work. -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 5:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action Each Direct DBMS queries for a specific subset of records. All of those records are then displayed in the resultsHTML. I need to add next/previous paging to those displayed rows. -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:08 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action I think this depends on how you are handling the selection of the subset of records. Does your Direct DBMS actually bring all records back and then filter in the resultsHTML, or do you limit the database's response? Robert -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action Yah, I can probably rewrite the queries to run in Search Actions, I'm honestly not sure why they're set up as Direct DBMS. However, the page has a fair list of different queries in the menu with slightly different output for each, so I was hoping to avoid rewriting them all. I suppose I could look on this as an opportunity to clean up some code; I may be able to set it up with one or two queries and use variables in the menus. :/ I didn't realize until I was messing with this that the Search Action seems to collect a fair bit of query info that the Direct DBMS Action doesn't; I'm not sure when or how it's collected, nor where it's hiding. Behind-the-scenes magic, I guess. -Original Message- From: Jim Kass [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:45 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action The DBMS Action has no knowledge about your query... and thus it cannot get row# information or totalrows (which is used in the manual's implementation of next/prev results). However, depending on how complex your DBMS Action, you can use the Search Action with custom criteria and results... and you can probably accomplish the same query and still use the pre-fab next/prev code. Just a suggestion. Jim Kass Web Developer -- Forestweb: The Source for Industry Intelligence Best Content -- Most Relevant -- Best Delivery http://www.forestweb.com (310) 553 - 0008 -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 1:31 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Paged results for a Direct DBMS action OK, I need to add next/previous paging to a webpage. This is the results page of a direct dbms action. The paging in the manual doesn't work, because it is based on having checked the Get Total Number of Matching Rows box in the Results tab of the Search Action. The Direct DBMS Results tab doesn't have that option, I dunno why. Has anyone done this? Thanks. j __ __ 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 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Paged results for a Direct DBMS action
Hey, now we're talking. I do lots of stuff with arrays, just hadn't thought about using it for paging. We're probably looking at 500 max for this puppy, so it shouldn't be a problem. User-scoped variables to hold your X and Y as you page through, or is there a better way? Muchas muchas gracias! jamileh -Original Message- From: Erik Gorka [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 5:11 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Paged results for a Direct DBMS action I've replicated that sort of function by loading the results of the Direct DBMS action into an array and showing row X through row Y from the array on each page. As long as you not expecting thousands of rows returned from the database and you're overly concerned about memory, this should work just fine for what you want to do. Erik On Dec 12, 2003, at 1:30 PM, Wilcox, Jamileh (HSC) wrote: OK, I need to add next/previous paging to a webpage. This is the results page of a direct dbms action. The paging in the manual doesn't work, because it is based on having checked the Get Total Number of Matching Rows box in the Results tab of the Search Action. The Direct DBMS Results tab doesn't have that option, I dunno why. Has anyone done this? Thanks. j __ _ _ 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
RE: Witango-Talk: Directory Contents Returned
Steve - is this what you're looking for? j -Original Message- From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 3:27 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned As I said..thanks again.but if I remember right there was one that was even easier then this. It had a couple of parts to it anyway, if anyone remembers that one, let me know please. Thanks Steve -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned There's probably more than you need in this, but I think what you want is there. -Original Message- From: Steve-Forg [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 3:36 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned I have build and used this taf before. I have even used it extensively in the past, but that was many machines ago and my snip's file is no longer.. SO, I am looking for a simple taf that use to be at the componet zone that had an external action that read the contents of a directory and then listed back what they were. This taf could also be customized via file name endings and of course, it was ran by the fact that it used a .bat file to do the external. Anyone remember this please let me know as I really used the heck out of it, once upon a time. Thanks Steve --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf list.taf Description: list.taf attachment: ls.bat
RE: Witango-Talk: Directory Contents Returned
Here ya go. -Original Message- From: Campbell Steve [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 10:37 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Directory Contents Returned Jami Ithink so..but,the headers are getting stripped somehow, could you zip these up? Steve From: Wilcox, Jamileh (HSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 15 Dec 2003 09:58:21 -0600 To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned Steve - is this what you're looking for? j -Original Message- From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 3:27 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned As I said..thanks again.but if I remember right there was one that was even easier then this. It had a couple of parts to it anyway, if anyone remembers that one, let me know please. Thanks Steve -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned There's probably more than you need in this, but I think what you want is there. -Original Message- From: Steve-Forg [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 3:36 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Directory Contents Returned I have build and used this taf before. I have even used it extensively in the past, but that was many machines ago and my snip's file is no longer.. SO, I am looking for a simple taf that use to be at the componet zone that had an external action that read the contents of a directory and then listed back what they were. This taf could also be customized via file name endings and of course, it was ran by the fact that it used a .bat file to do the external. Anyone remember this please let me know as I really used the heck out of it, once upon a time. Thanks Steve --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 12/2/2003 __ __ 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 dirlist.zip Description: dirlist.zip
Witango-Talk: Paged results for a Direct DBMS action
OK, I need to add next/previous paging to a webpage. This is the results page of a direct dbms action. The paging in the manual doesn't work, because it is based on having checked the Get Total Number of Matching Rows box in the Results tab of the Search Action. The Direct DBMS Results tab doesn't have that option, I dunno why. Has anyone done this? Thanks. j TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Paged results for a Direct DBMS action
Yah, I can probably rewrite the queries to run in Search Actions, I'm honestly not sure why they're set up as Direct DBMS. However, the page has a fair list of different queries in the menu with slightly different output for each, so I was hoping to avoid rewriting them all. I suppose I could look on this as an opportunity to clean up some code; I may be able to set it up with one or two queries and use variables in the menus. :/ I didn't realize until I was messing with this that the Search Action seems to collect a fair bit of query info that the Direct DBMS Action doesn't; I'm not sure when or how it's collected, nor where it's hiding. Behind-the-scenes magic, I guess. -Original Message- From: Jim Kass [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:45 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action The DBMS Action has no knowledge about your query... and thus it cannot get row# information or totalrows (which is used in the manual's implementation of next/prev results). However, depending on how complex your DBMS Action, you can use the Search Action with custom criteria and results... and you can probably accomplish the same query and still use the pre-fab next/prev code. Just a suggestion. Jim Kass Web Developer -- Forestweb: The Source for Industry Intelligence Best Content -- Most Relevant -- Best Delivery http://www.forestweb.com (310) 553 - 0008 -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 1:31 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Paged results for a Direct DBMS action OK, I need to add next/previous paging to a webpage. This is the results page of a direct dbms action. The paging in the manual doesn't work, because it is based on having checked the Get Total Number of Matching Rows box in the Results tab of the Search Action. The Direct DBMS Results tab doesn't have that option, I dunno why. Has anyone done this? Thanks. j __ __ 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
RE: Witango-Talk: Paged results for a Direct DBMS action
Each Direct DBMS queries for a specific subset of records. All of those records are then displayed in the resultsHTML. I need to add next/previous paging to those displayed rows. -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:08 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action I think this depends on how you are handling the selection of the subset of records. Does your Direct DBMS actually bring all records back and then filter in the resultsHTML, or do you limit the database's response? Robert -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action Yah, I can probably rewrite the queries to run in Search Actions, I'm honestly not sure why they're set up as Direct DBMS. However, the page has a fair list of different queries in the menu with slightly different output for each, so I was hoping to avoid rewriting them all. I suppose I could look on this as an opportunity to clean up some code; I may be able to set it up with one or two queries and use variables in the menus. :/ I didn't realize until I was messing with this that the Search Action seems to collect a fair bit of query info that the Direct DBMS Action doesn't; I'm not sure when or how it's collected, nor where it's hiding. Behind-the-scenes magic, I guess. -Original Message- From: Jim Kass [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:45 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action The DBMS Action has no knowledge about your query... and thus it cannot get row# information or totalrows (which is used in the manual's implementation of next/prev results). However, depending on how complex your DBMS Action, you can use the Search Action with custom criteria and results... and you can probably accomplish the same query and still use the pre-fab next/prev code. Just a suggestion. Jim Kass Web Developer -- Forestweb: The Source for Industry Intelligence Best Content -- Most Relevant -- Best Delivery http://www.forestweb.com (310) 553 - 0008 -Original Message- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 1:31 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Paged results for a Direct DBMS action OK, I need to add next/previous paging to a webpage. This is the results page of a direct dbms action. The paging in the manual doesn't work, because it is based on having checked the Get Total Number of Matching Rows box in the Results tab of the Search Action. The Direct DBMS Results tab doesn't have that option, I dunno why. Has anyone done this? Thanks. j __ __ 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
RE: Witango-Talk: OT: Looking for help - Certificates and SQL
Yes, the documentation says to load certificates set your root authority, then just turn on the Force Encryption. Unfortunately, it didn't work for us. That's a good article that I hadn't seen, though - thanks! Actually, I agree about the port have requested to change it. So far, I've not been able to talk them into it. Among other things, we have several 3rd-party proprietary systems running against that db server no one's sure if we can make port changes to that software. One of these days, maybe. Thanks for all the suggestions advice! j -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 6:23 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Yes it should be in the SQL Server and the ODBC Client setup. As a matter of fact I would suggest you change the port on SQL Server from 1433 to something else. This port is one of the most hacked on the net Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 3:49 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Yes, but what about when Witango (ODBC ---(via SSL)--- SQL Server?? I think this article is saying to just set the Force protocol encryption property in the Server Network Utility and the Client Network Utility and you're done (or something like that). http://msdn.microsoft.com/library/default.asp?url=/library/en- us/dnnetse c/ht ml/SecNetHT19.asp?frame=true Hope this helps. Cheers -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Whoa here ;-) HTTPS is for SSL com to IIS on port 443 SQL talks on port 1433 to ODBC Browser(https) -- IIS(SSL) port 443 Witango (ODBC -- SQL Odbc Driver port 1433 Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Hi Jamileh, Maybe that's the trick to get this working. In IIS when SSL is installed, HTTPS listens on port 443 instead of the default 80. Maybe when SSL is installed with SQL Server, it doesn't listen on the default port 1433 anymore - maybe it's just listening on a different port? Maybe Enterprise Manager and the other SQL Client components just have to be configured for the different port? In the SQL Server Client Network Utility, you can configure different ports for the default and there is a flag to Force protocol encryption 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Dunno, I'll have to ask. I hadn't even gotten as far as trying to set up any https files, and hadn't installed certs on IIS yet. We were just trying to get the boxes to talk over the default SQL port. -Original Message- From: Jeff Bohmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:59 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: OT: Looking for help - Certificates and SQL A quick thought: do you have port 443 open to your web server(s) on any firewalls and in W2K network config? - Jeff OK, we have need to secure our internal communications between servers. Plan: set up inhouse Certificate Authority, and use those certificates to encrypt communications between IIS and MSSQL servers. The ultimate goal is to have encrypted Witango websites available via the internet, securely accessing restricted SQL databases behind our firewall. We're talking serious federal regs here; we've got to be sure the data remains protected. We've set up a CA on our intranet webserver and added certificates to two test servers (IIS5 MS-SQL2000, both on W2K). The CA seems to be working OK, and certs seem to install
RE: Witango-Talk: OT: Looking for help - Certificates and SQL
Probably because I dunno jack about networking security, and we knew it should be possible with certs. :-) I'll check into this...thanks. -Original Message- From: Customer Support [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 6:25 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: OT: Looking for help - Certificates and SQL Why not do it all at the network level using IPSec - VPN. If the data is going through a firewall this is probably easier to administer and is less hassle in the long run. It also ensures that all data to and from the server is encrypted, not just the information to and from the db. Talk to your network guys and see what they can do for you. Witango Support On 10/12/2003, at 10:49 AM, Scott Cadillac wrote: Yes, but what about when Witango (ODBC ---(via SSL)--- SQL Server?? I think this article is saying to just set the Force protocol encryption property in the Server Network Utility and the Client Network Utility and you're done (or something like that). http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ dnnetsec/ht ml/SecNetHT19.asp?frame=true Hope this helps. Cheers -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Whoa here ;-) HTTPS is for SSL com to IIS on port 443 SQL talks on port 1433 to ODBC Browser(https) -- IIS(SSL) port 443 Witango (ODBC -- SQL Odbc Driver port 1433 Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Hi Jamileh, Maybe that's the trick to get this working. In IIS when SSL is installed, HTTPS listens on port 443 instead of the default 80. Maybe when SSL is installed with SQL Server, it doesn't listen on the default port 1433 anymore - maybe it's just listening on a different port? Maybe Enterprise Manager and the other SQL Client components just have to be configured for the different port? In the SQL Server Client Network Utility, you can configure different ports for the default and there is a flag to Force protocol encryption 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Dunno, I'll have to ask. I hadn't even gotten as far as trying to set up any https files, and hadn't installed certs on IIS yet. We were just trying to get the boxes to talk over the default SQL port. -Original Message- From: Jeff Bohmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:59 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: OT: Looking for help - Certificates and SQL A quick thought: do you have port 443 open to your web server(s) on any firewalls and in W2K network config? - Jeff OK, we have need to secure our internal communications between servers. Plan: set up inhouse Certificate Authority, and use those certificates to encrypt communications between IIS and MSSQL servers. The ultimate goal is to have encrypted Witango websites available via the internet, securely accessing restricted SQL databases behind our firewall. We're talking serious federal regs here; we've got to be sure the data remains protected. We've set up a CA on our intranet webserver and added certificates to two test servers (IIS5 MS-SQL2000, both on W2K). The CA seems to be working OK, and certs seem to install on the servers. However, whenever we force encryption on the SQL server, we can't access it at all - not from the web, not from Enterprise Manager, nada. (The data was very safe, however. ;^D) No one here has ever done either of these things (inhouse CA or SQL using certs), so we've no clue where the problem is. I'm pushing to get some help on this. If anyone on the list is interested in consulting on this, please send me an email. I'm not making the decisions, and we're notoriously slow to spend money, so don't count on anything happening soon or at all. But if I can send some business
RE: Witango-Talk: @COLUMN tag problems
I guess that is the problem - I'm not in the Results of the search action. I must've misread the help files. Thanks for all the responses! j -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:29 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: @COLUMN tag problems Correct. They way I always remember is because I drag the column out of the snippets window since the tag and syntax and quotes are all done for me that way. No change of typos. on 12/8/03 21:03, Stefan Gonick at [EMAIL PROTECTED] wrote: If I understood you correctly, then you can only use @column in the resultsHTML of the same seach action. You can't use @column in the results HTML of a later action. Stefan At 03:20 PM 12/8/2003, you wrote: Witango5; Windows2000, IIS5; MSSQL2000 SQL query: SELECT t1.CategoryID,t1.CategoryNum,t1.CategoryName,t2.ConcernID,t2.ConcernN um, t2.ConcernName,t2.ConcCatLink,t2.ComplimentStatus,t2.ComplaintStatus FROM dbo.tbl_ConcernCategories t1,dbo.tbl_Concerns t2 WHERE (t1.ActiveStatus=1 AND t2.StaffOnlyStatus='0' AND t2.ActiveStatus=1) AND ((t2.ConcCatLink=t1.CategoryID)) Filtered to Distinct CategoryNames and assigned to array @@user$CatList Witango code: @ROWS ARRAY='CatList' SCOPE='user' TR ALIGN=CENTER VALIGN=TOP TD COLSPAN='3' u@COL NUM='3'/u !-- Display current Category Name -- /TD /TR I've tried repeatedly to use @COLUMN NAME='CategoryName' instead of the @COL tag. It doesn't work, nothing is printed. (I've also tried with table.column and owner.table.column for the name.) Any idea what I could be doing wrong? Thanks. j _ ___ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: calling Ben Johansen
Ben - please let me know if you're online; there's an email that may have gone astray. Thanks. j TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: OT: Looking for help - Certificates and SQL
OK, we have need to secure our internal communications between servers. Plan: set up inhouse Certificate Authority, and use those certificates to encrypt communications between IIS and MSSQL servers. The ultimate goal is to have encrypted Witango websites available via the internet, securely accessing restricted SQL databases behind our firewall. We're talking serious federal regs here; we've got to be sure the data remains protected. We've set up a CA on our intranet webserver and added certificates to two test servers (IIS5 MS-SQL2000, both on W2K). The CA seems to be working OK, and certs seem to install on the servers. However, whenever we force encryption on the SQL server, we can't access it at all - not from the web, not from Enterprise Manager, nada. (The data was very safe, however. ;^D) No one here has ever done either of these things (inhouse CA or SQL using certs), so we've no clue where the problem is. I'm pushing to get some help on this. If anyone on the list is interested in consulting on this, please send me an email. I'm not making the decisions, and we're notoriously slow to spend money, so don't count on anything happening soon or at all. But if I can send some business to one of y'all rather than M$, I'd rather. Thanks! j TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: OT: Looking for help - Certificates and SQL
Dunno, I'll have to ask. I hadn't even gotten as far as trying to set up any https files, and hadn't installed certs on IIS yet. We were just trying to get the boxes to talk over the default SQL port. -Original Message- From: Jeff Bohmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:59 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: OT: Looking for help - Certificates and SQL A quick thought: do you have port 443 open to your web server(s) on any firewalls and in W2K network config? - Jeff OK, we have need to secure our internal communications between servers. Plan: set up inhouse Certificate Authority, and use those certificates to encrypt communications between IIS and MSSQL servers. The ultimate goal is to have encrypted Witango websites available via the internet, securely accessing restricted SQL databases behind our firewall. We're talking serious federal regs here; we've got to be sure the data remains protected. We've set up a CA on our intranet webserver and added certificates to two test servers (IIS5 MS-SQL2000, both on W2K). The CA seems to be working OK, and certs seem to install on the servers. However, whenever we force encryption on the SQL server, we can't access it at all - not from the web, not from Enterprise Manager, nada. (The data was very safe, however. ;^D) No one here has ever done either of these things (inhouse CA or SQL using certs), so we've no clue where the problem is. I'm pushing to get some help on this. If anyone on the list is interested in consulting on this, please send me an email. I'm not making the decisions, and we're notoriously slow to spend money, so don't count on anything happening soon or at all. But if I can send some business to one of y'all rather than M$, I'd rather. Thanks! j _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf -- Jeff Bohmer VisionLink, Inc. _ 303.402.0170 www.visionlink.org _ People. Tools. Change. Community. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: OT: Looking for help - Certificates and SQL
Right. As far as I know, port 1433 should be open between the two test machines. They talk fine until encryption is turned on. None of the documentation I've found says anything about encryption causing a port change. We followed these instructions for the SQL encryption: support.microsoft.com/servicedesks/webcasts/wc042302/WC042302.ppt The CA setup was...less informed. However, it seems to be working while the Force Encryption causes problems. Go figure. I could probably figure it out eventually, if I had time, but delaying projects for another week or two while I monkey about with it just ain't feasible. Next time, I'll do all the setup myself, then at least I'll know what has hasn't been done and what the results were. ;^P -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:33 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Whoa here ;-) HTTPS is for SSL com to IIS on port 443 SQL talks on port 1433 to ODBC Browser(https) -- IIS(SSL) port 443 Witango (ODBC -- SQL Odbc Driver port 1433 Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller Available for Witango Developement -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Hi Jamileh, Maybe that's the trick to get this working. In IIS when SSL is installed, HTTPS listens on port 443 instead of the default 80. Maybe when SSL is installed with SQL Server, it doesn't listen on the default port 1433 anymore - maybe it's just listening on a different port? Maybe Enterprise Manager and the other SQL Client components just have to be configured for the different port? In the SQL Server Client Network Utility, you can configure different ports for the default and there is a flag to Force protocol encryption 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: Looking for help - Certificates and SQL Dunno, I'll have to ask. I hadn't even gotten as far as trying to set up any https files, and hadn't installed certs on IIS yet. We were just trying to get the boxes to talk over the default SQL port. -Original Message- From: Jeff Bohmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:59 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: OT: Looking for help - Certificates and SQL A quick thought: do you have port 443 open to your web server(s) on any firewalls and in W2K network config? - Jeff OK, we have need to secure our internal communications between servers. Plan: set up inhouse Certificate Authority, and use those certificates to encrypt communications between IIS and MSSQL servers. The ultimate goal is to have encrypted Witango websites available via the internet, securely accessing restricted SQL databases behind our firewall. We're talking serious federal regs here; we've got to be sure the data remains protected. We've set up a CA on our intranet webserver and added certificates to two test servers (IIS5 MS-SQL2000, both on W2K). The CA seems to be working OK, and certs seem to install on the servers. However, whenever we force encryption on the SQL server, we can't access it at all - not from the web, not from Enterprise Manager, nada. (The data was very safe, however. ;^D) No one here has ever done either of these things (inhouse CA or SQL using certs), so we've no clue where the problem is. I'm pushing to get some help on this. If anyone on the list is interested in consulting on this, please send me an email. I'm not making the decisions, and we're notoriously slow to spend money, so don't count on anything happening soon or at all. But if I can send some business to one of y'all rather than M$, I'd rather. Thanks! j _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf -- Jeff Bohmer VisionLink, Inc. _ 303.402.0170 www.visionlink.org _ People. Tools. Change. Community
Witango-Talk: @COLUMN tag problems
Witango5; Windows2000, IIS5; MSSQL2000 SQL query: SELECT t1.CategoryID,t1.CategoryNum,t1.CategoryName,t2.ConcernID,t2.ConcernNum, t2.ConcernName,t2.ConcCatLink,t2.ComplimentStatus,t2.ComplaintStatus FROM dbo.tbl_ConcernCategories t1,dbo.tbl_Concerns t2 WHERE (t1.ActiveStatus=1 AND t2.StaffOnlyStatus='0' AND t2.ActiveStatus=1) AND ((t2.ConcCatLink=t1.CategoryID)) Filtered to Distinct CategoryNames and assigned to array @@user$CatList Witango code: @ROWS ARRAY='CatList' SCOPE='user' TR ALIGN=CENTER VALIGN=TOP TD COLSPAN='3' u@COL NUM='3'/u !-- Display current Category Name -- /TD /TR I've tried repeatedly to use @COLUMN NAME='CategoryName' instead of the @COL tag. It doesn't work, nothing is printed. (I've also tried with table.column and owner.table.column for the name.) Any idea what I could be doing wrong? Thanks. j TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: @COLUMN tag problems
Nope, it's from a Search action. -Original Message- From: Kevin Quinn [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: @COLUMN tag problems Is this in a Serach action or a Direct DBMS? You won't get column names from the Direct DBMS. That may be the problem. From: Wilcox, Jamileh (HSC) [EMAIL PROTECTED] Date: 2003/12/08 Mon PM 08:20:13 GMT To: [EMAIL PROTECTED] Subject: Witango-Talk: @COLUMN tag problems Witango5; Windows2000, IIS5; MSSQL2000 SQL query: SELECT t1.CategoryID,t1.CategoryNum,t1.CategoryName,t2.ConcernID,t2.ConcernNu m, t2.ConcernName,t2.ConcCatLink,t2.ComplimentStatus,t2.ComplaintStatus FROM dbo.tbl_ConcernCategories t1,dbo.tbl_Concerns t2 WHERE (t1.ActiveStatus=1 AND t2.StaffOnlyStatus='0' AND t2.ActiveStatus=1) AND ((t2.ConcCatLink=t1.CategoryID)) Filtered to Distinct CategoryNames and assigned to array @@user$CatList Witango code: @ROWS ARRAY='CatList' SCOPE='user' TR ALIGN=CENTER VALIGN=TOP TD COLSPAN='3' u@COL NUM='3'/u !-- Display current Category Name -- /TD /TR I've tried repeatedly to use @COLUMN NAME='CategoryName' instead of the @COL tag. It doesn't work, nothing is printed. (I've also tried with table.column and owner.table.column for the name.) Any idea what I could be doing wrong? Thanks. j __ __ 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
RE: Witango-Talk: @COLUMN tag problems
There's a search action that runs the query. In the ResultsHTML of the search action, I set the arrays. Then there's a ResultsHTML page that contains the @ROWS piece. -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:17 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: @COLUMN tag problems Is this result with the search action or after it? on 12/8/03 16:35, Wilcox, Jamileh (HSC) at [EMAIL PROTECTED] wrote: Nope, it's from a Search action. -Original Message- From: Kevin Quinn [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: @COLUMN tag problems Is this in a Serach action or a Direct DBMS? You won't get column names from the Direct DBMS. That may be the problem. From: Wilcox, Jamileh (HSC) [EMAIL PROTECTED] Date: 2003/12/08 Mon PM 08:20:13 GMT To: [EMAIL PROTECTED] Subject: Witango-Talk: @COLUMN tag problems Witango5; Windows2000, IIS5; MSSQL2000 SQL query: SELECT t1.CategoryID,t1.CategoryNum,t1.CategoryName,t2.ConcernID,t2.ConcernN u m, t2.ConcernName,t2.ConcCatLink,t2.ComplimentStatus,t2.ComplaintStatus FROM dbo.tbl_ConcernCategories t1,dbo.tbl_Concerns t2 WHERE (t1.ActiveStatus=1 AND t2.StaffOnlyStatus='0' AND t2.ActiveStatus=1) AND ((t2.ConcCatLink=t1.CategoryID)) Filtered to Distinct CategoryNames and assigned to array @@user$CatList Witango code: @ROWS ARRAY='CatList' SCOPE='user' TR ALIGN=CENTER VALIGN=TOP TD COLSPAN='3' u@COL NUM='3'/u !-- Display current Category Name -- /TD /TR I've tried repeatedly to use @COLUMN NAME='CategoryName' instead of the @COL tag. It doesn't work, nothing is printed. (I've also tried with table.column and owner.table.column for the name.) Any idea what I could be doing wrong? Thanks. j _ _ __ 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 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Those dang commas!
I often use carets ^ and pipes | for array delimiters to get around the comma problem. Didn't realize you could use something like [ROW] - I'll have to remember that! -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 5:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Those dang commas! I've used anything from as simple as a tilda ~ to using short text strings like [ROW] and [COL] as my delimiters. -Original Message- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 6:37 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Those dang commas! Every now and again a customer tells me their site isn't working. File: array.taf Position: RecordList Class: Internal Main Error Number: -612 The initialization string does not match the specified row and column dimensions, or the row and column dimensions are inconsistent within the initialization string. Takes me some time to realise that they have have entered a delimiter (, ; etc) in a field that is being used in an array and that all that needs to be done is to edit some database entries (a doddle in FMP). Of course what I really should do is fix the problem. I mean, commas are pretty standard fare for names of events, addresses etc. How do others approach this? Specify different row and column delimiters? Use some sort of encoding of the input field or variable? Use a replace and the character code for commas etc? I just don't want to reinvent the wheel or do 10 lines of code when there is a metatag of parameter I have missed. Any help would be appreciated. BTW T2000 mostly but WT5 also. Wayne Irvine Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 __ __ 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
Witango-Talk: Help with data validation
OK, this is driving me nuts. I've attached an example file with the relevant pieces of my app. I'm trying to validate form data. I may add javascript validation later, but at the moment, I'd rather have it in Witango. I've got required field data validating fine - see the 'If_P1_ValidationErrors' tacked on to the end. My strong preference would be to include all of the data validation in one IF action. I want to validate some fairly simple stuff on certain fields - i.e., valid telephone number, zipcode basic email formatting. I've tried various forms of pattern matching, but can't get any of them to work within an IF statement. So I thought I could at least check to be sure the phone zip fields were all numeric - but I can't even get that to work. Evidently, as far as I can tell from processing the attached taf, Witango thinks that 0=0 and 1=0. Surely someone of you has done this stuff and can tell this poor fool what I'm doing wrong. Thanks for any help you've got. And a grand weekend to those lucky devils who won't be working! jamileh example.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf example.taf Description: example.taf
Witango-Talk: OT: test platforms
We're in the process of building an application for public consumption. This is a new area for me, as all my previous apps have been intranet and built to campus standards for OS and browser. I am building primarily in HTML/Witango; there'll be some javascript, but I'm trying to keep that to nice-but-noncritical areas. I'm talking to my guys about building a couple machines for testing different browsers, etc. Can y'all give me recommendations for what I'll need, and/or the best way to do this? Thanks! jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Studio 5 bug?
I can't get to the Witango website today; has anyone heard of this problem? Witango DevStudio 5.0.1.037 on W2KPro SP3, current on security critical patches. If I open two instances of Witango (so that I can tab between files on the taskbar rather than switching within the Witango window), I'm only allowed to open a certain number of windows. (The number seems to depend on what's open.) Once the taskbar is full, no more windows will open - including popup boxes, Task Manager, anything. Is there a fix out for this and, if so, does anyone have a copy? Thanks much! jamileh TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: [OT] Automated File Transfers
Although I can't get 'em to buy the full version of WS-FTP, I've used the Lite version (which doesn't have command-line capability). I'd recommend the full version based on my experience with the little'un - it's a good program for not much $$. I use batch files to run the MS ftp utility (comes with Windows). Command-line info is in the Help files. I can send you some examples if that would help. jamileh -Original Message- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: [OT] Automated File Transfers John, I use WS-FTP Pro (on a Win 2K server), which has a pretty straightforward scriping language and an operating system command line interface. Witango can even write the scripts to a file, then execute the script with an external command line command. It's very inexpensive, and was a quick product to learn. Another advantage is that it can create SSL certificates. If the remote site also uses FTP with SSL, your transmissions are encrypted. I have an application that retrieves new orders every morning with this method. For more information, www.ipswitch.com Bill On Wed, 8 Oct 2003 10:42:27 -0400, John Shaw wrote: I need to automate the transfer of files from a remote external FTP site to my web server. I'd prefer to use a cron action in Witango to kick off and manage the process via COM. The COM would have to log in, check if the file exists, and transfer it. On the Witango side I would create the file name, execute the COM, then open and work with the file (XML in this case). Does anyone know of company that sells a component like that? Or, is there another way to do it? __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Poll: Version?
We're still on T2K, waiting for approval to upgrade to Witango5. Windows 2000 servers, MSSQL 2000. -Original Message- From: Alvin Dy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:01 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Poll: Version? hi there, i was asking the developers in this mailing list. oh by the way we still use T2K both in server(linux) and development studio(windows).. Content-Transfer-Encoding: 7bit On 9/23/03 12:41 AM, Alvin Dy [EMAIL PROTECTED] wrote: What is your current version of application server/development studio? Is he asking the list? Or Phil at WiTango? Steve _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.176 / Virus Database: 260.1.2 - Release Date: 9/18/03 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.176 / Virus Database: 260.1.2 - Release Date: 9/18/03 __ __ 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
RE: Witango-Talk: Poll: Version?
:~) Cool. I'll have to mention that Witango can manage to release a new version in the same time it takes us to buy a copy. ;-p -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:00 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Poll: Version? Hi You will need to change you request shortly to upgrade to Witango 5.5 Because... Phil just annouced the Witango 5.5 will go into Beta shortly after the conference. They have been working very hard and addressed all the issues that have come up on the list in this beta. So your requests on the list have been taken into account. Ben @ Corroboree 2003 -Original Message- From: Wilcox, Jamileh (HSC) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Wed, 24 Sep 2003 12:16:27 -0500 Subject: RE: Witango-Talk: Poll: Version? We're still on T2K, waiting for approval to upgrade to Witango5. Windows 2000 servers, MSSQL 2000. -Original Message- From: Alvin Dy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:01 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Poll: Version? hi there, i was asking the developers in this mailing list. oh by the way we still use T2K both in server(linux) and development studio(windows).. Content-Transfer-Encoding: 7bit On 9/23/03 12:41 AM, Alvin Dy [EMAIL PROTECTED] wrote: What is your current version of application server/development studio? Is he asking the list? Or Phil at WiTango? Steve _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.176 / Virus Database: 260.1.2 - Release Date: 9/18/03 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.176 / Virus Database: 260.1.2 - Release Date: 9/18/03 __ __ 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
RE: Witango-Talk: Could not execute Fork
C'est tres bizarre. I've been getting them today, too. I am mucking about with some external actions, so it's not really surprising I'd get the error, just odd to see it and then see these in email. Synchronicity strikes again! Unfortunately, when I tried to restart the Tango service, it wouldn't. Had to bounce the server. Good Monday to all and to all a good night. :) -Original Message- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 2:44 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Could not execute Fork Thanks David, that did the trick. I didn't say so in my first message but that was exactly the same thing we were doing. Very odd. -Original Message- From: David Green [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Could not execute Fork Gene, I had the same issue on the same platforms this morning. All I was doing was a External action to get a directory listing. After restarting the server, all was fine. I have no clue what or why, but it's working fine now. Good luck, Dave Green [EMAIL PROTECTED] Wolf, Gene wrote: For all of you still out there, I have just started getting a strange error on one of my programs. The error message is Could not execute Fork This is a Windows 2000 server system using Tango Version 5. Anyone ever see this message before and have any idea what we should do to correct it? Sincerely, Gene Wolf __ __ 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
RE: Witango-Talk: PDF stored in db?
I started out working with the image datatype and switched because I was having problems. I switched to text because I heard that it might work better than image. I'll try again with image next week. There may also be a Witango/Tango2K difference. I'm glad to hear you got it working! Ben will be interested too. Thanks. j -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 5:54 AM To: [EMAIL PROTECTED] Subject: 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
RE: NDN(7): SV: Witango-Talk: PDF stored in db?
Me too. Pretty odd. -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:32 AM To: [EMAIL PROTECTED] Subject: RE: NDN(7): SV: Witango-Talk: PDF stored in db? what the heck is this??? I had about 25 of these in my mail box this AM -Original Message- From: Mailer-Daemon [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 7:49 AM To: [EMAIL PROTECTED] Subject: NDN(7): SV: Witango-Talk: PDF stored in db? Sorry. Your message could not be delivered to: staceys,ECOMOLA (The name was not found at the remote site. Check that the name has been entered correctly.) __ __ 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
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, 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: id type
RE: Witango-Talk: PDF stored in db?
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 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
RE: Witango-Talk: PDF stored in db?
=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 _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/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/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: PDF stored in db?
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 _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/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/maillist.taf _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/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/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: PDF stored in db?
@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 _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/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/maillist.taf _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/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/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: PDF stored in db?
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 _ __ _ TO UNSUBSCRIBE: Go to http://www.witango.com/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
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. Thanks. j -Original Message- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Here's what works for me: 1. Query my db (three tables for mime type, media meta data, and the media data itself -- but you could put this into one table) 2. Set up the request scope variables @ROWS @ASSIGN NAME=type SCOPE=request VALUE=@COLUMN mime.type @ASSIGN NAME=date SCOPE=request VALUE=@COLUMN media_description.date_modified @ASSIGN NAME=size SCOPE=request VALUE=@COLUMN media.size @ASSIGN NAME=filename SCOPE=request VALUE=@COLUMN media.filename @ASSIGN NAME=file SCOPE=request VALUE=@COLUMN media.data /@ROWS 3. Set up the HTTP header @PURGERESULTS@assign name=encodeResults scope=request value=false@ASSIGN NAME=httpHeader SCOPE=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
RE: Witango-Talk: PDF stored in db?
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 __ __ 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 FileUploadToDb.taf Description: FileUploadToDb.taf
RE: Witango-Talk: PDF stored in db?
I take it back. The reason I'm having problems with the display is that it's not inserting the full file, only about 40 chars worth. I'm reworking it now, so any hints from Bengt would be most timely. :) j -Original Message- From: Wilcox, Jamileh (HSC) Sent: Thursday, September 04, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Actually, I've gotten the data to insert into a Text field. At the moment, I'm trying to get it back out again. :) P.S. Access might work, on very small files. Max looks to be ~65K. Since my two sample files are approaching that, I don't think it's workable for me. Here's the taf I used. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:40 AM To: [EMAIL PROTECTED] Subject: 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
RE: Witango-Talk: PDF stored in db?
It seems to be some sort of strange character that's causing the problem. One file uploads as 40 characters, the other as 1085. My text editor shows hexcode 00 at those locations. I'm inserting as text, with quotes around the data; dropping the quotes causes various errors. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:11 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? That is the problem I had and it was weird, it would stop when it reached the first space in, huh! I said this is text. I think I even tried wrapping it in quotes. 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:06 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I take it back. The reason I'm having problems with the display is that it's not inserting the full file, only about 40 chars worth. I'm reworking it now, so any hints from Bengt would be most timely. :) j -Original Message- From: Wilcox, Jamileh (HSC) Sent: Thursday, September 04, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Actually, I've gotten the data to insert into a Text field. At the moment, I'm trying to get it back out again. :) P.S. Access might work, on very small files. Max looks to be ~65K. Since my two sample files are approaching that, I don't think it's workable for me. Here's the taf I used. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:40 AM To: [EMAIL PROTECTED] Subject: 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
RE: Witango-Talk: empty argument
Yup, empty strings ('') are not the same thing as NULL in SQL. I believe MySQL supports this difference. If someone submitted an empty form, and that form touched fields in your database (even though nothing was inserted), then those columns contain nothing (i.e., empty strings) rather than NULLs. If your form/insert did not touch a particular field at all, that field would still be null. In MSSQL, true null values in a table are shown as NULL, but empty strings just show as blanks. If you query using their Query Analyzer tool, it shows NULL vs blank - it even exports NULL if you save the query results to a file. You can also change a value back to NULL with a [CTL]-[0] (using the Enterprise Manager GUI). I've not used MySQL enough to say how it shows the difference (if at all), but it may be similar, depending on the tools you're using. You're probably not used to seeing these nuances because Witango handles most of them for you. I think searching for an empty string (column = '') will always find nulls as well as empty strings...except maybe in Access - I seem to have a lot of problems with nulls/empty strings whenever I use Access, partly because you can't see the difference as easily (Access just shows blanks for both). Hope that helps! jamileh -Original Message- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:52 PM To: WiTango List Subject: Witango-Talk: empty argument I have a search action that looks for @ARG 1 = column1 AND @ARG 1 = column2 AND column1 is not NULL AND column2 is not NULL so if someone does an empty form, it should return nothing. It never does. Always gets a foundset. Same records, in fact. It finds records that have null content in column1 and column2 (mysql) (I can trap for empty arguments, but this seems odd) __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: PDF stored in db?
How would you do that uploading files? I've only seen it in email. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 1:13 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Yeah, that's right, that is what I was running into. I am wondering if it will take Quoted-Printable or Base-64 encoding? 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? It seems to be some sort of strange character that's causing the problem. One file uploads as 40 characters, the other as 1085. My text editor shows hexcode 00 at those locations. I'm inserting as text, with quotes around the data; dropping the quotes causes various errors. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:11 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? That is the problem I had and it was weird, it would stop when it reached the first space in, huh! I said this is text. I think I even tried wrapping it in quotes. 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:06 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? I take it back. The reason I'm having problems with the display is that it's not inserting the full file, only about 40 chars worth. I'm reworking it now, so any hints from Bengt would be most timely. :) j -Original Message- From: Wilcox, Jamileh (HSC) Sent: Thursday, September 04, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? Actually, I've gotten the data to insert into a Text field. At the moment, I'm trying to get it back out again. :) P.S. Access might work, on very small files. Max looks to be ~65K. Since my two sample files are approaching that, I don't think it's workable for me. Here's the taf I used. -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:40 AM To: [EMAIL PROTECTED] Subject: 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
RE: Witango-Talk: email actions w/ multiple destinations
Title: Message Atrix - it's always been commas, as far as I know. We're still on T2K - I had to fix a couple of mail actions a few months ago, because they'd been semicolon delimited and weren't working. (There was no over error, the mail just didn't go out.) -Original Message-From: Atrix Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:54 PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: email actions w/ multiple destinations heya everyone, i was wondering, what are the rules for seperating multiple email addresses in mail actions? in tango 4 we were using semicolons but it seems to want commas in witango 5. is this true or is there a setting somewhere to change this all or something? Thanks! Alan TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: OT: SMTP server
*g* I may think about changing mail servers, now that I'm collecting a few clues. == Here's @@resultSet for a successful mailing: 220 intranet.net.ouhsc.edu Microsoft ESMTP MAIL Service, Version: 5.0.2195.5329 ready at Thu, 28 Aug 2003 17:59:17 -0500 250 intranet.net.ouhsc.edu Hello [127.0.0.1] Command: MAIL FROM: cnevar 250 2.1.0 [EMAIL PROTECTED] OK Command: RCPT TO: lt;[EMAIL PROTECTED]gt; 250 2.1.5 [EMAIL PROTECTED] Command: Starting to send content 354 Start mail input; end with lt;CRLFgt;.lt;CRLFgt; Command: Content sent 250 2.6.0 lt;[EMAIL PROTECTED]gt; Queued mail for delivery 221 2.0.0 intranet.net.ouhsc.edu Service closing transmission channel Here's the SMTP log (now that's helpful, doncha know): 22:59:17 127.0.0.1 HELO - 250 22:59:17 127.0.0.1 MAIL - 250 22:59:17 127.0.0.1 RCPT - 250 22:59:17 127.0.0.1 DATA - 250 22:59:17 127.0.0.1 QUIT - 0 22:59:17 - - - 0 22:59:17 imail.ouhsc.edu EHLO - 0 22:59:17 imail.ouhsc.edu - - 0 22:59:17 imail.ouhsc.edu MAIL - 0 22:59:17 imail.ouhsc.edu - - 0 22:59:17 imail.ouhsc.edu RCPT - 0 22:59:17 imail.ouhsc.edu - - 0 22:59:17 imail.ouhsc.edu DATA - 0 22:59:17 imail.ouhsc.edu - - 0 22:59:17 imail.ouhsc.edu - - 0 22:59:17 imail.ouhsc.edu QUIT - 0 22:59:17 imail.ouhsc.edu - - 0 == Here's @@resultSet for a failed mailing: 220 intranet.net.ouhsc.edu Microsoft ESMTP MAIL Service, Version: 5.0.2195.5329 ready at Thu, 28 Aug 2003 18:02:24 -0500 250 intranet.net.ouhsc.edu Hello [127.0.0.1] Command: MAIL FROM: cnevar 250 2.1.0 [EMAIL PROTECTED] OK Command: RCPT TO: lt;[EMAIL PROTECTED]gt; 250 2.1.5 [EMAIL PROTECTED] Command: Starting to send content 354 Start mail input; end with lt;CRLFgt;.lt;CRLFgt; Command: Content sent 250 2.6.0 lt;[EMAIL PROTECTED]gt; Queued mail for delivery 221 2.0.0 intranet.net.ouhsc.edu Service closing transmission channel Here's the SMTP log: 23:02:24 127.0.0.1 HELO - 250 23:02:24 127.0.0.1 MAIL - 250 23:02:24 127.0.0.1 RCPT - 250 23:02:24 127.0.0.1 DATA - 250 23:02:24 127.0.0.1 QUIT - 0 23:02:32 - - - 0 23:02:32 imail.ouhsc.edu EHLO - 0 23:02:32 imail.ouhsc.edu - - 0 23:02:32 imail.ouhsc.edu MAIL - 0 23:02:32 imail.ouhsc.edu - - 0 23:02:32 imail.ouhsc.edu RCPT - 0 23:02:32 imail.ouhsc.edu - - 0 23:02:32 imail.ouhsc.edu DATA - 0 23:02:32 imail.ouhsc.edu - - 0 23:02:32 imail.ouhsc.edu - - 0 23:02:32 imail.ouhsc.edu QUIT - 0 23:02:32 imail.ouhsc.edu - - 0 == I don't see anything in either of those that would tell you an email delivery failed. The only place I'm finding that info is the System Event Log: Event Type: Warning Event Source: smtpsvc Event Category: None Event ID: 4000 Date: 8/28/2003 Time: 6:02:32 PM User: N/A Computer: intranet Description: Message delivery to the remote domain 'nowhere.com' failed for the following reason: Destination server does not exist. Data: : d6 02 04 c0 Ö..À -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 5:54 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: OT: SMTP server Of course not, this is free, if you want functionality you pay for M$Exchange Server. MDaemon (great mail server I might add :-) keep it in the primary que for 60 minutes, then it tries every 240 minutes for 5 days. Of course this is all configurable. When I looked at the built in SMTP server of IIS I couldn't find setting for this. Can you send a @@resultSet snippet of a failed email? 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 TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf